Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Account</title>
- </head>
- <body>
- <form method="POST" name="account" action="karakter-stat.php">
- <input type="text" name="account" /><br />
- <input type="submit" name="submit" value="Küldés" />
- </form>
- </body>
- </html>
- <?php
- $host = "127.0.0.1";
- $user = "root";
- $pass = "";
- $db_auth = "realmd";
- $db_char = "characters1";
- $account_name = $_POST['account'];
- mysql_connect($host,$user,$pass) or die(mysql_error());
- mysql_select_db($db_auth) or die(mysql_error());
- $account_id = mysql_query("SELECT `id` FROM `account` WHERE `username` = $account_name") or die(mysql_error());
- mysql_select_db($db_char) or die(mysql_error());
- $acc_chars = mysql_query("SELECT `name`, `level`, `race`, `class`, `copper`, `gender` FROM `characters` WHERE `account` = $account_id") or die(mysql_error());
- while($result = $mysql_fetch_array($acc_chars)) {
- print "<p>" . $result['name'] . "</p>
- <p>" . $result['level'] . "</p>";
- $race = $result['race'];
- $class = $result['class'];
- $gender = $result['gender'];
- switch($race) {
- case 1: //RACE ID
- if ($gender == 0) {
- print "<p><img src=\"images/human_m.png\"";
- } else {
- print "<p><img src=\"images/human_f.png\"";
- }
- break;
- case 3:
- if ($gender == 0) {
- print "<p><img src=\"images/dwarf_m.png\"";
- } else {
- print "<p><img src=\"images/dwarf_f.png\"";
- }
- break;
- case 7:
- if ($gender == 0) {
- print "<p><img src=\"images/gnome_m.png\"";
- } else {
- print "<p><img src=\"images/gnome_f.png\"";
- }
- break;
- case 11:
- if ($gender == 0) {
- print "<p><img src=\"images/draenei_m.png\"";
- } else {
- print "<p><img src=\"images/draenei_f.png\"";
- }
- break;
- case 4:
- if ($gender == 0) {
- print "<p><img src=\"images/nelf_m.png\"";
- } else {
- print "<p><img src=\"images/nelf_f.png\"";
- }
- break;
- case 2:
- if ($gender == 0) {
- print "<p><img src=\"images/orc_m.png\"";
- } else {
- print "<p><img src=\"images/orc_f.png\"";
- }
- break;
- case 8:
- if ($gender == 0) {
- print "<p><img src=\"images/troll_m.png\"";
- } else {
- print "<p><img src=\"images/troll_f.png\"";
- }
- break;
- case 6:
- if ($gender == 0) {
- print "<p><img src=\"images/tauren_m.png\"";
- } else {
- print "<p><img src=\"images/tauren_f.png\"";
- }
- break;
- case 10:
- if ($gender == 0) {
- print "<p><img src=\"images/belf_m.png\"";
- } else {
- print "<p><img src=\"images/belf_f.png\"";
- }
- break;
- case 5:
- if ($gender == 0) {
- print "<p><img src=\"images/undead_m.png\"";
- } else {
- print "<p><img src=\"images/undead_f.png\"";
- }
- break;
- }
- switch($class) {
- case 1: //CLASS ID
- print "<img src=\"images/warrior.png\"</p>";
- break;
- case 2:
- print "<img src=\"images/paladin.png\"</p>";
- break;
- case 4:
- print "<img src=\"images/rogue.png\"</p>";
- break;
- case 3:
- print "<img src=\"images/hunter.png\"</p>";
- break;
- case 5:
- print "<img src=\"images/priest.png\"</p>";
- break;
- case 8:
- print "<img src=\"images/mage.png\"</p>";
- break;
- case 9:
- print "<img src=\"images/warlock.png\"</p>";
- break;
- case 6:
- print "<img src=\"images/dk.png\"</p>";
- break;
- case 7:
- print "<img src=\"images/shaman.png\"</p>";
- break;
- case 11:
- print "<img src=\"images/druid.png\"</p>";
- break;
- }
- $copper_origi = $result['copper'];
- $gold = $copper_origi / 10000;
- $silver = $copper_origi / 100;
- $copper = $copper_origi / 100;
- print "<p>Money: <b>$gold</b><img src=\"images/gold.png\"> <b>$silver</b><img src=\"images/silver.png\"> <b>$copper</b></p>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement