Daily Raffle Reward help

[LordJasz]

Hello rAthenees.
could someone help me creating a NPC that makes a Raffle Everyday?

This is the very beggining of the script with the main idea.

	query_sql("select `value` from acc_reg_num where `key` = '#evento' order by `value` desc limit 1",.@winner);

	mes "Hello! Do you want to entry or receive your reward?";
	next;
	menu "Yes",SIM,"No",NAO,"Reward",Recompensa; 
	SIM: if(#evento<1){
		set #evento, rand(1,10000);
		mes "Done. Your Number is "+#evento+".";
		mes "Good Luck!";
		}
		else{
		mes "You're already participating. Your number is "+#evento+".";
		mes "Good Luck!";
		}
		close;
		end;
	NAO: mes "Okay! ^^";
		close;
		end;
	Recompensa:
		if (#winner = 1){
		mes "C O N G R A T U L A T I O N S!"
		getitem 607, 10;
		set #winner,0;
		}
		else{
		mes "Sorry, you're not the winner.";
		mes "Good luck next time!";
        }
		close;
		end;
OnClock1915:
	set #winner,1; // how can i set the winner here where #evento == .@winner?
	query_sql("UPDATE `acc_reg_num` SET `value` = '0' WHERE `key` ='#evento'");

Im stuck on how im gonna make it reset every day to make a new winner.
someone could shine my mind?
Thx

Edited August 14, 2018 by LordJasz

[skymia]

On 8/14/2018 at 10:44 AM, LordJasz said:

Hello rAthenees.
could someone help me creating a NPC that makes a Raffle Everyday?

This is the very beggining of the script with the main idea.

	query_sql("select `value` from acc_reg_num where `key` = '#evento' order by `value` desc limit 1",.@winner);

	mes "Hello! Do you want to entry or receive your reward?";
	next;
	menu "Yes",SIM,"No",NAO,"Reward",Recompensa; 
	SIM: if(#evento<1){
		set #evento, rand(1,10000);
		mes "Done. Your Number is "+#evento+".";
		mes "Good Luck!";
		}
		else{
		mes "You're already participating. Your number is "+#evento+".";
		mes "Good Luck!";
		}
		close;
		end;
	NAO: mes "Okay! ^^";
		close;
		end;
	Recompensa:
		if (#winner = 1){
		mes "C O N G R A T U L A T I O N S!"
		getitem 607, 10;
		set #winner,0;
		}
		else{
		mes "Sorry, you're not the winner.";
		mes "Good luck next time!";
        }
		close;
		end;
OnClock1915:
	set #winner,1; // how can i set the winner here where #evento == .@winner?
	query_sql("UPDATE `acc_reg_num` SET `value` = '0' WHERE `key` ='#evento'");

Im stuck on how im gonna make it reset every day to make a new winner.
someone could shine my mind?
Thx

did you already fix this?