[Guide]Auto_Delete the empty accounts (with no carrecters)

This is a discussion on [Guide]Auto_Delete the empty accounts (with no carrecters) within the Mu Archives board part of the Mu Online forum category; If there are empty acc your server will have lag (ping) , How do you proceed: Open Start -> Programs ...

Results 1 to 4 of 4
  1. #1
    cblt's Avatar
    cblt is offline Hacker
    Array
    Join Date
    Nov 2007
    Location
    In The Hell:)
    Posts
    226
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Rep Power
    13
    Reputation
    144

    [Guide]Auto_Delete the empty accounts (with no carrecters)

    If there are empty acc your server will have lag (ping) , How do you proceed:
    Open Start -> Programs -> Microsoft SQL Server -> Query Analyzer and take the next 2 codes



    Use this code one time!

    Code:
    alter table memb_info 
    add active int 
    alter table VI_CURR_INFO 
    add active int


    Use this code each time when you want to delete all the empty acc!



    Code:
    Update dbo.memb_info 
    SET active = 0 
    Update dbo.memb_info 
    SET active = 1 FROM memb_info join Character on memb_info.memb___id=Character.AccountID 
    collate Latin1_general_CI_AS 
    Update dbo.VI_CURR_INFO 
    SET active = 0 
    Update dbo.VI_CURR_INFO 
    SET active = 1 FROM VI_CURR_INFO join Character on VI_CURR_INFO.memb___id=Character.AccountID 
    collate Latin1_general_CI_AS 
    SELECT * FROM VI_CURR_INFO join MEMB_INFO on VI_CURR_INFO.memb___id=MEMB_INFO.memb___id 
    collate Latin1_general_CI_AS WHERE memb_info.active = 0 AND VI_CURR_INFO.active=0 
    DELETE FROM VI_CURR_INFO WHERE VI_CURR_INFO.active=0 
    DELETE FROM MEMB_INFO WHERE memb_info.active = 0


    (C)cblt , D3Scene MuOnline Moderator

  2. #2
    nekoni is offline Wannabe Member
    Array
    Join Date
    Jan 2008
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Rep Power
    0
    Reputation
    0
    nice guide, ill try!

  3. #3
    cblt's Avatar
    cblt is offline Hacker
    Array
    Join Date
    Nov 2007
    Location
    In The Hell:)
    Posts
    226
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Rep Power
    13
    Reputation
    144
    hf

  4. #4
    Macbeth's Avatar
    Macbeth is offline Mentor
    Array
    Join Date
    Jan 2008
    Location
    <? here ?>
    Posts
    140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Rep Power
    12
    Reputation
    75
    wow i didnt know this, nice.
    Czt Team Owner
    czt-team.org, your source for development.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •