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)

Mark.B 10-29-2007 07:27 PM

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.

Andrew Green 10-29-2007 08:21 PM

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

Mark.B 10-29-2007 08:23 PM

Quote:

Originally Posted by Andrew Green (Post 1371399)
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 10-29-2007 08:26 PM

Quote:

Originally Posted by Andrew Green (Post 1371381)
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

Code:

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

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

Tulsa 10-29-2007 08:34 PM

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

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 10-29-2007 09:05 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.

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

midorinome 10-29-2007 09:09 PM

Quote:

Originally Posted by Andrew Green (Post 1350473)
I plan on getting a multiplayer poker game in there, but don't ask for a timeline ;)


that would rock!!!

Andrew Green 10-29-2007 09:22 PM

Quote:

Originally Posted by midorinome (Post 1371455)
that would rock!!!

It's been in for a while now ;)

xxxsaint 10-29-2007 09:38 PM

Quote:

Originally Posted by Andrew Green (Post 1371465)
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 10-29-2007 09:51 PM

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 10-29-2007 11:42 PM

Quote:

Originally Posted by wrestlepower (Post 1371490)
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.

Quote:

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

Quote:

Originally Posted by hornstar1337 (Post 1371565)
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 10-30-2007 02:35 AM

Quote:

Originally Posted by hornstar1337 (Post 1371565)
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 10-30-2007 04:11 AM

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 10-30-2007 04:21 AM

Quote:

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 10-30-2007 04:27 AM

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 10-30-2007 11:00 AM

Quote:

Originally Posted by Twilkey SRT (Post 1369727)
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 10-30-2007 02:02 PM

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

Code:

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 10-30-2007 02:12 PM

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

StreetTriple 10-30-2007 02:16 PM

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

mcasteel 10-30-2007 02:21 PM

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 10-30-2007 02:41 PM

Quote:

Originally Posted by StreetTriple (Post 1371974)
but when i set a value and click "adjust cash" an Sql error appaer..


What value are you putting in?

hitmanuk2k 10-30-2007 02:44 PM

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 10-30-2007 02:45 PM

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 10-30-2007 02:46 PM

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

StreetTriple 10-30-2007 02:53 PM

ok perfect! THANKS!

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

Greek76 10-30-2007 05:15 PM

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

subnet_rx 10-30-2007 05:46 PM

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

Andrew Green 10-30-2007 05:54 PM

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


All times are GMT. The time now is 05:30 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.05511 seconds
  • Memory Usage 1,834KB
  • 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
  • (4)bbcode_code_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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