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)

Hornstar 12-02-2007 11:49 AM

Quote:

Originally Posted by Andrew Green (Post 1393284)
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.

I am not sure if I am completely confident messing around in phpmyadmin unless it is a very last resort. I may just wait for the update or disable the casino until the update if the database errors keep flooding in too much more, however is this next update looking like it may come out this week end, or later (So I can gauge what my best solution is :) ).

Thanks.

tropicon 12-02-2007 12:42 PM

We installed it, works great!

xadoa 12-02-2007 04:54 PM

Hi Andrew,

after i updated the .72 .. and i fixed the index switch1 thing and the stats worked great.. but i encountered another problem.. on my cronjob it didn't run, after i test run manually.. this is what i got:

Fatal error: Call to a member function on a non-object in /data/sv/sextalk/includes/cron/casino_lotto.php on line 127

Thanks

skcyber 12-02-2007 05:24 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.

the solution ;)

peterpigman 12-02-2007 10:23 PM

Quote:

Originally Posted by hornstar1337 (Post 1393461)
I am not sure if I am completely confident messing around in phpmyadmin unless it is a very last resort. I may just wait for the update or disable the casino until the update if the database errors keep flooding in too much more, however is this next update looking like it may come out this week end, or later (So I can gauge what my best solution is :) ).

Thanks.

It is unbelievably easy to do. Don't be put off by the sound of it. it takes 10 seconds.

powerful_rogue 12-02-2007 10:53 PM

Andy,

Just had a member of my forum ask the below:

Quote:

well i've dabbled many times in the casino, on all the games (other than the multiplayer one, as there nvr anyone there when i there!) but i've yet to finish in profit!!

what are the %age win margins set to? can they be changed? as it only fun and not serious.... could they be upped a little, might tempt more ppl to play the casino games??
Is there anyway of altering the odds?

Andrew Green 12-02-2007 11:32 PM

Quote:

Originally Posted by powerful_rogue (Post 1393764)
Andy,

Just had a member of my forum ask the below:



Is there anyway of altering the odds?

Nope, they are all near 100% though.

Without rigging the games that isn't going to change. Blackjack, Roulette & Let 'em Ride are all fixed, Video Poker is bumped up slightly from standard odds, I suppose that and slots "could" be altered, but that would unbalance things.

Andrew Green 12-02-2007 11:34 PM

Quote:

Originally Posted by hornstar1337 (Post 1393461)
I am not sure if I am completely confident messing around in phpmyadmin unless it is a very last resort. I may just wait for the update or disable the casino until the update if the database errors keep flooding in too much more, however is this next update looking like it may come out this week end, or later (So I can gauge what my best solution is :) ).

Thanks.


It's simple, and has no risk too it. Just click on the table name (casino_settings) and you will be shown the structure, there are also a bunch of little buttons beside each field, click the one that says "index" when you hover over it. That's it.

Hornstar 12-03-2007 06:40 AM

so click index for 'settingid' and 'settingname' and 'switch1' and switch2'?

I see this: "PRIMARY and INDEX keys should not both be set for column `settingid`"

Andrew Green 12-03-2007 12:49 PM

Quote:

Originally Posted by hornstar1337 (Post 1393901)
so click index for 'settingid' and 'settingname' and 'switch1' and switch2'?

I see this: "PRIMARY and INDEX keys should not both be set for column `settingid`"

Just switch1

ezurick 12-03-2007 02:04 PM

Quote:

Originally Posted by Andrew Green (Post 1394011)
Just switch1


Andrew, I got your latest installed.... but a couple of my users are reporting this error:

HTML Code:

Warning: max(): Array must contain atleast one element in /casino/letemride_deal.php on line 300

Warning: min(): Array must contain atleast one element in /casino/letemride_deal.php on line 300

Warning: max(): Array must contain atleast one element in /casino/letemride_deal.php on line 301

I asked them what they done to cause this, they said they done nothing out of the ordinary. I went into Let 'em Ride and played for a few minutes and couldn't reproduce the error... perhaps it something triggering based on the Array not setup properly?

Also, any luck in having the betting limits in the settings instead of messing with the .php files. As you know, that isn't working for me. Also, we need control to turn off the donation please...

Andrew Green 12-03-2007 02:07 PM

What betting limits?

csavern 12-03-2007 02:13 PM

Andrew any idea on how to fix this

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

ezurick 12-03-2007 02:22 PM

Quote:

Originally Posted by Andrew Green (Post 1394049)
What betting limits?

Andrew... if this question is for me on the array issue, I am not sure what you mean. I have all my games in the casino set up for betting from 1 to 1000. The normal setup that came with the initial download of the casino... then I added 50, 100, 500 and 1000. Is this what you mean?

Andrew Green 12-03-2007 03:14 PM

Quote:

Originally Posted by ezurick (Post 1394062)
Andrew... if this question is for me on the array issue, I am not sure what you mean. I have all my games in the casino set up for betting from 1 to 1000. The normal setup that came with the initial download of the casino... then I added 50, 100, 500 and 1000. Is this what you mean?

It was for this:
Quote:

Also, any luck in having the betting limits in the settings instead of messing with the .php files. As you know, that isn't working for me. Also, we need control to turn off the donation please...

RollaJedi 12-03-2007 05:22 PM

can you let me in on what other games you may be working on for the casino? My members absolutely love it. I run a star wars board and renamed the casino to 'Jabba's Palace Casino' (like Caesars Palace casino) :D

Andrew Green 12-03-2007 05:30 PM

Taking a bit of a break from adding new games to refine the existing things. Admincp is getting a major overhaul, as well as how things get stored. The table games should be allowing betting more then one chip, with table limits. Cash system needs a few additions. Lottery system needs to be expanded to allow raffles as well as number draws. Phrasing needs to get finished. And a bunch of other tidying up pieces.

ezurick 12-03-2007 05:31 PM

Quote:

Originally Posted by Andrew Green (Post 1394087)
It was for this:

Andrew, I am so sorry. Disregard this betting limitation thing. I confused this program for another one.... It's monday and I can't wake up... lol.

But is there anything for the array issue -or- the transfer to another player thing. I want to limit what members can transfer or donate.... or turn it off.

Andrew Green 12-03-2007 06:09 PM

Quote:

Originally Posted by ezurick (Post 1394172)
But is there anything for the array issue

Until I have some time to try and figure out what is causing that, no idea :)

Quote:

-or- the transfer to another player thing. I want to limit what members can transfer or donate.... or turn it off.
Turn it off is easy, delete the donate.php file and remove the link to it from the template ;)

RollaJedi 12-03-2007 06:37 PM

i'm not sure if others are posting about this yet or not, but the ball in the roulette is going all wonky on me. It rolls around a circle, but not on the spinning wheel. I just updated to the new version and it started doing this.

Booth 12-03-2007 06:49 PM

My users are reporting issues with Texas Hold'em and Internet Explorer. It doesn't seem to be detecting that they have java installed. Is this a known bug or just a problem with my installation?

Andrew Green 12-03-2007 06:49 PM

link to site?

Hornstar 12-03-2007 07:48 PM

Quote:

Originally Posted by Andrew Green (Post 1394011)
Just switch1

I had already clicked it for settingid, is there anyway to un index it now?

Andrew Green 12-03-2007 08:07 PM

Quote:

Originally Posted by hornstar1337 (Post 1394258)
I had already clicked it for settingid, is there anyway to un index it now?

Click the button again :)

dodgeboard.com 12-03-2007 10:46 PM

Quote:

Originally Posted by Booth (Post 1394214)
My users are reporting issues with Texas Hold'em and Internet Explorer. It doesn't seem to be detecting that they have java installed. Is this a known bug or just a problem with my installation?

Quote:

Originally Posted by Andrew Green (Post 1394216)
link to site?

http://www.blackburn247.com/forums/casino.php

I just tested it and it worked fine for me. Perhaps they do not have javascript enabled..?

I have seen issues where it may stay at the page stating that you need java enabled...but it is very rare and if I refresh it it goes right into the game.

ss-community 12-03-2007 11:01 PM

does anyone no how to wipe the scores that are in the unluckest People etc

dodgeboard.com 12-03-2007 11:33 PM

There is no built in feature to do it that I know of. You could do it using an SQL query, but it would be tricky to just single out the unluckiest people. Even then, I would think the next (unluckiest) in line would populate to being the unluckiest people.

Are you wanting to just eliminate the unluckest people stats? Or wipe all the stats?

You could wipe all the stats by uninstalling and reinstalling (the product.xml). Drop any tables (casino_*) that are left behind (if any) before reinstalling. Shouldn't have to do anything with the files. Choose overwrite when you reinstall the product.

If you want to clear the casino cash, that is a column in the user table.

Andrew Green 12-04-2007 03:54 AM

Quote:

Originally Posted by ss-community (Post 1394346)
does anyone no how to wipe the scores that are in the unluckest People etc

All the stats are drawn from the same numbers, if you want to reset delete all the entries in the casino_bet_stats table.

thuffner 12-04-2007 02:08 PM

My lottery still shows No Current Drawings Active or whatever, even after the fix you gave.

Any ideas???

Andrew Green 12-04-2007 02:42 PM

Quote:

Originally Posted by thuffner (Post 1394724)
My lottery still shows No Current Drawings Active or whatever, even after the fix you gave.

Any ideas???

did you run the cron job after doing it?

RollaJedi 12-04-2007 03:21 PM

Quote:

Originally Posted by RollaJedi (Post 1394206)
i'm not sure if others are posting about this yet or not, but the ball in the roulette is going all wonky on me. It rolls around a circle, but not on the spinning wheel. I just updated to the new version and it started doing this.

Not sure if anyone saw this or not. bump

Andrew Green 12-04-2007 03:58 PM

Quote:

Originally Posted by RollaJedi (Post 1394789)
Not sure if anyone saw this or not. bump

Try uploading the roulette files and reverting the roulette templates if they are different then the packaged ones. If that doesn't do it I'll need a link to the site.

daydie 12-04-2007 04:12 PM

Code:

Warning: Unknown(./includes/functions_forumlist.php): failed to open stream: No such file or directory in /includes/functions.php(5166) : eval()'d code on line 7

Fatal error: (null)(): Failed opening required './includes/functions_forumlist.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/daydie/public_html/includes/functions.php(5166) : eval()'d code on line 7


Why this happen? How to fix? I have tryed re-installing and replacing old files.

Andrew Green 12-04-2007 04:46 PM

Quote:

Originally Posted by daydie (Post 1394838)
Code:

Warning: Unknown(./includes/functions_forumlist.php): failed to open stream: No such file or directory in /includes/functions.php(5166) : eval()'d code on line 7

Fatal error: (null)(): Failed opening required './includes/functions_forumlist.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/daydie/public_html/includes/functions.php(5166) : eval()'d code on line 7


Why this happen? How to fix? I have tryed re-installing and replacing old files.

Do you have mkportal or some other addition that modifies your existing files?

daydie 12-04-2007 05:03 PM

vbSEO

Andrew Green 12-04-2007 05:19 PM

Quote:

Originally Posted by daydie (Post 1394882)
vbSEO


Might be it, did it have you change global.php or functions.php?

If that's it, depending on what it's doing, it could probably be made to work with this or turned off on casino pages.

daydie 12-04-2007 05:58 PM

ahh that reminds me, i changed the main URL from forum.daydie.co.uk to daydie.co.uk,

how do i make it work?

Andrew Green 12-04-2007 06:04 PM

shouldn't make a difference? as long as the casino.php file and casino folder are in the same place as your forum.

daydie 12-04-2007 06:36 PM

:( i need help with this, and i duno what the prob is

thuffner 12-04-2007 06:56 PM

Quote:

Originally Posted by Andrew Green (Post 1394747)
did you run the cron job after doing it?

How do I run the cron job?

Thanks so much! :)


All times are GMT. The time now is 03:48 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.04060 seconds
  • Memory Usage 1,845KB
  • 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
  • (1)bbcode_html_printable
  • (25)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