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 ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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 intASBEGIN 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 ONENDGO