X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=2b016d0b3e9aaf2621c1accf892c8bd031ca04bb;hp=4cc475fefc853dd49cbcda6bf718ed055ac06376;hb=20741b93fd58620af677a7f1039ffd16ea6ec689;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8 diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php index 4cc475fefc..2b016d0b3e 100644 --- a/inc/modules/admin/what-config_payouts.php +++ b/inc/modules/admin/what-config_payouts.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -41,30 +41,37 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); -if (isPostRequestParameterSet('rate')) setPostRequestParameter('rate', convertCommaToDot(postRequestParameter('rate'))); +// Convert 'rate' if set +if (isPostRequestElementSet('rate')) { + convertCommaToDotInPostData('rate'); +} // END - if -if ((isFormSent('add')) && (isPostRequestParameterSet('title')) && (postRequestParameter('rate') > 0)) { +if ((isFormSent('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(postRequestParameter('title')), __FILE__, __LINE__); + array(postRequestElement('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')", + 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'), + 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 @@ -83,109 +90,105 @@ $result_mem = SQL_QUERY("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_payouts` WHERE $display = true; if ((isFormSent('edit')) && (ifPostContainsSelections())) { - // Edit payout types - if ((isGetRequestParameterSet('ok')) && (getRequestParameter('ok') == 'ok')) { - // 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' + // Make payouts configurable + $display = false; //Suppress any other outputs + $OUT = ''; + foreach (postRequestElement('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 (postRequestElement('sel') as $id => $sel) { + // Secure id + $id = bigintval($id); + + // Edit only if something is entered + if ((isPostRequestElementSet('title', $id)) && (postRequestElement('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)); - } + array( + postRequestElement('type', $id), + convertCommaToDot(postRequestElement('rate', $id)), + convertCommaToDot(postRequestElement('min_points' , $id)), + postRequestElement('allow_url', $id), + bigintval($id) + ),__FILE__, __LINE__, false)); } + } - // Run all SQLs - runFilterChain('run_sqls'); + // Run all SQLs + runFilterChain('run_sqls'); - // Get message - $message = '{--ADMIN_PAYOUT_ENTRIES_CHANGED--}'; - } else { - $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_config_payouts_edit_row', true, $content); - } // END - foreach - - // Load main template - loadTemplate('admin_config_payouts_edit', false, $OUT); - } + // Get message + $message = '{--ADMIN_PAYOUT_ENTRIES_CHANGED--}'; } elseif ((isFormSent('delete')) && (ifPostContainsSelections())) { - // Delete payout types - if ((isGetRequestParameterSet('ok')) && (getRequestParameter('ok') == 'ok')) { - // 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 + $display = false; //Suppress any other outputs + $OUT = ''; + foreach (postRequestElement('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); - // Run all SQLs - runFilterChain('run_sqls'); + // Load row template and switch color + $OUT .= loadTemplate('admin_delete_payouts_row', true, $content); + } // END - foreach - // Get message - $message = '{--ADMIN_PAYOUT_ENTRIES_DELETED--}'; - } else { - $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_config_payouts_del_row', true, $content); - } // END - foreach - - // Load main template - loadTemplate('admin_config_payouts_del', false, $OUT); - } + // Load main template + loadTemplate('admin_delete_payouts', false, $OUT); +} elseif ((isFormSent('do_delete')) && (ifPostContainsSelections())) { + // Init SQLs + initSqls(); + + // Delete entries + 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 = '{--ADMIN_PAYOUT_ENTRIES_DELETED--}'; } if (!empty($message)) { // Output message - loadTemplate('admin_settings_saved', false, $message); + displayMessage($message); } // END - if // Payout types $result_type = SQL_QUERY("SELECT - `id`, `type`, `rate`, `min_points`, `from_account` + `id`,`type`,`rate`,`min_points`,`from_account` FROM `{?_MYSQL_PREFIX?}_payout_types` ORDER BY @@ -207,19 +210,21 @@ if ((!SQL_HASZERONUMS($result_type)) && ($display)) { } // END - if // Does your members request payouts? -if ((!SQL_HASZERONUMS($result_mem)) && ($display)) { +if ((!SQL_HASZERONUMS($result_mem)) && ($display === true)) { // Members has requested payouts - loadTemplate('admin_settings_saved', false, '{--ADMIN_PAYOUT_LIST_REQUESTS--}'); -} elseif ($display) { + displayMessage('{--ADMIN_PAYOUT_LIST_REQUESTS--}'); +} elseif ($display === true) { // No member requests so far - loadTemplate('admin_settings_saved', false, '{--ADMIN_PAYOUT_NO_MEMBER_REQUESTS--}'); + displayMessage('{--ADMIN_PAYOUT_NO_MEMBER_REQUESTS--}'); } // Free result SQL_FREERESULT($result_mem); // Add new payout type -if ($display === true) loadTemplate('admin_payout_add_new'); +if ($display === true) { + loadTemplate('admin_payout_add_new'); +} // END - if // [EOF] ?>