<?

	class nba {
		
		public function get_user_id($user) {
			
			global $mysql;
			global $config;
			global $nba;
			
			$sql = "SELECT * FROM `".$config->mysql->database."`.`user` WHERE `fb` = '".$user["id"]."'";
			$result = mysql_query($sql);
			
			if($result) {
				while($row = mysql_fetch_array($result)) {
					if($row["newsletter_key"]=="accepted") {
						return $nba->newsletter_feedback($row["id"]);
					} else {
						return $row["id"];
					}
				}
				return false;
			} else {
				return false;
			}

		}

		public function text($language,$path) {

			$textLib = array();
			
			if(file_exists($path."config/locale/".$language.".txt")) {
				$textFile = file_get_contents($path."config/locale/".$language.".txt");
				$textFileArr = explode("\n",$textFile);
				foreach($textFileArr as $text) {
					if(!empty($text)) {
						$textArr = explode(" :: ",$text);
						$textLib[$textArr[0]] = $textArr[1];
					}
				}
			}
			
			return $textLib;

		}
		
		public function get_user($user) {
			
			global $mysql;
			global $config;
			global $nba;
			
			$sql = "SELECT * FROM `".$config->mysql->database."`.`user` WHERE `id` = '".$user."'";
			$result = mysql_query($sql);
			
			if($result) {
				while($row = mysql_fetch_array($result)) {
					$user = array();
					$user["id"] = $row["id"];
					$user["fb"] = $row["fb"];
					$user["first_name"] = $row["first_name"];
					$user["last_name"] = $row["last_name"];
					$user["email"] = $row["email"];
					$user["locale"] = $row["locale"];
					return $user;
				}
				return false;
			} else {
				return false;
			}

		}
		
		public function create_user($user) {
		
			global $mysql;
			global $config;
			global $nba;
			
			$sql = "INSERT INTO `".$config->mysql->database."`.`user` (`fb`, `first_name`, `last_name`, `locale`) 
					VALUES ('".$user["id"]."', '".$user["first_name"]."', '".$user["last_name"]."','".$user["locale"]."')";
			$result = mysql_query($sql);
			
			if($result) {
				return $nba->get_user_id($user);
			} else {
				return false;
			}
			
		}
		
		public function generate_string($length = 10) {
		
			$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
			$charactersLength = strlen($characters);
			$randomString = '';
			for ($i = 0; $i < $length; $i++) {
				$randomString .= $characters[rand(0, $charactersLength - 1)];
			}
			return $randomString;
			
		}
		
		public function start_game($time) {
		
			global $mysql;
			global $config;
			global $nba;

			$user = $nba->get_user($_SESSION["user"]);
			
			$sql = "INSERT INTO `".$config->mysql->database."`.`games` (`user`, `start`, `fb`) 
					VALUES ('".$_SESSION["user"]."', '".$time."','".$user["fb"]."')";
			$result = mysql_query($sql);
			
			if($result) {
				return true;
			} else {
				return false;
			}
		
		}
		
		public function save_game($post) {
		
			global $mysql;
			global $config;
			
			$sql = "SELECT * FROM `".$config->mysql->database."`.`games` WHERE `user` = '".$_SESSION["user"]."' AND `start` = '".$post["startTime"]."'";
			$result = mysql_query($sql);

			if($result) {
				while($row = mysql_fetch_array($result)) {
				
					$sql = "UPDATE `".$config->mysql->database."`.`games` 
					SET `end` = '".time()."', `points` = '".$post["correct"]."', 
					`clicks` = '".$post["clicks"]."', `clicksTiming` = '".$post["clicksTiming"]."', 
					`false` = '".$post["false"]."', `timing` = '".$post["timing"]."', 
					`logos` = '".$post["logos"]."', `active` = '".$post["active"]."'
					WHERE `id` = '".$row["id"]."'";

					$result = mysql_query($sql);
					
					if($result) {
						return true;
					} else {
						return false;
					}
				}
				return false;
			} else {
				return false;
			}
		
		}

		public function get_games() {

			global $mysql;
			global $config;
			global $nba;

			$sql = "SELECT * FROM `".$config->mysql->database."`.`games` WHERE `user` = '".$_SESSION["user"]."' ORDER BY `points` DESC LIMIT 0,7";
			$result = mysql_query($sql);

			$games = array();
			$count = 0;

			if($result) {
				while($row = mysql_fetch_array($result)) {

					$games[$count]["user"] = $nba->get_user($row["user"]);
					$games[$count]["points"] = $row["points"];
					$count++;

				}
				return $games;
			} else {
				return false;
			}

		}
		
		public function mysql_connect($config) {
		
			return mysql_connect($config->mysql->host, $config->mysql->user, $config->mysql->password);
		
		}
		
		public function string2sql($string) {
			
			return htmlentities(utf8_decode(str_replace("'",'"',$string)));
			
		}
		
		public function visit($type,$path) {
			if($type!="phone"&&$type!="tablet"&&$type!="all"&&$type!="web"&&$type!="facebook") {
				$type = "pc";
			}
			$file = $path."config/count/".$type.".txt";
			if(file_exists($file)) {
				$count = (file_get_contents($file));
				$write = fopen($file,"w");
				fwrite($write,($count*1)+1);
				fclose($write);
			}
		}
	
	}

?>