Code:
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ORN - SQL Generator</title>
</head>
<body>
<?
$war = array(1,2,3,4,5,6,7,8,44,56);
$pally = array(9,10,45,50);
$hunter = array(11,12,15,16,17,46,51);
$rogue = array(18,19,20,21,22,23,24,52);
$priest = array(25,26,27,28,29,47,53);
$shammy = array(30,31,32,48);
$mage = array(34,35,36,37,49,54);
$lock = array(38,39,40,41,55);
$druid = array(42,43);
$all = array_merge($war, $pally, $hunter, $rogue, $priest, $shammy, $mage, $lock, $druid);
?>
<form action="pvp.php" method="post" enctype="multipart/form-data" name="form">
<input name="hid" type="hidden" value="hid" />
Class: <select name="class" size="1">
<option value="war">Warrior</option>
<option value="pally">Paladin</option>
<option value="hunter">Hunter</option>
<option value="rogue">Rogue</option>
<option value="priest">Priest</option>
<option value="shammy">Shaman</option>
<option value="mage">Mage</option>
<option value="lock">Warlock</option>
<option value="druid">Druid</option>
<option value="all">All</option>
</select><br /><br />
Item ID: <input name="item" type="text" value="<? if($_POST['item'] != '') { echo $_POST['item']; } ?>" /><br /><br />
Slot: <select name="slot" size="1">
<option value="0">Head</option>
<option value="1">Neck</option>
<option value="2">Shoulders</option>
<option value="3">Body</option>
<option value="4">Chest</option>
<option value="5">Waist</option>
<option value="6">Legs</option>
<option value="7">Feet</option>
<option value="8">Wrists</option>
<option value="9">Hands</option>
<option value="10">Finger1</option>
<option value="11">Finger2</option>
<option value="12">Trinket1</option>
<option value="13">Trinket2</option>
<option value="14">Back</option>
<option value="15">Mainhand</option>
<option value="16">Offhand</option>
<option value="17">Ranged</option>
<option value="18">Tabard</option>
<option value="19">Bag Slot 1</option>
<option value="20">Bag Slot 2</option>
<option value="21">Bag Slot 3</option>
<option value="22">Bag Slot 4</option>
<option value="23">Backpack Slot 1</option>
<option value="24">Backpack Slot 2</option>
<option value="25">Backpack Slot 3</option>
<option value="26">Backpack Slot 4</option>
<option value="27">Backpack Slot 5</option>
<option value="28">Backpack Slot 6</option>
<option value="29">Backpack Slot 7</option>
<option value="30">Backpack Slot 8</option>
<option value="31">Backpack Slot 9</option>
<option value="32">Backpack Slot 10</option>
<option value="33">Backpack Slot 11</option>
<option value="34">Backpack Slot 12</option>
<option value="35">Backpack Slot 13</option>
<option value="36">Backpack Slot 14</option>
<option value="37">Backpack Slot 15</option>
<option value="38">Backpack Slot 16</option>
</select><br /><br />
Quantity: <input name="quantity" type="text" value="<? if($_POST['quantity'] != '') { echo $_POST['quantity']; } else { echo '1'; } ?>" /><br /><br />
<input name="Submit" type="submit" value="Submit" /><br /><br /><br /><br />
<?
if($_POST['hid'] != '') {
$vclass = $_POST['class'];
$vc = $$vclass;
$outp = '';
for($i=0;$i<=sizeof($vc)-1;$i++) {
$outp .= "INSERT INTO playercreateinfo_items VALUES ('" . $vc[$i] . "', '" . $_POST['item'] . "', '" . $_POST['slot'] . "', '" . $_POST['quantity'] . "');\n";
}
echo '<textarea name="output" cols="130" rows="20">' . $outp . '</textarea>';
}
?>
</form>
</body>
</html>