summaryrefslogtreecommitdiff
path: root/npc/003-3
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2020-04-28 21:15:23 -0300
committerJesusaves <cpntb1@ymail.com>2020-04-28 21:15:23 -0300
commit0a1da134b49b32801bcdd0dfb82edf695e7d3823 (patch)
treed1a264a7705d36654e0d495f2c36dbd32a05f522 /npc/003-3
parente6b64e6b77f437cb58e0b5fe9def6313d38ab7e0 (diff)
downloadserverdata-0a1da134b49b32801bcdd0dfb82edf695e7d3823.tar.gz
serverdata-0a1da134b49b32801bcdd0dfb82edf695e7d3823.tar.bz2
serverdata-0a1da134b49b32801bcdd0dfb82edf695e7d3823.tar.xz
serverdata-0a1da134b49b32801bcdd0dfb82edf695e7d3823.zip
Be more solid
Diffstat (limited to 'npc/003-3')
-rw-r--r--npc/003-3/malindou.txt5
1 files changed, 5 insertions, 0 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt
index 0acbfc18a..df0279419 100644
--- a/npc/003-3/malindou.txt
+++ b/npc/003-3/malindou.txt
@@ -557,6 +557,11 @@ OnInit:
query_sql("UPDATE `guild_storage` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx0`='189' OR `opt_idx0`='200') AND (`opt_idx1`='189' OR `opt_idx1`='200') AND (`opt_val0` > '15' AND `opt_val1` > '15')");
query_sql("UPDATE `rodex_items` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx0`='189' OR `opt_idx0`='200') AND (`opt_idx1`='189' OR `opt_idx1`='200') AND (`opt_val0` > '15' AND `opt_val1` > '15')");
query_sql("UPDATE `auction` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx0`='189' OR `opt_idx0`='200') AND (`opt_idx1`='189' OR `opt_idx1`='200') AND (`opt_val0` > '15' AND `opt_val1` > '15')");
+
+ query_sql("UPDATE `inventory` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx1`=`opt_idx2`) AND (`opt_val0` > '15' AND `opt_val1` > '15')");
+ query_sql("UPDATE `storage` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx1`=`opt_idx2`) AND (`opt_val0` > '15' AND `opt_val1` > '15')");
+ query_sql("UPDATE `guild_storage` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx1`=`opt_idx2`) AND (`opt_val0` > '15' AND `opt_val1` > '15')");
+ query_sql("UPDATE `rodex_items` SET `opt_val0` = '15', `opt_val1` = '10' WHERE (`opt_idx1`=`opt_idx2`) AND (`opt_val0` > '15' AND `opt_val1` > '15')");
debugmes "";
debugmes "* Tolchi mess cleanup";
debugmes "";