EQArchives / eqemu-server-tuning

Track updates to the game server
MIT License
0 stars 0 forks source link

Karnor's Castle #6

Open nazwadi opened 1 year ago

nazwadi commented 1 year ago
nazwadi commented 1 year ago

Scroll of the Dark out of era (dropped from Skeletal Warlord)

turbosilk99 commented 1 year ago

Remove tradeskill item Plague Mites 24087 from db as out of era or flag them for later eras. https://everquest.allakhazam.com/db/item.html?item=9060

turbosilk99 commented 1 year ago

Extrapolating data from Magelo and P99 the drolvarg captain drop rates 80% solution should be: Drolvarge mantle 60% Cobalt Gauntlets - 3% Elder Spiritist's Vambraces - 3% Polyphenomenal Axe - .5% Jade Mace - 5% Lupine Dagger .5%

https://eq.magelo.com/npc/43627 https://wiki.project1999.com/A_drolvarg_captain

Polyphenomenal Axe was OP and nerfed out of the game later.

turbosilk99 commented 1 year ago

Can leave drolvarg pawbuster in but flag the pipe as not dropping until epic month. Or flag drolvarg pawbuster as not spawning until epic month.

turbosilk99 commented 1 year ago

It was so rare that there are hardly any old posts on it from Alla. One person stated he saw it the first day of Kunark release and hadn't seen it since. https://everquest.allakhazam.com/db/item.html?item=130#m98339248777879

It's so rare that it's not listed at all in Magelo. P99 doesn't list it - https://wiki.project1999.com/A_drolvarg_sentry. An "Everquest Ringed Mace of the Ykesha" search comes up with less than 30 hits many of which are modern due to legacy items coming out again in EQ Live server.

Per Nax and Turbo analysis this has been set to .1%.

turbosilk99 commented 1 year ago

Skeletal Captain should drop Fist of Zek in place of Wild Lord's Sandals. https://wiki.project1999.com/Skeletal_captain

turbosilk99 commented 1 year ago

Dust of Decay should be flagged as dropping in the Omens Era. https://everquest.allakhazam.com/db/quest.html?quest=2937

turbosilk99 commented 1 year ago

Wild Lord's gauntlets should drop off the spectral turnkey once Luclin is released.

turbosilk99 commented 1 year ago

Spirit of Venril Sathir is spawnable in epic release month.

turbosilk99 commented 1 year ago

Ventril Sathir is currently only dropping the epic Pulsing Green Stone. Should drop %: Cobalt Greaves -8 Blood Ember Greaves -8 Jaundiced Bone Greaves -8 Tolan's Darkwood Greaves-8 Deepwater Greaves-8 Mrylokar's Greaves-8 Singing Steel Greaves-8 Donal's Leggings of Mourning-8 Elder Spiritist's Greaves-9 Ancient Shissar Gauntlet-9 Diamond Encrusted Staff-14 Nightshad Scented Staff-14 Shissar Nulifier Staff-14 Shissar Guardian Staff-14 Waters of Impenetrable Aura-14 Lycanthropic Staff-14 Gnarled Staff-16

https://wiki.project1999.com/Venril_Sathir

turbosilk99 commented 1 year ago

Spawngroup 10671 should be: Drolvarg captain- 16% Sentry- 84%

https://wiki.project1999.com/A_drolvarg_captain

turbosilk99 commented 1 year ago

Spawn group 10644 skeletal captain should be 20%. https://wiki.project1999.com/Skeletal_captain

nazwadi commented 1 year ago

As discussed, this has been changed to 0.1% drop chance.

nazwadi commented 1 year ago

Raised Accuracy, ATK, Scalerate on all mobs except Venril_Sathir and Venril_Sathir_remains

UPDATE npc_types nt
SET ATK = 300, Accuracy = 150, scalerate = 150
WHERE name NOT LIKE "Venril_Sathir"
AND nt.id IN (SELECT DISTINCT s2.npcID FROM spawn2 sp
INNER JOIN spawngroup s ON sp.spawngroupID = s.id 
INNER JOIN spawnentry s2 ON s2.spawngroupID = s.id
INNER JOIN npc_types n ON n.id = s2.npcID 
WHERE sp.zone = 'karnor');
nazwadi commented 1 year ago

Raised MR, FR, CR, DR, PR to 48

UPDATE npc_types nt
SET MR = 48, FR = 48, CR = 48, DR = 48, PR = 48
WHERE name NOT LIKE "%Venril_Sathir%"
AND nt.id IN (SELECT DISTINCT s2.npcID FROM spawn2 sp
INNER JOIN spawngroup s ON sp.spawngroupID = s.id 
INNER JOIN spawnentry s2 ON s2.spawngroupID = s.id
INNER JOIN npc_types n ON n.id = s2.npcID 
WHERE sp.zone = 'karnor');
turbosilk99 commented 1 year ago