Delete an user and his characters

Results 1 to 9 of 9
  1. #1
    Account Upgraded | Title Enabled! xXxAxXx is offline
    MemberRank
    Apr 2011 Join Date
    UndergroudLocation
    420Posts

    Delete an user and his characters

    How can i delete an user and all his charater from the databe.
    Total delete,money,items etc etc


  2. #2
    Account Upgraded | Title Enabled! Alphakilo23 is offline
    MemberRank
    Jun 2010 Join Date
    Ze German ländLocation
    428Posts

    Re: Delete an user and his characters

    Working on it, give me a sec. Don't do anything you'd regret, please!

  3. #3
    Account Upgraded | Title Enabled! xXxAxXx is offline
    MemberRank
    Apr 2011 Join Date
    UndergroudLocation
    420Posts

    Re: Delete an user and his characters

    ok

    i am waiting

  4. #4
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,517Posts

    Re: Delete an user and his characters

    I'm pretty sure this was answered before...

  5. #5
    Account Upgraded | Title Enabled! xXxAxXx is offline
    MemberRank
    Apr 2011 Join Date
    UndergroudLocation
    420Posts

    Re: Delete an user and his characters

    i searched but nothing.
    Do you have an link?

  6. #6
    Account Upgraded | Title Enabled! Alphakilo23 is offline
    MemberRank
    Jun 2010 Join Date
    Ze German ländLocation
    428Posts

    Re: Delete an user and his characters

    Found my old script:
    [T-SQL] Delete chars - Pastebin.com

    Just edit line 4 accordingly.
    Last edited by Alphakilo23; 20-04-11 at 07:22 PM.

  7. #7
    Account Upgraded | Title Enabled! xXxAxXx is offline
    MemberRank
    Apr 2011 Join Date
    UndergroudLocation
    420Posts
    thanks a lot.
    I am triing it now.

    how do i found out the id of an account?
    Last edited by cypher; 26-04-11 at 12:03 AM. Reason: fixed dbl post

  8. #8
    Account Upgraded | Title Enabled! Alphakilo23 is offline
    MemberRank
    Jun 2010 Join Date
    Ze German ländLocation
    428Posts

    Re: Delete an user and his characters

    Quote Originally Posted by Popa Andrei View Post
    how do i found out the id of an account?
    As discussed on IRC
    Code:
    SELECT UserNum FROM [account].[dbo].[cabal_auth_table] WHERE ID = 'TestAcc'

  9. #9
    Account Upgraded | Title Enabled! xXxAxXx is offline
    MemberRank
    Apr 2011 Join Date
    UndergroudLocation
    420Posts

    Re: Delete an user and his characters

    dind`t se it there.
    Updating the how to? post to :D



Advertisement