disabling tbc for every player? menu

User Tag List

Results 1 to 5 of 5
  1. #1
    blackadder9's Avatar Active Member
    Reputation
    28
    Join Date
    Jan 2007
    Posts
    140
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    disabling tbc for every player?

    how to disable tbc for eveyrone ( and make people unable to create tbc accounts) on ascent?

    These ads disappear when you log in.

  2. #2
    Tom_2001's Avatar Lieutenant Commander
    Reputation
    177
    Join Date
    Oct 2007
    Posts
    609
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You see when you make account it says.. 8 in the flags section in accounts...
    Change it to 0..

    Really you could of found this out with search..

  3. #3
    namelessgnome's Avatar Contributor
    Reputation
    108
    Join Date
    May 2007
    Posts
    263
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    UPDATE characters
    SET flag=0
    WHERE flag = 8

  4. #4
    Gastricpenguin's Avatar Account not activated by Email
    Reputation
    980
    Join Date
    Feb 2007
    Posts
    2,237
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In actual sql terms, run this query:

    UPDATE `characters` SET (`flag`='0') WHERE (`flag`='8');

  5. #5
    namelessgnome's Avatar Contributor
    Reputation
    108
    Join Date
    May 2007
    Posts
    263
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    lol you wont need the extra stuff.
    EDIT: On MS SQL the quotes whould only cause the server to execute one more statement since the vaules are integers
    Last edited by namelessgnome; 01-28-2008 at 02:03 PM.

Similar Threads

  1. [RELEASE] Query; Every player starts with a item that sells for 10k gold.
    By Romis in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 03-03-2008, 07:34 AM
  2. [RELEASE] Query; Every player starts with a item that sells for 10k gold.
    By Romis in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 02-20-2008, 11:05 AM
  3. Reputation Calculator for EU players.
    By Enfeebleness in forum World of Warcraft General
    Replies: 11
    Last Post: 08-17-2007, 07:19 PM
  4. How to World PvP on a PvE server for New players
    By –eception in forum World of Warcraft Guides
    Replies: 7
    Last Post: 12-20-2006, 10:00 PM
  5. 3 marks for every wsg/ab
    By Matt in forum World of Warcraft Exploits
    Replies: 7
    Last Post: 08-18-2006, 01:39 AM
All times are GMT -5. The time now is 04:28 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search