Ideal Mangos DataBase

�� WOW

mybb@mybb.ru (Ubivic) — Sat, 10 Jan 2009 13:54:23 +0300

�� MMORPG � � �� World of Warcraft �� Wow-russian, �� , � �� , ��, �� , � �� x1, x10, x15, x25, �50, �75, x75, �100 � �� 50. Silvermoon, Bladefist, Crushridge, Evening Star, Shadowsong, Warsong, Blackmoon, Test-zone � Armageddon. �� : 2.4.3 Original � Burning Crusade. �� Game Masters. �� , � �� . �� . ��: set realmlist login.wow-russian.ru, �� http://wow-russian.ru

SVN

mybb@mybb.ru (AtOM) — Fri, 09 Jan 2009 21:30:58 +0300

http://subversion.assembla.com/svn/imdb/
�� ICQ

Gm comand mangos Wotlk en

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 15:30:21 +0300

acct 0 Syntax: .acct

Display the access level of your account.

additem 3 Syntax: .additem #itemid/[#itemname]/#shift-click-item-link #itemcount

Adds 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.

additemset 3 Syntax: .additemset #itemsetid

Add items from itemset of id #itemsetid to your or selected character inventory. Will add by one example each item from itemset.

addmove 2 Syntax: .addmove #creature_guid [#waittime]

Add your current location as a waypoint for creature with guid #creature_guid. And optional add wait time.

announce 1 Syntax: .announce $MessageToBroadcast

Send a global message to all players online in chat log.

aura 3 Syntax: .aura #spellid

Add the aura from spell #spellid to the selected Unit.

ban 3 Syntax is: ban <account|ip|character> $NameOrIp $bantime $reason
Ban account or IP and kick player.
$bantime: negative value leads to permban, otherwise use a timestring like �4d20h3s�.

baninfo 3 Syntax is: baninfo <account|ip|character>
Watch full information about a specific ban.

bank 3 Syntax: .bank

Show your bank inventory.

banlist 3 Syntax is: banlist <account|ip|character> $NameOrIp
searches the banlist for a pattern.

cast 3 Syntax: .cast #spellid
Cast #spellid to selected target. If no target selected cast to self.
cast back 3 Syntax: .cast back #spellid
Selected target will cast #spellid to your character.
cast self 3 Syntax: .cast self #spellid
Cast #spellid by target at target itself.
cast target 3 Syntax: .cast target #spellid
Selected target will cast #spellid to his victim.

commands 0 Syntax: .commands

Display a list of available commands for your account level.

cooldown 3 Syntax: .cooldown [#spell_id]

Remove all (if spell_id not provided) or #spel_id spell cooldown from selected character or you (if no selection).

damage 3 Syntax: .damage $damage_amount [$school [$spellid]]

Apply $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), 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 anim 2 Syntax: .debug anim #emoteid

Play emote #emoteid for your character.

debug getvalue 3 Syntax: .debug getvalue #field #isInt

Get the field #field of the selected creature. If no creature is selected, get the content of your field.
Use a #isInt of value 1 if the expected field content is an integer.

debug playsound 1 Syntax: .debug playsound #soundid

Play sound with #soundid.
Sound will be play only for you. Other players do not hear this.
Warning: client may have more 5000 sounds�

debug setvalue 3 Syntax: .debug setvalue #field #value #isInt

Set 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 standstate 2 Syntax: .debug standstate #emoteid

Change the emote of your character while standing to #emoteid.

debug update 3 Syntax: .debug update #field #value

Update the field #field of the selected character or creature with value #value.
If no #value is provided, display the content of field #field.

delticket 2 Syntax: .delticket all
.delticket #num
.delticket $character_name
all to dalete all tickets at server, $character_name to delete ticket of this character, #num to delete ticket #num.

demorph 2 Syntax: .demorph

Demorph the selected player.

die 3 Syntax: .die

Kill the selected player. If no player is selected, it will kill you.

dismount 0 Syntax: .dismount

Dismount you, if you are mounted.

distance 3 Syntax: .distance

Display the distance from your character to the selected creature.

event 2 Syntax: .event #event_id
Show details about event with #event_id.
event activelist 2 Syntax: .event activelist
Show list of currently active events.
event start 2 Syntax: .event start #event_id
Start event #event_id. Set start time for event to current moment (change not saved in DB).
event stop 2 Syntax: .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).

explorecheat 3 Syntax: .explorecheat #flag

Reveal 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.

gm 1 Syntax: .gm on/off

Enable or Disable GM MODE

gm fly 3 Syntax: .gm fly on/off

Enable/disable gm fly mode.

gm list 0 Syntax: .gm list

Display a list of available Game Masters.

gm visible 1 Syntax: .gm visible on/off

Output current visibility state or make GM visible(on) and invisible(off) for other players.

go creature 2 Syntax: .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 graveyard 2 Syntax: .go graveyard #graveyardId

Teleport to graveyard with the graveyardId specified.

go grid 1 Syntax: .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 object 1 Syntax: .go object #object_guid

Teleport your character to gameobject with guid #object_guid

go trigger 2 Syntax: .go trigger #trigger_id

Teleport your character to areatrigger with id #trigger_id. Character will be teleported to trigger target if selected areatrigger is telporting trigger.

go xy 1 Syntax: .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 xyz 1 Syntax: .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 zonexy 1 Syntax: .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 add 2 Syntax: .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 delete 2 Syntax: .gobject delete #go_guid

Delete gameobject with guid #go_guid.

gobject move 2 Syntax: .gobject move #goguid [#x #y #z]

Move gameobject #goguid to character coordinates (or to (#x,#y,#z) coordinates if its provide).

gobject near 3 Syntax: .gobject near [#distance]

Output 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 turn 2 Syntax: .gobject turn #goguid

Set for gameobject #goguid orientation same as current character orientation.

gobject target 2 Syntax: .gobject target [#go_id|#go_name_part]

Locate 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.

goname 1 Syntax: .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.

gps 1 Syntax: .gps

Display the position information for a selected character or creature. Position information includes X, Y, Z, and orientation, map Id and zone Id

groupgo 1 Syntax: .groupgo $charactername

Teleport the given character and his group to you.

guid 2 Syntax: .guid

Display the GUID for the selected character.

guild create 2 Syntax: .guild create $GuildLeaderName $GuildName

Create a guild named $GuildName with the player $GuildLeaderName as leader.

guild delete 2 Syntax: .guild delete $GuildName

Delete guild $GuildName.

guild invite 2 Syntax: .guild invite $CharacterName $GuildName

Add $CharacterName into a guild $GuildName.

guild rank 2 Syntax: .guild rank $CharacterName #Rank

Set for $CharacterName rank #Rank in a guild.

guild uninvite 2 Syntax: .guild uninvite $CharacterName

Remove $CharacterName from a guild.

help 0 Syntax: .help $command

Display usage instructions for the given $command.

hidearea 3 Syntax: .hidearea #areaid

Hide the area of #areaid to the selected character. If no character is selected, hide this area to you.

honor add 2 Syntax: .honor add $amount

Add a certain amount of honor (gained today) to the selected player.

honor addkill 2 Syntax: .honor addkikll

Add 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

Force the yesterday�s honor fields to be updated with today�s data, which will get reset for the selected player.

hover 3 Syntax: .hover #flag

Enable or disable hover mode for your character.

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

idleshutdown 3 Syntax: .idleshutdown #delay|cancel

Shut the server down after #delay seconds if no active connections are present (no players) or cancel the shutdown if cancel value is used.

info 0 Syntax: .info

Display server version and the number of connected players.

itemmove 2 Syntax: .itemmove #sourceslotid #destinationslotid

Move an item from slots #sourceslotid to #destinationslotid in your inventory
Not yet implemented

kick 2 Syntax: .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.

learn 3 Syntax: .learn #parameter

Selected character learn a spell of id #parameter.

learn all 3 Syntax: .learn all

Learn all big set different spell maybe useful for Administaror.

learn all_crafts 2 Syntax: .learn crafts

Learn all professions and recipes.

learn all_default 1 Syntax: .learn all_default [$playername]

Learn 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

Learn all default spells for Game Masters.

learn all_lang 1 Syntax: .learn all_lang

Learn all languages

learn all_myclass 3 Syntax: .learn all_myclass

Learn all spells and talents available for his class.

learn all_myspells 3 Syntax: .learn all_myspells

Learn all spells (except talents and spells with first rank learned as talent) available for his class.

learn all_mytalents 3 Syntax: .learn all_mytalents

Learn all talents (and spells with first rank learned as talent) available for his class.

levelup 3 Syntax: .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 and name not provided, increase your level. Command can be used for offline character. All stats and dependent VALUESrecalculated. At level decrease talents can be reset if need. Also at level decrease equipped items with greater level requirement can be lost.

linkgrave 3 Syntax: .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 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 creature 3 Syntax: .list creature #creature_id [#max_count]

Output 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 3 Syntax: .list item #item_id [#max_count]

Output items with item id #item_id found in all character inventories, mails and auctions. Output item guids, item owner guid, owner account and owner name. Will be output maximum #max_count items. If #max_count not provided use 10 as default value.

list object 3 Syntax: .list object #gameobject_id [#max_count]

Output gameobjects with gameobject id #gameobject_id found in world. Output gameobject guids and coordinates sorted by distance from character. Will be output maximum #max_count gameobject. If #max_count not provided use 10 as default value.

loadscripts 3 Syntax: .loadscripts $scriptlibraryname

Unload current and load the script library $scriptlibraryname or reload current if $scriptlibraryname omitted, in case you changed it while the server was running.

lockaccount 0 Syntax: .lockaccount [on|off]

Allow login from account only from current used IP or remove this requirement.

lookup area 1 Syntax: .lookup area $namepart

Looks up an area by $namepart, and returns all matches with their area ID�s.

lookup creature 3 Syntax: .lookup creature $namepart

Looks up a creature by $namepart, and returns all matches with their creature ID�s.

lookup event 2 Syntax: .lookup event $name
Attempts to find the ID of the event with the provided $name.

lookup faction 3 Syntax: .lookup faction $name
Attempts to find the ID of the faction with the provided $name.
lookup item 3 Syntax: .lookup item $itemname

Looks up an item by $itemname, and returns all matches with their Item ID�s.
lookup itemset 3 Syntax: .lookup itemset $itemname

Looks up an item set by $itemname, and returns all matches with their Item set ID�s.
lookup object 3 Syntax: .lookup object $objname

Looks up an gameobject by $objname, and returns all matches with their Gameobject ID�s.
lookup quest 3 Syntax: .lookup quest $namepart

Looks up a quest by $namepart, and returns all matches with their quest ID�s.
lookup skill 3 Syntax: .lookup skill $$namepart

Looks up a skill by $namepart, and returns all matches with their skill ID�s.
lookup spell 3 Syntax: .lookup spell $namepart

Looks up a spell by $namepart, and returns all matches with their spell ID�s.
lookup tele 1 Syntax: .lookup tele $substring

Search and output all .tele command locations with provide $substring in name.
maxskill 3 Syntax: .maxskill
Sets all skills of the targeted player to their maximum VALUESfor its current level.
Mod32Value 3 Syntax: .Mod32Value #field #value

Add #value to field #field of your character.
modify arena 3 Syntax: .modify arena #value
Add $amount arena points to the selected player.
name security help
modify aspeed 1 Syntax: .modify aspeed #rate

Modify 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 bit 1 Syntax: .modify bit #field #bit

Toggle the #bit bit of the #field field for the selected player. If no player is selected, modify your character.
modify bwalk 1 Syntax: .modify bwalk #rate

Modify 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 drunk 1 Syntax: .modify drunk #value
Set drunk level to #value (0..100). Value 0 remove drunk state, 100 is max drunked state.
modify energy 1 Syntax: .modify energy #energy

Modify the energy of the selected player. If no player is selected, modify your energy.
modify faction 1 Syntax: .modify faction #factionid #flagid #npcflagid #dynamicflagid

Modify the faction and flags of the selected creature. Without arguments, display the faction and flags of the selected creature.
modify honor 1 Syntax: .modify honor $amount

Add $amount honor points to the selected player.
modify hp 1 Syntax: .modify hp #newhp

Modify the hp of the selected player. If no player is selected, modify your hp.
modify mana 1 Syntax: .modify mana #newmana

Modify the mana of the selected player. If no player is selected, modify your mana.
modify money 1 Syntax:
.modify money #money
.money #money

Add or remove money to the selected player. If no player is selected, modify your money.

#gold can be negative to remove money.
modify morph 2 Syntax: .modify morph #displayid

Change your current model id to #displayid.
modify mount 1 Syntax:
.modify mount #id #speed
Display selected player as mounted at #id creature and set speed to #speed value.
modify rage 1 Syntax: .modify rage #newrage

Modify the rage of the selected player. If no player is selected, modify your rage.
modify rep 2 Syntax: .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 scale 1
modify speed 1 Syntax:
.modify speed #rate
.speed #rate

Modify 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 spell 1
modify swim 1 Syntax: .modify swim #rate

Modify 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 titles 1 Syntax: .modify titles #mask

Allows user to use all titles from #mask.
#mask=0 disables the title-choose-field

movegens 3 Syntax: .movegens
Show movement generators stack for selected creature or player.

mute 1 Syntax: .mute $playerName $timeInMinutes

Disible chat messaging for any character from account of character $playerName at $timeInMinutes minutes.

namego 1 Syntax: .namego $charactername

Teleport the given character to you.

neargrave 3 Syntax: .neargrave [alliance|horde]

Find nearest graveyard linked to zone (or only nearest from accepts alliance or horde faction ghosts).

notify 1 Syntax: .notify $MessageToBroadcast

Send a global message to all players online in screen.

npc add 2 Syntax: .npc add #creatureid

Spawn a creature by the given template id of #creatureid.

npc additem 2 Syntax: .npc additem #itemId <#maxcount><#incrtime><#extendedcost>r

Add 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 addweapon 3 Not yet implemented.
npc allowmove 3 Syntax: .npc allowmove

Enable or disable movement for the selected creature.

npc changelevel 2 Syntax: .npc changelevel #level

Change the level of the selected creature to #level.
#level may range from 1 to 63.

npc delete 2 Syntax: .npc delete

Delete the selected creature from the world.

npc delitem 2 Syntax: .npc delitem #itemId

Remove item #itemid from item list of selected vendor.

npc factionid 2 Syntax: .npc factionid #factionid

Set the faction of the selected creature to #factionid.

npc flag 2 Syntax: .npc flag #npcflag

Set 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 info 3 Syntax: .npc info

Display 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,
- and the creature type, e.g. if the creature is a vendor.

npc move 2 Syntax: .npc move [#creature_guid]

Move the targeted creature spawn point to your coordinates.

npc name 2 Syntax: .npc name $name

Change the name of the selected creature or character to $name.
Command disabled.

npc playemote 3 Syntax: .npc playemote #emoteid

Make the selected creature emote with an emote of id #emoteid.

npc setmodel 2 Syntax: .npc setmodel #displayid

Change the model id of the selected creature to #displayid.

npc setmovetype 2 Syntax: .npc setmovetype [#creature_guid] stay/random/way [NODEL]

Set 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.
Make sure you use NODEL, if you want to keep the waypoints.

npc spawndist 2 Syntax: .npc spawndist #dist

Adjust spawndistance of selected creature to dist.

npc spawntime 2 Syntax: .npc spawntime #time

Adjust spawntime of selected creature to time.

npc subname 2 Syntax: .npc subname $Name

Change the subname of the selected creature or player to $Name.

Command disabled.

npc textemote 3 Syntax: .npc textemote #emoteid

Make the selected creature to do textemote with an emote of id #emoteid.

npc whisper 1 Syntax: .npc whisper #playerguid #text
Make the selected npc whisper #text to #playerguid.

password 0 Syntax: .password $old_password $new_password $new_password

Change your account password.

pinfo 2 Syntax: .pinfo [$player_name] [rep]

Output account information for selected player or player find by $player_name. If �rep� parameter provided show reputation information for player.

Without arg show current player amount and 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

quest add 3 Syntax: .quest add #quest_id

Add 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 remove 3 Syntax: .quest remove #quest_id

Set quest #quest_id state to not completed and not active (and remove from active quest list) for selected player.

recall 1 Syntax: .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 and no player is selected, it will teleport you.

reload 3 Syntax: .reload table_name

Reload table `table_name` if reload support added for this table and this table can be _safe_ reloaded.
reload all 3 Syntax: .reload all

Reload all tables with reload support added and that can be _safe_ reloaded.
reload all_area 3 Syntax: .reload all_area

Reload all `areatrigger_*` tables if reload support added for this table and this table can be _safe_ reloaded.
reload all_loot 3 Syntax: .reload all_loot

Reload all `*_loot_template` tables. This can be slow operation with lags for server run.
reload all_quest 3 Syntax: .reload all_quest

Reload all quest related tables if reload support added for this table and this table can be _safe_ reloaded.
reload all_spell 3 Syntax: .reload all

Reload all `spell_*` tables with reload support added and that can be _safe_ reloaded.

reset all 3 Syntax: .reset all spells

Syntax: .reset all talents

Request reset spells or talents at next login each existed character.

reset honor 3 Syntax:
.reset honor [Playername]
Reset all honor data for targeted character.
reset level 3 Syntax:
.reset level [Playername]
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]
Removes all non-original spells from spellbook.
. Playername can be name of offline character.
reset stats 3 Syntax:
.reset stats [Playername]
Resets(recalculate) all stats of the targeted player to their original VALUESat current level.
reset talents 3 Syntax:
.reset talents [Playername]
Removes all talents of the targeted player. Playername can be name of offline character.

respawn 3 Syntax: .respawn

Respawn all nearest creatures and GO without waiting respawn time expiration.

revive 3 Syntax: .revive

Revive the selected player. If no player is selected, it will revive you.

save 0 Syntax: .save

Saves your character.

saveall 1 Syntax: .saveall

Save all characters in game.

security 3 Syntax: .security $name #level

Set the security level of player $name to a level of #level.

#level may range from 0 to 5.

sendmail 1 Syntax: .sendmail #playername #subject #text

Send a mail to a player. Note: subject may not contain spaces.

setskill 3 Syntax: .setskill #skill #level [#max]

Set 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.

showarea 3 Syntax: .showarea #areaid

Reveal the area of #areaid to the selected character. If no character is selected, reveal this area to you.

shutdown 3 Syntax: .shutdown seconds

Shut the server down after given seconds or cancel the shutdown if cancel value is used.

start 0 Syntax: .start

Teleport you to the starting area of your character.

taxicheat 1 Syntax: .taxicheat on/off
Temporary 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.

tele 1 Syntax: .tele #location

.tele Northrend
.tele BoreanTundra
.tele Dragonblight
.tele GrizzlyHills
.tele HowlingFjord
.tele IcecrownGlacier
.tele SholazarBasin
.tele TheStormPeaks
.tele ZulDrak
.tele dkstart
.tele alliancestart
.tele hordestart
.tele Valgarde
.tele ValianceKeep

Teleport player to a given location.

tele add 3 Syntax: .tele add $name

Add current your position to .tele command target locations list with name $name.

tele del 3 Syntax: .tele del $name

Remove location with name $name for .tele command locations list.

tele group 1 Syntax: .tele group#location

Teleport a selected player and his group members to a given location.

tele name 1 Syntax: .tele name #playername #location

Teleport a player to a given location.

ticket 2 Syntax: .ticket on
.ticket off
.ticket #num
.ticket $character_name

on/off for GMs to show or not a new ticket directly, $character_name to show ticket of this character, #num to show ticket #num.

transport 3 Not yet implemented.

unaura 3 Syntax: .unaura #spellid

Remove aura due to spell #spellid from the selected Unit.

unban 3 Syntax is: unban <account|ip|character> $NameOrIp
Unban account or IP.

unlearn 3 Syntax: .unlearn #startspell #endspell

Unlearn for selected player the range of spells between id #startspell and #endspell. If no #endspell is provided, just unlearn spell of id #startspell.

unmute 1 Syntax: .unmute $playerName

Restore chat messaging for any character from account of character $playerName.

wchange 3 Syntax: .wchange #weathertype #status

Set current weather to #weathertype with an intensity of #status.
#weathertype can be 1 for rain, 2 for snow, and 3 for sand. #status can be 0 for disabled, and 1 for enabled.

whispers 1 Syntax: .whispers on|off
Enable/disable accepting whispers by GM from players. By default use mangosd.conf setting.

wp 2 Using WP Command:
Each Waypoint Command has it�s own description!
wp add 2 Syntax: .wp add [#creature_guid or Select a Creature]
wp export 3 Syntax: .wp export [#creature_guid or Select a Creature] $filename
wp import 3 Syntax: .wp import $filename
wp modify 2 Syntax: .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)

��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:50:24 +0300

�� ?
-Micr�soft Visual Studio 2003/2005
-Tortoise SVN

��:
�� , �� .
�� "SVN Chekout..."
�� , � �� URL of repository ��
_https://mangos.svn.sourceforge.net/svnroot/mangos/trunk/
�� Accept Pernament
�� .
�� , �� win.
�� mangosdVC71 � mangosdVC80, �� Microsoft Visual studio 2003 �� mangosdVC71, �� Microsoft VS 2005 �� mangosdVC80.
�� .
��
�� , �� Build?, �� , �� , �� Batch Build.
�� , � �� . �� Release � �� Build.
��
P.S. ��
------ Build started: Project: realmd, Configuration: Debug Win32 ------
�� , ��
========== Build: 11 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========
�� .
�� , �� SVN Chekout...
� �� bin, �� Debug.
� Debug �� : libeay32.dll, libmySQL.dll, mangosd.exe, realmd.exe �MaNGOSScript.dll.
��
�� src, � �� Mangosd, �� mangosd.conf.in, �� .in, �� mangosd.conf, �� realmd �� realmd.conf.in, �� .in
��

��+��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:23:17 +0300

1.�� ( ( �� -> �� -> �� -> �� . �� IPCONFIG (�� ) �� , �� ) . �� 10.0.7.120 (�� )

2. �� realmd -> realmlist � �� -�� , �� .

3. �� . �� http://showip.com/ �� http://showip.net , �� -�� .

��:

Your IP address is 193.138.133.198

4. � �� c:/windows/system32/drivers/etc �� hosts

��

��:

���.���������.����.���   ���.�������.����

�� :

��:

10.0.7.120       193.138.133.198

�� 10.0.7.120 - ��
�� [color=yellow]1.�� ( ( �� -> �� -> �� -> �� . �� IPCONFIG (�� ) �� , �� ) . �� 10.0.7.120 (�� )
2. �� realmd -> realmlist � �� -�� , �� .

3. �� . �� http://showip.com/ �� http://showip.net , �� -�� .

��:

Your IP address is 193.138.133.198

4. � �� c:/windows/system32/drivers/etc �� hosts

��

�

��:

��.���������.����.��� ���.�������.����

�� :

��:

10.0.7.120 193.138.133.198

�� 10.0.7.120 - ��
�� 195.69.247.74 - �� (��) ��

�� , � ��
[color] - �� (��) ��

�� , � ��

��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:16:22 +0300

��
�� Designer Island.
1. �� gameobject_template.
2. �� entry � �� 400200.
3. �� + � �� , �� .
4. �� :
entry- �� 400201
type- 27 (�� 27)
displayID- �� , �� 7161-�� , 7146-�� , �� 6870 �� 39 �� smile.gif
name- �� .
faction- �� 0 �� 35 �� , 72 ��, 76 ��.
flags- �� 64 � �� -�� .�.
size- �� 1 �� .
sound0- �� areatrigger_template, �� entry, � �� 400201 �� 0.
5. �� + � �� .
6. �� .
7.�� .gps � �� , �� map, x, y, z, ��.
8. �� areatrigger_template � �� .
9. �� :
id- �� sound0.
name- �� .
required_level- �� .
trigger_map-0
trigger_position_x-0
trigger_position_y-0
trigger_position_z-0
target_map- �� 451
target_position_x- �� 16303,5
target_position_y- �� y �� -16173,5
target_position_z- �� z �� 40,4365
target_orientation-�� 0.
10. �� 5 � �� .
11. �� .addgo �� entry.
12. �� Designer Island.

[extendedCost]��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:15:34 +0300

�� , �� , �� .�. �� , �� .�.. �� , �� :

1)�� (��) �� `mangos`->`item_template`:
BuyPrice - ��
SellPrice - �� .

�� : �� , �� , �� ...
2) �� (�� ) �� `mangos`->`npc_vendor`->extendedCost. �� 0 - �� `item_template`, �� dbc. � �� extendedCost, �� ItemExtendedCost.dbc �� Quice. �� : �� (�� wowhead.com) � �� .

�� , �� :

��:

update `npc_vendor` set `extendedCost`=0 where `extendedCost`>0;

Download --.sql

2.4.3 � ��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:12:59 +0300

��
1. �� 2 ��. �� Mangos(�� 2.4.3) � WotLK(�� 3.0.3).
2. �� mangos �� , �� 2.4.3
3. �� WotLK �� , �� 3.0.23
4. � MySQL �� 3 �� , �� - Mangos(�� 2.4.3), WotLK(�� 3.0.3) � realmd.
5. � mangos �� 2.4.3
6. � WotLK �� 3.0.3.
7. �� Mangos � WotLK �� mangosd.conf �� .
6. �� realmd �� realmlist, �� , �� :
��:
ID Name Address Port icon color timezone
1 server 2.4.3 127.0.0.1 8085 1 1 1
2 WotLK 3.0.3 127.0.0.1 8086 1 1 1
7. �� realmd.conf, � WotLK. ��, ��
RealmServerPort = 3724(�� , �� 37240)
8. �� mangos.conf,� �� WotLK. ��, �� WorldServerPort = 8085(�� 8086)
RealmID = 1 (�� 2)
9. �� mangos.exe � realmd.exe �� .

� �� .
1 �� 2.4.3: mangos �� 8085, realmd �� 3724, � 1 ID � ��. �� mangos
2 �� 3.0.3: mangos �� 8086, realmd �� 37240, � 2 ID � ��. �� WotLK

��:
�� 2.4.3 �� .
�� 3.0.3 �� , � �� :37240 �� :
��:
Set realmlist 127.0.0.1:37240
��:
�� , �� WTF

�� NPC

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:11:40 +0300

[c] �� Spell.dbc [/c]

.�� DBC-CSV...
.� �� spell.dbc � �� DBC-CSV.
.�� DBC-CSV.bat.
.�� spell.dbc.csv
.�� , �� 17609, �� , � ��
.�� : Portall effect orgrimmar - ��
.��, �� spell.dbc(2 ��) � �� CSV-DBC.bat (� �� DBC-CSV ��)
�� spell.dbc - �� dbc...

[c]�� .[/c]

.�� mangos,�� areatrigger_template.
�� .
.��:

id - ��, ��

(.�� , �� 17609, �� , � �� )

name - �� .
required_level - �� .

�� NPC:
target_map
target_position_x
target_position_y
target_position_z
target_orientation
�� .gps � ��.

�� .

��.

[c]�� (NPC)[/c]

.�� , �� mangos, �� creature_template... �� , �� (�� Insert, �� + �� )
.�� :

entry - �� NPC
modelid_A - �� NPC
modelid_H - �� NPC
name - �� NPC.
subname - ��
minlevel - ��
maxlevel - ��
minhealth - �� -��
maxhealth - ��
faction_A - ��
faction_H - ��
npcflag - 2

� ��

[c]�� (��)[/c]

�� mangos,�� quest_template
�� .
�� :

Entry - ��
ZoneOrSort - 141
MinLevel - �� , �� ...
QestLevel - �� . ��
RequiredSkillValue - 0
Title - ��
RewSpell - �� , ��

�� mangos � �� creature_questrelation, �� .(�� ).

Repeatable - 1

��

[c]�� (�� NPC) [/c]

�� mangos � �� creature_questrelation, �� .

��.

id - �� NPC, �� .
quest - �� ..

�� creature_involvedrelation.

�� .

�� ?

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:11:04 +0300

�� ?
�� . �� !
� �� . �� ?
�� !
��. �� ! �� (��). �� . �� .
�� ?
�� :
1 �� (� ��)
2 �� (18103) �� (16222) �� (174559) - ��
(11078) - ��.
� �� ?
�� .�� (��: �� !).
�� (�� )
� �� !
�� :
.addgo �� .go spawn (�� )
.additem (�� )
.addspw (�� )
�� go http://www.wowdata.ru !
�� . � �� !

No-Ip ��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:07:53 +0300

�� , �� No-IP �� :

1. �� no-ip
2. �� e-mail
3. ��
4. �� , �� Control Panel
5. �� Add Domain
6. � �� :
7. Hostname - �� , � �� server.wow
8. �� Host Type - �� . � �� no-ip.org<�� , �� "ru" �� , �� .>
�� , �� Create Host
9. �� , ��
10. ��
11. �� , ��
12. ��
13. ��

�� , �� .

�� SQL ��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:07:27 +0300

��!

1. �� Navicat
2. ��
3. �� , � �� (�� mangos �� wotlkmangos)
4. ��
5. �� Exucute Batch File...
6. �� SQL ��
7. �� Start
8. �� , �� ...Successfull (�� - �� , ��)

�� 3.0.� � 33 ��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:06:53 +0300

��!

1. �� Wotlk 3.0.�
2. ��
3. �� Home
4. �� , �� Home �� IP ��
5. ��
6. �� www
7. �� IP ��
8. �� denwer
9. �� run.exe
10. �� Navicat
11. �� Connection
12. � �� Connection Name �� (��)
13. � �� Host name/IP Adress ��
14. � �� Port ��
15. � �� Username �� (� �� root �� mangos)
16. � �� Password �� (� �� mangos)
17. �� Test Connection
18. �� Connection Successfull, �� Save Password
19. ��
20. ��
21. �� realmd
22. �� realmlist
23. � �� realmlist �� name
24. � ��
25. �� adress �� IP ��
26. �� (�� )
27. ��
28. �� MaNGOS
29. ��
30. �� dbc, �� maps
31. �� dbc � maps � �� MaNGOS
32. �� run.exe �� , ��
33. �� MaNGOS �� realmd.exe, �� mangosd.exe

�� NPC �� Quice

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 12:06:26 +0300

� ��! ��!

1. �� Quice.
2. �� Creature
3. �� Creature Template
4. � �� Entry �� ID �� NPC (�� 8563957)
5. � �� Name �� (� �� Luthor)
6. � �� SubName �� , �� , �� (�� )
7. �� Modelid_A �� (� �� 19725)
8. � �� Modelid_H �� (� �� 20559)
9. � �� mingold � maxgold �� npc (�� )
10. � �� minlevel �� npc
11. � �� maxlevel �� npc
12. �� minmana � maxmana ��
13. � �� mindamag �� npc ��
14. � �� maxdamag �� npc ��
15. � �� Faction_A � Faction_H �� npc (�� , �� 35)
16. � �� npcflag �� , �� npc
17. �� Armor-Speed
18. � �� Armor �� npc
19. � �� Speed �� , � �� npc (�� 1 �� 10)
20. � �� Scale �� npc (1-15)
21. �� (� �� - �� , ��)
22. �� Show Creature Template Script
23. ��
24. �� , �� .sql
25. �� .

�� NPC �� Quice �� NPC!

��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 11:19:06 +0300

�� -�� , �� , � �� , �� (� �� "0")
� �� .
��!
�� , �� mangos, �� command
� �� mangos
�� , �� baninfo �� , �� , �� security �� 3 �� 1 (1 - �� , 2- �� 3 - �� )
��(�� )
� ��! �� baninfo �� '��!
�� !
��!
�� , ��!

��

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 11:18:36 +0300

�� (� �� ) �� , �� , �� , �� ...
�� , �� , �� , �� , �� , � �� , � �� , � �� .
�� , �� .
�� , �� .
�� , �� , �� . �� 30 ��, �� , �� .
�� .....�� "��" � �� , �.� � �� .
�� ip, �� . �� Ucoz, �� wow(�� ) �� ucoz �� , �� , �� ucoz �� .
�� :

�� , �� . �� , � �� , � �� . ��! � �� , � �� !

�� mangos � Hamachi

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 11:17:32 +0300

�� , �� , �� ...
��, �� .
=========================================================================

�� Mangos by KAPATEJIb � Hamachi
(I) Hamachi
�� ip � �� , �� hamachi �� ip!
�� .
1) �� ;
2)�� ;
3)��;
4)��
- Configure Hamachi (�� )
- �� Perferences
- � �� Change Nickname
- ��
- �� "��"
5)��
- �� "Create or join NetWorks
- �� "Create a new network.."
- � �� , �� ;
- �� , �� "Create"
- �� !
6)�� ip (�� ...�� 5.5.109.55)
�� (II) (Hamachi �� biggrin )
(II)��

[1] - �� C:\Server (�� ).
==================================================
[2] - � �� C:\Server\Mangos �� dbc_maps_vmap-extractor, �� 3 ��, �� vmap_assembler.exe, �� , �� [1] �� :\Server\Mangos, �� [2] �� Dbc � �� :\Server\Mangos, �� [3] �� Vmaps �� 1,76 �� :\Server\Mangos.
==================================================
[3] - �� C:\Server\home\xxx.xxx.xxx.xxx\www � �� account.php ��
$server = "xxx.xxx.xxx.xxx"; �� $server = "�� ip (�� (I) )".
==================================================
[4] - �� C:\Server\home\ � ��
(�� IP) �� ip (�� (I))
� �� .
==================================================
[5] - ��!!! �� MYSQL �� > ��> ��= mysql-nt �� mysql-max �� !
==================================================
[6] - �� C:\Server\ect �� Run.exe �� ... �� , � �� 2 �� (Mysql-M�x � Apache) �� !!!
==================================================
[7] - �� Navicat, �� Program Files, �� .
==================================================
[8] - �� Navicat:
��:
8.1) �� C:\Server\ect\ � �� Run.exe!
8.2) �� Navicat �� Connections
8.3) ��

1 (Connection Name)
2 (Host name/IP address)
3 (Port)
4 (User name)
5 (Password)

� ��

1) Connection Name - ��
----------------------
2)Host name/IP address - ��
----------------------
3)Port - ��
----------------------
4) User name - mangos
----------------------
5) Password - mangos
----------------------
8.4) �� .
----------------------
8.5) �� (Test Connections)
----------------------
8.6) �� (Test Connections)
----------------------
8.7) �� (Connection Successful) �� .
----------------------
6) �� 1) ��
----------------------
7) �� realmd �� reamlist �� Adress �� ip(�� I), �� IP(��) � �� , P.S. �� Navicatom � �� !!!.
�� ACCOUNT's �� http://��_Ip/index.php.
==================================================
7.1) � ��
�� Apache, Mysql � Navicat �� Navicat,
�� realmd
�� realmlist, �� dbinfo, �� localhost;3306;mangos;mangos;characters � ��

P.S. ��
==================================================
[9] - �� . �� >>> �� C:\Server\usr\local\mysql4\data � �� Forum, �� C:\Server\home\�� IP\www � �� Forum � �� , �� upload �� http://��IP/Forum/install � �� Forum �� C:\Server\usr\local\mysql4\data, ��
==================================================
[9.1] - �� .
�� C:\Server\usr\local\php5 �� php.ini
�� memory_limit = 8M ; Maximum amount of memory a script may consume (8MB)
� �� memory_limit = 15M ; Maximum amount of memory a script may consume (15MB)

P.S. �� !
==================================================
[10] - �� C:\Server\Mangos mangosd.conf � �� (�� , �� ) �� .
==================================================
[11] - �� !!! ��
Microsoft .Net Framework.v.2.0 .
==================================================
[12] - C:\Server\MaNGOS �� MaNGOS.exe � �� !!! �� ... �� reamlist.wft �� -�� !!!
================================================== ================
[13] - �� http://localhost �� !!!
================================================== ================
[14] - � �� C:\Server\etc\ �� >>> menu.exe �� : (��
�� (set userDir=D:\Server) �� (set userDir=C:\Server)
(�� ).
(� �� D:\)
==================================================
[14.1] - +�� MDBT (�� Run.exe � �� MDBT)!!!
P.S. �� !
�.�. ��, �� , �� , �� , � �� !
==================================================
Tnx KAPATEJIb and creators of UDB.
Compiled with Microsot Visual Studio 2005 by KAPATEJIb, UDB Revs DB.
�� mangos.ru , �� Hamachi �� (pro100Witya)!
� pro100Witya. �� . �� .
� �� - ��!

�� Full Version Database

mybb@mybb.ru (Watching) — Fri, 09 Jan 2009 11:05:59 +0300

23 �� Ideal Database!

Ideal Mangos DataBase

������ WOW

SVN

Gm comand mangos Wotlk en

���������� ����

�������+����

�������� ������ �������

[extendedCost]������� ������ �� ���� � ��������

2.4.3 � ��� ���� �� ����� �������

������� ���������� NPC

��� ������� ����� ���� ?

No-Ip ������� ������

��� �������� SQL ����� � ���� ������

��������� �������� ������� 3.0.� � 33 ����

������� NPC ����� Quice

������������� ����

������ ���������� �������

��������� �������� ������� mangos � Hamachi

���� Full Version Database

�� WOW

��

��+��

��

[extendedCost]��

2.4.3 � ��

�� NPC

�� ?

No-Ip ��

�� SQL ��

�� 3.0.� � 33 ��

�� NPC �� Quice

��

��

�� mangos � Hamachi

�� Full Version Database