Log in

View Full Version : Give Points to Thread Starter per Reply


SimplyBen
08-26-2006, 05:59 AM
I was wondering if anyone could tell me what values I must insert to give points or vbbux as my mod refers to them to the started of the thread everytime someone makes a reply to the thread. I have provided my code so far and will highlight the part I am stumped on. Thanks for any help, if this is in the wrong forum, sorry!

<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vbPlaza Integrated Store System for vBulletin 3.5+ # ||
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ?2006 GSCCC, Inc. # ||
|| # http://www.cmgsccc.com # ||
|| ################################################## ################## ||
\*================================================ ======================*/

// check to make sure VB_AREA is defined
$ben = 10;
if (defined('VB_AREA'))
{


// check if it's enabled first
if ($vbulletin->options['vbbux_enabled'] == 1)
{
// include the vbplaza functions
include_once(DIR . '/includes/functions_vbplaza.php');

// calculate the amount of points to give
$givepoints = vbplaza_calculate_post_points($post, $foruminfo['forumid'], $type);

// check if it should send the query
if ($givepoints != 0)
{
// verify they have enough points to do this action
if (($vbulletin->userinfo[$vbulletin->options['vbbux_pointsfield']] + $givepoints) < 0)
{
// display error, not enough points
eval(standard_error(fetch_error('vbplaza_not_enoug h_points')));
}

// send the query to give the points
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . $vbulletin->options['vbbux_pointstable'] . "
SET
`" . $vbulletin->options['vbbux_pointsfield'] . "` = `" . $vbulletin->options['vbbux_pointsfield'] . "` + " . $ben . "
WHERE userid = '" . $threadinfo['postuserid'] . "'
AND vbp_receivespoints = '1'
");

// check if this user was referred by anyone
/* if (($vbulletin->options['vbbux_perreferralactions'] != 0) && ($vbulletin->userinfo['referrerid'] > 0))
{
// multiply the $givepoints by the perreferralactions multiplier
$givepoints = $givepoints * $vbulletin->options['vbbux_perreferralactions'];

// send the query to give the points to this user
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . $vbulletin->options['vbbux_pointstable'] . "
SET
`" . $vbulletin->options['vbbux_pointsfield'] . "` = `" . $vbulletin->options['vbbux_pointsfield'] . "` + " . $givepoints . "
WHERE userid = '" . $vbulletin->userinfo['referrerid'] . "'
AND vbp_receivespoints = '1'
");
} */
}
}
}
?>

I have commented out the referral points part of the mod, but I do plan to use it later. The sql query I am attempting to use to give the thread starter points is..
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . $vbulletin->options['vbbux_pointstable'] . "
SET
`" . $vbulletin->options['vbbux_pointsfield'] . "` = `" . $vbulletin->options['vbbux_pointsfield'] . "` + " . $ben . "
WHERE userid = '" . $threadinfo['postuserid'] . "'
AND vbp_receivespoints = '1'
");

I changed one aspect of this code from the reply modification used in vbbux/vbplaza..
WHERE userid = '" . $threadinfo['postuserid'] . "'

Please enlighten me on how to recognize the thread starter as the user to giv the point to. When I use the original code, it does work by giving the person who replied their set points.. original code is..
WHERE userid = '" . $vbulletin->userinfo['userid'] . "'

Again, thanks for any help.