[DiscordArchive] can you show me the sql you're using?
[DiscordArchive] can you show me the sql you're using?
Original source
can you show me the sql you're using?
rektbyfaith
11-27-2021, 02:18 PM #1Archived author: Nyeriah • Posted: 2021-11-27T14:18:20.374000+00:00
Original source
can you show me the sql you're using?
Original source
Sec reheating coffee
rektbyfaith
11-27-2021, 02:18 PM #2Archived author: Malcrom • Posted: 2021-11-27T14:18:34.528000+00:00
Original source
Sec reheating coffee
Original source
``
rektbyfaith
11-27-2021, 02:19 PM #3Archived author: Malcrom • Posted: 2021-11-27T14:19:51.315000+00:00
Original source
``
Original source
```
-- Felendren the Banished
DELETE FROM `smart_scripts` WHERE `entryorguid`=15367 AND `source_type`=0 AND `id`=2;
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`,`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
(15367, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 41, 60000, 65, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Felendren the Banished - On Death - Set Respawn timer');
```
rektbyfaith
11-27-2021, 02:19 PM #4Archived author: Malcrom • Posted: 2021-11-27T14:19:57.931000+00:00
Original source
```
-- Felendren the Banished
DELETE FROM `smart_scripts` WHERE `entryorguid`=15367 AND `source_type`=0 AND `id`=2;
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`,`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
(15367, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 41, 60000, 65, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Felendren the Banished - On Death - Set Respawn timer');
```
Original source
Trying this one first
rektbyfaith
11-27-2021, 02:20 PM #5Archived author: Malcrom • Posted: 2021-11-27T14:20:28.461000+00:00
Original source
Trying this one first
Original source
what I think that could be happening is that SAI is processed before the creature's death
rektbyfaith
11-27-2021, 02:21 PM #6Archived author: Nyeriah • Posted: 2021-11-27T14:21:15.738000+00:00
Original source
what I think that could be happening is that SAI is processed before the creature's death
Original source
so the value we set gets overwritten by corpsedecay
rektbyfaith
11-27-2021, 02:21 PM #7Archived author: Nyeriah • Posted: 2021-11-27T14:21:31.177000+00:00
Original source
so the value we set gets overwritten by corpsedecay
Original source
oh
rektbyfaith
11-27-2021, 02:21 PM #8Archived author: Malcrom • Posted: 2021-11-27T14:21:37.393000+00:00
Original source
oh
Original source
Garrick Padfoot, Grik'nir the Cold, Meven Korgal, Githyiss the Vile, Sarkoth, Yarrog Baneshadow, Chief Sharptusk Thornmantle, "Squealer" Thornmantle, and Surveyor Candress all need this too
rektbyfaith
11-27-2021, 02:24 PM #9Archived author: Malcrom • Posted: 2021-11-27T14:24:33.978000+00:00
Original source
Garrick Padfoot, Grik'nir the Cold, Meven Korgal, Githyiss the Vile, Sarkoth, Yarrog Baneshadow, Chief Sharptusk Thornmantle, "Squealer" Thornmantle, and Surveyor Candress all need this too
Original source
I think we *should* be able to set respawn timers lower than 5 minutes (corpse decay) but I hit some kind of technical roadblock
rektbyfaith
11-27-2021, 02:25 PM #10Archived author: Nyeriah • Posted: 2021-11-27T14:25:16.605000+00:00
Original source
I think we *should* be able to set respawn timers lower than 5 minutes (corpse decay) but I hit some kind of technical roadblock