Change Birthday Script?

[Vince Jimenez]

Hello Guys,

I just want to know if someone have or make me this Script???

i need script to change their players Birthday ???

i know i need to goto database to change it but is there any script that no need to goto database to change their Birthday ? 

Once player change here birthday using npc its automatically change to data base.. ??

Thanks in Adv.
 

UP!!

Edited April 9, 2014 by nesty09

[Capuche]

prontera,150,150,5 script sdfghjhgfd 56,{

query_sql "select birthdate from login where account_id = "+ getcharid(3), .@birthdate$;

mes "you know what? i'm a mind reader";

mes "I know you are a "+ ( Sex ? " handsome man" : " beautiful lady" ) +" born in ^ff0000"+ .@birthdate$ +"^000000.";

mes "Your underwear color is.. what? ok i stop it";

next;

if ( select( "Change my birthdate", "Bye" ) == 2 ) close;

mes "Really? well tell me your new birthdate - format 0000-00-00 thanks";

input .@string$;

next;

explode( .@tmp$, .@string$, "-" );

if( getarraysize( .@tmp$ ) != 3 ||

getstrlen(.@tmp$[0]) != 4 || atoi(.@tmp$[0]) < 1 ||

getstrlen(.@tmp$[1]) != 2 || atoi(.@tmp$[1]) < 1 ||

getstrlen(.@tmp$[2]) != 2 || atoi(.@tmp$[2]) < 1 ) {

mes "wrong format bye";

close;

}

query_sql "update login set birthdate = '"+ escape_sql( .@string$ ) +"' where account_id = "+ getcharid(3);

mes "done";

close;

}

[Vince Jimenez]

i need it asap HUHUH ! HELP!

[Vince Jimenez]

prontera,150,150,5	script	sdfghjhgfd	56,{
	query_sql "select birthdate from login where account_id = "+ getcharid(3), .@birthdate$;
	mes "you know what? i'm a mind reader";
	mes "I know you are a "+ ( Sex ? " handsome man" : " beautiful lady" ) +" born in ^ff0000"+ .@birthdate$ +"^000000.";
	mes "Your underwear color is.. what? ok i stop it";
	next;
	if ( select( "Change my birthdate", "Bye" ) == 2 ) close;
	mes "Really? well tell me your new birthdate - format 0000-00-00 thanks";
	input .@string$;
	next;

	explode( .@tmp$, .@string$, "-" );
	if( getarraysize( .@tmp$ ) != 3 ||
		getstrlen(.@tmp$[0]) != 4 || atoi(.@tmp$[0]) < 1 ||
		getstrlen(.@tmp$[1]) != 2 || atoi(.@tmp$[1]) < 1 ||
		getstrlen(.@tmp$[2]) != 2 || atoi(.@tmp$[2]) < 1 ) {
		
		mes "wrong format bye";
		close;
	}
	query_sql "update login set birthdate = '"+ escape_sql( .@string$ ) +"' where account_id = "+ getcharid(3);
	mes "done";
	close;
}

hi sir thanks for your fast reply..

i need 1 more request... once the player Click the NPC its automatically default to 0000-00-00 >???

Please ? thanks !

once player click Birthday Defaulter its automatically 0000-00-00 to database also ??

[Capuche]

By default birthday value is 0000-00-00 in login table

I don't get it. You want a menu "default value" ?

[Vince Jimenez]

i mean if player click the npc its automatically the birthday change to 0000-00-00 ?
And npc say" Dispbottom : Your character change birthday to 0000-00-00 Thanks"

yes a default value

[Capuche]

Run in mysql

update login set birthdate = '0000-00-00'