Daily reward giver check for ip

[Kido]

Hello, how can i make this daily reward check ip ?

//==================== Informacion ==========================
//==== Recompensa Diaria==========================
//*************************************************************************
//=========================== Conf ==================================================================================
set .@rewname$,"^0000FF[ Premio Diario ]^000000";
setarray .items[0],507,506,508,509,510; //items
//********************************************************************************************************************
prontera,150,206,4	script	Prize	563,50,50,{
if(gettimetick(2) - lastTimeTalked > (60 * 60 * 24)) {
mes .@rewname$;
mes "Wanna get your daily reward?";
next;
switch(select("-Yush!:-No,thx!:-Cancel")) {
	case 1:
        set lastTimeTalked,gettimetick(2);
	mes .@rewname$;
	mes "Allright!";
	mes .@rewname$;
	set .@random,rand(1,25);
	getitem .items[.@random],1;
	close;
	case 2:
	mes .@rewname$;
	mes "Okay bye!";
	close;
	case 3:
	close;
	}
	}
	mes .@rewname$;
	mes "Sry "+strcharinfo(0)+", you already got this";
	mes "Wait 24 hours!!";
	close;
}

[Capuche]

//==================== Informacion ==========================

//==== Recompensa Diaria==========================

//*************************************************************************

//=========================== Conf ==================================================================================

//********************************************************************************************************************

prontera,150,206,4 script Prize 563,{

set .@rewname$,"^0000FF[ Premio Diario ]^000000";

setarray .items[0],507,506,508,509,510; //items

.@tick = gettimetick(2);

if(.@tick - lastTimeTalked > (60 * 60 * 24)) {

query_sql "select 1 from login join `char` on `char`.account_id = login.account_id join global_reg_value as g on g.char_id = `char`.char_id where last_ip = '"+ getcharip() +"' "+

"and g.`str` = 'lastTimeTalked' and value > ("+ .@tick +" - 86400)", .@tmp;

if ( .@tmp == 0 ) {

mes .@rewname$;

mes "Wanna get your daily reward?";

next;

switch(select("-Yush!:-No,thx!:-Cancel")) {

case 1:

set lastTimeTalked,gettimetick(2);

mes .@rewname$;

mes "Allright!";

getitem .items[ rand( getarraysize(.items) ) ], rand( 1,25 );

close;

case 2:

mes .@rewname$;

mes "Okay bye!";

close;

case 3:

close;

}

}

}

mes .@rewname$;

mes "Sry "+strcharinfo(0)+", you already got this";

mes "Wait 24 hours!!";

close;

}

[Kido]

Thank you >!