CREATE PROCEDURE WZ_CharInfoChange
@AdminId varchar(10),
@mess varchar(10),
@action varchar(50),
@AccId varchar(10),
@GameID varchar(16),
@gamenum int,
@unknow2 varchar(10),
@cLevel1 int,
@Up1 int,
@exp1 int,
@st1 int,
@dex1 int,
@vi1 int,
@en1 int,
@mlift1 int,
@dlift1 int,
@mmagic1 int,
@dmagic1 int,
@cLevel2 int,
@Up2 int,
@exp2 int,
@st2 int,
@dex2 int,
@vi2 int,
@en2 int,
@mlift2 int,
@dlift2 int,
@mmagic2 int,
@dmagic2 int AS
begin
insert into MngModifyLog (ManagerID,AccountId,GameID,servernumber,LogText) values (@AdminId,@AccId,@GameID,@gamenum,@action)
insert into CharInfoModifyOrigin (cLevel,LevelUpPoint,Experience,Strength,Dexterity,Vitality,Energy,Life,MaxLife,Mana,MaxMana) valueS (@cLevel1,@Up1,@exp1,@st1,@dex1,@vi1,@en1,@mlift1,@dlift1,@mmagic1,@dmagic1)
insert into CharInfoModify (cLevel,LevelUpPoint,Experience,Strength,Dexterity,Vitality,Energy,Life,MaxLife,Mana,MaxMana) valueS (@cLevel2,@Up2,@exp2,@st2,@dex2,@vi2,@en2,@mlift2,@dlift2,@mmagic2,@dmagic2) 内容来自dedecms
insert into CharInfoModify (cLevel,LevelUpPoint,Experience,Strength,Dexterity,Vitality,Energy,Life,MaxLife,Mana,MaxMana) valueS (@cLevel2,@Up2,@exp2,@st2,@dex2,@vi2,@en2,@mlift2,@dlift2,@mmagic2,@dmagic2)
update Character set cLevel=@cLevel2,LevelUpPoint=@Up2,Experience=@exp2,Strength=@st2,Dexterity=@dex2,Vitality=@vi2,Energy=@en2,Life=@mlift2,MaxLife=@dlift2,Mana=@mmagic2,MaxMana=@dmagic2 where AccountID=@AccId and Name=@GameId
end
GO
如果提示语法错误,那到你的MngModifyLog,CharInfoModifyOrigin,CharInfoModify这三个表的结构可能跟我有出入,自己看一下吧
下面是我这三个表的sql语句,结构上有几处我改过了大家自己看办
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CharInfoModify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CharInfoModify]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CharInfoModifyOrigin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) 内容来自dedecms
drop table [dbo].[CharInfoModifyOrigin]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MngModifyLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MngModifyLog]
GO
CREATE TABLE [dbo].[CharInfoModify] (
[Number] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[cLevel] [int] NULL ,
[LevelUpPoint] [int] NULL ,
[Experience] [int] NULL ,
[Strength] [smallint] NULL ,
[Dexterity] [smallint] NULL ,
[Vitality] [smallint] NULL ,
[Energy] [smallint] NULL ,
[Life] [real] NULL ,
[MaxLife] [real] NULL ,
[Mana] [real] NULL ,
[MaxMana] [real] NULL ,
[cDate] [smalldatetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CharInfoModifyOrigin] (
[Number] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[cLevel] [int] NULL ,
[LevelUpPoint] [int] NULL ,
[Experience] [int] NULL ,
[Strength] [smallint] NULL ,
[Dexterity] [smallint] NULL ,
[Vitality] [smallint] NULL , 内容来自dedecms
[Energy] [smallint] NULL ,
[Life] [real] NULL ,
[MaxLife] [real] NULL ,
[Mana] [real] NULL ,
[MaxMana] [real] NULL ,
[cDate] [smalldatetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MngModifyLog] (
[Number] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[ManagerID] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[AccountId] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GameID] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[servernumber] [tinyint] NULL ,
[IP] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[ModifyDate] [smalldatetime] NULL ,
[LogType] [smallint] NULL ,
[LogText] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CharInfoModify] WITH NOCHECK ADD
CONSTRAINT [DF_CharInfoModify_cDate] DEFAULT (getdate()) FOR [cDate]
GO
ALTER TABLE [dbo].[CharInfoModifyOrigin] WITH NOCHECK ADD
CONSTRAINT [DF_CharInfoModifyOrigin_cDate] DEFAULT (getdate()) FOR [cDate]
copyright dedecms
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号