Halloween Event (2012)

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever

Login with username, password and session length

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 Server Files

EZ Client Downloads

Custom UF MiniMap

Custom UF Inventory

EQEmu Server Status

EQEmulator Home

Allakhazam Home

UFMissingFilesList

TwitchTV

[marxist]

spawning somewhere else in zone would be amazing

[Blurring]

Would it be possible/easy to remove the loot tables from some of the trash mobs temporarily? I think a large part of the zone times / lag would be reduced if clients/server didn't have to resync and load 1000+ corpses on every zone.

If there's any way I could help please let me know, not sure what the process is like. I could prepare npc names and such though.

[marxist]

great idea if it is possible

[Strix]

Would it be possible/easy to remove the loot tables from some of the trash mobs temporarily?

+1

[Natedog]

Method 1 -- Seems tedious ...

PoDisease

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone = 'podisease';

CoDecay

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone = 'codecay';

PoNightmare

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone = 'ponightmare';

Kaesora

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone = 'kaesora';

These will set ALL mobs in those zones to have no loot table... so IF the Halloween bosses are set as Static spawns in those zones!!! They will get erased!!!!!


I am guessing they aren't set to ANY zone?? The Halloween bosses that is. So this shouldn't change their loot tables.



The other zones you can just replace the  spawn2.zone = 'XXXXX'  ... but a few of those zones have FG / CG loot items.. so removing the loot table from all the mobs would probably be a bad idea unless you write down the mobs loot table really fast.... then use the script and manually add the FG / CG loottable back to the specific mob.




Halloween Event Zones
befallen -- FG / CG
charasis -- Shield quest here??
citymist -- FG / CG
codecay
fearplane (Trick or Treat Quest) -- Custom loot zone
hateplane
kaesora
kurn
podisease
poeartha (New Halloween Event) -- Unsure?!
ponightmare
unrest (Trick or Treat Quest) -- FG / CG
veksar




Unrest ---  ((( Check NPC id for Garanel Rucksif )))) should be 63062 !!!  -- it will remove loot and SKIP him ((Dwarven workboots for FG quest!))

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone = 'unrest' AND npc_types.id NOT IN (63062);

Fearplane --- takes a few minutes to save the loot table before you nuke it all down to 0 ! -- But should help A LOT

Fearplane has the most lag of any zone due to the amount of mobs.. but the zone has low end custom gear.. so removing things would be a hassle unless you could somehow save the Loottables before doing that zone? I am unsure on how to do that.


Possible way to save zones loottable for Fearplane... since I am a noob

Code:

SELECT npc_types.id, npc_types.name, npc_types.loottable_id FROM npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID WHERE spawn2.zone = 'fearplane';

While using HeidiSQL -- I selected the entire grid this SQL just created.. and Exported the entire Grid as a SQL REPLACE with Column names in first row.. so now I have a text file with a a ton of Replaces to put the loottables back together...

and looks like this....


EXAMPLE of what the text file contains..  (Has my entire fearplane in it) This is jut one mob  

Code:

REPLACE INTO `npc_types` (`id`, `name`, `loottable_id`) VALUES (72001, 'Wraith_of_a_Shissar', 1);

Now that the fearplane is saved into a text file of REPLACE SQLs .. you can use


Fearplane

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone = 'fearplane';

Method 2 --- seems Faster?

Sidenote.....

Could backup all those zones loottables real fast .. then nuke them all to 0 just for the event.. and replace them afterwards . Just a thought!


IF you choose this Method... here you go!!

Create Grid of all NPCs in those zones... (( Export these as a SQL Replace with column names!! ))

Code:

SELECT npc_types.id, npc_types.name, npc_types.loottable_id FROM npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID WHERE spawn2.zone IN ('fearplane','unrest','befallen','charasis','codecay','kaesora','kurn','podisease','poeartha','ponightmare','veksar','citymist','hateplane');

Make sure none of the event mobs are NOT linked to those zones.. (( Still assuming you just use quest code to spawn them and not part of the spawn2 for these zones ))


Nuke ALL those zones

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone IN ('fearplane','unrest','befallen','charasis','codecay','kaesora','kurn','podisease','poeartha','ponightmare','veksar','citymist','hateplane');

Thanks!!  Event is fun so far.. just want to help with some of the lag!

[Hunter]

I'll see what I can tweak for Mon-Wed..

I could easily just back up the npc_types table, then set all loottables to 0, and revert to my saved table after the event. Of course I'd have to make sure the halloween bosses don't lose their loot, probably manually put them back in.

I might lower the candy requirements and allow instances in poeartha zone for the Black Unicorn too. Need to re-write the code so that the instances don't interfere with the count, otherwise they'll share the same count.

I think trash have 1/75 chance to spawn a T1 boss, then its 1/10 chance to spawn a T2 Boss, then a 1/4 chance to spawn a T3 (Cazic Thule) boss, etc up to finally a T5 boss, so yes they get more rare, harder to kill, and better loot. The T3-T5 are going to be rare bosses.

Just keep you all updated, that I'm watching and listening. Hopefully we're having fun so far.

Hunter

[Natedog]

Ya if you backup the npc_types tables you can nuke those zones with

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone IN ('fearplane','unrest','befallen','charasis','codecay','kaesora','kurn','podisease','poeartha','ponightmare','veksar','citymist','hateplane');

 

[Mixlor]

I am pretty much with the others on spawning the Insane Goblin somewhere else in the zone or putting a turn-in item to spawn him as well as getting rid of the loot on all other  non-event mobs. Lag wasn't terrible (unplayable)  for me but I did notice it. I have killed about 35-T1 bosses, 8-T2 bosses, 15 Cazic Thules, 4 Stone Monsters (with Freth's help) and got my ass handed to me over and over by 1 Insane Goblin standing over the SM corpse. I got 11 of my CT spawns turning in candy and loved the loot drops since I still have alot of toons that could use them. I know it can be frustrating not to get to loot a corpse because something (INSANE) is standing over it.

I am sure you are working on a fix with all the suggestions.. but here is another one. Making the Gob either not run back so dang fast....maybe slowly walk back to the original spawn point or not have him come back at all... just stay where the person trained him or died. I do think it is probably easier with coding to just have him spawn somewhere else in the zone like you have T5 bosses spawn in Abyss - but that is just my suggestions.

I am having fun with the event. First event and I am loving it. I would like to kill the Black Unicorn but will see how the lag issues work themselves out.

As always, thanks

Mixlor

***After thinking about it a little more... I think having him spawn somewhere else in the zone might be a tad bit too much too. Most people will not even mess with him so he will be left up. Eventually.. they will spawn him again.. so now there will be 2 up in the zone somewhere... and so on. Eventually you wont be able to kill mobs to get all the T1-SM to spawn because you have 2-??? Gobs in the zone. Now for us with summon way-points... we can just remake instances.. but for people using public zones that have no summon way-points...that will hurt someone just trying to get a 1.5 - 3.0 epic book off a mob.

I think I am in favor of just an item (make it a rare chance) you can loot off SM to turn in and spawn the Gob. I would rather have a stack of Goblin tokens (like MCP tokens) in my inventory than 15+ Goblins spawned up in public zones so I cant even get in to access my own private instances without getting trained or just flat out killed while zoning in.

I have a feeling that even SM might come to this and even CT since SM can be a pain for those that barely make it thru CT and then have the SM spawn on top of CT so they cant get the CT loot. Gotta draw the line somewhere but it seems to be the Insane Goblin that everyone (even the top geared folks) is talking about. You could make it where T1 bosses can drop a T2 boss token and so on. Take this into consideration so changes can be made all at one time without too many server downtimes.

Just my 2 cents.

Mixlor

[wolfegunr]

Just want to say ty Hunter for listening to us, and again, we all really appreciate all the time put into this.

Can't expect everything to go smoothly the first time something is implemented, even the billion dollar companies have this problem.

You rock, here's to looking forward to the tweaks. 

[Griz]

Could just make the goblin indifferent when he pops. That would solve the problem of him camping stone monster corpses.

I mean, if it's normal nature for a goblin to attack you, wouldn't an insane goblin just stand there?

[wolfegunr]

Enosis said the best and easiest fix yet. Have the goblin (and perhaps SM also?) Spawn with no aggro. This way we can loot the kill and pull when ready.

[Fugitive]

Enosis said the best and easiest fix yet. Have the goblin (and perhaps SM also?) Spawn with no aggro. This way we can loot the kill and pull when ready.

+99999999999999999999

agree no aggro on spawn lootz rez buff kill.. or be keeled one of the two.. =D

[Natedog]

Ya if you backup the npc_types tables you can nuke those zones with

Code:

UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.loottable_id = 0 WHERE spawn2.zone IN ('fearplane','unrest','befallen','charasis','codecay','kaesora','kurn','podisease','poeartha','ponightmare','veksar','citymist','hateplane');

 

If you are afraid it will delete the loot from the halloween bosses... put this at the end

Code:

 AND npc_types.id NOT IN (X, Y, Z);

X Y Z being... all the NPC IDs for   ... Spectre, Skeleton, Werewolf, Scarecrow, Zombie, Innoruuk, Rallos Zek, Tribunal, Cazic Thule, Stone Monster, Insane Goblin


Hope any of this helps 

[Hunter]

So Goblin is blocking people from looting CT? Yeah its a challenge. Goblin loot is better than CT loot anyways.

I could try to see if a timer would work, to make the goblin spawn 1 minute after CT dies?

If we're getting to the point of multiple goblins in zone, I could make them depop after 1 hour?

I'll see what ideas I can work with today to make Monday-Wednesday a bit easier.

[Natedog]

Anyway we could get trash loot removed from the trash ?   Before Monday that is.

Advanced search

• Unable to log in by Chieftan [November 23, 2024, 07:04:51 am]
• Everquest Tweaks and Sett... by Pubis [November 18, 2024, 11:18:15 am]
• Broken Stuff Repair Shop ... by Draca [November 12, 2024, 08:47:03 am]
• Update to Halls of Honor by Sarthin [November 10, 2024, 04:57:40 pm]
• Halloween 2024 by clbreastmilk [November 04, 2024, 07:55:17 am]
• Some T12 Questions by Miriya [October 28, 2024, 01:38:59 pm]
• HW 2024 by Raygan [October 21, 2024, 08:03:01 am]
• Ninja Looting by zefirus [October 20, 2024, 04:55:10 pm]
• Official Guild Creation R... by Tylperion [September 15, 2024, 11:54:54 am]
• T11 Feedback Thread by Sarthin [August 28, 2024, 12:45:01 pm]
• What's next for the rest ... by Mixlor [August 27, 2024, 02:01:07 pm]
• Hard Mode NPC by Mixlor [August 06, 2024, 09:37:00 am]
• Looking for some advice (... by Draca [July 31, 2024, 10:55:17 am]
• 4th of July Event by orkiho [July 12, 2024, 07:35:22 pm]
• New Server update causing... by Mixlor [June 02, 2024, 01:01:54 am]
• Memorial Day Event by wachna [May 30, 2024, 01:52:28 pm]
• EZServer Rules by Sarthin [May 30, 2024, 01:10:12 pm]
• Fear Itself, testing week... by torotornot [May 24, 2024, 09:29:42 am]
• Fear Itself, the new Even... by kendiian [April 26, 2024, 11:48:38 pm]
• Recent & Upcoming Changes by Dokplayer2 [April 23, 2024, 10:48:30 pm]
• Issue with my epic by fangzy [April 22, 2024, 07:32:32 pm]
• Few Changes - T11, VP, Gu... by clbreastmilk [April 10, 2024, 11:32:33 am]
• Combine HoH tokens macro.... by Dbeast [April 04, 2024, 05:10:46 pm]
• Warlock self buffs by Fecs [April 04, 2024, 03:56:08 pm]

Members

• Total Members: 6156
• Latest: Rin1

Stats

• Total Posts: 65127
• Total Topics: 5066
• Online Today: 298
• Online Ever: 8678
• (December 19, 2022, 02:32:09 pm)

Users Online

Users: 0
Guests: 261
Total: 261