diff options
| author | Jesusaves <cpntb1@ymail.com> | 2024-02-19 11:45:30 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2024-02-19 11:45:30 -0300 |
| commit | da2580afdbde821bae55de506b12568650d472fb (patch) | |
| tree | 16099e65b8edb5ad3196da6ef30996ea94f420bd | |
| parent | 3ef43a71a8df86fc056875bf52b303bfbcc61360 (diff) | |
| download | serverdata-da2580afdbde821bae55de506b12568650d472fb.tar.gz serverdata-da2580afdbde821bae55de506b12568650d472fb.tar.bz2 serverdata-da2580afdbde821bae55de506b12568650d472fb.tar.xz serverdata-da2580afdbde821bae55de506b12568650d472fb.zip | |
Flush picklog in asynchronous way whenever possible (anti-freeze)
| -rw-r--r-- | npc/003-3/malindou.txt | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index f3035f40c..2115bd3f8 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -1035,7 +1035,13 @@ OnInit: OnClock0500: if (gettime(GETTIME_DAYOFMONTH) >= 7) query_sql("DELETE FROM `chatlog` WHERE `time` < '"+sqldate(-7)+"'"); - query_sql("DELETE FROM `picklog` WHERE `time` < '"+sqldate(0, -1)+"'"); + // Flush picklog + if ($@HAS_API) { + query_sql("DELETE FROM `picklog` WHERE `time` < '"+sqldate(0, -1)+"'"); + } else { + apiasync("SQL", "DELETE FROM `picklog` WHERE `time` < '"+sqldate(0, -1)+"'"); + apiasync("SQLRUN", ""); + } // TODO: Have crontab make monthly .gz backup? // Remove overhead from picklog if (gettime(GETTIME_DAYOFMONTH) == 14) |