Jump to content

  •  

Diurnal

Member Since 03 Feb 2013
Offline Last Active Jan 26 2017 12:57 PM
-----

Topics I've Started

Function Problem - mail to getitem conversion

06 December 2016 - 05:52 AM

Hello,

 

I have disabled mail system on my server and found a an automated events script that uses mail system to give the prizes.

function Func_Prizes {
	announce "Congrats "+strcharinfo(0,getarg(0))+", a winner in the "+getarg(1)+" Event.",bc_all|bc_blue;
	query_sql("INSERT INTO `mail` (send_name,dest_id,title,message,nameid,amount,identify,zeny,time) VALUES ("+
		"'no-reply',"+getarg(0)+",'** "+getarg(1)+" **',"+
		"'Congratulations!% You have won % in the "+getarg(1)+" Event% % % % % % % %   [ Your reward is attached. ]',"+
		$@RewardID+","+$@RewardQNT+",1,"+$@RewardZeny+",UNIX_TIMESTAMP(NOW()))");
	announce "Rewards hava been sent via mail.",bc_self|bc_blue;
	query_sql("UPDATE `mail` SET message = REPLACE(message,'%',CHAR(13)) WHERE send_name = 'no-reply'");
}

Can anyone please help me convert this into getitem script command?