WWW.UNKNOWNS.RO
WWW.UNKNOWNS.RO
|
Nou pe simpatie:
xxIRISxx
 | Femeie
25 ani
Timis
cauta Barbat
25 - 60 ani |
|
|
WWW.UNKNOWNS.ROReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
 VIRUSWWW.UNKNOWNS.RODin: WWW.UNKNOWNS.RO
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 |
_______________________________________
WWW.UNKNOWNS.RO
|
|
| |
|
