// Add description as navigation point
addMenuDescription('admin', __FILE__);
-if (isGetRequestElementSet(('rallye'))) {
+if (isGetRequestElementSet('rallye')) {
// Price submitted?
if (isPostRequestElementSet('add')) {
if ((isPostRequestElementSet(('level'))) && ((isPostRequestElementSet(('points'))) || (isPostRequestElementSet(('info'))))) {
SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_rallye_prices` (rallye_id, price_level, points, info)
VALUES ('%s','%s','%s','%s')",
array(
- bigintval(getRequestElement('rallye')),
- bigintval(postRequestElement('level')),
- postRequestElement('points'),
- postRequestElement('info')
+ bigintval(getRequestElement('rallye')),
+ bigintval(postRequestElement('level')),
+ postRequestElement('points'),
+ postRequestElement('info')
), __FILE__, __LINE__);
loadTemplate('admin_settings_saved', false, getMessage('RALLYE_PRICE_LEVEL_SAVED'));
} else {
// 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(
- postRequestElement('rallye_id', $id),
- bigintval($level),
- postRequestElement('points', $id),
- postRequestElement('infos', $id),
- $id
+ postRequestElement('rallye_id', $id),
+ bigintval($level),
+ postRequestElement('points', $id),
+ postRequestElement('infos', $id),
+ $id
), __FILE__, __LINE__);
}
foreach (postRequestElement('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);
foreach (postRequestElement('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);
}
} 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` ASC",
+ $result = SQL_QUERY_ESC("SELECT `id`, `price_level`, `points`, `info` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY `price_level` ASC",
array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// List found rallyes
$OUT = ''; $SW = 2;
while ($content = SQL_FETCHARRAY($result)) {
- $select = "<input type=\"checkbox\" name=\"sel[".$content['id']."]\" class=\"admin_normal\" value=\"1\">";
- if ($content['is_active'] == 'Y') $select = "<div class=\"big\">".$content['id']."</div>";
-
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $content['id'],
- 'select' => $select,
'title' => $content['title'],
'admin_id' => $content['admin_id'],
- 'email_link' => generateEmailLink($content['admin_id']),
+ 'admin_link' => generateAdminLink($content['admin_id']),
'login' => $content['login'],
'start' => generateDateTime($content['start_time'], 3),
'end' => generateDateTime($content['end_time'], 3),