vb.org Archive - Wluke, buddy - what happened to the karma hack?

Business needs have dictated that I not pursue the Karma hack for my own purposes.

Instead we are developing a new system that will be used as a form of electronic currency in our forum for our members. As such it is not a user rating related feature anymore. Now SitePoint members will earn points (SitePoints, if you will) for contributing to the community. As time goes on they will be able to turn these points in for added member bonuses and discounts on products.

As such, I won't be persuing a simple "Karma" hack anymore. However here is the code that was used for the previous version of the hack. I converted this to PHP after looking at the PERL version written for UBB.

PHP Code:


		
			
<?php



require("global.php");

  $permissions=getpermissions($bbuserid,$bbusergroupid);

  if ($permissions[canreply]!=1) {

    eval("echo dovars(\"".gettemplate("karma_nopermission")."\");");

    exit;

  }



// ############################### Start Karma ###############################

if ($action=="karma") {

  //Make sure a user can't give karma on their own posts.

  if ($posterid==$bbuserid) {

    $points=$DB_site->query_first("Select karma from user where userid=$bbuserid");

    $karmicavg=$DB_site->query_first("SELECT SUM(rank) as netrank from karma where postid=$postid");

    $karmicbal=$karmicavg[netrank];

    $karma=$points[karma];

    if ($karmicbal>0) {

      $karmicmsg="Your Karma on this post is positive.";

    } elseif ($karmicbal<0) {

      $karmicmsg="Your Karma on this post is negative.";

    } elseif ($karmicbal==0 || $karmicbal==NULL) {

      $karmicmsg="There is no Karma on this post.";

    }

    eval("echo dovars(\"".gettemplate("karma_show")."\");");

    exit;

  }

  // Make Sure Karma is only given once per post.

  $karmaexists=$DB_site->query_first("Select count(*) as count from karma where userid=$bbuserid and postid=$postid");

  if ($karmaexists[count]<>0) {

    eval("echo dovars(\"".gettemplate("karma_exists")."\");");

    exit;

  }



  $userinfo=$DB_site->query_first("SELECT user.userid,post.userid as posterid,user.username as username

                                   FROM user LEFT JOIN post ON (user.userid = post.userid)

                                   WHERE post.postid=$postid");

  $postname=$userinfo[username];

  $posterid=$userinfo[posterid];

  $userid=$bbuserid;

  eval("echo dovars(\"".gettemplate("karma")."\");");

  exit;

}



// ############################### Update Karma ###############################

if ($action=="alter") {

 if ($comments=="No Comment") {

   $comments="";

 }



 $posterinfo=$DB_site->query_first("SELECT karma from user where userid=$posterid");

 $karma=$posterinfo[karma];

 $userinfo=$DB_site->query_first("SELECT posts from user where userid=$userid");

 $posts=$userinfo[posts];

 if ($posts > 1499)

   { $karmaaward=15; }

 elseif ($posts > 199)

   { $karmaaward=floor($posts/100); }

 else

   { $karmaaward=1; }



 $rank=0;

 if ($adjust=="praise")

   {$karma += $karmaaward;$rank += $karmaaward;}

 else

   {$karma -= $karmaaward;$rank -= $karmaaward;}

 if ($karma > $maxkarma)

   {$karma = $maxkarma;}

 if ($karma < $minkarma)

   {$karma = $minkarma;}

 $DB_site->query("UPDATE user SET karma=$karma where userid=$posterid");

 $DB_site->query("INSERT INTO karma (postid,userid,rank,comments,posterid) VALUES ($postid,$userid,$rank,'".addslashes($comments)."',$posterid)");

 //$DB_site->query("INSERT INTO karma (postid,userid,rank) VALUES ($postid,$userid,$rank)");

 eval("echo dovars(\"".gettemplate("karma_close")."\");");

 exit;

}



// ############################### Karma Help###############################

if ($action="help") {

    eval("echo dovars(\"".gettemplate("karma_help")."\");");

    exit;

  }



// ############################### View Comments ###############################

if ($action=="comments") {

  exit;

}

?>

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (2)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:

X vBulletin 3.8.12 by vBS Debug Information

Page Generation 0.02489 seconds
Memory Usage 1,772KB
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
(1)bbcode_php_printable
(2)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:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02489 seconds Memory Usage 1,772KB 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 (1)bbcode_php_printable (2)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: