X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_refs.php;h=ab5e019ec5810f75fb38fe819a0fbfa2b749e5e1;hb=5d4c23d84d3983263b09e6dd084060793b57f973;hp=227f507f8390b55445baba0e8b69b47c67b5b582;hpb=04b69ac9f33369cbf654396c4a42cb1fff710ff4;p=mailer.git diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php index 227f507f83..ab5e019ec5 100644 --- a/inc/modules/admin/what-list_refs.php +++ b/inc/modules/admin/what-list_refs.php @@ -10,17 +10,9 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Alle generierten Refs eines Mitgliedes anzeigen * * -------------------------------------------------------------------- * - * * - * Mod created by : Lars Moehlenbruch ( http://www.surfo.net ) * - * * - * -------------------------------------------------------------------- * - * * - * Highly modified by Roland Haeder * - * * - * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -44,11 +36,11 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); -if (isGetRequestParameterSet('userid')) { +if (isGetRequestElementSet('userid')) { // Secure userid - $userid = bigintval(getRequestParameter('userid')); + $userid = bigintval(getRequestElement('userid')); // Fix missing variable $result_levels = false; @@ -60,11 +52,11 @@ if (isGetRequestParameterSet('userid')) { $menge_lck = countSumTotalData($userid, 'user_data', 'userid', 'refid', true, " AND `status` != 'CONFIRMED'"); // Output info message - loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestParameter('userid')), $menge, $menge_lck)); + displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $menge, $menge_lck)); // Load all referal levels $result_levels = SQL_QUERY("SELECT - `level`, `percents` + `level`,`percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE @@ -73,22 +65,19 @@ ORDER BY `level` ASC", __FILE__, __LINE__); // Are there some levels (VERY BAD IF NONE!) - if (SQL_NUMROWS($result_levels) > 0) { + if (!SQL_HASZERONUMS($result_levels)) { // List all ref levels or entries if no refback is installed - $OUT = ''; $SW = 2; + $OUT = ''; while ($levels = SQL_FETCHARRAY($result_levels)) { - // Insert more data - $levels['sw'] = $SW; - // Is the refback still active? ;-) if (isExtensionActive('refback')) { // Load all refs of this user - $result_refs = SQL_QUERY_ESC("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`='%s' ORDER BY refid ASC", + $result_refs = SQL_QUERY_ESC("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s ORDER BY `refid` ASC", array($userid, $levels['level']), __FILE__, __LINE__); //* DEBUG: */ debugOutput($userid.'/'.$levels['level'].'/'.SQL_NUMROWS($result_refs)); // Do we have levels? - if (SQL_NUMROWS($result_refs) > 0) { + if (!SQL_HASZERONUMS($result_refs)) { // Count entries $menge = countSumTotalData($userid, 'user_data', 'userid', 'refid', true); $menge_lck = countSumTotalData($userid, 'user_data', 'userid', 'refid', true, " AND `status` != 'CONFIRMED'"); @@ -97,7 +86,7 @@ ORDER BY $levels['info'] = sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink($userid), $menge, $menge_lck); // Init variables - $OUT_REFS = ''; $SW = 2; + $OUT_REFS = ''; // Load all refs while ($content = SQL_FETCHARRAY($result_refs)) { @@ -109,7 +98,6 @@ ORDER BY // Prepare data for the template // @TODO Try to rewrite some to EL $content = array( - 'sw' => $SW, 'userid' => getUserData('userid'), 'gender' => getUserData('gender'), 'refs_link' => 0, @@ -121,7 +109,9 @@ ORDER BY ); // Check if referal count is larger 0 and update link - if ($refs_cnt > 0) $content['refs_link'] = generateUserProfileLink(getUserData('userid'), $refs_cnt, 'list_refs'); + if ($refs_cnt > 0) { + $content['refs_link'] = generateUserProfileLink(getUserData('userid'), $refs_cnt, 'list_refs'); + } // END - if // Load template for level one $OUT_REFS .= loadTemplate('admin_list_refs_row', true, $content); @@ -132,9 +122,6 @@ ORDER BY // Add content $levels['rows'] = $OUT_REFS; - - // Switch colors - $SW = 3 - $SW; } // END - while } else { // Output info message @@ -155,7 +142,6 @@ ORDER BY // Prepare data for the template $content = array( - 'sw' => $SW, 'userid' => $levels['userid'], 'gender' => $levels['gender'], 'refs_link' => 0, @@ -171,16 +157,13 @@ ORDER BY // Load template for level one $OUT .= loadTemplate('admin_list_refs_row', true, $content); - - // Switch colors - $SW = 3 - $SW; } } // END - while // Prepare content $content = array( 'rows' => $OUT, - 'userid' => getRequestParameter('userid') + 'userid' => getRequestElement('userid') ); // Load main template @@ -191,17 +174,17 @@ ORDER BY } } elseif (isExtensionActive('refback')) { // No levels found, very bad! - loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_REF_LEVELS--}'); + displayMessage('{--ADMIN_NO_REFERAL_LEVELS--}'); } else { // No refs made so far - loadTemplate('admin_settings_saved', false, '{--USER_REF_404--}'); + displayMessage('{--USER_REFERAL_404--}'); } // Free result SQL_FREERESULT($result_levels); } else { // User not found - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_MEMBER_404', getRequestParameter('userid'))); + displayMessage('{%message,ADMIN_MEMBER_404=' . getRequestElement('userid') . '%}'); } } else { // Output selection form with all confirmed user accounts listed