Bug Winning Jackpots

[TandyServices]

Jackpot

Is there a way to Manual Query all games to have a jackpot of 50? I have over 5000 games to add it to..

 

[Darkwaltz4]

you can go to manage games and change your number of displayed games to something your server can comfortably show (maybe 500? experiment)

then click the Select All box at the top (or the checkboxes of individual games along next to each one) and at the bottom you can pick Jackpot from the Selected: dropdown, and then an amount you wish to apply, and then the Update Games button.

 

[TandyServices]

yea that is taking a really long time.. Can only do like 100 at a time.. Figured there was a Query to do it some how

 

[Darkwaltz4]

If you wanna run a query that affects all games, it looks like:

UPDATE dbtech_vbarcade_game SET jackpot = X

Decide what you want for X and include your table prefix.

 

[TandyServices]

Thank you that worked great..

 

[TandyServices]

I have all the jackpots setup for 50 credits on members. The first time the game is played that member wins the 50 credits. The problem is: I don't think there getting the credits for winning it. The jackpot goes to empty but the credits are not added to that members credits..

 

[TandyServices]

I should also add.. I noticed when I play a game a few time and pay the 5 credits to play.. Those 5 credits are to go into the jackpot.. Well I would say if I play ten times only 2 or three of the times the jackpot goes up? Maybe i have a setting wrong?

 

[Darkwaltz4]

Check your main vbarcade settings:
Do you have Dynamic Jackpots set to Yes? That will cause price paid to be added to the jackpots. Have you set prices to play in the Manage Permissions section?
Do you have nothing set for Alternate Points System? If so, you need to have created Play Game and Win Game events

 

[TandyServices]

I think I have it fixed.. I think there was another mod conflicting with the Jackpots and other things.. But as of right now. I seems to be working..

Thank You for your help..