Advertisement
Guest User

Untitled

a guest
Jan 6th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. <?PHP
  2. $connecta = mysql_connect('localhost','','');
  3. $db = mysql_select_db('ragnarok');
  4. ?>
  5.  
  6. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  7. <html xmlns="http://www.w3.org/1999/xhtml">
  8. <head>
  9. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  10. <link rel="stylesheet" type="text/css" href="estilo.css" />
  11. <title>Ranking PvP Mooka</title>
  12. </head>
  13.  
  14. <body>
  15. <h1 align="center">Detalhes WOE</h1><br>
  16. <div id="ranking">
  17. <table border="0" cellpadding="0" cellspacing="0">
  18. <tr align="center" id="title">
  19. <td>Nome</td>
  20. <td>Guild</td>
  21. <td>Matou</td>
  22. <td>Dano Emperium</td>
  23. <td>Dano Barricadas</td>
  24. <td>Emperium Break</td>
  25. </tr>
  26.  
  27. <?PHP
  28. SELECT
  29. users.name,
  30. chars.*,
  31. guild.name as 'guild_name'
  32. FROM
  33. char_wstats as chars
  34. JOIN pvpm_data as users ON chars.char_id = users.id
  35. JOIN guild ON chars.char_id = guild.char_id
  36. ORDER BY
  37. chars.kill_count DESC
  38. LIMIT 50
  39. $pos = 1;
  40.  
  41. while($pvp = mysql_fetch_assoc($tabela)){
  42. echo '
  43. <tr align="center" id="player">
  44.  
  45. <td>'.$pvp['name'].'</td>
  46. <td>'.$pvp['guild_name'].'</td>
  47. <td>'.$pvp['kill_count'].'</td>
  48. <td>'.$pvp['emperium_damage'].'</td>
  49. <td>'.$pvp['barricade_damage'].'</td>
  50. <td>'.$pvp['emperium_kill'].'</td>
  51.  
  52. </tr>
  53. ';
  54.  
  55. $pos++;
  56. }
  57. ?>
  58. </table>
  59. </div>
  60.  
  61. </body>
  62. </html
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement