diff options
| -rw-r--r-- | db/re/item_db.conf | 56 | ||||
| -rw-r--r-- | npc/003-3/malindou.txt | 18 | ||||
| -rw-r--r-- | npc/functions/util.txt | 15 |
3 files changed, 61 insertions, 28 deletions
diff --git a/db/re/item_db.conf b/db/re/item_db.conf index 3e603e8a4..113d218c0 100644 --- a/db/re/item_db.conf +++ b/db/re/item_db.conf @@ -10507,18 +10507,18 @@ item_db: ( }, { Id: 6000 - AegisName: "WoodenBow" - Name: "Wooden Bow" + AegisName: "TrainingBow" + Name: "Training Bow" Type: "IT_WEAPON" - Buy: 2000 - Sell: 400 - Weight: 260 - Atk: 70 + Buy: 550 + Sell: 52 + Weight: 160 + Atk: 20 Range: 5 MinRange: 1 Loc: ["EQP_HAND_R", "EQP_HAND_L"] WeaponLv: 1 - EquipLv: 15 + EquipLv: 5 Subtype: "W_BOW" AllowAmmo: { Id6500: 1 @@ -10533,18 +10533,18 @@ item_db: ( }, { Id: 6001 - AegisName: "TrainingBow" - Name: "Training Bow" + AegisName: "WoodenBow" + Name: "Wooden Bow" Type: "IT_WEAPON" - Buy: 550 - Sell: 52 - Weight: 160 - Atk: 20 + Buy: 2000 + Sell: 400 + Weight: 260 + Atk: 70 Range: 5 MinRange: 1 Loc: ["EQP_HAND_R", "EQP_HAND_L"] WeaponLv: 1 - EquipLv: 5 + EquipLv: 15 Subtype: "W_BOW" AllowAmmo: { Id6500: 1 @@ -10610,18 +10610,18 @@ item_db: ( }, { Id: 6004 - AegisName: "ChampionshipBow" - Name: "Championship Bow" + AegisName: "DesertBow" + Name: "Desert Bow" Type: "IT_WEAPON" - Buy: 9620 - Sell: 2020 - Weight: 520 - Atk: 180 + Buy: 8550 + Sell: 1800 + Weight: 400 + Atk: 160 Range: 6 MinRange: 1 Loc: ["EQP_HAND_R", "EQP_HAND_L"] WeaponLv: 1 - EquipLv: 80 + EquipLv: 60 Subtype: "W_BOW" AllowAmmo: { Id6500: 1 @@ -10636,18 +10636,18 @@ item_db: ( }, { Id: 6005 - AegisName: "DesertBow" - Name: "Desert Bow" + AegisName: "ChampionshipBow" + Name: "Championship Bow" Type: "IT_WEAPON" - Buy: 8550 - Sell: 1800 - Weight: 400 - Atk: 160 + Buy: 9620 + Sell: 2020 + Weight: 520 + Atk: 180 Range: 6 MinRange: 1 Loc: ["EQP_HAND_R", "EQP_HAND_L"] WeaponLv: 1 - EquipLv: 60 + EquipLv: 80 Subtype: "W_BOW" AllowAmmo: { Id6500: 1 diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index 3655d3eaa..1a1d64f7a 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -183,6 +183,24 @@ OnInit: debugmes "* Fix critical bug with Nard (not needed on Main Server)"; debugmes ""; } + // Current UPDATE value: Qua Dez 26 21:45:10 -02 2018 + // Update players position + if ($UPDATE < 1545867910) { + ReplaceItemFromEveryPlayer(6000, 9990); + ReplaceItemFromEveryPlayer(6001, 9991); + ReplaceItemFromEveryPlayer(6004, 9994); + ReplaceItemFromEveryPlayer(6005, 9995); + + ReplaceItemFromEveryPlayer(9990, 6001); + ReplaceItemFromEveryPlayer(9991, 6000); + ReplaceItemFromEveryPlayer(9994, 6005); + ReplaceItemFromEveryPlayer(9995, 6004); + + $UPDATE=1545867910; + debugmes ""; + debugmes "* Update Bows IDs"; + debugmes ""; + } diff --git a/npc/functions/util.txt b/npc/functions/util.txt index 589a73262..99ba16bfc 100644 --- a/npc/functions/util.txt +++ b/npc/functions/util.txt @@ -44,6 +44,21 @@ function script DelQuestFromEveryPlayer { return; } +// Transforms an item in something else. +// ReplaceItemFromEveryPlayer( OldID, NewID ) +function script ReplaceItemFromEveryPlayer { + if (getarg(0, -1) < 0) + return; + debugmes("* Server update: %d item was replaced by %d"); + query_sql("UPDATE `inventory` SET `nameid`='"+getarg(1)+"' WHERE `nameid`="+getarg(0)); + query_sql("UPDATE `cart_inventory` SET `nameid`='"+getarg(1)+"' WHERE `nameid`="+getarg(0)); + query_sql("UPDATE `storage` SET `nameid`='"+getarg(1)+"' WHERE `nameid`="+getarg(0)); + query_sql("UPDATE `guild_storage` SET `nameid`='"+getarg(1)+"' WHERE `nameid`="+getarg(0)); + query_sql("UPDATE `rodex_items` SET `nameid`='"+getarg(1)+"' WHERE `nameid`="+getarg(0)); + query_sql("UPDATE `auction` SET `nameid`='"+getarg(1)+"' WHERE `nameid`="+getarg(0)); + return; +} + ///////////////////////////////////////////////////////////////////////////////// // Returns Nard reputation for discounts |