/GameEngine/Database/db_MYSQL.php

<?php

        class MYSQL_DB {

        	var $connection;

			

        	function MYSQL_DB() {

        		$this->connection = mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS) or die(mysql_error());

        		mysql_select_db(SQL_DB, $this->connection) or die(mysql_error());

        	}



        	function register($username, $password, $email, $tribe, $locate, $act) {

        		$time = time();

        		$timep = ($time + PROTECTION);

				$rand = rand(8900, 9000);

        		$q = "INSERT INTO " . TB_PREFIX . "users (username,password,access,email,timestamp,tribe,location,act,protect,clp,cp) VALUES ('$username', '$password', " . USER . ", '$email', $time, $tribe, $locate, '$act', $timep, '$rand', 1)";

        		if(mysql_query($q, $this->connection)) {

        			return mysql_insert_id($this->connection);

        		} else {

        			return false;

        		}

        	}



        	function activate($username, $password, $email, $tribe, $locate, $act, $act2) {

        		$time = time();

        		$q = "INSERT INTO " . TB_PREFIX . "activate (username,password,access,email,tribe,timestamp,location,act,act2) VALUES ('$username', '$password', " . USER . ", '$email', $tribe, $time, $locate, '$act', '$act2')";

        		if(mysql_query($q, $this->connection)) {

        			return mysql_insert_id($this->connection);

        		} else {

        			return false;

        		}

        	}



        	function unreg($username) {

        		$q = "DELETE from " . TB_PREFIX . "activate where username = '$username'";

        		return mysql_query($q, $this->connection);

        	}

        	function deleteReinf($id) {

        		$q = "DELETE from " . TB_PREFIX . "enforcement where id = '$id'";

        		mysql_query($q, $this->connection);

        	}

        	function updateResource($vid, $what, $number) {



        		$q = "UPDATE " . TB_PREFIX . "vdata set " . $what . "=" . $number . " where wref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_query($q, $this->connection);

        	}



        	function checkExist($ref, $mode) {



        		if(!$mode) {

        			$q = "SELECT username FROM " . TB_PREFIX . "users where username = '$ref' LIMIT 1";

        		} else {

        			$q = "SELECT email FROM " . TB_PREFIX . "users where email = '$ref' LIMIT 1";

        		}

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}

			

        	function checkExist_activate($ref, $mode) {



        		if(!$mode) {

        			$q = "SELECT username FROM " . TB_PREFIX . "activate where username = '$ref' LIMIT 1";

        		} else {

        			$q = "SELECT email FROM " . TB_PREFIX . "activate where email = '$ref' LIMIT 1";

        		}

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}

        	function updateUserField($ref, $field, $value, $mode) {

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "users set $field = '$value' where username = '$ref'";

        		} elseif($mode==1) {

        			$q = "UPDATE " . TB_PREFIX . "users set $field = '$value' where id = '$ref'";

        		} elseif($mode==2) {

					$q = "UPDATE " . TB_PREFIX . "users set $field = $field + '$value' where id = '$ref'";

				}

        		return mysql_query($q, $this->connection);

        	}



        	function getSitee($uid) {

        		$q = "SELECT id from " . TB_PREFIX . "users where sit1 = $uid or sit2 = $uid";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

			function getSitee1($uid) {

        		$q = "SELECT * from " . TB_PREFIX . "users where sit1 = $uid";

        		$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

        		return $dbarray;

        	}

			

			function getSitee2($uid) {

        		$q = "SELECT * from " . TB_PREFIX . "users where sit2 = $uid";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray;

        	}

			

        	function removeMeSit($uid, $uid2) {

        		$q = "UPDATE " . TB_PREFIX . "users set sit1 = 0 where id = $uid and sit1 = $uid2";

        		mysql_query($q, $this->connection);

        		$q2 = "UPDATE " . TB_PREFIX . "users set sit2 = 0 where id = $uid and sit2 = $uid2";

        		mysql_query($q2, $this->connection);

        	}



        	function getUserField($ref, $field, $mode) {

        		if(!$mode) {

        			$q = "SELECT $field FROM " . TB_PREFIX . "users where id = '$ref'";

        		} else {

        			$q = "SELECT $field FROM " . TB_PREFIX . "users where username = '$ref'";

        		}

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}



        	function getActivateField($ref, $field, $mode) {

        		if(!$mode) {

        			$q = "SELECT $field FROM " . TB_PREFIX . "activate where id = '$ref'";

        		} else {

        			$q = "SELECT $field FROM " . TB_PREFIX . "activate where username = '$ref'";

        		}

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}



        	function login($username, $password) {

        		$q = "SELECT password,sessid FROM " . TB_PREFIX . "users where username = '$username'";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		if($dbarray['password'] == md5($password)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function checkActivate($act) {

        		$q = "SELECT * FROM " . TB_PREFIX . "activate where act = '$act'";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);



        		return $dbarray;

        	}



        	function sitterLogin($username, $password) {

        		$q = "SELECT sit1,sit2 FROM " . TB_PREFIX . "users where username = '$username' and access != " . BANNED;

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		if($dbarray['sit1'] != 0) {

        			$q2 = "SELECT password FROM " . TB_PREFIX . "users where id = " . $dbarray['sit1'] . " and access != " . BANNED;

        			$result2 = mysql_query($q2, $this->connection);

        			$pw_sit1 = mysql_fetch_array($result2);

        		}

				elseif($dbarray['sit2'] != 0) {

        			$q3 = "SELECT password FROM " . TB_PREFIX . "users where id = " . $dbarray['sit2'] . " and access != " . BANNED;

        			$result3 = mysql_query($q3, $this->connection);

        			$pw_sit2 = mysql_fetch_array($result3);

        		}

        		if($dbarray['sit1'] != 0 || $dbarray['sit2'] != 0) {

        			if($pw_sit1['password'] == md5($password) || $pw_sit2['password'] == md5($password)) {

        				return true;

        			} else {

        				return false;

        			}

        		} else {

        			return false;

        		}

        	}



        	function setDeleting($uid, $mode) {

        		$time = time() + 72 * 3600;

        		if(!$mode) {

        			$q = "INSERT into " . TB_PREFIX . "deleting values ($uid,$time)";

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "deleting where uid = $uid";

        		}

        		mysql_query($q, $this->connection);

        	}



        	function isDeleting($uid) {

        		$q = "SELECT timestamp from " . TB_PREFIX . "deleting where uid = $uid";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['timestamp'];

        	}



        	function modifyGold($userid, $amt, $mode) {

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "users set gold = gold - $amt where id = $userid";

        		} else {

        			$q = "UPDATE " . TB_PREFIX . "users set gold = gold + $amt where id = $userid";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	/*****************************************

        	Function to retrieve user array via Username or ID

        	Mode 0: Search by Username

        	Mode 1: Search by ID

        	References: Alliance ID

        	*****************************************/



        	function getUserArray($ref, $mode) {

        		if(!$mode) {

        			$q = "SELECT * FROM " . TB_PREFIX . "users where username = '$ref'";

        		} else {

        			$q = "SELECT * FROM " . TB_PREFIX . "users where id = $ref";

        		}

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getUserWithEmail($email) {

        		$q = "SELECT * FROM " . TB_PREFIX . "users where email = '$email'";

				$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}



        	function activeModify($username, $mode) {

        		$time = time();

        		if(!$mode) {

        			$q = "INSERT into " . TB_PREFIX . "active VALUES ('$username',$time)";

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "active where username = '$username'";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	function addActiveUser($username, $time) {

        		$q = "REPLACE into " . TB_PREFIX . "active values ('$username',$time)";

        		if(mysql_query($q, $this->connection)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function updateActiveUser($username, $time) {

				$q = "REPLACE into " . TB_PREFIX . "active (`username`, `timestamp`) values ('$username',$time)";

        		$q2 = "UPDATE " . TB_PREFIX . "users set timestamp = $time where username = '$username'";

        		$exec1 = mysql_query($q, $this->connection);

        		$exec2 = mysql_query($q2, $this->connection);

        		if($exec1 && $exec2) {

        			return true;

        		} else {

        			return false;

        		}

        	}

			

			function checkSitter($username){

				$q = "SELECT * FROM ".TB_PREFIX."online WHERE name = '".$username."'";	

				$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

				return $dbarray['sitter'];

			}

			

			public function canConquerOasis($vref,$wref) {

				$AttackerFields = $this->getResourceLevel($vref);

				for($i=19;$i<=38;$i++) {

					if($AttackerFields['f'.$i.'t'] == 37) { $HeroMansionLevel = $AttackerFields['f'.$i]; }

				}

				if($this->VillageOasisCount($vref) < floor(($HeroMansionLevel-5)/5)) {

					$OasisInfo = $this->getOasisInfo($wref);

                    $troopcount = $this->countOasisTroops($wref);

					if($OasisInfo['conqured'] == 0 || $OasisInfo['conqured'] != 0 && $OasisInfo['loyalty'] < 99 / min(3,(4-$this->VillageOasisCount($OasisInfo['conqured']))) && $troopcount == 0) {

						$CoordsVillage = $this->getCoor($vref);

						$CoordsOasis = $this->getCoor($wref);

						if(abs($CoordsOasis['x']-$CoordsVillage['x'])<=3 && abs($CoordsOasis['y']-$CoordsVillage['y'])<=3) {

							return True;

						} else {

							return False;

						}

					} else {

						return False;

					}

				} else {

					return False;

				}

			}

			

			public function conquerOasis($vref,$wref) {

				$vinfo = $this->getVillage($vref);

				$uid = $vinfo['owner'];

				$q = "UPDATE `".TB_PREFIX."odata` SET conqured=$vref,loyalty=100,lastupdated=".time().",owner=$uid,name='Occupied Oasis' WHERE wref=$wref";

        		return mysql_query($q, $this->connection);

			}

			

			public function modifyOasisLoyalty($wref) {

				if($this->isVillageOases($wref) != 0) {

					$OasisInfo = $this->getOasisInfo($wref);

					if($OasisInfo['conqured'] != 0) {

						$LoyaltyAmendment = floor(100 / min(3,(4-$this->VillageOasisCount($OasisInfo['conqured']))));

						$q = "UPDATE `".TB_PREFIX."odata` SET loyalty=loyalty-$LoyaltyAmendment WHERE wref=$wref";

						return mysql_query($q, $this->connection);

					}

				}

			}



        	function checkactiveSession($username, $sessid) {

        		$user = $this->getUserArray($username, 0);

				$sessidarray = explode("+", $user['sessid']);

        		if(in_array($sessid, $sessidarray)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function submitProfile($uid, $gender, $location, $birthday, $des1, $des2) {

        		$q = "UPDATE " . TB_PREFIX . "users set gender = $gender, location = '$location', birthday = '$birthday', desc1 = '$des1', desc2 = '$des2' where id = $uid";

        		return mysql_query($q, $this->connection);

        	}



        	function gpack($uid, $gpack) {

        		$q = "UPDATE " . TB_PREFIX . "users set gpack = '$gpack' where id = $uid";

        		return mysql_query($q, $this->connection);

        	}



        	function UpdateOnline($mode, $name = "", $sit = 0) {

        		global $session;

        		if($mode == "login") {

        			$q = "INSERT IGNORE INTO " . TB_PREFIX . "online (name, time, sitter) VALUES ('$name', ".time().", ".$sit.")";

        			return mysql_query($q, $this->connection);

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "online WHERE name ='" . $session->username . "'";

        			return mysql_query($q, $this->connection);

        		}

        	}



        	//Choice placement where sector

			function generateBase($sector){

				$sector = ($sector == 0) ? rand(1, 4) : $sector;

				// (-/-) SW

				if($sector == 1){

					$x_a = (WORLD_MAX - (WORLD_MAX*2));

					$x_b = 0;

					$y_a = (WORLD_MAX - (WORLD_MAX*2));

					$y_b = 0;

					$order = "ORDER BY y DESC,x DESC";

					$mmm = rand(-1, -20);

					$x_y = "AND x < -4 AND y < $mmm";

				}

				// (+/-) SE

				elseif($sector == 2){

					$x_a = (WORLD_MAX - (WORLD_MAX*2));

					$x_b = 0;

					$y_a = 0;

					$y_b = WORLD_MAX;

					$order = "ORDER BY y ASC,x DESC";

					$mmm = rand(1, 20);

					$x_y = "AND x < -4 AND y > $mmm";

				}

				// (+/+) NE

				elseif($sector == 3){

					$x_a = 0;

					$x_b = WORLD_MAX;

					$y_a = 0;

					$y_b = WORLD_MAX;

					$order = "ORDER BY y,x ASC"; 

					$mmm = rand(1, 20);

					$x_y = "AND x > 4 AND y > $mmm";

				}

				// (-/+) NW

				elseif($sector == 4){

					$x_a = 0;

					$x_b = WORLD_MAX;

					$y_a = (WORLD_MAX - (WORLD_MAX*2));

					$y_b = 0;

					$order = "ORDER BY y DESC, x ASC";

					$mmm = rand(-1, -20);

					$x_y = "AND x > 4 AND y < $mmm";

				}

				$q = "SELECT * FROM ".TB_PREFIX."wdata where fieldtype = 3 and occupied = 0 $x_y and (x BETWEEN $x_a AND $x_b) and (y BETWEEN $y_a AND $y_b) $order LIMIT 20";

				

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['id'];

			}  

			

        	function setFieldTaken($id) {

        		$q = "UPDATE " . TB_PREFIX . "wdata set occupied = 1 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function addVillage($wid, $uid, $username, $capital) {

        		$total = count($this->getVillagesID($uid));

				if($total >= 1) {

					$vname = "????? ????";

				} else {

					$vname = "????? ".$username;

				}

				

        		$time = time();

        		$q = "INSERT into " . TB_PREFIX . "vdata (wref, owner, name, capital, pop, cp, celebration, wood, clay, iron, maxstore, crop, maxcrop, lastupdate, created) values 

        ('$wid', '$uid', '$vname', '$capital', 2, 1, 0, 780, 780, 780, 800, 780, 800, '$time', '$time')";

        		return mysql_query($q, $this->connection) or die(mysql_error());

        	}



        	function addResourceFields($vid, $type) {

        		switch($type) {

        			case 1:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,4,4,1,4,4,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 2:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,1,3,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 3:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,3,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 4:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,2,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 5:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,3,1,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 6:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,4,4,1,3,4,4,4,4,4,4,4,4,4,4,4,2,4,4,1,15)";

        				break;

        			case 7:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,4,1,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 8:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,4,1,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 9:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,4,1,1,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 10:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,1,2,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        			case 11:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,1,1,3,1,4,4,3,3,2,2,3,1,4,4,2,4,4,1,15)";

        				break;

        			case 12:

        				$q = "INSERT into " . TB_PREFIX . "fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,1,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";

        				break;

        		}

        		return mysql_query($q, $this->connection);

        	}

        	function isVillageOases($wref) {

        		$q = "SELECT id, oasistype FROM " . TB_PREFIX . "wdata where id = $wref";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['oasistype'];

        	}

			

			public function VillageOasisCount($vref) {

				$q = "SELECT count(*) FROM ".TB_PREFIX."odata WHERE conqured=$vref";

				$result = mysql_query($q, $this->connection);

				$row = mysql_fetch_row($result);

				return $row[0];

			}

			

        	function populateOasis() {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata where oasistype != 0";

        		$result = mysql_query($q, $this->connection);

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

        			$wid = $row['id'];



        			$this->addUnits($wid);



        		}

        	}





        	/***************************

        	Function to retrieve type of village via ID

        	References: Village ID

        	***************************/

        	function getVillageType($wref) {

        		$q = "SELECT id, fieldtype FROM " . TB_PREFIX . "wdata where id = $wref";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['fieldtype'];

        	}

			

			function getVillageData($wref) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata where id = $wref";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

			function getVillageType2($wref) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata where id = $wref";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['oasistype'];

        	}

			

			function getVilWref($x, $y) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata where x = $x AND y = $y";

        		$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

        		return $dbarray['id'];

        	}

			

			function checkVilExist($wref) {

        		$q = "SELECT * FROM " . TB_PREFIX . "vdata where wref = '$wref'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}

			

			function oasischecker($x, $y) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata where x = $x AND y = $y";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	/*****************************************

        	Function to retrieve if is ocuped via ID

        	References: Village ID

        	*****************************************/

        	function getVillageState($wref) {

        		$q = "SELECT oasistype,occupied FROM " . TB_PREFIX . "wdata where id = $wref";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		if($dbarray['occupied'] != 0 || $dbarray['oasistype'] != 0) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function getProfileVillages($uid) {

        		$q = "SELECT * from " . TB_PREFIX . "vdata where owner = $uid order by pop desc";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getProfileMedal($uid) {

        		$q = "SELECT id,categorie,plaats,week,img,points from " . TB_PREFIX . "medal where userid = $uid order by id desc";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);



        	}



        	function getProfileMedalAlly($uid) {

        		$q = "SELECT id,categorie,plaats,week,img,points from " . TB_PREFIX . "allimedal where allyid = $uid order by id desc";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);



        	}



        	function getVillageID($uid) {

        		$q = "SELECT wref FROM " . TB_PREFIX . "vdata WHERE owner = $uid";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['wref'];

        	}





        	function getVillagesID($uid) {

        		$q = "SELECT wref from " . TB_PREFIX . "vdata where owner = $uid order by capital DESC";

        		$result = mysql_query($q, $this->connection);

        		$array = $this->mysql_fetch_all($result);

        		$newarray = array();

        		for($i = 0; $i < count($array); $i++) {

        			array_push($newarray, $array[$i]['wref']);

        		}

        		return $newarray;

        	}



        	function getVillage($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "vdata where wref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

        	function getOasisV($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "odata where wref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getAInfo($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata where id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

						

        	function getMInfo($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata left JOIN " . TB_PREFIX . "vdata ON " . TB_PREFIX . "vdata.wref = " . TB_PREFIX . "wdata.id where " . TB_PREFIX . "wdata.id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}



        	function getOMInfo($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "wdata left JOIN " . TB_PREFIX . "odata ON " . TB_PREFIX . "odata.wref = " . TB_PREFIX . "wdata.id where " . TB_PREFIX . "wdata.id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}



        	function getOasis($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "odata where conqured = $vid";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getOasisInfo($wid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "odata where wref = $wid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function getVillageField($ref, $field) {

        		$q = "SELECT $field FROM " . TB_PREFIX . "vdata where wref = $ref";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];



        	}



        	function getOasisField($ref, $field) {

        		$q = "SELECT $field FROM " . TB_PREFIX . "odata where wref = $ref";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}



        	function setVillageField($ref, $field, $value) {

        		$q = "UPDATE " . TB_PREFIX . "vdata set $field = '$value' where wref = $ref";

        		return mysql_query($q, $this->connection);

        	}



        	function setVillageLevel($ref, $field, $value) {

        		$q = "UPDATE " . TB_PREFIX . "fdata set " . $field . " = '" . $value . "' where vref = " . $ref . "";

        		return mysql_query($q, $this->connection);

        	}



        	function getResourceLevel($vid) {

        		$q = "SELECT * from " . TB_PREFIX . "fdata where vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function getAdminLog() {

        		$q = "SELECT id,user,log,time from " . TB_PREFIX . "admin_log where id != 0 ORDER BY id DESC";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

			function delAdminLog($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "admin_log where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function getCoor($wref) {

        		$q = "SELECT x,y FROM " . TB_PREFIX . "wdata where id = $wref";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

        	function CheckForum($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_cat where alliance = '$id'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function CountCat($id) {

        		$q = "SELECT count(id) FROM " . TB_PREFIX . "forum_topic where cat = '$id'";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		return $row[0];

        	}



        	function LastTopic($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_topic where cat = '$id' order by post_date";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function CheckLastTopic($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_topic where cat = '$id'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function CheckLastPost($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_post where topic = '$id'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function LastPost($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_post where topic = '$id'";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function CountTopic($id) {

        		$q = "SELECT count(id) FROM " . TB_PREFIX . "forum_post where owner = '$id'";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);



        		$qs = "SELECT count(id) FROM " . TB_PREFIX . "forum_topic where owner = '$id'";

        		$results = mysql_query($qs, $this->connection);

        		$rows = mysql_fetch_row($results);

        		return $row[0] + $rows[0];

        	}



        	function CountPost($id) {

        		$q = "SELECT count(id) FROM " . TB_PREFIX . "forum_post where topic = '$id'";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		return $row[0];

        	}



        	function ForumCat($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_cat where alliance = '$id' ORDER BY id";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function ForumCatEdit($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_cat where id = '$id'";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function ForumCatName($id) {

        		$q = "SELECT forum_name from " . TB_PREFIX . "forum_cat where id = $id";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['forum_name'];

        	}



        	function CheckCatTopic($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_topic where cat = '$id'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function CheckResultEdit($alli) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_edit where alliance = '$alli'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function CheckCloseTopic($id) {

        		$q = "SELECT close from " . TB_PREFIX . "forum_topic where id = '$id'";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['close'];

        	}



        	function CheckEditRes($alli) {

        		$q = "SELECT result from " . TB_PREFIX . "forum_edit where alliance = '$alli'";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['result'];

        	}



        	function CreatResultEdit($alli, $result) {

        		$q = "INSERT into " . TB_PREFIX . "forum_edit values (0,'$alli','$result')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	function UpdateResultEdit($alli, $result) {

        		$date = time();

        		$q = "UPDATE " . TB_PREFIX . "forum_edit set result = '$result' where alliance = '$alli'";

        		return mysql_query($q, $this->connection);

        	}



        	function UpdateEditTopic($id, $title, $cat) {

        		$q = "UPDATE " . TB_PREFIX . "forum_topic set title = '$title', cat = '$cat' where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function UpdateEditForum($id, $name, $des) {

        		$q = "UPDATE " . TB_PREFIX . "forum_cat set forum_name = '$name', forum_des = '$des' where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function StickTopic($id, $mode) {

        		$q = "UPDATE " . TB_PREFIX . "forum_topic set stick = '$mode' where id = '$id'";

        		return mysql_query($q, $this->connection);

        	}



        	function ForumCatTopic($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_topic where cat = '$id' AND stick = '' ORDER BY post_date desc";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function ForumCatTopicStick($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_topic where cat = '$id' AND stick = '1' ORDER BY post_date desc";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function ShowTopic($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_topic where id = '$id'";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function ShowPost($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_post where topic = '$id'";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function ShowPostEdit($id) {

        		$q = "SELECT * from " . TB_PREFIX . "forum_post where id = '$id'";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function CreatForum($owner, $alli, $name, $des, $area) {

        		$q = "INSERT into " . TB_PREFIX . "forum_cat values (0,'$owner','$alli','$name','$des','$area')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	function CreatTopic($title, $post, $cat, $owner, $alli, $ends) {

        		$date = time();

        		$q = "INSERT into " . TB_PREFIX . "forum_topic values (0,'$title','$post','$date','$date','$cat','$owner','$alli','$ends','','')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	function CreatPost($post, $tids, $owner) {

        		$date = time();

        		$q = "INSERT into " . TB_PREFIX . "forum_post values (0,'$post','$tids','$owner','$date')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	function UpdatePostDate($id) {

        		$date = time();

        		$q = "UPDATE " . TB_PREFIX . "forum_topic set post_date = '$date' where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function EditUpdateTopic($id, $post) {

        		$q = "UPDATE " . TB_PREFIX . "forum_topic set post = '$post' where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function EditUpdatePost($id, $post) {

        		$q = "UPDATE " . TB_PREFIX . "forum_post set post = '$post' where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function LockTopic($id, $mode) {

        		$q = "UPDATE " . TB_PREFIX . "forum_topic set close = '$mode' where id = '$id'";

        		return mysql_query($q, $this->connection);

        	}



        	function DeleteCat($id) {

        		$qs = "DELETE from " . TB_PREFIX . "forum_cat where id = '$id'";

        		$q = "DELETE from " . TB_PREFIX . "forum_topic where cat = '$id'";

        		mysql_query($qs, $this->connection);

        		return mysql_query($q, $this->connection);

        	}



        	function DeleteTopic($id) {

        		$qs = "DELETE from " . TB_PREFIX . "forum_topic where id = '$id'";

        		//  $q = "DELETE from ".TB_PREFIX."forum_post where topic = '$id'";//

        		return mysql_query($qs, $this->connection); //

        		// mysql_query($q,$this->connection);

        	}



        	function DeletePost($id) {

        		$q = "DELETE from " . TB_PREFIX . "forum_post where id = '$id'";

        		return mysql_query($q, $this->connection);

        	}



        	function getAllianceName($id) {

        		$q = "SELECT tag from " . TB_PREFIX . "alidata where id = $id";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['tag'];

        	}



        	function getAlliancePermission($ref, $field, $mode) {

        		if(!$mode) {

        			$q = "SELECT $field FROM " . TB_PREFIX . "ali_permission where uid = '$ref'";

        		} else {

        			$q = "SELECT $field FROM " . TB_PREFIX . "ali_permission where username = '$ref'";

        		}

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}



        	function getAlliance($id) {

        		$q = "SELECT * from " . TB_PREFIX . "alidata where id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function setAlliName($aid, $name, $tag) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set name = '$name', tag = '$tag' where id = $aid";

        		return mysql_query($q, $this->connection);

        	}



        	function isAllianceOwner($id) {

        		$q = "SELECT * from " . TB_PREFIX . "alidata where leader = '$id'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function aExist($ref, $type) {

        		$q = "SELECT $type FROM " . TB_PREFIX . "alidata where $type = '$ref'";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	function modifyPoints($aid, $points, $amt) {

        		$q = "UPDATE " . TB_PREFIX . "users set $points = $points + $amt where id = $aid";

        		return mysql_query($q, $this->connection);

        	}



        	function modifyPointsAlly($aid, $points, $amt) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set $points = $points + $amt where id = $aid";

        		return mysql_query($q, $this->connection);

        	}



        	/*****************************************

        	Function to create an alliance

        	References: 

        	*****************************************/

        	function createAlliance($tag, $name, $uid, $max) {

        		$q = "INSERT into " . TB_PREFIX . "alidata values (0,'$name','$tag',$uid,0,0,0,'','',$max,'','','','','','','','')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	/*****************************************

        	Function to insert an alliance new

        	References: 

        	*****************************************/

        	function insertAlliNotice($aid, $notice) {

        		$time = time();

        		$q = "INSERT into " . TB_PREFIX . "ali_log values (0,'$aid','$notice',$time)";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	/*****************************************

        	Function to delete alliance if empty

        	References: 

        	*****************************************/

        	function deleteAlliance($aid) {

        		$result = mysql_query("SELECT * FROM " . TB_PREFIX . "users where alliance = $aid");

        		$num_rows = mysql_num_rows($result);

        		if($num_rows == 0) {

        			$q = "DELETE FROM " . TB_PREFIX . "alidata WHERE id = $aid";

        		}

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	/*****************************************

        	Function to read all alliance news

        	References: 

        	*****************************************/

        	function readAlliNotice($aid) {

        		$q = "SELECT * from " . TB_PREFIX . "ali_log where aid = $aid ORDER BY date DESC";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	/*****************************************

        	Function to create alliance permissions

        	References: ID, notice, description

        	*****************************************/

        	function createAlliPermissions($uid, $aid, $rank, $opt1, $opt2, $opt3, $opt4, $opt5, $opt6, $opt7, $opt8) {



        		$q = "INSERT into " . TB_PREFIX . "ali_permission values(0,'$uid','$aid','$rank','$opt1','$opt2','$opt3','$opt4','$opt5','$opt6','$opt7','$opt8')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	/*****************************************

        	Function to update alliance permissions

        	References: 

        	*****************************************/

        	function deleteAlliPermissions($uid) {

        		$q = "DELETE from " . TB_PREFIX . "ali_permission where uid = '$uid'";

        		return mysql_query($q, $this->connection);

        	}

        	/*****************************************

        	Function to update alliance permissions

        	References: 

        	*****************************************/

        	function updateAlliPermissions($uid, $aid, $rank, $opt1, $opt2, $opt3, $opt4, $opt5, $opt6, $opt7) {



        		$q = "UPDATE " . TB_PREFIX . "ali_permission SET rank = '$rank', opt1 = '$opt1', opt2 = '$opt2', opt3 = '$opt3', opt4 = '$opt4', opt5 = '$opt5', opt6 = '$opt6', opt7 = '$opt7' where uid = $uid && alliance =$aid";

        		return mysql_query($q, $this->connection);

        	}



        	/*****************************************

        	Function to read alliance permissions

        	References: ID, notice, description

        	*****************************************/

        	function getAlliPermissions($uid, $aid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "ali_permission where uid = $uid && alliance = $aid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	/*****************************************

        	Function to update an alliance description and notice

        	References: ID, notice, description

        	*****************************************/

        	function submitAlliProfile($aid, $notice, $desc) {



        		$q = "UPDATE " . TB_PREFIX . "alidata SET `notice` = '$notice', `desc` = '$desc' where id = $aid";

        		return mysql_query($q, $this->connection);

        	}



        	function diplomacyInviteAdd($alli1, $alli2, $type) {

        		$q = "INSERT INTO " . TB_PREFIX . "diplomacy (alli1,alli2,type,accepted) VALUES ($alli1,$alli2," . (int)intval($type) . ",0)";

        		return mysql_query($q, $this->connection);

        	}



        	function diplomacyOwnOffers($session_alliance) {

        		$q = "SELECT * FROM " . TB_PREFIX . "diplomacy WHERE alli1 = $session_alliance AND accepted = 0";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

            

            function getAllianceID($name) {

        		$q = "SELECT id FROM " . TB_PREFIX . "alidata WHERE tag ='" . $this->RemoveXSS($name) . "'";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['id'];

        	}



        	function getDiplomacy($aid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "diplomacy WHERE id = $aid";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function diplomacyCancelOffer($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "diplomacy WHERE id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function diplomacyInviteAccept($id, $session_alliance) {

        		$q = "UPDATE " . TB_PREFIX . "diplomacy SET accepted = 1 WHERE id = $id AND alli2 = $session_alliance";

        		return mysql_query($q, $this->connection);

        	}



        	function diplomacyInviteDenied($id, $session_alliance) {

        		$q = "DELETE FROM " . TB_PREFIX . "diplomacy WHERE id = $id AND alli2 = $session_alliance";

        		return mysql_query($q, $this->connection);

        	}



        	function diplomacyInviteCheck($session_alliance) {

        		$q = "SELECT * FROM " . TB_PREFIX . "diplomacy WHERE alli2 = $session_alliance AND accepted = 0";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function diplomacyExistingRelationships($session_alliance) {

        		$q = "SELECT * FROM " . TB_PREFIX . "diplomacy WHERE alli2 = $session_alliance AND accepted = 1";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

            

            function diplomacyExistingRelationships2($session_alliance) {

        		$q = "SELECT * FROM " . TB_PREFIX . "diplomacy WHERE alli1 = $session_alliance AND accepted = 1";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function diplomacyCancelExistingRelationship($id, $session_alliance) {

        		$q = "DELETE FROM " . TB_PREFIX . "diplomacy WHERE id = $id AND alli2 = $session_alliance";

        		return mysql_query($q, $this->connection);

        	}



        	function getUserAlliance($id) {

        		$q = "SELECT " . TB_PREFIX . "alidata.tag from " . TB_PREFIX . "users join " . TB_PREFIX . "alidata where " . TB_PREFIX . "users.alliance = " . TB_PREFIX . "alidata.id and " . TB_PREFIX . "users.id = $id";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		if($dbarray['tag'] == "") {

        			return "-";

        		} else {

        			return $dbarray['tag'];

        		}

        	}



        	function modifyResource($vid, $wood, $clay, $iron, $crop, $mode) {

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "vdata set wood = wood - $wood, clay = clay - $clay, iron = iron - $iron, crop = crop - $crop where wref = $vid";

        		} else {

        			$q = "UPDATE " . TB_PREFIX . "vdata set wood = wood + $wood, clay = clay + $clay, iron = iron + $iron, crop = crop + $crop where wref = $vid";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	function modifyOasisResource($vid, $wood, $clay, $iron, $crop, $mode) {

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "odata set wood = wood - $wood, clay = clay - $clay, iron = iron - $iron, crop = crop - $crop where wref = $vid";

        		} else {

        			$q = "UPDATE " . TB_PREFIX . "odata set wood = wood + $wood, clay = clay + $clay, iron = iron + $iron, crop = crop + $crop where wref = $vid";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	function getFieldLevel($vid, $field) {

        		$q = "SELECT f" . $field . " from " . TB_PREFIX . "fdata where vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_result($result, 0);

        	}



        	function getFieldType($vid, $field) {

        		$q = "SELECT f" . $field . "t from " . TB_PREFIX . "fdata where vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_result($result, 0);

        	}



        	function getVSumField($uid, $field) {

        		$q = "SELECT sum(" . $field . ") FROM " . TB_PREFIX . "vdata where owner = $uid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		return $row[0];

        	}



        	function updateVillage($vid) {

        		$time = time();

        		$q = "UPDATE " . TB_PREFIX . "vdata set lastupdate = $time where wref = $vid";

        		return mysql_query($q, $this->connection);

        	}

        	function updateOasis($vid) {

        		$time = time();

        		$q = "UPDATE " . TB_PREFIX . "odata set lastupdated = $time where wref = $vid";

        		return mysql_query($q, $this->connection);

        	}





        	function setVillageName($vid, $name) {

        		$q = "UPDATE " . TB_PREFIX . "vdata set name = '$name' where wref = $vid";

        		return mysql_query($q, $this->connection);

        	}



        	function modifyPop($vid, $pop, $mode) {

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "vdata set pop = pop + $pop where wref = $vid";

        		} else {

        			$q = "UPDATE " . TB_PREFIX . "vdata set pop = pop - $pop where wref = $vid";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	function addCP($ref, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "vdata set cp = cp + '$cp' where wref = '$ref'";

        		return mysql_query($q, $this->connection);

        	}



        	function addCel($ref, $cel, $type) {

        		$q = "UPDATE " . TB_PREFIX . "vdata set celebration = $cel, type= $type where wref = $ref";

        		return mysql_query($q, $this->connection);

        	}

        	function getCel() {

        		$time = time();

        		$q = "SELECT * FROM " . TB_PREFIX . "vdata where celebration < $time AND celebration != 0";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function clearCel($ref) {

        		$q = "UPDATE " . TB_PREFIX . "vdata set celebration = 0, type = 0 where wref = $ref";

        		return mysql_query($q, $this->connection);

        	}

        	function setCelCp($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "users set cp = cp + $cp where id = $user";

        		return mysql_query($q, $this->connection);

        	}



        	function clearExpansionSlot($id) {

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

        			$q = "UPDATE " . TB_PREFIX . "vdata SET exp" . $i . "=0 WHERE exp" . $i . "=" . $id;

        			mysql_query($q, $this->connection);

        		}

        	}



        	function getInvitation($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "ali_invite where uid = $uid";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getAliInvitations($aid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "ali_invite where alliance = $aid && accept = 0";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function sendInvitation($uid, $alli, $sender) {

        		$time = time();

        		$q = "INSERT INTO " . TB_PREFIX . "ali_invite values (0,$uid,$alli,$sender,$time,0)";

        		return mysql_query($q, $this->connection) or die(mysql_error());

        	}



        	function removeInvitation($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "ali_invite where id = $id";

        		return mysql_query($q, $this->connection);

        	}

			

			function delMessage($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "mdata WHERE id = $id";

        		return mysql_query($q, $this->connection);

        	}

			

			function delNotice($id, $uid) {

        		$q = "DELETE FROM " . TB_PREFIX . "ndata WHERE id = $id AND uid = $uid";

        		return mysql_query($q, $this->connection);

        	}



        	function sendMessage($client, $owner, $topic, $message, $send) {

        		$time = time();

        		$q = "INSERT INTO " . TB_PREFIX . "mdata values (0,$client,$owner,'$topic',\"$message\",0,0,$send,$time)";

        		return mysql_query($q, $this->connection);

        	}



        	function setArchived($id) {

        		$q = "UPDATE " . TB_PREFIX . "mdata set archived = 1 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function setNorm($id) {

        		$q = "UPDATE " . TB_PREFIX . "mdata set archived = 0 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	/***************************

        	Function to get messages

        	Mode 1: Get inbox

        	Mode 2: Get sent

        	Mode 3: Get message

        	Mode 4: Set viewed

        	Mode 5: Remove message

        	Mode 6: Retrieve archive

        	References: User ID/Message ID, Mode

        	***************************/

        	function getMessage($id, $mode) {

        		global $session;

        		switch($mode) {

        			case 1:

        				$q = "SELECT * FROM " . TB_PREFIX . "mdata WHERE target = $id and send = 0 and archived = 0 ORDER BY time DESC";

        				break;

        			case 2:

        				// removed send no longer needed as we dont send 2 messages any more just 1

        				$q = "SELECT * FROM " . TB_PREFIX . "mdata WHERE owner = $id ORDER BY time DESC";

        				break;

        			case 3:

        				$q = "SELECT * FROM " . TB_PREFIX . "mdata where id = $id";

        				break;

        			case 4:

        				$q = "UPDATE " . TB_PREFIX . "mdata set viewed = 1 where id = $id AND target = $session->uid";

        				break;

        			case 5:

        				$q = "DELETE FROM " . TB_PREFIX . "mdata where id = $id";

        				break;

        			case 6:

        				$q = "SELECT * FROM " . TB_PREFIX . "mdata where target = $id and send = 0 and archived = 1";

        				break;

					case 7:

        				$q = "SELECT * FROM " . TB_PREFIX . "mdata where target = $id and viewed = 0 and archived = 0";

        				break;

					case 8:

        				$q = "SELECT * FROM " . TB_PREFIX . "ndata where uid = $id and viewed = 0";

        				break;

        		}

        		if($mode <= 3 || $mode >= 7) {

        			$result = mysql_query($q, $this->connection);

        			return $this->mysql_fetch_all($result);

        		} else {

        			return mysql_query($q, $this->connection);

        		}

        	}



        	function unarchiveNotice($id) {

        		$q = "UPDATE " . TB_PREFIX . "ndata set archive = 0 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function archiveNotice($id) {

        		$q = "update " . TB_PREFIX . "ndata set archive = 1 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function removeNotice($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "ndata where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function noticeViewed($id) {

        		$q = "UPDATE " . TB_PREFIX . "ndata set viewed = 1 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function addNotice($uid, $toWref, $ally, $type, $topic, $data, $time = 0) {

        		if($time == 0) {

        			$time = time();

        		}

        		$q = "INSERT INTO " . TB_PREFIX . "ndata (id, uid, toWref, ally, topic, ntype, data, time, viewed) values (0,'$uid','$toWref','$ally','$topic',$type,'$data',$time,0)";

        		return mysql_query($q, $this->connection) or die(mysql_error());

        	}



        	function getNotice($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "ndata where uid = $uid ORDER BY time DESC";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

			

			function getAttacks($ref) {

        		$q = "SELECT * FROM " . TB_PREFIX . "attacks where id = '$ref'";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

			function getAlliAttacks($aid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "ndata WHERE ally = $aid ORDER BY time DESC";

        	}



        	function addBuilding($wid, $field, $type, $loop, $time) {

        		$x = "UPDATE " . TB_PREFIX . "fdata SET f" . $field . "t=" . $type . " WHERE vref=" . $wid;

        		mysql_query($x, $this->connection) or die(mysql_error());

        		$q = "INSERT into " . TB_PREFIX . "bdata values (0,$wid,$field,$type,$loop,$time)";

        		return mysql_query($q, $this->connection);

        	}



        	function removeBuilding($d) {

        		global $building;

        		$jobLoopconID = -1;

        		$SameBuildCount = 0;

        		$jobs = $building->buildArray;

        		for($i = 0; $i < sizeof($jobs); $i++) {

        			if($jobs[$i]['id'] == $d) {

        				$jobDeleted = $i;

        			}

        			if($jobs[$i]['loopcon'] == 1) {

        				$jobLoopconID = $i;

        			}

        		}

        		if(count($jobs) > 1 && ($jobs[0]['field'] == $jobs[1]['field'])) {

        			$SameBuildCount = 1;

        		}

        		if(count($jobs) > 2 && ($jobs[0]['field'] == $jobs[2]['field'])) {

        			$SameBuildCount = 2;

        		}

        		if(count($jobs) > 2 && ($jobs[1]['field'] == $jobs[2]['field'])) {

        			$SameBuildCount = 3;

        		}



        		if($SameBuildCount > 0) {

        			if($d == $jobs[floor($SameBuildCount / 3)]['id'] || $d == $jobs[floor($SameBuildCount / 2) + 1]['id']) {

        				$q = "UPDATE " . TB_PREFIX . "bdata SET loopcon=0,timestamp=" . $jobs[floor($SameBuildCount / 3)]['timestamp'] . " WHERE ID=" . $jobs[floor($SameBuildCount / 3)]['id'] . " OR ID=" . $jobs[floor($SameBuildCount / 2) + 1]['id'];

        				mysql_query($q, $this->connection);

        			}

        		} else {

        			if($jobs[$jobDeleted]['field'] >= 19) {

        				$x = "SELECT f" . $jobs[$jobDeleted]['field'] . " FROM " . TB_PREFIX . "fdata WHERE vref=" . $jobs[$jobDeleted]['wid'];

        				$result = mysql_query($x, $this->connection) or die(mysql_error());

        				$fieldlevel = mysql_fetch_row($result);

        				if($fieldlevel[0] == 0) {

        					$x = "UPDATE " . TB_PREFIX . "fdata SET f" . $jobs[$jobDeleted]['field'] . "t=0 WHERE vref=" . $jobs[$jobDeleted]['wid'];

        					mysql_query($x, $this->connection) or die(mysql_error());

        				}

        			}

        			if(($jobLoopconID >= 0) && ($jobs[$jobDeleted]['loopcon'] != 1)) {

        				if(($jobs[$jobLoopconID]['field'] <= 18 && $jobs[$jobDeleted]['field'] <= 18) || ($jobs[$jobLoopconID]['field'] >= 19 && $jobs[$jobDeleted]['field'] >= 19)) {

        					$uprequire = $building->resourceRequired($jobs[$jobLoopconID]['field'], $jobs[$jobLoopconID]['type']);

        					$x = "UPDATE " . TB_PREFIX . "bdata SET loopcon=0,timestamp=" . (time() + $uprequire['time']) . " WHERE wid=" . $jobs[$jobDeleted]['wid'] . " AND loopcon=1";

        					mysql_query($x, $this->connection) or die(mysql_error());

        				}

        			}

        		}

        		$q = "DELETE FROM " . TB_PREFIX . "bdata where id = $d";

        		return mysql_query($q, $this->connection);

        	}



        	function addDemolition($wid, $field) {

        		global $building, $village;

				$q = "DELETE FROM ".TB_PREFIX."bdata WHERE field=$field AND wid=$wid";

				mysql_query($q, $this->connection);

        		$uprequire = $building->resourceRequired($field,$village->resarray['f'.$field.'t']);

        		$q = "INSERT INTO ".TB_PREFIX."demolition VALUES (".$wid.",".$field.",".($this->getFieldLevel($wid,$field)-1).",".(time()+floor($uprequire['time']/2)).")";

				return mysql_query($q, $this->connection);

        	}





        	function getDemolition($wid = 0) {

        		if($wid) {

        			$q = "SELECT * FROM " . TB_PREFIX . "demolition WHERE vref=" . $wid;

        		} else {

        			$q = "SELECT * FROM " . TB_PREFIX . "demolition WHERE timetofinish<=" . time();

        		}

        		$result = mysql_query($q, $this->connection);

				if(!empty($result)) {

	        		return $this->mysql_fetch_all($result);

				} else {

					return NULL;

				}

        	}



        	function finishDemolition($wid) {

        		$q = "UPDATE " . TB_PREFIX . "demolition SET timetofinish=" . time() . " WHERE vref=" . $wid;

        		return mysql_query($q, $this->connection);

        	}



        	function delDemolition($wid) {

        		$q = "DELETE FROM " . TB_PREFIX . "demolition WHERE vref=" . $wid;

        		return mysql_query($q, $this->connection);

        	}



        	function getJobs($wid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "bdata where wid = $wid order by ID ASC";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getVillageByName($name) {

        		$name = mysql_real_escape_string($name, $this->connection);

        		$q = "SELECT wref FROM " . TB_PREFIX . "vdata where name = '$name' limit 1";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['wref'];

        	}



        	/***************************

        	Function to set accept flag on market

        	References: id

        	***************************/

        	function setMarketAcc($id) {

        		$q = "UPDATE " . TB_PREFIX . "market set accept = 1 where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	/***************************

        	Function to send resource to other village

        	Mode 0: Send

        	Mode 1: Cancel

        	References: Wood/ID, Clay, Iron, Crop, Mode

        	***************************/

        	function sendResource($ref, $clay, $iron, $crop, $merchant, $mode) {

        		if(!$mode) {

        			$q = "INSERT INTO " . TB_PREFIX . "send values (0,$ref,$clay,$iron,$crop,$merchant)";

        			mysql_query($q, $this->connection);

        			return mysql_insert_id($this->connection);

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "send where id = $ref";

        			return mysql_query($q, $this->connection);

        		}

        	}



        	/***************************

        	Function to get resources back if you delete offer

        	References: VillageRef (vref)

        	Made by: Dzoki

        	***************************/



        	function getResourcesBack($vref, $gtype, $gamt) {

        		//Xtype (1) = wood, (2) = clay, (3) = iron, (4) = crop

        		if($gtype == 1) {

        			$q = "UPDATE " . TB_PREFIX . "vdata SET `wood` = `wood` + '$gamt' WHERE wref = $vref";

        			return mysql_query($q, $this->connection);

        		} else

        			if($gtype == 2) {

        				$q = "UPDATE " . TB_PREFIX . "vdata SET `clay` = `clay` + '$gamt' WHERE wref = $vref";

        				return mysql_query($q, $this->connection);

        			} else

        				if($gtype == 3) {

        					$q = "UPDATE " . TB_PREFIX . "vdata SET `iron` = `iron` + '$gamt' WHERE wref = $vref";

        					return mysql_query($q, $this->connection);

        				} else

        					if($gtype == 4) {

        						$q = "UPDATE " . TB_PREFIX . "vdata SET `crop` = `crop` + '$gamt' WHERE wref = $vref";

        						return mysql_query($q, $this->connection);

        					}

        	}



        	/***************************

        	Function to get info about offered resources

        	References: VillageRef (vref)

        	Made by: Dzoki

        	***************************/



        	function getMarketField($vref, $field) {

        		$q = "SELECT $field FROM " . TB_PREFIX . "market where vref = '$vref'";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}



        	function removeAcceptedOffer($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "market where id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	/***************************

        	Function to add market offer

        	Mode 0: Add

        	Mode 1: Cancel

        	References: Village, Give, Amt, Want, Amt, Time, Alliance, Mode

        	***************************/

        	function addMarket($vid, $gtype, $gamt, $wtype, $wamt, $time, $alliance, $merchant, $mode) {

        		if(!$mode) {

        			$q = "INSERT INTO " . TB_PREFIX . "market values (0,$vid,$gtype,$gamt,$wtype,$wamt,0,$time,$alliance,$merchant)";

        			mysql_query($q, $this->connection);

        			return mysql_insert_id($this->connection);

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "market where id = $gtype and vref = $vid";

        			return mysql_query($q, $this->connection);

        		}

        	}



        	/***************************

        	Function to get market offer

        	References: Village, Mode

        	***************************/

        	function getMarket($vid, $mode) {

        		$alliance = $this->getUserField($this->getVillageField($vid, "owner"), "alliance", 0);

        		if(!$mode) {

        			$q = "SELECT * FROM " . TB_PREFIX . "market where vref = $vid and accept = 0 ORDER BY id DESC";

        		} else {

        			$q = "SELECT * FROM " . TB_PREFIX . "market where vref != $vid and alliance = $alliance or vref != $vid and alliance = 0 and accept = 0 ORDER BY id DESC";

        		}

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	/***************************

        	Function to get market offer

        	References: ID

        	***************************/

        	function getMarketInfo($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "market where id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function setMovementProc($moveid) {

        		$q = "UPDATE " . TB_PREFIX . "movement set proc = 1 where moveid = $moveid";

        		return mysql_query($q, $this->connection);

        	}



        	/***************************

        	Function to retrieve used merchant

        	References: Village

        	***************************/

        	function totalMerchantUsed($vid) {

        		$time = time();

        		$q = "SELECT sum(" . TB_PREFIX . "send.merchant) from " . TB_PREFIX . "send, " . TB_PREFIX . "movement where " . TB_PREFIX . "movement.from = $vid and " . TB_PREFIX . "send.id = " . TB_PREFIX . "movement.ref and " . TB_PREFIX . "movement.proc = 0 and sort_type = 0";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		$q2 = "SELECT sum(ref) from " . TB_PREFIX . "movement where sort_type = 2 and " . TB_PREFIX . "movement.to = $vid and proc = 0";

        		$result2 = mysql_query($q2, $this->connection);

        		$row2 = mysql_fetch_row($result2);

        		$q3 = "SELECT sum(merchant) from " . TB_PREFIX . "market where vref = $vid and accept = 0";

        		$result3 = mysql_query($q3, $this->connection);

        		$row3 = mysql_fetch_row($result3);

        		return $row[0] + $row2[0] + $row3[0];

        	}



        	/***************************

        	Function to retrieve movement of village

        	Type 0: Send Resource

        	Type 1: Send Merchant

        	Type 2: Return Resource

        	Type 3: Attack

        	Type 4: Return

        	Type 5: Settler

        	Type 6: Bounty

			Type 7: Reinf.

			Type 9: Adventure

        	Mode 0: Send/Out

        	Mode 1: Recieve/In

        	References: Type, Village, Mode

        	***************************/

        	function getMovement($type, $village, $mode) {

        		$time = time();

        		if(!$mode) {

        			$where = "from";

        		} else {

        			$where = "to";

        		}

        		switch($type) {

        			case 0:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "send where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "send.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 0";

        				break;

        			case 2:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 2";

        				break;

        			case 3:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "attacks where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 3 ORDER BY endtime ASC";

        				break;

        			case 4:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "attacks where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 4 ORDER BY endtime ASC";

        				break;

        			case 5:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement where " . TB_PREFIX . "movement." . $where . " = $village and sort_type = 5 and proc = 0";

        				break;

        			case 6:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement," . TB_PREFIX . "odata, " . TB_PREFIX . "attacks where " . TB_PREFIX . "odata.conqured = $village and " . TB_PREFIX . "movement.to = " . TB_PREFIX . "odata.wref and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 3 ORDER BY endtime ASC";

        				break;

					case 9:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement where " . TB_PREFIX . "movement." . $where . " = $village and sort_type = 9 and proc = 0";

        				break;

        			case 34:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "attacks where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 3 or " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX .

        					"movement.sort_type = 4 ORDER BY endtime ASC";

        				break;

        		}

        		$result = mysql_query($q, $this->connection);

        		$array = $this->mysql_fetch_all($result);

        		return $array;

        	}

			

			/***************************

        	Function to retrieve movement of village

        	Type 3: Attack

        	Type 4: Return

        	Type 5: Settler

        	Type 6: Bounty

			Type 7: Reinf.

			Type 9: Adventure

        	Mode 0: Send/Out

        	Mode 1: Recieve/In

        	References: Type, Village, Mode

        	***************************/

			function getMovement2($type, $village, $mode) {

        		$time = time();

        		if(!$mode) {

        			$where = "from";

        		} else {

        			$where = "to";

        		}

        		switch($type) {

					case 3:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "attacks where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 3 and " . TB_PREFIX . "attacks.attack_type != 2 ORDER BY endtime DESC";

						break;

        			case 34:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "attacks where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 3 and " . TB_PREFIX . "attacks.attack_type != 3 and " . TB_PREFIX . "attacks.attack_type != 4 or " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX .

        					"movement.sort_type = 4 ORDER BY endtime DESC";

        				break;

        			case 5:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement where " . TB_PREFIX . "movement." . $where . " = $village and sort_type = 5 and proc = 0";

        				break;

					case 7:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement, " . TB_PREFIX . "attacks where " . TB_PREFIX . "movement." . $where . " = $village and " . TB_PREFIX . "movement.ref = " . TB_PREFIX . "attacks.id and " . TB_PREFIX . "movement.proc = 0 and " . TB_PREFIX . "movement.sort_type = 3 and " . TB_PREFIX . "attacks.attack_type = 2 ORDER BY endtime DESC";

					case 9:

        				$q = "SELECT * FROM " . TB_PREFIX . "movement where " . TB_PREFIX . "movement." . $where . " = $village and sort_type = 9 and proc = 0";

        				break;

						

        		}

        		$result = mysql_query($q, $this->connection);

        		$array = $this->mysql_fetch_all($result);

        		return $array;

        	}



        	function addA2b($ckey, $timestamp, $to, $t1, $t2, $t3, $t4, $t5, $t6, $t7, $t8, $t9, $t10, $t11, $type) {

        		$q = "INSERT INTO " . TB_PREFIX . "a2b (ckey,time_check,to_vid,u1,u2,u3,u4,u5,u6,u7,u8,u9,u10,u11,type) VALUES ('$ckey', '$timestamp', '$to', '$t1', '$t2', '$t3', '$t4', '$t5', '$t6', '$t7', '$t8', '$t9', '$t10', '$t11', '$type')";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	function getA2b($ckey, $check) {

        		$q = "SELECT * from " . TB_PREFIX . "a2b where ckey = '" . $ckey . "' AND time_check = '" . $check . "'";

        		$result = mysql_query($q, $this->connection);

        		if($result) {

        			return mysql_fetch_assoc($result);

        		} else {

        			return false;

        		}

        	}



        	function addMovement($type, $from, $to, $ref, $data, $endtime) {

        		$q = "INSERT INTO " . TB_PREFIX . "movement values (0,$type,$from,$to,$ref,'$data',$endtime,0)";

        		return mysql_query($q, $this->connection);

        	}



        	function addAttack($vid, $t1, $t2, $t3, $t4, $t5, $t6, $t7, $t8, $t9, $t10, $t11, $type, $ctar1, $ctar2, $spy) {

        		$q = "INSERT INTO " . TB_PREFIX . "attacks values (0,$vid,$t1,$t2,$t3,$t4,$t5,$t6,$t7,$t8,$t9,$t10,$t11,$type,$ctar1,$ctar2,$spy)";

        		mysql_query($q, $this->connection);

        		return mysql_insert_id($this->connection);

        	}



        	function modifyAttack($aid, $unit, $amt) {

        		$unit = 't' . $unit;

        		$q = "UPDATE " . TB_PREFIX . "attacks set $unit = $unit - $amt where id = $aid";

        		return mysql_query($q, $this->connection);

        	}



        	function getRanking() {

        		$q = "SELECT id,username,alliance,ap,apall,dp,dpall,access FROM " . TB_PREFIX . "users WHERE tribe<=3 AND access<" . (INCLUDE_ADMIN ? "10" : "8");

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

			function getBuildList($type) {

        		$q = "SELECT * FROM " . TB_PREFIX . "bdata WHERE type = $type";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getVRanking() {

        		$q = "SELECT v.wref,v.name,v.owner,v.pop FROM " . TB_PREFIX . "vdata AS v," . TB_PREFIX . "users AS u WHERE v.owner=u.id AND u.tribe<=3 AND v.wref != '' AND u.access<" . (INCLUDE_ADMIN ? "10" : "8");

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getARanking() {

        		$q = "SELECT id,name,tag FROM " . TB_PREFIX . "alidata where id != ''";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}

			

        	function getHeroRanking() {

        		$q = "SELECT * FROM " . TB_PREFIX . "hero";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getAllMember($aid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "users where alliance = $aid order  by (SELECT sum(pop) FROM " . TB_PREFIX . "vdata WHERE owner =  " . TB_PREFIX . "users.id) desc";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function addUnits($vid) {

        		$q = "INSERT into " . TB_PREFIX . "units (vref) values ($vid)";

        		return mysql_query($q, $this->connection);

        	}



        	function getUnit($vid) {

				$q = "SELECT * FROM " . TB_PREFIX . "units where vref = ".$vid."";

        		$result = mysql_query($q, $this->connection);

        		if (!empty($result)) {

					return mysql_fetch_assoc($result);

				} else {

					return NULL;

				}

        	}

			function getHUnit($vid) {

				$q = "SELECT hero FROM " . TB_PREFIX . "units where vref = ".$vid."";

        		$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

        		if ($dbarray['hero']!=0) {

					return true;

				} else {

					return false;

				}

        	}

			

        	function getHero($uid=0) {

				if (!$uid) {

					$q = "SELECT * FROM ".TB_PREFIX."hero";

				} else {

	        		$q = "SELECT * FROM ".TB_PREFIX."hero WHERE dead=0 AND uid=$uid LIMIT 1";

				}

        		$result = mysql_query($q, $this->connection);

        		if (!empty($result)) {

					return $this->mysql_fetch_all($result);

				} else {

					return NULL;

				}

        	}



			function modifyHero($column,$value,$heroid,$mode=0) {

				if(!$mode){

					$q = "UPDATE ".TB_PREFIX."hero SET $column = $value WHERE heroid = $heroid";

				} elseif($mode==1){

					$q = "UPDATE ".TB_PREFIX."hero SET $column = $column + $value WHERE heroid = $heroid";

				} elseif($mode==2){

					$q = "UPDATE ".TB_PREFIX."hero SET $column = $column - $value WHERE heroid = $heroid";

				}

				return mysql_query($q, $this->connection);

			}

			

			function modifyHero2($column,$value,$uid,$mode) {

				if(!$mode){

					$q = "UPDATE ".TB_PREFIX."hero SET $column = $value WHERE uid = $uid";

				} elseif($mode==1){

					$q = "UPDATE ".TB_PREFIX."hero SET $column = $column + $value WHERE uid = $uid";

				} elseif($mode==2){

					$q = "UPDATE ".TB_PREFIX."hero SET $column = $column - $value WHERE uid = $uid";

				}

				return mysql_query($q, $this->connection);

			}

						

        	function addTech($vid) {

        		$q = "INSERT into " . TB_PREFIX . "tdata (vref) values ($vid)";

        		return mysql_query($q, $this->connection);

        	}



        	function addABTech($vid) {

        		$q = "INSERT into " . TB_PREFIX . "abdata (vref) values ($vid)";

        		return mysql_query($q, $this->connection);

        	}



        	function getABTech($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "abdata where vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function addResearch($vid, $tech, $time) {

        		$q = "INSERT into " . TB_PREFIX . "research values (0,$vid,'$tech',$time)";

        		return mysql_query($q, $this->connection);

        	}



        	function getResearching($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "research where vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function checkIfResearched($vref, $unit) {

        		$q = "SELECT $unit FROM " . TB_PREFIX . "tdata WHERE vref = $vref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$unit];

        	}



        	function getTech($vid) {

        		$q = "SELECT * from " . TB_PREFIX . "tdata where vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function getTraining($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "training where vref = $vid ORDER BY id";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function countTraining($vid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "training WHERE vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		return $row[0];

        	}



        	function trainUnit($vid, $unit, $amt, $pop, $each, $time, $mode) {

        		global $village, $building, $session, $technology;



        		if(!$mode) {

        			$barracks = array(1, 2, 3, 11, 12, 13, 14, 21, 22, 31, 32, 33, 34, 41, 42, 43, 44);

        			$stables = array(4, 5, 6, 15, 16, 23, 24, 25, 26, 35, 36, 45, 46);

        			$workshop = array(7, 8, 17, 18, 27, 28, 37, 38, 47, 48);

        			$residence = array(9, 10, 19, 20, 29, 30, 39, 40, 49, 50);



        			if(in_array($unit, $barracks)) {

        				$queued = $technology->getTrainingList(1);

        			} elseif(in_array($unit, $stables)) {

        				$queued = $technology->getTrainingList(2);

        			} elseif(in_array($unit, $workshop)) {

        				$queued = $technology->getTrainingList(3);

        			} elseif(in_array($unit, $residence)) {

        				$queued = $technology->getTrainingList(4);

        			}

        			if(count($queued) > 0) {

        				$time = $queued[count($queued) - 1]['commence'] + $queued[count($queued) - 1]['eachtime'] * $queued[count($queued) - 1]['amt'];

        			}

        			$now = time();

        			$q = "INSERT INTO " . TB_PREFIX . "training values (0,$vid,$unit,$amt,$pop,$now,$each,$time)";

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "training where id = $vid";

        		}

        		return mysql_query($q, $this->connection);

        	}

			

			function getHeroTrain($vid) {

        		$q = "SELECT * from " . TB_PREFIX . "training where vref = $vid and unit = 0";

        		$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

					if(empty($result)) {

						return false;

					} else {

						return $dbarray;

					}

        	}

			

			function trainHero($vid, $each, $mode) {

        		if(!$mode) {

        			$time = time();

        			$q = "INSERT INTO " . TB_PREFIX . "training values (0,$vid,0,1,6,$time,$each,$time)";

        		} else {

        			$q = "DELETE FROM " . TB_PREFIX . "training where id = $vid";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	function updateTraining($id, $trained) {

        		$time = time();

        		$q = "UPDATE " . TB_PREFIX . "training set amt = amt - $trained, timestamp = $time where id = $id";

        		return mysql_query($q, $this->connection);

        	}



        	function modifyUnit($vref, $unit, $amt, $mode) {

        		if($unit == 230) {

        			$unit = 30;

        		}

        		if($unit == 231) {

        			$unit = 31;

        		}

        		if($unit == 120) {

        			$unit = 20;

        		}

        		if($unit == 121) {

        			$unit = 21;

        		}

				if($unit == 'hero'){

					$unit = 'hero';

				}else{

        			$unit = 'u' . $unit;

				}

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "units set $unit = $unit - $amt where vref = $vref";

        		} else {

        			$q = "UPDATE " . TB_PREFIX . "units set $unit = $unit + $amt where vref = $vref";

        		}

        		return mysql_query($q, $this->connection);

        	}



        	function getEnforce($vid, $from) {

        		$q = "SELECT * from " . TB_PREFIX . "enforcement where `from` = $from and vref = $vid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}

			

			function checkEnforce($vid, $from) {

				$q = "SELECT * from " . TB_PREFIX . "enforcement where `from` = $from and vref = $vid";

        		$result = mysql_query($q, $this->connection);

				if(!empty($result)) {

					return mysql_insert_id($this->connection);

				}else{

					return true;

				}

			}

			



        	function addEnforce($data) {

        		$q = "INSERT into " . TB_PREFIX . "enforcement (vref,`from`) values (" . $data['to'] . "," . $data['from'] . ")";

        		mysql_query($q, $this->connection);

        		$id = mysql_insert_id($this->connection);

        		$owntribe = $this->getUserField($this->getVillageField($data['from'], "owner"), "tribe", 0);

        		$start = ($owntribe - 1) * 10 + 1;

        		$end = ($owntribe * 10);

        		//add unit

        		$j = '1';

        		for($i = $start; $i <= $end; $i++) {

        			$this->modifyEnforce($id, $i, $data['t' . $j . ''], 1);

        			$j++;

        		}

        		return mysql_insert_id($this->connection);

        	}

			

			function addHeroEnforce($data) {

				$q = "INSERT into " . TB_PREFIX . "enforcement (`vref`,`from`,`hero`) values (" . $data['to'] . "," . $data['from'] . ",1)";

        		mysql_query($q, $this->connection);

        	}

			

		

        	function modifyEnforce($id, $unit, $amt, $mode) {

				if($unit == 'hero'){

					$unit = 'hero';

				}else{

					$unit = 'u' . $unit;

				}

        		if(!$mode) {

        			$q = "UPDATE " . TB_PREFIX . "enforcement set $unit = $unit - $amt where id = $id";

        		} else {

        			$q = "UPDATE " . TB_PREFIX . "enforcement set $unit = $unit + $amt where id = $id";

        		}

        		mysql_query($q, $this->connection);

        	}



        	function getEnforceArray($id, $mode) {

        		if(!$mode) {

        			$q = "SELECT * from " . TB_PREFIX . "enforcement where id = $id";

        		} else {

        			$q = "SELECT * from " . TB_PREFIX . "enforcement where `from` = $id";

        		}

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_assoc($result);

        	}



        	function getEnforceVillage($id, $mode) {

        		if(!$mode) {

        			$q = "SELECT * from " . TB_PREFIX . "enforcement where `vref` = '$id'";

        		} else {

        			$q = "SELECT * from " . TB_PREFIX . "enforcement where `from` = '$id'";

        		}

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getVillageMovement($id) {

        		$vinfo = $this->getVillage($id);

        		$vtribe = $this->getUserField($vinfo['owner'], "tribe", 0);

        		$movingunits = array();

        		$outgoingarray = $this->getMovement(3, $id, 0);

        		if(!empty($outgoingarray)) {

        			foreach($outgoingarray as $out) {

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

        					$movingunits['u' . (($vtribe - 1) * 10 + $i)] += $out['t' . $i];

        				}

        			}

        		}

        		$returningarray = $this->getMovement(4, $id, 1);

        		if(!empty($returningarray)) {

        			foreach($returningarray as $ret) {

        				if($ret['attack_type'] != 1) {

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

        						$movingunits['u' . (($vtribe - 1) * 10 + $i)] += $ret['t' . $i];

        					}

        				}

        			}

        		}

        		$settlerarray = $this->getMovement(5, $id, 0);

        		if(!empty($settlerarray)) {

        			$movingunits['u' . ($vtribe * 10)] += 3 * count($settlerarray);

        		}

        		return $movingunits;

        	}



        	################# -START- ##################

        	##   WORLD WONDER STATISTICS FUNCTIONS!   ##

        	############################################



        	/***************************

        	Function to get all World Wonders

        	Made by: Dzoki

        	***************************/



        	function getWW() {

        		$q = "SELECT * FROM " . TB_PREFIX . "fdata WHERE f99t = 40";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return true;

        		} else {

        			return false;

        		}

        	}



        	/***************************

        	Function to get world wonder level!

        	Made by: Dzoki

        	***************************/



        	function getWWLevel($vref) {

        		$q = "SELECT f99 FROM " . TB_PREFIX . "fdata WHERE vref = $vref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['f99'];

        	}



        	/***************************

        	Function to get world wonder owner ID!

        	Made by: Dzoki

        	***************************/



        	function getWWOwnerID($vref) {

        		$q = "SELECT owner FROM " . TB_PREFIX . "vdata WHERE wref = $vref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['owner'];

        	}



        	/***************************

        	Function to get user alliance name!

        	Made by: Dzoki

        	***************************/



        	function getUserAllianceID($id) {

        		$q = "SELECT alliance FROM " . TB_PREFIX . "users where id = $id";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['alliance'];

        	}



        	/***************************

        	Function to get WW name

        	Made by: Dzoki

        	***************************/



        	function getWWName($vref) {

        		$q = "SELECT wwname FROM " . TB_PREFIX . "fdata WHERE vref = $vref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['wwname'];

        	}



        	/***************************

        	Function to change WW name

        	Made by: Dzoki

        	***************************/



        	function submitWWname($vref, $name) {

        		$q = "UPDATE " . TB_PREFIX . "fdata SET `wwname` = '$name' WHERE " . TB_PREFIX . "fdata.`vref` = $vref";

        		return mysql_query($q, $this->connection);

        	}



        	//medal functions

        	function addclimberpop($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "users set Rc = Rc + '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function addclimberrankpop($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "users set clp = clp + '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function removeclimberrankpop($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "users set clp = clp - '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function updateoldrank($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "users set oldrank = '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function removeclimberpop($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "users set Rc = Rc - '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	// ALLIANCE MEDAL FUNCTIONS

        	function addclimberpopAlly($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set Rc = Rc + '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function addclimberrankpopAlly($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set clp = clp + '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function removeclimberrankpopAlly($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set clp = clp - '$cp'' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function updateoldrankAlly($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set oldrank = '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}

        	function removeclimberpopAlly($user, $cp) {

        		$q = "UPDATE " . TB_PREFIX . "alidata set Rc = Rc - '$cp' where id = $user";

        		return mysql_query($q, $this->connection);

        	}



        	function modifyCommence($id) {

        		$time = time();

        		$q = "UPDATE " . TB_PREFIX . "training set commence = $time WHERE id=$id";



        		return mysql_query($q, $this->connection);

        	}





        	function getTrainingList() {

        		$q = "SELECT * FROM " . TB_PREFIX . "training where vref != ''";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function getNeedDelete() {

        		$time = time();

        		$q = "SELECT uid FROM " . TB_PREFIX . "deleting where timestamp < $time";

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	function countUser() {

        		$q = "SELECT count(id) FROM " . TB_PREFIX . "users where id != 0";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		return $row[0];

        	}



        	function countAlli() {

        		$q = "SELECT count(id) FROM " . TB_PREFIX . "alidata where id != 0";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		return $row[0];

        	}



        	/***************************

        	Function to process MYSQLi->fetch_all (Only exist in MYSQL)

        	References: Result

        	***************************/

        	function mysql_fetch_all($result) {

        		$all = array();

        		if($result) {

        			while($row = mysql_fetch_assoc($result)) {

        				$all[] = $row;

        			}

        			return $all;

        		}

        	}



        	function query_return($q) {

        		$result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

        	}



        	/***************************

        	Function to do free query

        	References: Query

        	***************************/

        	function query($query) {

        		return mysql_query($query, $this->connection);

        	}



        	function RemoveXSS($val) {

        		return htmlspecialchars($val, ENT_QUOTES);

        	}



        	//MARKET FIXES

        	function getWoodAvailable($wref) {

        		$q = "SELECT wood FROM " . TB_PREFIX . "vdata WHERE wref = $wref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['wood'];

        	}



        	function getClayAvailable($wref) {

        		$q = "SELECT clay FROM " . TB_PREFIX . "vdata WHERE wref = $wref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['clay'];

        	}



        	function getIronAvailable($wref) {

        		$q = "SELECT iron FROM " . TB_PREFIX . "vdata WHERE wref = $wref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['iron'];

        	}



        	function getCropAvailable($wref) {

        		$q = "SELECT crop FROM " . TB_PREFIX . "vdata WHERE wref = $wref";

        		$result = mysql_query($q, $this->connection) or die(mysql_error());

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['crop'];

        	}



        	function Getowner($vid) {

        		$s = "SELECT owner FROM " . TB_PREFIX . "vdata where wref = $vid";

        		$result1 = mysql_query($s, $this->connection);

        		$row1 = mysql_fetch_row($result1);

        		return $row1[0];

        	}



        	public function debug($time, $uid, $debug_info) {

        		$q = "INSERT INTO " . TB_PREFIX . "debug_info (time,uid,debug_info) VALUES ($time,$uid,$debug_info)";

        		if(mysql_query($q, $this->connection)) {

        			return mysql_insert_id($this->connection);

        		} else {

        			return false;

        		}

        	}

        	function poulateOasisdata() {

        		$q2 = "SELECT * FROM " . TB_PREFIX . "wdata where oasistype != 0";

        		$result2 = mysql_query($q2, $this->connection);

        		while($row = mysql_fetch_array($result2)) {

        			$wid = $row['id'];

switch($row['oasistype']) {

case 1:

$tt =  "1000,1000,1000,1000,1000,1000";

break;

case 2:

$tt =  "2000,1000,1000,2000,1000,2000";

break;

case 3:

$tt =  "2000,1000,1000,2000,2000,2000";

break;

case 4:

$tt =  "1000,1000,1000,1000,1000,1000";

break;

case 5:

$tt =  "1000,2000,1000,2000,1000,2000";

break;

case 6:

$tt =  "1000,2000,1000,2000,1000,2000";

break;

case 7:

$tt =  "1000,1000,1000,1000,1000,1000";

break;

case 8:

$tt =  "1000,1000,2000,2000,1000,2000";

break;

case 9:

$tt =  "1000,1000,2000,2000,2000,2000";

break;

case 10:

$tt =  "1000,1000,1000,1000,1000,1000";

break;

case 11:

$tt =  "1000,1000,1000,2000,2000,2000";

break;

case 12:

$tt =  "1000,1000,1000,2000,2000,2000";

break;

}

        			$basearray = $this->getOMInfo($wid);				

        			//We switch type of oasis and instert record with apropriate infomation.

        			$q = "INSERT into " . TB_PREFIX . "odata VALUES ('" . $basearray['id'] . "'," . $basearray['oasistype'] . ",0,".$tt."," . time() . ",100,3,'????? ????? ????')";

        			$result = mysql_query($q, $this->connection);

        		}

        	}



        	public function getAvailableExpansionTraining() {

        		global $building, $session, $technology, $village;

        		$q = "SELECT (IF(exp1=0,1,0)+IF(exp2=0,1,0)+IF(exp3=0,1,0)) FROM " . TB_PREFIX . "vdata WHERE wref = $village->wid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		$maxslots = $row[0];

        		$residence = $building->getTypeLevel(25);

        		$palace = $building->getTypeLevel(26);

        		if($residence > 0) {

        			$maxslots -= (3 - floor($residence / 10));

        		}

        		if($palace > 0) {

        			$maxslots -= (3 - floor(($palace - 5) / 5));

        		}



        		$q = "SELECT (u10+u20+u30) FROM " . TB_PREFIX . "units WHERE vref = $village->wid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		$settlers = $row[0];

        		$q = "SELECT (u9+u19+u29) FROM " . TB_PREFIX . "units WHERE vref = $village->wid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		$chiefs = $row[0];



        		$settlers += 3 * count($this->getMovement(5, $village->wid, 0));

        		$current_movement = $this->getMovement(3, $village->wid, 0);

        		if(!empty($current_movement)) {

        			foreach($current_movement as $build) {

        				$settlers += $build['t10'];

        				$chiefs += $build['t9'];

        			}

        		}

        		$current_movement = $this->getMovement(3, $village->wid, 1);

        		if(!empty($current_movement)) {

        			foreach($current_movement as $build) {

        				$settlers += $build['t10'];

        				$chiefs += $build['t9'];

        			}

        		}

        		$current_movement = $this->getMovement(4, $village->wid, 0);

        		if(!empty($current_movement)) {

        			foreach($current_movement as $build) {

        				$settlers += $build['t10'];

        				$chiefs += $build['t9'];

        			}

        		}

        		$current_movement = $this->getMovement(4, $village->wid, 1);

        		if(!empty($current_movement)) {

        			foreach($current_movement as $build) {

        				$settlers += $build['t10'];

        				$chiefs += $build['t9'];

        			}

        		}

        		$q = "SELECT (u10+u20+u30) FROM " . TB_PREFIX . "enforcement WHERE `from` = $village->wid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		if(!empty($row)) {

        			foreach($row as $reinf) {

        				$settlers += $reinf[0];

        			}

        		}

        		$q = "SELECT (u9+u19+u29) FROM " . TB_PREFIX . "enforcement WHERE `from` = $village->wid";

        		$result = mysql_query($q, $this->connection);

        		$row = mysql_fetch_row($result);

        		if(!empty($row)) {

        			foreach($row as $reinf) {

        				$chiefs += $reinf[0];

        			}

        		}

        		$trainlist = $technology->getTrainingList(4);

        		if(!empty($trainlist)) {

        			foreach($trainlist as $train) {

        				if($train['unit'] % 10 == 0) {

        					$settlers += $train['amt'];

        				}

        				if($train['unit'] % 10 == 9) {

        					$chiefs += $train['amt'];

        				}

        			}

        		}

        		// trapped settlers/chiefs calculation required



        		$settlerslots = $maxslots * 3 - $settlers - $chiefs * 3;

        		$chiefslots = $maxslots - $chiefs - floor(($settlers + 2) / 3);



        		if(!$technology->getTech(($session->tribe - 1) * 10 + 9)) {

        			$chiefslots = 0;

        		}

        		$slots = array("chiefs" => $chiefslots, "settlers" => $settlerslots);

        		return $slots;

        	}



        	function addArtefact($vref, $owner, $type, $size, $name, $desc, $effect, $img) {

        		$q = "INSERT INTO `" . TB_PREFIX . "artefacts` (`vref`, `owner`, `type`, `size`, `conquered`, `name`, `desc`, `effect`, `img`) VALUES ('$vref', '$owner', '$type', '$size', '" . time() . "', '$name', '$desc', '$effect', '$img')";

        		return mysql_query($q, $this->connection);

        	}



        	function getOwnArtefactInfo($vref) {

        		$q = "SELECT * FROM " . TB_PREFIX . "artefacts WHERE vref = $vref";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

        	function getOwnArtefactInfoByType($vref, $type) {

        		$q = "SELECT * FROM " . TB_PREFIX . "artefacts WHERE vref = $vref AND type = $type";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

        	function getOwnUniqueArtefactInfo($id, $type, $size) {

        		$q = "SELECT * FROM " . TB_PREFIX . "artefacts WHERE owner = $id AND type = $type AND size=$size";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}



        	function getArtefactInfo() {

        		$q = "SELECT * FROM " . TB_PREFIX . "artefacts WHERE id > 0";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

        	function claimArtefact($vref, $ovref, $id) {

        		$time = time();

        		$q = "UPDATE " . TB_PREFIX . "artefacts SET vref = $vref, owner = $id WHERE vref = $ovref";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}



        	function getArtefactDetails($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "artefacts WHERE id = " . $id . "";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function HeroFace($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "heroface WHERE uid = ".$uid."";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function addHeroFace($uid, $bread, $ear, $eye, $eyebrow, $face, $hair, $mouth, $nose, $color) {

				

				$q = "INSERT INTO `" . TB_PREFIX . "heroface` (`beard`, `ear`, `eye`, `eyebrow`, `face`, `hair`, `mouth`, `nose`, `color`, `foot`, `helmet`, `horse`, `leftHand`, `rightHand`) VALUES ('$bread', '$ear', '$eye', '$eyebrow', '$face', '$hair', '$mouth', '$nose', '$color', '0', '0', '0', 'leftHand', 'rightHand')";

        		return mysql_query($q, $this->connection);

        	}

			

			function modifyHeroFace($uid,$column,$value) {

                $q = "UPDATE ".TB_PREFIX."heroface SET $column = $value WHERE uid = $uid";

                return mysql_query($q, $this->connection);

            }

			

			function modifyHeroXp($column,$value,$uid) {

                $q = "UPDATE ".TB_PREFIX."hero SET $column = $column + $value WHERE uid = $uid";

                return mysql_query($q, $this->connection);

            }

			

			function populateOasisUnitsLow() {

        		$q2 = "SELECT * FROM " . TB_PREFIX . "wdata where oasistype != 0";

        		$result2 = mysql_query($q2, $this->connection);

        		while($row = mysql_fetch_array($result2)) {

        			$wid = $row['id'];

        			$basearray = $this->getMInfo($wid);

        			//each Troop is a Set for oasis type like mountains have rats spiders and snakes fields tigers elphants clay wolves so on stonger one more not so less

        			switch($basearray['oasistype']) {

        				case 1:

        				case 2:

							// Oasis Random populate

							$UP35 = rand(5, 30);

							$UP36 = rand(5, 30);

							$UP37 = rand(0, 30);

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u35 = u35 +  '" . $UP35 . "', u36 = u36 + '" . $UP36 . "', u37 = u37 + '" . $UP37 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 3:

							// Oasis Random populate

							$UP35 = rand(5, 30);

							$UP36 = rand(5, 30);

							$UP37 = rand(1, 30);

							$UP39 = rand(0, 10);

							$fil = rand(0,20);

							if($fil == 1){

								$UP40 = rand(0, 31);

							}else{

								$UP40 = 0;

							}

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u35 = u35 +  '" . $UP35 . "', u36 = u36 + '" . $UP36 . "', u37 = u37 + '" . $UP37 . "', u39 = u39 + '" . $UP39 . "', u40 = u40 + '" . $UP40 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 4:

        				case 5:

							// Oasis Random populate

							$UP31 = rand(5, 40);

							$UP32 = rand(5, 30);

							$UP35 = rand(0, 25);

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u31 = u31 +  '" . $UP31 . "', u32 = u32 + '" . $UP32 . "', u35 = u35 + '" . $UP35 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 6:

							// Oasis Random populate

							$UP31 = rand(5, 40);

							$UP32 = rand(5, 30);

							$UP35 = rand(1, 25);

							$UP38 = rand(0, 15);

							$fil = rand(0,20);

							if($fil == 1){

								$UP40 = rand(0, 31);

							}else{

								$UP40 = 0;

							}

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u31 = u31 +  '" . $UP31 . "', u32 = u32 + '" . $UP32 . "', u35 = u35 + '" . $UP35 . "', u38 = u38 + '" . $UP38 . "', u40 = u40 + '" . $UP40 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 7:

        				case 8:

							// Oasis Random populate

							$UP31 = rand(5, 40);

							$UP32 = rand(5, 30);

							$UP34 = rand(0, 25);

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u31 = u31 +  '" . $UP31 . "', u32 = u32 + '" . $UP32 . "', u34 = u34 + '" . $UP34 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 9:

							// Oasis Random populate

							$UP31 = rand(5, 40);

							$UP32 = rand(5, 30);

							$UP34 = rand(1, 25);

							$UP37 = rand(0, 15);

							$fil = rand(0,20);

							if($fil == 1){

								$UP40 = rand(0, 31);

							}else{

								$UP40 = 0;

							}

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u31 = u31 +  '" . $UP31 . "', u32 = u32 + '" . $UP32 . "', u34 = u34 + '" . $UP34 . "', u37 = u37 + '" . $UP37 . "', u40 = u40 + '" . $UP40 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 10:

        				case 11:

							// Oasis Random populate

							$UP31 = rand(5, 40);

							$UP33 = rand(5, 30);

							$UP37 = rand(1, 25);

							$UP39 = rand(0, 25);

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u31 = u31 +  '" . $UP31 . "', u33 = u33 + '" . $UP33 . "', u37 = u37 + '" . $UP37 . "', u39 = u39 + '" . $UP39 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        				case 12:

							// Oasis Random populate

							$UP31 = rand(5, 40);

							$UP33 = rand(5, 30);

							$UP38 = rand(1, 25);

							$UP39 = rand(0, 25);

							$fil = rand(0,20);

							if($fil == 1){

								$UP40 = rand(0, 31);

							}else{

								$UP40 = 0;

							}

							//+25% lumber per hour

        					$q = "UPDATE " . TB_PREFIX . "units SET u31 = u31 +  '" . $UP31 . "', u33 = u33 + '" . $UP33 . "', u38 = u38 + '" . $UP38 . "', u39 = u39 + '" . $UP39 . "', u40 = u40 + '" . $UP40 . "' WHERE vref = '" . $wid . "'";

        					$result = mysql_query($q, $this->connection);

        					break;

        			}

        		}

        	}

			

			public function hasBeginnerProtection($vid) {

				$q = "SELECT u.protect FROM ".TB_PREFIX."users u,".TB_PREFIX."vdata v WHERE u.id=v.owner AND v.wref=".$vid;

				$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

				if(!empty($dbarray)) {

					if(time()<$dbarray[0]) {

						return true;

					} else {

						return false;

					}

				} else {

					return false;

				}

			}

			

			function addCLP($uid, $clp) {

        		$q = "UPDATE " . TB_PREFIX . "users set clp = clp + $clp where id = $uid";

        		return mysql_query($q, $this->connection);

        	}

			

			function sendwlcMessage($client, $owner, $topic, $message, $send) {

        		$time = time();

        		$q = "INSERT INTO " . TB_PREFIX . "mdata values (0,$client,$owner,'$topic',\"$message\",1,0,$send,$time)";

        		return mysql_query($q, $this->connection);

        	}

			

			function getLinks($id){

                $q = 'SELECT * FROM ' . TB_PREFIX . 'links WHERE `userid` = ' . $id . ' ORDER BY `pos` ASC';

                $result = mysql_query($q, $this->connection);

        		return $this->mysql_fetch_all($result);

            }

			

			function getFarmlist($uid){

                $q = 'SELECT * FROM ' . TB_PREFIX . 'farmlist WHERE owner = ' . $uid . ' ORDER BY name ASC';

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

				

				if($dbarray['id']!=0) {

						return true;

					} else {

						return false;

					}

                            

            }

			

			function getRaidList($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "raidlist WHERE id = ".$id."";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getAllAuction() {

        		$q = "SELECT * FROM " . TB_PREFIX . "auction WHERE finish = 0";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getVilFarmlist($wref){

                $q = 'SELECT * FROM ' . TB_PREFIX . 'farmlist WHERE wref = ' . $wref . ' ORDER BY wref ASC';

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

				

				if($dbarray['id']!=0) {

						return true;

					} else {

						return false;

					}

                            

            }

			

			function delFarmList($id, $owner) {

        		$q = "DELETE FROM " . TB_PREFIX . "farmlist where id = $id and owner = $owner";

        		return mysql_query($q, $this->connection);

        	}

			

			

			function delSlotFarm($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "raidlist where id = $id";

        		return mysql_query($q, $this->connection);

        	}

			

			

			function createFarmList($wref, $owner, $name) {

        		$q = "INSERT INTO " . TB_PREFIX . "farmlist (`wref`, `owner`, `name`) VALUES ('$wref', '$owner', '$name')";

        		return mysql_query($q, $this->connection);

        	}

			

			function addSlotFarm($lid, $towref, $x, $y, $distance, $t1, $t2, $t3, $t4, $t5, $t6, $t7, $t8, $t9, $t10) {

        		$q = "INSERT INTO " . TB_PREFIX . "raidlist (`lid`, `towref`, `x`, `y`, `distance`, `t1`, `t2`, `t3`, `t4`, `t5`, `t6`, `t7`, `t8`, `t9`, `t10`) VALUES ('$lid', '$towref', '$x', '$y', '$distance', '$t1', '$t2', '$t3', '$t4', '$t5', '$t6', '$t7', '$t8', '$t9', '$t10')";

        		return mysql_query($q, $this->connection);

        	}

			

			function editSlotFarm($eid, $lid, $wref, $x, $y, $dist, $t1, $t2, $t3, $t4, $t5, $t6, $t7, $t8, $t9, $t10) {

				

				$q = "UPDATE " . TB_PREFIX . "raidlist set lid = '$lid', towref = '$wref', x = '$x', y = '$y', t1 = '$t1', t2 = '$t2', t3 = '$t3', t4 = '$t4', t5 = '$t5', t6 = '$t6', t7 = '$t7', t8 = '$t8', t9 = '$t9', t10 = '$t10' WHERE id = $eid";

        		return mysql_query($q, $this->connection);



        	}

			

			function getBerichte($uid) {

        		$q = "SELECT id FROM " . TB_PREFIX . "ndata where uid = $uid";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['id'];

        	}

			

			function removeOases($wref) {

                $q = "UPDATE ".TB_PREFIX."odata SET conqured = 0, owner = 3, name = '????? ????? ????' WHERE wref = $wref";

                return mysql_query($q, $this->connection);

            }

			

			function getArrayMemberVillage($uid){

			$q = 'SELECT a.wref, a.name, b.x, b.y from '.TB_PREFIX.'vdata AS a left join '.TB_PREFIX.'wdata AS b ON b.id = a.wref where owner = '.$uid.' order by capital DESC,pop DESC';

			$result = mysql_query($q, $this->connection);

			$array = $this->mysql_fetch_all($result);

			return $array;

			}

			

			function getNoticeData($nid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "ndata where id = $nid";

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['data'];

        	}

			

			function setSilver($uid, $silver, $mode) {

				if(!$mode){

        			$q = "UPDATE " . TB_PREFIX . "users set silver = silver - $silver where id = $uid";

				}else{

					$q = "UPDATE " . TB_PREFIX . "users set silver = silver + $silver where id = $uid";

				}

        		return mysql_query($q, $this->connection);

        	}

			

			function getAuctionSilver($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "auction where uid = $uid and finish = 0";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getAuctionData($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "auction where id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function delAuction($id) {

				$aucData = $this->getAuctionData($id);

				$btype = $aucData['btype'];

				if($btype>=7 || $btype!=12 || $btype!=13){

					$this->editHeroNum($aucData['itemid'], $aucData['num'], 1);

					$this->editProcItem($aucData['itemid'], 0);

					$q = "DELETE FROM " . TB_PREFIX . "auction where id = $id and finish = 0";

				}else{

					$this->editProcItem($aucData['itemid'], 0);

        			$q = "DELETE FROM " . TB_PREFIX . "auction where id = $id and finish = 0";

				}

        		return mysql_query($q, $this->connection);

        	}

			

			function getAuctionUser($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "auction where owner = $uid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

						

			function addAuction($owner, $itemid, $btype, $type, $amount) {

				$time = time()+AUCTIONTIME;

				if($btype==7 || $btype==8 || $btype==9 || $btype==10 || $btype==11 || $btype==13 || $btype==14){

					$silver = $amount;

					

					$itemData = $this->getItemData($itemid);

					if($amount == $itemData['num']){

						$q = "INSERT INTO " . TB_PREFIX . "auction (`owner`, `itemid`, `btype`, `type`, `num`, `uid`, `bids`, `silver`, `time`, `finish`) VALUES ('$owner', '$itemid', '$btype', '$type', '$amount', 0, 0, '$silver', '$time', 0)";

						$this->editProcItem($itemid, 1);

					}else{

						$this->editHeroNum($itemid, $amount, 0);

						$q = "INSERT INTO " . TB_PREFIX . "auction (`owner`, `itemid`, `btype`, `type`, `num`, `uid`, `bids`, `silver`, `time`, `finish`) VALUES ('$owner', '$itemid', '$btype', '$type', '$amount', 0, 0, '$silver', '$time', 0)";

						$this->editProcItem($itemid, 0);

					}

				}else{

					$silver = 100;

					$q = "INSERT INTO " . TB_PREFIX . "auction (`owner`, `itemid`, `btype`, `type`, `num`, `uid`, `bids`, `silver`, `time`, `finish`) VALUES ('$owner', '$itemid', '$btype', '$type', '$amount', 0, 0, '$silver', '$time', 0)";

					$this->editProcItem($itemid, 1);

				}

					

        		return mysql_query($q, $this->connection);

        	}

						

			function addBid($id, $uid, $silver) {

        		$q = "UPDATE " . TB_PREFIX . "auction set uid = $uid, silver = $silver, bids = bids + 1 where id = $id";

        		return mysql_query($q, $this->connection);

        	}

			

			function removeBidNotice($id) {

        		$q = "DELETE FROM " . TB_PREFIX . "auction where id = $id";

        		return mysql_query($q, $this->connection);

        	}

			

			function addHeroItem($uid, $btype, $type, $num) {

        		$q = "INSERT INTO " . TB_PREFIX . "heroitems (`uid`, `btype`, `type`, `num`, `proc`) VALUES ('$uid', '$btype', '$type', '$num', 0)";

        		return mysql_query($q, $this->connection);

        	}

			

			function checkHeroItem($uid, $btype){

                $q = "SELECT * FROM ".TB_PREFIX."heroitems WHERE uid = '$uid' and btype = '$btype' and proc = 0";

				$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);					

				if($dbarray['btype']==$btype) {

					return $dbarray['id'];

				} else {

					return false;

				}

            }

			

			function checkAttack($wref, $toWref){

                $q = "SELECT * FROM ".TB_PREFIX."movement WHERE `from` = '$wref' AND `to` = '$toWref' AND `proc` = '0' AND `sort_type` = '3'";

				$result = mysql_query($q, $this->connection);

				if(mysql_num_rows($result)) {

					return mysql_fetch_array($result);

				} else {

					return false;

				}

            }

			

			function getHeroItemID($uid, $btype) {

        		$q = "SELECT * FROM " . TB_PREFIX . "heroitems where uid = ".$uid." AND btype = ".$btype."";

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['id'];

        	}

			

			function getHeroItemID2($uid, $btype, $type) {

        		$q = "SELECT * FROM " . TB_PREFIX . "heroitems where uid = ".$uid." AND btype = ".$btype." AND type = ".$type."";

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['id'];

        	}

			

			function getItemData($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "heroitems WHERE id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function editHeroNum($id, $num, $mode) {

				if($mode==0){

        			$q = "UPDATE " . TB_PREFIX . "heroitems set num = num - $num where id = $id and proc = 0";

				}elseif($mode==1){

					$q = "UPDATE " . TB_PREFIX . "heroitems set num = num + $num where id = $id and proc = 0";

				}else{

					$q = "UPDATE " . TB_PREFIX . "heroitems set num = $num where id = $id and proc = 0";

				}

        		return mysql_query($q, $this->connection);

        	}

			

			function editProcItem($id, $mode) {

				if($mode==0){

        			$q = "UPDATE " . TB_PREFIX . "heroitems set proc = 0 where id = $id";

				}else{

					$q = "UPDATE " . TB_PREFIX . "heroitems set proc = 1 where id = $id";

				}

        		return mysql_query($q, $this->connection);

        	}

						

			function editBid($id, $silver) {

        		$q = "UPDATE " . TB_PREFIX . "auction set silver = $silver where id = $id";

        		return mysql_query($q, $this->connection);

        	}

			

			function checkBid($id, $silver){

                $q = "SELECT * FROM " . TB_PREFIX . "auction WHERE id = '$id'";

				$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

				

				if($dbarray['silver']>=$silver) {

						return false;

					} else {

						return true;

					}

            }

			

			function getBidData($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "auction WHERE id = $id";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function setHeroInventory($uid, $field, $value) {

        		$q = "UPDATE " . TB_PREFIX . "heroinventory set $field = '$value' where uid = $uid";

        		return mysql_query($q, $this->connection);

        	}

			

			function getHeroInventory($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "heroinventory WHERE uid = $uid";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getHeroData($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "hero WHERE uid = $uid";

        		$result = mysql_query($q, $this->connection);

				return mysql_fetch_array($result);

        	}

			

			function getFLData($id) {

        		$q = "SELECT * FROM " . TB_PREFIX . "farmlist where id = $id";

        		$result = mysql_query($q, $this->connection);

				return mysql_fetch_array($result);

        	}

			

			function getHeroField($uid, $field) {

        		$q = "SELECT ".$field." FROM " . TB_PREFIX . "hero WHERE uid = $uid";

        		$result = mysql_query($q, $this->connection);

				$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}

			

			function getVFH($uid) {

        		$q = "SELECT wref FROM " . TB_PREFIX . "vdata WHERE owner = $uid and capital = 1";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray['wref'];

        	}

			

			function getNotice2($id, $field) {

        		$q = "SELECT ".$field." FROM " . TB_PREFIX . "ndata where `id` = '$id'";

        		$result = mysql_query($q, $this->connection);

        		$dbarray = mysql_fetch_array($result);

        		return $dbarray[$field];

        	}

			

			function addAdventure($wref, $uid){

				$time = time()+(3600*120);

				$ddd = rand(0,3);

				if($ddd == 1){ $dif = 1; }else{ $dif = 0; }

				$sql = mysql_query("SELECT * FROM ".TB_PREFIX."wdata ORDER BY id DESC LIMIT 1");

				$query = mysql_fetch_array($sql, $this->connection);

				$lastw = 641601;

				if(($wref-10000)<=10){

					$w1 = rand(10,($wref+10000));

				}

				elseif(($wref+10000) >= $lastw){

					$w1 = rand(($wref-10000),($lastw-1000));

				}

				else{

					$w1 = rand(($wref-10000),($wref+10000));

				}

				

				$q = "INSERT into " . TB_PREFIX . "adventure (`wref`, `uid`, `dif`, `time`, `end`) values ('$w1', '$uid', '$dif', '$time', 0)";

        		return mysql_query($q, $this->connection) or die(mysql_error());

			}

			

			function addHero($uid){

				$time = time();

				$hash = md5($time);

				

				$q = "INSERT into " . TB_PREFIX . "hero (`uid`, `wref`, `level`, `speed`, `points`, `experience`, `dead`, `health`, `power`, `offBonus`, `defBonus`, `product`, `r0`, `autoregen`, `lastupdate`, `lastadv`, `hash`) values 

        ('$uid', 0, 0, '10', 0, '2', 0, '100', '100', 0, 0, '120', '30', '10', '$time', '$time', '$hash')";

        		return mysql_query($q, $this->connection) or die(mysql_error());

			}

			

			// Add new password => mode:0

			// Add new email => mode: 1

			function addNewProc($uid, $npw, $nemail, $act, $mode) {

        		$time = time();

        		if(!$mode){

					$q = "INSERT into " . TB_PREFIX . "newproc (uid, npw, act, time, proc) values ('$uid', '$npw', '$act', '$time', 0)";

				}else{

					$q = "INSERT into " . TB_PREFIX . "newproc (uid, nemail, act, time, proc) values ('$uid', '$nemail', '$act', '$time', 0)";

				}

        		

        		return mysql_query($q, $this->connection) or die(mysql_error());

        	}

			

			function checkProcExist($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "newproc where uid = '$uid' and proc = 0";

        		$result = mysql_query($q, $this->connection);

        		if(mysql_num_rows($result)) {

        			return false;

        		} else {

        			return true;

        		}

        	}

			

			function removeProc($uid) {

        		$q = "DELETE FROM " . TB_PREFIX . "newproc where uid = $uid";

        		return mysql_query($q, $this->connection);

        	}

			

			function checkBan($uid){

				$q = "SELECT * FROM " . TB_PREFIX . "banlist WHERE uid = $uid";

				$result = mysql_query($q, $this->connection);

				if(mysql_num_rows($result)) {

					return true;

				}else{

					return false;

				}

			}

						

			function getNewProc($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "newproc WHERE uid = $uid";

        		$result = mysql_query($q, $this->connection);

				if(mysql_num_rows($result)) {

        			return mysql_fetch_array($result);

        		} else {

        			return false;

        		}

        	}

			

			function getAdventure($uid, $wref) {

        		$q = "SELECT * FROM " . TB_PREFIX . "adventure WHERE uid = $uid and wref = '".$wref."'";

        		$result = mysql_query($q, $this->connection);

				if(mysql_num_rows($result)) {

        			return mysql_fetch_array($result);

        		} else {

        			return false;

        		}

        	}

			

			function editTableField($table, $field, $value, $refField, $ref) {

        		$q = "UPDATE " . TB_PREFIX . "".$table." set $field = '$value' where ".$refField." = '$ref'";

        		return mysql_query($q, $this->connection);

        	}

			

			function HeroItemsNum($uid) {

        		$q = "SELECT * FROM " . TB_PREFIX . "heroitems where uid = '$uid'";

        		$result = mysql_query($q, $this->connection);

        		return mysql_num_rows($result);

        	}

			

			function addHeroinventory($uid){				

				$q = "INSERT into " . TB_PREFIX . "heroinventory (`uid`) values ('$uid')";

        		return mysql_query($q, $this->connection) or die(mysql_error());

			}

			

			function config() {

        		$q = "SELECT * FROM " . TB_PREFIX . "config";

        		$result = mysql_query($q, $this->connection);

        		return mysql_fetch_array($result);

        	}

			

			function getAllianceDipProfile($aid, $type){

				$q = "SELECT * FROM ".TB_PREFIX."diplomacy WHERE alli1 = '$aid' AND type = '$type' AND accepted = '1'";

				$result = mysql_query($q, $this->connection);

				if(mysql_num_rows($result) == 0){

					$q2 = "SELECT * FROM ".TB_PREFIX."diplomacy WHERE alli2 = '$aid' AND type = '$type' AND accepted = '1'";

					$result2 = mysql_query($q2, $this->connection);

					while($row = mysql_fetch_array($result2)){

						$alliance = $this->getAlliance($row['alli1']);

						$text = "";

						$text .= "<a href=allianz.php?aid=".$alliance['id'].">".$alliance['tag']."</a><br> ";

					}

				}else{

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

						$alliance = $this->getAlliance($row['alli2']);

						$text = "";

						$text .= "<a href=allianz.php?aid=".$alliance['id'].">".$alliance['tag']."</a><br> ";

					}

				}

				if(strlen($text) == 0){

					$text = "-<br>";

				}

				return $text;

			}

			

			public function canClaimArtifact ($vref,$type) { 

				$DefenderFields = $this->getResourceLevel($vref); 

                for($i=19;$i<=38;$i++) { 

                    if($AttackerFields['f'.$i.'t'] == 27) {  

                        $defcanclaim = FALSE; 

                        $defTresuaryLevel = $AttackerFields['f'.$i];  

                    } else { 

                        $defcanclaim = TRUE;   

                    } 

                }  

                $AttackerFields = $this->getResourceLevel($vref); 

                for($i=19;$i<=38;$i++) { 

                	if($AttackerFields['f'.$i.'t'] == 27) { 

                		$attTresuaryLevel = $AttackerFields['f'.$i];  

                		if ($attTresuaryLevel >= 10){ 

                			$villageartifact = TRUE; 

                		}else{ 

                			$villageartifact = FALSE; 

                		} 

                		if ($attTresuaryLevel == 20){ 

                			$accountartifact = TRUE; 

                		}else{ 

                			$accountartifact = FALSE; 

                		} 

                	} 

                }

                if ($type == 1) { 

					if ($defcanclaim == TRUE && $villageartifact == TRUE){ 

						return TRUE; 

					}

                }else if($type == 2) { 

                	if ($defcanclaim == TRUE && $accountartifact == TRUE){ 

                		return TRUE; 

                	}    

                }else if($type == 3) { 

                	if ($defcanclaim == TRUE && $accountartifact == TRUE){ 

                		return TRUE; 

                	}    

                }else { return FALSE; }  

            }  

			

			function imagecopymerge_alpha($dst_im, $src_im, $dst_x, $dst_y, $src_x, $src_y, $src_w, $src_h, $pct){ 

				if(!isset($pct)){ 

					return false; 

				} 

				$pct /= 100; 

				// Get image width and height 

				$w = imagesx( $src_im ); 

				$h = imagesy( $src_im ); 

				// Turn alpha blending off 

				imagealphablending( $src_im, false ); 

				// Find the most opaque pixel in the image (the one with the smallest alpha value) 

				$minalpha = 127; 

				for( $x = 0; $x < $w; $x++ ) 

				for( $y = 0; $y < $h; $y++ ){ 

					$alpha = ( imagecolorat( $src_im, $x, $y ) >> 24 ) & 0xFF; 

					if( $alpha < $minalpha ){ 

						$minalpha = $alpha; 

					} 

				} 

				//loop through image pixels and modify alpha for each 

				for( $x = 0; $x < $w; $x++ ){ 

					for( $y = 0; $y < $h; $y++ ){ 

						//get current alpha value (represents the TANSPARENCY!) 

						$colorxy = imagecolorat( $src_im, $x, $y ); 

						$alpha = ( $colorxy >> 24 ) & 0xFF; 

						//calculate new alpha 

						if( $minalpha !== 127 ){ 

							$alpha = 127 + 127 * $pct * ( $alpha - 127 ) / ( 127 - $minalpha ); 

						} else { 

							$alpha += 127 * $pct; 

						} 

						//get the color index with new alpha 

						$alphacolorxy = imagecolorallocatealpha( $src_im, ( $colorxy >> 16 ) & 0xFF, ( $colorxy >> 8 ) & 0xFF, $colorxy & 0xFF, $alpha ); 

						//set pixel with the new color + opacity 

						if( !imagesetpixel( $src_im, $x, $y, $alphacolorxy ) ){ 

							return false; 

						} 

					} 

				} 

				// The image copy 

				imagecopy($dst_im, $src_im, $dst_x, $dst_y, $src_x, $src_y, $src_w, $src_h); 

			} 

        }

        ;



        $database = new MYSQL_DB;



?>