要多仓库的进来看看！！ [复制链接]

删除WHS_SELECT
读入
CREATE proc WHS_SELECT
@op int,
@Accountid varchar(10)
as
set nocount on
declare @aid varchar(10)
,@cknum int
if @op=1 begin --读取ID,检查仓库是否存在
SELECT @aid=AccountID,@cknum=NeedExtCK FROM warehouse WHERE AccountID=@accountid
if @cknum is null begin --打开主仓库
INSERT INTO warehouse (AccountID, Items, Money, EndUseDate, DbVersion)
VALUES (@accountid,cast(REPLICATE(char(0xff),1200) as varbinary(1200))
,0, getdate(), 1)
Select @accountid AS AccountID
end else begin
Update warehouse Set ExtCKNum=NeedExtCK WHERE AccountID=@accountid
if @cknum=0
Select @aid AS AccountID
else begin
if not EXISTS (select AccountID FROM ExtWareHouse WHERE AccountID=@accountid and Number=@cknum) begin
INSERT INTO ExtWarehouse (AccountID,Number,Items, Money, EndUseDate, DbVersion)
VALUES (@accountid,@cknum,cast(REPLICATE(char(0xff),1200) as varbinary(1200))
,0, getdate(), 1)
end
Select @accountid AS AccountID
end
end
end else if @op=2 begin
SELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountid
if @cknum=0
SELECT Items from warehouse where AccountID=@accountid
else
SELECT Items from ExtWareHouse WHERE AccountID=@Accountid AND Number=@cknum
end else begin
SELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountid
if @cknum=0
SELECT Money, DbVersion, pw from warehouse where AccountID=@accountid
else
SELECT Money, DbVersion, pw from ExtWareHouse where AccountID=@accountid AND Number=@cknum
end
set nocount off
GO
即可！！

顶你线。。。。

狂顶～～

删除 WHS_UPD_Items

读入

CREATE proc WHS_UPD_Items
@items varchar(2500),
@Accountid varchar(10)
as
set nocount on
declare @cknum int
SELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountid
if @cknum=0 --主仓库
UPDATE warehouse set Items=cast(@items as varbinary(1200))
where AccountID=@accountid
else
UPDATE ExtWareHouse set Items=cast(@items as varbinary(1200))
where AccountID=@accountid AND Number=@cknum
--waitfor delay '00:00:10'
set nocount off

GO

删除WHS_UPD_MnyPwDbv

读入

CREATE proc WHS_UPD_MnyPwDbv
@mny int,
@pw int,
@dbv int,
@Accountid varchar(10)
as
set nocount on
declare @cknum int
SELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountid
if @cknum=0 begin --主仓库
if @pw=0
UPDATE warehouse set Money=@mny,pw=@pw,DbVersion=@dbv
where AccountID=@accountid
else
UPDATE warehouse set Money=@mny,pw=@pw,lastpw=@pw,DbVersion=@dbv
where AccountID=@accountid
UPDATE ExtWareHouse set pw=@pw where AccountID=@accountid
end else begin
UPDATE ExtWareHouse set Money=@mny,pw=@pw,DbVersion=@dbv
where AccountID=@accountid AND Number=@cknum
UPDATE ExtWareHouse set pw=@pw where AccountID=@accountid
if @pw=0
UPDATE WareHouse set pw=@pw where AccountID=@accountid
else
UPDATE WareHouse set pw=@pw,lastpw=@pw where AccountID=@accountid
end
--waitfor delay '00:00:10'
set nocount off

GO

删除WHS_UPD_Money

读入

CREATE proc WHS_UPD_Money
@mny int,
@Accountid varchar(10)
as
set nocount on
declare @cknum int
SELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountid
if @cknum=0 --主仓库
UPDATE warehouse set Money=@mny
where AccountID=@accountid
else
UPDATE ExtWareHouse set Money=@mny
where AccountID=@accountid AND Number=@cknum
--waitfor delay '00:00:10'
set nocount off

GO

就着四步，一个都步能少！！！

什么意思？楼主，最新的数据库仓库又不能用啦？

谢谢，研究ing～

这是针对一定存在玩家的GM想用户扩展仓库而又不想删除玩家数据用的，知道吗？如果你们没有玩家数据就直接用，就不用这样子了

测试。。。。没有用。。。。

或许是偶苯。。。

好。。。。。。。。。

楼主的意思是不是更换数据库以后，新注册的用户可以正常使用扩展仓库，可是老账号不能使用，用这上面的办法老账号也可以使用啦？

偶去测试。不管成功与否都顶你一把先！

我试过了是不行的。

测试OK

是不是要重启动八个文件？重新加载扩展功能没用？

这办法好象没用，还是说方法不对？

我^&*(&(&*)*)$%^$&%*^(这些命令好像就是数据库本身带的存储过程呀，一样的修改以后有什么用？难道我眼花了看错了？我晕

顶一下吧