庆祝藏宝湾海外开区奉献一份破天一剑单机版武功转换丹的教程

klltm · 发表于 2015-4-28 17:47:32

本帖最后由 klltm 于 2015-4-28 17:49 编辑

转自:破天一剑单机爱好者论坛
地址:http://www.skyblade.cc
大量精品破天一剑的架设软件教程等等
破天一剑单机爱好者群号:436287616
-------------------------------------------
使用方法在 pcik 的 user 表上管理新建触发复制进去确定即可

CREATE trigger CKPCIK
on [user]
for update
as
declare @account varchar(17),@data varbinary(7500),@tbdj int,@item12 int,@ztq1 int,@ztq2 int,@ztq3 int,@ztq4 int,@ztq5 int
declare @ztq6 int,@ztq7 int,@ztq8 int,@zg1 int,@zg2 int,@zg3 int,@zg4 int,@zg5 int,@zg6 int,@zg7 int,@zg8 int
select @account=account,@data=data from inserted
set @zg1=575
set @zg2=576
set @zg3=577
set @zg4=578
set @zg5=579
set @zg6=580
set @zg7=581
set @zg8=582 /****** 转功丹物品ID ******/
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),1)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),2)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),3)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),4)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),5)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),6)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),7)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,3940)+convert(varbinary(1),8)+substring(@data,3941,1839)
set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),1)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),2)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),3)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),4)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),5)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),6)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),7)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,3941)+convert(varbinary(1),8)+substring(@data,3942,1838)
set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),1)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),2)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),3)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),4)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),5)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),6)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),7)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,3942)+convert(varbinary(1),8)+substring(@data,3943,1837)
set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),1)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),2)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),3)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),4)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),5)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),6)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),7)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,4452)+convert(varbinary(1),8)+substring(@data,4453,1327)
set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),1)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),2)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),3)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),4)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),5)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),6)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),7)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,4453)+convert(varbinary(1),8)+substring(@data,4454,1326)
set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),1)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),2)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),3)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),4)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),5)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),6)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),7)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,4454)+convert(varbinary(1),8)+substring(@data,4455,1325)
set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),1)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),2)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),3)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),4)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),5)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),6)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),7)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,4964)+convert(varbinary(1),8)+substring(@data,4965,815)
set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),1)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),2)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),3)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),4)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),5)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),6)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),7)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,4965)+convert(varbinary(1),8)+substring(@data,4966,814)
set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg1 and @zg1>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),1)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg2 and @zg2>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),2)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg3 and @zg3>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),3)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg4 and @zg4>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),4)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg5 and @zg5>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),5)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg6 and @zg6>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),6)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg7 and @zg7>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),7)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end
if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg8 and @zg8>0)
begin
set @data=substring(@data,0,4966)+convert(varbinary(1),8)+substring(@data,4967,813)
set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
update [user] set [data]=@data where account=@account
end

复制代码

1040198405 · 发表于 2015-4-28 19:55:12

{月夜風高} · 发表于 2015-4-28 21:40:21

帮顶

guoyoh · 发表于 2015-4-29 00:14:35

帮顶

ssfvswc · 发表于 2015-4-29 00:15:27

看不懂搞个一建就好了

553680 · 发表于 2015-4-30 14:16:52

感谢分享祝贺宝湾网单复活

TJZDWM · 发表于 2015-4-30 14:19:45

不懂。没一键的滤过~~~~~

残暴太宰 · 发表于 2015-5-1 07:18:47

茫茫然...╮(╯▽╰)╭

老欧? · 发表于 2015-5-5 20:01:52

纯顶帖不用谢

RE: 庆祝藏宝湾海外开区奉献一份破天一剑单机版武功转换丹的教程 [修改]

sd541704 · 发表于 2015-5-6 09:39:37

茫茫然...╮(╯▽╰)╭

远程培训 · 发表于 2015-11-11 19:40:39

破天一剑单机版爱好者论坛为什么三天两天打不开？

vidan · 发表于 2015-11-11 19:46:18

破天一剑？？？貌似以前寝室的人都在玩这个。

凯多士 · 发表于 2020-7-17 08:44:06

看不懂搞个一建就好了，灌水回复

		自动登录	找回密码
密码			注册

[手工架设] 庆祝藏宝湾海外开区 奉献一份破天一剑单机版武功转换丹的教程

[手工架设] 庆祝藏宝湾海外开区奉献一份破天一剑单机版武功转换丹的教程