PDA

View Full Version : Major Additions - Casino (w/ 10 player poker)


Pages : 1 2 3 4 5 6 7 8 [9] 10 11 12 13 14 15

Andrew Green
11-28-2007, 07:53 PM
I am using IE 6 and it is working fine (.72).

--------------------------------------------------------
I need a way to change the $ (dollar sign) on the Lottery.
I have visitors thinking that it is REAL dollars... lol. I
tried searching through the casino.php but I can not
find what is posting this. I really want to delete it, cause
I use vbcredits on my forum and $ don't equal credits.

Any help?

The phrase casino_currency_maker is what you are looking for. Also the change you made to the postbit said "$$cash", change the first "$" there

peterpigman
11-28-2007, 08:54 PM
I think the lottery has stopped working in .72, it is active in cpanel but it is saying "No Draw Active at this time, please check back later"
Tried to run it and it said





Any Ideas on this? I have reinstalled and stuff still not working.

dodgeboard.com
11-28-2007, 09:12 PM
Yes Peter,

Mine is doing the same thing. I originally thought mine was working as the draw was activated by the previous version. I then installed .72 and after the drawing (9 pm) there are no upcoming draws. Tried to run the scheduled task in admincp, just like you did and got the same error you got.

Casino Lottery Draw

Fatal error: Call to a member function on a non-object in /home/*****/public_html/forums/includes/cron/casino_lotto.php on line 127

There are no numbers being drawn in the lottery and the lottery is on. Tried reapplying settings but that did not work.

In Lottery, it just says:

No Draw Active at this time, please check back later

Sunray2
11-28-2007, 09:23 PM
That's strange, the file that counts on this is slots_ajax.php, if nothing in it has changed then that's likely not it. WOuld you be able to send me a link to your site?

Okay, but it is going to take me a few minutes. I will pm you with a login.

Thanks,

C.

Andrew Green
11-28-2007, 09:37 PM
Any Ideas on this? I have reinstalled and stuff still not working.

Yes, problem is here:


Line 127 / 128 are now:

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

They should be:


$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.

peterpigman
11-28-2007, 09:42 PM
Yes, problem is here:


Line 127 / 128 are now:

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

They should be:


$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.

Yeah that fixed it ty, I had to run one through scheduled tasks first but it then worked. :up:

dodgeboard.com
11-28-2007, 09:43 PM
Yes, problem is here:


Line 127 / 128 are now:

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

They should be:


$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.


Yep! That fixed it. Lottery is now working.

Thanks AGAIN Andrew!!

Wild Bronco
11-29-2007, 12:19 AM
Some translation is needed in casino.php?do=stats ;)

Wolf Link
11-29-2007, 12:24 AM
Do you know if this works with VBCredits?

Andrew Green
11-29-2007, 02:09 AM
Some translation is needed in casino.php?do=stats ;)

Phrasing is not finished, getting there, but still got a fair bit to go

Andrew Green
11-29-2007, 02:10 AM
Do you know if this works with VBCredits?


It does, works with just about any points / cahs system. You just change the field in the admincp and turn off anything that overlaps. (ex. Posting bonuses)

mikeylikesitz
11-29-2007, 02:57 AM
can the games amounts be changed on how much can be bet and won?

c4smok
11-29-2007, 04:22 AM
hmm is there a good shop I can intergrate with this?

shaynehammy
11-29-2007, 06:15 AM
I got this error?

Database error in vBulletin 3.6.4:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Error on rename of './shayneh_vbupgrade/user' to './shayneh_vbupgrade/#sql2-6ca-110a566' (errno: 145)
Error Number : 1025
Date : Thursday, November 29th 2007 @ 02:13:29 AM
Script : http://www.thechiefbaboon.com/Forums/admincp/plugin.php?do=productimport
Referrer : http://www.thechiefbaboon.com/Forums/admincp/plugin.php?do=productadd
Classname : vb_database

Mine isnt the Duplicate name problem but appears to be different???


EDIT -OH NO!!! I cant get into my forums anymore as i have a database error!! HELP!!
EDIT 2 - Phew. when i tried to install this mod, it somehow locked the USER table on my SQL server or something to that effect. forum is up but not trying to install that again until someone tells me why it fialed the first time.

ragtek
11-29-2007, 06:28 AM
it would be better/nicer if you change Casino: WOL displayif (($userinfo['activity'] == 'casino') || ($userinfo['activity'] == 'blackjack') ||($userinfo['activity'] == 'videopoker')|| ($userinfo['activity'] == 'letemride')|| ($userinfo['activity'] == 'sportspool') || ($userinfo['activity'] == 'lottery')|| ($userinfo['activity'] == 'slots')|| ($userinfo['activity'] == 'texasholdem')|| ($userinfo['activity'] == 'stats')|| ($userinfo['activity'] == 'roulette'))
{
$userinfo['where'] = "<a href=\"casino.php\">Casino</a>";
if ($userinfo['activity'] == 'casino')
$userinfo['action'] = "In Casino";
else if ($userinfo['activity'] == 'blackjack')
$userinfo['action'] = "Playing Blackjack";
else if ($userinfo['activity'] == 'roulette')
$userinfo['action'] = "Playing Roulette";
else if ($userinfo['activity'] == 'videopoker')
$userinfo['action'] = "Playing Video Poker";
else if ($userinfo['activity'] == 'lottery')
$userinfo['action'] = "Playing the Lottery";
else if ($userinfo['activity'] == 'sportspool')
$userinfo['action'] = "Placing bets";
else if ($userinfo['activity'] == 'slots')
$userinfo['action'] = "Playing Slots";
else if ($userinfo['activity'] == 'stats')
$userinfo['action'] = "Viewing Casino statistics";
else if ($userinfo['activity'] == 'letemride')
$userinfo['action'] = "Playing Let em Ride";
else if ($userinfo['activity'] == 'texasholdem')
$userinfo['action'] = "Playing Texas Hold em";
$handled = true;
} into a swich case part

buurman
11-29-2007, 07:02 AM
it would be better/nicer if you change Casino: WOL displayif (($userinfo['activity'] == 'casino') || ($userinfo['activity'] == 'blackjack') ||($userinfo['activity'] == 'videopoker')|| ($userinfo['activity'] == 'letemride')|| ($userinfo['activity'] == 'sportspool') || ($userinfo['activity'] == 'lottery')|| ($userinfo['activity'] == 'slots')|| ($userinfo['activity'] == 'texasholdem')|| ($userinfo['activity'] == 'stats')|| ($userinfo['activity'] == 'roulette'))
{
$userinfo['where'] = "<a href=\"casino.php\">Casino</a>";
if ($userinfo['activity'] == 'casino')
$userinfo['action'] = "In Casino";
else if ($userinfo['activity'] == 'blackjack')
$userinfo['action'] = "Playing Blackjack";
else if ($userinfo['activity'] == 'roulette')
$userinfo['action'] = "Playing Roulette";
else if ($userinfo['activity'] == 'videopoker')
$userinfo['action'] = "Playing Video Poker";
else if ($userinfo['activity'] == 'lottery')
$userinfo['action'] = "Playing the Lottery";
else if ($userinfo['activity'] == 'sportspool')
$userinfo['action'] = "Placing bets";
else if ($userinfo['activity'] == 'slots')
$userinfo['action'] = "Playing Slots";
else if ($userinfo['activity'] == 'stats')
$userinfo['action'] = "Viewing Casino statistics";
else if ($userinfo['activity'] == 'letemride')
$userinfo['action'] = "Playing Let em Ride";
else if ($userinfo['activity'] == 'texasholdem')
$userinfo['action'] = "Playing Texas Hold em";
$handled = true;
} into a swich case part

And this does exactly? or where to change this, always in for something new to try :)

GrandHolyKing
11-29-2007, 08:33 AM
I got this error?

Database error in vBulletin 3.6.4:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Error on rename of './shayneh_vbupgrade/user' to './shayneh_vbupgrade/#sql2-6ca-110a566' (errno: 145)
Error Number : 1025
Date : Thursday, November 29th 2007 @ 02:13:29 AM
Script : http://www.thechiefbaboon.com/Forums/admincp/plugin.php?do=productimport
Referrer : http://www.thechiefbaboon.com/Forums/admincp/plugin.php?do=productadd
Classname : vb_database

Mine isnt the Duplicate name problem but appears to be different???


EDIT -OH NO!!! I cant get into my forums anymore as i have a database error!! HELP!!
EDIT 2 - Phew. when i tried to install this mod, it somehow locked the USER table on my SQL server or something to that effect. forum is up but not trying to install that again until someone tells me why it fialed the first time. I also get this error, here is what mine says

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Thursday, November 29th 2007 @ 11:27:57 AM
Script : http://forum.multiformat-gamer.co.uk/admincp/plugin.php?do=productimport
Referrer : http://forum.multiformat-gamer.co.uk/admincp/plugin.php?do=productadd
IP Address :xx.xx.xx.xxxx

ezurick
11-29-2007, 09:55 AM
The phrase casino_currency_maker is what you are looking for. Also the change you made to the postbit said "$$cash", change the first "$" there

Ummm... can you explain what or how to change the Phrase please. I see the casino_currency_marker <-- note marker, not maker in my forum, is a $, but I see no way to edit this...

And the postbit change? Not sure what to do there either... Sorry, but me is dumb when it comes to php stuff. I know 'C' and you would think I would pick up on php... but things just ain't the same.

please help???

dodgeboard.com
11-29-2007, 11:28 AM
I also get this error, here is what mine says

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Thursday, November 29th 2007 @ 11:27:57 AM
Script : http://forum.multiformat-gamer.co.uk/admincp/plugin.php?do=productimport
Referrer : http://forum.multiformat-gamer.co.uk/admincp/plugin.php?do=productadd
IP Address :xx.xx.xx.xxxx

No, THis is a totally different error and a known one at that. See this thread for the fix:

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

Drop the column, reinstall- you should be fine.

dodgeboard.com
11-29-2007, 11:49 AM
Ummm... can you explain what or how to change the Phrase please. I see the casino_currency_marker <-- note marker, not maker in my forum, is a $, but I see no way to edit this...

And the postbit change? Not sure what to do there either... Sorry, but me is dumb when it comes to php stuff. I know 'C' and you would think I would pick up on php... but things just ain't the same.

please help???

This is a reoccuring subject on the thread.

Try searching this thread for "vbcredits". There are 54 posts that discuss it and several that explain how to implement vbcredits into the casino.

Also see:
http://www.vbgaming.org/forum/showthread.php?t=72


To get rid of the casino cash displayed in the posts:
To edit your postbit template, go into the styles & templates for the default style, find the posting templates and find postbit, open it, find the following and delete it:

<br />Casino Cash: $$post[casino_cash]

dodgeboard.com
11-29-2007, 12:07 PM
can the games amounts be changed on how much can be bet and won?

You can turn the chip denominations on/off in the casino settings in the admincp to control this.

ezurick
11-29-2007, 12:55 PM
This is a reoccuring subject on the thread.

Try searching this thread for "vbcredits". There are 54 posts that discuss it and several that explain how to implement vbcredits into the casino.

Also see:
http://www.vbgaming.org/forum/showthread.php?t=72

I am afraid I don't easily see my answers by weeding through 54 posts related to such a broad category or subject. This may be simple for you, but for some of us, we need a bit more detail on help. If you rather not help, please refrain from your comments and allow someone else to answer my questions.

To get rid of the casino cash displayed in the posts:
To edit your postbit template, go into the styles & templates for the default style, find the posting templates and find postbit, open it, find the following and delete it:

Again, this isn't very clear. I go into edit templates and I see "postbit", but there is nothing about casino in that template. What is the default style you refer to? I am not sure which template or file to edit -- or where to find that phase...

Andrew Green
11-29-2007, 01:18 PM
Ummm... can you explain what or how to change the Phrase please. I see the casino_currency_marker <-- note marker, not maker in my forum, is a $, but I see no way to edit this...



Admincp -> languages and Phrases -> Phrase manager

Phrase type is "casino" and name is "casino_currency_marker". Change it from "$" to whatever you want.


And the postbit change? Not sure what to do there either... Sorry, but me is dumb when it comes to php stuff. I know 'C' and you would think I would pick up on php... but things just ain't the same.

please help???

Part of the installation instructions involved adding a line to the postbit template. It had "$$cash" in it, the first "$" is what shows up, the second is part of the variable name. Change the first one. (If you didn't make that template change, this isn't necessary)

dodgeboard.com
11-29-2007, 01:30 PM
I am afraid I don't easily see my answers by weeding through 54 posts related to such a broad category or subject. This may be simple for you, but for some of us, we need a bit more detail on help. If you rather not help, please refrain from your comments and allow someone else to answer my questions....

I thought I was helping.... What "comments" did I say that offended you?..by telling you the answer you seek lies within this thread?

I am the only one that answered you...I was trying to help you. If you refuse to read a little, then maybe you should familiarize yourself with the search tool.


Again, this isn't very clear. I go into edit templates and I see "postbit", but there is nothing about casino in that template. What is the default style you refer to? I am not sure which template or file to edit -- or where to find that phase...

You are trying to delete the cash shown in the posts right?
You shouldn't even have it if you didint insert it to begin with.

rwilkins108
11-29-2007, 01:33 PM
not to get into anything here, but it surprises me how few people who run vB don't know that you can just Search this Thread... Instead, just say I'm not going to weed through x number of pages...

ezurick
11-29-2007, 01:36 PM
Admincp -> languages and Phrases -> Phrase manager

Phrase type is "casino" and name is "casino_currency_marker". Change it from "$" to whatever you want.

Hi Andrew. I am sorry to be a pain, but I follow this instruction and get the casino_currency_marker on my screen... but I see no way to change anything. My only edit option is the English translation at the bottom. Am I missing something?

Part of the installation instructions involved adding a line to the postbit template. It had "$$cash" in it, the first "$" is what shows up, the second is part of the variable name. Change the first one. (If you didn't make that template change, this isn't necessary)

Apparently I didn't do this cause I am using vbcredits... and the way I understood the write-up is that it was not necessary if I was using another cash system. So I skipped it. Perhaps I am confused about this, is it needed or necessary if I am using vbcredits?

Again, sorry to be a pain... just trying to get this right...

ezurick
11-29-2007, 01:41 PM
not to get into anything here, but it surprises me how few people who run vB don't know that you can just Search this Thread... Instead, just say I'm not going to weed through x number of pages...

Apparently I didn't find the answers I was looking for... so I needed more details... I know how to use the search. I am glad you can find all your answers by searching this thread... You are simply amazing! :cool:

Andrew Green
11-29-2007, 01:45 PM
Hi Andrew. I am sorry to be a pain, but I follow this instruction and get the casino_currency_marker on my screen... but I see no way to change anything. My only edit option is the English translation at the bottom. Am I missing something?



That's the spot, plop it in under English and save it.


Apparently I didn't do this cause I am using vbcredits... and the way I understood the write-up is that it was not necessary if I was using another cash system. So I skipped it. Perhaps I am confused about this, is it needed or necessary if I am using vbcredits?

Again, sorry to be a pain... just trying to get this right...



All it does is put the amount in the post bit, if you are using another cash system that does that already, it's not needed, or if you just don't want it there.

ezurick
11-29-2007, 01:48 PM
That's the spot, plop it in under English and save it.

All it does is put the amount in the post bit, if you are using another cash system that does that already, it's not needed, or if you just don't want it there.

Thank you so much... and again, I am sorry to bother so many people.... I'll be sure to refrain from future questions on this thread!

Andrew Green
11-29-2007, 01:57 PM
Thank you so much... and again, I am sorry to bother so many people.... I'll be sure to refrain from future questions on this thread!


Better to ask then to not ask

Bounce
11-29-2007, 02:22 PM
When I try and change the $ into £ (as i'm uk) in the $vbphrase[casino_currency_marker] all it does is convert it to a ?

I'll update the version to see iif that helps

Bounce
11-29-2007, 02:40 PM
In /casino.php?do=texasholdem it shows ? when everywhere else it shows £ now that ive upgraded to .72

Andrew Green
11-29-2007, 02:41 PM
Try with the html entity:
& # 1 6 3;
(without all the spaces)

Bounce
11-29-2007, 02:45 PM
Try with the html entity:
& # 1 6 3;
(without all the spaces)

Brilliant !!!

Thanks andrew that done the trick :up:

conker1
11-29-2007, 05:12 PM
Users can buy same tickets in lottery can you fix that.

Thanks.

Andrew Green
11-29-2007, 05:30 PM
Users can buy same tickets in lottery can you fix that.

Thanks.

You can do that in real life too ;)

NFLfbJunkie
11-29-2007, 05:35 PM
Hi Andrew. I jope you don't mind me re-posting a question I had a few pages back. But
how can I change the width of each of the statistics tables, making them each the same width, so that there is no empty space to the left and right of the tables? I have played around with the statistics_main template but have had no luck.

Andrew Green
11-29-2007, 05:47 PM
Hi Andrew. I jope you don't mind me re-posting a question I had a few pages back. But
how can I change the width of each of the statistics tables, making them each the same width, so that there is no empty space to the left and right of the tables? I have played around with the statistics_main template but have had no luck.


Not at all, thread is over 2000 posts, I miss things :D


casino_stats_2col

&

casino_stats_4col


add a " style='width:100%' " into the first line (table tag) and I think you'll be set.

NFLfbJunkie
11-29-2007, 05:53 PM
Sorry for my not knowing, but exactly where would this go in the two templates?

rwilkins108
11-29-2007, 05:53 PM
Apparently I didn't find the answers I was looking for... so I needed more details... I know how to use the search. I am glad you can find all your answers by searching this thread... You are simply amazing! :cool:

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!

conker1
11-29-2007, 05:53 PM
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
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
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
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 ...
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
the lottery doesn't work with .72 ...

the cron doesn't work ...
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 (https://vborg.vbsupport.ru/showpost.php?p=1391311&postcount=2005)

:)

skcyber
11-30-2007, 11:52 AM
thk you !!! :D

It's works fine now ! ;)

thuffner
11-30-2007, 12:25 PM
Yes, problem is here:


Line 127 / 128 are now:

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

They should be:


$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
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:


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
I just upgraded to the latest version and when I go to view the stats I get this database error:


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
I just upgraded to the latest version and when I go to view the stats I get this database error:


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


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
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
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
****: 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
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!

Hornstar
12-02-2007, 11:49 AM
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
Yes, problem is here:


Line 127 / 128 are now:

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

They should be:


$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
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:

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
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
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
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
Just switch1


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


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
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
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:

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
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
But is there anything for the array issue


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


-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
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
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
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?

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
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
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
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
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
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
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
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
did you run the cron job after doing it?
How do I run the cron job?

Thanks so much! :)

Andrew Green
12-04-2007, 07:10 PM
:( i need help with this, and i duno what the prob is


I'll have a look at your site when I get a chance, might be tonight but it depends on what time I get home...

How do I run the cron job?

Thanks so much! :)

Admincp -> Scheduled tasks.

It will run itself if you leave it, but until it runs nothing happens.

Erika
12-04-2007, 08:42 PM
My lottery stopped working? Any ideas...

dodgeboard.com
12-04-2007, 10:13 PM
Erika,

Try running your lottery draws manually:


Login to Admincp
Go to Scheduled tasks, Scheduled task Manager
Find Casino Lottery Draw, click run now.


Check to see if your lottery is working now.

If it is still not working, or you get this error (or something like it) when running the task:

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

Then you need to apply the fix.

Open the casino_lotto.php file (with Wordpad) that you uploaded (or still have on your PC) and make this change:

Find this

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

and change to this:

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

After correcting the file, UPLOAD THE NEWLY CORRECTED FILE back to the Forums directory (overwriting the old one).

Then go back into the admincp and rerun the Casino Lottery Draw Scheduled task (steps 1-3 above).

That should fix it.

Andrew said he is going to fix it in the next release. Holler if you need help.

EDIT: added modified casino_lotto.php file

Hornstar
12-05-2007, 12:05 AM
Click the button again :)

I now have these 2 errors on the page:

More than one INDEX key was created for column `settingid`

PRIMARY and INDEX keys should not both be set for column `settingid`

Told you it would have been best for me to leave phpmyadmin alone lol

I think I am making things worse, any idea how to fix the problem?

SVTCobraLTD
12-05-2007, 12:22 AM
Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(296) : eval()'d code on line 156

How do I get rid of this in the announcement?

SVT

Robert Paulson
12-05-2007, 12:24 AM
Can someone post a link to a Forum that is using the Casino.

I installed it last night, and I'm seeing the cash in different users account, but can't figure out how to open the actual games. :confused:

Yes, I'm new.

thuffner
12-05-2007, 01:15 AM
Erika,

Try running your lottery draws manually:


Login to Admincp
Go to Scheduled tasks, Scheduled task Manager
Find Casino Lottery Draw, click run now.


Check to see if your lottery is working now.

If it is still not working, or you get this error (or something like it) when running the task:



Then you need to apply the fix.

Open the casino.php file (with Wordpad) that you uploaded (or still have on your PC) and make this change:

Find this (almost half way down):

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

and change to this:

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

After correcting the file, UPLOAD THE NEWLY CORRECTED FILE back to the Forums directory (overwriting the old one).

Then go back into the admincp and rerun the Casino Lottery Draw Scheduled task (steps 1-3 above).

That should fix it.

Andrew said he is going to fix it in the next release. Holler if you need help.

Still didn't work. When will the files be updated with the new code?

I try to run the cron and I get a blank screen:


Casino Lottery Draw


...and nothing.

Twilkey
12-05-2007, 01:25 AM
Can someone post a link to a Forum that is using the Casino.

I installed it last night, and I'm seeing the cash in different users account, but can't figure out how to open the actual games. :confused:

Yes, I'm new.

http://your_site_url/casino.php


There is instructions in the readme on how to add a link to the navbar.

Robert Paulson
12-05-2007, 02:04 AM
http://your_site_url/casino.php


There is instructions in the readme on how to add a link to the navbar.

:o thanks, dude!

Andrew Green
12-05-2007, 03:34 AM
Still didn't work. When will the files be updated with the new code?




Probably this weekend.

dodgeboard.com
12-05-2007, 03:49 AM
Still didn't work. When will the files be updated with the new code?

I try to run the cron and I get a blank screen:


Casino Lottery Draw


...and nothing.

Oh shoot.... I made a mistake in my directions. The first time I mentioned the file casino_lotto.php, the second time I left out the "_lotto" MY BAD!! The file you have to edit is casino_lotto.php

I've attatched the corrected files:

casino.php (original)
casino_lotto.php (modified)

Upload these to your forums directory and overwrite the old ones.

Erika
12-05-2007, 08:33 AM
Erika,

Try running your lottery draws manually:

I applied the fix - thanks SO MUCH for your help :)

thuffner
12-05-2007, 11:20 AM
Oh shoot.... I made a mistake in my directions. The first time I mentioned the file casino_lotto.php, the second time I left out the "_lotto" MY BAD!! The file you have to edit is casino_lotto.php

I've attatched the corrected files:

casino.php (original)
casino_lotto.php (modified)

Upload these to your forums directory and overwrite the old ones.
Thanks! Works fine now after running the cron!!!

Mecho
12-05-2007, 04:17 PM
is there anyway to play with a Real cash ??

dodgeboard.com
12-05-2007, 04:52 PM
Not unless you are in a state that allows gambling, a licensed gambling outfit, and have all the permits.

Also remember that java scripts are client side programs...meaning that the program that spins the roulette or the slots runs on the client and then reports back the results to the server. A creative person could easily write their own script and manipulate their winnings. You would not want to use client side scripting for any "real money" situations.

This game is for fun and/or credits.

One Idea you could legally implement:

Entice your members to play and to save up their casino cash redeemable for a T-shirt or coffee mug with your website advertisement.

ss-community
12-05-2007, 09:21 PM
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.


were do i find this , i never instaled the product my brother did, also i would like to wipe them all ,

dodgeboard.com
12-05-2007, 09:40 PM
Do you know how to get to your phpMyAdmin?

If so, Login to it

Select casino_bet_stats on the left pane
Click "Browse" on top
then you'll see the data table below

each user(userid) will have an entry for each game(gameid) they have played (bet) & (won)

if you click on the pencil, you can change the value of the fields (bet) & (won)


PHPMYADMIN INFO (http://www.help.hostway.com/docs/phpmyadmin/faq/generalfaq.html#question7b)

TazeredBlackMan
12-06-2007, 12:33 AM
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.

This is happening for me too. The ball is off the mark, compared to how it was before I updated. I tried uploading all the files again and it still isn't fixing the problem. Any ideas?

Not only that, but the transparency of the image is all weird too. I can see the edges in IE. In firefox it's better.

dodgeboard.com
12-06-2007, 01:21 AM
you may want to post a link to your site....

Keyser S?ze
12-06-2007, 01:39 AM
this looks really nice, my only problem is that my navbar has too much stuff on it, and with arcade being there already, i wish i could make arcade "Gaming" and have that be a dropdown and inside be
Arcade
Casino

like that, i think that would look good, any way to do this?

Robert Paulson
12-06-2007, 02:49 AM
jeezus. This thing's like crack. My users are getting nutty.

dodgeboard.com
12-06-2007, 03:21 AM
this looks really nice, my only problem is that my navbar has too much stuff on it, and with arcade being there already, i wish i could make arcade "Gaming" and have that be a dropdown and inside be
Arcade
Casino

like that, i think that would look good, any way to do this?

Look at my navbar (http://www.dodgeboard.com/forums/). If you like the way I have setup my drop down menus, I can send you the template modifications.

Keyser S?ze
12-06-2007, 04:50 AM
yea that is what i wanted, thanks

ezurick
12-06-2007, 09:51 AM
Look at my navbar (http://www.dodgeboard.com/forums/). If you like the way I have setup my drop down menus, I can send you the template modifications.

Hey dodge... that is a nice navbar. Can you share that with me somehow too? :)

Also, I see you are still using vBadvanced 2.2.0... any reason that you didn't upgade to 3.0? I upgraded and some of my older plugins for it don't work properly anymore... such as the "recent threads". There are listed in the settings for it, but they won't show. Anywho... sure would like to see how you done your navbar... Thanks...

dodgeboard.com
12-06-2007, 12:49 PM
You must edit TWO parts of your navbar for dropdown menu's. The first part adds the text on the navbar and the second part adds the menu items to the menu.


Open your templates and go to navbar. Find this:

<td class="vbmenu_control"><a href="register.php$session[sessionurl_q]" rel="nofollow">$vbphrase[register]</a></td>
</if>

Underneath that add this:

<td id="FunStuff" class="vbmenu_control"><a href="$show[nojs_link]#FunStuff">Fun Stuff</a> <script type="text/javascript"> vbmenu_register("FunStuff"); </script></td>


Then find this near the bottom:

<!-- / user cp tools menu -->
</if>

Add below that:

<!-- your FunStuff menu -->

<div class="vbmenu_popup" id="FunStuff_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr><td class="thead">$vbphrase[name]</td></tr>

<tr><td class="vbmenu_option"><a href="casino.php?$session[sessionurl]">Casino</a></tr>

<tr><td class="vbmenu_option"><a href="arcade.php$session[sessionurl_q]">Arcade</a></td></tr>

<tr><td class="vbmenu_option"><a href="WHATEVER.php$session[sessionurl_q]">WHATEVER ELSE YOU WANT IN THE MENU</a></td></tr>

</table>
</div>
<!-- / your FunStuff menu -->

Just change anything in caps to what you want, and rename "FunStuff" to whatever you want to to use. But remember that the top code is linked to the bottom code. So if you change FunStuff in the top code, you must also chnage it in the first line in the bottom code @ ="vbmenu_popup" id="FunStuff_menu"

ss-community
12-06-2007, 01:38 PM
Do you know how to get to your phpMyAdmin?

If so, Login to it

Select casino_bet_stats on the left pane
Click "Browse" on top
then you'll see the data table below

each user(userid) will have an entry for each game(gameid) they have played (bet) & (won)

if you click on the pencil, you can change the value of the fields (bet) & (won)


PHPMYADMIN INFO (http://www.help.hostway.com/docs/phpmyadmin/faq/generalfaq.html#question7b)

when i log into my admin panel , on the left hand side of my forum i have a casion tab , i guess i click on that , (yes/No) , if i do click on it i get casino settings and nothing is in there

Andrew Green
12-06-2007, 01:48 PM
when i log into my admin panel , on the left hand side of my forum i have a casion tab , i guess i click on that , (yes/No) , if i do click on it i get casino settings and nothing is in there


The files in the admincp folder likely didn't get uploaded.

dodgeboard.com
12-06-2007, 01:52 PM
when i log into my admin panel , on the left hand side of my forum i have a casion tab , i guess i click on that , (yes/No) , if i do click on it i get casino settings and nothing is in there

To get to PHPMyadmin, usually you go through cpanel. It's not in the admincp.

Sounds like you may be missing some files.

You'll have to first select the database you have assigned to your forums, then you should see something like the attached screen shot.

TazeredBlackMan
12-06-2007, 04:15 PM
Is there any update on the roulette ball positioning?

Gooner
12-06-2007, 05:03 PM
this is awesome... more popular with my members than the arcade by miles..... please add more games +multiplayer games... thanks :D

ezurick
12-06-2007, 05:42 PM
Andrew, I got your latest installed.... but a couple of my users are reporting this error:


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...

Just to update you on this warning, one of my members that got this message said this:

"I bet between 1 - 25 and only raise if there is a payout on the screen. However I think this happened with the deal 3 cards up and 2 cards down."

Maybe this will help when you get time to look at this issue...

Shazz
12-06-2007, 06:01 PM
Having to click the button twice is getting confusing sometimes, haven't read this thread to see if 100 other people also say it though.

dodgeboard.com
12-06-2007, 09:15 PM
Having to click the button twice is getting confusing sometimes, haven't read this thread to see if 100 other people also say it though.


I've had to do it. it's a known issue. Kinda confusing, but you get used to it. I always double click now.

dodgeboard.com
12-06-2007, 09:19 PM
Is there any update on the roulette ball positioning?

I was trying to look at your problem...but your roulette is turned off

dodgeboard.com
12-06-2007, 10:09 PM
Also, we need control to turn off the donation please...

If you want to remove the link from the main page, all you have to do is drill into the template; casino_index_main and delete this:

<div style='text-align:center'><br/><a href='casino.php?do=donate'>$vbphrase[casino_donation_link]</a></div>

Course that wont stop the clever ones from accessing the feature via a direct url. Average member wont know that. Guess you could overcome that by emptying or deleting the template casino_donate.

peterpigman
12-06-2007, 10:34 PM
I was trying to look at your problem...but your roulette is turned off

It isn't lined up on mine either, just a bit off. Seems to be on the line rather than in between lines.

dodgeboard.com
12-06-2007, 11:12 PM
It isn't lined up on mine either, just a bit off. Seems to be on the line rather than in between lines.

Is there any update on the roulette ball positioning?


Okay... I figured it out. I was able to reproduce the issue by turning on ALL the chips.

You both have too many chip denominations turned ON. Turn off a couple of your chips in the admincp, casino settings, chips in use, roulette.

Then it will work.

Keyser S?ze
12-07-2007, 02:04 AM
dodge thanks for the code ill try it out tomorrow

to the author: why not put the casino options inside the vb options section as i hate to clutter up my admin cp

great hack now we just need an add on for virtual whores ;D

dodge can u make the funstuff aka games dropdown look more like the quicklinks?

cheers

dodgeboard.com
12-07-2007, 03:58 AM
It is the same - the only difference is the Quicklinks drop down is divided into sections.

Put this in the second part:

<tr><td class="thead">Section Name</td></tr>



Example:

<!-- your FunStuff menu -->

<div class="vbmenu_popup" id="FunStuff_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr><td class="thead">FIRST SECTION</td></tr>

<tr><td class="vbmenu_option"><a href="casino.php?$session[sessionurl]">Casino</a></tr>

<tr><td class="vbmenu_option"><a href="arcade.php$session[sessionurl_q]">Arcade</a></td></tr>

<tr><td class="thead">SECOND SECTION</td></tr>

<tr><td class="vbmenu_option"><a href="WHATEVER.php$session[sessionurl_q]">WHATEVER ELSE YOU WANT IN THE MENU</a></td></tr>

</table>
</div>
<!-- / your FunStuff menu -->

tropicon
12-07-2007, 10:01 AM
There is a problem with the lottery, we wanted a draw every day now error message for users No Draw Active at this time, please check back later

dodgeboard.com
12-07-2007, 11:31 AM
There is a problem with the lottery, we wanted a draw every day now error message for users No Draw Active at this time, please check back later


See this (https://vborg.vbsupport.ru/showpost.php?p=1395110&postcount=2123)

Keyser S?ze
12-07-2007, 12:56 PM
thanks dodge, worked

Andrew Green
12-07-2007, 01:02 PM
Having to click the button twice is getting confusing sometimes, haven't read this thread to see if 100 other people also say it though.

Which button was that?

1F42
12-07-2007, 02:41 PM
Installed all fine but I would like to change all the $ refs to ? ;) any pointers to where they are to be found thanks

Andrew Green
12-07-2007, 02:48 PM
The one in the postbit template you do manually, change the phrase "casino_currency_marker" for the rest.

1F42
12-07-2007, 02:51 PM
new to this but ill try and find thanks

1F42
12-07-2007, 03:06 PM
done that as a translation and works so just the postbits now thanks

$vbphrase[posts]: $post[posts]
<br />Casino Cash: $$post[casino_cash] This one :)

ChU v2
12-08-2007, 12:39 AM
Suggestions for future updates:

Don't know if you have some of this in the works or if I've missed it but here goes. I was an avid poker player in the past. This is mainly suggestions for the Texas Hold em part.

1. No Limit Poker! - Make it so users can customize bets.
2. View Previous Hands
3. More than one room available. - I assume more than 10 people will want to play at one time.
4. Options to show/hide hand if user folds - If opponent folds, the winner can select to show/hid there hand.
5. Custom 'avatars' to show above username when sitting at a table.
6. Is click the ready button before each hand necessary?
7. Beep to notify user of his/her turn if taking too long.
8. If user takes too long, set them to an idle state so they are at the table, but not in the hands, after a certain amount of time, user is kicked from the table.

Also is there a way to have like an Admin donate option for the Casino cash?

Hope I've helped.

Robert Paulson
12-08-2007, 12:51 AM
Suggestions for future updates:

Don't know if you have some of this in the works or if I've missed it but here goes. I was an avid poker player in the past. This is mainly suggestions for the Texas Hold em part.

I've had several users request the same things.

AWESOME add-on, though. Great job!

Is there a way for us to customize a few of the images, i.e. 'ninjas', 'chips', etc??

Andrew Green
12-08-2007, 03:10 AM
1. No Limit Poker! - Make it so users can customize bets.


At some point maybe.


2. View Previous Hands


Probably not, don't really see the benefit myself.


3. More than one room available. - I assume more than 10 people will want to play at one time.


Again, at some point.

4. Options to show/hide hand if user folds - If opponent folds, the winner can select to show/hid there hand.


Not sure what you mean


5. Custom 'avatars' to show above username when sitting at a table.

thought about that, but with a 10 player game, chat box and common cards, there isn't really any space to put them and keep everything on the screen at once without a high resolution monitor


6. Is click the ready button before each hand necessary?


Yep. Otherwise people that don't want dealt in, or have left the room will get dealt in.


7. Beep to notify user of his/her turn if taking too long.


Sound effects have been asked for before, might happen in the near future.


8. If user takes too long, set them to an idle state so they are at the table, but not in the hands, after a certain amount of time, user is kicked from the table.


That's the function of the ready button, keep people that are not sitting there from getting dealt in ;)

A way to boot people is needed however.


Also is there a way to have like an Admin donate option for the Casino cash?

Hope I've helped.

You can modify peoples cash manually in the admincp (user options), or increase amounts by usergroup.


I've had several users request the same things.

AWESOME add-on, though. Great job!

Is there a way for us to customize a few of the images, i.e. 'ninjas', 'chips', etc??

Sure, just replace the image files.

Robert Paulson
12-08-2007, 03:47 AM
Sure, just replace the image files.
thank you, sir!

Shazz
12-08-2007, 03:54 AM
This has probablly been asked many times too, to let people know I have done a search throughout the thread, but where exactly in the plugin would you change the 1 min time limit?

nautiqeman
12-08-2007, 10:25 PM
What would I need to edit to update the Sports Pool feature in this casino?

I'd like to continue to use my vBookie feature for this option and to link directly to it from the casino.php page.

Thanks!

xadoa
12-09-2007, 02:53 PM
worked great for me, thanks ..

xadoa

Erika,

Try running your lottery draws manually:


Login to Admincp
Go to Scheduled tasks, Scheduled task Manager
Find Casino Lottery Draw, click run now.


Check to see if your lottery is working now.

If it is still not working, or you get this error (or something like it) when running the task:



Then you need to apply the fix.

Open the casino_lotto.php file (with Wordpad) that you uploaded (or still have on your PC) and make this change:

Find this

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

and change to this:

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

After correcting the file, UPLOAD THE NEWLY CORRECTED FILE back to the Forums directory (overwriting the old one).

Then go back into the admincp and rerun the Casino Lottery Draw Scheduled task (steps 1-3 above).

That should fix it.

Andrew said he is going to fix it in the next release. Holler if you need help.

EDIT: added modified casino_lotto.php file

peterpigman
12-09-2007, 08:55 PM
Which button was that?

In texas hold em. Sometimes when you bet or check you have to click twice.

DieselMinded
12-09-2007, 09:47 PM
Andrew can you make the sports poll stay displayed untill they are settled then go away ?

meissenation
12-09-2007, 11:31 PM
I'm having a lot of problems with it kicking me and other people out of the Texas Holdem game randomly. Not sure why it happens yet. Happens with just two, 3, 4, etc.

meissenation
12-10-2007, 12:17 AM
Another thing I noticed, when I do the sports bets, if I select 14:00 it says that it closes at 1pm. Is it suppose to be 1 hour before, or is it off?

shaynehammy
12-10-2007, 04:15 AM
I've loaded the latest version and getting

Let &apos;em Ride 5 Card stud variation.

Not serious but how do i correct it?

EDIT: Got it. Was obviously having a bad look :(

Keyser S?ze
12-10-2007, 04:20 AM
i have a good idea, let ppl go in the negative to a certain amount, set by the admin, and if they are in the negative it says in post bit "casino cash: On Welfare"

:p

shaynehammy
12-10-2007, 05:11 AM
Why if i disable the games in admin do they still appear visable to all the users?

skcyber
12-10-2007, 05:58 AM
It's impossible to transfer cash to another member ... :(
In statistics, when we click on top players - Lottery we have the top players of sports betting

Lee G
12-10-2007, 09:31 AM
The latest version looks good and has solved the problem I had with the Texas hold em showing the table full when no one was in there.

But when you turn a game off, ie lottery, it still shows up in the menu for the games

Apart from that, it looks like another well put together update
Keep up the good work

ezurick
12-10-2007, 09:48 AM
The latest version looks good and has solved the problem I had with the Texas hold em showing the table full when no one was in there.

But when you turn a game off, ie lottery, it still shows up in the menu for the games

Apart from that, it looks like another well put together update
Keep up the good work

I just updated to .80 and I am not sure what the permissions do. I have a blank in every game and I tried (as the admin) to play the games, and it let me. Could you explain what that is for.

Also, in Roulette, the chip is not going on the board properly again. When I select a chip, it goes to the 2 to 1 box at the bottom and ya can't move it. We had this issue before and I can't remember what we done to correct it. Anyone else having this issue?

ezurick
12-10-2007, 10:04 AM
I just updated to .80 and I am not sure what the permissions do. I have a blank in every game and I tried (as the admin) to play the games, and it let me. Could you explain what that is for.

Also, in Roulette, the chip is not going on the board properly again. When I select a chip, it goes to the 2 to 1 box at the bottom and ya can't move it. We had this issue before and I can't remember what we done to correct it. Anyone else having this issue?

Oh heck! Nevermind. I forgot to revert. Roulette is working now. However, since I reverted, I am getting blanks on the game icons. I'll keep looking to see what the problem is, but I did manually change this from an earlier post to show icons before this version.

xxxsaint
12-10-2007, 02:01 PM
Oh heck! Nevermind. I forgot to revert. Roulette is working now. However, since I reverted, I am getting blanks on the game icons. I'll keep looking to see what the problem is, but I did manually change this from an earlier post to show icons before this version.

If you had icons from the earlier post , they're in the wrong directory now. You have to put your game icons in the " cards " folder.

stangger5
12-10-2007, 06:08 PM
Why if i disable the games in admin do they still appear visable to all the users?

Try this,,
edit the casino.php file..

Find:
$result = $db->query_read("SELECT * FROM casino_games ORDER BY gamename");
while ($row = $db->fetch_array($result))

And replace with this

$result = $db->query_read("SELECT * FROM casino_games WHERE active = 1 ORDER BY gamename");
while ($row = $db->fetch_array($result))

stangger5
12-10-2007, 06:16 PM
In statistics, when we click on top players - Lottery we have the top players of sports betting

Looks like the Lottery and Sports Betting are backwards in the data base,, casino_games table..

Setting the Sports Betting gameid to 3 and
the Lottery gameid to 4 should fix it..

Andrew Green
12-10-2007, 06:24 PM
I should have some time tomorrow, any problems that get posted I'll fix up then.

AWJunkies
12-10-2007, 07:37 PM
Nice work but for an added style thing you should center the images for the games instead of left.

ezurick
12-10-2007, 08:59 PM
If you had icons from the earlier post , they're in the wrong directory now. You have to put your game icons in the " cards " folder.

Strange... the .png are set in the settings and they are sitting in the cards folder... but they are still not showing up....

carubmun
12-10-2007, 08:59 PM
Andrew Green you rock.
That is all.

punchbowl
12-10-2007, 11:27 PM
Andrew Green you rock.
That is all.

I concur!

Andrew Green
12-11-2007, 02:00 AM
Strange... the .png are set in the settings and they are sitting in the cards folder... but they are still not showing up....

Link?

Robert Paulson
12-11-2007, 04:46 AM
This is probably a stupid question, but will I need to load the contents of the casino_0-80 folder, or just overwrite the xml file in the product manager?

SBlueman
12-11-2007, 05:30 AM
Both. Load the contents of the folders and overwrite the xml file.

RollaJedi
12-11-2007, 03:28 PM
help!!!!

i updated to the newest version and it gave me this when i installed the xml:

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Tuesday, December 11th 2007 @ 10:21:38 AM
Script : http://www.coreplanets.com/forums/*****
Referrer : http://www.coreplanets.com/forums/*****
IP Address : *******
Username : ******
Classname : vb_database

Andrew Green
12-11-2007, 03:32 PM
Remove the casino_cash field from the user table through phpmyadmin, next time you do not need to uninstall the product first, just import the new file without removing the old one.

RollaJedi
12-11-2007, 04:01 PM
i'm sorry. where is this on the admin area?

Andrew Green
12-11-2007, 04:09 PM
not the admin area, through phpmyadmin (I'm assuming you have access to phpmyadmin) which is usually accessed through plesk or cpanel.

RollaJedi
12-11-2007, 04:23 PM
no, i just have vbulletin and do all my changing of stuff through the admin area. I have only been doing this for a few months now so I'm pretty new to a lot of stuff.

I had installed your casino mod a while back and have installed all the updates so far just fine. However this one was different. Say when I went to roulette and tried clicking on a chip to use, it wouldnt 'light up'. Also, the strips that spin were above the actual slot machine as well. I guess I should have handled it differently, but I tried to reinstall the version before this one and it gave me one of those error messages, this time about the texas hold-em chat area. I tried uninstalling and reinstalling the new version and now here is where I am with the casino_cash error. I'd really like to get back to square one, but I'm not sure what to do.
Thank you

Andrew Green
12-11-2007, 05:34 PM
no, i just have vbulletin and do all my changing of stuff through the admin area. I have only been doing this for a few months now so I'm pretty new to a lot of stuff.

I had installed your casino mod a while back and have installed all the updates so far just fine. However this one was different. Say when I went to roulette and tried clicking on a chip to use, it wouldnt 'light up'. Also, the strips that spin were above the actual slot machine as well. I guess I should have handled it differently, but I tried to reinstall the version before this one and it gave me one of those error messages, this time about the texas hold-em chat area. I tried uninstalling and reinstalling the new version and now here is where I am with the casino_cash error. I'd really like to get back to square one, but I'm not sure what to do.
Thank you

I'll get back to you with a script to upload later today.

RollaJedi
12-11-2007, 05:39 PM
ok, thank you. sorry to be a problem. :P

punchbowl
12-11-2007, 06:30 PM
Donate:
when clicked on the main casino page http://www.xxxxxxx.com/forum/casino.php?do=donate no longer goes to the donate page. It just refreshes the main page.

Stats:
Still getting
"Notice: Undefined variable: db in /var/www/vhosts/xxxxxx.com/httpdocs/forum/casino/stats.php on line 2" if i click 'more stats' and then 'your stats' . Rest of the page loads normally.

Everything else seems great. Only updated last night.

Mark.B
12-11-2007, 07:17 PM
Donate:
when clicked on the main casino page http://www.xxxxxxx.com/forum/casino.php?do=donate no longer goes to the donate page. It just refreshes the main page.

Quick fix for that:

In casino.php find:
if($do == 'stats')
{
require_once('casino/stats.php');
exit();
}


Add below:
else if($_GET['do']=='donate')
{
require_once('casino/donate.php');
exit();
}
That'll patch it to make the donate link work until Andrew does a cleaner fix.

mastertek2000
12-11-2007, 07:38 PM
works great on my site thanks great mod

RollaJedi
12-11-2007, 07:59 PM
I'll get back to you with a script to upload later today.

leaving from work today and had a few minutes. just seeing if you might have that script for me yet. Thanks!

Andrew Green
12-11-2007, 08:00 PM
leaving from work today and had a few minutes. just seeing if you might have that script for me yet. Thanks!


Not till I get home from work ;)

RollaJedi
12-11-2007, 08:06 PM
ok, thats cool. :)
My folks in my forum love your mod and I do to. Just will be happy to have it back. :D

ChU v2
12-11-2007, 08:43 PM
At some point maybe.


I think no limit would be a huge step in the right direction, a lot of the interest is in No Limit poker.


Probably not, don't really see the benefit myself.

Benefit of showing previous hands would be just that, I can't always remember and I people are always asking "what did I just have" or "what did I fold again" after they see the flop or what not.


Not sure what you mean


Let's say a player folds, the other player could then have an option to show his cards to the players that folded.


thought about that, but with a 10 player game, chat box and common cards, there isn't really any space to put them and keep everything on the screen at once without a high resolution monitor


there's always room :D


Yep. Otherwise people that don't want dealt in, or have left the room will get dealt in.

What about a checkbox that the user can select to say if they want to be in the next or not. This can be done for the check or fold options as well, so the user can check the box before its there turn to speed up the gameplay


Sound effects have been asked for before, might happen in the near future.

Would help

Some more suggestions:

Displaying the winning hand in the chatbox. ex. "ChU wins with a pair of Kings"

With an additon of multiple rooms, tournaments 8 player tables, set cash, winner gets $ added to their total casino cash or admin set prize

I assume you have gone into a free online poker site and seen what they do, if not I suggest it. Most of my suggestions stem from playing online poker on fulltiltpoker.net

punchbowl
12-11-2007, 11:10 PM
Quick fix for that:
That'll patch it to make the donate link work until Andrew does a cleaner fix.
Perfect thanks.
:up:

Andrew Green
12-12-2007, 12:13 AM
.81

Fixed the the transfer cash link and the two backwards ones in the stats page, and added a log and on / off switch to transfers as well

SuperTaz
12-12-2007, 12:30 AM
Every day I sign on here, I see this mod has been updated. This is getting nuts. I am about ready to give up on this mod. lol :D

Andrew Green
12-12-2007, 12:40 AM
lol, well, that's the thing about beta releases, they are still in development so get updated fairly regularly ;)

This was mainly just to fix a couple bugs from .80, hopefully its all set until I have some larger additions now ;)

flyboyindy
12-12-2007, 01:12 AM
I tried to upgrate today and i got an SQL error:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060

Im not really that knowlegable on MySQL.... any ideas on what to do to get the Casino up and running again?

Thanks,
Frank

dodgeboard.com
12-12-2007, 01:14 AM
Every day I sign on here, I see this mod has been updated. This is getting nuts. I am about ready to give up on this mod. lol :D

Frequent updates means the developer is responding to your requests, fixing glitches, adding new features, etc. One of these most "frequent" updates we got the roulette game added.

I appreciate the diligence of the developer and the work he spends to integrate the features we are requesting.

Don't complain about frequent updates on a beta program - that's how we get to GOLD.

Andrew Green
12-12-2007, 01:17 AM
Next time don't uninstall before updating, just import the new product file and it will overwrite the old one. Do you have access to phpmyadmin? If so delete the casino_cash field from the user table, and delete any casino_* tables that are left.

If you don't have phpmysql let me know and I'll send you a file to do that.

I tried to upgrate today and i got an SQL error:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060

Im not really that knowlegable on MySQL.... any ideas on what to do to get the Casino up and running again?

Thanks,
Frank

Mixibiza
12-12-2007, 01:27 AM
It does seem like a great mod and I tried installing it. But when I try to access the casino I get the following error :

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

Fatal error: require_once() [function.require]: Failed opening required 'casino/stats.php' (include_path='.:/usr/local/lib/php/') in /mounted-storage/home78c/sub008/sc44374-ITEF/www/casino.php on line 177

Can you please help me on this. Thanks :)

Mixibiza
12-12-2007, 01:29 AM
Oooppps did i forgot to mention that i installed this version - casino 0 80.zip

Andrew Green
12-12-2007, 02:20 AM
looks like not everything got uploaded, or not to the right place.

The casino folder needs to go up in the main forum directory. So inside that you should have a "casino" folder, with "stats.php" and a whole lot of other files in it. (/casino/stats.php)

This message says that file doesn't exist.

Hornstar
12-12-2007, 02:34 AM
Casino is becoming very popular on my site. they love it.

Just wanted to let you know again, how much I love this mod :)

flyboyindy
12-12-2007, 02:55 AM
Thanks Andrew! Fixed it!

Robert Paulson
12-12-2007, 04:06 AM
Casino is becoming very popular on my site. they love it.

Just wanted to let you know again, how much I love this mod :)

Wait until you start getting the "I need more cash" PM's. It's a total P.I.T.A.!

But still, great add-on! They love it!

carubmun
12-12-2007, 06:20 AM
Every day I sign on here, I see this mod has been updated. This is getting nuts. I am about ready to give up on this mod. lol :D
Im gonna give you the benefit of the doubt in guessing that you mistyped in some way.
Because it would boggle the mind to think that someone finds that a mod maker updating his creation on a constant basis... is a bad thing.

In case i havent said so, big thanks to Andrew the creater of this mod.
My small forum is having loads of fun asking me for more money :)

Just a few humble suggestions. (excuse me if they have already been suggested)

1. Hold'Em seems a bit glitchy to my users, the game slows down, drops players in the middle of the hand, takes everyone back out to the "start game" screen that informs you about ajax. If you click start game you get right back into the game, but its pretty annoying.
Possibly might just be my server or database that has a problem if this hasnt been reported by anyone else.

2. Adding a "Who is playing Texas Hold Em" feature, as in the CMPS module... for those of us who dont use CMPS. Or at least a "Who is in the Casino" feature.

3. The option to disable the chat feature in the Hold Em area.
Or as a better option, for the chat feature to dump all posts into a single dedicated Hold Em thread in the forum. The way some shoutboxes operate.

4. A complaint from one of my users that might help.... "It's just that the big blind is first to act and can raise before the small blind calls the minimum, thats not how it should be".

5. Keep up the good work! :up:

SBlueman
12-12-2007, 06:31 AM
Updated and still loving this mod!

ezurick
12-12-2007, 06:31 AM
.81

Fixed the the transfer cash link and the two backwards ones in the stats page, and added a log and on / off switch to transfers as well

Thanks so much for the quick fixes Andrew... Everything appears to be working great! I did notice since I updated to .81 that games are showing up on the list that I have unchecked as active. Was that meant to be? Of course when a member clicks on it, it gives the normal vb warning about you don't have access... but it could be confusing to some newbies. Again, thanks for the great product... my members love it!

skcyber
12-12-2007, 08:01 AM
Try this,,
edit the casino.php file..

Find:
$result = $db->query_read("SELECT * FROM casino_games ORDER BY gamename");
while ($row = $db->fetch_array($result))

And replace with this

$result = $db->query_read("SELECT * FROM casino_games WHERE active = 1 ORDER BY gamename");
while ($row = $db->fetch_array($result))

I have already this problem ;)

Thank Andrew for the update ! :)

Mafialife Chris
12-12-2007, 08:32 AM
What does this mean?

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM casino_games ORDER BY gamename;

MySQL Error : Out of memory; restart server and try again (needed 524280 bytes)
Error Number : 1037
Date : Wednesday, December 12th 2007 @ 05:30:06 AM
Script : http://www.thefakemafia.com/casino.php
Referrer : http://www.thefakemafia.com/index.php
IP Address : 69.123.81.245
Username : Mafialife Chris
Classname : vB_Database

ezurick
12-12-2007, 10:08 AM
I have already this problem ;)

Thank Andrew for the update ! :)

Ha! That fixed me! Perhaps Andrew could make that permanent in the program so we don't have to change that on every update. And I am certainly not complaining about the updates... I just wished that some other authors would update their stuff... Excellent support Andrew!!!

Andrew Green
12-12-2007, 01:20 PM
What does this mean?


You ran out of memory...

Try the .81a, I redid that query to use less, might want to talk to your host too...

rwilkins108
12-12-2007, 04:17 PM
Andrew, just downladed 81To81A zip file and the casino.php on line 40 has this:

'casino_sportspool_maihttp://martialtalk.com/forum/search.php?searchid=905462n',

just checked, it's in the regular .81a zip file too...

Andrew Green
12-12-2007, 04:18 PM
no idea how that happened... gimme a sec...

dSpotter
12-12-2007, 04:31 PM
Call me blind, but how do I download this or where are the instructions?

I would like to add this to my vBulletin however I seem to going in circles lol. I tried going to the vbgaming web site and clicked on the download link there but it only took me back to the vbulletin.org page.

Can someone please point me in the right direction on how to get this for my board?

Jimandbob
12-12-2007, 04:32 PM
I think Andrew is just upgrading the download. It will be back soon

xchewbaka
12-12-2007, 05:13 PM
Andrew, just downladed 81To81A zip file and the casino.php on line 40 has this:

'casino_sportspool_maihttp://martialtalk.com/forum/search.php?searchid=905462n',

just checked, it's in the regular .81a zip file too...

i think you must edit your php.ini file on your server, there is not enough max_memory limit

dSpotter
12-12-2007, 05:21 PM
I think Andrew is just upgrading the download. It will be back soon

Oh okay, thanks. I will we check back later then. Hopefully will be able to add this soon :)

JimmiOO
12-12-2007, 05:41 PM
Im having problems getting hold em to work, ive got the start game button and this msg (This game is AJAX powered and requires javascript to be turned on) when i click the button it justs says page error at the bottom, any ideas and yes java is turned on :)

Sorry forgot to mention none of my members can play the game,

rwilkins108
12-12-2007, 05:42 PM
i think you must edit your php.ini file on your server, there is not enough max_memory limit

Think you meant that for someone else...

stangger5
12-12-2007, 06:28 PM
No Files Uploaded. ??

nautiqeman
12-12-2007, 06:32 PM
I'm trying to read through this thread to get the fix but I'm not sure if the fix was included with the newest Casino version, which is the one I'm running.

The lottery ran 1 time and now it just shows this message for Upcoming Draw: No Draw Active at this time, please check back later

nautiqeman
12-12-2007, 06:33 PM
a link to my lottery: http://www.thesternzone.com/forums/casino.php?do=lottery

nautiqeman
12-12-2007, 06:39 PM
n/m I updated the casino_loto.php file with $settings = $vbulletin->db->query_read($query);
$setting = $vbulletin->db->fetch_array($settings);

and now it's working!

alexgeek
12-12-2007, 08:32 PM
Ehh where do i download?

towermatt
12-12-2007, 09:02 PM
LOL

I was thinking the same, it must not be up there yet.

Of course, today is the day people want to donate to each other.

I have also lost the field to let my moderator edit sports events. :(

Andrew Green
12-12-2007, 09:22 PM
... hmm... oops?

I dunno where it went, I'm sure it was there...

Putting it back now.

towermatt
12-12-2007, 09:45 PM
All good to go now Andrew, thanks for the great updates.

1F42
12-12-2007, 10:23 PM
Just ran the update but noticed I have blank image holders in the main menu to the left of the titles. Did I miss something? I did upload and overwrite all the new files. Also lost the add chip options in admincp?

Right found the add chip options again but still have the first problem clicking on the properties of the place holders just brings up a path of cards and does not point to any .png file?

HC.
12-12-2007, 10:27 PM
I had to uninstall this mod
Just went to reinstall and had to go into database and drop tables
Went to reinstall product shows up in manage products
but not in my admincp
Why?

HC.
12-12-2007, 10:32 PM
I got it now

Mixibiza
12-13-2007, 01:46 AM
I was finally able to install it. Nice mod :)