SELECT * FROM
testboard__topics WHERE tid=4231
SELECT * FROM
testboard__cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' )
SELECT id, member_id, running_time, location FROM
testboard__sessions WHERE id='0f7ee99271eaa8fd5127d07a8fd6ce29' AND ip_address='38.107.191.92'
DELETE FROM
testboard__sessions WHERE ip_address='38.107.191.92'
SELECT set_cache_css,set_cache_wrapper,set_cache_macro,set_image_dir,set_emoticon_folder,set_skin_set_id,set_name,set_css_method FROM
testboard__skin_sets WHERE set_skin_set_id=3
SELECT pid,topic_id FROM
testboard__posts WHERE topic_id=4231 and queued=0 ORDER BY pid asc LIMIT 0,20
SELECT p.*, pp.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title,m.hide_email, m.warn_level, m.warn_lastwarn,
me.msnname,me.aim_name,me.icq_number,me.signature, me.website,me.yahoo,me.location, me.avatar_location, me.avatar_type, me.avatar_size, m.members_display_name,
pc.*
FROM
testboard__posts p
LEFT JOIN testboard__members m ON (m.id=p.author_id)
LEFT JOIN testboard__member_extra me ON (me.id=m.id)
LEFT JOIN testboard__pfields_content pc ON (pc.member_id=p.author_id)
LEFT JOIN testboard__profile_portal pp ON (m.id=pp.pp_member_id)
WHERE p.pid IN(4273)
ORDER BY pid asc
SELECT s.member_id, s.member_name, s.member_group, s.id, s.login_type, s.location, s.running_time
FROM
testboard__sessions s
WHERE s.location_1_type='topic' AND s.location_1_id=4231
AND s.running_time > 1265666198 AND s.in_error=0
SHUTDOWN: INSERT INTO testboard__sessions (id,member_name,member_id,member_group,login_type,running_time,ip_address,browser,location,in_error,location_1_type,location_1_id,location_2_type,location_2_id,location_3_type,location_3_id) VALUES('84d96d186fd846d94f0a68c9b3af5976','',0,2,0,1265667098,'38.107.191.92','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','st',0,'topic',4231,'forum',2,'',0)
SHUTDOWN: UPDATE testboard__topics SET views=views+1 WHERE tid=4231
Sep 5 2009, 08:19 PM
