Points Addon for Profile Comments

Points add on for the Profile Commenting System coded by Danny.VBT

This small add on lets you add or deduct points for new profile comments. You can use this with ebux, ucash, or any other system by changing the table and field info in the variable below.

QUICK NOTE: If your actually using decimals, this may round off the users points to the nearest whole #.

This is more or less all I needed but the same code could probably be reused for editing and deleting comments as well. If you want to enchance this in any way, by all means feel free to do so.

Step 1: Create a new phrase
(admincp -> languages and phrases -> phrase manager -> add new phrase)

Phrase Type: front end error messages
Product: vbulletin
Varname: error_not_enough_points
Text: Sorry but you do not have enough points to complete this action.

Step 2: Edit the "[Comments] Add Comment" plugin
(admincp -> Plugin System -> Plugin Manager)

Step 3: Add this code at the very top.

• Change the cost to whatever you would like. Negative #'s deduct points. Postive #'s add points.
• Change the table and field your points are stored in. If your are using ebux and do not have a table prefix, leave it alone.

PHP Code:

    /* **** Begin Points Hack **** */
    
    // Lets define some variables. 
    $cost = -10; // use negative numbers to deduct points for adding a comment
    
    // Where are your points stored? This is a default ebux without table prefix.
    $pointstable = 'user';                         // This is the table where the points are stored 
    $fieldx      = 'ebux';                        // This is the field where users points are stored
    
    /* **** End Points Hack **** */ 


Step 4: Look for this code in the plugin

PHP Code:

    $addcomment = $db->query_write("INSERT into " . TABLE_PREFIX . "space_comments (comment_title, comment_text, comment_date,  commenter_id, userid, commenter_name)
                                            VALUES ('" . $db->escape_string($vbulletin->GPC['title']) . "','" . $db->escape_string($parsed_text) . "','" . TIMENOW . "','" . $vbulletin->userinfo['userid'] . "', '" . $vbulletin->GPC['u'] . "','" . $vbulletin->userinfo['username'] . "')
                                          "); 


Step 5: Below that, add the following

PHP Code:

    /***** Begin Points Hack *****/
    
    // OKAY NO MORE EDITING! Lets begin doing points stuff
    
    // Lets see how many points the user has to start with
    $userpointsqry = $db->query_first("
        SELECT $fieldx FROM $pointstable 
        WHERE userid = " . $vbulletin->userinfo['userid'] . "
    ");
    
    $userpoints = (int) $userpointsqry + 0;
    
    //Lets do a quick check to see if they have enough points. 
    
    if ($cost < 0)
        {
        if ($userpoints < abs($cost))
            {
            eval(standard_error(fetch_error('error_not_enough_points')));
            }
        }
    
    // A little math to add/subtract the cost from the users existing points.
    $amt = $userpoints + $cost;
    
    
    // Lets update the users points now that they have made a comment
    $db->query_write("
        UPDATE $pointstable SET
        $fieldx =  '" . $db->escape_string($amt) . "'
        WHERE userid =  " . $vbulletin->userinfo['userid']   . "
    ");
    /***** End Points Hack *****/ 


Step 6: Save it and your done!

[mholtum]

hmmm I am not seeing Front End Error Messages..

Could be a problem..

[amizone143]

any screenshot bro

[Snake]

Thanks man, this is quite nice as I've just installed eStore and removed uShop. lol

[Reeve of shinra]

amizone143: nothing to take a screen shot of. This just adds/subtracts points, trying together to already existing and great mods.

[The Chief]

lookin good, I will definaetly try this out later on, when Danny upgrades the comments system

[trackpads]

Ok, got a problem, instead of adding the points it replaces the points on hand with the number that I said to add by.

Help!

[trackpads]

Originally Posted by trackpads

Ok, got a problem, instead of adding the points it replaces the points on hand with the number that I said to add by.

Help!

Also, still doing it, it takes the number I put in the hack (+10) and replaces the onhand points with that number +2.

Any ideas?

[vbreal]

i guess this didnt work to well

[vbreal]

did this ever work?