以下将每次登陆的玩家作IP位址记录在案,时时更新的储存过程
ALTER PROCEDURE [dbo].[PROC_INSERT_CURRENTUSER]
@AccountID varchar(50),
@CharID varchar(50),
@ServerNo int,
@ServerIP varchar(50),
@ClientIP varchar(50),
@nret smallint output
AS
INSERT INTO CURRENTUSER ( nServerNo, strServerIP, strAccountID, strCharID, strClientIP ) Values (@ServerNo, @ServerIP, @AccountID, @CharID, @ClientIP )
set @nret=1
update tb_user set IP = @clientip where straccountid = @accountid
~~~~~~~~~~~~~~~~~~~~~~~~~~``
将注意到的黑名玩家IP写在if@ip='在此加IP'~~~~~在他再次登陆时将马上掉线后自动以255限制登陆.
declare @ip varchar(50)
select @ip = IP from tb_user where straccountid = @accountid
if @ip ='200.121.195.45'
begin
update userdata set authority = 255 where struserid = @id
end
~~~~~~~~~~~~~~~~~~~~~
我们的问题是:
1,还没能限制第三方交易来防复制
2.神庙不能刷怪
3.人箭塔不灵活(奇怪在人物也无发对箭塔作出攻击伤害)
4.传送门未完正汉化
5.GM不能刷物品... |
