<?php
/************************************************************************
 * MXChange v0.2.1                                    Start: 07/03/2004 *
 * ================                             Last change: 08/22/2004 *
 *                                                                      *
 * -------------------------------------------------------------------- *
 * File              : what-config_rallye_prices.php                    *
 * -------------------------------------------------------------------- *
 * Short description : Setup rallye prices                              *
 * -------------------------------------------------------------------- *
 * Kurzbeschreibung  : Rallye-Preise einrichten                         *
 * -------------------------------------------------------------------- *
 *                                                                      *
 * -------------------------------------------------------------------- *
 * Copyright (c) 2003 - 2008 by Roland Haeder                           *
 * For more information visit: http://www.mxchange.org                  *
 *                                                                      *
 * This program is free software; you can redistribute it and/or modify *
 * it under the terms of the GNU General Public License as published by *
 * the Free Software Foundation; either version 2 of the License, or    *
 * (at your option) any later version.                                  *
 *                                                                      *
 * This program is distributed in the hope that it will be useful,      *
 * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
 * GNU General Public License for more details.                         *
 *                                                                      *
 * You should have received a copy of the GNU General Public License    *
 * along with this program; if not, write to the Free Software          *
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
 * MA  02110-1301  USA                                                  *
 ************************************************************************/

// Some security stuff...
if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
{
	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
	require($INC);
}
// Add description as navigation point
ADD_DESCR("admin", basename(__FILE__));

if (!empty($_GET['rallye']))
{
	// Price submitted?
	if (isset($_POST['add']))
	{
		if ((!empty($_POST['level'])) && ((!empty($_POST['points'])) || (!empty($_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=%d AND price_level='%s' LIMIT 1",
			 array(bigintval($_GET['rallye']), bigintval($_POST['level'])), __FILE__, __LINE__);

			if (SQL_NUMROWS($result) == 0)
			{
				// Ok, new price level entered!
				$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_rallye_prices (rallye_id, price_level, points, info)
VALUES ('%s', '%s', '%s', '%s')",
 array(
	bigintval($_GET['rallye']),
	bigintval($_POST['level']),
	$_POST['points'],
	$_POST['info']
), __FILE__, __LINE__);
				LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_PRICE_LEVEL_SAVED);
			}
			 else
			{
				// Free memory
				SQL_FREERESULT($result);

				// Price level found!
				LOAD_TEMPLATE("admin_settings_saved", false, RALLYE_PRICE_ALREADY_FOUND);
			}
		}
	}
	 elseif (isset($_POST['remove']))
	{
		// Check if at last one line is selected
		$SEL = SELECTION_COUNT($_POST['sel']);
		if ($SEL > 0)
		{
			// Delete selected entries
			foreach ($_POST['sel'] as $id=>$sel)
			{
				$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_rallye_prices WHERE id=%d 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=%d, price_level='%s', points='%s', info='%s' WHERE id=%d 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=%d 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."<A href=\"".URL."/modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=".$_GET['rallye']."\">".RALLYE_NO_PRICES_SELECTED_2."</A>".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=%d 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."<A href=\"".URL."/modules.php?module=admin&amp;what=config_rallye_prices&amp;rallye=".$_GET['rallye']."\">".RALLYE_NO_PRICES_SELECTED_2."</A>".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=%d 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 = "<INPUT type=\"checkbox\" name=\"sel[".$id."]\" class=\"admin_normal\" value=\"1\">";
			if ($active == "Y") $select = "<STRONG class=\"big\">".$id."</STRONG>";

			// 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);
	}
}
//
?>