Jump to content
  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
MesoX

[Návod] Jak na accounty?

Recommended Posts

1) Otevřeme si Navicat a vybereme databázi kde máme char a logon tabulky a otevřeme tabulku accounts

acc_gm1a.PNG

 

2) Do políčka GM flags doplníme písmenka podle toho jakou skupinu chceme danému accountu uvolnit (az = admin, a = včechny skupiny mimo skupiny z )

 

GM flagy

 

 

-------------------------------------------------------------------------------------------

| Command |flag|

-------------------------------------------------------------------------------------------

| masssummon | z | .masssummon - Summons all players. |

| commands | h | Shows Commands |

| help | h | Shows help for command |

| announce | u | Sends Msg To All |

| wannounce | u | Sends Widescreen Msg To All |

| appear | v | Teleports to xs position. |

| summon | v | Summons x to your position |

| banchar | b | Bans character x with or without reason |

| unbanchar | b | Unbans character x |

| kick | b | Kicks player from server |

| kill | r | .kill - Kills selected unit. |

| killplr | r | .killplr <name> - Kills specified player |

| revive | r | Revives you. |

| reviveplr | r | Revives player specified. |

| demorph | m | Demorphs from morphed model. |

| mount | m | Mounts into modelid x. |

| dismount | h | Dismounts. |

| gm | p | Shows active GMs |

| gmoff | t | Sets GM tag off |

| gmon | t | Sets GM tag on |

| gps | p | Shows Position |

| info | p | Server info |

| worldport | v | mapid x y z o |

| save | s | Saves your character |

| saveall | s | Saves all playing characters |

| start | m | Teleports you to a starting location |

| additem | m | Adds item by item ID, optional count |

| removeitem | m | Removes item u count u. |

| invincible | j | .invincible - Toggles INVINCIBILITY (mobs wont attack you) |

| invisible | i | .invisible - Toggles INVINCIBILITY and INVISIBILITY |

| resetreputation | n | Resets reputation to start levels. |

| resetspells | n | Resets all spells to starting spells of targeted player |

| resettalents | n | Resets all talents of targeted player |

| resetskills | n | .resetskills - Resets all skills. |

| learn | m | Learns spell |

| unlearn | m | Unlearns spell |

| getskilllevel | m | Gets the current level of a skill |

| getskillinfo | m | Gets all the skills from a player |

| learnskill | m | <skillid> [value] [maxvalue] - Learns skill id skillid. |

| advanceskill | m | advanceskill [skillid] [amount] |

| removeskill | m | .removeskill [skillid] - Removes skill by id |

| increaseweaponskill | m | Increase eqipped weapon skill x times (defaults to 1). |

| createaccount | z | Creates account. [username] [password] |

| playerinfo | m | Displays informations about the selected character |

| getpos | d | |

| clearcooldowns | m | Clears all cooldowns for your class. |

| removeauras | m | Removes all auras from target |

| paralyze | b | Roots/Paralyzes the target. |

| unparalyze | b | Unroots/Unparalyzes the target. |

| setmotd | m | Sets MOTD |

| additemset | m | Adds item set to inv. |

| gotrig | v | Warps to areatrigger [id] |

| exitinstance | m | Exits current instance |

| reloadtable | m | Reloads some of the database tables |

| servershutdown | z | Initiates server shutdown in seconds. |

| serverrestart | z | Initiates server restart in seconds. |

| allowwhispers | c | Allows whispers from player while in gmon mode. |

| blockwhispers | c | Blocks whispers from player while in gmon mode. |

| advanceallskills | m | Advances all skills points. |

| killbyplayer | f | Disconnects the player with name . |

| killbyaccount | f | Disconnects the session with account name . |

| castall | z | Makes all players online cast spell [x]. |

| dispelall | z | Dispels all negative (or positive w/ 1) auras on all players.|

| castspell | d | .castspell [spellid] - Casts spell on target. |

| modperiod | m | Changes period of current transporter. |

| npcfollow | m | Sets npc to follow you |

| nullfollow | m | Sets npc to not follow anything |

| formationlink | m | Sets formation master. |

| formationlink | m | Sets formation slave with distance and angle |

| formationclear | m | Removes formation from creature |

| playall | z | Plays a sound to the entire server. |

| addipban | m | Adds an address to the IP ban table [address] [duration] |

| delipban | m | Deletes an address from the IP ban table [address] |

| renamechar | m | Renames character x to y. |

| forcerenamechar | m | Forces character x to rename his char next login |

| getstanding | m | Gets standing of faction u. |

| setstanding | m | Sets stanging of faction u. |

| lookupitem | l | Looks up item string x. |

| lookupquest | l | Looks up quest string x. |

| lookupcreature | l | Looks up item string x. |

| changepassword | z | Changes your accounts password. |

| rehash | z | Reloads config file. |

| createarenateam | g | Creates arena team |

| whisperblock | g | Blocks like .gmon except without the [GM] tag |

| logcomment | 1 | Adds a comment to the GM log for the admins to read. |

| showitems | m | test for ItemIterator |

| testlos | m | tests los |

| testindoor | m | tests indoor |

| getheight | m | Gets height |

| renameallinvalidchars| z | Renames all invalid character names |

| removesickness | m | Removes ressurrection sickness from the target |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.modify

-------------------------------------------------------------------------------------------

| hp | m | Health Points/HP |

| mana | m | Mana Points/MP |

| rage | m | Rage Points |

| energy | m | Energy Points |

| level | m | Level |

| armor | m | Armor |

| holy | m | Holy Resistance |

| fire | m | Fire Resistance |

| nature | m | Nature Resistance |

| frost | m | Frost Resistance |

| shadow | m | Shadow Resistance |

| arcane | m | Arcane Resistance |

| damage | m | Unit Damage Min/Max |

| scale | m | Size/Scale |

| gold | m | Gold/Money/Copper |

| speed | m | Movement Speed |

| nativedisplayid | m | Native Display ID |

| displayid | m | Display ID |

| flags | m | Unit Flags |

| faction | m | Faction Template |

| dynamicflags | m | Dynamic Flags |

| talentpoints | m | Talent Points |

| happiness | m | Happiness |

| spirit | m | Spirit |

| boundingraidius | m | Bounding Radius |

| combatreach | m | Combat Reach |

| emotestate | m | NPC Emote State |

| bytes | m | Bytes |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.debug

-------------------------------------------------------------------------------------------

| infront | d | |

| showreact | d | |

| aimove | d | |

| dist | d | |

| face | d | |

| moveinfo | d | |

| setbytes | d | |

| getbytes | d | |

| unroot | d | |

| root | d | |

| landwalk | d | |

| waterwalk | d | |

| castspellne | d | Casts a spell without applying effects |

| aggrorange | d | .aggrorange Shows aggro Range of the selected Creature. |

| knockback | d | .knockback <value> Knocks you back. |

| fade | d | .fade <value> calls ModThreatModifyer. |

| threatMod | d | .threatMod <value> calls ModGeneratedThreatModifyer. |

| calcThreat | d | .calcThreat <dmg> <spellId> calculates threat. |

| threatList | d | returns all AITargets of the selected Creature. |

| gettptime | d | grabs transporter travel time |

| itempushresult | d | sends item push result |

| setbit | d | |

| setvalue | d | |

| aispelltestbegin | d | |

| aispelltestcontinue | d | |

| aispelltestskip | d | |

| dumpcoords | d | |

| sendpacket | d | <opcode ID> |

| sqlquery | d | <sql query> |

| rangecheck | d | Shows yard and internal range for distance |

| setallratings | d | Sets rating values to incremental numbers based on index |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.waypoint

-------------------------------------------------------------------------------------------

| add | w | Add wp at current pos |

| show | w | Show wps for creature |

| hide | w | Hide wps for creature |

| delete | w | Delete selected wp |

| movehere | w | Move to this wp |

| flags | w | Wp flags |

| waittime | w | Wait time at this wp |

| emote | w | Emote at this wp |

| skin | w | Skin at this wp |

| change | w | Change at this wp |

| info | w | Show info for wp |

| movetype | w | Movement type at wp |

| generate | w | Randomly generate wps |

| save | w | Save all waypoints |

| deleteall | w | Delete all waypoints |

| addfly | w | Adds a flying waypoint |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.gobject

-------------------------------------------------------------------------------------------

| select | o | Selects the nearest GameObject to you |

| delete | o | Deletes selected GameObject |

| spawn | o | Spawns a GameObject by ID |

| info | o | Gives you informations about selected GO |

| activate | o | Activates/Opens the selected GO. |

| enable | o | Enables the selected GO for use. |

| scale | o | Sets scale of selected GO |

| animprogress | o | Sets anim progress |

| export | o | Exports the current GO selected |

| move | g | Moves gameobject to player xyz |

| rotate | g | Rotates gameobject x degrees |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.battleground

-------------------------------------------------------------------------------------------

| setbgscore | e | <Teamid> <Score> - Sets battleground score. 2 Arguments. |

| startbg | e | Starts current battleground match. |

| pausebg | e | Pauses current battleground match. |

| bginfo | e | Displays information about current battleground. |

| battleground | e | Shows BG Menu |

| setworldstate | e | <var> <val> - Var can be in hex. WS Value. |

| playsound | e | <val>. Val can be in hex. |

| setbfstatus | e | .setbfstatus - NYI. |

| leave | e | Leaves the current battleground. |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.npc

-------------------------------------------------------------------------------------------

| vendoradditem | n | Adds to vendor |

| vendorremoveitem | n | Removes from vendor. |

| flags | n | Changes NPC flags |

| emote | n | .emote - Sets emote state |

| delete | n | Deletes mob from db and world. |

| info | n | Displays NPC information |

| addAgent | n | See [[ai_agent]] |

| listAgent | n | .npc listAgent |

| say | n | .npc say <text> - Makes selected mob say text <text>. |

| yell | n | .npc yell <Text> - Makes selected mob yell text <text>. |

| come | n | .npc come - Makes npc move to your position |

| return | n | .npc return - Returns ncp to spawnpoint. |

| spawn | n | .npc spawn - Spawns npc of entry <id> |

| spawnlink | n | .spawnlink sqlentry |

| possess | n | .npc possess - Possess an npc (mind control) |

| unpossess | n | .npc unpossess - Unposses any currently possessed npc. |

| select | n | .npc select - selects npc closest |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.cheat

-------------------------------------------------------------------------------------------

| status | m | Shows active cheats. |

| taxi | m | Enables all taxi nodes. |

| cooldown | m | Enables no cooldown cheat. |

| casttime | m | Enables no cast time cheat. |

| power | m | Disables mana consumption etc. |

| god | m | Sets god mode preventing you from taking damage. |

| fly | m | Sets fly mode |

| land | m | Unsets fly mode |

| explore | m | Reveals the unexplored parts of the map. |

| flyspeed | m | Modifies fly speed. |

| stack | m | Enables aura stacking cheat. |

| triggerpass | m | Ignores area trigger prerequisites. |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.honor

-------------------------------------------------------------------------------------------

| addpoints | m | Adds x amount of honor points/currency |

| addkills | m | Adds x amount of honor kills |

| globaldailyupdate | m | Daily honor field moves |

| singledailyupdate | m | Daily honor field moves for selected player only |

| pvpcredit | m | Sends PVP credit packet |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.pet

-------------------------------------------------------------------------------------------

| createpet | m | Creates a pet with <entry>. |

| renamepet | m | Renames a pet to <name>. |

| addspell | m | Teaches pet <spell>. |

| removespell | m | Removes pet spell <spell>. |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.recall

-------------------------------------------------------------------------------------------

| list | q | List recall locations |

| port | q | Port to recalled location |

| add | q | Add recall location |

| del | q | Remove a recall location |

| portplayer | m | recall ports player |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.quest

-------------------------------------------------------------------------------------------

| addboth | 2 | Add quest <id> to the targeted NPC as start finish |

| addfinish | 2 | Add quest <id> to the targeted NPC as finisher |

| addstart | 2 | Add quest <id> to the targeted NPC as starter |

| delboth | 2 | Delete quest <id> from the targeted NPC as start finish |

| delfinish | 2 | Delete quest <id> from the targeted NPC as finisher |

| delstart | 2 | Delete quest <id> from the targeted NPC as starter |

| complete | 2 | Complete/Finish quest <id> |

| finisher | 2 | Lookup quest finisher for quest <id> |

| item | 2 | Lookup itemid necessary for quest <id> |

| list | 2 | Lists the quests for the npc <id> |

| load | 2 | Loads quests from database |

| lookup | 2 | Looks up quest string x |

| giver | 2 | Lookup quest giver for quest <id> |

| remove | 2 | Removes the quest <id> from the targeted player |

| reward | 2 | Shows reward for quest <id> |

| status | 2 | Lists the status of quest <id> |

| spawn | 2 | Port to spawn location for quest <id> |

| start | 2 | Starts quest <id> |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.account

-------------------------------------------------------------------------------------------

| ban | a | Ban account. .account ban name timeperiod |

| unban | z | Unbans account x. |

| create | z | Create account. Pass it username password email. |

| email | z | Sets email address on account. Pass it username emailaddress |

| flags | z | .account flags <username> <flags> 0 = normal 8 = TBC |

| level | z | Sets gm level on account. Pass it username and GM flags |

| password | z | Sets password on account. Pass it username password. |

| mute | a | Mutes account for <timeperiod>. |

| unmute | a | Unmutes account <x> |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.guild

-------------------------------------------------------------------------------------------

| create | m | Creates a guild. |

| rename | m | Renames a guild. |

| members | m | Lists guildmembers and their ranks. |

| removeplayer | m | Removes a player from a guild. |

| disband | m | Disbands the guild of your target. |

-------------------------------------------------------------------------------------------

 

-------------------------------------------------------------------------------------------

.gmticket

-------------------------------------------------------------------------------------------

| get | c | Gets GM Ticket |

| getId | c | Gets GM Ticket by ID |

| delId | c | Deletes GM Ticket by ID |

-------------------------------------------------------------------------------------------

 

Share this post


Link to post
Share on other sites

Dobrá práce, snižuju ti warn a kdybys byl tak laskav a dal to do wiki, tak by to bylo ještě lepší. :)

Share this post


Link to post
Share on other sites
Sign in to follow this  

×