yeah did it, still couldnot be loaded=.="
heres's my script
izlude,128,213,3 script Anniversary Coins 123,{
query_sql "select `last_ip`, `newbie` from `login` where `last_ip` in (SELECT `last_ip` FROM `login` WHERE `account_id`=" + getcharid(3) +") having `newbie` = max(`newbie`) limit 1", .@last_ip$, .@tmp;
if ( .@tmp ) {
mes "I'm sorry, the rewards are exclusively for new players.";
close;
}
mes "Welcome! Here are some free gifts";
mes "for newcomers:";
for ( set .@i, 0; .@i < getarraysize(.reward); set .@i, .@i + 2 )
mes .reward[.@i+1] + " x " + getitemname(.reward[.@i]);
close2;
for ( set .@i, 0; .@i < getarraysize(.reward); set .@i, .@i + 2 )
getitem .reward[.@i], .reward[.@i+1];
query_sql "update `login` set `newbie` = 1 WHERE `last_ip`= '" + .@last_ip$ + "'";
end;
OnInit:
setarray .reward, 18158,100; // Rewards: <item id>,<item amount>
set .size, getarraysize( .reward );
}