if (REQUEST_ISSET_GET(('rallye'))) {
// Price submitted?
- if (REQUEST_ISSET_POST(('add'))) {
+ if (REQUEST_ISSET_POST('add')) {
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",
$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,
);
// Load row template and switch color
- $OUT .= LOAD_TEMPLATE("admin_config_rallye_prices_row", true, $content);
+ $OUT .= LOAD_TEMPLATE('admin_config_rallye_prices_row', true, $content);
$SW = 3 - $SW;
} // END - while
define('__RALLYE_ID', REQUEST_GET('rallye'));
// Load main template
- LOAD_TEMPLATE("admin_config_rallye_prices");
+ LOAD_TEMPLATE('admin_config_rallye_prices');
}
}
// Add form for adding new price level
if (!REQUEST_ISSET_POST('edit')) {
- LOAD_TEMPLATE("admin_add_rallye_prices", false, REQUEST_GET('rallye'));
+ LOAD_TEMPLATE('admin_add_rallye_prices', false, REQUEST_GET('rallye'));
}
} else {
// No rallye selected so display all available without prices
- $result = SQL_QUERY("SELECT d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active
-FROM `{!_MYSQL_PREFIX!}_rallye_data` AS d, `{!_MYSQL_PREFIX!}_admins` AS a
-WHERE d.admin_id=a.id ORDER BY start_time DESC", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT
+ d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active
+FROM
+ `{!_MYSQL_PREFIX!}_rallye_data` AS d,
+LEFT JOIN
+ `{!_MYSQL_PREFIX!}_admins` AS a
+ON
+ d.admin_id=a.id
+ORDER BY
+ `d.start_time` DESC", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// List found rallyes
$OUT = ''; $SW = 2;
'select' => $select,
'title' => $content['title'],
'aid' => $content['admin_id'],
- 'email_link' => generateMemberEmailLink($content['admin_id']),
+ 'email_link' => generateEmailLink($content['admin_id']),
'alogin' => $content['login'],
'start' => generateDateTime($content['start_time'], '3'),
'end' => generateDateTime($content['end_time'], '3'),
);
// Load row template and switch color
- $OUT .= LOAD_TEMPLATE("admin_list_rallye_prices_row", true, $content);
+ $OUT .= LOAD_TEMPLATE('admin_list_rallye_prices_row', true, $content);
$SW = 3 - $SW;
}
define('__RALLYE_ROWS', $OUT);
// Load main template
- LOAD_TEMPLATE("admin_list_rallye_prices");
+ LOAD_TEMPLATE('admin_list_rallye_prices');
} else {
// No rallyes setup so far
LOAD_TEMPLATE('admin_settings_saved', false, getMessage('RALLYE_NO_RALLYES_SETUP'));