if ((REQUEST_ISSET_POST('edit')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) {
// Edit payout types
if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == "ok")) {
+ // Init SQLs
+ INIT_SQLS();
+
// Edit entries
foreach (REQUEST_POST('sel') as $id => $sel) {
// Secure ID
// Edit only if something is entered
if ((REQUEST_ISSET_POST(('title', $id))) && (REQUEST_POST('rate', $id) > 0)) {
// Update entry
- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_payout_types` SET
+ ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_payout_types` SET
type='%s',
rate=%s,
min_points=%s,
WHERE id='".$id."' LIMIT 1",
array(
REQUEST_POST('title', $id),
- bigintval(REVERT_COMMA(REQUEST_POST('rate', $id))),
- bigintval(REVERT_COMMA(REQUEST_POST('mpoi' , $id))),
+ REVERT_COMMA(REQUEST_POST('rate', $id)),
+ REVERT_COMMA(REQUEST_POST('mpoi' , $id)),
REQUEST_POST('allow', $id),
-),__FILE__, __LINE__);
+),__FILE__, __LINE__, false));
}
}
+
+ // Run all SQLs
+ runFilterChain('run_sqls');
+
+ // Get message
$msg = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED');
} else {
$display = false; //Suppress any other outputs
- $SW = 2; $OUT = "";
+ $OUT = ""; $SW = 2;
foreach (REQUEST_POST('sel') as $id => $sel) {
// Load data
$result = SQL_QUERY_ESC("SELECT type, rate, min_points, allow_url FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
+ array(bigintval($id)), __FILE__, __LINE__);
list($title, $rate, $mpoi, $allow) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
$OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content);
$SW = 3 - $SW;
}
+
+ // @TODO Rewrite this constant
define('__PAYOUT_ROWS', $OUT);
// Load main template
} elseif ((REQUEST_ISSET_POST('del')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) {
// Delete payout types
if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == "ok")) {
+ // Init SQLs
+ INIT_SQLS();
+
// Delete entries
foreach (REQUEST_POST('sel') as $id => $sel) {
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
- }
+ ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE id=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__, false));
+ } // END - foreach
+
+ // Run all SQLs
+ runFilterChain('run_sqls');
+
+ // Get message
$msg = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED');
} else {
$display = false; //Suppress any other outputs
- $SW = 2; $OUT = "";
+ $OUT = ""; $SW = 2;
foreach (REQUEST_POST('sel') as $id => $sel) {
// Secure ID number
$id = bigintval($id);
// Load data
$result = SQL_QUERY_ESC("SELECT type, rate, min_points FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE id=%s LIMIT 1",
- array($id), __FILE__, __LINE__);
+ array($id), __FILE__, __LINE__);
list($title, $rate, $mpoi) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
if ((SQL_NUMROWS($result_type) > 0) && ($display)) {
// List all payout types
- $SW = 2; $OUT = "";
- while (list($id, $type, $rate, $mpoi, $from) = SQL_FETCHROW($result_type)) {
+ $OUT = ""; $SW = 2;
+ while ($content = SQL_FETCHARRAY($result_type)) {
// Prepare data for the row template
$content = array(
'sw' => $SW,
- 'id' => $id,
- 'from' => COMPILE_CODE($from),
- 'type' => COMPILE_CODE($type),
- 'rate' => TRANSLATE_COMMA($rate),
- 'mpoi' => TRANSLATE_COMMA($mpoi),
+ 'id' => $content['id'],
+ 'from' => COMPILE_CODE($content['from_account']),
+ 'type' => COMPILE_CODE($content['type']),
+ 'rate' => TRANSLATE_COMMA($content['rate']),
+ 'mpoi' => TRANSLATE_COMMA($content['min_points']),
);
// Load row template and switch color
// Free memory
SQL_FREERESULT($result_type);
+
+ // @TODO Rewrite this constant
define('__PAYOUT_ROWS', $OUT);
// Load main template