$value) {
// Secure id
$id = bigintval($id);
// Add UPDATE
addSql("UPDATE
`{?_MYSQL_PREFIX?}_payments`
SET
`time`='" . $value . "',
`payment`='" . postRequestElement('payment', $id) . "',
`price`='" . postRequestElement('price', $id) . "',
`mail_title`='" . postRequestElement('mail_title', $id) . "'
WHERE
`id`='" . $id . "'
LIMIT 1");
} // END - foreach
break;
case 'delete':
foreach (postRequestElement('id') as $id => $value) {
// Secure id
$id = bigintval($id);
// Add DELETE
addSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_payments` WHERE `id`=" . $id . " LIMIT 1");
} // END - foreach
break;
} // END - switch
// Nothing has changed by default
$content = '{--SETTINGS_NOT_SAVED--}';
// Save settings
if (countSqls() > 0) {
// Run all queries
runFilterChain('run_sqls');
// Purge cache
rebuildCache('payments', 'payments');
// Change message
$content = '{--SETTINGS_SAVED--}';
} // END - if
// Output template
displayMessage($content);
} elseif ((isFormSent('delete')) && (ifPostContainsSelections())) {
// Delete entries here
$OUT = '';
foreach (postRequestElement('sel') as $id => $value) {
$result = sqlQueryEscaped("SELECT
`id`,
`time`,
`payment`,
`mail_title`,
`price`
FROM
`{?_MYSQL_PREFIX?}_payments`
WHERE
`id`=%s
LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
$content = sqlFetchArray($result);
// Free result
sqlFreeResult($result);
// Load row template and switch colors
$OUT .= loadTemplate('admin_delete_payments_row', TRUE, $content);
} // END - foreach
// Load main template
loadTemplate('admin_delete_payments', FALSE, $OUT);
} elseif ((isFormSent('edit')) && (ifPostContainsSelections())) {
// Edit entries
$OUT = '';
foreach (postRequestElement('sel') as $id => $value) {
$result = sqlQueryEscaped("SELECT
`id`,
`time`,
`payment`,
`mail_title`,
`price`
FROM
`{?_MYSQL_PREFIX?}_payments`
WHERE
`id`=%s
LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
$content = sqlFetchArray($result);
// Free result
sqlFreeResult($result);
// Load row template and switch colors
$OUT .= loadTemplate('admin_edit_payments_row', TRUE, $content);
} // END - foreach
// Load main template
loadTemplate('admin_edit_payments', FALSE, $OUT);
} else {
// Referral levels
$result = sqlQuery("SELECT
`id`,
`time`,
`payment`,
`mail_title`,
`price`
FROM
`{?_MYSQL_PREFIX?}_payments`
ORDER BY
`time` ASC", __FILE__, __LINE__);
if (!ifSqlHasZeroNums($result)) {
// Make referral levels editable and deletable
$OUT = '';
// List already existing categories for editing
while ($content = sqlFetchArray($result)) {
// Load row template and switch colors
$OUT .= loadTemplate('admin_list_payments_row', TRUE, $content);
} // END - switch
// Free memory
sqlFreeResult($result);
// Load main template
loadTemplate('admin_list_payments', FALSE, $OUT);
} // END - if
// Form for adding new referral levels
loadTemplate('admin_add_payment');
}
// [EOF]
?>