Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- $connecta = mysql_connect('localhost','','');
- $db = mysql_select_db('ragnarok');
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <link rel="stylesheet" type="text/css" href="estilo.css" />
- <title>Ranking PvP Mooka</title>
- </head>
- <body>
- <h1 align="center">Detalhes WOE</h1><br>
- <div id="ranking">
- <table border="0" cellpadding="0" cellspacing="0">
- <tr align="center" id="title">
- <td>Nome</td>
- <td>Guild</td>
- <td>Matou</td>
- <td>Dano Emperium</td>
- <td>Dano Barricadas</td>
- <td>Emperium Break</td>
- </tr>
- <?PHP
- SELECT
- users.name,
- chars.*,
- guild.name as 'guild_name'
- FROM
- char_wstats as chars
- JOIN pvpm_data as users ON chars.char_id = users.id
- JOIN guild ON chars.char_id = guild.char_id
- ORDER BY
- chars.kill_count DESC
- LIMIT 50
- $pos = 1;
- while($pvp = mysql_fetch_assoc($tabela)){
- echo '
- <tr align="center" id="player">
- <td>'.$pvp['name'].'</td>
- <td>'.$pvp['guild_name'].'</td>
- <td>'.$pvp['kill_count'].'</td>
- <td>'.$pvp['emperium_damage'].'</td>
- <td>'.$pvp['barricade_damage'].'</td>
- <td>'.$pvp['emperium_kill'].'</td>
- </tr>
- ';
- $pos++;
- }
- ?>
- </table>
- </div>
- </body>
- </html
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement