A Race Against Time - Bug Fix

[doktorblazen]

Opraveno, testováno na chudákovi.
Pár řádků v smart_scripts 25584.

FIX:

DELETE FROM smart_scripts WHERE entryorguid=25584;
Download SQL_fix: https://drive.google.com/a/skaut.cz/file...sp=sharing

[mirra]

Code:

DELETE FROM smart_scripts WHERE entryorguid=25584;

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

Query: DELETE FROM smart_scripts WHERE entryorguid=25584

6 row(s) affected

Execution Time : 0.113 sec
Transfer Time  : 0.002 sec
Total Time     : 0.115 sec

Code:

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('25584','0','0','0','38','0','100','1','1','1','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Inquisitor Salrand - On Data Set 1 1 - Say Line 0');
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('25584','0','1','2','38','0','100','1','1','2','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Inquisitor Salrand - On Data Set 1 2 - Say Line 1 (No Repeat)');
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('25584','0','2','0','61','0','100','513','0','0','0','0','80','2558400','0','0','0','0','0','1','0','0','0','0','0','0','0','Inquisitor Salrand - On Data Set 1 2 - Run Script (No Repeat)');
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('25584','0','3','4','6','0','100','1','0','0','0','0','11','45809','0','0','0','0','0','1','0','0','0','0','0','0','0','Inquisitor Salrand - On Just Died - Cast \'Summon Salrand\'s Lockbox\' (No Repeat)');
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('25584','0','4','0','61','0','100','1','0','0','0','0','1','2','0','0','0','0','0','1','0','0','0','0','0','0','0','Inquisitor Salrand - On Just Died - Say Line 2 (No Repeat)');
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('25584','0','5','0','25','0','100','0','0','0','0','0','11','45775','0','0','0','0','0','1','0','0','0','0','0','0','0','Inquisitor Salrand - On Respawn - Evade (No Repeat)');
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('25584','0','6','0','1','0','100','0','5000','5000','10000','10000','11','45777','0','0','0','0','0','10','119586','25594','0','0','0','0','0','Inquisitor Salrand - Out of Combat - Cast \'Salrand\'s Beam\'');
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('25584','0','7','0','8','0','100','0','34897','0','1','1','20','1','0','0','0','0','0','21','50','0','0','0','0','0','0','Attack start - fix\r\n\r\n');

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

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.060 sec
Transfer Time  : 0 sec
Total Time     : 0.060 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, 1 warning(s)

Execution Time : 0.016 sec
Transfer Time  : 0 sec
Total Time     : 0.017 sec

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

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.017 sec
Transfer Time  : 0 sec
Total Time     : 0.017 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.023 sec
Transfer Time  : 0 sec
Total Time     : 0.024 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.016 sec
Transfer Time  : 0 sec
Total Time     : 0.017 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.016 sec
Transfer Time  : 0 sec
Total Time     : 0.016 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.017 sec
Transfer Time  : 0 sec
Total Time     : 0.017 sec