Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div id="wrapper">
- <div id="title">Change Character Race</div>
- <form action="functions/race.php" method="POST">
- Select a character<br>
- <select name="selectacc">
- <option value="" disabled selected>Select Account</option>
- <?php
- $conn = new mysqli($host, $dbuser, $dbpass, $authdb);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT id, username FROM account";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- echo "<option value='" . $row["id"]. "'>" . $row['username'] . "</option>";
- }
- } else {
- echo "<option value='' disabled>No characters avalible</option>";
- }
- $conn->close();
- ?>
- </select><br>
- <select name="selectchar">
- <option value="">Select Char</option>
- <!-- Här behövs en jQuery som ska selecta name från characters där account id = resultat från <select name="selectacc"> -->
- </select>
- <select name="race">
- <option value="1">Human</option>
- <option value="2">Orc</option>
- <option value="3">Dwarf</option>
- <option value="4">Night Elf</option>
- <option value="5">Undead</option>
- <option value="6">Tauren</option>
- <option value="7">Gnome</option>
- <option value="8">Troll</option>
- <option value="10">Blood Elf</option>
- <option value="11">Draenei</option>
- </select>
- <br>
- <input type="submit" value="Change Race">
- </form>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement