(SQL-QUERY)Find Multibotters

[royalblade]

This query basically checks all the online people and you can check the usernames charnames guildnames goldamount and online time... which is usually veery similiar for goldbotters/multibotters... its for servers that dont allow multibotting ... however i havent including any IP shit in it.. feel free to do so if u need it.. however ppl can use proxies etc too easily...

BAN the multibotters

PHP Code:

SELECT        _User.UserJID AS JID,_Guild.Name AS GuildName, _AccountJID.AccountID AS 
              Username, _Char.CharName16 AS Charname, 
             ((_AccountJID.Gold + _Char.RemainGold)) AS MillGold, _Char.NickName16 AS JobName,
             SRO_VT_LOG.dbo._OnlineOffline.Status AS CStatus, SRO_VT_LOG.dbo._OnlineOffline.mOnline AS OnlineTime 
FROM         _GuildMember with (nolock) INNER JOIN
             SRO_VT_LOG.dbo._OnlineOffline ON SRO_VT_LOG.dbo._OnlineOffline.CharID = _GuildMember.CharID INNER JOIN
             _Char ON _GuildMember.CharID = _Char.CharID INNER JOIN
             _Guild ON _GuildMember.GuildID = _Guild.ID LEFT OUTER JOIN
             _User ON _Char.CharID = _User.CharID RIGHT OUTER JOIN
             _AccountJID ON _User.UserJID = _AccountJID.JID    
WHERE     (_Char.CharName16 IS NOT NULL AND SRO_VT_LOG.dbo._OnlineOffline.mOnline IS NOT NULL )
ORDER BY Username,GuildName