Bug sql error 1.0.020

[doctorsexy]

This might have been reported before but just to make sure..

getting this error

Database error in vBulletin 4.1.6:
 
Invalid SQL:
UPDATE dbtech_vbarcade_data SET global_link = '', global_user = '', global_score = , local_winner = 977, history_winner = 977, local_plays = 0, local_avgscore = 0, local_timespent = , global_plays = , global_avgscore = , global_timespent =  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 ' local_winner = 977, history_winner = 977, local_plays = 0, local_avgscore = 0, ' at line 1
Error Number  : 1064
Request Date  : Friday, September 30th 2011 @ 07:53:17 AM
Error Date    : Friday, September 30th 2011 @ 07:53:17 AM
Script        : http://www.groovie-baby.co.uk/arcade.php
Referrer      :
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version :

 

[Darkwaltz4]

when you refresh, does it go away or keep happening? does your score still get saved?

 

[Nick]

I get nearly the same error, and it does persist after I refresh:

Database error in vBulletin 4.1.6:

Invalid SQL:
UPDATE dbtech_vbarcade_data SET global_link = '', global_user = '', global_score = , local_winner = 40, history_winner = 40, local_plays = 0, local_avgscore = 0, local_timespent = , global_plays = , global_avgscore = , global_timespent =  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 ' local_winner = 40, history_winner = 40, local_plays = 0, local_avgscore = 0, lo' at line 1
Error Number  : 1064
Request Date  : Monday, October 24th 2011 @ 02:54:16 AM
Error Date    : Monday, October 24th 2011 @ 02:54:16 AM
Script        : http://www.the-nextlevel.com/tnl/arcade.php
Referrer      : 
IP Address    : [[I]omitted[/I]]
Username      : Nick
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.92-community-log

 

[doctorsexy]

I havent had it again.. just went away ...

 

[Nick]

Well, it hasn't gone away for my site. The arcade is completely useless at the moment.

 

[Darkwaltz4]

Sorry about this guys, this should fix it:

in arcade.php find

$db->query_write("UPDATE " . TABLE_PREFIX . "dbtech_vbarcade_data SET global_link = '" . $db->escape_string($score['global_link']) . "', global_user = '" . $db->escape_string($score['global_user']) . "', global_score = " . $score['global_score'] . ", local_winner = " . $score['local_winner'] . ", history_winner = " . $score['history_winner'] . ", local_plays = " . $stats['plays'] . ", local_avgscore = " . doubleval($stats['avgscore']) . ", local_timespent = " . $stats['timespent'] . ", global_plays = " . $score['global_plays'] . ", global_avgscore = " . $score['global_avgscore'] . ", global_timespent = " . $score['global_timespent'] . " WHERE gameid = '" . $score['gameid'] . "'");

replace with

$db->query_write("UPDATE " . TABLE_PREFIX . "dbtech_vbarcade_data SET local_winner = " . intval($score['local_winner']) . ", history_winner = " . intval($score['history_winner']) . ", local_plays = " . intval($stats['plays']) . ", local_avgscore = " . doubleval($stats['avgscore']) . ", local_timespent = " . intval($stats['timespent']) . ", global_link = '" . $db->escape_string($score['global_link']) . "', global_user = '" . $db->escape_string($score['global_user']) . "', global_score = " . doubleval($score['global_score']) . ", global_plays = " . intval($score['global_plays']) . ", global_avgscore = " . doubleval($score['global_avgscore']) . ", global_timespent = " . intval($score['global_timespent']) . " WHERE gameid = '" . $score['gameid'] . "'");

 

[Nick]

It worked. Thank you.