Help - Pharmacy's menu showing duplicate item requirements

[RynFTW]

I've been crawling through code for hours trying to figure out where this is coming from.
This is ONLY occurring with Elementproof Potions, all other Pharmacy recipes display just fine.

I've looked at produce_db, item_db, skill_db, skill.c, clif.c, msgstringtable, everywhere I could think to look.
While I've certainly learned a lot about how skill menus work, I still haven't found where the menu pulls the required materials from.
From what I can tell, the produce_db just checks if the player has the required amount of items to succeed or fail in the creation. My produce_db does not duplicate materials.
This doesn't impact the creation process at all, it'll still check/delete the correct amount of materials when successfully crafting an Elementproof Potion, but my little OCD gremlin can't rest while this list duplication exists.

Does anyone know exactly how this menu list is generated, and how to edit it?

Also, apologies if this is in the wrong section. It's my first post, and this potentially touches multiple areas.

SOLVED: Found in data/metalprocessitemlist.txt 332 ~ 367

Edited August 20, 2023 by RynFTW

[Rynbef]

Check if the ProduceID isn't duplicated like in db/import or on sql.

 

Other Idea is to replace ur Lua files. Maybe there is a issue.

 

Rynbef~

[RynFTW]

Oh good thinking, I can't believe I didn't search for individual ProduceIDs. I was just obsessively scanning through everything else~

A grep for 12118 returned:

rathena/db/pre-re/item_db_etc.yml:      bonus2 bAddMonsterDropItem,12118,50;
rathena/db/pre-re/item_db_usable.yml:  - Id: 12118
rathena/db/pre-re/item_db_usable.yml:      getitem 12118,1;
rathena/db/pre-re/produce_db.txt:133,12118,22,228,1,7434,0,1012,2,716,1,1093,1
rathena/db/pre-re/quest_db.yml:  - Id: 12118
rathena/db/re/item_db_etc.yml:      bonus2 bAddMonsterDropItem,12118,50;
rathena/db/re/item_db_etc.yml:  - Id: 312118
rathena/db/re/item_db_usable.yml:  - Id: 12118
rathena/db/re/item_db_usable.yml:      getitem 12118,1;
rathena/db/re/item_db_usable.yml:      getitem 12118,3;
rathena/db/re/produce_db.txt:133,12118,22,228,1,7434,0,1012,2,716,1,1093,1

Along with some quests and merchants that are obviously unrelated. So no duplication server-side.
Must be client-side. Double checked all the LUA files, they're clean and good, but that led me to revisiting the data/*.txt files.
I went through every single file line by line and found this *DA NA NA NAAA*:

data/metalprocessitemlist.txt 332 ~ 367

12118#
2 Frills
1 Red Gemstone
#
12119#
3 Hearts of Mermaid
1 Blue Gemstone
#
12120#
2 Large Jellopies
1 Yellow Gemstone
#
12121#
3 Moth Dust
1 Blue Gemstone
#
12118#
2 Frills
1 Red Gemstone
1 Empty Potion Bottle
#
12119#
3 Hearts of Mermaid
1 Blue Gemstone
1 Empty Potion Bottle
#
12120#
2 Large Jellopies
1 Yellow Gemstone
1 Empty Potion Bottle
#
12121#
3 Powders of Butterfly
1 Blue Gemstone
1 Empty Potion Bottle
#

There it is! The source of the duplication. Tucked away in a file named something completely unrelated to potions or pharmacy.
Really handy to locate this, as I believe it's also the reason why Novice Crafting/Combination Kit isn't properly linked up, the recipes are missing in this file.
Also opens the door for customizing Pharmacy and other production skill/item recipes.

Thank you, fellow Ryn, for guiding me down the right path towards a solution, much appreciate~