joinen geht nicht
| Bug # | 133 | ||||
| Priorität | 1 (🔺 Sehr Hoch) | ||||
| Bereich | Hunting z | ||||
| Title | joinen geht nicht | ||||
| Beschreibung | hier fehler: ****************************** MySQL Error: 1109 Unknown table '$it' in where clause SQL-Query: SELECT g.*, m.players awaitingplayers, count(numpl.user) numplayers, if(p.user IS NULL, 0, 1) joined FROM hz_games g, hz_players numpl, hz_maps m LEFT JOIN hz_players p ON p.game=g.id AND p.user=66 WHERE g.id=$it.id AND g.state='open' AND numpl.game=g.id AND m.id=g.map GROUP BY numpl.game FILE: /home/CME/z/zooomclan/www/scripts/hz_game.fnc.php Line: 69 ****************************** | ||||
| Reported by | nijk @ | ||||
| Git Commit | |||||
| Assigned to | [z]biko @ 11.08.2004 16:47 | ||||
| Status | Resolved @ | ||||
| |||||