Okay, Who's Debuggin!?
<!--QuoteBegin--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> </td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->
FORM and GET Input
showtopic = 60569
st = 15
IP_ADDRESS = 67.165.206.138
request_method = get
act = ST
t = 60569
f = 10
Privacy = -1
last_activity = 1075625163
last_visit = 1075621019
Queries Used
SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html, f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms, f.show_rules, f.rules_text, f.rules_title, c.name as cat_name, c.id as cat_id FROM ivb_topics t, ivb_forums f , ivb_categories c WHERE t.tid=60569 and f.id = t.forum_id and f.category=c.id
--------------------------------------------------------------------------------
SELECT id, member_id, running_time, location FROM ivb_sessions WHERE id='f0438b2c8cd34bf07f1eee57c73fd270' and ip_address='67.165.206.138'
--------------------------------------------------------------------------------
SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post, m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.* FROM ivb_members m LEFT JOIN ivb_groups g ON (g.g_id=m.mgroup) LEFT JOIN ivb_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup ) WHERE m.id=21552
--------------------------------------------------------------------------------
UPDATE ivb_sessions SET member_name='Aea',member_id='21552',member_group='3',in_forum='10',in_topic='60569',login_type='-1',running_time='1075625259',location='ST,,' WHERE id='f0438b2c8cd34bf07f1eee57c73fd270'
--------------------------------------------------------------------------------
SELECT s.*, t.template, c.css_text FROM ivb_skins s LEFT JOIN ivb_templates t ON (t.tmid=s.tmpl_id) LEFT JOIN ivb_css c ON (s.css_id=c.cssid) WHERE s.default_set=1
--------------------------------------------------------------------------------
SELECT func_name, func_data, section_content FROM ivb_skin_templates WHERE set_id='1' AND group_name='skin_global'
--------------------------------------------------------------------------------
SELECT func_name, func_data, section_content FROM ivb_skin_templates WHERE set_id='1' AND group_name='skin_topic'
--------------------------------------------------------------------------------
SELECT f.id as forum_id, f.parent_id, f.subwrap, f.sub_can_post, f.name as forum_name, f.position, f.redirect_on, f.read_perms, c.id as cat_id, c.name FROM ivb_forums f LEFT JOIN ivb_categories c ON (c.id=f.category) WHERE c.state IN (1,2) ORDER BY c.position, f.position
--------------------------------------------------------------------------------
UPDATE ivb_topics SET views=views+1 WHERE tid='60569'
--------------------------------------------------------------------------------
SELECT id, title, pips, posts from ivb_titles ORDER BY posts DESC
--------------------------------------------------------------------------------
SELECT * FROM ivb_moderators WHERE forum_id=10 AND (member_id=21552 OR (is_group=1 AND group_id='3'))
--------------------------------------------------------------------------------
SELECT p.*, m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number, m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn, g.g_id, g.g_title, g.g_icon, g.g_dohtml FROM ivb_posts p LEFT JOIN ivb_members m ON (p.author_id=m.id) LEFT JOIN ivb_groups g ON (g.g_id=m.mgroup) WHERE p.topic_id=60569 and p.queued != 1 ORDER BY p.pid asc LIMIT 15, 15
--------------------------------------------------------------------------------
SELECT s.member_id, s.member_name, s.login_type, s.location, g.suffix, g.prefix, g.g_perm_id, m.org_perm_id FROM ivb_sessions s LEFT JOIN ivb_groups g ON (g.g_id=s.member_group) LEFT JOIN ivb_members m on (s.member_id=m.id) WHERE s.in_topic=60569 AND s.running_time > 1075624360 ORDER BY s.running_time DESC
--------------------------------------------------------------------------------
SELECT macro_value, macro_replace FROM ivb_macro WHERE macro_set=1
<!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
That about doubled your server load <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html//emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo--> Who's messing around in the admin cp again <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html//emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo-->
FORM and GET Input
showtopic = 60569
st = 15
IP_ADDRESS = 67.165.206.138
request_method = get
act = ST
t = 60569
f = 10
Privacy = -1
last_activity = 1075625163
last_visit = 1075621019
Queries Used
SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html, f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms, f.show_rules, f.rules_text, f.rules_title, c.name as cat_name, c.id as cat_id FROM ivb_topics t, ivb_forums f , ivb_categories c WHERE t.tid=60569 and f.id = t.forum_id and f.category=c.id
--------------------------------------------------------------------------------
SELECT id, member_id, running_time, location FROM ivb_sessions WHERE id='f0438b2c8cd34bf07f1eee57c73fd270' and ip_address='67.165.206.138'
--------------------------------------------------------------------------------
SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post, m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, m.sub_end, g.* FROM ivb_members m LEFT JOIN ivb_groups g ON (g.g_id=m.mgroup) LEFT JOIN ivb_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup ) WHERE m.id=21552
--------------------------------------------------------------------------------
UPDATE ivb_sessions SET member_name='Aea',member_id='21552',member_group='3',in_forum='10',in_topic='60569',login_type='-1',running_time='1075625259',location='ST,,' WHERE id='f0438b2c8cd34bf07f1eee57c73fd270'
--------------------------------------------------------------------------------
SELECT s.*, t.template, c.css_text FROM ivb_skins s LEFT JOIN ivb_templates t ON (t.tmid=s.tmpl_id) LEFT JOIN ivb_css c ON (s.css_id=c.cssid) WHERE s.default_set=1
--------------------------------------------------------------------------------
SELECT func_name, func_data, section_content FROM ivb_skin_templates WHERE set_id='1' AND group_name='skin_global'
--------------------------------------------------------------------------------
SELECT func_name, func_data, section_content FROM ivb_skin_templates WHERE set_id='1' AND group_name='skin_topic'
--------------------------------------------------------------------------------
SELECT f.id as forum_id, f.parent_id, f.subwrap, f.sub_can_post, f.name as forum_name, f.position, f.redirect_on, f.read_perms, c.id as cat_id, c.name FROM ivb_forums f LEFT JOIN ivb_categories c ON (c.id=f.category) WHERE c.state IN (1,2) ORDER BY c.position, f.position
--------------------------------------------------------------------------------
UPDATE ivb_topics SET views=views+1 WHERE tid='60569'
--------------------------------------------------------------------------------
SELECT id, title, pips, posts from ivb_titles ORDER BY posts DESC
--------------------------------------------------------------------------------
SELECT * FROM ivb_moderators WHERE forum_id=10 AND (member_id=21552 OR (is_group=1 AND group_id='3'))
--------------------------------------------------------------------------------
SELECT p.*, m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number, m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn, g.g_id, g.g_title, g.g_icon, g.g_dohtml FROM ivb_posts p LEFT JOIN ivb_members m ON (p.author_id=m.id) LEFT JOIN ivb_groups g ON (g.g_id=m.mgroup) WHERE p.topic_id=60569 and p.queued != 1 ORDER BY p.pid asc LIMIT 15, 15
--------------------------------------------------------------------------------
SELECT s.member_id, s.member_name, s.login_type, s.location, g.suffix, g.prefix, g.g_perm_id, m.org_perm_id FROM ivb_sessions s LEFT JOIN ivb_groups g ON (g.g_id=s.member_group) LEFT JOIN ivb_members m on (s.member_id=m.id) WHERE s.in_topic=60569 AND s.running_time > 1075624360 ORDER BY s.running_time DESC
--------------------------------------------------------------------------------
SELECT macro_value, macro_replace FROM ivb_macro WHERE macro_set=1
<!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
That about doubled your server load <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html//emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo--> Who's messing around in the admin cp again <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html//emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo-->
Comments
would you be so kind as to elaborate on what is going on there? in non code english <!--emo&::nerdy::--><img src='http://www.unknownworlds.com/forums/html//emoticons/nerd.gif' border='0' style='vertical-align:middle' alt='nerd.gif' /><!--endemo-->