LOAD_USER_DATA存储中加入此段代码,即可自动1,2转- UPDATE USERDATA SET Class = Class + 4 WHERE strUserId = @id AND Level > 10 AND Class IN(101, 201)
- UPDATE USERDATA SET Class = Class + 5 WHERE strUserId = @id AND Level > 10 AND Class IN(102, 202)
- UPDATE USERDATA SET Class = Class + 6 WHERE strUserId = @id AND Level > 10 AND Class IN(103, 203)
- UPDATE USERDATA SET Class = Class + 7 WHERE strUserId = @id AND Level > 10 AND Class IN(104, 204)
- UPDATE USERDATA SET Class = Class + 1 WHERE strUserId = @id AND Level > 59 AND Class IN(105, 107, 109, 111, 205, 207, 209, 211)
复制代码 |