X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_rallye_prices.php;h=380f1856be9982285a0cf6d503a59884005e5d11;hb=9d3e47c8ab6ff3ab7efca2a968d66a5ccf76728d;hp=09915021bdea7fac8b168a17cb9827cbaaef906e;hpb=7b0f17cd637e388049d2167811e4332cec1e979b;p=mailer.git diff --git a/inc/modules/admin/what-config_rallye_prices.php b/inc/modules/admin/what-config_rallye_prices.php index 09915021bd..380f1856be 100644 --- a/inc/modules/admin/what-config_rallye_prices.php +++ b/inc/modules/admin/what-config_rallye_prices.php @@ -51,18 +51,18 @@ if (REQUEST_ISSET_GET(('rallye'))) { if ((REQUEST_ISSET_POST(('level'))) && ((REQUEST_ISSET_POST(('points'))) || (REQUEST_ISSET_POST(('info'))))) { // Submitted data is valid, but maybe we already have this price level? $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s AND price_level='%s' LIMIT 1", - array(bigintval(REQUEST_GET('rallye')), bigintval(REQUEST_POST('level'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('rallye')), bigintval(REQUEST_POST('level'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 0) { // Ok, new price level entered! SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_rallye_prices` (rallye_id, price_level, points, info) VALUES ('%s','%s','%s','%s')", - array( - bigintval(REQUEST_GET('rallye')), - bigintval(REQUEST_POST('level')), - REQUEST_POST('points'), - REQUEST_POST('info') -), __FILE__, __LINE__); + array( + bigintval(REQUEST_GET('rallye')), + bigintval(REQUEST_POST('level')), + REQUEST_POST('points'), + REQUEST_POST('info') + ), __FILE__, __LINE__); LOAD_TEMPLATE('admin_settings_saved', false, getMessage('RALLYE_PRICE_LEVEL_SAVED')); } else { // Free memory @@ -79,7 +79,7 @@ VALUES ('%s','%s','%s','%s')", // Delete selected entries foreach (REQUEST_POST('sel') as $id => $sel) { SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE `id`=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + array(bigintval($id)), __FILE__, __LINE__); } // Output message @@ -95,13 +95,13 @@ VALUES ('%s','%s','%s','%s')", // Update entry SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_rallye_prices` SET rallye_id=%s, price_level='%s', points='%s', info='%s' WHERE `id`=%s LIMIT 1", - array( - REQUEST_POST('rallye_id', $id), - bigintval($level), - REQUEST_POST('points', $id]), - REQUEST_POST('infos', $id), - $id - ), __FILE__, __LINE__); + array( + REQUEST_POST('rallye_id', $id), + bigintval($level), + REQUEST_POST('points', $id), + REQUEST_POST('infos', $id), + $id + ), __FILE__, __LINE__); } // Output message @@ -117,7 +117,7 @@ VALUES ('%s','%s','%s','%s')", foreach (REQUEST_POST('sel') as $id => $sel) { // Load data to selected rallye $result = SQL_QUERY_ESC("SELECT rallye_id, price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE `id`=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + array(bigintval($id)), __FILE__, __LINE__); list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -125,7 +125,7 @@ VALUES ('%s','%s','%s','%s')", $content = array( 'sw' => $SW, 'id' => $id, - 'rallyes' => generateOptionList("rallye_data", "id", "title", $rallye), + 'rallyes' => generateOptionList("rallye_data", 'id', "title", $rallye), 'level' => $level, 'points' => $points, 'infos' => $infos, @@ -156,7 +156,7 @@ VALUES ('%s','%s','%s','%s')", foreach (REQUEST_POST('sel') as $id => $sel) { // Load data to selected rallye $result = SQL_QUERY_ESC("SELECT rallye_id, price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE `id`=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + array(bigintval($id)), __FILE__, __LINE__); list($rallye, $level, $points, $infos) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -190,7 +190,7 @@ VALUES ('%s','%s','%s','%s')", } else { // a rallye was selected, so check if there are already prices assigned... $result = SQL_QUERY_ESC("SELECT id, price_level, points, info FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level", - array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // Load all prices for the selected rallye @@ -254,8 +254,8 @@ WHERE d.admin_id=a.id ORDER BY start_time DESC", __FILE__, __LINE__); 'aid' => $content['admin_id'], 'email_link' => generateMemberEmailLink($content['admin_id']), 'alogin' => $content['login'], - 'start' => generateDateTime($content['start_time'], "3"), - 'end' => generateDateTime($content['end_time'], "3"), + 'start' => generateDateTime($content['start_time'], '3'), + 'end' => generateDateTime($content['end_time'], '3'), ); // Load row template and switch color