Bug Database error when deleting games.

[skol]

Syntax error when trying to delete a game..

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT tournid FROM dbtech_vbarcade_tourn WHERE gameid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

[skol]

It happens when your deleting a game in the arcade,not a problem with tournament deletions.

 

[Darkwaltz4]

I found this myself a couple days ago.

in (forum)/(admincp)/arcade_admin.php

find

$qgameid = "'" . $db->escape_string($vbulletin->GPC['gameid']) . "'";

move to above

$tourns = $db->query_read("SELECT tournid FROM " . TABLE_PREFIX . "dbtech_vbarcade_tourn WHERE gameid = $qgameid");