Help with Dual Client Blocker

[Guih]

Hello guys! So, i got this script from here 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!

[Emistry]

login.last_ip

change to

login.last_mac

default i believe should be `last_mac` unless your SQL table column name is different, then change accordingly.

getcharip()

change to

getcharmac()   // if you have the relevant script command to get MAC.

otherwise you might need some workaround to get the MAC address.

Ex

SELECT `last_mac` FROM `login` WHERE `account_id` = "+getcharid(3)

[Guih]

Thanks for answering Emistry, I changed the script as you suggested:

-	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_mac = '"+ getcharmac() +"'",.@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]+",";
	}
}

But now I got this error:

parse_callfunc: expected ')' to close argument list

On this line and function: 

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_mac = '"+ getcharmac() +"'",.@a ); //Annieruru Addition.

getcharmac()

So i guess I'll have to use the other method you told me about, but how can I insert it into this NPC? Thanks.