Clansphere :: FREE Clan Content Management System

Warning: cs_html_vote - 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_pwd, users_active FROM cs_users WHERE users_id = '1' LIMIT 0,1
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime, users_ajax, users_tpl, users_pwd FROM cs_users WHERE users_id = '1' AND users_pwd = 'a98d9862877949ebe5295f458001b476' LIMIT 0,1
UPDATE cs_users SET users_laston='1236502584' 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 = '84.--.--.--' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1236502584', count_location='news/recent' WHERE count_id='4'
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 < 1236502584
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'news'
SELECT * FROM cs_categories WHERE categories_mod = 'news' AND categories_access <= 5 ORDER BY categories_name
SELECT COUNT(DISTINCT news_id) FROM cs_news nws INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public > 0 AND cat.categories_access <= 5
SELECT nws.news_id AS news_id, nws.news_headline AS news_headline, nws.news_time AS news_time, nws.news_text AS news_text, nws.news_pictures AS news_pictures, nws.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, nws.categories_id AS categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name, nws.news_mirror AS news_mirror, nws.news_mirror_name AS news_mirror_name, nws.news_readmore AS news_readmore, nws.news_readmore_active AS news_readmore_active FROM cs_news nws INNER JOIN cs_users usr ON nws.users_id = usr.users_id INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public > 0 AND cat.categories_access <= 5 ORDER BY news_attached DESC, news_time DESC LIMIT 0,8
SELECT COUNT(*) FROM cs_count WHERE count_time > '1236502284'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1236463200'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1236376800' AND count_time < '1236463199'
SELECT COUNT(*) FROM cs_count WHERE count_time > '1235858400'
SELECT count_num FROM cs_count_archiv
SELECT COUNT(*) FROM cs_count
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0
SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1236502584' AND votes_end >= '1236502584' ORDER BY RAND() LIMIT 0,1
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 ASC LIMIT 0,10
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'abcode'
SELECT gallery_id FROM cs_gallery WHERE gallery_access < '5' AND gallery_status = '1' ORDER BY gallery_id DESC