summaryrefslogtreecommitdiff
path: root/npc/003-3
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2019-05-30 15:46:44 -0300
committerJesusaves <cpntb1@ymail.com>2019-05-30 15:46:44 -0300
commit890700b108fd4f1ea0b748b6a4eb0b49d85c90ab (patch)
treee41ad6100887aba2acd4a3a7bc304b3ef5390a6b /npc/003-3
parentddb4c03f64d652f941174c22715d56a25ed51e2f (diff)
downloadserverdata-890700b108fd4f1ea0b748b6a4eb0b49d85c90ab.tar.gz
serverdata-890700b108fd4f1ea0b748b6a4eb0b49d85c90ab.tar.bz2
serverdata-890700b108fd4f1ea0b748b6a4eb0b49d85c90ab.tar.xz
serverdata-890700b108fd4f1ea0b748b6a4eb0b49d85c90ab.zip
Several fixes and now NPCs have their own craft system.
So NPCs craft now may give bonuses too - existing craft bonuses maintaned.
Diffstat (limited to 'npc/003-3')
-rw-r--r--npc/003-3/malindou.txt33
1 files changed, 33 insertions, 0 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt
index 0942e7765..5e574978e 100644
--- a/npc/003-3/malindou.txt
+++ b/npc/003-3/malindou.txt
@@ -352,6 +352,39 @@ OnInit:
query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val3` SMALLINT(5) NOT NULL DEFAULT '0';");
query_sql("ALTER TABLE picklog MODIFY COLUMN `opt_val4` SMALLINT(5) NOT NULL DEFAULT '0';");
+ // Replace all BugSlayer, ShortGladius, RealBronzeGladius and Backsword
+ // With a version containing the critical damage option (bCritAtkRate)
+ // auction table have no faulty items, nor do carts nor do I care w/ rodex
+ // by the time this query was writen
+ // IOPT_CRITDMG id is 199
+ query_sql("UPDATE `inventory` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+BugSlayer);
+ query_sql("UPDATE `storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+BugSlayer);
+ query_sql("UPDATE `guild_storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+BugSlayer);
+
+ query_sql("UPDATE `inventory` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+ShortGladius);
+ query_sql("UPDATE `storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+ShortGladius);
+ query_sql("UPDATE `guild_storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+ShortGladius);
+
+ query_sql("UPDATE `inventory` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+RealBronzeGladius);
+ query_sql("UPDATE `storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+RealBronzeGladius);
+ query_sql("UPDATE `guild_storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+RealBronzeGladius);
+
+ query_sql("UPDATE `inventory` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+Backsword);
+ query_sql("UPDATE `storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+Backsword);
+ query_sql("UPDATE `guild_storage` SET `opt_idx0` = '199', `opt_val0` = '30'"+
+ " WHERE `nameid`="+Backsword);
+
$UPDATE=1558965422;
debugmes "";
debugmes "* picklog options Update";