diff options
| author | Jesusaves <cpntb1@ymail.com> | 2019-02-09 18:28:53 -0200 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2019-02-09 18:28:53 -0200 |
| commit | 935fbebe66b6007c86dd519458b27d74c7e74ade (patch) | |
| tree | f58782b0318020f36b9e09929139c68f13d89054 /npc/001-11/Demure.txt | |
| parent | b9137c42cc19ba00609778869dd9a3e81b152783 (diff) | |
| download | serverdata-935fbebe66b6007c86dd519458b27d74c7e74ade.tar.gz serverdata-935fbebe66b6007c86dd519458b27d74c7e74ade.tar.bz2 serverdata-935fbebe66b6007c86dd519458b27d74c7e74ade.tar.xz serverdata-935fbebe66b6007c86dd519458b27d74c7e74ade.zip | |
Allow @toevent to reach Valentine Highlands
Diffstat (limited to 'npc/001-11/Demure.txt')
| -rw-r--r-- | npc/001-11/Demure.txt | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/npc/001-11/Demure.txt b/npc/001-11/Demure.txt index 5cad9f2fb..462fa74e7 100644 --- a/npc/001-11/Demure.txt +++ b/npc/001-11/Demure.txt @@ -9,7 +9,7 @@ // Functions function ScoreValentine { - .@nb = query_sql("SELECT c.name, i.value FROM `acc_reg_num_db` AS i, `char` AS c WHERE i.key='#VALENTINE_POINTS' AND i.account_id=c.account_id ORDER BY i.value DESC LIMIT 10", .@name$, .@value); + .@nb = query_sql("SELECT c.name, i.value FROM `acc_reg_num_db` AS i, `char` AS c WHERE i.key='#VALENTINE_POINTS' AND i.account_id=c.account_id AND c.char_num='0' ORDER BY i.value DESC LIMIT 10", .@name$, .@value); mes "##B"+l("Top 10 - Valentine Day")+"##b"; mes("1." +.@name$[0]+" ("+.@value[0]+")"); @@ -175,6 +175,7 @@ L_Main: next; mes l("As with all TMW2 Major Events, the top 1 receive a special pet, and the other ranked ones get diverse rewards."); mes l("There might be reward for anyone who doesn't gets a rank, but I never count on that. So, let's start?"); + mesc l("Note: You must have a char on the first slot to leaderboard work. Points are shared accross all chars on your account."), 1; next; break; case 2: |