diff options
| author | Jesusaves <cpntb1@ymail.com> | 2019-05-30 15:46:44 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2019-05-30 15:46:44 -0300 |
| commit | 890700b108fd4f1ea0b748b6a4eb0b49d85c90ab (patch) | |
| tree | e41ad6100887aba2acd4a3a7bc304b3ef5390a6b /npc/003-3 | |
| parent | ddb4c03f64d652f941174c22715d56a25ed51e2f (diff) | |
| download | serverdata-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.txt | 33 |
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"; |