Help with Dual Client Blocker

[guihleao 0]

Hello guys! So, i got this script from rAthena and I need to do a few modifications that I've tried, but no success.

 

This is the original script:

-	script	dualclientkicker	-1,{OnPCLoadMapEvent:	set .@charmap$, strcharinfo(3);	if(!compare(.tmp$,.@charmap$)) end;	set .@len, query_sql("select account_id from `char` right join login on login.account_id = `char`.account_id where `char`.online = 1 and login.last_ip = '"+ getcharip() +"'",.@a ); //Annieruru Addition.	if(.@len-1) {		for(set(.@d,0);.@d<.@len;set(.@d,.@d+1)) {			getmapxy(.@map$,.@x,.@y,0,rid2name(.@a[.@d]));			if(.@charmap$==.@map$&&rid2name(.@a[.@d])!=strcharinfo(0)) {				dispbottom "Dual Client não disponível nesse mapa.";				warp "vilasyn",91,54;			}		}	}	end;	OnInit:	setarray   .maps$  ,	"aldeg_cas01", "gefg_cas01", "payg_cas01", "prtg_cas01", "guild_vs3";	set        .lens   ,	getarraysize(.maps$)                                   ;	for(set(.a,0);.a<.lens;set(.a,.a+1)) {		setmapflag .maps$[.a],	mf_loadevent ;		set .tmp$  ,.tmp$+.maps$[.a]+",";	}}

I'd like to make it look after the last_mac field instead of the last_ip field. And also, I have a separated login database, I tried this:

 

query_sql("select account_id from DB1.`char` right join DB2.login on login.account_id = `char`.account_id where `char`.online = 1 and login.last_ip = '"+ getcharip() +"'",.@a );

But no success.

 

Could anyone help me in these two situations?

 

Thanks in advance!

[maqc1 8]

Uh, there is no such thing as "last_mac" in Hercules (if I am not mistaken)... I think the server has no way to fetch the user's MAC adress.