A Test Forum

MEMBER: last_visit: 1328330538 / Today, 04:42 AM

MEMBER: uagent_key: __NONE__

MEMBER: uagent_type:

MEMBER: uagent_version: 0

SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','emoticons' )

SELECT * FROM sessions WHERE id='31e7056f1aefe38e34062d5bd7ce0fe7'

DELETE FROM sessions WHERE (id='31e7056f1aefe38e34062d5bd7ce0fe7' OR ip_address='38.107.179.207') OR running_time < 1328326938

SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )

SELECT * FROM skin_cache WHERE cache_set_id=1 AND cache_type IN ('css', 'replacements')

SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.forum_id=2 AND t.pinned IN (0,1) AND t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (875,679,945,861,851,839,832,816,806,800)

SELECT * FROM core_like_cache WHERE like_cache_id='cac03811255508b2807662888a108bf1'

SELECT s.member_id, s.member_name, s.member_group, s.id, s.login_type, s.running_time, s.uagent_type, s.seo_name, s.current_module,t.forum_id FROM sessions s LEFT JOIN topics t ON ( t.tid=s.location_1_id ) WHERE s.location_2_type='forum' AND s.location_2_id=2 AND s.running_time > 1328329639 AND s.in_error=0

SELECT * FROM bouncy_license WHERE app="BRC10"