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([email protected]$, @bdate$, "-");
		set [email protected]$, gettimestr("%m%d",21);
		if([email protected]$ == ([email protected]$[1]+""[email protected]$[2]))
		{
			getitem 7227,1;
			set #last_bdyear,gettimestr("%Y",21);
			set @byear, [email protected]$[0];
			set [email protected]$, (sex) ? "his":"her";
			announce "Hey everyone, "+strcharinfo(0)+" celebrates "[email protected]$+" "+(#[email protected])+" 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)+ "'", [email protected], [email protected];
        if ( ( gettime(6) == [email protected] ) && ( gettime(5) == [email protected] ) )
            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