[Mu Online] Cum Stergi Conturile Goale Automat

LordofDead

Intri in Start/Programs/Microsoft SQL Server/Query Analyzer!
Va Logati
Selectati database MuOnline loati codurile de mai jos .. pe rand .. unul cate unul cu copy paste iar pentru a le rula .. dati refresh .. F5 .. cel mai simplu.

Codurile :

alter table memb_info

add active int

alter table VI_CURR_INFO

add active int

Atentie aceste coduri le rulati o singura data!

Daka mai vreti alta data sa stergeti conturile goale folositi ori de cate ori vreti pe cele de mai de jos!

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
_________________
[Mu Online] Cum Stergi Conturile Goale Automat [Mu Online] Cum Stergi Conturile Goale Automat

[Mu Online] Cum Stergi Conturile Goale Automat [Mu Online] Cum Stergi Conturile Goale Automat