Requesting NPC Birthday

[Checkmate]

Hi.. rAthena Community...
Is there anyone here or someone can create for me some script or mybe sql... that can detect player birthday or the time of registration date.. TO give them some present of thier birthday?..?

Btw... Is there have any coincidence?..?

Thanks All  ^ ^ 

[Sanasol]

 

 

-	script	birthday	-1,{
	
	OnPCLoginEvent:
	if(#last_bdyear != gettime(7))
	{
		set @nb, query_sql("select birthdate from `login` where `account_id`='"+getcharid(3)+"'", @bdate$);
		explode(.@bdate$, @bdate$, "-");
		set .@curdate$, gettimestr("%m%d",21);
		if(.@curdate$ == (.@bdate$[1]+""+.@bdate$[2]))
		{
			getitem 7227,1;
			set #last_bdyear,gettimestr("%Y",21);
			set @byear, .@bdate$[0];
			set .@sexword$, (sex) ? "his":"her";
			announce "Hey everyone, "+strcharinfo(0)+" celebrates "+.@sexword$+" "+(#last_bdyear-@byear)+" birthday!",bc_blue|bc_all;
		}
	}
	
	end;
	
}

[Patskie]

Didn't try so test this :

-    script    Sample    -1,{
    OnPCLoginEvent:
        query_sql "SELECT `DATE_FORMAT(birthdate, '%m')`, `DATE_FORMAT(birthdate, '%d')` FROM `login` WHERE `account_id` = '" +getcharid(3)+ "'", .@month, .@day;
        if ( ( gettime(6) == .@month ) && ( gettime(5) == .@day ) )
            getitem 502, 10;
        dispbottom "Happy Birthday " +strcharinfo(0)+ "!";
        end;
}

[chowking]

getitem 7227,1;

 

suggest to use account bound items to prevent new account birthday exploit

[Sanasol]

 

getitem 7227,1;

 

suggest to use account bound items to prevent new account birthday exploit

 

ofc Need check for IP(or something else) or account bound

[chowking]

anyway great script thanks