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 clan_options WHERE options_mod='clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM clan_users WHERE users_id = '1' LIMIT 0,1
UPDATE clan_users SET users_laston='1194169348' WHERE users_id='1'
SELECT * FROM clan_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM clan_count WHERE count_ip = '84.147.108.124' ORDER BY count_id DESC LIMIT 0,1
UPDATE clan_count SET count_time='1194169348', count_location='news/recent' WHERE count_id='2'
SELECT options_name, options_value FROM clan_options WHERE options_mod='counter'
SELECT * FROM clan_categories WHERE categories_mod = 'news' AND categories_access <= '5' ORDER BY categories_name
SELECT COUNT(*) FROM clan_news nws INNER JOIN clan_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, nws.categories_id AS categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name FROM clan_news nws INNER JOIN clan_users usr ON nws.users_id = usr.users_id INNER JOIN clan_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 metatags_id, metatags_name, metatags_content FROM clan_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM clan_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0