Bug Games wont play due to conflict with jackpot

[Freekoid]

Getting this error

Database error in vBulletin 4.1.9:

Invalid SQL:
UPDATE dbtech_vbarcade_game SET jackpot = jackpot + WHERE gameid = 'ghost_vs_zombies';

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 'WHERE gameid = 'ghost_vs_zombies'' at line 1
Error Number : 1064
Request Date : Friday, December 16th 2011 @ 11:07:13 AM
Error Date : Friday, December 16th 2011 @ 11:07:15 AM
Script : http://www.muppet-testee.info/test/arcade.php?do=load&game=ghost_vs_zombies
Referrer : http://www.muppet-testee.info/test/arcade.php?game=ghost_vs_zombies
IP Address : *
Username : ***
Classname : vB_Database
MySQL Version : 5.1.56

Alternate Point System : dbtech_vbshop_points
Only one jackpot set for the above error game



different games result in the same error .... WHERE gamedid = 'the_7_elders'' at line 1

Oh theres the error ^^ you have ' and " in the same line John

 

[Darkwaltz4]

Are you charging to play?

Also, what does "Oh theres the error ^^ you have ' and " in the same line John" mean?

 

[Freekoid]

Are you charging to play?

I didnt charge to play as I couldnt find that setting

Also, what does "Oh theres the error ^^ you have ' and " in the same line John" mean?

I though you couldnt use syntax of apostrophe and quote in the same line, I'm probably wrong..

 

[Darkwaltz4]

You set price to play as part of your arcade permissions sets

Anyway, the error should go away if you edit some arcade category or permission and save it (even if you dont change it).

Should have put the arcade-cache call in the jackpot installer, so ill mark this a fixed bug for the next version

 

[Freekoid]

Error went away when I set my permission of price to play to 10 ie globally

I set a new permission of a single game permission of price to play to 20 then removed my 'set my original permission' back to free to play error came back.

But I can play the set price game.

 

[Darkwaltz4]

it doesnt work when you save a 0 or blank?

 

[Freekoid]

Tried 0 and it ignored and saved as normal ie showing 'free to play'

 

[Darkwaltz4]

So when it is free to play, you always get that database error?

 

[Freekoid]

Free to play is fine.

 

[Darkwaltz4]

So are you still getting the error?

 

[Freekoid]

Did some more testing..

Once the XML for jackpots is installed 'play for free' ie making no setting changes makes the arcade result in a database error due to the fact that you have to set a minimum price, but the problem is it wont allow you to set 0 so you can play for free.

I tried different combinations, I even tried setting the global permission to a set price and then used a new permission which was weighted and set this to free which still results in the same error.

 

[Darkwaltz4]

edit the vBArcade - Deduct Game Price plugin, find in the php code this:

if ($vbulletin->options['dbtech_vbarcade_credits_dynamic'])

replace with

if ($vbulletin->options['dbtech_vbarcade_credits_dynamic'] AND !empty($vbcredits[1]))

should take care of it

 

[Freekoid]

There is no such plugin called .. vBArcade - Deduct Game Price plugin

 

[Darkwaltz4]

You are looking at the set from vBArcade. Scroll to the set from the Jackpots and Prices addon. Try using your browser's search function (ctrl/cmd+f)

 

[Freekoid]

Found and edited, I was associating it with the main arcade and not the extra plugin :|

 

[Darkwaltz4]

so did that take care of it for you?