vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Lottery Addon For The Store Hack (https://vborg.vbsupport.ru/showthread.php?t=40056)

TalkHardRandy 02-07-2003 06:24 PM

Quote:

Originally posted by N9ne
Hi Lesane, how could I remove the upper limit for the jackpot for the lottery, which is 32000 or something right now?
Edit:

Never mind... change the value of jackpot from 'SMALLINT' to 'INT with a value of however many... I picked 8.

BTW Lesane, since it hasn't been said in a few pages - YOU ROCK!

mantra 02-17-2003 05:17 PM

i installed this hack. How come it does not show up in the store?

Any ideas?

dstruct2k 03-09-2003 06:35 AM

You have to go in to the Admin CP and start a lottery. Remember to only start one, unless having 2 running at the same time doesn't bother you. I'm going to run 1 weekly, and the other monthly. I hope it works out! :D

EDIT: Turns out that my "2 lotteries" thing didn't work out as planned. I was just seeing an echo of the first one.... :rolleyes:

DigitalDesktops 03-26-2003 05:39 PM

i get this error after i pick the winner, and click the link to reward the user:

PHP Code:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQLUPDATE user SET storep=storepWHERE userid='5'
mysql errorYou have an error in your SQL syntax near 'WHERE userid='5'' at line 1

mysql error number
1064 

this is where the error occured (Line 720)

PHP Code:

$rewarduser $DB_site->query("UPDATE user SET storep=storep+$kutje WHERE userid='$userid'"); 


DigitalDesktops 03-27-2003 01:21 AM

^ is anyone else having problems with this?

DPoole 03-27-2003 02:25 AM

yep i always got that so the way i got round it was when i picked a winner was to always start another lottery for the following wekk.Aint sure why it happens though

thamyeuvn 03-27-2003 03:23 AM

YEAH< this hack is very nice. But I have a idea for LESANE: Can you add a page like "WINNER" which show who is the winner and the number of ticket the winner has chossen . :D
It's very cool, really?

DigitalDesktops 03-27-2003 01:18 PM

Quote:

Today at 04:25 AM DPoole said this in Post #206
yep i always got that so the way i got round it was when i picked a winner was to always start another lottery for the following wekk.Aint sure why it happens though
The winner of the lottery doesn't get the jackpot. they just get 20 points back even though i set the lottery to 500 points.

EDIT: nvm i got it fixed. :)

RobinHood 03-28-2003 05:50 AM

Quote:

Yesterday at 03:18 PM DigitalDesktops said this in Post #208


The winner of the lottery doesn't get the jackpot. they just get 20 points back even though i set the lottery to 500 points.

EDIT: nvm i got it fixed. :)


How did you fix it? I got this error too.

Madacc 04-02-2003 08:23 PM

Quote:

03-26-03 at 07:39 PM DigitalDesktops said this in Post #204
i get this error after i pick the winner, and click the link to reward the user:

PHP Code:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQLUPDATE user SET storep=storepWHERE userid='5'
mysql errorYou have an error in your SQL syntax near 'WHERE userid='5'' at line 1

mysql error number
1064 

this is where the error occured (Line 720)

PHP Code:

$rewarduser $DB_site->query("UPDATE user SET storep=storep+$kutje WHERE userid='$userid'"); 


I'm getting the same error.. can anyone help out?


All times are GMT. The time now is 01:33 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.01404 seconds
  • Memory Usage 1,752KB
  • 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
  • (4)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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