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?
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?
Share this post
Link to post
Share on other sites