--直接复制下面的代码到 usp_Create_Char_R 表中 执行即可
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 04/14/2024 12:59:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** °³Ã¼: ÀúÀå ÇÁ·Î½ÃÀú dbo.usp_Create_Char_R ½ºÅ©¸³Æ® ³¯Â¥: 2006-05-26 ¿ÀÈÄ 1:54:44 ******/
ALTER Proc [dbo].[usp_Create_Char_R]
@ServerID tinyint,
@UserID varchar(18),
@UserUID int,
@CharName varchar(50) ,
@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,
/* ¿©±â±îÁö ÀÎÀÚ°ª ÁÖ¾îÁ®¾ß ÇÔ */
/* SP ³»ºÎ ÂüÁ¶¿ë º¯¼ö */
@CharID int = 0,
@NameCnt tinyint = 0
AS
SET NOCOUNT ON
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Level = 1 /*等级*/
SET @Skillpoint = 1000 /*技能点*/
SET @Statpoint = 0 /*属性点*/
SET @statpoint =(@level-1)*9
SET @Money = 0 /*金钱*/
--SET @kill = 10000 /*战功*/
--SET @SkillPoint = 5
--IF PATINDEX('%[^a-zA-Z0-9吖-座]%',@CharName) > 0
---BEGIN
--RETURN -1
--END
--ELSE
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del=0)
BEGIN
RETURN -2
END
ELSE
BEGIN
INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, K1, RenameCnt, RemainTime)
VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow,
@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig,'10000', 0,0)
--上面的10000是上线赠送战功的，对应上面的k1
IF ( @@ERROR<>0 )
RETURN -1
SET @CharID = IDENT_CURRENT('Chars')
RETURN @CharID
END
SET NOCOUNT OFF
觉得内容不错？我要
