ganzes Hunting Z tut nicht mehr

24
Bug #
Priorität2 (🔸 Hoch)
BereichHunting z
Titleganzes Hunting Z tut nicht mehr
BeschreibungMySQL Error: 1054

Unknown column 'g.id' in 'on clause'

SQL-Query: SELECT g.*, unix_timestamp(g.turndate) turndate, z.user z, m.name mapname,
if(me.type='z' && g.nextturn='z' || me.type!='z' && g.nextturn='players' && me.turndone='0', '1', '0') myturn
FROM hz_games g, hz_players z, hz_maps m
LEFT JOIN hz_players me ON me.user='117' AND me.game=g.id
WHERE g.state='running' AND z.game=g.id AND z.type='z' AND m.id=g.map AND me.user='117'
ORDER BY g.turndate DESC

FILE: /home/CME/zooomclan/www/scripts/hz_overview.php
Line: 17
Function:
Reported by @
 
Git Commit
Assigned to @ 26.05.2009 08:49
StatusResolved @ 24
1 up | 2 up | 3 up | 4 up | 5 up | 6 up | 7 up | 8 up | 9 up | 10 up | 11 up | 12 up |
^^^ Additional posts ^^^
zorg.ch
#109852 by @ 03.06.2009 22:34 - nach oben -
rethink your new queries :)
zorg.ch
#109855 by @ 03.06.2009 23:00 - nach oben -
haha, tschuder hat damals auch daran gezweifelt :-)
naja, in vielen fällen werden tables mehrfach instanziiert - spätestens dann hätte dein ansatz versagt...