[Share/Release] Updated updated NCDB

**technique** · 09-04-11, 11:05 AM

Original topic: http://arcemu.org/forums/index.php?showtopic=23690 (Includes credits)

A while ago Walla decided to release his database he worked a lot on after Next Chapter had discontinued. I have now made my own update to it which I would like to share with you all. It's not a lot though, more like huge cleanups and minor updates for it as in the released version by him there are quite a lot of double spawns and event spawns in the world. I cannot guarantee everything is gone, but almost.

Where did you get spawn data?
Retail. Do not worry it is "blizzlike".

Code:

Changelog A (9th April):
• Removed double spawns
• Removed event spawns
• Cleaned up tables
• Updated to work with latest ArcEmu (World updates to 4047)

Code:

Changelog B (10th April):
• Loot tables taken from WhyDB (Full credit to them)
• Removed custom texts
• Removed custom creature names
• Cleaned up loot tables
• Recounted creature_spawns and gameobject_spawns table ids (And obviously tables connected to them)

Code:

Changelog C (10th April):
• Removed double spawns of:
 • Private Thorsen
 • Royal Guards
 • Brave Darksky
 • Murphy West

• Removed Katrina Shimmerstar from Ironforge (Event spawn)
• Dismounted a lot of creatures that shouldn't be mounted
• Bixi Wobblebonk in Ironforge have had her spawn location corrected
• Holgar Stormaxe in Durotar have had his spawn location corrected
• All custom spawned creatures and objects have been removed from GM Island
• Removed duplicated portals in Shattrath City
• Runk Windtamer in Cenarion Hold have had his emote state corrected
• Sputtervalve in Ratchet have had his emote state corrected
• Removed workaround portals for transports (Might have missed one or two in Northrend but I doubt it, had to be done with command)
• All critters have had their factions updated (Except Chickens who refuses to change)
• The Rake is no longer spawned in Elwynn Forest
• Stormwind City Guards have had their equipment corrected
• Stormwind City Patrollers have had their equipment corrected
• Added 557 gossip texts to creatures
• Removed custom graveyards from Elwynn Forest
• All creatures offering quests now have quest flag
• All creatures with gossip now have gossip flag
• Corrected an error with the revision from last version

Code:

Changelog D (11th April):
• Hunter Trainers have had their gossip texts setup
• Portal to Blasted Lands has been spawned in Stormwind City
• Applied a full npcflag update (Dozens of npcflags corrected)
• Added hundreds of new gossips (Thanks to WhyDB for about ~100)
• Removed incorrect spawns of Beram Skychaser in Hillsbrad Foothills
• Removed double spawn of Richter in Hillsbrad Foothills
• Removed waypoints for a bunch of creatures that shouldn't move
• Removed all double spawns of the Forsaken Courier and her "army"
• A lot of creature text updates, no more rabbits telling you to go away etc
• Lieutenant Karter in Stormwind City is now mounted
• Removed custom spawned Orgrimmar Grunts from Orgrimmar
• Removed duplicated Arena Vendors from Gadgetzan