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

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

10-27-2007 09:28 PM

Quote:

Originally Posted by Twilkey SRT (Post 1369951)

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

10-27-2007 09:44 PM

Quote:

Originally Posted by BuRuNDi (Post 1369980)

Hi,

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

Code:

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

10-27-2007 10:14 PM

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

any ideas any one ?

shepherdblake

10-28-2007 02:42 AM

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

10-28-2007 02:51 AM

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

Andrew Green

10-28-2007 04:29 AM

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

10-28-2007 07:06 AM

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

Code:

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	10-28-2007 10:45 AM

Quote:

Originally Posted by BuRuNDi (Post 1369980)

Hi,

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

Code:

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

10-28-2007 11:16 AM

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

All times are GMT. The time now is 06:00 PM.

Page 127 of 353

127

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03786 seconds Memory Usage 1,757KB 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 (3)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: