From 28792a943938e2154514e8e5117a461e485a243d Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Mon, 17 Dec 2018 14:19:54 -0200 Subject: Fix bugs, and special weapons for DragonStar and others --- npc/003-3/malindou.txt | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'npc') diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index 5f6695d59..4a67e13b2 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -162,6 +162,27 @@ OnInit: debugmes "* Replaced Wooden Swords with Bug Slayer"; debugmes ""; } + // Current UPDATE value: Sab Dez 17 13:52:54 -02 2018 + // Fix a critical bug because Nard's ship doors logic was changed. Upgrade premium weapons in rare weapons + if ($UPDATE < 1545061974) { + query_sql("UPDATE `quest` SET `count1` = '3' WHERE `quest`.`quest_id`='0' AND `quest`.`count1` = '2' AND `quest`.`char_id` IN (SELECT `quest`.`char_id` WHERE `quest`.`quest_id` = '12' AND `quest`.`count1`>='1')"); + + query_sql("UPDATE `inventory` SET `nameid` = '"+LEGACY_MiereCleaver+"' WHERE `inventory`.`nameid`='"+MiereCleaver+"'"); + query_sql("UPDATE `storage` SET `nameid` = '"+LEGACY_MiereCleaver+"' WHERE `storage`.`nameid`='"+MiereCleaver+"'"); + query_sql("UPDATE `cart_inventory` SET `nameid` = '"+LEGACY_MiereCleaver+"' WHERE `cart_inventory`.`nameid`='"+MiereCleaver+"'"); + query_sql("UPDATE `guild_storage` SET `nameid` = '"+LEGACY_MiereCleaver+"' WHERE `guild_storage`.`nameid`='"+MiereCleaver+"'"); + + query_sql("UPDATE `inventory` SET `nameid` = '"+LEGACY_Broadsword+"' WHERE `inventory`.`nameid`='"+Broadsword+"'"); + query_sql("UPDATE `storage` SET `nameid` = '"+LEGACY_Broadsword+"' WHERE `storage`.`nameid`='"+Broadsword+"'"); + query_sql("UPDATE `cart_inventory` SET `nameid` = '"+LEGACY_Broadsword+"' WHERE `cart_inventory`.`nameid`='"+Broadsword+"'"); + query_sql("UPDATE `guild_storage` SET `nameid` = '"+LEGACY_Broadsword+"' WHERE `guild_storage`.`nameid`='"+Broadsword+"'"); + + $UPDATE=1545061974; + debugmes ""; + debugmes "* Replaced Miere Cleaver and Broad Sword with a special version specific for old players"; + debugmes "* Fix critical bug with Nard (not needed on Main Server)"; + debugmes ""; + } -- cgit v1.2.3-60-g2f50