diff options
Diffstat (limited to 'npc/003-1/ched.txt')
| -rw-r--r-- | npc/003-1/ched.txt | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/npc/003-1/ched.txt b/npc/003-1/ched.txt index df51cd581..7e89a7b13 100644 --- a/npc/003-1/ched.txt +++ b/npc/003-1/ched.txt @@ -11,7 +11,7 @@ return countitem(CactusCocktail)+countitem(CherryCocktail)+countitem(AppleCocktail); } function ScoreSSC { - .@nb = query_sql("SELECT c.name, i.count2 FROM `quest` AS i, `char` AS c WHERE i.quest_id=305 AND i.char_id=c.char_id ORDER BY i.count2 DESC LIMIT 10", .@name$, .@value); + .@nb = query_sql("SELECT c.name, i.count2 FROM `quest` AS i, `char` AS c WHERE i.quest_id=305 AND i.char_id=c.char_id AND i.count1="+(gettime(GETTIME_YEAR)-2000)+" ORDER BY i.count2 DESC LIMIT 10", .@name$, .@value); mes "##B"+l("Top 10 - Summer Ched's Event")+"##b"; mes("1."+.@name$[0]+" ("+.@value[0]+")"); |