Fixes phase 2
scripts/gameobject: correct reset of gameobjects (cages/prisons), move command out of if statement
Core/Spells:Beacon of Light

When holy paladin put beacon on someone and heal someone else, it shows up that the player with the beacon is being healed by himself, instead of the person who casting the Beacon.
This problem Can be solved by this.
Core/DB: Drop table script_texts
Core/Script: Fix Dimensional Ripper spell learning
Merge pull request #8583 from Gacko/scripttexts

Core/DB: Drop table script_texts
Implements saving of loot (items / money) contained inside lootable inventory items.

* Unlooted items / money persist across player sessions
* Loot inside items is tied to the item rather than the player so if trading
  partially looted items becomes possible, this implementation will still work

* New tables added:

    characters_database.sql (first time users)
    characters_create_item_loot.sql (existing users)

Implementation Can be tested with:

 Watertight Trunk [21113]
 Bulging Sack of Gems [25422]
 Fat Sack of Coins [11937]

Closes #2048
DB/Pathing: Various improvements to Ashenvale:

Add formation for Alliance Elites pathing in Barrens Closes #8629
Add pathing for Lady Vespia Closes #8630
Add pathing for Prince Raze Closes #8631
Add pathing for Rorgis Jowl Closes #8632
Add pathing for Branch Snapper Closes #8633
Add pathing for Akkrilus Closes #8634
Add pathing for Terrowulf Pack Lord Closes #8635
DB/SAI:

EAI -> SAI conversion for Urom adds Closes #8644
Fix quest: Whelps of the Wyrmcult Closes #8650
Remove npc immunity for Galen's Escape Closes #4942
Core/PetAI: Fix pet's self-jumping

Fix issue, when pet autocast leap-like spells on itself
Core/PetAI: Fix Ghouls emotions

Correction IDs of COWER and ROAR emotions for ghoul.
DB/SAI: Convert some more quest_end_scripts
DB/Cleanup: actually remove the quest_end_scripts and correct a questid in previous push
DB/Creatures: Add corrects hover for Vyragosa and Chillmaw
DB/Winter Veil: Add "Red Rider Air Rifle" at "Clockwork Assistant <Jepetto's Companion>" and "Jepetto Joybuzz <Toymaker>"
DB/Scripts: Implemented creature_text for Trial of the Champion
DB/SAI: Fix quest: Foundation for Revenge, closes https://github.com/TrinityCore/TrinityCore/issues/8621
Core/Items: DestroyItemCount also searches bank

Closes #8240

Signed-off-by: Nay <dnpd.dd@gmail.com>
Core/Creature: Update template - reinitialize spell bar for vehicles

	* update template didn't change spell bar for players if on vehicle that updates it's template, initialize spells was needed
	* combined with faction changing, since when update is called player faction is ignored and it should be changed to his (based on sniffs)
	* the idea of this automated check inside fix SAI problems mainly, because there you have nothing to use to reinitialize the bar - closes #5254
Merge pull request #8681 from xomachine/master

Core/PetAI: Emote and autocast fixes