Casino (w/ 10 player poker)

[ry215]

Thanks for this casino mod. One question: how do I set Super Moderators to give money to members?

[towermatt]

Try uploading the texasholdem_functions.php and texasholdem_ajax.php files again and overwriting existing ones. Looks like something in there got messed up.

I reuploaded the entire casino folder and I am not seeing anything--should I re import the product.

[Mark.B]

I'm now having trouble with the chatbox since 0.34...in both Firefox and IE, I can't submit any text to it, it just doesn't submit.

[Andrew Green]

I reuploaded the entire casino folder and I am not seeing anything--should I re import the product.

I doubt that would help. It's a rather odd thing happening, the XML file is being created properly, but with then end off the _functions.php file slapped in front of it. Best I can figure is that the file got a little bigger during the upgrade and pushed it over some sort of choke point, I have no idea why that would occur, and might not even be it. But give the attached a try, I split the file into 2 pieces, so if that is it this will hopefully fix it.

[Mark.B]

I'm now having trouble with the chatbox since 0.34...in both Firefox and IE, I can't submit any text to it, it just doesn't submit.
Hmmm...now it's working! Odd. Ignore me and I'll go away quietly.

[Mark.B]

Things a couple of members did notice on Hold'em tonight.

1) Members kept showing as having "left the game" when apparently they had not and were viewing the page still.

2) Three people played, two drew....I am told the pot should have been divided between the two who had drawn, but It wasn't, it was just lost to the system.

[towermatt]

I doubt that would help. It's a rather odd thing happening, the XML file is being created properly, but with then end off the _functions.php file slapped in front of it. Best I can figure is that the file got a little bigger during the upgrade and pushed it over some sort of choke point, I have no idea why that would occur, and might not even be it. But give the attached a try, I split the file into 2 pieces, so if that is it this will hopefully fix it.

Thank you sir, I will give that a try.

[towermatt]

Looks like it worked!

Thanks for the help.

[Andrew Green]

Looks like it worked!

Thanks for the help.

You're welcome, files will be split in future updates, so this won't be a problem again.

[Escoh]

You're welcome, files will be split in future updates, so this won't be a problem again.

Didnt work for me i tried the same thing odd.

Should i remove then reimport ?

[Andrew Green]

Didnt work for me i tried the same thing odd.

Should i remove then reimport ?


If it's the same problem all you need to do is replace those files, if that doesn't do it send me a link and I'll have a look.

[bobster65]

I doubt that would help. It's a rather odd thing happening, the XML file is being created properly, but with then end off the _functions.php file slapped in front of it. Best I can figure is that the file got a little bigger during the upgrade and pushed it over some sort of choke point, I have no idea why that would occur, and might not even be it. But give the attached a try, I split the file into 2 pieces, so if that is it this will hopefully fix it.

Hey Andrew,

Not sure if this is related or not, but I've not had one single problem yet until I downloaded this and added it...

now I've got a couple DB errors on Stats..

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE casino_bet_stats
SET won = won + 0, bet = bet +
WHERE userid = 8
AND gameid = 5;

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 userid = 8
AND gameid = 5' at line 3
Error Number : 1064
Date : Friday, October 19th 2007 @ 06:32:21 PM
Script : http://~REMOVED~/forums/casino/slots_ajax.php
Referrer : http://~REMOVED~/forums/casino.php?do=slots
IP Address : ~REMOVED~
Username : ~REMOVED~
Classname : vb_database

Everything else is working fine tho... just got a few of these in the last hr or so..

[aztecboi2003]

I haven't had any errors but my users cash isn't updating when they post, or log in.

[Mark.B]

I haven't had any errors but my users cash isn't updating when they post, or log in.
Check your scheduled task logs...there was a syntax error in one of the previous versions that was stopping this from running. The version in the latest zip works, the file is casino_update.php. Have that uploaded and make sure the scheduled task is active and it should work.

Test it by pressing "run now" against the Casino Update in scheduled tasks, you'll soon see if you've got the file with the error.

[aztecboi2003]

Check your scheduled task logs...there was a syntax error in one of the previous versions that was stopping this from running. The version in the latest zip works, the file is casino_update.php. Have that uploaded and make sure the scheduled task is active and it should work.

Test it by pressing "run now" against the Casino Update in scheduled tasks, you'll soon see if you've got the file with the error.

Thanks, I did as you said and it just has a blue screen that says update casino cash. Should I just grab the new casino_update.php and overwrite the file?

[Mark.B]

Thanks, I did as you said and it just has a blue screen that says update casino cash. Should I just grab the new casino_update.php and overwrite the file?
That message indicates it ought to have worked, if it says "Done". Have you checked everyone's cash to see if it has increased by the amount set in your admin cp?

[aztecboi2003]

That message indicates it ought to have worked, if it says "Done". Have you checked everyone's cash to see if it has increased by the amount set in your admin cp?

It says done in the bottom of the browser, but not on the cp page. I checked and it hasn't increased at all.

[Mark.B]

Sounds like it's not running then for some reason.

When manually running it the result should say:

Update Casino Cash

Done

Try grabbing the latest file, uploading it, and seeing if that works. Make sure it's in the includes/cron directory.

[aztecboi2003]

Sounds like it's not running then for some reason.

When manually running it the result should say:

Update Casino Cash

Done

Try grabbing the latest file, uploading it, and seeing if that works. Make sure it's in the includes/cron directory.

I did as you said and it works now. Thanks for the great support.

[Mark.B]

I did as you said and it works now. Thanks for the great support.
Great stuff...glad you got it fixed.

[aztecboi2003]

I think I have spotted a bug with the feature that displays a member's cash in their profile.

This seems to be showing the cash total of the person viewing the page, rather than the cash total of the member being viewed.

In other words, every member I view, it shows them as having the same total as me.

What was the fix for this? as this is the same thing thats happening to me. I read through the last few pages but perhaps I over looked the answer.

[sandt38]

I received a few requests to add the 1000 chip. So here is the set with the 1000 chip, all reupped into a single .rar file.

https://vborg.vbsupport.ru/external/2007/10/9.png https://vborg.vbsupport.ru/external/2007/10/10.png https://vborg.vbsupport.ru/external/2007/10/11.jpg https://vborg.vbsupport.ru/external/2007/10/11.png https://vborg.vbsupport.ru/external/2007/10/12.png https://vborg.vbsupport.ru/external/2007/10/13.png
https://vborg.vbsupport.ru/external/2007/10/14.pnghttps://vborg.vbsupport.ru/external/2007/10/15.png

Here is a .rar file for upload. (http://www.megaupload.com/?d=FWFQIQJC)

[SBlueman]

nm....fixed.

[Andrew Green]

Hey Andrew,

Not sure if this is related or not, but I've not had one single problem yet until I downloaded this and added it...

Everything else is working fine tho... just got a few of these in the last hr or so..

Not related, I'll dig into it though.

What was the fix for this? as this is the same thing thats happening to me. I read through the last few pages but perhaps I over looked the answer.

The .34 product file should have taken care of that, at least it works on mine. If not I might have to try a different approach for that.

[Vi3t4Lov3]

I received a few requests to add the 1000 chip. So here is the set with the 1000 chip, all reupped into a single .rar file.

https://vborg.vbsupport.ru/external/2007/10/9.png https://vborg.vbsupport.ru/external/2007/10/10.png https://vborg.vbsupport.ru/external/2007/10/11.jpg https://vborg.vbsupport.ru/external/2007/10/11.png https://vborg.vbsupport.ru/external/2007/10/12.png https://vborg.vbsupport.ru/external/2007/10/13.png
https://vborg.vbsupport.ru/external/2007/10/14.pnghttps://vborg.vbsupport.ru/external/2007/10/15.png

Here is a .rar file for upload. (http://www.megaupload.com/?d=FWFQIQJC)

thank so lot ...awesome job ...can you make to me two more chips. 5000 & 10000 or can you send me the PDF file

[blind-eddie]

Awesome work.... Thanks for the chip set.

I was wondering what legal laws we are breaking using this to generate cash for ourselves or our websites? I know it may vary from state to state, but is this legal for us to use this,even for fun?

[aztecboi2003]

Not related, I'll dig into it though.



The .34 product file should have taken care of that, at least it works on mine. If not I might have to try a different approach for that.

So if i just upload the product file it should fix it?

[Andrew Green]

So if i just upload the product file it should fix it?

Import, not upload, and yes, it should have done it.

[Andrew Green]

Awesome work.... Thanks for the chip set.

I was wondering what legal laws we are breaking using this to generate cash for ourselves or our websites? I know it may vary from state to state, but is this legal for us to use this,even for fun?


No real money involved, so I don't see what could possibly be illegal about it?

[blind-eddie]

What about:
I was wondering what legal laws we are breaking using this to generate cash for ourselves or our websites?

[Captain Kirk76]

But there is no real money involved, thus no laws being broken..

[lairnoc]

I would love to see an option to add cash for 1 user..

[Richard1964]

I would love to see an option to add cash for 1 user..

You can do that already! Just go into their User Preferences in the Admin Control Panel. The Casino Cash option is right at the BOTTOM of the LEFT column.

[deezelpope]

I received a few requests to add the 1000 chip. So here is the set with the 1000 chip, all reupped into a single .rar file.

https://vborg.vbsupport.ru/external/2007/10/9.png https://vborg.vbsupport.ru/external/2007/10/10.png https://vborg.vbsupport.ru/external/2007/10/11.jpg https://vborg.vbsupport.ru/external/2007/10/11.png https://vborg.vbsupport.ru/external/2007/10/12.png https://vborg.vbsupport.ru/external/2007/10/13.png
https://vborg.vbsupport.ru/external/2007/10/14.pnghttps://vborg.vbsupport.ru/external/2007/10/15.png

Here is a .rar file for upload. (http://www.megaupload.com/?d=FWFQIQJC)
Excellent work! Thank you very much!:)

[Ski-Whiz]

What about:


Do a search for "online poker"..... You will be surprised..

Making money off this is not an issue. I doubt you can create a site strictly off this...

Either way, it's not illegal in any shape.

[dyna88]

I would love to see an option to add cash for 1 user..

I second that

[bazzup]

I would love to see an option to add cash for 1 user..

You can do that already! Just go into their User Preferences in the Admin Control Panel. The Casino Cash option is right at the BOTTOM of the LEFT column.

I second that


This got answered

[sandt38]

thank so lot ...awesome job ...can you make to me two more chips. 5000 & 10000 or can you send me the PDF file

Sure, but I am running out of colors to use ;)

[Rouzbeh1]

hi,
are you planing to add roulette to your script too?

thanks again

[MiahBeSmokin420]

Can anyone confirm good stability for 3.6.7

im realy tired of wasting my time with unstable mods

[dyna88]

This got answered


Thanks missed it....

[Tulsa]

Nothing, queen high beat a pair of 5's when I was playing with one other person this morning.

[towermatt]

Awesome work.... Thanks for the chip set.

I was wondering what legal laws we are breaking using this to generate cash for ourselves or our websites? I know it may vary from state to state, but is this legal for us to use this,even for fun?

It's just free money on my site. You get paid for stuff like posting and referrals. We also have a "mod of the month" that I give a 1000 too (just came up with that one, they love it)

I thought I might be able to do real money one day in the way we have an "actual" poker game and people pay into it for real. That could be fun.

But its still not generating any money for the site unless I could play good poker that night and not lose my real stake.

[Cigarcritic]

When I renamed "Texas Hold" to Texas Hold'em I received a DB error.
Version: 0.33

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE casino_settings SET switch2 = 'Texas Hold'em' WHERE switch1 = 6 AND settingname = 'gamename';

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 'em' WHERE switch1 = 6 AND settingname = 'gamename'' at line 1
Error Number : 1064

[Cigarcritic]

I received a few requests to add the 1000 chip. So here is the set with the 1000 chip, all reupped into a single .rar file.

NICE !!! :up:

[towermatt]

I was hoping there could be a way to edit sports pool events. I put in a wrong closing time on one of the football games I added for this Sunday :(

[Mark.B]

I was hoping there could be a way to edit sports pool events. I put in a wrong closing time on one of the football games I added for this Sunday :(
If you have database access via phpMyadmin or similar, you can edit them in there.

Look for the table casino_sb_events and edit the eventdate field, (which includes the time).

You'll need a Unix timestamp generator to generate the new date & time, such as THIS ONE (http://www.4webhelp.net/us/timestamp.php).

[sandt38]

When I renamed "Texas Hold" to Texas Hold'em I received a DB error.


in .33 I saw apostrophes causing errors. It was with user names, however. It doesn't appear to be an issue with .34 Try removing it.

thank so lot ...awesome job ...can you make to me two more chips. 5000 & 10000 or can you send me the PDF file

https://vborg.vbsupport.ru/external/2007/10/9.png https://vborg.vbsupport.ru/external/2007/10/10.png https://vborg.vbsupport.ru/external/2007/10/11.jpg https://vborg.vbsupport.ru/external/2007/10/11.png https://vborg.vbsupport.ru/external/2007/10/12.png https://vborg.vbsupport.ru/external/2007/10/13.png
https://vborg.vbsupport.ru/external/2007/10/14.pnghttps://vborg.vbsupport.ru/external/2007/10/15.pnghttps://vborg.vbsupport.ru/https://vborg.vbsupport.ru/

And here is the file (http://www.megaupload.com/?d=SEVDDU10) for the upload. It includes all the markers from 1-10,000, not just the 5,000 and 10,000. Also, if you have a black or dark background the 10,000 chip has an outer glow, to make it stand out.

[towermatt]

If you have database access via phpMyadmin or similar, you can edit them in there.

Look for the table casino_sb_events and edit the eventdate field, which (includes the time).

You'll need a Unix timestamp generator to generate the new time, such as THIS ONE (http://www.4webhelp.net/us/timestamp.php).

Wow! Thanks. I will see if I can give that a try. Woefully log on phpadmin stuff though.

It could be I just need to tell those folks to get their bets in early :eek:

[Rushty]

im getting an sql error when trying to install v.34 on vb 3.6.8, error is:

Invalid SQL:
CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,
drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, range integer, numbers integer, totalodds integer, odds text, winper text);

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 'range integer, numbers integer, totalodds integer, odds text, winper text)' at line 2
Error Number : 1064

any ideas?

[towermatt]

in .33 I saw apostrophes causing errors. It was with user names, however. It doesn't appear to be an issue with .34 Try removing it.



Here are the 2 big chips you wanted:

https://vborg.vbsupport.ru/https://vborg.vbsupport.ru/

And here is the file (http://www.megaupload.com/?d=SEVDDU10) for the upload. It includes all the markers from 1-10,000, not just the 5,000 and 10,000. Also, if you have a black or dark background the 10,000 chip has an outer glow, to make it stand out.

I kind of feel like an idiot but I am not sure how to get this file from mega upload--not only that, but what to do with it in order to get those chips in my casino if I can figure out the first part. :erm:

Would someone mind spelling that out real quick?

Because I love those chips!

[Mark.B]

I kind of feel like an idiot but I am not sure how to get this file from mega upload--not only that, but what to do with it in order to get those chips in my casino if I can figure out the first part. :erm:

Would someone mind spelling that out real quick?

Because I love those chips!
You have to download the file, but initially you'll get a countdown timer counting down from 45 to zero...once it's done that, press "Free Download" and save them to your PC.

You'll then need to open them using something that can open RAR files, I've got WinRar (http://www.rarlab.com/download.htm) which is free to try out.

Then you extract them to your hard drive and upload them to the casino/cards folder.

[bobster65]

I kind of feel like an idiot but I am not sure how to get this file from mega upload--not only that, but what to do with it in order to get those chips in my casino if I can figure out the first part. :erm:

Would someone mind spelling that out real quick?

Because I love those chips!

just right click on the images and "save as" ... put them in a directory on your local machine and then ftp them to your server.

[dyna88]

You could also just right click on the images and "save image as"

Edit: Looks like bobster65 was a little quicker...lol

[Mark.B]

just right click on the images and "save as" ... put them in a directory on your local machine and then ftp them to your server.

You could also just right click on the images and "save image as"

Edit: Looks like bobster65 was a little quicker...lol
I did wonder about that. However, it's *possible* the ones in the posts are "for illustrative purposes only", and the real images may be saved in a higher quality format.

[towermatt]

Do you have to have a sign on for mega upload? I let it sit there for 10 mins and got nothing.

File name and description are down there but all the stuff I can click is for ads

Edit--Forgot to say...thanks for all the help you guys :)

[Mark.B]

Do you have to have a sign on for mega upload? I let it sit there for 10 mins and got nothing.

File name and description are down there but all the stuff I can click is for ads

Edit--Forgot to say...thanks for all the help you guys :)
Ah...there's a step I forgot about!!

When you get the initial MegaUploads page, there is a box at the top where you have to enter a three letter word (like an image verification). For me it always seems to be "ZUG".

Then press the Download button.

Then on the following page you get the download links, but for free download you have to wait for a 45 second timer to count down.

[towermatt]

Sweet! Got them downloaded and uploaded via ftp

Next question would be that the existing chips are .gif and these are .png

do I need to change that somewhere. I went in and they are still the old chips after uploading

[Mark.B]

Sweet! Got them downloaded and uploaded via ftp

Next question would be that the existing chips are .gif and these are .png

do I need to change that somewhere. I went in and they are still the old chips after uploading
Admin CP > Casino > Casino Settings

At the bottom are the chip denominations and also the URLs to their images...amend them accordingly. If the actual names are the same just change all the suffices to .png

[towermatt]

Wonderful!

I should have investigated that, totally logical. Thanks again for the help, the chips look great

They are on and are perfect. My site has all these black colors so they came across well

[Andrew Green]

im getting an sql error when trying to install v.34 on vb 3.6.8, error is:


What version of mysql are you using?

(Front page of your admincp has "MySQL Version")

I was hoping there could be a way to edit sports pool events. I put in a wrong closing time on one of the football games I added for this Sunday :(

It will, just not yet. That whole setup piece needs reworked.

[Mark.B]

For some reason my lottery did not set up a new draw for today when the cron ran.

I have tried running the cron manually, and no errors show up, but no new draw gets created.

It's been working ok previously. I'm a bit baffled.

[Mark.B]

For some reason my lottery did not set up a new draw for today when the cron ran.

I have tried running the cron manually, and no errors show up, but no new draw gets created.

It's been working ok previously. I'm a bit baffled.
Just an update - I have created a draw manually now for today (nicked bits of the cron script and patched it together), so that's why there's now one showing up, but for some reason it wouldn't create automatically.

[Mark.B]

Additionally, I'm still struggling with the time zones on the Sports Pool. Something isn't right.

I had an event that I set to close at 19:20hrs BST (GMT +1) today, and just now at 19.20hts it was still open. When I converted the timestamp in a converter, it equated to 01:00 BST. Even though the event did say ion the public screen that it would close at 19:00 BST.

I fixed it by manually changing the timestamp, but I don't think I have ever once managed to get an event to close at the desired time without altering the timestamp afterwards in the database.

When we select a time in the admincp, what timezone is it actually using? And what timezone then displays on the public site?

[towermatt]

For me, I am adding games that start at 1PM EST (for instance). I set my site to use Eastern Standard Time

So for me in Colorado (2hrs behind) it shows that it closes at 11am

I assume it is taking that from the board setting

[Andrew Green]

For some reason my lottery did not set up a new draw for today when the cron ran.

I have tried running the cron manually, and no errors show up, but no new draw gets created.

It's been working ok previously. I'm a bit baffled.

I have a couple ideas, I'll implement them all, should solve this, as well as give you the ability to start a draw if there isn't one.

Additionally, I'm still struggling with the time zones on the Sports Pool. Something isn't right.

I had an event that I set to close at 19:20hrs BST (GMT +1) today, and just now at 19.20hts it was still open. When I converted the timestamp in a converter, it equated to 01:00 BST. Even though the event did say ion the public screen that it would close at 19:00 BST.

I fixed it by manually changing the timestamp, but I don't think I have ever once managed to get an event to close at the desired time without altering the timestamp afterwards in the database.

When we select a time in the admincp, what timezone is it actually using? And what timezone then displays on the public site?

Right now it's using the server time, not vb time, but the server time. I'm going to slap in a adjustment to use the users time settings though.

[towermatt]

Cool! My server time must be EST.

That works well.

[Mark.B]

For me, I am adding games that start at 1PM EST (for instance). I set my site to use Eastern Standard Time

So for me in Colorado (2hrs behind) it shows that it closes at 11am

I assume it is taking that from the board setting
I dunno anymore. I get totally confused by time zones.

I have just made some changes to sportspool.php along the following lines:

$eventdate = vbdate($vbulletin->options['dateformat'], $eventtime);
$eventtime = vbdate($vbulletin->options['timeformat'], $eventtime);
Then I have gone into the template casino_sportspool_event, and added $eventtime next to $eventdate.

With a test event, if I now create the event with a time six hours before the time I actually want it to close, the close time shows correctly in BST on the public page.

The question then is, will the event actually close at that time or not? Because today's didn't, but that was before I made the changes.

I am assuming this works the same as the add scheduled tasks window, which also requires times to be six hours aheaed (for me anyway) but then shows them in my local time in the management window.

I *hate* timezones!!!!

PS....please don't think I'm criticising you in any way here Andrew. It's my own confusion with timezones that causes this, not your mod! I have the same problem trying to get crons to run at the right time.

[aztecboi2003]

Is there a way to add advertising or banners to the blackjack or the slots pages?

[sandt38]

Wonderful!

I should have investigated that, totally logical. Thanks again for the help, the chips look great

They are on and are perfect. My site has all these black colors so they came across well

Excellent. I am sorry i wasn't here to help you load these, but as long as you got it done that is what matters.

I designed these with my dark BGs in mind as well, although I actually labeled them with my forum's casino name. I have several skins, and most use a dark BG... I find it easier on the eyes. I am glad you like them.

[towermatt]

They go so well...here's a screen shot

http://img89.imageshack.us/img89/7105/screenia4.jpg

[lairnoc]

This got answered


THNX :P

[Mark.B]

Something I've just spotted..

In slots, your cash total is updated with your winnings/loss before the reels have stopped spinning.

Could this be made to do so afterwards? As otherwise people will think it's a fix, even though it isn't.

[Tulsa]

Something I've just spotted..

In slots, your cash total is updated with your winnings/loss before the reels have stopped spinning.

Could this be made to do so afterwards? As otherwise people will think it's a fix, even though it isn't.

Mine does do so afterwards.

[Mark.B]

Mine does do so afterwards.
Yeah I was sure mine did...but it isn't at the moment.

I shall investigate further!

[Mark.B]

Yeah I was sure mine did...but it isn't at the moment.

I shall investigate further!
I notice on Andrew's site the chips and total disappear while the reels are spinning.

I reckon this is a template edit I've done, and shall have a play around!

[Mark.B]

I notice on Andrew's site the chips and total disappear while the reels are spinning.

I reckon this is a template edit I've done, and shall have a play around!
Yup it's my template edits!

Gaah!

Much messing about needed now...again!

[BuckRodgers]

ok everthing was running fine till about 10 mins ago but now when i enter the casino ang go to texas holdem i get this db error

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM casino_texasholdem_whoisin WHERE userid = 7;

MySQL Error : Table 'web93-datadrome.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date : Sunday, October 21st 2007 @ 06:13:33 PM
Script : http://www.datadrome.co.uk/forum/casino.php?do=texasholdem
Referrer : http://www.datadrome.co.uk/forum/casino.php
IP Address : ****
Username : Samorite
Classname : vb_database

any ideas any one ?

[Andrew Green]

Texas Hold'em was working though?

And now it doesn't at all?

By that error it looks like one of your tables got erased, but there is nothing in there that could erase a table...

Do you have phpmyadmin access to your DB?

[BuckRodgers]

Texas Hold'em was working though?

And now it doesn't at all?

By that error it looks like one of your tables got erased, but there is nothing in there that could erase a table...

errr is there any way to fix ?
carnt get it to unistall so i am a bit stuck

yes i have phpmyadmin access

[Andrew Green]

errr is there any way to fix ?
carnt get it to unistall so i am a bit stuck

If you have direct access to mysql, most likely through phpmyadmin, run these two queries:


DROP TABLE casino_texasholdem_whoisin;
CREATE TABLE casino_texasholdem_whoisin (whoisinid integer NOT NULL PRIMARY KEY auto_increment, userid integer, seat integer, lastcheck integer, status integer, bet integer);

[BuckRodgers]

my sql said:

#1064 - You have an er in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Andrew Green]

bracket got left off in the copy and paste, fixed now.

[BuckRodgers]

ok that seems to have worked but got this now

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO casino_texasholdem_chatlog (msg, msgtime) VALUES ('<b>Samorite joins the game</b>', 1192990049);

MySQL Error : Table 'web93-datadrome.casino_texasholdem_chatlog' doesn't exist
Error Number : 1146
Date : Sunday, October 21st 2007 @ 07:07:29 PM
Script : http://www.datadrome.co.uk/forum/casino.php?do=texasholdem&action=joingame
Referrer :
IP Address : 82.22.587.216
Username : Samorite
Classname : vb_database

[Andrew Green]

Do your other games work?

Looks almost like it was partially uninstalled...

Anyways, running these should fix the other tables associated with Texas Hold'em

DROP TABLE casino_texasholdem_chatlog;
CREATE TABLE casino_texasholdem_chatlog (chatlogid integer NOT NULL PRIMARY KEY auto_increment, msg text, msgtime integer);

DROP TABLE casino_texasholdem_dealt;
CREATE TABLE casino_texasholdem_dealt (dealtid integer NOT NULL PRIMARY KEY auto_increment, playerid integer, card integer);

[BuckRodgers]

yaaaay all back working just got the admin error now

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 : Sunday, October 21st 2007 @ 07:19:50 PM
Script : http://www.datadrome.co.uk/forum/admincp/casino_settings.php
Referrer : http://www.datadrome.co.uk/forum/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct
IP Address : **********
Username : Samorite
Classname : vb_database

anyway to sort that ? I know i asked ya earler but while i got ya in the zone :P

[Andrew Green]

anyway to sort that i know i asked ya earler but while i got ya in the zone :P

It's actually fixed, in the next update. As well as everything else that I know about. Plus a new interface for the sportspool setup, and a new game (Let it Ride). Just finishing some stuff up with it, and hopefully will be able to get that out later today.

[BuckRodgers]

OK and a big thanks :D

Donation sent keep up the good work !

[towermatt]

It's actually fixed, in the next update. As well as everything else that I know about. Plus a new interface for the sportspool setup, and a new game (Let it Ride). Just finishing some stuff up with it, and hopefully will be able to get that out later today.

**does big happy banana dance**

Can't wait Andrew

[Andrew Green]

v 0.40 is up :)

Added a new game, redid the sportspool interface, fixed a bunch of bugs, etc

[onehost]

Can someone tell me if this casino is worth installing?

[towermatt]

I got it and have the same javascript thing in Texas Hold um. When you posted separated files?

Love the new game though, that looks great

Edit:

Very much so (to the post before mine)--if your members like playing cards and that sort of thing.

[Mark.B]

I seem to have a db error in the Sportspool:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM casino_sb_events WHERE groupid = 1 AND eventdate > 1193002354 + AND result IS NULL;

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 'AND result IS NULL' at line 1
Error Number : 1064

[Andrew Green]

I got it and have the same javascript thing in Texas Hold um. When you posted separated files?


Seperated further and reuploaded, hopefully that does it for you.

I seem to have a db error in the Sportspool:


I added a check to set that to 0 if it's empty and reuploaded, hopefully that solves it for you.

[evesve]

You forgot the code for "Who´s online" for the new game?

Looks nice anyway!

[Andrew Green]

Bugger, Well, "location unknown" for now, next update I'll plug that in :)

[bazzup]

updated cheers andrew

shows up like this in casino

Let 'em Ride

[thedvs]

i got this error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1193007434;

MySQL Error : Table 'board.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date : Monday, October 22nd 2007 @ 12:57:44 AM
Script : http://xxxxxxxxxt/forums/
Referrer :
IP Address : xxxxxx
Username : xxxxx
Classname : vB_Database

[Mark.B]

I added a check to set that to 0 if it's empty and reuploaded, hopefully that solves it for you.
Yep, works now, cheers.

[towermatt]

Seperated further and reuploaded, hopefully that does it for you.


That got it, thank you.

[wattieuk]

Any way to change the $ to £?

[Tulsa]

Well no errors of any kind for me on the upgrade.

I do have a question on the game play of let'em ride. It appears to me to be operating backwards from the real game. In the end I suppose it's a wash but you're supposed to place three bets and each bet opportunity be able to pull a bet off the table or "let it ride". With this we start with just one bet and have the opportunity to raise the bet.

Like I said it may all be a wash in the end it just seems odd in the play. Was this the intention of the play or just an easier way to program it?

[duckdodger]

this is my module for VbA cmps ;)

How would I go about changing the background color of the module? Right now it's too dark. I took a look but couldn't find any obvious background code. And is there any way to have it not display when no one is playing, or perhaps say "click here to start a game" or something like that?

Thanks

And good work on .40 Andrew! Installed fine and haven't had any problems so far.

[Mark.B]

I still have problems with times on the Sportspool.

I added a test event for closing at 1am BST (which is GMT plus 1). It shows on the public page as being due to close at 1am BST...but it's now past that time and the event is still there.

The timestamps appear to be correct when you convert them, so it must be something to do with the code that checks whether the timestamp has passed or not...at a guess.

[Andrew Green]

i got this error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1193007434;

MySQL Error : Table 'board.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date : Monday, October 22nd 2007 @ 12:57:44 AM
Script : http://xxxxxxxxxt/forums/
Referrer :
IP Address : xxxxxx
Username : xxxxx
Classname : vB_Database


This:
https://vborg.vbsupport.ru/showpost.php?p=1365200&postcount=831

Then This:
https://vborg.vbsupport.ru/showpost.php?p=1365224&postcount=835

Will remove then rebuild your texas hold'em tables.

[duckdodger]

Ah, now I see. The cmps module uses the template for the who's playing box under navbar. Which template should I edit to change the background of that box?

[sandt38]

Can someone tell me if this casino is worth installing?

YES!!!

It is one of the best Add-ons EVER IMHO!!!

[syrus.xl]

Nice mod! Installed... :)

I've made some new Gold chips - designed in Photoshop! :D When I have more time, I'll design a few more images.

Feel free to use them with this modification.

The Full set are in the .zip folder, including the 100 Gold Chip.

Regards,

Syrus XL Media

[geekyguru]

I received the following error on my main page after install:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1193017577;

MySQL Error : Table 'c60pilot_vbul.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date : Sunday, October 21st 2007 @ 08:46:47 PM
Script : http://www.60pilots.com/
Referrer :
IP Address : 75.85.135.9
Username : c60pilot
Classname : vB_Database

I am not sure what to do now :(
My site is hosed like a mofo

[syrus.xl]

By the look of the error it looks like you have not saved your own settings in the AdminCP for the Casino, therefore the database is missing certain values.

[syrus.xl]

A Blue set of replacement chips...

Note the .zip contains the following:

11 New Blue Chips in jpg format, with White backgrounds (see screen shots)
Tools Folder (Do not Upload)
-- 1 PNG Blue Background with Transparency
-- 1 PSD format (non-layered)

Note: These Blue Chips are saved as jpg's therefore you will need to change the extension in the vB Casino Admin section to use them.

All images can be changed using virtually any image program.

Enjoy!

[Andrew Green]

I received the following error on my main page after install:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1193017577;

MySQL Error : Table 'c60pilot_vbul.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date : Sunday, October 21st 2007 @ 08:46:47 PM
Script : http://www.60pilots.com/
Referrer :
IP Address : 75.85.135.9
Username : c60pilot
Classname : vB_Database

I am not sure what to do now :(
My site is hosed like a mofo


This:
https://vborg.vbsupport.ru/showpost.php?p=1365200&postcount=831

Then This:
https://vborg.vbsupport.ru/showpost.php?p=1365224&postcount=835


Edit: That's 3 of you that have had those tables disappear completely... Are you uninstalling first before upgrading, or just upgrading?

[Andrew Green]

I still have problems with times on the Sportspool.

I added a test event for closing at 1am BST (which is GMT plus 1). It shows on the public page as being due to close at 1am BST...but it's now past that time and the event is still there.

The timestamps appear to be correct when you convert them, so it must be something to do with the code that checks whether the timestamp has passed or not...at a guess.

I'll keep working on that then :(

[TheBlackPoet]

i like the improvements!!! will be back to let you know if im still having issues with those damn CLUBS...

[GoTTi]

i just did the upgrade from .31 to .40 and the casino.php page shows this for the let it ride game: Let 'em Ride

ideas?

[Andrew Green]

i just did the upgrade from .31 to .40 and the casino.php page shows this for the let it ride game: Let 'em Ride

ideas?

Strange, should be rendering that as a '

You can rename games and rewrite the descriptions in the CP, so change it there :)

[Mark.B]

I'll keep working on that then :(
Thanks Andrew. :D

Just for information, returning to the site at 0700 BST and the events have gone, so it looks like they are closing at server time rather than vbtime.

[SBlueman]

Odd...I upgraded this morning to 0.40 and the site is showing this mod as updated again after I downloaded the update already. Is there a update to .040 that I missed?

[Masiello]

Wow ;) you make this mod great day by day.

[Mr Peabody]

great hack just a suggestion though would be good to have how many players in texas holdem on the main casino page also.
Cheers :)

[Rushty]

im getting an error when installing on MySQL v5 on Windows

Database error in vBulletin 3.6.8, casino versions .38 & .4

the error seems to be down to the use of a reserved word 'range' within thw SQL that creates casino_lotto_draw. SQL below.

Invalid SQL:
CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,
drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, range integer, numbers integer, totalodds integer, odds text, winper text);

[leeman]

I get this error on : let'em ride, Videopoker and Black Jack.


Warning: Unknown(./infernoshout/engine/inferno_deploy.php): failed to open stream: No such file or directory in /includes/functions.php(5129) : eval()'d code on line 1

Fatal error: (null)() [function.require]: Failed opening required './infernoshout/engine/inferno_deploy.php' (include_path='.:/usr/local/lib/php') in /usr/home/XXXXXXXXXXX/insanetrain.com/public_html/forums/includes/functions.php(5129) : eval()'d code on line 1

[AdmiralGeek]

looks like, it is conflicting with Inferno Technologie, RPG maybe?

[leeman]

looks like, it is conflicting with Inferno Technologie, RPG maybe?

I have Inferno Shoutbox ....

But I get confused when it conflicts with 3 outa six games ...

Well gonna try some stuff. Unless someone else have gotten the same and solved it.

[AdmiralGeek]

the 250, 500, 1000, chip in the admin control panel are not added automatically
maybe the admin.php needs to be re-done.
They have to be entered manually?

Also i am using VB credits, new version. 1.4
and yet the credits in your mod is displaying as a dollar sign$ i have changed the cash type to credits in the admin panel, but the credits have different values

see the attached images.

[AdmiralGeek]

My mistake, over looked a setting within the Vbcredits system.

All good so far.

Be good to be able to change the dollar Symbol tho....

This will be very good when VB commencer comes out, people will actually be able to pay real money for the virtual credits and use them within the casino. Will there be gambling laws against this?

[rwilkins108]

On Let 'em Ride, are the payouts correct? when I initially bet $100 and then raise $100 and then raise $100 again, if I get a pair of 10s or better, I get $600. Since it's 1 to 1, shouldn't I get $300?

[BuckRodgers]

Strange, should be rendering that as a '

You can rename games and rewrite the descriptions in the CP, so change it there :)

when i try to save the changes i get

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 : Monday, October 22nd 2007 @ 12:30:41 PM
Script : http://www.datadrome.co.uk/forum/admincp/casino_settings.php?gamename1=Video+Poker&gamedesc1=Jacks+or+better+to+win.&gameactive1=1&gamename2=Blackjack&gamedesc2=Classic+Casino+Game.&gameactive2=1&gamename3=Sports+Betting+Pool&gamedesc3=Place+bets+on+upcoming+events.&gameactive3=1&gamename4=Lottery&gamedesc4=Buy+into+the+lottery&gameactive4=1&gamename5=Slots&gamedesc5=3+wheel+slot+machine&gameactive5=1&gamename6=Texas+Hold+&gamedesc6=Limit+game+of+Poker%2C+up+to+10+players&gameactive6=1&gamename7=Let+%26apos%3Bem+Ride&gamedesc7=5+Card+stud+variation&gameactive7=1&submit=Update+Games
Referrer : http://www.datadrome.co.uk/forum/admincp/casino_settings.php
IP Address : ***********
Username : samorite
Classname : vb_database

any ideas ?

[Wolf_Hook]

My members are going crazy over this hack and now they have started to make suggestions on how to make it a bit more interactive. I thought I would post an idea here from one of them.
I am a member of the ADELAIDE CASINO, and have a card, showing my loyalty and winnings to the CASINO

Just an IDEA, we could have CREDIT TEARS, for example;

any one over 500,000 credits = PLATINUM CARD
over 250,000 GOLD CARD
over 100,000 SILVER
50,000 BRONZE CARD, have it displayed as an avatar or signature!!??

These cards could be used for example a BRONZE CARD HOLDER TEXAS HOLD EM CUP, or something like that, where the player donates $500 each for prize money!!! and everyone starts with $1500 [just for the tournament] and the last man with all the money takes the $5000, if 10 players played of course!!

Does the casino have that ability, to make special POKER games???

Just an Idea..... If it can I think it would be fun!!

The CARDS anyway is a no brainer I reckon.... they should happen for sure!!!

What do you guys think???

Cheers and beers from the man in the Riverland!!

Raymo
If this can be done or not is another matter but I thought I would post it to just show how much people are enjoying the hack and looking to add things to it.

[csavern]

On Let 'em Ride, are the payouts correct? when I initially bet $100 and then raise $100 and then raise $100 again, if I get a pair of 10s or better, I get $600. Since it's 1 to 1, shouldn't I get $300?

You do get $300 the other $300 is your Bet

[AdmiralGeek]

logical error when playing the video poker, you get a pair of nines, and you get a jack wchi is better. The computer decides sure, we will make it two pair instead of letting you choose three of a kind, which is a higher pay out......

[Andrew Green]

im getting an error when installing on MySQL v5 on Windows

Database error in vBulletin 3.6.8, casino versions .38 & .4

the error seems to be down to the use of a reserved word 'range' within thw SQL that creates casino_lotto_draw. SQL below.

Invalid SQL:
CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,
drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, range integer, numbers integer, totalodds integer, odds text, winper text);

Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

Is that the error it is giving you? I can escape it or rename it next time around which should get around that...



I have Inferno Shoutbox ....

But I get confused when it conflicts with 3 outa six games ...

Well gonna try some stuff. Unless someone else have gotten the same and solved it.

Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?

the 250, 500, 1000, chip in the admin control panel are not added automatically
maybe the admin.php needs to be re-done.
They have to be entered manually?


Yes they do. I know a lot of people have added higher chips, and I didn't want to overwrite existing settings, so the images are there, but they aren't added in.

when i try to save the changes i get

any ideas ?

I'll patch that query out of there and post it here when I get a few minutes.

Thanks Andrew. :D

Just for information, returning to the site at 0700 BST and the events have gone, so it looks like they are closing at server time rather than vbtime.

Ok, so the times all show up properly, but the events are staying open passed the time shown?

[Andrew Green]

logical error when playing the video poker, you get a pair of nines, and you get a jack wchi is better. The computer decides sure, we will make it two pair instead of letting you choose three of a kind, which is a higher pay out......


Exactly what cards are you getting?

Any hand that would let you have both 2 pair and 3 of a kind should be a full house?

[Vizionz]

i am gonna install this shortly but mad props for putting this much work into a game mod.

[Andrew Green]

when i try to save the changes i get


any ideas ?


Overwrite the existing file with the attached one in the admincp folder.

[AdmiralGeek]

Exactly what cards are you getting?

Any hand that would let you have both 2 pair and 3 of a kind should be a full house?

no, when i had 1 pair, and a jack. the jack takes another card and turns it into a pair, instead of leeting the 1 pair be a three of a kind. Get me now?

[AdmiralGeek]

the wild card (jack) doesn't know how to handle the situation, it cant consider that when you have just one single pair, it cant turn it into a three of a kind, unless there is another pair in the hand.

three of a kind, is stronger than two pairs.

[Andrew Green]

Jack is not treated as a wild card?

[Rushty]

Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html


sorry I should have said its 5.1 not 5.0 and range is a reserved word on 5.1: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

[Mark.B]

Ok, so the times all show up properly, but the events are staying open passed the time shown?
Yep, that's exactly it.

I tested this by re-uploading the old file (which I have left up for the time being) and the events that should be closed then disappear.

[leeman]

Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?


I get it as soon as I click the link to the game ....

Where the cards should be I guess ...

[BuckRodgers]

ok thanks for the admin patch thats worked fine but when i click on more stats i get

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, casino_settings AS cs2, casino_bet_stats
WHERE cs1.settingname = 'gamename'
AND cs2.settingname = 'gameactive'
AND cs1.switch1 = gameid
AND cs2.switch2 = '1'
AND cs1.switch1 = cs2.switch1
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

and when i click on let em ride it just goes back to the casino main menu ?

[Mark.B]

and when i click on let em ride it just goes back to the casino main menu ?
I think the original casino.php file that was uploaded was missing a couple of lines that would solve that.

Looking at the ZIP file now, the lines are present, so if you redownload and replace the casino.php file, it should work.

[Andrew Green]

ok thanks for the admin patch thats worked fine but when i click on more stats i get


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


ok, not allowed to connect more then 2 tables at a time... got it.


and when i click on let em ride it just goes back to the casino main menu ?

Upload and overwrite the casino.php file ;)

[Mark.B]

I've only just spotted this, but the new texasholdem_ajax.php file seems to be causing the game to refuse to load, just showing the start button which has no effect.

Reverting to the old file fixes it.

[blind-eddie]

I am getting alot of db errors when I try to reset cash....

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user
SET casino_cash =;

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 '' at line 2
Error Number : 1064
Date : Monday, October 22nd 2007 @ 03:53:54 AM
Script : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user
SET casino_cash = o.oo;

MySQL Error : Unknown table 'o' in field list
Error Number : 1109
Date : Monday, October 22nd 2007 @ 03:55:10 AM
Script : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=o.oo&submit=Adjust+Cash
Referrer : http://outerzone.us/forum/xxxxxxx/casino_settings.php


Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user
SET casino_cash =;

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 '' at line 2
Error Number : 1064
Date : Monday, October 22nd 2007 @ 03:55:46 AM
Script : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer : http://outerzone.us/forum/xxxxxxx/casino_settings.php

[Andrew Green]

I am getting alot of db errors when I try to reset cash....


You're trying to reset to zero?

Put "0" in the field.

Leaving it blank won't work, decimals aren't needed.

[BWilliams]

Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146

Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.

[Andrew Green]

Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146


Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.

phpmyadmin and enter the following:


DROP TABLE casino_texasholdem_whoisin;
CREATE TABLE casino_texasholdem_whoisin (whoisinid integer NOT NULL PRIMARY KEY auto_increment, userid integer, seat integer, lastcheck integer, status integer, bet integer);

DROP TABLE casino_texasholdem_chatlog;
CREATE TABLE casino_texasholdem_chatlog (chatlogid integer NOT NULL PRIMARY KEY auto_increment, msg text, msgtime integer);

DROP TABLE casino_texasholdem_dealt;
CREATE TABLE casino_texasholdem_dealt (dealtid integer NOT NULL PRIMARY KEY auto_increment, playerid integer, card integer);

Where you upgrading or installing from scratch?

[aggiefan]

has there been any movement on a "who is in the casino" option for the "Whats going on?".... would be very nice to be able to tell who is in a game of texas holdem especially since its multiplayer.

[Andrew Green]

has there been any movement on a "who is in the casino" option for the "Whats going on?".... would be very nice to be able to tell who is in a game of texas holdem especially since its multiplayer.

Yes, latest version has a box on the main screen it does require a template change though. Instructions are in the readme.txt

[BWilliams]

phpmyadmin and enter the following:
Where you upgrading or installing from scratch?
Installing from scratch. I thought at the time I had the old version installed and was going to uninstall it and install the new version. Right when I clicked the uninstall option the site when down. Have search through the database and deleted everything casino related and deleted all files via ftp.

Even running that code in phpmyadmin the site is still down.

Here is the code again from one of the eMails:

Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1193077878;

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146




When I ran the sql command you provided I got this:

Error
SQL query:

DROP TABLE casino_texasholdem_whoisin;



MySQL said:

#1051 - Unknown table 'casino_texasholdem_whoisin'

[BWilliams]

OK, just added the table back manually and the site is back up and running again. Dam that was scary being that I didn't have a recent backup of the database! Lesson learned for sure.

I must have gotten atleast 500 Database Error eMails within the last 30 minutes

[aggiefan]

Yes, latest version has a box on the main screen it does require a template change though. Instructions are in the readme.txt

ahh thx.... just upgraded the script and didnt read the readme. i would like to see it enhanced though to show at the bottom of the page with the rest of vbulletin stats and how the flashchat plugin works. (this one https://vborg.vbsupport.ru/showthread.php?t=143840&highlight=users+flashchat)

[Andrew Green]

Installing from scratch. I thought at the time I had the old version installed and was going to uninstall it and install the new version. Right when I clicked the uninstall option the site when down. Have search through the database and deleted everything casino related and deleted all files via ftp.

Even running that code in phpmyadmin the site is still down.

Here is the code again from one of the eMails:


When I ran the sql command you provided I got this:

Upload this file to your main forum directory, and run it, then remove it.

It will rebuild all of your casino tables up to v .34 which I believe is where you where at from the errors you have, then you can update to .40 without uninstalling and everything should work.

[KoDex]

I get a database error when trying to uninstall, how do I delete it?!!:mad:

[Andrew Green]

I get a database error when trying to uninstall, how do I delete it?!!:mad:

Upload the attached to your main forum directory, run it, delete the file, then uninstall the product again.

This will drop all of the tables, if you get errors it's because you don't have those tables in, either because they where deleted or never where created. It will also clear the uninstall code for the product, so you won't get anymore errors uninstalling it.

[KoDex]

http://www.theurban.co.uk/dropcasino.php

database error still!! :(

[Andrew Green]

http://www.theurban.co.uk/dropcasino.php

database error still!! :(

As I said, that is ok, now uninstall the product again.

[KoDex]

sorted thanks.

[rwilkins108]

woo hoo :)

[towermatt]

Sports pool events can now be added, edited and resolved outside of the admincp

I am wondering about this new feature. Is this permissions we could give someone else on the site to do?

[Andrew Green]

I am wondering about this new feature. Is this permissions we could give someone else on the site to do?


AdminCP lets you choose usergroups for who has access to that.

[towermatt]

Thanks Andrew. I thought that is where it might be but I scanned the whole

adminCP>usergroups>specific user groups settings and could not find it. Should there be a new section in there?

[Andrew Green]

Casino settings -> Sportspool admin Usergroups

[towermatt]

Hmmm...even better.

I'm looking all over that thing and can't see it. Perhaps I didn't upload the file correctly even though that seems pretty straight forward.

My version shows .4

I'll keep having a look, to me its the same options as it always was. :(

Thanks again for the help

I have

general settings (not in there)
games available
mass cash adjustments
cash values

[towermatt]

LOL

I guess I simply do not have that option in the AdminCP--mine still says the same as it always did. Under Casino

Casino settings -> the list above, that's all that is there.
Groups
events
settle events
lottery settings
hold um settings

I even checked under the Vbulletin options. Simply cannot find it anywhere :(

[acegames]

LOL

I guess I simply do not have that option in the AdminCP--mine still says the same as it always did. Under Casino

Casino settings -> the list above, that's all that is there.
Groups
events
settle events
lottery settings
hold um settings

I even checked under the Vbulletin options. Simply cannot find it anywhere :(

Have you uploaded the latest casino-product and selected overwrite ?

[Andrew Green]

upload the admincp files again and overwrite the existing ones ;)

My guess is that you forgot the admincp stuff when you upgraded :D

[towermatt]

:D

I could see that, I will try again.

[Mark.B]

I haven't got this option either.

Casino
Casino Settings
Sports Pool Groups
Sports Pool Events
Sports Pool Settle Events
Lottery Setup
Texas Hold em Setup

[Andrew Green]

Should be right here:

[sinisterpain]

Strange, should be rendering that as a '

You can rename games and rewrite the descriptions in the CP, so change it there :)
Its in the template and the letemride.php file as well
$navbits = array();
$navbits['casino.php'] = "Casino";
$navbits[''] = "Let 'em Ride";
$navbits = construct_navbits($navbits);

[Mark.B]

Should be right here:
Ah I see, I thought it was an option in the menus on the left...got it now.

Andrew did you see my comment about the texasholdem ajax file? The 0.40 version seems to stop mine from working. I tried reverting the relevant templates etc but I couldn't make it work.

It loads and shows the "Start" button but won't go any further, even if you press the button.

Reverting to the previous file makes it work. Browser is Firefox.

[Andrew Green]

you have all 5 texasholdem files up and in place?

[NeilK]

Has something changed in the code for Video Poker and Slots? My biggest "degenerate" who I have reloaded with 100 in chips like 20 times, this afternoon turned $200 into $38,000. Most of that on VP but then some massive slot payouts too I'm told. Seems like an inside job ;).

[towermatt]

Should be right here:

That seems really straight forward. I still don't have it after the upload.

all that I have in the download for AdminCP are

casino_lotto_setup.php
casino_sb_events.php
casino_sb_groups.php
casino_sb_settle.php
casino_settings.php
casino_texasholdum.php

All were over written in the most recent upload.

I'd be happy to give your signon admin privileges if you would like to have a look Andrew

[Mark.B]

you have all 5 texasholdem files up and in place?
I have four in the /casino/ folder and one in the /admincp/folder.

[ry215]

Where can I change the default $250 to $0 for new user. Which table or template? Thanks!

[Mark.B]

Where can I change the default $250 to $0 for new user. Which table or template? Thanks!
This actually involves a database edit, unless I've missed something obvious. You'll need phpMyAdmin or similar.

Edit the table 'user', and find the row 'casino_cash' in the structure. Edit this and change the value 'Default' to '0'.

I always advise backing up your database first before altering it directly...in this case you could just back up the structure and data for the "user' table rather than the entire database. Easy enough to restore it then if anything goes wrong.

[ry215]

Mark, it works! Thanks for your quick help!

[ry215]

Andrew, thanks for the casino mode. Can't wait for some more multiplayers games such as Crap and Roulette.

What a great and easy-install mode.

[NeilK]

Has something changed in the code for Video Poker and Slots? My biggest "degenerate" who I have reloaded with 100 in chips like 20 times, this afternoon turned $200 into $38,000. Most of that on VP but then some massive slot payouts too I'm told. Seems like an inside job ;).

Looks like part of the problem is payouts on Jacks or Better hands (AKA High Pair). The user bets 1000, gets a pair of kings and is paid 2000. In typical casino video poker, the user would only break even (be paid 1000). The payout chart should be multiplied by the bet and that given to the winner.

I just bet 10, got two pair and was paid 30. (In my thinking, I should only get 20 or double my bet).

Maybe this is intentional and if so I can accept that. I just wanted to point ot that it's different than the VP machine at the casinos I go to.

Thanks for this cool hack, my users love it.

[NeilK]

Ditto on payouts for Let It Ride.

[Mark.B]

I see we have now broken 200 installs!

This modification has certainly caught the imagination, and it's extremely popular on my site.

I would hope that this will be a dead cert for the next Mod of the Month award now.

[towermatt]

I'll vote it in, its amazing.

I still can't see the field to let others add/edit sports pools but that is minor on this great mod.

not to mention, its probably my fault. Just can't figure out how.

[Mark.B]

I'll vote it in, its amazing.

I still can't see the field to let others add/edit sports pools but that is minor on this great mod.

not to mention, its probably my fault. Just can't figure out how.
It took me a bit to find it, but if you have uploaded the casino_settings.php file from 0.40 in the admin panel, then go to:

AdminCP > Casino > Casino Settings

It is the third option down (Sportspool admin usergroups)

71380

[Tulsa]

I see we have now broken 200 installs!

This modification has certainly caught the imagination, and it's extremely popular on my site.

I would hope that this will be a dead cert for the next Mod of the Month award now.

Already nominated.

[ry215]

Looks like part of the problem is payouts on Jacks or Better hands (AKA High Pair). The user bets 1000, gets a pair of kings and is paid 2000. In typical casino video poker, the user would only break even (be paid 1000). The payout chart should be multiplied by the bet and that given to the winner.

I just bet 10, got two pair and was paid 30. (In my thinking, I should only get 20 or double my bet).

Maybe this is intentional and if so I can accept that. I just wanted to point ot that it's different than the VP machine at the casinos I go to.

Thanks for this cool hack, my users love it.


:) oopppsss you're right!

[towermatt]

It took me a bit to find it, but if you have uploaded the casino_settings.php file from 0.40 in the admin panel, then go to:

AdminCP > Casino > Casino Settings

It is the third option down (Sportspool admin usergroups)

71380

Thanks Mark,

I did go back and do a full upload and studied that screen shot but the option is simply not there for me, its kind of weird because the instructions are totally straight forward.

scratch that, I got it now!! Thanks for the help.

I take every file in the folder and upload it when I do these but I brought over the one you mentioned one more time and its there. Serious user error somehow.

[towermatt]

And now I am not sure where to go to edit them :D

Wow! I'm high maintenance.

[Andrew Green]

Ditto on payouts for Let It Ride.

It was intentional, still experimenting a little, it was the other way before. Will likely end up using standard casino payouts in the end, and having the ability to edit them through the admincp if desired.

This actually involves a database edit, unless I've missed something obvious. You'll need phpMyAdmin or similar.


Nothing missed, I will eventually get a option in there to change this through the admincp rather then having to go to phpmyadmin though.


And now I am not sure where to go to edit them :D

Wow! I'm high maintenance.

Edit what?

[xxxsaint]

Is there any way to make the texas hold'em table contain a background image so we can create our own custom " table tops " ?

[hoof]

Installed, had the adminCP missing issue on V34 but V40 is running smooth :) Thanks for this cool mod, my users are loving it.

[Andrew Green]

Is there any way to make the texas hold'em table contain a background image so we can create our own custom " table tops " ?

not yet, by the time this hits that 1.0 release there will be more options for customization

[Vi3t4Lov3]

in .33 I saw apostrophes causing errors. It was with user names, however. It doesn't appear to be an issue with .34 Try removing it.



https://vborg.vbsupport.ru/external/2007/10/9.png https://vborg.vbsupport.ru/external/2007/10/10.png https://vborg.vbsupport.ru/external/2007/10/11.jpg https://vborg.vbsupport.ru/external/2007/10/11.png https://vborg.vbsupport.ru/external/2007/10/12.png https://vborg.vbsupport.ru/external/2007/10/13.png
https://vborg.vbsupport.ru/external/2007/10/14.pnghttps://vborg.vbsupport.ru/external/2007/10/15.pnghttp://i22.tinypic.com/al5ai8.pnghttp://i22.tinypic.com/169qama.png

And here is the file (http://www.megaupload.com/?d=SEVDDU10) for the upload. It includes all the markers from 1-10,000, not just the 5,000 and 10,000. Also, if you have a black or dark background the 10,000 chip has an outer glow, to make it stand out.

awesome ...I Appreciate that ....very helpful

[pitzerwm]

Looks like a great add on, but I was over at Dark Tower's and played Video Poker, at one point I had $168 and bet $100, it doesn't show me what cards replaced the discarded just comes up with "a washer on a string...." statement. The only thing to was to go back to Casino and then Video Poker again, it was showing $68, I play a bit more and got down to $18 I bet $10 and it does the same thing. A minor bug, I'd imagine.

[Andrew Green]

It is minor, and it should be fixed with the latest (0.40) release.

[The Bish]

Pure Greatness!

[thunder_sti]

Clicked Installed !!

1st time go--No issues--currently running great w/3.6.7 (Pl1) :)

Thanks

[Cigarcritic]

Andrew....Please add "Three Card Poker" to the wish list.

You're doing an excellent job and thanks for adding Let'em Ride and juicing up the Betting Pool.

[teedizz]

Thank you for this hack. I just wanted to report one small bug. Im currentl using the vbcredits intergration which is embedded in the coding and for some reason when I click on " more Stats " under casino.php, under " Richest Players " the Amount field is blank although the display of the richest usernames is correct. It just doesnt show the amount but order of the richest members is correct, a bit wierd....lol

[jasculs]

Does anyone know if it's possible to cheat at javascript or ajax based games because I have two people who have ridiculous point totals from the casino right now and I can't quite seem to see how it's is possible.

I have everyone 5,000 points and the most people can bet on a game is 100 points because that is the highest chip.

The person with the highest points from the casino by this Wednesday will win a prize.

One person had 1,200 points at one time on about last Thursday. Now they have over 110,000 points and their totals seem to be going up very fast. How is this? It just doesn't seem possible. If anyone knows can you shoot me a pm or maybe this person and one other person are just really lucky.

There were 25 people in this contest and more then half are eliminated because they lost all of their points.

Thanks

[BuckRodgers]

1. is there anyway you could incorporate a start button for Texas hold em ?
as when you have a few players in there its hard to get them all to start @ the same time

2. had 9 players in the room last night and as soon as the tenth player entered the room starting kicking players ?

3. still getting db error on clicking more stats
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, casino_settings AS cs2, casino_bet_stats
WHERE cs1.settingname = 'gamename'
AND cs2.settingname = 'gameactive'
AND cs1.switch1 = gameid
AND cs2.switch2 = '1'
AND cs1.switch1 = cs2.switch1
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

any help greatly received :)

[SLY LS1]

Hope you don't mind Andrew but I have made some new buttons, just tidied them up a bit, zip attached if anyone wants to use them.

If anyone would like differant colours etc, let me know and ill do some.

Cheers
SLY

[SLY LS1]

oh and

[leeman]

Thank you for this hack. I just wanted to report one small bug. Im currentl using the vbcredits intergration which is embedded in the coding and for some reason when I click on " more Stats " under casino.php, under " Richest Players " the Amount field is blank although the display of the richest usernames is correct. It just doesnt show the amount but order of the richest members is correct, a bit wierd....lol


I noticed that too ...

It "fixed" it self when they used the casino.

[leeman]

I must ask....

Anyone here who have got the casino installed successfully WITH the Inferno Shout box lite...????

[BuckRodgers]

I must ask....

Anyone here who have got the casino installed successfully WITH the Inferno Shout box lite...????

got it running fine with Inferno Shout box pro but i had problems when i showed shoutbox on any of the casino games

hope that helps

[Tulsa]

I had this reported to me from a user.

Tonight, there seemed to be a bug that forced a player to sit out the next hand if they folded. We also got booted on occasion, and often in the middle of a hand.

I've seen a lot of people get booted myself when playing and I've not played it since the .40 update so I've not seen where someone is forced to sit out the next hand if they fold.

[towermatt]

It was intentional, still experimenting a little, it was the other way before. Will likely end up using standard casino payouts in the end, and having the ability to edit them through the admincp if desired.



Nothing missed, I will eventually get a option in there to change this through the admincp rather then having to go to phpmyadmin though.




Edit what?

The sports pool events.

[csavern]

Here is a few more poker chips

Looks Best On A Dark Board

Hope everyone likes

Green

https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/

Orange

https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/

Black

https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/

Pink

https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/

Grey

https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/ https://vborg.vbsupport.ru/

These are in .png format


Here Is A Pic Of the differnt color chips

https://vborg.vbsupport.ru/
https://vborg.vbsupport.ru/


here is Bars and 7s on a black background
for those of yall that rather have a dark background other then white

just place the slotwheel3 file in your casino - cards folder

https://vborg.vbsupport.ru/

https://vborg.vbsupport.ru/



Here is Bars and 7's that got differnt bar's and cherrys on it also has a black background

American Bars and 7's

https://vborg.vbsupport.ru/

https://vborg.vbsupport.ru/

Replace your current slotwheel3.png with the one in this zip
upload it to casino/cards folder

To use this you will need to make a edit to make the payout table correct

Go to Languages & Phrases - click on - Search in Phrases

In Search for Text paste this in the box - Bar's and 7's Slots Payouts

then Click Edit

Then down at the bottom where it says

English (US) Translation
(Optional)

paste this code in the box and click save

<table class='tborder' >
<thead>
<tr>
<td class='thead' colspan='2'>Bar's and 7's Slots Payouts</td>
</tr>
</thead>
<tbody>
<tr>
<td class='alt1'>3 x Gold 7</td>
<td class='alt1'>250</td>
</tr>
<tr>
<td class='alt2'>3 x Red 7</td>
<td class='alt2'>100</td>
</tr>
<tr>
<td class='alt1'>3 x Blue Bars</td>
<td class='alt1'>20</td>
</tr>
<tr>
<td class='alt2'>3 x Blue 7</td>
<td class='alt2'>15</td>
</tr>
<tr>
<td class='alt1'>3 x Cherry</td>
<td class='alt1'>15</td>
</tr>
<tr>
<td class='alt2'>3 x White Bars</td>
<td class='alt2'>5</td>
</tr>
<tr>
<td class='alt1'>3 x 7</td>
<td class='alt1'>3</td>
</tr>
<tr>
<td class='alt2'>3 x Gold</td>
<td class='alt2'>3</td>
</tr>
<tr>
<td class='alt1'>3 x Red Bar</td>
<td class='alt1'>2</td>
</tr>
<tr>
<td class='alt2'>3 x Red</td>
<td class='alt2'>2</td>
</tr>
<tr>
<td class='alt1'>2 x Cherry</td>
<td class='alt1'>2</td>
</tr>
<tr>
<td class='alt2'>3 x Bar</td>
<td class='alt2'>1</td>
</tr>
<tr>
<td class='alt1'>3 x Blue</td>
<td class='alt1'>1</td>
</tr>
<tr>
<td class='alt2'>1 x Cherry</td>
<td class='alt2'>1</td>
</tr>
</table>

</td>
</tr>
</table>


Your done enjoy the slots



If anyone would like to see the slot in action visit http://www.rotormadness.com

[hoopsta]

awesome bro!

[chatzworld]

any chance of getting a multiplayer game of roulette many users have been asking me if we can get this :)

[BuckRodgers]

any chance of getting a multiplayer game of roulette many users have been asking me if we can get this :)

i second that !

[frosch68]

any chance of getting a multiplayer game of roulette many users have been asking me if we can get this :)

that were great YEAAAAH PLEASE !!

[Mark.B]

I go along with the roulette idea, as long as there's a realistic way of making it graphical.

Don't want it like some sites have where it's text only and just tells you what number has been spun. But giving it a graphical interface won't be easy.

[Mark.B]

I now seem to have Texas Holdem working with the up to date AJAX file. Not sure what was wrong, but it works now.

[teedizz]

Thank you for this hack. I just wanted to report one small bug. Im currentl using the vbcredits intergration which is embedded in the coding and for some reason when I click on " more Stats " under casino.php, under " Richest Players " the Amount field is blank although the display of the richest usernames is correct. It just doesnt show the amount but order of the richest members is correct, a bit wierd....lol

1 more bug I found is with blackjack. I got 11 on the first 2 cards, i hit and got a 10 which is 21 so I stayed. The dealer turns over his cards and got blackjack. Instead of it being a psuh, it actually took my chips as if i had lost :/

[Mark.B]

I have some more feedback on texas Holdem from one of my moderators who is quite experienced in the game:

===========
Still kicking people out and saying they've left when they haven't.

The game play itself is faster than it was, as is the chat window.
There is a problem with the betting. When you are first to play on the pocket, you can't check, you can only call, raise, or fold, as if you had the small blind - if you check, you actually double your bet.
Also, if your bet is called, you are given an opportunity to re-raise. That shouldn't happen. You should only be able to re-raise if someone else raises your bet - if everyone calls or folds, there should be no more betting on that round.

[towermatt]

Has anyone seen where you can now edit the sports events? I have the group numbers set in the field and put on a test event but could not see where to edit them :(

Probably a user error but it would be cool if someone at least knew where to look

[blind-eddie]

How about a "All in" button

[Cigarcritic]

Has anyone seen where you can now edit the sports events? I have the group numbers set in the field and put on a test event but could not see where to edit them :(

Probably a user error but it would be cool if someone at least knew where to look

See attachment.

[yoyoyoyo]

Thank you for this hack. I just wanted to report one small bug. Im currentl using the vbcredits intergration which is embedded in the coding and for some reason when I click on " more Stats " under casino.php, under " Richest Players " the Amount field is blank although the display of the richest usernames is correct. It just doesnt show the amount but order of the richest members is correct, a bit wierd....lolsame here, also using vbcredits

[Andrew Green]

any chance of getting a multiplayer game of roulette many users have been asking me if we can get this :)

To be honest I just don't see it translating well, there really is no need to have that as a multiplayer game as it is played against the house, not against each other. As a single player game maybe, but I can't say I see much appeal in turning this into a multiplayer game, there are better choices for that.

I go along with the roulette idea, as long as there's a realistic way of making it graphical.

Don't want it like some sites have where it's text only and just tells you what number has been spun. But giving it a graphical interface won't be easy.

I did some experimenting with it a while back, it would likely have a stationery wheel and a ball spinning around it. Without going to flash that's probably the closest I can get.

1 more bug I found is with blackjack. I got 11 on the first 2 cards, i hit and got a 10 which is 21 so I stayed. The dealer turns over his cards and got blackjack. Instead of it being a psuh, it actually took my chips as if i had lost :/

Not a bug, as I understand it a blackjack should beat a soft 21, going either direction.

Has anyone seen where you can now edit the sports events? I have the group numbers set in the field and put on a test event but could not see where to edit them :(

Probably a user error but it would be cool if someone at least knew where to look

On the open events page you should have a "add" button at the bottom. Beside each event you should have a "edit" and at the top there should be a 4th item called "settle bets"

[Mark.B]

I did some experimenting with it a while back, it would likely have a stationery wheel and a ball spinning around it. Without going to flash that's probably the closest I can get.
That would be absolutely fine from my perspective.

I'd would also say single player is better than multi player. Multiplayer is nice, as with Holdem, but it's insanely complicated at times and also involves getting everyone "wanting to play" at the same time, which is often tricky. Roulette lends itself to single player in a forum environment, IMO.

As for Flash, I'd be fine if it was done in that. My site has two arcades and everyone's used to the fact that our games section requires Flash enabled browsers, so from a purely selfish angle, I'd be fine if Flash was used. But the way you've described it without Flash sounds fine.

[carleboy]

Just a suggestion here but texas holdem dosnt wait long for people to click ready so alot of the time somone gets left out can it be made that the dealer has to hit a start button when everyone says they are ready in the shotbox or if not everyone in there ither hits reay or sit out that way it would be a more controlled inviroment ??

cheers and top hack m8 keep it up.

[carleboy]

That would be absolutely fine from my perspective.

I'd would also say single player is better than multi player. Multiplayer is nice, as with Holdem, but it's insanely complicated at times and also involves getting everyone "wanting to play" at the same time, which is often tricky. Roulette lends itself to single player in a forum environment, IMO.

As for Flash, I'd be fine if it was done in that. My site has two arcades and everyone's used to the fact that our games section requires Flash enabled browsers, so from a purely selfish angle, I'd be fine if Flash was used. But the way you've described it without Flash sounds fine.

agree totaly

i just look forward to having it lol cheers

[jasculs]

Thank you for this hack. I just wanted to report one small bug. Im currentl using the vbcredits intergration which is embedded in the coding and for some reason when I click on " more Stats " under casino.php, under " Richest Players " the Amount field is blank although the display of the richest usernames is correct. It just doesnt show the amount but order of the richest members is correct, a bit wierd....lol

I too have the same issue using vbcredits


Also I would do my best to not have any casino games in flash because people have a better ability to cheat then with javascript/ajax.

Also having the ability to set the amount of decks for black jack would be great. And for the deck to only shuffle when the stack has been gone through instead of every hand.

[towermatt]

On the open events page you should have a "add" button at the bottom. Beside each event you should have a "edit" and at the top there should be a 4th item called "settle bets"

Well crap, I am not sure why this one thing is so hard for me. Of course, it has to be the thing that people want. I am not seeing either one of those.

I hate to uninstall and re load because a bunch of folks have bets in there...not sure what to do to get those. Here is a screen shot of my betting pool page.

http://img85.imageshack.us/img85/8392/screenfb2.jpg

I'm not seeing the edit or the add

[Andrew Green]

Well crap, I am not sure why this one thing is so hard for me. Of course, it has to be the thing that people want. I am not seeing either one of those.

I hate to uninstall and re load because a bunch of folks have bets in there...not sure what to do to get those. Here is a screen shot of my betting pool page.

I'm not seeing the edit or the add

Don't need to uninstall, but you might try uploading and overwriting the sportspool.php file again, and double checking your usergroup settings

[towermatt]

That did it!

Thanks again Andrew. This thing is great.

Is there a way to delete all my test ones? Not a big deal but I thought I would throw the question out there.

[evesve]

How about a "All in" button
There is no "All In" in Limit Poker.
OK, if the bet is 4 and I only have 1, than it must be possible to bet "All In".
I don?t know how it is here...

[chatzworld]

about he roulette wouldn't mind it being single player at all jsut had a few people wanting it multi but if it was possible to get some other games multi player that would be great as they are loving having a multi player at the moment

[lasto]

about he roulette wouldn't mind it being single player at all jsut had a few people wanting it multi but if it was possible to get some other games multi player that would be great as they are loving having a multi player at the moment

wot roulette am i missing something here

[lasto]

ive only got 6 games on my menu :

Video Poker Jacks or better to win.
Blackjack Classic Casino Game.
Sports Betting Pool Place bets on upcoming events.
Lottery Buy into the lottery
Slots 3 wheel slot machine
Texas Hold 'em Limit game of Poker, up to 10 players

[yoyoyoyo]

That would be absolutely fine from my perspective.same here - any roulette you can work up would be awesome. A craps game would be good also

[Andrew Green]

ive only got 6 games on my menu :

Video Poker Jacks or better to win.
Blackjack Classic Casino Game.
Sports Betting Pool Place bets on upcoming events.
Lottery Buy into the lottery
Slots 3 wheel slot machine
Texas Hold 'em Limit game of Poker, up to 10 players


You're missing a "Let it Ride" which came with .40

Check to make sure it's listed and turned on in the casino settings, if not you might want to reimport the product file if you've already upgraded to .40 and it's still not there.

[lasto]

will i have to redo any edits ? not even sure which version i upped now

[Andrew Green]

will i have to redo any edits ? not even sure which version i upped now


There are only 3 template edits.

1 is to put the cash amount in the postbit

1 is to put a link on the navbar

1 is to put a box under the navbar if there is a poker game active.

They do not need to be redone on upgrades.

[NeilK]

Does anyone know if it's possible to cheat at javascript or ajax based games because I have two people who have ridiculous point totals from the casino right now and I can't quite seem to see how it's is possible.

I have everyone 5,000 points and the most people can bet on a game is 100 points because that is the highest chip.

The person with the highest points from the casino by this Wednesday will win a prize.

One person had 1,200 points at one time on about last Thursday. Now they have over 110,000 points and their totals seem to be going up very fast. How is this? It just doesn't seem possible. If anyone knows can you shoot me a pm or maybe this person and one other person are just really lucky.

There were 25 people in this contest and more then half are eliminated because they lost all of their points.

Thanks


I was wondering the same, after a user that couldn't get above 300 credits for days (constantly bugging me to reload him) suddenly, in a matter of a couple hours, got him self to 28000. If I watch his profile, and refresh every second, it's like watching the national debt climb. :)

[Andrew Green]

I'll put all the payouts to casino norms with the next update, then you can watch him bankrupt himself again :)

[lasto]

yeah cause at moment odds are in favour of the user.

[NeilK]

I'll put all the payouts to casino norms with the next update, then you can watch him bankrupt himself again :)

That's when I'll enable the big chips again. muahahahahahah

Thanks

[Wolf_Hook]

I am a little confused at the $inpoker addition.

Am I right in thinking that this is simply pasted right under the very last <if> statement in the Navbar template?

It just seems after doing that it has no effect.

[Andrew Green]

I am a little confused at the $inpoker addition.

Am I right in thinking that this is simply pasted right under the very last <if> statement in the Navbar template?

It just seems after doing that it has no effect.


Yup, very last line. And it will have no effect unless there is someone in the texas hold 'em game.

[74corvette]

Great Mod, at least my members have a way to loose the vbCredits now. They were starting to get restless.

I do have a couple problems that I didnt see an resolution for. One is the Richest Player field being blank. I'm using the Casino v4.0 mod, fresh install on a VBskinworks template with vbcredits. Is there a way to point that to VBcredits so the field isn't blank? Also I noticed While playing Slots, the payout amount doesn't show aligned in the payout box, it sits high in the box and covers where it says payout.

Any help is appreciated,

Great Mod.

[Wolf_Hook]

OK, thanks for your response.

[carleboy]

is there any way to change it from $ to £ i think that would be handy it the next update?

and andrew if you could acknolage the need for somthing on the texas holdem starting with a button or allowing a ready or sit out button as people get left out if they dont click ready quick enough cheers.

[Andrew Green]

is there any way to change it from $ to ? i think that would be handy it the next update?

and andrew if you could acknolage the need for somthing on the texas holdem starting with a button or allowing a ready or sit out button as people get left out if they dont click ready quick enough cheers.

The currency sign will be editable once this thing gets phrased, then everything will be easier to edit.

I'll have a look at the delay time before the game starts, increase it a little and pop up the warning button if it's getting close.