X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-sub_points.php;h=92d91b275cd3c62796cbd5015f660484ba15c9fc;hp=eb2dd8ea3ff1067443e0a889fee3b12787ee499a;hb=155492a5b96cec674846973a8524238b0365a848;hpb=da5c63bacddced77a951cbe7b223f314885a6c87 diff --git a/inc/modules/admin/what-sub_points.php b/inc/modules/admin/what-sub_points.php index eb2dd8ea3f..92d91b275c 100644 --- a/inc/modules/admin/what-sub_points.php +++ b/inc/modules/admin/what-sub_points.php @@ -50,9 +50,9 @@ if (getRequestElement('userid') == 'all') { $content['points'] = bigintval(postRequestElement('points')); // Load userid - $result_main = SQL_QUERY("SELECT `userid`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC", + $result_main = sqlQuery("SELECT `userid`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC", __FILE__, __LINE__); - while ($row = SQL_FETCHARRAY($result_main)) { + while ($row = sqlFetchArray($result_main)) { // Merge both arrays $content = merge_array($content, $row); @@ -61,7 +61,7 @@ if (getRequestElement('userid') == 'all') { // Prepare content $content = array( - 'reason' => SQL_ESCAPE(postRequestElement('reason')), + 'reason' => sqlEscapeString(postRequestElement('reason')), 'points' => bigintval(postRequestElement('points')), 'subject' => 'admin_sub_all', ); @@ -72,7 +72,7 @@ if (getRequestElement('userid') == 'all') { } // END - while // Free memory - SQL_FREERESULT($result_main); + sqlFreeResult($result_main); // Output message displayMessage('{--ADMIN_ALL_POINTS_SUB_DONE--}'); @@ -92,7 +92,7 @@ if (getRequestElement('userid') == 'all') { // Prepare content $content = array( - 'reason' => SQL_ESCAPE(postRequestElement('reason')), + 'reason' => sqlEscapeString(postRequestElement('reason')), 'points' => bigintval(postRequestElement('points')), 'subject' => 'admin_sub_single', );