Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #181  
Old 11-11-2013, 06:10 AM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

A few more edits / tweaks that might seem useful / helpful for people.

Augtypes up to 30

Add "_copy" to items and spells that are copied using the copy button.
(I cant count the number of times I edited the same item because I forgot to copy -- this helps remind you it was copied)


js.tmpl.php
Code:
--- "templates\iframes\js.tmpl.php"
+++ "templates\iframes\js.tmpl.php"
@@ -120,5 +120,15 @@
 form.augtype_Type_18.checked = form.all_none5.checked ;
 form.augtype_Type_19.checked = form.all_none5.checked ;
 form.augtype_Type_20.checked = form.all_none5.checked ;
+form.augtype_Type_21.checked = form.all_none5.checked ;
+form.augtype_Type_22.checked = form.all_none5.checked ;
+form.augtype_Type_23.checked = form.all_none5.checked ;
+form.augtype_Type_24.checked = form.all_none5.checked ;
+form.augtype_Type_25.checked = form.all_none5.checked ;
+form.augtype_Type_26.checked = form.all_none5.checked ;
+form.augtype_Type_27.checked = form.all_none5.checked ;
+form.augtype_Type_28.checked = form.all_none5.checked ;
+form.augtype_Type_29.checked = form.all_none5.checked ;
+form.augtype_Type_30.checked = form.all_none5.checked ;
 }
 </script>
\ No newline at end of file

Add "_copy" to spell name that is copied!

Code:
--- "lib\spells.php"
+++ "lib\spells.php"
@@ -184,6 +184,9 @@
   
   $query2 = "INSERT INTO spells_new ($fields, id) SELECT $fields, $newid AS id FROM spells_new WHERE id = '$id'";
   $mysql->query_no_result($query2);
+  $query3 = "UPDATE spells_new SET name = concat(Name, '_copy') WHERE id = $newid";
+  $mysql->query_no_result($query3);
+  
 
   return $newid;
 }

Add the augtypes to the add and edit templates

Code:
--- "templates\items\items.add.tmpl.php"
+++ "templates\items\items.add.tmpl.php"
@@ -795,8 +795,6 @@
                     <input type="checkbox" name="augtype_Type_2" value=2 <?echo ($augtype & 2) ? "checked" : ""?>> Type 2<br/>
                     <input type="checkbox" name="augtype_Type_3" value=4 <?echo ($augtype & 4) ? "checked" : ""?>> Type 3<br/>
                     <input type="checkbox" name="augtype_Type_4" value=8 <?echo ($augtype & 8) ? "checked" : ""?>> Type 4<br/>
-                  </td>
-                  <td valign="top" align="left"><br/>
                     <input type="checkbox" name="augtype_Type_5" value=16 <?echo ($augtype & 16) ? "checked" : ""?>> Type 5<br/>
                     <input type="checkbox" name="augtype_Type_6" value=32 <?echo ($augtype & 32) ? "checked" : ""?>> Type 6<br/>
                     <input type="checkbox" name="augtype_Type_7" value=64 <?echo ($augtype & 64) ? "checked" : ""?>> Type 7<br/>
@@ -807,8 +805,6 @@
                     <input type="checkbox" name="augtype_Type_10" value=512 <?echo ($augtype & 512) ? "checked" : ""?>> Type 10<br/>
                     <input type="checkbox" name="augtype_Type_11" value=1024 <?echo ($augtype & 1024) ? "checked" : ""?>> Type 11<br/>
                     <input type="checkbox" name="augtype_Type_12" value=2048 <?echo ($augtype & 2048) ? "checked" : ""?>> Type 12<br/>
-                  </td>
-                  <td valign="top" align="left"><br/>
                     <input type="checkbox" name="augtype_Type_13" value=4096 <?echo ($augtype & 4096) ? "checked" : ""?>> Type 13<br/>
                     <input type="checkbox" name="augtype_Type_14" value=8192 <?echo ($augtype & 8192) ? "checked" : ""?>> Type 14<br/>
                     <input type="checkbox" name="augtype_Type_15" value=16384 <?echo ($augtype & 16384) ? "checked" : ""?>> Type 15<br/>
@@ -819,9 +815,22 @@
                     <input type="checkbox" name="augtype_Type_18" value=131072 <?echo ($augtype & 131072) ? "checked" : ""?>> Type 18<br/>
                     <input type="checkbox" name="augtype_Type_19" value=262144 <?echo ($augtype & 262144) ? "checked" : ""?>> Type 19<br/>
                     <input type="checkbox" name="augtype_Type_20" value=524288 <?echo ($augtype & 524288) ? "checked" : ""?>> Type 20<br/>
+					<input type="checkbox" name="augtype_Type_21" value=1048576 <?echo ($augtype & 1048576) ? "checked" : ""?>> Type 21<br/>
+                    <input type="checkbox" name="augtype_Type_22" value=2097152 <?echo ($augtype & 2097152) ? "checked" : ""?>> Type 22<br/>
+                    <input type="checkbox" name="augtype_Type_23" value=4194304 <?echo ($augtype & 4194304) ? "checked" : ""?>> Type 23<br/>
+                    <input type="checkbox" name="augtype_Type_24" value=8388608 <?echo ($augtype & 8388608) ? "checked" : ""?>> Type 24<br/>
                   </td>
                   <td valign="top" align="left"><br/>
-                    <input type="checkbox" name="all_none5" value="yes" onClick="Check5(document.item_edit)"> <b>All/None</b>
+					<input type="checkbox" name="augtype_Type_25" value=16777216 <?echo ($augtype & 16777216) ? "checked" : ""?>> Type 25<br/>
+                    <input type="checkbox" name="augtype_Type_26" value=33554432 <?echo ($augtype & 33554432) ? "checked" : ""?>> Type 26<br/>
+                    <input type="checkbox" name="augtype_Type_27" value=67108864 <?echo ($augtype & 67108864) ? "checked" : ""?>> Type 27<br/>
+                    <input type="checkbox" name="augtype_Type_28" value=134217728 <?echo ($augtype & 134217728) ? "checked" : ""?>> Type 28<br/>
+					<input type="checkbox" name="augtype_Type_29" value=268435456 <?echo ($augtype & 268435456) ? "checked" : ""?>> Type 29<br/>
+                    <input type="checkbox" name="augtype_Type_30" value=536870912 <?echo ($augtype & 536870912) ? "checked" : ""?>> Type 30<br/>
+                  </td>
+                  <td valign="top" align="left">
+					 <br>
+                    <input type="checkbox" name="all_none5" value="yes" onClick="Check5(document.item_edit)"> <b>All/None</b><br/>
                   </td>
                 </tr>
               </table>
Code:
--- "templates\items\items.edit.tmpl.php"
+++ "templates\items\items.edit.tmpl.php"
@@ -738,8 +738,6 @@
                     <input type="checkbox" name="augtype_Type_2" value=2 <?echo ($augtype & 2) ? "checked" : ""?>> Type 2<br/>
                     <input type="checkbox" name="augtype_Type_3" value=4 <?echo ($augtype & 4) ? "checked" : ""?>> Type 3<br/>
                     <input type="checkbox" name="augtype_Type_4" value=8 <?echo ($augtype & 8) ? "checked" : ""?>> Type 4<br/>
-                  </td>
-                  <td valign="top" align="left"><br/>
                     <input type="checkbox" name="augtype_Type_5" value=16 <?echo ($augtype & 16) ? "checked" : ""?>> Type 5<br/>
                     <input type="checkbox" name="augtype_Type_6" value=32 <?echo ($augtype & 32) ? "checked" : ""?>> Type 6<br/>
                     <input type="checkbox" name="augtype_Type_7" value=64 <?echo ($augtype & 64) ? "checked" : ""?>> Type 7<br/>
@@ -750,8 +748,6 @@
                     <input type="checkbox" name="augtype_Type_10" value=512 <?echo ($augtype & 512) ? "checked" : ""?>> Type 10<br/>
                     <input type="checkbox" name="augtype_Type_11" value=1024 <?echo ($augtype & 1024) ? "checked" : ""?>> Type 11<br/>
                     <input type="checkbox" name="augtype_Type_12" value=2048 <?echo ($augtype & 2048) ? "checked" : ""?>> Type 12<br/>
-                  </td>
-                  <td valign="top" align="left"><br/>
                     <input type="checkbox" name="augtype_Type_13" value=4096 <?echo ($augtype & 4096) ? "checked" : ""?>> Type 13<br/>
                     <input type="checkbox" name="augtype_Type_14" value=8192 <?echo ($augtype & 8192) ? "checked" : ""?>> Type 14<br/>
                     <input type="checkbox" name="augtype_Type_15" value=16384 <?echo ($augtype & 16384) ? "checked" : ""?>> Type 15<br/>
@@ -762,9 +758,22 @@
                     <input type="checkbox" name="augtype_Type_18" value=131072 <?echo ($augtype & 131072) ? "checked" : ""?>> Type 18<br/>
                     <input type="checkbox" name="augtype_Type_19" value=262144 <?echo ($augtype & 262144) ? "checked" : ""?>> Type 19<br/>
                     <input type="checkbox" name="augtype_Type_20" value=524288 <?echo ($augtype & 524288) ? "checked" : ""?>> Type 20<br/>
+					<input type="checkbox" name="augtype_Type_21" value=1048576 <?echo ($augtype & 1048576) ? "checked" : ""?>> Type 21<br/>
+                    <input type="checkbox" name="augtype_Type_22" value=2097152 <?echo ($augtype & 2097152) ? "checked" : ""?>> Type 22<br/>
+                    <input type="checkbox" name="augtype_Type_23" value=4194304 <?echo ($augtype & 4194304) ? "checked" : ""?>> Type 23<br/>
+                    <input type="checkbox" name="augtype_Type_24" value=8388608 <?echo ($augtype & 8388608) ? "checked" : ""?>> Type 24<br/>
                   </td>
                   <td valign="top" align="left"><br/>
-                    <input type="checkbox" name="all_none5" value="yes" onClick="Check5(document.item_edit)"> <b>All/None</b>
+					<input type="checkbox" name="augtype_Type_25" value=16777216 <?echo ($augtype & 16777216) ? "checked" : ""?>> Type 25<br/>
+                    <input type="checkbox" name="augtype_Type_26" value=33554432 <?echo ($augtype & 33554432) ? "checked" : ""?>> Type 26<br/>
+                    <input type="checkbox" name="augtype_Type_27" value=67108864 <?echo ($augtype & 67108864) ? "checked" : ""?>> Type 27<br/>
+                    <input type="checkbox" name="augtype_Type_28" value=134217728 <?echo ($augtype & 134217728) ? "checked" : ""?>> Type 28<br/>
+					<input type="checkbox" name="augtype_Type_29" value=268435456 <?echo ($augtype & 268435456) ? "checked" : ""?>> Type 29<br/>
+                    <input type="checkbox" name="augtype_Type_30" value=536870912 <?echo ($augtype & 536870912) ? "checked" : ""?>> Type 30<br/>
+                  </td>
+                  <td valign="top" align="left">
+					 <br>
+                    <input type="checkbox" name="all_none5" value="yes" onClick="Check5(document.item_edit)"> <b>All/None</b><br/>
                   </td>
                 </tr>
               </table>

How all the augtypes look



New Augtypes and add "_copy" to the name of copied items

Code:
--- "lib\items.php"	
+++ "lib\items.php"	
@@ -366,6 +366,17 @@
   if (isset($_POST['augtype_Type_18'])) $augtype = $augtype+131072;
   if (isset($_POST['augtype_Type_19'])) $augtype = $augtype+262144;
   if (isset($_POST['augtype_Type_20'])) $augtype = $augtype+524288;
+  if (isset($_POST['augtype_Type_21'])) $augtype = $augtype+1048576;
+  if (isset($_POST['augtype_Type_22'])) $augtype = $augtype+2097152;
+  if (isset($_POST['augtype_Type_23'])) $augtype = $augtype+4194304;
+  if (isset($_POST['augtype_Type_24'])) $augtype = $augtype+8388608;
+  if (isset($_POST['augtype_Type_25'])) $augtype = $augtype+16777216;
+  if (isset($_POST['augtype_Type_26'])) $augtype = $augtype+33554432;
+  if (isset($_POST['augtype_Type_27'])) $augtype = $augtype+67108864;
+  if (isset($_POST['augtype_Type_28'])) $augtype = $augtype+134217728;
+  if (isset($_POST['augtype_Type_29'])) $augtype = $augtype+268435456;
+  if (isset($_POST['augtype_Type_30'])) $augtype = $augtype+536870912;
+  
   
   $fields = '';
   if ($item['slots'] != $slots) $fields .= "slots=\"$slots\", ";
@@ -568,7 +579,7 @@
    $mysql->query_no_result($query);
  
    $query2 = "INSERT INTO items (minstatus, Name, aagi, ac, accuracy, acha, adex, aint, artifactflag, asta, astr, attack, augrestrict, augslot1type, augslot1visible, augslot2type, augslot2visible, augslot3type, augslot3visible, augslot4type, augslot4visible, augslot5type, augslot5visible, augtype, avoidance, awis, bagsize, bagslots, bagtype, bagwr, banedmgamt, banedmgraceamt, banedmgbody, banedmgrace, bardtype, bardvalue, book, casttime, casttime_, charmfile, charmfileid, classes, color, combateffects, extradmgskill, extradmgamt, price, cr, damage, damageshield, deity, delay, augdistiller, dotshielding, dr, clicktype, clicklevel2, elemdmgtype, elemdmgamt, endur, factionamt1, factionamt2, factionamt3, factionamt4, factionmod1, factionmod2, factionmod3, factionmod4, filename, focuseffect, fr, fvnodrop, haste, clicklevel, hp, regen, icon, idfile, itemclass, itemtype, ldonprice, ldontheme, ldonsold, light, lore, loregroup, magic, mana, manaregen, enduranceregen, material, maxcharges, mr, nodrop, norent, pendingloreflag, pr, procrate, races, `range`, reclevel, recskill, reqlevel, sellrate, shielding, size, skillmodtype, skillmodvalue, slots, clickeffect, spellshield, strikethrough, stunresist, summonedflag, tradeskills, favor, weight, UNK012, UNK013, benefitflag, UNK054, UNK059, booktype, recastdelay, recasttype, guildfavor, UNK123, UNK124, attuneable, nopet, updated, comment, UNK127, pointtype, potionbelt, potionbeltslots, stacksize, notransfer, stackable, UNK134, UNK137, proceffect, proctype, proclevel2, proclevel, UNK142, worneffect, worntype, wornlevel2, wornlevel, UNK147, focustype, focuslevel2, focuslevel, UNK152, scrolleffect, scrolltype, scrolllevel2, scrolllevel, UNK157, serialized, verified, serialization, source, UNK033, lorefile, UNK014, svcorruption, UNK038, UNK060, augslot1unk2, augslot2unk2, augslot3unk2, augslot4unk2, augslot5unk2, UNK120, UNK121, questitemflag, UNK132, clickunk5, clickunk6, clickunk7, procunk1, procunk2, procunk3, procunk4, procunk6, procunk7, wornunk1, wornunk2, wornunk3, wornunk4, wornunk5, wornunk6, wornunk7, focusunk1, focusunk2, focusunk3, focusunk4, focusunk5, focusunk6, focusunk7, scrollunk1, scrollunk2, scrollunk3, scrollunk4, scrollunk5, scrollunk6, scrollunk7, UNK193, purity, evolvinglevel, clickname, procname, wornname, focusname, scrollname, dsmitigation, heroic_str, heroic_int, heroic_wis, heroic_agi, heroic_dex, heroic_sta, heroic_cha, heroic_pr, heroic_dr, heroic_fr, heroic_cr, heroic_mr, heroic_svcorrup, healamt, spelldmg, clairvoyance, backstabdmg, created, elitematerial, ldonsellbackrate, scriptfileid, expendablearrow, powersourcecapacity, bardeffect, bardeffecttype, bardlevel2, bardlevel, bardunk1, bardunk2, bardunk3, bardunk4,bardunk5, bardname, bardunk7, UNK214)
-	      SELECT minstatus, Name, aagi, ac, accuracy, acha, adex, aint, artifactflag, asta, astr, attack, augrestrict, augslot1type, augslot1visible, augslot2type, augslot2visible, augslot3type, augslot3visible, augslot4type, augslot4visible, augslot5type, augslot5visible, augtype, avoidance, awis, bagsize, bagslots, bagtype, bagwr, banedmgamt, banedmgraceamt, banedmgbody, banedmgrace, bardtype, bardvalue, book, casttime, casttime_, charmfile, charmfileid, classes, color, combateffects, extradmgskill, extradmgamt, price, cr, damage, damageshield, deity, delay, augdistiller, dotshielding, dr, clicktype, clicklevel2, elemdmgtype, elemdmgamt, endur, factionamt1, factionamt2, factionamt3, factionamt4, factionmod1, factionmod2, factionmod3, factionmod4, filename, focuseffect, fr, fvnodrop, haste, clicklevel, hp, regen, icon, idfile, itemclass, itemtype, ldonprice, ldontheme, ldonsold, light, lore, loregroup, magic, mana, manaregen, enduranceregen, material, maxcharges, mr, nodrop, norent, pendingloreflag, pr, procrate, races, `range`, reclevel, recskill, reqlevel, sellrate, shielding, size, skillmodtype, skillmodvalue, slots, clickeffect, spellshield, strikethrough, stunresist, summonedflag, tradeskills, favor, weight, UNK012, UNK013, benefitflag, UNK054, UNK059, booktype, recastdelay, recasttype, guildfavor, UNK123, UNK124, attuneable, nopet, updated, comment, UNK127, pointtype, potionbelt, potionbeltslots, stacksize, notransfer, stackable, UNK134, UNK137, proceffect, proctype, proclevel2, proclevel, UNK142, worneffect, worntype, wornlevel2, wornlevel, UNK147, focustype, focuslevel2, focuslevel, UNK152, scrolleffect, scrolltype, scrolllevel2, scrolllevel, UNK157, serialized, verified, serialization, source, UNK033, lorefile, UNK014, svcorruption, UNK038, UNK060, augslot1unk2, augslot2unk2, augslot3unk2, augslot4unk2, augslot5unk2, UNK120, UNK121, questitemflag, UNK132, clickunk5, clickunk6, clickunk7, procunk1, procunk2, procunk3, procunk4, procunk6, procunk7, wornunk1, wornunk2, wornunk3, wornunk4, wornunk5, wornunk6, wornunk7, focusunk1, focusunk2, focusunk3, focusunk4, focusunk5, focusunk6, focusunk7, scrollunk1, scrollunk2, scrollunk3, scrollunk4, scrollunk5, scrollunk6, scrollunk7, UNK193, purity, evolvinglevel, clickname, procname, wornname, focusname, scrollname, dsmitigation, heroic_str, heroic_int, heroic_wis, heroic_agi, heroic_dex, heroic_sta, heroic_cha, heroic_pr, heroic_dr, heroic_fr, heroic_cr, heroic_mr, heroic_svcorrup, healamt, spelldmg, clairvoyance, backstabdmg, created, elitematerial, ldonsellbackrate, scriptfileid, expendablearrow, powersourcecapacity, bardeffect, bardeffecttype, bardlevel2, bardlevel, bardunk1, bardunk2, bardunk3, bardunk4, bardunk5, bardname, bardunk7, UNK214 FROM items where id=$id";
+	      SELECT minstatus, concat(Name, '_copy'), aagi, ac, accuracy, acha, adex, aint, artifactflag, asta, astr, attack, augrestrict, augslot1type, augslot1visible, augslot2type, augslot2visible, augslot3type, augslot3visible, augslot4type, augslot4visible, augslot5type, augslot5visible, augtype, avoidance, awis, bagsize, bagslots, bagtype, bagwr, banedmgamt, banedmgraceamt, banedmgbody, banedmgrace, bardtype, bardvalue, book, casttime, casttime_, charmfile, charmfileid, classes, color, combateffects, extradmgskill, extradmgamt, price, cr, damage, damageshield, deity, delay, augdistiller, dotshielding, dr, clicktype, clicklevel2, elemdmgtype, elemdmgamt, endur, factionamt1, factionamt2, factionamt3, factionamt4, factionmod1, factionmod2, factionmod3, factionmod4, filename, focuseffect, fr, fvnodrop, haste, clicklevel, hp, regen, icon, idfile, itemclass, itemtype, ldonprice, ldontheme, ldonsold, light, lore, loregroup, magic, mana, manaregen, enduranceregen, material, maxcharges, mr, nodrop, norent, pendingloreflag, pr, procrate, races, `range`, reclevel, recskill, reqlevel, sellrate, shielding, size, skillmodtype, skillmodvalue, slots, clickeffect, spellshield, strikethrough, stunresist, summonedflag, tradeskills, favor, weight, UNK012, UNK013, benefitflag, UNK054, UNK059, booktype, recastdelay, recasttype, guildfavor, UNK123, UNK124, attuneable, nopet, updated, comment, UNK127, pointtype, potionbelt, potionbeltslots, stacksize, notransfer, stackable, UNK134, UNK137, proceffect, proctype, proclevel2, proclevel, UNK142, worneffect, worntype, wornlevel2, wornlevel, UNK147, focustype, focuslevel2, focuslevel, UNK152, scrolleffect, scrolltype, scrolllevel2, scrolllevel, UNK157, serialized, verified, serialization, source, UNK033, lorefile, UNK014, svcorruption, UNK038, UNK060, augslot1unk2, augslot2unk2, augslot3unk2, augslot4unk2, augslot5unk2, UNK120, UNK121, questitemflag, UNK132, clickunk5, clickunk6, clickunk7, procunk1, procunk2, procunk3, procunk4, procunk6, procunk7, wornunk1, wornunk2, wornunk3, wornunk4, wornunk5, wornunk6, wornunk7, focusunk1, focusunk2, focusunk3, focusunk4, focusunk5, focusunk6, focusunk7, scrollunk1, scrollunk2, scrollunk3, scrollunk4, scrollunk5, scrollunk6, scrollunk7, UNK193, purity, evolvinglevel, clickname, procname, wornname, focusname, scrollname, dsmitigation, heroic_str, heroic_int, heroic_wis, heroic_agi, heroic_dex, heroic_sta, heroic_cha, heroic_pr, heroic_dr, heroic_fr, heroic_cr, heroic_mr, heroic_svcorrup, healamt, spelldmg, clairvoyance, backstabdmg, created, elitematerial, ldonsellbackrate, scriptfileid, expendablearrow, powersourcecapacity, bardeffect, bardeffecttype, bardlevel2, bardlevel, bardunk1, bardunk2, bardunk3, bardunk4, bardunk5, bardname, bardunk7, UNK214 FROM items where id=$id";
    $mysql->query_no_result($query2);
    
    $query3 = "SELECT max(id) AS iid FROM items"; 
@@ -698,6 +709,16 @@
   if (isset($_POST['augtype_Type_18'])) $augtype = $augtype+131072;
   if (isset($_POST['augtype_Type_19'])) $augtype = $augtype+262144;
   if (isset($_POST['augtype_Type_20'])) $augtype = $augtype+524288;
+  if (isset($_POST['augtype_Type_21'])) $augtype = $augtype+1048576;
+  if (isset($_POST['augtype_Type_22'])) $augtype = $augtype+2097152;
+  if (isset($_POST['augtype_Type_23'])) $augtype = $augtype+4194304;
+  if (isset($_POST['augtype_Type_24'])) $augtype = $augtype+8388608;
+  if (isset($_POST['augtype_Type_25'])) $augtype = $augtype+16777216;
+  if (isset($_POST['augtype_Type_26'])) $augtype = $augtype+33554432;
+  if (isset($_POST['augtype_Type_27'])) $augtype = $augtype+67108864;
+  if (isset($_POST['augtype_Type_28'])) $augtype = $augtype+134217728;
+  if (isset($_POST['augtype_Type_29'])) $augtype = $augtype+268435456;
+  if (isset($_POST['augtype_Type_30'])) $augtype = $augtype+536870912;
   
   $fields = '';
   $fields .= "slots=\"$slots\", ";



This is just showing that an item can have up to 30 for augtype heh...






There is a way to have "Any augment type" which is Augtype -1 but I didn't add that.. but if someone else wants to add it that would be neato
Reply With Quote
  #182  
Old 11-11-2013, 07:33 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

Added with some very minor changes. Thanks!

Will have to discuss the -1 Augment type at some time as well.
Reply With Quote
  #183  
Old 01-06-2014, 11:53 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,595
Default

I'm currently having an issue with the PEQ Editor not having a login popup or anything, it is just a picture and the background, nothing more.
Reply With Quote
  #184  
Old 01-07-2014, 08:15 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

Discussed above and in the readme: most likely you forgot to turn on short open tags.
Reply With Quote
  #185  
Old 02-02-2014, 11:53 PM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

Would adding spawn2.version to the zonelist be something that would be helpful for anyone?

I have code for it.. just not sure if its too custom or whatever... :p


Here is what it looks like.... note I added $version (spawn2) to the searchbar for NPC editing

Reply With Quote
  #186  
Old 02-02-2014, 11:59 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

I have wanted to do something like that, it certainly will help for LDoN. I would definitely be interested in that code for inclusion in SVN.
Reply With Quote
  #187  
Old 02-03-2014, 12:41 AM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

The way I wrote it only works correctly with ... $npc_list = 2;

Gotta figure a way out to make it work with the other way as well.. but my brain huts from lack of sleep.. :p
Reply With Quote
  #188  
Old 02-03-2014, 01:14 AM
sorvani
Dragon
 
Join Date: May 2010
Posts: 965
Default

Yes, please. I been tinkering with Ikkinz stuff lately and it is apain in the ass to keep some things straight. But how would this code handle quest spawned? still have to hit the base version 0?
Reply With Quote
  #189  
Old 02-03-2014, 01:44 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

sorvani: Yes, I would have them under version 0 since they would be npc_types without a spawnpoint in the DB.

NatedogEZ: Share whatever you feel comfortable with. If it still needs work, one of us can finish it up.
Reply With Quote
  #190  
Old 02-03-2014, 08:16 PM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

I did something kinda stupid but it is sort of working in my favor lol... was using the variable $version for spawn2 version in the searchbar.. and forgot that npc_types has a version in the field list that uses it as the variable $version (doh)

The default database already has version set to npc_types in different versions which really helps and might be a better way to separate them.. but zone version

I think what I wrote though needs to be reconfigured to separate the variables.. so yeah.. doh :p
Reply With Quote
  #191  
Old 02-03-2014, 09:38 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Something to keep in mind. version in spawn2 is hard-fast. The server uses it so it has to be correct. However, version in npc_types is only used by us for organizational sake. It doesn't necessarily have to be correct. Meaning, a npc_type could have version in npc_types set to 0, even though it is in version 3 of the zone.

Also, a single NPC can be in multiple versions of a zone if it has multiple spawn points. That's where things get tricky with this :I
Reply With Quote
  #192  
Old 05-17-2014, 07:22 AM
Rhodan
Hill Giant
 
Join Date: Oct 2006
Posts: 179
Default

Is there something wrong with the svn? When I try to check out I get

Checkout from https://code.google.com/p/peqphpeditor, revision HEAD, Fully recursive, Externals included
Unable to connect to a repository at URL
'https://code.google.com/p/peqphpeditor'
Unexpected HTTP status 405 'Method Not Allowed' on '/p/peqphpeditor'

Additional errors:
OPTIONS request on '/p/peqphpeditor' failed: 405 Method Not Allowed
Thanks!
Reply With Quote
  #193  
Old 05-17-2014, 07:36 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,497
Default

I'm not having any issues with the SVN. Perhaps you had a connection issue.
Reply With Quote
  #194  
Old 05-17-2014, 07:49 AM
Rhodan
Hill Giant
 
Join Date: Oct 2006
Posts: 179
Default

I was able to update quests from svn. Don't know why peqeditor wouldn't work.
Reply With Quote
  #195  
Old 05-18-2014, 04:28 AM
vsab's Avatar
vsab
Discordant
 
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
Default

Get it from http://peqtgc.com/releases instead of SVN.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:03 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3