VBCasino

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

[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

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?



Any assistance on this please?