Clansphere :: FREE Clan Content Management System

SELECT options_name, options_value FROM tst_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM tst_users WHERE users_id = '2' LIMIT 0,1
UPDATE tst_users SET users_laston='1180722651' WHERE users_id='2'
SELECT * FROM tst_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM tst_count WHERE count_ip = '87.122.85.90' ORDER BY count_id DESC LIMIT 0,1
UPDATE tst_count SET count_time='1180722651', count_location='news/recent' WHERE count_id='137'
SELECT options_name, options_value FROM tst_options WHERE options_mod = 'counter'
SELECT * FROM tst_categories WHERE categories_mod = 'news' AND categories_access <= '5' ORDER BY categories_name
SELECT COUNT(DISTINCT news_id) FROM tst_news nws INNER JOIN tst_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 tst_news nws INNER JOIN tst_users usr ON nws.users_id = usr.users_id INNER JOIN tst_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 tst_abcode
SELECT COUNT(*) FROM tst_comments WHERE comments_mod = 'news' AND comments_fid = '2'
SELECT metatags_id, metatags_name, metatags_content FROM tst_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM tst_messages WHERE users_id_to = '2' AND messages_show_receiver = 1 AND messages_view = 0
SELECT COUNT(*) FROM tst_messages WHERE users_id_to = '2' AND messages_show_receiver = 1
SELECT COUNT(*) FROM tst_messages WHERE users_id = '2' AND messages_show_sender = 1
SELECT COUNT(*) FROM tst_messages WHERE users_id = '2' AND messages_archiv_sender = '1' OR users_id_to = '2' AND messages_archiv_receiver = '1'

Dateianhänge: