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 = '2' LIMIT 0,1
UPDATE bxcp_users SET users_laston='1180721748' WHERE users_id='2'
SELECT * FROM bxcp_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM bxcp_count WHERE count_ip = '213.182.118.44' ORDER BY count_id DESC LIMIT 0,1
UPDATE bxcp_count SET count_time='1180721748', count_location='news/recent' WHERE count_id='9193'
SELECT options_name, options_value FROM bxcp_options WHERE options_mod = 'counter'
SELECT * FROM bxcp_categories WHERE categories_mod = 'news' AND categories_access <= '5' ORDER BY categories_name
SELECT COUNT(DISTINCT news_id) 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 = '18'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '17'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '16'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '15'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '14'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '13'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '12'
SELECT COUNT(*) FROM bxcp_comments WHERE comments_mod = 'news' AND comments_fid = '11'
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 = '2' AND messages_show_receiver = 1 AND messages_view = 0
SELECT COUNT(*) FROM bxcp_messages WHERE users_id_to = '2' AND messages_show_receiver = 1
SELECT COUNT(*) FROM bxcp_messages WHERE users_id = '2' AND messages_show_sender = 1
SELECT COUNT(*) FROM bxcp_messages WHERE users_id = '2' AND messages_archiv_sender = '1' OR users_id_to = '2' AND messages_archiv_receiver = '1'

|

|

|

|

|