PageRenderTime 55ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 0ms

/Templates/Ranking/ally_top10.tpl

https://bitbucket.org/Dzoki/travianx
Smarty Template | 222 lines | 213 code | 9 blank | 0 comment | 37 complexity | 5a1c43f58676ef28c665d30bb7e54dd0 MD5 | raw file
    

  1.     <?php
    2. 

  2.     $db_host=SQL_SERVER; $db_user=SQL_USER; $db_pass=SQL_PASS; $db_name=SQL_DB;
    3. 

  3. 

  4.     $con = mysql_connect($db_host, $db_user, $db_pass);
    5. 

  5.     if (!$con)
    6. 

  6.       {
    7. 

  7.       die('Could not connect: ' . mysql_error());
    8. 

  8.       }
    9. 

  9. 

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

  11.     echo "Row ".$i;
    12. 

  12.     }
    13. 

  13.              
    14. 

  14.     mysql_select_db($db_name, $con);
    15. 

  15. 

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

  17.     $result2 = mysql_query("SELECT * FROM ".TB_PREFIX."alidata WHERE id = '".$session->alliance."' ORDER BY ap DESC Limit 1");
    18. 

  18. 	?>
    19. 

  19. 	<table cellpadding="1" cellspacing="1">
    20. 

  20. 	<thead>
    21. 

  21. 		<tr>
    22. 

  22. 			<th>Top 10 Alliances<div id="submenu"><a title="Top 10" href="statistiken.php?id=43"><img class="active btn_top10" src="img/x.gif" alt="Top 10"></a><a title="defender" href="statistiken.php?id=42"><img class="btn_def" src="img/x.gif" alt="defender"></a><a title="attacker" href="statistiken.php?id=41"><img class="btn_off" src="img/x.gif" alt="attacker"></a></div><div id="submenu2"><a title="Romans" href="statistiken.php?id=11"><img class="btn_v1" src="img/x.gif" alt="attacker"></a><a title="Teutons" href="statistiken.php?id=12"><img class="btn_v2" src="img/x.gif" alt="attacker"></a><a title="Gauls" href="statistiken.php?id=13"><img class="btn_v3" src="img/x.gif" alt="attacker"></a></div></th>
    23. 

  23. 		</tr>
    24. 

  24. 	</thead>
    25. 

  25. </table>
    26. 

  26. <table cellpadding="1" cellspacing="1" id="top10_offs" class="top10 row_table_data">
    27. 

  27. 	<thead>
    28. 

  28. 		<tr>
    29. 

  29. 			<th onclick="return Popup(3,5)"><img src="img/x.gif" class="help" alt="Instructions" title="Instructions">
    30. 

  30. 			</th>
    31. 

  31. 			<th colspan="2">Attackers of the week</th>
    32. 

  32. 		</tr>
    33. 

  33. 		<tr>
    34. 

  34. 			<td>No.</td>
    35. 

  35. 			<td>Alliance</td>
    36. 

  36. 			<td>Points</td>
    37. 

  37. 		</tr>
    38. 

  38. 	</thead>
    39. 

  39. 	<tbody>
    40. 

  40. <?php
    41. 

  41.     while($row = mysql_fetch_array($result))
    42. 

  42.       {
    43. 

  43. 	  if($row['id']==$session->alliance) {
    44. 

  44. 	  echo "<tr class=\"own hl\">"; } else { echo "<tr>"; }
    45. 

  45.       echo "<td class=\"ra fc\">".$i++.".&nbsp;</td>";
    46. 

  46.       echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>";
    47. 

  47.       echo "<td class=\"val lc\">".$row['ap']."</td>";
    48. 

  48.       echo "</tr>";
    49. 

  49.       }
    50. 

  50. ?>
    51. 

  51. 		 <tr>
    52. 

  52. 			<td colspan="3" class="empty"></td>
    53. 

  53. 		</tr>
    54. 

  54. <?php
    55. 

  55.     while($row = mysql_fetch_array($result2))
    56. 

  56.       {
    57. 

  57. 		if($row['id'] == $session->alliance) {
    58. 

  58. 		echo "<tr class=\"none\">"; } else { echo "<tr class=\"own hl\">"; }
    59. 

  59.       echo "<td class=\"ra fc\">?&nbsp;</td>";
    60. 

  60. 	  	if($row['id'] == $session->alliance) {
    61. 

  61. 		echo "<td class=\"pla\">".$row['tag']."</td>"; } else { echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>"; }
    62. 

  62.       echo "<td class=\"val lc\">".$row['ap']."</td>";
    63. 

  63.       echo "</tr>";
    64. 

  64.       }
    65. 

  65. ?>
    66. 

  66.          </tbody>
    67. 

  67. </table>
    68. 

  68. 

  69. 

  70. <?php
    71. 

  71.     for($i=1;$i<=0;$i++) {
    72. 

  72.     echo "Row ".$i;
    73. 

  73.     }
    74. 

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

  75.     $result2 = mysql_query("SELECT * FROM ".TB_PREFIX."alidata WHERE id = '".$session->alliance."' ORDER BY dp DESC Limit 1");
    76. 

  76. ?>
    77. 

  77. <table cellpadding="1" cellspacing="1" id="top10_defs" class="top10 row_table_data">
    78. 

  78. 	<thead>
    79. 

  79. 		<tr>
    80. 

  80. 			<th onclick="return Popup(3,5)"><img src="img/x.gif" class="help" alt="Instructions" title="Instructions">
    81. 

  81. 			</th>
    82. 

  82. 			<th colspan="2">Defenders of the week</th>
    83. 

  83. 		</tr>
    84. 

  84. 		<tr>
    85. 

  85. 			<td>No.</td>
    86. 

  86. 			<td>Alliance</td>
    87. 

  87. 			<td>Points</td>
    88. 

  88. 		</tr>
    89. 

  89. 	</thead>
    90. 

  90. 	<tbody>
    91. 

  91. <?php
    92. 

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

  93.       {
    94. 

  94. 	  if($row['id']==$session->alliance) {
    95. 

  95. 	  echo "<tr class=\"own hl\">"; } else { echo "<tr>"; }
    96. 

  96.       echo "<td class=\"ra fc\">".$i++.".&nbsp;</td>";
    97. 

  97. 	  echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>";
    98. 

  98.       echo "<td class=\"val lc\">".$row['dp']."</td>";
    99. 

  99.       echo "</tr>";
    100. 

  100.       }
    101. 

  101. ?>
    102. 

  102. 	
    103. 

  103. 		 <tr>
    104. 

  104. 			<td colspan="3" class="empty"></td>
    105. 

  105. 		</tr>
    106. 

  106. <?php
    107. 

  107.     while($row = mysql_fetch_array($result2))
    108. 

  108.       {
    109. 

  109.      if($row['id'] == $session->alliance) {
    110. 

  110. 		echo "<tr class=\"none\">"; } else { echo "<tr class=\"own hl\">"; }
    111. 

  111.       echo "<td class=\"ra fc\">?&nbsp;</td>";
    112. 

  112.      if($row['id'] == $session->alliance) {
    113. 

  113. 		echo "<td class=\"pla\">".$row['tag']."</td>"; } else { echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>"; }
    114. 

  114.       echo "<td class=\"val lc\">".$row['dp']."</td>";
    115. 

  115.       echo "</tr>";
    116. 

  116.       }
    117. 

  117. ?>
    118. 

  118.          </tbody>
    119. 

  119. </table>
    120. 

  120. 	
    121. 

  121. <?php
    122. 

  122.     for($i=1;$i<=0;$i++) {
    123. 

  123.     echo "Row ".$i;
    124. 

  124.     }
    125. 

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

  126.     $result2 = mysql_query("SELECT * FROM ".TB_PREFIX."alidata WHERE id = '".$session->alliance."' ORDER BY clp DESC Limit 1");
    127. 

  127. ?>
    128. 

  128. <div class="clear"></div>
    129. 

  129. <table cellpadding="1" cellspacing="1" id="top10_climbers" class="top10 row_table_data">
    130. 

  130. 	<thead>
    131. 

  131. 		<tr>
    132. 

  132. 			<th onclick="return Popup(3,5)"><img src="img/x.gif" class="help" alt="Instructions" title="Instructions">
    133. 

  133. 			</th>
    134. 

  134. 			<th colspan="2">Climbers of the week</th>
    135. 

  135. 		</tr>
    136. 

  136. 		<tr>
    137. 

  137. 			<td>No.</td>
    138. 

  138. 			<td>Alliance</td>
    139. 

  139. 			<td>Ranks</td>
    140. 

  140. 		</tr>
    141. 

  141. 	</thead>
    142. 

  142. 	<tbody>
    143. 

  143. <?php
    144. 

  144.     while($row = mysql_fetch_array($result))
    145. 

  145.       {
    146. 

  146. 	  if($row['id']==$session->alliance) {
    147. 

  147. 	  echo "<tr class=\"own hl\">"; } else { echo "<tr>"; }
    148. 

  148.       echo "<td class=\"ra fc\">".$i++.".&nbsp;</td>";
    149. 

  149.       echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>";
    150. 

  150.       echo "<td class=\"val lc\">".$row['clp']."</td>";
    151. 

  151.       echo "</tr>";
    152. 

  152.       }
    153. 

  153. ?>
    154. 

  154. 		 <tr>
    155. 

  155. 			<td colspan="3" class="empty"></td>
    156. 

  156. 		</tr>
    157. 

  157. <?php
    158. 

  158.     while($row = mysql_fetch_array($result2))
    159. 

  159.       {
    160. 

  160. 		if($row['id'] == $session->alliance) {
    161. 

  161. 		echo "<tr class=\"none\">"; } else { echo "<tr class=\"own hl\">"; }
    162. 

  162.       echo "<td class=\"ra fc\">?&nbsp;</td>";
    163. 

  163. 		if($row['id'] == $session->alliance) {
    164. 

  164. 		echo "<td class=\"pla\">".$row['tag']."</td>"; } else { echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>"; }    
    165. 

  165.           echo "<td class=\"val lc\">".$row['clp']."</td>";
    166. 

  166.       echo "</tr>";
    167. 

  167.       }
    168. 

  168. ?>
    169. 

  169.          </tbody>
    170. 

  170. </table>
    171. 

  171. <?php
    172. 

  172.     for($i=1;$i<=0;$i++) {
    173. 

  173.     echo "Row ".$i;
    174. 

  174.     }
    175. 

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

  176.     $result2 = mysql_query("SELECT * FROM ".TB_PREFIX."alidata WHERE id = '".$session->alliance."' ORDER BY RR DESC Limit 1");
    177. 

  177. ?>
    178. 

  178. <table cellpadding="1" cellspacing="1" id="top10_raiders" class="top10 row_table_data">
    179. 

  179. 	<thead>
    180. 

  180. 		<tr>
    181. 

  181. 			<th onclick="return Popup(3,5)"><img src="img/x.gif" class="help" alt="Instructions" title="Instructions">
    182. 

  182. 			</th>
    183. 

  183. 			<th colspan="2">Robbers of the week</th>
    184. 

  184. 		</tr>
    185. 

  185. 		<tr>
    186. 

  186. 			<td>No.</td>
    187. 

  187. 			<td>Alliance</td>
    188. 

  188. 			<td>Resources</td>
    189. 

  189. 		</tr>
    190. 

  190. 	</thead>
    191. 

  191. 	<tbody>
    192. 

  192. <?php
    193. 

  193.     while($row = mysql_fetch_array($result))
    194. 

  194.       {
    195. 

  195. 	  if($row['id']==$session->alliance) {
    196. 

  196. 	  echo "<tr class=\"own hl\">"; } else { echo "<tr>"; }
    197. 

  197.       echo "<td class=\"ra fc\">".$i++.".&nbsp;</td>";
    198. 

  198.       echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>";
    199. 

  199.       echo "<td class=\"val lc\">".$row['RR']."</td>";
    200. 

  200.       echo "</tr>";
    201. 

  201.       }
    202. 

  202. ?>
    203. 

  203. 		 <tr>
    204. 

  204. 			<td colspan="3" class="empty"></td>
    205. 

  205. 		</tr>
    206. 

  206. <?php
    207. 

  207.     while($row = mysql_fetch_array($result2))
    208. 

  208.       {
    209. 

  209.       if($row['id'] == $session->alliance) {
    210. 

  210. 		echo "<tr class=\"none\">"; } else { echo "<tr class=\"own hl\">"; }
    211. 

  211.       echo "<td class=\"ra fc\">?&nbsp;</td>";
    212. 

  212.       if($row['id'] == $session->alliance) {
    213. 

  213. 		echo "<td class=\"pla\">".$row['tag']."</td>"; } else { echo "<td class=\"pla\"><a href='allianz.php?aid=".$row['id']."'>".$row['tag']."</a></td>"; }
    214. 

  214.       echo "<td class=\"val lc\">".$row['RR']."</td>";
    215. 

  215.       echo "</tr>";
    216. 

  216.       }
    217. 

  217. 	  
    218. 

  218. 	mysql_close($con);
    219. 

  219. ?>
    220. 

  220.          </tbody>
    221. 

  221. </table>
    222. 

  222. <div>
    223.