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) { // Add now $result = 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 { // Free memory SQL_FREERESULT($result); // Does already exist $msg = "".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__); $display = true; if ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0)) { // Edit payout types if ((isset($_GET['ok'])) && ($_GET['ok'] == "ok")) { // Edit entries foreach ($_POST['sel'] as $id => $sel) { // Secure ID $id = bigintval($id); // Edit only if something is entered if ((!empty($_POST['title'][$id])) && ($_POST['rate'][$id] > 0)) { // Update entry $result = 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(REVERT_COMMA($_POST['rate'][$id])), bigintval(REVERT_COMMA($_POST['mpoi'][$id])), $_POST['allow'][$id], ),__FILE__, __LINE__); } } $msg = ADMIN_PAYOUT_ENTRIES_CHANGED; } else { $display = false; //Suppress any other outputs $SW = 2; $OUT = ""; foreach ($_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; } define('__PAYOUT_ROWS', $OUT); // Load main template LOAD_TEMPLATE("admin_config_payouts_edit"); } } elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0)) { // Delete payout types if ($_GET['ok'] == "ok") { // 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 { $display = false; //Suppress any other outputs $SW = 2; $OUT = ""; foreach ($_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 main template LOAD_TEMPLATE("admin_config_payouts_del"); } } if (!empty($msg)) { // Output message LOAD_TEMPLATE("admin_settings_saved", false, $msg); } // 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)) { // List all payout types $SW = 2; $OUT = ""; while (list($id, $type, $rate, $mpoi, $from) = SQL_FETCHROW($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), ); // Load row template and switch color $OUT .= LOAD_TEMPLATE("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"); } // Does your members request payouts? if ((SQL_NUMROWS($result_mem) > 0) && ($display)) { // Members has requested payouts SQL_FREERESULT($result_mem); OUTPUT_HTML("

".ADMIN_PAYOUT_LIST_REQUESTS."

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

".ADMIN_PAYOUT_NO_MEMBER_REQUESTS."

"); } // Add new paypout type if ($display) LOAD_TEMPLATE("admin_payout_add_new"); // ?>