PEQ Database Editor 1.0 (for servers 0.6.4 and up)

wolfwalkereci · #1 07-21-2013, 03:12 PM

Was looking at something else inside the editor and discovered why on creation I was not seeing special_abilities saved to the npc.
So until you can get support in for the params here is another patch which corrects that issue.

Code:

Index: templates/npc/npc.add.tmpl.php
===================================================================
--- templates/npc/npc.add.tmpl.php    (revision 370)
+++ templates/npc/npc.add.tmpl.php    (working copy)
@@ -146,45 +146,45 @@
             <table cellpadding="20px">
               <tr>
                 <td valign="top" align="left">
-                  <input type="checkbox" name="S" value="S"/> Summon<br/>
-                  <input type="checkbox" name="E" value="E"/> Enrage<br/>
-                  <input type="checkbox" name="R" value="R"/> Rampage<br/>
-                  <input type="checkbox" name="r" value="r"/> AE Rampage<br/>
-                  <input type="checkbox" name="F" value="F"/> Flurry<br/>
-                  <input type="checkbox" name="T" value="T"/> Triple Attack<br/>
-                  <input type="checkbox" name="Q" value="Q"/> Quad Attack<br/>
-                  <input type="checkbox" name="m" value="m"/> Magic Attack<br/>
-                  <input type="checkbox" name="b" value="b"/> Bane Attack<br/>
-                  <input type="checkbox" name="L" value="L"/> Dual Wield<br/>
-                  <input type="checkbox" name="Y" value="Y"/> Ranged Attack<br/>
+                  <input type="checkbox" name="1,1^" value="1,1^"/> Summon<br/>
+                  <input type="checkbox" name="2,1^" value="2,1^"/> Enrage<br/>
+                  <input type="checkbox" name="3,1^" value="3,1^"/> Rampage<br/>
+                  <input type="checkbox" name="4,1^" value="4,1^"/> AE Rampage<br/>
+                  <input type="checkbox" name="5,1^" value="5,1^"/> Flurry<br/>
+                  <input type="checkbox" name="6,1^" value="6,1^"/> Triple Attack<br/>
+                  <input type="checkbox" name="7,1^" value="7,1^"/> Quad Attack<br/>
+                  <input type="checkbox" name="10,1^" value="10,1^"/> Magic Attack<br/>
+                  <input type="checkbox" name="9,1" value="9,1"/> Bane Attack<br/>
+                  <input type="checkbox" name="8,1^" value="8,1^"/> Dual Wield<br/>
+                  <input type="checkbox" name="11,1^" value="11,1^"/> Ranged Attack<br/>
                 </td>
                 <td valign="top" align="left">
-                  <input type="checkbox" name="U" value="U"/> Unslowable<br/>
-                  <input type="checkbox" name="M" value="M"/> Unmezable<br/>
-                  <input type="checkbox" name="C" value="C"/> Uncharmable<br/>
-                  <input type="checkbox" name="N" value="N"/> Unstunable<br/>
-                  <input type="checkbox" name="I" value="I"/> Unsnareable<br/>
-                  <input type="checkbox" name="D" value="D"/> Unfearable<br/>
-                  <input type="checkbox" name="p" value="p"/> Unpacifiable<br/>
-                  <input type="checkbox" name="K" value="K"/> Immune to Dispell<br/>
-                  <input type="checkbox" name="Z" value="Z"/> No Harm from Players<br/>
-                  <input type="checkbox" name="g" value="g"/> Resist Ranged Spells<br/>
-                  <input type="checkbox" name="t" value="t"/> Tunnel Vision<br/>
-                  <input type="checkbox" name="i" value="i"/> Immune to Taunt<br/>
+                  <input type="checkbox" name="12,1^" value="12,1^"/> Unslowable<br/>
+                  <input type="checkbox" name="13,1^" value="13,1^"/> Unmezable<br/>
+                  <input type="checkbox" name="14,1^" value="14,1^"/> Uncharmable<br/>
+                  <input type="checkbox" name="15,1^" value="15,1^"/> Unstunable<br/>
+                  <input type="checkbox" name="16,1^" value="16,1^"/> Unsnareable<br/>
+                  <input type="checkbox" name="17,1^" value="17,1^"/> Unfearable<br/>
+                  <input type="checkbox" name="31,1^" value="31,1^"/> Unpacifiable<br/>
+                  <input type="checkbox" name="18,1^" value="18,1^"/> Immune to Dispell<br/>
+                  <input type="checkbox" name="35,1^" value="35,1^"/> No Harm from Players<br/>
+                  <input type="checkbox" name="26,1^" value="26,1^"/> Resist Ranged Spells<br/>
+                  <input type="checkbox" name="29,1^" value="29,1^"/> Tunnel Vision<br/>
+                  <input type="checkbox" name="28,1^" value="28,1^"/> Immune to Taunt<br/>
                 </td>
                 <td valign="top" align="left">
-                  <input type="checkbox" name="A" value="A"/> Immune to Melee<br/>
-                  <input type="checkbox" name="B" value="B"/> Immune to Magic<br/>
-                  <input type="checkbox" name="f" value="f"/> Immune to Fleeing<br/>
-                  <input type="checkbox" name="W" value="W"/> Immune to non-Magical Melee<br/>
-                  <input type="checkbox" name="O" value="O"/> Immune to non-Bane Melee<br/>
-                  <input type="checkbox" name="H" value="H"/> Will Not Aggro<br/>
-                  <input type="checkbox" name="G" value="G"/> Immune to Aggro<br/>
-                  <input type="checkbox" name="d" value="d"/> See through Feign Death<br/>
+                  <input type="checkbox" name="19,1^" value="19,1^"/> Immune to Melee<br/>
+                  <input type="checkbox" name="20,1^" value="20,1^"/> Immune to Magic<br/>
+                  <input type="checkbox" name="21,1^" value="21,1^"/> Immune to Fleeing<br/>
+                  <input type="checkbox" name="23,1^" value="23,1^"/> Immune to non-Magical Melee<br/>
+                  <input type="checkbox" name="22,1^" value="22,1^"/> Immune to non-Bane Melee<br/>
+                  <input type="checkbox" name="24,1^" value="24,1^"/> Will Not Aggro<br/>
+                  <input type="checkbox" name="25,1^" value="25,1^"/> Immune to Aggro<br/>
+                  <input type="checkbox" name="27,1^" value="27,1^"/> See through Feign Death<br/>
                   <input type="checkbox" name="npc_aggro" value="1"<?echo ($npc_aggro == 1) ? "checked" : "";?>/> Can Aggro NPCs<br/>
-                  <input type="checkbox" name="n" value="n"> Does NOT buff/heal friends<br/>
-                  <input type="checkbox" name="j" value="j" onClick="sanityCheck();"/> Tethered<br/>
-                  <input type="checkbox" name="J" value="J" onClick="sanityCheck();"/> Leashed<br/>
+                  <input type="checkbox" name="30,1^" value="30,1^"> Does NOT buff/heal friends<br/>
+                  <input type="checkbox" name="33,1^" value="33,1^" onClick="sanityCheck();"/> Tethered<br/>
+                  <input type="checkbox" name="32,1^" value="32,1^" onClick="sanityCheck();"/> Leashed<br/>
                 </td>
               </tr>
             </table>

**cavedude** · #2 07-24-2013, 01:16 PM

The newest editor has quick support added for special abilities (including editing those with params) and also lua quests. It's up on SVN now, or the daily dump can be grabbed tomorrow.

wolfwalkereci · #3 07-24-2013, 09:36 PM

Quote:

Originally Posted by cavedude

The newest editor has quick support added for special abilities (including editing those with params) and also lua quests. It's up on SVN now, or the daily dump can be grabbed tomorrow.

Great news! Thanks to those that actually know what they are doing with the editor. Love that tool.

wolfwalkereci · #4 07-29-2013, 07:58 AM

Cavedude or KLS
Another thing I noticed was adding lootdrops either did not let you specify mindrop, droplimit, multiplier, probability or if it did would ignore your input.

I understand that PEQ DB pulls everything off of magelo now in terms of the loot but for doing custom loot it was annoying to have to create then edit.
Not sure if this is correct but it works and here is a patch against r371.
Just noticed r372 is on svn but nothing effected by this patch was touched in r372.

Code:

Index: templates/loot/lootdrop.add.tmpl.php
===================================================================
--- templates/loot/lootdrop.add.tmpl.php    (revision 371)
+++ templates/loot/lootdrop.add.tmpl.php    (working copy)
@@ -13,13 +13,13 @@
               Suggested Name:<br>
               <input type="text" name="name" size="25" value="<?=$name?>"><br><br>
               Mindrop: <br>
-              <input type="text" name="mindrop" size="25" value="0"><br><br>
+              <input type="text" name="mindrop" size="25" value="<?=$mindrop?>"><br><br>
               Droplimit: <br>
-              <input type="text" name="droplimit" size="25" value="0"><br><br>
+              <input type="text" name="droplimit" size="25" value="<?=$droplimit?>"><br><br>
               Multiplier: <br>
-              <input type="text" name="multiplier" size="25" value="1"><br><br>
-        Probability: <br>
-              <input type="text" name="probability" size="25" value="100"><br><br>
+              <input type="text" name="multiplier" size="25" value="<?=$multiplier?>"><br><br>
+              Probability: <br>
+              <input type="text" name="probability" size="25" value="<?=$probability?>"><br><br>
               <center>
                 <input type="submit" name="submit" value="Submit Changes">
               </center>
Index: templates/loot/lootdrop.changebyid.tmpl.php
===================================================================
--- templates/loot/lootdrop.changebyid.tmpl.php    (revision 371)
+++ templates/loot/lootdrop.changebyid.tmpl.php    (working copy)
@@ -1,27 +1,27 @@
-       <table class="edit_form">
-         <tr>
-           <td class="edit_form_header">
-             Change Lootdrop
-           </td>
-         </tr>
-         <tr>
-           <td class="edit_form_content">
-             <form name="addlootdrop" method="post" action="index.php?editor=loot&z=<?=$currzone?>&zoneid=<?=$currzoneid?>&npcid=<?=$npcid?>&action=24">
-               <input type="hidden" name="ltid" value="<?=$ltid?>">
-               Enter Lootdrop ID:<br>
-               <input type="text" name="ldid" size="10"><br><br>
-               Mindrop: <br>
-               <input type="text" name="mindrop" size="5" value="0"><br><br>
-               Droplimit: <br>
-               <input type="text" name="droplimit" size="5" value="0"><br><br>
-               Multiplier: <br>
-               <input type="text" name="multiplier" size="5" value="1"><br><br>
-         Probability: <br>
-               <input type="text" name="probability" size="5" value="100"><br><br>
-               <center>
-                 <input type="submit">
-               </center>
-             </form>
-           </td>
-         </tr>
-       </table>
+       <table class="edit_form">
+         <tr>
+           <td class="edit_form_header">
+             Change Lootdrop
+           </td>
+         </tr>
+         <tr>
+           <td class="edit_form_content">
+             <form name="addlootdrop" method="post" action="index.php?editor=loot&z=<?=$currzone?>&zoneid=<?=$currzoneid?>&npcid=<?=$npcid?>&action=24">
+               <input type="hidden" name="ltid" value="<?=$ltid?>">
+               Enter Lootdrop ID:<br>
+               <input type="text" name="ldid"><br><br>
+               Probability:<br>
+               <input type="text" name="probability"><br><br>
+               Multiplier:<br>
+               <input type="text" name="multiplier"><br><br>
+               Droplimit:<br>
+               <input type="text" name="droplimit"><br><br>
+               Mindrop:<br>
+               <input type="text" name="mindrop"><br><br>
+               <center>
+                 <input type="submit">
+               </center>
+             </form>
+           </td>
+         </tr>
+       </table>
Index: templates/loot/lootdrop.changebysearch.tmpl.php
===================================================================
--- templates/loot/lootdrop.changebysearch.tmpl.php    (revision 371)
+++ templates/loot/lootdrop.changebysearch.tmpl.php    (working copy)
@@ -11,9 +11,13 @@
                Lootdrop ID:<br>
                <input type="text" name="ldid" value="<?=$ldid?>"><br><br>
                Probability:<br>
-               <input type="text" name="prob"><br><br>
+               <input type="text" name="probability"><br><br>
                Multiplier:<br>
-               <input type="text" name="mult"><br><br>
+               <input type="text" name="multiplier"><br><br>
+               Droplimit:<br>
+               <input type="text" name="droplimit"><br><br>
+               Mindrop:<br>
+               <input type="text" name="mindrop"><br><br>
                <center>
                  <input type="submit">
                </center>
Index: templates/loot/loottable.edit.entry.tmpl.php
===================================================================
--- templates/loot/loottable.edit.entry.tmpl.php    (revision 371)
+++ templates/loot/loottable.edit.entry.tmpl.php    (working copy)
@@ -9,8 +9,10 @@
             <strong>LootTable:</strong> <?=$ltid?><br>
             <strong>LootDrop:</strong> <?=$ldid?><br><br>
             <form name="loottable" id="loottable" method="post" action="index.php?editor=loot&z=<?=$currzone?>&zoneid=<?=$currzoneid?>&action=8&npcid=<?=$npcid?>&ltid=<?=$ltid?>&ldid=<?=$ldid?>">
-              Probability: <br><input type="text" name="prob" value="<?=$probability?>"><br><br>
-              Multiplier: <br><input type="text" name="mult" value="<?=$multiplier?>"><br><br>
+              Probability: <br><input type="text" name="probability" value="<?=$probability?>"><br><br>
+              Multiplier: <br><input type="text" name="multiplier" value="<?=$multiplier?>"><br><br>
+              Droplimit: <br><input type="text" name="droplimit" value="<?=$droplimit?>"><br><br>
+              Mindrop: <br><input type="text" name="mindrop" value="<?=$mindrop?>"><br><br>
               <center>
                 <input type="submit" name="submit" value="Submit Changes">
               </center>

**cavedude** · #5 07-29-2013, 10:24 AM

Could you tell me exactly where the problem is? It seems to be working fine for me.