[DATABASE] Next Chapter Database [Ascent,Mangos]

[Walla!]

Hey,
I See that my database not really known around here, so i would like to post it here.

NCDB is a global database that works on Mangos, Ascent (Soon to come: Wcell,SpuriousEmu) By using web installer.

Features:

• Eastern Kingdoms & kalimdor fully redone, 300k new waypoints.
• Outland's Instances & Raids fully redone, including fantastic visualization (flying waypoints, instance patrols & ALOT MORE).
• Blizzlike Quests, Creature, Items & Gameobjects(ripped from retail) as of patch 2.4.2
• Fully redone creature ai(10k rows).
• Fully redone trainers (50k rows).
• And alot of bugs fixes.

NCDB SVN is:
Revision 33: /

NCDB Latest release can be found here:
Revision 33: /trunk

NCDB Installation guidelines:
Installation - Next Chapter

Forum:
Next Chapter Community

Full Changelog

Revision: 33
Author: Walla
Date: 21:34:35, יום ראשון 27 יולי 2008
Message:
Works with(or newer): Arcemu Rev: 505 | Mangos Rev: 6387 | Ascent Rev: 4597
Web Installer
- [MANGOS] Added new step: Pre-queries for areatriggers.
NCDB Team
- Ruins of Ahn'Qiraj and Temple of Ahn'Qiraj spawns fully revamped.
- Sunwell creature stats have been updated.
- All missing spirit healers have been added.
- Humar the Pridelord is now spawned.
- Added more missing items(32 items) from patch 2.4.x.
- Smiling Jim have now gossip.
- Added teleport coords for spell "Stormwind to Dustwallow Teleport".
- All fixes from old revision that were not included, are included now.

Community Patches
- http://nc-db.info/showthread.php?tid=508
- http://nc-db.info/showthread.php?tid=498
- http://nc-db.info/showthread.php?tid=497

Revision: 32
Author: Walla
Date: 17:35:41, יום שני 21 יולי 2008
Message:
Works with(or newer): Arcemu Rev: 185 | Mangos Rev: 6334 | Ascent Rev: 4597
Web Installer
- Incorrect Integer Value has been corrected, regardless the mysql mode you have.
NCDB Team
- Molten core & Zul'Farak spawns are fully revamped.
- Quest Zone Or Sort have been fully rewrited!.
- Updated Viewing Distance to all world maps!.
- All Innkeepers have been fixed!.
- All Class trainers now offer reset talent.
- All Battlemasters are now working, players will be able to talk with the battlemasters and join the battleground.
- Gorrim Is now flight master!.
- Theremis Now sell Skyshatter Cord.
- Inscriber Veredis now sells Inscription of the Blade and Inscription of the Knight.
- Haughty Modiste Is now a vendor and offer to sell: Pattern: Haliscan Jacket and Pattern: Haliscan Pantaloons.
- Haris Pilton is now a vendor and offer to sell:"Gigantique" Bag, Gold Eternium Band, Noble's Elementium Signet, Ruby Shades, Sapphire Pinky Ring.
- Added Ice Block to Mage trainers
- Mycah now sells Pattern: Mycah's Botanical Bag.
- Grella now sells Nether Ray Fry.
- Manna-Enriched Horse Feed has now fixed requirements.
- Karazhan key quests have been fixed & adjusted.
- More corretions to spell teleport coords.
- Arcane Tomes and Fel Armaments quests are repeatable.
PSDB Team
- Fixed Missing trainerrs.
- Added 284 Missing items.
Community Patches
http://www.nc-db.info/showthread.php?tid=413
http://www.nc-db.info/showthread.php?tid=409
http://www.nc-db.info/showthread.php?tid=405

Revision: 31
Author: Walla
Date: 18:51:38, שבת 12 יולי 2008
Message:
Works with: Arcemu Rev: | Mangos Rev: 6270 | Ascent Rev: 4597

NCDB Team
- Sunwell instance is now spawned.
- Zul'Aman instance revamped.
- Thunder bullf city is now correctly spawned.
- Added even more items missing from patch 2.4
- Class trainers are able to reset talents now.
- Paladin now teaches correctly Judgement spell.
- Trauma Surgeon npc's now teaches first aid spells correctly.
- Druid's Flight form level requirements have been set to 68.
- Druid trianers now offer moonfire rank 6.
- Dual Wield can be learnt now.
- Rogue Trainers now teach Instant Posion rank 1.
- Rampage rank 2 can be learnt now.
- Correct Stats for Razorthorn Flayer and Ember of Azzinoth.
- Silva Fil'naveth and Bunthen Plainswind now offer you to fly between taxi nodes.
- Master Smith Burninate now offer quests, items and item's repair.

PSDB Team
- Mounts updated to level 30.
- Creature AI Fixes

Revision: 30
Author: Walla
Date: 21:03:01, שבת 05 יולי 2008
Message:
Updated Mangos rev support to mangos 6220 and newer.
NCDB Team:
- Massive fixes for mangos, alot of bugs have been sorted out(around 50k emu warnings have been sorted our, but they are still alot of warnings left).
- Season 4 started! updated/added vendors, spawns and items!.
- Spawed Red cloud mesa.
- Added alot of missing items from patch 2.4.
- Added missing creature loot (including patch 2.4 creatures)
- areatrigger_involvedrelation and fully redone.
- updated level requirement for all instances.
- entire database have been cleanup form useless data.
- updated and adjusted some creature levels(150 creatures).
- Many! Many more changes and improvements.
Community Patches:
- [FIX] Arena Season set 1- http://www.nc-db.info/showthread.php?tid=330
- [FIX] Some Skinning Fixes - http://www.nc-db.info/showthread.php?tid=335
- [ADD] Missing object - 188215  - http://www.nc-db.info/showthread.php?tid=331
- [FIX] Exploit Arena Season 2 - http://www.nc-db.info/showthread.php?tid=345
- [ADD] Magister's Terrace RewRep - http://www.nc-db.info/showthread.php?tid=349
- Elder Mottled Boar Wrong level - http://www.nc-db.info/showthread.php?tid=289

Revision: 29
Author: Walla
Date: 21:49:55, יום שני 30 יוני 2008
Message:
NCDB Team:
- Fully Rewrote RewXP and RewFaction for most(all?) quests.
- Netherwing hated to neutral quests requirements fixed
- Attunement to the core obsolete quest removed
- "Hunter training", "Well watcher Solanian", "Hidden enemies" quests requirements fixed
- The dread citadel Naxxramas (Naxxramas attunement quest) maxreputation added (no effect for Ascent/Arcemu at the moment, dunno about Mangos, but later with emu support it will work properly :-))
- Added all new tier 6 items to Theremis (the vendor).
- Fully rewrote class trainers.
- Added pet trainers.
- Fixed most problems regarding mount & profession trainers.
- Removed Bogus creature's ai.
NCDB Web Installer:
+ [NewStep] Items ExtandedCost cleanup (ArcEmu/Ascent).
+ [NewStep] Finish step (Mangos).
SVN:
+ DBC To CSV Converetor.

Revision: 28
Author: Walla
Date: 21:53:23, יום ראשון 29 יוני 2008
Message:
NCDB Patches:
- Fully new creature ai table, most data provided by santa(11k entries, please report about bugs).
- most (all?) quests that should be repeatable, are repeatable.
- Dual wield now added to all trainers who supposed to teach it.
- fixed quests of http://www.wowhead.com/?npc=10618
- Imp isn't hostile to player and npc's anymore.
Community Patches:
[Fix] All missions of the heroic daily - http://nc-db.info/showthread.php?tid=298
[Fix] Loot Bagdes - http://nc-db.info/showthread.php?tid=297
13 Random hp/lvl fixes - http://nc-db.info/showthread.php?tid=295
[Fix] Fel Orc Corpse should be dead and lying down. - http://nc-db.info/showthread.php?tid=292

Revision: 27
Author: Walla
Date: 10:44:19, יום ראשון 29 יוני 2008
Message:
Fixed ascent.

Revision: 26
Author: Walla
Date: 19:11:20, שבת 28 יוני 2008
Message:
- Added support for AscentEmu Rev 4597 (and newer).

Revision: 25
Author: Walla
Date: 12:19:38, שבת 28 יוני 2008
Message:
- Supports ArcEmu Rev 185(and newer) | Mangos Rev 6179(and newer)
NCDB patches:
- Almost all outland instance spawns have been FULLY redone:
   * Auchindoun: Auchenai Crypts
   * Auchindoun: Mana-Tombs
   * Auchindoun: Sethekk Halls
   * Auchindoun: Shadow Labyrinth
   * Coilfang Reservoir: The Steamvault
   * Coilfang Reservoir: The Underbog
   * Tempest Keep: The Arcatraz
   * Tempest Keep: The Botanica
   * Tempest Keep: The Mechanar
   * Coilfang Reservoir: Serpentshrine Cavern
   * Tempest Keep: The Eye
   * Gruul's Lair
   * Karazhan
   * Black Temple
   * Hellfire Citadel: Hellfire Ramparts
   * Hellfire Citadel: The Blood Furnace
   * Hellfire Citadel: The Shattered Halls
- The following zones are now (re)spawned:
   * [CITY] Orgrimmar.
   * [ZONE] Mulgore.
- 2.4.2 Portal Trainers fixes.
- corrected required races for quest 9552
- some reqsourceitem fixes
- added spells to portal trainer in exodar
- some Isle of QuelDanas quest fixes for quests :11554, 11555, 11556 and 11557
- skinning loot fixes for npcs: 23020 and 23026
- some Isle of QuelDanas quest fixes for quests :11554, 11555, 11556 and 11557
- skinning loot fixes for npcs: 23020 and 23026
Community Patches:
- Ripped Creature Levels and Quests level requirement from Armory, http://www.nc-db.info/showthread.php?tid=233.

Revision: 24
Author: Walla
Date: 22:48:30, יום רביעי 25 יוני 2008
Message:
NCDB Team updates:
- Map 1 Spawns Revamp, some zones might be empty, PLEASE report about those zones if you want to see them getting fixed.
- Morgan's Vigil is now spawned.
- Fixed Black Temple creature's equipment.
- Fixed all duplicates in RecItem columns.
- Fully redone aquatic form quest chains.
- gameobject bind for quests: 9882, 9883
- Dungeon 2 quests have been fixed(db part).
- Added 2 missing Naaru spawns.
- Fixed some of Children's Week quests (ReqRaces).
NCDB Community Patches:
- Profession Fix - http://www.nc-db.info/showthread.php?tid=237
- Galen Goodward - http://www.nc-db.info/showthread.php?tid=228
- Shattered Sun & Quel'danas quests - http://www.nc-db.info/showthread.php?tid=217
- Lots of hp/level fixes - http://www.nc-db.info/showthread.php?tid=214
- Isle of Quel'Danas Quest ReqLevel - http://www.nc-db.info/showthread.php?tid=210

Revision: 23
Author: Walla
Date: 10:08:47, יום רביעי 25 יוני 2008
Message:
- Fixed : Waypiont displayid Syntax Column 'forwardskinid' cannot be null

Revision: 22
Author: Walla
Date: 00:20:38, יום רביעי 25 יוני 2008
Message:
The instances following instances have been fully revamped(regarding spawns,waypoints and formations):
  * Hellfire Citadel: The Blood Furnace.
  * Hellfire Citadel: The Shattered Halls.

Revision: 21
Author: Walla
Date: 18:16:08, יום שלישי 24 יוני 2008
Message:
- Black Temple (MapId :#564) has been fully revamped, introducing you amazing environment that you have never seen.
- Creature proto generation fix.

Revision: 20
Author: Walla
Date: 13:07:09, יום שלישי 24 יוני 2008
Message:
- Updated database to work with mangos steps.
- Added workaround folder + gossip workaround for those who want to fix the npcflags.

NOTE: There is no support for workarounds.

Revision: 19
Author: Walla
Date: 12:59:45, יום שלישי 24 יוני 2008
Message:
NCDB is now fully support mangos.

NOTE: Mangos and ArcEmu are still in early stages, please report any bug you find at our forum.

Revision: 18
Author: Walla
Date: 11:34:24, יום שני 23 יוני 2008
Message:
Reverted.

Revision: 17
Author: Walla
Date: 11:29:52, יום שני 23 יוני 2008
Message:
Added Web Installer.

Revision: 16
Author: Walla
Date: 19:24:56, שבת 21 יוני 2008
Message:
- Fixed Areatriggers teleport bug. Coords taken from UDB, so BIG thanks.
- Fully Fixed Trainer requirements.

NCDB is can be considered as stable, just DON'T forget to read
http://nc-db.info/wiki/index.php/Installation

New table:
creature_spell_groups, fast introducion:
GroupEntry - SpellGroup Entry Id (linked in creature_template.SpellGroup)
SpellId - SpellId the mob from this spellgroup will cast(1 row for each spell).

Revision: 15
Author: Walla
Date: 15:00:44, שבת 21 יוני 2008
Message:
- Some random fixes for : rare creatures, trainers and fishing loot.
- For some reason about 3k spawns were not convert during the installation, fixed now.
- Updated fishing zones to the currect level.
- Fully redone battleground_battlemaster table.
- Added new creatures template to the database.
- Removed some old season object spawns.
- Trenton Lighthammer now has a gossip.
- Full revamp to spells_teleport_coords table.

Revision: 14
Author: Walla
Date: 13:08:40, שבת 21 יוני 2008
Message:
- Fixed waypoint flags, should fix any error related to integer value error.

Added patches:
  * Wrong loot fix - http://nc-db.info/showthread.php?tid=181
  * Medallions of the Horde/Alliance - http://nc-db.info/showthread.php?tid=197
  * [All Around] My Fixes - http://nc-db.info/showthread.php?tid=196
  * 3 quests requirements - http://nc-db.info/showthread.php?tid=185
  * Mote Gas Clouds For Engineer - http://nc-db.info/showthread.php?tid=138
  * Shattrath portals - http://nc-db.info/showthread.php?tid=182
  * [Recall] Typo Fix - http://nc-db.info/showthread.php?tid=178
  * Shattered Sun Offensive - quest rep. rewards - http://nc-db.info/showthread.php?tid=200
Fixed the following bugs:
  * Can't get into sunwell - http://nc-db.info/showthread.php?tid=189

Revision: 13
Author: Walla
Date: 00:10:20, שבת 21 יוני 2008
Message:
+ Fixed instance portal for :
   * Magisters' Terrace.
   * The Sunwell.

Revision: 12
Author: Walla
Date: 16:12:27, יום שישי 20 יוני 2008
Message:
+ Magisters' Terrace is now fully spawned.
- Isle of Quel'Danas spawns got fixed + ai.
- Map 0 Spawns are now fully working.
- Creature_proto is now generated as meant to be.
- Other fixes as well.

Revision: 11
Author: Walla
Date: 00:32:20, יום שישי 20 יוני 2008
Message:
- Graveyards are now fully working. (lol :|)

Revision: 10
Author: Walla
Date: 23:26:31, יום חמישי 19 יוני 2008
Message:
- Creature equipment fully redone.
- Creature mount display fixed.
- Added batch file for base database.
- Fixed "Column 'forwardskinid' cannot be null" bug.
- Graveyards and areatriggers should be fixed. (please report back)
- Fixed mount trainers.
- Applied patches:
http://nc-db.info/showthread.php?tid=157
http://nc-db.info/showthread.php?tid=133
http://nc-db.info/showthread.php?tid=150
http://nc-db.info/showthread.php?tid=152
http://nc-db.info/showthread.php?tid=159
http://nc-db.info/showthread.php?tid=162
http://nc-db.info/showthread.php?tid=112
http://nc-db.info/showthread.php?tid=160
http://nc-db.info/showthread.php?tid=164
http://nc-db.info/showthread.php?tid=136

Unrelated Structure changes:
battleground_template | New columns: Map1,Map2,Map3,Type,Band,IsActive.

Revision: 9
Author: Walla
Date: 23:41:42, יום שלישי 17 יוני 2008
Message:
- WI convert tool improvement and bug fixes.
- Removed all the duplicate spawns ingame!.
- NPCFlags redone.
- Fixed Frostsaber health. Patch provided by dfighter.
- Fixed trainer_spells structure. Patch provided by sarsen.
- GameObject Type 8. Patch provided by xinef.
- Bauble Container is now spawned. Patch provided by xinef.
- Teleport coords update. Patch provided by demossiah.
- Playercreateinfo updated. Patch provided by demossiah.

Revision: 8
Author: Walla
Date: 03:22:42, יום שלישי 17 יוני 2008
Message:
- Fixed map 0 spawns [=.
- Fixed AreaTrigger #2534 [Stormwind (Inside) - near Old Town].
- Orgrimmar Grunt now got gossip flag.
- Items_ExtendedCost added (Thanks to WhyDB).
- New instances are now working(not spawned!).

Revision: 7
Author: Walla
Date: 22:52:45, יום שני 16 יוני 2008
Message:
- Fixed SQL Dump.
- Fixed Bat file.
- Fixed: http://nc-db.info/showthread.php?tid=52
- Fixed some typo.

Revision: 6
Author: Walla
Date: 22:21:08, יום שני 16 יוני 2008
Message:
Sorry, now it should work.

Revision: 5
Author: Walla
Date: 22:20:07, יום שני 16 יוני 2008
Message:
Fixed Bat file.

Revision: 4
Author: Walla
Date: 22:18:45, יום שני 16 יוני 2008
Message:
Fixed Warning within the parser, patch provided by santa.

Revision: 3
Author: Walla
Date: 21:25:32, יום שני 16 יוני 2008
Message:
+ Added map 0 new spawns (Old table: 23k spawns, 10k waypoints. |  New table: 25k spawns, 130k waypoints.)
+NOTE: Database structure will not be automatically imported as of installation process, you'll have now to browse into sql structure and configure up the bat(windows users) or sh(*nix users) to chose destination.
- Fixed: http://nc-db.info/showthread.php?tid=49.
- Fixed: http://nc-db.info/showthread.php?tid=51.

Revision: 2
Author: Walla
Date: 12:49:39, יום שני 16 יוני 2008
Message:
+ Shattrath is now spawned.
+ Database structure will be automatically imported as of installation process.
- Fixed installation bugs related.
- Fixed Trainers step.
* Installation interface has been improved.

Revision: 1
Author: Walla
Date: 18:20:51, שבת 14 יוני 2008
Message:

[Power of Illuminati]

Your database is pretty unknown here beacuse of the extremly hard way to install it. Is it no other way for your team to fix it?

[Ickybad]

Well Its nice I think the webinstaller is VERY easy because all your doing is pulling over some files configing them then putting them in Xamp or Wamp and then you make 2 DB's one named NCDB one name anything really. Then execute the database.sql in the database.rar into the ncdb database then go into the webinstaller folder and find sql's and execute what ever emu your usings format.

[Walla!]

Next commit will have big improvements to the convertor, you won't need to create destination database anymore + alot of bugs fixes.

[2dgreengiant]

I See that my database not really known around here, so i would like to post it here.

wtf? everyone uses NCDB almost and if im correct most databases are based off NCDB . It's either NCDB or whydb for most people.

[BrantX]

I use NCDB and Whydb... But i got a question. After Brutallus there is a bunch of "Shadowsword Fel-Elves" there and no db i used has them... Am i just not seeing this right? or is it like completely unknown. lol?

[arigity]

wtf? everyone uses NCDB almost and if im correct most databases are based off NCDB . It's either NCDB or whydb for most people.

someone made a remark in wow general stating "whats ncdb" and after seeing their was no thread for it here, walla probably decided to make one.

[volitle]

yeh ive stopped using ncdb because when i use the web installer i either get some sort of insert error or create spawns is missing

[Strupantwn]

I use NCDB and Whydb... But i got a question. After Brutallus there is a bunch of "Shadowsword Fel-Elves" there and no db i used has them... Am i just not seeing this right? or is it like completely unknown. lol?

Those are trash mobs . . .

[BrantX]

Those are trash mobs . . .

Yeah... butz i want them spawned... :P