search

xackery / rebuildeq-v1

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

Charm of Defense #1120

Closed xackery closed 7 years ago

xackery commented 7 years ago 

INSERT INTO `peq`.`tasks` (`id`, `title`, `description`, `reward`, `rewardid`, `xpreward`, `rewardmethod`, `repeatable`) VALUES (302, 'Charm of Defense', '[1, Complete many tasks for Torgon Blademaster to prove you are worthy to use the Charm of Defense.]', 'Charm of Defense', 100045, 1000, 0, 0);

update items set nodrop = 1 where id = 2193 or id = 5523 or id = 2193 or id = 14551 or id = 4504 or id = 2346 or id = 71045;

REPLACE INTO `peq`.`activities` (`taskid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `delivertonpc`, `zoneid`) VALUES (302, 1, 1, 'Torgon Blademaster in Plane of Sky', 'Band of Discipline from Plane of Hate', 2193, 71045, 71);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `delivertonpc`, `zoneid`) VALUES (302, 1, 1, 1, 'Torgon Blademaster in Plane of Sky', 'Fluxbladed Axe from Plane of Fear', 5523, 71045, 71);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `delivertonpc`, `zoneid`) VALUES (302, 2, 1, 1, 'Torgon Blademaster in Plane of Sky', 'Azure Ruby Ring from Plane of Sky', 14551, 71045, 71);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `delivertonpc`, `zoneid`) VALUES (302, 3, 1, 1, 'Torgon Blademaster in Plane of Sky', 'Crown of King Tranix from Nagafen\'s Lair', 4504, 71045, 71);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `delivertonpc`, `zoneid`) VALUES (302, 4, 1, 1, 'Torgon Blademaster in Plane of Sky', 'White Wolf-Hide Cloak from Permafrost Keep', 2346, 71045, 71);

REPLACE INTO `peq`.`activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `goalid`, `goalcount`, `delivertonpc`, `zoneid`) VALUES (302, 5, 1, 1, 'Torgon Blademaster in Plane of Sky', 'Full Bottle of Experience', 100001, 15, 71045, 71);
xackery commented 7 years ago 
REPLACE 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`, `augslot6type`, `augslot6visible`, `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`, `herosforgemodel`, `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`, `skillmodmax`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `augslot6unk2`, `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`, `evoitem`, `evoid`, `evolvinglevel`, `evomax`, `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`, `UNK219`, `UNK220`, `UNK221`, `heirloom`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `placeable`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `epicitem`)
VALUES
    (100045, 0, 'Charm of Defense', 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, '', '0', 65535, 2147483647, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 1, 0, 0, 1898, 'IT63', 0, 17, 0, 0, 0, 0, 'Lore description', 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 7651, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, '2012-12-27 10:35:06', '', 0, 0, 0, 0, 100, 0, 1, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, '0000-00-00 00:00:00', '2012-05-03 13:10:27', '', '13THFLOOR', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, '00000000000000000000', 0, '', -1, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 'Defensive', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2005-02-18 18:12:49', 0, 70, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 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);