Clansphere :: FREE Clan Content Management System

SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM cs_users WHERE users_id = '1' LIMIT 0,1
UPDATE cs_users SET users_laston='1176726269' 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 = '87.122.152.69' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1176726269', count_location='gallery/create' WHERE count_id='1'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1
SELECT COUNT(*) FROM cs_messages WHERE users_id = '1' AND messages_show_sender = 1
SELECT COUNT(*) FROM cs_messages WHERE users_id = '1' AND messages_archiv_sender = '1' OR users_id_to = '1' AND messages_archiv_receiver = '1'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'gallery'
SELECT categories_id FROM cs_categories WHERE categories_mod='gallery' AND categories_name = 'test' ORDER BY categories_name LIMIT 0,1
REPLACE INTO cs_categories (categories_mod,categories_name) VALUES ('gallery','test')
SELECT categories_id FROM cs_categories WHERE categories_mod='gallery' AND categories_name = 'test' ORDER BY categories_name LIMIT 0,1
SELECT * FROM cs_gallery WHERE gallery_name = 'Battlefield_1942_005.jpg' ORDER BY gallery_id DESC
SELECT * FROM cs_categories WHERE categories_mod='gallery' ORDER BY categories_name
SELECT abcode_pattern, abcode_file FROM cs_abcode WHERE abcode_func = 'img' LIMIT 0,10