X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-del_sponsor.php;h=0efe1821d87a70438bc044bf0817ef84450a05e3;hp=0ffab7d914891a5a466b022e6b402a9bf58acd8b;hb=155492a5b96cec674846973a8524238b0365a848;hpb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86 diff --git a/inc/modules/admin/what-del_sponsor.php b/inc/modules/admin/what-del_sponsor.php index 0ffab7d914..0efe1821d8 100644 --- a/inc/modules/admin/what-del_sponsor.php +++ b/inc/modules/admin/what-del_sponsor.php @@ -45,13 +45,13 @@ addYouAreHereLink('admin', __FILE__); if (isGetRequestElementSet('id')) { // Check for selected sponsor - $result = SQL_QUERY_ESC("SELECT `id`, `email`, `gender`, `surname`, `family` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1", + $result = sqlQueryEscaped("SELECT `id`, `email`, `gender`, `surname`, `family` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1", array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // Remove sponsor if (isFormSent()) { // Load data and remember it in constants - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); // Prepare data for the template $content['reason'] = postRequestElement('reason'); @@ -61,11 +61,11 @@ if (isGetRequestElementSet('id')) { sendEmail($content['email'], '{--ADMIN_SPONSOR_DELETE_SUBJECT--}', $message); // Remove account - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1", + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1", array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); // Remove orders - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_orders` WHERE `sponsor_id`='%s' LIMIT 1", + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_orders` WHERE `sponsor_id`='%s' LIMIT 1", array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); // Output message @@ -75,7 +75,7 @@ if (isGetRequestElementSet('id')) { redirectToUrl('modules.php?module=admin&what=list_sponsor&id='.bigintval(getRequestElement('id'))); } else { // Load data - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); // Transfer data to constants for the template $content['userid'] = bigintval(getRequestElement('id')); @@ -89,7 +89,7 @@ if (isGetRequestElementSet('id')) { } // Free result - SQL_FREERESULT($result); + sqlFreeResult($result); } else { // Not called by what-list_sponsor.php displayMessage('{--ADMIN_CALL_NOT_DIRECTLY--}');