vb.org Archive - 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!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01267 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: