How to send Monthly Reward to players

now I have this script CREATE TABLE `poring` ( `char_id` INT PRIMARY KEY, `name` VARCHAR(24), `kills` INT, KEY(`kills`) ) ENGINE = InnoDB; prontera,155,185,5 script Poring Rank 1_F_MARIA,{ .@nb = query_sql("SELECT `name`, RANK() OVER(ORDER BY `kills` DESC), `kills` FROM `poring` ORDER BY `kills` DESC LIMIT 5", .@name$, .@rank, .@kills); if (!.@nb) mes "no ranking yet"; for ( .@i = 0; .@i < .@nb; ++.@i ) mes "No."+ .@rank[.@i] +" ["+ .@name$[.@i] +"] ~ "+ .@kills[.@i] +" kills"; next; if (query_sql("SELECT RANK() OVER(ORDER BY `kills` DESC), `kills` FROM `poring` WHERE `char_id` = "+ getcharid(CHAR_ID_CHAR), .@rank, .@kills)) { mes "Your kills -> "+ .@kills; mes "Your Rank -> No."+ .@rank; } else mes "You haven't kill a poring"; close; OnNPCKillEvent: if (killedrid == PORING) query_sql "INSERT INTO `poring` VALUES ("+ getcharid(CHAR_ID_CHAR) +", '"+ escape_sql(strcharinfo(PC_NAME)) +"', 1) ON DUPLICATE KEY UPDATE `name` = '"+ escape_sql(strcharinfo(PC_NAME)) +"', `kills` = `kills` +1"; end; } I want to send the monthly reward to players by mail, here's my take on how to tackle this problem prontera,155,185,5 script Poring Rank 1_F_MARIA,{ .@nb = query_sql("SELECT `name`, RANK() OVER(ORDER BY `kills` DESC), `kills` FROM `poring` ORDER BY `kills` DESC LIMIT 5", .@name$, .@rank, .@kills); if (!.@nb) mes "no ranking yet"; for ( .@i = 0; .@i < .@nb; ++.@i ) mes "No."+ .@rank[.@i] +" ["+ .@name$[.@i] +"] ~ "+ .@kills[.@i] +" kills"; next; if (query_sql("SELECT RANK() OVER(ORDER BY `kills` DESC), `kills` FROM `poring` WHERE `char_id` = "+ getcharid(CHAR_ID_CHAR), .@rank, .@kills)) { mes "Your kills -> "+ .@kills; mes "Your Rank -> No."+ .@rank; } else mes "You haven't kill a poring"; close; OnNPCKillEvent: if (killedrid == PORING) query_sql "INSERT INTO `poring` VALUES ("+ getcharid(CHAR_ID_CHAR) +", '"+ escape_sql(strcharinfo(PC_NAME)) +"', 1) ON DUPLICATE KEY UPDATE `name` = '"+ escape_sql(strcharinfo(PC_NAME)) +"', `kills` = `kills` +1"; end; OnInit: if (!$poringkill_last_given) { $poringkill_last_given = atoi(gettime(GETTIME_YEAR) +""+ gettime(GETTIME_MONTH)); end; } else if ($poringkill_last_given != atoi(gettime(GETTIME_YEAR) +""+ gettime(GETTIME_MONTH))) goto L_GiveMonthlyReward; end; OnClock0000: if (gettime(GETTIME_DAYOFMONTH) != 1) end; L_GiveMonthlyReward: $poringkill_last_given = atoi(gettime(GETTIME_YEAR) +""+ gettime(GETTIME_MONTH)); .@nb = query_sql("SELECT `char_id` FROM `poring` ORDER BY `kills` DESC LIMIT 5", .@cid); if (!.@nb) end; for (.@i = 0; .@i < .@nb; ++.@i) rodex_sendmail .@cid[.@i], "[Poring Rank]", "Poring Rank Monthly Reward", "Thanks for killing porings ~ You are Rank No."+(.@i +1)+" on the ladder. Please accept this reward.", 0, Jellopy, 1; query_sql "TRUNCATE `poring`"; end; }
yup, basically I just added a few more line down there

now break it into 3 parts

1. when the server first load the script, it will execute OnInit: and store the $poringkill_last_given variable
   it will store the value as '202010', 2020 is the year, and 10 is the current month
2.  then on 12:00am, it will execute OnClock0000: label,
   with the if (gettime(GETTIME_DAYOFMONTH) != 1) end; to halt the script if it isn't the day 1 of the month
   since it is a new month, '202011' is different from '202010' and thus execute the condition below
3. The second condition of OnInit: label is to make sure it will run L_GiveMonthlyReward: label IF the server isn't online during 12:00am of day 1 of the month.
   It will compare to the $poringkill_last_given variable every time, if it is different month, then it will execute the statement below
   it has to bypass the if (gettime(GETTIME_DAYOFMONTH) != 1) end; so even if the server somehow didn't even online on day 1 of the month, it will still giving out monthly reward for previous month

External Link:
Monthly MVP Rank

See Also:
How to send Weekly Rewards to players