PageRenderTime 51ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 0ms

/medals.php

https://bitbucket.org/Dzoki/travianx
PHP | 558 lines | 397 code | 74 blank | 87 comment | 49 complexity | 74690cc8cab473400c0be6479ee57232 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3. #################################################################################
    4. 

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

  5. ## --------------------------------------------------------------------------- ##
    6. 

  6. ##  Filename       medals.php                                                  ##
    7. 

  7. ##  Developed by:  Dixie                                                       ##
    8. 

  8. ##  License:       TravianX Project                                            ##
    9. 

  9. ##  Copyright:     TravianX (c) 2010-2011. All rights reserved.                ##
    10. 

  10. ##                                                                             ##
    11. 

  11. #################################################################################
    12. 

  12. 

  13. /******************************
    14. 

  14. INDELING CATEGORIEEN:
    15. 

  15. ===============================
    16. 

  16. == 1. Aanvallers top 10      ==
    17. 

  17. == 2. Defence top 10         ==
    18. 

  18. == 3. Klimmers top 10        ==
    19. 

  19. == 4. Overvallers top 10     ==
    20. 

  20. == 5. In att en def tegelijk ==
    21. 

  21. == 6. in top 3 - aanval      ==
    22. 

  22. == 7. in top 3 - verdediging ==
    23. 

  23. == 8. in top 3 - klimmers    ==
    24. 

  24. == 9. in top 3 - overval     ==
    25. 

  25. ******************************/
    26. 

  26. include_once("GameEngine/Account.php");
    27. 

  27. 

  28. mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS);
    29. 

  29. mysql_select_db(SQL_DB);
    30. 

  30. 

  31. if (mysql_num_rows(mysql_query("SELECT id FROM ".TB_PREFIX."users WHERE access = 9 AND id = ".$session->uid)) != '1') die("Hacking attemp!");
    32. 

  32. 

  33. 		//bepaal welke week we zitten
    34. 

  34. 		$q = "SELECT * FROM ".TB_PREFIX."medal order by week DESC LIMIT 0, 1";
    35. 

  35. 		$result = mysql_query($q);
    36. 

  36. 		if(mysql_num_rows($result)) {
    37. 

  37. 			$row=mysql_fetch_assoc($result);
    38. 

  38. 			$week=($row['week']+1);
    39. 

  39. 		} else {
    40. 

  40. 			$week='1';
    41. 

  41. 		}
    42. 

  42.         
    43. 

  43.         //Do same for ally week
    44. 

  44.         $q = "SELECT * FROM ".TB_PREFIX."allimedal order by week DESC LIMIT 0, 1";
    45. 

  45.         $result = mysql_query($q);
    46. 

  46.         if(mysql_num_rows($result)) {
    47. 

  47.             $row=mysql_fetch_assoc($result);
    48. 

  48.             $allyweek=($row['week']+1);
    49. 

  49.         } else {
    50. 

  50.             $allyweek='1';
    51. 

  51.         }
    52. 

  52. 	
    53. 

  53. 	//we mogen de lintjes weggeven
    54. 

  54. 	if(isset($_GET['giveout'])){
    55. 

  55. 	
    56. 

  56. 

  57. 	//Aanvallers v/d Week
    58. 

  58.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY ap DESC Limit 10");
    59. 

  59.     $i=0; 	while($row = mysql_fetch_array($result)){
    60. 

  60. 	$i++;	$img="t2_".($i)."";
    61. 

  61. 	$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '1', '".($i)."', '".$week."', '".$row['ap']."', '".$img."')";
    62. 

  62. 	$resul=mysql_query($quer);	  
    63. 

  63. 	}
    64. 

  64. 

  65. 	//Verdediger v/d Week
    66. 

  66.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY dp DESC Limit 10");
    67. 

  67.     $i=0; 	while($row = mysql_fetch_array($result)){
    68. 

  68. 	$i++;	$img="t3_".($i)."";
    69. 

  69. 	$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '2', '".($i)."', '".$week."', '".$row['dp']."', '".$img."')";
    70. 

  70. 	$resul=mysql_query($quer);	  
    71. 

  71. 	}	
    72. 

  72.     
    73. 

  73.     //Rank climbers of the week
    74. 

  74.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY clp DESC Limit 10");
    75. 

  75.     $i=0;     while($row = mysql_fetch_array($result)){
    76. 

  76.     $i++;    $img="t1_".($i)."";
    77. 

  77.     $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '10', '".($i)."', '".$week."', '".$row['clp']."', '".$img."')";
    78. 

  78.     $resul=mysql_query($quer);      
    79. 

  79.     }    
    80. 

  80. 

  81. 	//Overvallers v/d Week
    82. 

  82.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY RR DESC Limit 10");
    83. 

  83.     $i=0; 	while($row = mysql_fetch_array($result)){
    84. 

  84. 	$i++;	$img="t4_".($i)."";
    85. 

  85. 	$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '4', '".($i)."', '".$week."', '".$row['RR']."', '".$img."')";
    86. 

  86. 	$resul=mysql_query($quer);	  
    87. 

  87. 	}	
    88. 

  88. 	
    89. 

  89. 	//deel de bonus voor aanval+defence top 10 uit
    90. 

  90. 	//Pak de top10 aanvallers
    91. 

  91.         $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY ap DESC Limit 10");
    92. 

  92.     while($row = mysql_fetch_array($result)){
    93. 

  93.     
    94. 

  94.          //Pak de top10 verdedigers
    95. 

  95.         $result2 = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY dp DESC Limit 10");
    96. 

  96.         while($row2 = mysql_fetch_array($result2)){
    97. 

  97.             if($row['id']==$row2['id']){
    98. 

  98.             
    99. 

  99.             $query3="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 5";
    100. 

  100.             $result3=mysql_query($query3);
    101. 

  101.              $row3=mysql_fetch_row($result3);
    102. 

  102.         
    103. 

  103.                 //kijk welke kleur het lintje moet hebben
    104. 

  104.                 if($row3[0]<='2'){
    105. 

  105.                     $img="t22".$row3[0]."_1";
    106. 

  106.                         switch ($row3[0]) {
    107. 

  107.                             case "0":
    108. 

  108.                                 $tekst="";
    109. 

  109.                                 break;
    110. 

  110.                             case "1":
    111. 

  111.                                 $tekst="twice ";
    112. 

  112.                                 break;
    113. 

  113.                             case "2":
    114. 

  114.                                 $tekst="three times ";
    115. 

  115.                                 break;
    116. 

  116.                         }
    117. 

  117.                     $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '5', '0', '".$week."', '".$tekst."', '".$img."')";
    118. 

  118.                     $resul=mysql_query($quer);
    119. 

  119.                 }
    120. 

  120.             }
    121. 

  121.         }    
    122. 

  122.     }
    123. 

  123. 	
    124. 

  124. 	//je staat voor 3e / 5e / 10e keer in de top 3 aanvallers 
    125. 

  125. 	//Pak de top10 aanvallers
    126. 

  126.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY ap DESC Limit 10");
    127. 

  127.     while($row = mysql_fetch_array($result)){ 
    128. 

  128. 	
    129. 

  129. 			$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 1 AND plaats<=3";
    130. 

  130. 			$result1=mysql_query($query1);
    131. 

  131. 	 		$row1=mysql_fetch_row($result1);
    132. 

  132.  
    133. 

  133. 		
    134. 

  134. 		//2x in gestaan, dit is 3e dus lintje (brons)
    135. 

  135. 		if($row1[0]=='3'){	
    136. 

  136. 			$img="t120_1";
    137. 

  137. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '6', '0', '".$week."', 'Three', '".$img."')";
    138. 

  138. 			$resul=mysql_query($quer);
    139. 

  139. 		}
    140. 

  140. 		//4x in gestaan, dit is 5e dus lintje (zilver)
    141. 

  141. 		if($row1[0]=='5'){	
    142. 

  142. 			$img="t121_1";
    143. 

  143. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '6', '0', '".$week."', 'Five', '".$img."')";
    144. 

  144. 			$resul=mysql_query($quer);
    145. 

  145. 		}		
    146. 

  146. 		//9x in gestaan, dit is 10e dus lintje (goud)
    147. 

  147. 		if($row1[0]=='10'){	
    148. 

  148. 			$img="t122_1";
    149. 

  149. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '6', '0', '".$week."', 'Ten', '".$img."')";
    150. 

  150. 			$resul=mysql_query($quer);
    151. 

  151. 		}
    152. 

  152. 		
    153. 

  153. 	}
    154. 

  154. 	//je staat voor 3e / 5e / 10e keer in de top 10 aanvallers 
    155. 

  155.     //Pak de top10 aanvallers
    156. 

  156.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY ap DESC Limit 10");
    157. 

  157.     while($row = mysql_fetch_array($result)){ 
    158. 

  158.     
    159. 

  159.             $query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 1 AND plaats<=10";
    160. 

  160.             $result1=mysql_query($query1);
    161. 

  161.              $row1=mysql_fetch_row($result1);
    162. 

  162.  
    163. 

  163.         
    164. 

  164.         //2x in gestaan, dit is 3e dus lintje (brons)
    165. 

  165.         if($row1[0]=='3'){    
    166. 

  166.             $img="t130_1";
    167. 

  167.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '12', '0', '".$week."', 'Three', '".$img."')";
    168. 

  168.             $resul=mysql_query($quer);
    169. 

  169.         }
    170. 

  170.         //4x in gestaan, dit is 5e dus lintje (zilver)
    171. 

  171.         if($row1[0]=='5'){    
    172. 

  172.             $img="t131_1";
    173. 

  173.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '12', '0', '".$week."', 'Five', '".$img."')";
    174. 

  174.             $resul=mysql_query($quer);
    175. 

  175.         }        
    176. 

  176.         //9x in gestaan, dit is 10e dus lintje (goud)
    177. 

  177.         if($row1[0]=='10'){    
    178. 

  178.             $img="t132_1";
    179. 

  179.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '12', '0', '".$week."', 'Ten', '".$img."')";
    180. 

  180.             $resul=mysql_query($quer);
    181. 

  181.         }
    182. 

  182.         
    183. 

  183.     }
    184. 

  184. 	//je staat voor 3e / 5e / 10e keer in de top 3 verdedigers 
    185. 

  185. 	//Pak de top10 verdedigers
    186. 

  186.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY dp DESC Limit 10");
    187. 

  187.     while($row = mysql_fetch_array($result)){ 
    188. 

  188. 	
    189. 

  189. 			$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 2 AND plaats<=3";
    190. 

  190. 			$result1=mysql_query($query1);
    191. 

  191. 	 		$row1=mysql_fetch_row($result1);
    192. 

  192.  
    193. 

  193. 		
    194. 

  194. 		//2x in gestaan, dit is 3e dus lintje (brons)
    195. 

  195. 		if($row1[0]=='3'){	
    196. 

  196. 			$img="t140_1";
    197. 

  197. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '7', '0', '".$week."', 'Three', '".$img."')";
    198. 

  198. 			$resul=mysql_query($quer);
    199. 

  199. 		}
    200. 

  200. 		//4x in gestaan, dit is 5e dus lintje (zilver)
    201. 

  201. 		if($row1[0]=='5'){	
    202. 

  202. 			$img="t141_1";
    203. 

  203. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '7', '0', '".$week."', 'Five', '".$img."')";
    204. 

  204. 			$resul=mysql_query($quer);
    205. 

  205. 		}		
    206. 

  206. 		//9x in gestaan, dit is 10e dus lintje (goud)
    207. 

  207. 		if($row1[0]=='10'){	
    208. 

  208. 			$img="t142_1";
    209. 

  209. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '7', '0', '".$week."', 'Ten', '".$img."')";
    210. 

  210. 			$resul=mysql_query($quer);
    211. 

  211. 		}
    212. 

  212. 		
    213. 

  213. 	}
    214. 

  214.     //je staat voor 3e / 5e / 10e keer in de top 3 verdedigers 
    215. 

  215.     //Pak de top10 verdedigers
    216. 

  216.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY dp DESC Limit 10");
    217. 

  217.     while($row = mysql_fetch_array($result)){ 
    218. 

  218.     
    219. 

  219.             $query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 2 AND plaats<=10";
    220. 

  220.             $result1=mysql_query($query1);
    221. 

  221.              $row1=mysql_fetch_row($result1);
    222. 

  222.  
    223. 

  223.         
    224. 

  224.         //2x in gestaan, dit is 3e dus lintje (brons)
    225. 

  225.         if($row1[0]=='3'){    
    226. 

  226.             $img="t150_1";
    227. 

  227.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '13', '0', '".$week."', 'Three', '".$img."')";
    228. 

  228.             $resul=mysql_query($quer);
    229. 

  229.         }
    230. 

  230.         //4x in gestaan, dit is 5e dus lintje (zilver)
    231. 

  231.         if($row1[0]=='5'){    
    232. 

  232.             $img="t151_1";
    233. 

  233.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '13', '0', '".$week."', 'Five', '".$img."')";
    234. 

  234.             $resul=mysql_query($quer);
    235. 

  235.         }        
    236. 

  236.         //9x in gestaan, dit is 10e dus lintje (goud)
    237. 

  237.         if($row1[0]=='10'){    
    238. 

  238.             $img="t152_1";
    239. 

  239.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '13', '0', '".$week."', 'Ten', '".$img."')";
    240. 

  240.             $resul=mysql_query($quer);
    241. 

  241.         }
    242. 

  242.         
    243. 

  243.     }	
    244. 

  244. 

  245. 	//je staat voor 3e / 5e / 10e keer in de top 3 klimmers 
    246. 

  246. 	//Pak de top10 klimmers
    247. 

  247.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY Rc DESC Limit 10");
    248. 

  248.     while($row = mysql_fetch_array($result)){ 
    249. 

  249. 	
    250. 

  250. 			$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 3 AND plaats<=3";
    251. 

  251. 			$result1=mysql_query($query1);
    252. 

  252. 	 		$row1=mysql_fetch_row($result1);
    253. 

  253.  
    254. 

  254. 		
    255. 

  255. 		//2x in gestaan, dit is 3e dus lintje (brons)
    256. 

  256. 		if($row1[0]=='3'){	
    257. 

  257. 			$img="t100_1";
    258. 

  258. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '8', '0', '".$week."', 'Three', '".$img."')";
    259. 

  259. 			$resul=mysql_query($quer);
    260. 

  260. 		}
    261. 

  261. 		//4x in gestaan, dit is 5e dus lintje (zilver)
    262. 

  262. 		if($row1[0]=='5'){	
    263. 

  263. 			$img="t101_1";
    264. 

  264. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '8', '0', '".$week."', 'Five', '".$img."')";
    265. 

  265. 			$resul=mysql_query($quer);
    266. 

  266. 		}		
    267. 

  267. 		//9x in gestaan, dit is 10e dus lintje (goud)
    268. 

  268. 		if($row1[0]=='10'){	
    269. 

  269. 			$img="t102_1";
    270. 

  270. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '8', '0', '".$week."', 'Ten', '".$img."')";
    271. 

  271. 			$resul=mysql_query($quer);
    272. 

  272. 		}
    273. 

  273. 	}//je staat voor 3e / 5e / 10e keer in de top 3 klimmers 
    274. 

  274.     //Pak de top10 klimmers
    275. 

  275.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY Rc DESC Limit 10");
    276. 

  276.     while($row = mysql_fetch_array($result)){ 
    277. 

  277.     
    278. 

  278.             $query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 3 AND plaats<=10";
    279. 

  279.             $result1=mysql_query($query1);
    280. 

  280.              $row1=mysql_fetch_row($result1);
    281. 

  281.  
    282. 

  282.         
    283. 

  283.         //2x in gestaan, dit is 3e dus lintje (brons)
    284. 

  284.         if($row1[0]=='3'){    
    285. 

  285.             $img="t110_1";
    286. 

  286.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '14', '0', '".$week."', 'Three', '".$img."')";
    287. 

  287.             $resul=mysql_query($quer);
    288. 

  288.         }
    289. 

  289.         //4x in gestaan, dit is 5e dus lintje (zilver)
    290. 

  290.         if($row1[0]=='5'){    
    291. 

  291.             $img="t111_1";
    292. 

  292.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '14', '0', '".$week."', 'Five', '".$img."')";
    293. 

  293.             $resul=mysql_query($quer);
    294. 

  294.         }        
    295. 

  295.         //9x in gestaan, dit is 10e dus lintje (goud)
    296. 

  296.         if($row1[0]=='10'){    
    297. 

  297.             $img="t112_1";
    298. 

  298.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '14', '0', '".$week."', 'Ten', '".$img."')";
    299. 

  299.             $resul=mysql_query($quer);
    300. 

  300.         }
    301. 

  301.     }
    302. 

  302.     
    303. 

  303.     //je staat voor 3e / 5e / 10e keer in de top 3 klimmers 
    304. 

  304.     //Pak de top3 rank climbers 
    305. 

  305.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY clp DESC Limit 10");
    306. 

  306.     while($row = mysql_fetch_array($result)){ 
    307. 

  307.     
    308. 

  308.             $query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 10 AND plaats<=3";
    309. 

  309.             $result1=mysql_query($query1);
    310. 

  310.              $row1=mysql_fetch_row($result1);
    311. 

  311.  
    312. 

  312.         
    313. 

  313.         //2x in gestaan, dit is 3e dus lintje (brons)
    314. 

  314.         if($row1[0]=='3'){    
    315. 

  315.             $img="t200_1";
    316. 

  316.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '11', '0', '".$week."', 'Three', '".$img."')";
    317. 

  317.             $resul=mysql_query($quer);
    318. 

  318.         }
    319. 

  319.         //4x in gestaan, dit is 5e dus lintje (zilver)
    320. 

  320.         if($row1[0]=='5'){    
    321. 

  321.             $img="t201_1";
    322. 

  322.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '11', '0', '".$week."', 'Five', '".$img."')";
    323. 

  323.             $resul=mysql_query($quer);
    324. 

  324.         }        
    325. 

  325.         //9x in gestaan, dit is 10e dus lintje (goud)
    326. 

  326.         if($row1[0]=='10'){    
    327. 

  327.             $img="t202_1";
    328. 

  328.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '11', '0', '".$week."', 'Ten', '".$img."')";
    329. 

  329.             $resul=mysql_query($quer);
    330. 

  330.         }
    331. 

  331.     }
    332. 

  332.     //je staat voor 3e / 5e / 10e keer in de top 10klimmers 
    333. 

  333.     //Pak de top3 rank climbers 
    334. 

  334.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY clp DESC Limit 10");
    335. 

  335.     while($row = mysql_fetch_array($result)){ 
    336. 

  336.     
    337. 

  337.             $query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 10 AND plaats<=10";
    338. 

  338.             $result1=mysql_query($query1);
    339. 

  339.              $row1=mysql_fetch_row($result1);
    340. 

  340.  
    341. 

  341.         
    342. 

  342.         //2x in gestaan, dit is 3e dus lintje (brons)
    343. 

  343.         if($row1[0]=='3'){    
    344. 

  344.             $img="t210_1";
    345. 

  345.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '16', '0', '".$week."', 'Three', '".$img."')";
    346. 

  346.             $resul=mysql_query($quer);
    347. 

  347.         }
    348. 

  348.         //4x in gestaan, dit is 5e dus lintje (zilver)
    349. 

  349.         if($row1[0]=='5'){    
    350. 

  350.             $img="t211_1";
    351. 

  351.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '16', '0', '".$week."', 'Five', '".$img."')";
    352. 

  352.             $resul=mysql_query($quer);
    353. 

  353.         }        
    354. 

  354.         //9x in gestaan, dit is 10e dus lintje (goud)
    355. 

  355.         if($row1[0]=='10'){    
    356. 

  356.             $img="t212_1";
    357. 

  357.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '16', '0', '".$week."', 'Ten', '".$img."')";
    358. 

  358.             $resul=mysql_query($quer);
    359. 

  359.         }
    360. 

  360.     }    	
    361. 

  361. 

  362. 	//je staat voor 3e / 5e / 10e keer in de top 10 overvallers 
    363. 

  363. 	//Pak de top10 overvallers
    364. 

  364.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY RR DESC Limit 10");
    365. 

  365.     while($row = mysql_fetch_array($result)){ 
    366. 

  366. 	
    367. 

  367. 			$query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 4 AND plaats<=3";
    368. 

  368. 			$result1=mysql_query($query1);
    369. 

  369. 	 		$row1=mysql_fetch_row($result1);
    370. 

  370.  
    371. 

  371. 		
    372. 

  372. 		//2x in gestaan, dit is 3e dus lintje (brons)
    373. 

  373. 		if($row1[0]=='3'){	
    374. 

  374. 			$img="t160_1";
    375. 

  375. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '9', '0', '".$week."', 'Three', '".$img."')";
    376. 

  376. 			$resul=mysql_query($quer);
    377. 

  377. 		}
    378. 

  378. 		//4x in gestaan, dit is 5e dus lintje (zilver)
    379. 

  379. 		if($row1[0]=='5'){	
    380. 

  380. 			$img="t161_1";
    381. 

  381. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '9', '0', '".$week."', 'Five', '".$img."')";
    382. 

  382. 			$resul=mysql_query($quer);
    383. 

  383. 		}		
    384. 

  384. 		//9x in gestaan, dit is 10e dus lintje (goud)
    385. 

  385. 		if($row1[0]=='10'){	
    386. 

  386. 			$img="t162_1";
    387. 

  387. 			$quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '9', '0', '".$week."', 'Ten', '".$img."')";
    388. 

  388. 			$resul=mysql_query($quer);
    389. 

  389. 		}
    390. 

  390. 	} //je staat voor 3e / 5e / 10e keer in de top 10 overvallers 
    391. 

  391.     //Pak de top10 overvallers
    392. 

  392.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY RR DESC Limit 10");
    393. 

  393.     while($row = mysql_fetch_array($result)){ 
    394. 

  394.     
    395. 

  395.             $query1="SELECT count(*) FROM ".TB_PREFIX."medal WHERE userid='".$row['id']."' AND categorie = 4 AND plaats<=10";
    396. 

  396.             $result1=mysql_query($query1);
    397. 

  397.              $row1=mysql_fetch_row($result1);
    398. 

  398.  
    399. 

  399.         
    400. 

  400.         //2x in gestaan, dit is 3e dus lintje (brons)
    401. 

  401.         if($row1[0]=='3'){    
    402. 

  402.             $img="t170_1";
    403. 

  403.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '15', '0', '".$week."', 'Three', '".$img."')";
    404. 

  404.             $resul=mysql_query($quer);
    405. 

  405.         }
    406. 

  406.         //4x in gestaan, dit is 5e dus lintje (zilver)
    407. 

  407.         if($row1[0]=='5'){    
    408. 

  408.             $img="t171_1";
    409. 

  409.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '15', '0', '".$week."', 'Five', '".$img."')";
    410. 

  410.             $resul=mysql_query($quer);
    411. 

  411.         }        
    412. 

  412.         //9x in gestaan, dit is 10e dus lintje (goud)
    413. 

  413.         if($row1[0]=='10'){    
    414. 

  414.             $img="t172_1";
    415. 

  415.             $quer="insert into ".TB_PREFIX."medal(userid, categorie, plaats, week, points, img) values('".$row['id']."', '15', '0', '".$week."', 'Ten', '".$img."')";
    416. 

  416.             $resul=mysql_query($quer);
    417. 

  417.         }
    418. 

  418.     }
    419. 

  419. 	
    420. 

  420. 	//Zet alle waardens weer op 0
    421. 

  421. 	 $query="SELECT * FROM ".TB_PREFIX."users WHERE id > 3 ORDER BY id+0 DESC";
    422. 

  422. 	 $result=mysql_query($query);
    423. 

  423. 	 for ($i=0; $row=mysql_fetch_row($result); $i++){
    424. 

  424. 	 mysql_query("UPDATE ".TB_PREFIX."users SET ap=0, dp=0,Rc=0,clp=0, RR=0 WHERE id = ".$row[0]."");
    425. 

  425. 	}
    426. 

  426.     
    427. 

  427.     //Start alliance Medals wooot
    428. 

  428.     
    429. 

  429. 	//Aanvallers v/d Week
    430. 

  430.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY ap DESC Limit 10");
    431. 

  431.     $i=0;     while($row = mysql_fetch_array($result)){
    432. 

  432.     $i++;    $img="a2_".($i)."";
    433. 

  433.     $quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '1', '".($i)."', '".$allyweek."', '".$row['ap']."', '".$img."')";
    434. 

  434.     $resul=mysql_query($quer);      
    435. 

  435.     }
    436. 

  436. 

  437.     //Verdediger v/d Week
    438. 

  438.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY dp DESC Limit 10");
    439. 

  439.     $i=0;     while($row = mysql_fetch_array($result)){
    440. 

  440.     $i++;    $img="a3_".($i)."";
    441. 

  441.     $quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '2', '".($i)."', '".$allyweek."', '".$row['dp']."', '".$img."')";
    442. 

  442.     $resul=mysql_query($quer);      
    443. 

  443.     }    
    444. 

  444.     
    445. 

  445.       //Overvallers v/d Week
    446. 

  446.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY RR DESC Limit 10");
    447. 

  447.     $i=0;     while($row = mysql_fetch_array($result)){
    448. 

  448.     $i++;    $img="a4_".($i)."";
    449. 

  449.     $quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '4', '".($i)."', '".$allyweek."', '".$row['RR']."', '".$img."')";
    450. 

  450.     $resul=mysql_query($quer);      
    451. 

  451.     }
    452. 

  452.     
    453. 

  453.     //Rank climbers of the week
    454. 

  454.     $result = mysql_query("SELECT * FROM ".TB_PREFIX."alidata ORDER BY clp DESC Limit 10");
    455. 

  455.     $i=0;     while($row = mysql_fetch_array($result)){
    456. 

  456.     $i++;    $img="a1_".($i)."";
    457. 

  457.     $quer="insert into ".TB_PREFIX."allimedal(allyid, categorie, plaats, week, points, img) values('".$row['id']."', '3', '".($i)."', '".$allyweek."', '".$row['clp']."', '".$img."')";
    458. 

  458.     $resul=mysql_query($quer);      
    459. 

  459.     }
    460. 

  460.  
    461. 

  461.     
    462. 

  462.      $query="SELECT * FROM ".TB_PREFIX."alidata ORDER BY id+0 DESC";
    463. 

  463.      $result=mysql_query($query);
    464. 

  464.      for ($i=0; $row=mysql_fetch_row($result); $i++){
    465. 

  465.      mysql_query("UPDATE ".TB_PREFIX."alidata SET ap=0, dp=0, RR=0, clp=0 WHERE id = ".$row[0]."");
    466. 

  466.     }    
    467. 

  467. 	}
    468. 

  468. 

  469. ?>
    470. 

  470.     
    471. 

  471.     <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    472. 

  472. <html>
    473. 

  473. <head>
    474. 

  474. 	<title><?php echo SERVER_NAME ?></title>
    475. 

  475.     <link REL="shortcut icon" HREF="favicon.ico"/>
    476. 

  476. 	<meta http-equiv="cache-control" content="max-age=0" />
    477. 

  477. 	<meta http-equiv="pragma" content="no-cache" />
    478. 

  478. 	<meta http-equiv="expires" content="0" />
    479. 

  479. 	<meta http-equiv="imagetoolbar" content="no" />
    480. 

  480. 	<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
    481. 

  481. 

  482. 	<script src="mt-full.js?0ac36" type="text/javascript"></script>
    483. 

  483. 	<script src="unx.js?0ac36" type="text/javascript"></script>
    484. 

  484. 	<script src="new.js?0ac36" type="text/javascript"></script>
    485. 

  485. 	<link href="<?php echo GP_LOCATE; ?>lang/en/lang.css?f4b7c" rel="stylesheet" type="text/css" />
    486. 

  486. 	<link href="<?php echo GP_LOCATE; ?>lang/en/compact.css?f4b7c" rel="stylesheet" type="text/css" />
    487. 

  487. 	<?php
    488. 

  488. 	if($session->gpack == null || GP_ENABLE == false) {
    489. 

  489. 	echo "
    490. 

  490. 	<link href='".GP_LOCATE."travian.css?e21d2' rel='stylesheet' type='text/css' />
    491. 

  491. 	<link href='".GP_LOCATE."lang/en/lang.css?e21d2' rel='stylesheet' type='text/css' />";
    492. 

  492. 	} else {
    493. 

  493. 	echo "
    494. 

  494. 	<link href='".$session->gpack."travian.css?e21d2' rel='stylesheet' type='text/css' />
    495. 

  495. 	<link href='".$session->gpack."lang/en/lang.css?e21d2' rel='stylesheet' type='text/css' />";
    496. 

  496. 	}
    497. 

  497. 	?>
    498. 

  498. 	<script type="text/javascript">
    499. 

  499. 

  500. 		window.addEvent('domready', start);
    501. 

  501. 	</script>
    502. 

  502. </head> 
    503. 

  503. <body class="v35 ie ie8">
    504. 

  504. <div class="wrapper">
    505. 

  505. <img style="filter:chroma();" src="img/x.gif" id="msfilter" alt="" />
    506. 

  506. <div id="dynamic_header">
    507. 

  507. 	</div>
    508. 

  508. <?php include("Templates/header.tpl"); ?>
    509. 

  509. <div id="mid">
    510. 

  510. <?php include("Templates/menu.tpl"); ?>
    511. 

  511. 

  512. <div id="content"  class="login">
    513. 

  513. <?php
    514. 

  514. if(isset($_GET['giveout'])){?>
    515. 

  515. <h1><br/>Top 10 Medals</h1><br />
    516. 

  516. Done:<br />
    517. 

  517. -Top 10 Attacker<br />
    518. 

  518. -Top 10 Defender<br />
    519. 

  519. -Top 10 Robbers<br />
    520. 

  520. -Top 10 Alliance Attacker<br />
    521. 

  521. -Top 10 Alliance Defencer<br />
    522. 

  522. -Top 10 Alliance Robbers<br />
    523. 

  523. -Top 10 Alliance Climbers(Rank)<br />
    524. 

  524. -Top 10 Pop Climbers<br />
    525. 

  525. -Top 10 Rank Climbers<br />
    526. 

  526. -Bonus: Attacker AND Defender<br />
    527. 

  527. -Bonus: 3/5/10 times in a row top 3 Pop Climbers<br />
    528. 

  528. -Bonus: 3/5/10 times in a row top 3 Rank Climbers<br />
    529. 

  529. -Bonus: 3/5/10 times top 3 Attack<br />
    530. 

  530. -Bonus: 3/5/10 times top 3 Defence<br />
    531. 

  531. -Bonus: 3/5/10 times top 3 Robber<br />
    532. 

  532. 

  533. -Bonus: 3/5/10 times in a row top 10 Attack<br />
    534. 

  534. -Bonus: 3/5/10 times in a row top 10 Defence<br />
    535. 

  535. -Bonus: 3/5/10 times in a row top 10 Pop Climbers<br />
    536. 

  536. -Bonus: 3/5/10 times in a row top 10 Rank Climbers<br />
    537. 

  537. -Bonus: 3/5/10 times in a row top 10 Robber<br />
    538. 

  538. 

  539. 

  540. 

  541. <?php
    542. 

  542. } else{ ?><h1><br/>Top 10 Medals</h1><br />
    543. 

  543. Click <a href="?giveout">here</a>, to give the medals away for <b>week <?php echo $week; ?></b>!<br/>WARNING: Loading next page can take some time!
    544. 

  544. <?php } ?></div>
    545. 

  545. <div id="side_info" class="outgame">
    546. 

  546. </div>
    547. 

  547. 

  548. <div class="clear"></div>
    549. 

  549. 			</div>
    550. 

  550. 

  551. 			<div class="footer-stopper outgame"></div>
    552. 

  552.             <div class="clear"></div>
    553. 

  553.             
    554. 

  554. <?php include("Templates/footer.tpl"); ?>
    555. 

  555. <div id="ce"></div>
    556. 

  556. </body>
    557. 

  557. </html>
    558. 

  558. <?php mysql_close(); ?>
    559. 

  559.