Jump to content
For maintenance and updates, the community will be offline on 31 December 2022 ×
  • 0

[ERR] etc_drop_item.txt


astinasti

Question

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

2 answers to this question

Recommended Posts

  • 0
  • 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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • 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.