0)) { // Add new payout type $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', %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 $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__); $display = true; 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); // Prepare data for the row template $content['allow_url'] = addSelectionBox('yn', $content['allow_url'], 'allow_url[' . $content['id'] . ']'); // Load row template and switch color $OUT .= loadTemplate('admin_edit_payouts_row', true, $content); } // END - foreach // 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)); } } // 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); // Load row template and switch color $OUT .= loadTemplate('admin_delete_payouts_row', true, $content); } // END - foreach // 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($message)) { // Output message 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` ASC", __FILE__, __LINE__); if ((!SQL_HASZERONUMS($result_type)) && ($display)) { // List all payout types $OUT = ''; while ($content = SQL_FETCHARRAY($result_type)) { // Load row template and switch color $OUT .= loadTemplate('admin_config_payouts_row', true, $content); } // END - while // Free memory SQL_FREERESULT($result_type); // Load main template loadTemplate('admin_config_payouts', false, $OUT); } // END - if // Does your members request payouts? if ((!SQL_HASZERONUMS($result_mem)) && ($display === true)) { // Members has requested payouts displayMessage('{--ADMIN_PAYOUT_LIST_REQUESTS--}'); } elseif ($display === true) { // No member requests so far displayMessage('{--ADMIN_PAYOUT_NO_MEMBER_REQUESTS--}'); } // Free result SQL_FREERESULT($result_mem); // Add new payout type if ($display === true) { loadTemplate('admin_payout_add_new'); } // END - if // [EOF] ?>