Block Dual Mac Adress in Same Map

[brunoshp]

i use Internalguard and this guard  capture UniqueID i need to block dual account in same Map.

if have 1 account map not enter other in same Map.

 

In table Ragnarok guard put infomations about account in tables.

 

xxxxx_ragnarok

 Jogadoresid

 id , UniqueID , IP , Date , time

 

 

create table jogadoresid (

id int(10) unsigned not null auto_increment,

UniqueID varchar(255) not null,

IP varchar(255) not null,

Data date not null,

Hora time not null,

primary key (id));

 

[brunoshp]

im basied in Skorm script.

this

getuid(strcharinfo(0)) 

 get UniqueID Of Player

 

 

set .@len, query_sql("select account_id from `char` right join login on login.account_id = `char`.account_id where `char`.online = 1 and (select UniqueID from `jogadoresid` where `UniqueID` = '"+getuid(strcharinfo(0))+"')" );

this to.

 

query_sql("SELECT DISTINCT `account_id` FROM `char` WHERE `account_id` IN (SELECT `account_id` FROM `login` WHERE `last_ip` = (SELECT `IP` FROM `jogadoresid` WHERE `UniqueID`="+getuid(strcharinfo(0))+")) AND `last_map` = '"+strnpcinfo(4)+"' AND `online` <> 0;",.a);

 

 but not ok! pls help me

Edited December 30, 2013 by brunoshp