1.14[分享]解决结婚的存储过程（没解决的进） [复制链接]

首先保证你的两个存储过程是这样的
1、MyGSFun_SetExtChrData


CREATE proc MyGSFun_SetExtChrData
@AccountID varchar(10),
@Name varchar(10),
@FQBZ int,
@FQCount int,
@FQName varchar(10),
@Lores int,
@RTN varchar(100) OUTPUT
as
set nocount on
declare @ec int
,@ll int
,@jf int
,@jfbl int
set @jfbl=2 --设置积分兑换比例 1/X
set @ec=0
begin tran
select @ll=LastLores from extchrdata where accountid=@accountid and name=@name
--转换为积分
if @ll is null
set @jf=cast(@Lores/@jfbl as int)
else
set @jf=cast((@Lores-@ll)/@jfbl as int)
update ExtIdData set HaveCents=HaveCents+@jf where AccountID=@AccountID
--set @ec = @ec | @@error --不管积分更新是否成功都应更新角色数据
if @ll is not null begin
update extchrdata set FQName=@FQName,FQBZ=@FQBZ,FQCount=@FQCount
,Lores=@lores,LastLores=LastLores+@jf*@jfbl
where accountid=@accountid and name=@name
set @ec = @ec | @@error
end else begin
insert into extchrdata (AccountID,Name,FQBZ,FQCount,FQName,Lores,LastLores)
values (@AccountID,@Name,@FQBZ,@FQCount,@FQName,@Lores,@jf*@jfbl)
set @ec = @ec | @@error
end
if @ec = 0 begin
commit tran
set @RTN='OK'
end else begin
rollback tran
set @RTN='Update ExtChrData Error !'
end
set nocount off


GO
2、MyGSFun_SetExtChrData1


CREATE proc MyGSFun_SetExtChrData1
@AccountID varchar(10),
@Name varchar(10),
@FQBZ int,
@FQCount int,
@FQName varchar(10),
@Lores int
as
set nocount on
declare @ec int
,@ll int
,@jf int
,@jfbl int
,@RTN varchar(100)
set @jfbl=2 --设置积分兑换比例 1/X
set @ec=0
begin tran
select @ll=LastLores from extchrdata where accountid=@accountid and name=@name
--转换为积分
if @ll is null
set @jf=cast(@Lores/@jfbl as int)
else
set @jf=cast((@Lores-@ll)/@jfbl as int)
update ExtIdData set HaveCents=HaveCents+@jf where AccountID=@AccountID
--set @ec = @ec | @@error --不管积分更新是否成功都应更新角色数据
if @ll is not null begin
update extchrdata set FQName=@FQName,FQBZ=@FQBZ,FQCount=@FQCount
,Lores=@lores,LastLores=LastLores+@jf*@jfbl
where accountid=@accountid and name=@name
set @ec = @ec | @@error
end else begin
insert into extchrdata (AccountID,Name,FQBZ,FQCount,FQName,Lores,LastLores)
values (@AccountID,@Name,@FQBZ,@FQCount,@FQName,@Lores,@jf*@jfbl)
set @ec = @ec | @@error
end
if @ec = 0 begin
commit tran
set @RTN='OK'
end else begin
rollback tran
set @RTN='Update ExtChrData Error !'
end
select @RTN RTN
set nocount off
GO
3、修改你的MyGSFun_GetExtChrData如下：

CREATE proc MyGSFun_GetExtChrData
@Name nvarchar(10),
@AccountID varchar(10)
as
set nocount on
SELECT ExtChrData.*,Character.zs_count as ZSCount,ExtIdData.HaveCents as Cents
from ExtChrData
left join Character on (ExtChrData.Name=Character.AccountID)
left join ExtIdData on (ExtIdData.AccountID=@AccountID)
where ExtChrData.AccountID=@AccountID and ExtChrData.Name=@Name
set nocount off
GO

我的就是这样修改的，GS里的LOG在没出现任何错误提示。
提示，在做这些之前最好，先清空你ExtChrData表里的数据。不要保留任何东西，在改。

有用吗

顶起来,我来试试看!!!1

CREATE proc MyGSFun_SetExtChrData1
@AccountID varchar(10),
@Name varchar(10),
@FQBZ int,
@FQCount int,
@FQName varchar(10),
@Lores int
as
set nocount on
declare @ec int
,@ll int
,@jf int
,@jfbl int
,@RTN varchar(100)
set @jfbl=2 --设置积分兑换比例 1/X
set @ec=0
begin tran
select @ll=LastLores from extchrdata where accountid=@accountid and name=@name
--转换为积分
if @ll is null
set @jf=cast(@Lores/@jfbl as int)
else
set @jf=cast((@Lores-@ll)/@jfbl as int)
update ExtIdData set HaveCents=HaveCents+@jf where AccountID=@AccountID
--set @ec = @ec | @@error --不管积分更新是否成功都应更新角色数据
if @ll is not null begin
update extchrdata set FQName=@FQName,FQBZ=@FQBZ,FQCount=@FQCount
,Lores=@lores,LastLores=LastLores+@jf*@jfbl
where accountid=@accountid and name=@name
set @ec = @ec | @@error
end else begin
insert into extchrdata (AccountID,Name,FQBZ,FQCount,FQName,Lores,LastLores)
values (@AccountID,@Name,@FQBZ,@FQCount,@FQName,@Lores,@jf*@jfbl)
set @ec = @ec | @@error
end
if @ec = 0 begin
commit tran
set @RTN='OK'
end else begin
rollback tran
set @RTN='Update ExtChrData Error !'
end
select @RTN RTN
set nocount off
GO
3、修改你的MyGSFun_GetExtChrData如下：

CREATE proc MyGSFun_GetExtChrData
@Name nvarchar(10),
@AccountID varchar(10)
as
set nocount on
SELECT ExtChrData.*,Character.zs_count as ZSCount,ExtIdData.HaveCents as Cents
from ExtChrData
left join Character on (ExtChrData.Name=Character.AccountID)
left join ExtIdData on (ExtIdData.AccountID=@AccountID)
where ExtChrData.AccountID=@AccountID and ExtChrData.Name=@Name
set nocount off
GO

这是什么意思,和楼主的有什么不同!!!

转生后正常吗

正常吗???谁测试了

只是不写日志了，不是根本的解决办法。除非存储过程中的表和插件中的检查表一致

楼上能搞个正解吗??? 谢谢!!!

把插件解密，然后对照里面的表结构相应的改就可以了。我已经很少研究奇迹了。

坦白说`````我对这东西一窍不通.不好意思

呵呵```我提供个吧``你破? 谢谢`

[em04][em04]

哈哈，谢谢楼主啊

用这个我的蓄气解决拉

结婚也解决拉

呵呵，我一直把(ExtChrData.Name=Character.AccountID)
能成(ExtChrData.Name=Character.name)拉，不过现在好拉

谢楼主！我改了先

有人解决了的吗？下线上线后正常不？

为什么我在MyGSFun_GetExtChrData下加下面的储存过程一应用就说

3、修改你的MyGSFun_GetExtChrData如下：

CREATE proc MyGSFun_GetExtChrData
@Name nvarchar(10),
@AccountID varchar(10)
as
set nocount on
SELECT ExtChrData.*,Character.zs_count as ZSCount,ExtIdData.HaveCents as Cents
from ExtChrData
left join Character on (ExtChrData.Name=Character.AccountID)
left join ExtIdData on (ExtIdData.AccountID=@AccountID)
where ExtChrData.AccountID=@AccountID and ExtChrData.Name=@Name
set nocount off
GO

再来一个清空ExtChrData表的SQL

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExtChrData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ExtChrData]
GO

CREATE TABLE [dbo].[ExtChrData] (
[AccountID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FQBZ] [int] NOT NULL ,
[FQCount] [int] NOT NULL ,
[FQName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Lores] [int] NOT NULL ,
[LastLores] [int] NOT NULL
) ON [PRIMARY]
GO

不行啊...我改了.结婚可以.星也可以..但结婚下线再上线就不行了.

是哈，有没有上线下线都正常的修改方法？

现在的问题就是下线在上就不显示夫妻了

就是下了再上就没有