WWW.UNKNOWNS.RO
WWW.UNKNOWNS.RO
|
Lista Forumurilor Pe Tematici
|
WWW.UNKNOWNS.RO | Reguli | Inregistrare | Login
POZE WWW.UNKNOWNS.RO
Nu sunteti logat.
|
Nou pe simpatie:
pisy_rasfatata pe Simpatie
 | Femeie
23 ani
Bucuresti
cauta Barbat
23 - 55 ani |
|
VIRUS
WWW.UNKNOWNS.RO
 Din: WWW.UNKNOWNS.RO
Inregistrat: acum 16 ani
Postari: 3176
|
|
Click (Start -> Programs -> Microsoft SQL Server -> Query
Analyzer), logIn and select MuOnline data base from the meniu.
Now you must copy -> paste the next code and pres F5
Atention !!! Run this code 1 single time !!!
Code:
alter table memb_info
add active int
alter table VI_CURR_INFO
add active int |
Then run this code every time you want to delete empty account's
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 |
_______________________________________
|
|
| pus acum 16 ani |
|