diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/2131_world.sql | 42 | ||||
| -rw-r--r-- | sql/updates/2138_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/2139_script_waypoint.sql | 6 | ||||
| -rw-r--r-- | sql/updates/2139_world.sql | 4 | ||||
| -rw-r--r-- | sql/updates/2139_world_script.sql | 6 |
5 files changed, 31 insertions, 29 deletions
diff --git a/sql/updates/2131_world.sql b/sql/updates/2131_world.sql index 7d29d2af8bd..76fb0b69c52 100644 --- a/sql/updates/2131_world.sql +++ b/sql/updates/2131_world.sql @@ -1,20 +1,22 @@ -delete from command where name in ('server difftime', 'npc addtemp', 'gobject addtemp', ''); -insert into `command` (`name`, `security`, `help`) values('gobject tempadd','2','Adds a temporary gameobject that is not saved to DB.'); -insert into `command` (`name`, `security`, `help`) values('npc tempadd','2','Adds temporary NPC, not saved to database.'); -update command set name = "ahbotoption" where name = "ahbotoptions"; -delete from command where name in ('reload tickets'); -delete from command where name like "path%"; -delete from command where name like "wp%"; -insert into `command`(`name`,`security`,`help`) values ('wp load',2,'Syntax: .path load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'); -insert into `command`(`name`,`security`,`help`) values ('wp event',2,'Syntax: .path event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'); -insert into `command`(`name`,`security`,`help`) values ('wp event add',2,'Syntax: .path event add $subcommand\nAdd new waypoint action in DB.'); -insert into `command`(`name`,`security`,`help`) values ('wp event mod',2,'Syntax: .path mod $eventid $parameter $parameter_value\nModify parameter value for specified eventid.\nPossible parameters: pos_x, pos_y, pos_z, command, datalong, datalon2, dataint.'); -insert into `command`(`name`,`security`,`help`) values ('wp event listid',2,'Syntax: .path event listid $eventid\nShows specified eventid info.'); -insert into `command`(`name`,`security`,`help`) values ('wp unload',2,'Syntax: .path unload\nUnload path for selected creature.'); -insert into `command`(`name`,`security`,`help`) values ('wp show',2,'Syntax: .path show $option\nOptions:\non $pathid (or selected creature with loaded path) - Show path\noff - Hide path\ninfo $slected_waypoint - Show info for selected waypoint.'); -insert into `command`(`name`,`security`,`help`) values ('wp mod ',2,'Syntax: .path mod\nType .path mod to see the list of possible subcommands or .help path mod $subcommand to see info on subcommands.'); -insert into `command`(`name`,`security`,`help`) values ('wp mod del',2,'Syntax: .path mod del\nDelete selected waypoint.'); -insert into `command`(`name`,`security`,`help`) values ('wp mod move',2,'Syntax: .path mod move\nChange selected waypoint coordinates to your position.'); -insert into `command`(`name`,`security`,`help`) values ('wp mod move_flag',2,'Syntax: .path mod move_flag\nSet move/run flag.'); -insert into `command`(`name`,`security`,`help`) values ('wp mod action',2,'Syntax: .path mod action\nAssign action (waypoint script id) to selected waypoint.'); -insert into `command`(`name`,`security`,`help`) values ('wp mod action_chance',2,'Syntax: .path mod action_chance\nAssign chance.'); +DELETE FROM `command` WHERE `name` IN ('server difftime', 'npc tempadd', 'gobject tempadd', ''); +INSERT INTO `command` VALUES +('gobject tempadd','2','Adds a temporary gameobject that is not saved to DB.'), +('npc tempadd','2','Adds temporary NPC, not saved to database.'); +UPDATE `command` SET `name`="ahbotoption" WHERE `name`="ahbotoptions"; +DELETE FROM `command` WHERE `name` IN ('reload tickets'); +DELETE FROM `command` WHERE `name` LIKE "path%"; +DELETE FROM `command` WHERE `name` LIKE "wp%"; +INSERT INTO `command` VALUES +('wp load',2,'Syntax: .path load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'), +('wp event',2,'Syntax: .path event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'), +('wp event add',2,'Syntax: .path event add $subcommand\nAdd new waypoint action in DB.'), +('wp event mod',2,'Syntax: .path mod $eventid $parameter $parameter_value\nModify parameter value for specified eventid.\nPossible parameters: pos_x, pos_y, pos_z, command, datalong, datalon2, dataint.'), +('wp event listid',2,'Syntax: .path event listid $eventid\nShows specified eventid info.'), +('wp unload',2,'Syntax: .path unload\nUnload path for selected creature.'), +('wp show',2,'Syntax: .path show $option\nOptions:\non $pathid (or selected creature with loaded path) - Show path\noff - Hide path\ninfo $slected_waypoint - Show info for selected waypoint.'), +('wp mod ',2,'Syntax: .path mod\nType .path mod to see the list of possible subcommands or .help path mod $subcommand to see info on subcommands.'), +('wp mod del',2,'Syntax: .path mod del\nDelete selected waypoint.'), +('wp mod move',2,'Syntax: .path mod move\nChange selected waypoint coordinates to your position.'), +('wp mod move_flag',2,'Syntax: .path mod move_flag\nSet move/run flag.'), +('wp mod action',2,'Syntax: .path mod action\nAssign action (waypoint script id) to selected waypoint.'), +('wp mod action_chance',2,'Syntax: .path mod action_chance\nAssign chance.');
\ No newline at end of file diff --git a/sql/updates/2138_world.sql b/sql/updates/2138_world.sql index c95ca63c25d..1d290154c33 100644 --- a/sql/updates/2138_world.sql +++ b/sql/updates/2138_world.sql @@ -3,4 +3,4 @@ INSERT INTO `spell_proc_event` VALUES -- Tidial Force (55198, 0x00, 11, 0x000001C0, 0x00000000, 0x00000000, 0x00004000, 0x00000002, 0.000000, 0.000000, 0), -- Kill Command -(34026, 0x00, 9, 0x00000000, 0x10000000, 0x00000000, 0x0000000, 0x00000000, 0.000000, 0.000000, 0); +(34026, 0x00, 9, 0x00000000, 0x10000000, 0x00000000, 0x0000000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/2139_script_waypoint.sql b/sql/updates/2139_script_waypoint.sql index 765c6b7cc46..430366eafdb 100644 --- a/sql/updates/2139_script_waypoint.sql +++ b/sql/updates/2139_script_waypoint.sql @@ -10,8 +10,8 @@ CREATE TABLE script_waypoint ( PRIMARY KEY (entry, pointid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; -DELETE FROM script_waypoint WHERE entry=16295; -INSERT INTO script_waypoint VALUES +DELETE FROM `script_waypoint` WHERE `entry`=16295; +INSERT INTO `script_waypoint` VALUES (16295, 0, 7545.070000, -7359.870000, 162.354000, 4000, 'SAY_START'), (16295, 1, 7550.048340, -7362.237793, 162.235657, 0, ''), (16295, 2, 7566.976074, -7364.315430, 161.738770, 0, ''), @@ -46,4 +46,4 @@ INSERT INTO script_waypoint VALUES (16295, 31, 7603.768066, -7667.000488, 153.997726, 0, ''), (16295, 32, 7603.768066, -7667.000488, 153.997726, 4000, 'SAY_END_1'), (16295, 33, 7603.768066, -7667.000488, 153.997726, 8000, 'SAY_END_2'), -(16295, 34, 7603.768066, -7667.000488, 153.997726, 0, ''); +(16295, 34, 7603.768066, -7667.000488, 153.997726, 0, '');
\ No newline at end of file diff --git a/sql/updates/2139_world.sql b/sql/updates/2139_world.sql index 335cb55a278..dd7217e9bfd 100644 --- a/sql/updates/2139_world.sql +++ b/sql/updates/2139_world.sql @@ -1,2 +1,2 @@ -UPDATE gameobject_template SET `ScriptName`='go_cat_figurine' WHERE `entry`=13873; -UPDATE creature_template SET ScriptName='npc_garments_of_quests' WHERE entry IN (12429,12423,12427,12430,12428); +UPDATE `gameobject_template` SET `ScriptName`='go_cat_figurine' WHERE `entry`=13873; +UPDATE `creature_template` SET `ScriptName`='npc_garments_of_quests' WHERE `entry` IN (12429,12423,12427,12430,12428);
\ No newline at end of file diff --git a/sql/updates/2139_world_script.sql b/sql/updates/2139_world_script.sql index 6de4ace6424..3d40c497eae 100644 --- a/sql/updates/2139_world_script.sql +++ b/sql/updates/2139_world_script.sql @@ -1,5 +1,5 @@ -DELETE FROM script_texts WHERE entry BETWEEN -1000164 AND -1000174; -INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES +DELETE FROM `script_texts` WHERE `entry` BETWEEN -1000164 AND -1000174; +INSERT INTO `script_texts` (entry,content_default,sound,type,language,emote,comment) VALUES (-1000164,'Ah, $GPriest:Priestess; you came along just in time. I appreciate it.',0,0,0,2,'garments SAY_COMMON_HEALED'), (-1000165,'Thank you! Thank you, $GPriest:Priestess;. Now I can take on those gnolls with your power to back me!',0,0,1,1,'garments SAY_DG_KEL_THANKS'), (-1000166,'Farewell to you, and may shadow always protect you!',0,0,1,3,'garments SAY_DG_KEL_GOODBYE'), @@ -10,4 +10,4 @@ INSERT INTO script_texts (entry,content_default,sound,type,language,emote,commen (-1000171, 'Thank you! Thank you, $GPriest:Priestess;. Now I can take on those wendigo with the Light on my side!',0,0,7,1,'garments SAY_DOLF_THANKS'), (-1000172, 'Farewell to you, and may the Light be with you always.',0,0,7,3,'garments SAY_DOLF_GOODBYE'), (-1000173, 'Thank you! Thank you, $GPriest:Priestess;. Now I can take on those corrupt timberlings with Elune\'s power behind me!',0,0,2,1,'garments SAY_SHAYA_THANKS'), -(-1000174, 'Farewell to you, and may Elune be with you always.',0,0,2,3,'garments SAY_SHAYA_GOODBYE'); +(-1000174, 'Farewell to you, and may Elune be with you always.',0,0,2,3,'garments SAY_SHAYA_GOODBYE');
\ No newline at end of file |