织梦CMS - 轻松建站从此开始!

天堂系列-新天堂II殿堂级|传奇天堂3发布网站 TT3SF.COM

当前位置: 主页 > 天堂2私服 >

武魂私服给新生人物自动加先天点

时间:2011-06-05 12:03来源: 作者: 点击:
数据库里改存储过程:USPNewCreateChar如下: CREATE proc USPNewCreateChar @charindex int,@charid varchar(14),@userindex int,@kind tinyint,@edu tinyint,@jungsama tinyint, @colorhair tinyint,@colorUpper tinyint,@colorLower tinyint,@cellx small

数据库里改存储过程: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

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


  -- ?:?:? ?? ? ??
  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

   set @Hp = 38
   set @HpMax = 38

   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

   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)

  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())

  if @@rowcount <> 1
  begin
   rollback tran

   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

  insert charinfo_option (charid)
  values (@charid)

  if @@rowcount <> 1
  begin (责任编辑:admin)

织梦二维码生成器
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
验证码: 点击我更换图片
栏目列表
推荐内容