X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=8a5e102d6c616808f6d049b983a31902ffb8ae44;hb=668d3df20156d5dbd4f34342eeadcbd5d420a8f5;hp=810e489b64e7edd41702b637e39d748746ac185c;hpb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;p=mailer.git diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php index 810e489b64..8a5e102d6c 100644 --- a/inc/modules/admin/what-config_payouts.php +++ b/inc/modules/admin/what-config_payouts.php @@ -14,11 +14,9 @@ * $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 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -40,12 +38,15 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!isAdmin())) { die(); -} +} // 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 (isPostRequestParameterSet('rate')) { + convertCommaToDotInPostData('rate'); +} // END - if if ((isFormSent('add')) && (isPostRequestParameterSet('title')) && (postRequestParameter('rate') > 0)) { // Add new payout type @@ -54,8 +55,8 @@ if ((isFormSent('add')) && (isPostRequestParameterSet('title')) && (postRequestP 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')", +(`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')), @@ -76,7 +77,7 @@ VALUES ('%s', %d, %d,'%s','%s','%s','%s','%s','%s','%s')", SQL_FREERESULT($result); // Does already exist - $message = '
{--ADMIN_PAYOUT_TYPE_ALREADY--}
'; + $message = '
{--ADMIN_PAYOUT_TYPE_ALREADY--}
'; } } @@ -84,7 +85,7 @@ VALUES ('%s', %d, %d,'%s','%s','%s','%s','%s','%s','%s')", $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')) && (countPostSelection() > 0)) { +if ((isFormSent('edit')) && (ifPostContainsSelections())) { // Edit payout types if ((isGetRequestParameterSet('ok')) && (getRequestParameter('ok') == 'ok')) { // Init SQLs @@ -107,10 +108,10 @@ WHERE `id`=%s LIMIT 1", array( - postRequestParameter('title', $id), + postRequestParameter('type', $id), convertCommaToDot(postRequestParameter('rate', $id)), convertCommaToDot(postRequestParameter('min_points' , $id)), - postRequestParameter('allow', $id), + postRequestParameter('allow_url', $id), bigintval($id) ),__FILE__, __LINE__, false)); } @@ -123,33 +124,25 @@ LIMIT 1", $message = '{--ADMIN_PAYOUT_ENTRIES_CHANGED--}'; } else { $display = false; //Suppress any other outputs - $OUT = ''; $SW = 2; + $OUT = ''; foreach (postRequestParameter('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, $min_points, $allow) = SQL_FETCHROW($result); + $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 = array( - 'sw' => $SW, - 'id' => $id, - 'title' => $title, - 'rate' => translateComma($rate), - 'min_points' => translateComma($min_points), - 'allow' => addSelectionBox('yn', $allow, 'allow[' . $id . ']'), - ); + $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); - $SW = 3 - $SW; - } + } // END - foreach // Load main template loadTemplate('admin_config_payouts_edit', false, $OUT); } -} elseif ((isFormSent('del')) && (countPostSelection() > 0)) { +} elseif ((isFormSent('delete')) && (ifPostContainsSelections())) { // Delete payout types if ((isGetRequestParameterSet('ok')) && (getRequestParameter('ok') == 'ok')) { // Init SQLs @@ -158,7 +151,7 @@ LIMIT 1", // 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)); + array(bigintval($id)), __FILE__, __LINE__, false)); } // END - foreach // Run all SQLs @@ -168,30 +161,20 @@ LIMIT 1", $message = '{--ADMIN_PAYOUT_ENTRIES_DELETED--}'; } else { $display = false; //Suppress any other outputs - $OUT = ''; $SW = 2; + $OUT = ''; foreach (postRequestParameter('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, $min_points) = SQL_FETCHROW($result); + $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); - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'title' => $title, - 'rate' => translateComma($rate), - 'min_points' => translateComma($min_points), - ); - // Load row template and switch color $OUT .= loadTemplate('admin_config_payouts_del_row', true, $content); - $SW = 3 - $SW; - } + } // END - foreach // Load main template loadTemplate('admin_config_payouts_del', false, $OUT); @@ -200,7 +183,7 @@ LIMIT 1", if (!empty($message)) { // Output message - loadTemplate('admin_settings_saved', false, $message); + displayMessage($message); } // END - if // Payout types @@ -211,23 +194,12 @@ FROM ORDER BY `type` ASC", __FILE__, __LINE__); -if ((SQL_NUMROWS($result_type) > 0) && ($display)) { +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_account' => $content['from_account'], - 'type' => $content['type'], - 'rate' => translateComma($content['rate']), - 'min_points' => translateComma($content['min_points']), - ); - // Load row template and switch color $OUT .= loadTemplate('admin_config_payouts_row', true, $content); - $SW = 3 - $SW; } // END - while // Free memory @@ -235,15 +207,15 @@ if ((SQL_NUMROWS($result_type) > 0) && ($display)) { // Load main template 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)) { // Members has requested payouts - loadTemplate('admin_settings_saved', false, '{--ADMIN_PAYOUT_LIST_REQUESTS--}'); + displayMessage('{--ADMIN_PAYOUT_LIST_REQUESTS--}'); } elseif ($display) { // No member requests so far - loadTemplate('admin_settings_saved', false, '{--ADMIN_PAYOUT_NO_MEMBER_REQUESTS--}'); + displayMessage('{--ADMIN_PAYOUT_NO_MEMBER_REQUESTS--}'); } // Free result