WhyDB

History for whydb-users/

← Previous

Revision Author Commited Message
157 MesoX picture MesoX Sat 05 Nov, 2011 22:32:07 +0000
  • Applied ArcEmu DB updates up to revision 4693
  • Some waypoint cleanup
  • instance_bosses fixup
  • Removed War Effort Volunteer’s from spawn
  • Removed AQWar Resource objects from spawn
  • Removed a very lost, lonely anvil from Ironforge
  • The Grand Apothecary Putress in Shattrath City has been moved to the right coords
  • Whatever these Imps are, they shouldn’t be spawned now
  • Removed an incorrectly spawned Ahn’Qiraj Gong from the stairs outside the Scarab wall (The Scarab Dais)
  • Vaelastrasz the Corrupt is no longer surrounded by Death Talon Seether’s
  • Removed an incorrect spawn of Vaelastrasz in Blackwing Lair (Different entry than the real one)
  • Removed two large Orc Tents outside of Orgrimmar
  • Removed two incorrect and hostile Wolf spawns from The Crossroads (At the stables)
  • Reputation requirements for the quests of Eldara Dawnrunner
  • Quest ‘The Battle Must Go On’ is no longer available before completing 'The Battle for the Sun’s Reach Armory'
  • Quest ‘Distraction at the Dead Scar’ is no longer available before completing ‘The Air Strikes Must Continue’'
  • Removed a very lost Flamewaker Healer from Molten Core
  • Deleted five very lost Flamewaker Elites from Molten Core
  • Deleted Ragnaros from Molten Core (He is spawned by script)
  • Removed Majordomo Executus, his minions and his chest from Molten Core (Script event)
  • Removed Spirit of Minshina from spawn (Script)
  • Removed two Hallucination from spawn (Script)
  • update PVP status for some NPCs
  • hacky fix for the quest Vorsh athe Lasher (but it works as intended now :P)
  • Argent Peacekeeper has their ranged weapons equipped now
  • Fixing level and health for Shadowglen Sentinel
  • Fixing level and health for Shadowprey Guardian
  • Fixing level for Custodian of Time
  • The Black Morass fix for required heroic key and a quest + flags
  • Quest The Fate Of The Fallen – now the quest item spell can be cast only on npc 32149
  • Quest Ally of the Netherwing rewarded items
  • Updated ICC and Ruby Sanctum dungeon types and flags
  • Fixed some oversized anvils (note, how big they were before, I swear they were preparing somethin'...!)
  • Deleting some not used graveyards
  • Some new worldstates for outland
  • Around 1000 gameobjects get their faction fixed
  • Mails are beeing sent fter finishing some quests

As always, thanks to our community, as most of these fixes comes from forums :)
Specially thanks to Satanail, technique and Sadikum for most of these fixes (and ofc me)
156 MesoX picture MesoX Thu 29 Sep, 2011 18:50:12 +0000
  • Changing back table structure for db_version table, which is here to inform users,

what they have in their database in case they want to update their database themselves.

  • Appliead ArcEmu SQL updates up to revision 4598
  • Filled up table vehicle_accessories, thanks dfighter
  • Updated 285 creatures to act as vehicles
  • Updated another over 6 thousands creatures with new spells in fields spell_*
  • Some various updates of vehicles in Wintergrasp (thanks Sindastra)

Thanks to all contributors!
155 Sadikum picture Sadikum Thu 04 Aug, 2011 01:31:31 +0000

Forget to upload new arcemu_db_version.sql and delete totemspells.sql
154 Sadikum picture Sadikum Wed 03 Aug, 2011 21:44:52 +0000

Changeset 105:
* Delete Spirit guide in Warsong Gulch and Eye of The Storm (they’re spawned by the core).
* Fixes for Falconwing Square by jak.
* Fixed Thaelis the Hungerer’s waypoints (thanks jak).
* Some misc fixes by Satanail in the Argent Tournament (thanks to him).
* Fixe Kaalif, Shaani and Mar’nah factions, thanks technique.
* Delete a bunch of waypoints from creature which should not move (thanks technique).
* Delete some bad npc_gossip_textid (thanks technique again).
* Lady Katrana Prestor is no longer in game (thanks technique).
* Add a lot of PVP guards (thanks Satanail).
* Some fixe for Onyxia lair’s trash stats (thanks Satanail & UDB).
* Fixed quest : A Charitable Donation (thanks technique).
* Setting a lot of spell(1-4) from UDB, thanks to them again.
* 305 trainer with wrongnpcflags fixed.
* Applied SB@L sql to fix beast master (see Arcemu r4289).
* Applied SQL structure changes from Arcemu up to r4378.
* Fill the new spelldataid column with data from UDB (thanks).
Fully compatible with the latest Arcemu (r4424 atm).

FIXED : A query in creature_proto_npc_flags_fix.sql
153 Sadikum picture Sadikum Tue 05 Apr, 2011 16:26:15 +0000

* Fixed quest starter for Quest #6069 (The Hunter’s Path)
* Fixed Serpent-Touched Berserker not counting toward quest Foundation for Revenge
* Redid whole gameobject_quest_pickup_binding and gameobject_quest_item_binding
* Fix for 1 more item that sold for gold and badges
* Npc selling free honor that isnt even suppost to sell stuff http://www.wowhead.com/npc=15350
* Removed dalaran visters falling from sky (these are event only)
* Violet Hold Guards should not be attackable
* Fixed required targets for spell id #19512 (Quest Curing the Sick)
* Fixed Required quests for Tame the beast quests
* All creature quest starters and finishers have been redone!
* Fixed few gameobject states (according to arcemu r4054).
* Add some missing itempages and deleted those which are unused.
* Add 6 missing items.
* Delete a wrong entry in item_quest_association.
* Add a lot of emote for quests (thanks UDB).
+ Update some extra files
152 MesoX picture MesoX Sat 19 Feb, 2011 00:59:49 +0000

* added missing loot for fishing pools and tons of other missing objects.
* Correctly fixed a quest chain, thanks Satanail.
* Fix 287 others quests' RequiredQuest.
* Update ffa_loot field for all loot tables.
* Redo instance_bosses table

  • Add vendors template for Blazik Fireclaw (30885), Ziggle Sparks (8116) and Moonrage Armorer (3529).
  • Set trainer flag to trainer who hadn’t it.
  • Fix all pet trainers.
  • Add trainer template for Alenndaar Lapidaar (8308).
  • Fix creature with trainer flag which doesn’t trainer anything.
  • Redo reputation_creature_onkill (Thanks UDB and YTDB).
  • A few quests fix (Thanks UDB).
  • 4 new ai_threattospellid and some have been updated (Thanks to UDB again).
  • 25 new teleport_coords (UDB).
  • Fixed where 2 arcanums where sold one with rep requirement one without rep requirement.
  • Fixed some items that sold for money and badges.
  • Fixed 2 vendors spawning on top of each other.
  • Corrected Argent Skytalon’s health and level.
  • Deleted bad spawns from all arenas.
  • Fixed taming quests.
  • Fixed many creatures, which shouldn’t have any waypoints. (Thanks to DragonM15)
  • Corrected some spawns' orientations. (Thanks to DragonM15)
  • Alterac Valley has some GOs and NPCs scripted and spawned trough core so delete them from DB (Thanks to Satanail)

And many more! Thanks to all contributors, please keep up the good work!
151 Sadikum picture Sadikum Mon 03 Jan, 2011 23:00:21 +0000

HAPPY NEW YEAR EVERYONE !!! BEST WISHES FOR 2011 !!!
Rev 151 is out!
* Fix level, health and damage for Northsea Thug (25843).
* Zedd, Mage-Commander Evenstar, Slain Trapper, Fallen Earth Warrior and Surveyor Orlond are now a dead.
* Fix the spell casted by Imp Minion (12922).
* Fix the faction of Prisoner in The Stockades.
* You can now talk to Scourge Gryphon to fly up/down.
* You can now enter in Ruby Sanctum and Icecrown Citadel in heroic mode, thanks sanctum32.
* Add recall to the enter of Icecrown Citadel, Wyrmrest Temple and Ruby Sanctum and fix the one to Naxxramas, thanks sanctum 32.
* Fix npcflags of Great Bear Spirit (11956), thanks xxfrozen.
* Questlevel field of the quests table is no longer unsigned and the value have been updated.
* Fix some quests Requirement, thanks Satanail.
* Add 2 missing teleport_coords
* Fully redo table item_quest_association (Now full and 100% blizzlike)
And the Database is now compatible with Arcemu structure 3955.

Also updated world_optimize.sql to work correctly with latest revisions and handle all new tables.
150 MesoX picture MesoX Tue 07 Dec, 2010 23:16:18 +0000
  • Updated to newest ArcEmu revision
  • re-checked table loot_gameobjects, deleted/updated what was bad, refactored this table and updated to newest structure
  • deleted bad keys from tables ai_agents and vendors
  • Added spawn for creature: Tu’u’gwar
  • Fixed taxi flag for Frax Bucketdrop
  • Fixed gameobject spawns for Drakkari Canopic Jar
  • Fixed gameobject spawns for Splintered Bone Chunk
  • Updated around 450 quests' RequiredQuests, IncompleteTexts, CompleteTexts, ExploreTriggers etc.
  • Fixed target location for mage spell: "Teleport: Dalaran"
  • Fixed other 140 teleport spells missing in ArcEmu update
  • Added some other missing spawns and update creature informations for around 30 creatures
  • Fixed Northrend Alchemy Research – now researching correct spell at correct chances
  • Fixed Weapon Masters

And many more!

Many thanks to our contributors: Tiramisu, andriuspel, sanctum32, Yoshii and others
149 MesoX picture MesoX Mon 15 Nov, 2010 19:57:54 +0000
  • Seems I really like to upload old tables back to SVN without changesets added in them :/
148 MesoX picture MesoX Sun 14 Nov, 2010 17:36:51 +0000

Whoa changeset 100!

  • Updated 9441 quests to 3.3.5 patch (well updated around 9100 + 300 new quests) - all are from blizzlike cache, so all updated values are blizzlike – that doesn’t mean it will be bug free
  • Added 1 spell click spell
  • Fixed an error in tool.bat
  • Packed changeset 91 – 99 into 1 zip file
147 Sadikum picture Sadikum Sun 14 Nov, 2010 11:18:51 +0000

Changeset 99:

  • Update whydb to last arcemu structure (r3812).
  • Fill the tables quest_poi and quest_poi_points with data from UDB and YTDB (thanks to them).
  • Fill the new field in quest table with data from cache (all quests have now the right XP reward).
  • Add 305 new npc_text, 67 itempages and 85 teleport_coords from UDB (thanks to them).
146 MesoX picture MesoX Mon 08 Nov, 2010 19:28:21 +0000

Fixed version of 2.4.3 database, including latest 2.4.3 dataz, but structure is updated to work with latest 2.4.3 ArcEmu core.

Hopefully it works this time without any startup errors, if you notice any problems, let us know on forums.
145 MesoX picture MesoX Wed 29 Sep, 2010 13:55:19 +0000
  • 2.4.3 Database, many users are asking for it, so there you have it :P
144 MesoX picture MesoX Mon 27 Sep, 2010 09:30:12 +0000
  • Hmm this line in tool.bat have to be more visible and efficiency now.
143 Black2754 picture Black2754 Fri 24 Sep, 2010 21:08:58 +0000

added UNIX specific information to the HOWTO
142 MesoX picture MesoX Fri 24 Sep, 2010 20:16:36 +0000
  • Update description for 2 items.
  • Add teleport_coords for Cannon Prep spells.
  • Repair quest: Buying Some Time, missing kill requirement, thanks Tiramisu.
  • Update Salvageable Wood/Steel gameobject_spawns entry, thanks Cynmod.
  • Update requirement for Alliance Triage quest, thanks Tiramisu.
  • Update requirement for A Yeti Of Your Own quest.
  • Update spell for items Recipe: Succulent Orca Stew and Recipe: Showeltusk Soup.
  • Make quests non repeatable that shouldn’t be, thanks Tiramisu.
  • Make quests repeatable that should be, thanks Tiramisu.
  • Oshu’gun Crystal Powder quest corrections, add required quests, thanks Tiramisu.
  • Fix Aldor/Scryer quest reputation rewards, thanks Tiramisu.
  • DK starting area quest: A special surprise, thanks to Tiramisu.
  • Remove incorrect reputation reward from The Apple Falls, thanks Tiramisu.
  • Repair quest: The Return of the Crusade?, missing kill requirement, thanks Tiramisu.
  • Scourgestone quests missing starter and finisher NPC entries, thanks to Tiramisu.
  • Deleted some event specific spawns
  • Deleted some rare spawns which had multiple spawn points
  • Processed around 5 very huge WDB files, thanks to Jordythery and volitall
  • Fix minlevel for 46 maps.
  • Fixed death state for Ruby Dragon
  • Fixed 1 go to have blizzlike GO ID
  • Deleted creature “Waypoint” from database, it was causing fuckups for quests
  • Updated item Pioneer Buckler to be 100% blizzlike
  • Updated item Grimoire of Blood Pact (Rank 3) to be 100% blizzlike
  • Updated item Everglowing Robe to be 100% blizzlike
  • Updated item Grimoire of Devour Magic (Rank 6) to be 100% blizzlike
  • Updated item Boots of Ferocity to be 100% blizzlike
  • Updated item Grimoire of Intercept (Rank 2) to be 100% blizzlike
  • Updated item Grimoire of Anguish (Rank 2) blizzlike
  • Updated item General’s Scaled Greaves to be 100% blizzlike

all items with ID up to 37487 are 100% blizzlike. More will come in next release.

Also added little HOWTO, which explains usage of our tools. More info will be added soon. Also for other operating systems.
141 Black2754 picture Black2754 Thu 23 Sep, 2010 18:43:21 +0000
  • removed some bad lines in creature_names translations
140 Black2754 picture Black2754 Tue 14 Sep, 2010 19:39:03 +0000
  • redone loot_skinning
  • redone loot_pickpocketing
  • redone disenchanting part of loot_items
  • reverted r139

This is the continuation of r137. This should fix drop rates for quest items being too low and generally make rates somewhat more blizzlike.
Again, there is no changeset. Please reimport the three affected tables (or the whole database, if you prefer).
139 claudenegm picture claudenegm Wed 08 Sep, 2010 14:27:53 +0000
  • items_localized.sql reverted to the first rev released.
138 Black2754 picture Black2754 Fri 03 Sep, 2010 17:47:56 +0000
  • added new localisation data for items and creatures
  • removed some obsolete localisation data
137 Black2754 picture Black2754 Fri 03 Sep, 2010 13:57:26 +0000
  • redone loot_creatures
  • redone loot_gameobjects

This should fix a lot of issues with drop rates for quest items being too low and certain objects (chests, herbs, veins, ...) being always empty while others are not.
Other loot tables are to be redone in a similar way.
Sorry for not providing a changeset. Please reimport the two affected tables (or the whole database, if you prefer).
136 Sadikum picture Sadikum Tue 31 Aug, 2010 23:56:00 +0000

Remove some useless folder (and Debug folder which contain a lot of outdated file, and anyway they’re only useful to dev)
Update items_localized for french and add item for german.
135 MesoX picture MesoX Wed 25 Aug, 2010 17:46:33 +0000
  • Oh missed to update db_version :)
134 Black2754 picture Black2754 Wed 25 Aug, 2010 17:31:21 +0000
  • fixed a typo in the latest changeset
133 MesoX picture MesoX Wed 25 Aug, 2010 17:04:26 +0000

Changeset 97:

  • Fixed itemnames table – now all sets are showed correctly when you equip/deequip them
  • Gameobject Spawns in Ruby Sanctum have been redone to be more blizzlike
  • Some new Gameobjects for Ruby Sanctum added
  • Deleted wrong spell_coef_overrides
  • Fixed Gameobject Underworld Power Fragments
  • Fixed Gameobject Soul Font
  • Fixed NPC High Priestess Tua-Tua
  • Fixed NPC High Priest Hawinni
  • Fixed NPC High Priest Mu’funu
  • Fixed NPC Quetz’lun Worshipper
  • Fixed NPC Serpent-Touched Berserker
  • Fixed NPC Gooey Ghoul Drool
  • Fixed NPC Ghoul Feeding KC Bunny
  • Fixed NPC Alarmed Blighguard
  • Fixed Voltarus – Zul’drak areatriggers
  • Fixed NPC Blight Geist spell
  • Fixed few rare NPC positions
  • Fixed Gameobject Chunk of Saronite
  • Fixed Quest Bringing down Heb’Jin
  • Fixed Gameobject Zol’maz strongold cache
  • Fixed few gameobjects spawn
  • Added 5833 new waypoints
  • Fixed some triggers invisiblity
  • Fixed Quest The Leaders at Jin’Atai
  • Fixed NPC Jin’Alai Medicine Man + added his AI
  • Fixed NPC Jin’Alai Warrior + added his AI
  • Fixed Quest Eggs for Dubra’Jin
  • Fixed Quest A Yeti Of Your Own
  • Fixed texts for Undercity guards
  • Fixed Item Recipe: Succulent Orca Stew
  • Fixed Item Recipe: Showeltusk Soup
  • Fixed NPC Encased Electromental
  • Many new updates from cache files
  • Updated over 9000 spawns with new bytes0 – problems with non responding NPCs should be gone
  • Updated structure of ai_agents
  • Zone redone – Zul’Drak, will be finished in further revision
  • There shouldn’t be any GOs on some BG maps
  • Fixed 2 required targets for 2 spells (Flaming Spear and Sceptre of Suggestion

Thanks to all our contributors !

← Previous

Rss Commits for whydb-users:/