Need help!

[RockStar]

Hi

since rodex and mail box is not wrking this script auto event is using mail function.

i need help on someone that can help me fix this script about item prize sending?

at the moment it use query_sql("INSERT INTO `mail` (send_name,dest_id,title,message,nameid,amount,identify,zeny,time) VALUES

i want this script send direct to account when the winner is annouce..

Quote

}

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'");
}

 

[Cyro]

Replace qurysql with getitem, setzeny

 

getitem  @RewardID, @RewardQNT;

set Zeny,Zeny+@RewardZeny