diff options
| author | Jesusaves <cpntb1@ymail.com> | 2019-01-15 02:18:37 -0200 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2019-01-15 02:18:37 -0200 |
| commit | 2925600b4bc2441a5eb49fdb765ba82011dca751 (patch) | |
| tree | b866ebde83ea8af5d602bb19f7f85e1c7f13db4b /npc/003-3/malindou.txt | |
| parent | d87b39b4013f77d0d553c9495b6ee1b21b64cff3 (diff) | |
| download | serverdata-2925600b4bc2441a5eb49fdb765ba82011dca751.tar.gz serverdata-2925600b4bc2441a5eb49fdb765ba82011dca751.tar.bz2 serverdata-2925600b4bc2441a5eb49fdb765ba82011dca751.tar.xz serverdata-2925600b4bc2441a5eb49fdb765ba82011dca751.zip | |
Reset thief/merchant ranks back to 1, and any extra experience is now reset to 30.
Everyone will enjoy the minigame at least 1 or 2 times more.
BETA!!
Diffstat (limited to 'npc/003-3/malindou.txt')
| -rw-r--r-- | npc/003-3/malindou.txt | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index 678bc675d..00aeaad11 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -229,6 +229,33 @@ OnInit: debugmes "* Update Quiver IDs"; debugmes ""; } + // Current UPDATE value: Ter Jan 15 02:07:40 -02 2019 + // Reset all thief/merc ranks back to 1. + // If + if ($UPDATE < 1547525260) { + + // Already rank 2? Give enough exp to get rank 2 easily. + query_sql("UPDATE `char_reg_num_db` SET `value` = '30' WHERE `char_reg_num_db`.`key`='THIEF_EXP' AND `char_reg_num_db`.`char_id` IN (SELECT `char_reg_num_db`.`char_id` WHERE `char_reg_num_db`.`key` = 'THIEF_RANK' AND `char_reg_num_db`.`value`>='2')"); + // Didn't wanted to rank up? Reset exp to 30! + query_sql("UPDATE `char_reg_num_db` SET `value` = '30' WHERE `char_reg_num_db`.`key`='THIEF_EXP' AND `char_reg_num_db`.`value` >= '32' AND `char_reg_num_db`.`char_id` IN (SELECT `char_reg_num_db`.`char_id` WHERE `char_reg_num_db`.`key` = 'THIEF_RANK' AND `char_reg_num_db`.`value`<='1')"); + // Already rank 2? Return to rank 1. + query_sql("UPDATE `char_reg_num_db` SET `value` = '1' WHERE `char_reg_num_db`.`key`='THIEF_RANK' AND `char_reg_num_db`.`value` >= '2'"); + + // The same thing, now for merchants + + // Already rank 2? Give enough exp to get rank 2 easily. + query_sql("UPDATE `char_reg_num_db` SET `value` = '30' WHERE `char_reg_num_db`.`key`='MERC_EXP' AND `char_reg_num_db`.`char_id` IN (SELECT `char_reg_num_db`.`char_id` WHERE `char_reg_num_db`.`key` = 'MERC_RANK' AND `char_reg_num_db`.`value`>='2')"); + // Didn't wanted to rank up? Reset exp to 30! + query_sql("UPDATE `char_reg_num_db` SET `value` = '30' WHERE `char_reg_num_db`.`key`='MERC_EXP' AND `char_reg_num_db`.`value` >= '32' AND `char_reg_num_db`.`char_id` IN (SELECT `char_reg_num_db`.`char_id` WHERE `char_reg_num_db`.`key` = 'MERC_RANK' AND `char_reg_num_db`.`value`<='1')"); + // Already rank 2? Return to rank 1. + query_sql("UPDATE `char_reg_num_db` SET `value` = '1' WHERE `char_reg_num_db`.`key`='MERC_RANK' AND `char_reg_num_db`.`value` >= '2'"); + + $UPDATE=1547525260; + debugmes ""; + debugmes "* Merc/Thief ranks reset to 1"; + debugmes "Improving past rank 2 helps on minigame"; + debugmes ""; + } |