* Trinity sql coding style - fixed 2131_world

--HG--
branch : trunk

1 files changed, 22 insertions, 20 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