VBCasino

[waza]

Hey,
There has been a new release of the casino. I have added a lot of features and also adamgessel helped me a lot.

Because I was on vacation and people were waiting for the new release adamgessel has released it in a new thread.
wich is right here: https://vborg.vbsupport.ru/showthread.php?t=93374

I don't now if we continue here or in the other thread.

Here are the features:

*On/Off switch for every game
*A lot more games
*Master on/off switch
*Set which row in the user table the money comes from (so you can use it with petz, ucash or other)
*Set how much winners the lottery has to take
*The staggering in percents for the lottery winners (like the first wins 90% of the jackpot, second 50% and third 20%)
*Staggering per 5 guesses in for higher/lower game
*Set per usergroup what the price of a lottery ticket is
*Set per usergroup, per game if they are allowed to play it
*Set per usergroup or they can view the casino
*Set per usergroup or they can buy multiple lottery tickets (from reset to reset)
*PM function for lottery winners
*Verified to work with vBulletin 3.0.8
*Installer now works right.
*Installer now uninstalls BETA 1.
*Fully phrased

DEMO BOARD:
http://www.a-d-a-m.com/forum

SCREENSHOTS:
see below

[Logikos]

Is this a addon or a stand alone hack? Great work though. You also forgot the .zip file ;)

[waza]

Hey, I didn't forget it, I just didn't have winzip. I thought I could also user .rar files
This is a addon in this way: u have to got a money system like petz or vbookie or ucash ushop, it can be integrated in several systems

[boxingscene]

will this hack work with 3.03?

[waza]

It has only been tested with 3.0.7 but normally it will work with all the 3.0.x (not 3.x) versions.

[boxingscene]

It has only been tested with 3.0.7 but normally it will work with all the 3.0.x (not 3.x) versions.

I know this is a bit off the topic, but is there any Texas Hold'Em out there for VB in this format or is there a game version for any of the arcade game add ons? I would love to get a hold of something like that.

[waza]

Not in this type of game.
Maybe for you'll find something @ ibproarcade.com

[Biker_GA]

Whups!


Database error in vBulletin 3.0.6:

Invalid SQL:
ALTER TABLE usergroup ADD lotteryticketprice INT UNSIGNED DEFAULT '10' AFTER pmunread

mysql error: Unknown column 'pmunread' in 'usergroup'

mysql error number: 1054

Date: Thursday 21st of July 2005 12:49:12 PM

[Koutaru]

I love the slot machine! I'm definately adding it to my site when I get a shot at it ;)

[Reeve of shinra]

Niiiice

[adamgessel]

For those who are having the mySQL error (mysql error: Unknown column 'pmunread' in 'usergroup'), you can download this new install file that should fix the problem. I just tried it and it seems to work fine. The file is attached. Just replace it with the original, and once you're done installing, remove it.

EDIT: Updated with the new install file.

[DR?@M W?@V?R]

Anyone got a working demo to show us?

[Biker_GA]

For those who are having the mySQL error (mysql error: Unknown column 'pmunread' in 'usergroup'), you can download this new install file that should fix the problem. I just tried it and it seems to work fine. The file is attached. Just replace it with the original, and once you're done installing, remove it.

Boo-boo in yours as well. You're calling install_arcade.php at the end of the file when it should be casino_install.php.

[adamgessel]

I didn't do that. I only modified it so that the database was right.

[Biker_GA]

Found another error in the script. Where it adds usergrouppermissions to usergroup, it should actually read lotterygrouppermissions.

[Biker_GA]

OK.. This is getting just a wee bit tiresome.....


Database error in vBulletin 3.0.6:

Invalid SQL:
INSERT INTO lottery_settins (active,lotteryactive,slotsactive,cashrow,winners, winamount) VALUES ('1','1','1','uttpoints','1','60')

mysql error: Table 'globalaf_vbulletin.lottery_settins' doesn't exist

mysql error number: 1146

Date: Thursday 21st of July 2005 02:51:47 PM

[adamgessel]

Here is the new one.... I fixed a lot of errors that were in the old one. This one has been tested and works. I missed something in the earlier one.

Enjoy!

EDIT: Biker_GA, found the error you just found. It made it so that it would come up with errors when trying to update the usergroup settings, but I've tried it and works when you use the one attached.

EDIT 2: Fixed the installation, now the phrases are installed correctly, and everything seems to work fine. Let me know if anybody has more problems with this.

[adamgessel]

DR€@M W€@V€R, I installed the lottery and you can try it by going to:

http://www.fh123swap.com/board/lottery.php

Keep in mind that you'll need to register to try it out. I'll try to make it so that you don't need to, but I'm not sure if it will still work like it should.

[Biker_GA]

Here is the new one.... I fixed a lot of errors that were in the old one. This one has been tested and works. I missed something in the earlier one.

Enjoy!

EDIT: Biker_GA, found the error you just found. It made it so that it would come up with errors when trying to update the usergroup settings, but I've tried it and works when you use the one attached.

Had to fix the arcade reference again, but once that was done, the installation went fine. Thanks. :)

[Biker_GA]

Another error. When saving the settings in AdminCP, the error "Cannot find phrase "casino_cp_redirect" is displayed briefly.

[adamgessel]

I finally found what you meant by the arcade reference. I think I fixed it, but can't be sure because I never had a problem with it. Someone please confirm that it works, the posts I made earlier should have the newest one on it now, which should fix the reference.

[m0nde]

This would be a great addition to uCash/uShop. You could win uCash in the casino...

- Sid

[Biker_GA]

It does tie into uCash.

[Biker_GA]

Are purchase prices modified in the actual script? Or should there be something tied into uTT Store?

Edit -- Nevermind. Found it in the Usergroup settings.

[yoyoyoyo]

A nice addition to the slot machine would be to have animated gif pics for the resulting pictures of fruit. Then after they click on it they will roll a bit and then stop on the right picture. The results would be the same - just something pretty to look at :D

[adamgessel]

I fixed the phrase thing. The new installation file is available on my other posts.

[DS MrSinister]

Nice hack i will install tonight when i get home form work.

Clicks Install

[Biker_GA]

OK. Where do you set the payout values for the slots?

[waza]

Hey,
srry for the bugs, but that 's why it's a beta release ;).
I forgot to add the redirect phrase.
I will try to get out the bugs described and use the new installer (it's because I just changed the arcade installer.)
Thx to adamgessel and the others.
Btw, I would be glad if somebody could fix the winners section, I can't get it fixed.
Grz,
seba

[mkdevo]

DR?@M W?@V?R, I installed the lottery and you can try it by going to:

http://www.fh123swap.com/board/lottery.php

Keep in mind that you'll need to register to try it out. I'll try to make it so that you don't need to, but I'm not sure if it will still work like it should.

just a suggestion - you might want to make a 'test user' account for things like this.. saves people from the hassle of signing up for a one-time visit, and won't skew your numbers at all..

[adamgessel]

That's a good idea... I'll try setting up a test account.

Waza, I'll try to get the winner's section to work. I'll tell you if I get something going.

[adamgessel]

I have put up a test lottery account. If you would like the username/password, please PM me because I don't want my site to get spammed.

[Mr. Brian]

Looks cool.. Looking forward to it. :)

[waza]

@adamgessel: It 's not necesairy anymore to fix the winners, I did it myself, still another thx for fixing all the bugs in the installer.

Here I already fixed a million other bug fixes, the winners section and the phrases works also.

I'm now going to do the pm function and rewrite the cron so I can save some query's.

[adamgessel]

Okay... thanks waza for this hack. Let me know if there's something else I can help you with. I'd be happy to help you with any part of this hack. Just PM me if you need anything.

[MUDERCOOL]

dear waza I just installed the hack. I've been waiting for a thing like this for a long time. it's working smoothly. thank you very much. BTW I got "the" database error but fixed with adam's installer file. thank you adam, too.

I'm now trying to understand all the variables and (BTW it's smoothly working with UTTPOINTS) and waiting for someone to make the winners "SHOW" on the winners page, that is umm I think a must buddy.. also the PM add-on will be an awesome feature.

I didn't get how it pays the slots games' winners (what are the ratios, who can win or lose how much etc) but I'm on the code (I'm not a coder) and trying to figure out what controls what..

Thank You.

[MUDERCOOL]

$applecount=0;
$bananacount=0;
$orangecount=0;
$starcount=0;

ummm I cannot figure out how the slots system work indeed, it's not about the hack maybe but can someone briefly explain, should I edit anywhere edit on lottery.php to adjust winning ratios etc? because it shows on my page like this (/lottery.php?do=slots)

everthing seems "zero" although I played 3-4 times and it cut my points (money, uttstore points) like below:

https://vborg.vbsupport.ru/

Thank you for all for all concerns and this great hack again.

[mcyates]

when i try to buy a lottery ticket it comes up with this error in a box

"U Mag geen tickets Kopen"

What does this mean?

[mcyates]

i get this error now or i think its an error, when i try to buy a ticket. I've set the admin usergroup to they can buy tickets, buy multiple tickets and use the slot. The error i get below is when i try to buy a lottery ticket.

U hebt te weinig geld

[waza]

Ow, srry this is dutch :)
in the next release it's all phrased, so you'll understand it.

For now:
U Mag geen tickets Kopen -> U can't buy tickets, you can set this per usergroup in the admincp

U hebt te weinig geld -> You don't have enough money. you can set the price per ticket per usergroup in the admincp, you also need a money system... (like ucash/ushop)

If you don't have a money system (this requires some phpmyadmin knowledge):
go to you phpmyadmin and go to your vbulletin user table.
at a column named like credits, points, money, ...
Give U are all the users something like 500 credits.

Go to you casino settings and set the cashrow to wath you have named you column.

[waza]

I SHOULD NEED:
Can somebody give me (by uploading here) a zip package with all the images of a card game.
So the four times 1->10 + 3 pics.

Thx,
seba

[MorrisMcD]

How close is this to being out of Beta testing.. Seems a bunch of you have it workin well now...

[mcyates]

Ow, srry this is dutch :)
in the next release it's all phrased, so you'll understand it.

For now:
U Mag geen tickets Kopen -> U can't buy tickets, you can set this per usergroup in the admincp

U hebt te weinig geld -> You don't have enough money. you can set the price per ticket per usergroup in the admincp, you also need a money system... (like ucash/ushop)

If you don't have a money system (this requires some phpmyadmin knowledge):
go to you phpmyadmin and go to your vbulletin user table.
at a column named like credits, points, money, ...
Give U are all the users something like 500 credits.

Go to you casino settings and set the cashrow to wath you have named you column.

ok thanks. Once you sort the language out and make the winners show up then this will be a very good hack. I'll keep using it and just upgrade every time you do an upgrade.

Cheers

[mcyates]

BIG PROBLEM

Some of my members have complained that they have lost all their money after playing the lottery. How can this happen? Its only happened to people who have played the lottery.

[waza]

I think I have already fixed this, but to be sure:
can you tell me:
-did all of your members had this problem
-Where they all in the same usergroup
-what are there settings and what do they have to pay for a ticket.

IMPORTANT:
For safety reasons everyone can better close this hack untill I release beta 2 (Normally tomorrow).

[MUDERCOOL]

I'm waiting for beta 2 release eagerly, thanks wasa.

[adamgessel]

The 2nd Beta will be released tomorrow. It got delayed after a couple of things didn't work right.

[waza]

I know the fealing.
Maybe I'll make the release of tomorrow the 1.1.0 beta 1 :p.
There has been changed a lot.
my lottery.php counts almost 800 lines, you'll see why!!

[adamgessel]

I'm currently beta testing the beta ;)

Waza should be releasing it after we both look it over, but I'm not sure. I'm checking to make sure that people shouldn't have problems, and then maybe a final will be released.

[murrtex]

I applied this hack .but it does not work.I wanna uninstall it.How can i do.please help me...

[boo.3]

Texas hold'um *online*

and black jack *online*

then this would be sweet ;D

[waza]

@murrtex: In the beta 2 there is a uninstaller.
@boo.3: maybe for a later release.

In the beta 2 there are 3 new games, full phrased, a working winners section, thousands of bug fixes and a uninstaller.

[murrtex]

@murrtex: In the beta 2 there is a uninstaller.
@boo.3: maybe for a later release.

In the beta 2 there are 3 new games, full phrased, a working winners section, thousands of bug fixes and a uninstaller.


can you give me that download link please? (Beta 2) thanks

[Biker_GA]

Not available yet. ;) That's what they're still working on.

[pepel13]

Now that's what I've been looking for!

Too bad this is still in beta but I'll hope it will be il full release one day ;)

Thanks

[waza]

I'll release it tomorrow, 100% sure :).
Btw, If somebody could give me all the images of a card game??
Then i'll make blackjack (what will be for a later release).

[Biker_GA]

Heh. My users are going to hate you for creating this. I'm lovin' it. I'm watching money fly out of their pockets at record rates. **grin**

[MorrisMcD]

Released yet??? All bugs worked out?? I would normally just install it now, but this is a super busy time for my forum... I dont want to compromise any downtime at all...

Also.. I am going to be upgrading my server soon, and was wondering how many queries this hack brings.. Will it slow down my site significantly? If it not too intensive?

[boo.3]

@murrtex: In the beta 2 there is a uninstaller.
@boo.3: maybe for a later release.

In the beta 2 there are 3 new games, full phrased, a working winners section, thousands of bug fixes and a uninstaller.

ok thanks for reply ;)

[micheal332001]

Hi all

I have moded this a bit more i have added in a option to have the jackpot for the slots reset
to a set amount the admin puts in when in the casino options.
Also i have changed the payout so that if a player gets 3 bananas, 3 apples or 3 oranges they get a small % from the main jackpot, but if a player get 3 stars they win 100% of the jackpot this will reset back to the preset jackpot you have put in the casino options.
Im just finishing some of the code and making a read me file up so will add this in then.

[micheal332001]

Oh just found out that when the lottery had been done it dont show the winners when you click winners.
Is there a fix for this

[micheal332001]

here is the code for getting the winners if anyone could help me sort this out.


php code

if($_REQUEST['do']=="winners"){
$winner_results=$DB_site->query("SELECT t1.*,t2.username FROM ".TABLE_PREFIX."lottery_winners as t1,".TABLE_PREFIX."user as t2 WHERE t1.userid=t2.userid ORDER BY t1.id DESC");
$are_winners=$DB_site->num_rows($winner_results);
if($are_winners==0){
$winnerbits="0";
eval('$current = "' . fetch_template('lottery_winner') . '";');
}else{
$winnerbits="1";
$i=0;
$e=1;
while($winners=$DB_site->fetch_array($winner_results)){
$kleur = ($e % 2) ? $class='alt2' : $class='alt1';
$winners['place']=$winners['place']+1;
$date=$winners['date'];
if($e==1){
$prev=$date;
}
if($prev!=$date){
$datum=$prev;
eval('$morebits .= "'.fetch_template('lottery_winner_bit').'";');
$prev=$date;
$showbits="";
$i++;
}
eval('$showbits .= "' . fetch_template('lottery_winner_bit_bit') . '";');
$e++;
}
eval('$current = "'.fetch_template('lottery_winner').'";');
}
}

[TPCComOld]

Hey Waza,

I'm curious to know if you plan to or would consider adding Texas No Limit Hold em Poker to the casino?

I know it would be a hit.

[adamgessel]

I'm not sure if he went on vacation, I have been gone for the last few days and he has sent me the latest version. I sent him a PM reply, and if he doesn't respond I will try releasing it. I am adding a few things and bug testing it.

[micheal332001]

The onle problem i have is with the view winners as i have modded the slots for my site.
The slots on my site have a fixed win for the bananas oranges and apples.
The jackpot that was there is now only for the stars and every time someone plays the slots the jackpot will go up but the others will stay the same.
Also if a player wins the jackpot the jackpot will reset to a set amount set in the admincp/casino options. The win amount for the other fruits are also set there.
This gives the admin more control over the amount of points won.
I have also moded some templates so it will show the win pot for each fruit.

[slim cutty]

can anyone tell me why I continue to get this error when trying to install this

--------------------------------------------------------------

Database error in vBulletin 3.0.7:

Invalid SQL:
ALTER TABLE usergroup ADD lotteryticketprice INT UNSIGNED DEFAULT '10' AFTER pmunread

mysql error: Unknown column 'pmunread' in 'usergroup'

mysql error number: 1054

----------------------------------------------------------------

[Biker_GA]

Apparently you do not have a column called "pmunread" in your usergroup table.

[slim cutty]

How do I ad that column? and was it a column that is in the original install of vbulletin that I may have deleted? Help please...thanks in advance

EDITED *

wow..the file above that is zip''d is an old file.... how come it's still there? found all the errors reading every posts here... thanks for the help

[Marco van Herwaarden]

Just take out the 'AFTER pmunread'.

There is no pmunread column in the usergroup table, and it also doesn't make much sense to have one.

[slim cutty]

@ Micheal

How did you get those stats to show on the slot page? Did you modify any code in the lottery.php, if so where at did you modify code?

My page looks like his below.. it shows nothing but zeros doesn't seem to be making any connection with the database... but deducts uCash Points?

https://vborg.vbsupport.ru/

Any assistance on this please?

[adamgessel]

If you downloaded my version of the install file, you won't have any problems. It fixes a lot of problems you will have.

[wwesn1]

I thought this was suppose to be updated a couple days ago?!

[adamgessel]

Update:
Waza went on vacation, forgot to update. I'm going to post the new version here in a few minutes. I'm testing it out.

If I find anything wrong then it might take a little longer...

[adamgessel]

NEW VERSION:
https://vborg.vbsupport.ru/showthread.php?t=93370

[wwesn1]

well the new version thread seems to be gone. anyhow I did manage to download it and install and when I use it all I see is a page with an image on it that says "Play a game and maybe you'll in the Jackpot' but there are no games!

[adamgessel]

Sorry, put it in a new forum. It is available here:
https://vborg.vbsupport.ru/showthread.php?t=93374

Anyways, I'm looking into your problem. Please make sure you set all usergroups correctly. I'll look into the code to make sure everything is right...

[wwesn1]

okay thanks, and yes all the settings are correct

[wwesn1]

same thing on your demo forum

[adamgessel]

Okay, looking into the code... if something is found that is wrong, an updated version will be uploaded on the new thread and you will be notified.

[micheal332001]

@ Micheal

How did you get those stats to show on the slot page? Did you modify any code in the lottery.php, if so where at did you modify code?

My page looks like his below.. it shows nothing but zeros doesn't seem to be making any connection with the database... but deducts uCash Points?

http://www.mesajtahtasi.com/seemszero.jpg

Any assistance on this please?


Hi m8

There is not a problem with the code here there is a problem with the sql
if you look in to the sql and look for the table lottery_slots_stats
you will see its enpty you need to insert the info in manuly but use all ones as if you put 0's in it will not work.

Hope that helps

[waza]

let's continue in the new thread:

https://vborg.vbsupport.ru/showthread.php?t=93374

[Thug]

any plugins or more games for this

[tuanluu]

Will these hack upgrade to 3.5 anytime soon??

[funinthesun]

Has this been upgraded to 3.5 yet? :)

[waza]

no, srry, but as I now have some experience with vb 3.5 (vbbuddies) I might port this...

[funinthesun]

Thats great. Thanks :)

[marinefiend]

When is this going to be ported for 3.5?

[waza]

Micheal would do the port he said.
However, I gonna ask if he's already far, otherwise I'll port it.
Because I think I'll do a complete re-write for 3.5,
this hack was my first and I'm not satisfied with it and the code is not good either.

Grz,
seba

[micheal332001]

Micheal would do the port he said.
However, I gonna ask if he's already far, otherwise I'll port it.
Because I think I'll do a complete re-write for 3.5,
this hack was my first and I'm not satisfied with it and the code is not good either.

Grz,
seba

Hi there m8

I have this working now on 3.5.1 i hop to have the files ready for you soon waza.

[tuwebfacil]

Hey great news! Hope to see it soon!

[bashy]

Hi peeps

looking forward to seing this for 3.5....

Regards

Bashy

[Black_Widow]

I'm already waiting for a 3.5 version.
Thank you

[Holidazed]

Any update info on the 3.5 version yet?

[kylek]

Would love this to work on 3,5 and to be able to have it work with vbPlaza.

[Holidazed]

I don't think there is any intention of making this work on 3.5. I guess they just gave up.

[daylight]

well we are on 3.6.2 now.
just wondering will any update will be made?
thanks

[Greek Wizard]

well we are on 3.6.2 now.
just wondering will any update will be made?
thanks

Considering the demo site does not exist anymore, I would say no.

lol

[John Diver]

Pitty I was really interested in this :(

[Shazz]

Looks just as as vBPlaza!