FragenThread [Offi V15][OLD]

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

  • [FONT="Tahoma"][COLOR="LemonChiffon"][SIZE="2"]So, ich frage beileibe nicht oft und versuch es ja immer selber aber hier steck ich fest.

    Sobald ich einen Character erstellen will: Charactername bereits in verwenundung.

    Fehler aus Error.txt files:

    Quellcode

    1. 2010/04/26 13:32:16
    2. query:CHARACTER_STR 'I1',@im_idPlayer='0000000',@iserverindex='01',@iaccount='cross',@im_szName='Testcharacter1',@iplayerslot=1,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=6971.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=1,@im_dwHairColor=-329126,@im_dwHeadMesh=2,@im_dwSex=1,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
    3. SQLSTATE:23000 error:[Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'PK_tblMultiServerInfo'. Cannot insert duplicate key in object 'dbo.tblMultiServerInfo'.
    4. 2010/04/26 13:32:16
    5. query:CHARACTER_STR 'I1',@im_idPlayer='0000000',@iserverindex='01',@iaccount='cross',@im_szName='Testcharacter1',@iplayerslot=1,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=6971.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=1,@im_dwHairColor=-329126,@im_dwHeadMesh=2,@im_dwSex=1,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
    6. SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.


    Character_01 odbc ist auf english gestellt.

    hat jemand ne idee für mich?[/SIZE][/COLOR][/FONT]

  • Cross;113673 schrieb:

    [FONT="Tahoma"][COLOR="LemonChiffon"][SIZE="2"]So, ich frage beileibe nicht oft und versuch es ja immer selber aber hier steck ich fest.

    Sobald ich einen Character erstellen will: Charactername bereits in verwenundung.

    Fehler aus Error.txt files:

    Quellcode

    1. 2010/04/26 13:32:16
    2. query:CHARACTER_STR 'I1',@im_idPlayer='0000000',@iserverindex='01',@iaccount='cross',@im_szName='Testcharacter1',@iplayerslot=1,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=6971.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=1,@im_dwHairColor=-329126,@im_dwHeadMesh=2,@im_dwSex=1,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
    3. SQLSTATE:23000 error:[Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'PK_tblMultiServerInfo'. Cannot insert duplicate key in object 'dbo.tblMultiServerInfo'.
    4. 2010/04/26 13:32:16
    5. query:CHARACTER_STR 'I1',@im_idPlayer='0000000',@iserverindex='01',@iaccount='cross',@im_szName='Testcharacter1',@iplayerslot=1,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=6971.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=1,@im_dwHairColor=-329126,@im_dwHeadMesh=2,@im_dwSex=1,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
    6. SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.


    Character_01 odbc ist auf english gestellt.

    hat jemand ne idee für mich?[/SIZE][/COLOR][/FONT]


    Ich hatte gersten einen ähnlichen error. Liegt an der Char STR.

    Silla;113674 schrieb:

    ya stimme ich sedrika zu simon du hast selbst nichts drauf und flamest hier rum...omg also vote for ban...würde ich dazu nur noch sagen...
    Mffg:Silla


    Krich nicht in mein arsch xD
    Wenn simon nichts kann ist es seine sache. Failed at failing.
    Ich werde ban happy hab aber kein recht xD

  • [FONT="Tahoma"][COLOR="LemonChiffon"][SIZE="2"]

    Epic;113676 schrieb:

    @cross du hast das selbe problem wie ich^^

    character_str wird nicht erstellt^^


    Quellcode

    1. ALTER proc [dbo].[CHARACTER_STR]
    2. @iGu CHAR(2) = 'S1',
    3. @im_idPlayer CHAR(7) = '0000001',
    4. @iserverindex CHAR(2) = '01',
    5. /**********************************************
    6. INSERT 용
    7. **********************************************/
    8. -- CHARACTER_TBL
    9. @iaccount VARCHAR(32) = '',
    10. @im_szName VARCHAR(32) = '',
    11. @iplayerslot INT = 0,
    12. @idwWorldID INT = 0,
    13. @im_dwIndex INT = 0,
    14. @im_vPos_x REAL = 0,
    15. @im_vPos_y REAL = 0,
    16. @im_vPos_z REAL = 0,
    17. @im_szCharacterKey VARCHAR(32) = '',
    18. @im_dwSkinSet INT = 0,
    19. @im_dwHairMesh INT = 0,
    20. @im_dwHairColor INT = 0,
    21. @im_dwHeadMesh INT = 0,
    22. @im_dwSex INT = 0,
    23. /**********************************************
    24. UPDATE 용
    25. **********************************************/
    26. -- CHARACTER_TBL
    27. @im_vScale_x REAL = 0,
    28. @im_dwMotion INT = 0,
    29. @im_fAngle REAL = 0,
    30. @im_nHitPoint INT = 0,
    31. @im_nManaPoint INT = 0,
    32. @im_nFatiguePoint INT = 0,
    33. @im_dwRideItemIdx INT = 0,
    34. @im_dwGold INT = 0,
    35. @im_nJob INT = 0,
    36. @im_pActMover VARCHAR(50) = '',
    37. @im_nStr INT = 0,
    38. @im_nSta INT = 0,
    39. @im_nDex INT = 0,
    40. @im_nInt INT = 0,
    41. @im_nLevel INT = 0,
    42. @im_nExp1 BIGINT = 0,
    43. @im_nExp2 BIGINT = 0,
    44. @im_aJobSkill VARCHAR(500) ='',
    45. @im_aLicenseSkill VARCHAR(500) ='',
    46. @im_aJobLv VARCHAR(500) ='',
    47. @im_dwExpertLv INT = 0,
    48. @im_idMarkingWorld INT = 0,
    49. @im_vMarkingPos_x REAL = 0,
    50. @im_vMarkingPos_y REAL = 0,
    51. @im_vMarkingPos_z REAL = 0,
    52. @im_nRemainGP INT = 0,
    53. @im_nRemainLP INT = 0,
    54. @im_nFlightLv INT = 0,
    55. @im_nFxp INT = 0,
    56. @im_nTxp INT = 0,
    57. @im_lpQuestCntArray VARCHAR(3072)= '',
    58. @im_chAuthority CHAR(1) = '',
    59. @im_dwMode INT = 0,
    60. @im_idparty INT = 0,
    61. --@im_nNumKill INT = 0,
    62. @im_idMuerderer INT = 0,
    63. --@im_nSlaughter INT = 0,
    64. @im_nFame INT = 0,
    65. @im_nDeathExp BIGINT = 0,
    66. @im_nDeathLevel INT = 0,
    67. @im_dwFlyTime INT = 0,
    68. @im_nMessengerState INT = 0,
    69. @iTotalPlayTime INT = 0,
    70. ---------- 추가 시작 ----------
    71. -- PK Variable
    72. @im_nPKValue int=0,
    73. @im_dwPKPropensity int=0,
    74. @im_dwPKExp int=0,
    75. ---------- 추가 끝 ----------
    76. -- CARD_CUBE_TBL
    77. @im_Card VARCHAR(1980)= '',
    78. @im_Index_Card VARCHAR(215) = '',
    79. @im_ObjIndex_Card VARCHAR(215) = '',
    80. @im_Cube VARCHAR(1980)= '',
    81. @im_Index_Cube VARCHAR(215) = '',
    82. @im_ObjIndex_Cube VARCHAR(215) = '',
    83. -- INVENTORY_TBL
    84. @im_Inventory VARCHAR(6940)= '',
    85. @im_apIndex VARCHAR(345) = '',
    86. @im_adwEquipment VARCHAR(135) = '',
    87. @im_dwObjIndex VARCHAR(345) = '',
    88. -- TASKBAR_TBL
    89. @im_aSlotApplet VARCHAR(3100)= '',
    90. -- TASKBAR_ITEM_TBL
    91. @im_aSlotItem VARCHAR(6885)= '',
    92. -- TASKBAR_TBL
    93. @im_aSlotQueue VARCHAR(225)= '',
    94. @im_SkillBar SMALLINT = 0,
    95. -- BANK_TBL
    96. @im_Bank VARCHAR(4290)= '',
    97. @im_apIndex_Bank VARCHAR(215)= '',
    98. @im_dwObjIndex_Bank VARCHAR(215)= '',
    99. @im_dwGoldBank INT = 0,
    100. @im_nFuel INT = -1,
    101. @im_tmAccFuel INT = 0,
    102. @im_dwSMTime VARCHAR(2560)='',
    103. @iSkillInfluence varchar(2048) ='',
    104. @im_dwSkillPoint INT = 0,
    105. @im_aCompleteQuest varchar(1024) = '',
    106. @im_extInventory varchar(2000) = '',
    107. @im_extBank varchar(2000) = '',
    108. @im_InventoryPiercing varchar(8000) = '',
    109. @im_BankPiercing varchar(8000) = '',
    110. @im_dwReturnWorldID INT = 1,
    111. @im_vReturnPos_x REAL = 0,
    112. @im_vReturnPos_y REAL = 0,
    113. @im_vReturnPos_z REAL = 0
    114. -------------- ( Version 7 : Skill Update)
    115. , @im_SkillPoint int=0
    116. , @im_SkillLv int=0
    117. , @im_SkillExp bigint=0
    118. -------------- (추가 부분)
    119. , @idwEventFlag bigint=0,
    120. @idwEventTime int=0,
    121. @idwEventElapsed int=0
    122. -------------- (추가 부분)
    123. ----------추가 시작 ----------
    124. -- PVP (추가 시작)
    125. ,@im_nAngelExp bigint=0
    126. ,@im_nAngelLevel int=0
    127. ----------추가 끝 ----------
    128. --------------- Version 9 추가 부분 Pet관련
    129. ,@iszInventoryPet varchar(4200) = '$'
    130. ,@iszBankPet varchar(4200) = '$'
    131. ,@im_dwPetId int = -1
    132. ,@im_nExpLog int = 0
    133. ,@im_nAngelExpLog int = 0
    134. ---------------- Ver.11 Coupon
    135. , @im_nCoupon int = 0
    136. ---------------- Ver.13 Housing
    137. , @im_nHonor int = -1 --Master
    138. , @im_nLayer int = 0 --Housing
    139. ---------- Ver 15
    140. , @im_aCheckedQuest varchar(100) =''
    141. , @im_nCampusPoint int = 0
    142. , @im_idCampus int = 0
    145. /*******************************************************
    146. Gu 구분
    147. S : SELECT
    148. I : INSERT
    149. U : UPDATE
    150. D : DELETE
    153. 2005.04.11 updated
    155. ALTER TABLE CHARACTER_TBL ADD m_aCompleteQuest varchar(1024) NULL
    156. ALTER TABLE CHARACTER_TBL ALTER COLUMN m_lpQuestCntArray VARCHAR(3072) NULL
    158. *******************************************************/
    159. AS
    160. set nocount on
    161. declare @last_connect tinyint
    162. -- if (convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-19')
    163. -- begin
    164. -- IF @iGu IN ('S1','S2','S8')
    165. -- BEGIN
    166. -- if exists(SELECT * from RANKING.RANKING_DBF.dbo.last_1_month_tbl where account=(select account from CHARACTER_TBL WHERE m_idPlayer=@im_idPlayer and serverindex = @iserverindex))
    167. -- select @last_connect = 1
    168. -- else
    169. -- if exists(SELECT * from RANKING.RANKING_DBF.dbo.last_3_month_tbl where account=(select account from CHARACTER_TBL WHERE m_idPlayer=@im_idPlayer and serverindex = @iserverindex))
    170. -- select @last_connect = 3
    171. -- else
    172. -- begin
    173. -- select @last_connect = 0
    174. -- if not exists(select * from RANKING.RANKING_DBF.dbo.event_200507_tbl where account = (select account from CHARACTER_TBL WHERE m_idPlayer=@im_idPlayer and serverindex = @iserverindex))
    175. -- begin
    176. -- IF NOT EXISTS(SELECT * FROM CHARACTER_TBL WHERE m_idPlayer=@im_idPlayer and serverindex = @iserverindex and CreateTime > '2005-07-05')
    177. -- BEGIN
    178. -- INSERT ITEM_SEND_TBL
    179. -- (m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, End_Time, m_bItemResist, m_nResistAbilityOption, m_bCharged)
    180. -- VALUES
    181. -- (@im_idPlayer,@iserverindex,'행운의 상자',1,0,NULL,0,0,0)
    182. -- INSERT RANKING.RANKING_DBF.dbo.event_200507_tbl
    183. -- SELECT account,getdate() FROM CHARACTER_TBL WHERE m_idPlayer=@im_idPlayer and serverindex = @iserverindex
    184. -- END
    185. -- end
    186. -- end
    187. -- END
    188. -- end
    189. -- else
    190. set @last_connect = 1
    192. IF @iGu = 'S2' -- 슬롯에 따른 플레이어리스트 인벤토리정보 가져오기
    193. BEGIN
    194. IF @iaccount = '' OR @im_szName = ''
    195. BEGIN
    196. SELECT m_chAuthority = '',fError = '1', fText = '암호틀림'
    197. RETURN
    198. END
    199. SELECT A.dwWorldID,
    200. A.m_szName,
    201. A.playerslot,
    202. A.End_Time,
    203. A.BlockTime,
    204. A.m_dwIndex,
    205. A.m_idPlayer,
    206. A.m_idparty,
    207. A.m_dwSkinSet,
    208. A.m_dwHairMesh,
    209. A.m_dwHeadMesh,
    210. A.m_dwHairColor,
    211. A.m_dwSex,
    212. A.m_nJob,
    213. A.m_nLevel,
    214. A.m_vPos_x,
    215. A.m_vPos_y,
    216. A.m_vPos_z,
    217. A.m_nStr,
    218. A.m_nSta,
    219. A.m_nDex,
    220. A.m_nInt,
    221. --A.m_nSlaughter, -- raiders추가 2005.5.11
    222. A.m_aJobLv,
    223. A.m_chAuthority,
    224. A.m_idCompany,
    225. A.m_nMessengerState,
    226. B.m_Inventory,
    227. B.m_apIndex,
    228. B.m_adwEquipment,
    229. B.m_dwObjIndex,
    230. m_idGuild = CASE WHEN C.m_idGuild IS NULL THEN '0' ELSE C.m_idGuild END ,
    231. m_idWar = CASE WHEN C.m_idWar IS NULL THEN '0' ELSE C.m_idWar END,
    232. D.m_extInventory,
    233. D.m_InventoryPiercing,
    234. m_nHonor, -- 13 Ver. Master
    235. last_connect = @last_connect
    236. FROM CHARACTER_TBL as A inner join INVENTORY_TBL as B on A.serverindex = B.serverindex and A.m_idPlayer = B.m_idPlayer
    237. left outer join GUILD_MEMBER_TBL as C on A.serverindex = C.serverindex and A.m_idPlayer = C.m_idPlayer
    238. inner join INVENTORY_EXT_TBL as D on A.serverindex = D.serverindex and A.m_idPlayer = D.m_idPlayer
    239. WHERE A.m_idPlayer = B.m_idPlayer
    240. /*AND A.serverindex= B.serverindex
    241. AND B.m_idPlayer = D.m_idPlayer
    242. AND B.serverindex = D.serverindex
    243. AND D.m_idPlayer *= C.m_idPlayer
    244. AND D.serverindex *= C.serverindex*/
    245. AND A.isblock = 'F'
    246. AND A.account = @iaccount
    247. AND A.serverindex= @iserverindex
    248. ORDER BY A.playerslot
    250. insert into CHARACTER_TBL_penya_check (account, m_szName, m_dwGold, check_sec, serverindex)
    251. select @iaccount, m_szName, m_dwGold, 9, @iserverindex
    252. from CHARACTER_TBL (nolock)
    253. where account = @iaccount and serverindex = @iserverindex and TotalPlayTime < 1 and m_dwGold >= 1
    256. /* from CHARACTER_TBL as a inner join INVENTORY_TBL as B on a.serverindex = B.serverindex and a.m_idPlayer = b.m_idPlayer
    257. inner join INVENTOTY_EXT_TBL as d on b.serverindex = d.serverindex and b.m_idPlayer = d.m_idPlayer
    258. left outer join GUILD_MEMBER_TBL as c on d.serverindex = c.serverindex and d.m_idPlayer = c.m_idPlayer
    259. where a.account = @iaccount and a.serverindex = @iserverindex and a.isblock = 'F'
    260. order by a.playerslot*/
    261. RETURN
    262. END
    263. /*
    265. 슬롯에 따른 플레이어리스트 인벤토리정보 가져오기
    266. ex )
    267. CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
    268. CHARACTER_STR 'S2','0','02','seghope','1234'
    271. */
    273. ELSE
    274. IF @iGu = 'S3' -- 서버가 처음실행을 할대 캐릭터의 idPlayer를 다 가지고옴
    275. BEGIN
    276. SELECT m_szName, m_idPlayer,m_idCompany
    277. FROM CHARACTER_TBL
    278. WHERE serverindex = @iserverindex
    279. -- AND isblock = 'F'
    280. ORDER BY m_idPlayer
    281. RETURN
    282. END
    283. /*
    285. 서버가 처음실행을 할대 캐릭터의 idPlayer를 다 가지고옴
    286. ex )
    287. CHARACTER_STR 'S3','',@iserverindex
    288. CHARACTER_STR 'S3','','02'
    292. */
    294. ELSE
    295. IF @iGu = 'S4' -- 추가할 아이템 확인
    296. BEGIN
    297. declare @q1 nvarchar(4000)
    299. /* ------------ Valentine Event Start -------------*/
    300. IF getdate() >='2010-01-29 15:00:00' and getdate()<='2010-02-23 11:00:00'
    301. begin
    303. declare @S4_Create_Time datetime
    305. select @S4_Create_Time = CreateTime from CHARACTER_TBL (nolock)
    306. where m_idPlayer = @im_idPlayer and serverindex=@iserverindex
    308. IF @S4_Create_Time < '2010-02-05 09:00:00.000'
    309. begin
    311. declare @count_event char(1)
    313. select @count_event=count(*)
    314. from TB_VALENTINE_EVENT with (nolock)
    315. where Prodate = convert(char(8) ,getdate(),112) and m_idPlayer =@im_idPlayer
    318. IF @count_event = 0
    319. Begin
    321. declare @int_sex int
    323. select @int_sex=m_dwSex from CHARACTER_TBL with (nolock)
    324. where m_idPlayer=@im_idPlayer
    325. and serverindex=@iserverindex
    327. IF @int_sex = 0 -- male 26916 item , Female 26915
    328. begin
    330. insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_bCharged, idSender)
    331. select @im_idPlayer, @iserverindex, '26916', 2, 1, '0000000'
    333. end
    334. ELSE
    335. begin
    336. insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_bCharged, idSender)
    337. select @im_idPlayer, @iserverindex, '26915', 2, 1, '0000000'
    338. END
    342. insert into TB_VALENTINE_EVENT values ( convert(char(8) ,getdate(),112),@im_idPlayer,getdate())
    343. END
    344. END
    345. END
    347. /*
    348. CREATE TABLE dbo.TB_VALENTINE_EVENT
    349. (
    350. Prodate char(8) NOT NULL,
    351. m_idPlayer char(7) not null,
    352. regdate datetime NOT NULL
    353. ) ON [PRIMARY]
    355. */
    357. /* ------------ Valentine Event END -------------*/
    359. set @q1 = '
    360. SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
    361. m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId,
    362. 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,
    363. 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
    364. FROM ITEM_SEND_TBL
    365. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
    366. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
    367. /*
    368. SELECT Item_Name,
    369. Item_count,
    370. m_nAbilityOption,
    371. m_nNo,
    372. m_bItemResist,
    374. m_nResistAbilityOption,
    375. m_bCharged,
    376. nPiercedSize,
    377. adwItemId0,
    378. adwItemId1,
    379. adwItemId2,
    380. adwItemId3,
    381. m_dwKeepTime
    382. FROM ITEM_SEND_TBL
    383. WHERE m_idPlayer = @im_idPlayer
    384. AND serverindex = @iserverindex
    385. AND ItemFlag = 0
    386. */
    387. RETURN
    388. END
    389. /*
    392. 아이템 확인
    393. ex )
    394. CHARACTER_STR 'S4',@im_idPlayer,@iserverindex
    395. CHARACTER_STR 'S4','000001','01'
    397. */
    399. ELSE
    400. IF @iGu = 'S5' -- 아이템 지급후 테이블에서 아이템 삭제
    401. BEGIN
    402. -- DELETE ITEM_SEND_TBL
    403. UPDATE ITEM_SEND_TBL SET ItemFlag=1, ProvideDt=getdate()
    404. WHERE m_nNo = @iplayerslot
    405. IF @@ROWCOUNT = 0
    406. SELECT fError = '0'
    407. ELSE
    408. SELECT fError = '1'
    409. RETURN
    410. END
    411. /*
    413. 아이템 지급후 테이블에서 아이템 삭제
    414. ex )
    415. CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount
    416. CHARACTER_STR 'S5','000001','01','빗자루',1,1
    417. */
    419. ELSE
    420. IF @iGu = 'S6' -- 삭제할 아이템 확인
    421. BEGIN
    422. SELECT Item_Name,
    423. Item_count,
    424. m_nAbilityOption,
    425. m_nNo,
    426. State,
    427. m_bItemResist,
    428. m_nResistAbilityOption
    429. FROM ITEM_REMOVE_TBL
    430. WHERE m_idPlayer = @im_idPlayer
    431. AND serverindex = @iserverindex
    432. AND ItemFlag = 0
    433. RETURN
    434. END
    435. /*
    436. 아이템 확인
    437. ex )
    438. CHARACTER_STR 'S6',@im_idPlayer,@iserverindex
    439. CHARACTER_STR 'S6','000001','01'
    440. */
    442. ELSE
    443. IF @iGu = 'S7' -- 아이템 삭제후 테이블에서 아이템 삭제
    444. BEGIN
    445. -- DELETE ITEM_REMOVE_TBL
    446. UPDATE ITEM_REMOVE_TBL SET ItemFlag=1, DeleteDt=getdate()
    447. WHERE m_nNo = @iplayerslot
    448. IF @@ROWCOUNT = 0
    449. SELECT fError = '0'
    450. ELSE
    451. SELECT fError = '1'
    452. RETURN
    453. END
    454. /*
    455. 아이템 지급후 테이블에서 아이템 삭제
    456. ex )
    457. CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount
    458. CHARACTER_STR 'S7','000001','01','빗자루',1,1
    459. */
    461. IF @iGu = 'S8' -- 데이터 전체 가져오기
    462. BEGIN
    464. -- 뱅크 정보 가져오기 character 별
    465. DECLARE @om_chLoginAuthority CHAR(1)
    466. SELECT @om_chLoginAuthority = m_chLoginAuthority
    467. FROM ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL
    468. WHERE account = @iaccount
    470. SELECT m_chLoginAuthority = @om_chLoginAuthority,
    471. A.account,
    472. A.m_idPlayer,
    473. A.playerslot,
    474. A.serverindex,
    475. A.dwWorldID,
    476. A.m_szName,
    477. A.m_dwIndex,
    478. A.m_vScale_x,
    479. A.m_dwMotion,
    480. A.m_vPos_x,
    481. A.m_vPos_y,
    482. A.m_vPos_z,
    483. A.m_fAngle,
    484. A.m_szCharacterKey,
    485. A.m_idPlayer,
    486. A.m_nHitPoint,
    487. A.m_nManaPoint,
    488. A.m_nFatiguePoint,
    489. A.m_nFuel,
    490. A.m_dwSkinSet,
    491. A.m_dwHairMesh,
    492. A.m_dwHairColor,
    493. A.m_dwHeadMesh,
    494. A.m_dwSex,
    495. A.m_dwRideItemIdx,
    496. A.m_dwGold,
    497. A.m_nJob,
    498. A.m_pActMover,
    499. A.m_nStr,
    500. A.m_nSta,
    501. A.m_nDex,
    502. A.m_nInt,
    503. A.m_nLevel,
    504. A.m_nMaximumLevel,
    505. A.m_nExp1,
    506. A.m_nExp2,
    507. A.m_aJobSkill,
    508. A.m_aLicenseSkill,
    509. A.m_aJobLv,
    510. A.m_dwExpertLv,
    511. A.m_idMarkingWorld,
    512. A.m_vMarkingPos_x,
    513. A.m_vMarkingPos_y,
    514. A.m_vMarkingPos_z,
    515. A.m_nRemainGP,
    516. A.m_nRemainLP,
    517. A.m_nFlightLv,
    518. A.m_nFxp,
    519. A.m_nTxp,
    520. A.m_lpQuestCntArray,
    521. m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'),
    522. A.m_chAuthority,
    523. A.m_dwMode,
    524. A.m_idparty,
    525. A.m_idCompany,
    526. --A.m_nNumKill,
    527. A.m_idMuerderer,
    528. --A.m_nSlaughter,
    529. A.m_nFame,
    530. A.m_nDeathExp,
    531. A.m_nDeathLevel,
    532. A.m_dwFlyTime,
    533. A.m_nMessengerState,
    534. A.End_Time,
    535. A.BlockTime,
    536. A.blockby,
    537. A.isblock,
    538. A.TotalPlayTime,
    539. A.CreateTime,
    540. A.m_dwSkillPoint,
    541. B.m_aSlotApplet,
    542. B.m_aSlotQueue,
    543. B.m_SkillBar,
    544. C.m_aSlotItem,
    545. D.m_Inventory,
    546. D.m_apIndex,
    547. D.m_adwEquipment,
    548. D.m_dwObjIndex,
    549. m_idGuild = ISNULL(G.m_idGuild,'0'),
    551. m_idWar = ISNULL(G.m_idWar,'0'),
    552. A.m_tmAccFuel,
    554. A.m_tGuildMember,
    555. m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL') ,
    556. SkillInfluence = ISNULL(E.SkillInfluence,'$'),
    557. F.m_extInventory,
    558. F.m_InventoryPiercing,
    559. A.m_dwReturnWorldID,
    560. A.m_vReturnPos_x,
    561. A.m_vReturnPos_y,
    562. A.m_vReturnPos_z
    563. ------------------ ( ADD : Version7-Skill System)
    564. , m_SkillPoint = SkillPoint
    565. , m_SkillLv = SkillLv
    566. , m_SkillExp = SkillExp
    567. -------------- (추가 부분)
    568. ,A.dwEventFlag,
    569. A.dwEventTime,
    570. A.dwEventElapsed
    571. -------------- (추가 부분)
    572. ----------추가 시작 ----------
    573. , A.PKValue as m_nPKValue,
    574. A.PKPropensity as m_dwPKPropensity,
    575. A.PKExp as m_dwPKExp
    576. ----------추가 끝 ----------
    577. ----------추가 시작 ----------
    578. ,AngelExp as m_nAngelExp
    579. ,AngelLevel as m_nAngelLevel
    580. ----------추가 끝 ----------
    581. ------------------- Version9 Pet
    582. , F.szInventoryPet as szInventoryPet
    583. , A.m_dwPetId
    584. , A.m_nExpLog, A.m_nAngelExpLog
    585. ------------- Ver.11 Coupon
    586. --, m_nCoupon
    587. ------------- Ver.13 Housing
    588. , A.m_nLayer --
    589. , last_connect = @last_connect
    590. ---------- Ver 15
    591. , A.m_aCheckedQuest
    592. , A.m_nCampusPoint
    593. , A.idCampus
    594. , isnull(R.m_nRestPoint, 0) m_nRestPoint
    595. , isnull(R.m_LogOutTime, 0) m_LogOutTime
    596. FROM CHARACTER_TBL as A inner join TASKBAR_TBL as B on A.serverindex = B.serverindex and A.m_idPlayer = B.m_idPlayer
    597. inner join TASKBAR_ITEM_TBL as C on A.serverindex = C.serverindex and A.m_idPlayer = C.m_idPlayer
    598. inner join INVENTORY_TBL as D on A.serverindex = D.serverindex and A.m_idPlayer = D.m_idPlayer
    599. inner join SKILLINFLUENCE_TBL as E on A.serverindex = E.serverindex and A.m_idPlayer = E.m_idPlayer
    600. inner join INVENTORY_EXT_TBL as F on A.serverindex = F.serverindex and A.m_idPlayer = F.m_idPlayer
    601. left outer join GUILD_MEMBER_TBL as G on A.serverindex = G.serverindex and A.m_idPlayer = G.m_idPlayer
    602. left outer join BILING_ITEM_TBL as H on A.serverindex = H.serverindex and A.m_idPlayer = H.m_idPlayer
    603. left outer join tblRestPoint as R on A.serverindex = R.serverindex and A.m_idPlayer = R.m_idPlayer
    604. WHERE A.m_idPlayer = @im_idPlayer
    605. AND A.serverindex = @iserverindex
    606. /*AND A.m_idPlayer = B.m_idPlayer
    607. AND A.serverindex = B.serverindex
    608. AND B.m_idPlayer = C.m_idPlayer
    609. AND B.serverindex = C.serverindex
    610. AND C.m_idPlayer = D.m_idPlayer
    611. AND C.serverindex = D.serverindex
    612. AND D.m_idPlayer = E.m_idPlayer
    613. AND D.serverindex = E.serverindex
    614. AND E.m_idPlayer = F.m_idPlayer
    615. AND E.serverindex = F.serverindex
    616. AND F.serverindex *= G.serverindex
    617. AND F.m_idPlayer *= G.m_idPlayer
    618. AND F.serverindex *= H.serverindex
    619. AND F.m_idPlayer *= H.m_idPlayer*/
    620. AND A.account = lower(@iaccount)
    622. -- 뱅크 정보 가져오기 account 별
    624. -- DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT)
    625. --
    626. -- INSERT @bank
    627. -- (m_idPlayer,serverindex,playerslot)
    628. -- SELECT m_idPlayer,serverindex,playerslot
    629. -- FROM CHARACTER_TBL
    630. -- WHERE account = @iaccount
    631. -- AND isblock = 'F'
    632. -- ORDER BY playerslot
    634. SELECT a.m_idPlayer,
    635. c.playerslot,
    636. a.m_Bank,
    637. a.m_apIndex_Bank,
    638. a.m_dwObjIndex_Bank,
    639. a.m_dwGoldBank,
    640. a.m_BankPw,
    641. b.m_extBank,
    642. b.m_BankPiercing, b.szBankPet
    643. FROM dbo.BANK_TBL a,
    644. dbo.BANK_EXT_TBL b,
    645. dbo.CHARACTER_TBL c
    646. WHERE a.m_idPlayer = b.m_idPlayer
    647. AND a.serverindex = b.serverindex
    648. AND b.m_idPlayer = c.m_idPlayer
    649. AND b.serverindex = c.serverindex
    650. AND c.account = @iaccount
    651. AND c.isblock = 'F'
    652. ORDER BY c.playerslot
    654. ---------- Ver.11 Pocket
    655. SELECT a.nPocket,
    656. a.szItem,
    657. a.szIndex,
    658. a.szObjIndex,
    659. a.bExpired,
    660. a.tExpirationDate,
    661. b.szExt,
    662. b.szPiercing,
    663. b.szPet
    664. FROM tblPocket as a inner join tblPocketExt as b
    665. on a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket
    666. WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer
    667. ORDER BY a.nPocket
    669. RETURN
    670. END
    672. /*
    674. 데이터 전체 가져오기 New
    675. ex )
    676. CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount
    677. CHARACTER_STR 'S8','425120','01','ata3k'
    678. */
    679. ELSE
    680. IF @iGu = 'C1' -- 캐릭터 저장
    681. BEGIN
    682. UPDATE CHARACTER_TBL
    683. SET dwWorldID = @idwWorldID,
    684. m_dwIndex = @im_dwIndex,
    685. m_dwSex = @im_dwSex,
    686. m_vScale_x = @im_vScale_x,
    687. m_dwMotion = @im_dwMotion,
    688. m_vPos_x = @im_vPos_x,
    689. m_vPos_y = @im_vPos_y,
    690. m_vPos_z = @im_vPos_z,
    691. m_dwHairMesh = @im_dwHairMesh,
    692. m_dwHairColor = @im_dwHairColor,
    693. m_dwHeadMesh = @im_dwHeadMesh, -- 2004/11/08 추가
    694. m_fAngle = 0, --@im_fAngle,
    695. m_szCharacterKey = @im_szCharacterKey,
    697. m_nHitPoint = @im_nHitPoint,
    698. m_nManaPoint = @im_nManaPoint,
    699. m_nFatiguePoint = @im_nFatiguePoint,
    700. m_nFuel = @im_nFuel,
    701. m_dwRideItemIdx = @im_dwRideItemIdx,
    702. m_dwGold = @im_dwGold,
    703. m_nJob = @im_nJob,
    704. m_pActMover = @im_pActMover,
    705. m_nStr = @im_nStr,
    706. m_nSta = @im_nSta,
    707. m_nDex = @im_nDex,
    708. m_nInt = @im_nInt,
    709. m_nLevel = @im_nLevel,
    710. m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
    711. m_nExp1 = @im_nExp1,
    712. m_nExp2 = @im_nExp2,
    713. m_aJobSkill = @im_aJobSkill,
    714. m_aLicenseSkill = @im_aLicenseSkill,
    715. m_aJobLv = @im_aJobLv,
    716. m_dwExpertLv = @im_dwExpertLv,
    717. m_idMarkingWorld = @im_idMarkingWorld,
    718. m_vMarkingPos_x = @im_vMarkingPos_x,
    719. m_vMarkingPos_y = @im_vMarkingPos_y,
    720. m_vMarkingPos_z = @im_vMarkingPos_z,
    721. m_nRemainGP = @im_nRemainGP,
    722. m_nRemainLP = @im_nRemainLP,
    723. m_nFlightLv = @im_nFlightLv,
    724. m_nFxp = @im_nFxp,
    725. m_nTxp = @im_nTxp,
    726. m_lpQuestCntArray = @im_lpQuestCntArray,
    727. m_aCompleteQuest = @im_aCompleteQuest,
    728. m_dwMode = @im_dwMode,
    729. m_idparty = @im_idparty,
    730. --m_nNumKill = @im_nNumKill,
    731. m_idMuerderer = @im_idMuerderer,
    732. --m_nSlaughter = @im_nSlaughter ,
    734. m_nFame = @im_nFame,
    735. m_nDeathExp = @im_nDeathExp,
    736. m_nDeathLevel = @im_nDeathLevel,
    738. m_dwFlyTime = m_dwFlyTime + @im_dwFlyTime,
    739. m_nMessengerState = @im_nMessengerState,
    740. TotalPlayTime = TotalPlayTime + @iTotalPlayTime,
    741. m_tmAccFuel = @im_tmAccFuel,
    742. m_dwSkillPoint = @im_dwSkillPoint,
    743. m_dwReturnWorldID= @im_dwReturnWorldID,
    744. m_vReturnPos_x = @im_vReturnPos_x,
    745. m_vReturnPos_y = @im_vReturnPos_y,
    746. m_vReturnPos_z = @im_vReturnPos_z
    747. -------------- (ADD: Version7-SkillSystem)
    748. , SkillPoint = @im_SkillPoint
    749. , SkillLv = @im_SkillLv
    750. , SkillExp = @im_SkillExp
    751. -------------- (추가 부분)
    752. , dwEventFlag =@idwEventFlag,
    753. dwEventTime =@idwEventTime,
    754. dwEventElapsed =@idwEventElapsed
    755. -------------- (추가 부분)
    756. ----------추가 시작 ----------
    757. , PKValue = @im_nPKValue,
    758. PKPropensity = @im_dwPKPropensity,
    759. PKExp = @im_dwPKExp
    760. ----------추가 끝 ----------
    761. ----------추가 시작 ----------
    762. , AngelExp= @im_nAngelExp
    763. , AngelLevel= @im_nAngelLevel
    764. ----------추가 끝 ----------
    765. --------------------- Version9 Pet
    766. , m_dwPetId = @im_dwPetId
    767. , m_nExpLog = @im_nExpLog
    768. , m_nAngelExpLog = @im_nAngelExpLog
    769. ---------- Ver.11 Coupon
    770. , m_nCoupon = @im_nCoupon
    771. ---------- Ver.14
    772. , m_nLayer = @im_nLayer --Housing
    773. , m_nHonor = @im_nHonor --Master
    774. ---------- Ver 15
    775. , m_aCheckedQuest = @im_aCheckedQuest
    776. , m_nCampusPoint = @im_nCampusPoint
    777. , idCampus = @im_idCampus
    778. WHERE m_idPlayer = @im_idPlayer
    779. AND serverindex = @iserverindex
    781. -- if object_id('QUEST_TBL') is not null
    782. -- EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray
    784. --송현석 요청사항 빌링 관련
    785. IF @im_dwSMTime > ''
    786. BEGIN
    787. IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer AND serverindex = @iserverindex)
    788. UPDATE BILING_ITEM_TBL
    789. SET m_dwSMTime = @im_dwSMTime
    790. WHERE m_idPlayer = @im_idPlayer
    791. AND serverindex = @iserverindex
    792. ELSE
    793. INSERT BILING_ITEM_TBL
    794. (m_idPlayer,serverindex,m_dwSMTime)
    795. VALUES
    796. (@im_idPlayer,@iserverindex,@im_dwSMTime)
    797. END
    798. ELSE
    799. DELETE BILING_ITEM_TBL
    800. WHERE m_idPlayer = @im_idPlayer
    801. AND serverindex = @iserverindex
    804. -- UPDATE CARD_CUBE_TBL
    805. -- SET m_Card = @im_Card,
    806. -- m_apIndex_Card = @im_Index_Card,
    807. -- m_dwObjIndex_Card= @im_ObjIndex_Card,
    808. -- m_Cube = @im_Cube,
    809. -- m_apIndex_Cube = @im_Index_Cube,
    810. -- m_dwObjIndex_Cube=@im_ObjIndex_Cube
    811. -- WHERE m_idPlayer = @im_idPlayer
    812. -- AND serverindex = @iserverindex
    814. UPDATE INVENTORY_TBL
    815. SET m_Inventory = @im_Inventory,
    816. m_apIndex = @im_apIndex,
    817. m_adwEquipment = @im_adwEquipment,
    818. m_dwObjIndex = @im_dwObjIndex
    819. WHERE m_idPlayer = @im_idPlayer
    820. AND serverindex = @iserverindex
    823. UPDATE TASKBAR_TBL
    824. SET m_aSlotApplet = @im_aSlotApplet,
    825. m_aSlotQueue = @im_aSlotQueue,
    826. m_SkillBar = @im_SkillBar
    827. WHERE m_idPlayer = @im_idPlayer
    828. AND serverindex = @iserverindex
    831. UPDATE TASKBAR_ITEM_TBL
    832. SET m_aSlotItem = @im_aSlotItem
    833. WHERE m_idPlayer = @im_idPlayer
    834. AND serverindex = @iserverindex
    836. UPDATE BANK_TBL
    837. SET m_Bank = @im_Bank,
    838. m_apIndex_Bank = @im_apIndex_Bank,
    839. m_dwObjIndex_Bank = @im_dwObjIndex_Bank,
    840. m_dwGoldBank = @im_dwGoldBank
    841. WHERE m_idPlayer = @im_idPlayer
    842. AND serverindex = @iserverindex
    844. UPDATE SKILLINFLUENCE_TBL
    845. SET SkillInfluence = @iSkillInfluence
    846. WHERE m_idPlayer = @im_idPlayer
    847. AND serverindex = @iserverindex
    849. UPDATE INVENTORY_EXT_TBL
    850. SET m_extInventory = @im_extInventory,
    851. m_InventoryPiercing = @im_InventoryPiercing
    852. , szInventoryPet = @iszInventoryPet
    853. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
    855. UPDATE BANK_EXT_TBL
    856. SET m_extBank = @im_extBank,
    857. m_BankPiercing = @im_BankPiercing
    858. , szBankPet = @iszBankPet
    859. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
    861. SELECT fError = '1', fText = 'OK'
    862. RETURN
    863. END
    864. /*
    866. 정보업데이트
    867. ex )
    868. CHARACTER_STR 'U1', ALL ...
    869. CHARACTER_STR 'U1','000001','01' ...
    870. */
    872. ELSE
    873. IF @iGu = 'U2' --총 이용시간 수정
    874. BEGIN
    875. UPDATE CHARACTER_TBL
    876. SET TotalPlayTime = TotalPlayTime + @iplayerslot
    877. WHERE m_szName = @im_szName
    878. AND serverindex = @iserverindex
    879. RETURN
    880. END
    881. /*
    883. 총 이용시간 수정
    884. ex )
    885. CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime)
    886. CHARACTER_STR 'U2','','01','','beat',10234
    887. */
    889. ELSE
    890. IF @iGu = 'U3' --총 이용시간 수정 new
    891. BEGIN
    892. UPDATE CHARACTER_TBL
    893. SET TotalPlayTime = TotalPlayTime + @iplayerslot
    894. WHERE m_idPlayer = @im_idPlayer
    895. AND serverindex = @iserverindex
    896. RETURN
    897. END
    898. /*
    900. 총 이용시간 수정 (new)
    901. ex )
    902. CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime)
    903. CHARACTER_STR 'U3','000001','01','','',10234
    904. */
    906. ELSE
    907. IF @iGu = 'U4' --캐릭터 명 변경
    908. BEGIN
    909. IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_szName = @im_szName AND serverindex = @iserverindex)
    910. BEGIN
    911. SELECT fError = '0'
    912. END
    913. ELSE
    914. BEGIN
    915. UPDATE CHARACTER_TBL
    916. SET m_szName = @im_szName
    917. WHERE m_idPlayer = @im_idPlayer
    918. AND serverindex = @iserverindex
    919. SELECT fError = '1'
    920. END
    921. RETURN
    922. END
    924. /*
    927. 캐릭터 명 변경
    928. ex )
    929. CHARACTER_STR 'U4',@im_idPlayer,@iserverindex,@iaccount,@im_szName
    930. CHARACTER_STR 'U4','000001','01','','샛별공주'
    931. */
    932. -- Ver 15
    933. ELSE
    934. IF @iGu = 'U5' --사제 포인트 업데이트 추가
    935. BEGIN
    936. IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
    937. BEGIN
    938. UPDATE CHARACTER_TBL
    939. SET m_nCampusPoint = m_nCampusPoint + @iplayerslot
    940. WHERE m_idPlayer = @im_idPlayer
    941. AND serverindex = @iserverindex
    943. declare @u5m_nCampusPoint int
    945. select @u5m_nCampusPoint = m_nCampusPoint from CHARACTER_TBL (nolock) WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
    946. SELECT fError = '1', @u5m_nCampusPoint m_nCampusPoint
    947. END
    948. ELSE
    949. RETURN
    950. END
    951. ELSE
    952. IF @iGu = 'U6' -- 사제 ID 업데이트 추가
    953. BEGIN
    954. IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
    955. BEGIN
    956. UPDATE CHARACTER_TBL
    957. SET idCampus = @iplayerslot
    958. WHERE m_idPlayer = @im_idPlayer
    959. AND serverindex = @iserverindex
    960. SELECT fError = '1'
    961. END
    962. ELSE
    963. BEGIN
    964. SELECT fError = '0'
    965. END
    966. RETURN
    967. END
    969. ELSE
    970. IF @iGu = 'D1' -- 캐릭터 삭제
    971. BEGIN
    972. IF @im_szName = ''
    973. BEGIN
    974. SELECT fError = '1', fText = '주민번호틀림'
    975. RETURN
    976. END
    978. DECLARE @Exists int
    980. IF EXISTS(SELECT name from syscolumns where name='m_idPlayer' AND collation= 'Latin1_General_BIN')
    981. BEGIN
    982. IF EXISTS(SELECT * FROM ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND [password] = @im_szName )
    983. SET @Exists = 1
    984. ELSE
    985. SET @Exists = 0
    986. END
    987. ELSE
    988. BEGIN
    989. IF EXISTS(SELECT * FROM ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (id_no2 = @im_szName OR member = 'B' ))
    990. SET @Exists = 1
    991. ELSE
    992. SET @Exists = 0
    993. END
    995. IF @Exists > 0
    996. BEGIN
    997. DECLARE @currDate char(12)
    998. SET @currDate = CONVERT(CHAR(8),GETDATE(),112)
    999. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
    1000. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
    1004. IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND m_idWar > 0)
    1005. BEGIN
    1006. SELECT fError = '3', fText = '길드전중'
    1007. RETURN
    1008. END
    1009. ELSE
    1010. BEGIN
    1011. UPDATE CHARACTER_TBL
    1013. SET isblock = 'D',
    1014. End_Time = @currDate ,
    1016. BlockTime = LEFT(@currDate,8)
    1017. WHERE m_idPlayer = @im_idPlayer
    1018. AND serverindex = @iserverindex
    1021. UPDATE MESSENGER_TBL
    1022. SET State = 'D'
    1023. WHERE m_idPlayer = @im_idPlayer
    1024. AND serverindex = @iserverindex
    1026. UPDATE MESSENGER_TBL
    1027. SET State = 'D'
    1028. WHERE f_idPlayer = @im_idPlayer
    1029. AND serverindex = @iserverindex
    1033. /****************************************************************************************/
    1034. /** 200506 event **/
    1035. /****************************************************************************************/
    1038. -- if (not exists(select account from RANKING.RANKING_DBF.dbo.last_1_month_tbl where account = @iaccount)
    1039. -- and convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-12')
    1040. --
    1041. -- begin --: 1개월 이상 접속경험이 없는 계정대상 유저
    1042. -- declare @cash int,@get_cach int
    1043. -- select @cash = case when m_nLevel between 10 and 19 then 500
    1044. -- when m_nLevel between 20 and 39 then 1000
    1045. -- when m_nLevel between 40 and 49 then 1500
    1046. -- when m_nLevel between 50 and 59 then 2000
    1047. -- when m_nLevel between 60 and 69 then 2500
    1048. -- when m_nLevel >= 70 then 3000
    1049. -- else 0 end
    1050. -- from CHARACTER_TBL
    1051. -- where m_idPlayer = @im_idPlayer and serverindex = @iserverindex
    1052. --
    1053. -- select @get_cach = isnull(sum(amount),0)
    1054. -- from RANKING.RANKING_DBF.dbo.event_member_tbl
    1055. -- where account = @iaccount
    1056. -- group by account
    1057. --
    1058. -- if @cash + @get_cach > 5000
    1059. -- set @cash = 5000 - @get_cach
    1060. --
    1061. -- if @cash > 0
    1062. --
    1063. -- begin
    1064. -- declare @retcode int
    1065. --
    1066. -- if not exists(select * from BILLING.QLORD_MASTER.dbo.BX_TG_USERINFO where USER_ID = @iaccount)
    1067. -- exec BILLING.QLORD_MASTER.dbo.BX_SP_PROCESS_USERINFO @iaccount,@iaccount,'FLYF',' ','1111111111118',' ',' ',''
    1068. --
    1069. -- exec @retcode = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004',@cash,'캐릭터 보상 이벤트',0,''
    1070. --
    1071. -- if @retcode <> 1
    1072. -- set @cash = 0
    1073. --
    1074. -- insert RANKING.RANKING_DBF.dbo.event_member_tbl
    1075. -- (account,amount,m_idPlayer,serverindex,retcode,date)
    1076. -- values
    1077. -- (@iaccount,@cash,@im_idPlayer,@iserverindex,@retcode,getdate())
    1078. --
    1079. -- end
    1080. -- end
    1081. /****************************************************************************************/
    1082. /****************************************************************************************/
    1083. /****************************************************************************************/
    1086. IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
    1087. BEGIN
    1088. SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
    1089. RETURN
    1090. END
    1091. ELSE
    1092. BEGIN
    1093. SELECT fError = '0', fText = 'DELETE OK'
    1094. RETURN
    1095. END
    1098. END
    1099. END
    1100. ELSE
    1101. BEGIN
    1102. SELECT fError = '1', fText = '주민번호틀림'
    1103. RETURN
    1104. END
    1105. END
    1106. /*
    1108. 캐릭터 삭제
    1109. ex )
    1110. CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock)
    1111. CHARACTER_STR 'D1','001068','01','ata3k','1019311'
    1113. */
    1115. ELSE
    1116. IF @iGu = 'I1' -- 초기 정보 입력
    1117. BEGIN
    1118. IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
    1119. WHERE lower(m_szName) = lower(@im_szName) AND serverindex = @iserverindex)
    1120. BEGIN
    1121. SELECT fError = '0', fText = '캐릭터 중복!'
    1122. RETURN
    1123. END
    1124. ELSE
    1125. BEGIN
    1126. DECLARE
    1127. @om_idPlayer CHAR (7) ,
    1128. @om_vScale_x REAL ,
    1129. @om_dwMotion INT ,
    1130. @om_fAngle REAL ,
    1131. @om_nHitPoint INT ,
    1132. @om_nManaPoint INT ,
    1133. @om_nFatiguePoint INT ,
    1134. @om_dwRideItemIdx INT ,
    1135. @om_dwGold INT ,
    1136. @om_nJob INT ,
    1137. @om_pActMover VARCHAR(50) ,
    1138. @om_nStr INT ,
    1139. @om_nSta INT ,
    1140. @om_nDex INT ,
    1141. @om_nInt INT ,
    1142. @om_nLevel INT ,
    1144. @om_nExp1 BIGINT ,
    1145. @om_nExp2 BIGINT ,
    1146. @om_aJobSkill VARCHAR (500),
    1147. @om_aLicenseSkill VARCHAR (500),
    1148. @om_aJobLv VARCHAR (500),
    1149. @om_dwExpertLv INT ,
    1150. @om_idMarkingWorld INT ,
    1151. @om_vMarkingPos_x REAL ,
    1152. @om_vMarkingPos_y REAL ,
    1153. @om_vMarkingPos_z REAL ,
    1154. @om_nRemainGP INT ,
    1155. @om_nRemainLP INT ,
    1156. @om_nFlightLv INT ,
    1157. @om_nFxp INT ,
    1158. @om_nTxp INT ,
    1160. @om_lpQuestCntArray VARCHAR(1024),
    1161. @om_chAuthority CHAR(1) ,
    1162. @om_dwMode INT ,
    1163. @oblockby VARCHAR(32) ,
    1164. @oTotalPlayTime INT ,
    1165. @oisblock CHAR(1) ,
    1166. @oEnd_Time CHAR(12) ,
    1167. @om_Inventory VARCHAR(6940),
    1168. @om_apIndex VARCHAR(345) ,
    1169. @om_adwEquipment VARCHAR(135) ,
    1170. @om_aSlotApplet VARCHAR(3100),
    1171. @om_aSlotItem VARCHAR(6885),
    1172. @om_aSlotQueue VARCHAR(225),
    1173. @om_SkillBar SMALLINT,
    1174. @om_dwObjIndex VARCHAR(345) ,
    1175. @om_Card VARCHAR(1980),
    1176. @om_Cube VARCHAR(1980),
    1177. @om_apIndex_Card VARCHAR(215) ,
    1178. @om_dwObjIndex_Card VARCHAR(215) ,
    1179. @om_apIndex_Cube VARCHAR(215) ,
    1180. @om_dwObjIndex_Cube VARCHAR(215) ,
    1181. @om_idparty INT ,
    1182. --@om_nNumKill INT ,
    1183. @om_idMuerderer INT ,
    1184. --@om_nSlaughter INT ,
    1185. @om_nFame INT ,
    1186. @om_nDeathExp BIGINT ,
    1187. @om_nDeathLevel INT ,
    1188. @om_dwFlyTime INT ,
    1189. @om_nMessengerState INT ,
    1190. @om_Bank VARCHAR(4290),
    1191. @om_apIndex_Bank VARCHAR(215) ,
    1192. @om_dwObjIndex_Bank VARCHAR(215) ,
    1193. @om_dwGoldBank INT
    1194. ---------- Ver 15
    1195. , @om_aCheckedQuest varchar(100)
    1196. , @om_nCampusPoint int
    1197. , @om_idCampus int
    1199. IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE serverindex = @iserverindex)
    1200. SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7)
    1201. FROM CHARACTER_TBL
    1202. WHERE serverindex = @iserverindex
    1203. ELSE
    1204. SELECT @om_idPlayer = '0000001'
    1206. SELECT @om_vScale_x = m_vScale_x,
    1207. @om_dwMotion = m_dwMotion,
    1208. @om_fAngle = m_fAngle,
    1209. @om_nHitPoint = m_nHitPoint,
    1210. @om_nManaPoint = m_nManaPoint,
    1211. @om_nFatiguePoint = m_nFatiguePoint,
    1212. @om_dwRideItemIdx = m_dwRideItemIdx,
    1213. @om_dwGold = m_dwGold,
    1214. @om_nJob = m_nJob,
    1215. @om_pActMover = m_pActMover,
    1216. @om_nStr = m_nStr,
    1217. @om_nSta = m_nSta,
    1218. @om_nDex = m_nDex,
    1219. @om_nInt = m_nInt,
    1220. @om_nLevel = m_nLevel,
    1221. @om_nExp1 = m_nExp1,
    1222. @om_nExp2 = m_nExp2,
    1223. @om_aJobSkill = m_aJobSkill,
    1224. @om_aLicenseSkill = m_aLicenseSkill,
    1225. @om_aJobLv = m_aJobLv,
    1227. @om_dwExpertLv = m_dwExpertLv,
    1228. @om_idMarkingWorld = m_idMarkingWorld,
    1229. @om_vMarkingPos_x = m_vMarkingPos_x,
    1230. @om_vMarkingPos_y = m_vMarkingPos_y,
    1231. @om_vMarkingPos_z = m_vMarkingPos_z,
    1232. @om_nRemainGP = m_nRemainGP,
    1233. @om_nRemainLP = m_nRemainLP,
    1234. @om_nFlightLv = m_nFlightLv,
    1235. @om_nFxp = m_nFxp,
    1236. @om_nTxp = m_nTxp,
    1237. @om_lpQuestCntArray = m_lpQuestCntArray,
    1238. @om_chAuthority = m_chAuthority,
    1239. @om_dwMode = m_dwMode,
    1240. @oblockby = blockby,
    1241. @oTotalPlayTime = TotalPlayTime,
    1242. @oisblock = isblock,
    1243. @oEnd_Time = CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000',
    1244. @om_Inventory = m_Inventory,
    1245. @om_apIndex = m_apIndex,
    1246. @om_adwEquipment = m_adwEquipment,
    1247. @om_aSlotApplet = m_aSlotApplet,
    1248. @om_aSlotItem = m_aSlotItem,
    1249. @om_aSlotQueue = m_aSlotQueue,
    1250. @om_SkillBar = m_SkillBar,
    1251. @om_dwObjIndex = m_dwObjIndex,
    1252. @om_Card = m_Card,
    1253. @om_Cube = m_Cube,
    1254. @om_apIndex_Card = m_apIndex_Card,
    1255. @om_dwObjIndex_Card = m_dwObjIndex_Card,
    1256. @om_apIndex_Cube = m_apIndex_Cube,
    1258. @om_dwObjIndex_Cube = m_dwObjIndex_Cube,
    1259. @om_idparty = m_idparty,
    1260. --@om_nNumKill = m_nNumKill,
    1261. @om_idMuerderer = m_idMuerderer,
    1262. --@om_nSlaughter = m_nSlaughter ,
    1263. @om_nFame = m_nFame,
    1264. @om_nDeathExp = m_nDeathExp,
    1265. @om_nDeathLevel = m_nDeathLevel,
    1266. @om_dwFlyTime = m_dwFlyTime,
    1267. @om_nMessengerState = m_nMessengerState,
    1268. @om_Bank = m_Bank,
    1269. @om_apIndex_Bank = m_apIndex_Bank,
    1270. @om_dwObjIndex_Bank = m_dwObjIndex_Bank,
    1271. @om_dwGoldBank = m_dwGoldBank
    1273. FROM BASE_VALUE_TBL
    1274. WHERE g_nSex = @im_dwSex
    1278. INSERT CHARACTER_TBL
    1279. (
    1280. m_idPlayer,
    1281. serverindex,
    1282. account,
    1283. m_szName,
    1284. playerslot,
    1285. dwWorldID,
    1286. m_dwIndex,
    1287. m_vScale_x,
    1288. m_dwMotion,
    1289. m_vPos_x,
    1291. m_vPos_y,
    1292. m_vPos_z,
    1293. m_fAngle,
    1294. m_szCharacterKey,
    1296. m_nHitPoint,
    1297. m_nManaPoint,
    1298. m_nFatiguePoint,
    1299. m_nFuel,
    1300. m_dwSkinSet,
    1301. m_dwHairMesh,
    1302. m_dwHairColor,
    1303. m_dwHeadMesh,
    1304. m_dwSex,
    1305. m_dwRideItemIdx,
    1306. m_dwGold,
    1307. m_nJob,
    1308. m_pActMover,
    1309. m_nStr,
    1310. m_nSta,
    1311. m_nDex,
    1312. m_nInt,
    1313. m_nLevel,
    1314. m_nMaximumLevel,
    1315. m_nExp1,
    1316. m_nExp2,
    1317. m_aJobSkill,
    1318. m_aLicenseSkill,
    1319. m_aJobLv,
    1320. m_dwExpertLv,
    1321. m_idMarkingWorld,
    1322. m_vMarkingPos_x,
    1323. m_vMarkingPos_y,
    1324. m_vMarkingPos_z,
    1325. m_nRemainGP,
    1326. m_nRemainLP,
    1328. m_nFlightLv,
    1329. m_nFxp,
    1330. m_nTxp,
    1331. m_lpQuestCntArray,
    1332. m_aCompleteQuest,
    1333. m_chAuthority,
    1334. m_dwMode,
    1335. m_idparty,
    1336. m_idCompany,
    1337. --m_nNumKill,
    1338. m_idMuerderer,
    1339. --m_nSlaughter,
    1340. m_nFame,
    1341. m_nDeathExp,
    1342. m_nDeathLevel,
    1344. m_dwFlyTime,
    1345. m_nMessengerState,
    1346. blockby,
    1347. TotalPlayTime,
    1348. isblock,
    1349. End_Time,
    1350. BlockTime,
    1351. CreateTime,
    1352. m_tmAccFuel,
    1353. m_tGuildMember,
    1354. m_dwSkillPoint,
    1355. m_dwReturnWorldID,
    1356. m_vReturnPos_x,
    1357. m_vReturnPos_y,
    1358. m_vReturnPos_z
    1359. ---------- Ver 15
    1360. , m_aCheckedQuest
    1361. , m_nCampusPoint
    1362. , idCampus
    1363. )
    1364. VALUES
    1365. (
    1366. @om_idPlayer,
    1367. @iserverindex,
    1368. @iaccount,
    1369. @im_szName,
    1370. @iplayerslot,
    1371. @idwWorldID,
    1372. @im_dwIndex,
    1373. @om_vScale_x,
    1375. @om_dwMotion,
    1376. @im_vPos_x,
    1377. @im_vPos_y,
    1378. @im_vPos_z,
    1379. @om_fAngle,
    1380. @im_szCharacterKey,
    1381. @om_nHitPoint,
    1382. @om_nManaPoint,
    1383. @om_nFatiguePoint,
    1384. -1, --m_nFuel
    1385. @im_dwSkinSet,
    1386. @im_dwHairMesh,
    1387. @im_dwHairColor,
    1388. @im_dwHeadMesh,
    1389. @im_dwSex,
    1390. @om_dwRideItemIdx,
    1391. @om_dwGold,
    1392. @om_nJob,
    1393. @om_pActMover,
    1394. @om_nStr,
    1395. @om_nSta,
    1396. @om_nDex,
    1397. @om_nInt,
    1398. @om_nLevel,
    1399. 1, --m_nMaximumLevel
    1400. @om_nExp1,
    1401. @om_nExp2,
    1402. @om_aJobSkill,
    1403. @om_aLicenseSkill,
    1404. @om_aJobLv,
    1405. @om_dwExpertLv,
    1406. @om_idMarkingWorld,
    1407. @om_vMarkingPos_x,
    1408. @om_vMarkingPos_y,
    1409. @om_vMarkingPos_z,
    1410. @om_nRemainGP,
    1411. @om_nRemainLP,
    1412. @om_nFlightLv,
    1413. @om_nFxp,
    1414. @om_nTxp,
    1415. @om_lpQuestCntArray,
    1416. '$', -- m_aCompleteQuest
    1417. @om_chAuthority,
    1418. @om_dwMode,
    1419. @om_idparty,
    1420. '000000', -- m_idCompany
    1421. --@om_nNumKill,
    1422. @om_idMuerderer,
    1423. --@om_nSlaughter,
    1424. @om_nFame,
    1425. @om_nDeathExp,
    1426. @om_nDeathLevel,
    1427. @om_dwFlyTime ,
    1428. @om_nMessengerState,
    1429. @oblockby,
    1430. @oTotalPlayTime,
    1431. @oisblock,
    1432. @oEnd_Time,
    1433. CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
    1434. GETDATE(),
    1435. 0,
    1436. CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
    1437. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
    1438. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
    1439. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
    1440. 0, --m_dwSkillPoint
    1441. 1,
    1442. 0,
    1443. 0,
    1444. 0
    1445. , '$'
    1446. , 0
    1447. , 0
    1448. )
    1451. INSERT INVENTORY_TBL
    1452. (
    1453. m_idPlayer,
    1454. serverindex,
    1455. m_Inventory,
    1456. m_apIndex,
    1457. m_adwEquipment,
    1458. m_dwObjIndex
    1459. )
    1460. VALUES
    1461. (
    1462. @om_idPlayer,
    1463. @iserverindex,
    1464. @om_Inventory,
    1465. @om_apIndex,
    1466. @om_adwEquipment,
    1467. @om_dwObjIndex
    1468. )
    1471. IF @@SERVERNAME = 'WEB' OR @@SERVERNAME = 'SERVER4'
    1472. 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/$'
    1474. INSERT TASKBAR_TBL
    1475. (
    1476. m_idPlayer,
    1477. serverindex,
    1478. m_aSlotApplet,
    1479. m_aSlotQueue,
    1480. m_SkillBar
    1482. )
    1483. VALUES
    1484. (
    1485. @om_idPlayer,
    1486. @iserverindex,
    1487. @om_aSlotApplet,
    1488. @om_aSlotQueue,
    1489. @om_SkillBar
    1490. )
    1493. INSERT TASKBAR_ITEM_TBL
    1494. (
    1495. m_idPlayer,
    1496. serverindex,
    1497. m_aSlotItem
    1498. )
    1500. VALUES
    1501. (
    1502. @om_idPlayer,
    1503. @iserverindex,
    1504. @om_aSlotItem
    1505. )
    1507. INSERT BANK_TBL
    1508. (
    1509. m_idPlayer,
    1510. serverindex,
    1511. m_Bank,
    1512. m_BankPw,
    1513. m_apIndex_Bank,
    1514. m_dwObjIndex_Bank ,
    1515. m_dwGoldBank
    1516. )
    1517. VALUES
    1518. (
    1519. @om_idPlayer,
    1520. @iserverindex,
    1521. @om_Bank,
    1522. '0000', -- m_BankPw
    1523. @om_apIndex_Bank,
    1524. @om_dwObjIndex_Bank,
    1525. @om_dwGoldBank
    1526. )
    1528. INSERT SKILLINFLUENCE_TBL
    1529. (
    1530. m_idPlayer,
    1531. serverindex,
    1532. SkillInfluence
    1533. )
    1534. VALUES
    1535. (
    1536. @om_idPlayer,
    1537. @iserverindex,
    1538. '$'
    1539. )
    1541. INSERT INVENTORY_EXT_TBL
    1542. (
    1543. m_idPlayer,
    1544. serverindex,
    1545. m_extInventory,
    1546. m_InventoryPiercing
    1547. )
    1548. VALUES
    1549. (
    1550. @om_idPlayer,
    1551. @iserverindex,
    1552. '$','$'
    1553. )
    1555. INSERT BANK_EXT_TBL
    1556. (
    1557. m_idPlayer,
    1558. serverindex,
    1559. m_extBank,
    1560. m_BankPiercing
    1561. )
    1562. VALUES
    1563. (
    1564. @om_idPlayer,
    1565. @iserverindex,
    1566. '$','$'
    1567. )
    1569. INSERT INTO tblMultiServerInfo(serverindex, m_idPlayer, MultiServer)
    1570. VALUES (@iserverindex, @om_idPlayer, 0)
    1572. INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
    1573. VALUES (@iserverindex, @om_idPlayer, 1, 0, 0)
    1574. INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
    1575. VALUES (@iserverindex, @om_idPlayer, 2, 0, 1)
    1576. INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
    1577. VALUES (@iserverindex, @om_idPlayer, 3, 0, 2)
    1579. ------------ Ver.11 Pocket
    1580. INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
    1581. VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 )
    1583. INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
    1584. VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' )
    1586. INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
    1587. VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 )
    1589. INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
    1590. VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' )
    1592. INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
    1593. VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 )
    1595. INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
    1596. VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' )
    1597. ------------ Ver.13 Master
    1598. insert into tblMaster_all (serverindex, m_idPlayer, sec) --달인
    1599. select @iserverindex, @om_idPlayer, 1
    1600. insert into tblMaster_all (serverindex, m_idPlayer, sec)
    1601. select @iserverindex, @om_idPlayer, 2
    1602. insert into tblMaster_all (serverindex, m_idPlayer, sec)
    1603. select @iserverindex, @om_idPlayer, 3
    1605. ------------------- ver. 15
    1606. insert into tblRestPoint (serverindex, m_idPlayer)
    1607. select @iserverindex, @om_idPlayer
    1609. SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer
    1610. RETURN
    1611. END
    1612. END
    1614. /*
    1616. 초기 정보 입력
    1617. ex )
    1618. CHARACTER_STR 'I1','',@iserverindex,@iaccount,@im_szName,@iplayerslot,@idwWorldID,
    1619. @im_dwIndex,@im_vPos_x,@im_vPos_y,@im_vPos_z,@im_szCharacterKey,
    1620. @im_dwSkinSet,@im_dwHairMesh,@im_dwHairColor,@im_dwHeadMesh,@im_dwSex
    1621. CHARACTER_STR 'I1','','01','beat','샛별공주3',0,0,
    1622. 0,0,0,0,'',
    1623. 0,0,0,0,0
    1625. */
    1626. set nocount off
    1627. RETURN
    Alles anzeigen


    hab die char_str sehrwohl :x[/SIZE][/COLOR][/FONT]

  • @ cross

    ja die wird aber nicht erstellt :o

    bei mir zumindest nicht ,ich probier mal deine abfrage dann berichte ich^^

    Bei mir kommt der Error:OLE DB provider "SQLNCLI" for linked server "ACCOUNT" returned message "Login timeout expired".
    OLE DB provider "SQLNCLI" for linked server "ACCOUNT" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
    Msg 65535, Level 16, State 1, Line 0
    SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

    Und sie ist immernochnicht da^^