Forum Moderator VegaS™ 10275 Posted May 22, 2019 Forum Moderator Share Posted May 22, 2019 (edited) M2 Download Center This is the hidden content, please Sign In or Sign Up ( Internal ) This is the hidden content, please Sign In or Sign Up ( GitHub ) What's the issue? SYSERR: Aug 22 18:36:42.624296 :: ReadEtcDropItemFile: No such an item (name: Èò»ö ´ó±â+) SYSERR: Aug 22 18:36:42.624379 :: Boot: cannot load ETCDropItem: locale/germany/etc_drop_item.txt Some people fixed it long time ago by replacing the column name from item_proto (which is korean) with vnum. If you want to do it like this and don't want the source change (from below) or you don't have the source code of your game core, you can use a update query and copy the vnum to name just if the vnum from item_proto exists inside of mob_proto.drop_item by a specific mob. UPDATE player.item_proto SET name = vnum WHERE vnum IN (SELECT drop_item FROM player.mob_proto WHERE drop_item >= 10); # Affected rows: 83 # Time: 35.919ms How can i know where the items are dropped? So, the structure of etc_drop_item.txt is based on dropping a item with a probability from a specific mob where that mob have the item vnum attached in column mob_drop -> drop_item. SELECT DISTINCT locale_name, vnum, drop_item FROM player.mob_proto where drop_item >= 10; locale_name vnum drop_item Wolf 102 30028 Alpha Wolf 103 30069 Alpha Blue Wolf 105 30027 Grey Wolf 106 30070 How-To-Fix Default structure: item_proto.name prob 늑대발톱 2.0 늑대발톱+ 2.0 늑대털 2.0 멧돼지의 어금니 2.0 With the fix you can use both of methods: item_proto.[name or vnum] prob 30028 2.0 30069 2.0 30027 2.0 멧돼지의 어금니 2.0 This is the hidden content, please Sign In or Sign Up epository: This is the hidden content, please Sign In or Sign Up Edited September 6, 2022 by Metin2 Dev Core X - External 2 Internal 54 1 2 23 6 43 Check my GitHub Profile Click to find all the threads started by me [TOOL] Text file loader + JSON Link to comment Share on other sites More sharing options...
Forum Moderator VegaS™ 10275 Posted October 1, 2019 Author Forum Moderator Share Posted October 1, 2019 Moved to git. This is the hidden content, please Sign In or Sign Up 18 1 3 3 5 Check my GitHub Profile Click to find all the threads started by me [TOOL] Text file loader + JSON Link to comment Share on other sites More sharing options...
danhakhavro 42 Posted July 31, 2020 Share Posted July 31, 2020 (edited) Hi, the query is running endlessly. Edited August 26, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Finnael 481 Posted August 11, 2020 Share Posted August 11, 2020 (edited) It doesn't run endlessly, it just takes some time. Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Recommended Posts