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)

powerful_rogue 11-20-2007 07:53 PM

Quote:

Originally Posted by Andrew Green (Post 1386463)
But did stop eventually?

Not for one of the members that contacted me. He quit after a few minutes.

sandt38 11-20-2007 10:43 PM

I am having the same problem with Roulette spinning continuously, Andrew.

winstone 11-20-2007 10:51 PM

same problem here with roulette,

Point on improving roulette: it is a great addition to place "something (like in casinos)" on the number that has been picked randomly once the spinning is done, and prints down somewhere how much the player has won in that round. Plus, in all the roulette games, there is a display which shows all the previous numbers, that would be a great addition too.

Great work so far, keep it up! I will donate my share to the project once I fully integrate it to my forum. I am still working on the templates to make it look more like a casino, but have been following your great progress closely.

Regards

ry215 11-20-2007 11:10 PM

Plz help, Andrew. I just upgraded 0.7 and once in a few times when I go to the casino, it says this:

Database error in vBulletin 3.6.6:

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 also says that when I click on More Stats.

peterpigman 11-21-2007 12:10 AM

Quote:

Originally Posted by ry215 (Post 1386549)
Plz help, Andrew. I just upgraded 0.7 and once in a few times when I go to the casino, it says this:

Database error in vBulletin 3.6.6:

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 also says that when I click on More Stats.

You need to make a table in your db, it is pretty easy. I had the same problem.

https://vborg.vbsupport.ru/showpost....postcount=1304

dodgeboard.com 11-21-2007 01:34 AM

Quote:

Originally Posted by Andrew Green (Post 1386257)
Check your lottery settings, hit update regardless and see if that fixes it.


Did that, then installed the .70 update according to the directions.

Still happening:

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO casino_lotto_draw (drawtime, jackpot, price, `range`, numbers, totalodds, odds, winper) VALUES (1195786800, 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
Date : Tuesday, November 20th 2007 @ 09:03:04 PM
Script : http://www.dodgeboard.com/forums/cron.php?rand=664320
Referrer : http://www.dodgeboard.com/forums/new...-calendar.html
IP Address : 76.213.128.43
Username : Unregistered
Classname : vb_database
Note that I only get this error in an email, and everything seems to work fine for me.

Asi9ine 11-21-2007 05:44 AM

This has been horrible so far, I have to say. I would like to recommend not releasing a product that does a) not install on the first try, and b) not work anyway, with all of the bugs it has. Was it not worth waiting another month to iron everything out?

Don't get me wrong, I couldn't build something of this magnitude, but this seems like a half-done job.

powerful_rogue 11-21-2007 08:13 AM

Quote:

Originally Posted by Asi9ine (Post 1386659)
This has been horrible so far, I have to say. I would like to recommend not releasing a product that does a) not install on the first try, and b) not work anyway, with all of the bugs it has. Was it not worth waiting another month to iron everything out?

Don't get me wrong, I couldn't build something of this magnitude, but this seems like a half-done job.

This product is in Beta Stage as highlighted at the top of the forum. Products in Beta stage mean they may have have bugs and its not recommeneded to install on a live board.

Why didnt you wait until the final version was released instead of installing beta on your live board?

I installed this first time, just like many others on here did. Just becasue it didnt install first time for you would suggest you didnt follow something correctly- Not very nice tarring the mod when its installed fine for everyone.

Some people :rolleyes:

Rajdeep 11-21-2007 08:16 AM

I didnt understood this line - "Delete the field from your user table through phpmyadmin"

What field ????

Quote:

Originally Posted by Andrew Green (Post 1386421)
Delete the field from your user table through phpmyadmin, as well as any casino_* tables. Then import the product.

You do not need to remove the old product file to upgrade, all that does is wipe your stats, scores and everything clean, just import the new product file and check off the allow overwrite box.


SLY LS1 11-21-2007 09:11 AM

Quote:

Originally Posted by Asi9ine (Post 1386659)
This has been horrible so far, I have to say. I would like to recommend not releasing a product that does a) not install on the first try, and b) not work anyway, with all of the bugs it has. Was it not worth waiting another month to iron everything out?

Don't get me wrong, I couldn't build something of this magnitude, but this seems like a half-done job.


Ha-ha, U joke

Lets blame the product because you failed to install it properly!!!

The product is in Beta stage and most people on here are helping out with bugs here and there, I've had it working fine on my site for over a month, I suggest you have another go, probably take your time and do it properly this time then come back and apoligise to Andrew when you've worked out just how good this mod is...


All times are GMT. The time now is 09:24 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.04230 seconds
  • Memory Usage 1,757KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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