請問如何解決帳戶不穩的問題?

[深情校長]

引用ffffff大大所說:
帐号问题数据库添加一个主键就可以了。 分数更新直接写一个脚本放在自动任务里就行！

請問要添加什麼主键??

現在我只要登出 在登入 就會出現 帳號或密碼錯誤..
還請大大指點..

[dodoegg]

问题出在battles2这个数据库里的MyLogoutGame的存储过程
他需要调用另外一个存储过程

[深情校長]

作者: dodoegg

问题出在battles2这个数据库里的MyLogoutGame的存储过程
他需要调用另外一个存储过程

在battles2这个这个数据库里的MyLogoutGame的存储过程
我调用另外兩个存储过程
1.MyLogoutGameOld <----可以登出登入兩次 帳戶就會出現不穩

2.MyLogoutGameVeryOld <---- 登出後就會不穩

請問大大哪邊還需要修改呢??

[dodoegg]

修改MyLogoutGame的存储过程倒数第2行
exec SERVERXXX.billing.dbo.MyLogoutFromGameNew @userid

XXX是多少我忘记了,把SERVERXXX删掉,变成
exec .billing.dbo.MyLogoutFromGameNew @userid就可以了,记得前面有个点

[深情校長]

dodoegg 大大 非常感謝你

已經順利解決 帳號無法順利登入的問題了

好在有您的協助 小弟才可以解決這問題

至於無法升級的問題 是否您也知道呢?

[dodoegg]

提高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]

[深情校長]

謝謝您 ^^
您真的幫助我很多...

非常感謝...

[dodoegg]

不客气,还有问题的话可以去我的博客看看,
http://j.99081.com/dodoegg

[hyq1979]

作者: dodoegg

不客气,还有问题的话可以去我的博客看看,
http://j.99081.com/dodoegg

博客地址失效了，晕！

[hyq1979]

大大不错，真的解决了帐户登陆不稳定的问题。不过还有两个小问题：
loginserver.exe运行后最后几行是什么意思
fatal error - realperocess :115
co.memmanger free memory block :99

[Puzzle]

SEE SEE

[glaucus]

刚找了端重温 也遇到类似问题..进来学习一下

[x567]

重溫一下就夢吧最近才搞懂一些架服法