X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=1b2de6bd1a3da1f7ca246365769b83532b672f69;hp=58e04477de046797243f46724d9cc586ef937442;hb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;hpb=7f104f6fe558bb56b4205241435a2357c2feece1 diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php index 58e04477de..1b2de6bd1a 100644 --- a/inc/modules/admin/what-config_payouts.php +++ b/inc/modules/admin/what-config_payouts.php @@ -1,6 +1,6 @@ 0)) -{ +if ((isPostRequestElementSet('add')) && (isPostRequestElementSet('title')) && (postRequestElement('rate') > 0)) { // Add new payout type - $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_payout_types WHERE type='%s' LIMIT 1", - array($_POST['title']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) - { + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE type='%s' LIMIT 1", + array(postRequestElement('title')), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == '0') { // Add now - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_payout_types + 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')", - array( - $_POST['title'], - bigintval($_POST['rate']), - bigintval($_POST['mpoi']), - $_POST['yacc'], - $_POST['ypass'], - $_POST['yurl'], - $_POST['yrdone'], - $_POST['yrfailed'], - $_POST['ytrans'], - $_POST['allow_url'], -), __FILE__, __LINE__); - $msg = "".ADMIN_PAYOUT_TYPE_ADDED.""; - } - else - { + array( + postRequestElement('title'), + bigintval(postRequestElement('rate')), + bigintval(postRequestElement('min_points')), + postRequestElement('yacc'), + postRequestElement('ypass'), + postRequestElement('yurl'), + postRequestElement('yrdone'), + postRequestElement('yrfailed'), + postRequestElement('ytrans'), + postRequestElement('allow_url'), + ), __FILE__, __LINE__); + + // Get message + $message = getMessage('ADMIN_PAYOUT_TYPE_ADDED'); + } else { // Free memory SQL_FREERESULT($result); // Does already exist - $msg = "".ADMIN_PAYOUT_TYPE_ALREADY.""; + $message = "
{--ADMIN_PAYOUT_TYPE_ALREADY--}
"; } } // Payout requests by your members -$result_mem = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_user_payouts WHERE status='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__); +$result_mem = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_payouts` WHERE `status`='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__); $display = true; -if ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0)) -{ +if ((isPostRequestElementSet('edit')) && (countPostSelection() > 0)) { // Edit payout types - if ((isset($_GET['ok'])) && ($_GET['ok'] == "ok")) - { + if ((isGetRequestElementSet('ok')) && (getRequestElement('ok') == 'ok')) { + // Init SQLs + initSqls(); + // Edit entries - foreach ($_POST['sel'] as $id => $sel) - { - // Secure ID + foreach (postRequestElement('sel') as $id => $sel) { + // Secure id $id = bigintval($id); // Edit only if something is entered - if ((!empty($_POST['title'][$id])) && ($_POST['rate'][$id] > 0)) - { + if ((isPostRequestElementSet('title', $id)) && (postRequestElement('rate', $id) > 0)) { // Update entry - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_payout_types SET + addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_payout_types` SET type='%s', rate=%s, min_points=%s, allow_url='%s' -WHERE id='".$id."' LIMIT 1", - array( - $_POST['title'][$id], - bigintval(str_replace(",", ".", $_POST['rate'][$id])), - bigintval(str_replace(",", ".", $_POST['mpoi'][$id])), - $_POST['allow'][$id], -),__FILE__, __LINE__); +WHERE `id`='".$id."' LIMIT 1", + array( + postRequestElement('title', $id), + convertCommaToDot(postRequestElement('rate', $id)), + convertCommaToDot(postRequestElement('min_points' , $id)), + postRequestElement('allow', $id), + ),__FILE__, __LINE__, false)); } } - $msg = ADMIN_PAYOUT_ENTRIES_CHANGED; - } - else - { + + // Run all SQLs + runFilterChain('run_sqls'); + + // Get message + $message = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED'); + } else { $display = false; //Suppress any other outputs - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id => $sel) - { + $OUT = ''; $SW = 2; + foreach (postRequestElement('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, $mpoi, $allow) = SQL_FETCHROW($result); + $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); SQL_FREERESULT($result); // Prepare data for the row template $content = array( 'sw' => $SW, 'id' => $id, - 'title' => COMPILE_CODE($title), - 'rate' => TRANSLATE_COMMA($rate), - 'mpoi' => TRANSLATE_COMMA($mpoi), - 'allow' => ADD_SELECTION("yn", $allow, "allow[".$id."]"), + 'title' => $title, + 'rate' => translateComma($rate), + 'min_points' => translateComma($min_points), + 'allow' => addSelectionBox('yn', $allow, "allow[".$id."]"), ); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content); + $OUT .= loadTemplate('admin_config_payouts_edit_row', true, $content); $SW = 3 - $SW; } - define('__PAYOUT_ROWS', $OUT); // Load main template - LOAD_TEMPLATE("admin_config_payouts_edit"); + loadTemplate('admin_config_payouts_edit', false, $OUT); } -} - elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0)) -{ +} elseif ((isPostRequestElementSet('del')) && (countPostSelection() > 0)) { // Delete payout types - if ($_GET['ok'] == "ok") - { + if ((isGetRequestElementSet('ok')) && (getRequestElement('ok') == 'ok')) { + // Init SQLs + initSqls(); + // Delete entries - foreach ($_POST['sel'] as $id => $sel) - { - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payout_types WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } - $msg = ADMIN_PAYOUT_ENTRIES_DELETED; - } - else - { + foreach (postRequestElement('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)); + } // END - foreach + + // Run all SQLs + runFilterChain('run_sqls'); + + // Get message + $message = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED'); + } else { $display = false; //Suppress any other outputs - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id => $sel) - { - // Secure ID number + $OUT = ''; $SW = 2; + foreach (postRequestElement('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__); - list($title, $rate, $mpoi) = SQL_FETCHROW($result); + $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); SQL_FREERESULT($result); // Prepare data for the row template $content = array( 'sw' => $SW, 'id' => $id, - 'title' => COMPILE_CODE($title), - 'rate' => TRANSLATE_COMMA($rate), - 'mpoi' => TRANSLATE_COMMA($mpoi), + 'title' => $title, + 'rate' => translateComma($rate), + 'min_points' => translateComma($min_points), ); // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_payouts_del_row", true, $content); + $OUT .= loadTemplate('admin_config_payouts_del_row', true, $content); $SW = 3 - $SW; } - define('__PAYOUT_ROWS', $OUT); // Load main template - LOAD_TEMPLATE("admin_config_payouts_del"); + loadTemplate('admin_config_payouts_del', false, $OUT); } } -if (!empty($msg)) -{ +if (!empty($message)) { // Output message - LOAD_TEMPLATE("admin_settings_saved", false, $msg); -} + loadTemplate('admin_settings_saved', false, $message); +} // END - if // Payout types -$result_type = SQL_QUERY("SELECT id, type, rate, min_points, from_account FROM "._MYSQL_PREFIX."_payout_types ORDER BY type", __FILE__, __LINE__); - -if ((SQL_NUMROWS($result_type) > 0) && ($display)) -{ +$result_type = SQL_QUERY("SELECT + `id`, `type`, `rate`, `min_points`, `from_account` +FROM + `{?_MYSQL_PREFIX?}_payout_types` +ORDER BY + `type` ASC", __FILE__, __LINE__); + +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), + 'sw' => $SW, + '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 .= LOAD_TEMPLATE("admin_config_payouts_row", true, $content); + $OUT .= loadTemplate('admin_config_payouts_row', true, $content); $SW = 3 - $SW; } // Free memory SQL_FREERESULT($result_type); - define('__PAYOUT_ROWS', $OUT); // Load main template - LOAD_TEMPLATE("admin_config_payouts"); + loadTemplate('admin_config_payouts', false, $OUT); } // Does your members request payouts? -if ((SQL_NUMROWS($result_mem) > 0) && ($display)) -{ +if ((SQL_NUMROWS($result_mem) > 0) && ($display)) { // Members has requested payouts - SQL_FREERESULT($result_mem); - OUTPUT_HTML("

".ADMIN_PAYOUT_LIST_REQUESTS."

"); -} - elseif ($display) -{ + loadTemplate('admin_settings_saved', false, "{--ADMIN_PAYOUT_LIST_REQUESTS--}

"); +} elseif ($display) { // No member requests so far - OUTPUT_HTML("

".ADMIN_PAYOUT_NO_MEMBER_REQUESTS."

"); + loadTemplate('admin_settings_saved', false, getMessage('ADMIN_PAYOUT_NO_MEMBER_REQUESTS')); } + +// Free result +SQL_FREERESULT($result_mem); + // Add new paypout type -if ($display) LOAD_TEMPLATE("admin_payout_add_new"); +if ($display === true) loadTemplate('admin_payout_add_new'); -// +// [EOF] ?>