Auto_Delete pentru conturile goale (fara character's pe ele)

View previous topic View next topic Go down

Auto_Delete pentru conturile goale (fara character's pe ele)

Post by  on Sun Dec 23, 2007 12:40 pm

Din cauza acestor conturi nefolosite exista si lag.....Asa faci sa scapi de ele

Deschideti (Start -> Programs -> Microsoft SQL Server -> Query Analyzer),
logativa si selectati baza de date MuOnline din meniu ce cade din varf.
Acum nu va trebuie decat sa dati copy -> paste,pe rand,la codurile de mai jos si sa le rulati apasand F5!



RULATI ACEST COD DOAR ODATA!

Cod:
alter table memb_info

add active int

alter table VI_CURR_INFO

add active int



APOI RULATI ACEST CO DE CATE ORI VRETI SA STERGETI CONTURI GOALE!

Cod:
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


Favourite Game : MuOnline
Registration date : 1969-12-31

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum