Error: C:\sites\gtfsite\mods\medals\users.php -> cs_sql_select - Column 'users_id' in where clause is ambiguous
C:\sites\gtfsite\system\core\account.php
1) 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 = 1 AND users_pwd = 'eb26786dbe99ec37e9fa4744d57b220a946b1a37' AND users_active = 1 LIMIT 0,1
2) UPDATE cs_users SET users_laston='1247732114' WHERE users_id = 1
C:\sites\gtfsite\system\runstartup\count.php
3) UPDATE cs_count SET count_time='1247732114', count_location='medals/users' WHERE count_id = 52566
C:\sites\gtfsite\system\core\tools.php
4) SELECT users_nick, users_active, users_delete FROM cs_users WHERE users_id = '1' LIMIT 0,1
5) SELECT COUNT(*) FROM cs_usersgallery WHERE users_id = '1'
6) SELECT COUNT(*) FROM cs_members WHERE users_id = '1'
7) SELECT COUNT(*) FROM cs_computers WHERE users_id = '1'
8) SELECT COUNT(*) FROM cs_buddys WHERE users_id = '1'
9) SELECT COUNT(*) FROM cs_gbook WHERE gbook_users_id = '1' AND (gbook_lock = 1)
10) SELECT COUNT(*) FROM cs_medalsuser WHERE users_id = '1'
11) SELECT COUNT(*) FROM cs_players WHERE users_id = '1' AND (players_played = 1)
C:\sites\gtfsite\mods\gallery\navlist.php
12) SELECT gallery_id FROM cs_gallery WHERE gallery_access < '5' AND gallery_status = '1' ORDER BY gallery_id DESC
C:\sites\gtfsite\mods\banners\navlist.php
13) SELECT banners_picture, banners_alt, banners_url FROM cs_banners ORDER BY banners_order ASC
C:\sites\gtfsite\mods\bannerrotation\navlist.php
14) SELECT bannerrotation_id, bannerrotation_image, bannerrotation_alt, bannerrotation_views FROM cs_bannerrotation WHERE bannerrotation_activated = '1' ORDER BY rand() LIMIT 0,1
15) UPDATE cs_bannerrotation SET bannerrotation_views='69324' WHERE bannerrotation_id = 11
16) UPDATE cs_options SET options_value='11' WHERE options_mod = 'bannerrotation' AND options_name = 'last_id'
C:\sites\gtfsite\mods\users\navlast.php
17) SELECT users_id, users_nick, users_register, users_active FROM cs_users WHERE users_active = '1' ORDER BY users_register DESC LIMIT 0,4
C:\sites\gtfsite\mods\users\navonline.php
18) SELECT users_id, users_nick, users_country, users_active, users_invisible FROM cs_users WHERE users_laston > 1247731814 AND users_active = '1' AND users_invisible = '0' ORDER BY users_laston DESC LIMIT 0,8
C:\sites\gtfsite\mods\count\navone.php
19) SELECT COUNT(*) FROM cs_count WHERE count_time > '1247731814'
C:\sites\gtfsite\mods\count\navyes.php
20) SELECT COUNT(*) FROM cs_count WHERE count_time > '1247601600' AND count_time < '1247687999'
C:\sites\gtfsite\mods\count\navday.php
21) SELECT COUNT(*) FROM cs_count WHERE count_time > '1247688000'
C:\sites\gtfsite\mods\count\navmon.php
22) SELECT SUM(count_num) AS count FROM cs_count_archiv WHERE count_mode = 1
23) SELECT COUNT(*) FROM cs_count
C:\sites\gtfsite\mods\count\navall.php
24) SELECT count_num FROM cs_count_archiv
25) SELECT COUNT(*) FROM cs_count
C:\sites\gtfsite\mods\ticker\display.php
26) 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
C:\sites\gtfsite\mods\ticker\userticker.php
27) SELECT users_id, users_nick FROM cs_users ORDER BY users_register DESC LIMIT 0,3
C:\sites\gtfsite\mods\ticker\filesticker.php
28) SELECT files_id, files_name, files_version FROM cs_files ORDER BY files_time DESC LIMIT 0,3
C:\sites\gtfsite\mods\ticker\newsticker.php
29) SELECT news_id, news_headline, news_time FROM cs_news WHERE news_public > 0 ORDER BY news_time DESC LIMIT 0,3
C:\sites\gtfsite\mods\wars\navnext.php
30) 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 > '1247732114' AND war.wars_status = 'upcoming' ORDER BY war.wars_date ASC LIMIT 0,4
C:\sites\gtfsite\mods\wars\navlist.php
31) 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_clans cln ON war.clans_id = cln.clans_id WHERE war.wars_status = 'played' ORDER BY war.wars_date DESC LIMIT 0,4
C:\sites\gtfsite\mods\users\navlogin.php
32) SELECT COUNT(*) FROM cs_messages WHERE users_id_to = 1 AND messages_show_receiver = 1 AND messages_view = 0
33) SELECT COUNT(*) FROM cs_mail WHERE mail_answered = 0
C:\sites\gtfsite\mods\votes\navlist.php
34) SELECT votes_id, votes_question, votes_election, votes_several FROM cs_votes WHERE votes_access <= '5' AND votes_start <= '1247732114' AND votes_end >= '1247732114' ORDER BY RAND() LIMIT 0,1
C:\sites\gtfsite\mods\events\navcal.php
35) SELECT users_age,users_nick FROM cs_users WHERE users_age LIKE '%-07-%' AND users_hidden NOT LIKE '%users_age%'
36) 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
37) SELECT events_time,events_name,events_more FROM cs_events WHERE events_time >= '1246392000' AND events_time <= '1249070399'
38) SELECT wars_date AS events_time FROM cs_wars WHERE wars_date >= '1246392000' AND wars_date <= '1249070399'
39) SELECT wars.wars_date AS wdate,clans.clans_name AS enemy,categories.categories_name AS category FROM cs_wars wars INNER JOIN cs_clans clans ON (clans.clans_id = wars.clans_id) INNER JOIN cs_categories categories ON (categories.categories_id = wars.categories_id) WHERE wars_date >= '1246392000' AND wars_date <= '1249070399'
C:\sites\gtfsite\mods\events\nav_birthday.php
40) SELECT users_id,users_nick,users_country,users_age,users_active,users_delete FROM cs_users WHERE users_age LIKE '%-07-16' AND users_active = '1'
C:\sites\gtfsite\mods\shoutbox\navlist.php
41) SELECT COUNT(*) FROM cs_shoutbox
42) SELECT shoutbox_name, shoutbox_text, shoutbox_date FROM cs_shoutbox ORDER BY shoutbox_date ASC LIMIT 3510,5
C:\sites\gtfsite\system\core\abcode.php
43) SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
44) SELECT abcode_pattern, abcode_file FROM cs_abcode WHERE abcode_func = 'img' LIMIT 0,10

Das Leben ist ein Scheiß Spiel hat aber ne Geile Grafik

|

|

|