ArcEmu: [share] Updated Updated Ncdb - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

[share] Updated Updated Ncdb

#1 User is offline   technique 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 145
  • Joined: 19-June 08
  • Gender:Male
  • Location:Underground
  • Interests:Emulation?
  • Server OS:Other

Posted 09 April 2011 - 09:59 AM

Original topic: http://arcemu.org/fo...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".

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

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)

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

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

Changelog E (11th April):
• Removed Melnan Darkstone from Ironforge (Event related)
• You must now complete quest 'A Charitable Donation' before you can start quest 'Your Continued Support'
• Removed double spawns of Haggard War Veteran in Shattrath City
• Removed double spawns of Kevin Browning in Shattrath City
• Removed double spawn of Kira Songshine in Elwynn Forest
• Removed thousands, most likely all, custom spawned objects from spawn
• Removed all custom spawned creatures from Gurubashi Arena
• Added recall location for The Ruby Sanctum (.recall port RubySanctum)

Changelog F (11th April):
• Accidently messed up some objects last update, now it is fully fine again

Changelog G (12th April):
• And more necessary gameobject cleanup/adjustment (Thanks to WhyDB for some herb/vein spawns that seemed to be missing, eh I won't leech to much from you I promise :3)
• Removed a bunch of custom gameobject names


Other changelogs (By Walla)
http://pastebin.com/1Hv78Kjp
http://pastebin.com/d6VkeD8h
http://pastebin.com/sJ8PQs4i
http://pastebin.com/AmJvEay2
http://pastebin.com/gWfeP8Sg
http://pastebin.com/f506f7688
http://pastebin.com/f2244a33f
http://pastebin.com/f6deb0898

Support: ArcEmu r4141+
Download: http://filebeam.com/...f632e88fa803639
Password: arcemu.org

Enjoy!
ŧechnique,
the one and only
2

#2 User is offline   Hasbro 

  • Project Manager
  • PipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 2,526
  • Joined: 07-June 08
  • Gender:Male
  • Location:New York
  • Server OS:Windows

Posted 09 April 2011 - 12:01 PM

Let me be the first to say thanks!

Thanks to Walla, his team, everyone else involved, and you :)
1

#3 User is offline   technique 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 145
  • Joined: 19-June 08
  • Gender:Male
  • Location:Underground
  • Interests:Emulation?
  • Server OS:Other

Posted 11 April 2011 - 02:56 PM

:)

Might update it. There are a couple of custom entries in there as well as out-dated loot tables I assume, if dfighter used loot tables from NCDBr101.

EDIT: Updated, if anyone would prefer to use Walla's database without events and such around, because it really is an epic database.
ŧechnique,
the one and only
0

#4 User is offline   paroxysm 

  • Chatty Cathy
  • Group: Retired
  • Posts: 320
  • Joined: 25-June 08
  • Gender:Male
  • Server OS:Windows

Posted 12 April 2011 - 08:02 PM

filebeam link doesn't work for me. Will you link it w/ other uploader?
0

#5 User is offline   trulaypirata 

  • Member
  • Pip
  • Group: Members
  • Posts: 40
  • Joined: 08-June 08
  • Gender:Male
  • Location:Córdoba, Capital del Cuarteto (arg)
  • Interests:Warcraft.
  • Server OS:Windows

Posted 12 April 2011 - 11:59 PM

Download: http://www.mediafire...x7gax2kaqp392s4
...
0

#6 User is offline   technique 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 145
  • Joined: 19-June 08
  • Gender:Male
  • Location:Underground
  • Interests:Emulation?
  • Server OS:Other

Posted 13 April 2011 - 11:42 AM

Thanks trulaypirata, I will upload other mirrors if I do a new revision.
ŧechnique,
the one and only
0

#7 User is offline   paroxysm 

  • Chatty Cathy
  • Group: Retired
  • Posts: 320
  • Joined: 25-June 08
  • Gender:Male
  • Server OS:Windows

Posted 13 April 2011 - 05:04 PM

For windows users who try to import this database via command prompt syntax
mysql <dbname> -u <name> -p <pass> < <dumpfile>.sql
and it's aborting prematurely due to some syntax errors.
First, login into mysql using 'mysql <dbname> -u <name> -p <pass>' then, while logged in, execute
source /path_to_dump_file/<dumpfile>.sql

This will make mysql continue importing the rest of the tables rather than aborting the whole process upon a few errors.

EDIT : Replaced my old db with this and my console gets raped with such errors :
[18:15][Arcemu]LootMgr: Loot for 6073 contains non-existant item 13049 . (loot_creatures)


These are being reported for quest items, loot_creatures, loot_gameobjects, loot_pickpocketing and they're immense.
0

#8 User is offline   technique 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 145
  • Joined: 19-June 08
  • Gender:Male
  • Location:Underground
  • Interests:Emulation?
  • Server OS:Other

Posted 15 April 2011 - 01:06 PM

View Postparoxysm, on 13 April 2011 - 05:04 PM, said:

EDIT : Replaced my old db with this and my console gets raped with such errors :
[18:15][Arcemu]LootMgr: Loot for 6073 contains non-existant item 13049 . (loot_creatures)


These are being reported for quest items, loot_creatures, loot_gameobjects, loot_pickpocketing and they're immense.

Really? I'm not receiving those :S

Try cleanup with
DELETE FROM `loot_creatures` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_fishing` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_gameobjects` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_items` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_pickpocketing` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_skinning` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_disenchanting` WHERE `itemid` NOT IN (SELECT entry from `items`);
DELETE FROM `loot_disenchanting` WHERE `entryid` NOT IN (SELECT `entry` FROM `items`);
DELETE FROM `loot_creatures` WHERE `entryid` NOT IN (SELECT entry from `creature_names`);
DELETE FROM `loot_pickpocketing` WHERE `entryid` NOT IN (SELECT entry from `creature_names`);
DELETE FROM `loot_skinning` WHERE `entryid` NOT IN (SELECT entry from `creature_names`);
DELETE FROM `loot_creatures` WHERE `entryid` NOT IN (SELECT entry from `creature_proto`);
DELETE FROM `loot_pickpocketing` WHERE `entryid` NOT IN (SELECT entry from `creature_proto`);
DELETE FROM `loot_skinning` WHERE `entryid` NOT IN (SELECT entry from `creature_proto`);
DELETE FROM `loot_gameobjects` WHERE `entryid` NOT IN (SELECT entry FROM `gameobject_names`);
DELETE FROM `loot_fishing` WHERE `entryid` NOT IN (SELECT `Zone` FROM `fishing`);
DELETE FROM `loot_gameobjects` WHERE `entryid` NOT IN (SELECT `entry` FROM `gameobject_names` WHERE `type` = 3);
DELETE FROM `loot_pickpocketing` WHERE `entryid` NOT IN (SELECT `entry` FROM `creature_names` WHERE `type` = 7);
DELETE FROM `loot_skinning` WHERE `entryid` IN (SELECT `entry` FROM `creature_names` WHERE `type` = 8);

...To see if it helps.

This version is using WhyDB loot tables, maybe something is up with them? If this destroys it even more I will have to revert it then.
ŧechnique,
the one and only
0

#9 User is offline   paroxysm 

  • Chatty Cathy
  • Group: Retired
  • Posts: 320
  • Joined: 25-June 08
  • Gender:Male
  • Server OS:Windows

Posted 15 April 2011 - 02:08 PM

[14:05][Arcemu]ObjectMgr: Tried to add association to item 17345 for non-existen
t quest 1126.
[14:05][Arcemu]ObjectMgr: Tried to add finisher to go 179485 for non-existent qu
est 1193.
[14:05][Arcemu]ObjectMgr: Tried to add starter to go 174599 for non-existent que
st 1514.
[14:05][Arcemu]ObjectMgr: Tried to add finisher to npc 14325 for non-existent qu
est 1318.


These are left.
0

#10 User is offline   technique 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 145
  • Joined: 19-June 08
  • Gender:Male
  • Location:Underground
  • Interests:Emulation?
  • Server OS:Other

Posted 15 April 2011 - 03:41 PM

Strange. You might wanna run the cleanups located here as well http://arcemu.org/fo...showtopic=24157

As soon as I have time I'll get things straight again.
ŧechnique,
the one and only
0

#11 User is offline   Marforius 

  • Permanantly on leave
  • PipPipPipPip
  • Group: Members
  • Posts: 597
  • Joined: 07-August 08
  • IRC:Marforius
  • Gender:Male
  • Location:Rome
  • Interests:ArcEmulatorius
  • Server OS:Linux

Posted 19 April 2011 - 09:18 PM

See if you can use anything from Pathway should be a few rare books/gossips in there - I know I skewed most quests up but I was very short on time to collect them all.
0

#12 User is offline   ssalter 

  • Newbie
  • Group: Members
  • Posts: 8
  • Joined: 18-September 08

Posted 11 June 2011 - 11:05 AM

This looked hopeful. I just installed ArcEmu 4249 trunk and tried the WhyDB (which didn't exist the last time I was fooling with this stuff!) since NCDB apparently wasn't supported. Things worked fine except some spell errors and such on the console.

Downloaded this sql dump and ran it on my arc_world db. No errors except the batch file run (Navicat) just kept running forever. Maybe that is associated.

Ok, problems:

on world startup I see things like:

[11:50][Arcemu]ScriptMgr has registered a dummy aura handler for Spell ID: 27012
( Hurricane ), but spell has no dummy aura!
[11:50][Arcemu]ScriptMgr has registered a dummy aura handler for Spell ID: 48978
( Bladed Armor ), but spell has no dummy aura!
[11:50][Arcemu]ScriptMgr has registered a dummy aura handler for Spell ID: 49390
( Bladed Armor ), but spell has no dummy aura!
[11:50][Arcemu]ScriptMgr has registered a dummy aura handler for Spell ID: 49391
( Bladed Armor ), but spell has no dummy aura!


Then, when the client connects there is zero spawn and the console shows a LOT of messages such as:

[12:04][Arcemu]MapCell: Failed spawning Creature 1412 with spawnId 9713 MapId 1
[12:04][Arcemu]MapCell: Failed spawning Creature 1412 with spawnId 9719 MapId 1
[12:04][Arcemu]MapCell: Failed spawning Creature 1420 with spawnId 10355 MapId 1

[12:04][Arcemu]MapCell: Failed spawning Creature 5782 with spawnId 41066 MapId 1

[12:04][Arcemu]MapCell: Failed spawning Creature 1420 with spawnId 10353 MapId 1

[12:04][Arcemu]MapCell: Failed spawning Creature 1420 with spawnId 10370 MapId 1

[12:04][Arcemu]MapCell: Failed spawning Creature 4262 with spawnId 33331 MapId 1

[12:04][Arcemu]MapCell: Failed spawning Creature 1420 with spawnId 10341 MapId 1



Any ideas?

Thanks.
Steve

UPDATE: I shouldn't rely on Navicat. That enormous sql dump overwhelmed it. I just dropped arc_world, recreated it, re-setup the structure, and then imported the sql dump via Mysql command line.

That got rid of the spawn errors.

I still get the "dummy aura" errors and things like:

[13:38][Arcemu]Spell ID: 20585 ( Wisp Spirit ) has a dummy effect ( 0 ) but no h
andler for it.
[13:38][Arcemu]Spell 10848 ( Shroud of Death ) has an apply dummy aura effect, b
ut no handler for it.

but at least the NPCs have appeared!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users