Another tidbit about special upgrades... The game is actually kind of dumb and most weapons that get special upgraded are actually a different item. Like a standard Battle Sword is item id 4024, but if you put blue stones into it it becomes item type 140301, which is a Battle Sword with blue upgrades.
This is how they have it set up so that stoned weapons get S or R on the end of the name, it's actually a different item with a different translation entry. Some newer weapons still do it (Savage Fire Wand is 67216, changes to 143028 with blue stones in it), they just didn't bother adding R or S to the end of names with newer ones...
^it's a really dumb an exploitable way to go about it.
For a long time people were able to use certain tools that must not be named and all they had to do was force "drop" the item being special upgraded and they end up with before and after versions of the item.
There are also newer items that don't do that (Merlin Knuckles come to mind).
Alright so it's been a while and I've learned more about Mabi's data structures so here's some more clarified info.
Goibne Stone does... Idunno'. It's defined but has no interactions.Goibne Stone: A mysterious stone that contains the power of Goibne. You can use it to draw hidden power from your equipment, but overusing it may damage your item.
Conversion Stone: Changes the nature of specially upgraded equipment. Equipment that was upgraded with either a Red or Blue Upgrade Stone switches to the upgrade type of the opposite color.
Conversion Stone should work, somebody needs to convince Nexon to release it.
There's 1xx, 2xx, and 3xx types of special upgrades.
1xx are for the old system, 2xx are current blues, 3xx are current reds.
201 is 1-hander blue damage, 301 is 1-hander red crit.
202 is axe blue damage, 302 is axe red crit.
203 is 2-hander blue damage, 303 is 2-hander red crit.
204 is magic blue damage, 304 is wind cylinder frozen blast.
205 is fire cylinder fire damage
206 is water cylinder water damage
207 is earth cylinder barrier spike HP
208 is wind cylinder frozen blast duration
201-208 exist and are accounted for.
301-304 exist and are accounted for.
So the only special upgrade stat boost types that exist but aren't accounted for are ones in the 1xx family, none of which appear to be assigned to any type of item (probably because if they were, we'd be able to use them). These are the ones for the original design when they were planning on splitting combat into classes/styles/whatever.
ID 101 calls for stat boosts that don't exist.
ID 102 is for 1-handed swords and calls for the following stat boosts.
ID 103 is for 1-handed daggers and calls for the following stat boosts.
ID 104 is for ranged weapons, max damage values of 10,20,30,45,60,75,90,110,130,150.
ID 105 is fire cylinders, fire damage values of 5,10,15,20,30,40,50,60,80,100.
ID 106 is earth cylinders, earth "damage?" bonuses of 5,10,15,20,30,40,50,60,80,100 with Barrier Spike HP bonuses of 10,20,40,60,90,120,160,200,250,300.
ID 107 is wind cylinders, damage bonus of 5,10,15,20,30,40,50,60,80,100, frozen blast duration bonus (in milliseconds) of 500,1000,1500,2000,2500,3000,3500,4000,5000,6000, angle bonus of 1,2,4,6,8,10,13,16,21,25.
ID 108 is water cylinders, damage bonus of 5,10,15,20,30,40,50,60,80,100.
ID 109 is wands, critical plus 1,1,2,2,3,4,5,6,7,8, dura plus 1,1,2,2,3,4,5,6,7,8, magic damage plus 5,10,15,20,30,40,50,60,70,80 (but almost all magic bonuses were x4'd in a later update so these would be too), MP usage -5,-10,-15,-20,-25,-30,-35,-40,-45,-50 (likely percent).
ID 110 is staves, critical bonuses of 1,2,3,4,5,6,7,8,9,10, dura bonuses of 1,1,2,2,3,3,4,4,5,5, magic damage bonuses of 5,10,20,30.40,55,70,85,100,120 (holy crap imagine those translated to MA), MP usage -4,-8,-12,-16,-20,-24,-28,-32,-36,-40 (again likely percents).
Yes I got lazy with the ranged stats and tabling things, typing is effort, etc.