SymbolixDEV

    //Fixed by Ac-Web Community
    //Modified by Marcus
    //original script created by ??
     
    #include "ScriptPCH.h"
    #include "Language.h"
    #include "Pet.h"
     
    #define GOSSIP_ITEM_STABLE "Stable"
    #define GOSSIP_ITEM_NEWPET "New Pet"

SymbolixDEV

diff --git a/sql/transmogrification/characters_transmogrification.sql b/sql/transmogrification/characters_transmogrification.sql
new file mode 100644
index 0000000..8a73e1b
--- /dev/null
+++ b/sql/transmogrification/characters_transmogrification.sql
@@ -0,0 +1,6 @@
+-- BlizzLikeCore Transmogrification
+CREATE TABLE IF NOT EXISTS `custom_transmogrification` (
+  `GUID` int(10) unsigned NOT NULL DEFAULT '0',
+  `FakeEntry` int(10) unsigned NOT NULL DEFAULT '0',

SymbolixDEV

Thanks: Saqirmdev @ Tibbi for Re-coded to new version
Shared by: SymbolixDEV

rev. https://github.com/TrinityCore/TrinityCore/commit/57145ada8162b89aeaba79f981068b93f1afb0eb 
SaqiRev: https://github.com/saqirmdev/TrinityCore/commit/9fb1c18cfbda51023eb54d9932c94b4e13a86525

===================================================================================================
From 9fb1c18cfbda51023eb54d9932c94b4e13a86525 Mon Sep 17 00:00:00 2001
From: Saqirmdev <[email protected]>
Date: Wed, 31 Oct 2012 22:56:35 +0100

SymbolixDEV

diff --git a/sql/updates/world/2012_06_14_09_world_spell_script_names.sql b/sql/updates/world/2012_06_14_09_world_spell_script_names.sql
new file mode 100644
index 0000000..f14e44e
--- /dev/null
+++ b/sql/updates/world/2012_06_14_09_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=-603;
+INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES
+(-603,'spell_warl_curse_of_doom');
diff --git a/src/server/game/Spells/Auras/SpellAuras.cpp b/src/server/game/Spells/Auras/SpellAuras.cpp

SymbolixDEV

diff --git a/sql/updates/world/2012_06_14_09_world_spell_script_names.sql b/sql/updates/world/2012_06_14_09_world_spell_script_names.sql
new file mode 100644
index 0000000..f14e44e
--- /dev/null
+++ b/sql/updates/world/2012_06_14_09_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=-603;
+INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES
+(-603,'spell_warl_curse_of_doom');
diff --git a/src/server/game/Spells/Auras/SpellAuras.cpp b/src/server/game/Spells/Auras/SpellAuras.cpp

SymbolixDEV

From 8d9b630c95b655607cd8d9e4d9d6c09f66ba44da Mon Sep 17 00:00:00 2001
From: ddark <[email protected]>
Date: Wed, 6 Jun 2012 13:28:43 +0400
Subject: [PATCH] Revert "Revert "Hack fix of Entrapment and Lock and Load""

This reverts commit 05275b49931317c9910d9f8cd6a4050ecb7df336.
---
 sql/custom/world/spell_script_names.sql    |   14 +++
 src/server/scripts/Spells/spell_hunter.cpp |  136 ++++++++++++++++++++++++++++
 2 files changed, 150 insertions(+), 0 deletions(-)

SymbolixDEV

Thanks: Saqirmdev @ Tibbi
Shared by: SymbolixDEV
Fixed by SymbolixDEV
Subject: [PATCH] Implentement Arena-Spectate for Trinity core 3.3.5a last rev
 
---
 src/server/game/Battlegrounds/Battleground.cpp     |   30 +-
 src/server/game/Battlegrounds/Battleground.h       |   10 +
 src/server/game/Battlegrounds/BattlegroundMgr.h    |    6 +-
 src/server/game/Battlegrounds/SpectatorAddon.cpp   |  217 +++++++++

SymbolixDEV

//Orginal script by : ???
//Fixed errors by : SymbolixDEV
#include "ScriptPCH.h"
#include <cstring>

#define SET_CURRENCY 2  //0 for gold, 1 for honor, 2 for tokens
#define TOKEN_ID 23247 // token id

#if SET_CURRENCY == 0
#define BOUNTY_1 "I would like to place a 20g bounty."

SymbolixDEV

diff --git a/sql/arena-spectator/spectator.sql b/sql/arena-spectator/spectator.sql
new file mode 100644
index 0000000..39cff15
--- /dev/null
+++ b/sql/arena-spectator/spectator.sql
@@ -0,0 +1,12 @@
+-- Implement Arena Spectator
+DELETE FROM `command` WHERE `name` = 'spectate';
+INSERT INTO `command` (`name`, `security`, `help`) VALUES ('spectate', 0, 'Syntax: .spectate $subcommand.\nUse .help sppectate');
+DELETE FROM `command` WHERE `name` = 'spectate view';

SymbolixDEV

//test NPC by SymbolixDEV
#include "ScriptPCH.h"

uint32 buffIdstools[] = { 43223, 5862, 33377, 33779, 31305, 70692, 42995 };

class npc_test : public CreatureScript
{
public:
	npc_test() : CreatureScript("npc_test") { }