Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > vbBux / vbPlaza
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBadvanced Module to show Lotto jackpots, endtime, and number of tickets owned/sold Details »»
vBadvanced Module to show Lotto jackpots, endtime, and number of tickets owned/sold
Version: , by Quarterbore Quarterbore is offline
Developer Last Online: Aug 2020 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 08-21-2006 Last Update: Never Installs: 0
 
No support by the author.

OK, this code is really not optomized but the MYSQL coding of this is just a little above my own skill. So, I am sharing my vBa module with the hopes that someone can help optomize it as right now I query the database FOUR times in this tiny block!

It works as is but I know someone with more skill then I have would be able to make it work better....

Here are some notes:

I hard coded the two lotteries I use on my site lotteryid = '1' and lotteryid = '2'. I did this as I couldn't figure out how to do this in an array. I also did not program this with phrases as I have no plans to use this in multiple languages.

Here is the code:

PHP Code:
<?php
    
// search for the lottery
    
$weeklylottery $vbulletin->db->query_first("SELECT jackpot,enddateline,ticketssold FROM " TABLE_PREFIX "vbplaza_lottery WHERE lotteryid = '1' AND active = 1");
        
// count how many times this user has purchased a ticket for the weekly lottery
        
$weeklyticketsowned $vbulletin->db->query_first("
            SELECT COUNT(*) AS count
            FROM " 
TABLE_PREFIX "vbplaza_lotteryticket
            WHERE lotteryid = '1'
                AND userid = '" 
$vbulletin->userinfo['userid'] . "'
        "
);
    
$dailylottery $vbulletin->db->query_first("SELECT jackpot,enddateline,ticketssold FROM " TABLE_PREFIX "vbplaza_lottery WHERE lotteryid = '2' AND active = 1");
        
// count how many times this user has purchased a ticket for the daily lottery
        
$dailyticketsowned $vbulletin->db->query_first("
            SELECT COUNT(*) AS count
            FROM " 
TABLE_PREFIX "vbplaza_lotteryticket
            WHERE lotteryid = '2'
                AND userid = '" 
$vbulletin->userinfo['userid'] . "'
        "
);

    
$daily['jackpot'] = number_format($dailylottery['jackpot'], $vbulletin->options['vbplaza_decimalplaces']);
    
$daily['enddate'] = vbdate($vbulletin->options['dateformat'] . ', ' $vbulletin->options['timeformat'], $dailylottery['enddateline']);


    
$weekly['jackpot'] = number_format($weeklylottery['jackpot'], $vbulletin->options['vbplaza_decimalplaces']);
    
$weekly['enddate'] = vbdate($vbulletin->options['dateformat'] . ', ' $vbulletin->options['timeformat'], $weeklylottery['enddateline']);


echo 
'<tr><td><div class="smallfont">';

echo 
'Daily Lotto: ' $daily['jackpot'] . '<br />' ;
echo 
$daily['enddate']  . '<br />';
echo 
'You own ' $dailyticketsowned[count] . ' of the ' $dailyticketssold ' tickets.<br /><br />';

echo 
'Weekly Lotto: ' $weekly['jackpot']  . '<br />';
echo 
$weekly['enddate']  . '<br />';
echo 
'You own ' $weeklyticketsowned[count] . ' of the ' $weekticketssold ' tickets.<br />';


echo 
'</td></tr></div>';

?>

Attached is a screenshot...

Thanks for any help improving this!

Download Now

File Type: (21.4 KB, 18 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:57 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.03713 seconds
  • Memory Usage 2,238KB
  • Queries Executed 17 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit_attachment
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete