数据库里改存储过程:USPNewCreateChar如下:
CREATE proc USPNewCreateChar @charindex int,@charid varchar(14),@userindex int,@kind tinyint,@edu tinyint,@jungsama tinyint,
@colorhair tinyint,@colorUpper tinyint,@colorLower tinyint,@cellx smallint,@cellz smallint
as
set nocount on
declare @flag smallint
declare @Count smallint 内容来自dedecms
if @charid = ''
begin
set @flag = 150
select @flag
return
end 本文来自织梦
if exists (select charid from charinfo_base where charid = @charid)
begin
set @flag=3
select @flag
return
end
else
begin
select @Count = count(charid) from Charinfo_base where userindex = @userindex
织梦好,好织梦
if @Count >= 3
begin
set @flag = 7
select @flag
return
end
declare @NickName varchar(14)
declare @Job smallint
declare @Level tinyint
declare @CharExp int
declare @CharFame int
declare @guilty int
declare @adminchar tinyint
declare @InbornPoint smallint 织梦内容管理系统
declare @Strength smallint
declare @Osung smallint
declare @WonyYang smallint
declare @speed smallint
declare @Magic smallint
declare @Hp int
declare @HpMax int
declare @Negong smallint
declare @NegongMax smallint
declare @fatigue smallint
declare @fatigueMax smallint
declare @zonenum tinyint
--declare @cellx smallint
--declare @cellz smallint copyright dedecms
-- ?:?:? ?? ? ??
set @NickName =''
set @Job = 0
set @Level = 1
set @CharExp = 0
set @CharFame = 1
set @guilty = 0
set @adminchar =0
set @InbornPoint =2000 (在这里加你要分新人的先天点,比如我加2000点)
set @Negong = 59
set @NegongMax = 59 织梦好,好织梦
-- ?:?:? ???? ?? ???
if @jungsama = 1
begin
set @Strength = 12
set @Osung = 8
set @WonyYang = 8
set @speed = 12
set @Magic = 15 dedecms.com
set @Hp = 38
set @HpMax = 38 dedecms.com
set @fatigue =21
set @fatigueMax =21
set @zonenum = 1
end
else if @jungsama = 2
begin
set @Strength = 10
set @Osung = 15
set @WonyYang = 10
set @speed = 10
set @Magic = 10
织梦好,好织梦
set @Hp = 48
set @HpMax = 48 织梦好,好织梦
set @fatigue = 34
set @fatigueMax = 34
内容来自dedecms
set @zonenum = 2
end
else if @jungsama = 3
begin
set @Strength = 10
set @Osung = 12
set @WonyYang = 15
set @speed = 10
set @Magic = 8
set @Hp = 70
set @HpMax = 70 织梦内容管理系统
set @fatigue = 39
set @fatigueMax = 39
织梦好,好织梦
set @zonenum = 3
end
else
begin
set @flag=100
select @flag
return
end
本文来自织梦
begin tran
insert charinfo_base
values (@charid,@userindex,@kind,@edu,@jungsama,@nickname,@job,@level,@charexp,@charfame,@strength,@osung,@wonyyang,@speed,@magic,
@inbornpoint,@hp,@hpmax,@negong,@negongmax,@fatigue,@fatiguemax,@colorhair,@colorupper,@colorlower,@guilty,@zonenum,@cellx,@cellz,@adminchar) 内容来自dedecms
if @@rowcount <> 1
begin
rollback tran
set @flag = 100
select @flag
return
end 织梦内容管理系统
insert charinfo_time
values(@charid,@userindex,0,0,0,getdate(),getdate(),getdate()) copyright dedecms
if @@rowcount <> 1
begin
rollback tran
内容来自dedecms
set @flag = 100
select @flag
return
end
insert charinfo_skill (charid)
values (@charid)
if @@rowcount <> 1
begin
rollback tran
set @flag = 100
select @flag
return
end dedecms.com
insert charinfo_option (charid)
values (@charid) 本文来自织梦
if @@rowcount <> 1
begin
rollback tran
set @flag = 100
select @flag
return
end dedecms.com
exec USPCreateCharItem @userindex,@charid dedecms.com
commit tran
set @flag = 0
select @flag
return
end
GO
copyright dedecms
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号