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)

GoTTi 10-15-2007 02:52 AM

Quote:

Originally Posted by Andrew Green (Post 1360351)
Did you change the default value in your table?


yes i did. fro250 to 0. it sets everyone to 0 now. thanks.

GoTTi 10-15-2007 02:55 AM

can the holdem game be made to be unlimited?

sandt38 10-15-2007 03:03 AM

Quote:

Originally Posted by Andrew Green (Post 1360326)
it is bolded, you probably have your body color set to white?

yes

xchewbaka 10-15-2007 03:03 AM

Quote:

Originally Posted by stangger5 (Post 1360268)
I`ve got about 30 data base errors and getting more...lol..

Code:

Invalid SQL:SELECT vbbux FROM jelsoft_user AS user WHERE userid =; 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 1Error Number : 1064Date : Monday, October 15th 2007 @ 03:04:42 AMScript : http://www.thissite.com/casino/texasholdem_ajax.phpReferrer : http://www.thissite.com/casino.php?do=texasholdem


same here :o

Andrew Green 10-15-2007 03:05 AM

Quote:

Originally Posted by sandt38 (Post 1360362)
yes


I'll plug a "color: black" into those once I figure out this database error everyone is having

dawnavon 10-15-2007 03:06 AM

Quote:

Originally Posted by Ski-Whiz (Post 1360269)
Yeah, when I'm in the room, and we both hit ready, one gets kicked out..

:erm:
I've had that happen too, seems like if it is just 2 players it will happen, but with 3 or more players the game runs fine.

great Mod!!

Andrew Green 10-15-2007 03:16 AM

I think I might have the database error found, attached file should fix it, if someone who is having it can confirm this I'll update the main archive. (texasholdem_ajax.php attached to first post)

stangger5 10-15-2007 04:20 AM

Still get the same data base error with the new texasholdem_ajax.php..

I was useing my pc with IE7,,I couldnt read any of the chat box..
I login useing a laptop with IE6,,I can read the chat box with it...

GoTTi 10-15-2007 04:39 AM

removing a group from the events in admincp does not work.

Shazz 10-15-2007 04:51 AM

Screenshots look amazing. Wow

Masiello 10-15-2007 06:40 AM

Wow, you doing a true great work Andrew and create a fantastic product, I'm so excited awaiting the stable version for my Lottery site

Captain Kirk76 10-15-2007 06:59 AM

Quote:

Originally Posted by dawnavon (Post 1360366)
:erm:
I've had that happen too, seems like if it is just 2 players it will happen, but with 3 or more players the game runs fine.

great Mod!!

I have experienced this with my members too

Mark.B 10-15-2007 08:21 AM

We ran a test game with three players last night, and we found the following:

1) One of the three players had trouble with the chatroom box, he could type into it and we could see what he typed but he couldn't see anything we typed.

2) Sometimes you found yoursdelf pressing a ready button which did not respond.

3) One player ended up showing as "sat out" but could not get back in.

Apart from that, it's looking good. I didn't get any database errors.

wilburshere 10-15-2007 08:25 AM

excellent love it well done

frosch68 10-15-2007 10:13 AM

after betting i get this error

Quote:

Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:
SELECT casino_cash FROM vbuser AS user WHERE userid =;

MySQL-Fehler : 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 1
Fehler-Nr. : 1064
Datum : Monday, October 15th 2007 @ 01:10:10 PM
Skript : http://www.mydomain.com/forum/casino...oldem_ajax.php
Referrer : http://www.mydomain.com/forum/casino.php?do=texasholdem
IP-Adresse : 90.187.172.183
Benutzername : Tanja
Klassenname : vB_Database

FreeFall1 10-15-2007 10:41 AM

I managed to get it all uninstalled in the end, when i try a new install now i get this database error

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Monday, October 15th 2007 @ 07:40:02 AM
Script : http://www.channelislandsforum.co.uk...=productimport
Referrer : http://www.channelislandsforum.co.uk...?do=productadd

ninjamaster 10-15-2007 10:43 AM

thanks for this it look fun

ScottRowan 10-15-2007 11:04 AM

Does this work with vbCredits?

sandt38 10-15-2007 11:24 AM

Quote:

Originally Posted by ScottRowan (Post 1360626)
Does this work with vbCredits?

Yes. Just add "credits" into the money field.

dyna88 10-15-2007 11:27 AM

When I try to adjust cash I get this SQL error

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:

                        UPDATE vb3_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 15th 2007 @ 01:28:09 PM
Script      : http://........../casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer    : http://........../casino_settings.php
IP Address  : XXX.XXX.XXX.XXX
Username    : XXXXXX
Classname    : vb_database


Andrew Green 10-15-2007 11:56 AM

Quote:

Invalid SQL:
SELECT casino_cash FROM vbuser AS user WHERE userid =;
Pretty sure I found the problem with this, will post a fix later today.

Robbed 10-15-2007 12:36 PM

Where still having problems with the payouts and payout alignment.

https://vborg.vbsupport.ru/

Andrew Green 10-15-2007 12:51 PM

Quote:

Originally Posted by Robbed (Post 1360682)
Where still having problems with the payouts and payout alignment.

What site is this on?

Robbed 10-15-2007 12:59 PM

<a href="http://thebreakaway.net/forums" target="_blank">http://thebreakaway.net/forums</a>

u: test
p: test

Another issue, no lottery winners but in stats it shows
Lottery 13375 23655 177%

Andrew Green 10-15-2007 01:27 PM

Quote:

Originally Posted by Robbed (Post 1360700)
http://thebreakaway.net/forums

u: test
p: test

Another issue, no lottery winners but in stats it shows
Lottery 13375 23655 177%

payout problem is that you have a older version of the slotwheel image in there, New one doesn't have banana's at all so it's showing different results then it thinks it has.

The other one, not sure, that one is odd. I'll play with it a little and get something that works in.

dyna88 10-15-2007 01:42 PM

Ok I figured out I got this error because I didn't enter an amount when I tried to reset the amount...

Code:

Database error in vBulletin 3.6.7:

Invalid SQL:

                        UPDATE vb3_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 15th 2007 @ 01:28:09 PM
Script      : http://........../casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer    : http://........../casino_settings.php
IP Address  : XXX.XXX.XXX.XXX
Username    : XXXXXX
Classname    : vb_database


Andrew Green 10-15-2007 02:29 PM

Quote:

Originally Posted by jay007 (Post 1360067)
im getting a database error after an install, any suggestions/Help greatfully appreciated.
THX

Database error in vBulletin 3.6.8:

Code:

Invalid SQL:

                                                        SELECT cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active
                                                        FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4   
                                                        WHERE cs1.switch1=cs2.switch1
                                                        AND cs1.switch1= cs3.switch1
                                                        AND cs1.switch1= cs4.switch1
                                                        AND cs1.settingname='gamefile'
                                                        AND cs2.settingname='gamename'
                                                        AND cs3.settingname='gamedesc'
                                                        AND cs4.settingname='gameactive'
                                                        AND cs4.switch2='1';

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


This is a difference in your mysql settings not liking that query, I'll rework it into something simpler with the next update.

hoopsta 10-15-2007 02:39 PM

Is it possible to have stats for -

Top Casino Winners - Day
Top Casino Winners - Week

This might encourage more competition for those who don't show up on the overall winner board.

Also, it would be cool if down the road the Texas Hold 'Em was set up with a TOURAMENT feature where members had to "BUY IN" (say for $1,000 or so and play until they drop out or have no money left) so that a tournament could be held with a defined winner.

*not that you don't have enough time doing other stuff... just a thought! :)

thx

Andrew Green 10-15-2007 02:50 PM

Quote:

Originally Posted by hoopsta (Post 1360774)
Is it possible to have stats for -

Top Casino Winners - Day
Top Casino Winners - Week

This might encourage more competition for those who don't show up on the overall winner board.

The with the way those numbers are tracked, it's a one or the other thing. I could add a option to have them clear weekly or monthly, but no dates are tracked, just totals.

Quote:

Also, it would be cool if down the road the Texas Hold 'Em was set up with a TOURAMENT feature where members had to "BUY IN" (say for $1,000 or so and play until they drop out or have no money left) so that a tournament could be held with a defined winner.

*not that you don't have enough time doing other stuff... just a thought! :)

thx
Have to get all the bugs out of the stuff I have in there before thinking about what else I want to do ;)

FreeFall1 10-15-2007 03:17 PM

Hi im still getting this database error when i try to install, it looks like the Casino_Cash has been duplicated, anyone know how i get this sorted??

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Monday, October 15th 2007 @ 12:15:08 PM

Andrew Green 10-15-2007 03:21 PM

Quote:

Originally Posted by FreeFall1 (Post 1360809)
Hi im still getting this database error when i try to install, it looks like the Casino_Cash has been duplicated, anyone know how i get this sorted??


Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Monday, October 15th 2007 @ 12:15:08 PM


I am guessing you had it installed at some point already?

Do you have access to phpmyadmin or a mysql console?

gwerzal 10-15-2007 03:23 PM

Hi

Great mod, just installed the newest version today.

One question though

In the sports pool section there is 10 available set outcome spaces.

Would there be any chance of making it so you could have 50 set outcomes.

This would make this product rearly useful for me.

Andrew Green 10-15-2007 03:26 PM

Quote:

Originally Posted by gwerzal (Post 1360812)
Hi

Great mod, just installed the newest version today.

One question though

In the sports pool section there is 10 available set outcome spaces.

Would there be any chance of making it so you could have 50 set outcomes.

This would make this product rearly useful for me.


Shouldn't be too hard to change how many are allowed, I'll get back to you.

FreeFall1 10-15-2007 04:00 PM

Quote:

Originally Posted by Andrew Green (Post 1360810)
I am guessing you had it installed at some point already?

Do you have access to phpmyadmin or a mysql console?



Hi Andrew yes i had .22 installed that was working well, i installed 3 lastnight, it installed ok at first but the problem started when i installed it again by over writing it, i could not uninstall, i have access to phpmyadmin and mysql console

Andrew Green 10-15-2007 04:05 PM

You can manually remove the casino_cash field from the table, then the reinstall should work. If you want to keep existing data we could also strip the product file to not try and add them again.

evesve 10-15-2007 04:19 PM

I want all kind of Holdem games:
...Limit,
...No Limit,
...Pot Limit,
...Tournament
but I am very happy if we can get this to work for 100% first!

Here is an easy file to learn about the basic glossery for Texas Holdem...

csavern 10-15-2007 04:27 PM

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT credits FROM user AS user WHERE userid =;

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 1
Error Number : 1064
Date : Monday, October 15th 2007 @ 11:49:13 AM
Script : http://www.rotormadness.com/Forum/ca...oldem_ajax.php
Referrer : http://www.rotormadness.com/Forum/ca...do=texasholdem
IP Address :
Username : csavern
Classname : vB_Database



anyone know how to fix this problem

FreeFall1 10-15-2007 04:46 PM

Quote:

Originally Posted by Andrew Green (Post 1360832)
You can manually remove the casino_cash field from the table, then the reinstall should work. If you want to keep existing data we could also strip the product file to not try and add them again.



Thanks Andrew i deleted the casino_cash from the php and sql and now got a clean install and working ok, THANKS, im still getting proba with the chat box though after the first text it seems to freeze

Andrew Green 10-15-2007 04:56 PM

Quote:

Originally Posted by csavern (Post 1360847)
anyone know how to fix this problem

I do, and will tonight.

Quote:

Originally Posted by FreeFall1 (Post 1360861)
Thanks Andrew i deleted the casino_cash from the php and sql and now got a clean install and working ok, THANKS, im still getting proba with the chat box though after the first text it seems to freeze

Internet Explorer? If so try it in Firefox, Opera or something else and see if works there.

towermatt 10-15-2007 05:20 PM

I installed this after reading the thread, it looks great. My members have been yelling for that Texas holdum as well.

0 problem installing and I will begin testing on it now. Thanks for the great mod


All times are GMT. The time now is 02: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.03480 seconds
  • Memory Usage 1,849KB
  • 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
  • (20)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