ganzes Hunting Z tut nicht mehr

Question

Bug #

591

Priorität

2 (🔸 Hoch)

Bereich

Hunting z

Title

ganzes Hunting Z tut nicht mehr

Beschreibung

MySQL 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

IneX @ 12.06.2006 14:44

Git Commit

Assigned to

[z]bert @ 26.05.2009 08:49

Status

Resolved @ 03.06.2009 10:24