summaryrefslogtreecommitdiff
path: root/npc/003-3
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2018-12-17 14:19:54 -0200
committerJesusaves <cpntb1@ymail.com>2018-12-17 14:19:54 -0200
commit28792a943938e2154514e8e5117a461e485a243d (patch)
tree572d39f971c38acbfa0cffe993914e1d89d723ea /npc/003-3
parent9e0741ad32ec71fb66a04f90d3d2818972bd45ee (diff)
downloadserverdata-28792a943938e2154514e8e5117a461e485a243d.tar.gz
serverdata-28792a943938e2154514e8e5117a461e485a243d.tar.bz2
serverdata-28792a943938e2154514e8e5117a461e485a243d.tar.xz
serverdata-28792a943938e2154514e8e5117a461e485a243d.zip
Fix bugs, and special weapons for DragonStar and others
Diffstat (limited to 'npc/003-3')
-rw-r--r--npc/003-3/malindou.txt21
1 files changed, 21 insertions, 0 deletions
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 "";
+ }