新建角色的等级指定代码(你可以指定各种属性值),必要的注释也有了,已编译通过:
use muonline
go 织梦内容管理系统
CREATE Procedure WZ_CreateCharacter
@AccountID varchar(10),
@Name varchar(10),
@Class tinyint
AS
Begin
织梦内容管理系统
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @Result tinyint
DECLARE @FASHI int --变量声明
DECLARE @ZHANSHI int
DECLARE @JINGLING int
DECLARE @MOJIAN int
DECLARE @SHENGDAO int
DECLARE @BORNMONEY int
DECLARE @BORNLEVEL int --添加对新建等级的变量的声明,类型为 int
SET @Result = 0x00
SET @FASHI= 300 -- 法师出生点数
SET @ZHANSHI= 300 -- 战士出生点数
SET @JINGLING= 300 -- 精灵出生点数
SET @MOJIAN= 400 -- 魔剑出生点数
SET @SHENGDAO= 400 -- 圣导出生点数
SET @BORNMONEY= 20000000 -- 出生送的钱
SET @BORNLEVEL= 30 -- 新建立时的角色等级,你可以自己修改,我这里的例子是30级,但不要超出限度 织梦内容管理系统
If EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
begin
SET @Result = 0x01
GOTO ProcEnd
end
BEGIN TRAN
内容来自dedecms
If NOT EXISTS ( SELECT Id FROM AccountCharacter WHERE Id = @AccountID )
begin
INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)
SET @Result = @@Error
end
else
begin
Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)
SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID
if( ( @g1 Is NULL) OR (Len(@g1) = 0))
dedecms.com
begin
UPDATE AccountCharacter SET GameID1 = @Name
WHERE Id = @AccountID
SET @Result = @@Error
end
else if( @g2 Is NULL OR Len(@g2) = 0) dedecms.com
begin
UPDATE AccountCharacter SET GameID2 = @Name
WHERE Id = @AccountID 本文来自织梦
SET @Result = @@Error
end
else if( @g3 Is NULL OR Len(@g3) = 0)
begin
UPDATE AccountCharacter SET GameID3 = @Name
WHERE Id = @AccountID
织梦好,好织梦
SET @Result = @@Error
end
else if( @g4 Is NULL OR Len(@g4) = 0)
begin
UPDATE AccountCharacter SET GameID4 = @Name
WHERE Id = @AccountID
dedecms.com
SET @Result = @@Error
end
else if( @g5 Is NULL OR Len(@g5) = 0)
begin
UPDATE AccountCharacter SET GameID5 = @Name
WHERE Id = @AccountID 本文来自织梦
SET @Result = @@Error
end
else
begin
SET @Result = 0x03
GOTO TranProcEnd
if( @Result <> 0 )
begin
GOTO TranProcEnd
end
else
begin
DECLARE @UPPOINT int
if(@Class=0)
begin
SET @UPPOINT = @FASHI
--SET @BORNLEVEL = 10 --也可以在这里对各职业进行指定的等级,举例为10级
end
else if(@Class=16) 内容来自dedecms
begin
SET @UPPOINT = @ZHANSHI
--SET @BORNLEVEL = 12 --也可以在这里对各职业进行指定的等级,举例为12级
end
else if(@Class=32)
begin
SET @UPPOINT = @JINGLING
--SET @BORNLEVEL = 13 --也可以在这里对各职业进行指定的等级,举例为13级
end
else if(@Class=48)
begin 织梦内容管理系统
SET @UPPOINT = @MOJIAN
--SET @BORNLEVEL = 14 --也可以在这里对各职业进行指定的等级,举例为14级
end
else
begin
SET @UPPOINT = @SHENGDAO
--SET @BORNLEVEL = 8 --也可以在这里对各职业进行指定的等级,举例为8级
end
INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MDate, LDate, Quest, DbVersion, Leadership,money )
SELECT @AccountID As AccountID, @Name As Name, @BORNLEVEL AS Level,@UPPOINT AS LevelUpPoint,@Class As Class,
Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership,@BORNMONEY As money
FROM DefaultClassType WHERE Class = @Class
本文来自织梦
SET @Result = @@Error
end 本文来自织梦
TranProcEnd:
IF ( @Result <> 0 )
ROLLBACK TRAN
ELSE
COMMIT TRAN
copyright dedecms
ProcEnd:
SET NOCOUNT OFF
SET XACT_ABORT OFF
织梦好,好织梦
SELECT
CASE @Result
WHEN 0x00 THEN 0x01
WHEN 0x01 THEN 0x00
WHEN 0x03 THEN 0x03
ELSE 0x02
END AS Result
End
GO
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号