if (SQL_HASZERONUMS($result)) {
// Add now
SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_payout_types`
-(type, rate, min_points, from_account, from_pass, engine_url, engine_ret_ok, engine_ret_failed, pass_enc, allow_url)
-VALUES ('%s', %d, %d,'%s','%s','%s','%s','%s','%s','%s')",
+(`type`, `rate`, `min_points`, `from_account`, `from_pass`, `engine_url`, `engine_ret_ok`, `engine_ret_failed`, `pass_enc`, `allow_url`)
+VALUES ('%s', %s, %s,'%s','%s','%s','%s','%s','%s','%s')",
array(
postRequestParameter('title'),
bigintval(postRequestParameter('rate')),
$result_mem = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_payouts` WHERE `status`='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__);
$display = true;
-if ((isFormSent('edit')) && (countPostSelection() > 0)) {
+if ((isFormSent('edit')) && (ifPostContainsSelections())) {
// Edit payout types
if ((isGetRequestParameterSet('ok')) && (getRequestParameter('ok') == 'ok')) {
// Init SQLs
`id`=%s
LIMIT 1",
array(
- postRequestParameter('title', $id),
+ postRequestParameter('type', $id),
convertCommaToDot(postRequestParameter('rate', $id)),
convertCommaToDot(postRequestParameter('min_points' , $id)),
- postRequestParameter('allow', $id),
+ postRequestParameter('allow_url', $id),
bigintval($id)
),__FILE__, __LINE__, false));
}
$OUT = '';
foreach (postRequestParameter('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__);
- list($title, $rate, $min_points, $allow) = SQL_FETCHROW($result);
+ $result = SQL_QUERY_ESC("SELECT `id`, `type`, `rate`, `min_points`, `allow_url` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ $content = SQL_FETCHARRAY($result);
SQL_FREERESULT($result);
// Prepare data for the row template
- $content = array(
- 'id' => $id,
- 'title' => $title,
- 'rate' => translateComma($rate),
- 'min_points' => translateComma($min_points),
- 'allow' => addSelectionBox('yn', $allow, 'allow[' . $id . ']'),
- );
+ $content['allow_url'] = addSelectionBox('yn', $content['allow_url'], 'allow_url[' . $content['id'] . ']');
// Load row template and switch color
$OUT .= loadTemplate('admin_config_payouts_edit_row', true, $content);
// Load main template
loadTemplate('admin_config_payouts_edit', false, $OUT);
}
-} elseif ((isFormSent('del')) && (countPostSelection() > 0)) {
+} elseif ((isFormSent('del')) && (ifPostContainsSelections())) {
// Delete payout types
if ((isGetRequestParameterSet('ok')) && (getRequestParameter('ok') == 'ok')) {
// Init SQLs
// Delete entries
foreach (postRequestParameter('sel') as $id => $sel) {
addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__, false));
+ array(bigintval($id)), __FILE__, __LINE__, false));
} // END - foreach
// Run all SQLs
$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__);
- list($title, $rate, $min_points) = SQL_FETCHROW($result);
+ $result = SQL_QUERY_ESC("SELECT `id`, `type`, `rate`, `min_points` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+ array($id), __FILE__, __LINE__);
+ $content = SQL_FETCHARRAY($result);
SQL_FREERESULT($result);
- // Prepare data for the row template
- $content = array(
- 'id' => $id,
- 'title' => $title,
- 'rate' => translateComma($rate),
- 'min_points' => translateComma($min_points),
- );
-
// Load row template and switch color
$OUT .= loadTemplate('admin_config_payouts_del_row', true, $content);
} // END - foreach
ORDER BY
`type` ASC", __FILE__, __LINE__);
-if ((SQL_NUMROWS($result_type) > 0) && ($display)) {
+if ((!SQL_HASZERONUMS($result_type)) && ($display)) {
// List all payout types
$OUT = '';
while ($content = SQL_FETCHARRAY($result_type)) {
- // Prepare data for the row template
- $content = array(
- 'id' => $content['id'],
- 'from_account' => $content['from_account'],
- 'type' => $content['type'],
- 'rate' => translateComma($content['rate']),
- 'min_points' => translateComma($content['min_points']),
- );
-
// Load row template and switch color
$OUT .= loadTemplate('admin_config_payouts_row', true, $content);
} // END - while
} // END - if
// Does your members request payouts?
-if ((SQL_NUMROWS($result_mem) > 0) && ($display)) {
+if ((!SQL_HASZERONUMS($result_mem)) && ($display)) {
// Members has requested payouts
loadTemplate('admin_settings_saved', false, '<a href="{%url=modules.php?module=admin&what=list_payouts%}">{--ADMIN_PAYOUT_LIST_REQUESTS--}</a>');
} elseif ($display) {