USE [RanGameS1]
GO
/****** Object: StoredProcedure [dbo].[ChaInfoUpdateBase] Script Date: 03/03/2021 2:36:21 PM ******/
DROP PROCEDURE [dbo].[ChaInfoUpdateBase]
GO
/****** Object: StoredProcedure [dbo].[ChaInfoUpdateBase] Script Date: 03/03/2021 2:36:21 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ChaInfoUpdateBase]
@ChaBright int,
@
Chalevel int,
@
Chamoney money,
@ChaDex int,
@ChaIntel int,
@
Chaschool int,
@ChaHair int,
@ChaFace int,
@
Chaliving int,
@
Chastrong int,
@
Chapower int,
@
Chaspirit int,
@
Chastrength int,
@
ChastRemain int,
@ChaAttackP int,
@ChaDefenseP int,
@ChaFightA int,
@
ChashootA int,
@ChaExp money,
@
ChaskillPoint int,
@ChaHP int,
@
ChamP int,
@
ChasP int,
@ChaPK int,
@
ChastartMap int,
@
ChastartGate int,
@
ChaposX float,
@
ChaposY float,
@
ChaposZ float,
@
ChasaveMap int,
@
ChasavePosX float,
@
ChasavePosY float,
@
ChasavePosZ float,
@
ChareturnMap int,
@
ChareturnPosX float,
@
ChareturnPosY float,
@
ChareturnPosZ float,
@
ChareExp money,
@
ChasafeTime smallint,
@
ChacP int,
@ChaNum int,
@
ChamacroT int,
@
SkillSlotNum int,
@
CharebornNum int
AS
BEGIN
SET NOCOUNT ON
UPDATE dbo.ChaInfo
SET ChaBright = @ChaBright,
ChaLevel = @
Chalevel,
ChaMoney = @
Chamoney,
ChaDex = @ChaDex,
ChaIntel = @ChaIntel,
ChaSchool = @
Chaschool,
ChaHair = @ChaHair,
ChaFace = @ChaFace,
ChaLiving = @
Chaliving,
ChaStrong = @
Chastrong,
ChaPower = @
Chapower,
ChaSpirit = @
Chaspirit,
ChaStrength = @
Chastrength,
ChaStRemain = @
ChastRemain,
ChaAttackP = @ChaAttackP,
ChaDefenseP = @ChaDefenseP,
ChaFightA = @ChaFightA,
ChaShootA = @
ChashootA,
ChaExp = @ChaExp,
ChaSkillPoint = @
ChaskillPoint,
ChaHP = @ChaHP,
ChaMP = @
ChamP,
ChaSP = @
ChasP,
ChaPK = @ChaPK,
ChaStartMap = @
ChastartMap,
ChaStartGate = @
ChastartGate,
ChaPosX = @
ChaposX,
ChaPosY = @
ChaposY,
ChaPosZ = @
ChaposZ,
ChaSaveMap = @
ChasaveMap,
ChaSavePosX = @
ChasavePosX,
ChaSavePosY = @
ChasavePosY,
ChaSavePosZ = @
ChasavePosZ,
ChaReturnMap = @
ChareturnMap,
ChaReturnPosX = @
ChareturnPosX,
ChaReturnPosY = @
ChareturnPosY,
ChaReturnPosZ = @
ChareturnPosZ,
ChaReExp = @
ChareExp,
ChaSafeTime = @
ChasafeTime,
ChaCP = @
ChacP,
ChaMacroT = @
ChamacroT,
SkillSlotNum = @
SkillSlotNum,
ChaRebornNum = @
CharebornNum
WHERE ChaNum = @ChaNum
exec sp_DeleteChaResetInfo @ChaNum
SET NOCOUNT ON
END
GO