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
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