// Delete entries here
$OUT = '';
foreach (postRequestElement('sel') as $id => $value) {
- $result = SQL_QUERY_ESC("SELECT
+ $result = sqlQueryEscaped("SELECT
`id`,
`time`,
`payment`,
`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);
// Edit entries
$OUT = '';
foreach (postRequestElement('sel') as $id => $value) {
- $result = SQL_QUERY_ESC("SELECT
+ $result = sqlQueryEscaped("SELECT
`id`,
`time`,
`payment`,
`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);
loadTemplate('admin_edit_payments', FALSE, $OUT);
} else {
// Referral levels
- $result = SQL_QUERY("SELECT
+ $result = sqlQuery("SELECT
`id`,
`time`,
`payment`,
`{?_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);