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~