* $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';
} // END - if
// Load referral points
- $result_points = SQL_QUERY_ESC('SELECT
+ $result_points = sqlQueryEscaped('SELECT
' . getAllPointColumns('p.', ',') . '
`r`.`counter`
FROM
), __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);
} // END - while
// Free memory
-SQL_FREERESULT($result_depths);
+sqlFreeResult($result_depths);
// Add userid
$content['userid'] = getMemberId();