X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-list_refs.php;h=e6c5b31f89df9d375bb016bbcd0a56cfefff28ea;hb=ccc4a69ce9b17aa8d7b1554a3b2b017db091821b;hp=4bfaa48adcc307294940a36f8c868253b8f2a573;hpb=81bfbcd72e424060ea1223b49ad92fcfa150f361;p=mailer.git diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php index 4bfaa48adc..e6c5b31f89 100644 --- a/inc/modules/admin/what-list_refs.php +++ b/inc/modules/admin/what-list_refs.php @@ -52,7 +52,7 @@ if (REQUEST_ISSET_GET('uid')) { // Check if the user already exists $result_user = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array($uid), __FILE__, __LINE__); + array($uid), __FILE__, __LINE__); // User found? if (SQL_NUMROWS($result_user) == 1) { @@ -66,9 +66,9 @@ ORDER BY level ASC", __FILE__, __LINE__); } else { // Loads surname, family's name and the email address $result = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s", - array($uid), __FILE__, __LINE__); + array($uid), __FILE__, __LINE__); $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY `userid` ASC", - array($uid), __FILE__, __LINE__); + array($uid), __FILE__, __LINE__); $menge = SQL_RESULT($result , 0, 0); $menge_lck = SQL_RESULT($result_lck, 0, 0); @@ -78,7 +78,7 @@ ORDER BY level ASC", __FILE__, __LINE__); // Query for refs $result_levels = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s ORDER BY userid ASC", - array($uid), __FILE__, __LINE__); + array($uid), __FILE__, __LINE__); // Output info message LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(REQUEST_GET('uid')), $menge, $menge_lck)); @@ -96,16 +96,16 @@ ORDER BY level ASC", __FILE__, __LINE__); if (EXT_IS_ACTIVE('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", - array($uid, $levels['level']), __FILE__, __LINE__); + array($uid, $levels['level']), __FILE__, __LINE__); //* DEBUG: */ echo $uid.'/'.$levels['level'].'/'.SQL_NUMROWS($result_refs)."
\n"; // Do we have levels? if (SQL_NUMROWS($result_refs) > 0) { // Loads surname, family's name and the email address $result = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s", - array($uid), __FILE__, __LINE__); + array($uid), __FILE__, __LINE__); $result_lck = SQL_QUERY_ESC("SELECT COUNT(*) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s AND status != 'CONFIRMED' ORDER BY `userid` ASC", - array($uid), __FILE__, __LINE__); + array($uid), __FILE__, __LINE__); $menge = SQL_RESULT($result , 0, 0); $menge_lck = SQL_RESULT($result_lck, 0, 0); @@ -123,7 +123,7 @@ ORDER BY level ASC", __FILE__, __LINE__); while ($content = SQL_FETCHARRAY($result_refs)) { // Query for data $result_user = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email, status, joined FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array($content['refid']), __FILE__, __LINE__); + array($content['refid']), __FILE__, __LINE__); // Is the data there? if (SQL_NUMROWS($result_user) == 1) { @@ -132,7 +132,7 @@ ORDER BY level ASC", __FILE__, __LINE__); // Check for referals $result_cnt = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s", - array($content['refid']), __FILE__, __LINE__); + array($content['refid']), __FILE__, __LINE__); // Load refs $refs_cnt = SQL_RESULT($result_cnt, 0, 0); @@ -188,7 +188,7 @@ ORDER BY level ASC", __FILE__, __LINE__); } else { // Check for referals $result_refs = SQL_QUERY_ESC("SELECT COUNT(userid) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE refid=%s", - array(bigintval($levels['userid'])), __FILE__, __LINE__); + array(bigintval($levels['userid'])), __FILE__, __LINE__); $refs_cnt = SQL_RESULT($result_refs, 0, 0); SQL_FREERESULT($result_refs);