[Release] NCDB Milestone 0.2.3 !!!

Quote:

---

---------------------------------------------------------------------------------
------ - Next-Chapter Database Milestone 0.2.3 - ------
----- - Build #663 - -----
---------------------------------------------------------------------------------
General
- Party Loot support!
- Fully Redone Playercreateinfo for all the classes and the races.
- Fully Redone Playercreateinfo_Bars for all classes and races.

Battlegrounds, Raids & Dungeons
- All levels for Multimode instances are corrected! Heroic and normal instances will have the correct level rates!.
- Auchenai Crypts
* Re-Done Instance Spawns
- RageFire Chasm
* Adjusted Global Respawn for all creatures inside the instance.
- Deadmines
* Adjusted Global Respawn for all creatures inside the instance.
- Wailing Caverns
* Adjusted Global Respawn for all creatures inside the instance.
- Shadowfang Keep
* Adjusted Global Respawn for all creatures inside the instance.
- The Stockades
* Adjusted Global Respawn for all creatures inside the instance.
- Blackfathom Deeps
* Adjusted Global Respawn for all creatures inside the instance.
- Gnomeregan
* Adjusted Global Respawn for all creatures inside the instance.
- Razorfen Kraul
* Adjusted Global Respawn for all creatures inside the instance.
- The Scarlet Monastery
* Adjusted Global Respawn for all creatures inside the instance.
- Razorfen Downs
* Adjusted Global Respawn for all creatures inside the instance.
- Zul'Farrak
* Adjusted Global Respawn for all creatures inside the instance.
- Uldaman
* Adjusted Global Respawn for all creatures inside the instance.
- Maraudon
* Adjusted Global Respawn for all creatures inside the instance.
- Temple of Atal'Hakkar
* Adjusted Global Respawn for all creatures inside the instance.
- Sethekk Halls
* Correct incorrect ranks for all creatures inside the instance.
- Shadow Labyrinth
* Correct incorrect ranks for all creatures inside the instance.
- Auchenai Crypts
* Correct incorrect ranks for all creatures inside the instance.
- The Steamvault
* Correct incorrect ranks for all creatures inside the instance.
- Karazhan
* Corrected Gold Dropped By Bosses.
- Warsong Gulch
* Spirit Healers have been removed from this map.
* The maximum player can play at same match increased to 20 players.
- Arathi Basin
* The maximum player can play at same match increased to 30 players.
- Caverns of Time: Hyjal Summit
* Corrected Anetheron's loot template
- Blade's Edge Arena
* The minimum level requirement for the arena have changed.
- Zul'Aman
* The minimum level requirement for the arena have changed.
- Black Temple
* Illidan Stormrage is now counted as boss.
* Fixed Black Temple questline.

Trainers, Spells & Professions
- Adjusted train prices for some of the First Aid bandages
- Apprentice profession ranks are now counted as Profession.
- Corrected Level Requirement for Blessing of Might Rank 4
- Correct Spell Requirement for all posions spells for rogues.
- Grumnus Steelshaper is now teaching Armor Crafterers how to craft the following items:
* Breastplate of Kings
* Bulwark of Kings
* Bulwark of the Ancient Kings
* Embrace of the Twisting Nether
* Nether Chain Shirt
* Twisting Nether Chain Shirt
* Earthforged Leggings
* Heavy Earthforged Breastplate
* Stormforged Hauberk
* Truesilver Breastplate
* Truesilver Gauntlets
* Windforged Leggings
- Avenger's Shield Rank 2 is avilable for all trainers that should have it.
- Doctor Gregory Victor is now a First Aid trainer.
- Doctor Gustaf VanHowzen is now a First Aid trainer.
- Iorioa is now a Portal trainer.
- Mi'irku Farstep is now a Portal trainer.

World Environment
- Fixed all creatures & spawns related to Black Temple chain quest.
- Master Pyreanor is now spawned in Orgrimmar.
- Filled Herbs with Questitems
- Chicken don't give repeatable quest anymore.
- Fixed Flametongue Totem rank 5 and Grounding Totem spawn / apply aura effect
- Quel'dorei Magewraith: Creatures have been added to the world.
- New creatures added to the database:
* Mistress of the Mines.
* Ronag the Slave Driver.
* Seer Kanai.
- Corrected Health to the follwing creatures
* Halaani Guards.
* Plainstriders.
- Corrected Faction of the following creatures:
* Gyll.
* Gringer.
* Crazed Murkblood Miner.
* Lesser Nether Drake.
* Scalewing Serpent.
* Ridgespine Stalker.
* Suraku.
* Jorus.
* Zoya.
* Malfas.
* Onyxen.
* Vornaku.
- Corrected NPCFlags to the following creatures
* All Creatures related to Hunter Mid-level questline
* All Creatures related to Priest Mid-level questline
* All Creatures related to Shaman Mid-level questline
* All Creatures related to Paladin Mid-level questline
* All Creatures related to Warrior Mid-level questline
* All Creatures related to Rogue Mid-level questline
* All Creatures related to Warlock Mid-level questline
* All Creatures related to Mage Mid-level questline
* All Creatures related to Druid Mid-level questline
* All Creatures related to ALL mages quest.
* Chicken
* Tirion Fordring
* Chef Jessen
* Yenniku
* Foggy MacKreel
* Sentinel Selarin
* Vorrel Sengutz
* Private Hendel
* Balos Jacken
* Henze Faulk
* Onin MacHammar
* Taskmaster Fizzule
* Spirit of Kirith
* Corporal Thund Splithoof
* Homing Robot OOX-17/TN
* Stone Watcher of Norgannon
* Pilot Xiggs Fuselighter
* Nyrill
* Commander Gor'shak
* Kharan Mighthammer
* Marshal Windsor
* Sha'ni Proudtusk
* Gaeriyan
* Cyrus Therepentous
* Grark Lorkrub
* Arei
* Bijou
* Vaelan
* Awbee
* Finkle Einhorn
* Magistrate Marduke
* Rigger Gizelton
* Narain Soothfancy
* Stormpike Quartermaster
* Frostwolf Quartermaster
* Zaetar's Spirit
* Reginald Windsor
* Vaelastrasz the Corrupt
* Commander Mulfort
* Commander Louis Philips
* Smith Regzar
* Wing Commander Jeztor
* Wing Commander Mulverick
* Primalist Thurloga
* Murgot Deepforge
* Commander Duffy
* Commander Karl Philips
* Wing Commander Ichman
* Wing Commander Slidore
* Wing Commander Vipore
* Frostwolf Wolf Rider Commander
* Arch Druid Renferal
* Field Marshal Teravaine
* Stormpike Ram Rider Commander
* Frostwolf Stable Master
* Stormpike Stable Master
* Celebras the Redeemed
* Mountaineer Boombellow
* Jotek
* Stomper Kreeg
* Knot Thimblejack
* Highlord Demitrian
* Daio the Decrepit
* Vartrus the Ancient
* Stoma the Ancient
* Hastat the Ancient
* Raedon Duskstriker
* Primal Torntusk
* Smith Slagtree
* Katoom the Angler
* Huntsman Markhor
* Elder Torntusk
* Gelvas Grimegate
* Yebb Neblegear
* Chronos
* Rinling
* Kruban Darkblade
* Morja
* Deathmaster Dwire
* Heart of Hakkar
* Riggle Bassbait
* Jang
* Fishbot 5000
* Baristolth of the Shifting Sands
* Merithra of the Dream
* Caelestrasz
* Arygos
* Windcaller Yessendra
* Warden Haro
* Keyl Swiftclaw
* Andorgos
* Kandrostrasz
* Vethsera
* Meridith the Mermaiden
* Windcaller Kaldon
* Eye of C'Thun
* Forest Wisp
* Colossus Researcher Sophia
* Colossus Researcher Nestor
* Colossus Researcher Eazel
* Valadar Starsong
* Lunar Festival Herald
* Lunar Festival Emissary
* Lunar Festival Harbinger
* Fariel Starsong
* Mokvar
* Mux Manascrambler
* Ysida Harmon
* Falrin Treeshaper
* Bodley
* Spirit of Lord Valthalak
* Dirk Thunderwood
* Rohan the Assassin
* Huntsman Leopold
* Mataus the Wrathcaster
* Rimblat Earthshatter
* Dispatch Commander Metz
* Guard Didier
* Ambassador Sunsorrow
* Craftsman Wilhelm
* Bloodsail Traitor
* Bronn Fitzwrench
* Rumsen Fizzlebrack
* Mupsi Shacklefridd
* Wravien
* Gradav
* Kamsis
* Taleris Dawngazer
* Emissary Whitebeard
* Emissary Gormok
* General Kirika
* Marshal Bluewall
* Scout Bloodfist
* Rifleman Torrig
* Magistrix Elosai
* Ambassador Dawnsinger
* Vindicator Palanaar
* Anchorite Truuen
* K'ure
* Defender Sorli
* Kurenai Captive
* Mag'har Captive
* Archmage Leryda
* Kristen DeMeza
* Sal'salabim
* Mother Kashur
* Chief Researcher Kartos
* Spy To'gun
* D'ore
* Thrall
* Cryo-Engineer Sha'heen
* Greatfather Aldrimus
* "Dirty" Larry
* Wing Commander Gryphongar
* Runetog Wildhammer
* Gryphoneer Windbellow
* Image of Wind Trader Marid
* Captured Protectorate Vanguard
* Earthmender Wilda
* Spirit of Ar'tor
* David Wayne
* Neltharaku
* Kor'kron Wind Rider
* Evergrove Druid
* Skywing
* Vindicator Haylen
* V'eru
* Sky Commander Keller
* Skyguard Prisoner
* Suraku
* Jorus
* Onyxien
* Malfas
* Zoya
* Voranaku
* Brewmeister Bilger
* Zaruk
* Vol'jin
* Warosh the Redeemed
* Lord Tirion Fordring
* Lorekeeper Javon
* Dreadsteed Spirit
* Overseer Oilfist
* Janela Stouthammer
* Arcanist Nozzlespring
* Merok Longstride
* Shadow Priestess Shai
* Advisor Sorrelon
* Aeranas
* Advisor Duskingdawn
* Advisor Sunsworn
* Architect Nemos
* Whitebark's Spirit
* Aether-tech Apprentice
* Mathredis Firestar
* Cork Gizelton
* Magister Aledis
* Sa'at

Quests
- Corrected all creatureloot %s for Warlocks quests
- Nethermine Cargo is now lootable.
- Clamlette Surprise Removed Quest Requirement.
- Corrected all objectloot related to Krasus's Compendium.
- Corrected ReqItemCount for Felendren the Banished
- Corrected Thirst Unending ReqKill
- Securing the Supply Lines: Removed Prequest becouse of core bug
- Fixed The Battle for Alterac Req Kill
- Fixed Curing The Sick (Horde and Alliance version)
- Corrected drop for Metal Coffer
- New Quests have been added:
* In Service of the Illidari.
* Enter the Taskmaster.
* Crazed and Confused.
* Netherwing Crystals.
* Nethermine Flayer Hide.
* Redemption of the Ashtongue.
* Seek Out the Ashtongue.
* The Fall of the Betrayer.
* Stand Tall, Captain!.
* Rise, Overseer!.
* The Netherwing Mines.
* Picking Up The Pieces...
* Bow to the Highlord.
* Hail, Commander!.
* Dragons are the Least of Our Problems.
- Fixed a wrong Gameobject from the quest the First Trial.
- Fixed the itempages for all the items from the Coldridge Valley quests.
- Fixed the gameobject for the Bloodscale Wanted Poster and quest.
- Corrected Provitem and Reqkillmob for all Taming The Beast quests
- Corrected Provided Items and Quest Objectives for the quests Related to
Hunter's Pet Quests..
- Adjusted and fixed quest starter/finisher to the following quests:
* WANTED: Syndicate Personnel.
* WANTED: Baron Vardus.
* WANTED: Baron Longshore.
- Adjusted and fixed the following Alchemy's quests:
* Elixirs for the Bladeleafs.
* Master of Elixirs.
* Master of Potions.
* Master of Transmutation.
- Adjusted and fixed the following mage's quests:
* Glyphic Letter
* Glyphic Memorandum
* Glyphic Scroll
* Glyphic Tablet
* Mage Training
* Mage Training
* Fetch!
* Ju-Ju Heaps
* Mage-tastic Gizmonitor
* Mirror Lake
* Recently Living
* Speak with Anastasia
* Speak with Bink
* Speak with Jennea
* Speak with Un'thuwa
* The Balnir Farmstead
* The Purest Water
* Control
* Gathering Materials
* Gathering Materials
* Manaweave Robe
* Report to Anastasia
* Report to Jennea
* Spellfire Robes
* A Simple Robe
* Arcane Reavers
* Investigate the Alchemist Shop
* Investigate the Blue Recluse
* Astral Knot Garment
* High Sorcerer Andromath
* Laughing Sisters
* Nether-lace Garment
* Pristine Spider Silk
* Speak with Deino
* Waters of Xavian
* Ur's Treatise on Shadow Magic
* Get the Scoop
* Hidden Secrets
* Journey to the Marsh
* Celestial Power
* Items of Power
* Mage's Wand
* Mana Surges
* Return to the Marsh
* The Infernal Orb
* The Exorcism
* Power in Uldaman
* Rituals of Power
- Fixed and Adjusted Mid-level questline for Druid:
* Torwa Pathfinder
* Bloodpetal Poison
* Toxic Test
* A Better Ingredient
- Fixed and Adjusted Mid-level questline for Hunter:
* The Hunter's Charm
* Courser Antlers
* Wavethrashing
* The Green Drake
- Fixed and Adjusted Mid-level questline for Mage:
* Magecraft
* Magic Dust
* The Siren's Coral
* Destroy Morphaz
- Fixed and Adjusted Mid-level questline for Paladin(Alliance):
* Chillwind Camp
* Dispelling Evil
* Inert Scourgestones
* Forging the Mightstone
- Fixed and Adjusted Mid-level questline for Paladin(Horde):
* To The Bulwark
* Prove Your Hatred
* Wisdom of the Banshee Queen
* Ancient Evil
- Fixed and Adjusted Mid-level questline for Priest:
* Cenarion Aid
* Of Coursers We Know
* The Ichor of Undeath
* Blood of Morphaz
- Fixed and Adjusted Mid-level questline for Rogue:
* A Simple Request
* Sealed Azure Bag
* Encoded Fragments
* The Azure Key
- Fixed and Adjusted Mid-level questline for Shaman:
* Elemental Mastery
* Mastering the Elements
* Spirit Totem
* Da Voodoo
- Fixed and Adjusted Mid-level questline for Warlock:
* An Imp's Request
* The Wrong Stuff
* Trolls of a Feather
- Fixed and Adjusted Mid-level questline for Warrior:
* A Troubled Spirit
* Warrior Kinship
* War on the Shadowsworn
* Voodoo Feathers

Items
- Added Epic Reputation Jewelcrafting patterns to vendors
- Fixed the broom mounts in the world tables - DEVELOPER NOTE - PLEASE FIX THIS STUPID LINE, WRITE UNDERSTANDABLE CHANGELOG!.
- Bag of Empty Ooze Containers: This item is contain loot now.
- Bloodpetal Sprout is now loot-able even when you don't have the quests.
- Corrected % loot for:
* Highland Raptor Eye
* Razorflank's Heart
* Bloodscalp Totem
* Rattlecage Skull
* All Items related to Hunter Mid-level questline
* All Items related to Priest Mid-level questline
* All Items related to Shaman Mid-level questline
* All Items related to Paladin Mid-level questline
* All Items related to Warrior Mid-level questline
* All Items related to Rogue Mid-level questline
* All Items related to Warlock Mid-level questline
* All Items related to Mage Mid-level questline
* All Items related to Druid Mid-level questline
* All Items related to ALL mage's quest.

---

Link :

DOWNLOAD NOW![FileBeam]


:count:

:poster_je

There is no new items from 2.3 patch.. :(

but there is many bug fixes for 2.3.0

what ascent rev i need for this db ?? 2.4 stable is work???

yes work :)

the wow.exe crashed when i login .. why???

i tested with stable 2.4 and 0.2.3 everything working... just fresh install new milestone upload this updates : (1649) World - Banned Phrases.sql (2074) World - Creature Names Localized.sql (2074) World - Gameobject Names Localized.sql (2074) World - Itempages Localized.sql (2074) World - Items Localized.sql (2074) World - NPC Text Localized.sql (2074) World - Quests Localized.sql

now i'm testing this db without those updates but with only one baned pharses

working fine :P

LOLZ table "spells112" don't exist :)) =))

man dont work ... i execut sql update say, but the wow.exe are crashed ..... and i execut all sql updates and the wow are stuck after load ............

thats db for 2.3.0 not for 2.2.3 you are using 2.3.0?

version of wow??? i heave 2.2.3 but the server is 2.3.0 and accept all version

no....the server dont accept 2.2.3 ;) just update your client and it will work fine ;)

ZulAman working yet?

Stable Branch 2.4 and NCDB 0.2.3 crashes like every minute... Its stupid

And the items for the new version are there?.. and other question, is best milestone that other ncdb? why?

no there is no new items in this release..

I'm testing this new db 0.2.3 with ascent stable 2.4, and works fine, but the trainers have the same bugs of older revisions, (in warriors case teaches dranei language, troll language, orc language, etc. when learn dual-wield or plate-mail or when train weapons, and don't allow train mortal strike rank 2, or revenge rank 8) any fix for this?

and the mail system doesn't work, what can I do?


Thanks.

upload some sql updates that will fix not all but some bugs

Couple of question answered

If you ascent.exe crashes with the milestone 0.2.3, then obviously, you don't reaslly know what you are doing. The SQL Updates in you're core's folder is there for an REASON. not just to look at if you're bored.

Confirm - Ascent STABLE 2.4 and NCDB Milestone 0.2.3 Are a Brilliant pair and work fine.

Thanks, Good luck.
Maphew

hope someone has a answer for this but since i updated to 2.3 i cant open my back pack hope someone knows whats wrong

Error occured at:2007-11-24 15:49:10
Line no.:64
Error Code: 1054 - Unknown column 'x' in 'field list'

Query:
INSERT INTO creature_spawns (id, entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, npc_respawn_link, channel_spell, channel_target_sqlid, channel_target_sqlid_creature) VALUES
(NULL, 18373, 558, "52,7433", "-388,22", "26,5871", "3,15172", 0, 17715, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18371, 558, "-54,4476", "-163,648", "26,3863", "0,079226", 0, 18916, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "79,9316", "41,1243", "4,2618", "1,54805", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "88,5018", "40,6629", "4,26168", "1,57554", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "81,6306", "-8,60259", "-0,0602919", "4,73428", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "77,2325", "-8,70862", "-0,0589728", "4,79698", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "86,187", "8,40783", "-0,0652589", "1,63994", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "91,6555", "8,2969", "-0,0665891", "1,56664", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "88,9876", "-41,2988", "4,26141", "4,76542", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "83,2462", "-40,9254", "4,26141", "4,75626", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "118,887", "-4,96386", "0,00798282", "1,25168", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "118,103", "2,23761", "-0,129691", "4,74736", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "144,267", "41,8539", "4,26112", "1,55497", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "150,325", "42,0356", "4,26112", "1,60079", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "189,034", "-5,63821", "0,0405801", "2,0177", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "182,907", "2,94025", "-0,122063", "5,32554", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "230,317", "19,5912", "-0,0632148", "1,45222", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "221,699", "0,75114", "-0,0857775", "3,71181", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "212,945", "-5,46786", "-0,104528", "0,544038", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "206,78", "-18,2432", "26,8615", "1,60956", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "212,545", "-18,0196", "27,3345", "1,60956", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "235,934", "-86,1576", "26,5912", "1,58573", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "243,76", "-85,972", "26,5912", "1,5949", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "226,458", "-171,258", "26,592", "0,402402", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "224,523", "-165,87", "26,592", "0,100024", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "225,261", "-159,539", "26,592", "5,96171", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "89,7118", "-154,29", "15,2643", "3,19973", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "90,1438", "-160,415", "15,2872", "3,14933", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "89,4773", "-166,255", "15,291", "3,09435", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "24,4408", "-166,286", "13,7941", "2,95612", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "24,6456", "-160,598", "13,82", "3,02851", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "-129,24", "-167,635", "26,5885", "0,126465", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "-129,8", "-158,549", "26,5892", "6,15047", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18521, 558, "-138,584", "-234,527", "26,4407", "2,06299", 0, 17991, 16, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18521, 558, "-147,972", "-233,952", "27,7351", "1,37119", 0, 17991, 16, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18524, 558, "-140,876", "-240,791", "26,4872", "2,05383", 0, 17970, 16, 0, 0, 0, 0, 0, 0, 0, 0)

Error occured at:2007-11-24 15:49:11
Line no.:64
Error Code: 1054 - Unknown column 'x' in 'field list'




Help-me No Update to new NCDB 0.2.3 Pls help-me

Error occured at:2007-11-24 15:49:10
Line no.:64
Error Code: 1054 - Unknown column 'x' in 'field list'

Query:
INSERT INTO creature_spawns (id, entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, npc_respawn_link, channel_spell, channel_target_sqlid, channel_target_sqlid_creature) VALUES
(NULL, 18373, 558, "52,7433", "-388,22", "26,5871", "3,15172", 0, 17715, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18371, 558, "-54,4476", "-163,648", "26,3863", "0,079226", 0, 18916, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "79,9316", "41,1243", "4,2618", "1,54805", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "88,5018", "40,6629", "4,26168", "1,57554", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "81,6306", "-8,60259", "-0,0602919", "4,73428", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "77,2325", "-8,70862", "-0,0589728", "4,79698", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "86,187", "8,40783", "-0,0652589", "1,63994", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "91,6555", "8,2969", "-0,0665891", "1,56664", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "88,9876", "-41,2988", "4,26141", "4,76542", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "83,2462", "-40,9254", "4,26141", "4,75626", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "118,887", "-4,96386", "0,00798282", "1,25168", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "118,103", "2,23761", "-0,129691", "4,74736", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "144,267", "41,8539", "4,26112", "1,55497", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "150,325", "42,0356", "4,26112", "1,60079", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "189,034", "-5,63821", "0,0405801", "2,0177", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "182,907", "2,94025", "-0,122063", "5,32554", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "230,317", "19,5912", "-0,0632148", "1,45222", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "221,699", "0,75114", "-0,0857775", "3,71181", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "212,945", "-5,46786", "-0,104528", "0,544038", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "206,78", "-18,2432", "26,8615", "1,60956", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "212,545", "-18,0196", "27,3345", "1,60956", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "235,934", "-86,1576", "26,5912", "1,58573", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "243,76", "-85,972", "26,5912", "1,5949", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "226,458", "-171,258", "26,592", "0,402402", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "224,523", "-165,87", "26,592", "0,100024", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "225,261", "-159,539", "26,592", "5,96171", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18495, 558, "89,7118", "-154,29", "15,2643", "3,19973", 0, 17942, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18493, 558, "90,1438", "-160,415", "15,2872", "3,14933", 0, 17924, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "89,4773", "-166,255", "15,291", "3,09435", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "24,4408", "-166,286", "13,7941", "2,95612", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "24,6456", "-160,598", "13,82", "3,02851", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "-129,24", "-167,635", "26,5885", "0,126465", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18497, 558, "-129,8", "-158,549", "26,5892", "6,15047", 0, 17910, 14, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18521, 558, "-138,584", "-234,527", "26,4407", "2,06299", 0, 17991, 16, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18521, 558, "-147,972", "-233,952", "27,7351", "1,37119", 0, 17991, 16, 0, 0, 0, 0, 0, 0, 0, 0),
(NULL, 18524, 558, "-140,876", "-240,791", "26,4872", "2,05383", 0, 17970, 16, 0, 0, 0, 0, 0, 0, 0, 0)

Error occured at:2007-11-24 15:49:11
Line no.:64
Error Code: 1054 - Unknown column 'x' in 'field list'



Pls help-me no update to new Ncdb 0.2.3 help-me

edergti you are having these problems because you are trying to execute it onto another existing database right?. This cannot be done, you must delete you're current DB to execute milestone.0.2.3 successfully.

Or add the line

Code:

---

DROP TABLE IF EXISTS 'creature_spawns';

---

This new NCDB is very good ...

So that ta very complicated hehe

How do I stay it?
I already tried all ways and nothing works

I started with

Milestone 0.2.1 to 0.2.2
Character full db

I deletei the table Creature_spawns
But we have not completely 100%

Full-Update
Full-DB

After which the first version 0.2.2?



Please help me to do something for
Remaining working ...???

http://img117.imageshack.us/img117/5448/errorjg5.png

and i get that error...

My question is when there are loaded accounts from the version 2.2.3 also it works well?

I have a problem that the ascent is closed on having tried to enter to the world with the loaded accounts...

:thumbdown

http://img213.imageshack.us/img213/8...rashtw4.th.jpg

i suppose your trying to connect 2.3.0 server with 2.2.3 client ?

How many times guys! Installing Milestone 0.2.3 onto an existing Database will NOT work. Use a clean database.

And how we should start?

The First Full-DB or Full-Update?

just upload Full DB if you want clean install if you want update you 0.2.2 then upload Full-Update

I want to know what is the first FULL DATABASE

And if need Run also UPDATE - FULL-0.2.3

???????

Please help me here

What beginning, and which I do not need?

Well let me start with beginning saying thanx for the database, i just started with the ascent thingy and this works like Charm...

All i did was applied the Banned Names and phrases updates and i imported the spell112 table from - NCDB Rev 662 (i think it was) in the worlld DB and went off playing.

Only thing is i get some error about a chris folder and object.h , andd dont seem to can adjust honor, it DCs then and dont adjust it.


Running Ascent 2427

To the poster before me :

U adjust the tool.bat and started it ? Then I guess its clear ..

hm...milestone 2.3.0 have bugs... but NCDB 669 fixed many bugs so download 669 and ascent rev 2445 and it will work PERFECTO! :D i'm using 669 superb

Yeah but those little 669 dont upgrade ur DB and if u install it ur db will be clean. So i only use milestones

but 669 revs fixed many bugs...just spawn missed npc and works perfect ;)

i forgot portals some portals doesnt work you need to spawn new

so youre saying forget milestone and just import rev 669?

Can we have a link for Rev. 669?

How about all the quest updates etc, u have more info bout that rev. ?? I just "lended"the missin 112spell table from the other on the milestone...

hi every body can u help me . when i install ncdb milestone vrsion 0.2.3 it error code
Error Code: 1054 - Unknown column 'x' in 'field list' how to config it to right ,
and how to config the too to run too.bat if some one can help me pleace replay to the my email Yahoo! thank u :(

Ascent is not for beginners! If you don't know what that error means, stick to an easier emulator.

help me . when i install ncdb milestone vrsion 0.2.3 it error code
Error Code: 1054 - Unknown column 'x' in 'field list'


help me here

need run FULL-UPDATE ?

all are different from each other

please :( HELP-ME

read paco's post above you'rs