vb.org Archive
Page 23 of 89 « First 132122 23 24253373 Last »
Show 40 post(s) from this thread on one page

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)

AdmiralGeek 10-22-2007 12:38 PM
logical error when playing the video poker, you get a pair of nines, and you get a jack wchi is better. The computer decides sure, we will make it two pair instead of letting you choose three of a kind, which is a higher pay out......

Andrew Green 10-22-2007 01:17 PM
Quote:
Originally Posted by Rushty (Post 1365718)
im getting an error when installing on MySQL v5 on Windows

Database error in vBulletin 3.6.8, casino versions .38 & .4

the error seems to be down to the use of a reserved word 'range' within thw SQL that creates casino_lotto_draw. SQL below.

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);
Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/...ved-words.html

Is that the error it is giving you? I can escape it or rename it next time around which should get around that...



Quote:
Originally Posted by leeman (Post 1365764)
I have Inferno Shoutbox ....

But I get confused when it conflicts with 3 outa six games ...

Well gonna try some stuff. Unless someone else have gotten the same and solved it.
Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?

Quote:
Originally Posted by AdmiralGeek (Post 1365767)
the 250, 500, 1000, chip in the admin control panel are not added automatically
maybe the admin.php needs to be re-done.
They have to be entered manually?
Yes they do. I know a lot of people have added higher chips, and I didn't want to overwrite existing settings, so the images are there, but they aren't added in.

Quote:
Originally Posted by samorite (Post 1365785)
when i try to save the changes i get

any ideas ?
I'll patch that query out of there and post it here when I get a few minutes.

Quote:
Originally Posted by Mark.B (Post 1365648)
Thanks Andrew. :D

Just for information, returning to the site at 0700 BST and the events have gone, so it looks like they are closing at server time rather than vbtime.
Ok, so the times all show up properly, but the events are staying open passed the time shown?

Andrew Green 10-22-2007 01:21 PM
Quote:
Originally Posted by AdmiralGeek (Post 1365855)
logical error when playing the video poker, you get a pair of nines, and you get a jack wchi is better. The computer decides sure, we will make it two pair instead of letting you choose three of a kind, which is a higher pay out......

Exactly what cards are you getting?

Any hand that would let you have both 2 pair and 3 of a kind should be a full house?

Vizionz 10-22-2007 01:27 PM
i am gonna install this shortly but mad props for putting this much work into a game mod.

Andrew Green 10-22-2007 01:32 PM
Quote:
Originally Posted by samorite (Post 1365785)
when i try to save the changes i get


any ideas ?

Overwrite the existing file with the attached one in the admincp folder.

AdmiralGeek 10-22-2007 01:49 PM
Quote:
Originally Posted by Andrew Green (Post 1365885)
Exactly what cards are you getting?

Any hand that would let you have both 2 pair and 3 of a kind should be a full house?
no, when i had 1 pair, and a jack. the jack takes another card and turns it into a pair, instead of leeting the 1 pair be a three of a kind. Get me now?

AdmiralGeek 10-22-2007 01:53 PM
the wild card (jack) doesn't know how to handle the situation, it cant consider that when you have just one single pair, it cant turn it into a three of a kind, unless there is another pair in the hand.

three of a kind, is stronger than two pairs.

Andrew Green 10-22-2007 02:14 PM
Jack is not treated as a wild card?

Rushty 10-22-2007 02:27 PM
Quote:
Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/...ved-words.html

sorry I should have said its 5.1 not 5.0 and range is a reserved word on 5.1: http://dev.mysql.com/doc/refman/5.1/...ved-words.html

Mark.B 10-22-2007 02:28 PM
Quote:
Originally Posted by Andrew Green (Post 1365878)
Ok, so the times all show up properly, but the events are staying open passed the time shown?
Yep, that's exactly it.

I tested this by re-uploading the old file (which I have left up for the time being) and the events that should be closed then disappear.

leeman 10-22-2007 02:33 PM
Quote:
Originally Posted by Andrew Green (Post 1365878)


Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?
I get it as soon as I click the link to the game ....

Where the cards should be I guess ...

BuckRodgers 10-22-2007 03:16 PM
ok thanks for the admin patch thats worked fine but when i click on more stats i get

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, casino_settings AS cs2, casino_bet_stats
                WHERE cs1.settingname = 'gamename'
                AND cs2.settingname = 'gameactive'
                AND cs1.switch1 = gameid
                AND cs2.switch2 = '1'
                AND cs1.switch1 = cs2.switch1
                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
and when i click on let em ride it just goes back to the casino main menu ?

Mark.B 10-22-2007 04:04 PM
Quote:
Originally Posted by samorite (Post 1365978)

and when i click on let em ride it just goes back to the casino main menu ?
I think the original casino.php file that was uploaded was missing a couple of lines that would solve that.

Looking at the ZIP file now, the lines are present, so if you redownload and replace the casino.php file, it should work.

Andrew Green 10-22-2007 04:10 PM
Quote:
Originally Posted by samorite (Post 1365978)
ok thanks for the admin patch thats worked fine but when i click on more stats i get


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
ok, not allowed to connect more then 2 tables at a time... got it.

Quote:
and when i click on let em ride it just goes back to the casino main menu ?
Upload and overwrite the casino.php file ;)

Mark.B 10-22-2007 04:12 PM
I've only just spotted this, but the new texasholdem_ajax.php file seems to be causing the game to refuse to load, just showing the start button which has no effect.

Reverting to the old file fixes it.

blind-eddie 10-22-2007 04:38 PM
I am getting alot of db errors when I try to reset cash....

Code:
Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user
SET casino_cash =;

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 '' at line 2
Error Number : 1064
Date        : Monday, October 22nd 2007 @ 03:53:54 AM
Script      : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer    : http://outerzone.us/forum/xxxxxxx/casino_settings.php
Code:
Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user
SET casino_cash = o.oo;

MySQL Error  : Unknown table 'o' in field list
Error Number : 1109
Date        : Monday, October 22nd 2007 @ 03:55:10 AM
Script      : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=o.oo&submit=Adjust+Cash
Referrer    : http://outerzone.us/forum/xxxxxxx/casino_settings.php
Code:
Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user
SET casino_cash =;

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 '' at line 2
Error Number : 1064
Date        : Monday, October 22nd 2007 @ 03:55:46 AM
Script      : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer    : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Andrew Green 10-22-2007 05:09 PM
Quote:
Originally Posted by blind-eddie (Post 1366044)
I am getting alot of db errors when I try to reset cash....
You're trying to reset to zero?

Put "0" in the field.

Leaving it blank won't work, decimals aren't needed.

BWilliams 10-22-2007 05:13 PM
Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146

Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.

Andrew Green 10-22-2007 05:25 PM
Quote:
Originally Posted by BWilliams (Post 1366063)
Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146


Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.
phpmyadmin and enter the following:

Code:
DROP TABLE casino_texasholdem_whoisin;
CREATE TABLE casino_texasholdem_whoisin (whoisinid integer NOT NULL PRIMARY KEY auto_increment, userid integer, seat integer, lastcheck integer, status integer, bet integer);

DROP TABLE casino_texasholdem_chatlog;
CREATE TABLE casino_texasholdem_chatlog (chatlogid integer NOT NULL PRIMARY KEY auto_increment, msg text, msgtime integer);

DROP TABLE casino_texasholdem_dealt;
CREATE TABLE casino_texasholdem_dealt (dealtid integer NOT NULL PRIMARY KEY auto_increment, playerid integer, card integer);
Where you upgrading or installing from scratch?

aggiefan 10-22-2007 05:30 PM
has there been any movement on a "who is in the casino" option for the "Whats going on?".... would be very nice to be able to tell who is in a game of texas holdem especially since its multiplayer.

Andrew Green 10-22-2007 05:31 PM
Quote:
Originally Posted by aggiefan (Post 1366074)
has there been any movement on a "who is in the casino" option for the "Whats going on?".... would be very nice to be able to tell who is in a game of texas holdem especially since its multiplayer.
Yes, latest version has a box on the main screen it does require a template change though. Instructions are in the readme.txt

BWilliams 10-22-2007 05:37 PM
Quote:
Originally Posted by Andrew Green (Post 1366069)
phpmyadmin and enter the following:
Where you upgrading or installing from scratch?
Installing from scratch. I thought at the time I had the old version installed and was going to uninstall it and install the new version. Right when I clicked the uninstall option the site when down. Have search through the database and deleted everything casino related and deleted all files via ftp.

Even running that code in phpmyadmin the site is still down.

Here is the code again from one of the eMails:

Quote:
Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1193077878;

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146



When I ran the sql command you provided I got this:

Quote:
Error
SQL query:

DROP TABLE casino_texasholdem_whoisin;



MySQL said:

#1051 - Unknown table 'casino_texasholdem_whoisin'

BWilliams 10-22-2007 05:42 PM
OK, just added the table back manually and the site is back up and running again. Dam that was scary being that I didn't have a recent backup of the database! Lesson learned for sure.

I must have gotten atleast 500 Database Error eMails within the last 30 minutes

aggiefan 10-22-2007 05:47 PM
Quote:
Originally Posted by Andrew Green (Post 1366075)
Yes, latest version has a box on the main screen it does require a template change though. Instructions are in the readme.txt
ahh thx.... just upgraded the script and didnt read the readme. i would like to see it enhanced though to show at the bottom of the page with the rest of vbulletin stats and how the flashchat plugin works. (this one https://vborg.vbsupport.ru/showthrea...sers+flashchat)

Andrew Green 10-22-2007 05:49 PM
Quote:
Originally Posted by BWilliams (Post 1366080)
Installing from scratch. I thought at the time I had the old version installed and was going to uninstall it and install the new version. Right when I clicked the uninstall option the site when down. Have search through the database and deleted everything casino related and deleted all files via ftp.

Even running that code in phpmyadmin the site is still down.

Here is the code again from one of the eMails:


When I ran the sql command you provided I got this:
Upload this file to your main forum directory, and run it, then remove it.

It will rebuild all of your casino tables up to v .34 which I believe is where you where at from the errors you have, then you can update to .40 without uninstalling and everything should work.

KoDex 10-22-2007 05:53 PM
I get a database error when trying to uninstall, how do I delete it?!!:mad:

Andrew Green 10-22-2007 06:02 PM
Quote:
Originally Posted by KoDex (Post 1366093)
I get a database error when trying to uninstall, how do I delete it?!!:mad:
Upload the attached to your main forum directory, run it, delete the file, then uninstall the product again.

This will drop all of the tables, if you get errors it's because you don't have those tables in, either because they where deleted or never where created. It will also clear the uninstall code for the product, so you won't get anymore errors uninstalling it.

KoDex 10-22-2007 06:22 PM
http://www.theurban.co.uk/dropcasino.php

database error still!! :(

Andrew Green 10-22-2007 06:29 PM
Quote:
Originally Posted by KoDex (Post 1366115)
As I said, that is ok, now uninstall the product again.

KoDex 10-22-2007 06:36 PM
sorted thanks.

rwilkins108 10-22-2007 06:51 PM
woo hoo :)

towermatt 10-22-2007 06:55 PM
Quote:
Sports pool events can now be added, edited and resolved outside of the admincp
I am wondering about this new feature. Is this permissions we could give someone else on the site to do?

Andrew Green 10-22-2007 07:34 PM
Quote:
Originally Posted by towermatt (Post 1366135)
I am wondering about this new feature. Is this permissions we could give someone else on the site to do?

AdminCP lets you choose usergroups for who has access to that.

towermatt 10-22-2007 07:40 PM
Thanks Andrew. I thought that is where it might be but I scanned the whole

adminCP>usergroups>specific user groups settings and could not find it. Should there be a new section in there?

Andrew Green 10-22-2007 07:41 PM
Casino settings -> Sportspool admin Usergroups

towermatt 10-22-2007 07:44 PM
Hmmm...even better.

I'm looking all over that thing and can't see it. Perhaps I didn't upload the file correctly even though that seems pretty straight forward.

My version shows .4

I'll keep having a look, to me its the same options as it always was. :(

Thanks again for the help

I have

general settings (not in there)
games available
mass cash adjustments
cash values

towermatt 10-22-2007 07:52 PM
LOL

I guess I simply do not have that option in the AdminCP--mine still says the same as it always did. Under Casino

Casino settings -> the list above, that's all that is there.
Groups
events
settle events
lottery settings
hold um settings

I even checked under the Vbulletin options. Simply cannot find it anywhere :(

acegames 10-22-2007 08:04 PM
Quote:
Originally Posted by towermatt (Post 1366173)
LOL

I guess I simply do not have that option in the AdminCP--mine still says the same as it always did. Under Casino

Casino settings -> the list above, that's all that is there.
Groups
events
settle events
lottery settings
hold um settings

I even checked under the Vbulletin options. Simply cannot find it anywhere :(
Have you uploaded the latest casino-product and selected overwrite ?

Andrew Green 10-22-2007 08:05 PM
upload the admincp files again and overwrite the existing ones ;)

My guess is that you forgot the admincp stuff when you upgraded :D

towermatt 10-22-2007 08:06 PM
:D

I could see that, I will try again.


All times are GMT. The time now is 09:28 AM.
Page 23 of 89 « First 132122 23 24253373 Last »
Show 40 post(s) from this thread on one page

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.02702 seconds
  • Memory Usage 1,856KB
  • 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
  • (5)bbcode_code_printable
  • (27)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