v2.0.9

mangoszero database version 2.0.9 released!

With this release we mostly focussed on bug fixes, and missing data. The full
list of changes is available below.

Changes

• reimplementing older fixes
• Quest Event script for quest 75 The Legend of Stalvan
• Quest start scripts for Quest 68 74 The Legend of Stalvan
• Fixing OfferRewardText for Quests 1004 1018 1019 1047 A new frontier
• Remove TBC script for Lady Sylvanas Windrunner for the Lament of the Highborne
• Fix queststartobject for quest 6284 Arachnophobia
• fix questitem dropchance for quest 1093 super reaper 6000
• fix of earlier commit
• corrected reputation values for Stonetalon Mountains
• MinLevel and Level corrections for Stonetalon Mountains
• corrected factions for quest 6421 Boulderslide ravine
• Corrected XP Value to pre TBC for Quest 1089 The Den
• added DB support for quest 1221 Blueleaf Tubers
• Spawn and attack Script for Quest 881 Echeyakee
• SQL statement added to prevent error on update
• Add creature placeholder for modelid 15234 used in transformation from Hook of the Master Angler
• Added teleport location.
• Added core update for primary key on version table.
• Added a few hints for #122 to prepare a fix.
• Added core update for commands renamed.
• Fixed #57 - health for creature 4949 has been set to an appropriate value.
• fixes #83 - Dire maul doors and torches properly reset.
• Added teleport location for Warosh's teleport.
• Added dialogue for quest 7622. This updates #102
• Comment spell script target as exasmple for missing targets.

v2.0.8: mangoszero database version 2.0.8 released!

mangoszero database version 2.0.8 released!

With this release we mostly focussed on bug fixes, and missing data. The full
list of changes is available below.

Changes

• Corrected RewMoneyMaxLevel values.
• Added fixes for * Azuregos quest chain, * Master Craftsman Omarion, * Naxxramas
• Added quest requirements.
• Corrected typos in area trigger teleports.
• Changed Blackwing Lair exit to Blackrock Spire.
• Added fix for quest 1132 to correct quest text.
• Undo removal of loot template references.
• Delete some TBC items from creature loot
• Added fixes for database startup errors.
• Added missing assignments for scripts.
• Fixes #114 - removed duplicate spawn, and related data for Cenarion Hold Infantry.
• Fixed #112 - added missing gossip menu, and condition for gossip option.
• Fixes #113 - added gossip menu, and conditional options for Orb of Command.
• Fixed #116 - Enraged Hippogryph should be friendly with Darnassus, and also not in a monster faction template.
• Fixes #117 - added Midsummer related creatures to game event.
• Fixes #9 - added missing loot condition for quest 5147.
• Fixes #22 - update experience reward for quest 8460.
• Fixes #14 - update experience reward for quest 8464.
• Fixes #3 - update experience reward for quest 4402.
• Added database updates from ScriptDev2.
• Added fixes from http://community.getmangos.co.uk/index.php?topic=20127.0 - Ubrs mobs and also lower lbrs. - Pathing. - Awbee Gossip. Source Udb - Worg Pup resize. - Warosh and Jed runewatcher. - Emotes to veteran, dreadweaver,legionnaire and Goraluk Anvilcrack. - Links 3 patrols. - Adjusts Unforged Runic Breastplate to stand. - Removes Spire Spiderling - Die on Evade' ai spell
• Added updates for many creature templates.
• Renamed scripted_event_id to scripted_event.
• Added fixes from Ela, backports from external sources.
• Droprate fix for item 11148 needed for quest 3924 samophlange Manual
• Quest end script for quest 857 the tear of the moons and feegly now pathing
• Bubbly fissure fix and fix for quest 877 The Stagnant Oasis
• Correct max reputation value for quest 9267 mending old wounds
• Reputation to pre TBC values for the barrens darkspear trolls
• XP corrections for the barrens
• Reputation to pre TBC values for the barrens
• MinLevel and Questlevel corrections for the barrens
• Required races corrections for the barrens
• Add INSERT statement that I forgot to include in my previous commit.
• Add quest start script to Vyletongue Corruption (7029 & 7041)
• Added spell targets for spells cast by Scarlet Oracle Demetria.
• Added initial spell research for spells missing a target.
• Ignore a few common temporary files, and project files.
• Lower blackrock spire fall out teleport. - Add Bijou - Added npc Naxxramas Military Sub-Boss Trigger For gothic fight - Updated Naxxramas Military Sub-Boss Trigger level. 80 to 60, and unit flag from 130 to 2 - Change Spectral death knight/Unrelenting Death Knight name also Unrelenting rider/unrelenting trainee/Spectral rider faction rank
• Ubrs: missing most fire and bonfires Ie entry to beasts room - ubrs: spider eggs - ubrs: chests - ubrs: Doodad_BOSSGATE02 draks second gate ubrs uses sd2 id - lbrs: bijous belongings - lbrs: Pooling of bijous belongings - ubrs: Adjust runes in ubrs pyroguard emberseer room and delete extra rune (theres a duplicate) - ubrs: fifth mosharu tablet place correctly (move to wall at the moment just tossed strangely in room) - ubrs: sixth mosharu tablet place correctly (move to wall at the moment just tossed strangely in room)
• Remove faerlinas surgical assistants and trash began again - Used some anub placeholders to fill in the extra missing npcs of faerlinas trash
• Embalming slime random movement add and decrease npc scale
• Minor change death touched warrior to doom touched warrior.
• Sewage slime placeholders near patchwerk are actually npc living poison. Level Updated.
• Change Weapon on Dark Touched Warrior from axe to bucket.
• Added fixes for UBRS/LBRS, and a few Naxxramas additions.
• Moved tested fixes to update pack.
• Remove two non-classic items from the npc_vendor table
• Spawn all, except patrolling, Emissary NPCs and banners in Orgrimmar.
• Add class trainer Points of Interest to Bluffwatcher (3084) gossip options. Fixes #98.
• Updated rare spawns.
• Add missing DELETE statement in my previous commit
• Add pathing to creature Seeker Thompson (14404) in Undercity. Fixes #94.
• Fixing quest 437 The death fields
• Add script for quest Fields of Grief (407)
• Spell script for spell 7669 bethors potion
• Properly quote column names in update.
• Add Points of Interest to Undercity Guardian (5624) gossip options. Fixes #86.
• Add script for the warlock summoning event in the Magic Quarter, Undercity
• Dalar Dawnweaver now using correct spell
• Reward Money and XP to pre TBC/WOTLK quest 452 Pyrewood Ambush
• Reward Money pre TBC for quest 450 a recipe for Death
• Silverpine Forest Reputation values pre TBC
• Correct MinLevels for Silverpine Forest
• Missing horde questflags for Silverpine Forest
• Add missing DELETE queries to updatepack 2.0.8
• Add gossip to Miranda Breechlock (11536) and Hasana (10856)
• Add gossip option for creature Caretaker Alen (11038)
• Quest end script for quest 771 Rite of vision
• Fixing quest 772 rite of vision
• Spawn 2 missing PvP-related NPCs (Sergeant Ba'sha & Officer Areyn)
• Quest end script for quest 755 rites of the earthmother
• Remove one unneeded fix from the last commit
• Add ~84 fixes from Project Silverpine to the next updatepack. More coming later.
• Added a bunch of fixes for testing.
• Fixing questtext quest 750 The Hunt continues
• Fixing questtext quest 747 the hunt begins
• Reputation values preTBC for Mulgore
• MinLevel Corrections for Mulgore
• Missing horde Questflags for Mulgore
• Quest start script fixes for sarkoth questline quest 790 804
• Quest end script for quest 808 Minshinas Skull
• Fixing Offer reward text for quest 842 crossroads conscription
• Removing wrong objective from quest 809 Ak zeloth

v2.0.7: mangoszero database version 2.0.7 released!

mangoszero database version 2.0.7 released!

With this release we mostly focussed on bug fixes, and missing data. The full
list of changes is available below.

Changes

• Naxxramas 40 Frenzied bats/plagued bats scale/plague beast waypoints, pt2.
• Naxxramas 40 Frenzied bats/plagued bats scale/plague beast waypoints.
• Naxxramas 40 Frenzied bats/plagued bats death lord pt1/pt2.
• Naxxramas 40 Gargoyles ooc/rock and pathing.
• Naxxramas 40 combat dummys and some repositioning/rename.
• Added pathing and emotes for Skeletal Smith, and renamed Death Knight to Deathknight.
• Added Naxxramas weapon corrections/additions.
• Add gossip to npc (3144) for quest (4941)
• Add condition to Love is in the Air vendor items
• Vile Familiars Questline fix
• reputation correction to pre tbc for durotar
• Correct MinLevel and QuestLevel for Durotar
• missing horde flags for durotar
• offer reward text for the new horde Quest 787
• Quest Welcome Questlevel Correction all factions
• Correct Required Races quest 1049 Compendium of the Fallen
• fathom stone disspawn fix
• correct required races for quest 656 summoning the princess
• Added proper graveyard connections for Blackrock mountains and related zones.
• quest end script 524 Elixir of Agony
• tirisfal reputation fix
• Hypercapazitor Gizmo quest support
• [p] fixes for quest Pyrewood Ambush
• [p] Vital Intelligence Minlevel correction
• [p] The red messenger Minlevel correction
• [p] quest fix and min level a rogues deal
• [p] fix Rot hide gnoll cast curse of thule as selfcast
• [p] A Plague Upon Thee XP correction
• [p] minlevel and xp fixes tirisfal glades
• [p] Correct MinLevel A Letter undelivered
• [p] Speak with Sevren MinLevel corrected
• [p] All missing horde questflags for tirisfal
• [p] The prodigal lich returns script
• [p] fixes pack not core dependent
• Removed 2 non-existing conditions
• Removed 2 non-existant ScriptNames
• [m] Updated full sql to match [r2420]
• Pusillin (Dire Maul) - scripted UDB 406
• Naxxramas UDB 406
• Uldaman missing chest UDB 406
• AQ20 entrance spawns UDB 406
• Changes to Corporal Teeka Bloodsnarl
• Removed randomized movement from William Kielar
• Added npc gossip to Smith Regzar
• Added npc gossip to Aurora Skycaller
• Added npc gossip to Old Ironbark
• Added npc gossip to Tal
• Changes to Silverpine Deathguard
• Removed MPs from Cenarion Outrider
• Changed the Min. Level of the quest 'The Scepter of Celebras'
• Changes to Azuregos and Spirit of Azuregos
• Repositioned the following NPCs in the Stormwind Keep
• Changes to Crimson Courier
• Removed Mana Points from all Auctioneers