Thursday, September 30, 2010

Full mangos command list

Original from http://www.reaper-x.com/2007/09/21/wow-mangos-gm-game-master-commands/
Really helpful !!!

namesecurityhelp
account0Syntax: .accountDisplay the access level of your account.
account characters3Syntax: .account characters [#accountId|$accountName]Show list all characters for account seelcted by provided #accountId or $accountName, or for selected player in game.
account create4Syntax: .account create $account $passwordCreate account & set password to it.
account delete4Syntax: .account delete $accountDelete account with all characters.
account lock0Syntax: .account lock [on|off]Allow login from account only from current used IP or remove this requirement.
account onlinelist4Syntax: .account onlinelistShow list of online accounts.
account password0Syntax: .account password $old_password $new_password $new_passwordChange your account password.
account set addon3Syntax: .account set addon [#accountId|$accountName] #addonSet user (possible targeted) expansion addon level allowed. Addon values: 0 – normal, 1 – tbc, 2 – wotlk.
account set gmlevel4Syntax: .account set gmlevel [#accountId|$accountName] #levelSet the security level for targeted player (can’t be used at self) or for #accountId or $accountName to a level of #level.

#level may range from 0 to 3.

account set password4Syntax: .account set password (#accountId|$accountName) $password $passwordSet password for account.
additem3Syntax: .additem #itemid/[#itemname]/#shift-click-item-link #itemcountAdds the specified number of items of id #itemid (or exact (!) name $itemname in brackets, or link created by shift-click at item in inventory or recipe) to your or selected character inventory. If #itemcount is omitted, only one item will be added.
.
additemset3Syntax: .additemset #itemsetidAdd items from itemset of id #itemsetid to your or selected character inventory. Will add by one example each item from itemset.
announce1Syntax: .announce $MessageToBroadcastSend a global message to all players online in chat log.
aura3Syntax: .aura #spellidAdd the aura from spell #spellid to the selected Unit.
ban account3Syntax: .ban account $Name $bantime $reason
Ban account kick player.
$bantime: negative value leads to permban, otherwise use a timestring like “4d20h3s”.
ban character3Syntax: .ban character $Name $bantime $reason
Ban account & kick player.
$bantime: negative value leads to permban, otherwise use a timestring like “4d20h3s”.
ban ip3Syntax: .ban ip $Ip $bantime $reason
Ban IP.
$bantime: negative value leads to permban, otherwise use a timestring like “4d20h3s”.
baninfo account3Syntax: .baninfo account $accountid
Watch full information approximately a specific ban.
baninfo character3Syntax: .baninfo character $charactername
Watch full information approximately a specific ban.
baninfo ip3Syntax: .baninfo ip $ip
Watch full information approximately a specific ban.
bank3Syntax: .bankShow your bank inventory.
banlist account3Syntax: .banlist account [$Name]
Searches the banlist for a account name pattern or show full list account bans.
banlist character3Syntax: .banlist character $Name
Searches the banlist for a character name pattern. Pattern required.
banlist ip3Syntax: .banlist ip [$Ip]
Searches the banlist for a IP pattern or show full list of IP bans.
cast3Syntax: .cast #spellid [triggered]
Cast #spellid to selected target. If no target selected cast to self. If ‘trigered’ or part provided then spell casted with triggered flag.
cast back3Syntax: .cast back #spellid [triggered]
Selected target will cast #spellid to your character. If ‘trigered’ or part provided then spell casted with triggered flag.
cast dist3Syntax: .cast dist #spellid [#dist [triggered]]
You will cast spell to pint at distance #dist. If ‘trigered’ or part provided then spell casted with triggered flag. Not all spells can be casted as area spells.
cast self3Syntax: .cast self #spellid [triggered]
Cast #spellid by target at target itself. If ‘trigered’ or part provided then spell casted with triggered flag.
cast target3Syntax: .cast target #spellid [triggered]
Selected target will cast #spellid to his victim. If ‘trigered’ or part provided then spell casted with triggered flag.
character customize2Syntax: .character customize [$name]Mark selected in game or by $name in command character for customize at next login.
character deleted delete4Syntax: .character deleted delete #guid|$nameCompletely deletes the selected characters.
If $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 list3Syntax: .character deleted list [#guid|$name]Shows a list with all deleted characters.
If $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 old4Syntax: .character deleted old [#keepDays]Completely deletes all characters with deleted time longer #keepDays. If #keepDays not provided the used value from mangosd.conf option ‘CharDelete.KeepDays’. If referenced config option disabled (use 0 value) then command can’t be used without #keepDays.
character deleted restore3Syntax: .character deleted restore #guid|$name [$newname] [#new account]Restores deleted characters.
If $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.
If $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 erase4Syntax: .character erase $nameDelete character $name. Character finally deleted in case any deleting options.
character level3Syntax: .character level [$playername] [#level]Set 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 & name not provided, increase your level. Command can be used for offline character. All stats & 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 rename2Syntax: .character rename [$name]Mark selected in game or by $name in command character for rename at next login.
character reputation2Syntax: .character reputation [$player_name]Show reputation information for selected player or player find by $player_name.
character titles2Syntax: .character titles [$player_name]Show known titles list for selected player or player find by $player_name.
combatstop2Syntax: .combatstop [$playername]
Stop combat for selected character. If selected non-player then command applied to self. If $playername provided then attempt applied to online player $playername.
commands0Syntax: .commandsDisplay a list of available commands for your account level.
cooldown3Syntax: .cooldown [#spell_id]Remove all (if spell_id not provided) or #spel_id spell cooldown from selected character or you (if no selection).
damage3Syntax: .damage $damage_amount [$school [$spellid]]Apply $damage to target. If not $school & $spellid provided then this flat clean melee damage without any modifiers. If $school provided then damage modified by armor reduction (if school physical), & target absorbing modifiers & result applied as melee damage to target. If spell provided then damage modified & applied as spell damage. $spellid can be shift-link.
debug anim2Syntax: .debug anim #emoteidPlay emote #emoteid for your character.
debug arena3Syntax: .debug arenaToggle debug mode for arenas. In debug mode GM can start arena with single player.
debug bg3Syntax: .debug bgToggle debug mode for battlegrounds. In debug mode GM can start battleground with single player.
debug getvalue3Syntax: .debug getvalue #field #isIntGet the field #field of the selected creature. If no creature is selected, obtain the content of your field.

Use a #isInt of value 1 if the expected field content is an integer.

debug play cinematic1Syntax: .debug play cinematic #cinematicidPlay cinematic #cinematicid for you. You stay at place while your mind fly.
debug play movie1Syntax: .debug play movie #movieidPlay movie #movieid for you.
debug play sound1Syntax: .debug play sound #soundidPlay sound with #soundid.
Sound will be play only for you. Other players do not hear this.
Warning: client may have more 5000 sounds…
debug setvalue3Syntax: .debug setvalue #field #value #isIntSet the field #field of the selected creature with value #value. If no creature is selected, set the content of your field.

Use a #isInt of value 1 if #value is an integer.

debug update3Syntax: .debug update #field #valueUpdate the field #field of the selected character or creature with value #value.

If no #value is provided, display the content of field #field.

debug Mod32Value3Syntax: .debug Mod32Value #field #valueAdd #value to field #field of your character.
delticket2Syntax: .delticket all
.delticket #num
.delticket $character_nameall to dalete all tickets at server, $character_name to delete ticket of this character, #num to delete ticket #num.
demorph2Syntax: .demorphDemorph the selected player.
die3Syntax: .dieKill the selected player. If no player is selected, it will kill you.
dismount0Syntax: .dismountDismount you, if you are mounted.
distance3Syntax: .distance [$name/$link]Display the distance from your character to the selected creature/player, or player with name $name, or player/creature/gameobject pointed to shift-link with guid.
event2Syntax: .event #event_id
Show details approximately event with #event_id.
event list2Syntax: .event list
Show list of currently active events.
Show list of all events
event start2Syntax: .event start #event_id
Start event #event_id. Set start time for event to current moment (change not saved in DB).
event stop2Syntax: .event stop #event_id
Stop 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).
explorecheat3Syntax: .explorecheat #flagReveal or hide all maps for the selected player. If no player is selected, hide or reveal maps to you.

Use a #flag of value 1 to reveal, use a #flag value of 0 to hide all maps.

flusharenapoints3Syntax: .flusharenapointsUse it to distribute arena points based on arena team ratings, & start a new week.
gm1Syntax: .gm [on/off]Enable or Disable in game GM MODE or show current state of on/off not provided.
gm chat1Syntax: .gm chat [on/off]Enable or disable chat GM MODE (show gm badge in messages) or show current state of on/off not provided.
gm fly3Syntax: .gm fly [on/off]
Enable/disable gm fly mode.
gm ingame0Syntax: .gm ingameDisplay a list of available in game Game Masters.
gm list3Syntax: .gm listDisplay a list of all Game Masters accounts & security levels.
gm visible1Syntax: .gm visible on/offOutput current visibility state or make GM visible(on) & invisible(off) for other players.
go creature1Syntax: .go creature #creature_guid
Teleport your character to creature with guid #creature_guid.
.gocreature #creature_name
Teleport your character to creature with this name.
.gocreature id #creature_id
Teleport your character to a creature that was spawned from the template with this entry.
*If* more than one creature is found, then you are teleported to the first that is found inside the database.
go graveyard1Syntax: .go graveyard #graveyardId
Teleport to graveyard with the graveyardId specified.
go grid1Syntax: .go grid #gridX #gridY [#mapId]Teleport the gm to center of grid with provided indexes at map #mapId (or current map if it not provided).
go object1Syntax: .go object #object_guid
Teleport your character to gameobject with guid #object_guid
go taxinode1Syntax: .go taxinode #taxinodeTeleport player to taxinode coordinates. You can look up zone using .lookup taxinode $namepart
go trigger1Syntax: .go trigger #trigger_idTeleport your character to areatrigger with id #trigger_id. Character will be teleported to trigger target if selected areatrigger is telporting trigger.
go xy1Syntax: .go xy #x #y [#mapid]Teleport player to point with (#x,#y) coordinates at ground(water) level at map #mapid or same map if #mapid not provided.
go xyz1Syntax: .go xyz #x #y #z [#mapid]Teleport player to point with (#x,#y,#z) coordinates at ground(water) level at map #mapid or same map if #mapid not provided.
go zonexy1Syntax: .go zonexy #x #y [#zone]Teleport 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 add2Syntax: .gobject add #id <spawntimeSecs>Add a game object from game object templates to the world at your current location using the #id.
spawntimesecs sets the spawntime, it is optional.

Note: this is a copy of .gameobject.

gobject delete2Syntax: .gobject delete #go_guid
Delete gameobject with guid #go_guid.
gobject move2Syntax: .gobject move #goguid [#x #y #z]Move gameobject #goguid to character coordinates (or to (#x,#y,#z) coordinates if its provide).
gobject near2Syntax: .gobject near [#distance]Output gameobjects at distance #distance from player. Output gameobject guids & coordinates sorted by distance from character. If #distance not provided use 10 as default value.
gobject setphase2Syntax: .gobject setphase #guid #phasemaskGameobject with DB guid #guid phasemask changed to #phasemask with related world vision update for players. Gameobject state saved to DB & persistent.
gobject turn2Syntax: .gobject turn #goguidSet for gameobject #goguid orientation same as current character orientation.
gobject target2Syntax: .gobject target [#go_id|#go_name_part]Locate & show position nearest gameobject. If #go_id or #go_name_part provide then locate & show position of nearest gameobject with gameobject template id #go_id or name included #go_name_part as part.
goname1Syntax: .goname [$charactername]Teleport 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.
gps1Syntax: .gps [$name|$shift-link]Display 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, & orientation, map Id & zone Id
groupgo1Syntax: .groupgo [$charactername]Teleport the given character & his group to you. Teleported only online characters yet original selected group member can be offline.
guid2Syntax: .guidDisplay the GUID for the selected character.
guild create2Syntax: .guild create [$GuildLeaderName] “$GuildName”Create a guild named $GuildName with the player $GuildLeaderName (or selected) as leader. Guild name must in quotes.
guild delete2Syntax: .guild delete “$GuildName”Delete guild $GuildName. Guild name must in quotes.
guild invite2Syntax: .guild invite [$CharacterName] “$GuildName”Add player $CharacterName (or selected) into a guild $GuildName. Guild name must in quotes.
guild rank2Syntax: .guild rank $CharacterName #RankSet for $CharacterName rank #Rank in a guild.
guild uninvite2Syntax: .guild uninvite [$CharacterName]Remove player $CharacterName (or selected) from a guild.
help0Syntax: .help [$command]Display usage instructions for the given $command. If no $command provided show list available commands.
hidearea3Syntax: .hidearea #areaidHide the area of #areaid to the selected character. If no character is selected, hide this area to you.
honor add2Syntax: .honor add $amountAdd a certain amount of honor (gained today) to the selected player.
honor addkill2Syntax: .honor addkikllAdd the targeted unit as one of your pvp kills today (you only obtain honor if it’s a racial leader or a player)
honor update2Syntax: .honor updateForce the yesterday’s honor fields to be updated with today’s data, which will obtain reset for the selected player.
name security help
hover3Syntax: .hover #flagEnable or disable hover mode for your character.

Use a #flag of value 1 to enable, use a #flag value of 0 to disable hover.

instance unbind3Syntax: .instance unbind all
All of the selected player’s binds will be cleared.
.instance unbind #mapid
Only the specified #mapid instance will be cleared.
instance listbinds3Syntax: .instance listbinds
Lists the binds of the selected player.
instance stats3Syntax: .instance stats
Shows statistics approximately instances.
instance savedata3Syntax: .instance savedata
Save the InstanceData for the current player’s map to the DB.
itemmove2Syntax: .itemmove #sourceslotid #destinationslotidMove an item from slots #sourceslotid to #destinationslotid in your inventory

Not yet implemented

kick2Syntax: .kick [$charactername]Kick the given character name from the world. If no character name is provided then the selected player (except for yourself) will be kicked.
learn3Syntax: .learn #spell [all]Selected character learn a spell of id #spell. If ‘all’ provided then all ranks learned.
learn all3Syntax: .learn allLearn all huge set different spell maybe useful for Administaror.
learn all_crafts2Syntax: .learn craftsLearn all professions & recipes.
learn all_default1Syntax: .learn all_default [$playername]Learn for selected/$playername player all default spells for his race/class & spells rewarded by completed quests.
learn all_gm2Syntax: .learn all_gmLearn all default spells for Game Masters.
learn all_lang1Syntax: .learn all_langLearn all languages
learn all_myclass3Syntax: .learn all_myclassLearn all spells & talents available for his class.
learn all_mypettalents3Syntax: .learn all_mypettalentsLearn all talents for your pet available for his creature type (only for hunter pets).
learn all_myspells3Syntax: .learn all_myspellsLearn all spells (except talents & spells with first rank learned as talent) available for his class.
learn all_mytalents3Syntax: .learn all_mytalentsLearn all talents (and spells with first rank learned as talent) available for his class.
learn all_recipes2Syntax: .learn all_recipes [$profession]Learns all recipes of specified profession & sets skill level to max.
Example: .learn all_recipes enchanting
levelup3Syntax: .levelup [$playername] [#numberoflevels]Increase/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 & name not provided, increase your level. Command can be used for offline character. All stats & dependent VALUESrecalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost.
linkgrave3Syntax: .linkgrave #graveyard_id [alliance|horde]Link 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 & accept ghost of this faction. Add only single graveyard at another map & only if no graveyards linked (or planned linked at same map).
list creature3Syntax: .list creature #creature_id [#max_count]Output creatures with creature id #creature_id found in world. Output creature guids & coordinates sorted by distance from character. Will be output maximum #max_count creatures. If #max_count not provided use 10 as default value.
list item3Syntax: .list item #item_id [#max_count]Output items with item id #item_id found in all character inventories, mails, auctions, & guild banks. Output item guids, item owner guid, owner account & owner name (guild name & guid in case guild bank). Will be output maximum #max_count items. If #max_count not provided use 10 as default value.
list object3Syntax: .list object #gameobject_id [#max_count]Output gameobjects with gameobject id #gameobject_id found in world. Output gameobject guids & coordinates sorted by distance from character. Will be output maximum #max_count gameobject. If #max_count not provided use 10 as default value.
list talents3Syntax: .list talentsShow list all really known (as learned spells) talent rank spells for selected player or self.
loadscripts3Syntax: .loadscripts $scriptlibrarynameUnload current & load the script library $scriptlibraryname or reload current if $scriptlibraryname omitted, in case you changed it while the server was running.
lookup account email2Syntax: .lookup account email $emailpart [#limit]Searchs accounts, which email including $emailpart with optional parametr #limit of results. If #limit not provided expected 100.
lookup account ip2Syntax: lookup account ip $ippart [#limit]Searchs accounts, which last used ip inluding $ippart (textual) with optional parametr #$limit of results. If #limit not provided expected 100.
lookup account name2Syntax: .lookup account name $accountpart [#limit]Searchs accounts, which username including $accountpart with optional parametr #limit of results. If #limit not provided expected 100.
lookup area1Syntax: .lookup area $namepartLooks up an area by $namepart, & returns all matches with their area ID’s.
lookup creature3Syntax: .lookup creature $namepartLooks up a creature by $namepart, & returns all matches with their creature ID’s.
lookup event2Syntax: .lookup event $name
Attempts to find the ID of the event with the provided $name.
lookup faction3Syntax: .lookup faction $name
Attempts to find the ID of the faction with the provided $name.
lookup item3Syntax: .lookup item $itemnameLooks up an item by $itemname, & returns all matches with their Item ID’s.
lookup itemset3Syntax: .lookup itemset $itemnameLooks up an item set by $itemname, & returns all matches with their Item set ID’s.
lookup object3Syntax: .lookup object $objnameLooks up an gameobject by $objname, & returns all matches with their Gameobject ID’s.
lookup player account2Syntax: .lookup player account $accountpart [#limit]Searchs players, which account username including $accountpart with optional parametr #limit of results. If #limit not provided expected 100.
lookup player email2Syntax: .lookup player email $emailpart [#limit]Searchs players, which account email including $emailpart with optional parametr #limit of results. If #limit not provided expected 100.
lookup player ip2Syntax: .lookup player ip $ippart [#limit]Searchs players, which account last used ip inluding $ippart (textual) with optional parametr #limit of results. If #limit not provided expected 100.
lookup quest3Syntax: .lookup quest $namepartLooks up a quest by $namepart, & returns all matches with their quest ID’s.
lookup skill3Syntax: .lookup skill $$namepartLooks up a skill by $namepart, & returns all matches with their skill ID’s.
lookup spell3Syntax: .lookup spell $namepartLooks up a spell by $namepart, & returns all matches with their spell ID’s.
lookup taxinode3Syntax: .lookup taxinode $substringSearch & output all taxinodes with provide $substring in name.
lookup tele1Syntax: .lookup tele $substringSearch & output all .tele command locations with provide $substring in name.
lookup title2Syntax: .lookup title $$namepartLooks up a title by $namepart, & returns all matches with their title ID’s & index’s.
maxskill3Syntax: .maxskill
Sets all skills of the targeted player to their maximum VALUESfor its current level.
modify arena1Syntax: .modify arena #value
Add $amount arena points to the selected player.
modify aspeed1Syntax: .modify aspeed #rateModify 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.

#rate may range from 0.1 to 10.

modify bit1Syntax: .modify bit #field #bitToggle the #bit bit of the #field field for the selected player. If no player is selected, modify your character.
modify bwalk1Syntax: .modify bwalk #rateModify the speed of the selected player while running backwards to “normal walk back speed”*rate. If no player is selected, modify your speed.

#rate may range from 0.1 to 10.

modify drunk1Syntax: .modify drunk #value
Set drunk level to #value (0..100). Value 0 remove drunk state, 100 is max drunked state.
modify energy1Syntax: .modify energy #energyModify the energy of the selected player. If no player is selected, modify your energy.
modify faction1Syntax: .modify faction #factionid #flagid #npcflagid #dynamicflagidModify the faction & flags of the selected creature. Without arguments, display the faction & flags of the selected creature.
modify fly1Syntax: .modify fly #rate
.fly #rateModify the flying speed of the selected player to “normal base fly speed”*rate. If no player is selected, modify your fly.

#rate may range from 0.1 to 10.

modify gender2Syntax: .modify gender male/femaleChange gender of selected player.
modify honor1Syntax: .modify honor $amountAdd $amount honor points to the selected player.
modify hp1Syntax: .modify hp #newhpModify the hp of the selected player. If no player is selected, modify your hp.
modify mana1Syntax: .modify mana #newmanaModify the mana of the selected player. If no player is selected, modify your mana.
modify money1Syntax: .modify money #money
.money #moneyAdd or remove money to the selected player. If no player is selected, modify your money.

#gold can be negative to remove money.

modify morph2Syntax: .modify morph #displayidChange your current model id to #displayid.
modify mount1Syntax: .modify mount #id #speed
Display selected player as mounted at #id creature & set speed to #speed value.
modify phase3Syntax: .modify phase #phasemaskSelected 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 rage1Syntax: .modify rage #newrageModify the rage of the selected player. If no player is selected, modify your rage.
modify rep2Syntax: .modify rep #repId (#repvalue | $rankname [#delta])
Sets the selected players reputation with faction #repId to #repvalue or to $reprank.
If the reputation rank name is provided, the resulting reputation will be the lowest reputation for that rank plus the delta amount, if specified.
You can use ‘.pinfo rep’ to list all known reputation ids, or use ‘.lookup faction $name’ to locate a specific faction id.
modify runicpower1Syntax: .modify runicpower #newrunicpowerModify the runic power of the selected player. If no player is selected, modify your runic power.
modify scale1Syntax: .modify scale #scaleChange model scale for targeted player (util relogin) or creature (until respawn).
modify speed1Syntax: .modify speed #rate
.speed #rateModify the running speed of the selected player to “normal base run speed”*rate. If no player is selected, modify your speed.

#rate may range from 0.1 to 10.

modify spell1
modify standstate2Syntax: .modify standstate #emoteidChange the emote of your character while standing to #emoteid.
modify swim1Syntax: .modify swim #rateModify the swim speed of the selected player to “normal swim speed”*rate. If no player is selected, modify your speed.

#rate may range from 0.1 to 10.

modify tp1Syntax: .modify tp #amountSet free talent pointes for selected character or character’s pet. It will be reset to default expected at next levelup/login/quest reward.
movegens3Syntax: .movegens
Show movement generators stack for selected creature or player.
mute1Syntax: .mute [$playerName] $timeInMinutesDisible chat messaging for any character from account of character $playerName (or currently selected) at $timeInMinutes minutes. Player can be offline.
namego1Syntax: .namego [$charactername]Teleport the given character to you. Character can be offline.
neargrave3Syntax: .neargrave [alliance|horde]Find nearest graveyard linked to zone (or only nearest from accepts alliance or horde faction ghosts).
notify1Syntax: .notify $MessageToBroadcastSend a global message to all players online in screen.
npc add2Syntax: .npc add #creatureidSpawn a creature by the given template id of #creatureid.
npc additem2Syntax: .npc additem #itemId <#maxcount><#incrtime><#extendedcost>rAdd item #itemid to item list of selected vendor. Also optionally set max count item in vendor item list & time to item count restoring & items ExtendedCost.
npc addmove2Syntax: .npc addmove #creature_guid [#waittime]Add your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.
npc addweapon3Not yet implemented.
npc allowmove3Syntax: .npc allowmoveEnable or disable movement creatures in world. Not implemented.
npc changelevel2Syntax: .npc changelevel #levelChange the level of the selected creature to #level.

#level may range from 1 to 63.

npc delete2Syntax: .npc delete [#guid]Delete creature with guid #guid (or the selected if no guid is provided)
npc delitem2Syntax: .npc delitem #itemIdRemove item #itemid from item list of selected vendor.
npc factionid2Syntax: .npc factionid #factionidSet the faction of the selected creature to #factionid.
npc flag2Syntax: .npc flag #npcflagSet the NPC flags of creature template of the selected creature & selected creature to #npcflag. NPC flags will applied to all creatures of selected creature template after server restart or grid unload/load.
npc follow2Syntax: .npc followSelected creature start follow you until death/fight/etc.
npc info3Syntax: .npc infoDisplay a list of details for the selected creature.

The list includes:
– GUID, Faction, NPC flags, Entry ID, Model ID,
– Level,
– Health (current/maximum),

– Field flags, dynamic flags, faction template,
– Position information,
– & the creature type, e.g. if the creature is a vendor.

npc move2Syntax: .npc move [#creature_guid]Move the targeted creature spawn point to your coordinates.
npc name2Syntax: .npc name $nameChange the name of the selected creature or character to $name.

Command disabled.

npc playemote3Syntax: .npc playemote #emoteidMake the selected creature emote with an emote of id #emoteid.
npc say1Syntax: .npc say #text
Make the selected npc says #text.
npc setdeathstate2Syntax: .npc setdeathstate on/offSet default death state (dead/alive) for npc at spawn.
npc setmodel2Syntax: .npc setmodel #displayidChange the model id of the selected creature to #displayid.
npc setmovetype2Syntax: .npc setmovetype [#creature_guid] stay/random/way [NODEL]Set for creature pointed by #creature_guid (or selected if #creature_guid not provided) movement type & 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.
Make sure you use NODEL, if you want to keep the waypoints.
npc setphase2Syntax: .npc setphase #phasemaskSelected unit or pet phasemask changed to #phasemask with related world vision update for players. In creature case state saved to DB & persistent. In pet case alter active until in game phase changed for owner, owner re-login, or GM-mode enable/disable..
npc spawndist2Syntax: .npc spawndist #distAdjust spawndistance of selected creature to dist.
npc spawntime2Syntax: .npc spawntime #timeAdjust spawntime of selected creature to time.
npc subname2Syntax: .npc subname $NameChange the subname of the selected creature or player to $Name.

Command disabled.

npc tame2Syntax: .npc tameTame selected creature (tameable non pet creature). You don’t must have pet.
npc textemote1Syntax: .npc textemote #emoteidMake the selected creature to do textemote with an emote of id #emoteid.
name security help
npc whisper1Syntax: .npc whisper #playerguid #text
Make the selected npc whisper #text to #playerguid.
npc unfollow2Syntax: .npc unfollowSelected creature (non pet) stop follow you.
npc yell1Syntax: .npc yell #text
Make the selected npc yells #text.
pdump write3Syntax: .pdump write $filename $playerNameOrGUID
Write character dump with name/guid $playerNameOrGUID to file $filename.
pdump load3Syntax: .pdump load $filename $account [$newname] [$newguid]
Load character dump from dump file into character list of $account with saved or $newname, with saved (or first free) or $newguid guid.
pinfo2Syntax: .pinfo [$player_name]Output account information for selected player or player find by $player_name.
quest add3Syntax: .quest add #quest_idAdd to character quest log quest #quest_id. Quest started from item can’t be added by this command yet correct .additem call provided in command output.
quest complete3Syntax: .quest complete #questid
Mark all quest objectives as completed for target character active quest. After this target character can go & obtain quest reward.
quest remove3Syntax: .quest remove #quest_idSet quest #quest_id state to not completed & not active (and remove from active quest list) for selected player.
quit4Syntax: quitClose RA connection. Command must be typed fully (quit).
recall1Syntax: .recall [$playername]Teleport $playername or selected player to the place where he has been before last use of a teleportation command. If no $playername is entered & no player is selected, it will teleport you.
reload all3Syntax: .reload allReload all tables with reload support added & that can be _safe_ reloaded.
reload all_achievement3Syntax: .reload all_achievementReload all `achievement_*` tables if reload support added for this table & this table can be _safe_ reloaded.
reload all_area3Syntax: .reload all_areaReload all `areatrigger_*` tables if reload support added for this table & this table can be _safe_ reloaded.
reload all_eventai3Syntax: .reload all_eventaiReload `creature_ai_*` tables if reload support added for these tables & these tables can be _safe_ reloaded.
reload all_item3Syntax: .reload all_itemReload `item_required_target`, `page_texts` & `item_enchantment_template` tables.
reload all_locales3Syntax: .reload all_localesReload all `locales_*` tables with reload support added & that can be _safe_ reloaded.
reload all_loot3Syntax: .reload all_lootReload all `*_loot_template` tables. This can be slow operation with lags for server run.
reload all_npc3Syntax: .reload all_npcReload `points_of_interest` & `npc_*` tables if reload support added for these tables & these tables can be _safe_ reloaded.
reload all_quest3Syntax: .reload all_questReload all quest related tables if reload support added for this table & this table can be _safe_ reloaded.
reload all_spell3Syntax: .reload all_spellReload all `spell_*` tables with reload support added & that can be _safe_ reloaded.
reload all_scripts3Syntax: .reload all_scriptsReload `*_scripts` tables.
reload config3Syntax: .reload configReload config settings (by default stored in mangosd.conf). Not all settings can be alter 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 alter at reload.
repairitems2Syntax: .repairitemsRepair all selected player’s items.
reset achievements3Syntax: .reset achievements [$playername]Reset 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 all3Syntax: .reset all spellsSyntax: .reset all talents

Request reset spells or talents (including talents for all character’s pets if any) at next login each existed character.

reset honor3Syntax: .reset honor [Playername]
Reset all honor data for targeted character.
reset level3Syntax: .reset level [Playername]
Reset level to 1 including reset stats & talents. Equipped items with greater level requirement can be lost.
reset spells3Syntax: .reset spells [Playername]
Removes all non-original spells from spellbook.
. Playername can be name of offline character.
reset stats3Syntax: .reset stats [Playername]
Resets(recalculate) all stats of the targeted player to their original VALUESat current level.
reset specs3Syntax: .reset specs [Playername]
Removes all talents (for all specs) of the targeted player or named player. Playername can be name of offline character. With player talents moreover will be reset talents for all character’s pets if any.
reset talents3Syntax: .reset talents [Playername]
Removes all talents (current spec) of the targeted player or pet or named player. With player talents moreover will be reset talents for all character’s pets if any.
respawn3Syntax: .respawnRespawn selected creature or respawn all nearest creatures (if none selected) & GO without waiting respawn time expiration.
revive3Syntax: .reviveRevive the selected player. If no player is selected, it will revive you.
save0Syntax: .saveSaves your character.
saveall1Syntax: .saveallSave all characters in game.
send items3Syntax: .send items #playername “#subject” “#text” itemid1[:count1] itemid2[:count2] … itemidN[:countN]Send a mail to a player. Subject & 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 mail1Syntax: .send mail #playername “#subject” “#text”Send a mail to a player. Subject & mail text must be in “”.
send message3Syntax: .send message $playername $messageSend screen message to player from ADMINISTRATOR.
send money3Syntax: .send money #playername “#subject” “#text” #moneySend mail with money to a player. Subject & mail text must be in “”.
server corpses2Syntax: .server corpsesTriggering corpses expire check in world.
server exit4Syntax: .server exitTerminate mangosd NOW. Exit code 0.
server info0Syntax: .server infoDisplay server version & the number of connected players.
server idleshutdown3Syntax: .server idleshutdown #delay [#exist_code]Shut the server down after #delay seconds if no active connections are present (no players). Use #exist_code or 0 as program exist code.
server idleshutdown cancel3Syntax: .server idleshutdown cancelCancel the restart/shutdown timer if any.
server idlerestart3Syntax: .server idlerestart #delayRestart the server after #delay seconds if no active connections are present (no players). Use #exist_code or 2 as program exist code.
server idlerestart cancel3Syntax: .server idlerestart cancelCancel the restart/shutdown timer if any.
server log filter4Syntax: .server log filter [($filtername|all) (on|off)]Show or set server log filters. If used “all” then all filters will be set to on/off state.
server log level4Syntax: .server log level [#level]Show or set server log level (0 – errors only, 1 – basic, 2 – detail, 3 – debug).
server motd0Syntax: .server motdShow server Message of the day.
server plimit3Syntax: .server plimit [#num|-1|-2|-3|reset|player|moderator|gamemaster|administrator]Without arg show current player amount & security level limitations for login to server, with arg set player linit ($num > 0) or securiti limitation ($num < 0 or security leme name. With `reset` sets player limit to the one in the config file
server restart3Syntax: .server restart #delayRestart the server after #delay seconds. Use #exist_code or 2 as program exist code.
server restart cancel3Syntax: .server restart cancelCancel the restart/shutdown timer if any.
server set motd3Syntax: .server set motd $MOTDSet server Message of the day.
server shutdown3Syntax: .server shutdown #delay [#exit_code]Shut the server down after #delay seconds. Use #exit_code or 0 as program exit code.
server shutdown cancel3Syntax: .server shutdown cancelCancel the restart/shutdown timer if any.
setskill3Syntax: .setskill #skill #level [#max]Set a skill of id #skill with a current skill value of #level & 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.
showarea3Syntax: .showarea #areaidReveal the area of #areaid to the selected character. If no character is selected, reveal this area to you.
start0Syntax: .startTeleport you to the starting area of your character.
taxicheat1Syntax: .taxicheat on/offTemporary grant access or remove to all taxi routes for the selected character. If no character is selected, hide or reveal all routes to you.

Visited taxi nodes sill accessible after removing access.

tele1Syntax: .tele #locationTeleport player to a given location.
tele add3Syntax: .tele add $nameAdd current your position to .tele command target locations list with name $name.
tele del3Syntax: .tele del $nameRemove location with name $name for .tele command locations list.
tele group1Syntax: .tele group#locationTeleport a selected player & his group members to a given location.
tele name1Syntax: .tele name [#playername] #locationTeleport the given character to a given location. Character can be offline.
ticket2Syntax: .ticket on
.ticket off
.ticket #num
.ticket $character_nameon/off for GMs to show or not a new ticket directly, $character_name to show ticket of this character, #num to show ticket #num.
titles add2Syntax: .titles add #title
Add title #title (id or shift-link) to known titles list for selected player.
titles current2Syntax: .titles current #title
Set 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 remove2Syntax: .titles remove #title
Remove title #title (id or shift-link) from known titles list for selected player.
titles setmask2Syntax: .titles setmask #maskAllows user to use all titles from #mask.

#mask=0 disables the title-choose-field

unaura3Syntax: .unaura #spellidRemove aura due to spell #spellid from the selected Unit.
unban account3Syntax: .unban account $Name
Unban accounts for account name pattern.
unban character3Syntax: .unban character $Name
Unban accounts for character name pattern.
unban ip3Syntax : .unban ip $Ip
Unban accounts for IP pattern.
unlearn3Syntax: .unlearn #spell [all]Unlearn for selected player a spell #spell. If ‘all’ provided then all ranks unlearned.
unmute1Syntax: .unmute $playerNameRestore chat messaging for any character from account of character $playerName.
waterwalk2Syntax: .waterwalk on/offSet on/off waterwalk state for selected player.
wchange3Syntax: .wchange #weathertype #statusSet current weather to #weathertype with an intensity of #status.

#weathertype can be 1 for rain, 2 for snow, & 3 for sand. #status can be 0 for disabled, & 1 for enabled.

whispers1Syntax: .whispers on|off
Enable/disable accepting whispers by GM from players. By default use mangosd.conf setting.
wp2Using WP Command:
Each Waypoint Command has it’s own description!
wp add2Syntax: .wp add [#creature_guid or Select a Creature]
wp export3Syntax: .wp export [#creature_guid or Select a Creature] $filename
wp import3Syntax: .wp import $filename
wp modify2Syntax: .wp modify [#creature_guid or Select a Creature]
add – Add a waypoint after the selected visual
waittime $time
emote ID
spell ID
text1| text2| text3| text4| text5 <text>
model1 ID
model2 ID
move(moves wp to player pos)
del (deletes the wp)Only one parameter per time!
wp show2Syntax: .wp show [#creature_guid or Select a Creature]
on
first
last
off
infoFor using info you have to do first show on & than select a Visual-Waypoint & do the show info!

Saturday, September 25, 2010

HTC Hero Tethering after upgrade to Android 2.1

After my HTC Hero upgraded to Android 2.1, I found it is failed to use USB tethering, neither HTC Sync or PDANet works.

The solution is reset to factory settings & install the latest version of HTC sync on your PC, & everything will be working again.

You can download the HTC sync for Android 2.1 from http://www.htc.com/uk/SupportViewNews.aspx?dl_id=982&news_id=776

NOTICE: You will need to reinstall all the applications on your mobile.

Friday, September 24, 2010

Sphinx service crashes

The sphinx sometime crashes if you set seamless_rotate = 1 in your sphinx config file

Set seamless_rotate = 0; may resolve the problem

Thursday, September 16, 2010

How to compile pseuwow under Linux

Pseuwow is widely known as a client emulator for mangos project, it allows you sent chat text to players in game through command line in console which is just like a bot. It officially announce it is 99% support Linux, however due to the author does not familiar with Linux, the Makefile become the 1% which is causes some minor problem.

Prepare

git clone http://github.com/fgenesis/pseuwow.gitmv  pseuwow/src/dep/include/openssl  pseuwow/src/dep/include/opensslx

You need to create a Makefile.am in pseuwow/src/dep/src/irrKlang/

INCLUDES = -I../../include/irrklang -I../../includelibdir=$(top_builddir)/src/dep/lib/linux-gccnoinst_LIBRARIES = libIrrKlang.alibIrrKlang_a_SOURCES = \irrKlang.cpp

and modify pseuwow/src/dep/src/Makefile.am

SUBDIRS = irrlicht zlib zthread irrKlangThen modify pseuwow/src/Client/Makefile.am

Fix the line

../dep/lib/linux-gcc/libIrrKlang.so\

to the correct path

Then

$aclocal$autoreconf$automake$./configure --prefix=/opt/pseuwow$make$make install

at last, you need to copy the entire “dep” direictory & “conf” directory to /opt/pseuwow/bin/

Pseuwow is widely known as a client emulator for mangos project, it allows you sent chat text to players in game through command line in console which is just like a bot. It officially announce it is 99% support Linux, however due to the author does not familiar with Linux, the Makefile become the 1% which is causes some minor problem.

Run multiple SQL query in PHP when using SQL variables

Some times you may need to run mulitple query in PHP to obtain the query result you want. eg

SELECT `column` INTO @column FROM table LIMIT 1;SET @query = CONCAT("SELECT DISTINCT table2.",@column,"  FROM table2");PREPARE stmt FROM @query;EXECUTE stmt;

Here is an example function

function doMultiQuery{if(mysqli_multi_query($con, $query)){  do {     if ($result = mysqli_store_result($con)) {           if(mysqli_num_rows($result)>0)           {                 return $result;           }           @mysqli_free_result($con);     }   } while (@mysqli_next_result($con));}}

How to speed up compile with "make" in Linux

There is an option which is

make -jx

x=the number of concurrent  jobs

For a Dual Core 2 2.0 GHZ CPU, make -j5 will be a feasible choice.

CAUTION: it will cost much more CPU usage while the number increases,  please be careful to use this in any live environment.

Wednesday, September 15, 2010

Access denied due to hash character in MYSQL password

The db password in sphinx configure file should not contains any hash characters which cause access denied during connecting to the database server.