NPC that gives item if your acc is 1 month old

[Pink Guy]

Okay, Can someone please make an npc that gives you an item if your account is 1 month old? Also, you can only get 1 per account. Sample getitem -> 909,1

Thanks for whoever will help me.

[Patskie]

http://rathena.org/board/topic/83835-request-script-that-give-item-monthly-or-daily/?p=205098

[Pink Guy]

Not this one. But Thanks for replying. I'm trying to find the one that gives you an item IF YOUR ACCOUNT IS 1 MONTH OLD so those who haven't been playing for that long, won't be able to receive the item.

[Patskie]

Ahh sorry haha me slow mind

[Skorm]

If you're running flux it could be done from the cp_createlog.

[Capuche]

or try

prontera,155,150,5	script	iuniono	89,{

	if ( #reward_on_one_month ) {
		mes "you already get your reward";
		close;
	}
	query_sql "SELECT `userid` FROM `login` WHERE `account_id`="+ getcharid(3), .@userid$;
	query_logsql "select datediff( curdate(),`time`) from `loginlog` where `user`='"+ escape_sql( .@userid$ ) +"' order by `time` asc limit 1", .@tmp;
	if ( .@tmp > 30 ) {	// more than 1 month = reward
		#reward_on_one_month = 1;
		getitem 501,1;

		mes "1 month is not too long isn't it?";
		close;
	}
	else {
		mes "keep going!";
		mes "^0000ff*I have been here for "+ .@tmp +" day"+ ( .@tmp > 1 ? "s" : "" ) +" now.*";
		close;
	}
}

[Pink Guy]

Thank you for all the replies. I shall test this script you made, Capuche. Also, is there a guide for it, Skorm?