DELETE FROM INVENTORYTABLE WHERE (IT_DELETE = 1)
4.满160转的改为5转,100转的改为3转,50转的改为1转就行了
SET zsnum = 5555 WHERE (zsnum >= 160)
UPDATE CHARTABLE SET zsnum = 3333 WHERE (zsnum >= 100) AND (zsnum < 160)
UPDATE CHARTABLE SET zsnum = 1111 WHERE (zsnum >= 50) AND (zsnum < 100)
UPDATE CHARTABLE SET zsnum = 0 WHERE (zsnum < 50)
6.760 和 630 的会员装备 都改成4区的顶级装备属性.
=====================================================================
1 攻击力 300 set @op = 1 ;set @opval = 300
2 命中 600
3 致命率 150
4 致命伤害提高 150
5 命中几率 150
6 魔法攻击力 300
7 防御力 300
8 闪躲 1500
9 格挡概率 300
10 魔法防御力 300
11 力量 300
12 敏捷 300
13 智慧 300
14 信仰 300
15 火系抗性 300
16 冰系抗性 300
17 电系抗性 300
18 状态抗性 300
19 体力最大增加 600
20 魔力最大增加 600
21 火系抗性下降 240
22 冰系抗性下降 240
23 电系抗性下降 240
24 状态抗性下降 240
25 火系伤害 150
26 冰系伤害 150
27 电系伤害 150
28 所有技能上升 1
29 生命吸收 150
30 魔力吸收 150
31 中毒率 150
32 燃烧率 150
33 伤口恶化 150
34 眩晕 150
35 迟缓 150
40 击退率 150
============================================================
declare @op int
declare @opval int
--set @op = 1 ;set @opval = 300
--set @op = 2 ;set @opval = 600
--set @op = 3 ;set @opval = 150
--set @op = 4 ;set @opval = 150
--set @op = 5 ;set @opval = 150
--set @op = 6 ;set @opval = 300
--set @op = 7 ;set @opval = 300
--set @op = 8 ;set @opval = 1500
--set @op = 9 ;set @opval = 300
--set @op = 10 ;set @opval = 300
--set @op = 11 ;set @opval = 300
--set @op = 12 ;set @opval = 300
--set @op = 13 ;set @opval = 300
--set @op = 14 ;set @opval = 300
--set @op = 15 ;set @opval = 300
--set @op = 16 ;set @opval = 300
--set @op = 17 ;set @opval = 300
--set @op = 18 ;set @opval = 300
--set @op = 19 ;set @opval = 600
--set @op = 20 ;set @opval = 600
--set @op = 21 ;set @opval = 240
--set @op = 22 ;set @opval = 240
--set @op = 23 ;set @opval = 240
--set @op = 24 ;set @opval = 240
--set @op = 25 ;set @opval = 150
--set @op = 26 ;set @opval = 150
--set @op = 27 ;set @opval = 150
--set @op = 28 ;set @opval = 1
--set @op = 29 ;set @opval = 150
--set @op = 30 ;set @opval = 150
--set @op = 31 ;set @opval = 150
--set @op = 32 ;set @opval = 150
--set @op = 33 ;set @opval = 150
--set @op = 34 ;set @opval = 150
--set @op = 35 ;set @opval = 150
set @op = 40 ;set @opval = 150
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE1 = @opval
WHERE (IT_OPTIONID1 = @op) AND (IT_OPTIONVALUE1 >@opval)
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE2 = @opval
WHERE (IT_OPTIONID2 = @op) AND (IT_OPTIONVALUE2 >@opval)
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE3 = @opval
WHERE (IT_OPTIONID3 = @op) AND (IT_OPTIONVALUE3 >@opval)
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE4 = @opval
WHERE (IT_OPTIONID4 = @op) AND (IT_OPTIONVALUE4 >@opval)
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE5 = @opval
WHERE (IT_OPTIONID5 = @op) AND (IT_OPTIONVALUE5 >@opval)
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE6 = @opval
WHERE (IT_OPTIONID6 = @op) AND (IT_OPTIONVALUE6 >@opval)
UPDATE INVENTORYTABLE
SET IT_OPTIONVALUE7 = @opval
WHERE (IT_OPTIONID7 = @op) AND (IT_OPTIONVALUE7 >@opval)