Delete never used accounts


Published:   Comment: No Comments

游戏数据库

This is a SQL Script (execute run in Query Analyzer), which will delete accounts, that have never logged in!

Code:

DECLARE @Acc varchar(10), @Chars varchar(10), @test int
select @test = 0
DECLARE LISTA CURSOR LOCAL FOR
SELECT memb___id FROM MEMB_INFO
OPEN LISTA
FETCH NEXT FROM LISTA INTO @Acc
WHILE @@FETCH_STATUS = 0
begin
if (SELECT COUNT(*) FROM Character where AccountID=@Acc) = 0
begin
DELETE from MEMB_INFO where memb___id=@Acc
DELETE from VI_CURR_INFO where memb___id=@Acc
select @test = @test + 1
end

FETCH NEXT FROM LISTA INTO @Acc
end
CLOSE LISTA
DEALLOCATE LISTA
print @test

Use at your own risk (cuz what if a player has just created his account and hasn't connected yet?!)

none
Last Modified:2023-12-19 01:18:28

我有话说