X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_sponsor.php;h=af6d22ea558275992c858c04b548ebd3e4d7419c;hp=74bd7e8ce913676eee5cbe2d93cf4d3064d98e09;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=db0c6702086eea2c44d0aae1702dc2e77a0afc4e diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php index 74bd7e8ce9..af6d22ea55 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 - 2015 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), @@ -56,7 +56,7 @@ if (isFormSent()) { ); // Load his personal data - $result_main = SQL_QUERY_ESC("SELECT + $result_main = sqlQueryEscaped("SELECT `id`, `gender`, `surname`, `family`, `email`, `remote_addr`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`, `points_amount`, `points_used`, @@ -70,36 +70,40 @@ WHERE LIMIT 1", array($content['id']), __FILE__, __LINE__); - /// Is there an entry? - if (SQL_NUMROWS($result_main) == 1) { + // Is there an entry? + if (sqlNumRows($result_main) == 1) { // Load data - $content = SQL_FETCHARRAY($result_main); + $content = sqlFetchArray($result_main); // Check for open payments and close them - $result = SQL_QUERY_ESC("SELECT - so.admin_id, so.pay_count, - UNIX_TIMESTAMP(so.pay_ordered) AS `pay_ordered`, - so.pay_status, sp.pay_name, sp.pay_rate, sp.pay_currency + $result = sqlQueryEscaped("SELECT + `so`.`admin_id`, + `so`.`pay_count`, + UNIX_TIMESTAMP(`so`.`pay_ordered`) AS `pay_ordered`, + `so`.`pay_status`, + `sp`.`pay_name`, + `sp`.`pay_rate`, + `sp`.`pay_currency` FROM - `{?_MYSQL_PREFIX?}_sponsor_orders` AS so + `{?_MYSQL_PREFIX?}_sponsor_orders` AS `so` LEFT JOIN - `{?_MYSQL_PREFIX?}_sponsor_paytypes` AS sp + `{?_MYSQL_PREFIX?}_sponsor_paytypes` AS `sp` ON - sp.id=so.payment_id + `sp`.`id`=`so`.`payment_id` WHERE - so.sponsor_id=%s + `so`.`sponsor_id`=%s ORDER BY - sp.pay_name ASC", + `sp`.`pay_name` ASC", array($content['id']), __FILE__, __LINE__); - if (!SQL_HASZERONUMS($result)) { + if (!ifSqlHasZeroNumRows($result)) { // Payment does exist - while ($content2 = SQL_FETCHARRAY($result)) { + while ($content2 = sqlFetchArray($result)) { // Merge both arrays $content = merge_array($content, $content2); // Set default email $content['email'] = '{--SPONSOR_NO_ADMIN--}'; - if ($content['admin_id'] > 0) { + if (isValidId($content['admin_id'])) { // Load admin's email address for contact $content['email'] = getAdminEmail($content['admin_id']); } // END - if @@ -121,18 +125,18 @@ ORDER BY } // Free memory - SQL_FREERESULT($result); + sqlFreeResult($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; } // Free memory - SQL_FREERESULT($result_main); + sqlFreeResult($result_main); // Unlock sponsor account - SQL_QUERY_ESC("UPDATE + sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='CONFIRMED' @@ -142,42 +146,48 @@ WHERE LIMIT 1", array($content['id']), __FILE__, __LINE__); - // Update, if applyable, referal count and points - if ((isValidUserId($content['refid'])) && ($content['refid'] != $content['id'])) { - // Update referal account - SQL_QUERY_ESC("UPDATE + // Update, if applyable, referral count and points + if ((isValidId($content['refid'])) && ($content['refid'] != $content['id'])) { + // Update referral account + sqlQueryEscaped("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", array(bigintval($content['refid'])), __FILE__, __LINE__); // Whas that update fine? - if (!SQL_HASZEROAFFECTED()) { - // Load referal's data - $result = SQL_QUERY_ESC("SELECT - `id`, `gender`, `surname`, `family`, `email`, - (`points_amount` - `points_used`) AS points, - `receive_warnings`, `ref_count` AS refs + if (!ifSqlHasZeroAffectedRows()) { + // Load referral's data + $result = sqlQueryEscaped("SELECT + `id`, + `gender`, + `surname`, + `family`, + `email`, + (`points_amount` - `points_used`) AS `points`, + `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 = sqlFetchArray($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 - SQL_FREERESULT($result); + sqlFreeResult($result); } // END - if } // END - if @@ -192,7 +202,7 @@ LIMIT 1", } // END - if // Begin listing of all pending sponsor accounts -$result = SQL_QUERY("SELECT +$result = sqlQuery("SELECT `id`, `gender`, `surname`, `family`, `email`, `remote_addr`, UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created` FROM @@ -202,26 +212,26 @@ WHERE ORDER BY `id`", __FILE__, __LINE__); -if (!SQL_HASZERONUMS($result)) { +if (!ifSqlHasZeroNumRows($result)) { // Entries found so let's list them! $OUT = ''; - while ($content = SQL_FETCHARRAY($result)) { + while ($content = sqlFetchArray($result)) { // Translate some data $content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2); // Load row template and switch colors - $OUT .= loadTemplate('admin_unlock_sponsor_row', true, $content); + $OUT .= loadTemplate('admin_unlock_sponsor_row', TRUE, $content); } // END - while // Load template - loadTemplate('admin_unlock_sponsor', false, $OUT); + loadTemplate('admin_unlock_sponsor', FALSE, $OUT); } else { // No pending accounts found displayMessage('{--ADMIN_SPONSOR_NONE_PENDING--}'); } // Free memory -SQL_FREERESULT($result); +sqlFreeResult($result); // [EOF] ?>