[INFO] Server Upgrade Core 4263

And another upgrade!
Please read this change log carefully.

After this upgrade we will continue to support 2.3.3 only so please avoid upgrading your client to 2.3.4!
(It will be announced when we are ready for the 2.3.4 patch.)

[EDIT-UPDATE] (fixed after the official release)
Pending on server restart:
Core
-
Database
-
Scripts
-

!!Already running on the live server from here!!
Core
- fixed items getting lost from bag swaps / mails and bank swaps
- clearing the guild info (char escapes)
- crashfix Sethekk Halls (currently disabled)
- crashfix instance manatombs
- crashfix: hellfire ramparts
- dead pets casting
- Battleground: Eye Of The Storm (minimum req. 2 vs 2) special thanks to jajcer!
- fixed bank / stacked items getting lost
- lockpicking from level 307 to 325 note that the lower level lock picking is working as it should already!
- lowered the battleground que check, at least 2 vs 2 to start a battle from now on.
- relearning talents
- Client crash using guildbanks fixed
- druid Brambles
- druid natures grace
- druid control of nature
- shaman: Earth Shield
- rogue Cloak of Shadows
- mage: ice block
- priest: improved power word fortitude
- paladin: Improved Seal of the Crusader
- rogue: dispelling all debuff
- pet xp calculation based on wowiki
- pet and owner do not get xp if owner didnt participate in combat
- pet looses one happiness level upon death
- pet should defend its owner if not in passive st.
- pet fixed some logic in unit vs. unit attack reaction, so victim is victim... (should fix gaining threat from pets as well)
- pet proper untrain message
- falldamaged tweaked
- battlegrounds will need 5 ppl to join from now on
- stealth more blizzlike
- item dupe/gold exploits fixed
- fear overlapping
- arathi basin control points
- transportation (boats zeppelins!) (do not move when using the trams!)
- crash fix in the spellhandlers
- crash fix instance arcatraz
- fixed 'battleground has ended' bug
- basic implementation of pet untrain (need to finish penalties)
- added level requirement when teaching pet
- restriction to 4 active spells per pet
- Zapthrottle Mote Extractor (currently only one active swamp in Zangarmash(85,49), more will be added!)
- auto attack will no longer trigger while feared or stunned
- Illumination will now correctly display the mana restored
- new quest associations handling (will fix ~200 quests that required items)
- memory leak fixes in the battlegrounds
- flag check routines battlegrounds
- charge corrections
- some Duel fixes
- fixed spell assertion failed in OSX client
- shaman Ancestral healing
- warlock Hellfire
- warlock Shadow Trance
- warlock Soulshatter
- shaman Mana Tide Totem
- shaman Stoneclaw Totem
- Item mods
- Elevator in instance Mechanar
- Ranged damage calculation
- Warsong Gulch crash fix
- Warsong Gulch flagreturn on re-pick fixed
- Warsong gulch crash fix (isinworld)
- 32 crashfixes in 9 different instance scripts
- warrior execute
- rofue vanish
- casting another spell while one is casting will no longer remove the casting bar for the old spell
- rare item lost fix for disenchanting
- Shaman: Shamanistic focus (ty for the great report!)
- Shaman: Elemental Mastery

Database
- Another big update of npc gossips. If you seen so far, almost all npc gossips was just:
"Hello, how can i help you $n", but from now some / most of the npc will say what they should say, like in retail.(Stories and such)
- 960 faction updates
- 699 mana updates
- 429 scale updates
- 1682 creature equipment updates
- 2154 combat reach updates.
- 98 Quests adjusts.
- 30 Quest relation adjusts(quest starter / finisher).
- 1 Gameobject adjust.
- 37 Npc texts adjusts.
- Stormwind City has been fully redone!
- Around 50 new creature spawns!.
- Around 200 new Gameobject Spawns!.
- Around 150 Gossip & Links have been added!.
- Corrected Alot of stuff to stormwind npc's:
- Yorus Barleybrew - Dreanei Version.
- Alot of fixes over ghostlands.
- Alot of fixes over vendors(Arena,honor and random vendors over the world).
- Alot of loot fixes related to quests.
- Throne of Kil'jadaen proto fixes (thanks to blizzy for pointing it out)
- Deleted Nazgrel in Orgrimmar
- Fire Beetle scale fix
- Honor Hold Defender faction changes
- Damn Arena vendors... added some for Nagrand s1/s2 Horde's s1 in Hall of Legends
- Cleaned up some spawns in Searing Gorge (hopefully better)
- Redid Stormwind Shaman class trainer spells (based off wowhead)...would be nice if I found a trainer spells parser...
- Hyjal rep on kill and mining veins loot
- Deleted Engineering trainer spells which are not ingame
- Added Enchant Cloak: Subtley to Honor Hold/Thrallmar rep vendors

Scripts
- Added Wailing Caverns Script and Event.
- Molten Core & The Eye: various polishing and fixes
- Wailing Caverns instance added
[/EDIT-UPDATE]

Core
- Fixed AH lost items (tested with 1k+ transfers)
- Priest heal over time
- Item swap during combat
- Fixed arena

Database
- Added WoWRage repair bot!
- Removed all instances item/quest requirements!
- Silthus Zone have been fully redone.
- Rivern Frostwind has a correct npcflags now.
- Jubahl Corpseseeker has a correct npcflags now.
- Quartermaster Hicks has a correct npcflags now.
- Grikka has a correct npcflags now.
- Innkeeper Aelerya has a correct npcflags now.
- Ambassador Pax'ivi has a correct npcflags now.
- Samir has a correct npcflags now.
- Zungam has a correct npcflags now.
- Belia Thundergranite has a correct npcflags now.
- Removed shitty ai_agents in hellfire peninsula (shattered hand npcs)
- Added vendor loot to Aldraan + npc flags (prolly needs repair flag)
- New Fel Reaver waypoints + speeds
- Bunch o' npc_text (Honor Hold)
- Enraged Air Spirit corrected displayid
- Stormwind Infrantry mountdisplayid change
- Mag'har Refugee standstate (1)
- Fully redone spawns, vendors, proto's, gameobjects, gossips in Goldshire
- Re-done Flamestrike trainer_spells
- Protean Spawn scale fix
- Took out Fel Reaver ai_agents (they sucked)
- The Path of the Adept required item fix
- The Purest Water required item fix
- Added new table `disenchantingloot`
- Loots ripped from WoWhead
- Added missing IncompleteText Battle of Hillsbrad quests.
- Added Quest Starter & Finisher to Free at Last! (Horde And Alliance Versions)
- Fully redone spawns, vendors, proto's, gameobjects, gossips, trainers to darkshire.
- The quest "Free at Last!" has now correct Completion Text.
- Corrected Required Level to the following quests:
- Sage No More (Entry: #11103).
- Restorer No More (Entry: #11104).
- Champion No More (Entry: #11105).
- Defender No More (Entry: #11106).
- Corrected Quest Starter and / or Finisher to the following Quests:
- Manaweave Robe (Entry: #1941).
- Orc warlock/hunter/shaman/priest correct racial starting spell
- Overseer Gorthak weapon/shield
- Area52 Aldor "none aggro" flags
- Gordok Mastiff incorrect faction (was 85)
- From Higi for Zul'Farrak (bug tracker)
- Delete extra Shadowlod Deathwail (bug brought up by lyon 667 on bug tracker)
- Wisps in Outland
- Alterac Mountains (Jailer Borhuin)
- Apothecary Zelana provided item
- All PreTBC Bosses level corrected.
- Shadowpine Catlord respawn time corrected.
- Shadowpine Hexxer respawn time corrected.
- The Master's Terrace Provided Item corrected.
- Vi'el <Exotic Reagent Merchant> flag corrected.
- Items table have been fully redone, all items should be fully BLIZZLIKE,
All faked items were removed, all missing items have been added.
- Adding all maps to worldmap_info
- Fixed typo on update file.
- Ahn'Qiraj War have been adjusted and improved.
- The Scepter of the Shifting Sands quest chain is now fully working!.
- Fixed Drop rate to the following items:
- Draconic for Dummies (Entry: #21103).
- Draconic for Dummies (Entry: #21104).
- Draconic for Dummies (Entry: #21105).
- Draconic for Dummies (Entry: #21106).
- Draconic for Dummies (Entry: #21107).
- Draconic for Dummies (Entry: #21108).
- Draconic for Dummies (Entry: #21109).
- Draconic for Dummies (Entry: #21110).
- Lakmaeran's Carcass (Entry: #21027).
- Fragment of the Nightmare's Corruption (Entry: #21146).
- Fragment of the Nightmare's Corruption (Entry: #21147).
- Fragment of the Nightmare's Corruption (Entry: #21148).
- Fragment of the Nightmare's Corruption (Entry: #21149).
- Added missing loots:
- Fragment of the Nightmare's Corruption (Entry: #21149).
- Creature_names table have been fully redone, about 4k new creatures have been added,
thousandths of creatures have been adjusted and updated.
- Quests table have been fully redone, about 1k quests have been added, thousandths have been
adjusted.
- Zul'Aman is a 10-player, level 70 outdoor instance located in the Ghostlands. Players
will be able to confront six new bosses including the Forest Troll Warlord Zul'jin.
- Serpentshrine Cavern have been fully redone, including creature stats, info, spawns, waypoints
and more.
- Most(ALL?) quests from patch 2.1 & 2.2 & 2.3 have been added to the database.
- Guild Banks have been introduced. The Guild Bank will allow players with the appropriate
permissions to store items and money for use by the rest of the guild.
- Darkmoon Faire have been added & supported once again!.
- Most Creatures over Azeroth and outland displays their weapons properly.
- Karazhan(Raid-Instances) have bene fully redone, all creatures, waypoints, spawns
formations, droploot and misc have been redone.
- Most(all) of the new profession recipes that have been introduced in patch 2.2 and 2.3 have
been added.
- Most(all) creatures have been updated into patch 2.3 changes, to make leveling easier, a lot
creatures have been nerfed and adjusted for faster leveling.
- Mana Tombs have been fully redone, including creature stats, info, spawns, waypoints
Creatures AI.
- Hellfire Ramparts have been fully redone, including creature stats, info, spawns, waypoints
Creatures AI.
- Magtheridon Lair have been fully redone, including creature stats, info, spawns, waypoints
and more.
- The Underbog have been fully redone, including creature stats, info, spawns, waypoints
and more.
- Auchenai Crypts have been fully redone, including creature stats, info, spawns, waypoints
and more.
- Zul'Gurub have been fully redone, including creature stats, info, spawns, waypoints
and more.
- Sethekk Halls have been fully redone, including creature stats, info, spawns, waypoints
and more.
- Most items that have been added in patch 2.3 have been added.
- Fixed all Druid(class) quests, and everything related into it.
- The new mounts that have been added in patch 2.3 are use-able.
- Shattrath City have been fully revamp, all the missing npc's have been added, corrected
spawning locations for all the creatures, including Christmas spawns and creatures.
- All Alliance towns in outlands have been fully revamp, all the missing npc's have been added,
corrected spawning locations for all the creatures, fully blizzlike.
- Limited Vendors Supported (Herbs, Ores etc are time-spawned now).
- Champions' Hall and Hall of Legends have been fully redone, fully new spawns, updated vendors,
Fixes & new creatures.
- Skettis has been fully revamp, fully new spawns, updated creatures, new waypoints including the
near by camp.
- Creatures Stand State are support now, creatures will be able to kneel, sit, sleep, appear as dead
and more.
- Outland creatures have now updated factions, auras, weapon display, mount display, scale and even more.
- Adding Spotlight effect to all lunar event "elder" npc's.
- Adding Invisibility and Stealth Detection for guards.
- Adding Retribution Aura to Highlord Bolvar Fordragon, seems he's using it.
- Adding Invisibility visual effect to Agent Kearnen
- Adding 3 missing "kids" and their spawn & waypoints.
- More fixes for factions, combat reach, aggro range, scale, mana, armor and weapon equipments.

Scripts
- encounter in raid The Eye fixed
- black temple temp. disabled!
- Added a few functionalities to MoonScriptCreatureAI
- High Astromancer Solarian is now fully boss mods (BigWigs/DeadlyBossMods) compliant, closer to blizzlike.
- Rewritten and unfortunately untested Attumen and Midnight AIs. Still probably not bug less and not yet finished.
- Morogrim Tidewalker optimizations. Deleted all 4 unneeded variables and instead of that used array properties and real timers.
- Redone Moroes and Maiden of Virtue.
- Small fix in SSC
- Redone Broggok & The Maker in MoonScriptCreatureAI (thx barondeathicon Cheesy

)
- Tested new class by finishing convertion work on High Astromancer Solarian, he's now the first boss to use the new MoonScriptBossAI class. (Tested with one player, need testing with many players)
- Morogrim Tidewalker work.
- Gruul's Cave In Spell has Random Target now.
- New Stable and Working Target changing system for the advisors. Why were they Unselectable?? that not blizz-like...they should just be Unattackble.
- Totally redone Karathress encounter.
- Totally redone Hydross the Unstable.
- More work on one of the four blood elf advisors ( Thaladred the Darkener )
The should do the Emote everytime he gains a target. Not sure if he will do the emote if he changes his target tho :S
- Fixed crash in Shade of Aran + cleanup
Introduction of the MoonScriptCreatureAI base class. Its far from complete but its a good overview of the direction I'm taking. See forums for more.
- Molten Core is the first instance to implement it. Its not fully converted yet because I wanted to share what I've done so far.
- Added Leotheras the Blind complete event, fully tested. I'll post other updates in the next days.
- Implemented Shade of Aran Atiesh check. If a player has Atiesh, the boss yells "Where did you get that?! Did HE send you?!"

Many many thanks to moon++/ascent/ncdb!