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

[ULTIMATESSJ]

Originally posted by Vivi Ornitier
hmmm . .. i tried those commands and it still brings up a blank page.

same with me

[eiSecure]

oh, whoop!

It's supposed to be contest.php?action=view

:bunny:

[BigJohnson]

Wow that doesn't work neither. What do we do now.

[BigJohnson]

Wait a sec. Where are the template edits? contest_main

Huh i see these in the php file but no where in the directions did it say to make templates. Something fishy is going on here. o_0

[eiSecure]

Oh, whoops... yeah, you need to create a template, sorry, my bad. ^_^

Here, just put this in as your template content...

Name the template contest_main :bunny:

[BigJohnson]

This hack works great but just one thing that is wierd about it. Is there any way you can only get into a contest once. Because i can click enter contest for the same contest and still be paying not even noing that i enter the contest. So if there could be an error screen or something that says you already have entered this contest please make something like that. Thanks so much. This hack is amazng. I love it. But with out this it seems pretty funny. Thanks

[eiSecure]

To prevent someone from submitting more than one ticket, you can modify the code a little to have a while() loop that checks if the results from a SQL select statement return any results.

If you make it select the username, and the number of results is greater than 0, just popup an error.

[BigJohnson]

Thats the prob hehe. I don't no how to code hahaha. I am learning but please post the code that would help tremendously. Also where to put the code would help also hehe. Thanks.

[eiSecure]

Okay...

In contest.php, find:

PHP Code:

// ############################### start enter contest ##########################
if ($action=="enter") {
  include("./global.php");
  //check usergroup of user to see if they can use Profile
  if ($bbuserinfo[userid]==0) {
    show_nopermission();
  }
  $contestentry=$DB_site->query("SELECT id,name,price,open,winner FROM contest_contests WHERE id='$contestid'");
  while ($contest=$DB_site->fetch_array($contestentry)) {
    $giladd=$contest['price'];
    $open=$contest['open'];
  }

  if ($open=="NO") {
    $contestbody .= "This contest has been concluded. Your entry has not been entered.";
    eval("dooutput(\"".gettemplate("contest_main")."\");");
  } else {

  $pointfield="storep";
  $gilstr=$DB_site->query_first("SELECT storep FROM user WHERE userid='$bbuserinfo[userid]'");
$gil=$gilstr[$pointfield];
$gilamt=$gilstr[$pointfield];
if ($gil < $giladd) {
$contestbody .= "You do not have enough points to enter.";
}
else {
$postgil = ($gilamt - $giladd);
$DB_site->query("UPDATE user SET storep='$postgil' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("INSERT INTO contest_entries (id,userid,contestid) VALUES (NULL,$bbuserinfo[userid],$contestid)");
$contestbody .= "You have entered this contest.";
}
eval("dooutput(\"".gettemplate("contest_main")."\");");
}
} 


Replace:

PHP Code:

// ############################### start enter contest ##########################
if ($action=="enter") {
  include("./global.php");
  //check usergroup of user to see if they can use Profile
  if ($bbuserinfo[userid]==0) {
    show_nopermission();
  }
  $contestentry=$DB_site->query("SELECT id,name,price,open,winner FROM contest_contests WHERE id='$contestid'");
  while ($contest=$DB_site->fetch_array($contestentry)) {
    $giladd=$contest['price'];
    $open=$contest['open'];
  }
  $contestcheck=$DB_site->query("SELECT * FROM contest_entries WHERE userid='$bbuserinfo[userid]'");
  if ($open=="NO") {
    $contestbody .= "This contest has been concluded. Your entry has not been entered.";
    eval("dooutput(\"".gettemplate("contest_main")."\");");
  } elseif ($DB_site->num_rows($contestcheck)>0) {
    $contestbody .= "Sorry, you can only enter this contest once.";
    eval("dooutput(\"".gettemplate("contest_main")."\");");
  } else {

  $pointfield="storep";
  $gilstr=$DB_site->query_first("SELECT storep FROM user WHERE userid='$bbuserinfo[userid]'");
$gil=$gilstr[$pointfield];
$gilamt=$gilstr[$pointfield];
if ($gil < $giladd) {
$contestbody .= "You do not have enough points to enter.";
}
else {
$postgil = ($gilamt - $giladd);
$DB_site->query("UPDATE user SET storep='$postgil' WHERE userid='$bbuserinfo[userid]'");
$DB_site->query("INSERT INTO contest_entries (id,userid,contestid) VALUES (NULL,$bbuserinfo[userid],$contestid)");
$contestbody .= "You have entered this contest.";
}
eval("dooutput(\"".gettemplate("contest_main")."\");");
}
} 


I haven't tested this, but it should work.:bunny:

[BigJohnson]

O it worked great. This is a great hack. Thanks so much. I think you should update the first post for everyone with this update this is a great update thanks so much you are the greatest.