PageRenderTime 59ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

/GameEngine/Admin/database.php

https://github.com/DEVVELO/TravianZ-By-Shadowss
PHP | 858 lines | 747 code | 76 blank | 35 comment | 180 complexity | 6aa0844b14cd4118b8af39cd6d56ed29 MD5 | raw file
    

  1. <?php
    2. 

  2. #################################################################################
    3. 

  3. ##                                                                             ##
    4. 

  4. ##              -= YOU MUST NOT REMOVE OR CHANGE THIS NOTICE =-                ##
    5. 

  5. ##                                                                             ##
    6. 

  6. ## --------------------------------------------------------------------------- ##
    7. 

  7. ##                                                                             ##
    8. 

  8. ##  Project:       TravianZ                                                    ##
    9. 

  9. ##  Version:       05.03.2014                                                  ##
    10. 

  10. ##  Filename:      GameEngine/Admin/database.php                               ##
    11. 

  11. ##  Developed by:  Dzoki                                                       ##
    12. 

  12. ##  Edited by:     Shadow and ronix                                            ##
    13. 

  13. ##  License:       Creative Commons BY-NC-SA 3.0                               ##
    14. 

  14. ##  Copyright:     TravianZ (c) 2014 - All rights reserved                     ##
    15. 

  15. ##  URLs:          http://travian.shadowss/ro                                  ##
    16. 

  16. ##  Source code:   https://github.com/Shadowss/TravianZ	                       ##
    17. 

  17. ##                                                                             ##
    18. 

  18. #################################################################################
    19. 

  19. if(isset($gameinstall) && $gameinstall == 1){
    20. 

  20. include_once("../../GameEngine/config.php");
    21. 

  21. include_once("../../GameEngine/Data/buidata.php");
    22. 

  22. }else{
    23. 

  23. include_once("../GameEngine/Data/unitdata.php");
    24. 

  24. include_once("../GameEngine/Technology.php");
    25. 

  25. include_once("../GameEngine/Data/buidata.php");
    26. 

  26. }
    27. 

  27. class adm_DB {
    28. 

  28. 	var $connection;
    29. 

  29. 

  30.   function adm_DB(){
    31. 

  31. 	global $database;
    32. 

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

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

  34. 	}
    35. 

  35. 

  36. 	function Login($username,$password){
    37. 

  37. 		$q = "SELECT password FROM ".TB_PREFIX."users where username = '$username' and access >= ".MULTIHUNTER;
    38. 

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

  39. 		$dbarray = mysql_fetch_array($result);
    40. 

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

  41. 			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,'X','$username logged in (IP: <b>".$_SERVER['REMOTE_ADDR']."</b>)',".time().")");
    42. 

  42. 			return true;
    43. 

  43. 		}
    44. 

  44. 		else {
    45. 

  45. 			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,'X','<font color=\'red\'><b>IP: ".$_SERVER['REMOTE_ADDR']." tried to log in with username <u> $username</u> but access was denied!</font></b>',".time().")");
    46. 

  46. 			return false;
    47. 

  47. 		}
    48. 

  48. 	}
    49. 

  49. 

  50. 	function recountPopUser($uid){
    51. 

  51. 	 global $database;
    52. 

  52. 	 $villages = $database->getProfileVillages($uid);
    53. 

  53. 	for ($i = 0; $i <= count($villages)-1; $i++) {
    54. 

  54. 	  $vid = $villages[$i]['wref'];
    55. 

  55. 	  $this->recountPop($vid);
    56. 

  56. 	  $this->recountCP($vid);
    57. 

  57. 	}
    58. 

  58.   }
    59. 

  59. 

  60.     function recountPop($vid){
    61. 

  61.     global $database;
    62. 

  62.     $fdata = $database->getResourceLevel($vid);
    63. 

  63.     $popTot = 0;
    64. 

  64.     for ($i = 1; $i <= 40; $i++) {
    65. 

  65.         $lvl = $fdata["f".$i];
    66. 

  66.         $building = $fdata["f".$i."t"];
    67. 

  67.         if($building>0 && $lvl>0){
    68. 

  68.             $popTot += $this->buildingPOP($building,$lvl);
    69. 

  69.         }
    70. 

  70.     }
    71. 

  71. 

  72.     $q = "UPDATE ".TB_PREFIX."vdata set pop = $popTot where wref = $vid";
    73. 

  73.     mysql_query($q, $this->connection);
    74. 

  74.   }
    75. 

  75.   
    76. 

  76.     function recountCP($vid){
    77. 

  77.     global $database;
    78. 

  78.     $fdata = $database->getResourceLevel($vid);
    79. 

  79.     $popTot = 0;
    80. 

  80.     for ($i = 1; $i <= 40; $i++) {
    81. 

  81.         $lvl = $fdata["f".$i];
    82. 

  82.         $building = $fdata["f".$i."t"];
    83. 

  83.         if($building>0 && $lvl>0){
    84. 

  84.             $popTot += $this->buildingCP($building,$lvl);
    85. 

  85.         }
    86. 

  86.     }
    87. 

  87.     $q = "UPDATE ".TB_PREFIX."vdata set cp = $popTot where wref = $vid";
    88. 

  88.     mysql_query($q, $this->connection);
    89. 

  89.     }
    90. 

  90. 

  91.   function buildingPOP($f,$lvl){
    92. 

  92.     $name = "bid".$f;
    93. 

  93.     global $$name;
    94. 

  94.     $popT = 0;
    95. 

  95.     $dataarray = $$name;
    96. 

  96. 

  97.     for ($i = 1; $i <= $lvl; $i++) {
    98. 

  98.         $popT += $dataarray[$i]['pop'];
    99. 

  99.     }
    100. 

  100.     return $popT;
    101. 

  101.   }
    102. 

  102.   
    103. 

  103.     function buildingCP($f,$lvl){
    104. 

  104.         $name = "bid".$f;
    105. 

  105.         global $$name;
    106. 

  106.         $popT = 0;
    107. 

  107.         $dataarray = $$name;
    108. 

  108.         
    109. 

  109.         for ($i = 1; $i <= $lvl; $i++) {
    110. 

  110.             $popT += $dataarray[$i]['cp'];
    111. 

  111.         }
    112. 

  112.         return $popT;
    113. 

  113.     } 
    114. 

  114. 

  115. 	function getWref($x,$y) {
    116. 

  116. 		$q = "SELECT id FROM ".TB_PREFIX."wdata where x = $x and y = $y";
    117. 

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

  118. 		$r = mysql_fetch_array($result);
    119. 

  119. 		return $r['id'];
    120. 

  120. 	}
    121. 

  121. 

  122. 	function AddVillage($post){
    123. 

  123. 	global $database;
    124. 

  124. 	  $wid = $this->getWref($post['x'],$post['y']);
    125. 

  125. 	  $uid = $post['uid'];
    126. 

  126. 	$status = $database->getVillageState($wid);
    127. 

  127. 	$status = 0;
    128. 

  128. 	if($status == 0){
    129. 

  129. 	mysql_query("Insert into ".TB_PREFIX."admin_log values (0,".$_SESSION['id'].",'Added new village <b><a href=\'admin.php?p=village&did=$wid\'>$wid</a></b> to user <b><a href=\'admin.php?p=player&uid=$uid\'>$uid</a></b>',".time().")");
    130. 

  130. 	  $database->setFieldTaken($wid);
    131. 

  131. 		  $database->addVillage($wid,$uid,'new village','0');
    132. 

  132. 		  $database->addResourceFields($wid,$database->getVillageType($wid));
    133. 

  133. 		  $database->addUnits($wid);
    134. 

  134. 		  $database->addTech($wid);
    135. 

  135. 		  $database->addABTech($wid);
    136. 

  136. 	}
    137. 

  137.   }
    138. 

  138. 

  139. 	function Punish($post){
    140. 

  140. 	 global $database;
    141. 

  141. 	   $villages = $database->getProfileVillages($post['uid']);
    142. 

  142. 	   $admid = $post['admid'];
    143. 

  143. 	   $user = $database->getUserArray($post['uid'],1);
    144. 

  144. 		  for ($i = 0; $i <= count($villages)-1; $i++) {
    145. 

  145. 			$vid = $villages[$i]['wref'];
    146. 

  146. 			if($post['punish']){
    147. 

  147. 			  $popOld = $villages[$i]['pop'];
    148. 

  148. 			  $proc = 100-$post['punish'];
    149. 

  149. 			  $pop = floor(($popOld/100)*($proc));
    150. 

  150. 				if($pop <= 1 ){$pop = 2;}
    151. 

  151. 				$this->PunishBuilding($vid,$proc,$pop);
    152. 

  152. 

  153. 			}
    154. 

  154. 			if($post['del_troop']){
    155. 

  155. 				if($user['tribe'] == 1) {
    156. 

  156. 				  $unit = 1;
    157. 

  157. 				}else if($user['tribe'] == 2) {
    158. 

  158. 				  $unit = 11;
    159. 

  159. 				}else if($user['tribe'] == 3) {
    160. 

  160. 				  $unit = 21;
    161. 

  161. 				}
    162. 

  162. 				  $this->DelUnits($villages[$i]['wref'],$unit);
    163. 

  163. 			}
    164. 

  164. 			if($post['clean_ware']){
    165. 

  165. 			  $time = time();
    166. 

  166. 			  $q = "UPDATE ".TB_PREFIX."vdata SET `wood` = '0', `clay` = '0', `iron` = '0', `crop` = '0', `lastupdate` = '$time' WHERE wref = $vid;";
    167. 

  167. 			  mysql_query($q, $this->connection);
    168. 

  168. 			}
    169. 

  169. 		  }
    170. 

  170. 			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,".$_SESSION['id'].",'Punished user: <a href=\'admin.php?p=player&uid=".$post['uid']."\'>".$post['uid']."</a> with <b>-".$post['punish']."%</b> population',".time().")");
    171. 

  171.   }
    172. 

  172. 

  173.   function PunishBuilding($vid,$proc,$pop){
    174. 

  174. 	global $database;
    175. 

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

  176. 	mysql_query($q, $this->connection);
    177. 

  177. 	$fdata = $database->getResourceLevel($vid);
    178. 

  178. 	for ($i = 1; $i <= 40; $i++) {
    179. 

  179. 	  if($fdata['f'.$i]>1){
    180. 

  180. 		$zm = ($fdata['f'.$i]/100)*$proc;
    181. 

  181. 		if($zm < 1){$zm = 1;}else{$zm = floor($zm);}
    182. 

  182. 		$q = "UPDATE ".TB_PREFIX."fdata SET `f$i` = '$zm' WHERE `vref` = $vid;";
    183. 

  183. 		mysql_query($q, $this->connection);
    184. 

  184. 	  }
    185. 

  185. 	}
    186. 

  186.   }
    187. 

  187. 

  188.   function DelUnits($vid,$unit){
    189. 

  189. 	for ($i = $unit; $i <= 9+$unit; $i++) {
    190. 

  190. 	  $this->DelUnits2($vid,$unit);
    191. 

  191. 	}
    192. 

  192.   }
    193. 

  193. 

  194.   function DelUnits2($vid,$unit){
    195. 

  195. 	  $q = "UPDATE ".TB_PREFIX."units SET `u$unit` = '0' WHERE `vref` = $vid;";
    196. 

  196. 	  mysql_query($q, $this->connection);
    197. 

  197.   }
    198. 

  198. 

  199. 	function DelPlayer($uid,$pass){
    200. 

  200. 	 global $database;
    201. 

  201. 	$ID = $_SESSION['id'];//$database->getUserField($_SESSION['username'],'id',1);
    202. 

  202. 	   if($this->CheckPass($pass,$ID)){
    203. 

  203. 		 $villages = $database->getProfileVillages($uid);
    204. 

  204. 		  for ($i = 0; $i <= count($villages)-1; $i++) {
    205. 

  205. 			$this->DelVillage($villages[$i]['wref'], 1);
    206. 

  206. 		  }
    207. 

  207.  		$q = "DELETE FROM ".TB_PREFIX."hero where uid = $uid";
    208. 

  208. 		mysql_query($q, $this->connection);
    209. 

  209.  
    210. 

  210. 		$name = $database->getUserField($uid,"username",0);
    211. 

  211. 		mysql_query("Insert into ".TB_PREFIX."admin_log values (0,$ID,'Deleted user <a>$name</a>',".time().")");
    212. 

  212. 		$q = "DELETE FROM ".TB_PREFIX."users WHERE `id` = $uid;";
    213. 

  213. 		 mysql_query($q, $this->connection);
    214. 

  214. 	}
    215. 

  215.   }
    216. 

  216. 

  217.   function getUserActive() {
    218. 

  218. 	$time = time() - (60*5);
    219. 

  219. 		$q = "SELECT * FROM ".TB_PREFIX."users where timestamp > $time and username != 'support'";
    220. 

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

  221. 	return $this->mysql_fetch_all($result);
    222. 

  222. 	}
    223. 

  223. 

  224.   function CheckPass($password,$uid){
    225. 

  225. 	$q = "SELECT password FROM ".TB_PREFIX."users where id = '$uid' and access = ".ADMIN;
    226. 

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

  227. 		$dbarray = mysql_fetch_array($result);
    228. 

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

  229. 		  return true;
    230. 

  230. 	}else{
    231. 

  231. 	  return false;
    232. 

  232. 	}
    233. 

  233.   }
    234. 

  234. 

  235. 	function DelVillage($wref, $mode=0){
    236. 

  236. 		global $database;
    237. 

  237. 		if($mode==0){
    238. 

  238. 			$q = "SELECT * FROM ".TB_PREFIX."vdata WHERE `wref` = $wref and capital = 0";
    239. 

  239. 	  }else{
    240. 

  240. 		$q = "SELECT * FROM ".TB_PREFIX."vdata WHERE `wref` = $wref";
    241. 

  241. 	  }
    242. 

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

  243. 		if(mysql_num_rows($result) > 0){
    244. 

  244. 			mysql_query("Insert into ".TB_PREFIX."admin_log values (0,".$_SESSION['id'].",'Deleted village <b>$wref</b>',".time().")");
    245. 

  245. 

  246. 			$database->clearExpansionSlot($wref);
    247. 

  247. 		
    248. 

  248. 			$q = "DELETE FROM ".TB_PREFIX."abdata where vref = $wref";
    249. 

  249. 			mysql_query($q, $this->connection);
    250. 

  250. 			$q = "DELETE FROM ".TB_PREFIX."bdata where wid = $wref";
    251. 

  251. 			mysql_query($q, $this->connection);
    252. 

  252. 			$q = "DELETE FROM ".TB_PREFIX."market where vref = $wref";
    253. 

  253. 			mysql_query($q, $this->connection);
    254. 

  254. 			$q = "DELETE FROM ".TB_PREFIX."odata where wref = $wref";
    255. 

  255. 			mysql_query($q, $this->connection);
    256. 

  256. 			$q = "DELETE FROM ".TB_PREFIX."research where vref = $wref";
    257. 

  257. 			mysql_query($q, $this->connection);
    258. 

  258. 			$q = "DELETE FROM ".TB_PREFIX."tdata where vref = $wref";
    259. 

  259. 			mysql_query($q, $this->connection);
    260. 

  260. 			$q = "DELETE FROM ".TB_PREFIX."fdata where vref = $wref";
    261. 

  261. 			mysql_query($q, $this->connection);
    262. 

  262. 			$q = "DELETE FROM ".TB_PREFIX."training where vref = $wref";
    263. 

  263. 			mysql_query($q, $this->connection);
    264. 

  264. 			$q = "DELETE FROM ".TB_PREFIX."units where vref = $wref";
    265. 

  265. 			mysql_query($q, $this->connection);
    266. 

  266. 			$q = "DELETE FROM ".TB_PREFIX."farmlist where wref = $wref";
    267. 

  267. 			mysql_query($q, $this->connection);
    268. 

  268. 			$q = "DELETE FROM ".TB_PREFIX."raidlist where towref = $wref";
    269. 

  269. 			mysql_query($q, $this->connection);
    270. 

  270. 		
    271. 

  271. 			$q = "DELETE FROM ".TB_PREFIX."movement where `from` = $wref and proc=0";
    272. 

  272. 			mysql_query($q, $this->connection);
    273. 

  273. 				
    274. 

  274. 			$getmovement = $database->getMovement(3,$wref,1);
    275. 

  275. 			foreach($getmovement as $movedata) {
    276. 

  276. 				$time = microtime(true);
    277. 

  277. 				$time2 = $time - $movedata['starttime'];
    278. 

  278. 				$database->setMovementProc($movedata['moveid']);
    279. 

  279. 				$database->addMovement(4,$movedata['to'],$movedata['from'],$movedata['ref'],$time,$time+$time2);
    280. 

  280. 			//$database->setMovementProc($movedata['moveid']);
    281. 

  281. 			}
    282. 

  282. 

  283. 			//check	return enforcement from del village
    284. 

  284. 			$this->returnTroops($wref);
    285. 

  285. 		
    286. 

  286. 			$q = "DELETE FROM ".TB_PREFIX."vdata WHERE `wref` = $wref";
    287. 

  287. 			mysql_query($q, $this->connection);
    288. 

  288. 	
    289. 

  289. 			if (mysql_affected_rows()>0) {
    290. 

  290. 				$q = "UPDATE ".TB_PREFIX."wdata set occupied = 0 where id = $wref";
    291. 

  291. 				mysql_query($q, $this->connection);
    292. 

  292. 			
    293. 

  293. 				$getprisoners = $database->getPrisoners($wref);
    294. 

  294. 				foreach($getprisoners as $pris) {
    295. 

  295. 					$troops = 0;
    296. 

  296. 					for($i=1;$i<12;$i++){
    297. 

  297. 						$troops += $pris['t'.$i];
    298. 

  298. 					}
    299. 

  299. 					$database->modifyUnit($pris['wref'],array("99o"),array($troops),array(0));
    300. 

  300. 					$database->deletePrisoners($pris['id']);
    301. 

  301. 				}
    302. 

  302. 				$getprisoners = $database->getPrisoners3($wref);
    303. 

  303. 				foreach($getprisoners as $pris) {
    304. 

  304. 					$troops = 0;
    305. 

  305. 					for($i=1;$i<12;$i++){
    306. 

  306. 						$troops += $pris['t'.$i];
    307. 

  307. 					}
    308. 

  308. 					$database->modifyUnit($pris['wref'],array("99o"),array($troops),array(0));
    309. 

  309. 					$database->deletePrisoners($pris['id']);
    310. 

  310. 				}
    311. 

  311. 			}
    312. 

  312. 		}
    313. 

  313. 	}	
    314. 

  314.   
    315. 

  315. 	function DelBan($uid,$id){
    316. 

  316. 	 global $database;
    317. 

  317. 	$name = addslashes($database->getUserField($uid,"username",0));
    318. 

  318. 	mysql_query("Insert into ".TB_PREFIX."admin_log values (0,".$_SESSION['id'].",'Unbanned user <a href=\'admin.php?p=player&uid=$uid\'>$name</a>',".time().")");
    319. 

  319. 	$q = "UPDATE ".TB_PREFIX."users SET `access` = '".USER."' WHERE `id` = $uid;";
    320. 

  320. 	mysql_query($q, $this->connection);
    321. 

  321. 	$q = "UPDATE ".TB_PREFIX."banlist SET `active` = '0' WHERE `id` = $id;";
    322. 

  322. 	mysql_query($q, $this->connection);
    323. 

  323.   }
    324. 

  324. 

  325.   function AddBan($uid,$end,$reason){
    326. 

  326. 	global $database;
    327. 

  327. 	$name = addslashes($database->getUserField($uid,"username",0));
    328. 

  328. 	mysql_query("Insert into ".TB_PREFIX."admin_log values (0,".$_SESSION['id'].",'Banned user <a href=\'admin.php?p=player&uid=$uid\'>$name</a>',".time().")");
    329. 

  329. 	$q = "UPDATE ".TB_PREFIX."users SET `access` = '0' WHERE `id` = $uid;";
    330. 

  330. 	mysql_query($q, $this->connection);
    331. 

  331. 	$time = time();
    332. 

  332. 	$admin = $_SESSION['id'];  //$database->getUserField($_SESSION['username'],'id',1);
    333. 

  333. 	$name = addslashes($database->getUserField($uid,'username',0));
    334. 

  334. 	$q = "INSERT INTO ".TB_PREFIX."banlist (`uid`, `name`, `reason`, `time`, `end`, `admin`, `active`) VALUES ($uid, '$name' , '$reason', '$time', '$end', '$admin', '1');";
    335. 

  335. 	mysql_query($q, $this->connection);
    336. 

  336.   }
    337. 

  337. 

  338.   function search_player($player){
    339. 

  339. 	$q = "SELECT id,username FROM ".TB_PREFIX."users WHERE `username` LIKE '%$player%' and username != 'support'";
    340. 

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

  341. 	return $this->mysql_fetch_all($result);
    342. 

  342.   }
    343. 

  343. 

  344.   function search_email($email){
    345. 

  345. 	$q = "SELECT id,email FROM ".TB_PREFIX."users WHERE `email` LIKE '%$email%' and username != 'support'";
    346. 

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

  347. 	return $this->mysql_fetch_all($result);
    348. 

  348.   }
    349. 

  349. 

  350.   function search_village($village){
    351. 

  351. 	$q = "SELECT * FROM ".TB_PREFIX."vdata WHERE `name` LIKE '%$village%' or `wref` LIKE '%$village%'";
    352. 

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

  353. 	return $this->mysql_fetch_all($result);
    354. 

  354.   }
    355. 

  355. 

  356.   function search_alliance($alliance){
    357. 

  357. 	$q = "SELECT * FROM ".TB_PREFIX."alidata WHERE `name` LIKE '%$alliance%' or `tag` LIKE '%$alliance%' or `id` LIKE '%$alliance%'";
    358. 

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

  359. 	return $this->mysql_fetch_all($result);
    360. 

  360.   }
    361. 

  361. 

  362.   function search_ip($ip){
    363. 

  363. 	$q = "SELECT * FROM ".TB_PREFIX."login_log WHERE `ip` LIKE '%$ip%'";
    364. 

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

  365. 	return $this->mysql_fetch_all($result);
    366. 

  366.   }
    367. 

  367. 

  368.   function search_banned(){
    369. 

  369. 	$q = "SELECT * FROM ".TB_PREFIX."banlist where active = '1'";
    370. 

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

  371. 	return $this->mysql_fetch_all($result);
    372. 

  372.   }
    373. 

  373. 

  374.   function Del_banned(){
    375. 

  375. 	//$q = "SELECT * FROM ".TB_PREFIX."banlist";
    376. 

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

  377. 	return $this->mysql_fetch_all($result);
    378. 

  378.   }
    379. 

  379. 

  380. 	/***************************
    381. 

  381. 	Function to process MYSQLi->fetch_all (Only exist in MYSQL)
    382. 

  382. 	References: Result
    383. 

  383. 	***************************/
    384. 

  384. 	function mysql_fetch_all($result) {
    385. 

  385. 		$all = array();
    386. 

  386. 		if($result) {
    387. 

  387. 		while ($row = mysql_fetch_assoc($result)){ $all[] = $row; }
    388. 

  388. 		return $all;
    389. 

  389. 		}
    390. 

  390. 	}
    391. 

  391. 

  392. 	function query_return($q) {
    393. 

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

  394. 		return $this->mysql_fetch_all($result);
    395. 

  395. 	}
    396. 

  396. 

  397. 	/***************************
    398. 

  398. 	Function to do free query
    399. 

  399. 	References: Query
    400. 

  400. 	***************************/
    401. 

  401. 	function query($query) {
    402. 

  402. 		return mysql_query($query, $this->connection);
    403. 

  403. 	}
    404. 

  404. 

  405. 	public function getTypeLevel($tid,$vid) {
    406. 

  406. 		global $village,$database;
    407. 

  407. 		$keyholder = array();
    408. 

  408. 		
    409. 

  409. 		if($vid == 0) {
    410. 

  410. 			$resourcearray = $village->resarray;
    411. 

  411. 		} else {
    412. 

  412. 			$resourcearray = $database->getResourceLevel($vid);
    413. 

  413. 		}
    414. 

  414. 		foreach(array_keys($resourcearray,$tid) as $key) {
    415. 

  415. 			if(strpos($key,'t')) {
    416. 

  416. 				$key = preg_replace("/[^0-9]/", '', $key);
    417. 

  417. 				array_push($keyholder, $key);
    418. 

  418. 			}
    419. 

  419. 		}
    420. 

  420. 		$element = count($keyholder);
    421. 

  421. 		if($element >= 2) {
    422. 

  422. 			if($tid <= 4) {
    423. 

  423. 				$temparray = array();
    424. 

  424. 				for($i=0;$i<=$element-1;$i++) {
    425. 

  425. 					array_push($temparray,$resourcearray['f'.$keyholder[$i]]);
    426. 

  426. 				}
    427. 

  427. 				foreach ($temparray as $key => $val) {
    428. 

  428. 					if ($val == max($temparray))
    429. 

  429. 					$target = $key;
    430. 

  430. 				}
    431. 

  431. 			}
    432. 

  432. 			else {
    433. 

  433. 				$target = 0;
    434. 

  434. 				for($i=1;$i<=$element-1;$i++) {
    435. 

  435. 					if($resourcearray['f'.$keyholder[$i]] > $resourcearray['f'.$keyholder[$target]]) {
    436. 

  436. 						$target = $i;
    437. 

  437. 					}
    438. 

  438. 				}
    439. 

  439. 			}
    440. 

  440. 		}
    441. 

  441. 		else if($element == 1) {
    442. 

  442. 			$target = 0;
    443. 

  443. 		}
    444. 

  444. 		else {
    445. 

  445. 			return 0;
    446. 

  446. 		}
    447. 

  447. 		if($keyholder[$target] != "") {
    448. 

  448. 			return $resourcearray['f'.$keyholder[$target]];
    449. 

  449. 		}
    450. 

  450. 		else {
    451. 

  451. 			return 0;
    452. 

  452. 		}
    453. 

  453. 	}
    454. 

  454. 

  455. 	   public function procDistanceTime($coor,$thiscoor,$ref,$vid) {
    456. 

  456. 		global $bid28,$bid14;
    457. 

  457. 		
    458. 

  458. 		$xdistance = ABS($thiscoor['x'] - $coor['x']);
    459. 

  459. 		if($xdistance > WORLD_MAX) {
    460. 

  460. 			$xdistance = (2 * WORLD_MAX + 1) - $xdistance;
    461. 

  461. 		}
    462. 

  462. 		$ydistance = ABS($thiscoor['y'] - $coor['y']);
    463. 

  463. 		if($ydistance > WORLD_MAX) {
    464. 

  464. 			$ydistance = (2 * WORLD_MAX + 1) - $ydistance;
    465. 

  465. 		}
    466. 

  466. 		$distance = SQRT(POW($xdistance,2)+POW($ydistance,2));
    467. 

  467. 		$speed = $ref;
    468. 

  468. 		if($this->getTypeLevel(14,$vid) != 0 && $distance >= TS_THRESHOLD) {
    469. 

  469. 			$speed = $speed * ($bid14[$this->getTypeLevel(14,$vid)]['attri']/100) ;
    470. 

  470. 		}
    471. 

  471. 

  472. 		if($speed!=0){
    473. 

  473. 		return round(($distance/$speed) * 3600 / INCREASE_SPEED);
    474. 

  474. 		}else{
    475. 

  475. 		return round($distance * 3600 / INCREASE_SPEED);
    476. 

  476. 		}
    477. 

  477. 	}
    478. 

  478.     public function returnTroops($wref) {
    479. 

  479.         global $database;
    480. 

  480. 

  481.         $getenforce=$database->getEnforceVillage($wref,0);
    482. 

  482.         
    483. 

  483. 		//if(($enforce['from']==$village->wid) || ($enforce['vref']==$village->wid)){
    484. 

  484.         foreach($getenforce as $enforce) {
    485. 

  485. 			
    486. 

  486. 			$to = $database->getVillage($enforce['from']);
    487. 

  487. 			$Gtribe = "";
    488. 

  488. 			if ($database->getUserField($to['owner'],'tribe',0) ==  '2'){ $Gtribe = "1"; }
    489. 

  489. 			else if ($database->getUserField($to['owner'],'tribe',0) == '3'){ $Gtribe =  "2"; }
    490. 

  490. 			else if ($database->getUserField($to['owner'],'tribe',0) ==  '4'){ $Gtribe = "3"; }
    491. 

  491. 			else if  ($database->getUserField($to['owner'],'tribe',0) == '5'){ $Gtribe =  "4"; }
    492. 

  492.                     
    493. 

  493. 			$start = ($database->getUserField($to['owner'],'tribe',0)-1)*10+1;
    494. 

  494. 			$end = ($database->getUserField($to['owner'],'tribe',0)*10);
    495. 

  495. 

  496. 			$from = $database->getVillage($enforce['from']);
    497. 

  497. 			$fromcoor = $database->getCoor($enforce['from']);
    498. 

  498. 			$tocoor = $database->getCoor($enforce['vref']);
    499. 

  499. 			$fromCor = array('x'=>$tocoor['x'], 'y'=>$tocoor['y']);
    500. 

  500. 			$toCor = array('x'=>$fromcoor['x'], 'y'=>$fromcoor['y']);
    501. 

  501. 

  502. 			$speeds = array();
    503. 

  503. 

  504. 			//find slowest unit.
    505. 

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

  506. 				
    507. 

  507. 				if(intval($enforce['u'.$i]) > 0){
    508. 

  508. 					if($unitarray) { reset($unitarray); }
    509. 

  509. 					$unitarray = $GLOBALS["u".$i];
    510. 

  510. 					$speeds[] = $unitarray['speed'];
    511. 

  511. 					//echo print_r(array_keys($speeds))."unitspd\n".$i."trib\n";
    512. 

  512. 					
    513. 

  513. 

  514. 				} else {
    515. 

  515. 					$enforce['u'.$i]='0';
    516. 

  516. 				}
    517. 

  517. 				
    518. 

  518. 			}
    519. 

  519. 			
    520. 

  520. 			if( intval($enforce['hero']) > 0){
    521. 

  521. 				$q = "SELECT * FROM ".TB_PREFIX."hero WHERE uid = ".$from['owner']."";
    522. 

  522. 				$result = mysql_query($q);
    523. 

  523. 				$hero_f=mysql_fetch_array($result);
    524. 

  524. 				$hero_unit=$hero_f['unit'];
    525. 

  525. 				$speeds[] = $GLOBALS['u'.$hero_unit]['speed'];
    526. 

  526. 			} else {
    527. 

  527. 				$enforce['hero']='0';
    528. 

  528. 			}
    529. 

  529. 			
    530. 

  530. 			$artefact = count($database->getOwnUniqueArtefactInfo2($from['owner'],2,3,0));
    531. 

  531. 			$artefact1 = count($database->getOwnUniqueArtefactInfo2($enforce['from'],2,1,1));
    532. 

  532. 			$artefact2 = count($database->getOwnUniqueArtefactInfo2($from['owner'],2,2,0));
    533. 

  533. 			if($artefact > 0){
    534. 

  534. 				$fastertroops = 3;
    535. 

  535. 			}else if($artefact1 > 0){
    536. 

  536. 				$fastertroops = 2;
    537. 

  537. 			}else if($artefact2 > 0){
    538. 

  538. 				$fastertroops = 1.5;
    539. 

  539. 			}else{
    540. 

  540. 				$fastertroops = 1;
    541. 

  541. 			}
    542. 

  542. 			$time = round($this->procDistanceTime($fromCor,$toCor,min($speeds),$enforce['from'])/$fastertroops);
    543. 

  543. 			
    544. 

  544. 			$foolartefact2 = $database->getFoolArtefactInfo(2,$enforce['from'],$from['owner']);
    545. 

  545. 			if(count($foolartefact2) > 0){
    546. 

  546. 				foreach($foolartefact2 as $arte){
    547. 

  547. 					if($arte['bad_effect'] == 1){
    548. 

  548. 						$time *= $arte['effect2'];
    549. 

  549. 					}else{
    550. 

  550. 						$time /= $arte['effect2'];
    551. 

  551. 						$time = round($time);
    552. 

  552. 					}
    553. 

  553. 				}
    554. 

  554. 			}
    555. 

  555. 			$reference =  $database->addAttack($enforce['from'],$enforce['u'.$start],$enforce['u'.($start+1)],$enforce['u'.($start+2)],$enforce['u'.($start+3)],$enforce['u'.($start+4)],$enforce['u'.($start+5)],$enforce['u'.($start+6)],$enforce['u'.($start+7)],$enforce['u'.($start+8)],$enforce['u'.($start+9)],$enforce['hero'],2,0,0,0,0);
    556. 

  556. 			$database->addMovement(4,$wref,$enforce['from'],$reference,time(),($time+time()));
    557. 

  557. 			$database->deleteReinf($enforce['id']);
    558. 

  558. 		}
    559. 

  559. 	}	
    560. 

  560. 

  561. 

  562. 	public function calculateProduction($wid,$uid,$b1,$b2,$b3,$b4,$fdata,$ocounter,$pop) {
    563. 

  563. 		global $technology,$database;
    564. 

  564. 		$normalA = $database->getOwnArtefactInfoByType($wid,4);
    565. 

  565. 		$largeA = $database->getOwnUniqueArtefactInfo($uid,4,2);
    566. 

  566. 		$uniqueA = $database->getOwnUniqueArtefactInfo($uid,4,3);
    567. 

  567. 		$upkeep = $this->getUpkeep($this->getAllUnits($wid),0,$wid,$uid);
    568. 

  568. 		
    569. 

  569. 		
    570. 

  570. 		$production=array();
    571. 

  571. 		$production['wood'] = $this->getWoodProd($fdata, $ocounter,$b1);
    572. 

  572. 		$production['clay'] = $this->getClayProd($fdata, $ocounter,$b2);
    573. 

  573. 		$production['iron'] = $this->getIronProd($fdata, $ocounter,$b3);
    574. 

  574. 		if ($uniqueA['size']==3 && $uniqueA['owner']==$uid){
    575. 

  575. 			$production['crop'] = $this->getCropProd($fdata, $ocounter,$b4)-$pop-(($upkeep)-round($upkeep*0.50));
    576. 

  576. 		}elseif ($normalA['type']==4 && $normalA['size']==1 && $normalA['owner']==$uid){
    577. 

  577. 			$production['crop'] = $this->getCropProd($fdata, $ocounter,$b4)-$pop-(($upkeep)-round($upkeep*0.25));
    578. 

  578. 		}else if ($largeA['size']==2 && $largeA['owner']==$uid){
    579. 

  579. 			$production['crop'] = $this->getCropProd($fdata, $ocounter,$b4)-$pop-(($upkeep)-round($upkeep*0.25));
    580. 

  580. 		}else{
    581. 

  581. 			$production['crop'] = $this->getCropProd($fdata, $ocounter,$b4)-$pop-$upkeep;
    582. 

  582. 		}
    583. 

  583. 		return $production;
    584. 

  584. 	}
    585. 

  585. 

  586. 	private function getWoodProd($fdata,$ocounter,$b1) {
    587. 

  587. 		global $bid1,$bid5;
    588. 

  588. 		$basewood = $sawmill = 0;
    589. 

  589. 		$woodholder = array();
    590. 

  590. 		for($i=1;$i<=38;$i++) {
    591. 

  591. 			if($fdata['f'.$i.'t'] == 1) {
    592. 

  592. 				array_push($woodholder,'f'.$i);
    593. 

  593. 			}
    594. 

  594. 			if($fdata['f'.$i.'t'] == 5) {
    595. 

  595. 				$sawmill = $fdata['f'.$i];
    596. 

  596. 			}
    597. 

  597. 		}
    598. 

  598. 		for($i=0;$i<=count($woodholder)-1;$i++) { $basewood+= $bid1[$fdata[$woodholder[$i]]]['prod']; }
    599. 

  599. 		$wood = $basewood + $basewood * 0.25 * $ocounter[0];
    600. 

  600. 		if($sawmill >= 1) {
    601. 

  601. 			$wood += $basewood / 100 * $bid5[$sawmill]['attri'];
    602. 

  602. 		}
    603. 

  603. 		if($b1 > time()) {
    604. 

  604. 			$wood *= 1.25;
    605. 

  605. 		}
    606. 

  606. 		$wood *= SPEED;
    607. 

  607. 		return round($wood);
    608. 

  608. 	}
    609. 

  609. 

  610. 	private function getClayProd($fdata,$ocounter,$b2) {
    611. 

  611. 		global $bid2,$bid6,$session;
    612. 

  612. 		$baseclay = $clay = $brick = 0;
    613. 

  613. 		$clayholder = array();
    614. 

  614. 		for($i=1;$i<=38;$i++) {
    615. 

  615. 			if($fdata['f'.$i.'t'] == 2) {
    616. 

  616. 				array_push($clayholder,'f'.$i);
    617. 

  617. 			}
    618. 

  618. 			if($fdata['f'.$i.'t'] == 6) {
    619. 

  619. 				$brick = $fdata['f'.$i];
    620. 

  620. 			}
    621. 

  621. 		}
    622. 

  622. 		for($i=0;$i<=count($clayholder)-1;$i++) { $baseclay+= $bid2[$fdata[$clayholder[$i]]]['prod']; }
    623. 

  623. 		$clay = $baseclay + $baseclay * 0.25 * $ocounter[1];
    624. 

  624. 		if($brick >= 1) {
    625. 

  625. 			$clay += $baseclay / 100 * $bid6[$brick]['attri'];
    626. 

  626. 		}
    627. 

  627. 		if($b2 > time()) {
    628. 

  628. 			$clay *= 1.25;
    629. 

  629. 		}
    630. 

  630. 		$clay *= SPEED;
    631. 

  631. 		return round($clay);
    632. 

  632. 	}
    633. 

  633. 

  634. 	private function getIronProd($fdata,$ocounter,$b3) {
    635. 

  635. 		global $bid3,$bid7;
    636. 

  636. 		$baseiron = $foundry = 0;
    637. 

  637. 		$ironholder = array();
    638. 

  638. 		for($i=1;$i<=38;$i++) {
    639. 

  639. 			if($fdata['f'.$i.'t'] == 3) {
    640. 

  640. 				array_push($ironholder,'f'.$i);
    641. 

  641. 			}
    642. 

  642. 			if($fdata['f'.$i.'t'] == 7) {
    643. 

  643. 				$foundry = $fdata['f'.$i];
    644. 

  644. 			}
    645. 

  645. 		}
    646. 

  646. 		for($i=0;$i<=count($ironholder)-1;$i++) { $baseiron+= $bid3[$fdata[$ironholder[$i]]]['prod']; }
    647. 

  647. 		$iron = $baseiron + $baseiron * 0.25 * $ocounter[2];
    648. 

  648. 		if($foundry >= 1) {
    649. 

  649. 			$iron += $baseiron / 100 * $bid7[$foundry]['attri'];
    650. 

  650. 		}
    651. 

  651. 		if($b3 > time()) {
    652. 

  652. 			$iron *= 1.25;
    653. 

  653. 		}
    654. 

  654. 		$iron *= SPEED;
    655. 

  655. 		return round($iron);
    656. 

  656. 	}
    657. 

  657. 

  658. 	private function getCropProd($fdata,$ocounter,$b4) {
    659. 

  659. 		global $bid4,$bid8,$bid9;
    660. 

  660. 		$basecrop = $grainmill = $bakery = 0;
    661. 

  661. 		$cropholder = array();
    662. 

  662. 		for($i=1;$i<=38;$i++) {
    663. 

  663. 			if($fdata['f'.$i.'t'] == 4) {
    664. 

  664. 				array_push($cropholder,'f'.$i);
    665. 

  665. 			}
    666. 

  666. 			if($fdata['f'.$i.'t'] == 8) {
    667. 

  667. 				$grainmill = $fdata['f'.$i];
    668. 

  668. 			}
    669. 

  669. 			if($fdata['f'.$i.'t'] == 9) {
    670. 

  670. 				$bakery = $fdata['f'.$i];
    671. 

  671. 			}
    672. 

  672. 		}
    673. 

  673. 		for($i=0;$i<=count($cropholder)-1;$i++) { $basecrop+= $bid4[$fdata[$cropholder[$i]]]['prod']; }
    674. 

  674. 		$crop = $basecrop + $basecrop * 0.25 * $ocounter[3];
    675. 

  675. 		$jcrop=0;
    676. 

  676. 		if($grainmill >= 1) $jcrop=$bid8[$grainmill]['attri'];
    677. 

  677. 		if($bakery >= 1) $jcrop+=$bid9[$bakery]['attri'];
    678. 

  678. 		$crop += $basecrop /100 * $jcrop;
    679. 

  679. 		if($b4 > time()) {
    680. 

  680. 			$crop *= 1.25;
    681. 

  681. 		}
    682. 

  682. 		$crop *= SPEED;
    683. 

  683. 		return round($crop);
    684. 

  684. 	}
    685. 

  685. 

  686. 		function getAllUnits($base,$InVillageOnly=False,$mode=0) {
    687. 

  687. 		global $database;
    688. 

  688. 		$ownunit = $database->getUnit($base);
    689. 

  689. 		$ownunit['u99'] -= $ownunit['u99'];
    690. 

  690. 		$ownunit['u99o'] -= $ownunit['u99o'];
    691. 

  691. 		$enforcementarray = $database->getEnforceVillage($base,0);
    692. 

  692. 		if(count($enforcementarray) > 0) {
    693. 

  693. 			foreach($enforcementarray as $enforce) {
    694. 

  694. 				for($i=1;$i<=50;$i++) {
    695. 

  695. 					$ownunit['u'.$i] += $enforce['u'.$i];
    696. 

  696. 				}
    697. 

  697. 				$ownunit['hero'] += $enforce['hero'];
    698. 

  698. 			}
    699. 

  699. 		}
    700. 

  700. 		if ($mode==0) {
    701. 

  701. 			$enforceoasis=$database->getOasisEnforce($base,0);
    702. 

  702. 			if(count($enforceoasis) > 0) {
    703. 

  703. 				foreach($enforceoasis as $enforce) {
    704. 

  704. 					for($i=1;$i<=50;$i++) {
    705. 

  705. 						$ownunit['u'.$i] += $enforce['u'.$i];
    706. 

  706. 					}
    707. 

  707. 					$ownunit['hero'] += $enforce['hero'];
    708. 

  708. 				}
    709. 

  709. 			}
    710. 

  710. 			//$enforcementarray = $database->getEnforceVillage($base,1);
    711. 

  711. 			$enforceoasis1=$database->getOasisEnforce($base,1);
    712. 

  712. 			if(count($enforceoasis1) > 0) {
    713. 

  713. 				foreach($enforceoasis1 as $enforce) {
    714. 

  714. 					for($i=1;$i<=50;$i++) {
    715. 

  715. 						$ownunit['u'.$i] += $enforce['u'.$i];
    716. 

  716. 					}
    717. 

  717. 					$ownunit['hero'] += $enforce['hero'];
    718. 

  718. 				}
    719. 

  719. 			}		
    720. 

  720. 

  721. 			
    722. 

  722. 			$prisoners = $database->getPrisoners($base,1);
    723. 

  723. 			if(!empty($prisoners)) {
    724. 

  724. 				foreach($prisoners as $prisoner){
    725. 

  725. 					$owner = $database->getVillageField($base,"owner");
    726. 

  726. 					$ownertribe = $database->getUserField($owner,"tribe",0);
    727. 

  727. 					$start = ($ownertribe-1)*10+1;
    728. 

  728. 					$end = ($ownertribe*10);
    729. 

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

  730. 						$j = $i-$start+1;
    731. 

  731. 						$ownunit['u'.$i] += $prisoner['t'.$j];
    732. 

  732. 					}
    733. 

  733. 					$ownunit['hero'] += $prisoner['t11'];
    734. 

  734. 				}
    735. 

  735. 			}
    736. 

  736. 		}
    737. 

  737. 		
    738. 

  738. 		if(!$InVillageOnly) {
    739. 

  739. 			$movement = $database->getVillageMovement($base);
    740. 

  740. 			if(!empty($movement)) {
    741. 

  741. 				for($i=1;$i<=50;$i++) {
    742. 

  742. 					if (isset($movement['u'.$i])) {
    743. 

  743. 						$ownunit['u'.$i] += $movement['u'.$i];
    744. 

  744. 					}
    745. 

  745. 				}
    746. 

  746. 				$ownunit['hero'] += $movement['hero'];
    747. 

  747. 			}
    748. 

  748. 		}
    749. 

  749. 		return $ownunit;
    750. 

  750. 	}
    751. 

  751. 	
    752. 

  752. 	public function getUpkeep($array,$type,$vid,$uid,$prisoners=0) {
    753. 

  753. 		global $database;
    754. 

  754. 		$buildarray = array();
    755. 

  755. 		$buildarray = $database->getResourceLevel($vid);
    756. 

  756. 		$upkeep = 0;
    757. 

  757. 		switch($type) {
    758. 

  758. 			case 0:
    759. 

  759. 			$start = 1;
    760. 

  760. 			$end = 50;
    761. 

  761. 			break;
    762. 

  762. 			case 1:
    763. 

  763. 			$start = 1;
    764. 

  764. 			$end = 10;
    765. 

  765. 			break;
    766. 

  766. 			case 2:
    767. 

  767. 			$start = 11;
    768. 

  768. 			$end = 20;
    769. 

  769. 			break;
    770. 

  770. 			case 3:
    771. 

  771. 			$start = 21;
    772. 

  772. 			$end = 30;
    773. 

  773. 			break;
    774. 

  774. 			case 4:
    775. 

  775. 			$start = 31;
    776. 

  776. 			$end = 40;
    777. 

  777. 			break;
    778. 

  778. 			case 5:
    779. 

  779. 			$start = 41;
    780. 

  780. 			$end = 50;
    781. 

  781. 			break;
    782. 

  782. 		}
    783. 

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

  784. 			$k = $i-$start+1;
    785. 

  785. 			$unit = "u".$i;
    786. 

  786. 			$unit2 = "t".$k;
    787. 

  787. 			global $$unit;
    788. 

  788. 			$dataarray = $$unit;
    789. 

  789. 			for($j=19;$j<=38;$j++) {
    790. 

  790. 			if($buildarray['f'.$j.'t'] == 41) {
    791. 

  791. 			$horsedrinking = $j;
    792. 

  792. 			}
    793. 

  793. 			}
    794. 

  794. 			if($prisoners == 0){
    795. 

  795. 			if(isset($horsedrinking)){
    796. 

  796. 			if(($i==4 && $buildarray['f'.$horsedrinking] >= 10)
    797. 

  797. 			|| ($i==5 && $buildarray['f'.$horsedrinking] >= 15)
    798. 

  798. 			|| ($i==6 && $buildarray['f'.$horsedrinking] == 20)) {
    799. 

  799. 			$upkeep += ($dataarray['pop']-1) * $array[$unit];
    800. 

  800. 			} else {
    801. 

  801. 			$upkeep += $dataarray['pop'] * $array[$unit];
    802. 

  802. 			}}else{
    803. 

  803. 			$upkeep += $dataarray['pop'] * $array[$unit];
    804. 

  804. 			}
    805. 

  805. 			}else{
    806. 

  806. 			if(isset($horsedrinking)){
    807. 

  807. 			if(($i==4 && $buildarray['f'.$horsedrinking] >= 10)
    808. 

  808. 			|| ($i==5 && $buildarray['f'.$horsedrinking] >= 15)
    809. 

  809. 			|| ($i==6 && $buildarray['f'.$horsedrinking] == 20)) {
    810. 

  810. 			$upkeep += ($dataarray['pop']-1) * $array[$unit2];
    811. 

  811. 			} else {
    812. 

  812. 			$upkeep += $dataarray['pop'] * $array[$unit2];
    813. 

  813. 			}}else{
    814. 

  814. 			$upkeep += $dataarray['pop'] * $array[$unit2];
    815. 

  815. 			}
    816. 

  816. 			}
    817. 

  817. 		}
    818. 

  818. 		 //   $unit = "hero";
    819. 

  819. 		 //   global $$unit;
    820. 

  820. 		 //   $dataarray = $$unit;
    821. 

  821. 		 if($prisoners == 0){
    822. 

  822. 			$upkeep += (isset($array['hero'])? $array['hero'] * 6:0);
    823. 

  823. 		 }else{
    824. 

  824. 			$upkeep += (isset($array['t11'])? $array['t11'] * 6:0);
    825. 

  825. 		 }
    826. 

  826. 			$artefact = count($database->getOwnUniqueArtefactInfo2($uid,4,3,0));
    827. 

  827. 			$artefact1 = count($database->getOwnUniqueArtefactInfo2($vid,4,1,1));
    828. 

  828. 			$artefact2 = count($database->getOwnUniqueArtefactInfo2($uid,4,2,0));
    829. 

  829. 			if($artefact > 0){
    830. 

  830. 			$upkeep /= 2;
    831. 

  831. 			$upkeep = round($upkeep);
    832. 

  832. 			}else if($artefact1 > 0){
    833. 

  833. 			$upkeep /= 2;
    834. 

  834. 			$upkeep = round($upkeep);
    835. 

  835. 			}else if($artefact2 > 0){
    836. 

  836. 			$upkeep /= 4;
    837. 

  837. 			$upkeep = round($upkeep);
    838. 

  838. 			$upkeep *= 3;
    839. 

  839. 			}
    840. 

  840. 			$foolartefact = $database->getFoolArtefactInfo(4,$vid,$uid);
    841. 

  841. 			if(count($foolartefact) > 0){
    842. 

  842. 			foreach($foolartefact as $arte){
    843. 

  843. 			if($arte['bad_effect'] == 1){
    844. 

  844. 			$upkeep *= $arte['effect2'];
    845. 

  845. 			}else{
    846. 

  846. 			$upkeep /= $arte['effect2'];
    847. 

  847. 			$upkeep = round($upkeep);
    848. 

  848. 			}
    849. 

  849. 			}
    850. 

  850. 			}
    851. 

  851. 		return $upkeep;
    852. 

  852. 	}
    853. 

  853. 	
    854. 

  854. };
    855. 

  855. 

  856. $admin = new adm_DB;
    857. 

  857. include("function.php");
    858. 

  858. ?>
    859. 

  859.