Clansphere :: FREE Clan Content Management System

12) SELECT abonements_id FROM cs_abonements WHERE threads_id = 8 AND users_id = 9 LIMIT 0,1
13) SELECT boardmods_modpanel, boardmods_edit, boardmods_del FROM cs_boardmods WHERE users_id = 9 LIMIT 0,1
14) SELECT users_id FROM cs_boardmods
15) SELECT bdr.comments_id AS comments_id, bdr.boardreport_id AS boardreport_id, bdr.boardreport_time AS boardreport_time, bdr.boardreport_text AS boardreport_text, bdr.users_id AS users_id, usr.users_nick AS users_nick, usr.users_delete AS users_delete, usr.users_active AS users_active, bdr.boardreport_done AS boardreport_done FROM cs_boardreport bdr INNER JOIN cs_users usr ON bdr.users_id = usr.users_id WHERE bdr.threads_id = 8 ORDER BY bdr.comments_id ASC
16) SELECT boardvotes_access, boardvotes_end, boardvotes_question, boardvotes_election FROM cs_boardvotes WHERE threads_id = 8 LIMIT 0,1
17) SELECT comments_id, boardfiles_name, boardfiles_id, boardfiles_downloaded FROM cs_boardfiles WHERE threads_id = 8 AND comments_id = 0 ORDER BY boardfiles_id ASC
23) SELECT users_nick, users_country, com.users_id AS users_id, users_avatar, users_delete, users_laston, users_invisible, users_place, users_hidden, comments_time, comments_edit, comments_fid, comments_text, users_signature, users_email ,users_msn, users_icq, users_skype,users_active,users_url, comments_id FROM cs_comments com LEFT JOIN cs_users usr ON com.users_id = usr.users_id WHERE comments_mod = 'board' AND comments_fid = 8 ORDER BY comments_id ASC LIMIT 0,20
24) SELECT users_id, comments_time FROM cs_comments WHERE comments_mod = 'board' AND comments_fid = 8 ORDER BY comments_id DESC LIMIT 0,1
/var/www/web597/html/clansphere/mods/board/functions.php
18) SELECT threads_id FROM cs_threads WHERE board_id = '1' AND threads_time > '1246504036' ORDER BY threads_time ASC LIMIT 0,1
19) SELECT threads_id FROM cs_threads WHERE board_id = '1' AND threads_time < '1246504036' ORDER BY threads_time DESC LIMIT 0,1
20) SELECT COUNT(*) FROM cs_comments WHERE users_id = '9'
21) SELECT COUNT(*) FROM cs_threads WHERE users_id = '9'
/var/www/web597/html/clansphere/system/core/abcode.php
22) SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
41) SELECT abcode_pattern, abcode_file FROM cs_abcode WHERE abcode_func = 'img' LIMIT 0,10
/var/www/web597/html/clansphere/mods/users/navlogin2.php
25) SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '9' AND messages_show_receiver = '1' AND messages_view = '0'
/var/www/web597/html/clansphere/mods/wars/navnext.php
26) SELECT war.games_id AS games_id, war.wars_date AS wars_date, sqd.squads_name AS squads_name, cln.clans_name AS clans_name, war.wars_id AS wars_id FROM cs_wars war INNER JOIN cs_squads sqd ON war.squads_id = sqd.squads_id INNER JOIN cs_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_date > '1246504036' AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,4
/var/www/web597/html/clansphere/mods/wars/navlist.php
27) SELECT war.games_id AS games_id, cln.clans_short AS clans_short, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id FROM cs_wars war INNER JOIN cs_categories cat ON war.categories_id = cat.categories_id INNER JOIN cs_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_status = 'played' ORDER BY war.wars_date DESC LIMIT 0,4
/var/www/web597/html/clansphere/mods/banners/navright.php
28) SELECT banners_picture, banners_alt, banners_url FROM cs_banners ORDER BY banners_order ASC
/var/www/web597/html/clansphere/mods/partner/rotation.php
29) SELECT partner_id FROM cs_partner WHERE partner_rimg != '' ORDER BY partner_id DESC LIMIT 0,1
30) SELECT partner_id, partner_rimg, partner_alt, partner_url FROM cs_partner WHERE partner_rimg != '' AND partner_id > '0' ORDER BY partner_id ASC LIMIT 0,1
31) UPDATE cs_options SET options_value='' WHERE options_mod = 'partner' AND options_name = 'last_id'
/var/www/web597/html/clansphere/mods/news/navlist.php
32) SELECT ne.news_id AS news_id, ne.news_headline AS news_headline, ne.news_time AS news_time FROM cs_news ne INNER JOIN cs_categories cat ON ne.categories_id = cat.categories_id WHERE ne.news_public > '0' AND cat.categories_access <= '5' ORDER BY ne.news_time DESC LIMIT 0,4
/var/www/web597/html/clansphere/mods/board/navlist.php
33) SELECT users_readtime FROM cs_users WHERE users_id = '9' LIMIT 0,1
34) SELECT thr.threads_headline AS threads_headline, thr.threads_id AS threads_id, thr.threads_last_time AS threads_last_time FROM cs_threads thr INNER JOIN cs_board frm ON frm.board_id = thr.board_id LEFT JOIN cs_read red ON thr.threads_id = red.threads_id AND red.users_id = '9' WHERE frm.board_access <= '5' AND frm.board_pwd = '' AND thr.threads_last_time > '1245294436' AND (thr.threads_last_time > red.read_since OR red.threads_id IS NULL) ORDER BY thr.threads_last_time DESC LIMIT 0,8
/var/www/web597/html/clansphere/mods/files/navlist.php
35) SELECT files_name, files_id FROM cs_files ORDER BY files_time DESC LIMIT 0,4
/var/www/web597/html/clansphere/mods/users/navonline.php
36) SELECT users_id, users_nick, users_country, users_active, users_invisible FROM cs_users WHERE users_laston > 1246503736 AND users_active = '1' AND users_invisible = '0' ORDER BY users_laston DESC LIMIT 0,8
/var/www/web597/html/clansphere/mods/events/navcal.php
37) SELECT users_age FROM cs_users WHERE users_age LIKE '%-07-%' AND users_hidden NOT LIKE '%users_age%'
38) SELECT evs.events_time AS events_time FROM cs_events evs INNER JOIN cs_categories cat ON evs.categories_id = cat.categories_id WHERE events_time >= '1246392000' AND events_time <= '1249070399' AND cat.categories_access <= 5
/var/www/web597/html/clansphere/mods/shoutbox/navlist.php
39) SELECT COUNT(*) FROM cs_shoutbox
40) SELECT shoutbox_name, shoutbox_text, shoutbox_date FROM cs_shoutbox ORDER BY shoutbox_date ASC LIMIT 23,8
/var/www/web597/html/clansphere/mods/votes/navlist.php
42) SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1246504036' AND votes_end >= '1246504036' ORDER BY RAND() LIMIT 0,1
/var/www/web597/html/clansphere/mods/count/navone.php
43) SELECT COUNT(*) FROM cs_count WHERE count_time > '1246503736'
/var/www/web597/html/clansphere/mods/count/navday.php
44) SELECT COUNT(*) FROM cs_count WHERE count_time > '1246478400'
/var/www/web597/html/clansphere/mods/count/navyes.php
45) SELECT COUNT(*) FROM cs_count WHERE count_time > '1246392000' AND count_time < '1246478399'
/var/www/web597/html/clansphere/mods/count/navmon.php
46) SELECT SUM(count_num) AS count FROM cs_count_archiv WHERE count_mode = 1
47) SELECT COUNT(*) FROM cs_count
/var/www/web597/html/clansphere/mods/count/navall.php
48) SELECT count_num FROM cs_count_archiv
49) SELECT COUNT(*) FROM cs_count

|

|