NCDB 31 is available on the SVN.....
Printable View
NCDB 31 is available on the SVN.....
which db is the best for arcemu?
WHY DB is the best atm
WhyDB195
Finally got my brains together to (hopefully) not make mistakes...
Updates protos correct level faction and min/maxhealth min/max damage
Some Spawns.. waypoints
Added some items from 2.4 and 2.4.3 (last one wont work yet but they're in @ least, need lots of work to be done to make it 2.4.3 ^^)
Updated some missing details in quests.sql
Added Missing objectloot.sql
----
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/creature_waypoints.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/objectloot.sql
Modified : /development/ascent_world/quests.sql
Added : /development/changesets/changeset_39.sql
NCDB31
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
----
Modified : /trunk/sql/database.rar
Modified : /trunk/web installer/index.php
Modified : /trunk/web installer/sql/mangos.sql
WhyDB196
/*Haris Pilton needs to Be a vendor 2.4.3*/
/*Removing some shit*/
/*2.4.3 Items (Only will work with 2.4.3 DBC) like Big Battle Bear ^^*/
/*Some 2.4 Items where free, not anymore*/
/*Lady Palanseer fix (AGAIN!)*/
/*Missing Objectloot*/
/*Some More Missing Items (Midsummer Festival stuff)*/
----
Modified : /development/ascent_world/creature_names.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/items_extendedcost.sql
Modified : /development/ascent_world/objectloot.sql
Modified : /development/ascent_world/vendors.sql
Added : /development/changesets/changeset_40.sql
Modified : /tool.bat
NCDB32
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
----
Modified : /trunk/sql/database.rar
Modified : /trunk/web installer/index.php
Modified : /trunk/web installer/sql/mangos.sql
Modified : /trunk/web installer/c_copytable_p1.php
WhyDB197
Modified Tool not to load the moon ++ crap sql, if u want it load it manually
/*Ancient gem vein exploit fix */ Thanks to maestro
/*Medallion of the Horde/Alliance*/ Thanks to Recon
/*The Black Bride* Thanks weyhey15 for report
/*[Fix] Tome of divinity (ALIANCE) thanks gcanoca
/*Chain lightning rank2 learning fix*/
BIG THANKS TO sadikum for some Uber Queries ^^
/*added Even more Missing protos*/
/*added Missing name And proto 27704*/
/*added missing Can Not Train gossip text*/
/*added Missing Can Train gossip*/
/*added Missing trainer_spawns*/
/*Killed all Unused and crap Quests*/
/*Hmm some crap in formations*/
/*Dancing Flames PROTO*/
/*Midsummer Merchant*/
/*Frostsaber HP Fix*/
/*corrected money drop Rockjaw Trogg*/
/*Cassa Crimsonwing double Spawn*/
/*Headless Horseman doesnot to be mounted on himself^^*/
/*Swapped buyprice,sellprice column form some items*/
/*Fixed Blade edge Mountains some stupid mobs*/
----
Modified : /development/ascent_world/creature_formations.sql
Modified : /development/ascent_world/creature_names.sql
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/creature_waypoints.sql
Modified : /development/ascent_world/creatureloot.sql
Modified : /development/ascent_world/gameobject_names.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/items_extendedcost.sql
Modified : /development/ascent_world/npc_text.sql
Modified : /development/ascent_world/quests.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/ascent_world/vendors.sql
Added : /development/changesets/archive/changesets 31-40.rar
Deleted : /development/changesets/changeset_31.sql
Deleted : /development/changesets/changeset_32.sql
Deleted : /development/changesets/changeset_33.sql
Deleted : /development/changesets/changeset_34.sql
Deleted : /development/changesets/changeset_35.sql
Deleted : /development/changesets/changeset_36.sql
Deleted : /development/changesets/changeset_37.sql
Deleted : /development/changesets/changeset_38.sql
Deleted : /development/changesets/changeset_39.sql
Added : /development/changesets/changeset_41.sql
Modified : /tool.bat
WhyDB199
Community Fixes Thanks guys...
Added into changesets/changeset_41.sql
/*Halazzi hp fix by Recon*/
/*Fix all incorrect factions by ActioN*/
/*FIX faction for Scorchshell Pincer by minho*/
/*Riding trainers + lvl 30 mounts*/
/*corrected Haris Pilton by recon*/
/*Shadowsword Vanquisher and Shadowsword Assassin - Djhenghiz*/
/*loot of Badge of Justice (29434) By Black*/
/*--Fix Syphon and Mana Feeder faction to be non-neutral (Karazhan)*/
/*--Fix the curators scale so he's not going through the roof (Karazhan)*/
/*-- Spawn Echo of Medivh at the chess event by millsu2*/
/*--Arklon Crystal Artifact quest item should be a 100% chance drop from Pentatharon when you have the quest by millsu2*/
/*Pyroblast rank 10 needs rank 9,*/
/*-- Chain lightning rank2 learning fix -- maestro*/
Seems i cant move them to added on the forum :( Bummer since Cyber is taking a break @ campzone
----
Modified : /development/ascent_world/creature_proto.sql
Modified : /development/ascent_world/creature_spawns.sql
Modified : /development/ascent_world/creatureloot.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/changesets/changeset_41.sql
WhyDB204
/*Added these Fixes from community*/ there in changeset_42.sql
/*Crap in Ai_agents by Recon*/
/*[FIX] Ai_agents - Chain Heal by Vincent*/
/*-- Make healing wave rank 5 heal npc instead of target -- by Maestro*/
/*Naberius Fixed the Books ^^*/
/*fishing books and firstaid*/
/*Hmm more trainer_spells which the parse project missed ??*/
/*Palladin thanks to Naberius*/
----
Modified : /development/ascent_world/ai_agents.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/changesets/changeset_42.sql
can you start uploading the whydb with db installer plz? or as one big sql file?
i have a problem.. i try a lot of different databases and the Playerpet table doesn't stock any information.. i mean it doesn't save the pet .. i have a hunter.. i guess the information sent by client doesn't match with the Playerpet table.. and this is bad.. i can't find any solutions
NCDB33
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.
----
Modified : /trunk/sql/database.rar
Modified : /trunk/web installer/index.php
Added : /trunk/web installer/mangos/s0_queries.php
Modified : /trunk/web installer/mangos/s11_queries.php
Modified : /trunk/web installer/mangos/s1_areatrigger_teleport.php
Modified : /trunk/web installer/mangos.php
Modified : /trunk/web installer/sql/mangos.sql
Yelly204
/*Added these Fixes from community*/ there in changeset_42.sql
/*Crap in Ai_agents by Recon*/
/*[FIX] Ai_agents - Chain Heal by Vincent*/
/*-- Make healing wave rank 5 heal npc instead of target -- by Maestro*/
/*Naberius Fixed the Books ^^*/
/*fishing books and firstaid*/
/*Hmm more trainer_spells which the parse project missed ??*/
/*Palladin thanks to Naberius*/
----
Modified : /development/ascent_world/ai_agents.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/changesets/changeset_42.sql
NCDB34
Works with(or newer): Arcemu Rev: 505 | Mangos Rev: 6398 | Ascent Rev: 4597
Web Installer
- Next Chapter Web installer now automatically import destination structure into the database.
- [Mangos] New column support
NCDB Team
- Removed all gameobject duplicates.
- Fixed stats for Gorgannon.
- Quests updated into patch 2.4.2 and have now gameobject requirement aswell.
- Arena(all seasons) & Honor vendors fully fixed.
- Creature Equipment fully redone for maps 0,1 outland instance & raids.
- Updated Haughty Modiste sell template.
- Shattrath guards now mounted.
- Sunwell spawn fixes & additions.
- Minor Manifestation of Earth is now spawned.
- Anthion Harmon and Bodley are now spawned as part of Dungeon Set 2 questline.
- Added more 10 new items.
- Warrior trainers now offer to learn charge spell.
- Anwehu, Ontuvo,Technician Halmaha are now spawned.
- Priest trainer now teach Touch of Weakness.
- Fixed Trainer Load Issues
- G'eras is now spawned at his correct position.
- Selin Fireheart is now spawned.
- Added teleport position for Stonard and Theramore.
For your comfort we attached this time converted ncdb for each structure(just execute):
http://rapidshare.com/files/134534168/arcemu.rar
http://rapidshare.com/files/134534167/mangos.rar
http://rapidshare.com/files/134534169/ascent.rar
----
Modified : /trunk/sql/database.rar
Added : /trunk/web installer/ascent/s0_import.php
Added : /trunk/web installer/ascent/s0_queries.php
Modified : /trunk/web installer/ascent.php
Modified : /trunk/web installer/c_copytable_p1.php
Modified : /trunk/web installer/c_copytable_p2.php
Modified : /trunk/web installer/include/config.inc.php
Modified : /trunk/web installer/include/functions.php
Modified : /trunk/web installer/include/header.inc.php
Modified : /trunk/web installer/index.php
Added : /trunk/web installer/mangos/s0_import.php
Modified : /trunk/web installer/mangos/s10_skill_discovery_template.php
Modified : /trunk/web installer/mangos/s10_skill_extra_item_template.php
Modified : /trunk/web installer/mangos/s10_spell_teleport.php
Modified : /trunk/web installer/mangos/s11_queries.php
Modified : /trunk/web installer/mangos/s1_areatrigger_involvedrelation.php
Modified : /trunk/web installer/mangos/s1_areatrigger_tavern.php
Modified : /trunk/web installer/mangos/s1_areatrigger_teleport.php
Modified : /trunk/web installer/mangos/s2_battleground_template.php
Modified : /trunk/web installer/mangos/s2_battlemaster_entry.php
Modified : /trunk/web installer/mangos/s3_creature.php
Modified : /trunk/web installer/mangos/s3_creature_addons.php
Modified : /trunk/web installer/mangos/s3_creature_equip_template.php
Modified : /trunk/web installer/mangos/s3_creature_involvedrelation.php
Modified : /trunk/web installer/mangos/s3_creature_model_info.php
Added : /trunk/web installer/mangos/s3_creature_model_infob.php
Modified : /trunk/web installer/mangos/s3_creature_movement.php
Modified : /trunk/web installer/mangos/s3_creature_onkill_reputation.php
Modified : /trunk/web installer/mangos/s3_creature_questrelation.php
Modified : /trunk/web installer/mangos/s3_creature_template.php
Modified : /trunk/web installer/mangos/s4_quest_template.php
Modified : /trunk/web installer/mangos/s5_item_enchantment_template_a.php
Modified : /trunk/web installer/mangos/s5_item_enchantment_template_b.php
Modified : /trunk/web installer/mangos/s5_item_template.php
Modified : /trunk/web installer/mangos/s5_page_text.php
Modified : /trunk/web installer/mangos/s6_gameobject.php
Modified : /trunk/web installer/mangos/s6_gameobject_involvedrelation.php
Modified : /trunk/web installer/mangos/s6_gameobject_questrelation.php
Modified : /trunk/web installer/mangos/s6_gameobject_template.php
Modified : /trunk/web installer/mangos/s7_creature_loot_template.php
Modified : /trunk/web installer/mangos/s7_disenchant_loot_template.php
Modified : /trunk/web installer/mangos/s7_fishing_loot_template.php
Modified : /trunk/web installer/mangos/s7_gameobject_loot_template.php
Modified : /trunk/web installer/mangos/s7_item_loot_template.php
Modified : /trunk/web installer/mangos/s7_pickpocketing_loot_template.php
Modified : /trunk/web installer/mangos/s7_prospecting_loot_template.php
Modified : /trunk/web installer/mangos/s7_skinning_loot_template.php
Modified : /trunk/web installer/mangos/s8_game_graveyard_zone.php
Modified : /trunk/web installer/mangos/s8_game_tele.php
Modified : /trunk/web installer/mangos/s8_instance_template.php
Modified : /trunk/web installer/mangos/s8_transports.php
Modified : /trunk/web installer/mangos/s9_npc_text.php
Modified : /trunk/web installer/mangos/s9_npc_trainer.php
Modified : /trunk/web installer/mangos/s9_npc_vendor.php
Modified : /trunk/web installer/mangos.php
Modified : /trunk/web installer/sql/arcemu.sql
Modified : /trunk/web installer/sql/ascent.sql
Modified : /trunk/web installer/sql/mangos.sql
Deleted : /trunk/web installer/sql/mysql.exe
Deleted : /trunk/web installer/sql/nix-install.sh
Deleted : /trunk/web installer/sql/win-install.bat
I inported this sql file with SQLog and went ingame and no NPC's...