vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Casino (w/ 10 player poker) (https://vborg.vbsupport.ru/showthread.php?t=159151)

Jimandbob 11-21-2007 07:09 PM

Andy, Just installed this on a live board.

It is fantastic, Thanks for all the hard work:)

TazeredBlackMan 11-21-2007 07:48 PM

Quote:

Originally Posted by Andrew Green (Post 1387051)
I might get a chance to look into this tonight or tomorrow, depending on what's going on. I'll have something by the end of the weekend at the latest.

Take your time, man, this is fun either way.

Also, this may just be me, but could you set up a statistics for the poorest people? I have a board that delights in mocking and laughing at them.

Spinball 11-21-2007 09:18 PM

Hello and thanks for the hack.
In the UK, our lottery has numbers 1-49 with 6 balls picked plus a bonus ball.
Full details at http://en.wikipedia.org/wiki/National_Lottery
I'd be VERY grateful if you could modify your wonderful hack so that it would be possible to emulate the UK Lotto.
Many thanks.

Andrew Green 11-21-2007 09:32 PM

Quote:

Originally Posted by Spinball (Post 1387161)
Hello and thanks for the hack.
In the UK, our lottery has numbers 1-49 with 6 balls picked plus a bonus ball.
Full details at http://en.wikipedia.org/wiki/National_Lottery
I'd be VERY grateful if you could modify your wonderful hack so that it would be possible to emulate the UK Lotto.
Many thanks.

That can definitely be done, we got the same odds here. I just figured that for a forum odds of 1 in 14 million where a little steep, you'd likely go years without ever getting a winner

Spinball 11-21-2007 09:39 PM

Got a bug for you.
Changed the currency symbol to a pound as per another post here.
The change is not reflected in the user profile page. It still shows a dollar sign.

Spinball 11-21-2007 10:20 PM

Quote:

Originally Posted by Andrew Green (Post 1387167)
That can definitely be done, we got the same odds here. I just figured that for a forum odds of 1 in 14 million where a little steep, you'd likely go years without ever getting a winner

There are set prizes :
3 numbers ?10 56:1 (i.e. 1 in 57)
4 numbers 22% of remaining fund 1,031:1
5 numbers 10% of remaining fund 55,490:1
5 numbers and bonus ball 16% of remaining fund 2,330,635:1
6 numbers 52% of remaining fund 13,983,815:1 (i.e. 1 in 13,983,816)

I can imagine that programming the lottery could get quite complicated, but we could have it so that the whole fund rolls over (if it doesn't already).

Tulsa 11-21-2007 10:25 PM

Andrew - is the any plans on giving the admin control of the odds for each of the games? I'd like to loosen mine up a bit as winning is fun for people and breaking even gets a tad bit old.

peterpigman 11-21-2007 10:34 PM

Quote:

Originally Posted by Tulsa (Post 1387196)
Andrew - is the any plans on giving the admin control of the odds for each of the games? I'd like to loosen mine up a bit as winning is fun for people and breaking even gets a tad bit old.

I use the thread rating/creating and posting bonus as a carrot to get people posting. Every now and again have a bonus day giving out lots of $s. The last time I did it we broke our highest posts and threads in a day ever lol. They soon blow that away and want another. As we have a section where anything goes it gives them something to do for a bit too. It has created an e-conomy with female members selling provocative pics :D for casino money which I found kinda funny. The options are endless tbh.

towermatt 11-21-2007 10:51 PM

The Casino Settings allow a way to "pay" people automatically for that stuff. My members love it.

We have also created access levels like you would do for an actual paid forum--they can "buy" privileges with their booty. People were worried about post whoring but it doesn't seem to be happening. Not to mention, my board is still pretty small (for now)

I also "pay" the staff.

Tulsa 11-21-2007 11:11 PM

Quote:

Originally Posted by peterpigman (Post 1387200)
I use the thread rating/creating and posting bonus as a carrot to get people posting. Every now and again have a bonus day giving out lots of $s. The last time I did it we broke our highest posts and threads in a day ever lol. They soon blow that away and want another. As we have a section where anything goes it gives them something to do for a bit too. It has created an e-conomy with female members selling provocative pics :D for casino money which I found kinda funny. The options are endless tbh.

All I can say is you must have better looking women on your forum than mine! Whoa.. not good.. :D

Andrew Green 11-22-2007 02:19 AM

Quote:

Originally Posted by Tulsa (Post 1387196)
Andrew - is the any plans on giving the admin control of the odds for each of the games? I'd like to loosen mine up a bit as winning is fun for people and breaking even gets a tad bit old.

Not really, for most games it's not even possible without "rigging" the game, which is something I definitely don't want to do.


Quote:

Originally Posted by Spinball (Post 1387190)
There are set prizes :
3 numbers ?10 56:1 (i.e. 1 in 57)
4 numbers 22% of remaining fund 1,031:1
5 numbers 10% of remaining fund 55,490:1
5 numbers and bonus ball 16% of remaining fund 2,330,635:1
6 numbers 52% of remaining fund 13,983,815:1 (i.e. 1 in 13,983,816)

I can imagine that programming the lottery could get quite complicated, but we could have it so that the whole fund rolls over (if it doesn't already).


Yeah, that was a day of math...

Basically that is what happens, although the percentages are different, and set up to payout about 100% overtime regardless of the numbers plugged in. However the percentages are set up with less number choices in mind, so a 6 number draw would pay very little for 3 & 4 hits. Which I think would annoy folks, as mentioned above, people like to win. If the lottery goes a year with no winners, chances are it would have no players either.


Quote:

Originally Posted by Spinball (Post 1387172)
Got a bug for you.
Changed the currency symbol to a pound as per another post here.
The change is not reflected in the user profile page. It still shows a dollar sign.

Yes, I'm undecided on whether I am calling it a bug yet or not though :D

You can manually change it in the plugin, but can't use the phrase in the plugin as that "group" isn't loaded outside the casino. I will probably end up moving it to the global group at some point though, and fixing that. But for now just edit the template. It will say something like "$$cash", just change the first dollar sign.

fxs158 11-22-2007 03:43 AM

Andrew thanks for a great mod, three request not sure if they have been asked or if it is possible.

For pools would it be possible to add the handicap or points to the individual teams?

Also would it be possible to create a football ticket where one could lets say add all nfl games and members select a team for each game, the tickets are sold lets say for 10 dollars and all the money is put in one pot. Whom ever selects the most team that won will get the total jackpot?

Lastly on poker, would mo limit Texas hold them be a possibility?

This is by far the best mod on my forum and really popular.

waller99 11-22-2007 03:57 AM

Andrew,

can you shoot me a quick reply to this?
https://vborg.vbsupport.ru/showpost....postcount=1870

Thanks.

Andrew Green 11-22-2007 04:06 AM

Quote:

Originally Posted by waller99 (Post 1387316)
Andrew,

can you shoot me a quick reply to this?
https://vborg.vbsupport.ru/showpost....postcount=1870

Thanks.

Yes I can, I'll have a look at making it more obvious next time I update.

Spinball 11-22-2007 05:53 AM

Quote:

Originally Posted by Andrew Green (Post 1387264)
It will say something like "$$cash", just change the first dollar sign.

Will do, thanks.
Another request (which is surely an indication of the enthusiasm with which you hack is being adopted) : is it possible to give people cash when they post to their blogs in the official vBulletin blog please? I really want to encourage the blog element of the site and this is one nice way to do so.
Also in some games, I think it would be useful to have a 'Leave table' type button or link (in Blackjack for example) so make it a little clearer for folks who miss the nav breadcrumb.
Thanks

DieselMinded 11-22-2007 11:59 AM

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE casino_blackjack_dealt SET hand = 1 WHERE cardnum = AND playerid = 1022;

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 playerid = 1022' at line 1
Error Number : 1064
Date : Thursday, November 22nd 2007 @ 12:51:03 AM
Script : http://dieselbombers.com/casino/blackjack_deal.php
Referrer : http://dieselbombers.com/casino.php?do=blackjack
IP Address : 0000000000000
Username : xzaq103
Classname : vb_database

evesve 11-22-2007 02:57 PM

Quote:

Originally Posted by Andrew Green (Post 1386976)
Well, I never claimed it was done. the version is listed at 0.70, and I'd say about 70% done is right.

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

This is bad, really bad, that people don?t understand that this is a BETA!
Please, Andrew, don?t run too fast!
It?s better with a bug-free product than 20 new games!
I can promise you a donation when we get 1.0! :up:

towermatt 11-22-2007 03:42 PM

I don't mind beta testing it a bit. My site is very much member developed so everyone lends a hand in developing this great product.

Its really fun

evesve 11-22-2007 06:47 PM

Quote:

Originally Posted by evesve (Post 1386418)
Nice game Roulette!
A bug...Winning number "0", I didn?t bet "0", I won ~4000

Once again.
I bet 50 (x9 but not on "0")
After bet I had 5209.
After winning number "0" I had 12409
Maybe important to know how much I won?

evesve 11-22-2007 06:50 PM

Quote:

Originally Posted by evesve (Post 1387658)
Once again.
I bet 50 (x9 but not on "0")
After bet I had 5209.
After winning number "0" I had 12409
Maybe important to know how much I won?

"0" came up again.
I bet 200 (from my 12409) on "0" and now I have 19409
Now I am a very rich man!

Black Tiger 11-23-2007 12:15 AM

@Andrew: I don't know if you are home yet, but if you are, could you please remember to have a look at post #1712?

Second issue is that when playing BlackJack a little fast, it tends to hang (stops working).

The Cat! 11-23-2007 02:34 AM

This is gonna sound sad, but how do I

"import the product"?

The Cat! 11-23-2007 03:19 AM

Let me rephrase that. How do I import the xml file?

Andrew Green 11-23-2007 03:25 AM

Quote:

Originally Posted by The Cat! (Post 1387849)
Let me rephrase that. How do I import the xml file?

In the admincp under products, at the very bottom "Add new product" select the product_casino.xml file and go :)

The Cat! 11-23-2007 03:27 AM

Thanks Andrew, this is my first mod install so I will

be asking a few questions that most of you will find

disturbing... I'm sure... LOL...

buurman 11-23-2007 06:07 AM

Quote:

Originally Posted by Andrew Green (Post 1386220)
Does it log them out right away? or is it a minute or so before that happens? What browser is the person getting logged out using?



Probably, I've not really looked into it though. Might have a look at CMPS and put together some modules at some point.

I had a problem with uploading files, they got corrupted, so no problems anymore... thx!
My users love it, so do I, so thx a bunch!

Hope the CMPS Module will be available in the future..

Erika 11-23-2007 06:16 AM

I just wanted to say THANK YOU for such a great mod! It works like a charm!

The Cat! 11-23-2007 07:08 AM

The only problem we are having is in the Texas hold'em

after several (4 or 5) hands the game freezes up. Thoughts?

Skyline_GT 11-23-2007 07:30 AM

I got this error on this page casino.php?do=stats
and I am using 0.70

Quote:

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 : Friday, November 23rd 2007 @ 04:29:19 AM
Script : casino.php?do=stats
Referrer :
IP Address :
Username :
Classname : vB_Database

peterpigman 11-23-2007 07:45 PM

Quote:

Originally Posted by Skyline_GT (Post 1387934)
I got this error on this page casino.php?do=stats
and I am using 0.70

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

daydie 11-23-2007 10:37 PM

Hey,

I had this hack installed n running for about 2 week,s suddenly it started getting errors when ppl wanted to play blackjack, so i uninstalled and try re-installing, i get this error:

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 : Friday, November 23rd 2007 @ 06:35:57 PM
Script : http://daydie.co.uk/admincp/plugin.php?do=productimport
Referrer : http://daydie.co.uk/admincp/plugin.php?do=productadd
IP Address : 82.23.183.49
Username : daydie
Classname : vb_database


Please hlp

Skyline_GT 11-23-2007 11:24 PM

Quote:

Originally Posted by peterpigman (Post 1388264)

Thanks a lot.

hgb 11-24-2007 02:21 AM

bet was plased on black but went to even

user says this

This is a 20" flatpanel viewsonic in 1280 x 1024...... small windows.

My roulette wheel looks just like the pic you posted ***** when I first openit up..... ballis slightly off set like that.

But if the window is to the right side and I place a bet.... the bet will not be on the number I clicked.... the bet will be placed far to the left..... example; if the window is all the way to the right so I can choose the bet amount chip...... and I place that bet on Black... it will instead place the bet on Even.
If you center the window the bet will be placed on Red, instead of Black.
BUT when the window is all the way to the left it will place the bet where I click.

does that make sense?

Oh by the way.. I use Mozilla Sea Monkey.

Erika 11-24-2007 08:59 AM

Quote:

Originally Posted by daydie (Post 1388347)
Hey,

I had this hack installed n running for about 2 week,s suddenly it started getting errors when ppl wanted to play blackjack, so i uninstalled and try re-installing, i get this error:

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 : Friday, November 23rd 2007 @ 06:35:57 PM
Script : http://daydie.co.uk/admincp/plugin.php?do=productimport
Referrer : http://daydie.co.uk/admincp/plugin.php?do=productadd
IP Address : 82.23.183.49
Username : daydie
Classname : vb_database


Please hlp

I tried uninstalling myself, so that I could reset the casino values - I told my members to play with it and added a ton of money each day, but wanted to reset it all ---

I went remove all the files and then to re-install as well and get the exact same error:
Duplicate column name 'casino_cash'

I went into MySQL's, but it didn't have a casino_cash --- I did drop all the other casino tables I saw though and tried the re-install - still no luck.

Please help!

Mark.B 11-24-2007 10:03 AM

casino_cash isn't a database table, it's a column within the USER table....have a look in there, it MUST still exist. Delete it from there and then try to reinstall.

Erika 11-24-2007 04:10 PM

That did the trick Mark! Thanks so much!

Mark.B 11-24-2007 06:24 PM

Quote:

Originally Posted by Erika (Post 1388695)
That did the trick Mark! Thanks so much!

Fantastic stuff, glad you got it sorted.

Dermo-MIO 11-24-2007 07:07 PM

great mod was just wondering how do i edit things in the admin cp ? i can find an option anywere thanks

Mark.B 11-24-2007 07:18 PM

Quote:

Originally Posted by Dermo-MIO (Post 1388783)
great mod was just wondering how do i edit things in the admin cp ? i can find an option anywere thanks

Make sure you have uploaded the files in the admincp folder, the options should be on the left under "casino".

Robbed 11-24-2007 10:19 PM

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

        
SELECT sum(bet) AS betsum(won) AS woncs1.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 rowscheck your WHERE and use SET SQL_BIG_SELECTS=or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number 1104
Date         
SaturdayNovember 24th 2007 07:21:18 PM
Script       
forums/casino.php?do=stats
Referrer     
: /forums/casino.php?
IP Address   
Username     Rob
Classname    
vB_Database 

Get this when clicking more stats


All times are GMT. The time now is 08:09 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07069 seconds
  • Memory Usage 1,866KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (21)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete