Clansphere :: FREE Clan Content Management System

/var/www/web255/html/clan/system/core/functions.php
1) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
/var/www/web255/html/clan/system/core/account.php
2) SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime, users_ajax, users_tpl, users_pwd FROM cs_users WHERE users_id = '49' AND users_pwd = 'e35efdb935133e45c8c469a3a149299c57f15f65' AND users_active = 1 LIMIT 0,1
3) UPDATE cs_users SET users_laston='1238235392' WHERE users_id='49'
4) SELECT * FROM cs_access WHERE access_id = 5 LIMIT 0,1
/var/www/web255/html/clan/system/runstartup/fckeditor.php
5) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'fckeditor'
/var/www/web255/html/clan/system/runstartup/count.php
6) SELECT count_id, count_time FROM cs_count WHERE count_ip = '91.15.74.171' ORDER BY count_id DESC LIMIT 0,1
7) UPDATE cs_count SET count_time='1238235392', count_location='news/recent' WHERE count_id='6630'
8) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
/var/www/web255/html/clan/system/runstartup/news.php
9) SELECT news_publishs_at FROM cs_news WHERE news_public = 0 AND news_publishs_at != 0 ORDER BY news_publishs_at ASC LIMIT 0,1
/var/www/web255/html/clan/mods/news/recent.php
10) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'news'
11) SELECT * FROM cs_categories WHERE categories_mod = 'news' AND categories_access <= 5 ORDER BY categories_name
12) 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 > 0 AND cat.categories_access <= 5
13) 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 > 0 AND cat.categories_access <= 5 ORDER BY news_attached DESC, news_time DESC LIMIT 0,5
16) SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 54
17) SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 53
18) SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 52
19) SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 51
20) SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = 50
/var/www/web255/html/clan/system/core/abcode.php
14) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'abcode'
15) SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
/var/www/web255/html/clan/mods/clansphere/navmeta.php
21) SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
/var/www/web255/html/clan/mods/users/navlogin.php
22) SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '49' AND messages_show_receiver = 1 AND messages_view = 0
23) SELECT COUNT(*) FROM cs_mail WHERE mail_answered = 0
/var/www/web255/html/clan/mods/ticker/display.php
24) SELECT * FROM cs_ticker tck JOIN cs_options opt ON opt.options_mod='ticker' WHERE tck.ticker_id=opt.options_value AND opt.options_name='active_id' LIMIT 0,1
/var/www/web255/html/clan/mods/ticker/func.php
25) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'ticker'
/var/www/web255/html/clan/mods/ticker/userticker.php
26) SELECT users_id, users_nick FROM cs_users ORDER BY users_register DESC LIMIT 0,3
/var/www/web255/html/clan/mods/ticker/newsticker.php
27) SELECT news_id, news_headline, news_time FROM cs_news WHERE news_public > 0 ORDER BY news_time DESC LIMIT 0,3
/var/www/web255/html/clan/mods/count/navone.php
28) SELECT COUNT(*) FROM cs_count WHERE count_time > '1238235092'
/var/www/web255/html/clan/mods/count/navday.php
29) SELECT COUNT(*) FROM cs_count WHERE count_time > '1238191200'
/var/www/web255/html/clan/mods/count/navyes.php
30) SELECT COUNT(*) FROM cs_count WHERE count_time > '1238104800' AND count_time < '1238191199'
/var/www/web255/html/clan/mods/count/navmon.php
31) SELECT COUNT(*) FROM cs_count WHERE count_time > '1235858400'
/var/www/web255/html/clan/mods/count/navall.php
32) SELECT count_num FROM cs_count_archiv
33) SELECT COUNT(*) FROM cs_count
/var/www/web255/html/clan/mods/wars/navnext.php
34) 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 > '1238235392' AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,4
/var/www/web255/html/clan/mods/wars/navlist.php
35) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'wars'
36) 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/web255/html/clan/mods/users/navonline.php
37) SELECT users_id, users_nick, users_country, users_active, users_invisible FROM cs_users WHERE users_laston > 1238235092 AND users_active = '1' AND users_invisible = '0' ORDER BY users_laston DESC LIMIT 0,8
/var/www/web255/html/clan/mods/users/navbirth.php
38) SELECT users_id, users_nick, users_age, users_active FROM cs_users WHERE users_age LIKE '%-03-28' AND users_hidden NOT LIKE '%users_age%' AND users_active = '1' ORDER BY users_nick ASC LIMIT 0,4
/var/www/web255/html/clan/mods/votes/navlist.php
39) SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1238235392' AND votes_end >= '1238235392' ORDER BY RAND() LIMIT 0,1
/var/www/web255/html/clan/mods/events/navcal.php
40) SELECT options_name, options_value FROM cs_options WHERE options_mod = 'events'
41) SELECT users_age FROM cs_users WHERE users_age LIKE '%-03-%' AND users_hidden NOT LIKE '%users_age%'
42) 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 >= '1235865600' AND events_time <= '1238543999' AND cat.categories_access <= 5
43) SELECT wars_date AS events_time FROM cs_wars WHERE wars_date >= '1235865600' AND wars_date <= '1238543999'
/var/www/web255/html/clan/mods/banners/navlist.php
44) SELECT banners_picture, banners_alt, banners_url FROM cs_banners ORDER BY banners_order ASC

|

|

|

|