Jump to content

Small Fix for Read (etc_drop_item.txt)


Recommended Posts

  • Forum Moderator

M2 Download Center

This is the hidden content, please
( Internal )

This is the hidden content, please
( 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.

68747470733a2f2f692e6779617a6f2e636f6d2f39616463653961663637373166343966366162353162393166353035613539372e706e67

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
epository:

This is the hidden content, please

Edited by Metin2 Dev
Core X - External 2 Internal
  • Metin2 Dev 50
  • Smile Tear 1
  • Think 2
  • Good 22
  • Love 6
  • Love 40
Link to comment
Share on other sites

  • 4 months later...
  • Forum Moderator

Moved to git.

  • Metin2 Dev 17
  • Not Good 1
  • Good 2
  • Love 3
  • Love 5
Link to comment
Share on other sites

  • 9 months later...
  • 2 weeks later...

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.