CHARACTER_STR

USE [CHARACTER_01_DBF]
GO
/****** Object:  StoredProcedure [dbo].[CHARACTER_STR]    Script Date: 4/8/2020 1:16:11 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[CHARACTER_STR]
    @iGu                                CHAR(2)             = 'S1',
    @im_idPlayer                CHAR(7)             = '0000001',
    @iserverindex               CHAR(2)             = '01',
    /**********************************************
     INSERT ¢¯e
    **********************************************/
    -- CHARACTER_TBL
    @iaccount                       VARCHAR(32) = '',
    @im_szName              VARCHAR(32) = '',
    @iplayerslot                    INT                     = 0,
    @idwWorldID                 INT                         = 0,
    @im_dwIndex                 INT                         = 0,
    @im_vPos_x                  REAL                    = 0,
    @im_vPos_y                  REAL                    = 0,
    @im_vPos_z                  REAL                    = 0,
    @im_szCharacterKey  VARCHAR(32) = '',
    @im_dwSkinSet           INT                     = 0,
    @im_dwHairMesh      INT                     = 0,
    @im_dwHairColor         INT                     = 0,
    @im_dwHeadMesh      INT                     = 0,
    @im_dwSex                   INT                     = 0,
    /**********************************************
     UPDATE ¢¯e
    **********************************************/
    -- CHARACTER_TBL
    @im_vScale_x                REAL                    =   0,
    @im_dwMotion                INT                     =   0,
    @im_fAngle                  REAL                    =   0,
    @im_nHitPoint               INT                     =   0,
    @im_nManaPoint          INT                     =   0,
    @im_nFatiguePoint       INT                     =   0,
    @im_dwRideItemIdx       INT                     =   0,
    @im_dwGold                  INT                     =   0,
    @im_nJob                        INT                     =   0,
    @im_pActMover               VARCHAR(50) =   '',
    @im_nStr                        INT                     =   0,
    @im_nSta                        INT                     =   0,
    @im_nDex                        INT                     =   0,
    @im_nInt                            INT                     =   0,
    @im_nLevel                  INT                     =   0,
    @im_nExp1                   BIGINT                      =   0,
    @im_nExp2                   BIGINT                      =   0,
    @im_aJobSkill               VARCHAR(500)    ='',
    @im_aLicenseSkill       VARCHAR(500)    ='',
    @im_aJobLv                  VARCHAR(500)    ='',
    @im_dwExpertLv          INT                     =   0,
    @im_idMarkingWorld  INT                     =   0,
    @im_vMarkingPos_x   REAL                    =   0,
    @im_vMarkingPos_y   REAL                    =   0,
    @im_vMarkingPos_z   REAL                    =   0,
    @im_nRemainGP           INT                     =   0,
    @im_nRemainLP           INT                     =   0,
    @im_nFlightLv               INT                     =   0,
    @im_nFxp                        INT                     =   0,
    @im_nTxp                        INT                     =   0,
    @im_lpQuestCntArray VARCHAR(3072)= '',
    @im_chAuthority         CHAR(1)             = '',
    @im_dwMode              INT                     =   0,
    @im_idparty                 INT                     =   0,
    @im_idMuerderer         INT                     =   0,
    @im_nFame                   INT                     =   0,
    @im_nDeathExp               BIGINT                  =  0,
    @im_nDeathLevel             INT                 =  0,
    @im_dwFlyTime                   INT                 =  0,
    @im_nMessengerState     INT                 =  0,
    @iTotalPlayTime         INT                     =   0
    -------------- (ADD : Version8-PK System)
    ,@im_nPKValue           INT=0
    ,@im_dwPKPropensity     INT=0
    ,@im_dwPKExp            INT=0
    -- CARD_CUBE_TBL
    ,@im_Card                       VARCHAR(1980)= '',
    @im_Index_Card          VARCHAR(215)    = '',
    @im_ObjIndex_Card   VARCHAR(215)    = '',
    @im_Cube                        VARCHAR(1980)= '',
    @im_Index_Cube          VARCHAR(215)    = '',
    @im_ObjIndex_Cube   VARCHAR(215)    = '',
    -- INVENTORY_TBL
    @im_Inventory               VARCHAR(MAX)= '',
    @im_apIndex                 VARCHAR(2500)   = '',
    @im_adwEquipment    VARCHAR(135)    = '',
    @im_dwObjIndex          VARCHAR(2500)   = '',
    -- TASKBAR_TBL
    @im_aSlotApplet             VARCHAR(3100)= '',
    -- TASKBAR_ITEM_TBL
    @im_aSlotItem               VARCHAR(6885)= '',
    -- TASKBAR_TBL
    @im_aSlotQueue          VARCHAR(225)= '',
    @im_SkillBar                    SMALLINT            = 0,
    -- BANK_TBL
    @im_Bank                        VARCHAR(4290)= '',
    @im_apIndex_Bank        VARCHAR(215)= '',
    @im_dwObjIndex_Bank VARCHAR(215)= '',
    @im_dwGoldBank          INT                     = 0,
    @im_nFuel                       INT                     = -1,
    @im_tmAccFuel               INT                         = 0,
    @im_dwSMTime            VARCHAR(2560)='',
    @iSkillInfluence                VARCHAR(2048) ='',
    @im_dwSkillPoint            INT                         = 0,
    @im_aCompleteQuest  VARCHAR(3072) = '',
    @im_extInventory            VARCHAR(MAX) = '',
    @im_extBank                 VARCHAR(2000) = '',
    @im_InventoryPiercing VARCHAR(MAX) = '',
    @im_BankPiercing        VARCHAR(8000) = '',
    @im_dwReturnWorldID INT                     = 1,
    @im_vReturnPos_x        REAL                    = 0,
    @im_vReturnPos_y        REAL                    = 0,
    @im_vReturnPos_z        REAL                    = 0,
    -------------- ( Version 7 : Skill Update)
    @im_SkillPoint          INT=0,
    @im_SkillLv             INT=0,
    @im_SkillExp            BIGINT=0,
    -------------- (A©¬¡Æ¢® ¨¬I¨¬¨¢ : 2006 11 13 Attendant Class)
    @idwEventFlag                   BIGINT=0,
    @idwEventTime          INT=0,


    @idwEventElapsed                INT=0
    -------------- (ADD : Version8-Angel System)
    ,@im_nAngelExp      BIGINT=0
    ,@im_nAngelLevel        INT=0
    --------------- Version 9 A©¬¡Æ¢® ¨¬I¨¬¨¢ Pet¡Æu¡¤A
,@iszInventoryPet   VARCHAR(MAX)     = '$'

,@iszBankPet    VARCHAR(4200)     = '$'
,@im_dwPetId INT = -1

,@im_nExpLog INT = 0
,@im_nAngelExpLog INT = 0
,@im_nCoupon INT = 0
--------------- ver. 13
, @im_nHonor INT = -1
, @im_nLayer INT = 0
---------- Ver 15
--, @im_BankPW char(4) = '0000'
, @im_aCheckedQuest VARCHAR(100) =''
, @im_nCampusPoint INT = 0
, @im_idCampus INT = 0

/*******************************************************
    Gu ¡¾¢¬¨¬¨¢
    S : SELECT
    I  : INSERT
    U : UPDATE
    D : DELETE


2005.04.11 updated

ALTER TABLE  CHARACTER_TBL  ADD   m_aCompleteQuest  varchar(1024) NULL
ALTER TABLE CHARACTER_TBL  ALTER COLUMN   m_lpQuestCntArray VARCHAR(3072) NULL

*******************************************************/
AS
SET nocount ON
DECLARE @last_connect tinyint
SET @last_connect = 1

DECLARE @om_chLoginAuthority CHAR(1),@oaccount VARCHAR(32),@oplayerslot INT

IF @iGu = 'S2' -- ¨ö¨ö¡¤O¢¯¢® ¥ìu¢¬¡Í CA¡¤©öAI¨úi¢¬¢ç¨ö¨¬¨¡¢ç AI¨¬¡ÍAa¢¬¢çA¢´¨¬¢¬  ¡Æ¢®A¢ç¢¯A¡¾a
    BEGIN
        IF @iaccount = '' OR @im_szName  = ''
        BEGIN
            SELECT m_chAuthority = '',fError = '1', fText = '¨úIE¡Ì¨¡©÷¢¬©÷'
            RETURN
        END

        SELECT playerslot,MAX(m_idPlayer) AS m_idplayer
        INTO #temp_realPlayerslot
        FROM dbo.CHARACTER_TBL A
        WHERE A.isblock = 'F' AND A.account = @iaccount AND A.serverindex = @iserverindex
        GROUP BY playerslot

            SELECT  A.dwWorldID,
                            A.m_szName,
                            A.playerslot,
                            A.End_Time,
                            A.BlockTime,
                            A.m_dwIndex,
                            A.m_idPlayer,
                            A.m_idparty,
                            A.m_dwSkinSet,
                            A.m_dwHairMesh,
                            A.m_dwHeadMesh,
                            A.m_dwHairColor,
                            A.m_dwSex,
                            A.m_nJob,
                            A.m_nLevel,
                            A.m_vPos_x,
                            A.m_vPos_y,
                            A.m_vPos_z,
                            A.m_nStr,
                            A.m_nSta,
                            A.m_nDex,
                            A.m_nInt,
                            A.m_aJobLv,
                            A.m_chAuthority,
                            A.m_idCompany,
                            A.m_nMessengerState,
                            B.m_Inventory,
                            B.m_apIndex,
                            B.m_adwEquipment,
                            B.m_dwObjIndex,
                            m_idGuild = CASE WHEN C.m_idGuild  IS NULL THEN '0' ELSE C.m_idGuild END    ,
                            m_idWar = CASE WHEN C.m_idWar  IS NULL THEN '0' ELSE C.m_idWar END,
                            D.m_extInventory,
                            D.m_InventoryPiercing,
                            ------------- ver. 13
                            A.m_nHonor,
                            last_connect = @last_connect
            FROM CHARACTER_TBL AS A
                INNER JOIN INVENTORY_TBL AS B ON A.m_idPlayer = B.m_idPlayer AND A.serverindex = B.serverindex
                INNER JOIN INVENTORY_EXT_TBL AS D ON B.serverindex = D.serverindex AND B.m_idPlayer = D.m_idPlayer
                INNER JOIN #temp_realPlayerslot AS ttt ON A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot
                LEFT OUTER JOIN GUILD_MEMBER_TBL AS C ON D.m_idPlayer = C.m_idPlayer AND D.serverindex = C.serverindex
            WHERE   A.isblock = 'F'
                AND A.account = @iaccount
                AND A.serverindex = @iserverindex
            ORDER BY A.playerslot

INSERT INTO CHARACTER_TBL_penya_check (account, m_szName, m_dwGold, check_sec, serverindex)
SELECT @iaccount, m_szName, m_dwGold, 9, @iserverindex
FROM CHARACTER_TBL (nolock)
WHERE account = @iaccount AND serverindex = @iserverindex AND TotalPlayTime < 1 AND m_dwGold >= 1

                RETURN
    END
/*

     ¨ö¨ö¡¤O¢¯¢® ¥ìu¢¬¡Í CA¡¤©öAI¨úi¢¬¢ç¨ö¨¬¨¡¢ç AI¨¬¡ÍAa¢¬¢çA¢´¨¬¢¬  ¡Æ¢®A¢ç¢¯A¡¾a
     ex )
     CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
     CHARACTER_STR 'S2','0','02','seghope','1234'


*/

ELSE
IF @iGu = 'S3' -- ¨ù¡©©öo¡Æ¢® A©øA¨ö¨öCCaA¡í CO¢¥e A©ø¢¬?AIAC idPlayer¢¬| ¢¥U ¡Æ¢®Ao¡Æi¢¯E
    BEGIN
         SELECT m_szName, m_idPlayer,m_idCompany
            FROM CHARACTER_TBL
         WHERE serverindex = @iserverindex
--            AND  isblock = 'F'
         ORDER BY m_idPlayer
        RETURN
    END
/*

     ¨ù¡©©öo¡Æ¢® A©øA¨ö¨öCCaA¡í CO¢¥e A©ø¢¬?AIAC idPlayer¢¬| ¢¥U ¡Æ¢®Ao¡Æi¢¯E
     ex )
     CHARACTER_STR 'S3','',@iserverindex
     CHARACTER_STR 'S3','','01'



*/

ELSE
IF @iGu = 'S4' -- A©¬¡Æ¢®CO ¨ú¨¡AIAU E¢çAI
    BEGIN

    DECLARE @s4_account VARCHAR(32), @i1_e_date datetime

        DECLARE @q1 nvarchar(4000)

        SET @q1 = '
        SELECT  Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
            m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4,
            m_dwKeepTime, nRandomOptItemId,
            isnull(adwItemId5, 0) as adwItemId5, isnull(adwItemId6, 0) as adwItemId6, isnull(adwItemId7, 0) as adwItemId7, isnull(adwItemId8, 0) as adwItemId8, isnull(adwItemId9, 0) as adwItemId9, isnull(nUMPiercedSize, 0) as nUMPiercedSize,
            isnull(adwUMItemId0, 0) as adwUMItemId0, isnull(adwUMItemId1, 0) as adwUMItemId1, isnull(adwUMItemId2, 0) as adwUMItemId2, isnull(adwUMItemId3, 0) as adwUMItemId3, isnull(adwUMItemId4, 0) as adwUMItemId4
        FROM ITEM_SEND_TBL
        WHERE m_idPlayer = @im_idPlayer
            AND serverindex = @iserverindex
            AND ItemFlag = 0'
        EXEC sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
        RETURN
    END
/*


     ¨ú¨¡AIAU E¢çAI
     ex )
     CHARACTER_STR 'S4',@im_idPlayer,@iserverindex
     CHARACTER_STR 'S4','000001','01'

*/

ELSE
IF @iGu = 'S5' -- ¨ú¨¡AIAU Ao¡¾¨­EA A¡¿AI¨¬i¢¯¢®¨ù¡© ¨ú¨¡AIAU ¡íeA|
    BEGIN
--      DELETE ITEM_SEND_TBL
        UPDATE ITEM_SEND_TBL SET ProvideDt=getdate(), ItemFlag=1
         WHERE  m_nNo  = @iplayerslot
        IF @@ROWCOUNT = 0
        SELECT fError = '0'
        ELSE
        SELECT fError = '1'
        RETURN
    END
/*

     ¨ú¨¡AIAU Ao¡¾¨­EA A¡¿AI¨¬i¢¯¢®¨ù¡© ¨ú¨¡AIAU ¡íeA|
     ex )
     CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount
     CHARACTER_STR 'S5','000001','01','¨¬©ªAU¡¤c',1,1
*/

ELSE
IF @iGu = 'S6' -- ¡íeA|CO ¨ú¨¡AIAU E¢çAI

    BEGIN
        SELECT  Item_Name,
                        Item_count,
                        m_nAbilityOption,
                        m_nNo,
                        State,
                        m_bItemResist,
                        m_nResistAbilityOption
            FROM ITEM_REMOVE_TBL
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex
              AND   ItemFlag = 0
    RETURN
    END
/*
    ¨ú¨¡AIAU E¢çAI
    ex )
     CHARACTER_STR 'S6',@im_idPlayer,@iserverindex
     CHARACTER_STR 'S6','000001','01'
*/

ELSE
IF @iGu = 'S7' -- ¨ú¨¡AIAU ¡íeA|EA A¡¿AI¨¬i¢¯¢®¨ù¡© ¨ú¨¡AIAU ¡íeA|
    BEGIN
--      DELETE  ITEM_REMOVE_TBL
        UPDATE ITEM_REMOVE_TBL SET DeleteDt=getdate(), ItemFlag=1
         WHERE  m_nNo  = @iplayerslot

        IF @@ROWCOUNT = 0
        SELECT fError = '0'
        ELSE
        SELECT fError = '1'
        RETURN
    END
/*
     ¨ú¨¡AIAU Ao¡¾¨­EA A¡¿AI¨¬i¢¯¢®¨ù¡© ¨ú¨¡AIAU ¡íeA|
     ex )
     CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount
     CHARACTER_STR 'S7','000001','01','¨¬©ªAU¡¤c',1,1
*/

IF @iGu = 'S8' -- ¥ì¡ÍAIAI AuA¨ù ¡Æ¢®A¢ç¢¯A¡¾a
    BEGIN


                SELECT @om_chLoginAuthority = m_chLoginAuthority
                  FROM  ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL
                WHERE account   = @iaccount


                SELECT  m_chLoginAuthority = @om_chLoginAuthority,
                                A.account,
                                A.m_idPlayer,
                                A.playerslot,
                                A.serverindex,
                                A.dwWorldID,
                                A.m_szName,
                                A.m_dwIndex,
                                A.m_vScale_x,
                                A.m_dwMotion,
                                A.m_vPos_x,
                                A.m_vPos_y,
                                A.m_vPos_z,
                                A.m_fAngle,
                                A.m_szCharacterKey,
                                A.m_idPlayer,
                                A.m_nHitPoint,
                                A.m_nManaPoint,
                                A.m_nFatiguePoint,
                                A.m_nFuel,
                                A.m_dwSkinSet,
                                A.m_dwHairMesh,
                                A.m_dwHairColor,
                                A.m_dwHeadMesh,
                                A.m_dwSex,
                                A.m_dwRideItemIdx,
                                A.m_dwGold,
                                A.m_nJob,
                                A.m_pActMover,
                                A.m_nStr,
                                A.m_nSta,
                                A.m_nDex,
                                A.m_nInt,
                                A.m_nLevel,

                                A.m_nMaximumLevel,
                                A.m_nExp1,
                                A.m_nExp2,
                                A.m_aJobSkill,
                                A.m_aLicenseSkill,
                                A.m_aJobLv,
                                A.m_dwExpertLv,
                                A.m_idMarkingWorld,
                                A.m_vMarkingPos_x,
                                A.m_vMarkingPos_y,
                                A.m_vMarkingPos_z,
                                A.m_nRemainGP,
                                A.m_nRemainLP,
                                A.m_nFlightLv,
                                A.m_nFxp,
                                A.m_nTxp,
                                A.m_lpQuestCntArray,
                                m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'),
                                A.m_chAuthority,
                                A.m_dwMode,
                                A.m_idparty,
                                A.m_idCompany,
                                A.m_idMuerderer,
                                A.m_nFame,
                                A.m_nDeathExp,
                                A.m_nDeathLevel,
                                A.m_dwFlyTime,
                                A.m_nMessengerState,
                                A.End_Time,
                                A.BlockTime,
                                A.blockby,
                                A.isblock,
                                A.TotalPlayTime,
                                A.CreateTime,
                                A.m_dwSkillPoint,
                                B.m_aSlotApplet,
                                B.m_aSlotQueue,
                                B.m_SkillBar,
                                C.m_aSlotItem,
                                D.m_Inventory,
                                D.m_apIndex,
                                D.m_adwEquipment,
                                D.m_dwObjIndex,
                                m_idGuild = ISNULL(G.m_idGuild,'0'),
                                m_idWar = ISNULL(G.m_idWar,'0'),
                                A.m_tmAccFuel,
                                A.m_tGuildMember,
                                m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL')    ,
                                SkillInfluence = ISNULL(E.SkillInfluence,'$'),
                                F.m_extInventory,
                                F.m_InventoryPiercing,
                                A.m_dwReturnWorldID,
                                A.m_vReturnPos_x,
                                A.m_vReturnPos_y,
                                A.m_vReturnPos_z,
                                last_connect = @last_connect,
                                A.m_SkillPoint,
                                A.m_SkillLv,
                                A.m_SkillExp,
                              -------------- (2006 11 13 A©¬¡Æ¢® ¨¬I¨¬¨¢ : Attedant Event)
                                A.dwEventFlag,
                                A.dwEventTime,
                                A.dwEventElapsed
                              -------------- (Version8 : PK System)
                                ,A.PKValue      AS m_nPKValue
                                ,A.PKPropensity AS m_dwPKPropensity
                                ,A.PKExp        AS m_dwPKExp
                              -------------- (Version8 : Angel System)
                                ,A.AngelExp     AS m_nAngelExp
                                ,A.AngelLevel   AS m_nAngelLevel
                            ------------------- Version9 Pet

                                ,F.szInventoryPet AS szInventoryPet
                                ,A.m_dwPetId
                                , A.m_nExpLog, A.m_nAngelExpLog
                                ,m_nCoupon
                                ------------ ver. 13
                                , A.m_nLayer
                                ---------- Ver 15
                                , A.m_aCheckedQuest
                                , A.m_nCampusPoint
                                , A.idCampus
                                , isnull(R.m_nRestPoint, 0) m_nRestPoint
                                , isnull(R.m_LogOutTime, 0) m_LogOutTime
            FROM CHARACTER_TBL A
                    INNER JOIN TASKBAR_TBL B ON A.m_idPlayer   = B.m_idPlayer AND A.serverindex  = B.serverindex
                    INNER JOIN TASKBAR_ITEM_TBL C ON B.m_idPlayer   = C.m_idPlayer AND B.serverindex  = C.serverindex
                    INNER JOIN INVENTORY_TBL D ON C.m_idPlayer   = D.m_idPlayer AND C.serverindex  = D.serverindex
                    INNER JOIN SKILLINFLUENCE_TBL E ON D.m_idPlayer   = E.m_idPlayer AND D.serverindex  = E.serverindex
                    INNER JOIN INVENTORY_EXT_TBL F ON E.m_idPlayer   = F.m_idPlayer AND E.serverindex  = F.serverindex
                    LEFT OUTER JOIN GUILD_MEMBER_TBL G ON F.serverindex = G.serverindex AND F.m_idPlayer = G.m_idPlayer
                    LEFT OUTER JOIN BILING_ITEM_TBL H ON F.serverindex = H.serverindex AND F.m_idPlayer = H.m_idPlayer
                    LEFT OUTER JOIN tblRestPoint R ON F.serverindex = R.serverindex AND F.m_idPlayer = R.m_idPlayer
            WHERE A.m_idPlayer = @im_idPlayer
                    AND A.serverindex = @iserverindex
                    AND A.account = LOWER(@iaccount)
                    AND A.isblock = 'F' -- fix

INSERT INTO CHARACTER_TBL_validity_check (m_idPlayer, serverindex, account, m_szName, TotalPlayTime, m_dwGold, m_nLevel, m_nJob, sum_ability, CreateTime)
SELECT m_idPlayer, serverindex, account, m_szName, TotalPlayTime, m_dwGold, m_nLevel, m_nJob, (m_nStr + m_nSta + m_nDex + m_nInt), CreateTime
FROM CHARACTER_TBL (nolock)
WHERE m_idPlayer = @im_idPlayer AND TotalPlayTime <= 1
    AND (m_dwGold >= 1 OR m_nLevel >= 2 OR m_nJob >= 1 OR (m_nStr + m_nSta + m_nDex + m_nInt) > 60)


DECLARE @m_dwGold_old BIGINT, @m_dwGold_now BIGINT
SELECT @m_dwGold_old = m_dwGold FROM tblLogout_Penya (nolock) WHERE m_idPlayer = @im_idPlayer
SELECT @m_dwGold_now = m_dwGold FROM CHARACTER_TBL (nolock) WHERE serverindex = @iserverindex AND m_idPlayer = @im_idPlayer
IF (@m_dwGold_old <> @m_dwGold_now)
BEGIN
    INSERT INTO tblLogout_Penya_Diff_Log (serverindex, m_idPlayer, m_dwGold_old, regdate_old, m_dwGold_now)
    SELECT serverindex, m_idPlayer, @m_dwGold_old, regdate, @m_dwGold_now
    FROM tblLogout_Penya (nolock)
    WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
END

                -- ©ö©£A¨Ï A¢´¨¬¢¬ ¡Æ¢®A¢ç¢¯A¡¾a account ¨¬¡Æ

--              DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT)
--
--              INSERT @bank
--              (m_idPlayer,serverindex,playerslot)
--               SELECT m_idPlayer,serverindex,playerslot
--               FROM CHARACTER_TBL
--               WHERE account = @iaccount
--               AND isblock = 'F'
--               ORDER BY playerslot

                SELECT  a.m_idPlayer,
                                c.playerslot,
                                a.m_Bank,
                                a.m_apIndex_Bank,
                                a.m_dwObjIndex_Bank,
                                a.m_dwGoldBank,
                                a.m_BankPw,
                                b.m_extBank,
                                                    b.m_BankPiercing
                                ,b.szBankPet
                   FROM     dbo.BANK_TBL a,
                            dbo.BANK_EXT_TBL b,
                            dbo.CHARACTER_TBL  c
               WHERE    a.m_idPlayer = b.m_idPlayer
                    AND a.serverindex = b.serverindex
                    AND b.m_idPlayer = c.m_idPlayer
                    AND b.serverindex = c.serverindex
                      AND c.account = @iaccount
                    AND c.isblock = 'F'
                ORDER BY c.playerslot

                -- Pocket Info
            SELECT  a.nPocket,
                a.szItem,
                a.szIndex,
                a.szObjIndex,
                a.bExpired,
                a.tExpirationDate,
                b.szExt,
                b.szPiercing,
                b.szPet
            FROM    tblPocket AS a INNER JOIN tblPocketExt AS b
                ON a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket
            WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer
            ORDER BY a.nPocket

        RETURN
    END
/*

     ¥ì¡ÍAIAI AuA¨ù ¡Æ¢®A¢ç¢¯A¡¾a New
     ex )
     CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount
     CHARACTER_STR 'S8','425120','01','ata3k'
*/
ELSE
IF @iGu = 'U1' -- A©ø¢¬?AI AuAa
    BEGIN
        UPDATE CHARACTER_TBL
              SET   dwWorldID               = @idwWorldID,
                        m_dwIndex               = @im_dwIndex,
                        m_dwSex                 = @im_dwSex,
                        m_vScale_x              = @im_vScale_x,
                        m_dwMotion              = @im_dwMotion,
                        m_vPos_x                    = @im_vPos_x,
                        m_vPos_y                    = @im_vPos_y,
                        m_vPos_z                    = @im_vPos_z,
                        m_dwHairMesh        = @im_dwHairMesh,
                        m_dwHairColor           = @im_dwHairColor,
                        m_dwHeadMesh        = @im_dwHeadMesh,  -- 2004/11/08   A©¬¡Æ¢®
                        m_fAngle                    = 0, --@im_fAngle,
                        m_szCharacterKey    = @im_szCharacterKey,
                        m_nHitPoint                 = @im_nHitPoint,
                        m_nManaPoint            = @im_nManaPoint,
                        m_nFatiguePoint         = @im_nFatiguePoint,
                        m_nFuel                     = @im_nFuel,
                        m_dwRideItemIdx         = @im_dwRideItemIdx,
                        m_dwGold                    = @im_dwGold,
                        m_nJob                      = @im_nJob,
                        m_pActMover             = @im_pActMover,
                        m_nStr                      = @im_nStr,
                        m_nSta                      = @im_nSta,
                        m_nDex                      = @im_nDex,
                        m_nInt                      = @im_nInt,
                        m_nLevel                    = @im_nLevel,
                        m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
                        m_nExp1                 = @im_nExp1,
                        m_nExp2                     = @im_nExp2,
                        m_aJobSkill                 = @im_aJobSkill,
                        m_aLicenseSkill         = @im_aLicenseSkill,
                        m_aJobLv                    = @im_aJobLv,
                        m_dwExpertLv            = @im_dwExpertLv,
                        m_idMarkingWorld    = @im_idMarkingWorld,
                        m_vMarkingPos_x     = @im_vMarkingPos_x,
                        m_vMarkingPos_y     = @im_vMarkingPos_y,
                        m_vMarkingPos_z     = @im_vMarkingPos_z,
                        m_nRemainGP             = @im_nRemainGP,
                        m_nRemainLP             = @im_nRemainLP,
                        m_nFlightLv                 = @im_nFlightLv,
                        m_nFxp                      = @im_nFxp,
                        m_nTxp                      = @im_nTxp,
                        m_lpQuestCntArray   = @im_lpQuestCntArray,
                        m_aCompleteQuest = @im_aCompleteQuest,
                        m_dwMode                = @im_dwMode,
                        m_idparty                   = @im_idparty,
                        m_idMuerderer       = @im_idMuerderer,
                        m_nFame                     = @im_nFame,
                        m_nDeathExp         = @im_nDeathExp,
                        m_nDeathLevel           = @im_nDeathLevel,
                        --m_dwFlyTime               = m_dwFlyTime + @im_dwFlyTime,
                        m_dwFlyTime = @im_dwFlyTime,
                        m_nMessengerState = @im_nMessengerState,
                        TotalPlayTime           = TotalPlayTime + @iTotalPlayTime,
                        m_tmAccFuel             = @im_tmAccFuel,
                        m_dwSkillPoint          = @im_dwSkillPoint,
                        m_dwReturnWorldID= @im_dwReturnWorldID,
                        m_vReturnPos_x      = @im_vReturnPos_x,
                        m_vReturnPos_y      = @im_vReturnPos_y,
                        m_vReturnPos_z      = @im_vReturnPos_z,
                        m_SkillPoint        =@im_SkillPoint,
                        m_SkillLv           =@im_SkillLv,
                        m_SkillExp                      =@im_SkillExp
                      -------------- (A©¬¡Æ¢® ¨¬I¨¬¨¢ : 2006 11 13 Attendant Event)
                        , dwEventFlag                     =@idwEventFlag
                        , dwEventTime                     =@idwEventTime
                        , dwEventElapsed          =@idwEventElapsed
                      -------------- (ADD: Version8-PK System)

                        , PKValue           = @im_nPKValue
                        , PKPropensity      = @im_dwPKPropensity
                        , PKExp             = @im_dwPKExp
                      -------------- (ADD: Version8-Angel System)
                        , AngelExp          = @im_nAngelExp
                        , AngelLevel        = @im_nAngelLevel
                    --------------------- Version9 Pet
                        , m_dwPetId = @im_dwPetId

                        , m_nExpLog = @im_nExpLog
                        , m_nAngelExpLog = @im_nAngelExpLog
                        , m_nCoupon = @im_nCoupon
                        ------------- ver. 13
                        , m_nHonor = @im_nHonor
                        , m_nLayer = @im_nLayer
                        ---------- Ver 15
                        , m_aCheckedQuest = @im_aCheckedQuest
                        , m_nCampusPoint = @im_nCampusPoint
                        , idCampus = @im_idCampus
                WHERE   m_idPlayer                              = @im_idPlayer
                AND     serverindex                 = @iserverindex

--      if object_id('QUEST_TBL') is not null
--          EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray

UPDATE tblLogout_Penya
SET m_dwGold = @im_dwGold, regdate = getdate()
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex

        IF @im_nLevel>=120 BEGIN
            UPDATE  CHARACTER_TBL
                SET FinalLevelDt=getdate()
            WHERE   serverindex=@iserverindex
                AND m_idPlayer=@im_idPlayer
                AND FinalLevelDt='2000-01-01'
        END

        --¨ùUCo¨ù¢ç ¢¯aA¡í¡ícC¡¿ ¨¬o¢¬¥ì ¡Æu¡¤A
        IF @im_dwSMTime > ''
            BEGIN
                IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer  AND serverindex     = @iserverindex)
                UPDATE BILING_ITEM_TBL
                        SET m_dwSMTime = @im_dwSMTime
                 WHERE  m_idPlayer                  = @im_idPlayer
                      AND   serverindex                 = @iserverindex
                ELSE
                INSERT BILING_ITEM_TBL
                    (m_idPlayer,serverindex,m_dwSMTime)
                VALUES
                    (@im_idPlayer,@iserverindex,@im_dwSMTime)
            END
        ELSE
             DELETE BILING_ITEM_TBL
             WHERE  m_idPlayer                  = @im_idPlayer
                  AND   serverindex                 = @iserverindex


--      UPDATE  CARD_CUBE_TBL
--              SET m_Card                      = @im_Card,
--                      m_apIndex_Card      = @im_Index_Card,
--                      m_dwObjIndex_Card= @im_ObjIndex_Card,
--                      m_Cube                      = @im_Cube,
--                      m_apIndex_Cube  = @im_Index_Cube,
--                      m_dwObjIndex_Cube=@im_ObjIndex_Cube
--       WHERE  m_idPlayer                  = @im_idPlayer
--            AND   serverindex                 = @iserverindex

        UPDATE INVENTORY_TBL
              SET   m_Inventory                 = @im_Inventory,
                        m_apIndex               = @im_apIndex,
                        m_adwEquipment  = @im_adwEquipment,
                        m_dwObjIndex            = @im_dwObjIndex
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex



        UPDATE TASKBAR_TBL
              SET   m_aSlotApplet           = @im_aSlotApplet,
                        m_aSlotQueue            = @im_aSlotQueue,
                        m_SkillBar                  = @im_SkillBar
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex




        UPDATE TASKBAR_ITEM_TBL
              SET   m_aSlotItem                 = @im_aSlotItem
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex

        UPDATE BANK_TBL
              SET   m_Bank                      = @im_Bank,
                        m_apIndex_Bank      = @im_apIndex_Bank,
                        m_dwObjIndex_Bank = @im_dwObjIndex_Bank,
                        m_dwGoldBank        = @im_dwGoldBank
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex

        UPDATE SKILLINFLUENCE_TBL
             SET SkillInfluence = @iSkillInfluence
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex

        UPDATE INVENTORY_EXT_TBL
              SET   m_extInventory              = @im_extInventory,
                        m_InventoryPiercing= @im_InventoryPiercing
            ,szInventoryPet = @iszInventoryPet
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex

        UPDATE BANK_EXT_TBL
              SET   m_extBank                       = @im_extBank,
                        m_BankPiercing          = @im_BankPiercing
            , szBankPet = @iszBankPet
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex

        SELECT fError = '1', fText = 'OK'
        RETURN
    END
/*

    A¢´¨¬¢¬¨ú¡À¥ì¡ÍAI¨¡¢ç
     ex )
     CHARACTER_STR 'C1', ALL ...
     CHARACTER_STR 'C1','000001','01' ...
*/

ELSE
IF @iGu = 'U2' --AN AI¢¯e¨öA¡Æ¡Ì ¨ùoA¢´
    BEGIN
        UPDATE CHARACTER_TBL
              SET   TotalPlayTime           = TotalPlayTime + @iplayerslot
         WHERE  m_szName                = @im_szName
              AND   serverindex                 = @iserverindex
        RETURN
    END
/*

    AN AI¢¯e¨öA¡Æ¡Ì ¨ùoA¢´
     ex )
     CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime)
     CHARACTER_STR 'U2','','01','','beat',10234
*/

ELSE
IF @iGu = 'U3' --AN AI¢¯e¨öA¡Æ¡Ì ¨ùoA¢´ new
    BEGIN
        UPDATE CHARACTER_TBL
              SET   TotalPlayTime           = TotalPlayTime + @iplayerslot
         WHERE  m_idPlayer                  = @im_idPlayer
              AND   serverindex                 = @iserverindex
        RETURN
    END
/*

    AN AI¢¯e¨öA¡Æ¡Ì ¨ùoA¢´ (new)
     ex )
     CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime)
     CHARACTER_STR 'U3','000001','01','','',10234
*/

ELSE
IF @iGu = 'U4' --A©ø¢¬?AI ¢¬i ¨¬?¡Æ©¡
    BEGIN
        IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_szName  = @im_szName  AND serverindex    = @iserverindex)
            BEGIN
                SELECT fError = '0'
            END
        ELSE
            BEGIN
                UPDATE CHARACTER_TBL
                      SET   m_szName            = @im_szName
                 WHERE  m_idPlayer                  = @im_idPlayer
                      AND   serverindex                 = @iserverindex
                SELECT fError = '1'
            END
        RETURN
    END


-- Ver 15
ELSE
IF @iGu = 'U5' --¡ícA| ¨¡¡ÀAI¨¡¢ç ¨ú¡À¥ì¡ÍAI¨¡¢ç A©¬¡Æ¢®
    BEGIN
        IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex  = @iserverindex)
            BEGIN
                UPDATE CHARACTER_TBL
                      SET   m_nCampusPoint          = m_nCampusPoint + @iplayerslot
                 WHERE  m_idPlayer                  = @im_idPlayer
                      AND   serverindex                 = @iserverindex

                DECLARE @u5m_nCampusPoint INT

                SELECT @u5m_nCampusPoint = m_nCampusPoint FROM CHARACTER_TBL (nolock) WHERE  m_idPlayer = @im_idPlayer AND serverindex  = @iserverindex
                SELECT fError = '1', @u5m_nCampusPoint  m_nCampusPoint
            END
        ELSE
        RETURN
    END
ELSE
IF @iGu = 'U6' -- ¡ícA| ID ¨ú¡À¥ì¡ÍAI¨¡¢ç A©¬¡Æ¢®
    BEGIN
        IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE  m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
            BEGIN
                UPDATE CHARACTER_TBL
                      SET   idCampus            = @iplayerslot
                 WHERE  m_idPlayer                  = @im_idPlayer
                      AND   serverindex                 = @iserverindex
                SELECT fError = '1'
            END
        ELSE
            BEGIN
                SELECT fError = '0'
            END
        RETURN
    END

/*


    A©ø¢¬?AI ¢¬i ¨¬?¡Æ©¡
     ex )
     CHARACTER_STR 'U4',@im_idPlayer,@iserverindex,@iaccount,@im_szName
     CHARACTER_STR 'U4','000001','01','','¡íu¨¬¡Æ¡Æ©ªAO'
*/
ELSE
IF @iGu = 'D1' -- A©ø¢¬?AI ¡íeA|
    BEGIN
        IF @im_szName = ''
        BEGIN
            SELECT fError = '1', fText = '2A¡À ¨¬n©ö¨¢©ö©ªE¡Ì ¨¡©÷¢¬©÷'
            RETURN
        END
            IF NOT EXISTS (SELECT * FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND account = @iaccount AND serverindex = @iserverindex)
            BEGIN
                SELECT fError = '1'
                RETURN
            END

            DECLARE @EXISTS INT
/*
            IF EXISTS(SELECT name  from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN')
                BEGIN
                    IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL  WHERE account = @iaccount AND (password =  @im_szName OR member = 'B' ))
                      SET @Exists = 1
                    ELSE
                        SET @Exists = 0
                END
            ELSE
                BEGIN
--                  IF EXISTS(SELECT *  FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL  WHERE account = @iaccount AND (id_no2 =  @im_szName OR member = 'B' ))
                    if exists (select  *  from BANK_TBL (nolock) where m_idPlayer = @im_idPlayer AND m_BankPw =  @im_szName )
                      SET @Exists = 1
                    ELSE
                        SET @Exists = 0
                END
*/
SET @EXISTS = 1
            IF @EXISTS > 0
                BEGIN
                    DECLARE @currDate CHAR(12)
                    SET @currDate = CONVERT(CHAR(8),GETDATE(),112)
                                               + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
                                               + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)



                    IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE     m_idPlayer = @im_idPlayer AND serverindex = @iserverindex   AND m_idWar > 0)
                        BEGIN
                        SELECT fError = '3', fText = '¡¾©¡¥ìaAuA©¬'
                        RETURN
                        END
                    ELSE
                        BEGIN
                        UPDATE CHARACTER_TBL
                              SET isblock                       = 'D',
                                      End_Time                      = @currDate ,
                                      BlockTime                 = LEFT(@currDate,8)
                        WHERE   m_idPlayer                  = @im_idPlayer
                              AND   serverindex                 = @iserverindex

                        UPDATE MESSENGER_TBL
                               SET State = 'D'
                         WHERE  m_idPlayer                  = @im_idPlayer
                              AND   serverindex                 = @iserverindex

                        UPDATE MESSENGER_TBL
                               SET State = 'D'
                         WHERE  f_idPlayer                  = @im_idPlayer
                              AND   serverindex                 = @iserverindex



                        IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL   WHERE   m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
                            BEGIN
                                SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL   WHERE    m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
                                RETURN

                            END
                        ELSE
                            BEGIN
                                SELECT fError = '0', fText = 'DELETE OK'
                                RETURN
                            END

                        END
                END
            ELSE
                BEGIN
                    SELECT fError = '1', fText = 'AO©öI©ö©ªE¡Ì¨¡©÷¢¬©÷'
                    RETURN
                END
    END
/*

    A©ø¢¬?AI ¡íeA|
     ex )
     CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock)
     CHARACTER_STR 'D1','001068','01','ata3k','1019311'

*/

ELSE
IF @iGu = 'I1' -- ?? ?? ??
    BEGIN
            IF EXISTS(SELECT playerslot FROM CHARACTER_TBL WHERE account = @iaccount AND playerslot = 0 AND isblock = 'F')
            IF EXISTS(SELECT playerslot FROM CHARACTER_TBL WHERE account = @iaccount AND playerslot = 1 AND isblock = 'F')
            IF EXISTS(SELECT playerslot FROM CHARACTER_TBL WHERE account = @iaccount AND playerslot = 2 AND isblock = 'F')
  BEGIN
   SELECT fError = '0', fText = 'Slot belegt!'
   RETURN
  END

 DECLARE @i1_cnt INT
 SELECT @i1_cnt = COUNT(*) FROM CHARACTER_TBL WHERE account = @iaccount AND isblock = 'F'
 IF @i1_cnt > 2
 BEGIN
  SELECT  fError = '0', fText = 'Too many chars!'
  RETURN
 END

    IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
          WHERE (( LOWER(m_szName) = LOWER(@im_szName) ) OR (playerslot = @iPlayerslot AND account = @iaccount  ) ) AND isblock = 'F' AND serverindex = @iserverindex )
        BEGIN
            SELECT  fError = '0', fText = 'Can not overwrite player!' -- fix char overwrite
            RETURN
        END
    ELSE
        BEGIN
            DECLARE
                                @om_idPlayer                    CHAR        (7)     ,
                                @om_vScale_x                    REAL                    ,
                                @om_dwMotion                    INT                     ,
                                @om_fAngle                      REAL                    ,
                                @om_nHitPoint                   INT                     ,
                                @om_nManaPoint              INT                     ,
                                @om_nFatiguePoint           INT                     ,
                                @om_dwRideItemIdx       INT                     ,
                                @om_dwGold                  INT                     ,
                                @om_nJob                            INT                     ,
                                @om_pActMover               VARCHAR(50) ,
                                @om_nStr                            INT                     ,
                                @om_nSta                            INT                     ,
                                @om_nDex                            INT                     ,
                                @om_nInt                            INT                     ,
                                @om_nLevel                      INT                     ,
                                @om_nExp1                       BIGINT                      ,
                                @om_nExp2                       BIGINT                      ,
                                @om_aJobSkill                   VARCHAR (500),
                                @om_aLicenseSkill           VARCHAR (500),
                                @om_aJobLv                      VARCHAR (500),
                                @om_dwExpertLv              INT                     ,
                                @om_idMarkingWorld      INT                     ,
                                @om_vMarkingPos_x       REAL                    ,
                                @om_vMarkingPos_y       REAL                    ,
                                @om_vMarkingPos_z       REAL                    ,
                                @om_nRemainGP               INT                     ,
                                @om_nRemainLP               INT                     ,
                                @om_nFlightLv                   INT                     ,
                                @om_nFxp                            INT                     ,
                                @om_nTxp                            INT                     ,
                                @om_lpQuestCntArray     VARCHAR(1024),
                                @om_chAuthority             CHAR(1)             ,
                                @om_dwMode                  INT                     ,
                                @oblockby                           VARCHAR(32) ,
                                @oTotalPlayTime             INT                     ,
                                @oisblock                           CHAR(1)             ,
                                @oEnd_Time                      CHAR(12)    ,
                                @om_Inventory                   VARCHAR(MAX),
                                @om_apIndex                 VARCHAR(1000)   ,
                                @om_adwEquipment        VARCHAR(135)    ,
                                @om_aSlotApplet             VARCHAR(3100),
                                @om_aSlotItem                   VARCHAR(6885),
                                @om_aSlotQueue              VARCHAR(225),
                                @om_SkillBar                        SMALLINT,
                                @om_dwObjIndex              VARCHAR(1000)   ,
                                @om_Card                            VARCHAR(1980),
                                @om_Cube                        VARCHAR(1980),
                                @om_apIndex_Card            VARCHAR(215)    ,
                                @om_dwObjIndex_Card VARCHAR(215)    ,
                                @om_apIndex_Cube        VARCHAR(215)    ,
                                @om_dwObjIndex_Cube VARCHAR(215)    ,
                                @om_idparty                     INT                     ,
                                @om_idMuerderer         INT                     ,
                                @om_nFame                       INT                     ,
                                @om_nDeathExp               BIGINT                      ,
                                @om_nDeathLevel         INT                     ,
                                @om_dwFlyTime               INT                     ,
                                @om_nMessengerState INT                     ,
                                @om_Bank                            VARCHAR(4290),
                                @om_apIndex_Bank            VARCHAR(215)    ,
                                @om_dwObjIndex_Bank VARCHAR(215)    ,
                                @om_dwGoldBank          INT
                                ---------- Ver 15
                                , @om_aCheckedQuest VARCHAR(100)
                                , @om_nCampusPoint INT
                                , @om_idCampus INT

                 IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE  serverindex = @iserverindex)
                 SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7)
                   FROM CHARACTER_TBL
                  WHERE  serverindex = @iserverindex
                ELSE
                SELECT @om_idPlayer = '0000001'

                 SELECT @om_vScale_x                = m_vScale_x,
                                @om_dwMotion                = m_dwMotion,
                                @om_fAngle                      = m_fAngle,
                                @om_nHitPoint                   = m_nHitPoint,
                                @om_nManaPoint          = m_nManaPoint,
                                @om_nFatiguePoint           = m_nFatiguePoint,
                                @om_dwRideItemIdx       = m_dwRideItemIdx,
                                @om_dwGold                  = m_dwGold,
                                @om_nJob                        = m_nJob,
                                @om_pActMover               = m_pActMover,
                                @om_nStr                            = m_nStr,

                                @om_nSta                            = m_nSta,
                                @om_nDex                        = m_nDex,
                                @om_nInt                            = m_nInt,
                                @om_nLevel                      = m_nLevel,
                                @om_nExp1                       = m_nExp1,
                                @om_nExp2                       = m_nExp2,

                                @om_aJobSkill                   = m_aJobSkill,
                                @om_aLicenseSkill           = m_aLicenseSkill,
                                @om_aJobLv                  = m_aJobLv,
                                @om_dwExpertLv              = m_dwExpertLv,
                                @om_idMarkingWorld      = m_idMarkingWorld,
                                @om_vMarkingPos_x       = m_vMarkingPos_x,
                                @om_vMarkingPos_y       = m_vMarkingPos_y,
                                @om_vMarkingPos_z       = m_vMarkingPos_z,
                                @om_nRemainGP           = m_nRemainGP,
                                @om_nRemainLP           = m_nRemainLP,
                                @om_nFlightLv                   = m_nFlightLv,
                                @om_nFxp                        = m_nFxp,
                                @om_nTxp                        = m_nTxp,
                                @om_lpQuestCntArray     = m_lpQuestCntArray,
                                @om_chAuthority                 = m_chAuthority,
                                @om_dwMode                  = m_dwMode,
                                @oblockby                       = blockby,
                                @oTotalPlayTime                 = TotalPlayTime,
                                @oisblock                           = isblock,
                                @oEnd_Time                  = CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000',
                                @om_Inventory                   = m_Inventory,
                                @om_apIndex                     = m_apIndex,
                                @om_adwEquipment        = m_adwEquipment,
                                @om_aSlotApplet                 = m_aSlotApplet,
                                @om_aSlotItem                   = m_aSlotItem,
                                @om_aSlotQueue          = m_aSlotQueue,
                                @om_SkillBar                        = m_SkillBar,
                                @om_dwObjIndex          = m_dwObjIndex,
                                @om_Card                        = m_Card,
                                @om_Cube                        = m_Cube,
                                @om_apIndex_Card        = m_apIndex_Card,
                                @om_dwObjIndex_Card = m_dwObjIndex_Card,
                                @om_apIndex_Cube        = m_apIndex_Cube,
                                @om_dwObjIndex_Cube = m_dwObjIndex_Cube,
                                @om_idparty                         = m_idparty,
                                @om_idMuerderer             = m_idMuerderer,
                                @om_nFame                       = m_nFame,
                                @om_nDeathExp               = m_nDeathExp,
                                @om_nDeathLevel         = m_nDeathLevel,
                                @om_dwFlyTime               = m_dwFlyTime,
                                @om_nMessengerState     = m_nMessengerState,
                                @om_Bank                            = m_Bank,
                                @om_apIndex_Bank            = m_apIndex_Bank,
                                @om_dwObjIndex_Bank     = m_dwObjIndex_Bank,
                                @om_dwGoldBank          = m_dwGoldBank

                   FROM BASE_VALUE_TBL
                 WHERE g_nSex                               = @im_dwSex



                INSERT CHARACTER_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                account,
                                m_szName,
                                playerslot,
                                dwWorldID,
                                m_dwIndex,
                                m_vScale_x,
                                m_dwMotion,
                                m_vPos_x,
                                m_vPos_y,
                                m_vPos_z,
                                m_fAngle,
                                m_szCharacterKey,
                                m_nHitPoint,
                                m_nManaPoint,
                                m_nFatiguePoint,
                                m_nFuel,
                                m_dwSkinSet,
                                m_dwHairMesh,
                                m_dwHairColor,
                                m_dwHeadMesh,
                                m_dwSex,
                                m_dwRideItemIdx,
                                m_dwGold,
                                m_nJob,
                                m_pActMover,
                                m_nStr,
                                m_nSta,
                                m_nDex,
                                m_nInt,
                                m_nLevel,
                                m_nMaximumLevel,
                                m_nExp1,
                                m_nExp2,
                                m_aJobSkill,
                                m_aLicenseSkill,
                                m_aJobLv,
                                m_dwExpertLv,
                                m_idMarkingWorld,
                                m_vMarkingPos_x,
                                m_vMarkingPos_y,
                                m_vMarkingPos_z,
                                m_nRemainGP,
                                m_nRemainLP,
                                m_nFlightLv,
                                m_nFxp,
                                m_nTxp,
                                m_lpQuestCntArray,
                                m_aCompleteQuest,
                                m_chAuthority,
                                m_dwMode,
                                m_idparty,
                                m_idCompany,
                                m_idMuerderer,
                                m_nFame,
                                m_nDeathExp,
                                m_nDeathLevel,
                                m_dwFlyTime,
                                m_nMessengerState,
                                blockby,
                                TotalPlayTime,
                                isblock,
                                End_Time,
                                BlockTime,
                                CreateTime,
                                m_tmAccFuel,
                                m_tGuildMember,
                                m_dwSkillPoint,
                                m_dwReturnWorldID,
                                m_vReturnPos_x,
                                m_vReturnPos_y,
                                m_vReturnPos_z,
                                m_SkillPoint,
                                m_SkillLv,
                                m_SkillExp
                                ---------- Ver 15
                                , m_aCheckedQuest
                                , m_nCampusPoint
                                , idCampus
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                @iaccount,
                                @im_szName,
                                @iplayerslot,
                                @idwWorldID,
                                @im_dwIndex,
                                @om_vScale_x,
                                @om_dwMotion,
                                @im_vPos_x,

                                @im_vPos_y,
                                @im_vPos_z,
                                @om_fAngle,
                                @im_szCharacterKey,
                                @om_nHitPoint,
                                @om_nManaPoint,
                                @om_nFatiguePoint,
                                -1, --m_nFuel
                                @im_dwSkinSet,
                                @im_dwHairMesh,
                                @im_dwHairColor,
                                @im_dwHeadMesh,
                                @im_dwSex,
                                @om_dwRideItemIdx,
                                @om_dwGold,
                                @om_nJob,
                                @om_pActMover,
                                @om_nStr,
                                @om_nSta,
                                @om_nDex,
                                @om_nInt,
                                @om_nLevel,
                                1, --m_nMaximumLevel
                                @om_nExp1,
                                @om_nExp2,
                                @om_aJobSkill,
                                @om_aLicenseSkill,
                                @om_aJobLv,
                                @om_dwExpertLv,
                                @om_idMarkingWorld,
                                @om_vMarkingPos_x,
                                @om_vMarkingPos_y,
                                @om_vMarkingPos_z,
                                @om_nRemainGP,
                                @om_nRemainLP,
                                @om_nFlightLv,
                                @om_nFxp,
                                @om_nTxp,
                                @om_lpQuestCntArray,
                                '$', -- m_aCompleteQuest
                                @om_chAuthority,
                                @om_dwMode,
                                @om_idparty,
                                '000000', -- m_idCompany
                                @om_idMuerderer,
                                @om_nFame,
                                @om_nDeathExp,
                                @om_nDeathLevel,
                                @om_dwFlyTime   ,
                                @om_nMessengerState,
                                @oblockby,
                                @oTotalPlayTime,
                                @oisblock,
                                @oEnd_Time,
                                CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
                                GETDATE(),
                                0,
                                CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
                                    + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
                                    + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
                                    + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
                                0, --m_dwSkillPoint
                                                    1,
                                                    0,
                                                    0,
                                                    0,
                            @im_SkillPoint,
                            @im_SkillLv,
                            @im_SkillExp
                            -- Ver 15
                            , '$'
                            , 0
                            , 0
                            )


                INSERT INVENTORY_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                m_Inventory,
                                m_apIndex,
                                m_adwEquipment,
                                m_dwObjIndex
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                @om_Inventory,
                                @om_apIndex,
                                @om_adwEquipment,
                                @om_dwObjIndex
                            )


--              INSERT CARD_CUBE_TBL
--                          (
--                              m_idPlayer,
--                              serverindex,
--                              m_Card,
--                              m_Cube,
--                              m_apIndex_Card,
--                              m_dwObjIndex_Card,
--                              m_apIndex_Cube,
--                              m_dwObjIndex_Cube
--                          )
--              VALUES
--                          (
--                              @om_idPlayer,
--                              @iserverindex,
--                              @om_Card,
--                              @om_Cube,
--                              @om_apIndex_Card,
--                              @om_dwObjIndex_Card,
--                              @om_apIndex_Cube,
--                              @om_dwObjIndex_Cube
--                          )



                IF @@SERVERNAME = 'WEB' OR  @@SERVERNAME = 'SERVER4'
                SET @om_aSlotApplet = '0,2,400,0,0,0,0/1,2,398,0,1,0,0/2,2,2010,0,2,0,0/3,2,1005,0,3,0,0/4,3,25,0,4,0,0/$'

                INSERT TASKBAR_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                m_aSlotApplet,
                                m_aSlotQueue,
                                m_SkillBar

                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                @om_aSlotApplet,
                                @om_aSlotQueue,
                                @om_SkillBar
                            )


                INSERT TASKBAR_ITEM_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                m_aSlotItem
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                @om_aSlotItem
                            )
            INSERT BANK_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                m_Bank,
                                m_BankPw,
                                m_apIndex_Bank,
                                m_dwObjIndex_Bank ,
                                m_dwGoldBank
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                @om_Bank,
                                '0000', -- m_BankPw
--                              @im_BankPW,
                                @om_apIndex_Bank,
                                @om_dwObjIndex_Bank,
                                @om_dwGoldBank
                            )

        INSERT SKILLINFLUENCE_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                SkillInfluence
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                '$'
                            )

        INSERT INVENTORY_EXT_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                m_extInventory,
                                m_InventoryPiercing
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                '$','$'
                            )

        INSERT BANK_EXT_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                m_extBank,
                                m_BankPiercing
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                '$','$'
                            )

        -- Skill Information
        INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
            VALUES (@iserverindex, @om_idPlayer, 1, 0, 0)
        INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
            VALUES (@iserverindex, @om_idPlayer, 2, 0, 1)
        INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
            VALUES (@iserverindex, @om_idPlayer, 3, 0, 2)

        -- Pocket
    INSERT  tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
    VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 )

    INSERT  tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
    VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' )

    INSERT  tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
    VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 )

    INSERT  tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
    VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' )

    INSERT  tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
    VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 )

    INSERT  tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
    VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' )

    ------------------- ver. 13
    INSERT INTO tblMaster_all (serverindex, m_idPlayer, sec)
    SELECT @iserverindex, @om_idPlayer, 1
    INSERT INTO tblMaster_all (serverindex, m_idPlayer, sec)
    SELECT @iserverindex, @om_idPlayer, 2
    INSERT INTO tblMaster_all (serverindex, m_idPlayer, sec)
    SELECT @iserverindex, @om_idPlayer, 3

    ------------------- ver. 15
    INSERT INTO tblRestPoint (serverindex, m_idPlayer)
    SELECT @iserverindex, @om_idPlayer

    ------------ Penay check default setting
    INSERT INTO tblLogout_Penya (serverindex, m_idPlayer)
    SELECT @iserverindex, @om_idPlayer


        SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer
        RETURN
        END
    END

/*


     ex )
     CHARACTER_STR 'I1','',@iserverindex,@iaccount,@im_szName,@iplayerslot,@idwWorldID,
                                            @im_dwIndex,@im_vPos_x,@im_vPos_y,@im_vPos_z,@im_szCharacterKey,
                                            @im_dwSkinSet,@im_dwHairMesh,@im_dwHairColor,@im_dwHeadMesh,@im_dwSex
     CHARACTER_STR 'I1','','01','beat','¡íu¨¬¡Æ¡Æ©ªAO3',0,0,
                                            0,0,0,0,'',
                                            0,0,0,0,0

*/
SET nocount off
RETURN