{"action":"created","issue":{"url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk/issues/398","repository_url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk","labels_url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk/issues/398/labels{/name}","comments_url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk/issues/398/comments","events_url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk/issues/398/events","html_url":"https://github.com/azerothcore/azerothcore-wotlk/issues/398","id":209991151,"number":398,"title":"[CORE][SPELL] Animal Blood","user":{"login":"starrheld","id":14246378,"avatar_url":"https://avatars0.githubusercontent.com/u/14246378?v=3","gravatar_id":"","url":"https://api.github.com/users/starrheld","html_url":"https://github.com/starrheld","followers_url":"https://api.github.com/users/starrheld/followers","following_url":"https://api.github.com/users/starrheld/following{/other_user}","gists_url":"https://api.github.com/users/starrheld/gists{/gist_id}","starred_url":"https://api.github.com/users/starrheld/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/starrheld/subscriptions","organizations_url":"https://api.github.com/users/starrheld/orgs","repos_url":"https://api.github.com/users/starrheld/repos","events_url":"https://api.github.com/users/starrheld/events{/privacy}","received_events_url":"https://api.github.com/users/starrheld/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-02-24T08:48:18Z","updated_at":"2017-04-15T20:46:26Z","closed_at":null,"body":"**Description**: Visual bug & Spell bug\r\n\r\n**Current behaviour**: ** The spell **[Animal Blood]** says\r\n\r\n> You've recently killed an animal in the Borean Tundra. Stay away from the druids of D.E.H.T.A. until the blood dries up or find something to wash the blood off you.\r\n\r\nHowever, as you clearly can see in the image down below, the Druids are not hostile and will not attack me hence the aura **[Animal Blood]** is applied.\r\n\r\n\r\n**Expected behaviour**: ** When the aura is applied to your character the D.E.H.T.A druids/npc(s) should become hostile and attack you.\r\n\r\n**Steps to reproduce the problem**:\r\n\r\n1. Kill any animal that gives you the aura **[Animal Blood]**.\r\n2. Go and hang out at the D.E.H.T.A Camp in Borean Tundra.\r\n\r\n![IMG1](http://i.imgur.com/gQLcpQa.jpg)\r\n\r\n## When you walk in water/liquid the Spell should despawn in the water, however as of right now it's not applied on the surface of the water/liquid but instead in the air.\r\n![IMG2](http://i.imgur.com/wvXHxNh.jpg)\r\n\r\n\r\n**Branch(es)**: Master\r\n\r\n**AC hash/commit**:  b2b365b2096f\r\n\r\n**Operating system**:  Windows 7\r\n\r\n**Modules**:  None\r\n\r\n**Other Customizations**: None\r\n\r\n\r\n[//]: # (This template is for problem reports, for other type of reports edit it accordingly)\r\n[//]: # (If this is a crash report, include the crashlog with https://gist.github.com/)\r\n[//]: # (For fixes containing c++ create a Pull Request)"},"comment":{"url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk/issues/comments/294316943","html_url":"https://github.com/azerothcore/azerothcore-wotlk/issues/398#issuecomment-294316943","issue_url":"https://api.github.com/repos/azerothcore/azerothcore-wotlk/issues/398","id":294316943,"user":{"login":"starrheld","id":14246378,"avatar_url":"https://avatars0.githubusercontent.com/u/14246378?v=3","gravatar_id":"","url":"https://api.github.com/users/starrheld","html_url":"https://github.com/starrheld","followers_url":"https://api.github.com/users/starrheld/followers","following_url":"https://api.github.com/users/starrheld/following{/other_user}","gists_url":"https://api.github.com/users/starrheld/gists{/gist_id}","starred_url":"https://api.github.com/users/starrheld/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/starrheld/subscriptions","organizations_url":"https://api.github.com/users/starrheld/orgs","repos_url":"https://api.github.com/users/starrheld/repos","events_url":"https://api.github.com/users/starrheld/events{/privacy}","received_events_url":"https://api.github.com/users/starrheld/received_events","type":"User","site_admin":false},"created_at":"2017-04-15T20:46:26Z","updated_at":"2017-04-15T20:46:26Z","body":"Fix (not for placement above liquid/water surface):\r\n\r\n```SQL\r\n-- D.E.T.H.A TEXT AND SAI\r\nDELETE FROM `creature_text` WHERE `entry` IN (25808, 25809, 25819, 25812, 25811, 25810, 25838) AND `groupid` = 0; \r\nINSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES\r\n(25808,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25808,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25808,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),\r\n--\r\n(25809,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25809,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25809,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),\r\n--\r\n(25812,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25812,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25812,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),\r\n--\r\n(25811,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25811,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25811,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),\r\n--\r\n(25810,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25810,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25810,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),\r\n--\r\n(25838,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25838,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25838,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,''),\r\n--\r\n(25819,0,0,' Do you think us fools! You\\'re covered in animal blood!',12,0,100,5,4000,0,0,0,''),\r\n(25819,0,1,' BUTCHER! DIE!',12,0,100,5,4000,0,0,0,''),\r\n(25819,0,2,' Calf killer! Murderer! You will pay for this!',12,0,100,5,4000,0,0,0,'');\r\n\r\nSET @ENTRY := 25808;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"D.E.H.T.A. Enforcer - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,10,0,100,0,1,20,0,0,49,2,0,0,0,0,0,25,20,1,0,0,0,0,0,\"D.E.H.T.A. Enforcer - Within 1-20 Range Out of Combat LoS - Start Attacking\");\r\n\r\nDELETE FROM `creature_formations` WHERE `leaderGUID`= 132974;\r\nINSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES\r\n(132974,132974,0,0,2,0,0),\r\n(132974,132976,0,0,2,0,0);\r\n\r\nSET @ENTRY := 25819;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"D.E.H.T.A. Enforcer - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,\"D.E.H.T.A. Enforcer - Within 1-20 Range Out of Combat LoS - Start Attacking\"),\r\n(@ENTRY,0,2,0,4,0,100,0,0,0,0,0,91,1,0,0,0,0,0,1,0,0,0,0,0,0,0,\"D.E.H.T.A. Enforcer - On Aggro - Remove Flag Standstate Sit Down\"),\r\n(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,90,1,0,0,0,0,0,1,0,0,0,0,0,0,0,\"D.E.H.T.A. Enforcer - On Reset - Set Flag Standstate Sit Down\");\r\n\r\nSET @ENTRY := 25809;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Arch Druid Lathorius - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Arch Druid Lathorius - On Aggro - Remove Npc Flags Gossip & Questgiver\"),\r\n(@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,\"Arch Druid Lathorius - Within 1-20 Range Out of Combat LoS - Start Attacking\"),\r\n(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Arch Druid Lathorius - On Reset - Set Npc Flags Gossip & Questgiver\");\r\n\r\nSET @ENTRY := 25811;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Zaza - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Zaza - On Aggro - Remove Npc Flag Questgiver\"),\r\n(@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,\"Zaza - Within 1-20 Range Out of Combat LoS - Start Attacking\"),\r\n(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Zaza - On Reset - Set Npc Flag Questgiver\");\r\n\r\nSET @ENTRY := 25810;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Cenius - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Cenius - On Aggro - Remove Npc Flag Questgiver\"),\r\n(@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,\"Hierophant Cenius - Within 1-20 Range Out of Combat LoS - Start Attacking\"),\r\n(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Cenius - On Reset - Set Npc Flag Questgiver\");\r\n\r\nSET @ENTRY := 25812;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Killinger the Den Watcher - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Killinger the Den Watcher - On Aggro - Remove Npc Flag Questgiver\"),\r\n(@ENTRY,0,2,0,10,0,100,0,1,20,0,0,49,0,0,0,0,0,0,25,20,1,0,0,0,0,0,\"Killinger the Den Watcher - Within 1-20 Range Out of Combat LoS - Start Attacking\"),\r\n(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Killinger the Den Watcher - On Reset - Set Npc Flag Questgiver\");\r\n\r\nSET @ENTRY := 25838;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Liandra - On Aggro - Say Line 0\"),\r\n(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Liandra - On Aggro - Remove Npc Flag Questgiver\"),\r\n(@ENTRY,0,2,0,10,0,100,0,1,25,0,0,49,0,0,0,0,0,0,25,25,1,0,0,0,0,0,\"Hierophant Liandra - Within 1-25 Range Out of Combat LoS - Start Attacking\"),\r\n(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Liandra - On Reset - Set Npc Flag Questgiver\"),\r\n(@ENTRY,0,4,0,4,0,100,0,0,0,0,0,91,1,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Liandra - On Aggro - Remove Flag Standstate Sit Down\"),\r\n(@ENTRY,0,5,0,25,0,100,0,0,0,0,0,90,1,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hierophant Liandra - On Reset - Set Flag Standstate Sit Down\");\r\n\r\nSET @ENTRY := 25839;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,0,0,100,0,5000,8000,60000,65000,11,5915,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Northsea Mercenary - In Combat - Cast 'Crazed'\");\r\n\r\nSET @ENTRY := 25844;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\r\nINSERT 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`,`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\r\n(@ENTRY,0,0,0,0,0,100,0,5000,8000,60000,65000,11,5915,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Northsea Thug - In Combat - Cast 'Crazed'\");\r\n``` "}}
{"actor":{"display_login":"starrheld"}}