|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |
08-01-2013, 02:05 PM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Also, I wanted to say keep mucking! Once you get a solid grasp of the editor, I'll have no problem giving you SVN access, so you can commit your changes directly.
|
08-01-2013, 03:26 PM
|
|
Discordant
|
|
Join Date: Dec 2005
Posts: 435
|
|
I enjoy tinkering with the tools the eqemu community uses and produces.
The peq editor has been a favorite of mine for some time since I sometimes forget to double check sql syntax and then I end up borking entire tables.
Just ask Natedog he was on vent with me the other day when I had to drop altadv_vars because I changed in range using <= and <= ... silly me.
GUI interfaces help reduce the mistakes I make 
I would have posted this on the PEQ boards but for some reason I just never made a forum account there, no idea why because I monitor the forums for all gold/green and high pop white server looking for reasons to tinker with things.
I can't think of anything else the editor could use that would not step on other tools that are already well made or bloat it in size but I'll continue poking it with a spork and post .patch files for stuff to be considered.
__________________
|
08-27-2013, 08:01 PM
|
 |
Developer
|
|
Join Date: Mar 2003
Posts: 1,500
|
|
Notices are not errors. Think of them as just warnings.
Since you are using 1.8.2, that has newer PHP. I recommend using this to turn off all the strict/warnings.
Code:
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED & ~E_WARNING
|
08-27-2013, 09:11 PM
|
|
Discordant
|
|
Join Date: Dec 2005
Posts: 435
|
|
Report back if joligario's suggestion does not work out. As I said earlier there are a bunch of people that will assist in figuring it out with you.
__________________
|
08-29-2013, 09:16 PM
|
|
Fire Beetle
|
|
Join Date: Jul 2012
Posts: 9
|
|
Made the above changes but still get the variable error. Seems everything is working just errors everywhere.
|
08-31-2013, 06:10 PM
|
|
Developer
|
|
Join Date: Mar 2003
Posts: 1,500
|
|
Not descriptive enough for anyone to help you.
|
08-31-2013, 06:34 PM
|
|
Discordant
|
|
Join Date: Dec 2005
Posts: 435
|
|
Can you print screen, crop it and post that so we can see what is going on.
__________________
|
 |
|
 |
10-03-2013, 09:42 AM
|
 |
Developer
|
|
Join Date: Dec 2012
Posts: 515
|
|
I noticed there were few missing spell effects in the Spell editor when I grabbed the newest PEQ editor from the daily dump.
I decided to update the ones that were OLD "unknowns" that are now known to the correct effect name and added all the ones that were missing.
Placed "NI" at the from the effect if it wasn't implement as of 10 /3 /2013
Code:
--- "lib\spellenums.php"
+++ "lib\spellenums.php"
@@ -772,14 +772,14 @@
332 => "Summon To Corpse",
333 => "Effect On Fade",
334 => "Bard AOE Dot",
- 335 => "Unknown335",
+ 335 => "BlockNextSpellFocus",
337 => "Percent XP Increase",
338 => "Summon and Res All Corpses",
339 => "Trigger On Cast",
340 => "Lifeshard Chance",
342 => "Immune to Fleeing",
343 => "Interrupt Casting",
- 348 => "Unkown348",
+ 348 => "LimitManaCost",
350 => "Manaburn",
351 => "Persistent Effect",
352 => "Unknown352",
@@ -788,9 +788,9 @@
355 => "Unknown355",
358 => "Current Mana Once",
360 => "Spell On Kill",
- 361 => "Unknown361",
+ 361 => "SpellOnDeath",
365 => "Spell On Death",
- 366 => "Unkown366",
+ 366 => "NI ShieldEquipDmgMod",
367 => "Add Body Type",
368 => "Faction Mod",
369 => "Corruption Counter",
@@ -803,7 +803,68 @@
380 => "Knockdown",
382 => "Block Damage Shield",
383 => "Decrease Hitpoints",
- 384 => "Leap"
+ 384 => "Leap",
+ 385 => "LimitSpellGroup",
+ 386 => "CastOnCurer",
+ 387 => "CastOnCure",
+ 388 => "NI SummonCorpseZone",
+ 389 => "Forceful_Rejuv",
+ 390 => "NI CastResistRestrict",
+ 391 => "NI Unknown391",
+ 392 => "AdditionalHeal2",
+ 393 => "HealRate2",
+ 394 => "NI Unknown394",
+ 395 => "CriticalHealRate",
+ 396 => "AdditionalHeal",
+ 397 => "NI PetMeleeMitigation",
+ 398 => "SwarmPetDuration",
+ 399 => "Twincast",
+ 400 => "HealGroupFromMana",
+ 401 => "ManaDrainWithDmg",
+ 402 => "EndDrainWithDmg",
+ 403 => "NI ReluctantBene",
+ 404 => "LimitExcludeSkill",
+ 405 => "TwoHandBluntBlock",
+ 406 => "CastonNumHitFade",
+ 407 => "NI Unknown397",
+ 408 => "LimitHPPercent",
+ 409 => "LimitManaPercent",
+ 410 => "LimitEndPercent",
+ 411 => "LimitClass",
+ 412 => "NI Unknown412",
+ 413 => "IncreaseSpellPower",
+ 414 => "LimitSpellSkill",
+ 415 => "NI Unknown415",
+ 416 => "ACv2",
+ 417 => "ManaRegen_v2",
+ 418 => "SkillDamageAmount2",
+ 419 => "AddMeleeProc",
+ 420 => "NI Unknown420",
+ 421 => "IncreaseNumHits",
+ 422 => "NI Unknown422",
+ 423 => "NI Unknown423",
+ 424 => "GravityEffect",
+ 425 => "NI Display",
+ 426 => "NI IncreaseExtTargetWindow",
+ 427 => "SkillProc",
+ 428 => "LimitToSkill",
+ 429 => "SkillProc2",
+ 430 => "NI Unknown430",
+ 431 => "NI Unknown431",
+ 432 => "NI Unknown432",
+ 433 => "NI Uknonwn433",
+ 434 => "CriticalHealChance2",
+ 435 => "CriticalHealOverTime2",
+ 436 => "NI Unknown432",
+ 437 => "NI Anchor",
+ 438 => "NI Unknown438",
+ 439 => "NI IncreaseAssassinationLvl",
+ 440 => "FinishingBlowLvl",
+ 441 => "NI MovementSpeed2",
+ 442 => "NI TriggerOnHPAmount",
+ 443 => "NI Unknown443",
+ 444 => "NI AggroLock",
+ 445 => "NI AdditionalMercenary"
);
$sp_fields = array(
|
 |
|
 |
|
|
|
10-04-2013, 08:22 AM
|
|
Developer
|
|
Join Date: Dec 2012
Posts: 515
|
|
Found a few missing fields for item edit / add.
Allow for augtype up to 20
Code:
--- "templates\iframes\js.tmpl.php"
+++ "templates\iframes\js.tmpl.php"
@@ -112,5 +112,13 @@
form.augtype_Type_10.checked = form.all_none5.checked ;
form.augtype_Type_11.checked = form.all_none5.checked ;
form.augtype_Type_12.checked = form.all_none5.checked ;
+form.augtype_Type_13.checked = form.all_none5.checked ;
+form.augtype_Type_14.checked = form.all_none5.checked ;
+form.augtype_Type_15.checked = form.all_none5.checked ;
+form.augtype_Type_16.checked = form.all_none5.checked ;
+form.augtype_Type_17.checked = form.all_none5.checked ;
+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 ;
}
</script>
Code:
--- "templates\items\items.add.tmpl.php"
+++ "templates\items\items.add.tmpl.php"
@@ -811,6 +811,18 @@
<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/>
+ <input type="checkbox" name="augtype_Type_16" value=32768 <?echo ($augtype & 32768) ? "checked" : ""?>> Type 16<br/>
+ </td>
+ <td valign="top" align="left"><br/>
+ <input type="checkbox" name="augtype_Type_17" value=65536 <?echo ($augtype & 65536) ? "checked" : ""?>> Type 17<br/>
+ <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/>
+ </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>
Code:
--- "templates\items\items.edit.tmpl.php"
+++ "templates\items\items.edit.tmpl.php"
@@ -752,6 +752,18 @@
<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/>
+ <input type="checkbox" name="augtype_Type_16" value=32768 <?echo ($augtype & 32768) ? "checked" : ""?>> Type 16<br/>
+ </td>
+ <td valign="top" align="left"><br/>
+ <input type="checkbox" name="augtype_Type_17" value=65536 <?echo ($augtype & 65536) ? "checked" : ""?>> Type 17<br/>
+ <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/>
+ </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>
Code:
--- "lib\items.php"
+++ "lib\items.php"
@@ -358,6 +358,14 @@
if (isset($_POST['augtype_Type_10'])) $augtype = $augtype+512;
if (isset($_POST['augtype_Type_11'])) $augtype = $augtype+1024;
if (isset($_POST['augtype_Type_12'])) $augtype = $augtype+2048;
+ if (isset($_POST['augtype_Type_13'])) $augtype = $augtype+4096;
+ if (isset($_POST['augtype_Type_14'])) $augtype = $augtype+8192;
+ if (isset($_POST['augtype_Type_15'])) $augtype = $augtype+16384;
+ if (isset($_POST['augtype_Type_16'])) $augtype = $augtype+32768;
+ if (isset($_POST['augtype_Type_17'])) $augtype = $augtype+65536;
+ 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;
$fields = '';
if ($item['slots'] != $slots) $fields .= "slots=\"$slots\", ";
@@ -682,6 +690,14 @@
if (isset($_POST['augtype_Type_10'])) $augtype = $augtype+512;
if (isset($_POST['augtype_Type_11'])) $augtype = $augtype+1024;
if (isset($_POST['augtype_Type_12'])) $augtype = $augtype+2048;
+ if (isset($_POST['augtype_Type_13'])) $augtype = $augtype+4096;
+ if (isset($_POST['augtype_Type_14'])) $augtype = $augtype+8192;
+ if (isset($_POST['augtype_Type_15'])) $augtype = $augtype+16384;
+ if (isset($_POST['augtype_Type_16'])) $augtype = $augtype+32768;
+ if (isset($_POST['augtype_Type_17'])) $augtype = $augtype+65536;
+ 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;
$fields = '';
$fields .= "slots=\"$slots\", ";
Thank you for this wonderful tool
Created a random item with it
|
|
|
|
10-04-2013, 05:44 PM
|
|
Developer
|
|
Join Date: Mar 2003
Posts: 1,500
|
|
Thank you for the contribution. I'll get this in tonight.
|
|
|
|
11-11-2013, 06:10 AM
|
|
Developer
|
|
Join Date: Dec 2012
Posts: 515
|
|
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
|
|
|
|
05-17-2014, 07:22 AM
|
|
Hill Giant
|
|
Join Date: Oct 2006
Posts: 179
|
|
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! |
11-11-2013, 07:33 PM
|
|
Developer
|
|
Join Date: Mar 2003
Posts: 1,500
|
|
Added with some very minor changes. Thanks!
Will have to discuss the -1 Augment type at some time as well.
|
01-06-2014, 11:53 PM
|
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,604
|
|
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.
 |
01-07-2014, 08:15 AM
|
|
Developer
|
|
Join Date: Mar 2003
Posts: 1,500
|
|
Discussed above and in the readme: most likely you forgot to turn on short open tags.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 01:00 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Hybrid Mode
