diff options
| author | Jesusaves <cpntb1@ymail.com> | 2020-04-26 12:48:08 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2020-04-26 12:48:08 -0300 |
| commit | 844cd70f74252426a4b07f854e6ae4eb197a19d3 (patch) | |
| tree | e1cfacc730f2df893d9e7b11f74609c241fb334f | |
| parent | f92b9e29336a9cad703f694468865d2d25b72336 (diff) | |
| download | serverdata-844cd70f74252426a4b07f854e6ae4eb197a19d3.tar.gz serverdata-844cd70f74252426a4b07f854e6ae4eb197a19d3.tar.bz2 serverdata-844cd70f74252426a4b07f854e6ae4eb197a19d3.tar.xz serverdata-844cd70f74252426a4b07f854e6ae4eb197a19d3.zip | |
Some more code to avoid accidentaly messing up with Groata inventory.
Better to destroy too less than destroy too much
| -rw-r--r-- | npc/003-3/malindou.txt | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index a6f29ae0a..0acbfc18a 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -551,12 +551,12 @@ OnInit: // Language over simplification if ($UPDATE < 1587915715) { $UPDATE=1587915715; - query_sql("UPDATE `inventory` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx0`='189' OR `opt_idx0`='200') AND (`opt_idx1`='189' OR `opt_idx1`='200')"); - query_sql("UPDATE `cart_inventory` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx0`='189' OR `opt_idx0`='200') AND (`opt_idx1`='189' OR `opt_idx1`='200')"); - query_sql("UPDATE `storage` SET `opt_val0` = '15', `opt_val1` = '5' WHERE (`opt_idx0`='189' OR `opt_idx0`='200') AND (`opt_idx1`='189' OR `opt_idx1`='200')"); - 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')"); - 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')"); - 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')"); + query_sql("UPDATE `inventory` 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 `cart_inventory` 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 `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 `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')"); debugmes ""; debugmes "* Tolchi mess cleanup"; debugmes ""; |