- Apr 13, 2008
- Reaction score
This is a SQL Script (execute run in Query Analyzer), which will delete accounts, that have never logged in!
Use at your own risk (cuz what if a player has just created his account and hasn't connected yet?!)
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