User Points System

UPDATE: Code tested on both 2.0.3 and 2.2.0

Install instructions updated to reflect differences in versions.

Ability to specify Text values for points directly added.
=====================

As requested in this thread ( http://vbulletin.org/forum/showthrea...threadid=23114 )

This hack includes a small script and instructions on how to install and set up the system.

Purpose: Just a simple engine that allows mods and admins to award arbitrary points to users, which will be displayed under their names/avatars.

The points can be named anything you wish, and represent anything you choose. You can use the script to add or subtract them.

As the script utilizes a Custom Profile Field, the point field can be directly edited in the CP when editing a user, allowing you to place text in the field rather than merely a number.

On our forum, the points are called Gil and represent our virtual currency

It is used to purchase perks like Custom Titles and avatars.

Our staff, having no use for Gil, instead like to have snappy quotes in the field, like "I send greetings of death!!!" (Reno) and "Who needs Gil when you have power?" (Sephiroth)

[black]

if u only want admins to do it just simply dont do the part palmer added

NICE HACK!!!!! I NEEDED THIS

[Reeve of shinra]

First, back up your forum!

To set the defaul value as zero this is what you need to do:

1. Find out the # of the custom field you created to use for the 'points' (you should already know this if its installed).

2. Go into PhPmyAdmin (which your webhost likely provides).

3. On the left frame should be a list of databases, look for vbulletin, or VB, or forum or whatever you set yours up as during the install.

4. Click the plus button to expand the directory for your VB and look for a link that says 'userfield' and click on it.

5. The right frame should now have a list of all your custom profile fields. Look for the one you created. If this was your first it should be field5.

6. Click 'change'

7. Where is says 'TYPE' click the drop down box under it and change it to 'INT'

8. Change 'Null' to 'Not Null'

9. For 'Default' Put in 0.

Click Save and your set.

[Palmer ofShinra]

Originally posted by Lesane
Thanks for this great Hack Palmer, one question: What to do if i only want that admins can give points?

In points.php

Replace

PHP Code:

$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;
  } 


With

PHP Code:

if (!$bbuserinfo[usergroupid]==6) {
    echo "<p>You do not have permission to do this!</p>";
    exit;
  } 


In moderator.php

Replace

PHP Code:

if ($action=="points") {

  $userid = verifyid("user",$userid);

  $permissions=getpermissions();
  if ($permissions[ismoderator] or $ismod=$DB_site->query_first("SELECT * FROM moderator WHERE userid=$bbuserinfo[userid] AND canviewprofile=1")) 


With

PHP Code:

if ($action=="points") {

  $userid = verifyid("user",$userid);

if (!$bbuserinfo[usergroupid]==6) 


[Lesane]

Originally posted by Reeve of shinra
First, back up your forum!

To set the defaul value as zero this is what you need to do:

1. Find out the # of the custom field you created to use for the 'points' (you should already know this if its installed).

2. Go into PhPmyAdmin (which your webhost likely provides).

3. On the left frame should be a list of databases, look for vbulletin, or VB, or forum or whatever you set yours up as during the install.

4. Click the plus button to expand the directory for your VB and look for a link that says 'userfield' and click on it.

5. The right frame should now have a list of all your custom profile fields. Look for the one you created. If this was your first it should be field5.

6. Click 'change'

7. Where is says 'TYPE' click the drop down box under it and change it to 'INT'

8. Change 'Null' to 'Not Null'

9. For 'Default' Put in 0.


Click Save and your set.

That worked great, thanks "Palmer of Shinra".

[Lesane]

Originally posted by Palmer ofShinra


In points.php

Replace

PHP Code:

$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;
  } 


With

PHP Code:

if (!$bbuserinfo[usergroupid]==6) {
    echo "<p>You do not have permission to do this!</p>";
    exit;
  } 


In moderator.php

Replace

PHP Code:

if ($action=="points") {

  $userid = verifyid("user",$userid);

  $permissions=getpermissions();
  if ($permissions[ismoderator] or $ismod=$DB_site->query_first("SELECT * FROM moderator WHERE userid=$bbuserinfo[userid] AND canviewprofile=1")) 


With

PHP Code:

if ($action=="points") {

  $userid = verifyid("user",$userid);

if (!$bbuserinfo[usergroupid]==6) 


Thanks again.

[dotagious]

[QUOTE]Originally posted by Lesane
Is it also possible to give everyone, as default, 0?

[Crinos]

Great hack

Is it possible to "excempt" admins and mods from this user point system? Is it also possible to excempt a particular user group from having user points? Thanks

[Palmer ofShinra]

Exempt them how?

Not have the points show up? Not give them points?

[Crinos]

Well, exempt them so that they are not entitled to points, hence no points will show up in their postbit (or at least, something to the effect of "N/A" instead of the user points themselves).

I have mods and staffers in my site, and I don't want them to take part in the user points system (because it's all to easy to have the mods give points to themselves or to their fellow mods - not that they are doing it but the temptation is there )

Hence, I want administrators, super mods, moderators to be exempted ... also a particular user group (staffers) if it's possible...

Not having them show up in their postbits or getinfo will also work for me, if the above is not possible Thanks!

[squawell]

help me i get this error

Parse error: parse error in c:\apache\htdocs\forum\moderator.php on line 20

what's wrong??that line is }