path: root/data/sql/base/db_world/command.sql

-- MySQL dump 10.13  Distrib 8.4.3, for Win64 (x86_64)
--
-- Host: localhost    Database: acore_world
-- ------------------------------------------------------
-- Server version	8.4.3

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `command`
--

DROP TABLE IF EXISTS `command`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `command` (
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `security` tinyint unsigned NOT NULL DEFAULT '0',
  `help` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `command`
--

LOCK TABLES `command` WRITE;
/*!40000 ALTER TABLE `command` DISABLE KEYS */;
INSERT INTO `command` VALUES
('account',0,'Syntax: .account\r\n\r\nDisplay the access level of your account and the email adress if you possess the necessary permissions.'),
('account 2fa',0,'Syntax: .account 2fa <setup/remove>'),
('account 2fa remove',0,'Syntax: .account 2fa remove <token>\nDisables two-factor authentication for this account, if enabled.'),
('account 2fa setup',0,'Syntax: .account 2fa setup\nSets up two-factor authentication for this account.'),
('account addon',1,'Syntax: .account addon #addon\nSet expansion addon level allowed. Addon values: 0 - normal, 1 - tbc, 2 - wotlk.'),
('account create',4,'Syntax: .account create $account $password $email\r\n\r\nCreate account and set password to it.\r\n$email is optional, can be left blank.'),
('account delete',4,'Syntax: .account delete $account\r\n\r\nDelete account with all characters.'),
('account lock country',0,'Syntax: .account lock country [on|off]\nAllow login from account only from current used Country or remove this requirement.'),
('account lock ip',0,'Syntax: .account lock ip [on|off]\nAllow login from account only from current used IP or remove this requirement.'),
('account onlinelist',4,'Syntax: .account onlinelist\r\n\r\nShow list of online accounts.'),
('account password',0,'Syntax: .account password $old_password $new_password $new_password [$email]\r\n\r\nChange your account password. You may need to check the actual security mode to see if email input is necessary.'),
('account set',2,'Syntax: .account set $subcommand\nType .account set to see the list of possible subcommands or .help account set $subcommand to see info on subcommands'),
('account set 2fa',0,'Syntax: .account set 2fa <account> <secret/off>\nProvide a base32 encoded secret to setup two-factor authentication for the account.\nSpecify \'off\' to disable two-factor authentication for the account.'),
('account set addon',2,'Syntax: .account set addon [$account] #addon\r\n\r\nSet user (possible targeted) expansion addon level allowed. Addon values: 0 - normal, 1 - tbc, 2 - wotlk.'),
('account set email',4,'Syntax: .account set email $account $email $email_confirmation\nAdd or change an email to the account.'),
('account set gmlevel',4,'Syntax: .account set gmlevel [$account] #level [#realmid]\r\n\r\nSet the security level for targeted player (can\'t be used at self) or for account $name to a level of #level on the realm #realmID.\r\n\r\n#level may range from 0 to 3.\r\n\r\n#reamID may be -1 for all realms.'),
('account set password',4,'Syntax: .account set password $account $password $password\r\n\r\nSet password for account.'),
('achievement',2,'Syntax: .achievement $subcommand\nType .achievement to see the list of possible subcommands or .help achievement $subcommand to see info on subcommands'),
('achievement add',2,'Syntax: .achievement add $achievement\nAdd an achievement to the targeted player.\n$achievement: can be either achievement id or achievement link'),
('achievement checkall',3,'Syntax: .achievement checkall\r\nCheck all achievement criteria of the selected player.'),
('additem',2,'Syntax: .additem Optional(playerName/playerGUID) #itemID/[#itemName]/#itemLink #itemCount\r\nAdds the specified item to you, the selected character or the specifed character name/GUID.\r\nIf #itemCount is negative, you will remove #itemID.'),
('additem set',2,'Syntax: .additemset #itemsetid\r\n\r\nAdd items from itemset of id #itemsetid to your or selected character inventory. Will add by one example each item from itemset.'),
('announce',2,'Syntax: .announce $MessageToBroadcast\r\n\r\nSend a global message to all players online in chat log.'),
('appear',1,'Syntax: .appear [$charactername]\r\n\r\nTeleport to the given character. Either specify the character name or click on the character\'s portrait,e.g. when you are in a group. Character can be offline.'),
('arena captain',3,'Syntax: .arena captain #TeamID $name\n\nA command to set new captain to the team $name must be in the team'),
('arena create',3,'Syntax: .arena create $name \"arena name\" #type\n\nA command to create a new Arena-team in game. #type  = [2/3/5]'),
('arena disband',3,'Syntax: .arena disband #TeamID\n\nA command to disband Arena-team in game.'),
('arena info',2,'Syntax: .arena info #TeamID\n\nA command that show info about arena team'),
('arena lookup',2,'Syntax: .arena lookup $name\n\nA command that give a list of arenateam with the given $name'),
('arena rename',3,'Syntax: .arena rename \"oldname\" \"newname\"\n\nA command to rename Arena-team name.'),
('arena season deleteteams',3,'Syntax: .arena season deleteteams\nDeletes ALL arena teams.'),
('arena season reward',3,'Syntax: .arena season reward $brackets\nBuilds a ladder by combining team brackets and provides rewards from the arena_season_reward table.\nExample usage:\n \n# Combine all brackets, build a ladder, and distribute rewards among them\n.arena season reward all\n \n# Build ladders separately for 2v2, 3v3, and 5v5 brackets so each bracket receives its own rewards\n.arena season reward 2\n.arena season reward 3\n.arena season reward 5\n \n# Combine 2v2 and 3v3 brackets and distribute rewards\n.arena season reward 2,3'),
('arena season set state',3,'Syntax: .arena season set state $state\nChanges the state for the current season.\nAvailable states:\n 0 - disabled. Players can\'t queue for the arena.\n 1 - in progress. Players can use arena-related functionality.'),
('arena season start',3,'Syntax: .arena season start $season_id\nStarts a new arena season, places the correct vendors, and sets the new season state to IN PROGRESS.'),
('aura',2,'Syntax: .aura #spellid\r\n\r\nAdd the aura from spell #spellid to the selected Unit.'),
('aura stack',2,'Syntax: .aurastack #spellid #stacks\r\n\r\nModify #stacks of an already applied #spellid to the selected Unit.'),
('bags',2,'Syntax: .bags $subcommand \nType .bags to see the list of possible subcommands or .help bags $subcommand to see info on subcommands'),
('bags clear',2,'Syntax: .bags clear $itemQuality \nClear from players\' bags all items including and below $itemQuality (or all items if used .bags clear all).'),
('ban',2,'Syntax: .ban $subcommand\nType .ban to see the list of possible subcommands or .help ban $subcommand to see info on subcommands'),
('ban account',2,'Syntax: .ban account $Name $bantime $reason\r\nBan account kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
('ban character',2,'Syntax: .ban character $Name $bantime $reason\nBan character and kick player.\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
('ban ip',2,'Syntax: .ban ip $Ip $bantime $reason\r\nBan IP.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
('ban playeraccount',2,'Syntax: .ban playeraccount $Name $bantime $reason\nBan account and kick player.\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
('baninfo',2,'Syntax: .baninfo $subcommand\nType .baninfo to see the list of possible subcommands or .help baninfo $subcommand to see info on subcommands'),
('baninfo account',2,'Syntax: .baninfo account $accountid\r\nWatch full information about a specific ban.'),
('baninfo character',2,'Syntax: .baninfo character $charactername \r\nWatch full information about a specific ban.'),
('baninfo ip',2,'Syntax: .baninfo ip $ip\r\nWatch full information about a specific ban.'),
('banlist',2,'Syntax: .banlist $subcommand\nType .banlist to see the list of possible subcommands or .help banlist $subcommand to see info on subcommands'),
('banlist account',2,'Syntax: .banlist account [$Name]\r\nSearches the banlist for a account name pattern or show full list account bans.'),
('banlist character',2,'Syntax: .banlist character $Name\r\nSearches the banlist for a character name pattern. Pattern required.'),
('banlist ip',2,'Syntax: .banlist ip [$Ip]\r\nSearches the banlist for a IP pattern or show full list of IP bans.'),
('bf',3,'Syntax: .bf $subcommand\nType .bf to see the list of possible subcommands or .help bf $subcommand to see info on subcommands.'),
('bf enable',3,'Syntax: .bf enable #battleid'),
('bf start',3,'Syntax: .bf start #battleid'),
('bf stop',3,'Syntax: .bf stop #battleid'),
('bf switch',3,'Syntax: .bf switch #battleid'),
('bf timer',3,'Syntax: .bf timer #battleid #timer\n#timer: use a timestring like \"1h15m30s\".'),
('bindsight',3,'Syntax: .bindsight\r\n\r\nBinds vision to the selected unit indefinitely. Cannot be used while currently possessing a target.'),
('cache',1,'Character data cached during start up.\nType .cache to see a list of subcommands or .help $subcommand to see info on subcommands.'),
('cache delete',3,'Syntax: .cache delete $playerName\nDeletes the cached data for the selected character. Use for debugging only!'),
('cache info',1,'Syntax: .cache info $playerName\nDisplays cached data for the selected character.'),
('cache refresh',1,'Syntax: .cache refresh $playerName\nDeletes the current cache and refreshes it with updated data.'),
('cast',2,'Syntax: .cast #spellid [triggered]\r\n  Cast #spellid to selected target. If no target selected cast to self. If \'triggered\' or part provided then spell cast with triggered flag.'),
('cast back',2,'Syntax: .cast back #spellid [triggered]\r\n  Selected target will cast #spellid to your character. If \'triggered\' or part provided then spell cast with triggered flag.'),
('cast dest',2,'Syntax: .cast dest #spellid #x #y #z [triggered]\r\n  Selected target will cast #spellid at provided destination. If \'triggered\' or part provided then spell cast with triggered flag.'),
('cast dist',2,'Syntax: .cast dist #spellid [#dist [triggered]]\r\n  You will cast spell to point at distance #dist. If \'triggered\' or part provided then spell cast with triggered flag. Not all spells can be cast as area spells.'),
('cast self',2,'Syntax: .cast self #spellid [triggered]\r\n  Cast #spellid by target at target itself. If \'triggered\' or part provided then spell cast with triggered flag.'),
('cast target',2,'Syntax: .cast target #spellid [triggered]\r\n  Selected target will cast #spellid to his victim. If \'triggered\' or part provided then spell cast with triggered flag.'),
('character',2,'Syntax: character $subcommand\n Type .character to see a list of possible subcommands\n or .help character $subcommand to see info on the subcommand.'),
('character changeaccount',3,'Syntax: .character changeaccount $NewAccountName $Name.\nMoves the specified character to the provided account. \nKicks the player if the character is online.'),
('character changefaction',2,'Syntax: .character changefaction $name\r\n\r\nChange character faction.'),
('character changerace',2,'Syntax: .character changerace $name\r\n\r\nChange character race.'),
('character check bag',2,'Syntax: .character check bag [$target_player]\r #bagSlot 1 - 4'),
('character check bank',2,'Syntax: .character check bank \r\n\r\nShow your bank inventory.'),
('character check profession',2,'Syntax: .character check profession [$target_player]\r\nShow known professions list for selected player'),
('character customize',2,'Syntax: .character customize [$name]\r\n\r\nMark selected in game or by $name in command character for customize at next login.'),
('character deleted delete',4,'Syntax: .character deleted delete #guid|$name\r\n\r\nCompletely deletes the selected characters.\r\nIf $name is supplied, only characters with that string in their name will be deleted, if #guid is supplied, only the character with that GUID will be deleted.'),
('character deleted list',3,'Syntax: .character deleted list [#guid|$name]\r\n\r\nShows a list with all deleted characters.\r\nIf $name is supplied, only characters with that string in their name will be selected, if #guid is supplied, only the character with that GUID will be selected.'),
('character deleted purge',4,'Syntax: .character deleted purge [#keepDays]\r\nCompletely removes all characters from the database that where deleted more than #keepDays ago. If #keepDays not provided the used value from worldserver.conf option \'CharDelete.KeepDays\'. If \'CharDelete.KeepDays\' option is disabled (set to value 0) then this command can\'t be used without the specifying #keepDays parameter.'),
('character deleted restore',3,'Syntax: .character deleted restore #guid|$name [$newname] [#new account]\r\n\r\nRestores deleted characters.\r\nIf $name is supplied, only characters with that string in their name will be restored, if $guid is supplied, only the character with that GUID will be restored.\r\nIf $newname is set, the character will be restored with that name instead of the original one. If #newaccount is set, the character will be restored to specific account character list. This works only with one character!'),
('character erase',4,'Syntax: .character erase $name\r\n\r\nDelete character $name. Character finally deleted in case any deleting options.'),
('character level',2,'Syntax: .character level [$playername] [#level]\r\n\r\nSet the level of character with $playername (or the selected if not name provided) by #numberoflevels Or +1 if no #numberoflevels provided). If #numberoflevels is omitted, the level will be increase by 1. If #numberoflevels is 0, the same level will be restarted. If no character is selected and name not provided, increase your level. Command can be used for offline character. All stats and dependent values recalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost.'),
('character rename',2,'Syntax: .character rename [$name] [reserveName] [$newName]\r\n\r\nMark selected in game or by $name in command character for rename at next login.\r\n\r\nIf [reserveName] is 1 then the player\'s current name is added to the list of reserved names.\r\nIf [newName] then the player will be forced rename.'),
('character reputation',2,'Syntax: .character reputation [$player_name]\r\n\r\nShow reputation information for selected player or player find by $player_name.'),
('character titles',2,'Syntax: .character titles [$player_name]\r\n\r\nShow known titles list for selected player or player find by $player_name.'),
('cheat',2,'Syntax: .cheat $subcommand\r\nType .cheat to see the list of possible subcommands or .help cheat $subcommand to see info on subcommands'),
('cheat casttime',2,'Syntax: .cheat casttime [on/off]\r\nRemove spells\' casting time.'),
('cheat cooldown',2,'Syntax: .cheat cooldown [on/off]\r\nDisable spells\' cooldowns.'),
('cheat explore',2,'Syntax: .cheat explore #flag\r\nReveal or hide all maps for the selected player. If no player is selected, hide or reveal maps to you.\r\nUse a #flag of value 1 to reveal, use a #flag value of 0 to hide all maps.'),
('cheat god',2,'Syntax: .cheat god [on/off]\r\nTurn the user invulnerable.'),
('cheat power',2,'Syntax: .cheat power [on/off]\r\nRemove spells\' cost (mana, energy, rage...).'),
('cheat taxi',2,'Syntax: .cheat taxi on/off\r\nTemporary grant access to all taxi routes for the selected character.\r\n If no character is selected, hide or reveal all routes to you. Visited taxi nodes are still accessible after removing access.'),
('cheat waterwalk',2,'Syntax: .cheat waterwalk on/off\r\nAllow to walk on water (self or selected character).'),
('combatstop',2,'Syntax: .combatstop [$playername]\r\nStop combat for selected character. If selected non-player then command applied to self. If $playername provided then attempt applied to online player $playername.'),
('cometome',3,'Syntax: .cometome $parameter\nMake selected creature come to your current location (new position not saved to DB).'),
('commands',0,'Syntax: .commands\r\n\r\nDisplay a list of available commands for your account level.'),
('commentator',2,'Syntax: .commentator [on/off]\r\n\r\nEnable or Disable in game Commentator tag or show current state if on/off not provided.'),
('cooldown',2,'Syntax: .cooldown [#spell_id]\r\n\r\nRemove all (if spell_id not provided) or #spel_id spell cooldown from selected character or you (if no selection).'),
('damage',2,'Syntax: .damage $damage_amount [$school [$spellid]]\r\n\r\nApply $damage to target. If not $school and $spellid provided then this flat clean melee damage without any modifiers. If $school provided then damage modified by armor reduction (if school physical),\n and target absorbing modifiers and result applied as melee damage to target. If spell provided then damage modified and applied as spell damage. $spellid can be shift-link.'),
('debug',2,'Syntax: .debug $subcommand\nType .debug to see the list of possible subcommands or .help debug $subcommand to see info on subcommands'),
('debug anim',3,'TODO'),
('debug areatriggers',3,'Syntax: .debug areatriggers\nToggle debug mode for areatriggers. In debug mode GM will be notified if reaching an areatrigger'),
('debug arena',3,'Syntax: .debug arena\r\n\r\nToggle debug mode for arenas. In debug mode GM can start arena with single player.'),
('debug bg',3,'Syntax: .debug bg\r\n\r\nToggle debug mode for battlegrounds. In debug mode GM can start battleground with single player.'),
('debug boundary',3,'Syntax: .debug boundary [duration] [fill] [z]\nOptional arguments:\n- duration: Duration in ms (default: 5000, max: 180000).\n- fill: Fills the boundary with markers.\n- z: Includes z-axis in visualization.'),
('debug cooldown',3,'Syntax: .debug cooldown #spellID #cooldownTime #itemID\nApply a cooldown of the given duration (in milliseconds) for the given spell and item ID.'),
('debug dummy',3,'Syntax: .debug dummy <???>\n\nCatch-all debug command. Does nothing by default. If you want it to do things for testing, add the things to its script in cs_debug.cpp.'),
('debug entervehicle',3,'Syntax: .debug entervehicle #entry #seatID\nEnter the targeted or given vehicle ID in the given seat.'),
('debug getitemstate',3,'Syntax: .debug getitemstate #itemState [unchanged/changed/new/removed/queue/check_all]\nReturns all items in a given player\'s inventory with a given item state.'),
('debug getitemvalue',3,'Syntax: .debug getitemvalue #GUID #index\nReturns the value of the given index for the given item GUID.'),
('debug getvalue',3,'Syntax: .debug getvalue #index #isInt\nReturns either an integer or float value at a given index of your target.'),
('debug hostile',1,'Syntax: .debug hostile\nReturns the hostile reference list of a given player.'),
('debug itemexpire',3,'Syntax: .debug itemexpire #GUID\nDestroy an item with the given GUID.'),
('debug lfg',3,'Syntax: .debug lfg\r\nToggle debug mode for lfg. In debug mode GM can start lfg queue with one player.'),
('debug lootrecipient',3,'Syntax: .debug lootrecipient\nReturns the loot recipient of the targeted creature.'),
('debug los',3,'Syntax: .debug los\nReturns line of sight status between you and your target.'),
('debug Mod32Value',3,'Syntax: .debug Mod32Value #field #value\r\n\r\nAdd #value to field #field of your character.'),
('debug moveflags',3,'Syntax: .debug moveflags [$newMoveFlags [$newMoveFlags2]]\r\nNo params given will output the current moveflags of the target'),
('debug objectcount',3,'Syntax: .debug objectcount <optional map id> Shows the number of Creatures and GameObjects for the specified map id or for all maps if none is specified'),
('debug play',1,'Syntax: .debug play $subcommand\nType .debug play to see the list of possible subcommands or .help debug play $subcommand to see info on subcommands.'),
('debug play cinematic',1,'Syntax: .debug play cinematic #cinematicid\r\n\r\nPlay cinematic #cinematicid for you. You stay at place while your mind fly.\r\n'),
('debug play movie',1,'Syntax: .debug play movie #movieid\r\n\r\nPlay movie #movieid for you.'),
('debug play music',3,'Syntax: .debug play music <musicId>\nPlay music with <musicId>.\nMusic will be played only for you. Other players will not hear this.'),
('debug play sound',1,'Syntax: .debug play sound #soundid\r\n\r\nPlay sound with #soundid.\r\nSound will be play only for you. Other players do not hear this.\r\nWarning: client may have more 5000 sounds...'),
('debug play visual',3,'Syntax: .debug play visual #visualid\r\nPlay spell visual with #visualid.\n#visualid refers to the ID from SpellVisualKit.dbc'),
('debug send',3,'Syntax: .debug send $subcommand\nType .debug send to see the list of possible subcommands or .help debug send $subcommand to see info on subcommands.'),
('debug send buyerror',3,'Syntax: .debug send buyerror #error\nSends the given buy error result.'),
('debug send channelnotify',3,'Syntax: .debug send channelnotify #type\nSends a channel notify message of the given type.'),
('debug send chatmessage',3,'Syntax: .debug send chatmessage #type\nSends a chat message of the given type.'),
('debug send equiperror',3,'Syntax: .debug send equiperror #error\nSends the given equip error result.'),
('debug send largepacket',3,'Syntax: .debug send largepacket\nSends a system message of 128 kilobytes.'),
('debug send opcode',3,'Syntax: .debug send opcode\nSends opcodes contained in \"opcode.txt\".'),
('debug send qinvalidmsg',3,'Syntax: .debug send qinvalidmsg #error\nSends the given quest error result.'),
('debug send qpartymsg',3,'Syntax: .debug send qpartymsg #message\nSends the given party quest share message.'),
('debug send sellerror',3,'Syntax: .debug send sellerror #error\nSends the given sell error result.'),
('debug send setphaseshift',3,'Syntax: .debug send setphaseshift #phaseShift\nSends a phase shift message with the given phase shift value.'),
('debug send spellfail',3,'Syntax: .debug send spellfail #result #failArgument1 #failArgument2\nSends a spell failure message with the given result and argument values.'),
('debug setaurastate',3,'Syntax: .debug setaurastate #state #apply\nSets the selected units aura state using the given apply value.'),
('debug setbit',3,'Syntax: .debug setbit #index #bit\nSets the unsigned 32-bit integer value of the target at the given index to the given bit.'),
('debug setitemvalue',3,'Syntax: .debug setitemvalue #GUID #index #value\nSets the value of the given index for the given item GUID to the given value.'),
('debug setvalue',3,'Syntax: .debug setvalue #index #value\nSets the unsigned 32-bit integer or float value of the target at the given index to the given value.'),
('debug setvid',3,'Syntax: .debug setvid #ID\nCurrently disabled.\nSets the given target\'s vehicle ID to the given value.'),
('debug spawnvehicle',3,'Syntax: .debug spawnvehicle #entry #ID\nCreates a vehicle with the given ID.'),
('debug threat',3,'Syntax: .debug threat\nReturns the threat list of a given creature.'),
('debug update',3,'Syntax: .debug update #index #value\nSets the unsigned 32-bit integer value of the target at the given index to the given bit.'),
('debug uws',3,'Syntax: .debug uws #variable #value\nSends a worldstate update for the given variable to the given value.'),
('deserter bg add',3,'Syntax: .deserter bg add $playerName <$time>\r\nAdds the bg deserter debuff to a player or your target with $time.\nOptional $time: use a timestring like \"1h15m30s\".Default: 15m'),
('deserter bg remove',3,'Syntax: .deserter bg remove $playerName \n\n Removes the bg deserter debuff from a player or your target.'),
('deserter bg remove all',3,'Syntax: .deserter bg remove all <$maxDuration>\r\n Removes the bg deserter debuff from all online and offline players.\nOptional $maxDuration sets the maximum duration to be removed. Use a timestring like \"1h45m\". \"-1\" for any duration. Default: 15m'),
('deserter instance add',3,'Syntax: .deserter instance add $playerName <$time>\r\nAdds the instance deserter debuff to a player or your target with $time.\nOptional $time: use a timestring like \"1h15m30s\". Default: 30m'),
('deserter instance remove',3,'Syntax: .deserter instance remove $playerName \n\n Removes the instance deserter debuff from a player or your target.'),
('deserter instance remove all',3,'Syntax: .deserter instance remove all <$maxDuration>\r\n Removes the instance deserter debuff from all online and offline players.\nOptional $maxDuration sets the maximum duration to be removed. Use a timestring like \"1h45m\". \"-1\" for any duration. Default: 30m'),
('dev',3,'Syntax: .dev [on/off]\r\n\r\nEnable or Disable in game Dev tag or show current state if on/off not provided.'),
('die',2,'Syntax: .die\r\n\r\nKill the selected player. If no player is selected, it will kill you.'),
('disable add battleground',3,'Syntax: .disable add battleground $entry $flag $comment'),
('disable add map',3,'Syntax: .disable add map $entry $flag $comment'),
('disable add outdoorpvp',3,'Syntax: .disable add outdoorpvp $entry $flag $comment'),
('disable add quest',3,'Syntax: .disable add quest $entry $flag $comment'),
('disable add spell',3,'Syntax: .disable add spell $entry $flag $comment'),
('disable add vmap',3,'Syntax: .disable add vmap $entry $flag $comment'),
('disable remove battleground',3,'Syntax: .disable remove battleground $entry'),
('disable remove map',3,'Syntax: .disable remove map $entry'),
('disable remove outdoorpvp',3,'Syntax: .disable remove outdoorpvp $entry'),
('disable remove quest',3,'Syntax: .disable remove quest $entry'),
('disable remove spell',3,'Syntax: .disable remove spell $entry'),
('disable remove vmap',3,'Syntax: .disable remove vmap $entry'),
('dismount',0,'Syntax: .dismount\r\n\r\nDismount you, if you are mounted.'),
('distance',3,'Syntax: .distance\r\n\r\nDisplay the distance from your character to the selected creature.'),
('event',2,'Syntax: .event #event_id\r\nShow details about event with #event_id.'),
('event activelist',2,'Syntax: .event activelist\r\nShow list of currently active events.'),
('event start',2,'Syntax: .event start #event_id\r\nStart event #event_id. Set start time for event to current moment (change not saved in DB).'),
('event stop',2,'Syntax: .event stop #event_id\r\nStop event #event_id. Set start time for event to time in past that make current moment is event stop time (change not saved in DB).'),
('flusharenapoints',3,'Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'),
('freeze',2,'Syntax: .freeze (#player)\r\n\"Freezes\" #player and disables his chat. When using this without #name it will freeze your target.'),
('gear repair',2,'Syntax: .gear repair \nRepair all selected player\'s items.'),
('gear stats',0,'Syntax: .gear stats'),
('gm',1,'Syntax: .gm [on/off]\r\n\r\nEnable or Disable in game GM MODE or show current state of on/off not provided.'),
('gm chat',2,'Syntax: .gm chat [on/off]\r\n\r\nEnable or disable chat GM MODE (show gm badge in messages) or show current state of on/off not provided.'),
('gm fly',2,'Syntax: .gm fly [on/off]\r\nEnable/disable gm fly mode.'),
('gm ingame',0,'Syntax: .gm ingame\r\n\r\nDisplay a list of available in game Game Masters.'),
('gm list',3,'Syntax: .gm list\r\n\r\nDisplay a list of all Game Masters accounts and security levels.'),
('gm visible',2,'Syntax: .gm visible on/off\r\n\r\nOutput current visibility state or make GM visible(on) and invisible(off) for other players.'),
('gmannounce',2,'Syntax: .gmannounce $announcement\r\nSend an announcement to online Gamemasters.'),
('gmnameannounce',2,'Syntax: .gmnameannounce $announcement.\r\nSend an announcement to all online GM\'s, displaying the name of the sender.'),
('gmnotify',2,'Syntax: .gmnotify $notification\r\nDisplays a notification on the screen of all online GM\'s.'),
('go',1,'Syntax: .go $subcommand\nType .go to see the list of possible subcommands or .help go $subcommand to see info on subcommands'),
('go creature',1,'Syntax: .go creature #creature_guid\r\nTeleport your character to creature with guid #creature_guid.\r\n.gocreature #creature_name\r\nTeleport your character to creature with this name.\r\n.gocreature id #creature_id\r\nTeleport your character to a creature that was spawned from the template with this entry.\r\n*If* more than one creature is found, then you are teleported to the first that is found inside the database.'),
('go creature id',1,'Syntax: .go creature id #creature_entry [#spawn] Teleports you to first (if no #spawn provided) spawn the given creature entry. '),
('go creature name',1,'Syntax: .go creature name #name\r\nTeleports you to the first spawn for the given creature name.\r\n*If* more than one creature is found, then you are teleported to the first that is found inside the database.'),
('go gameobject id',1,'Syntax: .go gameobject id #gameobject_entry [#spawn] Teleports you to first (if no #spawn provided) spawn the given gameobject entry.'),
('go graveyard',1,'Syntax: .go graveyard #graveyardId\r\n Teleport to graveyard with the graveyardId specified.'),
('go grid',1,'Syntax: .go grid #gridX #gridY [#mapId]\r\n\r\nTeleport the gm to center of grid with provided indexes at map #mapId (or current map if it not provided).'),
('go quest',1,'Syntax: .go quest <starter/ender> <quest>.\nTeleports you to the quest starter/ender creature or object.'),
('go taxinode',1,'Syntax: .go taxinode #taxinode\r\n\r\nTeleport player to taxinode coordinates. You can look up zone using .lookup taxinode $namepart'),
('go ticket',2,'Syntax: .go ticket #ticketid\r\nTeleports the user to the location where $ticketid was created.'),
('go trigger',1,'Syntax: .go trigger #trigger_id\r\n\r\nTeleport your character to areatrigger with id #trigger_id. Character will be teleported to trigger target if selected areatrigger is telporting trigger.'),
('go xyz',1,'\rSyntax: .go xyz #x #y [#z [#mapid [#orientation]]]\r\rTeleport player to point with (#x,#y,#z) coordinates at map #mapid with orientation #orientation.\r\rIf #z is not provided, ground/water level will be used. If #mapid is not provided, the current map will be used. If #orientation is not provided, the current orientation will be used.\r\rNon-numbers are allowed and will be ignored.'),
('go zonexy',1,'Syntax: .go zonexy #x #y [#zone]\r\n\r\nTeleport player to point with (#x,#y) client coordinates at ground(water) level in zone #zoneid or current zone if #zoneid not provided. You can look up zone using .lookup area $namepart'),
('gobject',2,'Syntax: .gobject $subcommand\nType .gobject to see the list of possible subcommands or .help gobject $subcommand to see info on subcommands'),
('gobject activate',2,'Syntax: .gobject activate #guid\r\n\r\nActivates an object like a door or a button.'),
('gobject add',3,'Syntax: .gobject add #id <spawntimeSecs>\r\n\r\nAdd a game object from game object templates to the world at your current location using the #id.\r\nspawntimesecs sets the spawntime, it is optional.\r\n\r\nNote: this is a copy of .gameobject.'),
('gobject add temp',2,'Adds a temporary gameobject that is not saved to DB.'),
('gobject delete',3,'Syntax: .gobject delete #go_guid\r\nDelete gameobject with guid #go_guid.'),
('gobject info',1,'Syntax: .gobject info [$object_entry]\r \r Query Gameobject information for selected gameobject or given entry.'),
('gobject move',3,'Syntax: .gobject move #goguid [#x #y #z]\r\n\r\nMove gameobject #goguid to character coordinates (or to (#x,#y,#z) coordinates if its provide).'),
('gobject near',1,'Syntax: .gobject near  [#distance]\r\n\r\nOutput gameobjects at distance #distance from player. Output gameobject guids and coordinates sorted by distance from character. If #distance not provided use 10 as default value.'),
('gobject respawn',1,'Syntax: .gobject respawn #guid./nRespawns the target gameobject.'),
('gobject set',3,'Syntax: .gobject set $subcommand\nType .gobject set to see the list of possible subcommands or .help gobject set $subcommand to see info on subcommands.'),
('gobject set phase',3,'Syntax: .gobject set phase #guid #phasemask\r\n\r\nGameobject with DB guid #guid phasemask changed to #phasemask with related world vision update for players. Gameobject state saved to DB and persistent.'),
('gobject set state',3,'Syntax: .gobject set state #GUIDLow, #objectType, #objectState\nSets the byte value or sends a custom animation for a given gameobject GUID.'),
('gobject target',1,'Syntax: .gobject target [#go_id|#go_name_part]\r\n\r\nLocate and show position nearest gameobject. If #go_id or #go_name_part provide then locate and show position of nearest gameobject with gameobject template id #go_id or name included #go_name_part as part.'),
('gobject turn',3,'Syntax: .gobject turn #goguid \r\n\r\nSet for gameobject #goguid orientation same as current character orientation.'),
('gps',1,'Syntax: .gps [$name|$shift-link]\r\n\r\nDisplay the position information for a selected character or creature (also if player name $name provided then for named player, or if creature/gameobject shift-link provided then pointed creature/gameobject if it loaded). Position information includes X, Y, Z, and orientation, map Id and zone Id'),
('group',2,'Syntax: .group $subcommand\nType .group to see the list of possible subcommands or .help group $subcommand to see info on subcommands'),
('group disband',2,'Syntax: .group disband [$characterName]\n\nDisbands the given character\'s group.'),
('group join',2,'Syntax: .group join $AnyCharacterNameFromGroup [$CharacterName] \r\nAdds to group of player $AnyCharacterNameFromGroup player $CharacterName (or selected).'),
('group leader',2,'Syntax: .group leader [$characterName]\n\nSets the given character as his group\'s leader.'),
('group list',2,'Syntax: .group list [$CharacterName] \r\nLists all the members of the group/party the player is in.'),
('group remove',2,'Syntax: .group remove [$characterName]\n\nRemoves the given character from his group.'),
('group revive',2,'Syntax: .group revive\r\n\r\nRevives all players in your group.'),
('groupsummon',2,'Syntax: .groupsummon [$charactername]\r\n\r\nTeleport the given character and his group to you. Teleported only online characters but original selected group member can be offline.'),
('guid',2,'Syntax: .guid\r\n\r\nDisplay the GUID for the selected character.'),
('guild',2,'Syntax: .guild $subcommand\nType .guild to see the list of possible subcommands or .help guild $subcommand to see info on subcommands'),
('guild create',2,'Syntax: .guild create [$GuildLeaderName] \"$GuildName\"\r\n\r\nCreate a guild named $GuildName with the player $GuildLeaderName (or selected) as leader.  Guild name must in quotes.'),
('guild delete',2,'Syntax: .guild delete \"$GuildName\"\r\n\r\nDelete guild $GuildName. Guild name must in quotes.'),
('guild info',2,'Shows information about the target\'s guild or a given Guild Id or Name.'),
('guild invite',2,'Syntax: .guild invite [$CharacterName] \"$GuildName\"\r\n\r\nAdd player $CharacterName (or selected) into a guild $GuildName. Guild name must in quotes.'),
('guild rank',2,'Syntax: .guild rank [$CharacterName] #RankNumber\r\n\r\nSet for player $CharacterName (or selected) rank #Rank in a guild. Ranks value are numeric, 0 = Guild Master, 1 = Officer, etc...'),
('guild rename',3,'Syntax: .guild rename \"$GuildName\" \"$NewGuildName\" \n\n Rename a guild named $GuildName with $NewGuildName. Guild name and new guild name must in quotes.'),
('guild uninvite',2,'Syntax: .guild uninvite [$CharacterName]\r\n\r\nRemove player $CharacterName (or selected) from a guild.'),
('help',0,'Syntax: .help [$command]\r\n\r\nDisplay usage instructions for the given $command. If no $command provided show list available commands.'),
('hidearea',3,'Syntax: .hidearea #areaid\r\n\r\nHide the area of #areaid to the selected character. If no character is selected, hide this area to you.'),
('honor',2,'Syntax: .honor $subcommand\nType .honor to see the list of possible subcommands or .help honor $subcommand to see info on subcommands'),
('honor add',2,'Syntax: .honor add $amount\r\n\r\nAdd a certain amount of honor (gained today) to the selected player.'),
('honor add kill',2,'Syntax: .honor add kill\r\n\r\nAdd the targeted unit as one of your pvp kills today (you only get honor if it\'s a racial leader or a player)'),
('honor update',2,'Syntax: .honor update\r\n\r\nForce the yesterday\'s honor fields to be updated with today\'s data, which will get reset for the selected player.'),
('instance',1,'Syntax: .instance $subcommand\nType .instance to see the list of possible subcommands or .help instance $subcommand to see info on subcommands'),
('instance getbossstate',1,'Syntax: .instance getbossstate [$Name]\nDisplays the state for every available encounter.\nIf no character name is provided, the current map will be used as target.'),
('instance listbinds',1,'Syntax: .instance listbinds\r\n  Lists the binds of the selected player.'),
('instance savedata',3,'Syntax: .instance savedata\r\n  Save the InstanceData for the current player\'s map to the DB.'),
('instance setbossstate',2,'Syntax: .instance setbossstate $bossId $encounterState [$Name]\r\nSets the EncounterState for the given boss id to a new value. EncounterStates range from 0 to 5.\r\nIf no character name is provided, the current map will be used as target.'),
('instance unbind',2,'Syntax: .instance unbind <mapid|all> [difficulty]\r\n  Clear all/some of player\'s binds'),
('inventory',1,'Syntax: .inventory $subcommand \nType .inventory to see the list of possible subcommands or .help inventory $subcommand to see info on subcommands'),
('inventory count',1,'Syntax: .inventory count $playerName or $plaerGuid \nCount free slots in bags divided into different bag types.'),
('item move',2,'Syntax: .itemmove #sourceslotid #destinationslotid\r\n\r\nMove an item from slots #sourceslotid to #destinationslotid in your inventory\r\n\r\nNot yet implemented'),
('item refund',3,'Syntax: .item refund <name> <item> <extendedCost> \nRemoves the item and restores honor/arena/items according to extended cost.'),
('item restore',2,'Syntax: .item restore [#recoveryItemId] [#playername]\r\n\r\nRestore an disposed item for the specified player. Get recoveryId from \".item restore list\" command.'),
('item restore list',2,'Syntax: .item restore list [#playername]\r\n\r\nSee restorable items for the specified player.'),
('kick',2,'Syntax: .kick [$charactername] [$reason]\r\n\r\nKick the given character name from the world with or without reason. If no character name is provided then the selected player (except for yourself) will be kicked. If no reason is provided, default is \"No Reason\".'),
('learn',2,'Syntax: .learn #spell [all]\r\n\r\nSelected character learn a spell of id #spell. If \'all\' provided then all ranks learned.'),
('learn all',2,'Syntax: .learn all $subcommand\nType .learn all to see the list of possible subcommands or .help learn all $subcommand to see info on subcommands.'),
('learn all crafts',2,'Syntax: .learn crafts\r\n\r\nLearn all professions and recipes.'),
('learn all default',2,'Syntax: .learn all default [$playername]\r\n\r\nLearn for selected/$playername player all default spells for his race/class and spells rewarded by completed quests.'),
('learn all gm',2,'Syntax: .learn all gm\r\n\r\nLearn all default spells for Game Masters.'),
('learn all lang',2,'Syntax: .learn all lang\r\n\r\nLearn all languages'),
('learn all my',2,'Syntax: .learn all my $subcommand\nType .learn all my to see the list of possible subcommands or .help learn all my $subcommand to see info on subcommands.'),
('learn all my class',2,'Syntax: .learn all my class\r\n\r\nLearn all spells and talents available for his class.'),
('learn all my pettalents',2,'Syntax: .learn all my pettalents\r\n\r\nLearn all talents for your pet available for his creature type (only for hunter pets).'),
('learn all my spells',2,'Syntax: .learn all my spells\r\n\r\nLearn all spells (except talents and spells with first rank learned as talent) available for his class.'),
('learn all my talents',2,'Syntax: .learn all my talents\r\n\r\nLearn all talents (and spells with first rank learned as talent) available for his class.'),
('learn all recipes',2,'Syntax: .learn all recipes [$profession]\r\rLearns all recipes of specified profession and sets skill level to max.\rExample: .learn all recipes enchanting'),
('levelup',2,'Syntax: .levelup [$playername] [#numberoflevels]\r\n\r\nIncrease/decrease the level of character with $playername (or the selected if not name provided) by #numberoflevels Or +1 if no #numberoflevels provided). If #numberoflevels is omitted, the level will be increase by 1. If #numberoflevels is 0, the same level will be restarted. If no character is selected and name not provided, increase your level. Command can be used for offline character. All stats and dependent values recalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost.'),
('lfg',1,'Syntax: .lfg $subcommand\nType .lfg to see the list of possible subcommands or .help lfg $subcommand to see info on subcommands.'),
('lfg clean',3,'Syntax: .flg clean\n Cleans current queue, only for debugging purposes.'),
('lfg group',1,'Syntax: .lfg group\n Shows information about all players in the group  (state, roles, comment, dungeons selected).'),
('lfg options',2,'Syntax: .lfg options [new value]\n Shows current lfg options. New value is set if extra param is present.'),
('lfg player',1,'Syntax: .lfg player\n Shows information about player (state, roles, comment, dungeons selected).'),
('lfg queue',1,'Syntax: .lfg queue\n Shows info about current lfg queues.'),
('linkgrave',3,'Syntax: .linkgrave #graveyard_id [alliance|horde]\r\n\r\nLink current zone to graveyard for any (or alliance/horde faction ghosts). This let character ghost from zone teleport to graveyard after die if graveyard is nearest from linked to zone and accept ghost of this faction. Add only single graveyard at another map and only if no graveyards linked (or planned linked at same map).'),
('list',1,'Syntax: .list $subcommand\nType .list to see the list of possible subcommands or .help list $subcommand to see info on subcommands'),
('list auras',1,'Syntax: .list auras\nList auras (passive and active) of selected creature or player. If no creature or player is selected, list your own auras.'),
('list creature',1,'Syntax: .list creature #creature_id [#max_count]\r\n\r\nOutput creatures with creature id #creature_id found in world. Output creature guids and coordinates sorted by distance from character. Will be output maximum #max_count creatures. If #max_count not provided use 10 as default value.'),
('list item',1,'Syntax: .list item #item_id [#max_count]\r\n\r\nOutput items with item id #item_id found in all character inventories, mails, auctions, and guild banks. Output item guids, item owner guid, owner account and owner name (guild name and guid in case guild bank). Will be output maximum #max_count items. If #max_count not provided use 10 as default value.'),
('list object',1,'[DEPRECATED]: use \".list gobject\" instead.\r\nSyntax: .go object #object_guid\r\nTeleport your character to gameobject with guid #object_guid'),
('lookup',1,'Syntax: .lookup $subcommand\nType .lookup to see the list of possible subcommands or .help lookup $subcommand to see info on subcommands'),
('lookup area',1,'Syntax: .lookup area $namepart\r\n\r\nLooks up an area by $namepart, and returns all matches with their area ID\'s.'),
('lookup creature',1,'Syntax: .lookup creature $namepart\r\n\r\nLooks up a creature by $namepart, and returns all matches with their creature ID\'s.'),
('lookup event',1,'Syntax: .lookup event $name\r\nAttempts to find the ID of the event with the provided $name.'),
('lookup faction',1,'Syntax: .lookup faction $name\r\nAttempts to find the ID of the faction with the provided $name.'),
('lookup gobject',1,'Syntax: .lookup object $objname\r\n\r\nLooks up an gameobject by $objname, and returns all matches with their Gameobject ID\'s.'),
('lookup item',1,'Syntax: .lookup item $itemname\r\n\r\nLooks up an item by $itemname, and returns all matches with their Item ID\'s.'),
('lookup item set',1,'Syntax: .lookup itemset $itemname\r\n\r\nLooks up an item set by $itemname, and returns all matches with their Item set ID\'s.'),
('lookup map',1,'Syntax: .lookup map $namepart\r\n\r\nLooks up a map by $namepart, and returns all matches with their map ID\'s.'),
('lookup object',1,'[DEPRECATED]: use \".lookup gobject\" instead.\r\nSyntax: .go object #object_guid\r\nTeleport your character to gameobject with guid #object_guid'),
('lookup player',2,'Syntax: .lookup player $subcommand\nType .lookup player to see the list of possible subcommands or .help lookup player $subcommand to see info on subcommands.'),
('lookup player account',2,'Syntax: .lookup player account $account ($limit) \r\n\r\n Searchs players, which account username is $account with optional parametr $limit of results.'),
('lookup player email',2,'Syntax: .lookup player email $email ($limit) \r\n\r\n Searchs players, which account email is $email with optional parametr $limit of results.'),
('lookup player ip',2,'Syntax: .lookup player ip $ip ($limit) \r\n\r\n Searchs players, which account ast_ip is $ip with optional parametr $limit of results.'),
('lookup quest',1,'Syntax: .lookup quest $namepart\r\n\r\nLooks up a quest by $namepart, and returns all matches with their quest ID\'s.'),
('lookup skill',1,'Syntax: .lookup skill $$namepart\r\n\r\nLooks up a skill by $namepart, and returns all matches with their skill ID\'s.'),
('lookup spell',1,'Syntax: .lookup spell $namepart\r\n\r\nLooks up a spell by $namepart, and returns all matches with their spell ID\'s.'),
('lookup spell id',1,'Syntax: .lookup spell id #spellid\n\nLooks up a spell by #spellid, and returns the match with its spell name.'),
('lookup taxinode',1,'Syntax: .lookup taxinode $substring\r\n\r\nSearch and output all taxinodes with provide $substring in name.'),
('lookup teleport',1,'Syntax: .lookup teleport $substring\r\nSearch and output all .teleport command locations with provide $substring in name.'),
('lookup title',1,'Syntax: .lookup title $$namepart\r\n\r\nLooks up a title by $namepart, and returns all matches with their title ID\'s and index\'s.'),
('mailbox',1,'Syntax: .mailbox\r\n\r\nShow your mailbox content.'),
('maxskill',2,'Syntax: .maxskill\r\nSets all skills of the targeted player to their maximum values for its current level.'),
('mmap',3,'Syntax: Syntax: .mmaps $subcommand Type .mmaps to see the list of possible subcommands or .help mmaps $subcommand to see info on subcommands'),
('mmap loadedtiles',3,'Syntax: .mmap loadedtiles to show which tiles are currently loaded'),
('mmap loc',3,'Syntax: .mmap loc to print on which tile one is'),
('mmap path',3,'Syntax: .mmap path to calculate and show a path to current select unit'),
('mmap stats',3,'Syntax: .mmap stats to show information about current state of mmaps'),
('mmap testarea',3,'Syntax: .mmap testarea to calculate paths for all nearby npcs to player'),
('modify',2,'Syntax: .modify $subcommand\nType .modify to see the list of possible subcommands or .help modify $subcommand to see info on subcommands'),
('modify arenapoints',2,'Syntax: .modify arenapoints #value\r\nAdd $amount arena points to the selected player.'),
('modify bit',2,'Syntax: .modify bit #field #bit\r\n\r\nToggle the #bit bit of the #field field for the selected player. If no player is selected, modify your character.'),
('modify drunk',2,'Syntax: .modify drunk #value\r\n Set drunk level to #value (0..100). Value 0 remove drunk state, 100 is max drunked state.'),
('modify energy',2,'Syntax: .modify energy #energy\r\n\r\nModify the energy of the selected player. If no player is selected, modify your energy.'),
('modify faction',3,'Syntax: .modify faction #factionid #flagid #npcflagid #dynamicflagid\r\n\r\nModify the faction and flags of the selected creature. Without arguments, display the faction and flags of the selected creature.'),
('modify gender',2,'Syntax: .modify gender male/female\r\n\r\nChange gender of selected player.'),
('modify honor',2,'Syntax: .modify honor $amount\r\n\r\nAdd $amount honor points to the selected player.'),
('modify hp',2,'Syntax: .modify hp #newhp\r\n\r\nModify the hp of the selected player. If no player is selected, modify your hp.'),
('modify mana',2,'Syntax: .modify mana #newmana\r\n\r\nModify the mana of the selected player. If no player is selected, modify your mana.'),
('modify money',2,'Syntax: .modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.'),
('modify mount',2,'Syntax: .modify mount #id #speed\nSet CreatureDisplayID as #id and set speed to #speed value between 0.1 - 50.0'),
('modify phase',2,'Syntax: .modify phase #phasemask\r\n\r\nSelected character phasemask changed to #phasemask with related world vision update. Change active until in game phase changed, or GM-mode enable/disable, or re-login. Character pts pasemask update to same value.'),
('modify rage',2,'Syntax: .modify rage #newrage\r\n\r\nModify the rage of the selected player. If no player is selected, modify your rage.'),
('modify reputation',2,'Syntax: .modify reputation #repId (#repvalue | $rankname [#delta])\nSets the selected players reputation with faction #repId to #repvalue or to $reprank.\nIf the reputation rank name is provided, the resulting reputation will be the lowest reputation for that rank plus the delta amount, if specified.\nYou can use \'.pinfo rep\' to list all known reputation ids, or use \'.lookup faction $name\' to locate a specific faction id.'),
('modify runicpower',2,'Syntax: .modify runicpower #newrunicpower\r\n\r\nModify the runic power of the selected player. If no player is selected, modify your runic power.'),
('modify scale',2,'.modify scale #scale\nModify size of the selected player or creature to \"normal scale\"*rate. If no player or creature is selected, modify your size.\n#rate may range from 0.1 to 10.'),
('modify speed',2,'Syntax: .modify speed $speedtype #rate\r\n\r\nModify the running speed of the selected player to \"normal base run speed\"= 1. If no player is selected, modify your speed.\r\n\r\n$speedtypes may be fly, all, walk, backwalk, or swim.\r\n\r\n #rate may range from 0.1 to 50.'),
('modify speed all',2,'Syntax: .modify aspeed #rate\r\n\r\nModify all speeds -run,swim,run back,swim back- of the selected player to \"normalbase speed for this move type\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'),
('modify speed backwalk',2,'Syntax: .modify speed backwalk #rate\r\n\r\nModify the speed of the selected player while running backwards to \"normal walk back speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'),
('modify speed fly',2,'.modify speed fly #rate\nModify the flying speed of the selected player to \"normal flying speed\"*rate. If no player is selected, modify your speed.\n #rate may range from 0.1 to 50.'),
('modify speed swim',2,'Syntax: .modify speed swim #rate\r\n\r\nModify the swim speed of the selected player to \"normal swim speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'),
('modify speed walk',2,'Syntax: .modify speed bwalk #rate\r\n\r\nModify the speed of the selected player while running to \"normal walk speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 50.'),
('modify spell',4,'TODO'),
('modify standstate',2,'Syntax: .modify standstate #emoteid\r\n\r\nChange the emote of your character while standing to #emoteid.'),
('modify talentpoints',2,'Syntax: .modify talentpoints #amount\r\n\r\nSet free talent points for selected character or character\'s pet. It will be reset to default expected at next levelup/login/quest reward.'),
('morph',1,'Syntax: .morph $subcommand\r\nType .morph to see the list of possible subcommands or \".help morph\" to see info on subcommands'),
('morph mount',1,'Syntax: .morph mount #displayid - Change the selected target\'s mount\'s model ID to #displayid.'),
('morph reset',1,'Syntax: .morph reset - Doesn\'t use any parameters to reset the selected target\'s model'),
('morph target',1,'Syntax: .morph target #displayid - Change the selected target\'s current model id to #displayid.'),
('movegens',3,'Syntax: .movegens\r\n  Show movement generators stack for selected creature or player.'),
('mute',2,'Syntax: .mute [$playerName] $mutetime [$reason]\r\nDisible chat messaging for any character from account of character $playerName (or currently selected) at $mutetime time. Player can be offline.\n$mutetime: use a timestring like \"1d15h33s\".'),
('mutehistory',2,'Syntax: .mutehistory $accountName. Shows mute history for an account.'),
('nameannounce',2,'Syntax: .nameannounce $announcement.\nSend an announcement to all online players, displaying the name of the sender.'),
('neargrave',2,'Syntax: .neargrave [alliance|horde]\r\n\r\nFind nearest graveyard linked to zone (or only nearest from accepts alliance or horde faction ghosts).'),
('notify',2,'Syntax: .notify $MessageToBroadcast\r\n\r\nSend a global message to all players online in screen.'),
('npc',2,'Syntax: .npc $subcommand\nType .npc to see the list of possible subcommands or .help npc $subcommand to see info on subcommands'),
('npc add',3,'Syntax: .npc add #creatureid\r\n\r\nSpawn a creature by the given template id of #creatureid.'),
('npc add formation',3,'Syntax: .npc add formation $leader\nAdd selected creature to a leader\'s formation.'),
('npc add item',3,'Syntax: .npc add item #itemId <#maxcount><#incrtime><#extendedcost>r\r\n\r\nAdd item #itemid to item list of selected vendor. Also optionally set max count item in vendor item list and time to item count restoring and items ExtendedCost.'),
('npc add move',3,'Syntax: .npc add move #creature_guid [#waittime]\r\n\r\nAdd your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.'),
('npc add temp',3,'Syntax: .npc add temp\r\n\r\nAdds temporary NPC, not saved to database.'),
('npc delete',3,'Syntax: .npc delete [#guid]\r\n\r\nDelete creature with guid #guid (or the selected if no guid is provided)'),
('npc delete item',3,'Syntax: .npc delete item #itemId\r\n\r\nRemove item #itemid from item list of selected vendor.'),
('npc follow',2,'Syntax: .npc follow start\r\n\r\nSelected creature start follow you until death/fight/etc.'),
('npc follow stop',2,'Syntax: .npc follow stop\r\n\r\nSelected creature (non pet) stop follow you.'),
('npc guid',1,'Syntax: .npc guid\r\n\r\nDisplays GUID, faction, NPC flags, Entry ID, Model ID for selected creature.'),
('npc info',1,'Syntax: .npc info\r\n\r\nDisplay a list of details for the selected creature.\r\n\r\nThe list includes:\r\n- GUID, Faction, NPC flags, Entry ID, Model ID,\r\n- Level,\r\n- Health (current/maximum),\n\r\n\r\n- Field flags, dynamic flags, faction template, \r\n- Position information,\r\n- and the creature type, e.g. if the creature is a vendor.'),
('npc move',3,'Syntax: .npc move [#creature_guid]\r\n\r\nMove the targeted creature spawn point to your coordinates.'),
('npc near',2,'Syntax: .npc near #distance\nReturns all database creature spawns in a given distance.'),
('npc playemote',2,'Syntax: .npc playemote #emoteid\r\n\r\nMake the selected creature emote with an emote of id #emoteid.'),
('npc say',2,'Syntax: .npc say $message\nMake selected creature say specified message.'),
('npc set',3,'Syntax: .npc set $subcommand\nType .npc set to see the list of possible subcommands or .help npc set $subcommand to see info on subcommands.'),
('npc set allowmove',3,'Syntax: .npc set allowmove\r\n\r\nEnable or disable movement creatures in world. Not implemented.'),
('npc set data',3,'Syntax: .npc set data $field $data\nSets data for the selected creature. Used for testing Scripting'),
('npc set entry',3,'Syntax: .npc set entry $entry\nSwitch selected creature with another entry from creature_template. - New creature.id value not saved to DB.'),
('npc set faction original',3,'Syntax: .npc set faction original\r\n\r\nRevert the temporal faction of the selected creature.'),
('npc set faction permanent',3,'Syntax: .npc set faction permanent #factionid\r\n\r\nPermanently set the faction of the selected creature to #factionid.'),
('npc set faction temp',3,'Syntax: .npc set faction temp #factionid\r\n\r\nTemporarily set the faction of the selected creature to #factionid.'),
('npc set flag',3,'Syntax: .npc set flag #npcflag\r\n\r\nSet the NPC flags of creature template of the selected creature and selected creature to #npcflag. NPC flags will applied to all creatures of selected creature template after server restart or grid unload/load.'),
('npc set level',3,'Syntax: .npc set level #level\r\n\r\nChange the level of the selected creature to #level.\r\n\r\n#level may range from 1 to (CONFIG_MAX_PLAYER_LEVEL) + 3.'),
('npc set link',3,'Syntax: .npc set link $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'),
('npc set model',3,'Syntax: .npc set model #displayid\r\n\r\nChange the model id of the selected creature to #displayid.'),
('npc set movetype',3,'Syntax: .npc set movetype [#creature_guid] stay/random/way [NODEL]\r\n\r\nSet for creature pointed by #creature_guid (or selected if #creature_guid not provided) movement type and move it to respawn position (if creature alive). Any existing waypoints for creature will be removed from the database if you do not use NODEL. If the creature is dead then movement type will applied at creature respawn.\r\nMake sure you use NODEL, if you want to keep the waypoints.'),
('npc set phase',3,'Syntax: .npc set phase #phasemask\r\n\r\nSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB and persistent. In pet case change active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..'),
('npc set spawntime',3,'Syntax: .npc set spawntime #time\r\nAdjust spawntime of selected creature to #time.\n#time: use a timestring like \"10m30s\".'),
('npc set wanderdistance',3,'Syntax: .npc set wanderdistance #dist\r\n\r\nAdjust wander distance of selected creature to dist.'),
('npc tame',2,'Syntax: .npc tame\nCreates a player pet of the targeted creature.'),
('npc textemote',2,'Syntax: .npc textemote #emoteid\r\n\r\nMake the selected creature to do textemote with an emote of id #emoteid.'),
('npc whisper',2,'Syntax: .npc whisper #playername #text\r\nMake the selected npc whisper #text to  #playername.'),
('npc yell',2,'Syntax: .npc yell $message\nMake selected creature yell specified message.'),
('opendoor',1,'Syntax: .opendoor [$range]\nOpens the nearest door within the range provided (default 5.0yd)'),
('pdump',3,'Syntax: .pdump $subcommand\nType .pdump to see the list of possible subcommands or .help pdump $subcommand to see info on subcommands'),
('pdump load',3,'Syntax: .pdump load $filename $account [$newname] [$newguid]\r\nLoad character dump from dump file into character list of $account with saved or $newname, with saved (or first free) or $newguid guid.'),
('pdump write',3,'Syntax: .pdump write $filename $playerNameOrGUID\r\nWrite character dump with name/guid $playerNameOrGUID to file $filename.'),
('pet',2,'Syntax: .pet $subcommand\nType .pet to see the list of possible subcommands or .help pet $subcommand to see info on subcommands'),
('pet create',2,'Syntax: .pet create\r\n\r\nCreates a pet of the selected creature.'),
('pet learn',2,'Syntax: .pet learn\r\n\r\nLearn #spellid to pet.'),
('pet unlearn',2,'Syntax: .pet unlean\r\n\r\nunLearn #spellid to pet.'),
('pinfo',2,'Syntax: .pinfo [$player_name/#GUID]\r\n\r\nOutput account information and guild information for selected player or player find by $player_name or #GUID.'),
('playall',2,'Syntax: .playall #soundid\r\n\r\nPlayer a sound to whole server.'),
('player learn',2,'Syntax: .player learn #playername #spell [all].'),
('player unlearn',2,'Syntax: .player unlearn #playername #spell [all].'),
('possess',2,'Syntax: .possess\r\n\r\nPossesses indefinitely the selected creature.'),
('quest',2,'Syntax: .quest $subcommand\nType .quest to see the list of possible subcommands or .help quest $subcommand to see info on subcommands'),
('quest add',2,'Syntax: .quest add #quest_id\r\n\r\nAdd to character quest log quest #quest_id. Quest started from item can\'t be added by this command but correct .additem call provided in command output.'),
('quest complete',2,'Syntax: .quest complete #questid\r\nMark all quest objectives as completed for target character active quest. After this target character can go and get quest reward.'),
('quest remove',2,'Syntax: .quest remove #quest_id\r\n\r\nSet quest #quest_id state to not completed and not active (and remove from active quest list) for selected player.'),
('quest reward',2,'Syntax: .quest reward #questId\n\nGrants quest reward to selected player and removes quest from his log (quest must be in completed state).'),
('recall',2,'Syntax: .recall [$playername]\r\n\r\nTeleport $playername or selected player to the place where he has been before last use of a teleportation command. If no $playername is entered and no player is selected, it will teleport you.'),
('reload',3,'Syntax: .reload $subcommand\nType .reload to see the list of possible subcommands or .help reload $subcommand to see info on subcommands'),
('reload achievement_criteria_data',3,'Syntax: .reload achievement_criteria_data\nReload achievement_criteria_data table.'),
('reload achievement_reward',3,'Syntax: .reload achievement_reward\nReload achievement_reward table.'),
('reload achievement_reward_locale',3,'Syntax: .reload achievement_reward_locale\nReload achievement_reward_locale table.'),
('reload acore_string',3,'Syntax: .reload acore_string\nReload acore_string table.'),
('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.'),
('reload all achievement',3,'Syntax: .reload all achievement\r\n\r\nReload achievement_reward, achievement_criteria_data tables.'),
('reload all area',3,'Syntax: .reload all area\r\n\r\nReload areatrigger_teleport, areatrigger_tavern, game_graveyard_zone tables.'),
('reload all gossips',3,'Syntax: .reload all gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, points_of_interest tables.'),
('reload all item',3,'Syntax: .reload all item\nReload page_text, item_enchantment_table tables.'),
('reload all locales',3,'Syntax: .reload all locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'),
('reload all loot',3,'Syntax: .reload all loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.'),
('reload all npc',3,'Syntax: .reload all npc\nReload npc_option, npc_trainer, npc vendor, points of interest tables.'),
('reload all quest',3,'Syntax: .reload all quest\r\n\r\nReload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.'),
('reload all scripts',3,'Syntax: .reload all scripts\nReload gameobject_scripts, event_scripts, quest_end_scripts, quest_start_scripts, spell_scripts, db_script_string, waypoint_scripts tables.'),
('reload all spell',3,'Syntax: .reload all spell\r\n\r\nReload all `spell_*` tables with reload support added and that can be _safe_ reloaded.'),
('reload areatrigger_involvedrelation',3,'Syntax: .reload areatrigger_involvedrelation\nReload areatrigger_involvedrelation table.'),
('reload areatrigger_tavern',3,'Syntax: .reload areatrigger_tavern\nReload areatrigger_tavern table.'),
('reload areatrigger_teleport',3,'Syntax: .reload areatrigger_teleport\nReload areatrigger_teleport table.'),
('reload auctions',3,'Syntax: .reload auctions\nReload dynamic data tables from the database.'),
('reload autobroadcast',3,'Syntax: .reload autobroadcast\nReload autobroadcast table.'),
('reload battleground_template',3,'Syntax: .reload battleground_template\r\nReload Battleground Templates.'),
('reload broadcast_text',3,'Syntax: .reload broadcast_text\r\n\r\nReload broadcast_text table.'),
('reload command',3,'Syntax: .reload command\nReload command table.'),
('reload conditions',3,'Reload conditions table.'),
('reload config',3,'Syntax: .reload config\r\n\r\nReload config settings (by default stored in worldserver.conf). Not all settings can be change at reload: some new setting values will be ignored until restart, some values will applied with delay or only to new objects/maps, some values will explicitly rejected to change at reload.'),
('reload creature_linked_respawn',3,'Syntax: .reload creature_linked_respawn\r\nReload creature_linked_respawn table.'),
('reload creature_loot_template',3,'Syntax: .reload creature_loot_template\nReload creature_loot_template table.'),
('reload creature_movement_override',3,'Syntax: .reload creature_movement_override\nReload creature_movement_override table.'),
('reload creature_onkill_reputation',3,'Syntax: .reload creature_onkill_reputation\r\nReload creature_onkill_reputation table.'),
('reload creature_questender',3,'Syntax: .reload creature_questender\nReload creature_questender table.'),
('reload creature_queststarter',3,'Syntax: .reload creature_queststarter\nReload creature_queststarter table.'),
('reload creature_template',3,'Syntax: .reload creature_template $entry\r\nReload the specified creature\'s template.'),
('reload creature_template_locale',3,'Syntax: .reload creature_template_locale\nReload creature_template_locale table.'),
('reload creature_text',3,'Syntax: .reload creature_text\r\nReload creature_text table.'),
('reload creature_text_locale',3,'Syntax: .reload creature_text_locale\nReload creature_text_locale Table.'),
('reload disables',3,'Syntax: .reload disables\r\nReload disables table.'),
('reload disenchant_loot_template',3,'Syntax: .reload disenchant_loot_template\nReload disenchant_loot_template table.'),
('reload dungeon_access_requirements',3,'Syntax: .reload dungeon_access_requirements\r Reload dungeon_access_requirements table.'),
('reload dungeon_access_template',3,'Syntax: .reload dungeon_access_template\r Reload dungeon_access_template table.'),
('reload event_scripts',3,'Syntax: .reload event_scripts\nReload event_scripts table.'),
('reload fishing_loot_template',3,'Syntax: .reload fishing_loot_template\nReload fishing_loot_template table.'),
('reload game_event_npc_vendor',3,'Syntax: .reload game_event_npc_vendor\r Reload game_event_npc_vendor table.'),
('reload game_graveyard',3,'Syntax: .reload game_graveyard\nReload game_graveyard table.'),
('reload game_tele',3,'Syntax: .reload game_tele\nReload game_tele table.'),
('reload gameobject_loot_template',3,'Syntax: .reload gameobject_loot_template\nReload gameobject_loot_template table.'),
('reload gameobject_questender',3,'Syntax: .reload gameobject_questender\\nReload gameobject_questender table.'),
('reload gameobject_queststarter',3,'Syntax: .reload gameobject_queststarter\nReload gameobject_queststarter table.'),
('reload gameobject_template_locale',3,'Syntax: .reload gameobject_template_locale\nReload gameobject_template_locale table.'),
('reload gm_tickets',3,'Syntax: .reload gm_tickets\nReload gm_tickets table.'),
('reload gossip_menu',3,'Syntax: .reload gossip_menu\nReload gossip_menu table.'),
('reload gossip_menu_option',3,'Syntax: .reload gossip_menu_option\nReload gossip_menu_option table.'),
('reload gossip_menu_option_locale',3,'Syntax: .reload gossip_menu_option_locale\nReload gossip_menu_option_locale table.'),
('reload graveyard_zone',3,'Syntax: .reload graveyard_zone'),
('reload item_enchantment_template',3,'Syntax: .reload item_enchantment_template\nReload item_enchantment_template table.'),
('reload item_loot_template',3,'Syntax: .reload item_loot_template\nReload item_loot_template table.'),
('reload item_set_name_locale',3,'Syntax: .reload item_set_name_locale\nReload item_set_name_locale table.'),
('reload item_set_names',3,'Syntax: .reload item_set_names\nReload item_set_names table.'),
('reload item_template_locale',3,'Syntax: .reload item_template_locale\nReload item_template_locale table.'),
('reload lfg_dungeon_rewards',3,'Syntax: .reload lfg_dungeon_rewards\nReload lfg_dungeon_rewards table.'),
('reload mail_level_reward',3,'Syntax: .reload mail_level_reward\nReload mail_level_reward table.'),
('reload mail_loot_template',3,'Syntax: .reload quest_mail_loot_template\nReload quest_mail_loot_template table.'),
('reload mail_server_template',3,'Syntax: .reload mail_server_template\nReload server_mail_template table.'),
('reload milling_loot_template',3,'Syntax: .reload milling_loot_template\nReload milling_loot_template table.'),
('reload module_string',3,'Syntax: .reload module_string'),
('reload motd',3,'Syntax: .reload motd\nReload motd table.'),
('reload npc_spellclick_spells',3,'Syntax: .reload npc_spellclick_spells\nReload npc_spellclick_spells table.'),
('reload npc_text_locale',3,'Syntax: .reload npc_text_locale\nReload npc_text_locale table.'),
('reload npc_trainer',3,'Syntax: .reload npc_trainer\nReload npc_trainer table.'),
('reload npc_vendor',3,'Syntax: .reload npc_vendor\nReload npc_vendor table.'),
('reload page_text',3,'Syntax: .reload page_text\r\nReload page_text table.\nYou need to delete your client cache or change the cache number in the config in order for your players see the changes.'),
('reload page_text_locale',3,'Syntax: .reload page_text_locale\r\nReload page_text_locale table.\nYou need to delete your client cache or change the cache number in config in order for your players see the changes.'),
('reload pickpocketing_loot_template',3,'Syntax: .reload pickpocketing_loot_template\nReload pickpocketing_loot_template table.'),
('reload player_loot_template',3,'Syntax: .reload player_loot_template\nReload player_loot_template table.'),
('reload points_of_interest',3,'Syntax: .reload points_of_interest\nReload points_of_interest table.'),
('reload points_of_interest_locale',3,'Syntax: .reload points_of_interest_locale\nReload points_of_interest_locale table.'),
('reload prospecting_loot_template',3,'Syntax: .reload prospecting_loot_template\nReload prospecting_loot_template table.'),
('reload quest_greeting',3,'Syntax: .reload quest_greeting\nReload quest_greeting table.'),
('reload quest_poi',3,'Syntax: .reload quest_poi\nReload quest_poi table.'),
('reload quest_template',3,'Syntax: .reload quest_template\nReload quest_template table.'),
('reload quest_template_locale',3,'Syntax: .reload quest_template_locale\nReload quest_template_locale table.'),
('reload reference_loot_template',3,'Syntax: .reload reference_loot_template\nReload reference_loot_template table.'),
('reload reserved_name',3,'Syntax: .reload reserved_name\nReload reserved_name table.'),
('reload skill_discovery_template',3,'Syntax: .reload skill_discovery_template\nReload skill_discovery_template table.'),
('reload skill_extra_item_template',3,'Syntax: .reload skill_extra_item_template\nReload skill_extra_item_template table.'),
('reload skill_fishing_base_level',3,'Syntax: .reload skill_fishing_base_level\nReload skill_fishing_base_level table.'),
('reload skinning_loot_template',3,'Syntax: .reload skinning_loot_template\nReload skinning_loot_template table.'),
('reload smart_scripts',3,'Syntax: .reload smart_scripts\nReload smart_scripts table.'),
('reload spell_area',3,'Syntax: .reload spell_area\nReload spell_area table.'),
('reload spell_bonus_data',3,'Syntax: .reload spell_bonus_data\nReload spell_bonus_data table.'),
('reload spell_group',3,'Syntax: .reload spell_group\nReload spell_group table.'),
('reload spell_group_stack_rules',3,'Syntax: .reload spell_group\nReload spell_group_stack_rules table.'),
('reload spell_linked_spell',3,'Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.'),
('reload spell_loot_template',3,'Syntax: .reload spell_loot_template\nReload spell_loot_template table.'),
('reload spell_pet_auras',3,'Syntax: .reload spell_pet_auras\nReload spell_pet_auras table.'),
('reload spell_proc',3,'Syntax: .reload spell_proc\nReload spell_proc table.'),
('reload spell_proc_event',3,'Syntax: .reload spell_proc_event\nReload spell_proc_event table.'),
('reload spell_required',3,'Syntax: .reload spell_required\nReload spell_required table.'),
('reload spell_scripts',3,'Syntax: .reload spell_scripts\nReload spell_scripts table.'),
('reload spell_target_position',3,'Syntax: .reload spell_target_position\nReload spell_target_position table.'),
('reload spell_threats',3,'Syntax: .reload spell_threats\nReload spell_threats table.'),
('reload vehicle_accessory',3,'Syntax: .reload vehicle_accessory\n\nReloads GUID-based vehicle accessory definitions from the database.'),
('reload vehicle_template_accessory',3,'Syntax: .reload vehicle_template_accessory\n\nReloads entry-based vehicle accessory definitions from the database.'),
('reload waypoint_data',3,'Syntax: .reload waypoint_data will reload waypoint_data table.'),
('reload waypoint_scripts',3,'Syntax: .reload waypoint_scripts\nReload waypoint_scripts table.'),
('reset',3,'Syntax: .reset $subcommand\nType .reset to see the list of possible subcommands or .help reset $subcommand to see info on subcommands'),
('reset achievements',4,'Syntax: .reset achievements [$playername]\r\n\r\nReset achievements data for selected or named (online or offline) character. Achievements for persistance progress data like completed quests/etc re-filled at reset. Achievements for events like kills/casts/etc will lost.'),
('reset all',4,'Syntax: .reset all spells\r\n\r\nSyntax: .reset all talents\r\n\r\nRequest reset spells or talents (including talents for all character\'s pets if any) at next login each existed character.'),
('reset honor',3,'Syntax: .reset honor [Playername]\r\n  Reset all honor data for targeted character.'),
('reset items',3,'Syntax : .reset items equipped|bags|bank|keyring|currency|vendor_buyback|all|allbags #playername\nDelete items in the player inventory (equipped, bank, bags etc...) depending on the chosen option.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items all',3,'Syntax : .reset items all #playername\nDelete all items in the selected player\'s inventory (equipped, in bags, in bank, in keyring, in currency list and in vendor buy back tab).\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items allbags',3,'Syntax : .reset items allbags #playername\nDelete all items in the selected player\'s inventory (equipped, in bags, in bank, in keyring, in currency list and in vendor buy back tab)\nThis command also deletes the bags.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items bags',3,'Syntax : .reset items bags #playername\nDelete all items in the selected player\'s bags.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items bank',3,'Syntax : .reset items bank #playername\nDelete all items in the selected player\'s bank.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items currency',3,'Syntax : .reset items currency #playername\nDelete all items in the selected player\'s currencies list.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items equipped',3,'Syntax : .reset items equipped #playername\nDelete all items equipped on the target player.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items keyring',3,'Syntax : .reset items keyring #playername\nDelete all items in the selected player\'s keyring.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset items vendor_buyback',3,'Syntax : .reset items vendor_buyback #playername\nDelete all items in the selected player\'s vendor buyback tab.\n#playername : Optional target player name (if player is online only). If not provided the command will execute on the selected target player.'),
('reset level',3,'Syntax: .reset level [Playername]\r\n  Reset level to 1 including reset stats and talents.  Equipped items with greater level requirement can be lost.'),
('reset spells',3,'Syntax: .reset spells [Playername]\r\n  Removes all non-original spells from spellbook.\r\n. Playername can be name of offline character.'),
('reset stats',3,'Syntax: .reset stats [Playername]\r\n  Resets(recalculate) all stats of the targeted player to their original VALUESat current level.'),
('reset talents',3,'Syntax: .reset talents [Playername]\r\n  Removes all talents of the targeted player or pet or named player. Playername can be name of offline character. With player talents also will be reset talents for all character\'s pets if any.'),
('respawn',2,'Syntax: .respawn\nRespawn the selected unit without waiting respawn time expiration.'),
('respawn all',2,'Syntax: .respawn all\nRespawn all nearest creatures and GO without waiting respawn time expiration.'),
('revive',2,'Syntax: .revive\r\n\r\nRevive the selected player. If no player is selected, it will revive you.'),
('save',0,'Syntax: .save\r\n\r\nSaves your character.'),
('saveall',2,'Syntax: .saveall\r\n\r\nSave all characters in game.'),
('send',2,'Syntax: send $subcommand\n Type .send to see a list of possible subcommands\n or .help send $subcommand to see info on the subcommand.'),
('send items',2,'Syntax: .send items #playername \"#subject\" \"#text\" itemid1[:count1] itemid2[:count2] ... itemidN[:countN]\r\n\r\nSend a mail to a player. Subject and mail text must be in \"\". If for itemid not provided related count values then expected 1, if count > max items in stack then items will be send in required amount stacks. All stacks amount in mail limited to 12.'),
('send mail',2,'Syntax: .send mail #playername \"#subject\" \"#text\"\r\n\r\nSend a mail to a player. Subject and mail text must be in \"\".'),
('send message',3,'Syntax: .send message $playername $message\r\n\r\nSend screen message to player from ADMINISTRATOR.'),
('send money',2,'Syntax: .send money #playername \"#subject\" \"#text\" #money\r\n\r\nSend mail with money to a player. Subject and mail text must be in \"\".'),
('server',3,'Syntax: .server $subcommand\nType .server to see the list of possible subcommands or .help server $subcommand to see info on subcommands'),
('server corpses',2,'Syntax: .server corpses\r\n\r\nTriggering corpses expire check in world.'),
('server debug',3,'Syntax: .server debug\r\nShows detailed information about the server setup, useful when reporting a bug.'),
('server exit',4,'Syntax: .server exit\r\n\r\nTerminate AzerothCore NOW. Exit code 0.'),
('server idlerestart',4,'Syntax: .server idlerestart #delay\r\nRestart the server after #delay if no active connections are present (no players). Use #exist_code or 2 as program exist code.\n#delay: use a timestring like \"1h15m30s\".'),
('server idlerestart cancel',3,'Syntax: .server idlerestart cancel\r\n\r\nCancel the restart/shutdown timer if any.'),
('server idleshutdown',4,'Syntax: .server idleshutdown #delay [#exist_code]\r\nShut the server down after #delay if no active connections are present (no players). Use #exist_code or 0 as program exist code.\n#delay: use a timestring like \"1h15m30s\".'),
('server idleshutdown cancel',3,'Syntax: .server idleshutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.'),
('server info',0,'Syntax: .server info\r\n\r\nDisplay server version and the number of connected players.'),
('server motd',0,'Syntax: .server motd\r\n\r\nShow server Message of the day.'),
('server restart',3,'Syntax: .server restart #delay\r\nRestart the server after #delay. Use #exist_code or 2 as program exist code.\n#delay: use a timestring like \"1h15m30s\".'),
('server restart cancel',3,'Syntax: .server restart cancel\r\n\r\nCancel the restart/shutdown timer if any.'),
('server set closed',4,'Syntax: server set closed on/off\r\n\r\nSets whether the world accepts new client connectsions.'),
('server set loglevel',4,'Syntax: .server set loglevel $facility $name $loglevel. $facility can take the values: appender (a) or logger (l). $loglevel can take the values: disabled (0),\n trace (1),\n debug (2),\n info (3),\n warn (4),\n error (5) or fatal (6)'),
('server set motd',3,'Syntax: .server set motd Optional($realmId) Optional($locale) $MOTD\r \r Set server Message of the day for the specified $realmId.\r If $realmId is not provided it will update for the current realm. \r Use $realmId -1 to set motd for all realms. If $locale is not provided enUS will be used.'),
('server shutdown',3,'Syntax: .server shutdown #delay [#exit_code]\r\nShut the server down after #delay. Use #exit_code or 0 as program exit code.\n#delay: use a timestring like \"1h15m30s\".'),
('server shutdown cancel',3,'Syntax: .server shutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.'),
('setskill',2,'Syntax: .setskill #skill #level [#max]\r\n\r\nSet a skill of id #skill with a current skill value of #level and a maximum value of #max (or equal current maximum if not provide) for the selected character. If no character is selected, you learn the skill.'),
('settings',1,'Syntax: .settings $subcommand\nType .setting to see the list of all available commands.'),
('settings announcer',1,'Syntax: .settings announcer <type> <on/off>.\nDisables receiving announcements. Valid announcement types are: \'autobroadcast\', \'arena\' and \'bg\''),
('showarea',2,'Syntax: .showarea #areaid\r\n\r\nReveal the area of #areaid to the selected character. If no character is selected, reveal this area to you.'),
('skirmish',3,'Syntax: .skirmish [arena] [XvX] [Nick1] [Nick2] ... [NickN]\n[arena] can be \"all\" or comma-separated list of possible arenas (NA, BE, RL, DS, RV).\n[XvX] can be 1v1, 2v2, 3v3, 5v5. After [XvX] specify enough nicknames for that mode.'),
('spect',0,'Syntax: .spect $subcommand\nType .spect to see the list of possible subcommands or .help spect $subcommand to see info on subcommands.'),
('spect leave',0,'Syntax: .spect leave\nLeave an arena you are spectating.'),
('spect reset',0,'Syntax: .spect reset\nReset various values related to spectating.'),
('spect spectate',0,'Syntax: .spect spectate #name\nBegin spectating the given player.'),
('spect version',0,'Syntax: .spect version #version\nVerify addon version for arena spectating.'),
('spect watch',0,'Syntax: .spect watch #name\nBegin watching the given player.'),
('string',2,'Syntax: .string #id [#locale]'),
('summon',2,'Syntax: .summon [$charactername]\r\n\r\nTeleport the given character to you. Character can be offline.'),
('teleport',1,'Syntax: .teleport #location\r\nTeleport player to a given location.'),
('teleport add',3,'Syntax: .teleport add $name\r\nAdd current your position to .teleport command target locations list with name $name.'),
('teleport del',3,'Syntax: .teleport del $name\r\nRemove location with name $name for .teleport command locations list.'),
('teleport group',2,'Syntax: .teleport group#location\r\nTeleport a selected player and his group members to a given location.'),
('teleport name',2,'Syntax: .teleport name [#playername] #location\r\nTeleport the given character to a given location. Character can be offline.\r\nTo teleport to homebind, set #location to \"$home\" (without quotes).'),
('teleport name npc guid',2,'Syntax: .teleport name id #playername #creatureSpawnId\nTeleport the given character to creature with spawn id #creatureSpawnId. Character can be offline.'),
('teleport name npc id',2,'Syntax: .teleport name id #playername #creatureId\nTeleport the given character to first found creature with id #creatureId. Character can be offline.'),
('teleport name npc name',2,'Syntax: .teleport name id #playername #creatureName\nTeleport the given character to first found creature with name (must match exactly) #creatureName. Character can be offline.'),
('ticket',2,'Syntax: .ticket $subcommand\nType .ticket to see the list of possible subcommands or .help ticket $subcommand to see info on subcommands'),
('ticket assign',2,'Usage: .ticket assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.'),
('ticket close',2,'Usage: .ticket close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'),
('ticket closedlist',2,'Displays a list of closed GM tickets.'),
('ticket comment',2,'Usage: .ticket comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'),
('ticket complete',2,'Syntax: .ticket complete #ticketID\nMark a ticket of the given ID as complete.'),
('ticket delete',3,'Usage: .ticket delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'),
('ticket escalate',2,'Syntax: .ticket escalate #ticketID\nAdd a ticket of the given ID to the escalation queue.'),
('ticket escalatedlist',2,'Syntax: .ticket escalatedlist\nReturn all open tickets in the escalation queue.'),
('ticket list',2,'Displays a list of open GM tickets.'),
('ticket onlinelist',2,'Displays a list of open GM tickets whose owner is online.'),
('ticket reset',4,'Syntax: .ticket reset\nRemoves all closed tickets and resets the counter, if no pending open tickets are existing.'),
('ticket response',2,'Syntax: .ticket response $subcommand\nType .ticket response to see the list of possible subcommands or .help ticket response $subcommand to see info on subcommands.'),
('ticket response append',2,'Add a response\n\nSyntax: ticket response append $ticketId $response'),
('ticket response appendln',2,'Add a response to a new line.\n\nSyntax: ticket response appendln $ticketId $response'),
('ticket response delete',2,'Delete a ticket response\n\nSyntax: ticket response delete $ticketId'),
('ticket response show',2,'Show a ticket response\n\nSyntax: ticket response show $ticketId'),
('ticket togglesystem',3,'Syntax: .ticket togglesystem\nToggle whether tickets are allowed or disallowed.'),
('ticket unassign',2,'Usage: .ticket unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'),
('ticket viewid',2,'Usage: .ticket viewid $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'),
('ticket viewname',2,'Usage: .ticket viewname $creatorname. \r\nReturns details about specified ticket. Ticket must be open and not deleted.'),
('titles',2,'Syntax: .titles $subcommand\nType .titles to see the list of possible subcommands or .help titles $subcommand to see info on subcommands.'),
('titles add',2,'Syntax: .titles add #title\r\nAdd title #title (id or shift-link) to known titles list for selected player.'),
('titles current',2,'Syntax: .titles current #title\r\nSet title #title (id or shift-link) as current selected titl for selected player. If title not in known title list for player then it will be added to list.'),
('titles remove',2,'Syntax: .titles remove #title\r\nRemove title #title (id or shift-link) from known titles list for selected player.'),
('titles set',2,'Syntax: .titles set $subcommand\nType .titles set to see the list of possible subcommands or .help titles set $subcommand to see info on subcommands.'),
('titles set mask',2,'Syntax: .titles set mask #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'),
('unaura',2,'Syntax: .unaura #spellid\r\n\r\nRemove aura due to spell #spellid from the selected Unit.'),
('unban',3,'Syntax: .unban $subcommand\nType .unban to see the list of possible subcommands or .help unban $subcommand to see info on subcommands'),
('unban account',3,'Syntax: .unban account $Name\r\nUnban accounts for account name pattern.'),
('unban character',3,'Syntax: .unban character $Name\r\nUnban accounts for character name pattern.'),
('unban ip',3,'Syntax : .unban ip $Ip\r\nUnban accounts for IP pattern.'),
('unban playeraccount',3,'Syntax: .unban playeraccount #name\nUnban accounts for character name pattern.'),
('unbindsight',3,'Syntax: .unbindsight\r\n\r\nRemoves bound vision. Cannot be used while currently possessing a target.'),
('unfreeze',2,'Syntax: .unfreeze (#player)\r\n\"Unfreezes\" #player and enables his chat again. When using this without #name it will unfreeze your target.'),
('unlearn',2,'Syntax: .unlearn #spell [all]\r\n\r\nUnlearn for selected player a spell #spell.  If \'all\' provided then all ranks unlearned.'),
('unmute',2,'Syntax: .unmute [$playerName]\r\n\r\nRestore chat messaging for any character from account of character $playerName (or selected). Character can be ofline.'),
('unpossess',2,'Syntax: .unpossess\r\n\r\nIf you are possessed, unpossesses yourself; otherwise unpossesses current possessed target.'),
('unstuck',2,'Syntax: .unstuck $playername [inn/graveyard/startzone]\n\nTeleports specified player to specified location. Default location is player\'s current hearth location.'),
('wchange',3,'Syntax: .wchange #weathertype #grade\nSet current weather to #weathertype with an intensity of #grade.\n\n#weathertype can be 0 for fine, 1 for rain, 2 for snow, 3 for storm, 86 for thunders, 90 for blackrain.\n#grade is a float value from 0.0 (disabled) to 1.0 (maximum intensity).'),
('whispers',1,'Syntax: .whispers on|off\r\nEnable/disable accepting whispers by GM from players. By default use trinityd.conf setting.'),
('worldstate scourgeinvasion battleswon',3,'Syntax: .worldstate scourgeinvasion battleswon <value>\nAdjusts the Scourge Invasion battles won count by <value> (can be negative).'),
('worldstate scourgeinvasion show',3,'Syntax: .worldstate scourgeinvasion show\nDisplays the current status of the Scourge Invasion.'),
('worldstate scourgeinvasion startzone',3,'Syntax: .worldstate scourgeinvasion startzone <id>\nStarts a Scourge Invasion event in the zone specified by <id>.\nValid zone IDs: 0-7.'),
('worldstate scourgeinvasion state',3,'Syntax: .worldstate scourgeinvasion state <value>\nSets the Scourge Invasion state.\nValid values:\n0: Disabled\n1: Enabled'),
('worldstate sunsreach gate',3,'Syntax: .worldstate sunsreach gate <gate>.\nSets the phase of Sunwell Plateau Gate.\nValid values are:\n0: All Gates Closed\n1: Gate 1 Agamath Open\n2: Gate 2 Rohendar Open\n3: Gate 3 Archonisus Open.'),
('worldstate sunsreach phase',3,'Syntax: .worldstate sunsreach phase <value>.\nSets the phase of Sun\'s Reach.\nValid values are:\n0: Staging Area\n1: Sanctum\n2: Armory\n3: Harbor.'),
('worldstate sunsreach subphase',3,'Syntax: .worldstate sunsreach subphase <mask>.\nSets the subphase mask of Sun\'s Reach.\nValid values are:\n1: Portal\n2: Anvil\n4: Alchemy Lab\n8: Monument\n15: All.'),
('wp',3,'Syntax: wp $subcommand\n Type .wp to see a list of possible subcommands\n or .help wp $subcommand to see info on the subcommand.'),
('wp add',3,'Syntax: .wp add\r\n\r\nAdd a waypoint for the selected creature at your current position.'),
('wp event',3,'Syntax: .wp event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'),
('wp load',3,'Syntax: .wp load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'),
('wp modify',3,'Syntax: '),
('wp reload',3,'Syntax: .wp reload $pathid\nLoad path changes ingame - IMPORTANT: must be applied first for new paths before .wp load #pathid '),
('wp show',3,'Syntax: .wp show $option\nOptions:\non $pathid (or selected creature with loaded path) - Show path\noff - Hide path\ninfo $selected_waypoint - Show info for selected waypoint.'),
('wp unload',3,'Syntax: .wp unload\nUnload path for selected creature.'),
('wpgps',3,'Syntax: .wpgps\r\nOutput current position to sql developer log as partial SQL query to be used in pathing (formated for waypoint_data table).\r\nUse .wpgps sai for waypoint (SAI) table format.');
/*!40000 ALTER TABLE `command` ENABLE KEYS */;
UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-07-19 12:08:44