* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
} // END - if
// Query for referral levels and percents
-$result_depths = SQL_QUERY('SELECT `level`,`percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY `level` ASC', __FILE__, __LINE__);
+$result_depths = sqlQuery('SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` ORDER BY `level` ASC', __FILE__, __LINE__);
// Get total depths
-$numDepths = SQL_NUMROWS($result_depths);
+$numDepths = sqlNumRows($result_depths);
// Add many more rows for the login/turbo/ref/order bonus
// @TODO Should we rewrite this to a filter?
$OUT = '';
// Load ref levels
-while ($data = SQL_FETCHARRAY($result_depths)) {
+while ($data = sqlFetchArray($result_depths)) {
// Init points and counter here
$content['counter'] = '0';
$content['points'] = '0.00000';
$content = merge_array($content, $data);
// Default for referral level > 0
- $depth = 'p.`ref_depth`=%s';
+ $depth = '`p`.`ref_depth`=%s';
if (is_null($content['level'])) {
- $depth = 'p.`ref_depth` IS NULL';
+ $depth = '`p`.`ref_depth` IS NULL';
} // END - if
// Load referral points
- $result_points = SQL_QUERY_ESC('SELECT
+ $result_points = sqlQueryEscaped('SELECT
' . getAllPointColumns('p.', ',') . '
- r.`counter`
+ `r`.`counter`
FROM
- `{?_MYSQL_PREFIX?}_user_points` AS p
+ `{?_MYSQL_PREFIX?}_user_points` AS `p`
LEFT JOIN
- `{?_MYSQL_PREFIX?}_refsystem` AS r
+ `{?_MYSQL_PREFIX?}_refsystem` AS `r`
ON
- p.`userid`=r.`userid` AND
- p.`ref_depth`=r.`level`
+ `p`.`userid`=`r`.`userid` AND
+ `p`.`ref_depth`=`r`.`level`
WHERE
- p.`userid`=%s AND
+ `p`.`userid`=%s AND
' . $depth . '
LIMIT 1',
array(
), __FILE__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result_points) == 1) {
+ if (sqlNumRows($result_points) == 1) {
// Load data
- $content = merge_array($content, SQL_FETCHARRAY($result_points));
+ $content = merge_array($content, sqlFetchArray($result_points));
// Add locked-/points
$content['part_points'] += $content['points'];
} // END - if
// Free result
- SQL_FREERESULT($result_points);
+ sqlFreeResult($result_points);
// Output row
- $OUT .= loadTemplate('member_points_row', true, $content);
+ $OUT .= loadTemplate('member_points_row', TRUE, $content);
} // END - while
// Free memory
-SQL_FREERESULT($result_depths);
+sqlFreeResult($result_depths);
// Add userid
$content['userid'] = getMemberId();
$content['bonus_total_points'] = getUserData('turbo_bonus') + getUserData('login_bonus') + getUserData('bonus_ref') + getUserData('bonus_order') + getUserData('bonus_stats');
// Output rows
- $content['special_rows'] = loadTemplate('member_points_bonus_rows', true, $content);
+ $content['special_rows'] = loadTemplate('member_points_bonus_rows', TRUE, $content);
} elseif ((isExtensionActive('bonus')) && (!isBonusRallyeActive())) {
// Bonus active rallye deactivated
- $content['special_rows'] = loadTemplate('member_points_bonus_disabled', true);
+ $content['special_rows'] = loadTemplate('member_points_bonus_disabled', TRUE);
} elseif ((isAdmin()) && (isExtensionInstalledAndOlder('bonus', '0.2.2')) && (isExtensionActive('bonus'))) {
// Please upgrade your bonus extension to v0.2.2 or newer!
$content['special_rows'] = loadTemplate('member_points_upgrade');
// Load final template
if (isExtensionActive('user')) {
// Load template when required extension is there
- loadTemplate('member_points', false, $content);
+ loadTemplate('member_points', FALSE, $content);
} elseif (isAdmin()) {
// Missing extension
displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=user%}');