Lottery Addon For The Store Hack

Info:
This addon for the store hack gives you the ability to add a Lottery on your store. A lottery with the same principles as a normal lottery. Users buy a lottery ticket in the store and after the specified enddate you or any other admin execute the lottery script in the admincp wich search for a random user from the database and checks if the user bought a ticket and if so then he will receive the jackpot if not then the lottery stays online.

The jackpot will be increased with the amount of the lottery ticket everytime when a new member buy's a ticket.

What to do:
2 Query's: 1 new table, 1 new row.
3 File Edit's: Admin/Index.php, Store.php & Storeadmin.php
1 Template Edit: Store_bit
2 New Templates: store_lottery_error & store_lottery_updated

Some Features:
- A new action on the store: Lottery
- Winner will be picked randomly
- Winner will be pm'ed with a winner's message
- Losers will be pm'ed with a loser's message
- Define Start Date of the lottery
- Define End Date of the lottery
- Define title of the lottery
- Define the amount of a ticket
- Maximum of 1 Ticket Per User
- And more....

This lottery addon will only work with the latest version of the store hack and is compatible with any Vbulletin 2.*.* version.

Have fun with the addon,
Lesane.

[tpearl5]

Originally posted by Lesane


You are using an old mysql version wich don't support that way of choosing a random user. Mysql version 3.23+ supports the "order by rand" function.

Yep! that did the trick. Cept I changed it to pick from the storelottery table so it looks like:

PHP Code:

$findus=$DB_site->query_first("select *, rand() as r from storelottery where lotnumber=2 order by r limit 1;"); 


You rawk Lesane!

Now I just need to get the display on the main page working. http://degster.com/midi/board/ Nothing shows up? (should be right under member # and above newest member)

[Larz]

Lesane, amazing work man. I installed the store yesterday, and my board had over 1000 new posts the same day, that's triple the usual amount. Today is lottery day, and the users are loving it.

I just still (!) can't make the lottery jackpot display on the index.php. I tried every step in this thread, and it just doesn't display.

I am wondering if I'm doing something wrong - I don't have this:

//Most Popular Thread by Replies

in my index.php either?

Board is http://gamesdebat.jubii.dk by the way...

[Lesane]

You're welcome.

The forumhome code on this post works great, it's tested.
https://vborg.vbsupport.ru/showthrea...353#post284353

You can add the code before:

PHP Code:

// get newest member 


[Larz]

It still does not work...

Index.php attached.

One other thing, the colors on the page where you're shown the cost of the lottery tickey are off on my board, they're some shade of blue and my board is in grey only.

[Lesane]

2 things:

1. There must be an active lottery.
2. Maybe you forgot to put the variable $jackpot in the forumhome template.

[Larz]

I have a lottery going and about 5 different $jackpots in various places in forumhome, without anything happening.

[N9ne]

Hi Lesane, how could I remove the upper limit for the jackpot for the lottery, which is 32000 or something right now?

[dgessler]

Quicky Question: Did anyone figure out how to fix the extra line of space below the username when a user has glow on?

Thanks,
Dan

[tpearl5]

That's related to the store hack itself, but if you put the glow tag in a table than it won't return. i.e. http://degster.com/midi/board/t2604.html

[Peace]

Lesane, how can I change the PM from "Dear Loser" to Dear Member"?