Clansphere :: FREE Clan Content Management System

|

|

|

|

|

|

|

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 = 1 LIMIT 0,1
UPDATE cs_users SET users_laston='1219004346' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = 5 LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '91.67.50.88' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1219004346', count_location='board/toplist' WHERE count_id='40583'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'fckeditor'
SELECT COUNT(*) FROM cs_news WHERE news_publishs_at != 0 AND news_public = 0 AND news_publishs_at < 1219004346
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'gallery'
SELECT usr.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, COUNT(DISTINCT cms.comments_id) + COUNT(DISTINCT thr.threads_id) AS comments FROM cs_comments cms LEFT JOIN cs_users usr ON cms.users_id = usr.users_id LEFT JOIN cs_threads thr ON thr.users_id = usr.users_id GROUP BY usr.users_id, usr.users_nick ORDER BY comments DESC, usr.users_nick LIMIT 0,20
SELECT COUNT(usr.users_id) FROM cs_comments cms LEFT JOIN cs_users usr ON cms.users_id = usr.users_id LEFT JOIN cs_threads thr ON thr.users_id = usr.users_id GROUP BY usr.users_id, usr.users_nick
SELECT boardranks_min, boardranks_name FROM cs_boardranks ORDER BY boardranks_min ASC
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'abcode'
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 = '1' AND messages_show_receiver = 1 AND messages_view = 0

|

|

|