提高rank的解决方法,由于都是私服架设,游戏人数不会太多,所以我改成了达到一定积分就升级,而不是按原来的百分比计算,所以修改前请自行备份相关的存储过程代码. 在查询分析器中执行一下代码解决:
[HIDE]
use battles2
go
alter PROCEDURE _rankngrade AS
update users set users.rank = aa.rank
from users, (select b.userid userid,
b.userpoint userpoint,
(select count(*)+1
from users a
where a.userpoint > b.userpoint) rank
from users b ) aa
where users.userid = aa.userid
update users set userchorac = 540 where rank <> 0 and userpoint between 1284303 and 2140452
update users set userchorac = 510 where rank <> 0 and userpoint between 679083 and 1284303
update users set userchorac = 480 where rank <> 0 and userpoint between 389514 and 679083
update users set userchorac = 450 where rank <> 0 and userpoint between 238326 and 389513
update users set userchorac = 420 where rank <> 0 and userpoint between 148886 and 238325
update users set userchorac = 390 where rank <> 0 and userpoint between 98083 and 148885
update users set userchorac = 360 where rank <> 0 and userpoint between 69217 and 98084
update users set userchorac = 330 where rank <> 0 and userpoint between 48884 and 69216
update users set userchorac = 300 where rank <> 0 and userpoint between 35977 and 48883
update users set userchorac = 270 where rank <> 0 and userpoint between 26533 and 35976
update users set userchorac = 240 where rank <> 0 and userpoint between 19106 and 26532
update users set userchorac = 210 where rank <> 0 and userpoint between 13935 and 19105
update users set userchorac = 180 where rank <> 0 and userpoint between 10441 and 13934
update users set userchorac = 150 where rank <> 0 and userpoint between 8068 and 10440
update users set userchorac = 120 where rank <> 0 and userpoint between 6339 and 8067
update users set userchorac = 90 where rank <> 0 and userpoint between 5001 and 6338
GO
[/HIDE]