* Scripts/Commands: Fix guid usage and enhance commands

- Fix targeting gameobjects and creatures for .dist and .gps. The old code used DB guid to search from core generated guid lists.
- Fix some error messages saying 'no player found' even if creatures and gameobjects and players were searched
- Change atoi to atoul when receiving lowguids as string or other uint32 values
- Use ObjectGuid::LowType instead of uint32 for lowguid type
- Allow .gob info to take in gameobject guid link as well as entry link in addition to gameobject entry and update the documentation of the command
- Change .gob delete to post the spawnid (dbguid) instead of the ingame generated guid (which is basically never seen or used by the player in any other commands that I see)
- Allow spawntimesecs to be negative when spawning a gameobject
- Disable searching by ingame spawn id in commands. (it makes little sense for a user to provide a number which is then attempted to be used as DB guid and non DB guid when both could have a match)
- Update .gob turn documentation to tell about possibility to provide orientation in command
- Correct the types in .gob add command result trinity_string
- Correct the creature search for .npc del
- Change .event to .event info
- Add .go offset command
- Remove the .go command for empty string (no subcommand given) because it just used .go xyz
- Extend .gob info to show size, faction, flags and model dimensions
- Remove some unnecessary casts
- Document .wp show better (first and last were not documented)
- Insert spawnid to .wp show info error message
- Fix spawntime printing for .gobject target
- Fix guid targetting for .npc set movetype
- Fix query by spawnid for .wp show info
- Fix deleting of existing waypoints when twice doing the command .wp show on
- Fix deleting of existing waypoints when doing the command .wp show off
- Change wpguid column in DB and in core to uint32, which is what the spawnid type is in core and db.

Closes #18978

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2017_03_11_00_auth.sql b/sql/updates/auth/master/2017_03_11_00_auth.sql
new file mode 100644
index 00000000000..4d158f5ed8f
--- /dev/null
+++ b/sql/updates/auth/master/2017_03_11_00_auth.sql
@@ -0,0 +1,5 @@
+UPDATE `rbac_permissions` SET `name`='Command: event info' WHERE  `id`=367;
+DELETE FROM `rbac_permissions` WHERE `id` = 852;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (852, 'Command: go offset');
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 198 AND `linkedId` = 852;
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (198, 852);