vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   VBCasino (https://vborg.vbsupport.ru/showthread.php?t=92613)

micheal332001 07-30-2005 06:06 PM

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 07-30-2005 10:42 PM

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 07-31-2005 01:44 AM

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 07-31-2005 10:02 PM

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 07-31-2005 10:38 PM

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 08-01-2005 05:58 AM

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 08-01-2005 06:06 AM

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

slim cutty 08-01-2005 06:26 AM

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 08-01-2005 06:30 AM

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 08-01-2005 10:00 AM

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


All times are GMT. The time now is 07:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01311 seconds
  • Memory Usage 1,748KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete