Auto_Delete pentru conturile goale (fara character's pe ele)
MMORG ZONE :: MMORPG Development - Server Files :: Mu Online :: Guides :: Romanian Guides (sponsored by Starmedia Forum)
Page 1 of 1
Auto_Delete pentru conturile goale (fara character's pe ele)
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!
APOI RULATI ACEST CO DE CATE ORI VRETI SA STERGETI CONTURI GOALE!
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
Similar topics
» [Guide] Blocking Characters with illegal stats
» Cum faci server de vers. 1.02K, 1.02N cu si fara Router !!!
» [Tutorial]Cum faci server de CS fara IP Global
» WoW Server fara MySQL (EXTREM DE SIMPLU)+pics
» Comenzi pentru GM
» Cum faci server de vers. 1.02K, 1.02N cu si fara Router !!!
» [Tutorial]Cum faci server de CS fara IP Global
» WoW Server fara MySQL (EXTREM DE SIMPLU)+pics
» Comenzi pentru GM
MMORG ZONE :: MMORPG Development - Server Files :: Mu Online :: Guides :: Romanian Guides (sponsored by Starmedia Forum)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|