diff options
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"; |