Query master needed menu

Shout-Out

User Tag List

Results 1 to 7 of 7
  1. #1
    Algorithm's Avatar Member
    Reputation
    175
    Join Date
    Mar 2008
    Posts
    395
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query master needed

    Is there a query that can delete characters from database that account is banned or no longer exists in the database?

    Query master needed
  2. #2
    Sonic Waffle's Avatar Contributor
    Reputation
    170
    Join Date
    Dec 2007
    Posts
    990
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by master1979 View Post
    Is there a query that can delete characters from database that account is banned or no longer exists in the database?
    Well, I can quickly write you a PHP script that deletes the characters of the account that got banned. Otherwise, I think you would have to do it manually.


  3. #3
    Algorithm's Avatar Member
    Reputation
    175
    Join Date
    Mar 2008
    Posts
    395
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Dark Soul View Post
    Well, I can quickly write you a PHP script that deletes the characters of the account that got banned. Otherwise, I think you would have to do it manually.

    would you be so kind?

  4. #4
    Sonic Waffle's Avatar Contributor
    Reputation
    170
    Join Date
    Dec 2007
    Posts
    990
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, going to post in a sec...


  5. #5
    Algorithm's Avatar Member
    Reputation
    175
    Join Date
    Mar 2008
    Posts
    395
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Dark Soul View Post
    Ok, going to post in a sec...

    cool thanx

  6. #6
    kreegoth's Avatar Contributor
    Reputation
    122
    Join Date
    Jun 2008
    Posts
    810
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well you could just use Delete * From `characters` where `acct` = X and put the Banned accounts number where x is.... Should work.. Back up first as always though

  7. #7
    Snailz's Avatar Contributor Authenticator enabled
    Reputation
    239
    Join Date
    Nov 2007
    Posts
    941
    Thanks G/R
    2/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just do what kreegoth said, MUCH MUCH easyer.
    Cheese Cake?

Similar Threads

  1. An usefull query needed . +Repx2 if i get it : )
    By Arugos in forum WoW EMU Questions & Requests
    Replies: 8
    Last Post: 09-19-2008, 01:23 PM
  2. Need Help With two SQL Queries
    By BoP in forum Programming
    Replies: 3
    Last Post: 06-12-2008, 09:15 PM
  3. + 2 REP, Need a simple Mysql Querie
    By mafiaboy in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 02-13-2008, 09:46 PM
  4. + 2 REP, Need another simple Querie
    By mafiaboy in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 01-06-2008, 07:01 PM
  5. need a query
    By Tankotron in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 09-09-2007, 10:28 AM
All times are GMT -5. The time now is 04:43 AM. 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