<?php

date_default_timezone_set('Europe/Madrid'); 

if (substr_count($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip')) {

	ob_start("ob_gzhandler");

} else {

	ob_start();

}

if(!isset($_SESSION)) {

	session_start();

}

error_reporting(E_ALL);

ini_set("display_errors", 1);

///// GLOBAL VARS \\\\\

$SERVER_ROOT	= $_SERVER['DOCUMENT_ROOT'];



include $SERVER_ROOT ."/-system/siteData.php";



///// GLOBAL SITE URLs \\\\\

$companyName	= "FAB Almería";

$baseSiteURL	= "fabalmeria.es";

$ENurl			= "https://www.$baseSiteURL/";

$ESurl			= $ENurl ."es/";

$FRurl			= $ENurl ."fr/";

$DEurl			= $ENurl ."de/";

$NLurl			= $ENurl ."nl/";

$RUurl			= $ENurl ."ru/";

$Iurl			= $ENurl ."images/";



$url			= $ENurl;

$ADurl			= $url ."admin/";



$emailEmailAdd	= "info@caabowls.org";



$currentPage				= $_SERVER['PHP_SELF'];

$linksURLS					= array("en"=>"$ENurl");//, "es"=>"$ESurl", "fr"=>"$FRurl", "de"=>"$DEurl", "nl"=>"$NLurl", "ru"=>"$RUurl");

$langArray					= array("en"=>"English");//, "es"=>"Spanish", "fr"=>"French", "de"=>"German", "nl"=>"Dutch/Belgian", "ru"=>"Russian");

$langURLArray				= array("en");//, "es", "fr", "de", "nl", "ru");



///// PHOTO SIZES \\\\\

$maxPhotos			= 20;

$photoWidth			= 600;

$photoHeight		= 800;

$photoGWidth		= 1440;

$photoGHeight		= 960;

$zoomWidth			= 1280;

$zoomHeight			= 1707;

$thumbWidth			= 252;

$thumbHeight		= 336;

$bgWidth			= 1920;

$bgHeight			= 1020;

$bgTitleHeight		= 360;

$galleryHeight		= 610;

$imageThumbWidth	= 200;

$imageThumbHeight	= 112;

$galleryThumbWidth	= 300;

$galleryThumbHeight	= 168;

$badgeHeight		= 75;



$cookieName		= 'FABAAdLogin';



///// ADMIN COOKIE \\\\\

if (isset($_COOKIE[$cookieName])) {

	$adminCookie	= $_COOKIE[$cookieName];

	list($adminID, $adminCookieVar) = explode("-", $adminCookie);

} elseif (isset($_SESSION[$cookieName])) {

	$adminCookie	= $_SESSION[$cookieName];

	list($adminID, $adminCookieVar) = explode("-", $adminCookie);

} else {

	$adminID		= '';

	$adminCookieVar	= '';

}

if ( isset($_COOKIE[$cookieName]) || isset($_SESSION[$cookieName]) ) {

	$adminQuery = mysqli_query($conn, "SELECT cookieVar FROM admin WHERE id = '$adminID'");

	if (mysqli_num_rows($adminQuery) == 0) {

		setcookie ($cookieName, "", time() - 3600);

		session_destroy();

		header("location: $url");

		exit();

	} else {

		while ($aQC = mysqli_fetch_array($adminQuery)) {

			$cookieVar	= $aQC["cookieVar"];

		}

		if ($adminCookieVar == $cookieVar) {

			if ($currentPage == "/admin/index.php") {

				$redirectURL = "home.html";

				header("location: $redirectURL");

			}

		} else {

			setcookie ($cookieName, "", time() - 3600);

			session_destroy();

			header("location: $url");

			exit();

		}

	}

	

} else {

	if (($currentPage != "/admin/index.php") && ($currentPage != "/admin/test.php") && ($currentPage != "/admin/login.php") && ($currentPage != "/admin/logout.php")) {

		$redirectURL = "$ADurl"."?redirect=$attemptedPage";

		header("location: $redirectURL");

		exit();

	}

}

if ($adminID != 0) {

	$adminQuery = mysqli_query($conn, "SELECT * FROM admin WHERE id = '$adminID'");

	while ($aQ = mysqli_fetch_array($adminQuery)) {

		$adminName	= $aQ["adminName"];

		$adminEmail	= $aQ["adminEmail"];

	}

	if ($adminID == 1 || $adminID == 2) {

		$adminPriv	= array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55", "56", "57", "58", "59", "60", "61", "62", "63", "64", "65", "66", "67", "68", "69", "70", "71", "72", "73", "74", "75", "76", "77", "78", "79", "80", "81", "82", "83", "84", "85", "86", "87", "88", "89", "90", "91", "92", "93", "94", "95", "96", "97", "98", "99");

	} else {

		$privQuery = mysqli_query($conn, "SELECT privelegeArray FROM adminPriveleges WHERE adminID = '$adminID'");

		while ($pQ = mysqli_fetch_array($privQuery)) {

			$privSet	= trim($pQ["privelegeArray"], "|");

		}

		$adminPriv	= explode("|", $privSet);

	}

	if (isset($thisCheckID)) {

		if (!in_array($thisCheckID, $adminPriv)) {

			header("Location: $ADurl");

		}

	}



} else {

	$adminName	= "";

	$adminPriv	= array();

}

$badURL		= array(' - ', '?', '!', '¿', '¡', '     ', '    ', '   ', '  ', ' ', '\'', '&amp;', '&', '/','Á', 'á', 'À', 'à', 'Â', 'â', 'É', 'é', 'È', 'è', 'Ê', 'ê', 'Í', 'í', 'Ì', 'ì', 'Î', 'î', 'Ó', 'ó', 'Ò', 'ò', 'Ô', 'ô', 'Ú', 'ú', 'Ù', 'ù', 'Û', 'û', 'Ü', 'ü', 'Ñ', 'ñ', 'Ç', 'ç', '(', ')', ',', '.', '´', '~', '"', "Ă", "ă", "Â", "â", "Î", "î", "Ș", "ș", "Ş", "ş", "Ţ", "ţ", "Ö", "ö", "Œ", "œ", "Ø", "ø", "Ä", "ä", "Ë", "ë", "Å", "å", "%");

$goodURL	= array('-', '', '', '', '', '-', '-', '-', '-', '-', '', 'and', 'and', '-', 'A', 'a', 'A', 'a', 'A', 'a', 'E', 'e', 'E', 'e', 'E', 'e', 'I', 'i', 'I', 'i', 'I', 'i', 'O', 'o', 'O', 'o', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'N', 'n', 'C', 'c', '', '', '', '', '', '-', '', "A", "a", "A", "a", "I", "i", "S", "s", "S", "s", "T", "t", "O", "o", "OE", "oe", "O", "o", "A", "a", "E", "e", "A", "a", "");



$goodFilterURL	= array('', '', '', '', '', '', '', '', '', '', 'and', 'and', '', 'A', 'a', 'A', 'a', 'A', 'a', 'E', 'e', 'E', 'e', 'E', 'e', 'I', 'i', 'I', 'i', 'I', 'i', 'O', 'o', 'O', 'o', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'N', 'n', 'C', 'c', '', '', '', '', '', '', '', "A", "a", "A", "a", "I", "i", "S", "s", "S", "s", "T", "t", "O", "o", "OE", "oe", "O", "o", "A", "a", "E", "e", "A", "a", "");

	

$encGood		= array("&amp; ", "\"");

$encBad			= array("& ", "\'");



///// GLOBAL FUNCTIONS \\\\\

class Translit {

		var $html_aware = false;

	var $case_sensitive = false;

	var $cirilica = array("љ", "њ", "е", "р", "т", "з", "у", "и", "о", "п", "ш", "ђ", "ж", "а", "с", "д", "ф", "г", "х", "ј", "к", "л", "ч", "ћ", "џ", "ц", "в", "б", "н", "м", "Љ", "Њ", "Е", "Р", "Т", "З", "У", "И", "О", "П", "Ш", "Ђ", "Ж", "А", "С", "Д", "Ф", "Г", "Х", "Ј", "К", "Л", "Ч", "Ћ", "Џ", "Ц", "В", "Б", "Н", "М", "ью", "й", "ь", "ы", "я", "ю", "ъ", "э");

	var $latinica = array("lj", "nj", "e", "r", "t", "z", "u", "i", "o", "p", "s", "d", "z", "a", "s", "d", "f", "g", "h", "j", "k", "l", "c", "c", "dz", "c", "v", "b", "n", "m", "Lj", "Nj", "E", "R", "T", "Z", "U", "I", "O", "P", "S", "D", "Z", "A", "S", "D", "F", "G", "H", "J", "K", "L", "C", "D", "DZ", "C", "V", "B", "N", "M", "yu", "th", "L", "s", "I", "yu", "", "e");



	function tagsafe_replace($search, $replace, $subject, $casesensitive = false)  {

		$subject = '>' . $subject . '<';

		$search = preg_quote($search);

		$cs = !$casesensitive ? 'i' : '';



		preg_match_all('/>[^<]*(' . $search . ')[^<]*</i', $subject, $matches, PREG_PATTERN_ORDER);



		foreach($matches[0] as $match) {

			$tmp = preg_replace("/($search)/", $replace, $match);

			$subject = str_replace($match, $tmp, $subject);

		}



		return substr($subject, 1, -1);

	}



	function Transliterate($cyrilic) {

		if ($this->html_aware) {

			for ($i=0;$i<count($this->cirilica);$i++) {

				$cyrilic = $this->tagsafe_replace($this->cirilica[$i],$this->latinica[$i],$cyrilic,$this->case_sensitive);

			}

			return $cyrilic;

		} else {

			return str_replace($this->cirilica, $this->latinica, $cyrilic);

		}

	}

}

function cleanPost($postedVar, $conn) {

	$returnVar	= mysqli_real_escape_string($conn, htmlspecialchars(str_replace(array("<script>", "<script type", "</script>"), array("", "", ""), $postedVar), ENT_QUOTES, 'UTF-8'));

	$returnVar	= addslashes($returnVar);

	return $returnVar;

}

function createPDFht() {

	include '../-system/siteData.php';



	$htAccess	= 'Options -MultiViews

Options +SymLinksIfOwnerMatch



RewriteEngine on

RewriteBase /pdf/



RewriteRule ^league-fixtures-([0-9]+).html$ fixturesPrint.php?leagueID=$1

RewriteRule ^league-fixtures-details-([0-9]+).html$ fixturesPrintDetails.php?leagueID=$1

RewriteRule ^league-fixtures-playoffs-([0-9]+).html$ fixturesPrintPlayoffs.php?leagueID=$1

';

	$pageURLs	= array();

	$catQuery = mysqli_query($conn, "SELECT pageURL FROM leagueGroups ORDER BY pageURL ASC");

	while ($cQ = mysqli_fetch_array($catQuery)) {

		$pageURLs[]	= $cQ["pageURL"];

	}

	$catURLs	= implode("|", $pageURLs);



	$htAccess	.='

RewriteRule ^('. $catURLs .')-(.*)-league-fixtures.pdf$ fixturesPrintPDF.php?groupURL=$1&leagueURL=$2



RewriteRule ^tournament-fixtures-([0-9]+).html$ tournamentPrint.php?tournamentID=$1';



	$pageURLs	= array();

	$tCatQuery = mysqli_query($conn, "SELECT pageURL FROM knockoutGroups ORDER BY pageURL ASC");

	while ($tCQ = mysqli_fetch_array($tCatQuery)) {

		$pageURLs[]	= $tCQ["pageURL"];

	}

	$tCatURLs	= implode("|", $pageURLs);



	$htAccess	.='

RewriteRule ^('. $tCatURLs .')-(.*)-tournament-fixtures.pdf$ tournamentPrintPDF.php?groupURL=$1&tournamentURL=$2



RewriteRule ^(.*)-registrants.html$ registrantsPrint.php?pageURL=$1

RewriteRule ^(.*)-registrants.pdf$ registrantsPrintPDF.php?pageURL=$1';



	return $htAccess;

}



function GlobalNumber($number, $currencyLanguage) {

	$LANG_FORMAT = $currencyLanguage;

	if ($LANG_FORMAT == "en") {

		$formattedNo = number_format($number, 0, ".", ",");

	} else {

		$formattedNo = number_format($number, 0, ",", ".");

	}

	

	return $formattedNo;

}

function GlobalSNumber($number, $currencyLanguage) {

	$LANG_FORMAT = $currencyLanguage;

	if ($LANG_FORMAT == "en") {

		$formattedNo = number_format($number, 2, ".", ",");

	} else {

		$formattedNo = number_format($number, 2, ",", ".");

	}

	

	return $formattedNo;

}

function localiseDate($thisDate, $thisLang = "en") {

	$ofArray	= array("en"=>"of", "es"=>"de", "de"=>"", "fr"=>"", "nl"=>"", "ru"=>"");

	$of			= $ofArray[$thisLang];

	$monthsEN	= array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");

	$daysEN		= array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");

	$thEN		= array("st ", "th ", "nd ", "rd ");



	$daysLocal	= array(	"en"=>array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"), 

							"es"=>array("Lunes", "Martes", "Miércoles", "Jueves", "Viernes", "Sábado", "Domingo"), 

							"de"=>array("Montag" , "Dienstag", "Mittwoch", "Donnerstag" , "Freitag" , "Samstag" , "Sonntag"), 

							"fr"=>array("Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi", "Dimanche"), 

							"nl"=>array("Maandag", "Dinsdag", "Woensdag", "Donderdag", "Vrijdag", "Zaterdag", "Zondag"), 

							"ru"=>array("понедельник", "вторник", " среда", "Четверг", "Пятница", "суббота", "Воскресенье"));

	$thLocal	= array(	"en"=>array("st ", "th ", "nd ", "rd "), 

							"es"=>array(" de ", " de ", " de ", " de "), 

							"de"=>array(" ", " ", " ", " "), 

							"fr"=>array(" ", " ", " ", " "), 

							"nl"=>array(" ", " ", " ", " "), 

							"ru"=>array(" ", " ", " ", " "));

	$mthsLocal	= array(	"en"=>array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"), 

							"es"=>array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"), 

							"de"=>array("Januar", " Februar", "März", "April", "Mai", "Juni" , "Juli" , "August" , "September" , "Oktober" , "November" , "Dezember"), 

							"fr"=>array("Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Août", "Septembre", "Octobre", "Novembre", "Décembre"), 

							"nl"=>array("Januari", "Februari", "Maart", "April", "Mei", "Juni", "Juli", "August", "September", "Oktober", "November", "December"), 

							"ru"=>array("Январь", "Февраль", "Март", "Апрель", "Май", "Июнь", "Июль", "Август", "Сентябрь", "Октябрь", "ноябрь", "Декабрь"));



	$thisDate	= strtotime($thisDate);

	$theDate	= date("jS", $thisDate) ." ". date("F, Y", $thisDate);

	$theDate	= str_replace($thEN, $thLocal[$thisLang], $theDate);

	$theDate	= str_replace($daysEN, $daysLocal[$thisLang], $theDate);

	$theDate	= str_replace($monthsEN, $mthsLocal[$thisLang], $theDate);

	return $theDate;

}

function everything_in_tags($string, $tagname) {

	$pattern	= "#<\s*?$tagname\b[^>]*>(.*?)</$tagname\b[^>]*>#s";

	preg_match($pattern, $string, $matches);

	return $matches[1];

}

function getFirstPara($string){

	$string = substr($string,0, strpos($string, "</p")+4);

	return $string;

}

function assignRandValue($num) {

	$lettersNumberArray	= array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");

	return $lettersNumberArray[$num];

}

function getRandID($length) {

	if($length > 0) {

		$rand_id="";

		for($i = 1; $i <= $length; $i++) {

			mt_srand((double)microtime() * 1000000);

			$num = mt_rand(0,61);

			$rand_id .= assignRandValue($num);

		}

	}

	return $rand_id;

}

function getNoRounds($compLeft) {

	$noRounds		= 1;

	if ($compLeft > 2) {

		do {

			$compLeft	= $compLeft / 2;

			$noRounds++;

		} while ($compLeft > 2);

	}



	return $noRounds;

}

?>