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

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

转自:破天一剑单机爱好者论坛
地址:http://www.skyblade.cc
大量精品破天一剑的架设 软件 教程等等
破天一剑单机爱好者群号:436287616

——————————————-


使用方法 在 pcik 的 user 表上 管理新建触发 复制进去 确定即可

1. CREATE trigger CKPCIK
2. on [user]
3. for update
4. as
5. declare @account varchar(17),@data varbinary(7500),@tbdj int,@item12 int,@ztq1 int,@ztq2 int,@ztq3 int,@ztq4 int,@ztq5 int
6. declare @ztq6 int,@ztq7 int,@ztq8 int,@zg1 int,@zg2 int,@zg3 int,@zg4 int,@zg5 int,@zg6 int,@zg7 int,@zg8 int
7. select @account=account,@data=data from inserted
9. set @zg1=575
10. set @zg2=576
11. set @zg3=577
12. set @zg4=578
13. set @zg5=579
14. set @zg6=580
15. set @zg7=581
16. set @zg8=582  /****** 转功丹物品ID ******/
19. if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg1 and @zg1>0)   
21.   begin
22.    set @data=substring(@data,0,3940)+convert(varbinary(1),1)+substring(@data,3941,1839)
23.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
24.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
25.    update [user] set [data]=@data where account=@account
26.   end
28. if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg2 and @zg2>0)   
30.   begin
31.    set @data=substring(@data,0,3940)+convert(varbinary(1),2)+substring(@data,3941,1839)
32.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
33.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
34.    update [user] set [data]=@data where account=@account
35.   end
37. if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg3 and @zg3>0)   
39.   begin
40.    set @data=substring(@data,0,3940)+convert(varbinary(1),3)+substring(@data,3941,1839)
41.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
42.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
43.    update [user] set [data]=@data where account=@account
44.   end
46. if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg4 and @zg4>0)   
48.   begin
49.    set @data=substring(@data,0,3940)+convert(varbinary(1),4)+substring(@data,3941,1839)
50.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
51.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
52.    update [user] set [data]=@data where account=@account
53.   end
55. if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg5 and @zg5>0)   
57.   begin
58.    set @data=substring(@data,0,3940)+convert(varbinary(1),5)+substring(@data,3941,1839)
59.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
60.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
61.    update [user] set [data]=@data where account=@account
62.   end
64. if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg6 and @zg6>0)   
66.   begin
67.    set @data=substring(@data,0,3940)+convert(varbinary(1),6)+substring(@data,3941,1839)
68.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
69.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
70.    update [user] set [data]=@data where account=@account
71.   end
73. if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg7 and @zg7>0)   
75.   begin
76.    set @data=substring(@data,0,3940)+convert(varbinary(1),7)+substring(@data,3941,1839)
77.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
78.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
79.    update [user] set [data]=@data where account=@account
80.   end
82. if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,315,1)+substring(@data,314,1))=@zg8 and @zg8>0)   
84.   begin
85.    set @data=substring(@data,0,3940)+convert(varbinary(1),8)+substring(@data,3941,1839)
86.    set @data=substring(@data,0,314)+convert(varbinary(4),0)+substring(@data,318,5462)
87.    set @data=substring(@data,0,318)+convert(varbinary(4),0)+substring(@data,322,5458)
88.    update [user] set [data]=@data where account=@account
89.   end
91. if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg1 and @zg1>0)   
93.   begin
94.    set @data=substring(@data,0,3941)+convert(varbinary(1),1)+substring(@data,3942,1838)
95.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
96.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
97.    update [user] set [data]=@data where account=@account
98.   end
100. if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg2 and @zg2>0)   
102.   begin
103.    set @data=substring(@data,0,3941)+convert(varbinary(1),2)+substring(@data,3942,1838)
104.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
105.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
106.    update [user] set [data]=@data where account=@account
107.   end
109. if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg3 and @zg3>0)   
111.   begin
112.    set @data=substring(@data,0,3941)+convert(varbinary(1),3)+substring(@data,3942,1838)
113.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
114.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
115.    update [user] set [data]=@data where account=@account
116.   end
118. if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg4 and @zg4>0)   
120.   begin
121.    set @data=substring(@data,0,3941)+convert(varbinary(1),4)+substring(@data,3942,1838)
122.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
123.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
124.    update [user] set [data]=@data where account=@account
125.   end
127. if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg5 and @zg5>0)   
129.   begin
130.    set @data=substring(@data,0,3941)+convert(varbinary(1),5)+substring(@data,3942,1838)
131.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
132.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
133.    update [user] set [data]=@data where account=@account
134.   end
136. if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg6 and @zg6>0)   
138.   begin
139.    set @data=substring(@data,0,3941)+convert(varbinary(1),6)+substring(@data,3942,1838)
140.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
141.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
142.    update [user] set [data]=@data where account=@account
143.   end
145. if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg7 and @zg7>0)   
147.   begin
148.    set @data=substring(@data,0,3941)+convert(varbinary(1),7)+substring(@data,3942,1838)
149.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
150.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
151.    update [user] set [data]=@data where account=@account
152.   end
154. if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,323,1)+substring(@data,322,1))=@zg8 and @zg8>0)   
156.   begin
157.    set @data=substring(@data,0,3941)+convert(varbinary(1),8)+substring(@data,3942,1838)
158.    set @data=substring(@data,0,322)+convert(varbinary(4),0)+substring(@data,326,5454)
159.    set @data=substring(@data,0,326)+convert(varbinary(4),0)+substring(@data,330,5450)
160.    update [user] set [data]=@data where account=@account
161.   end
163. if(substring(@data,24,1)<>0x68) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg1 and @zg1>0)   
165.   begin
166.    set @data=substring(@data,0,3942)+convert(varbinary(1),1)+substring(@data,3943,1837)
167.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
168.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
169.    update [user] set [data]=@data where account=@account
170.   end
172. if(substring(@data,24,1)<>0x6B) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg2 and @zg2>0)   
174.   begin
175.    set @data=substring(@data,0,3942)+convert(varbinary(1),2)+substring(@data,3943,1837)
176.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
177.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
178.    update [user] set [data]=@data where account=@account
179.   end
181. if(substring(@data,24,1)<>0x6C) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg3 and @zg3>0)   
183.   begin
184.    set @data=substring(@data,0,3942)+convert(varbinary(1),3)+substring(@data,3943,1837)
185.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
186.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
187.    update [user] set [data]=@data where account=@account
188.   end
190. if(substring(@data,24,1)<>0x67) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg4 and @zg4>0)   
192.   begin
193.    set @data=substring(@data,0,3942)+convert(varbinary(1),4)+substring(@data,3943,1837)
194.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
195.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
196.    update [user] set [data]=@data where account=@account
197.   end
199. if(substring(@data,24,1)<>0x6A) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg5 and @zg5>0)   
201.   begin
202.    set @data=substring(@data,0,3942)+convert(varbinary(1),5)+substring(@data,3943,1837)
203.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
204.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
205.    update [user] set [data]=@data where account=@account
206.   end
208. if(substring(@data,24,1)<>0x66) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg6 and @zg6>0)   
210.   begin
211.    set @data=substring(@data,0,3942)+convert(varbinary(1),6)+substring(@data,3943,1837)
212.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
213.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
214.    update [user] set [data]=@data where account=@account
215.   end
217. if(substring(@data,24,1)<>0x65) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg7 and @zg7>0)   
219.   begin
220.    set @data=substring(@data,0,3942)+convert(varbinary(1),7)+substring(@data,3943,1837)
221.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
222.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
223.    update [user] set [data]=@data where account=@account
224.   end
226. if(substring(@data,24,1)<>0x69) and (convert(int,substring(@data,331,1)+substring(@data,330,1))=@zg8 and @zg8>0)   
228.   begin
229.    set @data=substring(@data,0,3942)+convert(varbinary(1),8)+substring(@data,3943,1837)
230.    set @data=substring(@data,0,330)+convert(varbinary(4),0)+substring(@data,334,5446)
231.    set @data=substring(@data,0,334)+convert(varbinary(4),0)+substring(@data,338,5442)
232.    update [user] set [data]=@data where account=@account
233.   end
235. if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg1 and @zg1>0)   
237.   begin
238.    set @data=substring(@data,0,4452)+convert(varbinary(1),1)+substring(@data,4453,1327)
239.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
240.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
241.    update [user] set [data]=@data where account=@account
242.   end
244. if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg2 and @zg2>0)   
246.   begin
247.    set @data=substring(@data,0,4452)+convert(varbinary(1),2)+substring(@data,4453,1327)
248.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
249.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
250.    update [user] set [data]=@data where account=@account
251.   end
253. if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg3 and @zg3>0)   
255.   begin
256.    set @data=substring(@data,0,4452)+convert(varbinary(1),3)+substring(@data,4453,1327)
257.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
258.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
259.    update [user] set [data]=@data where account=@account
260.   end
262. if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg4 and @zg4>0)   
264.   begin
265.    set @data=substring(@data,0,4452)+convert(varbinary(1),4)+substring(@data,4453,1327)
266.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
267.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
268.    update [user] set [data]=@data where account=@account
269.   end
271. if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg5 and @zg5>0)   
273.   begin
274.    set @data=substring(@data,0,4452)+convert(varbinary(1),5)+substring(@data,4453,1327)
275.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
276.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
277.    update [user] set [data]=@data where account=@account
278.   end
280. if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg6 and @zg6>0)   
282.   begin
283.    set @data=substring(@data,0,4452)+convert(varbinary(1),6)+substring(@data,4453,1327)
284.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
285.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
286.    update [user] set [data]=@data where account=@account
287.   end
289. if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg7 and @zg7>0)   
291.   begin
292.    set @data=substring(@data,0,4452)+convert(varbinary(1),7)+substring(@data,4453,1327)
293.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
294.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
295.    update [user] set [data]=@data where account=@account
296.   end
298. if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1070,1)+substring(@data,1069,1))=@zg8 and @zg8>0)   
300.   begin
301.    set @data=substring(@data,0,4452)+convert(varbinary(1),8)+substring(@data,4453,1327)
302.    set @data=substring(@data,0,1069)+convert(varbinary(4),0)+substring(@data,1073,4707)
303.    set @data=substring(@data,0,1073)+convert(varbinary(4),0)+substring(@data,1077,4703)
304.    update [user] set [data]=@data where account=@account
305.   end
307. if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg1 and @zg1>0)   
309.   begin
310.    set @data=substring(@data,0,4453)+convert(varbinary(1),1)+substring(@data,4454,1326)
311.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
312.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
313.    update [user] set [data]=@data where account=@account
314.   end
316. if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg2 and @zg2>0)   
318.   begin
319.    set @data=substring(@data,0,4453)+convert(varbinary(1),2)+substring(@data,4454,1326)
320.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
321.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
322.    update [user] set [data]=@data where account=@account
323.   end
325. if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg3 and @zg3>0)   
327.   begin
328.    set @data=substring(@data,0,4453)+convert(varbinary(1),3)+substring(@data,4454,1326)
329.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
330.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
331.    update [user] set [data]=@data where account=@account
332.   end
334. if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg4 and @zg4>0)   
336.   begin
337.    set @data=substring(@data,0,4453)+convert(varbinary(1),4)+substring(@data,4454,1326)
338.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
339.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
340.    update [user] set [data]=@data where account=@account
341.   end
343. if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg5 and @zg5>0)   
345.   begin
346.    set @data=substring(@data,0,4453)+convert(varbinary(1),5)+substring(@data,4454,1326)
347.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
348.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
349.    update [user] set [data]=@data where account=@account
350.   end
352. if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg6 and @zg6>0)   
354.   begin
355.    set @data=substring(@data,0,4453)+convert(varbinary(1),6)+substring(@data,4454,1326)
356.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
357.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
358.    update [user] set [data]=@data where account=@account
359.   end
361. if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg7 and @zg7>0)   
363.   begin
364.    set @data=substring(@data,0,4453)+convert(varbinary(1),7)+substring(@data,4454,1326)
365.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
366.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
367.    update [user] set [data]=@data where account=@account
368.   end
370. if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1078,1)+substring(@data,1077,1))=@zg8 and @zg8>0)   
372.   begin
373.    set @data=substring(@data,0,4453)+convert(varbinary(1),8)+substring(@data,4454,1326)
374.    set @data=substring(@data,0,1077)+convert(varbinary(4),0)+substring(@data,1081,4699)
375.    set @data=substring(@data,0,1081)+convert(varbinary(4),0)+substring(@data,1085,4695)
376.    update [user] set [data]=@data where account=@account
377.   end
379. if(substring(@data,779,1)<>0x68) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg1 and @zg1>0)   
381.   begin
382.    set @data=substring(@data,0,4454)+convert(varbinary(1),1)+substring(@data,4455,1325)
383.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
384.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
385.    update [user] set [data]=@data where account=@account
386.   end
388. if(substring(@data,779,1)<>0x6B) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg2 and @zg2>0)   
390.   begin
391.    set @data=substring(@data,0,4454)+convert(varbinary(1),2)+substring(@data,4455,1325)
392.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
393.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
394.    update [user] set [data]=@data where account=@account
395.   end
397. if(substring(@data,779,1)<>0x6C) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg3 and @zg3>0)   
399.   begin
400.    set @data=substring(@data,0,4454)+convert(varbinary(1),3)+substring(@data,4455,1325)
401.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
402.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
403.    update [user] set [data]=@data where account=@account
404.   end
406. if(substring(@data,779,1)<>0x67) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg4 and @zg4>0)   
408.   begin
409.    set @data=substring(@data,0,4454)+convert(varbinary(1),4)+substring(@data,4455,1325)
410.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
411.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
412.    update [user] set [data]=@data where account=@account
413.   end
415. if(substring(@data,779,1)<>0x6A) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg5 and @zg5>0)   
417.   begin
418.    set @data=substring(@data,0,4454)+convert(varbinary(1),5)+substring(@data,4455,1325)
419.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
420.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
421.    update [user] set [data]=@data where account=@account
422.   end
424. if(substring(@data,779,1)<>0x66) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg6 and @zg6>0)   
426.   begin
427.    set @data=substring(@data,0,4454)+convert(varbinary(1),6)+substring(@data,4455,1325)
428.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
429.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
430.    update [user] set [data]=@data where account=@account
431.   end
433. if(substring(@data,779,1)<>0x65) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg7 and @zg7>0)   
435.   begin
436.    set @data=substring(@data,0,4454)+convert(varbinary(1),7)+substring(@data,4455,1325)
437.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
438.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
439.    update [user] set [data]=@data where account=@account
440.   end
442. if(substring(@data,779,1)<>0x69) and (convert(int,substring(@data,1086,1)+substring(@data,1085,1))=@zg8 and @zg8>0)   
444.   begin
445.    set @data=substring(@data,0,4454)+convert(varbinary(1),8)+substring(@data,4455,1325)
446.    set @data=substring(@data,0,1085)+convert(varbinary(4),0)+substring(@data,1089,4691)
447.    set @data=substring(@data,0,1089)+convert(varbinary(4),0)+substring(@data,1093,4687)
448.    update [user] set [data]=@data where account=@account
449.   end
451. if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg1 and @zg1>0)   
453.   begin
454.    set @data=substring(@data,0,4964)+convert(varbinary(1),1)+substring(@data,4965,815)
455.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
456.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
457.    update [user] set [data]=@data where account=@account
458.   end
460. if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg2 and @zg2>0)   
462.   begin
463.    set @data=substring(@data,0,4964)+convert(varbinary(1),2)+substring(@data,4965,815)
464.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
465.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
466.    update [user] set [data]=@data where account=@account
467.   end
469. if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg3 and @zg3>0)   
471.   begin
472.    set @data=substring(@data,0,4964)+convert(varbinary(1),3)+substring(@data,4965,815)
473.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
474.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
475.    update [user] set [data]=@data where account=@account
476.   end
478. if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg4 and @zg4>0)   
480.   begin
481.    set @data=substring(@data,0,4964)+convert(varbinary(1),4)+substring(@data,4965,815)
482.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
483.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
484.    update [user] set [data]=@data where account=@account
485.   end
487. if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg5 and @zg5>0)   
489.   begin
490.    set @data=substring(@data,0,4964)+convert(varbinary(1),5)+substring(@data,4965,815)
491.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
492.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
493.    update [user] set [data]=@data where account=@account
494.   end
496. if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg6 and @zg6>0)   
498.   begin
499.    set @data=substring(@data,0,4964)+convert(varbinary(1),6)+substring(@data,4965,815)
500.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
501.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
502.    update [user] set [data]=@data where account=@account
503.   end
505. if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg7 and @zg7>0)   
507.   begin
508.    set @data=substring(@data,0,4964)+convert(varbinary(1),7)+substring(@data,4965,815)
509.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
510.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
511.    update [user] set [data]=@data where account=@account
512.   end
514. if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1825,1)+substring(@data,1824,1))=@zg8 and @zg8>0)   
516.   begin
517.    set @data=substring(@data,0,4964)+convert(varbinary(1),8)+substring(@data,4965,815)
518.    set @data=substring(@data,0,1824)+convert(varbinary(4),0)+substring(@data,1828,3952)
519.    set @data=substring(@data,0,1828)+convert(varbinary(4),0)+substring(@data,1832,3948)
520.    update [user] set [data]=@data where account=@account
521.   end
523. if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg1 and @zg1>0)   
525.   begin
526.    set @data=substring(@data,0,4965)+convert(varbinary(1),1)+substring(@data,4966,814)
527.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
528.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
529.    update [user] set [data]=@data where account=@account
530.   end
532. if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg2 and @zg2>0)   
534.   begin
535.    set @data=substring(@data,0,4965)+convert(varbinary(1),2)+substring(@data,4966,814)
536.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
537.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
538.    update [user] set [data]=@data where account=@account
539.   end
541. if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg3 and @zg3>0)   
543.   begin
544.    set @data=substring(@data,0,4965)+convert(varbinary(1),3)+substring(@data,4966,814)
545.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
546.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
547.    update [user] set [data]=@data where account=@account
548.   end
550. if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg4 and @zg4>0)   
552.   begin
553.    set @data=substring(@data,0,4965)+convert(varbinary(1),4)+substring(@data,4966,814)
554.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
555.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
556.    update [user] set [data]=@data where account=@account
557.   end
559. if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg5 and @zg5>0)   
561.   begin
562.    set @data=substring(@data,0,4965)+convert(varbinary(1),5)+substring(@data,4966,814)
563.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
564.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
565.    update [user] set [data]=@data where account=@account
566.   end
568. if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg6 and @zg6>0)   
570.   begin
571.    set @data=substring(@data,0,4965)+convert(varbinary(1),6)+substring(@data,4966,814)
572.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
573.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
574.    update [user] set [data]=@data where account=@account
575.   end
577. if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg7 and @zg7>0)   
579.   begin
580.    set @data=substring(@data,0,4965)+convert(varbinary(1),7)+substring(@data,4966,814)
581.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
582.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
583.    update [user] set [data]=@data where account=@account
584.   end
586. if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1833,1)+substring(@data,1832,1))=@zg8 and @zg8>0)   
588.   begin
589.    set @data=substring(@data,0,4965)+convert(varbinary(1),8)+substring(@data,4966,814)
590.    set @data=substring(@data,0,1832)+convert(varbinary(4),0)+substring(@data,1836,3944)
591.    set @data=substring(@data,0,1836)+convert(varbinary(4),0)+substring(@data,1840,3940)
592.    update [user] set [data]=@data where account=@account
593.   end
595. if(substring(@data,1534,1)<>0x68) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg1 and @zg1>0)   
597.   begin
598.    set @data=substring(@data,0,4966)+convert(varbinary(1),1)+substring(@data,4967,813)
599.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
600.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
601.    update [user] set [data]=@data where account=@account
602.   end
604. if(substring(@data,1534,1)<>0x6B) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg2 and @zg2>0)   
606.   begin
607.    set @data=substring(@data,0,4966)+convert(varbinary(1),2)+substring(@data,4967,813)
608.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
609.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
610.    update [user] set [data]=@data where account=@account
611.   end
613. if(substring(@data,1534,1)<>0x6C) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg3 and @zg3>0)   
615.   begin
616.    set @data=substring(@data,0,4966)+convert(varbinary(1),3)+substring(@data,4967,813)
617.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
618.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
619.    update [user] set [data]=@data where account=@account
620.   end
622. if(substring(@data,1534,1)<>0x67) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg4 and @zg4>0)   
624.   begin
625.    set @data=substring(@data,0,4966)+convert(varbinary(1),4)+substring(@data,4967,813)
626.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
627.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
628.    update [user] set [data]=@data where account=@account
629.   end
631. if(substring(@data,1534,1)<>0x6A) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg5 and @zg5>0)   
633.   begin
634.    set @data=substring(@data,0,4966)+convert(varbinary(1),5)+substring(@data,4967,813)
635.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
636.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
637.    update [user] set [data]=@data where account=@account
638.   end
640. if(substring(@data,1534,1)<>0x66) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg6 and @zg6>0)   
642.   begin
643.    set @data=substring(@data,0,4966)+convert(varbinary(1),6)+substring(@data,4967,813)
644.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
645.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
646.    update [user] set [data]=@data where account=@account
647.   end
649. if(substring(@data,1534,1)<>0x65) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg7 and @zg7>0)   
651.   begin
652.    set @data=substring(@data,0,4966)+convert(varbinary(1),7)+substring(@data,4967,813)
653.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
654.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
655.    update [user] set [data]=@data where account=@account
656.   end
658. if(substring(@data,1534,1)<>0x69) and (convert(int,substring(@data,1841,1)+substring(@data,1840,1))=@zg8 and @zg8>0)   
660.   begin
661.    set @data=substring(@data,0,4966)+convert(varbinary(1),8)+substring(@data,4967,813)
662.    set @data=substring(@data,0,1840)+convert(varbinary(4),0)+substring(@data,1844,3936)
663.    set @data=substring(@data,0,1844)+convert(varbinary(4),0)+substring(@data,1848,3932)
664.    update [user] set [data]=@data where account=@account
665.   end

复制代码