ArcEmu: Starting Gear Generator - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Starting Gear Generator WIP - NOT READY FOR USE

#1 User is offline   dbrown1986 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 264
  • Joined: 13-December 08
  • Gender:Male
  • Location:In Oblivion...
  • Interests:Computers & College.

Posted 12 October 2009 - 11:49 PM

Updated arrays of old script for people,

Nevermind the title of this thread, this script is now Gold..

<!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);
$deathknight =array (56, 57, 58, 59, 60, 61, 62, 63, 64, 65);
$all = array_merge($war, $pally, $hunter, $rogue, $priest, $shammy, $mage, $lock, $druid, $deathknight);
?>

<form action=\"viewpage.php?page_id=32\" 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=\"deathknight">Death Knight</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=\"70\" rows=\"20\">\' . $outp . \'</textarea>\';
    }
?>
</form>
</body>
</html></center>


I cannot give original credits on this as the file came with my CMS and does not have any credits. Thx to whomever created it though.

This post has been edited by dbrown1986: 13 October 2009 - 07:49 AM

Posted Image

Posted Image
Posted Image

Save yourself a post, ask your questions here!
0

#2 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 13 October 2009 - 03:59 PM

What exactly is this supposed to do?
0

#3 User is offline   Cele 

  • Member
  • Pip
  • Group: Members
  • Posts: 83
  • Joined: 04-August 08
  • Gender:Male

Posted 13 October 2009 - 07:45 PM

From reading over it, it looks like you select a race, then you select the slot then put in an item id for that class to start with.
0

#4 User is offline   dbrown1986 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 264
  • Joined: 13-December 08
  • Gender:Male
  • Location:In Oblivion...
  • Interests:Computers & College.

Posted 13 October 2009 - 11:11 PM

Use as an include or make your own php file with this in it and it does exactly what he said

you choose a class, an item, the slot and the quantity then it generates SQL queries that you import into playercreateinfo_items to give new players the specified item id.
Posted Image

Posted Image
Posted Image

Save yourself a post, ask your questions here!
0

#5 User is offline   Bob Herman 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 452
  • Joined: 11-October 08
  • Gender:Male

Posted 14 October 2009 - 03:53 PM

Mhmm, that's what I thought. But what's the point of this? You could just have a person start with an item using the database only.
0

#6 User is offline   dbrown1986 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 264
  • Joined: 13-December 08
  • Gender:Male
  • Location:In Oblivion...
  • Interests:Computers & College.

Posted 15 October 2009 - 02:00 PM

The point of this = n00b friendly script. A person who does not now the race/class combination array can simply generate the queries using this tool and import them, it may also help them learn which arrays belong to which race and class.
Posted Image

Posted Image
Posted Image

Save yourself a post, ask your questions here!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users