Casino (w/ 10 player poker)

[Twilkey]

Please help me, y cant uninstall it

i use 0.50 and installed over 0.51, with either of this uninstall works.
Please post the error you are getting.

[team76]

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

Database error in vBulletin 3.6.8:

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

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

[BuckRodgers]

Delet the "casino_cash" field from your user table and you will be able to install again, that's the only leftover piece.

can any one tell me how to do this please ?

[Twilkey]

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

Database error in vBulletin 3.6.8:

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

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

can any one tell me how to do this please ?

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

Steps:
1. Sign in to your phpMyAdmin.

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

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

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

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

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

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

[chatzworld]

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

[rungok]

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

[BuRuNDi]

Hi,

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

Database error in vBulletin 3.6.8:

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
Date : Saturday, October 27th 2007 @ 04:59:52 PM
Script : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport
Referrer : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd
IP Address : 189.131.68.222
Username : BuRuNDi
Classname : vb_database

Thanks in advance :)

[Twilkey]

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

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

Hi,

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

Database error in vBulletin 3.6.8:

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
Date : Saturday, October 27th 2007 @ 04:59:52 PM
Script : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport
Referrer : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd
IP Address : 189.131.68.222
Username : BuRuNDi
Classname : vb_database

Thanks in advance :)

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

[Freesteyelz]

Attached file fixes.

Some left over testing code, replace existing file with this one.

(This goes for everyone that updated before this post, otherwise two of the seats will get nothing but a 3 & 4. )

Main .zip has been updated.


Thank you for the fix. :up:

[Kalina]

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

[Twilkey]

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

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

[johnrizz]

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

Steps:
1. Sign in to your phpMyAdmin.

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

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

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

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

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

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


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

[johnrizz]

Hi,

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

Database error in vBulletin 3.6.8:

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
Date : Saturday, October 27th 2007 @ 04:59:52 PM
Script : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport
Referrer : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd
IP Address : 189.131.68.222
Username : BuRuNDi
Classname : vb_database

Thanks in advance :)

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

[BuckRodgers]

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

any ideas any one ?

[shepherdblake]

Great mod - my users love it!!!

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

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

[shepherdblake]

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

[Andrew Green]

for everyone having installation / uninstallation issues:

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

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

[peterpigman]

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


Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, October 28th 2007 @ 03:57:29 AM
Script : http://forum.uncoverreality.com/casino.php?do=stats
Referrer : http://forum.uncoverreality.com/casino.php
IP Address : xxxxxxx
Username : Peterpigman
Classname : vB_Database

[HO3R]

Hi,

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

Database error in vBulletin 3.6.8:

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
Date : Saturday, October 27th 2007 @ 04:59:52 PM
Script : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport
Referrer : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd
IP Address : 189.131.68.222
Username : BuRuNDi
Classname : vb_database

Thanks in advance :)

Same error here with me!
I keep on looking!

Anyway great work

Greetz

[hitmanuk2k]

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

[sandt38]

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

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

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

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

[Twilkey]

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


Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, October 28th 2007 @ 03:57:29 AM
Script : http://forum.uncoverreality.com/casino.php?do=stats
Referrer : http://forum.uncoverreality.com/casino.php
IP Address : xxxxxxx
Username : Peterpigman
Classname : vB_Database

Contacting your host is what you needed to do.

Same error here with me!
I keep on looking!

Anyway great work

Greetz

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

[Tulsa]

Question on texas hold'em play.

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

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

[TaBaTaN]

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

Database error in vBulletin 3.6.8:

Invalid SQL:
DROP TABLE casino_letitride_dealt;

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

Please help me

[rungok]

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

Let &epos;em Ride

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

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

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

[SBlueman]

for everyone having installation / uninstallation issues:

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

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

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

[Andrew Green]

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

Let &epos;em Ride

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

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

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

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

[Captain Kirk76]

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

[rwilkins108]

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

Thanks

[Andrew Green]

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

Thanks

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

[Gripemaster]

I have a question before I install this fine looking addon. I have an arcade installed on my forum, and I have members who live in the arcade and very rarely post. I notice in the initial post that it can be restricted to usergroups, but does it offer a setting where a member has to have X number of posts before being allowed to play in the casino? Otherwise no one would ever post on my forum again. LOL :rolleyes:

[Strik3]

uhm if i include the xml i got this error :/

Databaserrror in vBulletin 3.6.8:

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-Fehler : 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
Fehler-Nr. : 1064
Datum : Sunday, October 28th 2007 @ 07:57:29 PM
Skript : http://xxx/admincp/plugin.php?do=productimport
Referrer : http://xxx/admincp/plugin.php?do=productadd
IP-Adresse : xxx.xxx.xxx.xxx
Benutzername : xx
Klassenname : vB_Database

[evesve]

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

Thanks
If I bet 10, raise (10) and raise again (10) than I have bet 30.
A pair give me 60 but than I must take 60-30=30
My payout is 30 and that is right.
OR?

[Andrew Green]

points come off as you bet.

So if you had bet 30, you are already down by 3o, so adding 60 puts you at +30 from where you where before the hand.

[Andrew Green]

I have a question before I install this fine looking addon. I have an arcade installed on my forum, and I have members who live in the arcade and very rarely post. I notice in the initial post that it can be restricted to usergroups, but does it offer a setting where a member has to have X number of posts before being allowed to play in the casino? Otherwise no one would ever post on my forum again. LOL :rolleyes:

You can set up a usergroup that people are promoted too once they hit a certain number of posts.

Under usergroups -> promotions.

[Mark.B]

I've lost track slightly on updates here...is the sportspool timezone thing fixed yet, or is that for a later update?

[Andrew Green]

gimme a hour or two, working on that now as part of this next one.

[Mark.B]

gimme a hour or two, working on that now as part of this next one.
No rush...it was just that I was doing the 0.51 upgrade and wanted to see if I needed to bother with a Beyond Compare on sportspool.php...I shan't bother for now as I'm using an older file for that.

(I have to do a beyond compare to get the file edits back in that I have done to allow my casino navbar, Dream's Chatbox and my own Latest Threads scrolling module to appear on Casino pages. :D )

[Andrew Green]

.52 up now:

- Added a uninstall script in case something goes wrong, added error checking to existing uninstall code. If you where getting errors installing, run that, then uninstall the product, then reinstall with the newest version.
- Added the option to change default cash new users start with.
- Added cash bonuses for getting & giving reputation
- Added cash bonus for rating threads
- Fixed bug of sportspool events closing at different times in different timezones.

[NFLfbJunkie]

With all of the uninstalling problems, does upgrading/overwriting files with Version .52 cause any problems?

[Andrew Green]

It shouldn't. The only problems with that have been if you tried to uninstall a old version, then install a new one. Straight upgrades have never been a problem.

[Andrew Green]

Another option here might be a button that lets them reset to 100 (or some other amount)

Here is that:

http://vbgaming.org/forum/showthread.php?t=34

[Strik3]

removed all casino .51 files and uplaoded the whole pack again and get the same SQL error since befor..

[jasonbh]

How do you change the dollar sign to a pound sign?

$ -------> £

I'm in the UK you see.
Thanks.

[Andrew Green]

How do you change the dollar sign to a pound sign?

$ -------> ?

I'm in the UK you see.
Thanks.



Basically you're stuck until I phrase it all, then it will be easy :)

[Skyline_GT]

It would be awesome if there is an option to start a unlimited Texas holdem tournament. They will be given a different kind of chips to use in the tournament like the real tournament.

[rungok]

There is a problem with the sports betting events. When i try to Add and Event these outcomes shows:

:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

When i write inn values on line 1 to 8, the first choise (without the number) disappears and i get to 8'es. If I then try to edit the outcomes, I will get to 9'es next time. There is some values moving forward and some disappearing there. This seemes to work fine in Admin CP though.

And the time is still 1 hour wrong. I'm in GMT+1 zone. When I add a event closing at 21:00 the forums shows that it closes at 20:00.

FYI: I first installed v0.50, upgraded to 0.51 and then v0.52 with overwrite as specified.

[rwilkins108]

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

https://vborg.vbsupport.ru/external/2007/10/7.jpg (http://www.u-assist.com/photopost/showphoto.php/photo/16845)

I bet 100 raised 100 raised 100 again. If this is 1 to 1, that means I should just get back my money, $300.00, not $600.00. This is in .52 .

Thanks,

[xxxsaint]

https://vborg.vbsupport.ru/external/2007/10/7.jpg (http://www.u-assist.com/photopost/showphoto.php/photo/16845)

I bet 100 raised 100 raised 100 again. If this is 1 to 1, that means I should just get back my money, $300.00, not $600.00. This is in .52 .

Thanks,

If you were sitting at a casino table , you'd be right , because you would have never had that $300 leave your chip stack. However, when you click the $100 bet , it deducts $100 from your total money , and each time you raise it takes $100 as well. What you're not seeing is that before the payout , your bankroll is $300 shorter than when you clicked the first $100 bet , so since you won , in order for it to pay you the 1-1 $300 profit , it has to give you $600 back. If you would've lost , then it would have done it's job correctly by taking your $300.

[peterpigman]

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


Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date : Sunday, October 28th 2007 @ 03:57:29 AM
Script : http://forum.uncoverreality.com/casino.php?do=stats
Referrer : http://forum.uncoverreality.com/casino.php
IP Address : xxxxxxx
Username : Peterpigman
Classname : vB_Database

Ok I got a reply from my host about this, they replied with this.

We would like to inform you that the error you have received cannot be avoided by modifying SQL_BIG_SELECTS or SQL_MAX_JOIN_SIZE since that has been disabled due to rampant abuse. We would like to advise you that in almost all cases this issue can be resolved by adding an "index" to the columns that are referenced in the SQL statement. We suggest using phpMyAdmin to add an index to the fields referenced in the ON or WHERE clauses of the statement.

How the hell do I do that?

[parabat]

Looking good. Gonna test it and will be back to comment.
Thanx

-PB

[Twilkey]

I was playing in the casino one day and decided that I didn't want to click the casino button to go back and choose a different game. So I did a little work and ended up with my own casino navbar. Then I thought that others may want to use this also, without doing the work. So I made a product for it. Only a little template editing is required.

Difficulty: Easy
Files: 1
Template Edits: Between 1 and 9 (Depends where you want the navbar.)

I have also included a readme with instructions on the template edits.

Casino Credit goes to Andrew Green.
If you would like to add this to the Casino product, then that is fine by me.

[TheBlackPoet]

thanks twilkey... i like it... and it makes it easy to click to new... now if i can just stop losing money!!!!

[Andrew Green]

Ok I got a reply from my host about this, they replied with this.



How the hell do I do that?


Go into phpmadmin, click on the casino_settings' table. It will show you the structure in a little table. Third from the right is a button that says "Index" (image attached)

[towermatt]

.52 is going on today

I'm hoping that weird thing with the javascript doesn't happen but they don't play holdum too much during the day so it should be okay.

[Andrew Green]

It's not your javascript, it'w your php doing funky things on the include ;)

[towermatt]

Oh--I was just using that word as something that we would both recognize because its kind of the error moniker. :D

I'm not sure whats up with it, is it something I could ask my host about?

[Andrew Green]

Would be worth a try, basically it's including the end part of a .php file that has been included as part of the output. It has nothing to do with the contents of the file, and will do it in the middle of words. Last one I think was starting half way through a "return". All I did to fix it for you was remove most of the comments.

[towermatt]

Hmmm...would I have a good chance of them fixing it or should we mess with something else.

I hate to have you create a new file for me everytime. :(

[Andrew Green]

First thing you can try is just stripping out all of the commented stuff, which will probably do it.

[towermatt]

What PHP file would that be?

[Andrew Green]

texasholdem_functions.php has been the one that's been having it's tail stuffed into the output.

[carleboy]

It seems to working lovely now :)

any chance of putting the slot games together in casino home?

Video Poker
Blackjack
Sports Betting Pool
Lottery
Fruit Slots
Texas Hold
Let it Ride
Ninja Slots

Would be much better as

Video Poker
Blackjack
Sports Betting Pool
Lottery
Texas Hold
Let it Ride
Fruit Slots
Ninja Slots
7's Slots would also be nice in there.

Video Poker
Blackjack
Sports Betting Pool
Lottery
Texas Hold
Let it Ride
Slots

And the slots in a new page
Fruit Slots
Ninja Slots
7's Slots



Or even better if you could give us a selection in admin settings to change the order our selfs.

also the texas holdem still needs somthing to give us control over when it starts or a bleep etc as a game ends so that everyone knows to press ready so they dont get left out.

cheers andy keep it up m8.

[evesve]

Or even better if you could give us a selection in admin settings to change the order our selfs.

:up:

[towermatt]

texasholdem_functions.php has been the one that's been having it's tail stuffed into the output.

Thanks, I will have a look.

[peterpigman]

Go into phpmadmin, click on the casino_settings' table. It will show you the structure in a little table. Third from the right is a button that says "Index" (image attached)

Thanks, that fixed it. Server support gave me this

We would like to refer you to MySQL's manual which describes how to create an INDEX. http://dev.mysql.com/doc/refman/5.0/en/create-index.html

So i was thinking I had to write something out. Ty. :up:

[towermatt]

texasholdem_functions.php has been the one that's been having it's tail stuffed into the output.

Well now I am feeling a little stupid.

So I download the upgrade, pop open the file referenced above and "strip out all the commented stuff"

I assume this means getting rid of things it doesn't need but how can I tell what is commented?

[Andrew Green]

Any line that starts with "//" ;)

[towermatt]

Ah--that is what I thought.

I will do this at home tonight with a drink I think.

[Ski-Whiz]

So when do you get your own forum here on vb.org?? :D

[Mark.B]

I have something to report on the Lottery.

One of my members reported that they had a ticket with the jackpot numbers on, but it didn't pay out. On inspection I found it had done the draw, but not created a new one.

I then found out this member seems to have purchased over 600 tickets (!)

Is it possible that such a large number of tickets has caused the system to fall over? And would it also be a good idea to have limit on the number of tickets one member can purchase?

[Andrew Green]

I don't think it would, but I never tested it with that that many on the same draw...

I don't think I'll have time tonight, but tomorrow I should have time to try and break it, or at least figure out where it mighthave broken.

[Geez]

Database error in vBulletin 3.6.7:

Invalid SQL:
CREATE TABLE casino_settings (settingid integer NOT NULL PRIMARY KEY auto_increment,
settingname text, switch1 integer, switch2 text);

MySQL Error : Table 'casino_settings' already exists
Error Number : 1050
Date : Monday, October 29th 2007 @ 04:31:01 PM


can anyone tell me what to change in phpmyadmin to fix this? thank you

[Mark.B]

I've decided that, in common with a couple of others, I'd REALLY like the option of a third slots game with the 777 reel. Cos that reel looks great, but I don't want to lose the Ninja slots. :D

[Andrew Green]

Database error in vBulletin 3.6.7:

Invalid SQL:
CREATE TABLE casino_settings (settingid integer NOT NULL PRIMARY KEY auto_increment,
settingname text, switch1 integer, switch2 text);

MySQL Error : Table 'casino_settings' already exists
Error Number : 1050
Date : Monday, October 29th 2007 @ 04:31:01 PM


can anyone tell me what to change in phpmyadmin to fix this? thank you


With .52 there is a file in the tools folder that should clean everything out, then you'll be able to uninstall (if you can't now) and then reinstall.

To do it manually delete all tables that start with casino_ plus the casino_credits field in the user table, then go to products -> edit and delete all the stuff under uninstall code for casino, uninstall and then install with the latest version.

[Geez]

thank you for your response.

this was in an attempt to INSTALL. use this same procedure anyways?

[Andrew Green]

thank you for your response.

this was in an attempt to INSTALL. use this same procedure anyways?

Yes, I'm assuming you had a old version installed at one point and uninstalled? That's most likely where something failed, just needs to clean up so it can do it again.

[Andrew Green]

I've decided that, in common with a couple of others, I'd REALLY like the option of a third slots game with the 777 reel. Cos that reel looks great, but I don't want to lose the Ninja slots. :D


I can add new 3 wheel set ups fairly easily, only pain in the but part is calculating the payouts, so a 3rd wheel is definitely doable.

[Geez]

oh ok i took over this board so maybe they tried to install this at one point. thank you very much, i will try this right now

[Mark.B]

I can add new 3 wheel set ups fairly easily, only pain in the but part is calculating the payouts, so a 3rd wheel is definitely doable.
Personally, I'm not fussed if it shares the same (or similar) payouts to one of the existing ones, though I realise that might not suit everyone.

[Andrew Green]

I just think doing two machines that have no differences other then the images is cheating ;)

[Mark.B]

I just think doing two machines that have no differences other then the images is cheating ;)
Yeah you're probably right.

Well, if you do get time it'd be great, but if not it is no problem.

[Geez]

With .52 there is a file in the tools folder that should clean everything out, then you'll be able to uninstall (if you can't now) and then reinstall.

To do it manually delete all tables that start with casino_ plus the casino_credits field in the user table, then go to products -> edit and delete all the stuff under uninstall code for casino, uninstall and then install with the latest version.


well this worked for that error, but now i get

Database error in vBulletin 3.6.7:

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
Date : Monday, October 29th 2007 @ 05:22:53 PM

[Andrew Green]

Looks like you are using .51, .52 (current version) solved that :)

[Tulsa]

Can you set it up so all the points lost in the casino go straight into the admin's account? Then it would really be like owning a casino! :D


Just kidding...

[Geez]

im pretty sure i downloaded .52, but i may be wrong.

do i need to upload all those other files again or do i just need the updated xml file from the current version?

[evesve]

I can add new 3 wheel set ups fairly easily, only pain in the but part is calculating the payouts, so a 3rd wheel is definitely doable.

Isn?t it time for a 5-wheels?
:) :D ;) :up:

[midorinome]

I plan on getting a multiplayer poker game in there, but don't ask for a timeline ;)


that would rock!!!

[Andrew Green]

that would rock!!!

It's been in for a while now ;)

[xxxsaint]

It's been in for a while now ;)


Any word on a 5 card stud multiplayer ? Would kinda be like mixing texas hold'em and video poker together maybe ??

[wrestlepower]

can i just say this is ++++ing amazing. One of the most fun hacks ive ever installed. Only slight problem is that people seeem to be winning too often and that goes agaisnt my stingy nature.

[Hornstar]

can i just say this is ++++ing amazing. One of the most fun hacks ive ever installed. Only slight problem is that people seeem to be winning too often and that goes agaisnt my stingy nature. your lucky that people are winning, people think it is rigged on my board lol

Edit: just got a database error sent to my email.


Database error in vBulletin 3.6.8:

Invalid SQL:

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

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 = 103392
AND gameid = 8' at line 3
Error Number : 1064

[Twilkey]

your lucky that people are winning, people think it is rigged on my board lol

Edit: just got a database error sent to my email.

That was fixed in .52. What version are you using.

[Andrew Green]

your lucky that people are winning, people think it is rigged on my board lol

Edit: just got a database error sent to my email.

Most likely cause at first glance is someone trying to "cheat". Altering the javascript to try and bet a amount that isn't available would likely generate that error.

I'll add something to handle that a little more gracefully next round.

[gertoo]

Great addon *installed*

At some point the Llotery wasnt working, (no error message just no one was able to buy tickets)but now it does. I havent changed anything before or after so i wont be able to tell what was causing it.

[jasculs]

Most likely cause at first glance is someone trying to "cheat". Altering the javascript to try and bet a amount that isn't available would likely generate that error.

Is it possible for them to cheat this way?

[Andrew Green]

Nope, you sure don't trust your members ;)

Everything is done on the server end, cheating like can be done in flash based games is not really possible. They just get a error, and even if it worked it's not much of a cheat, they just bet a amount that normally isn't allowed.

[Robbed]

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

No, I didn't touch any templates. It was working fine in the first few versions.

[StreetTriple]

i've installed the last version 0.52 but i've this sql error (i've receive a mail):

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE forum_vbuser
SET casino_cash =
WHERE usergroupid IN (6);

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 usergroupid IN (6)' at line 3 Error Number : 1064
Date : Tuesday, October 30th 2007 @ 03:45:16 PM
Script : http://www.xxxxxxx.xxxxx/admincp/casino_settings.php?massadj=1&usergroups=6&amount=&submit=Adjust+Cash
Referrer : http://www.xxxxxxx.xxxx/admincp/casino_settings.php
IP Address : 79.x.37.xxx
Username : xxxxxxxxx
Classname : vb_database


this error is present also in "Mass Cash Adjustments " option...
how i can resolve it?

[Andrew Green]

You need to put something in there, if you want to set everyone to 0, put "0" in the field.

[StreetTriple]

but when i set a value and click "adjust cash" an Sql error appaer..

[mcasteel]

On my forum, there seems to be a problem with the Sit Out feature in Hold'em. If you fold, you have to sit out two hands and most people can't get back into the game unless they sit out 10 hands.

[Andrew Green]

but when i set a value and click "adjust cash" an Sql error appaer..


What value are you putting in?

[hitmanuk2k]

The Hold'em rules seem to be a little off. The dealer is acting first on the flop when it should be the small blind.

[StreetTriple]

i've click "reset" and insert usergroup id (only admin) and i click "adjust cash"
i do not insert any number in "amount"

[Andrew Green]

You need to enter something under amount. If you want zero, then enter "0"

[StreetTriple]

ok perfect! THANKS!

in the next release can you insert the phrases? I want translate it to italian lenguage!

[Greek76]

Just installed so far no problems. Great mod by the way!

[subnet_rx]

Has anyone experienced ridiculous money gains through some hack or bug? That would be my only concern with this addon.

[Andrew Green]

All the games should be paying out around 100% if they are played well. Some people will get lucky, others will not.

[hitmanuk2k]

OK the mod has been installed for a few hours and here are some things my users picked up on and would like changing for future updates:

- Split pots in Hold'em go to the bank (points disapear instead of being split).
- The dealer acts first on the flop in Hold'em, should be the small blind.
- Payouts for getting 3 in a row on slots are too low.
- Easier to know when it is your turn in hold'em

[Andrew Green]

- Split pots in Hold'em go to the bank (points disapear instead of being split).


That should have been fixed, but I've gotten a report of soemthing else I was sure I had fixed happening, so I'll check this when I get home... I'm thinking I made a stupid mistake and archived the wrong copy of a file...


- The dealer acts first on the flop in Hold'em, should be the small blind.

Will ook into that as well.


- Payouts for getting 3 in a row on slots are too low.


any higher and everyones cash would skyrocket. The machines pay out 100% right now.


- Easier to know when it is your turn in hold'em

... how much easier do you want it? If it's not your turn you can't do anything, if it is you can?

[hitmanuk2k]

Just a basic noise perhaps like poker software do? I know this just a mod for vbulletin so obviously no where near as advanced... and my members REALLY appriciate this mod it's great... but just something to make it easier to identify your turn would be great. Also, no-limit if it's possible? It's the most played type of poker.

Like I say though, I am being picky but it would turn a great mod into a marvelous one!

[towermatt]

I think the fact that it says "WAIT" when its not your turn works pretty well but I can see how if you were looking away you may not realize it was your turn.

Hey Andrew: Once I strip that file of the "unremarks" can I just save it for future upgrades or will I have to do that everytime?

[mcasteel]

So no one else is having problems when folding and not being able to play the next hand? For instance, when I fold sometimes it makes me sit out 4 or 5 hands before it will let me play again. Any help is appreciated.

[Andrew Green]

It was a issue, but it should be solved as of v .51, try reuploading the texasholdem files and make sure the overwrite the existing ones, if you are still having problems let me know. But I tested this on my server, .50 has the missing button, .52 does not.

[FreeFall1]

Hi Andrew would it be possible for tesax hold to show how many peeps are in the game before you enter?

[Cooleyvol]

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/public_html/forums/includes/xml/cpnav_casino.xml) is not within the allowed path(s): (/home/wwwtot/:/usr/lib/php:/usr/local/lib/php:/tmp) in /admincp/plugin.php on line 149

I get that error when importing the xml file.

When I just browse to the xml file on my computer and try to import, I get an invalid file message.

Any thoughts? I've never had a problem before.

[peterpigman]

Hi Andrew would it be possible for tesax hold to show how many peeps are in the game before you enter?

This part adds a box below your navbar showing how many players are in the Texas Hold em poker game, if any. If you would prefer not to use this feature disable the "Casino cash in profile" plugin.

========

In navbar Template, at the very bottom add:

*************************************************
$inpoker
*************************************************


it is in the readme file.

[Andrew Green]

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/public_html/forums/includes/xml/cpnav_casino.xml) is not within the allowed path(s): (/home/wwwtot/:/usr/lib/php:/usr/local/lib/php:/tmp) in /admincp/plugin.php on line 149

I get that error when importing the xml file.

When I just browse to the xml file on my computer and try to import, I get an invalid file message.

Any thoughts? I've never had a problem before.


? are you trying to import the cpnav_casino.xml file? If so that is the cause, that one just gets uploaded, it is the "product-casino.xml" file you import.

[Cooleyvol]

duh...........thanks. I had a brainfart.

[Atwal]

I'm having a problem with the Sports Pool betting event. It keeps having an extra column in the options.
It goes
:
1:
2:
3:
etc.

And if I use the ":" and the "1:" column, it says you need at least two options so I do "1:" and "2:" and it has no betting options so I do ":" "1:" "2:" and it still has no options.

[Andrew Green]

Using 1 & 2 should work, just ignore the ":"

You do also need to make sure you have a group selected (needs to be created in the admincp), a title and a date, otherwise it won't go through.

[rwilkins108]

you know what would be cool is if casino.php was accessible by guests, but the individual games (which would be shown) were only available to users, that way guests could see what their missing out on and be persuaded to join.

[Mark.B]

you know what would be cool is if casino.php was accessible by guests, but the individual games (which would be shown) were only available to users, that way guests could see what their missing out on and be persuaded to join.
Yes, I've been thinking that too actually.

[Andrew Green]

you know what would be cool is if casino.php was accessible by guests, but the individual games (which would be shown) were only available to users, that way guests could see what their missing out on and be persuaded to join.

I was thinking that too :D

Will be that way by the time it goes to a v1.0 release.

[rwilkins108]

I was thinking that too :D
Will be that way by the time it goes to a v1.0 release.


EXCELLENT :D Thanks Andrew!

[Atwal]

Will there be a "Delete event" in the upcomming versions for the sports pool?

[king_huzi]

Is it possible to have multiple people on a table Blackjack ... It would be fun to play blackjack with 2-3 friends and a chat ... even though it wont be multiplayer ... but it would really spice things up

[subnet_rx]

Is it possible to up the chip amounts? I'd like to have $10k and $25k.

[subnet_rx]

Is it possible to up the chip amounts? I'd like to have $10k and $25k.

Nevermind, just found it.

[subnet_rx]

I found a problem I think. I was testing the blackjack, clicked hit, and nothing was added. Clicked hit again, and got a bust. The 3rd card never did show up. If my blackjack and math are correct, this should be a 19.

[Andrew Green]

looks like it just didn't finish loading the picture for the 4, although you could make sure the image file made it to the server to be safe.

[Atwal]

For the new versions coming up, could we see something like a roulette?

Great product by the way.

[Hornstar]

For the new versions coming up, could we see something like a roulette?

Great product by the way.
That would be cool ^^

[vemkeit]

Very cool this is great thanks

[Greek76]

So when you play the casino is it suppose integrate all your vbux points or no? I did the file edit and replaced it with vbux like you said but when Im at the casino it does not show the amount of vbux points that I have it shows a much smaller amount. For example I actually have 13,000,000 something of vbplaza points but in the casino it shows 1304548. Also can you play texas against the computer if their are no other players?

[subnet_rx]

looks like it just didn't finish loading the picture for the 4, although you could make sure the image file made it to the server to be safe.

Shouldn't some alt text load that displays the number if the image doesn't load though?

[Andrew Green]

Shouldn't some alt text load that displays the number if the image doesn't load though?


It should, and when I actually code that in it will. 0.53, and about half way to where it needs to go, so there are a few things that it should do, but doesn't at this point.

[Andrew Green]

So when you play the casino is it suppose integrate all your vbux points or no? I did the file edit and replaced it with vbux like you said but when Im at the casino it does not show the amount of vbux points that I have it shows a much smaller amount. For example I actually have 13,000,000 something of vbplaza points but in the casino it shows 1304548. Also can you play texas against the computer if their are no other players?

no computer players in Texas Hold'em, just against the computer. As for vbux, I have never used it personally so I'm not sure why it would do that. Is it taking exactly 10% for everyone, close to 10%, different for different people?

[Greek76]

no computer players in Texas Hold'em, just against the computer. As for vbux, I have never used it personally so I'm not sure why it would do that. Is it taking exactly 10% for everyone, close to 10%, different for different people?

Well so far nobody complained yet I only noticed mine.

[Andrew Green]

It is exactly 10% though?

[Mark.B]

Wow hasn't this thread gone quiet. :o

Has everyone got all their issues fixed or something?

[riskofficer]

Russian language letters do not work (cyrillic 1251 or something like this -- im not specialist in this). I get something like arab letters "Èíôëÿöèÿ â êîíöå ãîäà" when translating or begin event or something else.

Excuse me for my English.

[deezelpope]

We're all off playing!!:D

[Andrew Green]

Russian language letters do not work (cyrillic 1251 or something like this -- im not specialist in this). I get something like arab letters "???????? ? ????? ????" when translating or begin event or something else.

Excuse me for my English.


I know, I think I have a solution to that, just need to implement and test it.

[Black Tiger]

I just installed this one, looks great!

I have a couple of questions though:

1.) I've vBA running. Now I want to integrate this in the sidebare so I have to edit the casino.php and add these lines:
define('VBA_PORTAL', true);
define('VBA_PAGE', 'RSide');

If I don't, all is working fine. If I do, I get this error notice:
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/mydomain/public_html/forums/includes/vba_cmps_include_template.php on line 9

How can this be fixed?
I don't want to use the module which was also mentioned in this post.

2.) In the lottery I put it to 40 numbers. But I would like to get 6 numbers drawn, but that isn't possible, maximum 5. Why?

3.) How can I change the amount of winnings? Now the Casino Jackpot for the lottery is 817685 and I would like to adjust this, same as with some other prices, how is this done?

4.) Foud a little bug, in the Let 'em Ride the title Let 'em Ride is ok, but in the forumlink it says:
Myforums->casino->Let 'em Ride

[DieselMinded]

Can you make this add a [x] after the nav bar link to display how many people are in the casino please

http://www.dieselbombers.com/

[Black Tiger]

5.) I see a Dollar sign everywhere. Where can I change this to a € (euro) sign?

[DieselMinded]

/me installed

Would like to integrate the Thanks Hack to the Default cash system

[Andrew Green]

I just installed this one, looks great!

I have a couple of questions though:

1.) I've vBA running. Now I want to integrate this in the sidebare so I have to edit the casino.php and add these lines:
define('VBA_PORTAL', true);
define('VBA_PAGE', 'RSide');

If I don't, all is working fine. If I do, I get this error notice:


Error is coming from VBA code, not casino. I have no idea as I don't use that product.



2.) In the lottery I put it to 40 numbers. But I would like to get 6 numbers drawn, but that isn't possible, maximum 5. Why?


to be perfectly honest, with 6 x 40 you'd be looking at odds of about 1 in 4 million, didn't think anyone would want it that high. From what I have seen I think most are only using 3 balls with a range of 15-20.

I can increase that with the next set, there really wasn't a reason, but with those numbers you will get very few people winning anything.


3.) How can I change the amount of winnings? Now the Casino Jackpot for the lottery is 817685 and I would like to adjust this, same as with some other prices, how is this done?


It increases as people buy tickets, and is calculated for a payout of 100% over time. There is no way to manually set it as it is based on the number of balls and the range of numbers.


4.) Foud a little bug, in the Let 'em Ride the title Let 'em Ride is ok, but in the forumlink it says:
Myforums->casino->Let 'em Ride

Yes, this has been fixed with the next release. Internet explorer quirk.

5.) I see a Dollar sign everywhere. Where can I change this to a ? (euro) sign?

No where right now, once phrases are in place you would edit the phrase.

[Andrew Green]

Can you make this add a [x] after the nav bar link to display how many people are in the casino please

http://www.dieselbombers.com/

You will get a display under the navbar saying how many people are in the Texas Hold'em game if that is what you are after. But if no one is in there you won't see it.

[DieselMinded]

I would like a more suttle approch at whos in there currently i have my chat and vbay set up to show [x] after the link in the navbar and i would really love for this to be the same , Can you help ?

[DieselMinded]

How can i convert it ?

heres my Vbay Link Code in my nav bar how do i change this to the amount of users in texas holdem

<td class="vbmenu_control"><a href="vbay.php">$vbphrase[vbay_navbar]<if condition="$vbulletin->options['vbay_auctionsinnav'] == '1'"> [$auctions]</if></a></td>

[DieselMinded]

<td class="vbmenu_control"><a href="casino.php?$session[sessionurl]">Casino</a></td><if condition="$vbulletin->options['vbay_auctionsinnav'] == '1'"> [$inpoker]</if></a></td>

????

[Andrew Green]

I would like a more suttle approch at whos in there currently i have my chat and vbay set up to show [x] after the link in the navbar and i would really love for this to be the same , Can you help ?


Change the plugin "casino players in poker" to this:
$pokertimeout = time() - 30;

$result = $db->query_read("SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > $pokertimeout");

$row = $db->fetch_array($result);

$inpoker = $row[np];



and put "$inpoker" wherever you want the number to show up. However this is just players in the poker game, not the single player games.

[DieselMinded]

That seems to be working great !! Thank YOU !! do you know how to remove the [] from the nav bar if no ones in poker ?

Never mind its showing [0] thats cool

thanks again

[Andrew Green]

<if condition="! $inpoker">[$inpoker]</if>

[DieselMinded]

That dont seem to be working i get nothing on index then it will go to [] on some pages all tests done with 1 player in poker

<td class="vbmenu_control"><a href="casino.php?$session[sessionurl]">Casino <if condition="! $inpoker">[$inpoker]</if></a></td>

[DieselMinded]

i removed the ! and its working

[Andrew Green]

i removed the ! and its working

opps, sorry about that, switched what I was going to give you half way through and got a mix of both :D

[DieselMinded]

lol No Biggie Thanks A Ton !

[bbchevy396]

I installed, and nothing came up in the admin cp. I uninstalled with the products manager, and tried to reinstall. When I import the xml file, this is what I get.:

Database error in vBulletin 3.6.8:

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

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060

Can anyone help me out here?

Thanks.

Edit...... Got it fixed, Thanks Mr green!

[DieselMinded]

Why Does the Poker Flash ?

[leeman]

OK.

When I disable the shoubox I get all games to work.

But I get this error on texas holdem.
"There are no free seats available, please try again later."

And I'm alone at the site ....

Just updated to 0.52

[riskofficer]

How to remove "cash: 250" from profile view?

Do not work buttons in blackjack. When mouseover they become black, but then, when mouse on other position, they still black -- javascript error. (vista, ie7)

[Crapforum]

Hi andrew.

After the update 0.52 the lottery doesnt work anymore on my site..
It tells me "No Draw Active at this time, please check back later" although its active in adminpanel and sched.task.

All the other fixed in 0.52 work great.
ty.

[Twilkey]

I installed, and nothing came up in the admin cp. I uninstalled with the products manager, and tried to reinstall. When I import the xml file, this is what I get.:


Database error in vBulletin 3.6.8:

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

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060



Can anyone help me out here?

Thanks.
You need to do this, then reinstall if you wish.

Steps:
1. Sign in to your phpMyAdmin.

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

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

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

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

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

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

[Twilkey]

How to remove "cash: 250" from profile view?


What you need to do is go to your admincp, and to your plugin manager. Find the plugin Casino cash in profile. Now just set its active field to no. Now save and you are done.

[Black Tiger]

Thank you for all your quick answers.

Error is coming from VBA code, not casino. I have no idea as I don't use that product.
Are you sure? I've several hacks amongst which also downloads II. They all don't give this problem when I put the vBA code in the file.

If anybody has this running under vBA 2.2.1 and can help me with how they did it, any help would be very appreciated!

[Andrew Green]

Why Does the Poker Flash ?

Has to do with it redrawing the cards, usually this isn't a problem, depends on your browser / computer.

OK.

When I disable the shoubox I get all games to work.

But I get this error on texas holdem.
"There are no free seats available, please try again later."

And I'm alone at the site ....

Just updated to 0.52


Check the setting: "Maximum players (2-10)" in the Texas Hold'em Settings.

Hi andrew.

After the update 0.52 the lottery doesnt work anymore on my site..
It tells me "No Draw Active at this time, please check back later" although its active in adminpanel and sched.task.

All the other fixed in 0.52 work great.
ty.

I'll look into it, it was working before? And if you hit recent draws, are they listed there?

Thank you for all your quick answers.

Are you sure? I've several hacks amongst which also downloads II. They all don't give this problem when I put the vBA code in the file.

If anybody has this running under vBA 2.2.1 and can help me with how they did it, any help would be very appreciated!

This is a vBA file that the error is ocurring in:
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/mydomain/public_html/forums/includes/vba_cmps_include_template.php on line 9


Could be something conflicting between the two, but I've not used vBA so I really can't say.

[leeman]

Check the setting: "Maximum players (2-10)" in the Texas Hold'em Settings.





It's on 10....

[Crapforum]

I'll look into it, it was working before? And if you hit recent draws, are they listed there?



thanks!
yes it was working before and "past draws" shows the latest draws and works fine.
All i did was upgrade to 0.52
I already try changing some settings and saving again but that didnt work.

Is there a way to reinitialize the lottery part? without re-installing the mod completely...

[Andrew Green]

Just to clarify, does "past draws" show draws more recent then when it stopped working? Or did they stop getting added to after the upgrade as well?

[Crapforum]

No , no new draws were made after the upgrade.
I did do a manual run of the cron job...I hope that didnt mess things up.

[Andrew Green]

It shouldn't, cron job finished properly (ie said "Done")?

and the cron job file was updgraded with everything else?

[Crapforum]

It shouldn't, cron job finished properly (ie said "Done")?

and the cron job file was updgraded with everything else?

yes, runs fine....done etc.
im gonna upload it again, just to make sure thats not the problem.

[Black Tiger]

Same problem over here with a new install.
Cronjob run manually, no changes made, no "past draws" visible.

Also if I change in the ACP the number of balls from 40 to 30, in the ACP the Jackpot goes toe 176646 but on the lotto page it is still 817690.
Seems like things on the Lotto page don't change when changes are made in the ACP.

[Andrew Green]

Same problem over here with a new install.
Cronjob run manually, no changes made, no "past draws" visible.

Also if I change in the ACP the number of balls from 40 to 30, in the ACP the Jackpot goes toe 176646 but on the lotto page it is still 817690.
Seems like things on the Lotto page don't change when changes are made in the ACP.

They shouldn't change right away, not until a new draw is set. Current draw finishes using the numbers it was created with before the new settings kick in.

[Black Tiger]

New draw was already set for tomorrow. Numbers are not finished either.

[Crapforum]

Well I got it working again.

The cronjob didnt create a new draw entry. (ticketnumbers =null)
I just set the lastdraw ticketnumbers field to Null again, manually run the cronjob and it works fine again.

Still dont know what caused it, but I know how to fix it now. ;)

Keep up the great work!

[thuffner]

Awesome mod!

Just wanted to suggest deleting Sports events - and I think something is wrong with the options for sports events - the numbering at least...

[Andrew Green]

Awesome mod!

Just wanted to suggest deleting Sports events - and I think something is wrong with the options for sports events - the numbering at least...


Just ignore the ":", it's already gone in the development version. ;)

A delete option will probably show up soon as well, although I'd recommend against using it... Best close them IMO, once an event is open for people to bet on it, if you delete it you'll get complaints.

[thuffner]

What about inactivity in poker?

Is everyone in the room screwed if someone gets booted/not active?

[Andrew Green]

If they don't respond or leave the room they automatically fold.

[Soonerdude]

My members love this mod! Thanks so much.

I've already had a few go broke and asking me if there is any way 1 player can easily loan money to another. Might be cool to add some kind of loan shark feature where those who don't really play much, can loan to others, with interest.

[towermatt]

Just ignore the ":", it's already gone in the development version. ;)

A delete option will probably show up soon as well, although I'd recommend against using it... Best close them IMO, once an event is open for people to bet on it, if you delete it you'll get complaints.

For me its just going to be to get rid of the test ones.

[Andrew Green]

My members love this mod! Thanks so much.

I've already had a few go broke and asking me if there is any way 1 player can easily loan money to another. Might be cool to add some kind of loan shark feature where those who don't really play much, can loan to others, with interest.

I do have a coupl of options available here: http://vbgaming.org/forum/forumdisplay.php?f=12

One to reset to a minimum on a scheduled basis, another to give a reset button to users.

For me its just going to be to get rid of the test ones.

if you're in a rush, could always be done through phpmyadmin, but I should have a delete option in there soon.

[DieselMinded]

What about inactivity in poker?

Is everyone in the room screwed if someone gets booted/not active?

How Do you Boot a user from the table ?

[Andrew Green]

Nothing in place to do that right now.

[towermatt]

Thanks Andrew--its not too big a deal so I can wait.

But I appreciate you throwing it on there, we have it figured out now so we won't have to do too much with it in the future.

I am going to strip that file of the "unremarks" tomorrow.

Do I have to do that every time there is an upgrade or can I just save a version of it and upload everytime?

[Andrew Green]

I'm still not really sure what causes the problem you've been having, seems slightly random, so it might need something, might not.

[towermatt]

hahaha

Okay, I don't mind fixing it every time I guess. :)

[SVTCobraLTD]

Is there anything to intergrate vbcredits into this to use as cash?

SVT

[Andrew Green]

Is there anything to intergrate vbcredits into this to use as cash?

SVT


Yes, instructions are in the readme.txt file.

[bbchevy396]

Installed , and a bit hit! Thanks!

One question, it may have been asked, but 97 pages is alot of posts to look through.
How about "no limit", or "All-in" Texas Hold'em?...... It would spice things up a bit. My members have been asking.

thanks again!

Jim

[wickedstangs]

Just installed and got an error when trying to play the card games. Looks like the slots and lottery are working? Also, How do I enable AJAX and Javascript?

Warning: require_once(../mkportal/include/VB/vb_out.php) [function.require-once]: failed to open stream: No such file or directory in /includes/functions.php on line 5170

Fatal error: require_once() [function.require]: Failed opening required '../mkportal/include/VB/vb_out.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/generals') in /home/gmntmare/public_html/community/includes/functions.php on line 5170

[SVTCobraLTD]

Where can I fix the coding for the entering of the games?

When I click on a game it is doing /forums/casino/casino.php but needs to be /forums/casino.php

Also when I go into the index of the games, it says "$" but has no amount next to it. I changed the default cash to vbcredits and when I get a game to load, it does show my current amount of credits.

I tried installing <a href="casino.php?$session[sessionurl]">Enter Casino</a></td> at the top of my arcade but for some reason it is not showing up anywhere on that page. Is that coding incorrect?

SVT

[993ti]

You might want to check this for the arcade thingy:
https://vborg.vbsupport.ru/showpost.php?p=1367376&postcount=1029

Not sure why it goes to casino/casino.php, it installed perfectly on my board (3.6.8 patch 1).

[Twilkey]

Where can I fix the coding for the entering of the games?

When I click on a game it is doing /forums/casino/casino.php but needs to be /forums/casino.php



Where did you install the casino.php. It should be in your forums root folder. Not in the casino folder.

[SVTCobraLTD]

Where did you install the casino.php. It should be in your forums root folder. Not in the casino folder.

casino.php is in the forums folder not in the casino folder. I found out what the problem was... i was trying to access it by going to mysite.com/forums/casino/index.php But if I do mysite.com/forums/casino.php it all is fine. Now I just need to read that other thread about the link in the arcade. Thanks

SVT

[towermatt]

I put on the upgrade, stripped all the remarks out of texasholdum_functions.php--reuploaded that file to my server and I am still getting the javascript error in the Hold Um game.

I went over and over the file to make sure I removed them all so I'm not sure what to do from here.

Also tried uploading that same file (that you fixed for me) in there, still the same thing

[Andrew Green]

Just installed and got an error when trying to play the card games. Looks like the slots and lottery are working? Also, How do I enable AJAX and Javascript?

This looks like something going wrong with the mkportal portion of your site, I'm guessing it had you edit functions.php?


You could try changing it's include functions to point to the full path of the mkportal files rather then "'../mkportal..."

[wickedstangs]

This looks like something going wrong with the mkportal portion of your site, I'm guessing it had you edit functions.php?


You could try changing it's include functions to point to the full path of the mkportal files rather then "'../mkportal..."

Andrew thanks for the quick reply. But, you are way over my head :) when you say try changing its include functions to point to the full path of the mkportal files rather then? Can you give me a little of more info...

Thanks again..

[Andrew Green]

Warning: require_once(../mkportal/include/VB/vb_out.php) [function.require-once]: failed to open stream: No such file or directory in /includes/functions.php on line 5170

Fatal error: require_once() [function.require]: Failed opening required '../mkportal/include/VB/vb_out.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/generals') in /home/gmntmare/public_html/community/includes/functions.php on line 5170

I'm just guessing as I'm not sure what it's doing. But looking at this it's trying to grab a mkportal file and can't find it from within the functions.php file.

instead of using "../" to jump to the folder, you could try the full path to the file. Replacing "../" with "/home/gmntmare/public_html/"

[wickedstangs]

which file do I try and change it in?

[Andrew Green]

which file do I try and change it in?

community/includes/functions.php

[towermatt]

Any idea on me Andrew? My holdum is still on the fritz :)

If you could do it one more time to the texasholdum_functions.php file for me, I will make a copy and figure out which ones. Then be able to do it next time.

[wickedstangs]

alot of info in that file. Can I upload it and you just take a look at it.


This is what I found on line 5170
//added from MKportal
define ( 'IN_MKP', 1 );
require_once "../mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end added

SHOULD I CHANGE TO THIS?

//added from MKportal
define ( 'IN_MKP', 1 );
require_once "/home/gmntmare/public_html/mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end added

[Andrew Green]

SHOULD I CHANGE TO THIS?

//added from MKportal
define ( 'IN_MKP', 1 );
require_once "/home/gmntmare/public_html/mkportal/include/VB/vb_out.php";
$output = mkportal_board_out($output);
//end added

That would be my first guess.

[wickedstangs]

Tried the above code and got this now?

Warning: require(../mkportal/conf_mk.php) [function.require]: failed to open stream: No such file or directory in /home/gmntmare/public_html/mkportal/include/VB/vb_out.php on line 30

Fatal error: require() [function.require]: Failed opening required '../mkportal/conf_mk.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/generals') in /home/gmntmare/public_html/mkportal/include/VB/vb_out.php on line 30

[Andrew Green]

well that's progress :lol:

Same thing in mkportal/include/VB/vb_out.php

find & replace "../" with "/home/gmntmare/public_html/"

[wickedstangs]

Here is the mkportal/include/function.php couldnt find it this time..And thanks again.

Andrew when I click on any of the card games I get this
This game is AJAX powered and requires javascript to be turned on.
and Start Button

When I click the start button it gives me the message above. How do I know my AJax is powerd and javascript is on?

[wickedstangs]

well that's progress :lol:

Same thing in mkportal/include/VB/vb_out.php

find & replace "../" with "/home/gmntmare/public_html/"

Andrew I found the info you said and it worked but, now I get red x for all my images. We are getting somewhere...:)
http://www.wickedstangs.com/Casino.jpg

[SVTCobraLTD]

3. Instructions for ibProArcade:

In FTP go to arcade/functions/functions.php and find:


global $header, $vbphrase, $vboptions, $stylevar, $headinclude, $bbuserinfo, $session, $show, $pmbox;



And replace it with:


global $header, $vbphrase, $vboptions, $stylevar, $headinclude, $bbuserinfo, $session, $show, $pmbox, $inpoker;



I did this code change but still there is nothing in the aracade.

Where the aracade home page says "Arcade ? Tournaments ? Your Settings ? Your Favorites ? Your Rankings ? Leaderboard ? Arcade ModCP" I would like to add "Casino" in there. Where can I edit this?

SVT

[Andrew Green]

I did this code change but still there is nothing in the aracade.

Where the aracade home page says "Arcade ? Tournaments ? Your Settings ? Your Favorites ? Your Rankings ? Leaderboard ? Arcade ModCP" I would like to add "Casino" in there. Where can I edit this?

SVT

The above was just to get the box that shows when someone is in the poker game to work on casino pages, if you want a link from within the arcade you'll have to add one into the Arcade's templates, or directly into the arcade.php file if it doesn't use templates.

[Andrew Green]

Andrew I found the info you said and it worked but, now I get red x for all my images. We are getting somewhere...:)


Did you add anything for mkportal into the casino files or templates?

[SVTCobraLTD]

Where the aracade home page says "Arcade ? Tournaments ? Your Settings ? Your Favorites ? Your Rankings ? Leaderboard ? Arcade ModCP" I would like to add "Casino" in there. Where can I edit this?

Looked in both the template and arcade.php files and I cannot find where to edit this header.

SVT

[Andrew Green]

v 0.60 (Nov 3)
- Added ability to delete event (event must be closed to delete it)
- Reworked Stats pages, more stats shown and page restructured
- Phrased most of the front end (currency marker is "casino_currency_marker")
- Texas Hold'em chatbox should allow non-english characters
- Redid buttons, added table graphic
- Added a bars and 7's slots (based on wheel by csavern)
- Removed the "Loading..." screens after taking action
- Fixed bug with extra line in adding sportspool event

To update overwrite all of the old files and import the product, revert any modified templates and don't forget the files in other folders Also some of the images have changed, those need uploaded again. (as well as the includes and admincp files) You DO NOT need to uninstall the previous version to upgrade, this will cause problems. Just overwrite existing files and import the product again, allowing overwrite.

**Make sure you overwrite ALL existing files and revert ALL templates**

[rwilkins108]

small thing, but getting this on the casino.php page for let 'em ride
Let &apos;em Ride (https://vborg.vbsupport.ru/casino.php?do=letemride)

[Andrew Green]

small thing, but getting this on the casino.php page for let 'em ride
Let &apos;em Ride (https://vborg.vbsupport.ru/casino.php?do=letemride)

More of a old thing hanging around, should be fixed for anyone installing from scratch, but depending on what version you are updating from that might still be there.

Just change the name of the game in the admincp.

[rwilkins108]

Liking the new update! Lots of little things that make it that much nicer! Plus, I see you made casino.php accessible to guests :D nice!

edit: for dumb brain fart...

[Andrew Green]

what config.php? do you mean casino.php?

[wickedstangs]

Did you add anything for mkportal into the casino files or templates?


No I did not

[Andrew Green]

No I did not

ok, just checking as it is sticking it header into the game window somehow.

Anyways, you'd have to do basically the same thing to get the images back

find where they are and plug the full path in:

so find "atb_home.gif"
which right now is set up like this: "../mkportal/templates/Forum/images/logo.gif"

and remove the ".." so it looks like this: "/mkportal/templates/Forum/images/atb_home.gif"

and same thing for all the other navbar images.

[wickedstangs]

Andrew I can find the images but, I cannot find which .php file they would be listed in? How can I do that?

[Andrew Green]

open files one at a time and CTRL+F -> "images/atb_home.gif" would be your best bet, I can't give you too specific of instructions as I don't use that piece of software.

[rwilkins108]

what config.php? do you mean casino.php?

oh, duh, i've just been installing wordpress forums (bbPress) and been in and out of it's config.php, so I guess I had it on my mind, yes, I meant casino.php :P

[Andrew Green]

oh, duh, i've just been installing wordpress forums (bbPress) and been in and out of it's config.php, so I guess I had it on my mind, yes, I meant casino.php :P

ok good, had me worried for a second there :D

[Dream]

Does this comes with it's own points system?

[Andrew Green]

Does this comes with it's own points system?


Yes, or you can use a different one by changing the cash field in the admincp.

[Dream]

Thanks :) I think I'm going to install this one.

[sinisterpain]

In texas holdem now I get start click start and nothing happens. getting message of ajax support requiring java to be enable which it is.

edit: IE7 problem thanks Andrew for the fix

[SBlueman]

New version installed! I love the new backgrounds on the card games, very slick.

[Andrew Green]

In texas holdem now I get start click start and nothing happens. getting message of ajax support requiring java to be enable which it is

I signed up, but don't have permissions to play...

[Andrew Green]

Note:

Minor problem in one of the files, broke chat on IE. FIxed version is in the main archive, if you've downloaded already the file you need to replace is up as well.

[Dream]

Installed, this mod is VERY nice and simple, thanks for sharing and for your hard work. Rated it 5 stars, and donated 10 bucks as a token of my appreciation. Thanks :)

I have one user that is having problems on IE7, can't click buttons on blackjack. On my Firefox 2 here everything seems to be working fine.

Also I'm amazed with the slots, can't imagine how you made it.

[johnrizz]

Andrew, Not sure if its just mine but the wheels on Slots - Bars and 7s continue to spin when you place a bet, sometimes they do stop though...

[Andrew Green]

make sure all your files got overwritten and if you've changed any templates revert them.

[SVTCobraLTD]

How can I turn off the Cash that is put in the Member's Profile? I looked in MEMBERINFO but couldnt find it.

SVT

[towermatt]

This is truly terrific Andrew, amazing work.

I love the new graphics and hold um works like a charm after the install.

Expect my donation for this on the 15th, its really good. Also voted Mod of the Month.

[dodgeuk19]

am loving this mod, gone down well on site i run,

any thoughts on a no limit poker ??

[inciarco]

Great Improvements, Andrew Green!! :up:

I Confirm the Bug in Texas Hold'em!! It Don't Start, and Every Player That Access That Game Is Creating a New One, not Joining an Already Created Game!! :( :confused:

I Hope You Can Fix That Little Bug!! ;)

The Images Are Great!! :up:

Until the Fixing I'm Returning to Previous Version 0.52!! :rolleyes:

My Best Regards!! ;)

:)

[sinisterpain]

IE7 problem with blackjack too just tested with firefox works fine but IE 7 buttons do not work

[Andrew Green]

I Confirm the Bug in Texas Hold'em!! It Don't Start, and Every Player That Access That Game Is Creating a New One, not Joining an Already Created Game!! :( :confused:


Bug fix has been made, just replace the "texasholdem_ajax.php" file that is in the main post.

[sinisterpain]

He just fixed the ie 7 issue with a new ajax file

[inciarco]

I Confirm Bug in Black Jack (Internet Explorer 6)!! Buttons Don't Work!! Allows To Start Game, Place Bet, But Can't Hit, Stay or Double Down!! :( :confused:

I Hope You Can Fix This Bug... In Previous Version Was Working Fine!! ;)

My Best Regards!! ;)

:)

[Andrew Green]

IE7 problem with blackjack too just tested with firefox works fine but IE 7 buttons do not work

Not my day with IE...

import fixed product file, will solve it.

[inciarco]

Not my day with IE...

import fixed product file, will solve it.

Importing the Fixed File "product-casino" Corrects the Problem with Black Jack!! Thank You Very Much Andrew Green!! :up:

My Best Regards!! ;)

:)

[Cigarcritic]

No payout chart in Bars and Seven.

The felt is a good start.