-- created by sungyong 2003.11.19
CREATE PROCEDURE [dbo].[UMG_ACCOUNT_INFO_DELETE]
@AccountID  VARCHAR(20)

AS

DECLARE @nation tinyint
DECLARE @charnum tinyint
DECLARE @charid1 CHAR(21)
DECLARE @charid2 CHAR(21)
DECLARE @charid3 CHAR(21)

SET @charid1 = NULL
SET @charid2 = NULL
SET @charid3 = NULL

SELECT @nation = bNation, @charnum = bCharNum, @charid1 = strCharID1, @charid2 = strCharID2, @charid3=strCharID3
FROM ACCOUNT_CHAR
WHERE strAccountID = @AccountID

IF @@rowcount = 0
BEGIN
    RETURN
END

---- 캐릭터 삭제 처리 시작 -----------------------------------
IF @charid1 IS NOT NULL
BEGIN
    EXEC UMG_CHAR_DELETE @AccountID, @charid1
END

IF @charid2 IS NOT NULL
BEGIN
    EXEC UMG_CHAR_DELETE @AccountID, @charid2
END

IF @charid3 IS NOT NULL
BEGIN
    EXEC UMG_CHAR_DELETE @AccountID, @charid3
END

---- 캐릭터 삭제 처리 끝 -----------------------------------

---- 창고, 캐릭정보계정 백업후 삭제 처리 시작 -----------------------------------
DECLARE @money INT, @dwtime INT, @strWHdata VARCHAR(1600), @strSerial VARCHAR(1600)

SELECT @money=nMoney, @dwtime=dwTime,  @strWHdata=WarehouseData, @strSerial=strSerial
FROM WAREHOUSE
WHERE strAccountID = @AccountID

IF @@rowcount <> 0
BEGIN
    INSERT INTO
    DELETED_WAREHOUSE ( strAccountID,nMoney,dwTime,WarehouseData,strSerial  )
    VALUES ( @AccountID, @money, @dwtime, @strWHdata, @strSerial )

    DELETE FROM
    WAREHOUSE
    WHERE strAccountID = @AccountID
END

INSERT INTO
DELETED_ACCOUNT_CHAR ( strAccountID, bNation, bCharNum, strCharID1, strCharID2, strCharID3  )
VALUES ( @AccountID, @nation, @charnum, @charid1, @charid2, @charid3 )

DELETE FROM
ACCOUNT_CHAR
WHERE strAccountID = @AccountID

---- 캐릭정보계정 백업후 삭제 처리 끝 -----------------------------------