Reward System: Point based

[Palmer ofShinra]

Well, after some time, I threw a simple version of this hack together for our board.

It's nothing fancy and pretty well completely tweaked for our specific setup.

But really, it's quite simple.

The short way to do it...

Add a Custom User Field. Call it Bonus Points or something.

Remember which field number it is (ours was 5, the first custom field we made)

Now, edit the Postbit template.
Right after where it says
Posts: $post[posts]

add
[pre]<br><a href="http://www.myboard.com/board/mod/points.php?action=points&userid=$post[userid]" target=_blank>Points: $post[field5]</a>[/pre]
(change field5 to whichever number matches)

This displays the total points the user has and adds a link (opening in a new window) to give them points.

Then points.php should look something like this

PHP Code:

<?php

error_reporting(7);

require("./global.php");

cpheader("<title>Your Title Here</title>");
echo "<p>";

$perms=getpermissions();
if (!$perms[ismoderator] and !$ismod=$DB_site->query_first("SELECT * FROM moderator WHERE userid=$bbuserinfo[userid]")) {
    echo "<p>You do not have permission to do this!</p>";
    exit;
  }
if ($action=="points") {
$user=$DB_site->query_first("SELECT username FROM user WHERE userid='$userid'");
doformheader("points","dopoints");
maketableheader("Give Points to $user[username]");
makehiddencode("userid",$userid);
makehiddencode("username",$user[username]);
makeinputcode("Points to give","amount","");
doformfooter("Submit Points");
}

if ($HTTP_POST_VARS['action']=="dopoints") {
$userpointstr=$DB_site->query_first("SELECT field5 FROM userfield WHERE userid=$userid");
$userpoints = (int) $userpointstr[field5];
$amount = (int) $amount;
$pointstr = ($userpoints + $amount);
$DB_site->query("UPDATE userfield SET field5='$pointstr' WHERE userid=$userid");
echo "$username has been given $amount Points successfully.<br>";
}

cpfooter();
?>

Put this PHP file, named points.php, into your MOD folder.

Now that you have that... you have your basic Points giving and displaying down.
You can use the query

$userpointstr=$DB_site->query_first("SELECT field5 FROM userfield WHERE userid=$userid");

to fetch a user's current points anytime... what you do with that number is up to you.

On our fr\orum, the points (Called "Gil") are used as a virtual currency to buy things like custom titles and avatars.
I have a completely automated system for that set up too.