WhyDB
|
Citation :-- Index have been redone, all table now have a PRIMARY one and some have KEY.
-- Update 147 ai_threattospellid and add 93 new.
-- Add 27 itempetfood and update a lot of them
-- Update/add some itempages
-- Update/add some npc_text
-- Add some spell_coef_override
-- Redo playercreateinfo table to correct some starting value.
-- Some quest, spawns and creature by andriuspel, thanks to him.
-- Redo playercreateinfo and playercreateinfo_bars, thanks to andriuspel for reporting some bugs.
-- Structure up-to-date for last arcemu rev.
-- Optimize the whole database.
Citation :* creature_spawns have been redone including:
- possible ALL raids (also ICC, RS etc.)
- newest Argent Tournament
- almost all values updated ( mostly bytes and flags, also emotes and weapons - over 51 000 creatures has weapons now ! )
- updated spawns in all main cities (including also battlemaster changes included in one of the latest patch )
- invisible creatures are now really invisible, visible dummy targets no more!
- all original dungeons have been redone
- many updates to outland and northrend dungeons too !
- flying npc should be flying !
NOTE: there still may be some NPCs missing or some, which should be deleted, feel free to post them on our forums / or fix them by yourself
* creature_waypoints redone - redone from 0 ! original whydb contains around 140 000 waypoints, new table has around 420 000 waypoints !
* creature_names updated - added informations from cache files, that means we updated over 5000 NPCs and added a lot of useful creatures for scripts
* creature_proto updated - updated mostly damage values, health, armor, resistances, respawn times, levels etc. for almost all creatures! Also added a lot of new missing creatures
* added ai_agents for creatures in Ruby Sanctum
* areatriggers - fixed many old areatriggers + added 2 new ( Ruby sanctum entrance + exit)
* battlemasters - fixed battlemasters table regarding to blizzlike values !
* creature quest finishers and starters have been redone too, added a lot of missing and deleted useless old starters and finishers
* updated 974 gameobjects from retail cache files
* redone gameobject quest starters and finishers
* added tons of missing spawns for gameobjects ! Mostly dungeon related objects or/and a lot of them were updated in old world too
* updated table instance_bosses with new values
* added new itempages and updated a lot of old itempages
* updated and added few missing items for 3.3.5a
* added tons of new gossip texts for creatures in world ( around 1000 )
* added around 1304 new npc_monstersay events ! Let's make world more living
* added new profession discoveries - now you will able to discover new recipes from spell Northrend Alchemy Research
* redone table reputation_creature_onkill now you get reputation from creatures also in northrend dungeons
* AND MANY, MANY MORE!
Thanks to: Lich, leonardo14, S@lwy for helping me with waypoints, UDB, YTDB for some informations
Notes: Although spawns and waypoints took me ~ 5 months, there still may be bugs, mainly due to ArcEmu's vmaps not working correctly. You may notice some bugs regarding creature movement in caves or in buildings (moving trough walls, falling down trough floors) - feel free to report them or fix them and post your fixes on forums
Note2: We are really sorry that we will not commit changeset this time, changes in this revision are too huge to be in 1 changeset file.