commands.sql

-- lvl 0: Player
-- lvl 1: GM T0 (Triager)
-- lvl 2: GM T1 (Entertainer/Moderator)
-- lvl 3: GM T2 (Protector)
-- lvl 4: Administrator

--
-- Player
--
UPDATE `command`
SET `security` = 0
WHERE `name` IN (
    'account',
    'account 2fa',
    'account 2fa remove',
    'account 2fa setup',
    'account lock country',
    'account lock ip',
    'account password',
    'commands',
    'debug',
    'debug hostile', -- Matches live
    'gobject',
    'gobject near', -- Matches live
    'gobject target', -- Matches live
    'gps',
    'help',
    'npc',
    'npc info', -- Matches live
    'npc near',
    'save',
    'server',
    'server info',
    'server motd',
    'settings', -- Matches live
    'settings announcer', -- Matches live
    'spect',
    'spect leave',
    'spect reset',
    'spect spectate',
    'spect version',
    'spect watch'
);

--
-- GM T0 (Triager)
--
UPDATE `command`
SET `security` = 1
WHERE `name` IN (
    'account addon',
    'appear',
    'arena info',
    'arena lookup',
    'ban', -- Matches live
    'ban account', -- Matches live
    'bindsight',
    'cache',
    'cache info',
    'character',
    'character check bag',
    'character check bank',
    'character check profession',
    'character rename', -- Matches live
    'character reputation',
    'character titles',
    'cheat',
    'cheat casttime',
    'cheat cooldown',
    'cheat explore',
    'cheat god',
    'cheat power',
    'cheat taxi',
    'cheat waterwalk',
    'combatstop',
    'cooldown',
    'dismount',
    'distance',
    'event',
    'event activelist',
    'gear repair',
    'gear stats',
    'gm', -- Matches live
    'gm chat', -- Matches live
    'gm fly', -- Matches live
    'gm ingame', -- Matches live
    'gm visible', -- Matches live
    'gmannounce', -- Matches live
    'gmnameannounce', -- Matches live
    'gmnotify', -- Matches live
    'go',
    'go creature',
    'go creature id',
    'go creature name',
    'go graveyard',
    'go grid',
    'go quest',
    'go taxinode',
    'go trigger',
    'go xyz',
    'go zonexy',
    'gobject activate', -- Matches live
    'gobject info',
    'gps',
    'guild info',
    'instance',
    'instance getbossstate',
    'instance listbinds',
    'instance unbind',
    'inventory',
    'inventory count',
    'item move',
    'learn',
    'learn all',
    'learn all crafts',
    'learn all default',
    'learn all gm',
    'learn all lang',
    'learn all my',
    'learn all my class',
    'learn all my pettalents',
    'learn all my spells',
    'learn all my talents',
    'learn all recipes',
    'lfg group',
    'lfg player',
    'lfg queue',
    'list',
    'list auras',
    'list creature',
    'list item',
    'list object',
    'lookup',
    'lookup area',
    'lookup creature',
    'lookup event',
    'lookup faction',
    'lookup gobject',
    'lookup item',
    'lookup item set',
    'lookup map',
    'lookup object',
    'lookup quest',
    'lookup skill',
    'lookup spell',
    'lookup spell id',
    'lookup taxinode',
    'lookup teleport',
    'lookup title',
    'mailbox',
    'maxskill',
    'modify',
    'modify drunk',
    'modify energy',
    'modify hp',
    'modify mana',
    'modify mount',
    'modify phase',
    'modify rage',
    'modify reputation',
    'modify runicpower',
    'modify scale',
    'modify speed', -- Matches live
    'modify speed all',
    'modify speed backwalk',
    'modify speed fly',
    'modify speed swim',
    'modify speed walk',
    'modify standstate',
    'modify talentpoints',
    'morph',
    'morph mount',
    'morph reset',
    'mute', -- Matches live
    'mutehistory', -- Matches live
    'neargrave',
    'npc guid',
    'npc near',
    'npc playemote',
    'npc say',
    'npc textemote',
    'npc whisper',
    'npc yell',
    'pet',
    'pet create',
    'pet learn',
    'pet unlearn',
    'pinfo', -- Matches live
    'player learn',
    'player unlearn',
    'possess',
    'quest',
    'quest add',
    'quest complete',
    'quest remove',
    'quest reward',
    'recall',
    'respawn',
    'revive',
    'server debug',
    'setskill',
    'showarea',
    'summon', -- Matches live
    'teleport',
    'titles',
    'titles add',
    'titles current',
    'titles remove',
    'titles set',
    'titles set mask',
    'unaura',
    'unbindsight',
    'unlearn',
    'unpossess',
    'whispers'
);

--
-- GM T1 (Entertainer/Moderator)
--
UPDATE `command`
SET `security` = 2
WHERE `name` IN (
    'achievement',
    'achievement add',
    'achievement checkall',
    'arena rename',
    'bags',
    'bags clear',
    'ban character',
    'ban ip',
    'ban playeraccount',
    'baninfo',
    'baninfo account',
    'baninfo character',
    'baninfo ip',
    'banlist',
    'banlist account',
    'banlist character',
    'banlist ip',
    'cache delete',
    'cache refresh',
    'cast',
    'cast back',
    'cast dest',
    'cast dist',
    'cast self',
    'cast target',
    'character changefaction',
    'character changerace',
    'character customize',
    'commentator',
    'debug play', -- Matches live
    'debug play cinematic', -- Matches live
    'debug play movie', -- Matches live
    'debug play sound', -- Matches live
    'deserter bg add',
    'deserter bg remove',
    'deserter instance add',
    'deserter instance remove',
    'dev',
    'die',
    'event start',
    'event stop',
    'freeze',
    'go ticket',
    'gobject add',
    'gobject add temp',
    'gobject delete',
    'gobject move',
    'gobject respawn',
    'gobject set',
    'gobject set phase',
    'gobject set state',
    'gobject turn',
    'group',
    'group disband',
    'group join',
    'group leader',
    'group list',
    'group remove',
    'groupsummon',
    'guid',
    'guild',
    'guild create',
    'guild delete',
    'guild invite',
    'guild rank',
    'guild rename',
    'guild uninvite',
    'hidearea',
    'instance setbossstate',
    'item refund',
    'item restore',
    'item restore list',
    'kick',
    'levelup', -- Matches live
    'lfg', -- Matches live
    'lfg options',
    'lookup player',
    'lookup player account',
    'lookup player email',
    'lookup player ip',
    'modify bit',
    'modify gender',
    'morph target',
    'movegens',
    'npc add',
    'npc add formation',
    'npc add item',
    'npc add move',
    'npc add temp',
    'npc delete',
    'npc delete item',
    'npc follow',
    'npc follow stop',
    'npc move',
    'npc set',
    'npc set allowmove',
    'npc set data',
    'npc set entry',
    'npc set faction original',
    'npc set faction permanent',
    'npc set faction temp',
    'npc set flag',
    'npc set level',
    'npc set link',
    'npc set model',
    'npc set movetype',
    'npc set phase',
    'npc set spawntime',
    'npc set wanderdistance',
    'npc tame',
    'send',
    'send mail',
    'send message',
    'string',
    'teleport group',
    'teleport name',
    'teleport name npc guid',
    'teleport name npc id',
    'teleport name npc name',
    'ticket',
    'ticket assign',
    'ticket close',
    'ticket closedlist',
    'ticket comment',
    'ticket complete',
    'ticket escalate',
    'ticket escalatedlist',
    'ticket list',
    'ticket onlinelist',
    'ticket response',
    'ticket response append',
    'ticket response appendln',
    'ticket response delete',
    'ticket response show',
    'ticket unassign',
    'ticket viewid',
    'ticket viewname',
    'unban',
    'unban account',
    'unban character',
    'unban ip',
    'unban playeraccount',
    'unfreeze',
    'unmute',
    'unstuck'
);

--
-- GM T2 (Protector)
--
UPDATE `command`
SET `security` = 3
WHERE `name` IN (
    'account set',
    'account set 2fa',
    'account set addon',
    'account set email',
    'account set gmlevel',
    'account set password',
    'additem', -- Matches live
    'additem set', -- Matches live
    'announce',
    'arena captain',
    'arena create',
    'arena disband',
    'aura',
    'aura stack',
    'bf',
    'bf enable',
    'bf start',
    'bf stop',
    'bf switch',
    'bf timer',
    'character changeaccount',
    'character deleted list',
    'character deleted restore',
    'character level',
    'cometome',
    'damage',
    'debug anim',
    'debug areatriggers',
    'debug arena',
    'debug bg',
    'debug cooldown',
    'debug dummy',
    'debug entervehicle',
    'debug getitemstate',
    'debug getitemvalue',
    'debug getvalue',
    'debug itemexpire',
    'debug lfg',
    'debug lootrecipient',
    'debug los',
    'debug Mod32Value',
    'debug moveflags',
    'debug objectcount',
    'debug play music',
    'debug play visual',
    'debug send',
    'debug send buyerror',
    'debug send channelnotify',
    'debug send chatmessage',
    'debug send equiperror',
    'debug send largepacket',
    'debug send opcode',
    'debug send qinvalidmsg',
    'debug send qpartymsg',
    'debug send sellerror',
    'debug send setphaseshift',
    'debug send spellfail',
    'debug setaurastate',
    'debug setbit',
    'debug setitemvalue',
    'debug setvalue',
    'debug setvid',
    'debug spawnvehicle',
    'debug threat',
    'debug update',
    'debug uws',
    'deserter bg remove all',
    'deserter instance remove all',
    'disable add battleground',
    'disable add map',
    'disable add outdoorpvp',
    'disable add quest',
    'disable add spell',
    'disable add vmap',
    'disable remove battleground',
    'disable remove map',
    'disable remove outdoorpvp',
    'disable remove quest',
    'disable remove spell',
    'disable remove vmap',
    'flusharenapoints',
    'gm list',
    'honor', -- Matches live
    'honor add', -- Matches live
    'honor add kill', -- Matches live
    'honor update', -- Matches live
    'instance savedata',
    'lfg clean',
    'linkgrave',
    'mmap',
    'mmap loadedtiles',
    'mmap loc',
    'mmap path',
    'mmap stats',
    'mmap testarea',
    'modify arenapoints', -- Matches live
    'modify faction',
    'modify honor', -- Matches live
    'modify money', -- Matches live
    'nameannounce',
    'notify',
    'pdump',
    'pdump load',
    'pdump write',
    'playall',
    'reload',
    'reload achievement_criteria_data',
    'reload achievement_reward',
    'reload achievement_reward_locale',
    'reload acore_string',
    'reload all',
    'reload all achievement',
    'reload all area',
    'reload all gossips',
    'reload all item',
    'reload all locales',
    'reload all loot',
    'reload all npc',
    'reload all quest',
    'reload all scripts',
    'reload all spell',
    'reload areatrigger_involvedrelation',
    'reload areatrigger_tavern',
    'reload areatrigger_teleport',
    'reload auctions',
    'reload autobroadcast',
    'reload battleground_template',
    'reload broadcast_text',
    'reload command',
    'reload conditions',
    'reload config',
    'reload creature_linked_respawn',
    'reload creature_loot_template',
    'reload creature_movement_override',
    'reload creature_onkill_reputation',
    'reload creature_questender',
    'reload creature_queststarter',
    'reload creature_template',
    'reload creature_template_locale',
    'reload creature_text',
    'reload creature_text_locale',
    'reload disables',
    'reload disenchant_loot_template',
    'reload dungeon_access_requirements',
    'reload dungeon_access_template',
    'reload event_scripts',
    'reload fishing_loot_template',
    'reload gameobject_loot_template',
    'reload gameobject_questender',
    'reload gameobject_queststarter',
    'reload gameobject_template_locale',
    'reload game_graveyard',
    'reload game_tele',
    'reload gm_tickets',
    'reload gossip_menu',
    'reload gossip_menu_option',
    'reload gossip_menu_option_locale',
    'reload graveyard_zone',
    'reload item_enchantment_template',
    'reload item_loot_template',
    'reload item_set_names',
    'reload item_set_name_locale',
    'reload item_template_locale',
    'reload lfg_dungeon_rewards',
    'reload mail_level_reward',
    'reload mail_loot_template',
    'reload mail_server_template',
    'reload milling_loot_template',
    'reload module_string',
    'reload motd',
    'reload npc_spellclick_spells',
    'reload npc_text_locale',
    'reload npc_trainer',
    'reload npc_vendor',
    'reload page_text',
    'reload page_text_locale',
    'reload pickpocketing_loot_template',
    'reload player_loot_template',
    'reload points_of_interest',
    'reload points_of_interest_locale',
    'reload prospecting_loot_template',
    'reload quest_greeting',
    'reload quest_poi',
    'reload quest_template',
    'reload quest_template_locale',
    'reload reference_loot_template',
    'reload reserved_name',
    'reload skill_discovery_template',
    'reload skill_extra_item_template',
    'reload skill_fishing_base_level',
    'reload skinning_loot_template',
    'reload smart_scripts',
    'reload spell_area',
    'reload spell_bonus_data',
    'reload spell_group',
    'reload spell_group_stack_rules',
    'reload spell_linked_spell',
    'reload spell_loot_template',
    'reload spell_pet_auras',
    'reload spell_proc',
    'reload spell_proc_event',
    'reload spell_required',
    'reload spell_scripts',
    'reload spell_target_position',
    'reload spell_threats',
    'reload vehicle_accessory',
    'reload vehicle_template_accessory',
    'reload waypoint_data',
    'reload waypoint_scripts',
    'respawn all',
    'saveall',
    'send items', -- Matches live
    'send money', -- Matches live
    'server corpses',
    'server idlerestart cancel',
    'server idleshutdown cancel',
    'server restart',
    'server restart cancel',
    'server set motd',
    'server shutdown',
    'server shutdown cancel',
    'skirmish',
    'teleport add',
    'teleport del',
    'ticket delete',
    'ticket togglesystem',
    'wchange',
    'wp',
    'wp add',
    'wp event',
    'wp load',
    'wp modify',
    'wp reload',
    'wp show',
    'wp unload',
    'wpgps'
);


--
-- Administrator
--
UPDATE `command`
SET `security` = 4
WHERE `name` IN (
    'account create',
    'account delete',
    'account onlinelist',
    'character deleted delete',
    'character deleted purge',
    'character erase',
    'reset',
    'reset achievements',
    'reset all',
    'reset honor',
    'reset items',
    'reset items all',
    'reset items allbags',
    'reset items bags',
    'reset items bank',
    'reset items currency',
    'reset items equipped',
    'reset items keyring',
    'reset items vendor_buyback',
    'reset level',
    'reset spells',
    'reset stats',
    'reset talents',
    'server exit',
    'server idlerestart',
    'server idleshutdown',
    'server set closed',
    'server set loglevel',
    'ticket reset',
    'modify spell'
);