PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[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.

[wolfwalkereci]

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]

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.

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]

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