Can't, it works off whole numbers only.


Is anyone betting on the other team? Winners divide up the total that has been bet, so if no one bets on the other team you only get your money back as that is all that was in the pot.

I've seen it a few times as well now, will be looking into it in the next few days.

Hey Andrew Green, how are we looking on the raffle system?

Great hack, my members are loving this, and going broke on a regular basis

Perhaps not... but what contols the jackpot? How can I change it?

The mod looks brilliant, I have one query tho.

I'm currently using vcash on my site and want the casino mod to use the same. Instead of casino_cash what do I put int he settings to make vcash the default monetary value?

Immediate help required! :D

Just seen this. Answered my question! :D <3

Not sure which files would have done it but the problem did not exist until I upgraded to the newest version. The ones before that were fine. Any idea of where to even start looking?



SVT

The Numbers used, how many numbers get drawn, the range on those numbers and the ticket price. Also it will adjust over time based on how many tickets have been bought.



What version where you using previously?

Not quite.

I'd be dead by now if hearing the same question over and bloody over again could hurt me.:D

Actually, I feel sorry for those poor saps that are unable to help themselves. How can they even run a vBulletin site?

we have been trying texas hold em on our board with 5 players, but it seems that the game is pushing down our server performance while we are playing.
is the game loading all informations directly from the database ?

Yes, but all is a as little as it can get away with from as small of tables as it can get away with. I will look at optimizing it as much as I can, but I don't expect a huge difference. You can turn the delay time up, which will cut that back a little. But any multiplayer game that runs through the server is going to use some resources.

wouldn't it be possible to make it all in flas so that it is not using the database for getting the data from ?
I think this is a big problem if you have a big board where many users are online. we use a server only for our forum, and our database has alot of resources that can be used but it still pushes down the whole performance of our board while only 4 users are playing. the performance was down that you nearly couldn't reach our website. and loading a single site needs up to 6 or 8 seconds which is way to much.
i realy like the casino and if this problem could be fixed I would love to install it and make it accessable for all of our users. I would really like to help with this, but my programming skills are too bad. do you see any chances for fixing this problems ?

The reason I am asking is... I am using vbcredits. I run this wednesdays (it defaults to 11pm). I've been using it for about 6 weeks... My forum members and myslef seen the jackpot get up to over 5000... there has never been a winner, but after that drawing and no winner, the jaclpot went down to 1200 something for the next drawing. So it is not holding the balance or allowing the balance to carry forward. Can admins get control of that jackpot balance for the lottery please? It is getting some folks upset cause they see no winner, but the jackpot goes down... and they are calling that unfair... and I agree!

I hear ya!

This kind of says it all here...

(rule #2)

bwahahaa!!!! :D

vBulletin Message

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:

* Bitfield Collision: prefixrequired = credits_cantearn

What do I do?

That doesn't look like it has anything to do with the casino?

No it has to do with vbcredits and the latest release of 3.7.0 betas.

how about using sockets?

http://forum.tufat.com/showthread.php?t=25042

Just to confirm, there is a bug in the lottery, has to do with how the odds are calculated which throws the JP off. This is fixed in my development version, so next update it will be gone. Replace existing file (includes/cron/ folder) with attached to solve it now, won't show fixed until a new draw is created.

Thanks Andrew... I updated with this, but now my Lottery is stuck on charging 2 credits when I have it set for 10. I refreshed over and over... I ran the Lottery Draw task manually... still stuck on 2. I know it was set and changed on 10 prior to this... I am not sure what happened...

Also, we started to try the Sports Betting in Casino on some football games. I settled them, but I can not see how what the jackpot is or how it was distributed. Me as the admin can't even see what a user won or lost. Is there plans to change this in your new version?

Thanks...

Until the existing draw is over a new one won't get created.

i just upgraded and lost all my big chips .. it goes to 10 bucks thats it

Go to the game settings and turn them on.

they are on ;) thats the first thing i checked

ok i went in and reset all the chips and clicked update settings now the entire area to set chip values is gone from the admin panel and still 10 bucks is as high as the chips go the last thing you see in settings is as far as it goes

https://vborg.vbsupport.ru/

Got multiple Database errors Last Night

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT sum(bet) AS bet, sum(won) AS won, cs1.switch2
FROM casino_settings AS cs1
LEFT JOIN casino_settings AS cs2 ON cs1.switch1 = cs2.switch1
LEFT JOIN casino_bet_stats ON cs1.switch1 = gameid
WHERE cs1.settingname = 'gamename'
AND cs2.settingname = 'gameactive'
AND cs2.switch2 = '1'
GROUP BY gameid;

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Monday, December 31st 2007 @ 02:54:13 AM
Script : http://www.dieselbombers.com/casino.php
Referrer :
IP Address :
Username :
Classname : vb_database

Any Fix?

Yes, I understand that... but the ticket amount won't change until the new drawing? That's strange... Shortly after I installed the Casino I set it at 10. I refreshed my browser and went to the Casino Lottery and it showed 10. All I done was updated this latest file and ran the lottery task... I noticed that the ticket amount is now 2. I went to the settings and it is 10. I resaved it, refreshed my browser and went back to the Casino lottery and it is still 2. It is like it doesn't care what the admin settings are... I shouldn't have to wait until a new drawing to change the amount of the ticket, right?

They've just moved, the acp got restructured, look under "Casino -> Game Settings".

Need to add a index to switch1 in the casino_settings table, this can be done through phpmyadmin. Will also set the next update to do it on install.


When the admincp got reworked all of the settings reverted to their defaults, chips in use, names, descriptions and lottery settings. That's why it is back to 2.

You also cannot change a draw once it has been started, changes always effect the next draw created, never ones that are already up. The reason is, lets say the ticket price is 1, I but 10 tickets, you change the ticket price to 10, this effects jackpots and has other people paying more then I did for the same tickets. Another problem is lets say I pick the numbers 10, 15 & 23. Then you go and change the number range to 1-15, yet I have a ticket with 23 on it.

Superb mod - my members love it !

I only have one problem - Texas Hold 'Em worked when i first installed. Once i posted to the board for people to test EVERYONE (inc me) gets the message "This game is AJAX powered and requires javascript to be turned on"

I also see others with this same problem - any help is appreciated

My setup:
vb 3.6.4
Vista / IE7

What Query do i send to the database im getting 10 of these database emails every 12 hours

Re: What did you do to do this
Quote: Originally Posted by DieselMinded
Quote: Originally Posted by MEMBER
Quote: Originally Posted by DieselMinded
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT sum(bet) AS bet, sum(won) AS won, cs1.switch2
FROM casino_settings AS cs1
LEFT JOIN casino_settings AS cs2 ON cs1.switch1 = cs2.switch1
LEFT JOIN casino_bet_stats ON cs1.switch1 = gameid
WHERE cs1.settingname = 'gamename'
AND cs2.settingname = 'gameactive'
AND cs2.switch2 = '1'
GROUP BY gameid;

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Monday, December 31st 2007 @ 06:46:05 PM
Script : http://www.dieselbombers.com/casino.php?
Referrer : http://www.dieselbombers.com/
IP Address : ipipipipipip
Username : MEMBER
Classname : vb_database


????

Did you get an error in the casino a little bit ago?


Ya I had $70 and tried to bet $100

Hi Andrew... Ok, that makes sense. I'll wait until the next drawing for it to change to the correct amount.

Is there a quick fix to remove games that are not active from the Casino menu? I thought you had this fixed at one time... not sure, but I don't use the Texas Hold 'em... and it is annoying to have users constantly ask about it cause it is on the Casino menu, but when they click it, they get the typical vb error of not having permission.

Thanks for your great Mod! And Happy New Year!!!

Andrew! Help! I just setup a Sports Bet for the NFL playoffs... AFC and NFC having multiple games for each. I saved them and refreshed my browser... Now I get a database error with no details. How frustrating. I can't do anything because of this error. I can't even get into my adminCP... anything I do I get a database error.

[Edit] Andrew... Nevermind. I figured it. I needed to change something in my config.php file so the admin could change the admin user account... I uploaded it and didn't realize it had the wrong database name in it... False alarm... Sorry....

is it possible to add more games.... like No limit holdem?

No query, do it through phpmyadmin.

Select the table, it will show the structure, beside each field there will be a bunch of little boxes, click the one that says "index"

Thanks Sir

I have a bit of a weird problem. In my casino, I have all the chips set up and I can see them.

It does not allow me to choose the 500 and 100 for some reason. That is as high as it goes and its just those two.

I combed the settings and couldn't figure it out. I also unchecked and rechecked all, after that re saved the overall casino settings.

EDIT--Sorry, I figured it out. Table limit field.

I love this. I just wanted to add that so far this is working fine with 3.7 beta 3.