X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-payments.php;h=6b266f45fc1a71fef9f5d85926b3b8e11ca4c94e;hp=b62197a5f635dd5ca81431148b476d3755de9e4b;hb=155492a5b96cec674846973a8524238b0365a848;hpb=da5c63bacddced77a951cbe7b223f314885a6c87 diff --git a/inc/modules/admin/what-payments.php b/inc/modules/admin/what-payments.php index b62197a5f6..6b266f45fc 100644 --- a/inc/modules/admin/what-payments.php +++ b/inc/modules/admin/what-payments.php @@ -121,7 +121,7 @@ LIMIT 1"); // Delete entries here $OUT = ''; foreach (postRequestElement('sel') as $id => $value) { - $result = SQL_QUERY_ESC("SELECT + $result = sqlQueryEscaped("SELECT `id`, `time`, `payment`, @@ -133,10 +133,10 @@ WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); // Free result - SQL_FREERESULT($result); + sqlFreeResult($result); // Load row template and switch colors $OUT .= loadTemplate('admin_delete_payments_row', TRUE, $content); @@ -148,7 +148,7 @@ LIMIT 1", // Edit entries $OUT = ''; foreach (postRequestElement('sel') as $id => $value) { - $result = SQL_QUERY_ESC("SELECT + $result = sqlQueryEscaped("SELECT `id`, `time`, `payment`, @@ -160,10 +160,10 @@ WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); // Free result - SQL_FREERESULT($result); + sqlFreeResult($result); // Load row template and switch colors $OUT .= loadTemplate('admin_edit_payments_row', TRUE, $content); @@ -173,7 +173,7 @@ LIMIT 1", loadTemplate('admin_edit_payments', FALSE, $OUT); } else { // Referral levels - $result = SQL_QUERY("SELECT + $result = sqlQuery("SELECT `id`, `time`, `payment`, @@ -183,18 +183,18 @@ FROM `{?_MYSQL_PREFIX?}_payments` ORDER BY `time` ASC", __FILE__, __LINE__); - if (!SQL_HASZERONUMS($result)) { + if (!ifSqlHasZeroNums($result)) { // Make referral levels editable and deletable $OUT = ''; // List already existing categories for editing - while ($content = SQL_FETCHARRAY($result)) { + while ($content = sqlFetchArray($result)) { // Load row template and switch colors $OUT .= loadTemplate('admin_list_payments_row', TRUE, $content); } // END - switch // Free memory - SQL_FREERESULT($result); + sqlFreeResult($result); // Load main template loadTemplate('admin_list_payments', FALSE, $OUT);