vb.org Archive - Lottery Addon For The Store Hack

Page 5 of 27

« First

Last »

Show 40 post(s) from this thread on one page

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)

Lesane

06-21-2002 12:45 PM

Quote:

Originally posted by ULTIMATESSJ
whenever i try to buy a lottery ticket it always says this

Invalid SQL: UPDATE store SET quantity=quantity-1 WHERE id=10
mysql error: Unknown column 'quantity' in 'field list'

mysql error number: 1054

Date: Thursday 20th of June 2002 06:10:37 PM
Script: http://www.animexplosion.com/forums/forums/store.php
Referer: http://www.animexplosion.com/forums/...action=lottery

The lottery addon is based on the latest version of the store hack, but look at this post for the right query for earlier versions:
https://vborg.vbsupport.ru/showthrea...595#post263595

Lesane

06-21-2002 12:46 PM

Quote:

Originally posted by MrBojangle1
well I am also having probs even with the new sql query code

https://vborg.vbsupport.ru/showthrea...595#post263595 ;)

Lesane

06-21-2002 12:48 PM

Quote:

Originally posted by Itworx4me
My start dates are set wrong. Like in 1969. The money in the Jackpot don't show up either. How do I fix this?

Wich php version is running there? The code just takes the currently date & time.

Lesane

06-21-2002 12:49 PM

Quote:

Originally posted by CHoooo
Like they said before "God of Hacks" :D

Hey choooooooooooooooo, what are you doing here? Are u lost? :D

Lesane

06-21-2002 12:50 PM

Quote:

Originally posted by Limpkinw
Great hack!

Question...

When the lottery is ended is there a way to reset the tickets purchased so the ones in the previous Lotto have to buy again?

Hopefully I am clear about what I mean... Just tring to keep it interesting for the people "in" cause if for exp. it takes a month for anyone to win they won't be able to participate for a month

When the lottery will be ended then everything from the lottery table will be deleted.

Lesane

06-21-2002 12:54 PM

Quote:

Originally posted by trainer
ok have a question... my site has over 10k members and about 1/2 are not active. is there a way to pick a winny out of the tickets sold rather then from all the members. couple be weeks before someone wins.

also how does this stop people from creating bogus accounts just to buy another ticket?

great idea just thinking aloud...

1. Find this part in storeadmin.php:

PHP Code:


		
			
$findus=$DB_site->query_first("SELECT * FROM user ORDER BY RAND() desc LIMIT 1");

And change it to:

PHP Code:


		
			
$findus=$DB_site->query_first("SELECT * FROM storelottery WHERE lotnumber=2 ORDER BY RAND() desc LIMIT 1");

2. Tell them this:
https://vborg.vbsupport.ru/showthrea...594#post263594

Lilac

06-21-2002 01:57 PM

Quote:

Originally posted by Peace
Lesane, a question, what's the postbit or link code for "richest" person? I want to display the "richest person" on my forum home.

I need this too. Do anyone know the postbit for this? Lesane, anyone?

LightBringer

06-21-2002 02:21 PM

Quick question:

Why would you want members that haven't bought a ticket even participating in the lottery?

That's like going to your local powerball location, grabbing a scratch off, and someone else winning it even when they didn't buy it hehe :)

Lesane

06-21-2002 03:38 PM

Quote:

Originally posted by LightBringer
Quick question:

Why would you want members that haven't bought a ticket even participating in the lottery?

That's like going to your local powerball location, grabbing a scratch off, and someone else winning it even when they didn't buy it hehe :)

Huh? :confused: They aint participate on the lottery, the script just look in the user table if a user bought a ticket and if not then the lottery stays online and if so then the user will get rewarded.

Lesane

06-21-2002 03:48 PM

Quote:

Originally posted by Peace
Lesane, a question, what's the postbit or link code for "richest" person? I want to display the "richest person" on my forum home.

Richest person? This is the lottery addon thread and not the store hack thread ;):lick:

All times are GMT. The time now is 10:53 AM.

Page 5 of 27

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01272 seconds Memory Usage 1,749KB 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 (2)bbcode_php_printable (9)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
Messages: