Scripts/Commands: Fix trinity_string usage and enhance commands

1 files changed, 98 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_99_99_18863_world.sql b/sql/updates/world/master/2017_99_99_18863_world.sql
new file mode 100644
index 00000000000..89b5c48f18c
--- /dev/null
+++ b/sql/updates/world/master/2017_99_99_18863_world.sql
@@ -0,0 +1,98 @@
+-- trinity_string content
+UPDATE `trinity_string` SET `content_default`='Up to %i expansions are allowed now.' WHERE  `entry`=61;
+UPDATE `trinity_string` SET `content_default`='Current energy: %i' WHERE  `entry`=124;
+UPDATE `trinity_string` SET `content_default`='GUID %s, faction is %u, flags is %u, npcflag is %s, dynflag is %u.' WHERE  `entry`=128;
+UPDATE `trinity_string` SET `content_default`='You changed GUID=%s\'s Faction to %u, flags to %u, npcflag to %s, dynflag to %u.' WHERE  `entry`=130;
+UPDATE `trinity_string` SET `content_default`='USER1: %s, ADD: %s, DIF: %s\n' WHERE  `entry`=152;
+UPDATE `trinity_string` SET `content_default`='You take %s copper from %s.' WHERE  `entry`=155;
+UPDATE `trinity_string` SET `content_default`='%s took %s copper from you.' WHERE  `entry`=156;
+UPDATE `trinity_string` SET `content_default`='You give %s copper to %s.' WHERE  `entry`=157;
+UPDATE `trinity_string` SET `content_default`='%s gave you %s copper.' WHERE  `entry`=158;
+UPDATE `trinity_string` SET `content_default`='USER2: %s, ADD: %s, RESULT: %s\n' WHERE  `entry`=160;
+UPDATE `trinity_string` SET `content_default`='Removed bit %u in field %u.' WHERE  `entry`=161;
+UPDATE `trinity_string` SET `content_default`='Set bit %u in field %u.' WHERE  `entry`=162;
+UPDATE `trinity_string` SET `content_default`='Gameobject %s (GUID: %s) damaged %i (actual health: %u).' WHERE  `entry`=177;
+UPDATE `trinity_string` SET `content_default`='TransMapID: %i TransOffsetX: %f TransOffsetY: %f TransOffsetZ: %f TransOffsetO: %f (Transport ID: %u %s)' WHERE  `entry`=186;
+UPDATE `trinity_string` SET `content_default`='Item \'%u\' \'%s\' added to list with maxcount \'%u\' and incrtime \'%u\' and extendedcost \'%u\'' WHERE  `entry`=206;
+UPDATE `trinity_string` SET `content_default`='Item \'%u\' \'%s\' deleted from vendor list' WHERE  `entry`=208;
+UPDATE `trinity_string` SET `content_default`='Item \'%u\' not found in vendor list.' WHERE  `entry`=209;
+UPDATE `trinity_string` SET `content_default`='Could not create visual waypoint with creatureID: %u' WHERE  `entry`=228;
+UPDATE `trinity_string` SET `content_default`='Could not create waypoint-creature with ID: %u' WHERE  `entry`=230;
+UPDATE `trinity_string` SET `content_default`='Warning: Could not delete WP with ID: %s from the world' WHERE  `entry`=242;
+UPDATE `trinity_string` SET `content_default`='Creature (GUID:%s) must be on the same map as player!' WHERE  `entry`=272;
+UPDATE `trinity_string` SET `content_default`='Game Object (GUID: %s) not found' WHERE  `entry`=273;
+UPDATE `trinity_string` SET `content_default`='Game Object (GUID: %s) has a nonexistent owner %s, can\'t be deleted.' WHERE  `entry`=274;
+UPDATE `trinity_string` SET `content_default`='Game Object |cffffffff|Hgameobject:%s|h[%s]|h|r (%s) turned to %f' WHERE  `entry`=276;
+UPDATE `trinity_string` SET `content_default`='Game Object |cffffffff|Hgameobject:%s|h[%s]|h|r (%s) moved' WHERE  `entry`=277;
+UPDATE `trinity_string` SET `content_default`='Creature (GUID: %s) not found' WHERE  `entry`=287;
+UPDATE `trinity_string` SET `content_default`='Spawn time changed to: %u' WHERE  `entry`=298;
+UPDATE `trinity_string` SET `content_default`='Faction %u unknown!' WHERE  `entry`=308;
+UPDATE `trinity_string` SET `content_default`='%u (idx:%u) - |cffffffff|Htitle:%u|h[%s %s]|h|r %s %s ' WHERE  `entry`=349;
+UPDATE `trinity_string` SET `content_default`='%u (idx:%u) - [%s %s] %s %s ' WHERE  `entry`=350;
+UPDATE `trinity_string` SET `content_default`='Security level of account %s changed to %u.' WHERE  `entry`=401;
+UPDATE `trinity_string` SET `content_default`='Target unit has %s auras:' WHERE  `entry`=467;
+UPDATE `trinity_string` SET `content_default`='id: %u %s effmask: %u charges: %d stack: %d slot %d duration: %d maxduration: %d %s %s caster: %s %s' WHERE  `entry`=468;
+UPDATE `trinity_string` SET `content_default`='Target unit has %s auras of type %u:' WHERE  `entry`=469;
+UPDATE `trinity_string` SET `content_default`='id: %u eff: %u amount: %i' WHERE  `entry`=470;
+UPDATE `trinity_string` SET `content_default`='Command : Additem, itemId = %u, amount = %i' WHERE  `entry`=494;
+UPDATE `trinity_string` SET `content_default`='Removed itemID = %u, amount = %i from %s' WHERE  `entry`=496;
+UPDATE `trinity_string` SET `content_default`='Cannot create item \'%u\' (amount: %u)' WHERE  `entry`=497;
+UPDATE `trinity_string` SET `content_default`='%s - sender: %s (guid: %s account: %u) receiver: %s (guid: %s account: %u) %s' WHERE  `entry`=509;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hitem:%u:0:0:0:0:0:0:0:0|h[%s]|h|r ' WHERE  `entry`=512;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hquest:%u:%i|h[%s]|h|r %s' WHERE  `entry`=513;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hcreature_entry:%u|h[%s]|h|r ' WHERE  `entry`=514;
+UPDATE `trinity_string` SET `content_default`='%s - |cffffffff|Hcreature:%s|h[%s X:%f Y:%f Z:%f MapId:%u]|h|r' WHERE  `entry`=515;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hgameobject_entry:%u|h[%s]|h|r ' WHERE  `entry`=516;
+UPDATE `trinity_string` SET `content_default`='%s (Entry: %u) - |cffffffff|Hgameobject:%s|h[%s X:%f Y:%f Z:%f MapId:%u]|h|r ' WHERE  `entry`=517;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hitemset:%u|h[%s %s]|h|r ' WHERE  `entry`=518;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hskill:%u|h[%s %s]|h|r %s %s' WHERE  `entry`=521;
+UPDATE `trinity_string` SET `content_default`='Selected object:\n|cffffffff|Hgameobject:%s|h[%s]|h|r GUID: %s ID: %u\nX: %f Y: %f Z: %f MapId: %u\nOrientation: %f\nPhaseId %u\nPhaseGroup %u' WHERE  `entry`=524;
+UPDATE `trinity_string` SET `content_default`='>> Add Game Object \'%u\' (%s) (GUID: %s) added at \'%f %f %f\'.' WHERE  `entry`=525;
+UPDATE `trinity_string` SET `content_default`='NPC currently selected by player: DB GUID: %s, %s. Faction: %u. npcFlags: %s. Entry: %u. DisplayID: %u (Native: %u).' WHERE  `entry`=539;
+UPDATE `trinity_string` SET `content_default`='Health (base): %u. (max): %s. (current): %s.' WHERE  `entry`=541;
+UPDATE `trinity_string` SET `content_default`='%s leveled you up to (%u).' WHERE  `entry`=557;
+UPDATE `trinity_string` SET `content_default`='%s leveled you down to (%u).' WHERE  `entry`=558;
+UPDATE `trinity_string` SET `content_default`='%s updateIndex: %u, value: %u.' WHERE  `entry`=562;
+UPDATE `trinity_string` SET `content_default`='You change %s UpdateIndex: %u value to %u.' WHERE  `entry`=563;
+UPDATE `trinity_string` SET `content_default`='The value index %u is too big for %s (count: %u).' WHERE  `entry`=564;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Hgameevent:%u|h[%s]|h|r%s' WHERE  `entry`=583;
+UPDATE `trinity_string` SET `content_default`='│ Guild: %s (ID: %s)' WHERE  `entry`=849;
+UPDATE `trinity_string` SET `content_default`='├─ Rank: %s, ID: %u' WHERE  `entry`=850;
+UPDATE `trinity_string` SET `content_default`='| %80s | %20s | %15s (%10u) | %19s |' WHERE  `entry`=1017;
+UPDATE `trinity_string` SET `content_default`='The character \'%s\' (GUID: %s Account %u) can NOT be restored: The account does not exist!' WHERE  `entry`=1023;
+UPDATE `trinity_string` SET `content_default`='The character \'%s\' (GUID: %s Account %u) can NOT be restored: The account character list is full!' WHERE  `entry`=1024;
+UPDATE `trinity_string` SET `content_default`='The character \'%s\' (GUID: %s Account %u) can NOT be restored: The name is already in use!' WHERE  `entry`=1025;
+UPDATE `trinity_string` SET `content_default`='%u - %s %s' WHERE  `entry`=1103;
+UPDATE `trinity_string` SET `content_default`='%u - %s' WHERE  `entry`=1104;
+UPDATE `trinity_string` SET `content_default`='%u - %s' WHERE  `entry`=1105;
+UPDATE `trinity_string` SET `content_default`='%u - %s %s' WHERE  `entry`=1106;
+UPDATE `trinity_string` SET `content_default`='%u - %s' WHERE  `entry`=1107;
+UPDATE `trinity_string` SET `content_default`='%u - %s %s' WHERE  `entry`=1108;
+UPDATE `trinity_string` SET `content_default`='%u - %s %s %s %s' WHERE  `entry`=1109;
+UPDATE `trinity_string` SET `content_default`='%s - %s X:%f Y:%f Z:%f MapId:%u' WHERE  `entry`=1110;
+UPDATE `trinity_string` SET `content_default`='%s - %s X:%f Y:%f Z:%f MapId:%u' WHERE  `entry`=1111;
+UPDATE `trinity_string` SET `content_default`='The character guid %s is already in use!' WHERE  `entry`=1117;
+UPDATE `trinity_string` SET `content_default`='%u - |cffffffff|Htaxinode:%u|h[%s %s]|h|r (Map:%u X:%f Y:%f Z:%f)' WHERE  `entry`=1128;
+UPDATE `trinity_string` SET `content_default`='%u - %s %s (Map:%u X:%f Y:%f Z:%f)' WHERE  `entry`=1129;
+UPDATE `trinity_string` SET `content_default`='Group type: %s and consists of %s players.' WHERE  `entry`=1149;
+UPDATE `trinity_string` SET `content_default`='Sender: %s(%s), Receiver: %s(%s)' WHERE  `entry`=1153;
+UPDATE `trinity_string` SET `content_default`='Displaying Guild Details for %s (Id: %s)' WHERE  `entry`=1177;
+UPDATE `trinity_string` SET `content_default`='| Guild Bank: %s gold' WHERE  `entry`=1181;
+UPDATE `trinity_string` SET `content_default`='Ticket %u is already assigned to someone else.' WHERE  `entry`=2007;
+UPDATE `trinity_string` SET `content_default`='This ticket is already assigned to yourself. To unassign use .ticket unassign %u and then reassign.' WHERE  `entry`=2013;
+UPDATE `trinity_string` SET `content_default`='Ticket %u is not assigned, you cannot unassign it.' WHERE  `entry`=2014;
+UPDATE `trinity_string` SET `content_default`='Cannot close ticket %u, it is assigned to another GM.' WHERE  `entry`=2016;
+UPDATE `trinity_string` SET `content_default`='Result limit reached (max results: %u)' WHERE  `entry`=5029;
+UPDATE `trinity_string` SET `content_default`='EquipmentId: %u (Original: %i).' WHERE  `entry`=5036;
+UPDATE `trinity_string` SET `content_default`='Map: %u | ID: %u | perm: %s | extended: %s | diff: %d | canReset: %s | TTR: %s' WHERE  `entry`=5045;
+UPDATE `trinity_string` SET `content_default`='Player binds: %u' WHERE  `entry`=5046;
+UPDATE `trinity_string` SET `content_default`='Group binds: %u' WHERE  `entry`=5047;
+UPDATE `trinity_string` SET `content_default`='Unbinding map: %u inst: %u perm: %s diff: %d canReset: %s TTR: %s' WHERE  `entry`=5048;
+UPDATE `trinity_string` SET `content_default`='Instances unbound: %u' WHERE  `entry`=5049;
+UPDATE `trinity_string` SET `content_default`='Instances loaded: %u' WHERE  `entry`=5050;
+UPDATE `trinity_string` SET `content_default`='Players in instances: %u' WHERE  `entry`=5051;
+UPDATE `trinity_string` SET `content_default`='Instance saves: %u' WHERE  `entry`=5052;
+UPDATE `trinity_string` SET `content_default`='Players bound: %u' WHERE  `entry`=5053;
+UPDATE `trinity_string` SET `content_default`='Groups bound: %u' WHERE  `entry`=5054;
+UPDATE `trinity_string` SET `content_default`='Boss id %u state is now set to %i (%s).' WHERE  `entry`=5057;
+UPDATE `trinity_string` SET `content_default`='Boss id %u state is %i (%s).' WHERE  `entry`=5058;