Jump to content
  • 0

NPC that gives item if your acc is 1 month old


Question

Posted

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.

6 answers to this question

Recommended Posts

Posted

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.

Posted

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;
	}
}

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...