Flyff Chars komplett aus DB löschen?!

					DELETE CHARACTER_TBL WHERE isblock='D'
					
					DECLARE @name varchar(256)
					DECLARE Delete_Cursor CURSOR FOR 
					SELECT	B.name
						FROM	syscolumns A,sysobjects B
						WHERE	A.id = B.id
					   AND B.name NOT IN('CHARACTER_TBL','MESSENGER_TBL')
					   AND A.name = 'm_idPlayer'
					   AND B.type='U'
					ORDER BY B.name
					
					OPEN Delete_Cursor
					
					FETCH NEXT FROM Delete_Cursor 
					INTO @name
					
					WHILE @@FETCH_STATUS = 0
					BEGIN
						PRINT @name + '??'
						EXEC('DELETE ' + @name + ' WHERE m_idPlayer NOT IN (SELECT m_idPlayer FROM CHARACTER_TBL)')
					   FETCH NEXT FROM Delete_Cursor 
					   INTO @name
					END
					
					DELETE TAG_TBL  WHERE f_idPlayer NOT IN (SELECT m_idPlayer FROM CHARACTER_TBL)
					
					PRINT '??? ?? ??'
					-- ?? 2009-09-16 ??? ?? ?? ?? (EXEC MESSENGER_STR 'D2','',@serverindex ?? ?? ??)
					delete tblMessenger
					where idPlayer not in (select m_idPlayer from CHARACTER_TBL)

					delete tblMessenger
					where idFriend not in (select m_idPlayer from CHARACTER_TBL)

--					EXEC MESSENGER_STR 'D2','',@serverindex

					
					PRINT 'Delete Skill'
					DELETE 	tblSkillPoint 
					WHERE 	PlayerID NOT IN (SELECT m_idPlayer FROM CHARACTER_TBL)


					CLOSE Delete_Cursor
					DEALLOCATE Delete_Cursor

CREATE proc [dbo].[CHARACTER_DELETE_STR]
	@serverindex char(2)
AS

set nocount on
set lock_timeout 600000
set transaction isolation level read uncommitted
set xact_abort on

	declare @ddate char(8)
	set @ddate = convert(char(8),DATEADD(d, -7, getdate()),112)

	CREATE TABLE #TEMP_DELETE_CHR ( m_idPlayer char(7)  )

	-- 삭제 캐릭터에 대한 캐릭터 ID 입력
	insert into #TEMP_DELETE_CHR 
	select m_idPlayer from CHARACTER_TBL (nolock)
	where isblock='D' AND  End_Time <= @ddate and serverindex = @serverindex

	-- 삭제 캐릭터에 대한 삭제 정보 입력
	insert into CHARACTER_TBL_DEL (serverindex, m_idPlayer, m_szName, account, m_nLevel, m_nJob, CreateTime)
	select serverindex, m_idPlayer, m_szName, account, m_nLevel, m_nJob, CreateTime
	from CHARACTER_TBL (nolock)
	where m_idPlayer in ( select m_idPlayer from #TEMP_DELETE_CHR)

	DECLARE @name varchar(256)
	DECLARE Delete_Cursor CURSOR FOR 
	
	SELECT	B.name 
		FROM	syscolumns A,sysobjects B
		WHERE	A.id = B.id
			AND B.name NOT IN('MESSENGER_TBL', 'BILING_ITEM_TBL'
				, 'CHARACTER_TBL_DEL', 'tblFunnyCoin',' tblLogout_Penya', 'tblLogout_Penya_Diff_Log'
				, 'GUILD_COMBAT_1TO1_BATTLE_PERSON_TBL'
				, 'BANK_EXT_TBL','BANK_TBL','INVENTORY_EXT_TBL','INVENTORY_TBL')
			and B.name not like '%item2row%'
			and upper(B.name) not like '%TMP_%'
			AND (A.name = 'm_idPlayer' or A.name = 'serverindex')
			AND B.type='U'
		group by B.name
		having count(*) > 1
	ORDER BY B.name
		
	OPEN Delete_Cursor
	
	FETCH NEXT FROM Delete_Cursor 
	INTO @name
					
	WHILE @@FETCH_STATUS = 0
	BEGIN
		PRINT @name + ' TABLE DELETE'
		exec ('DELETE ' + @name + ' WHERE m_idPlayer IN (
					select m_idPlayer from #TEMP_DELETE_CHR ) 
					and serverindex = ''' + @serverindex + '''')
	        FETCH NEXT FROM Delete_Cursor 
		      INTO @name
	END

				
	PRINT 'NOTE DELETE'
	DELETE TAG_TBL  
	WHERE f_idPlayer in (select m_idPlayer from #TEMP_DELETE_CHR) and serverindex = @serverindex
					
	PRINT 'FRIEND LIST DELETE(OTHER USER)'
	delete tblMessenger
	where idPlayer in (select m_idPlayer from #TEMP_DELETE_CHR) and serverindex = @serverindex
	
	delete tblMessenger
	where idFriend in (select m_idPlayer from #TEMP_DELETE_CHR) and serverindex = @serverindex

	PRINT 'Delete Skill'
	DELETE tblSkillPoint 
	WHERE PlayerID in (select m_idPlayer from #TEMP_DELETE_CHR) AND serverindex = @serverindex

	CLOSE Delete_Cursor
	DEALLOCATE Delete_Cursor

	drop table #TEMP_DELETE_CHR
RETURN

exec CHARACTER_DELETE_STR 'xx'
GO