search

xackery / rebuildeq-v1

Rebuild Everquest
GNU Lesser General Public License v3.0
1 stars 0 forks source link

HP Buff Consolidator for Paladin #224

Closed xackery closed 8 years ago

xackery commented 8 years ago

http://everquest.allakhazam.com/db/spelllist.html?name=&type=pal&level=1&opt=And+Higher&action=searc Get every HP Buff, Symbol, and AC buff (Brell's etc), and get their spell_ids and level. E.g. spell_id //level 202 //8 Courage 11 //15 Holy Armor 219 //20 Center 485 //24 Symbol of Transal 368 //30 Spirit Armor 486 //33 Symbol of Ryltan 89 //37 Daring 18 //39 Guard 487 //46 Symbol of Pinzarn 312 //47 Valor 19 //48 Armor of Faith 3578 //49 Brell's Steadfast Aegis 4064 //55 Austerity 4065 //58 Blessing of Austerity 488 //58 Symbol of Naltron 20 //60 Shield of Words 2590 //60 Brell's Mountainous Barrier 314 //60 Resolution

xackery commented 8 years ago 
  REPLACE INTO items (`Name`, `lore`, `artifactflag`, `color`, `fvnodrop`, `icon`, `id`, `idfile`, `itemclass`, `itemtype`, `loregroup`, `magic`, `material`, `minstatus`, `nodrop`, `norent`, `pendingloreflag`, `tradeskills`, `comment`, `created`, `deity`, `evolvinglevel`, `light`, `serialization`, `serialized`, `source`, `updated`, `verified`, `favor`, `guildfavor`, `ldonprice`, `ldonsellbackrate`, `ldonsold`, `ldontheme`, `pointtype`, `price`, `sellrate`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `classes`, `races`, `slots`, `reclevel`, `recskill`, `reqlevel`, `potionbelt`, `potionbeltslots`, `stackable`, `stacksize`, `attuneable`, `expendablearrow`, `nopet`, `notransfer`, `size`, `weight`, `heroic_cr`, `heroic_dr`, `heroic_fr`, `heroic_mr`, `heroic_pr`, `heroic_svcorrup`, `cr`, `dr`, `fr`, `mr`, `pr`, `svcorruption`, `ac`, `endur`, `hp`, `mana`, `aagi`, `acha`, `adex`, `aint`, `asta`, `astr`, `awis`, `heroic_agi`, `heroic_cha`, `heroic_dex`, `heroic_int`, `heroic_sta`, `heroic_str`, `heroic_wis`, `accuracy`, `attack`, `avoidance`, `clairvoyance`, `combateffects`, `damageshield`, `dotshielding`, `dsmitigation`, `enduranceregen`, `healamt`, `manaregen`, `regen`, `shielding`, `spellshield`, `strikethrough`, `stunresist`, `damage`, `delay`, `haste`, `banedmgamt`, `banedmgbody`, `banedmgrace`, `banedmgraceamt`, `elemdmgamt`, `elemdmgtype`, `extradmgamt`, `extradmgskill`, `backstabdmg`, `range`, `spelldmg`, `augdistiller`, `augrestrict`, `augslot1type`, `augslot1unk2`, `augslot1visible`, `augslot2type`, `augslot2unk2`, `augslot2visible`, `augslot3type`, `augslot3unk2`, `augslot3visible`, `augslot4type`, `augslot4unk2`, `augslot4visible`, `augslot5type`, `augslot5unk2`, `augslot5visible`, `augtype`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `bardeffect`, `bardeffecttype`, `bardtype`, `bardvalue`, `casttime`, `casttime_`, `clickeffect`, `clicklevel`, `clicklevel2`, `clicktype`, `maxcharges`, `recastdelay`, `recasttype`, `focuseffect`, `focuslevel`, `focuslevel2`, `focustype`, `proceffect`, `proclevel`, `proclevel2`, `procrate`, `proctype`, `scrolleffect`, `scrolllevel`, `scrolllevel2`, `scrolltype`, `clickname`, `focusname`, `procname`, `scrollname`, `wornname`, `worneffect`, `wornlevel`, `wornlevel2`, `worntype`, `UNK012`, `UNK013`, `UNK014`, `UNK033`, `UNK054`, `UNK059`, `UNK060`, `UNK120`, `UNK121`, `UNK123`, `UNK124`, `UNK127`, `UNK132`, `UNK134`, `UNK137`, `UNK142`, `UNK147`, `UNK152`, `UNK157`, `UNK193`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `augslot6type`, `augslot6unk2`, `augslot6visible`, `bardlevel`, `bardlevel2`, `bardname`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardunk7`, `benefitflag`, `book`, `booktype`, `charmfile`, `charmfileid`, `clickunk5`, `clickunk6`, `clickunk7`, `elitematerial`, `epicitem`, `evoid`, `evoitem`, `evomax`, `filename`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `heirloom`, `herosforgemodel`, `lorefile`, `placeable`, `powersourcecapacity`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `purity`, `questitemflag`, `scriptfileid`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `skillmodmax`, `skillmodtype`, `skillmodvalue`, `summonedflag`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`) VALUES ('Brell\'s Blessing', 'Paladin Buff', '0', '2147483647', '0', '1300', '100500', 'IT63', '0', '17', '-1', '0', '3', '0', '0', '1', '0', '0', '', '2005-02-18 18:12:49', '0', '0', '0', '', '0000-00-00 00:00:00', '13THFLOOR', '2012-12-27 10:35:06', '2012-05-03 13:10:27', '0', '2', '0', '70', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4', '65535', '6291456', '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', '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', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '2000', '0', '202', '1', '0', '1', '-1', '0', '0', '-1', '0', '0', '0', '-1', '0', '0', '0', '0', '-1', '0', '0', '0', 'Bless', '', '', '', '', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '00000000000000000000', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '-256', '255', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '', '0', '0', '', '-1', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '', '-1', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '', '-1');
xackery commented 8 years ago

i'm going to take out the item and instead use the spell courage to make this happen

xackery commented 8 years ago

Closing for now, will create a new issue when more problems found.