11
This is not the query when you click on submit, right?
I mean you select the avator you wish and then press submit. Right after that you should get all these querries:
Quote:
Queries
SELECT * FROM xoops_20131___config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_20131___session WHERE sess_id = '********************************'
SELECT * FROM xoops_20131___users WHERE uid=1
SELECT * FROM xoops_20131___config WHERE (conf_modid = '0' AND conf_catid = '2') ORDER BY conf_order ASC
SELECT * FROM xoops_20131___config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC
UPDATE xoops_20131___users SET uname = 'testuser', name = '', email = '***@**************.de', url = 'http://***url***/', user_avatar = 'savt43410c7aeb671.jpg', user_icq = '', user_from = '', user_sig = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', posts = 0, pass = '********************************', attachsig = 0, rank = 7, level= 5, theme = 'default', timezone_offset = 0.00, umode = 'thread', last_login = 1128350098, uorder = 0, notify_method = 1, notify_mode = 0, user_occ = '', bio = '', user_intrest = '', user_mailok = 0 WHERE uid = 1
SELECT a.*, COUNT(u.user_id) AS count FROM xoops_20131___avatar a LEFT JOIN xoops_20131___avatar_user_link u ON u.avatar_id=a.avatar_id WHERE avatar_file = 'savt43410c7aeb671.jpg' GROUP BY a.avatar_id ORDER BY avatar_weight, avatar_id
DELETE FROM xoops_20131___avatar_user_link WHERE user_id = 1
INSERT INTO xoops_20131___avatar_user_link (avatar_id, user_id) VALUES (1, 1)
Total: 9 queries
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...