+- For-rum 3server.cz (http://for-rum.3server.cz)
+-- Forum: TEAM ONLY (http://for-rum.3server.cz/forumdisplay.php?fid=4)
+--- Forum: SQL (http://for-rum.3server.cz/forumdisplay.php?fid=6)
+---- Forum: Solved (http://for-rum.3server.cz/forumdisplay.php?fid=10)
+---- Thread: Protecting Our Own (quest fix) (/showthread.php?tid=53)
Protecting Our Own (quest fix) - doktorblazen - 12-24-2018
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');
RE: Protecting Our Own (quest fix) - mirra - 12-24-2018
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
RE: Protecting Our Own (quest fix) - doktorblazen - 07-22-2019
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');