Freebies NPC Points via last_mac

[MikZ 5]

Good day Herc. scripters,

 

wanted to know, if does this script read last_mac or last_ip?

I only changed last_ip to last_mac, does that work? what else do i need to change?

Please help. thanks!

poring_w01,100,123,6	script	SoloPack Points	TW_TOWER,{

set .@n$, "[Seyra]";
query_sql ("SELECT `last_mac` FROM `login` WHERE `account_id`=" + getcharid(3) + "", .@lip$);
if ( getd("$" + .@lip$ + "_NG") > 0 || #NewbieGift > 0)
{
mes .@n$;
mes "I'm sorry, the rewards are exclusively for new players.";
close;
}

mes .@n$;
mes "Welcome! "+strcharinfo(0)+"";
mes "Here are your points to trade in SOLO PACK SHOP"; 
close2;
set #NewbieGift, 1;
setd "$" + .@lip$ + "_NG", getd("$" + .@lip$ + "_NG") + 1;
#FREEBIESSET += 1;
#FREEBIESWING += 1;
#FREEBIESJARD += 2;
end;

OnInit:
waitingroom "Solo Pack Points!",0;
end;

}

Edited October 24, 2016 by MikZ

[MikZ 5]

Anyone?

[MikZ 5]

this is solved. ty!