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)

Gripemaster 10-28-2007 05:55 PM

I have a question before I install this fine looking addon. I have an arcade installed on my forum, and I have members who live in the arcade and very rarely post. I notice in the initial post that it can be restricted to usergroups, but does it offer a setting where a member has to have X number of posts before being allowed to play in the casino? Otherwise no one would ever post on my forum again. LOL :rolleyes:

Strik3 10-28-2007 06:00 PM

uhm if i include the xml i got this error :/

Code:

Databaserrror in vBulletin 3.6.8:

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);

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 ''range' integer, numbers integer, totalodds integer, odds text, winper text)' at line 2
Fehler-Nr.  : 1064
Datum        : Sunday, October 28th 2007 @ 07:57:29 PM
Skript      : http://xxx/admincp/plugin.php?do=productimport
Referrer    : http://xxx/admincp/plugin.php?do=productadd
IP-Adresse  : xxx.xxx.xxx.xxx
Benutzername : xx
Klassenname  : vB_Database


evesve 10-28-2007 06:11 PM

Quote:

Originally Posted by rwilkins108 (Post 1370486)
Andrew, after updating to .51, I see the Let 'em Ride payouts are wrong again. They're doubled what they should be and that was fixed in .50.

Thanks

If I bet 10, raise (10) and raise again (10) than I have bet 30.
A pair give me 60 but than I must take 60-30=30
My payout is 30 and that is right.
OR?

Andrew Green 10-28-2007 06:39 PM

points come off as you bet.

So if you had bet 30, you are already down by 3o, so adding 60 puts you at +30 from where you where before the hand.

Andrew Green 10-28-2007 06:49 PM

Quote:

Originally Posted by Gripemaster (Post 1370550)
I have a question before I install this fine looking addon. I have an arcade installed on my forum, and I have members who live in the arcade and very rarely post. I notice in the initial post that it can be restricted to usergroups, but does it offer a setting where a member has to have X number of posts before being allowed to play in the casino? Otherwise no one would ever post on my forum again. LOL :rolleyes:

You can set up a usergroup that people are promoted too once they hit a certain number of posts.

Under usergroups -> promotions.

Mark.B 10-28-2007 07:23 PM

I've lost track slightly on updates here...is the sportspool timezone thing fixed yet, or is that for a later update?

Andrew Green 10-28-2007 07:29 PM

gimme a hour or two, working on that now as part of this next one.

Mark.B 10-28-2007 07:39 PM

Quote:

Originally Posted by Andrew Green (Post 1370614)
gimme a hour or two, working on that now as part of this next one.

No rush...it was just that I was doing the 0.51 upgrade and wanted to see if I needed to bother with a Beyond Compare on sportspool.php...I shan't bother for now as I'm using an older file for that.

(I have to do a beyond compare to get the file edits back in that I have done to allow my casino navbar, Dream's Chatbox and my own Latest Threads scrolling module to appear on Casino pages. :D )

Andrew Green 10-28-2007 08:48 PM

.52 up now:

- Added a uninstall script in case something goes wrong, added error checking to existing uninstall code. If you where getting errors installing, run that, then uninstall the product, then reinstall with the newest version.
- Added the option to change default cash new users start with.
- Added cash bonuses for getting & giving reputation
- Added cash bonus for rating threads
- Fixed bug of sportspool events closing at different times in different timezones.

NFLfbJunkie 10-28-2007 08:56 PM

With all of the uninstalling problems, does upgrading/overwriting files with Version .52 cause any problems?

Andrew Green 10-28-2007 09:11 PM

It shouldn't. The only problems with that have been if you tried to uninstall a old version, then install a new one. Straight upgrades have never been a problem.

Andrew Green 10-28-2007 09:13 PM

Quote:

Originally Posted by Andrew Green (Post 1368478)
Another option here might be a button that lets them reset to 100 (or some other amount)

Here is that:

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

Strik3 10-28-2007 09:55 PM

removed all casino .51 files and uplaoded the whole pack again and get the same SQL error since befor..

jasonbh 10-28-2007 11:07 PM

How do you change the dollar sign to a pound sign?

$ -------> £

I'm in the UK you see.
Thanks.

Andrew Green 10-28-2007 11:58 PM

Quote:

Originally Posted by jasonbh (Post 1370745)
How do you change the dollar sign to a pound sign?

$ -------> ?

I'm in the UK you see.
Thanks.



Basically you're stuck until I phrase it all, then it will be easy :)

Skyline_GT 10-29-2007 12:12 AM

It would be awesome if there is an option to start a unlimited Texas holdem tournament. They will be given a different kind of chips to use in the tournament like the real tournament.

rungok 10-29-2007 12:23 AM

There is a problem with the sports betting events. When i try to Add and Event these outcomes shows:

:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

When i write inn values on line 1 to 8, the first choise (without the number) disappears and i get to 8'es. If I then try to edit the outcomes, I will get to 9'es next time. There is some values moving forward and some disappearing there. This seemes to work fine in Admin CP though.

And the time is still 1 hour wrong. I'm in GMT+1 zone. When I add a event closing at 21:00 the forums shows that it closes at 20:00.

FYI: I first installed v0.50, upgraded to 0.51 and then v0.52 with overwrite as specified.

rwilkins108 10-29-2007 12:34 AM

Quote:

Originally Posted by Andrew Green (Post 1370545)
My understanding is that they are correct now, but where incorrect in .50.

https://vborg.vbsupport.ru/external/2007/10/7.jpg

I bet 100 raised 100 raised 100 again. If this is 1 to 1, that means I should just get back my money, $300.00, not $600.00. This is in .52 .

Thanks,

xxxsaint 10-29-2007 02:59 AM

Quote:

Originally Posted by rwilkins108 (Post 1370794)
https://vborg.vbsupport.ru/external/2007/10/7.jpg

I bet 100 raised 100 raised 100 again. If this is 1 to 1, that means I should just get back my money, $300.00, not $600.00. This is in .52 .

Thanks,

If you were sitting at a casino table , you'd be right , because you would have never had that $300 leave your chip stack. However, when you click the $100 bet , it deducts $100 from your total money , and each time you raise it takes $100 as well. What you're not seeing is that before the payout , your bankroll is $300 shorter than when you clicked the first $100 bet , so since you won , in order for it to pay you the 1-1 $300 profit , it has to give you $600 back. If you would've lost , then it would have done it's job correctly by taking your $300.

peterpigman 10-29-2007 06:33 AM

Quote:

Originally Posted by peterpigman (Post 1370241)
getting this error when you bring up stats, I'm guessing it is a server prob and have contacted my host, am I correct?


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
Date        : Sunday, October 28th 2007 @ 03:57:29 AM
Script      : http://forum.uncoverreality.com/casino.php?do=stats
Referrer    : http://forum.uncoverreality.com/casino.php
IP Address  : xxxxxxx
Username    : Peterpigman
Classname    : vB_Database


Ok I got a reply from my host about this, they replied with this.

Quote:

We would like to inform you that the error you have received cannot be avoided by modifying SQL_BIG_SELECTS or SQL_MAX_JOIN_SIZE since that has been disabled due to rampant abuse. We would like to advise you that in almost all cases this issue can be resolved by adding an "index" to the columns that are referenced in the SQL statement. We suggest using phpMyAdmin to add an index to the fields referenced in the ON or WHERE clauses of the statement.
How the hell do I do that?

parabat 10-29-2007 10:47 AM

Looking good. Gonna test it and will be back to comment.
Thanx

-PB

Twilkey 10-29-2007 12:02 PM

I was playing in the casino one day and decided that I didn't want to click the casino button to go back and choose a different game. So I did a little work and ended up with my own casino navbar. Then I thought that others may want to use this also, without doing the work. So I made a product for it. Only a little template editing is required.

Difficulty:
Easy
Files: 1
Template Edits: Between 1 and 9 (Depends where you want the navbar.)

I have also included a readme with instructions on the template edits.

Casino Credit goes to Andrew Green.
If you would like to add this to the Casino product, then that is fine by me.

TheBlackPoet 10-29-2007 12:20 PM

thanks twilkey... i like it... and it makes it easy to click to new... now if i can just stop losing money!!!!

Andrew Green 10-29-2007 12:59 PM

Quote:

Originally Posted by peterpigman (Post 1370936)
Ok I got a reply from my host about this, they replied with this.



How the hell do I do that?


Go into phpmadmin, click on the casino_settings' table. It will show you the structure in a little table. Third from the right is a button that says "Index" (image attached)

towermatt 10-29-2007 02:04 PM

.52 is going on today

I'm hoping that weird thing with the javascript doesn't happen but they don't play holdum too much during the day so it should be okay.

Andrew Green 10-29-2007 02:43 PM

It's not your javascript, it'w your php doing funky things on the include ;)

towermatt 10-29-2007 02:51 PM

Oh--I was just using that word as something that we would both recognize because its kind of the error moniker. :D

I'm not sure whats up with it, is it something I could ask my host about?

Andrew Green 10-29-2007 02:55 PM

Would be worth a try, basically it's including the end part of a .php file that has been included as part of the output. It has nothing to do with the contents of the file, and will do it in the middle of words. Last one I think was starting half way through a "return". All I did to fix it for you was remove most of the comments.

towermatt 10-29-2007 02:58 PM

Hmmm...would I have a good chance of them fixing it or should we mess with something else.

I hate to have you create a new file for me everytime. :(

Andrew Green 10-29-2007 03:05 PM

First thing you can try is just stripping out all of the commented stuff, which will probably do it.

towermatt 10-29-2007 03:25 PM

What PHP file would that be?

Andrew Green 10-29-2007 03:27 PM

texasholdem_functions.php has been the one that's been having it's tail stuffed into the output.

carleboy 10-29-2007 03:32 PM

It seems to working lovely now :)

any chance of putting the slot games together in casino home?

Code:

Video Poker
Blackjack
Sports Betting Pool
Lottery
Fruit Slots
Texas Hold
Let it Ride
Ninja Slots

Would be much better as

Code:

Video Poker
Blackjack
Sports Betting Pool
Lottery 
Texas Hold
Let it Ride
Fruit Slots
Ninja Slots
7's Slots would also be nice in there.

Code:

Video Poker
Blackjack
Sports Betting Pool
Lottery 
Texas Hold
Let it Ride
Slots

And the slots in a new page

       
Code:

       
Fruit Slots
Ninja Slots
7's Slots





Or even better if you could give us a selection in admin settings to change the order our selfs.

also the texas holdem still needs somthing to give us control over when it starts or a bleep etc as a game ends so that everyone knows to press ready so they dont get left out.

cheers andy keep it up m8.

evesve 10-29-2007 03:47 PM

Quote:

Originally Posted by carleboy (Post 1371205)
Or even better if you could give us a selection in admin settings to change the order our selfs.

:up:

towermatt 10-29-2007 03:53 PM

Quote:

Originally Posted by Andrew Green (Post 1371201)
texasholdem_functions.php has been the one that's been having it's tail stuffed into the output.

Thanks, I will have a look.

peterpigman 10-29-2007 05:02 PM

Quote:

Originally Posted by Andrew Green (Post 1371111)
Go into phpmadmin, click on the casino_settings' table. It will show you the structure in a little table. Third from the right is a button that says "Index" (image attached)

Thanks, that fixed it. Server support gave me this

Quote:

We would like to refer you to MySQL's manual which describes how to create an INDEX. http://dev.mysql.com/doc/refman/5.0/...ate-index.html
So i was thinking I had to write something out. Ty. :up:

towermatt 10-29-2007 05:20 PM

Quote:

Originally Posted by Andrew Green (Post 1371201)
texasholdem_functions.php has been the one that's been having it's tail stuffed into the output.

Well now I am feeling a little stupid.

So I download the upgrade, pop open the file referenced above and "strip out all the commented stuff"

I assume this means getting rid of things it doesn't need but how can I tell what is commented?

Andrew Green 10-29-2007 05:24 PM

Any line that starts with "//" ;)

towermatt 10-29-2007 05:38 PM

Ah--that is what I thought.

I will do this at home tonight with a drink I think.

Ski-Whiz 10-29-2007 05:44 PM

So when do you get your own forum here on vb.org?? :D


All times are GMT. The time now is 05:51 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.04391 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
  • (6)bbcode_code_printable
  • (15)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