[madhouse]

john ,

Got an issue with mysql error...It worked the first time but tried to play it again , and this is the messege I got.

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT gamechallenges.*, user.username, user.userid, games.title, user2.username AS username2, user2.userid AS userid2 FROM gamechallenges
LEFT JOIN user AS user ON gamechallenges.challengerid = user.userid
LEFT JOIN user AS user2 ON gamechallenges.challengedid = user2.userid
LEFT JOIN games AS games ON gamechallenges.game = games.shortname
WHERE (challengedid=1
AND status=0) OR (challengerid=1
AND status=2)

mysql error: Column: 'status' in where clause is ambiguous

mysql error number: 1052

Date: Sunday 18th of January 2004 10:55:35 AM
Script: http://www.modcentral.us/forum/arcade.php?
Referer: http://www.modcentral.us/forum/index.php?