Clansphere :: FREE Clan Content Management System

SELECT options_name, options_value FROM bxcp_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM bxcp_users WHERE users_id = '1' LIMIT 0,1
UPDATE bxcp_users SET users_laston='1175495194' WHERE users_id='1'
SELECT * FROM bxcp_access WHERE access_id = '16' LIMIT 0,1
SELECT count_id, count_time FROM bxcp_count WHERE count_ip = '217.91.95.236' ORDER BY count_id DESC LIMIT 0,1
UPDATE bxcp_count SET count_time='1175495194', count_location='news/recent' WHERE count_id='28549'
SELECT options_name, options_value FROM bxcp_options WHERE options_mod = 'counter'
SELECT metatags_id, metatags_name, metatags_content FROM bxcp_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM bxcp_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0
SELECT COUNT(*) FROM bxcp_messages WHERE users_id_to = '1' AND messages_show_receiver = 1
SELECT COUNT(*) FROM bxcp_messages WHERE users_id = '1' AND messages_show_sender = 1
SELECT COUNT(*) FROM bxcp_messages WHERE users_id = '1' AND messages_archiv_sender = '1' OR users_id_to = '1' AND messages_archiv_receiver = '1'
SELECT * FROM bxcp_categories WHERE categories_mod = 'news' AND categories_access <= '5' ORDER BY categories_name
SELECT COUNT(*) FROM bxcp_news nws INNER JOIN bxcp_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 bxcp_news nws INNER JOIN bxcp_users usr ON nws.users_id = usr.users_id INNER JOIN bxcp_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 abcode_func, abcode_pattern, abcode_result, abcode_file FROM bxcp_abcode
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '210'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '112'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '155'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '209'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '208'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '207'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '206'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '205'