Welcome to Tutorials - Games

Please REGISTER !!

Cum stergi conturile goale Automat

In jos

Cum stergi conturile goale Automat

Mesaj Scris de scritian la data de Sam Iun 25, 2011 9:54 am

Intri in Start/Programs/Microsoft SQL Server/Query Analyzer va logati
selectati database MuOnline loati codurile de mai .. pe rand .. ul cate ul 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 de mai 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 :

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
avatar
scritian
LeveL 2
LeveL 2

Sex : masculin
Mesaje : 44
Puncte : 113
Reputaţie : 6
Data naşterii : 20/07/1998
Vârsta : 20
Localizare : Timisoara
Stare de spirit : Buna :)

Sus In jos

Sus

- Subiecte similare

 
Permisiunile acestui forum:
Nu puteti raspunde la subiectele acestui forum