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
DB/World: Fix a typo in file 2012_11_24_03_world_varius_fixes.sql

>ERROR 1264 (22003) at line 359: Out of range value for column 'ConditionTarget'

The above error is only present when using MySQL strict mode (and that is **recommended**)
To enable strict mode add `sql_mode=STRICT_ALL_TABLES` to my.init MySQL configuration file
DB/World: Create a new sql with the code fixed in 294d7c0707abe42812, also fix typo
DB/World: Correct some waypoint_data and properly add PK to this table
Scripts/Events/Achievement: fix 'Out With It'

Credits to @darkman1983

Closes #8211
Closes #8126

Signed-off-by: Nay <dnpd.dd@gmail.com>
DB/SpellClick: Remove redundant spellclick spell for npc 30228, as it is already indirectly applied from npc 30500
DB/Misc: Fix startup errors
Core/PetAI: Fixed a crash in PetAI::CanAttack
Closes #8660
Core/QuestHandler: Minor change on output from two logentries to make more sense
Core/Spells: Rename spell script scripts in correct script name
Core: Fix non pch build
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