[Archive] Starting Gear Query Generator
[Archive] Starting Gear Query Generator
11-04-2025, 12:46 PM
Original source
Quote: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>
rektbyfaith
11-04-2025, 12:46 PM #1Archived author: _duracell • Posted: 2025-11-04T13:46:15.282828
Original source
Quote: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>
11-04-2025, 12:46 PM
Original source
Quote:Very Very nice! Im going to upload a page on my website that everyone can use.
+4 rep
rektbyfaith
11-04-2025, 12:46 PM #2Archived author: Gastricpenguin • Posted: 2025-11-04T13:46:15.282828
Original source
Quote:Very Very nice! Im going to upload a page on my website that everyone can use.
+4 rep
11-04-2025, 12:46 PM
Original source
Quote: 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 tooI just made it really vanilla.
rektbyfaith
11-04-2025, 12:46 PM #3Archived author: _duracell • Posted: 2025-11-04T13:46:15.282828
Original source
Quote: 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
11-04-2025, 12:46 PM
Original source
Quote:Done! Check out Gastricpenguin Developement now!
I left you a little note on the Server Tools page Lolk2
![[Image: biggrin.png]](https://www.ownedcore.com/forums/images/smilies/biggrin.png)
rektbyfaith
11-04-2025, 12:46 PM #4Archived author: Gastricpenguin • Posted: 2025-11-04T13:46:15.282828
Original source
Quote:Done! Check out Gastricpenguin Developement now!
I left you a little note on the Server Tools page Lolk2
11-04-2025, 12:46 PM
Original source
Quote: Nicely done!
rektbyfaith
11-04-2025, 12:46 PM #5Archived author: _duracell • Posted: 2025-11-04T13:46:15.282828
Original source
Quote: Nicely done!
11-04-2025, 12:46 PM
Original source
Quote: wow thats awsome =O
rektbyfaith
11-04-2025, 12:46 PM #6Archived author: diogolinheiro • Posted: 2025-11-04T13:46:15.282828
Original source
Quote: wow thats awsome =O
11-04-2025, 12:46 PM
Original source
Quote: LEACHED from EMUPEDIA
Emupedia
dont give him rep
rektbyfaith
11-04-2025, 12:46 PM #7Archived author: Blindgunner • Posted: 2025-11-04T13:46:15.282828
Original source
Quote: LEACHED from EMUPEDIA
Emupedia
dont give him rep
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)