i overwrited all files of my 0.61a version with 0.70 files.i removed the older product file thn whn i m trying to iport the file it says Database error in vBulletin 3.6.8:

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

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Tuesday, November 20th 2007 @ 03:13:45 PM
Script : http://mastidl.com/admincp/plugin.php?do=productimport
Referrer : http://mastidl.com/admincp/plugin.php?do=productadd
IP Address : 59.95.29.52
Username : KINGOFDEVILZ
Classname : vB_Database

Nice game Roulette!
A bug...Winning number "0", I didn´t bet "0", I won ~4000

Delete the field from your user table through phpmyadmin, as well as any casino_* tables. Then import the product.

You do not need to remove the old product file to upgrade, all that does is wipe your stats, scores and everything clean, just import the new product file and check off the allow overwrite box.

Woohoo!

I mean oops... ok, I'll have a look at that when I get a chance.

Change my currency from $ to € (glad to find out there was no cost after all):D

I'm changing also the casino_ currency_ marker but find out that the currency in the user profile did not change.
But this was easy doing in the "Casino cash in profile" plug-in.

Keep up the good work.:up:

This is an amazing mod!

All seems to work perfect, except a few reports relating to roulette. Appears sometimes the roulette wheel will not stop spinning!

Some times its fine, other times it spins for around a minute. One chap managed to make a cup of coffee to come back and find it still spinning!

That's odd, providing everything goes through properly it does two laps then slows and lands on the 3rd. What browser and is your server under heavy load?

Is Craps in the works ?

http://en.wikipedia.org/wiki/Craps

Im using FF and the other member was using IE7.
No problems with the server, everything else including the other casino games seem to be running nicely.

When I played earlier it must have down around 9 laps of the wheel.

But did stop eventually?

Not for one of the members that contacted me. He quit after a few minutes.

I am having the same problem with Roulette spinning continuously, Andrew.

same problem here with roulette,

Point on improving roulette: it is a great addition to place "something (like in casinos)" on the number that has been picked randomly once the spinning is done, and prints down somewhere how much the player has won in that round. Plus, in all the roulette games, there is a display which shows all the previous numbers, that would be a great addition too.

Great work so far, keep it up! I will donate my share to the project once I fully integrate it to my forum. I am still working on the templates to make it look more like a casino, but have been following your great progress closely.

Regards

Plz help, Andrew. I just upgraded 0.7 and once in a few times when I go to the casino, it says this:

Database error in vBulletin 3.6.6:

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

It also says that when I click on More Stats.

You need to make a table in your db, it is pretty easy. I had the same problem.

https://vborg.vbsupport.ru/showpost....postcount=1304

Did that, then installed the .70 update according to the directions.

Still happening:

Note that I only get this error in an email, and everything seems to work fine for me.

This has been horrible so far, I have to say. I would like to recommend not releasing a product that does a) not install on the first try, and b) not work anyway, with all of the bugs it has. Was it not worth waiting another month to iron everything out?

Don't get me wrong, I couldn't build something of this magnitude, but this seems like a half-done job.

This product is in Beta Stage as highlighted at the top of the forum. Products in Beta stage mean they may have have bugs and its not recommeneded to install on a live board.

Why didnt you wait until the final version was released instead of installing beta on your live board?

I installed this first time, just like many others on here did. Just becasue it didnt install first time for you would suggest you didnt follow something correctly- Not very nice tarring the mod when its installed fine for everyone.

Some people :rolleyes:

I didnt understood this line - "Delete the field from your user table through phpmyadmin"

What field ????

Ha-ha, U joke

Lets blame the product because you failed to install it properly!!!

The product is in Beta stage and most people on here are helping out with bugs here and there, I've had it working fine on my site for over a month, I suggest you have another go, probably take your time and do it properly this time then come back and apoligise to Andrew when you've worked out just how good this mod is...

Wow! Really? I've been installing and upgrading from the very first versions, I've never had a problem, I mean there are things that work or don't work sometimes, but I've never had a problem with install. Thing is, everyone's set up is different and the problems arise that are setup specific, that's how things get fixed, so deal with the fact that this is Beta, its FREE and that Andrew is doing the best he can to fix issues as they are found.

The casino_cash field in the user table.

nice new feature (roulette) Andrew, i had no problems installing.
1 small request concerning roulette...would it be possible to show your WIN amount after each turn. And also keep the chips on the table until a new turn starts...
keep up the good work!

Thanks for helping sir....

too popular with my members! :D

I left it open to all over the weekend and apart from some glitches (especially the texas) everything went fine. I restricted the texas to 6 seats and downed the reload to 1000.
People played but complained a lot about freezing and odd glitches.

By tuesday I had to restrict casino access to about 50 members as it was taking a hammering.

The poker is the main thing that needs work - i fill the tables no problem but thats where the trouble begins!

It's a great mod and i'm looking forward to developments/fixes.

Cheers

I really don't understand why some posters have to be so rude. I really don't.

I shall refrain from launching into one of my big spiels about it, since this isn't the place. But suffice to say I have had an elegant sufficiency of it!

Thank you Andrew, once again, for yet another fantastic update, and I love the roulette. This mod is amazing work.

Can you give me some specifics?

Generally speaking, they're 14 and know everything.

I'll pm you a link to the casino forum and you can read it at your leisure (if at all) - i've asked for user feedback/screenhots etc and have told them it's in development - i sent you a user/pw a while back(either on here or vbgaming.) Might be a decent site to load test a bit.

I haven't personally played that much.

I'm not posting links publicly unfortunately but if I can help in the testing/dev then great.

Andrew, this is by far the best mod I have ever messed with in vbulletin. Thanks again.

I do have one request though. Is there a way that I can define the winner of a pool and make it more obvious once the event has been settled?

Example: (this is how it currently is after the event has bee settled)

Attachment 72517

Maybe change the winner's font color:

Attachment 72518

Or even better, change the color of the table cells:

Attachment 72519


Keep up the good work. Thanks again.

Dustin

Like the old saying goes

you can please some of the people some of the time

but

you can not please all the people all the time

The biggest problem here i think is people dont under stand BETA

and even when this product is 100% there will be people complaining about something

and even when it is the users fault they will have to point a finger some where and Andrew

will be a good one to point at :D

Good mod Andrew

This MOD is still in BETA stage, which means there will be bugs that the coder continues to clean up through the help of everyone else's testing of the MOD. Andrew answers to all bugs that are found and he updates the MOD frequently. This is an awesome MOD and the final product should be even better.

Keep up the great work Andrew.

Thanks Man Testing You Hack

Well, I never claimed it was done. the version is listed at 0.70, and I'd say about 70% done is right.

This is also a free product, and is not my job. I work full time, teach evening classes, have a girlfriend, etc. This is a small piece of my time, and to be perfeclty honest works quite well. 405 installs and over 50% of the votes for MOTM this month. Not bad for a release that is less then 2 months old.

Now this is free, it gets maybe 5-10 hours programming a week, that's all I got for it. Releasing as a Beta through development gives me hundreds of hours of testing across hundreds of boards by thousands of users. Bugs get fixed much faster this way and I can spend time adding new things rather then spending all my time testing.

But hey, 400 installs, if everyone wants to put $10 / month I'd consider doing this flltime. But for now, suck it up princess.

Hey, regarding the roulette table, a few members have said that the payout on the roulette isn't working properly.

Here is the post he sent to me, I hope maybe it can shed some light and that this issue hasn't been brought up already.

Any ideas?

Thanks again.

I might get a chance to look into this tonight or tomorrow, depending on what's going on. I'll have something by the end of the weekend at the latest.

Bump!! :p

I Think This Bugs are Important to be Solved!! :confused: :(

My Best Regards, Andrew Green!! ;)

:)

You just got 10 bucks from me, as a small token of appreciation. You're doing a GREAT job and I thank you for that, and of course I already voted your Casino for the MOTM!

Best regards

/Mike

Best mod I have ever put on, it was my pleasure to donate to Andrew and his wonderful work.

I love that last line :D

Andrew, I reloaded the product, casino.php, and all the Casino folder files and my error is resolved.

It would be nice if there were text explaining what was won or lost on the Roulette table, though.