<?
//require_once('./classes/DbManager.class.php');
class UsersCities
{
    private $cityid;
    private $userid;
    private $enddate;
    private $endtime;
    private $endround;

    private $db;

    public function __construct()
    {
    	$this->db = new DbManager();
    }

    public function setUsersCities($cityid, $userid, $enddate, $endtime, $endround)
    {
     	$this->cityid = $cityid;
        $this->userid = $userid;
        $this->enddate = $enddate;
        $this->endtime = $endtime;
        $this->endround = $endround;
    }

    public function CityId()
    {
    	return $this->cityid;
    }
    public function UserId()
    {
    	return $this->userid;
    }
    public function EndDate()
    {
    	return $this->enddate;
    }
    public function EndTime()
    {
    	return $this->endtime;
    }
    public function EndRound()
    {
    	return $this->endround;
    }

    public function setCityId($value)
    {
    	$this->cityid = $value;
    }
    public function setUserId($value)
    {
    	$this->userid = $value;
    }
    public function setEndDate($value)
    {
        $this->enddate = $value;
    }
    public function setEndTime($value)
    {
    	$this->endtime = $value;
    }
    public function setEndRound($value)
    {
    	$this->endround = $value;
    }

	public function checkUserCity($cityid, $userid)
	{
		$foundUsers = "";
		$foundUser = "";
		$retval = false;
		
		$foundUsers = $this->db->getUsersByCityId($cityid);
		if (is_array($foundUsers))
		{
			foreach ($foundUsers as $foundUser)
			{
				if ($foundUser instanceof User)
				{
					if ($foundUser->getUserId() == $userid)
					{
						$retval = true;
						break;
					}
				}
			}
		}
		elseif ($foundUsers instanceof User)
		{
			if ($foundUsers->getUserId() == $userid)
			{
				$retval = true;
			}
		}
		return $retval;
	}

    public function getUsersCitiesByCityId($cityid)
    {
		return $this->db->getUsersCitiesByCityId($cityid);
    }

    public function getUsersCitiesByUserId($userid)
    {
    	return $this->db->getUsersCitiesByUserId($userid);
    }

    public function getUsersCitiesByUserIdAndCityId($userid, $city)
    {
    	return $this->db->getUsersCitiesByUserIdAndCityId($userid, $city);
    }

    public function insertUsersCities($cityid, $userid)
    {
    	$this->db->insertUsersCities($cityid, $userid);
    }

    public function updateUsersCities()
    {
    	$this->db->updateUsersCities($this);
    }
}
?><?
	//require_once('UsersCities.class.php');

class User
{
    private $firstname;
    private $lastname;
    private $email;
    private $password;
    private $isactive;
    private $userid;
    private $islogedin;
    private $isadmin;
    private $nationality;
    private $birthday;
    private $cellphone;
    private $city;
    private $occupation;
    private $isrunner;
    private $languages;
    private $whyiwillwin;
    private $supportcount;
    private $supportnames;
    private $supportemail;
    private $supportcellphone;
    private $medicalconditions;
    private $medicaltreatment;
	private $comment;
	private $usercity;

    public function getFirstName()
    {
		return utf8_decode($this->setReturnValue($this->firstname));
    }

    public function setFirstName($value)
    {
        $this->firstname = $value;
    }

    public function getLastName()
    {
		return utf8_decode($this->setReturnValue($this->lastname));
    }

    public function setLastName($value)
    {
        $this->lastname = $value;
    }

    public function getEmail()
    {
        return $this->email;
    }

    public function setEmail($value)
    {
        if ($this->isEmail($value))
        {
            $this->email = $value;
        }
    }

    public function getPass()
    {
        return $this->setReturnValue($this->password);
    }

    public function setPass($value)
    {
    	$this->password = md5($value);
    }

    public function setPassFromDB($value)
    {
    	$this->password = $value;
    }

    public function isActive()
    {
        return $this->isactive;
    }

    public function setIsActive($value)
    {
        $this->isactive = $value;
    }

    public function getUserId()
    {
        return $this->userid;
    }

    public function setUserId($value)
    {
        $this->userid = $value;
    }

    public function isLogedIn()
    {
        return $this->islogedin;
    }

    public function setIsLogedIn($value)
    {
        $this->islogedin = $value;
    }

    public function isAdmin()
    {
        return $this->isadmin;
    }

    public function setIsAdmin($value)
    {
        $this->isadmin = $value;
    }

    public function getNationality()
    {
        return $this->setReturnValue($this->nationality);
    }

    public function setNationality($value)
    {
        $this->nationality = $value;
    }

    public function getBirthDay()
    {
        return $this->setReturnValue($this->birthday);
    }

    public function setBirthDay($value)
    {
        $this->birthday = $value;
    }

    public function getCellPhone()
    {
        return $this->setReturnValue($this->cellphone);
    }

    public function setCellPhone($value)
    {
        $this->cellphone = $value;
    }

    public function getCity()
    {
        return $this->setReturnValue($this->city);
    }

    public function setCity($value)
    {
        $this->city = $value;
    }

    public function getOccupation()
    {
        return $this->setReturnValue($this->occupation);
    }

    public function setOccupation($value)
    {
        $this->occupation = $value;
    }

    public function isRunner()
    {
        return $this->isrunner;
    }

    public function setIsRunner($value)
    {
        $this->isrunner = $value;
    }

    public function getLanguages()
    {
        return $this->setReturnValue($this->languages);
    }

    public function setLanguages($value)
    {
        $this->languages = $value;
    }

    public function getWhyIWillWin()
    {
		return utf8_decode($this->setReturnValue($this->whyiwillwin));
    }

    public function setWhyIWillWin($value)
    {
        $this->whyiwillwin = $value;
    }

    public function getSupportCount()
    {
        return $this->supportcount;
    }

    public function setSupportCount($value)
    {
        $this->supportcount = $value;
    }

    public function getSupportNames()
    {
        return utf8_decode($this->setReturnValue($this->supportnames));
    }

    public function setSupportNames($value)
    {
        $this->supportnames = $value;
    }

    public function getSupportEmail()
    {
        return $this->setReturnValue($this->supportemail);
    }

    public function setSupportEmail($value)
    {
        $this->supportemail = $value;
    }

    public function getSupportCellPhone()
    {
        return $this->setReturnValue($this->supportcellphone);
    }

    public function setSupportCellPhone($value)
    {
        $this->supportcellphone = $value;
    }

    public function getMedicalConditions()
    {
        return $this->medicalconditions;
    }

    public function setMedicalConditions($value)
    {
        $this->medicalconditions = $value;
    }

    public function getMedicalTreatment()
    {
        return $this->medicaltreatment;
    }

    public function setMedicalTreatment($value)
    {
        $this->medicaltreatment = $value;
    }

    public function getComment()
    {
		return utf8_decode($this->setReturnValue($this->comment));
    }

    public function setComment($value)
    {
        $this->comment = $value;
    }

    public function getCurrentUserCity()
    {
    	return $this->usercity;
    }

    public function setCurrentUserCity($value)
    {
    	if ($this->usercity == "")
        {
        	$this->usercity = new UsersCities();
        }
    	$this->usercity = $value;
    }

  //  echo "Benutzer " . $um->getUser()->getName() . " ist " . $um->getUser()->getAktiv();
    public function __construct($email = "", $password = "")
    {
    	if ($email != "")
        {
        	$this->setEmail($email);
        	$this->setPass($password);
        }
    }

    private function isEmail($email)
    {
        //TODO: mailprüfung
        return True;
    }

    private function setReturnValue($value)
    {
    	if ($value == "" || $value == "0000-00-00")
        {
        	$value = "-";
        }
        return $value;
    }

}
?><?
require_once("./classes/DbConfig.class.php");
//require_once("./classes/CityResult.class.php");
//require_once("./funcs/funcs.php");

class DbManager
{
	private $dbconfig;
    private $link;
    private $db;
    private $isConnected;

    public function __construct()
    {
    	$this->dbconfig = new DbConfig();
        $this->isConnected = false;
    }

	public function connect()
    {
    	global $link, $db;
   	    $link = mysqli_connect($this->dbconfig->getDbHost(),$this->dbconfig->getDbUser(),$this->dbconfig->getDbPass()) or die("Keine Verbindung zur Datenbank.".mysqli_error($link));
   	    $db = mysqli_select_db($link, $this->dbconfig->getDbName()) or die ("Konnte Datenbank nicht oeffnen.".mysqli_error($link));
	}

    private function checkConnection()
    {
//		if (!$this->isConnected)
//        {
        	$this->connect();
            $this->isConnected = True;
//        }
    }

    private function executeCommand($cmd)
    {
    	global $link;
		$this->checkConnection();
        $result = mysqli_query($link, $cmd);
        if (!$result)
        {
	    	echo 'Abfrage konnte nicht ausgeführt werden: <br>'.$cmd.'<br>'.mysqli_error($link);
	    	exit;
        }
        else
        {
        	return $result;
        }
    }

	
######################################################Results################################
	
    public function getResultsByCityId($CityId)
    {
        $sqlcmd = "(select u.UserId, uc.CityId, FirstName, LastName, BirthDay, Nationality, EndRound, EndDate, EndTime ";
		$sqlcmd .= "from users u ";
		$sqlcmd .= "inner join userscities uc ";
		$sqlcmd .= "on u.userid = uc.userid and uc.cityid = ".$CityId." ";
		$sqlcmd .= "where uc.endround=0 and u.isActive = 1 ";
		$sqlcmd .= "order by u.firstname asc limit 1000) ";
		$sqlcmd .= "union ";
		$sqlcmd .= "(select u.UserId, uc.CityId, FirstName, LastName, BirthDay, Nationality, EndRound, EndDate, EndTime ";
		$sqlcmd .= "from users u ";
		$sqlcmd .= "inner join userscities uc ";
		$sqlcmd .= "on u.userid = uc.userid and uc.cityid = ".$CityId." ";
		$sqlcmd .= "where uc.endround>99 and u.isActive = 1 ";
		$sqlcmd .= "order by uc.endround desc, uc.enddate desc, uc.endtime desc, u.lastname asc limit 1000);";
        return $this->getResultsFromDB($sqlcmd);
    }

    private function getResultsFromDB($sqlcmd)
    {
    	$result = $this->executeCommand($sqlcmd);
        $rownr = 0;
		$results = "";
        while ($row = mysqli_fetch_object($result))
        {
            $results[$rownr] = new CityResult();
            $this->setResultValues($results[$rownr], $row);
            $rownr++;
        }
      	return $results;
    }

    private function setResultValues($cro, $row)
    {
        $cro->setUserId($row->UserId);
        $cro->setCityId($row->CityId);
        $cro->setFirstName($row->FirstName);
        $cro->setLastName($row->LastName);
        $cro->setNationality($row->Nationality);
        $cro->setBirthDay($row->BirthDay);
        $cro->setEndRound($row->EndRound);
        $cro->setEndDate($row->EndDate);
        $cro->setEndTime($row->EndTime);
    }

###########################################User#########################

	public function getUsersByRunnerAndActive($isrunner, $isaktiv)
	{
		
	}
	
	public function updateUsers($users)
	{
		foreach($users as $u)
		{
			$this->updateUser($u);
		}
	}
	
	public function getUsers()
	{
		$sqlcmd = "select * from users;";
		return $this->getUsersFromDB($sqlcmd);
	}
	
	public function getUsersByCityId($CityId)
	{
		$sqlcmd = "select * from users where userid in (select userid from userscities where cityid = ".$CityId.") order by firstname;";
		return $this->getUsersFromDB($sqlcmd);
	}
	
	public function getUserByEmail($Email)
	{
		$sqlcmd = "select * from users where email = '".$Email."';";
		return $this->getUsersFromDB($sqlcmd);
	}
	
	public function getUserByUserId($UserId)
	{
		$sqlcmd = "select * from users where userid = ".$UserId.";";
		return $this->getUsersFromDB($sqlcmd);
	}
	
    public function getUsersByCityIdAndActive($CityId, $active)
    {
        $sqlcmd = "select * from users where isactive = ".$active." and userid in (select userid from userscities where cityid = ".$CityId.");";
        //$sqlcmd = "select * from users where isactive = ".$active." and userid in (select userid from userscities where cityid = ".$CityId.");";
        return $this->getUsersFromDB($sqlcmd);
    }

    private function getUsersFromDB($sqlcmd)
    {
    	$result = $this->executeCommand($sqlcmd);
        $rownr = 0;
		$users = "";
		$returnvalue = "";
        while ($row = mysqli_fetch_object($result))
        {
            $users[$rownr] = new User();
            $this->setUserValues($users[$rownr], $row);
            $rownr++;
        }
		if ($rownr == 1)
		{
			$returnvalue = $users[0];
		}
		else
		{
			$returnvalue = $users;
		}
		return $returnvalue;
    }

    private function setUserValues($uo, $row)
    {
        $uo->setUserId($row->UserID);
        $uo->setEmail($row->Email);
        $uo->setPassFromDB($row->Password);
        $uo->setFirstName($row->FirstName);
        $uo->setLastName($row->LastName);
        $uo->setNationality($row->Nationality);
        $uo->setBirthDay($row->BirthDay);
        $uo->setCellPhone($row->CellPhone);
        $uo->setCity($row->City);
        $uo->setOccupation($row->Occupation);
        if ($row->isActive == '')
        {
        	$uo->setIsActive(0);
        }
        else
        {
        	$uo->setIsActive($row->isActive);
        }
        if ($row->isRunner == '')
        {
        	$uo->setIsRunner(0);
        }
        else
        {
        	$uo->setIsRunner($row->isRunner);
        }
        if ($row->isAdmin == '')
        {
        	$uo->setIsAdmin(0);
        }
        else
        {
        	$uo->setIsAdmin($row->isAdmin);
        }
		$uo->setLanguages($row->Languages);
        $uo->setWhyIWillWin($row->WhyIWillWin);
        if ($row->SupportCount == '')
        {
        	$uo->setSupportCount(0);
        }
        else
        {
        	$uo->setSupportCount($row->SupportCount);
        }
        $uo->setSupportNames($row->SupportNames);
        $uo->setSupportEmail($row->SupportEmail);
        $uo->setSupportCellPhone($row->SupportCellPhone);
        if ($row->MedicalConditions == '')
        {
        	$uo->setMedicalConditions(0);
        }
        else
        {
        	$uo->setMedicalConditions($row->MedicalConditions);
        }
		$uo->setMedicalTreatment($row->MedicalTreatment);
        $uo->setComment($row->Comment);
    }

    public function getUser($userclass)
    {
    	$sqlab = "select * from users";
        $sqlab .= " where isAdmin = 1 and Email = \"" . $userclass->getEmail() . "\" and Password = \"" . $userclass->getPass() . "\";";

        $result = $this->executeCommand($sqlab);
        if (mysqli_num_rows($result)==1)
        {
            $row = mysqli_fetch_object($result);
            $this->setUserValues($userclass, $row);
            $userclass->setIsLogedIn(1);
        }
        else
        {
            $userclass->setIsLogedIn(0);
        }
    }

    public function insertUser($userobject)
    {
		//TODO: user updateten
        $returnvalue = 0;

		$this->executeCommand($this->createUserSQLCommand($userobject, 'i'));
        if (mysql_affected_rows() > 0)
        {
	        $returnvalue = mysql_insert_id();
        }
        return $returnvalue;
    }

    public function updateUser($userobject)
    {
    	//TODO: userinserten
        $returnvalue = false;

        $this->executeCommand($this->createUserSQLCommand($userobject, 'u'));
        if (mysql_affected_rows() > 0)
        {
	        $returnvalue = true;
        }
        return $returnvalue;
    }

    private function createUserSQLCommand($userobject, $commandType)
    {
		$sqlab = "";

		if ($commandType == 'i')
        {
           	$sqlab = "insert into users (Email, Password, FirstName, LastName, Nationality, ";
            $sqlab .= "BirthDay, CellPhone, City, Occupation, isActive, isAdmin, isRunner, ";
            $sqlab .= "Languages, WhyIWillWin, SupportCount, SupportNames, SupportEmail, ";
            $sqlab .= "SupportCellPhone, MedicalConditions, MedicalTreatment, Comment) ";
	        $sqlab .= "values (\"".$userobject->getEmail()."\", \"".$userobject->getPass()."\", ";
            $sqlab .= "\"".$userobject->getFirstName()."\", \"".$userobject->getLastName()."\", ";
            $sqlab .= "\"".$userobject->getNationality()."\", \"".$userobject->getBirthday()."\", ";
            $sqlab .= "\"".$userobject->getCellPhone()."\", \"".$userobject->getCity()."\", ";
            $sqlab .= "\"".$userobject->getOccupation()."\", ".$userobject->isActive().", ";
            $sqlab .= "".$userobject->isAdmin().", ".$userobject->isRunner().", ";
            $sqlab .= "\"".$userobject->getLanguages()."\", \"".$userobject->getWhyIWillWin()."\", ";
            $sqlab .= "\"".$userobject->getSupportCount()."\", \"".$userobject->getSupportNames()."\", ";
            $sqlab .= "\"".$userobject->getSupportEmail()."\", \"".$userobject->getSupportCellPhone()."\", ";
            $sqlab .= "".$userobject->getMedicalConditions().", \"".$userobject->getMedicalTreatment()."\", ";
            $sqlab .= "\"".$userobject->getComment()."\");";
//        	echo "sql: ".$sqlab;
        }
        else if ($commandType == 'u')
        {
        	//TODO: update command
           	$sqlab = "update users ";
	        $sqlab .= "set Email=\"".$userobject->getEmail()."\", Password=\"".$userobject->getPass()."\", ";
            $sqlab .= "FirstName = \"".$userobject->getFirstName()."\", LastName = \"".$userobject->getLastName()."\", ";
            $sqlab .= "Nationality = \"".$userobject->getNationality()."\", BirthDay = \"".$userobject->getBirthday()."\", ";
            $sqlab .= "CellPhone = \"".$userobject->getCellPhone()."\", City = \"".$userobject->getCity()."\", ";
            $sqlab .= "Occupation = \"".$userobject->getOccupation()."\", isActive = ".$userobject->isActive().", ";
            $sqlab .= "isAdmin = ".$userobject->isAdmin().", isRunner = ".$userobject->isRunner().", ";
            $sqlab .= "Languages = \"".$userobject->getLanguages()."\", WhyIWillWin = \"".$userobject->getWhyIWillWin()."\", ";
            $sqlab .= "SupportCount = ".$userobject->getSupportCount().", SupportNames = \"".$userobject->getSupportNames()."\", ";
            $sqlab .= "SupportEmail = \"".$userobject->getSupportEmail()."\", SupportCellPhone = \"".$userobject->getSupportCellPhone()."\", ";
            $sqlab .= "MedicalConditions = ".$userobject->getMedicalConditions().", MedicalTreatment = \"".$userobject->getMedicalTreatment()."\", ";
            $sqlab .= "Comment = \"".$userobject->getComment()."\" ";
            $sqlab .= "where UserId = ".$userobject->getUserId().";";
//        	echo "sql: ".$sqlab;
        }
        else if ($commandType == 'd')
        {
        	//TODO: delete command
        }
        return $sqlab;
    }

//#####################Blog##########################
    public function insertNews($blogobject)
    {
		$returnvalue = 0;

        $gd = getdate();
        $datum = date('Y-m-d', $gd[0]);
        $zeit = date('H:i:s', $gd[0]);

    	$sqlab = "insert into blogs (Datum, Zeit, Eintrag, UserID) ";
        $sqlab .= "values \"".$datum."\", \"".$zeit."\", \"".$blogobject->getEintrag()."\", \"".$blogobject->getUserID()."\"";

        $this->executeCommand($sqlab);
        if (mysql_affected_rows() > 0)
        {
	        $returnvalue = mysql_insert_id();
        }
    }

//####################Inspirations############################

	public function insertInspiration($LanguageID, $EntryDate, $EntryTime, $Subject, $Inspiration, $Author, $Active)
	{
		$returnvalue = 0;
		$sqlcmd = "insert into inspirations (LanguageID, EntryDate, EntryTime, Subject, Inspiration, Author, Active) values ('".$LanguageID."', '".$EntryDate."', '".$EntryTime."', '".$Subject."', '".$Inspiration."', '".$Author."', '".$Active."');";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = mysql_insert_id();
		}
		return $returnvalue;
	}

	public function updateInspiration($InspirationID, $LanguageID, $EntryDate, $EntryTime, $Subject, $Inspiration, $Author, $Active)
	{
		$returnvalue = false;
		$sqlcmd = "update inspirations set LanguageID = '".$LanguageID."', EntryDate = '".$EntryDate."', EntryTime = '".$EntryTime."', Subject = '".$Subject."', Inspiration = '".$Inspiration."', Author = '".$Author."', Active = '".$Active."' where inspirationid = ".$InspirationID.";";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}

	public function getInspirationByInspirationId($obj)
	{
		$sqlcmd = "select * from inspirations where inspirationid = ".$obj->InspirationId().";";
		$result = $this->executeCommand($sqlcmd);
		if (mysqli_num_rows($result)==1)
		{
			$row = mysqli_fetch_object($result);
			$obj->setInspirationID($row->InspirationID);
			$obj->setLanguageID($row->LanguageID);
			$obj->setEntryDate($row->EntryDate);
			$obj->setEntryTime($row->EntryTime);
			$obj->setSubject($row->Subject);
			$obj->setInspiration($row->Inspiration);
			$obj->setAuthor($row->Author);
			$obj->setActive($row->Active);
		}
	}
	
	public function getInspirations()
	{
		$sqlcmd = "select * from inspirations order by EntryDate, EntryTime;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$values[$rownr] = new Inspiration();
			$values[$rownr]->setInspirationID($row->InspirationID);
			$values[$rownr]->setLanguageID($row->LanguageID);
			$values[$rownr]->setEntryDate($row->EntryDate);
			$values[$rownr]->setEntryTime($row->EntryTime);
			$values[$rownr]->setSubject($row->Subject);
			$values[$rownr]->setInspiration($row->Inspiration);
			$values[$rownr]->setAuthor($row->Author);
			$values[$rownr]->setActive($row->Active);
			$rownr++;
		}
		return $values;
	}
	
	
	//####################FAQ############################
	
	public function insertFAQ($LanguageID, $Headline, $FAQ, $Position, $Active)
	{
		$returnvalue = 0;
		$sqlcmd = "insert into faq (LanguageID, Headline, FAQ, Position, Active) values ('".$LanguageID."', '".$Headline."', '".$FAQ."', '".$Position."', '".$Active."');";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = mysql_insert_id();
		}
		return $returnvalue;
	}
	
	public function updateFAQ($FAQID, $LanguageID, $Headline, $FAQ, $Position, $Active)
	{
		$returnvalue = false;
		$sqlcmd = "update faq set LanguageID = '".$LanguageID."', Headline = '".$Headline."', FAQ = '".$FAQ."', Position = '".$Position."', Active = '".$Active."' where FAQID = ".$FAQID.";";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}

	public function getFAQByLanguageID($LanguageID)
	{
		$sqlcmd = "select * from faq where LanguageID = '".$LanguageID."' order by position;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$values[$rownr] = new FAQ();
			$values[$rownr]->setFAQID($row->FAQId);
			$values[$rownr]->setLanguageID($row->LanguageID);
			$values[$rownr]->setHeadline($row->Headline);
			$values[$rownr]->setFAQ($row->FAQ);
			$values[$rownr]->setPosition($row->Position);
			$values[$rownr]->setActive($row->Active);
			$rownr++;
		}
		return $values;
	}
	
	public function getFAQByFAQId($obj)
	{
		$sqlcmd = "select * from faq where faqid = '".$obj->FAQId()."';";
		$result = $this->executeCommand($sqlcmd);
		if (mysqli_num_rows($result)==1)
		{
			$row = mysqli_fetch_object($result);
			$obj->setFAQ($row->FAQ);
			$obj->setLanguageId($row->LanguageId);
			$obj->setHeadline($row->Headline);
			$obj->setPosition($row->Position);
			$obj->setActive($row->Active);
		}
	}
	
	public function getFAQ()
	{
		$sqlcmd = "select * from faq;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$values[$rownr] = new FAQ();
			$values[$rownr]->setFAQId($row->FAQId);
			$values[$rownr]->setHeadline($row->Headline);
			$values[$rownr]->setFAQ($row->FAQ);
			$values[$rownr]->setPosition($row->Position);
			$values[$rownr]->setActive($row->Active);
			$rownr++;
		}
		return $values;
	}
	
	####################################################City###################################
	
	public function getCities()
	{
		$sqlcmd = "select * from cities order by city;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$cities[$rownr] = new City();
			$cities[$rownr]->setCityId($row->CityID);
			$cities[$rownr]->setCity($row->City);
			$cities[$rownr]->setStartDate($row->StartDate);
			$cities[$rownr]->setStartTime($row->StartTime);
			$cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
			$rownr++;
		}
		return $cities;
	}
	
	public function getCitiesByActive($active)
	{
		$sqlcmd = "select * from cities where active = ".$active." order by StartDate;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$cities[$rownr] = new City();
			$cities[$rownr]->setCityId($row->CityID);
			$cities[$rownr]->setCity($row->City);
			$cities[$rownr]->setStartDate($row->StartDate);
			$cities[$rownr]->setStartTime($row->StartTime);
			$cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
			$rownr++;
		}
		return $cities;
	}

	public function getCitiesByFinished($finished)
	{
		$sqlcmd = "select * from cities where finished = ".$finished." order by StartDate;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$cities[$rownr] = new City();
			$cities[$rownr]->setCityId($row->CityID);
			$cities[$rownr]->setCity($row->City);
			$cities[$rownr]->setStartDate($row->StartDate);
			$cities[$rownr]->setStartTime($row->StartTime);
			$cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
			$rownr++;
		}
		return $cities;
	}

	public function getCitiesByCountryAndActive($short, $active)
	{
		$sqlcmd = "select * from cities where country = '".$short."' and active = ".$active." order by StartDate;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$cities[$rownr] = new City();
			$cities[$rownr]->setCityId($row->CityID);
			$cities[$rownr]->setCity($row->City);
			$cities[$rownr]->setStartDate($row->StartDate);
			$cities[$rownr]->setStartTime($row->StartTime);
			$cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
			$rownr++;
		}
		return $cities;
	}

	public function getCitiesAndCountriesByStartDate($datum)
	{
		$sqlcmd = "select c.CityID, c.City, c.StartDate, c.StartTime, c2.Country, c.Abbreviation, c.Racecourse, c.Active, c.TimeShift, c.Finished from cities c inner join countries c2 on c.country = c2.short where c.startdate > \"".$datum."\" order by c.startdate asc;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$cities[$rownr] = new City();
			$cities[$rownr]->setCityId($row->CityID);
			$cities[$rownr]->setCity($row->City);
			$cities[$rownr]->setStartDate($row->StartDate);
			$cities[$rownr]->setStartTime($row->StartTime);
			$cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
			$rownr++;
		}
		return $cities;
	}
	
	public function getCitiesAndCountriesByStartDateAndActive($datum, $active)
	{
		$sqlcmd = "select c.CityID, c.City, c.StartDate, c.StartTime, c2.Country, c.Abbreviation, c.Racecourse, c.Active, c.TimeShift, c.Finished from cities c inner join countries c2 on c.country = c2.short where c.startdate > \"".$datum."\" and c.active = ".$active." order by c.startdate asc;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$cities[$rownr] = new City();
			$cities[$rownr]->setCityId($row->CityID);
			$cities[$rownr]->setCity($row->City);
			$cities[$rownr]->setStartDate($row->StartDate);
			$cities[$rownr]->setStartTime($row->StartTime);
			$cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
			$rownr++;
		}
		return $cities;
	}

	public function getCitiesByStartDate($datum)
    {
        $sqlcmd = "select * from cities where startdate > \"".$datum."\" order by startdate asc;";
        $result = $this->executeCommand($sqlcmd);
        $rownr = 0;
        while ($row = mysqli_fetch_object($result))
        {
            $cities[$rownr] = new City();
            $cities[$rownr]->setCityId($row->CityID);
	        $cities[$rownr]->setCity($row->City);
	        $cities[$rownr]->setStartDate($row->StartDate);
	        $cities[$rownr]->setStartTime($row->StartTime);
	        $cities[$rownr]->setCountry($row->Country);
			$cities[$rownr]->setAbbreviation($row->Abbreviation);
			$cities[$rownr]->setActive($row->Active);
			$cities[$rownr]->setRacecourse($row->Racecourse);
			$cities[$rownr]->setTimeShift($row->TimeShift);
			$cities[$rownr]->setFinished($row->Finished);
            $rownr++;
        }
        return $cities;
    }

	public function getCityByAbbreviation($co)
    {
		$sqlcmd = "select * from cities where abbreviation=\"".$co->Abbreviation()."\";";
        $result = $this->executeCommand($sqlcmd);
        if (mysqli_num_rows($result)==1)
        {
            $row = mysqli_fetch_object($result);
	        $co->setCityId($row->CityID);
	        $co->setCity($row->City);
	        $co->setStartDate($row->StartDate);
	        $co->setStartTime($row->StartTime);
	        $co->setCountry($row->Country);
			$co->setAbbreviation($row->Abbreviation);
			$co->setActive($row->Active);
			$co->setRacecourse($row->Racecourse);
			$co->setTimeShift($row->TimeShift);
			$co->setFinished($row->Finished);
		}
    }

    public function getCityByCity($co)
    {
        $sqlcmd = "select * from cities where city=\"".$co->City()."\";";
        $result = $this->executeCommand($sqlcmd);
        if (mysqli_num_rows($result)==1)
        {
            $row = mysqli_fetch_object($result);
	        $co->setCityId($row->CityID);
	        $co->setCity($row->City);
	        $co->setStartDate($row->StartDate);
	        $co->setStartTime($row->StartTime);
	        $co->setCountry($row->Country);
			$co->setAbbreviation($row->Abbreviation);
			$co->setRacecourse($row->Racecourse);
			$co->setActive($row->Active);
			$co->setTimeShift($row->TimeShift);
			$co->setFinished($row->Finished);
		}
    }

	public function getCityByCityId($co)
	{
		$sqlcmd = "select * from cities where cityid=\"".$co->CityId()."\";";
		$result = $this->executeCommand($sqlcmd);
		if (mysqli_num_rows($result)==1)
		{
			$row = mysqli_fetch_object($result);
			$co->setCityId($row->CityID);
			$co->setCity($row->City);
			$co->setStartDate($row->StartDate);
			$co->setStartTime($row->StartTime);
			$co->setCountry($row->Country);
			$co->setAbbreviation($row->Abbreviation);
			$co->setActive($row->Active);
			$co->setRacecourse($row->Racecourse);
			$co->setTimeShift($row->TimeShift);
			$co->setFinished($row->Finished);
		}
	}
	
	public function insertCity($cityname, $startDate, $startTime, $country, $abbreviation, $racecourse, $active, $timeshift, $finished)
	{
		$returnvalue = 0;
		$sqlcmd = "insert into cities (city, startdate, starttime, country, abbreviation, racecourse, active, timeshift, finished) values ('".$cityname."', '".$startDate."', '".$startTime."', '".$country."', '".$abbreviation."', '".$racecourse."', '".$active."', '".$timeshift."', '".$finished."');";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = mysql_insert_id();
		}
		return $returnvalue;
	}
	
	public function updateCity($cityid, $cityname, $startDate, $startTime, $country, $abbreviation, $racecourse, $active, $timeshift, $finished)
	{
		$returnvalue = false;
		$sqlcmd = "update cities set city = '".$cityname."', startdate = '".$startDate."', starttime = '".$startTime."', country = '".$country."', abbreviation = '".$abbreviation."', racecourse = '".$racecourse."', active = '".$active."', timeshift = '".$timeshift."', finished = '".$finished."' where cityid = ".$cityid.";";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}
	
	###################################################UserCities################################
	
    public function getUsersCitesByUserId($userid)
    {
    }

    public function getUsersCitesByCityId($cityid)
    {
    }

    public function getUsersCitiesByUserIdAndCityId($userid, $cityid)
    {
        $sqlcmd = "select * from userscities where cityid=".$cityid." and userid=".$userid.";";
        $result = $this->executeCommand($sqlcmd);
        $uco = new UsersCities();
        if (mysqli_num_rows($result)==1)
        {
            $row = mysql_fetch_object($result);
	        $uco->setUsersCities($row->CityID, $row->UserID, $row->EndDate, $row->EndTime, $row->EndRound);
		}
        return $uco;
    }

    public function insertUsersCities($cityid, $userid)
    {
    	$sqlcmd = "insert into userscities (CityId, UserId) values (".$cityid.", ".$userid.");";
        $this->executeCommand($sqlcmd);
    }

    public function updateUsersCities($uco)
    {
    	$sqlcmd = "update userscities set EndDate = \"".$uco->EndDate()."\", EndTime = \"".$uco->EndTime()."\", EndRound = ".$uco->EndRound()." where UserId = ".$uco->UserId()." and CityId = ".$uco->CityId().";";
        $this->executeCommand($sqlcmd);
    }
	
	####################################################Configuration##############################
	public function insertConfiguration($LanguageID, $Headline, $FAQ, $Active)
	{
		$returnvalue = 0;
		$sqlcmd = "insert into faq (LanguageID, Headline, FAQ, Active) values ('".$LanguageID."', '".$Headline."', '".$FAQ."', '".$Active."');";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = mysql_insert_id();
		}
		return $returnvalue;
	}
	
	public function updateConfiguration($FAQID, $LanguageID, $Headline, $FAQ, $Active)
	{
		$returnvalue = false;
		$sqlcmd = "update faq set LanguageID = '".$LanguageID."', Headline = '".$Headline."', FAQ = '".$FAQ."', Active = '".$Active."' where FAQID = ".$FAQID.";";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}
	
	public function getConfigurationByPage($Page)
	{
		$sqlcmd = "select c.*, p.page from configuration c inner join pages on c.pageid = p.pageid where p.page = '".strstrtolower($Page)."';";
		$result = $this->executeCommand($sqlcmd);
		$returnvalue = "";
		
		$rownr = 0;
		while ($row = mysql_fetch_object($result))
		{
			$values[$rownr] = new Configuration();
			$values[$rownr]->setConfigurationID($row->ConfigurationID);
			$values[$rownr]->setPageId($row->PageId);
			$values[$rownr]->setConfigText($row->ConfigText);
			$values[$rownr]->setConfigValue($row->ConfigValue);
			$rownr++;
		}
		if ($rownr == 1)
		{
			$returnvalue = $values[0];
		}
		else
		{
			$returnvalue = $values;
		}
		return $returnvalue;
	}

	public function getConfigurationByPageAndConfigText($Page, $ConfigText)
	{
		$sqlcmd = "select c.ConfigText, c.ConfigValue, c.PageID, p.page from configuration c inner join pages p on c.pageid = p.pageid where c.ConfigText = '".$ConfigText."' and p.page = '".strtolower($Page)."';";
		// echo "SQL: $sqlcmd";
		$result = $this->executeCommand($sqlcmd);
		$returnvalue = "";
		
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$values[$rownr] = new Configuration();
			if (!isset($row->ConfigID)) {
				$row->ConfigID = false;
			}
			$values[$rownr]->setConfigID($row->ConfigID);
			$values[$rownr]->setPageId($row->PageID);
			$values[$rownr]->setConfigText($row->ConfigText);
			$values[$rownr]->setConfigValue($row->ConfigValue);
			$rownr++;
		}
		if ($rownr == 1)
		{
			$returnvalue = $values[0];
		}
		else
		{
			$returnvalue = $values;
		}
		return $returnvalue;
	}

		####################################################Countries##############################
	public function insertCountry($Short, $Country, $Active)
	{
		$returnvalue = 0;
		$sqlcmd = "insert into countries (Short, Country, Active) values ('".$Short."', '".$Country."', '".$Active."');";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = $Short;
		}
		return $returnvalue;
	}
	
	public function updateCountry($Short, $Country, $Active)
	{
		$returnvalue = false;
		$sqlcmd = "update countries set Short = '".$Short."', Country = '".$Country."', Active = '".$Active."' where Short = '".$Short."';";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}

	public function getCountriesByActive($active)
	{
		$sqlcmd = "select * from countries where active = ".$active." order by Country ASC;";
		$result = $this->executeCommand($sqlcmd);
		$returnvalue = "";
		
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$values[$rownr] = new Country();
			$values[$rownr]->setShort($row->Short);
			$values[$rownr]->setCountry($row->Country);
			$values[$rownr]->setActive($row->Active);
			$rownr++;
		}
		if ($rownr == 1)
		{
			$returnvalue = $values[0];
		}
		else
		{
			$returnvalue = $values;
		}
		return $returnvalue;
	}
	
	public function getCountries()
	{
		$sqlcmd = "select * from countries order by Country ASC;";
		$result = $this->executeCommand($sqlcmd);
		$returnvalue = "";
		
		$rownr = 0;
		while ($row = mysqli_fetch_object($result))
		{
			$values[$rownr] = new Country();
			$values[$rownr]->setShort($row->Short);
			$values[$rownr]->setCountry($row->Country);
			$values[$rownr]->setActive($row->Active);
			$rownr++;
		}
		if ($rownr == 1)
		{
			$returnvalue = $values[0];
		}
		else
		{
			$returnvalue = $values;
		}
		return $returnvalue;
	}

	public function getCountryByShort($obj)
	{
		$sqlcmd = "select * from countries where short = '".$obj->Short()."';";
		$result = $this->executeCommand($sqlcmd);
		if (mysqli_num_rows($result)==1)
		{
			$row = mysqli_fetch_object($result);
			$obj->setShort($row->Short);
			$obj->setCountry($row->Country);
			$obj->setActive($row->Active);
		}
	}

	####################################################Language##############################
	
	public function getLanguages()
	{
		$sqlcmd = "select * from languages order by language;";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		while ($row = mysql_fetch_object($result))
		{
			$values[$rownr] = new Language();
			$values[$rownr]->setLanguageID($row->LanguageID);
			$values[$rownr]->setLanguage($row->Language);
			$values[$rownr]->setShort($row->Short);
			$rownr++;
		}
		return $values;
	}
	
	public function getLanguageIdByShort($short)
	{
		$sqlcmd = "select LanguageId from languages where short = '".$short."';";
		$result = $this->executeCommand($sqlcmd);
		$rownr = 0;
		$returnvalue = "";
		$row = mysqli_fetch_row($result);
		return $row[0];
	}
	
	//####################################################ApplicationMail##############################
	
	public function getApplicationMailByCityID($AppObj, $ElseDefault)
	{
		$sqlcmd = "select * from applicationmail where cityid = ".$AppObj->CityID().";";
		$result = $this->executeCommand($sqlcmd);
		if (mysqli_num_rows($result)==1)
		{
			$row = mysqli_fetch_object($result);
			$AppObj->setSubject($row->Subject);
			$AppObj->setContent($row->Content);
			$AppObj->setLanguageID($row->LanguageID);
			$AppObj->setActive($row->Active);
			$AppObj->setExists(true);
		} 
		else
		{
			if ($ElseDefault==false)
			{
				$AppObj->setSubject("");
				$AppObj->setContent("");
				$AppObj->setLanguageID("");
				$AppObj->setActive(true);
				$AppObj->setExists(false);
			}
			else
			{
				$sqlcmd = "select * from applicationmail where cityid = 1;";
				$result = $this->executeCommand($sqlcmd);
				if (mysqli_num_rows($result)==1)
				{
					$row = mysqli_fetch_object($result);
					$AppObj->setSubject($row->Subject);
					$AppObj->setContent($row->Content);
					$AppObj->setLanguageID($row->LanguageID);
					$AppObj->setActive($row->Active);
					$AppObj->setExists(false);
				} 			
			}
		}
	}
	
	public function insertApplicationMail($CityID, $Subject, $Content, $LanguageID, $Active)
	{
		$returnvalue = 0;
		
		if ($LanguageID == "") { $LanguageID = "1"; }
		
		$sqlcmd = "insert into applicationmail (CityID, Subject, Content, LanguageID, Active) values (".$CityID.", '".$Subject."', '".$Content."', ".$LanguageID.", ".$Active.");";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}
	
	public function insertApplicationMailObject($AppObj)
	{
		$returnvalue = 0;
		
		$CityID = $AppObj->CityID();
		$Subject = $AppObj->Subject();
		$Content = $AppObj->Content();
		$LanguageID = $AppObj->LanguageID();
		$Active=$AppObj->Active();

		return $this->insertApplicationMail($CityID, $Subject, $Content, $LanguageID, $Active);		
	}
	
	public function updateApplicationMail($CityID, $Subject, $Content, $LanguageID, $Active)
	{
		$returnvalue = false;
		
		$sqlcmd = "update applicationmail set Subject = '".$Subject."', Content = '".$Content."', LanguageID = ".$LanguageID.", Active = ".$Active." WHERE CityID = ".$CityID.";";
		$this->executeCommand($sqlcmd);
		if (mysql_affected_rows() > 0)
		{
			$returnvalue = true;
		}
		return $returnvalue;
	}
	
	public function updateApplicationMailObject($AppObj)
	{
		$returnvalue = 0;
		
		$CityID = $AppObj->CityID();
		$Subject = $AppObj->Subject();
		$Content = $AppObj->Content();
		$LanguageID = $AppObj->LanguageID();
		$Active=$AppObj->Active();
		
		return $this->updateApplicationMail($CityID, $Subject, $Content, $LanguageID, $Active);		
	}

}	
?><?
require_once("./classes/User.class.php");
require_once("./classes/DbManager.class.php");

class UserManager
{
	private $userobject;
    private $db;

/*        public function __construct($email, $pass)
    {
        $this->userobject = new User($email, $pass);
//            echo "Pass: " . $this->userobject->getPass() . "<br>";
        $this->db = new DbManager();
    }
*/

    public function __construct($userobject = "")
    {
        if ($userobject instanceof User)
        {
        	$this->userobject = $userobject;
    	}
        else
        {
            $this->userobject = new User();
        }
//            echo "Pass: " . $this->userobject->getPass() . "<br>";
        $this->db = new DbManager();
    }

    public function login()
    {
//	     	echo "user: " . $this->userobject->getPass() . "<br>";
    	$this->db->getUser($this->userobject);
    }

	public function UserObject()
	{
		if (!$this->userobject instanceof User)
		{
			$this->userobject = new User();
		}
		return $this->userobject;
	}

/*		public function setUserObject($userobject)
	{
		$this->userobject = $userobject;
	}*/

    public function getUser()
    {
    	return $this->userobject;
    }

    public function getUsers()
    {
    	return $this->db->getUsers();
    }

    public function getUsersByCityId($cityid)
    {
    	return $this->db->getUsersByCityId($cityid);
    }

	public function getUserByUserId($userid)
    {
		$this->userobject = $this->db->getUserByUserID($userid);		
	}

	public function getUserByEmail($email)
	{
		return $this->db->getUserByEmail($email);
	}

    public function getUsersByCityIdAndActive($cityid, $active)
    {
    	return $this->db->getUsersByCityIdAndActive($cityid, $active);
    }

    public function insertUser()
    {
    	$this->userobject->setUserID($this->db->insertUser($this->userobject));
        return $this->userobject->getUserID();
    }

    public function updateUser()
    {
    	$this->db->updateUser($this->userobject);
    }

    public function updateExUser($user)
    {
    	$this->db->updateUser($user);
    }

    public function updateUsers($users)
    {
    	$this->db->updateUsers($users);
    }
}
?><?
require_once('./classes/DbManager.class.php');
class City
{
    private $cityid;
    private $city;
    private $startdate;
    private $starttime;
    private $country; 
	private $abbreviation;
	private $racecourse;
	private $active;
	private $timeshift;
	private $finished;
    private $db;

    public function __construct()
    {
    	$this->db = new DbManager();
    }

	public function setCity2($id, $city, $date, $time, $country, $abbreviation, $racecourse, $active, $timeshift, $finished)
    {
     	$this->cityid = $id;
        $this->city = $city;
        $this->startdate = $date;
        $this->starttime = $time;
        $this->country = $country;
		$this->abbreviation = $abbreviation;
		$this->racecourse = $racecourse;
		$this->active = $active;
		$this->timeshift = $timeshift;
		$this->finished = $finished;
    }

    public function CityId()
    {
    	return $this->cityid;
    }
    public function City()
    {
    	return $this->city;
    }
    public function StartDate()
    {
    	return $this->startdate;
    }
    public function StartTime()
    {
    	return $this->starttime;
    }
    public function Country()
    {
    	return $this->country;
    }
	public function Abbreviation()
	{
		return $this->abbreviation;
	}
	public function Racecourse()
	{
		return $this->racecourse;
	}
	public function Active()
	{
		return $this->active;
	}
	public function TimeShift()
	{
		return $this->timeshift;
	}
	public function Finished()
	{
		return $this->finished;
	}
	
    public function setCityId($value)
    {
    	$this->cityid = $value;
    }
    public function setCity($value)
    {
    	$this->city = $value;
    }
    public function setStartDate($value)
    {
        $this->startdate = $value;
    }
    public function setStartTime($value)
    {
    	$this->starttime = $value;
    }
    public function setCountry($value)
    {
    	$this->country = $value;
    }
	public function setAbbreviation($value)
	{
		$this->abbreviation = $value;
	}
	public function setRacecourse($value)
	{
		$this->racecourse = $value;
	}
	public function setActive($value)
	{
		$this->active = $value;
	}
	public function setTimeShift($value)
	{
		$this->timeshift = $value;
	}
	public function setFinished($value)
	{
		$this->finished = $value;
	}

	public function getCityByAbbreviation()
	{
		$this->db->getCityByAbbreviation($this);
	}
	
    public function getCityByCity()
    {
		$this->db->getCityByCity($this);
    }

	public function getCityByCityId()
	{
		$this->db->getCityByCityId($this);
	}
	
    public function getCitiesByStartDate($datum)
    {
    	return $this->db->getCitiesByStartDate($datum);
    }

	public function getCitiesAndCountriesByStartDate($datum)
	{
		return $this->db->getCitiesAndCountriesByStartDate($datum);
	}
	
	public function getCitiesAndCountriesByStartDateAndActive($datum, $active)
	{
		return $this->db->getCitiesAndCountriesByStartDateAndActive($datum, $active);
	}

	public function insertCity()
	{
		$this->db->insertCity($this->city, $this->startdate, $this->starttime, $this->country, $this->abbreviation, $this->racecourse,  $this->active, $this->timeshift, $this->finished);
	}
	
	public function updateCity()
	{
		$this->db->updateCity($this->cityid, $this->city, $this->startdate, $this->starttime, $this->country, $this->abbreviation, $this->racecourse, $this->active, $this->timeshift, $this->finished);
	}
	
    public function getStartAsTimestamp()
    {
    	$d = preg_split("/-/", $this->StartDate());
    	$t = preg_split("/:/", $this->StartTime());
    	//echo "d: ".print_r($d);
    	//echo "t: ".print_r($t);
    	//echo mktime($t[0], $t[1], $t[2], $d[1], $d[2], $d[0]);
    	return mktime($t[0], $t[1], $t[2], $d[1], $d[2], $d[0]);
    }
	
	public function getStartAsBerlinTimestamp()
	{
		return $this->getStartAsTimestamp() - (($this->timeshift - 1) * 3600);
	}
}
?><?
require_once('./classes/DbManager.class.php');

class Country
{
	private $short;
	private $country;
	private $active;
	private $db;
	
	public function __construct()
	{
		$this->db = new DbManager();
	}
	
	public function Short()
	{
		return $this->short;
	}
	public function Country()
	{
		return $this->country;
	}
	public function Active()
	{
		return $this->active;
	}
	
	public function setShort($value)
	{
		$this->short = $value;
	}
	public function setCountry($value)
	{
		$this->country = $value;
	}
	public function setActive($value)
	{
		$this->active = $value;
	}

	public function getCountryByShort()
	{
		$this->db->getCountryByShort($this);
	}
	
	public function insertCountry()
	{
		$this->db->insertCountry($this->short, $this->country, $this->active);
	}
	
	public function updateCountry()
	{
		$this->db->updateCountry($this->short, $this->country, $this->active);
	}
}
?><br />
<b>Warning</b>:  session_start(): Session cannot be started after headers have already been sent in <b>/var/www/hosts/000507/extramileendurathon/htdocs/index.php</b> on line <b>20</b><br />
<br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;DbManager&quot; not found in /var/www/hosts/000507/extramileendurathon/htdocs/index.php:32
Stack trace:
#0 {main}
  thrown in <b>/var/www/hosts/000507/extramileendurathon/htdocs/index.php</b> on line <b>32</b><br />