X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=12d4efd35163df0cc4dbcfa94f948b8d7a696517;hp=4ab60ecce6f15350657e39e7612fb4a6da9ab676;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=fb7120ffa230b62b54895bcf95952e1cf30f8594 diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php index 4ab60ecce6..12d4efd351 100644 --- a/inc/modules/admin/what-config_payouts.php +++ b/inc/modules/admin/what-config_payouts.php @@ -1,7 +1,7 @@ 0)) { +if ((isFormSent('add')) && (isPostRequestParameterSet('title')) && (postRequestParameter('rate') > 0)) { // Add new payout type - $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE type='%s' LIMIT 1", - array(REQUEST_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(postRequestParameter('title')), __FILE__, __LINE__); + 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')", - array( - REQUEST_POST('title'), - bigintval(REQUEST_POST('rate')), - bigintval(REQUEST_POST('mpoi')), - REQUEST_POST('yacc'), - REQUEST_POST('ypass'), - REQUEST_POST('yurl'), - REQUEST_POST('yrdone'), - REQUEST_POST('yrfailed'), - REQUEST_POST('ytrans'), - REQUEST_POST('allow_url'), -), __FILE__, __LINE__); - $msg = getMessage('ADMIN_PAYOUT_TYPE_ADDED'); + 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', %s, %s,'%s','%s','%s','%s','%s','%s','%s' +)", + array( + postRequestParameter('title'), + bigintval(postRequestParameter('rate')), + bigintval(postRequestParameter('min_points')), + postRequestParameter('yacc'), + postRequestParameter('ypass'), + postRequestParameter('yurl'), + postRequestParameter('yrdone'), + postRequestParameter('yrfailed'), + postRequestParameter('ytrans'), + postRequestParameter('allow_url'), + ), __FILE__, __LINE__); + + // Get message + $message = '{--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 ((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 - $id = bigintval($id); - - // Edit only if something is entered - if ((REQUEST_ISSET_POST(('title', $id))) && (REQUEST_POST('rate', $id) > 0)) { - // Update entry - ADD_SQL(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( - REQUEST_POST('title', $id), - REVERT_COMMA(REQUEST_POST('rate', $id)), - REVERT_COMMA(REQUEST_POST('mpoi' , $id)), - REQUEST_POST('allow', $id), -),__FILE__, __LINE__, false)); - } - } - - // Run all SQLs - runFilterChain('run_sqls'); +if ((isFormSent('edit')) && (ifPostContainsSelections())) { + // Make payouts configurable + $display = false; //Suppress any other outputs + $OUT = ''; + foreach (postRequestParameter('sel') as $id => $sel) { + // Load data + $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); - // Get message - $msg = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED'); - } else { - $display = false; //Suppress any other outputs - $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__); - list($title, $rate, $mpoi, $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."]"), - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content); - $SW = 3 - $SW; - } + // Prepare data for the row template + $content['allow_url'] = addSelectionBox('yn', $content['allow_url'], 'allow_url[' . $content['id'] . ']'); - // @TODO Rewrite this constant - define('__PAYOUT_ROWS', $OUT); + // Load row template and switch color + $OUT .= loadTemplate('admin_edit_payouts_row', true, $content); + } // END - foreach - // Load main template - LOAD_TEMPLATE("admin_config_payouts_edit"); + // Load main template + loadTemplate('admin_edit_payouts', false, $OUT); +} elseif ((isFormSent('do_edit')) && (ifPostContainsSelections())) { + // Change them now + // Init SQLs + initSqls(); + + // Edit entries + foreach (postRequestParameter('sel') as $id => $sel) { + // Secure id + $id = bigintval($id); + + // Edit only if something is entered + if ((isPostRequestParameterSet('title', $id)) && (postRequestParameter('rate', $id) > 0)) { + // Update entry + addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_payout_types` SET + `type`='%s', + `rate`=%s, + `min_points`=%s, + `allow_url`='%s' +WHERE + `id`=%s +LIMIT 1", + array( + postRequestParameter('type', $id), + convertCommaToDot(postRequestParameter('rate', $id)), + convertCommaToDot(postRequestParameter('min_points' , $id)), + postRequestParameter('allow_url', $id), + bigintval($id) + ),__FILE__, __LINE__, false)); + } } -} 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) { - 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'); + // Run all SQLs + runFilterChain('run_sqls'); + + // Get message + $message = '{--ADMIN_PAYOUT_ENTRIES_CHANGED--}'; +} elseif ((isFormSent('delete')) && (ifPostContainsSelections())) { + $display = false; //Suppress any other outputs + $OUT = ''; + foreach (postRequestParameter('sel') as $id => $sel) { + // Secure id number + $id = bigintval($id); + + // Load data + $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); - // Get message - $msg = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED'); - } else { - $display = false; //Suppress any other outputs - $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__); - list($title, $rate, $mpoi) = 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), - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_payouts_del_row", true, $content); - $SW = 3 - $SW; - } - define('__PAYOUT_ROWS', $OUT); + // Load row template and switch color + $OUT .= loadTemplate('admin_delete_payouts_row', true, $content); + } // END - foreach - // Load main template - LOAD_TEMPLATE("admin_config_payouts_del"); - } + // Load main template + loadTemplate('admin_delete_payouts', false, $OUT); +} elseif ((isFormSent('do_delete')) && (ifPostContainsSelections())) { + // Init SQLs + initSqls(); + + // 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)); + } // END - foreach + + // Run all SQLs + runFilterChain('run_sqls'); + + // Get message + $message = '{--ADMIN_PAYOUT_ENTRIES_DELETED--}'; } -if (!empty($msg)) { +if (!empty($message)) { // Output message - LOAD_TEMPLATE("admin_settings_saved", false, $msg); -} + displayMessage($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_HASZERONUMS($result_type)) && ($display)) { // List all payout types - $OUT = ""; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result_type)) { - // Prepare data for the row template - $content = array( - 'sw' => $SW, - '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 - $OUT .= LOAD_TEMPLATE("admin_config_payouts_row", true, $content); - $SW = 3 - $SW; - } + $OUT .= loadTemplate('admin_config_payouts_row', true, $content); + } // END - while // Free memory SQL_FREERESULT($result_type); - // @TODO Rewrite this constant - define('__PAYOUT_ROWS', $OUT); - // Load main template - LOAD_TEMPLATE("admin_config_payouts"); -} + loadTemplate('admin_config_payouts', false, $OUT); +} // END - if // Does your members request payouts? -if ((SQL_NUMROWS($result_mem) > 0) && ($display)) { +if ((!SQL_HASZERONUMS($result_mem)) && ($display === true)) { // Members has requested payouts - LOAD_TEMPLATE("admin_settings_saved", false, "{--ADMIN_PAYOUT_LIST_REQUESTS--}

"); -} elseif ($display) { + displayMessage('{--ADMIN_PAYOUT_LIST_REQUESTS--}'); +} elseif ($display === true) { // No member requests so far - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_PAYOUT_NO_MEMBER_REQUESTS')); + displayMessage('{--ADMIN_PAYOUT_NO_MEMBER_REQUESTS--}'); } // Free result SQL_FREERESULT($result_mem); -// Add new paypout type -if ($display) LOAD_TEMPLATE("admin_payout_add_new"); +// Add new payout type +if ($display === true) { + loadTemplate('admin_payout_add_new'); +} // END - if -// +// [EOF] ?>