Clansphere :: FREE Clan Content Management System

Warning: cs_html_table - Function goes away in next minor release, use themes instead
Warning: cs_html_roco - Function goes away in next minor release, use themes instead
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime, users_pwd FROM cs_users WHERE users_id = 3 LIMIT 0,1
UPDATE cs_users SET users_laston='1219570560' WHERE users_id='3'
SELECT * FROM cs_access WHERE access_id = 5 LIMIT 0,1
SELECT COUNT(*) FROM cs_news WHERE news_publishs_at != 0 AND news_public = 0 AND news_publishs_at < 1219570560
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'fckeditor'
SELECT count_id, count_time FROM cs_count WHERE count_ip = '88.67.203.101' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1219570560', count_location='fckeditor/options' WHERE count_id='124540'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'gallery'
UPDATE cs_options SET options_value='1' WHERE options_mod = 'fckeditor' AND options_name = 'mode'
UPDATE cs_options SET options_value='0' WHERE options_mod = 'fckeditor' AND options_name = 'skin'
UPDATE cs_options SET options_value='' WHERE options_mod = 'fckeditor' AND options_name = 'height'
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '3' AND messages_show_receiver = 1 AND messages_view = 0
SELECT partner_id, partner_name, partner_url, partner_alt, partner_nimg FROM cs_partner WHERE partner_nimg != '' ORDER BY partner_priority ASC
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'abcode'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1219570260'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1219525200'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1219438800' AND count_time < '1219525199'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1217538000'
SELECT count_num FROM cs_count_archiv
SELECT COUNT(*) FROM cs_count
SELECT users_readtime FROM cs_users WHERE users_id = '3' LIMIT 0,1
SELECT thr.threads_headline AS threads_headline, thr.threads_id AS threads_id, thr.threads_last_time AS threads_last_time FROM cs_threads thr INNER JOIN cs_board frm ON frm.board_id = thr.board_id LEFT JOIN cs_read red ON thr.threads_id = red.threads_id AND red.users_id = '3' WHERE frm.board_access <= '5' AND board_pwd = '' AND thr.threads_last_time > '1218360960' AND (thr.threads_last_time > red.read_since OR red.threads_id IS NULL) ORDER BY thr.threads_last_time DESC LIMIT 0,8
SELECT war.games_id AS games_id, war.wars_date AS wars_date, sqd.squads_name AS squads_name, cln.clans_tag AS clans_name, war.wars_id AS wars_id FROM cs_wars war INNER JOIN cs_squads sqd ON war.squads_id = sqd.squads_id INNER JOIN cs_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_date > '1219570560' AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,5
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'wars'
SELECT war.games_id AS games_id, cln.clans_short AS clans_short, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_date AS wars_date, war.wars_id AS wars_id FROM cs_wars war INNER JOIN cs_categories cat ON war.categories_id = cat.categories_id INNER JOIN cs_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_status = 'played' ORDER BY wars_date DESC LIMIT 0,5
SELECT users_id, users_nick, users_country, access_id,users_active, users_invisible FROM cs_users WHERE users_laston > 1219570260 AND users_active = '1' AND users_invisible = '0' ORDER BY users_laston DESC LIMIT 0,8
SELECT COUNT(*) FROM cs_shoutbox
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'shoutbox'
SELECT shoutbox_name, shoutbox_text, shoutbox_date FROM cs_shoutbox ORDER BY shoutbox_date DESC LIMIT 0,5
SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
SELECT abcode_pattern, abcode_file FROM cs_abcode WHERE abcode_func = 'img' LIMIT 0,10

ClanSphere - professional clan care starts here

|

|