Clansphere :: FREE Clan Content Management System

/var/www/system/core/account.php
1) SELECT * FROM cs_users WHERE users_id = 1 AND users_active = 1 AND users_delete = 0 LIMIT 0,1
2) UPDATE cs_users SET users_laston='1394895240' WHERE users_id = 1
/var/www/mods/count/startup.php
3) UPDATE cs_count SET count_time='1394895240', count_location='news/recent' WHERE count_id = 26
/var/www/mods/categories/functions.php
4) SELECT categories_id, categories_name, categories_subid FROM cs_categories WHERE categories_mod = 'news' AND categories_access <= '5' ORDER BY categories_subid ASC, categories_name
/var/www/mods/news/recent.php
5) SELECT COUNT(DISTINCT news_id) FROM cs_news nws INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public = 1 AND cat.categories_access <= 5
6) 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, usr.users_active AS users_active, usr.users_delete AS users_delete, nws.categories_id AS categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name, nws.news_mirror AS news_mirror, nws.news_mirror_name AS news_mirror_name, nws.news_readmore AS news_readmore, nws.news_readmore_active AS news_readmore_active FROM cs_news nws INNER JOIN cs_users usr ON nws.users_id = usr.users_id INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public = 1 AND cat.categories_access <= 5 ORDER BY news_attached DESC, news_time DESC LIMIT 0,6
/var/www/mods/sponsors/navlist.php
7) SELECT sponsors_id, sponsors_name, sponsors_url, sponsors_alt, sponsors_nimg FROM cs_sponsors WHERE sponsors_nimg != '' ORDER BY RAND() LIMIT 0,1
/var/www/mods/videogallery/navlist.php
8) SELECT videogallery_id, categories_id, videogallery_date, videogallery_name, videogallery_upload, videogallery_link, videogallery_text, videogallery_count, videogallery_link_active, videogallery_hoster FROM cs_videogallery ORDER BY videogallery_id DESC,videogallery_date DESC LIMIT 0,1
/var/www/mods/users/navlogin_new.php
9) SELECT users_picture, users_country FROM cs_users WHERE users_id = 1 LIMIT 0,1
10) SELECT COUNT(*) FROM cs_blog_user WHERE users_id = 1
11) SELECT COUNT(*) FROM cs_blog WHERE users_id = 1
12) SELECT users_id, squads_id FROM cs_members WHERE users_id = '1' AND members_admin = '1' LIMIT 0,1
13) SELECT COUNT(*) FROM cs_messages WHERE users_id_to = 1 AND messages_show_receiver = 1 AND messages_view = 0
/var/www/mods/wars/navlist_new.php
14) 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_date AS wars_date, war.wars_id AS wars_id FROM cs_wars war 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,6
/var/www/mods/wars/navnext_new.php
15) 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 > 1394895240 AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,6
/var/www/mods/files/navlist_new.php
16) SELECT files_name, files_time, files_id, files_count FROM cs_files fls INNER JOIN cs_categories cat ON fls.categories_id = cat.categories_id WHERE cat.categories_access <= 5 ORDER BY files_count DESC LIMIT 0,1
17) SELECT files_name, files_time, files_id, files_count FROM cs_files fls INNER JOIN cs_categories cat ON fls.categories_id = cat.categories_id WHERE cat.categories_access <= 5 ORDER BY files_time DESC LIMIT 0,5
/var/www/mods/board/navlist_new.php
18) SELECT users_readtime FROM cs_users WHERE users_id = '1' LIMIT 0,1
19) SELECT thr.threads_headline AS threads_headline, thr.threads_id AS threads_id, thr.threads_last_time AS threads_last_time, frm.board_name AS board_name, frm.board_id AS board_id 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 = '1' LEFT JOIN cs_members mrs ON frm.squads_id = mrs.squads_id AND mrs.users_id = '1' WHERE (frm.board_access <= '5' OR frm.squads_id = mrs.squads_id) AND frm.board_pwd = '' ORDER BY thr.threads_last_time DESC LIMIT 0,8
/var/www/mods/votes/navlist_new.php
20) SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1394895240' AND votes_end >= '1394895240' ORDER BY votes_end ASC LIMIT 0,1
/var/www/mods/slider/navlist.php
21) SELECT * FROM cs_slider ORDER BY slider_id DESC LIMIT 0,5
/var/www/mods/banners/navlist_new.php
22) SELECT banners_picture, banners_alt, banners_url FROM cs_banners ORDER BY RAND() LIMIT 0,1
/var/www/mods/gallery/navlist_new.php
23) SELECT gal.gallery_id AS gallery_id, gal.gallery_titel AS gallery_titel, fol.folders_name AS folders_name FROM cs_gallery gal INNER JOIN cs_folders fol ON gal.folders_id = fol.folders_id WHERE gal.gallery_access < '5' AND gal.gallery_status = '1' ORDER BY gal.gallery_id DESC LIMIT 0,10
/var/www/mods/wars/navtop_new.php
24) SELECT war.wars_date AS wars_date, sqd.squads_name AS squads_name, sqd.squads_id AS squads_id, sqd.squads_picture AS squads_picture, cln.clans_name AS clans_name, owncln.clans_picture AS squad_picture, cln.clans_picture AS clans_picture, cln.clans_id AS clans_id, 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 INNER JOIN cs_clans owncln ON owncln.clans_id = sqd.clans_id WHERE war.wars_date > 1394895240 AND war.wars_status = 'upcoming' AND war.wars_topmatch = 1 ORDER BY RAND() LIMIT 0,1
/var/www/mods/events/navcal.php
25) SELECT users_age FROM cs_users WHERE users_age LIKE '%-03-%' AND users_hidden NOT LIKE '%users_age%'
26) 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 >= '1393624800' AND events_time <= '1396295999' AND cat.categories_access <= 5
27) SELECT wars_date AS events_time FROM cs_wars WHERE wars_date >= '1393624800' AND wars_date <= '1396295999'
/var/www/mods/shoutbox/navlist_new.php
28) SELECT COUNT(*) FROM cs_shoutbox
29) SELECT shoutbox_name, shoutbox_text, shoutbox_date FROM cs_shoutbox ORDER BY shoutbox_date ASC LIMIT 0,6
/var/www/mods/squads/navlist.php
30) SELECT squads_name, squads_picture2, squads_id FROM cs_squads WHERE squads_own = '1' AND squads_joinus = '0' AND squads_fightus = '0' AND squads_picture2 != '' ORDER BY squads_order ASC

|