Fix for user list in rallye
[mailer.git] / inc / modules / admin / what-list_rallyes.php
index 52bdf868cf619aa80e4b5497424a1a1009a2d71e..b6fdb930c6d3f44067df2d92d2d9d603fa0f0221 100644 (file)
@@ -55,13 +55,13 @@ if (isGetRequestElementSet('rallye')) {
        if (isGetRequestElementSet('activate')) {
                // Activate / deactivate
                switch (getRequestElement('activate')) {
-                       case 1: // Activate
+                       case '1': // Activate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1",
                                        array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
 
-                       case 0: // Deactivate
+                       case '0': // Deactivate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1",
                                        array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
@@ -70,13 +70,13 @@ if (isGetRequestElementSet('rallye')) {
        } elseif (isGetRequestElementSet('notify')) {
                // Automatic notification
                switch (getRequestElement('notify')) {
-                       case 1: // Activate
+                       case '1': // Activate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1",
                                        array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
 
-                       case 0: // Deactivate
+                       case '0': // Deactivate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1",
                                        array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
@@ -85,13 +85,13 @@ if (isGetRequestElementSet('rallye')) {
        } elseif (isGetRequestElementSet('auto')) {
                // Automatic adding of new members
                switch (getRequestElement('auto')) {
-                       case 1: // Activate
+                       case '1': // Activate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='Y' WHERE `id`=%s AND `auto_add_new_user`='N' LIMIT 1",
                                        array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
 
-                       case 0: // Deactivate
+                       case '0': // Deactivate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='N' WHERE `id`=%s AND `auto_add_new_user`='Y' LIMIT 1",
                                        array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
@@ -250,23 +250,17 @@ LIMIT 1",
                        $br = '';
 
                        // Output row
-                       if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = "<strong>"; $br = "</strong>"; }
-                       if (($row['refs'] > 0) || ($cnt > 0)) {
-                               // Insert link to referal list
-                               //* DEBUG: */ outputHtml('-'.$row['userid'].'/'.$cnt.'/'.$row['refs']."-<br />");
-                               $cnt = generateUserProfileLink($row['userid'], $cnt, 'list_refs');
-                               $row['refs'] = generateUserProfileLink($row['userid'], $row['refs'], 'list_refs');
-                       } // END - if
+                       if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = '<strong>'; $br = '</strong>'; }
 
                        // Get user points
                        $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1");
                        //* DEBUG: */ outputHtml(basename(__FILE__).":userid={$row['userid']},points={$points},opoints={$row['curr_points']}<br />");
 
                        // Prepare content
-                       // @TODO Rewritings: userid->userid,opoints->curr_points,old->refs in template
+                       // @TODO Rewritings: opoints->curr_points,old->refs in template
                        $row = array(
                                'sw'      => $SW ,
-                               'userid'     => $row['userid'],
+                               'userid'  => $row['userid'],
                                'bold_l'  => $bl ,
                                'bold_r'  => $br ,
                                'old'     => $row['refs'],
@@ -279,11 +273,15 @@ LIMIT 1",
                        $SW = 3 - $SW;
                } // END - while
 
+               // Remember rows
+               $content['rows']   = $OUT;
+               $content['rallye'] = getRequestElement('rallye');
+
                // Free memory
                SQL_FREERESULT($result);
 
                // Load template
-               loadTemplate('admin_list_rallye_usr', false, $OUT);
+               loadTemplate('admin_list_rallye_usr', false, $content);
        } else {
                // No entries found?
                loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ADMIN_USERS_404'));
@@ -323,7 +321,7 @@ ORDER BY
                        $row = array(
                                'select'     => "<input type=\"checkbox\" name=\"sel[".$data['id']."]\" class=\"admin_normal\" value=\"1\" />",
                                'admin_id'   => $data['admin_id'],
-                               'email_link' => generateEmailLink($data['admin_id']),
+                               'admin_link' => generateAdminLink($data['admin_id']),
                                'login'      => $data['login'],
                                'id'         => $data['id'],
                                'sw'         => $SW,