Trinitycore: DB/Creature: Gnomish Flame Turret

[DanVS]

Description:

Implement behaviour of Gnomish Flame Turret.

-- Fnomish Flame Turret (17458)
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=17458;
DELETE FROM `smart_scripts` WHERE `entryorguid`=17458;
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(17458,0,0,0,54,0,100,1,0,0,0,0,0,103,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnomish Flame Turret - On Creature Just spawned - Root"),
(17458,0,1,0,54,0,100,1,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnomish Flame Turret - On Creature Just spawned - Disable Auto Attack"),
(17458,0,2,0,9,0,100,0,0,10,1000,1000,0,11,30527,0,0,0,0,0,25,10,0,0,0,0,0,0,"Gnomish Flame Turret - Within 0-10 Range - Cast 'Flame Cannon'");

Branch(es):

• [x] 3.3.5
• [x] master

TC rev. hash/commit:

TC>TrinityCore rev. e350cfc4374f+ 2018-04-02 00:48:08 +0200 (3.3.5 branch) (Unix, RelWithDebInfo, Static)
Using SSL version: OpenSSL 1.0.2g 1 Mar 2016 (library: OpenSSL 1.0.2g 1 Mar 2016)
Using Boost version: 1.58.0
Using MySQL version: 5.7.21
Using CMake version: 3.5.1
Compiled on:
Automatic database updates are enabled for the following databases: Auth, Characters, World
Worldserver listening connections on port 8085
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1
MMAPs status: Enabled
maps directory located in ../data/maps. Total size: 252191207 bytes
vmaps directory located in ../data/vmaps. Total size: 588247501 bytes
mmaps directory located in ../data/mmaps. Total size: 2152621156 bytes
Using World DB: TDB 335.64

[Faq]

shouldn't this be in PR?

[ghost]

No, SQL-only fixes are posted in issues and not in a PR.
Pull Request is only if you have got C++ code && SQL files.

---

edit: @DanVS , Fnomish Flame Turret (FFT) is a funny name. I wish it had been FTW, though (Fnomish Turret Wagon ?) 😆

[Killyana]

We cannot push this until the spell scaling is fixed, otherwise it could be used as exploit to kill high level players and npcs.

[Kodekc]

UPDATE `item_template` SET `RequiredLevel`='58' WHERE  `entry`=23841;