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)

ezurick 09-26-2008 11:55 AM

Quote:

Originally Posted by Red Blaze (Post 1628972)
Not sure if this has been asked, yet. I read and re-read your first post, but still found no solution. I see two versions of the zip. Do I install .91 first, then upgrade to .92? Or can I install version .92 right off the bat?

Yes, install only one of them. The author just left an older version online if you prefer it... but not sure why anyone would want it. Also, if you use this with vbcredits, be sure to weed back through the thread and see manual updates. I don't rmemeber them and I am not sure how far back, but there are a couple to get it working right.

pmcnamara 09-26-2008 03:04 PM

any known time table for the recode ?

developer hasn't been online since june ?

shaunh 09-29-2008 06:41 AM

For time management, does this mod use the vbulletin clock or it's own clock?

I'm considering moving from vBookie to the sports pool in this mod because vBookie will not observe the new US daylight savings, though the rest of the board does.

WildFire.ca 09-29-2008 06:14 PM

I am getting this error "This game is AJAX powered and requires JavaScript to be turned on" It seemed to be working at first now its causing some problems. The problem seems to be with hold'em but one of the members were getting the error in 21 also. My site url is www.couchlockcafe.com if you want to take a look

troybtj 09-30-2008 05:45 PM

Version 0.92 Installed and working in vB 3.7.3 PL1. This add-on ROCKS!

Warning - Raw Database and system changes used below. Do not attempt if changes aren't clear, you could hork your entire installation!

That aside.. The Casino worked OK for a while, then I was getting the "This game is AJAX Powered", or random user page reloads, booting them. By this time, myself, as well as a huge mob of members were... unhappy addicts, and needed their casino back! This is the most AWESOME add-on I've ever come across, by the way! First I unloaded/reloaded add-on. Finally corrected errors by optimizing the DB Tables, then tweaking php5-xcache module options. Optimizer/Cache could also be Zend Server, or any other PHP caching optimizer, something vBulletin recommends for all larger installations.

Below are the general steps I took, which reduced server load greatly, and increased speed by ∞, followed by "Suggestions for next version".

*Note: The below does depend on free real RAM for caching, so if server is digging heavily into swap space to start with, the below may not be as magic as they were for this case, but should still help.

What I did to speed up existing code database access by ∞, most commands entered at mysql client prompt:
  • Change the "text" field types in database to varchar(x) with x being between 20 and 64 for most fields, like game name, in all tables. Make sure the field is big enough, but not overboard, e.g. 200 chars for 'username'. Any time a text field is used in query, it forces a temp table, no matter how small the query. The only fields that couldn't be readily changed were the PHP code storage.
  • Add indexes to all tables linked or used in conditions, pretty good performance increase, small DB size increase due to small table size.
  • Once most "text" fields in most casino_* files were changed to "varchar()", then indexed if needed:
  • Run ANALYZE TABLE casino_<tablename> - for each table.
  • If required, install php5-xcache module (or similar) and tweak settings.

WishList for next version
  • Would LOVE to have plugin use the vbulletin Datastore memcache config if enabled.
  • Lacking full memcache ability, ability to use the php5-memcache module if available, greatly reducing overhead from very frequent DB Reads

Details: Easy-ish explanation, hosting providers may be able/eager to help with this as well. In my.cnf, enable slow-query-log at 1-3 seconds, AND "log queries without indexes". For each <query> that shows up in mysql-slow, run "Explain <query>" in mySQL CLI, if it doesn't show indexes, add them to the fields in search portion of query (where clause, in, =, etc), especially if under "Extra" it says "using filesort" or similar, those are killing performance, especially at the rate the query is called.

Hope this helps some that were having problems with overloading/speed problems.

shot2bits 10-02-2008 09:21 AM

Hi, wondered if someone may be able to help.

I reverted my default template back and all of a sudden the casino (and arcade) vanished from the navbar.

They appear to both still be installed and active according to the admin panel yet thay are no longer on the navbar.

Any ideas?

Thanks, Rob.

troybtj 10-02-2008 09:55 AM

Quote:

Originally Posted by shot2bits (Post 1635462)
Hi, wondered if someone may be able to help.

I reverted my default template back and all of a sudden the casino (and arcade) vanished from the navbar.

They appear to both still be installed and active according to the admin panel yet thay are no longer on the navbar.

Any ideas?

Thanks, Rob.

In "navbar" template in your theme under AdminCP -> Style Manager -> <<expand>>
Search for:
Code:

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
Above that, add in the template:
Code:

<td class="vbmenu_control"><a href="casino.php?$session[sessionurl]">$vbphrase[casino_casino]</a></td>
That puts the link to the left of Calendar, the default. You can put it in a different spot as well, make sure to not miss a tag for an <if> statment, or put it inside another <td></td>

If you use template-modifications add on, that might be a better way to do the edits.

Disclaimer: I am not the developer of this, or affiliated in any way, just thought I'd help.

RichieBoy67 10-03-2008 06:29 AM

I am sorry I haven't read through this thread yet-- Is there a version for 3.7+ coming out any time soon??

Thanks

dxlwebs 10-03-2008 02:31 PM

does vbcredits work with this ?

sandt38 10-07-2008 12:41 AM

Quote:

Originally Posted by RichieBoy67 (Post 1636260)
I am sorry I haven't read through this thread yet-- Is there a version for 3.7+ coming out any time soon??

Thanks

A friend of mine had issues with his 3.7.X board running .92. They were freezing up constantly. I sent him .91 (I have every version of every software I load on my hard drive at home, in case I need to revert) and it ran smoothly for him. At that time .91 wasn't up here. I can only assume he realized .91 works better with 3.7 then .92 did.

I had to switch to 3.7.3 2 weeks ago (had to get vBCommerce running ;) ) and have also had no issues with .91 running.

Quote:

Originally Posted by dxlwebs (Post 1636487)
does vbcredits work with this ?

Yes, just change the cash field in the adminCP to "credits".

fattony69 10-07-2008 02:17 AM

I run 3.7.3 and have no problem with .92.

stack24 10-09-2008 04:42 PM

I have .92 installed on my 3.7.3 system and I was wondering how to get more than 100 as the max bet? I have checked all the chip denominations in the settings but when you play you can't bet more than 100 no matter how much money you have. Is that just how the game is setup?

Thanks

troybtj 10-09-2008 07:08 PM

Quote:

Originally Posted by stack24 (Post 1641224)
I have .92 installed on my 3.7.3 system and I was wondering how to get more than 100 as the max bet? I have checked all the chip denominations in the settings but when you play you can't bet more than 100 no matter how much money you have. Is that just how the game is setup?

Thanks

AdminCP -> Casino -> Game Settings -> Table Limit (Each Game is set independently)

That should set you up. I'm running the same version on 3.7.3.1

Minor glitches with AJAX in Texas Holdem, but most all were fixed by forcing the tables to be in memory (in post above).

milla da killa 10-09-2008 10:03 PM

Is there a way to set up more Texas Hold'em tables? With different blinds?

computer1 10-10-2008 06:22 AM

HI!
This work noce to the latest vers of vb :)
but where can I finde more game to the casino ??

1F42 10-13-2008 08:28 PM

I'm on version 0.81 can I update straight to ver 0.92? I've searched this thread and read many pages first but without finding an answer, also can I assume that the update will not reset my admin casino settings0 or users history/cash? I've never done an update before for any mod so naturally I am a little cautious ;)

And thanks for a fantastiic mod :)

1F42 10-19-2008 09:06 AM

Found out the hard way but yes it does update from 0.81 without a hitch...luckily

troybtj 10-20-2008 05:18 PM

Make sure you back up your database first! This cannot be undone! Double check table names if clicking/choosing in a graphical interface!


These are the tables to drop/delete when uninstalling or upgrading. (response was to now missing question above)

From mysql command line interface (CLI), assuming your database is titled "vbulletin", this would be how to do it on the server if you have shell access:

Code:

>  mysql vbulletin

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DROP TABLE casino_bet_stats;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_blackjack_dealt;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_donatelog;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_games;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_letitride_dealt;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_lotto_draw;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_lotto_tickets;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_sb_bets;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_sb_events;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_sb_groups;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_sb_outcomes;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_settings;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_texasholdem_chatlog;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_texasholdem_dealt;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_texasholdem_whoisin;
Query OK, x rows affected (X.XX sec)
mysql> DROP TABLE casino_vidpok_dealt;
Query OK, x rows affected (X.XX sec)

If you have a graphical interface to your database, select the table names above and choose "DROP" or "DELETE".

The above does NOT get rid of the "casino_cash" field in CN_user. The new installer overlooks that if it already exists. Otherwise, the solution for that is on most of the pages from the beginning of this thread.

infernow 10-20-2008 06:58 PM

This is a nice mod thanks

INSTALLED !

RockMTP 10-22-2008 08:55 AM

I have this installed and it works great!

Just wondering if it could be linked to the 'post thanks' hack to give users cash to play with every time they get thanked?

shadyninja 10-27-2008 12:26 AM

nice mod~installed!

westernohiopc 10-28-2008 04:57 AM

Im sure this has been answered a million time but after reading 25 pagesm and had about 190 to go I decieded to just ask.....
I get this error when clicking on the casino link in the default style... also I am going to have to add it to every style? cause none of our other styles have no casino link in the navibar. I added it ot the default....?

Warning: require_once(casino/stats.php) [function.require-once]: failed to open stream: No such file or directory in [path]\casino.php on line 231

Fatal error: require_once() [function.require]: Failed opening required 'casino/stats.php' (include_path='.;C:\php5\pear') in c:\domains\fta4free.com\wwwroot\forums\casino.php on line 231

dodgeboard.com 11-01-2008 11:27 PM

reupload the files, in ASCII format, not binary.

Yes, you have to edit NAVBAR in every style.

Chloraseptic 11-02-2008 08:11 AM

I have followed all the steps (and read all the pages ... all 200+) and still am getting the "This game is AJAX powered and requires javascript to be turned on." .. Im currently running 3.7.3, and I uninstalled (dropped the tables I needed to drop) and made the '/clientscripts' fix to the header...

has anyone got any ideas? The 'slots' ones work, just not the others....

Thanks

Maxman1544 11-02-2008 01:07 PM

I just went to give everyone cash and realized that casino is no longer listed in my admincp. Weird. I am on 3.72. Odd.

stickskills 11-03-2008 10:37 AM

Hey guys, thinking of installing this, but does it allow you to use an external cash hack to give the users cash to play with? Or does it use its own standalone cash system?

stickskills 11-06-2008 10:53 PM

A well done mod, hoping to see a new version come out sometime soon. :)

SNATCH3R 11-07-2008 04:47 AM

Quote:

Originally Posted by stickskills (Post 1658466)
Hey guys, thinking of installing this, but does it allow you to use an external cash hack to give the users cash to play with? Or does it use its own standalone cash system?

it allows you to use external cash system....am using vbcredits cash....

hobsdv 11-07-2008 07:02 PM

installed on 3.7.3 works perfectly

thanks

msworld 11-08-2008 02:12 PM

installed.

thank you .

RobbieZ 11-08-2008 06:42 PM

Im having problems with the sports betting.

*edit* Ive sussed it.. never set permissions.

Greek Wizard 11-10-2008 05:37 AM

Well I went and screwed something up.

I had it working fine with version 0.70 or something, but decided to upgrade to 0.92 and now when you go to the casino, clicking on any of the games links does nothing. It just refreshes the main casino page.

On a different site it works fine for me, so it's not a browser issue.

I tried upgrading.

Then uninstalling (manually in SQL), and deleting all the files and reinstalling both 0.91 and 0.92 with no luck.

i tried searching, but "pages won't load" or Games won't load" or Games don't play gives me nothing.

Thoughts?

hitmanuk2k 11-10-2008 01:42 PM

If anyone has this installed on a site about poker or gambling or something similar, let me know as a client of mine at work is interested in advertising on such sites.

benzz0 11-11-2008 05:28 PM

Quote:

Originally Posted by Bakushan (Post 1624840)
installed, and the users love it

any way to add $ to individual users?

I just edit the USER table and add whatever dollar amount in the Casino_Cash field...works like a champ but you need database edit privies...and I am NOT responsible if you hork you system up! :P

DieselMinded 11-12-2008 07:21 PM

PHP Code:

Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE casino_blackjack_dealt SET hand 1 WHERE cardnum =  AND playerid 5297;

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'AND playerid = 5297' at line 1
Error Number  
1064
Request Date  
WednesdayNovember 12th 2008 04:15:03 PM
Error Date    
WednesdayNovember 12th 2008 04:15:07 PM
Script        
http://www.dieselbombers.com/casino.php?do=blackjack&ajax=1
Referrer      http://www.dieselbombers.com/casino.php?do=blackjack
IP Address    : *************
Username      : ***********
Classname     vB_Database
MySQL Version 


How do i fix this?

glass fanatic 11-13-2008 06:43 AM

I uploaded this and everything seems to be there. Have the Casino button in the usercp but when I click on the button in the nav bar I get this...

The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404
www.theglassrod.com
Thu Nov 13 08:40:03 2008
Apache/2.0.59 (Gentoo) mod_ssl/2.0.59 OpenSSL/0.9.8g PHP/5.2.6-pl6-gentoo with Suhosin-Patch FrontPage/5.0.2.2635 1.0.1

Greek Wizard 11-23-2008 05:22 AM

Quote:

Originally Posted by Greek Wizard (Post 1662772)
Well I went and screwed something up.

I had it working fine with version 0.70 or something, but decided to upgrade to 0.92 and now when you go to the casino, clicking on any of the games links does nothing. It just refreshes the main casino page.

On a different site it works fine for me, so it's not a browser issue.

I tried upgrading.

Then uninstalling (manually in SQL), and deleting all the files and reinstalling both 0.91 and 0.92 with no luck.

i tried searching, but "pages won't load" or Games won't load" or Games don't play gives me nothing.

Thoughts?

Anyone have any ideas on why I click ona link it just refreshes the stats?

Does this newest version run on 3.6.x? (That said, I tried updating to 3.8.x and it did not work either)

if not, anyone have an older version that does?

DieselMinded 11-23-2008 02:17 PM

Hate to see this mod in the graveyard

Andrew hasnt been on since June

ArnyVee 11-23-2008 04:53 PM

This one's in mod graveyard? Wow....I wish someone would pick it up and update it. :(

Paulie420 11-23-2008 09:23 PM

Ok, so I started the install on this.

I copied all the files to their right directories, but got to the in the install text:

3. Import the xml file

And I don't know how to import the XML file. Or what XML file to use. Lol.

Also, any other tips you think I'll need during the install?

I just read posts about this being in the graveyard? And I HOPE not, my users would love a casino on the forums... I am using a new copy of vBulletin. 3.7.3 Patch Level 1 to be exact.

Does anyone have this working with this version?
If so, please help a newbie out and post the answers to my questions... If this is useable on 3.7.3 Patch Level 1 I want to get it installed.

Thanks in advance!

Paulie420


All times are GMT. The time now is 09:34 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.03580 seconds
  • Memory Usage 1,854KB
  • 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
  • (1)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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