Jump to content

[ERR] etc_drop_item.txt


Recommended Posts

Hi , i have this error and i don't understand why :|

 

My etc_drop_item :

Èò»ö ´ó±â+ 2.0

i have this syserr :

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

i know what it say , in fact in my db there is the name Èò»ö ´ó±â+ :

30073 Èò»ö ´ó±â+ Banderola alba+ 5 0 0 1 0 4 0 300 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 -1 -1 -1 -1 -1 0 0 0

sorry for my bad english >.<

Link to comment
Share on other sites

  • 4 years later...
  • Forum Moderator

If you want to do it like @Alphax Wolf, you can do 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 > 0);
# Affected rows: 83
# Time: 35.919ms

And if you want to see what monsters are using etc_drop_item, there's a ex select query.

SELECT DISTINCT drop_item FROM player.mob_proto where drop_item > 0;

Btw, i would change the structure of reading the file instead of doing this, here's a hint.

 

  • Love 3
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

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.