X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=4ab60ecce6f15350657e39e7612fb4a6da9ab676;hb=fb7120ffa230b62b54895bcf95952e1cf30f8594;hp=3156f0d7ec761b25da9069edc91be4cf90758eac;hpb=c78089215285d52d483760699d07a96dfbbe0671;p=mailer.git diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php index 3156f0d7ec..4ab60ecce6 100644 --- a/inc/modules/admin/what-config_payouts.php +++ b/inc/modules/admin/what-config_payouts.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Auszahlungensarten editieren * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $Date:: $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -80,6 +85,9 @@ $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 @@ -88,7 +96,7 @@ if ((REQUEST_ISSET_POST('edit')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) // Edit only if something is entered if ((REQUEST_ISSET_POST(('title', $id))) && (REQUEST_POST('rate', $id) > 0)) { // Update entry - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_payout_types` SET + ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_payout_types` SET type='%s', rate=%s, min_points=%s, @@ -96,20 +104,25 @@ allow_url='%s' WHERE id='".$id."' LIMIT 1", array( REQUEST_POST('title', $id), - bigintval(REVERT_COMMA(REQUEST_POST('rate', $id))), - bigintval(REVERT_COMMA(REQUEST_POST('mpoi' , $id))), + REVERT_COMMA(REQUEST_POST('rate', $id)), + REVERT_COMMA(REQUEST_POST('mpoi' , $id)), REQUEST_POST('allow', $id), -),__FILE__, __LINE__); +),__FILE__, __LINE__, false)); } } + + // Run all SQLs + runFilterChain('run_sqls'); + + // Get message $msg = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED'); } else { $display = false; //Suppress any other outputs - $SW = 2; $OUT = ""; + $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__); + array(bigintval($id)), __FILE__, __LINE__); list($title, $rate, $mpoi, $allow) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -127,6 +140,8 @@ WHERE id='".$id."' LIMIT 1", $OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content); $SW = 3 - $SW; } + + // @TODO Rewrite this constant define('__PAYOUT_ROWS', $OUT); // Load main template @@ -135,22 +150,30 @@ WHERE id='".$id."' LIMIT 1", } 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) { - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } + 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'); + + // Get message $msg = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED'); } else { $display = false; //Suppress any other outputs - $SW = 2; $OUT = ""; + $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__); + array($id), __FILE__, __LINE__); list($title, $rate, $mpoi) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -184,16 +207,16 @@ $result_type = SQL_QUERY("SELECT id, type, rate, min_points, from_account FROM ` 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), + '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 @@ -203,6 +226,8 @@ if ((SQL_NUMROWS($result_type) > 0) && ($display)) { // Free memory SQL_FREERESULT($result_type); + + // @TODO Rewrite this constant define('__PAYOUT_ROWS', $OUT); // Load main template