SQL command to change GM levels. menu

User Tag List

Results 1 to 2 of 2
  1. #1
    controlsx2's Avatar Member
    Reputation
    16
    Join Date
    Jun 2007
    Posts
    223
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL command to change GM levels.

    Im using commade overide table to give all normal players ability to port to mall. So ive set account creation page to make all all players now in this new gorup "L" but i already have another 250ish accounts that need updating. Can somone make me a quiery for sql that does

    "Insert in table `accounts` value `L` in column `gm` where current value = ``"

    Something like that xD ^^

    SQL command to change GM levels.
  2. #2
    TheSpidey's Avatar Elite User
    Reputation
    365
    Join Date
    Jan 2008
    Posts
    2,200
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    UPDATE `accounts` SET `gm`="L" WHERE `gm` = "" OR `gm` = "0";

Similar Threads

  1. command to change raid difficulty?
    By magickmann in forum WoW UI, Macros and Talent Specs
    Replies: 0
    Last Post: 07-09-2016, 12:50 PM
  2. [ArcEmu] How to set spawn or add times on commands for different gm levels
    By Found in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 04-21-2011, 04:07 PM
  3. [ArcEmu] command that changes the BODY display but not ARMOR display.
    By darkmagishin in forum WoW EMU Questions & Requests
    Replies: 4
    Last Post: 12-18-2010, 06:53 AM
  4. [Spell change] Regrowth! (level 10)
    By coldmrn in forum World of Warcraft Model Editing
    Replies: 12
    Last Post: 05-16-2008, 06:14 PM
  5. [Request] How to change instance Level?
    By Ellenor in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 01-29-2008, 07:42 AM
All times are GMT -5. The time now is 09:40 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search