Make a GM account using Navicat. menu

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    Daxo's Avatar Member
    Reputation
    23
    Join Date
    Jul 2007
    Posts
    257
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Make a GM account using Navicat.

    Well basically i broke my GM account on my own server and i was looking on this site and i couldent find a guide on how to make a gm account.

    Step one : Open your main DB is Navicat/Mysql
    Step two : Find the table called "Account" and open it.
    Step three : Change account to 1 if its your first account and if its your 2nd account change it to 2 so on....
    Step four : Change login into your desired account name.
    Step five : Change Password to your desired password.
    Step six : Change GM into az ( i have no clue why but it gives you admin )
    Step Seven : DO NOT DO ANYTHING to Banned, Lastlogin, lastip
    Step Eight : Removed because its a worthless step!
    Step nine : Change flag into 8 if you want it BC and 0 for normal wow


    DONE!
    Please leave comments if you cant understand and ill try to tell you again.
    Last edited by Daxo; 11-03-2007 at 05:31 PM.

    If you need any Emu server help PM me and i will do my best to help you.

    Make a GM account using Navicat.
  2. #2
    Kimahri's Avatar Member
    Reputation
    17
    Join Date
    Apr 2007
    Posts
    31
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Thanks for this mate!

  3. #3
    Dojob020's Avatar Member
    Reputation
    1
    Join Date
    Jul 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    So is this actually for Live servers or just Emu?...

  4. #4
    Errage's Avatar Contributor Authenticator enabled
    Reputation
    94
    Join Date
    Jan 2007
    Posts
    2,832
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    This is for Emulation Servers, so you're in the wrong section
    I used to be a Super Mod. Now I'm just Super, thanks for asking.

  5. #5
    Dragut's Avatar Member
    Reputation
    4
    Join Date
    Aug 2007
    Posts
    110
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Anyone know what to put if you want the GM to be a lower lvl, like just a normal GM instead of Admin?

  6. #6
    The_Zealot's Avatar Member
    Reputation
    45
    Join Date
    May 2007
    Posts
    154
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Ranks for GMs: 1,2,3,az
    Flags: 0 = Normal 8= TBC

  7. #7
    Dragut's Avatar Member
    Reputation
    4
    Join Date
    Aug 2007
    Posts
    110
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Originally Posted by Zealot94 View Post
    Ranks for GMs: 1,2,3,az
    Flags: 0 = Normal 8= TBC
    Thanks alot. +rep

  8. #8
    imfamous08's Avatar Member
    Reputation
    1
    Join Date
    Sep 2007
    Posts
    9
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    hey dude i need HELP i went to navicat and put everything in but it didnt register it to my server.. what do i do?

  9. #9
    lilsavalex's Avatar Member
    Reputation
    6
    Join Date
    Jan 2007
    Posts
    85
    Thanks G/R
    0/0
    Trade Feedback
    2 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Deleted old thread.
    Last edited by lilsavalex; 07-03-2022 at 08:55 PM.

  10. #10
    supakilla's Avatar Member
    Reputation
    1
    Join Date
    Sep 2007
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    I cant find the Flag thingy :S

  11. #11
    imfamous08's Avatar Member
    Reputation
    1
    Join Date
    Sep 2007
    Posts
    9
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    i really need help guys i make a gm account but when i go and try to login to it, it doesnt even say its an account. someone please help. itll will be a good server already got vendors just need to know how to make accounts if someone helps me i will make them gm on my server btw(hamachi)

  12. #12
    XPZaIN's Avatar Member
    Reputation
    1
    Join Date
    Sep 2006
    Posts
    86
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Originally Posted by Zealot94 View Post
    Ranks for GMs: 1,2,3,az
    Flags: 0 = Normal 8= TBC
    That is not true...
    antrix/ascent is based on flags rather than levels...

    Here is a post made by Jerkstore... I DO NOT TAKE ANY CREDIT

    Afternoon project: create a complete list of GM commands.
    This list was pulled directly from the Antrix r77 sources (src/game/chat.cpp). The command descriptions are (almost) exactly as they appear in that file, except more user-friendly.

    GM commands can be executed either with the ! or . character. e.g., !kill and .kill have the same effect.

    MaNGOS users will be familiar with the concept of the command table -- a good number of these commands cannot be executed themselves; they must be done through their "parent" command. For example: you do not type .gold 7000, you would type .modify gold 7000. Similarly, you would type .battleground leave instead of .leave to use the 'leave' command under the '.battleground' set.

    Let me repeat: If a command under a certain heading is not working by itself, the first thing you should try is looking for the "Main [type] command table" under that command's heading in this list.




    To enable all GM abilities, set your GM flags to ‘az’ in your accounts table (thanks elmis!). This is not necessarily recommended! To enable sub-sets of these abilities, use the appropriate letters, enclosed in brackets next to each heading.

    For instance, setting the flags to 'egpt' would make a GM who can only answer Tickets and administrate the battlegrounds.

    Banstick Commands [b]
    banchar: Bans character x with or without reason
    unbanchar: Unbans character x
    kick: Kicks player from server
    paralyze: Roots/Paralyzes the target.
    unparalyze: Unroots/Unparalyzes the target.

    Chat Control [c]
    allowwhispers: Allows whispers from player <s> while in gmon mode.
    blockwhispers: Blocks whispers from player <s> while in gmon mode.

    Debug Commands [d]
    debug: Main ‘debug’ command table. Usage: .debug <subcommand> <args>
    infront: No description entered.
    showreact: No description entered.
    aimove: No description entered.
    dist: No description entered.
    face: No description entered.
    moveinfo: No description entered.
    setbytes: No description entered.
    getbytes: No description entered.
    unroot: No description entered.
    root: No description entered.
    landwalk: No description entered.
    waterwalk: No description entered.
    castspell: .castspell <spellid> - Casts spell on target.
    castspellne: .castspellne <spellid> - Casts spell on target (only plays animations, doesnt handle effects or range/facing/etc.
    celldelete: USE WITH CAUTION! '.celldelete YES' - Removes everything in current cell from game and database. '.celldelete YES YES' removes everything in a range of 1cell.
    addrestxp: .addrestxp - Adds x rest XP to player.
    generatename: .generatename - Generates name for pet, etc.
    attackerinfo: .attackerinfo - Shows selected mob/player's attacker's infomation.
    showattackers: .showattackers - Shows selected mob/player's attacker on the minimap.
    aggrorange: .aggrorange - Shows aggro Range of the selected Creature.
    knockback : .knockback <value> - Knocks you back.
    fade : .fade <value> - calls ModThreatModifyer().
    threatMod : .threatMod <value> - calls ModGeneratedThreatModifyer().
    calcThreat : .calcThreat <dmg> <spellId> - calculates threat.
    threatList : .threatList - returns all AI_Targets of the selected Creature.
    gettptime: grabs transporter travel time
    itempushresult: sends item push result
    weather: No description entered.
    setbit: No description entered.
    setvalue: No description entered.
    getpos: No description entered.

    Battlegrounds Commands [e]
    battleground: Main BG command table. Usage: .battleground <subcommand> <args>
    setbgscore: <Teamid> <Score> - Sets battleground score. 2 Arguments.
    startbg: Starts current battleground match.
    pausebg: Pauses current battleground match.
    bginfo: Displays information about current battleground.
    battleground: Shows BG Menu
    setworldstate: <var> <val> - Var can be in hex. WS Value.
    playsound: <val>. Val can be in hex.
    setbfstatus: .setbfstatus – Not Yet Implemented.
    leave: Leaves the current battleground.

    Extended Debug Commands? [f]
    killbyplayer: Disconnects the player with name <s>.
    killbyaccount: Disconnects the session with account name <s>.
    getrate: Gets rate <x>.
    setrate: Sets rate <x>.

    GM Ticket Commands [g]
    gmTicket: Main GM ticket system command table. Usage: .gmTicket <subcommand> <args>
    get: Gets GM Ticket
    getId: Gets GM Ticket by ID
    delId: Deletes GM Ticket by ID

    Invincibility Command [j]
    invincible: .invincible - Toggles INVINCIBILITY (mobs won't attack you)

    Invisibility Command [i]
    invisible: .invisible - Toggles INVINCIBILITY and INVISIBILITY (mobs won't attack you and nobody can see you, but they can see your chat messages)

    Guild Commands [l]
    createguild: No description entered.

    Modify commands [m]
    modify: Main stat-modification command table. Usage: .modify <subcommand> <args>
    hp: Health Points/HP
    mana: Mana Points/MP
    rage: Rage Points
    energy: Energy Points
    armor: Armor
    holy: Holy Resistance
    fire: Fire Resistance
    nature: Nature Resistance
    frost: Frost Resistance
    shadow: Shadow Resistance
    arcane: Arcane Resistance
    damage: Unit Damage Min/Max
    scale: Size/Scale
    gold: Gold/Money/Copper
    speed: Movement Speed
    nativedisplayid: Native Display ID
    displayid: Display ID
    flags: Unit Flags:
    faction: Faction Template
    dynamicflags: Dynamic Flags
    talentpoints: Talent Points
    loyalty: Loyalty
    spirit: Spirit
    boundingraidus: Bounding Radius
    combatreach: Combat Reach
    emotestate: NPC Emote State

    More Modify Commands [m]
    createaccount: .createaccount - Creates account. Format should be .createaccount username password email
    playerinfo: .playerinfo - Displays informations about the selected character (account...)
    mount: Mounts into modelid x.
    dismount: Dismounts.
    start: Teleport's you to a starting location
    levelup: No description entered.
    additem: No description entered.
    removeitem: Removes item %u count %u.
    learn: Learns spell
    unlearn: Unlearns spell
    learnskill: .learnskill <skillid> (optional) <value> <maxvalue> - Learns skill id skillid.
    advanceskill: advanceskill <skillid> <amount, optional, default = 1> - Advances skill line x times..
    removeskill: .removeskill <skillid> - Removes skill
    increaseweaponskill: .increaseweaponskill <count> - Increase eqipped weapon skill x times (defaults to 1).
    removeauras: Removes all auras from target
    setmotd: Sets MOTD
    additemset: Adds item set to inv.
    gotrig: Warps to areatrigger <id>
    createinstance: Creates instance on map <map>
    goinstance: Joins instance <instance> <x> <y> <z> <optional mapid>
    exitinstance: Exits current instance, return to entry point.
    dbreload: Reloads some of the database tables
    spawnspiritguide: Spawns a spirit guide (params: 1 = horde, 0 = alliance)
    advanceallskills: Advances all skills <x> points.
    unlockmovement: Unlocks movement for player.
    modperiod: Changes period of current transporter.
    npcfollow: Sets npc to follow you
    follow: Sets npc to not follow anything
    formationlink1: Sets formation master.
    formationlink2: Sets formation slave with distance and angle
    formationclear: Removes formation from creature
    playall: Plays a sound to the entire server.
    addipban: Bans an ip address <address/mask> <duration, 0=perm>
    banaccounts: Bans accounts <name> <duration, 0=perm>
    renamechar: Renames character x to y.
    forcerenamechar: Forces character x to rename his char next login
    getstanding: Gets standing of faction %u.
    setstanding: Sets standing of faction %u.

    Cheat Commands [m]
    cheat: Main cheat command table. Usage: .cheat <subcommand> <args>
    status: Shows active cheats.
    taxi: Enables all taxi nodes.
    cooldown: Enables no cooldown cheat.
    casttime: Enables no cast time cheat.
    power: Disables mana consumption etc.
    god: Sets god mode, prevents you from taking damage.
    fly: Sets fly mode
    land: Unsets fly mode
    explore: Reveals the unexplored parts of the map.
    flyspeed: Modifies fly speed.
    stack: Enables aura stacking cheat.
    morph: Morphs into model id x.
    demorph: Demorphs from morphed model.

    Honor Modification Commands [m]
    honor: Main honor system command table. Usage: .honor <subcommand> <args>
    getpvprank: Gets PVP Rank
    setpvprank: Sets PVP Rank
    addpoints: Adds x amount of honor points/currency
    addkills: Adds x amount of honor kills
    globaldailyupdate: Daily honor field moves
    singledailyupdate: Daily honor field moves for selected player only
    pvpcredit: Sends PVP credit packet, with specified rank and points

    Pet Commands [m]
    pet: Main pet command table. Usage: .pet <subcommand> <args>
    createpet: Creates a pet with <entry>.
    renamepet: Renames a pet to <name>.
    enablerename: Enables pet rename.
    addspell: Teaches pet <spell>.
    removespell: Removes pet spell <spell>.

    NPC Commands [n]
    npc: Main NPC command table. Usage: .npc <subcommand> <args>
    vendoradditem: Adds to vendor
    vendorremoveitem: Removes from vendor.
    flags: Changes NPC flags
    emote: emote - Sets emote state
    run: No description entered.
    addweapon: No description entered.
    allowmove: No description entered.
    addgrave: No description entered.
    addspirit: No description entered.
    faction: No description entered.
    delete: Deletes mob from db and world.
    info: Displays NPC information
    guid: Shows selected object guid
    addAgent: .npc addAgent <agent> <procEvent> <procChance> <procCount> <spellId> <spellType> <spelltargetType> <spellCooldown> <floatMisc1> <Misc2>
    delAgent: .npc delAgent <procEvent> <spellId>
    listAgent: .npc listAgent
    reset: resets npc health/dmg from temp table.
    export: Exports the npc to a sql file
    say: .npc say <text> - Makes selected mob say text <text>.
    yell: .npc yell <Text> - Makes selected mob yell text <text>.
    come: .npc come - Makes npc move to your position
    return: .npc return - Returns ncp to spawnpoint.
    spawn: .npc spawn - Spawns npc of entry <id>
    spawnlink: .spawnlink sqlentry
    resetreputation: .resetreputation - Resets reputation to start levels. (use on characters that were made before reputation fixes.)
    resetlevel: .resetlevel - Resets all stats to level 1 of targeted player. DANGEROUS.
    resetspells: .resetspells - Resets all spells to starting spells of targeted player. DANGEROUS.
    resettalents: .resettalents - Resets all talents of targeted player to that of their current level. DANGEROUS.
    resetskills: .resetskills - Resets all skills.

    GameObject Commands [o]
    gobject: Main gameobject command table. Usage: .gobject <subcommand> <args>
    select: Selects the nearest GameObject to you
    delete: Deletes selected GameObject
    spawn: Spawns a GameObject by ID
    info: Gives you informations about selected GO
    activate: Activates/Opens the selected GO.
    enable: Enables the selected GO for use.
    scale: Sets scale of selected GO
    animprogress: Sets anim progress
    export: Exports the current GO selected
    statelink: .statelink sqlentry, Links a GO state to a Npc

    Information Commands [p]
    gm: Shows active GM's
    gps: Shows Position
    info: Server info
    uptime: Shows server uptime

    Teleport (Recall)Commands [q]
    recall: Main teleportation command table. Usage: .recall <subcommand> <args>
    list: List recall locations
    port: Port to recalled location
    add: Add recall location
    del: Remove a recall location
    portplayer: recall ports player

    Life and Death Commands [r]
    kill: .kill - Kills selected unit.
    revive: Revives you.: 0, 0, 0},
    reviveplr: Revives player specified.

    Save Commands [s]
    save: Save's your character
    saveall: Save's all playing characters

    GM Tag Commands [t]
    fmoff: Sets GM tag off
    gmon: Sets GM tag on

    Universal Commands [u]
    Commands: Shows Commands
    help: Shows help for command
    announce: Sends Msg To All
    wannounce: Sends Widescreen Msg To All


    Extended Teleport Commands [v]
    appear: Teleports to x's position.
    summon: Summons x to your position
    worldport: No description entered.

    Waypoint Commands [w]
    waypoint: waypointCommandTable
    add: Add wp at current pos
    show: Show wp's for creature
    hide: Hide wp's for creature
    delete: Delete selected wp
    movehere: Move to this wp
    flags: Wp flags
    waittime: Wait time at this wp
    emote: Emote at this wp
    skin: Skin at this wp
    change: Change at this wp
    info: Show info for wp
    movetype: Movement type at wp
    generateNo description entered.Randomly generate wps
    save: Save all waypoints
    deleteall: Delete all waypoints

    Admin Commands [z]
    security: No description entered.
    servershutdown: Initiates server shutdown in <x> seconds.
    serverrestart: Initiates server restart in <x> seconds.
    castall: Makes all players online cast spell <x>.

  13. #13
    pabohan's Avatar Member
    Reputation
    1
    Join Date
    Sep 2007
    Posts
    23
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    so is this for YOUR server or can you do it to a random one you join?

  14. #14
    scott772288's Avatar Member
    Reputation
    1
    Join Date
    Jul 2007
    Posts
    10
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Thanks a lot for this.

  15. #15
    Mesmoras's Avatar Active Member
    Reputation
    30
    Join Date
    Jul 2007
    Posts
    332
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Make a GM account using Navicat.

    Superbimba I don't think you're understanding what you are saying. You basically just posted a thread on all GM commands and mentioned something about flags. GM and Flags are 2 totally different columns bro.
    +rep is a better way to thank some one.
    xxtennisdudexx: erm, u do know manGOS is VERY buggy compared to antrix.
    mesmoras: It may be buggy but it's so easy, even a caveman can do it. lol

Page 1 of 2 12 LastLast

Similar Threads

  1. How To make custome items and venders using navicat
    By spleee101 in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 11-19-2007, 12:53 PM
  2. How do i have a blood elf druid or something like that using navicat?
    By jtmurkz in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 09-26-2007, 01:05 AM
  3. Question about making a new account.
    By DarkSinner in forum World of Warcraft General
    Replies: 2
    Last Post: 09-13-2007, 05:54 AM
  4. How do i make my server public using Hamachi?
    By Hinata_92 in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 09-02-2007, 06:14 PM
All times are GMT -5. The time now is 12:08 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search