ProjectSkyfire/SkyFireEMU — Issue #83: sql problem in 2012_01_09_01_world_misc.sql
Author: alangb01
Created: 2012-01-18 01:25:24+00:00
State: open

--->line 1312 - 1315
=================================================================================
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
(33498,0,0,0,23,0,100,0,63124,1,0,0,81,16777216,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maloric - on Aura: Incapacitate Maloric - set npcflag: Spellklick'),
(33498,0,1,0,23,0,100,0,63124,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maloric - on NoAura: Incapacitate Maloric - set npcflag: none');

first insert have action_param1 set 1677216, in table structure this value is out of range (mediumint)

=================================================================================
--->line 2252 and line 2262
=================================================================================
UPDATE `item_template` SET `ScriptName` = 'item_snq_control_unit' WHERE `entry` = 34981;
UPDATE `item_template` SET `ScriptName` = 'item_interdimensional_refabricator' WHERE `entry` = 35479;

Table Structure doesn't exist