I have the latest update and mine works. Did you do any template editing or anything. If so, what did you do.

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT cs1.switch1 AS gameid, cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active
FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4
WHERE cs1.switch1=cs2.switch1
AND cs1.switch1= cs3.switch1
AND cs1.switch1= cs4.switch1
AND cs1.settingname='gamefile'
AND cs2.settingname='gamename'
AND cs3.settingname='gamedesc'
AND cs4.settingname='gameactive';

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 : Saturday, October 27th 2007 @ 11:15:58 AM
Script : http://forum.uncoverreality.com/admi...t=Update+Games
Referrer : http://forum.uncoverreality.com/admi...o_settings.php
IP Address : xxxxxxxxxx
Username : Peterpigman
Classname : vB_Database

What version of the casino are you using.

0.51

The problem is that the values above default to a too low value. To fix
this, edit your server connection and in the "MySQL Options" tab, set a
reasonable value for "Automatically limit SELECT queries to" and set the
value for "Maximum Join Size" to 1000000. That should fix these problems.

Um if that is a server setting I don't have access we are on a shared server.

You will need to get in contact with your host admin then and ask them to do this for you.

Follow on to this, I found you need at least two people in the Texas Hold Em to play, is this right or can you set it to run single player whilst you wait for others to join in?

Thanks Lee

Yeah you need at least two players, and one of the players is the dealer

Please help me, y cant uninstall it

i use 0.50 and installed over 0.51, with either of this uninstall works.

Please post the error you are getting.

hi,sorry im use translator,i'm french
I have an error message after the importation of the file:

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Saturday, October 27th 2007 @ 09:27:13 PM
Script : http://www.team76.fr/team/admincp/pl...=productimport
Referrer : http://www.team76.fr/team/admincp/pl...?do=productadd
IP Address : 62.201.69.45
Username : Team76
Classname : vb_database

can any one tell me how to do this please ?

You both need to do the same thing. Delete the casino cash column in the user table.

Steps:
1. Sign in to your phpMyAdmin.

2. On the left column, click the database you use for your forums.

3. After clicking it, it should extend to show all the tables in that database.

4. Scroll down to the user table and click it.

5. Now on the right, scroll down till you see a row that says casino_cash.

6. Directly to the right you will see a red X. Click it. That drops the column.

Now you can reinstall the product or whatever you were planning to do.

Feature Request - Would love to see when bets are settled a PM sent to the user saying it they won, lost, or drew

Excellent mod. The MP Texas just rocks! Keep up the good work dude.... :D

Hi,

I got this error, could you please tell me what to do?

Thanks in advance :)

You would be better to post that in the right forum on the vbgaming.org board.

You seem to have an error in your SQL syntax. You should contact your web host.

Thank you for the fix. :up:

Was wondering if you take requests? My members are complaining about the new payout adjustment you've made, they tell me you basically only get back what you put in, is it possible to make it so we can adjust the setting within the casino settings in the admincp? Thank you!

Posting requests on vbgaming.org would be better. More of a chance that your request wont get missed by the clutter of so many replies.

I would like to add to this, after this is all done. When reinstalling casino, install from the first version that was created, not the .51 or you will wind up with a casino_lotto_draw error.. this is what happened to me...

Did you get this error when trying to reinstall the product-casino.xml? if so then follow post #1254

okie thats worked thanks, I have installed the update but on the slots they just keep spinning ?

any ideas any one ?

Great mod - my users love it!!!

Any chance you could fine tune the texas holdem a little?

It's not clear when you need to start a new game (like if you had folded early on in the previous game). lot's of my users aren't computer literate, so they sometimes have to sit out because they weren't fast enough.

we also need an audio beep when it's your turn to bet, or join the game

for everyone having installation / uninstallation issues:

I'll put together a update tomorrow afternoon that will be a complete rewrite of the intstall / unintall code. which will check for oddities rather then die on them.

Will also rename the range field completely for anyone using mysql 5.1 getting errors around that.

getting this error when you bring up stats, I'm guessing it is a server prob and have contacted my host, am I correct?

Same error here with me!
I keep on looking!

Anyway great work

Greetz

I think I may wait until the Texas Hold'em is improved a bit, but this sure is a great mod.

I had a Texas Hold'em Tourney on my forum last night. It went flawlessly. I had a buy in and switched from vBCredits (my board currency) to casino_cash for markers (500/1500 respectively).

The one thing I did make a mistake on... I didn't create a special usergroup to lock others out of the casino. We had a few people straggle in and start playing with their 500 casino cash credits they are allotted via default. I created a new usergroup for the next time around.

Prizes were:
-Payouts were in casino cash converted to forum currency (so while buyin was 500, we paid out 1500, or the equivalent of casino cash they won)
-Special CT bragging on the poker champ. (will go to the next winner, so only 1 has this title at a time)
-$5000 in currency delivered to the new usergroup "Poker Champion" (to which I attatched the CT, obviously)

Just figured i would share an idea with you all to generate significant interest in the casino... it was great fun.

Contacting your host is what you needed to do.

Andrew is making an update so that this will not happen. Just keep looking back here for an update.

Question on texas hold'em play.

In one hand yesterday the table cards were a flush and each of the players only had a pair outside of the flush. The game called the hand a draw as the flush on the table was higher than anything with either players hold cards factored in. Is this typical play or should the flush have been ignored and at least one of each players cards been used to determine the winner?

Secondly I am still experiencing players freezing up and having to refresh their screens. Of course it shows as someone playing as suddenly left the game. Not sure if that is happening when they freeze up or when the refresh but I'm guessing it's when they freeze up as they don't immediately show as being back.

I tried uninstall with 0.50 didnt work, i tried wit 0.51 didnt work either

Database error in vBulletin 3.6.8:

Invalid SQL:
DROP TABLE casino_letitride_dealt;

MySQL Error : Unknown table 'casino_letitride_dealt'
Error Number : 1051
Date : Sunday, October 28th 2007 @ 12:35:05 PM
Script : http://www.netplay.com.ar/forum/admi...do=productkill
Referrer : http://www.netplay.com.ar/forum/admi...ctid=casino&s=
Classname : vB_Database

Please help me

In your xml-productfile you have to different approaches to the ' sign when putting it into the database. The second approach does not work and produces something like:

Let &epos;em Ride

The approach that works:
$query = "INSERT INTO casino_settings (settingname, switch1, switch2) VALUES ('gamename', 6, 'Texas Hold \'em')";

The approach that does not work:
$query = "INSERT INTO casino_settings (settingname, switch1, switch2) VALUES ('gamename', 7, 'Let &#3 9;em Ride')";

So you should use the first method on both games for your nest release. Not a big deal though. I just changed the title in the database myself, but that's not easy for everyone.

I noticed many people were bringing up the same issue so I just am quoting the mod author.

Newest version does do that, but won't update existing settings.

I have a small feature request/suggestion.
the capability to buy multiple lottery tickets at the same time?

Andrew, after updating to .51, I see the Let 'em Ride payouts are wrong again. They're doubled what they should be and that was fixed in .50.

Thanks

My understanding is that they are correct now, but where incorrect in .50.