Member List

MEMBER: last_visit: 1328834003 / Today, 12:33 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','report_cache','report_plugins','ranks','reputation_levels' )

SELECT * FROM sessions WHERE id='1f01af5f1f3da285db48ba95358e7e69'

DELETE FROM sessions WHERE (id='1f01af5f1f3da285db48ba95358e7e69' OR ip_address='38.107.179.207') OR running_time < 1328830403

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

SELECT COUNT( * ) as cnt 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 ) WHERE m.members_l_display_name !='' AND m.members_l_display_name IS NOT NULL AND m.member_group_id NOT IN(5) AND m.members_l_display_name LIKE 's%'

SELECT m.member_id 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 ) WHERE m.members_l_display_name !='' AND m.members_l_display_name IS NOT NULL AND m.member_group_id NOT IN(5) AND m.members_l_display_name LIKE 's%' ORDER BY m.members_l_display_name asc LIMIT 0,20

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 (621,1016,196,792,274,483,653,212,41,209,953,441,498,467,169,463,762,421,494,536)

SELECT * FROM bouncy_license WHERE app="BRC10"