Clansphere :: FREE Clan Content Management System

|

[clip=mehr...]/system/core/account.php
1) SELECT * FROM sc2_users WHERE users_nick = 'Cool' LIMIT 0,1
2) SELECT * FROM sc2_users WHERE users_id = '1' AND users_active = 1 AND users_delete = 0 LIMIT 0,1
3) UPDATE sc2_users SET users_laston='1294189612' WHERE users_id = 1
mods/clansphere/sec_func.php
4) UPDATE sc2_options SET options_value='1294189612' WHERE options_mod = 'clansphere' AND options_name = 'sec_time'
mods/users/navrand.php
5) SELECT users_id, users_nick, users_name, users_surname, users_picture, users_country, users_register, users_active, users_hidden FROM sc2_users WHERE users_active = '1' AND users_delete = '0' ORDER BY RAND() LIMIT 0,1
mods/banners/navlist.php
6) SELECT banners_picture, banners_alt, banners_url FROM sc2_banners ORDER BY banners_order ASC LIMIT 0,10
mods/board/navlist.php
7) SELECT users_readtime FROM sc2_users WHERE users_id = '1' LIMIT 0,1
8) 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 sc2_threads thr INNER JOIN sc2_board frm ON frm.board_id = thr.board_id LEFT JOIN sc2_read red ON thr.threads_id = red.threads_id AND red.users_id = '1' WHERE frm.board_access <= '5' AND frm.board_pwd = '' AND thr.threads_last_time > '1292980013' AND (thr.threads_last_time > red.read_since OR red.threads_id IS NULL) ORDER BY thr.threads_last_time DESC LIMIT 0,10
mods/board/functions.php
9) SELECT read_since FROM sc2_read red WHERE red.threads_id = 11 AND red.users_id = 1 LIMIT 0,1
10) SELECT read_since FROM sc2_read red WHERE red.threads_id = 20 AND red.users_id = 1 LIMIT 0,1
11) SELECT COUNT(*) FROM sc2_comments com WHERE com.comments_fid = 20 AND com.comments_mod = 'board' AND com.comments_time > 1294081344
12) SELECT threads_comments FROM sc2_threads thr WHERE threads_id = 20 LIMIT 0,1
13) SELECT opt.options_value FROM sc2_options opt WHERE opt.options_mod = 'board' AND opt.options_name = 'sort' LIMIT 0,1
14) SELECT read_since FROM sc2_read red WHERE red.threads_id = 22 AND red.users_id = 1 LIMIT 0,1
15) SELECT COUNT(*) FROM sc2_comments com WHERE com.comments_fid = 22 AND com.comments_mod = 'board' AND com.comments_time > 1293914315
16) SELECT threads_comments FROM sc2_threads thr WHERE threads_id = 22 LIMIT 0,1
17) SELECT opt.options_value FROM sc2_options opt WHERE opt.options_mod = 'board' AND opt.options_name = 'sort' LIMIT 0,1
18) SELECT read_since FROM sc2_read red WHERE red.threads_id = 23 AND red.users_id = 1 LIMIT 0,1
19) SELECT COUNT(*) FROM sc2_comments com WHERE com.comments_fid = 23 AND com.comments_mod = 'board' AND com.comments_time > 1293906785
20) SELECT threads_comments FROM sc2_threads thr WHERE threads_id = 23 LIMIT 0,1
21) SELECT opt.options_value FROM sc2_options opt WHERE opt.options_mod = 'board' AND opt.options_name = 'sort' LIMIT 0,1
22) SELECT read_since FROM sc2_read red WHERE red.threads_id = 24 AND red.users_id = 1 LIMIT 0,1
23) SELECT COUNT(*) FROM sc2_comments com WHERE com.comments_fid = 24 AND com.comments_mod = 'board' AND com.comments_time > 1293942761
24) SELECT threads_comments FROM sc2_threads thr WHERE threads_id = 24 LIMIT 0,1
25) SELECT opt.options_value FROM sc2_options opt WHERE opt.options_mod = 'board' AND opt.options_name = 'sort' LIMIT 0,1
26) SELECT read_since FROM sc2_read red WHERE red.threads_id = 3 AND red.users_id = 1 LIMIT 0,1
mods/shoutbox/navlist.php
27) SELECT COUNT(*) FROM sc2_shoutbox
28) SELECT shoutbox_name, shoutbox_text, shoutbox_date FROM sc2_shoutbox ORDER BY shoutbox_date DESC LIMIT 0,10
mods/wars/navnext.php
29) 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 sc2_wars war INNER JOIN sc2_squads sqd ON war.squads_id = sqd.squads_id INNER JOIN sc2_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_date > 1294189613 AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,4
mods/wars/navlist.php
30) 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 sc2_wars war INNER JOIN sc2_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_status = 'played' ORDER BY war.wars_date DESC LIMIT 0,4
mods/votes/navlist.php
31) SELECT votes_id, votes_question, votes_election, votes_several FROM sc2_votes WHERE votes_access <= '5' AND votes_start <= '1294189613' AND votes_end >= '1294189613' ORDER BY RAND() LIMIT 0,1

|

|

|

|

|