<?php
if(empty($errorMsg))
{
    $query = "SELECT Country.Id, Country.Name
    FROM Country
	INNER JOIN MarketCountry ON Country.Id = MarketCountry.CountryId
	INNER JOIN Market ON Market.Id = MarketCountry.MarketId
	WHERE Market.WebsiteId = '" . $websiteId . "'
	AND Market.Live = 1 AND MarketCountry.Live = 1
	GROUP BY Country.Id, Country.Name ORDER BY CASE WHEN Country.Id = 234 THEN 0 WHEN Country.Id = 250 THEN 2 ELSE 1 END, Country.Name;";
    if(isset($_REQUEST['country_id']) && !empty($_REQUEST['country_id']))
    {
        $country_id = intval($_REQUEST['country_id']);
        if($country_id == 235)
        {
            $query = "SELECT Country.Id, Country.Name
            FROM Country
            INNER JOIN MarketCountry ON Country.Id = MarketCountry.CountryId
            INNER JOIN Market ON Market.Id = MarketCountry.MarketId
            WHERE Market.WebsiteId = '" . $websiteId . "' AND (Country.Id = 234 OR Country.Id = 233)
            AND Market.Live = 1 AND MarketCountry.Live = 1
            GROUP BY Country.Id, Country.Name ORDER BY CASE WHEN Country.Id = 234 THEN 0 WHEN Country.Id = 250 THEN 2 ELSE 1 END, Country.Name;";
        }
        else if($country_id != 234)
        {
            $query = "SELECT Country.Id, Country.Name
            FROM Country
            INNER JOIN MarketCountry ON Country.Id = MarketCountry.CountryId
            INNER JOIN Market ON Market.Id = MarketCountry.MarketId
            WHERE Market.WebsiteId = '" . $websiteId . "' AND Country.Id = 234
            AND Market.Live = 1 AND MarketCountry.Live = 1
            GROUP BY Country.Id, Country.Name ORDER BY CASE WHEN Country.Id = 234 THEN 0 WHEN Country.Id = 250 THEN 2 ELSE 1 END, Country.Name;";
        }
        else
        {
            $query = "SELECT Country.Id, Country.Name
            FROM Country
            INNER JOIN MarketCountry ON Country.Id = MarketCountry.CountryId
            INNER JOIN Market ON Market.Id = MarketCountry.MarketId
            WHERE Market.WebsiteId = '" . $websiteId . "' AND Country.Id != '" . $country_id . "'
            AND Market.Live = 1 AND MarketCountry.Live = 1
            GROUP BY Country.Id, Country.Name ORDER BY CASE WHEN Country.Id = 234 THEN 0 WHEN Country.Id = 250 THEN 2 ELSE 1 END, Country.Name;";
        }
    }
    if ($result = $mysqli->query($query))
    {
        if($result->num_rows == 0)
        {
            $errorMsg[] = 'No countries have been found';
        }
        else
        {
            $xmlContent = $xml->addChild('Countries');
	        while ($row = $result->fetch_object())
	        {
                $xmlCountry = $xmlContent->addChild('Country');
	            $xmlCountry->addChild('Id', intval($row->Id));
                $xmlCountry->addChild('Name', encodeString($row->Name));
	        }
        }
    }
    else
    {
	    print $mysqli->error;
	    exit;
    }
    $result->close();
}



?>