Protecting Our Own (quest fix)

[doktorblazen]

Oprava questu protecting our own. Pár změn v smart_scripts. Vyzkoušeno na chudakovi.

DELETE FROM smart_scripts WHERE entryorguid='20748';

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('20748','0','0','0','25','0','100','0','0','0','0','0','11','37691','0','0','0','0','0','1','0','0','0','0','0','0','0','Thunderlord Dire Wolf - On Reset - Cast Stealth Detection');
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('20748','0','1','0','0','0','100','0','4000','6000','10000','11000','11','5781','0','0','0','0','0','2','0','0','0','0','0','0','0','Thunderlord Dire Wolf - IC - Cast Threatening Growl');
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('20748','0','2','0','8','0','100','512','32578','0','120000','120000','33','21142','0','0','0','0','0','7','0','0','0','0','0','0','0','Thunderlord Dire Wolf - on spell hit - Credit quest');

[mirra]

4 queries executed, 4 success, 0 errors, 1 warnings

Query: DELETE FROM smart_scripts WHERE entryorguid='20748'

1 row(s) affected

Execution Time : 0.062 sec
Transfer Time  : 0 sec
Total Time     : 0.062 sec
--------------------------------------------------

Query: INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...

1 row(s) affected

Execution Time : 0.025 sec
Transfer Time  : 0 sec
Total Time     : 0.026 sec
--------------------------------------------------

Query: INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...

1 row(s) affected

Execution Time : 0.034 sec
Transfer Time  : 0 sec
Total Time     : 0.035 sec
--------------------------------------------------

Query: INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...

1 row(s) affected, 1 warning(s)

Execution Time : 0.024 sec
Transfer Time  : 0.001 sec
Total Time     : 0.025 sec

Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab

[doktorblazen]

Ok, pořád to prý nefunguje, proto tu mám další fix. Prosím nahodit.

DELETE FROM smart_scripts WHERE entryorguid=20748;
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
(20748,0,0,0,25,0,100,0,0,0,0,0,11,37691,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - On Reset - Cast Stealth Detection'),
(20748,0,1,0,0,0,100,0,4000,6000,10000,11000,11,5781,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - IC - Cast Threatening Growl'),
(20748,0,2,0,8,0,100,0,32578,0,120000,120000,33,21142,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Thunderlord Dire Wolf - on spell hit - Credit quest');