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 
|