diff options
| author | Jesusaves <cpntb1@ymail.com> | 2021-02-24 20:58:13 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2021-02-24 20:58:13 -0300 |
| commit | 15d0535c8e3102ffdc710ab426d0c6b49a9b3864 (patch) | |
| tree | ad16b03e1e0286cd03fc3ee5d407ad56c045365c | |
| parent | 8909eb9b54f38e6b9b8e456245b57854e04bc33e (diff) | |
| download | serverdata-15d0535c8e3102ffdc710ab426d0c6b49a9b3864.tar.gz serverdata-15d0535c8e3102ffdc710ab426d0c6b49a9b3864.tar.bz2 serverdata-15d0535c8e3102ffdc710ab426d0c6b49a9b3864.tar.xz serverdata-15d0535c8e3102ffdc710ab426d0c6b49a9b3864.zip | |
...Oops.
| -rw-r--r-- | npc/functions/scoreboards.txt | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 4488b0dd2..dece70f10 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -18,7 +18,7 @@ function script ScoreboardsReload { .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='HONOR' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@hof_name$, $@hof_value); .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='ACADEMIC_RANK' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 30", $@hoa_name$, $@hoa_value); .@nb = query_sql("SELECT c.name, i.value FROM `mapreg` AS i, `char` AS c WHERE i.varname='$REFERRAL_IDS' AND i.index=c.account_id ORDER BY i.value DESC LIMIT 20", $@hor_name$, $@hor_value); - .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='PC_DIE_COUNTER' AND i.char_id=c.char_id AND c.last_login >= "+gettimetick(2)-86400+" ORDER BY i.value ASC LIMIT 10", $@hod_name$, $@hod_value); + .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='PC_DIE_COUNTER' AND i.char_id=c.char_id AND c.last_login >= "+(gettimetick(2)-86400)+" ORDER BY i.value ASC LIMIT 10", $@hod_name$, $@hod_value); // Seasonal Scoreboards if (season() == SUMMER || season() == AUTUMN) { |