Advertisement
Guest User

Untitled

a guest
May 28th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. <table class="table">
  2. <thead>
  3. <tr>
  4. <th>KRÓLESTWO</th>
  5. <th>PUNKTY</th>
  6. </tr>
  7. </thead>
  8. <tbody>
  9. <?php
  10.  
  11. $user = mysql_query("SELECT * FROM kingdoms");
  12.  
  13. $guildPoints = array();
  14. while($row = mysql_fetch_array($user)){
  15. $guild = json_decode($row['dbval'], true);
  16. $guildPoints[$row['dbkey']] = $guild['resourcepoints'];
  17. }
  18.  
  19. arsort($guildPoints);
  20. if (count($guildPoints) > 10) {
  21. $guildPoints = array_slice($guildPoints, 0, 10);
  22. }
  23. foreach ($guildPoints as $key => $value) {
  24. echo'
  25. <tr>
  26. <td> '.$key.'</td>
  27. <td> '.$value.'</td>
  28. </tr>
  29. ';
  30. }
  31. ?>
  32. </tbody>
  33. </table>
  34.  
  35. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement