Parser error fixed + some empty lines added between table rows (tr)

[mailer.git] / inc / modules / member / what-points.php

diff --git a/inc/modules/member/what-points.php b/inc/modules/member/what-points.php
index f6f5d598404259c617a3f4b489532f8a994e187b..b18a3d13c692bb4dcd1ccc673d05665516c72a6a 100644 (file)
--- a/inc/modules/member/what-points.php
+++ b/inc/modules/member/what-points.php
@@ -16,7 +16,7 @@
  * $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 *
@@ -52,10 +52,10 @@ if ((!isExtensionActive('user')) && (!isAdmin())) {
 } // 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?
@@ -82,7 +82,7 @@ $content['part_locked_order']   = '0.00000';
 $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';
@@ -94,24 +94,24 @@ while ($data = SQL_FETCHARRAY($result_depths)) {
        $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(
@@ -120,9 +120,9 @@ LIMIT 1',
                ), __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'];
@@ -139,14 +139,14 @@ LIMIT 1',
        } // 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();