X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_sponsor_pay.php;h=66474e60a8e2e469219f4fcbe3d98bc5cc0a4979;hb=9c7762b58197f49b318942d22cf3db0d21f625f5;hp=dbf1afe7a696f2d378ce5c3ca79edddc4d891314;hpb=c2245ee6923f35880d1df7ef0d9b78fa26ae25e7;p=mailer.git diff --git a/inc/modules/admin/what-list_sponsor_pay.php b/inc/modules/admin/what-list_sponsor_pay.php index dbf1afe7a6..66474e60a8 100644 --- a/inc/modules/admin/what-list_sponsor_pay.php +++ b/inc/modules/admin/what-list_sponsor_pay.php @@ -1,7 +1,7 @@ $sel) { - // Secure ID + foreach (postRequestElement('id') as $id => $sel) { + // Secure id $id = bigintval($id); // Save entry - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_paytypes` -SET pay_name='%s', pay_rate='%s', pay_min_count='%s', pay_currency='%s' WHERE `id`='%s' LIMIT 1", + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_sponsor_paytypes` +SET + `pay_name`='%s', + `pay_rate`='%s', + `pay_min_count`='%s', + `pay_currency`='%s' +WHERE + `id`='%s' +LIMIT 1", array( - REQUEST_POST('name', $id), - REQUEST_POST('rate', $id), - bigintval(REQUEST_POST('min', $id)), - REQUEST_POST('curr', $id), - $id + postRequestElement('name', $id), + postRequestElement('rate', $id), + bigintval(postRequestElement('min', $id)), + postRequestElement('curr', $id), + $id ), __FILE__, __LINE__); } // Generate message $message = getMessage('SPONSOR_PAY_ENTRIES_CHANGED'); - } elseif (REQUEST_ISSET_POST('remove')) { + } elseif (isPostRequestElementSet('remove')) { // Remove entries here... - foreach (REQUEST_POST('id') as $id => $sel) { + foreach (postRequestElement('id') as $id => $sel) { // Remove entry - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_sponsor_paytypes` WHERE `id`='%s' LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `id`='%s' LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); } // Generate message @@ -99,43 +106,43 @@ SET pay_name='%s', pay_rate='%s', pay_min_count='%s', pay_currency='%s' WHERE `i if (!empty($message)) { // Output message - LOAD_TEMPLATE('admin_settings_saved', false, $message); - } + loadTemplate('admin_settings_saved', false, $message); + } // END - if } -if (REQUEST_ISSET_POST('add')) { +if (isPostRequestElementSet('add')) { // Check if entry with same name does exists - $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_sponsor_paytypes` WHERE pay_name='%s' LIMIT 1", - array(REQUEST_POST('pay_name')), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) { + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `pay_name`='%s' LIMIT 1", + array(postRequestElement('pay_name')), __FILE__, __LINE__); + if (SQL_NUMROWS($result) == '0') { // No entry found so add this line - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_sponsor_paytypes` (pay_name, pay_rate, pay_min_count, pay_currency) VALUES ('%s','%s','%s','%s')", - array( - htmlspecialchars(REQUEST_POST('pay_name')), - convertCommaToDot(REQUEST_POST('pay_rate')), - bigintval(REQUEST_POST('pay_min_count')), - htmlspecialchars(REQUEST_POST('pay_currency')) - ), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_paytypes` (`pay_name`, `pay_rate`, `pay_min_count`, `pay_currency`) VALUES ('%s','%s','%s','%s')", + array( + postRequestElement('pay_name'), + convertCommaToDot(postRequestElement('pay_rate')), + bigintval(postRequestElement('pay_min_count')), + postRequestElement('pay_currency') + ), __FILE__, __LINE__); // Payment type added! - $message = sprintf(getMessage('ADMIN_SPONSOR_PAYTYPE_ADDED'), REQUEST_POST('pay_name')); + $message = sprintf(getMessage('ADMIN_SPONSOR_PAYTYPE_ADDED'), postRequestElement('pay_name')); } else { // Free memory SQL_FREERESULT($result); // Entry does already exists - $message = sprintf(getMessage('ADMIN_SPONSOR_PAYTYPE_ALREADY'), REQUEST_POST('pay_name')); + $message = sprintf(getMessage('ADMIN_SPONSOR_PAYTYPE_ALREADY'), postRequestElement('pay_name')); } // Output message - LOAD_TEMPLATE('admin_settings_saved', false, $message); -} elseif ((REQUEST_ISSET_POST('edit')) || (REQUEST_ISSET_POST('del'))) { + loadTemplate('admin_settings_saved', false, $message); +} elseif ((isPostRequestElementSet('edit')) || (isPostRequestElementSet('del'))) { // Load all data $OUT = ''; $SW = 2; - foreach (REQUEST_POST('id') as $id => $sel) { + foreach (postRequestElement('id') as $id => $sel) { // Load entry - $result = SQL_QUERY_ESC("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM `{!_MYSQL_PREFIX!}_sponsor_paytypes` WHERE `id`='%s' LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `pay_name`, `pay_rate`, `pay_min_count`, `pay_currency` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `id`='%s' LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Load data list($name, $rate, $min, $curr) = SQL_FETCHROW($result); @@ -151,36 +158,33 @@ if (REQUEST_ISSET_POST('add')) { 'curr' => htmlspecialchars($curr) ); - if (REQUEST_ISSET_POST('edit')) { + if (isPostRequestElementSet('edit')) { // Edit entry - $OUT .= LOAD_TEMPLATE("admin_list_sponsor_pay_edit_row", true, $content); + $OUT .= loadTemplate('admin_list_sponsor_pay_edit_row', true, $content); } else { // Delete entry - $OUT .= LOAD_TEMPLATE("admin_list_sponsor_pay_del_row", true, $content); + $OUT .= loadTemplate('admin_list_sponsor_pay_del_row', true, $content); } } else { // Entry invalid - $OUT .= LOAD_TEMPLATE("admin_list_sponsor_pay_404", true, $id); + $OUT .= loadTemplate('admin_list_sponsor_pay_404', true, $id); } // Switch colors $SW = 3 - $SW; } // END - foreach - // Remember content in constant - define('__SPONSOR_ROWS', $OUT); - // Load main template depending on mode (edit/delete) - if (REQUEST_ISSET_POST('edit')) { + if (isPostRequestElementSet('edit')) { // Load main edit template - LOAD_TEMPLATE("admin_list_sponsor_pay_edit"); + loadTemplate('admin_list_sponsor_pay_edit', false, $OUT); } else { // Load main delete template - LOAD_TEMPLATE("admin_list_sponsor_pay_del"); + loadTemplate('admin_list_sponsor_pay_del', false, $OUT); } } else { // Load all payment types - $result = SQL_QUERY("SELECT id, pay_name, pay_rate, pay_min_count, pay_currency FROM `{!_MYSQL_PREFIX!}_sponsor_paytypes` ORDER BY pay_name", + $result = SQL_QUERY("SELECT `id`, `pay_name`, `pay_rate`, `pay_min_count`, `pay_currency` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` ORDER BY `pay_name` ASC", __FILE__, __LINE__); // Do we have some paytypes setup? @@ -201,7 +205,7 @@ if (REQUEST_ISSET_POST('add')) { ); // Add row - $OUT .= LOAD_TEMPLATE("admin_list_sponsor_pay_row", true, $content); + $OUT .= loadTemplate('admin_list_sponsor_pay_row', true, $content); // Switch colors $SW = 3 - $SW; @@ -210,22 +214,19 @@ if (REQUEST_ISSET_POST('add')) { // Free memory SQL_FREERESULT($result); - // Remember rows in constant for the template - define('__LIST_ROWS', $OUT); - // Load list template - define('__LIST_CONTENT', LOAD_TEMPLATE("admin_list_sponsor_pay", true)); + $content['list_out'] = loadTemplate('admin_list_sponsor_pay', true, $OUT); } else { // Noting setup so far! - define('__LIST_CONTENT', LOAD_TEMPLATE('admin_settings_saved', true, getMessage('ADMIN_SPONSOR_NO_PAYTYPES'))); + $content['list_out'] = loadTemplate('admin_settings_saved', true, getMessage('ADMIN_SPONSOR_NO_PAYTYPES')); } // Add new payment types here - define('__ADD_CONTENT', LOAD_TEMPLATE("admin_add_sponsor_paytype", true)); + $content['add_out'] = loadTemplate('admin_add_sponsor_paytype', true); // Load final template - LOAD_TEMPLATE("admin_sponsor_paytypes"); + loadTemplate('admin_sponsor_paytypes', false, $content); } -// +// [EOF] ?>