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 );
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:
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:
But no success.
Could anyone help me in these two situations?
Thanks in advance!
Share this post
Link to post
Share on other sites