// Some security stuff...
if (!defined('__SECURITY')) {
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
require($INC);
}
function AUTOPURGE_ADD_POINTS($uid, $points) {
// Check if he has locked points or not
- $result = SQL_QUERY_ESC("SELECT ref_payout FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `ref_payout` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid`=%s LIMIT 1",
array(bigintval($uid)), __FUNCTION__, __LINE__);
list($payout) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
if (($payout > 0) && (!empty($payout))) {
// Yes, he has.
- $target = "locked_points";
- } elseif ($payout == "0") {
+ $target = 'locked_points';
+ } elseif ($payout == '0') {
// No, he has not
- $target = "points";
+ $target = 'points';
}
// Add points...
$jackpot += $points;
} else {
// .. to user's account
- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_points` SET %s=%s+%s WHERE userid=%s AND ref_depth=0 LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_points` SET `%s`=`%s`+%s WHERE `userid`=%s AND `ref_depth`=0 LIMIT 1",
array($target, $target, $points, bigintval($uid)), __FUNCTION__, __LINE__);
// Update mediadata as well
- if ((GET_EXT_VERSION("mediadata") >= "0.0.4") && ($target == "points")) {
+ if ((GET_EXT_VERSION('mediadata') >= '0.0.4') && ($target == 'points')) {
// Update database
- MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
- }
+ MEDIA_UPDATE_ENTRY(array('total_points'), 'add', $points);
+ } // END - if
// Send out mail to user
- $msg = LOAD_EMAIL_TEMPLATE("member_autopurge_points", TRANSLATE_COMMA($points), $uid);
- SEND_EMAIL($uid, AUTOPURGE_MEMBER_SUBJECT, $msg);
+ $message = LOAD_EMAIL_TEMPLATE('member_autopurge_points', translateComma($points), $uid);
+ sendEmail($uid, getMessage('AUTOPURGE_MEMBER_SUBJECT'), $message);
}
}