Contest Hack -- Points hack addon

This is basically a hack addon to the points hack that allows users to use their points, similar to the lottery hack by Lesane for the store hack, to purchase tickets that can be used in random (or rigged.) drawings.

It has a decent admin cp interface, letting you edit/modify/delete contests, etc. and also has the option to pick a random winner.

Here's install instructions...

1. Run these SQL statements:

CREATE TABLE `contest_contests` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`name` TEXT NOT NULL, 
`price` TEXT NOT NULL, 
`open` TEXT NOT NULL, 
`winner` TEXT NOT NULL,
INDEX (`id`)
);

CREATE TABLE `contest_entries` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`userid` TEXT NOT NULL, 
`contestid` TEXT NOT NULL,
INDEX (`id`)
);

2. Download the zip and replace your original points.php file in your mod directory with the updated one.

3. Extract contest.php to your forum directory.

4. In admin/index.php:

Find:

makenavoption("New Posts","../mod/moderate.php?action=posts","<br>");
makenavoption("New Attachments","../mod/moderate.php?action=attachments");
makenavselect("Moderation","<hr>");

Add after:

// *************************************************
makenavoption("Add","../mod/points.php?action=newcontest","|");
makenavoption("Modify","../mod/points.php?action=modifycontest", "|");
makenavoption("Draw","../mod/points.php?action=drawwinners", "|");
makenavoption("Past Winners","../mod/points.php?action=viewwinners");
makenavselect("Contests");

5. Enjoy!:bunny:



P.S.: This originally started as a hack I custom-wrote for a forum, but after some consideration, I decided to release it here to everybody.

Links and Donations are greatly appreciated.

P.P.S.: This is my first hack that's released here, so if you see problems, be sure to let me know.


If you want each user to be able to only have one entry, view post number 19

[eiSecure]

These two hacks are fully compatible.

[Brainmaster]

Hmmm ... a mod from vb-germany saids me that it's doesn't goes, 'cause I've got one addon for the user point hack ... I'll try it later to do this ... THX U

[Heineken77]

If the original author of this great hack is too busy to make it so that you can choose in the adminCP to send an email / PM or both (choice is given to admin) to the winner saying - message you specify. And also sending out a email / PM or both to all the losers saying - message you specify?

This would really help me out as I'm running a basketball league and want to make it so they can check their messages to see what lottery draft possition they've won

Sincerely Hoping!
Heineken

[Heineken77]

I will pay someone money via PayPal if they would be able to hook up the PM or Email notification addition to this hack that I requested above

Also, I am wondering if there's atleast a way to delete entries. If that is a small addition, that would SERIOUSLY help me out!

[Heineken77]

OK....I figured out on my own how to remove entries. Through MySQL Is there anyone who could figure out how to have the winners and losers notified by PM and Email letting them know whether they won or lost? I'll pay for it!

[eiSecure]

Since you put it that way... I'm in.

Just send me an email with your PayPal and what you think it's worth and I'll find some time to add it in.

[planetrap]

i get a database error when i try to enter a contest

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT storep FROM user WHERE userid='1143'
mysql error: Unknown column 'storep' in 'field list'

mysql error number: 1054

I do have the point hack installed

[LilTara]

I had the same problem planetrap.... I ended up having to replace everwhere it said storep in the contest and points phps with field6 (The field my points are in) and changing user to userfield.

Seems to work... at least so far. Look where it says ***start enter contest*** in the contest.php and where it says ***startdopoints*** in the points.php

P.S. Don't know if it's relevant but I'm using 2.2.9 aranoid:

[lancepoint]

will this work with vb 3.03 if so HELP! it will be for logo template and flash design cotests at designerbeat.com. and at lancepoint.com I know this is an old post but i cannot seem to find anyone that can do a contest hack. I did however get a pm from someone who has one installed but it isnt for sale...

please help. my head is worked to the bone. racking it over this.