+- 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: Glyph Chasing - Bug fix (/showthread.php?tid=61)
Glyph Chasing - Bug fix - doktorblazen - 01-19-2019
Fixnuto. Vyzkoušeno na Chudákovi.
Co je potřeba nahodit?:
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=180453;
DELETE FROM smart_scripts WHERE (entryorguid=180453 AND source_type=1);
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
(180453,1,0,1,62,0,100,0,6561,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'close gossip'),
(180453,1,1,0,61,0,100,1,0,0,0,0,56,20456,1,0,0,0,0,7,0,0,0,0,0,0,0,'additem 20456');
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=180454;
DELETE FROM smart_scripts WHERE (entryorguid=180454 AND source_type=1);
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
(180454,1,0,1,62,0,100,0,6560,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'close gossip'),
(180454,1,1,0,61,0,100,1,0,0,0,0,56,20455,1,0,0,0,0,7,0,0,0,0,0,0,0,'additem 20455');
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=180455;
DELETE FROM smart_scripts WHERE (entryorguid=180455 AND source_type=1);
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
(180455,1,0,1,62,0,100,0,6559,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'close gossip'),
(180455,1,1,0,61,0,100,1,0,0,0,0,56,20454,1,0,0,0,0,7,0,0,0,0,0,0,0,'additem 20454');
RE: Glyph Chasing - Bug fix - mirra - 01-19-2019
9 queries executed, 9 success, 0 errors, 0 warnings
Query: UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=180453
0 row(s) affected
Execution Time : 0.027 sec
Transfer Time : 0 sec
Total Time : 0.028 sec
--------------------------------------------------
Query: DELETE FROM smart_scripts WHERE (entryorguid=180453 AND source_type=1)
2 row(s) affected
Execution Time : 0.045 sec
Transfer Time : 0 sec
Total Time : 0.046 sec
--------------------------------------------------
Query: INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,eve...
2 row(s) affected
Execution Time : 0.017 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=180454
0 row(s) affected
Execution Time : 0.018 sec
Transfer Time : 0 sec
Total Time : 0.018 sec
--------------------------------------------------
Query: DELETE FROM smart_scripts WHERE (entryorguid=180454 AND source_type=1)
2 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,event_flags,event_param1,eve...
2 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=180455
0 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: DELETE FROM smart_scripts WHERE (entryorguid=180455 AND source_type=1)
2 row(s) affected
Execution Time : 0.029 sec
Transfer Time : 0 sec
Total Time : 0.029 sec
--------------------------------------------------
Query: INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,eve...
2 row(s) affected
Execution Time : 0.017 sec
Transfer Time : 0 sec
Total Time : 0.017 sec