vb.org Archive - Major Additions - Casino (w/ 10 player poker)

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

10-29-2007 07:40 PM

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	10-29-2007 07:44 PM

Code:

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

10-29-2007 07:52 PM

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

10-29-2007 07:59 PM

Quote:

Originally Posted by Geez (Post 1371372)

Code:

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	10-29-2007 08:07 PM

thank you for your response.

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

Andrew Green

10-29-2007 08:12 PM

Quote:

Originally Posted by Geez (Post 1371386)

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

10-29-2007 08:13 PM

Quote:

Originally Posted by Mark.B (Post 1371375)

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	10-29-2007 08:13 PM

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

10-29-2007 08:16 PM

Quote:

Originally Posted by Andrew Green (Post 1371392)

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.

All times are GMT. The time now is 12:48 AM.

Page 133 of 353

133

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03530 seconds Memory Usage 1,745KB 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 (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: