Getting Started
Rules
Character Mover
Optimization Guide
EZ Wiki
EZ Guide
Magelo
Zone List
Spell Recipes
T10.5 Spell Recipes
Crafting Recipes
Donate
EZ Player Discord
EZ Server Files
EZ Client Downloads
Custom UF MiniMap
Custom UF Inventory
EQEmulator Home
Allakhazam Home
UFMissingFilesList
TwitchTV
UPDATE spells_new SET effectid3 = 254 WHERE name LIKE '%Wail of Tashan%';UPDATE spells_new SET resistdiff = -1000 WHERE id = 10222;UPDATE spells_new SET effect_base_value2 = 50, effect_base_value3 = 50, effect_base_value4 = 50 WHERE id = 10143;UPDATE spells_new SET effect_base_value2 = 75, effect_base_value3 = 75, effect_base_value4 = 75 WHERE id = 10144;UPDATE spells_new SET effect_base_value2 = 100, effect_base_value3 = 100, effect_base_value4 = 100 WHERE id = 10145;UPDATE spells_new SET max2 = 1500 WHERE id = 10153;UPDATE spells_new SET effect_base_value2 = -5000, max2 = 5000 WHERE id = 10155;UPDATE spells_new SET effect_base_value1 = 367, effect_limit_value1 = 3 WHERE id = 10160;UPDATE spells_new SET effect_base_value6 = 7500, targettype = 6 WHERE id = 10162;INSERT INTO `items` (`id`, `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`, `elitematerial`, `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`, `ldonsellbackrate`, `UNK120`, `UNK121`, `questitemflag`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `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`, `scriptfileid`, `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`) VALUES (225372, 0, 'Spell: Brushcoat II', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', 8, 4278190080, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', -1, 0, 0, 0, 0, 0, 0, 504, 'IT63', 0, 20, 0, 0, 0, 0, 'Spell: Brushcoat II', -1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 2, 0, 1, -1, 0, 0, -1, 0, 0, 0, 0, 0, 25, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, 0, 0, '2011-12-17 08:40:35', '0', 0, 0, 0, 0, 20, 0, 1, '0', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 10188, 7, 0, 0, 0, NULL, '2010-04-03 22:22:04', NULL, '13THFLOOR', 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 70, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '0', -1, 0, '0', 0, '0', -1, 0, 0, 0, 0, '0', -1, 0, 0, 0, 0, 0, '0', -1, 0, 0, 0, 0, 0, '0', -1, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '0', '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);UPDATE spells_new SET effect_limit_value2 = 0 WHERE id = 10228 or id = 10229 or id = 10230 or id = 10231;UPDATE spells_new SET buffdurationformula = 2 WHERE id = 10243;UPDATE spells_new SET formula1 = 123 WHERE id = 10166 OR id = 10167 OR id = 10174 OR id = 10177;UPDATE spells_new SET formula1 = 123 WHERE id >= 10180 AND id <= 10186;UPDATE spells_new SET formula1 = 123 WHERE id = 10189 OR id = 10190;UPDATE spells_new SET formula1 = 123 WHERE id >= 10193 AND id <= 10200;UPDATE spells_new SET formula1 = 123 WHERE id = 10208 AND id = 10209;