[Nexus[l33t]]

]

Originally Posted by AutomatikStudio

Hmmm...I searched in arcade.php and the phrase "SET highscoreid" wasn't anywhere in it.

it's actually in arcadeupdate.php. i was having the same problem with the error messages.....

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE games SET highscorerid=,highscore=118 WHERE shortname='pedestriankiller' 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 'highscore=118 WHERE shortname='pedestriankiller'' at line 1

i think this guy knew what the deal was. i applied that fix and it seems to be working fine at the moment. we'll see how it goes, but here's his post.....

https://vborg.vbsupport.ru/showpost....postcount=1708

but to make it easier for somebody who might be having this problem, in arcadeupdate.php find...

if ($scores) {
	foreach ($scores as $key => $value) {
		$DB_site->query("UPDATE " . TABLE_PREFIX . "games SET highscorerid=$value[userid],highscore=$value[score] WHERE shortname='$key'");
	}
}

switch it out with this....

if ($scores) {
	foreach ($scores as $key => $value) {
		$DB_site->query("UPDATE " . TABLE_PREFIX . "games SET highscore=$value[score] WHERE shortname='$key'");
	}
}

Disclaimer: i may or may not know what the hell i'm doing. so if you kill your board it's your own damn fault. :speechless:

may the force be with you