Starting Gear Query Generator

**_duracell** · 11-04-2007

What It Does: It's an easy way to generate SQL queries for adding starting gear by class. Code is generated via PHP that adds the data into the playercreateinfo_items table. This is compatible with the latest NCDB milestone 0.2.2

How to Use It: Select the class from the dropdown. Then, look up the item id you wish to add, and enter it. Next, select the slot the item goes into. Finally, enter the quantity. Click submit and the SQL code will be generated below it. Copy & paste the code into your MySQL client query or save it as an .sql file and execute that.

Upcoming Changes: I plan on adding support for multiple item entries at once, sometime in the future. Also, creating a generator for starting spells and skills, which is pretty much the same concept.

Working Example: ORN - SQL Generator

Source Code:

Code:

<!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=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>

**Gastricpenguin** · 11-04-2007

Very Very nice! Im going to upload a page on my website that everyone can use.
+4 rep

**_duracell** · 11-04-2007

Glad I could help. I've been using it for a while on my own server, thought I'd share.

Feel free to spice it up too

I just made it really vanilla.

**Gastricpenguin** · 11-04-2007

Done! Check out Gastricpenguin Developement now!

I left you a little note on the Server Tools page Lolk2

**_duracell** · 11-05-2007

Nicely done!

**diogolinheiro** · 11-05-2007

wow thats awsome =O

**Blindgunner** · 11-14-2007

LEACHED from EMUPEDIA

Emupedia

dont give him rep

Shout-Out

User Tag List

Thread: Starting Gear Query Generator

Thread Tools

Search Thread

Starting Gear Query Generator

Re: Starting Gear Query Generator

Re: Starting Gear Query Generator

Re: Starting Gear Query Generator

Re: Starting Gear Query Generator

Re: Starting Gear Query Generator

Re: Starting Gear Query Generator

Similar Threads

New Player starting gear?

[Guide/Release] Rogue Gear/Query

[Release] Starting Gear Query Generator (May be Updated)

[Release] Illidan's Starting Gear, Weapons, Skills + Quest

Starting Gear! For your Server!

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino