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)

conker1 11-29-2007 05:53 PM

Quote:

Originally Posted by Andrew Green (Post 1391802)
You can do that in real life too ;)

in my country you cant buy same tickets ;)

Well Thanks for reply...

Sunray2 11-29-2007 06:07 PM

Quote:

Originally Posted by Sunray2 (Post 1391301)
Okay, but it is going to take me a few minutes. I will pm you with a login.

Thanks,

C.

Andrew,

The slots are working:o. I was a complete dunce. I was testing the games as if I were at a casino where I would in reality either have a bucket of coins or paid in credits that I would draw funds from. Sooooo, my thought process was that I should be gaining credits to cash out, not keeping the same amount of credits when I hit for what equaled the amount the was bet.:D

Now that I am awake, testing is going great. I cannot wait for this beta to be a final.

Thanks for a great mod!

C.

ezurick 11-29-2007 06:07 PM

Quote:

Originally Posted by rwilkins108 (Post 1391818)
Actually, I wasn't talking about you, I'm talking about the others that have said "I'm not weeding through x number of pages"... It was just a general gripe and not directed at you, stop being so defensive!

:up:

RockMTP 11-29-2007 06:53 PM

Great program...Thanks!

I installed .72 (fresh install) as per the readme file but when i click the admincp> sports pool events / sports pool settle events & lottery setup I get a 'URL Not found On This Server' error page.

I can't see anything i've missed so any ideas would be appreciated.

Thanks

Andrew Green 11-29-2007 06:54 PM

Sounds like the admincp files didn't get uploaded.

RockMTP 11-29-2007 07:10 PM

Exactly it...only half of them got ftp'd for some reason! Thanks

xxxsaint 11-29-2007 11:58 PM

Are there any plans to introduce actual .tar game files like used in ibProCasino for this casino mod as well ?

SVTCobraLTD 11-30-2007 12:01 AM

How many people are running .72?

SVT

Andrew Green 11-30-2007 01:14 AM

Quote:

Originally Posted by xxxsaint (Post 1392031)
Are there any plans to introduce actual .tar game files like used in ibProCasino for this casino mod as well ?

Nope, this has nothing to do with any other casino, everything in it was written by me for it.

:Judge: 11-30-2007 03:51 AM

Fresh install could not have went any better. Great addition, thank you so very much Mr. Green :)

I am having issues with IE users in Texas Hold'em, that I have already mentioned at vbgaming.org.

shepherdblake 11-30-2007 04:21 AM

Running 7.2 without issue.

Greek76 11-30-2007 05:17 AM

Having a problem with the slots. After a few times of playing the bars dont stop spinning lol. My members have been complaining of dizziness. Is their a fix? Also how do you purchase a ticket for the lottery? I dont see an option when I click on the lottery to purchase a ticket. Thanks

skcyber 11-30-2007 11:23 AM

the lottery doesn't work with .72 ...

the cron doesn't work ...
Code:

Casino Lottery Draw

Fatal error: Call to a member function query_read() on a non-object in /home/*******/forum/includes/cron/casino_lotto.php on line 127


hgb 11-30-2007 11:31 AM

Quote:

Originally Posted by skcyber (Post 1392275)
the lottery doesn't work with .72 ...

the cron doesn't work ...
Code:

Casino Lottery Draw

Fatal error: Call to a member function query_read() on a non-object in /home/*******/forum/includes/cron/casino_lotto.php on line 127


fix is HERE

:)

skcyber 11-30-2007 11:52 AM

thk you !!! :D

It's works fine now ! ;)

thuffner 11-30-2007 12:25 PM

Quote:

Originally Posted by Andrew Green (Post 1391311)
Yes, problem is here:


Line 127 / 128 are now:

Code:

        $settings = $db->query_read($query);
        $setting = $db->fetch_array($settings);

They should be:

Code:

        $settings = $vbulletin->db->query_read($query);
        $setting = $vbulletin->db->fetch_array($settings);


Will be fixed next time I update, or making that change will do it.

What file is this in? My lottery is not working...

I saw some instances of that in casino.php - is this the file I need to edit? Is there more than one instance of that code in the file?

Andrew Green 11-30-2007 12:40 PM

includes/cron/casino_lotto.php

Greek76 11-30-2007 01:18 PM

Ah ok I didnt see the problem was posted before with the lottery. I changed the code ran the query and all is working well. Now just a fix for the slots.

Andrew Green 11-30-2007 01:33 PM

Quote:

Originally Posted by Greek76 (Post 1392343)
Ah ok I didnt see the problem was posted before with the lottery. I changed the code ran the query and all is working well. Now just a fix for the slots.

What's going wrong with your slots?

Hornstar 11-30-2007 02:36 PM

I just upgraded to the latest version and when I go to view the stats I get this database error:

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


jasculs 11-30-2007 02:37 PM

How are we looking with the "Raffle" addition. Any good news?

Andrew Green 11-30-2007 02:42 PM

Quote:

Originally Posted by hornstar1337 (Post 1392375)
I just upgraded to the latest version and when I go to view the stats I get this database error:

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


It seems to be coming up more frequently. You can solve it by adding a index to the "switch1" field in the casino_settings table through phpmyadmin.

I'm going to look at a better solution this weekend.

xadoa 11-30-2007 04:37 PM

hi,

great mod .. can u add a cronjob that refill all the account with 0 dollars back to the default value? so the lose users can play again next day? do this as in the 24hr based ??

thanks

XD

xadoa 11-30-2007 04:54 PM

Quote:

Originally Posted by hornstar1337 (Post 1392375)
I just upgraded to the latest version and when I go to view the stats I get this database error:

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


i got the same problem ..

xd

Andrew Green 11-30-2007 04:57 PM

Quote:

Originally Posted by xadoa (Post 1392424)
hi,

great mod .. can u add a cronjob that refill all the account with 0 dollars back to the default value? so the lose users can play again next day? do this as in the 24hr based ??

thanks

XD

This:
http://vbgaming.org/forum/showthread.php?t=11

or this:
http://vbgaming.org/forum/showthread.php?t=34

should give you what you need.

Hornstar 11-30-2007 04:58 PM

I may wait til you can provide a fix, as I dont want to make things worse.

I am not sure if this following database is due to the above, but I got this one when changing the cash setting in admincp to vbux

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE casino_settings SET switch1 =  WHERE settingname = 'ratebonus';

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 settingname = 'ratebonus'' at line 1
Error Number : 1064
Date        : Friday, November 30th 2007 @ 12:31:59 PM


Andrew Green 11-30-2007 05:01 PM

looks like you tried leaving the cell blank, if you want it set to "0", put a "0" in the box :)

danhaga 11-30-2007 05:01 PM

Problem:

I just uploaded and installed this. The install seemed to go fine. The admincp is visible and working.

When I go to the casino page I get a list of 10 games but when I click on them I get a black white screen, no errors.

I tried the headinclude edit on first page with no luck. Any ideas?

Firefox 2.0.0.10

Andrew Green 11-30-2007 05:04 PM

what's the site?

(and you might want to check the one in your profile... it didn't lead where it should have)

danhaga 11-30-2007 05:08 PM

Quote:

Originally Posted by Andrew Green (Post 1392444)
what's the site?

(and you might want to check the one in your profile... it didn't lead where it should have)

Ahh.. gotta update that

http://www.urbanatrophy.com/forum/casino/

danhaga 11-30-2007 06:08 PM

Another thing...

When I first installed it I got a "The requested URL http:// was not found on this server." upon clicking on the game links.

I looked at the address bar and saw that it was looking for casino/casino.php which was not there. I copied it from root to the casio folder.

So now instead of the "The requested URL http:// was not found on this server." error I get the white screen.

ajm4481 11-30-2007 06:11 PM

for some odd reason, the texas holdem feature isn't working and funny enough thats the main reason for downloading and installing this mod. Everything else works just fine. The issue when you click on texas holdem it loads the game and it looks fine.... You click the ready button and nothing happens... I got someone else to try to join at the same time and everything and he doesn't see me and i don't see him... any ideas on whats going on?
thanks in advanced

Andrew Green 11-30-2007 07:08 PM

Quote:

Originally Posted by ajm4481 (Post 1392477)
for some odd reason, the texas holdem feature isn't working and funny enough thats the main reason for downloading and installing this mod. Everything else works just fine. The issue when you click on texas holdem it loads the game and it looks fine.... You click the ready button and nothing happens... I got someone else to try to join at the same time and everything and he doesn't see me and i don't see him... any ideas on whats going on?
thanks in advanced



Update to .72, should fix that.

HDT 11-30-2007 10:55 PM

updated to .72 but now layout of roulette table not fix to screen,so when we view on 1024x768 resolutions screen the table has overlap.On v .71 displayed perfect.

csavern 12-01-2007 01:53 PM

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO casino_lotto_draw (drawtime, jackpot, price, `range`, numbers, totalodds, odds, winper) VALUES (1196830800, 0, 2, 25, 3, , '', '');

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

MikeTrin 12-01-2007 02:57 PM

This is VERY beta and full of sql errors. You may not want to run this on a busy server!!!

I hope it uninstalls.

punchbowl 12-01-2007 03:55 PM

Quote:

****: I bet he\'s asleep
minor but an ' causes a little hiccup.

Big improvement on the poker in this update (.72)

Seems much more responsive now. Regular players have reported getting no freezing. Had one report of a freeze but i blame user error!

Great work!

*Haven't tried out the sportsbook or lottery much yet. It'd be nice to have a permissions group for who can play poker and who can administer the lotto. Also perhaps the ability to kick people from the table would be nice - annoying to have someone 'parked' and have to wait for them to timeout every deal before we get our cards.

Kmaster 12-02-2007 01:21 AM

While I'm click ther casino user status, I have rec'd below datadase error.

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
http://www.xxxxxxxxxx.us/forums/casino.php?do=stats

Andrew Green 12-02-2007 01:36 AM

Quote:

Originally Posted by Kmaster (Post 1393281)
While I'm click ther casino user status, I have rec'd below datadase error.

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
http://www.xxxxxxxxxx.us/forums/casino.php?do=stats

This is a fairly common one, you can solve it by going into phpmyadmin and adding a index to the "casino_settings" table on the "switch1" field.

Next release will involve a major remodeling of how a lot of the settings are stored and will eliminate it completely.

Nikke 12-02-2007 07:34 AM

Any eta for the next release? Great product!


All times are GMT. The time now is 04:39 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.05731 seconds
  • Memory Usage 1,841KB
  • 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
  • (8)bbcode_code_printable
  • (14)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