Re: [DataBase][Releases] everytime update with changelog
NCDB8
Arcemu: 834 And Newer.
Mangos: 6557 And newer.
Ascent: 5012 And newer.
NCDB Team:
- Adjusted & Fixed creature's min & max health stats for over 6000 creatures!(Map 0, 1, 530).
- Adjusted & Fixed creature's respawn time for rare creatures(Part 1).
- Adjusted & Fixed creature's creature's level, faction, equipment & movements speed (Map 0, 1, 530).
- Fixed profession ranks, where the spellid was incorrect.
- Massive fixes for trainers adding over 100 new spells to learn by trainer.
- Fixed Repeatable settings for some of the Ahn'Qiraj quests.
- Some random fixes for quest starters.
- Updated some quests requirement for Argent dawn quests & Messenger to Westfall/ Darkshire quests
- Removed few incorect loots.
- Removed fun-portals of Gurubashi Arena.
- Mangos, Ascent & Arcemu tested on Appserv strict mode and work successfully.
----
Modified : /trunk/sql/database.zip
Modified : /trunk/web installer/index.php
Modified : /trunk/web installer/mangos/s11_queries.php
Modified : /trunk/web installer/sql/ascent.sql
Modified : /trunk/web installer/sql/extra/SunPlusPlus_full.sql
Modified : /trunk/web installer/sql/mangos.sql
Re: [DataBase][Releases] everytime update with changelog
well i been away from wow for abit and now i come back and find theres even more databases out now...so my question is what is the best database to use for a blizzlike/funserver?
Re: [DataBase][Releases] everytime update with changelog
ABD Link is dead. Might want to fix that.
Re: [DataBase][Releases] everytime update with changelog
Bloodshed2007: I guess it's WhyDB or Yelly
Re: [DataBase][Releases] everytime update with changelog
WhyDB231
Deleted databaseclean.sql since it's no longer needed. This file is dynamicly created using the tool.bat
tool.bat -> no need to re-create databaseclean.sql anymore
----
Deleted : /development/ascent_world/databaseclean.sql
Modified : /tool.bat
Re: [DataBase][Releases] everytime update with changelog
WhyDB233
* Full redone reputation_creature_onkill (somebody made this table shitty ^^ )
* Added tons of new spawns for gameobjects (flowers, chests, etc. )
* Corrected entry for horde to Alterac valley
* Corrected Black qiraji resonating crystal
* Many upadates in creature_proto (like npcflags etc.)
* Many new creatureloots
* Added Teleport: Stonard, Portal: Stonard, Teleport: Theramore, Portal: Theramore with right coors, gameobjectec (portals), trainers and their spawns
* Added many items to item_quest_association
* Update some extended costs
* Some small updates in changeset_55
* Some updates and additions in tool.bat (thx for Sadikum and me)
* Added spawns for Windy cloud, and many other
* Some debugs
* Workaround : modImmunities
Enjoy it :P
----
Modified : /development/ascent_char/empty_character.sql
Modified : /development/ascent_char/empty_logonserver.sql
Modified : /development/ascent_world/areatriggers.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/creatureloot.sql
Modified : /development/ascent_world/gameobject_names.sql
Modified : /development/ascent_world/gameobject_spawns.sql
Modified : /development/ascent_world/item_quest_association.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/quests.sql
Modified : /development/ascent_world/reputation_creature_onkill.sql
Modified : /development/ascent_world/teleport_coords.sql
Modified : /development/ascent_world/trainer_defs.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/ascent_world/vendors.sql
Modified : /development/ascent_world/worldbroadcast.sql
Modified : /development/ascent_world/worldmap_info.sql
Modified : /development/changesets/changeset_55.sql
Added : /development/changesets/changeset_56.sql
Added : /development/extras/Debug/Loots/get_loot_count.sql
Added : /development/extras/Debug/Reputation
Added : /development/extras/Debug/Reputation/Duplicite reputations.sql
Added : /development/extras/workaround
Added : /development/extras/workaround/modImmunites
Added : /development/extras/workaround/modImmunites/modimmunites.sql
Modified : /tool.bat
Re: [DataBase][Releases] everytime update with changelog
WhyDB236
Added latest ArcEmu world updates to full database, no changeset.
----
Modified : /development/ascent_world/creatureloot.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/quests.sql
Modified : /development/ascent_world/trainer_spells.sql
Modified : /development/ascent_world/vendors.sql
Modified : /development/ascent_world/worldstring_tables.sql
Re: [DataBase][Releases] everytime update with changelog
WhyDB236 - 23.7 Mb
WotLK244 WhyDB - 416.4 Kb
[*] Changed the link in the tools to the right website - how could we ever forget that :([*] Added WotLK.bat to simply change the current trainer_spells table to the WotLK TEST table.[*] Added WotLK directory + BETA version of trainer_spells table.[*] Deleted outdated Sun++ SQL file, for accurate SQL file -> please check Sun++ SVN.[*] Added latest SQL updates released by ArcEmu. WhyDB fully supports ArcEmu again ;) No need to apply the SQL's yourself.
This said, now check the trainer_spells (and issues with it):
What should be working?
- WoW + BC class trainers + spells which you can learn from them
- WoW + BC + WotLK primairy profession trainers + spells which you can learn from them
- Armor spells which can be learned from some trainers
- Weapon spells which can be learned from some trainers
Known issues:
- Secondary professions aren't working yet, since Wowhead removed the list of NPC's which should teach them.
- As said above, but with the exception of a few spells (like certain bandages in First Aid). There's no way to add a secondary profession yet, but if you manually add one, you should be able to learn the follow-up spells from the trainer in some cases.
- As said above, riding isn't supported with the exception of the new Ice-flying thingy. Currently added to 3 NPC's.
NOTE: Issues with this table need to be reported in a special thread. http://www.whydb.org/forum/viewforum.php?f=29
Have fun testing!
* Finally :P Added wotlk playercreate info ! WhyDB for the best !
* Ah also added worldmap_info
* updated again :P
* New Stuff for WotLK
- areatriggers for dungeons - now all dungeons can be accesed by players
- recalls for northrend ( i think all zones and some dungeons )
- redony worlmap_info with all repops
Enjoy!
Re: [DataBase][Releases] everytime update with changelog
Dj one more question um the runeforges and all other stuff works now normaly ??
Re: [DataBase][Releases] everytime update with changelog
Re: [DataBase][Releases] everytime update with changelog
* Graveyard table totaly rewriten! Including new graveyards in Northrend ! Need testing and some cleanups.
Re: [DataBase][Releases] everytime update with changelog
WhyDBWotLK246
Updated WotLK trainer_spells table.
[*] Fixed Paladin aura's[*] Fixed sub-catagory professions (for example Engineering - Goblim)[*] Druid now unlearn old spell when manacost is the same as the rank before.
Re: [DataBase][Releases] everytime update with changelog
WhyDB244[*] Few new gameobjects[*] Season 4 fix, by maestro[*] Latest ArcEmu worldupdate included in Full DB, NOT in changeset![*] Tool.bat typo's fixed..[*] Lots 'n lots of community fixes, too many to name, thanks everyone!!!
----
Modified : /development/ascent_world/areatriggers.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/creatureloot.sql
Modified : /development/ascent_world/gameobject_names.sql
Modified : /development/ascent_world/gameobject_quest_starter.sql
Modified : /development/ascent_world/gameobject_spawns.sql
Modified : /development/ascent_world/item_quest_association.sql
Modified : /development/ascent_world/itempages.sql
Modified : /development/ascent_world/items.sql
Modified : /development/ascent_world/quests.sql
Modified : /development/ascent_world/teleport_coords.sql
Modified : /development/ascent_world/vendors.sql
Modified : /development/ascent_world/worldbroadcast.sql
Added : /development/changesets/changeset_57.sql
Modified : /tool.bat
Re: [DataBase][Releases] everytime update with changelog
Hello the link WhyDb244 not work sorry for my inglish i`m spanish.:rolleyes:
Thanks you.
Re: [DataBase][Releases] everytime update with changelog