0)
{
// Delete selected entries
foreach ($_POST['sel'] as $id => $sel)
{
$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
}
// Output message
LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ENTRIES_DELETED);
}
else
{
LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ENTRIES_NOT_DELETED);
}
}
elseif (isset($_POST['change']))
{
// Change entries
foreach ($_POST['level'] as $id => $level)
{
// Secure ID
$id = bigintval($id);
// Update entry
$result = 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($_POST['rallye_id'][$id], bigintval($level), $_POST['points'][$id], $_POST['infos'][$id], $id), __FILE__, __LINE__);
}
// Output message
LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_ENTRIES_CHANGED);
}
if (isset($_POST['edit']))
{
// Check if at last one line is selected
$SEL = SELECTION_COUNT($_POST['sel']);
if ($SEL > 0)
{
// Make selected editable
$SW = 2; $OUT = "";
foreach ($_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__);
list($rallye, $level, $points, $infos) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $id,
'rallyes' => ADD_OPTION_LINES("rallye_data", "id", "title", $rallye),
'level' => $level,
'points' => $points,
'infos' => $infos,
);
// Load row template and switch color
$OUT .= LOAD_TEMPLATE("admin_config_rallye_edit_row", true, $content);
$SW = 3 - $SW;
}
define('__PRICE_ROWS', $OUT);
// Prepare data for the main template
define('__RALLYE_ID', $_GET['rallye']);
// Load main template
LOAD_TEMPLATE("admin_config_rallye_edit");
}
else
{
// Nothing selected
$content = RALLYE_NO_PRICES_SELECTED_1."".RALLYE_NO_PRICES_SELECTED_2."".RALLYE_NO_PRICES_SELECTED_3;
LOAD_TEMPLATE("admin_settings_saved", false, $content);
}
}
elseif (isset($_POST['del']))
{
// Check if at last one line is selected
$SEL = SELECTION_COUNT($_POST['sel']);
if ($SEL > 0)
{
// List all prices
$SW = 2; $OUT = "";
foreach ($_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__);
list($rallye, $level, $points, $infos) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
if (empty($infos)) $infos = "---";
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $id,
'level' => $level,
'points' => $points,
'infos' => $infos,
);
// Load row template and switch color
$OUT .= LOAD_TEMPLATE("admin_config_rallye_del_row", true, $content);
$SW = 3 - $SW;
}
define('__PRICE_ROWS', $OUT);
// Prepare data for the main template
define('__RALLYE_ID', $_GET['rallye']);
// Load main template
LOAD_TEMPLATE("admin_config_rallye_del");
}
else
{
// Nothing selected
$content = RALLYE_NO_PRICES_SELECTED_1."".RALLYE_NO_PRICES_SELECTED_2."".RALLYE_NO_PRICES_SELECTED_3;
LOAD_TEMPLATE("admin_settings_saved", false, $content);
}
}
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($_GET['rallye'])), __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0)
{
// Load all prices for the selected rallye
$SW = 2; $OUT = "";
while(list($id, $level, $points, $infos) = SQL_FETCHROW($result))
{
if (empty($infos)) $infos = "---";
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $id,
'level' => $level,
'points' => $points,
'infos' => $infos,
);
// Load row template and switch color
$OUT .= LOAD_TEMPLATE("admin_config_rallye_prices_row", true, $content);
$SW = 3 - $SW;
}
// Free memory
SQL_FREERESULT($result);
define('__PRICE_ROWS', $OUT);
// Prepare data for the main template
define('__RALLYE_ID', $_GET['rallye']);
// Load main template
LOAD_TEMPLATE("admin_config_rallye_prices");
}
}
// Add form for adding new price level
if (empty($_POST['edit']))
{
LOAD_TEMPLATE("admin_add_rallye_prices", false, $_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__);
if (SQL_NUMROWS($result) > 0)
{
// List found rallyes
$SW = 2; $OUT = "";
while (list($id, $aid, $start, $end, $title, $alogin, $active) = SQL_FETCHROW($result))
{
$select = "";
if ($active == "Y") $select = "".$id."";
// Prepare data for the row template
$content = array(
'sw' => $SW,
'id' => $id,
'select' => $select,
'title' => $title,
'aid' => $aid,
'email_link' => CREATE_EMAIL_LINK($aid),
'alogin' => $alogin,
'start' => MAKE_DATETIME($start, "3"),
'end' => MAKE_DATETIME($end, "3"),
);
// Load row template and switch color
$OUT .= LOAD_TEMPLATE("admin_list_rallye_prices_row", true, $content);
$SW = 3 - $SW;
}
// Free memory
SQL_FREERESULT($result);
define('__RALLYE_ROWS', $OUT);
// Load main template
LOAD_TEMPLATE("admin_list_rallye_prices");
}
else
{
// No rallyes setup so far
LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_NO_RALLYES_SETUP);
}
}
//
?>