From 2925600b4bc2441a5eb49fdb765ba82011dca751 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Tue, 15 Jan 2019 02:18:37 -0200 Subject: 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!! --- npc/003-3/malindou.txt | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'npc/003-3') 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 ""; + } -- cgit v1.2.3-60-g2f50