Renamed 'comma_def' to 'max_comma' to fit with configuration entry

[mailer.git] / inc / modules / admin / what-list_user_amounts.php

diff --git a/inc/modules/admin/what-list_user_amounts.php b/inc/modules/admin/what-list_user_amounts.php
index 76523825fcd3b637f400f6634316544a9959c6c9..cb6958a305fea1432c5f117c0c8998d00edbd06a 100644 (file)
--- a/inc/modules/admin/what-list_user_amounts.php
+++ b/inc/modules/admin/what-list_user_amounts.php
@@ -47,7 +47,7 @@ addYouAreHereLink('admin', __FILE__);
 $sql = '';
 foreach (runFilterChain('locked_points_columns_array', array('points')) as $column) {
        // Add it with/-out locked
-       $sql .= 'p.`' . $column . '` + p.`locked_' . $column . '` +';
+       $sql .= '`p`.`' . $column . '` + `p`.`locked_' . $column . '` +';
 } // END - foreach
 
 // Remove last plus
@@ -55,21 +55,21 @@ $sql = substr($sql, 0, -1);
 
 // Run the query to obtain all user's amounts (regardless of their status)
 $result = SQL_QUERY('SELECT
-       p.`userid`,
+       `p`.`userid`,
        SUM(
                ' . $sql . ' -
-               d.`used_points`
+               `d`.`used_points`
        ) AS `points`
 FROM
        `{?_MYSQL_PREFIX?}_user_points` AS `p`
 INNER JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ON
-       d.`userid`=p.`userid`
+       `d`.`userid`=`p`.`userid`
 GROUP BY
-       p.`userid`
+       `p`.`userid`
 ORDER BY
-       p.`userid` ASC', __FILE__, __LINE__);
+       `p`.`userid` ASC', __FILE__, __LINE__);
 
 // Are there entries? (sorry, the XML functions cannot "produce" the above SQL statement)
 if (!SQL_HASZERONUMS($result)) {