Bug Database error

[DxtGaming]

All acade pages giving this error
Database error in vBulletin 4.1.5:
Not sure what happened there but I think its a bug
(I am not the guy in charge of the FTP so I am not sure if its an issue on our side or no but if you need an account I will ask him to give you one to verify it)

Invalid SQL:
UPDATE dbtech_vbarcade_data SET global_link = '', global_user = '', global_score = 0, local_winner = 0, local_plays = 1, local_avgscore = , local_timespent = 170, global_plays = 0, global_avgscore = 0, global_timespent = 0 WHERE gameid = 'berzerk-ball';

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_timespent = 170, global_plays = 0, global_avgscore = 0, global_timespent ' at line 1
Error Number : 1064
Request Date : Tuesday, August 16th 2011 @ 02:13:52 PM
Error Date : Tuesday, August 16th 2011 @ 02:13:52 PM
Script : http://www.dxtgaming.com/forums/arcade.php?game=avalon-simon-says
Referrer : http://www.dxtgaming.com/forums/arcade.php
IP Address : *************
Username : Dxt-Devil_Qc
Classname : vB_Database
MySQL Version : 5.0.92-community

 

[Darkwaltz4]

To fix, edit arcade.php, find

local_avgscore = " . $stats['avgscore']

replace with

local_avgscore = " . doubleval($stats['avgscore'])

 

[DxtGaming]

Thank you ! It solved the issue

 

[DxtGaming]

When I click on Action tab
This error appear and soon as I click in Search field it disappear

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/arcade.php on line 608

I am not sure if I should have make another thread
And I have a lil question too: Do all tabs are being displayed or only them with games?

 

[Darkwaltz4]

Please start new threads for new issues, so i can track them separately