X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=831b2827924d2ffd0e37f6db99c03890881c125d;hb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb;hp=b70f6b73a5230fb1299575a2fafe652054f12a14;hpb=f4d7dc336fde4cebc47701026a94d193f77854a1;p=mailer.git diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php index b70f6b73a5..831b282792 100644 --- a/inc/modules/admin/what-unlock_sponsor.php +++ b/inc/modules/admin/what-unlock_sponsor.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 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 * @@ -48,7 +48,7 @@ if (isFormSent()) { // Does he have selected at least one sponsor? if (ifPostContainsSelections('id')) { // At least one entry selected - foreach (postRequestParameter('id') as $id => $selected) { + foreach (postRequestElement('id') as $id => $selected) { // Secure id number and init $content $content = array( 'id' => bigintval($id), @@ -99,7 +99,7 @@ ORDER BY // Set default email $content['email'] = '{--SPONSOR_NO_ADMIN--}'; - if ($content['admin_id'] > 0) { + if (isValidUserId($content['admin_id'])) { // Load admin's email address for contact $content['email'] = getAdminEmail($content['admin_id']); } // END - if @@ -124,7 +124,7 @@ ORDER BY SQL_FREERESULT($result); } else { // Not found - displayMessage(getMaskedMessage('ADMIN_SPONSOR_ACCOUNT_404_ALREADY_CONFIRMED', $content['id'])); + displayMessage('{%message,ADMIN_SPONSOR_ACCOUNT_404_ALREADY_CONFIRMED=' . $content['id'] . '%}'); return; } @@ -142,13 +142,14 @@ WHERE LIMIT 1", array($content['id']), __FILE__, __LINE__); - // Update, if applyable, referal count and points + // Update, if applyable, referral count and points if ((isValidUserId($content['refid'])) && ($content['refid'] != $content['id'])) { - // Update referal account + // Update referral account SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET - `points_amount`=`points_amount`+{?sponsor_ref_points?}, `ref_count`=`ref_count`+1 + `points_amount`=`points_amount`+{?sponsor_ref_points?}, + `ref_count`=`ref_count`+1 WHERE `id`=%s LIMIT 1", @@ -156,24 +157,29 @@ LIMIT 1", // Whas that update fine? if (!SQL_HASZEROAFFECTED()) { - // Load referal's data + // Load referral's data $result = SQL_QUERY_ESC("SELECT - `id`, `gender`, `surname`, `family`, `email`, + `id`, + `gender`, + `surname`, + `family`, + `email`, (`points_amount` - `points_used`) AS `points`, - `receive_warnings`, `ref_count` AS refs + `receive_warnings`, + `ref_count` AS `refs` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1", array(bigintval($content['refid'])), __FILE__, __LINE__); - $REFERAL = SQL_FETCHARRAY($result); + $REFERRAL = SQL_FETCHARRAY($result); // Send warnings out? - if ($REFERAL['receive_warnings'] == 'Y') { - // Send notification to referal - $REFERAL_MSG = loadEmailTemplate('sponsor_ref_notify', $REFERAL); - sendEmail($REFERAL['email'], '{--SPONSOR_REFERAL_NOTIFY_SUBJECT--}', $REFERAL_MSG); + if ($REFERRAL['receive_warnings'] == 'Y') { + // Send notification to referral + $REFERRAL_MSG = loadEmailTemplate('sponsor_ref_notify', $REFERRAL); + sendEmail($REFERRAL['email'], '{--SPONSOR_REFERRAL_NOTIFY_SUBJECT--}', $REFERRAL_MSG); } // END - if // Free memory