| SimplyBen |
08-26-2006 05:59 AM |
Give Points to Thread Starter per Reply
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!
Code:
<?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_enough_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..
Code:
$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..
Code:
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..
Code:
WHERE userid = '" . $vbulletin->userinfo['userid'] . "'
Again, thanks for any help. |
More Information