name changes and sony item numbers

[mewkus]

I'm not sure what the easiest method for conveying these changes, but below is text that can be cut/paste into a .csv file that lists items whose names have been changed by SOE. If you prefer the data in an alternate form, lemme know and I'll see what I can do. (I've also some of the sony item numbers for the new tradeskill stuff that hasn't made its way onto eqitems or lucy yet).

"old name", "item number", "new name"
"Elaborate Stargazer Cuirass", 18572, "Elaborate Stargazer Robe"
"Elaborate Stargazer Greaves", 18576, "Elaborate Stargazer Breeches"
"Elaborate Stargazer Helm", 18575, "Elaborate Stargazer Cap"
"Elegant Metalfiber Breeches", 28863, "Elegant Metalofiber Breeches"
"Erudite Sewing Kit", 6243, "Worn Erudite Sewing Kit"
"Feir`Dal Champagne", 25551, "Feir'Dal Champagne"
"Feir`Dal Fletching Kit", 7858, "Feir'dal Fletching Kit"
"Feir`Dal Robe Pattern", 8172, "Feir'Dal Robe Pattern"
"Fier`Dal Sewing Kit", 20304, "Feir'Dal Sewing Kit"
"Fier`Dal Sewing Kit", 2563, "Worn Feir'Dal Sewing Kit"
"Intricate Book of Barbarian Culture", 20289, "Sacred Book of Barbarian Culture"
"Intricate Book of Dark Elven Culture", 20290, "Sacred Book of Dark Elven Culture"
"Intricate Book of Dwarven Culture", 20291, "Sacred Book of Dwarven Culture"
"Intricate Book of Erudite Culture", 20292, "Sacred Book of Erudite Culture"
"Intricate Book of Froglok Culture", 20293, "Sacred Book of Froglok Culture"
"Intricate Book of Gnomish Culture", 20294, "Sacred Book of Gnomish Culture"
"Intricate Book of Half Elven Culture", 20295, "Sacred Book of Half Elven Culture"
"Intricate Book of Halfling Culture", 20296, "Sacred Book of Halfling Culture"
"Intricate Book of High Elven Culture", 20297, "Sacred Book of High Elven Culture"
"Intricate Book of Human Culture", 20298, "Sacred Book of Human Culture"
"Intricate Book of Iksar Culture", 20299, "Sacred Book of Iksar Culture"
"Intricate Book of Ogre Culture", 20300, "Sacred Book of Ogre Culture"
"Intricate Book of Troll Culture", 20301, "Sacred Book of Troll Culture"
"Intricate Book of Vah Shir Culture", 20302, "Sacred Book of Vah Shir Culture"
"Intricate Book of Wood Elven Culture", 20303, "Sacred Book of Wood Elven Culture"
"Intricate Crystalweave Helm", 26990, "Intricate Crystalweave Cap"
"Intricate Stargazer Greaves", 18569, "Intricate Stargazer Breeches"
"Intricate Stargazer Helm", 18568, "Intricate Stargazer Cap"
"Lion Tooth", 21507, "Greater Cat Tooth"
"Matted Lion Pelt", 21504, "Matted Greater Cat Pelt"
"Mithril Fier`Dal Long Sword", 5847, "Mithril Feir'Dal Long Sword"
"Mithril Fier`Dal Long Sword", 5849, "Mithril Feir'Dal Long Sword"
"Mithril Fier`Dal Long Sword", 5848, "Mithril Feir'Dal Long Sword"
"Mithril Fier`Dal Morning Star", 5850, "Mithril Feir'Dal Morning Star"
"Mithril Fier`Dal Morning Star", 5852, "Mithril Feir'Dal Morning Star"
"Mithril Fier`Dal Morning Star", 5851, "Mithril Feir'Dal Morning Star"
"Mithril Fier'Dal Dagger", 5844, "Mithril Feir'Dal Dagger"
"Mithril Fier'Dal Rapier", 5853, "Mithril Feir'Dal Rapier"
"Mithril Fier'Dal Spear", 5856, "Mithril Feir'Dal Spear"
"Mithril Fier'Dal Spear", 5857, "Mithril Feir'Dal Spear"
"Mithril Leathers of the Fier`Dal", 7431, "Mithril Leathers of the Feir'Dal"
"Ornate Book of Barbarian Culture", 20244, "Revered Book of Barbarian Culture"
"Ornate Book of Dark Elven Culture", 20245, "Revered Book of Dark Elven Culture"
"Ornate Book of Dwarven Culture", 20246, "Revered Book of Dwarven Culture"
"Ornate Book of Erudite Culture", 20247, "Revered Book of Erudite Culture"
"Ornate Book of Froglok Culture", 20248, "Revered Book of Froglok Culture"
"Ornate Book of Gnomish Culture", 20249, "Revered Book of Gnomish Culture"
"Ornate Book of Half Elven Culture", 20250, "Revered Book of Half Elven Culture"
"Ornate Book of Halfling Culture", 20251, "Revered Book of Halfling Culture"
"Ornate Book of High Elven Culture", 20252, "Revered Book of High Elven Culture"
"Ornate Book of Human Culture", 20253, "Revered Book of Human Culture"
"Ornate Book of Iksar Culture", 20254, "Revered Book of Iksar Culture"
"Ornate Book of Ogre Culture", 20255, "Revered Book of Ogre Culture"
"Ornate Book of Troll Culture", 20256, "Revered Book of Troll Culture"
"Ornate Book of Vah Shir Culture", 20257, "Revered Book of Vah Shir Culture"
"Ornate Book of Wood Elven Culture", 20258, "Revered Book of Wood Elven Culture"
"Ornate Crystalweave Helm", 26925, "Ornate Crystalweave Cap"
"Ornate Stargazer Cuirass", 18558, "Ornate Stargazer Robe"
"Ornate Stargazer Greaves", 18562, "Ornate Stargazer Breeches"
"Ornate Stargazer Helm", 18561, "Ornate Stargazer Cap"
"Simple Book of Barbarian Culture", 20274, "Blessed Book of Barbarian Culture"
"Simple Book of Dark Elven Culture", 20275, "Blessed Book of Dark Elven Culture"
"Simple Book of Dwarven Culture", 20276, "Blessed Book of Dwarven Culture"
"Simple Book of Erudite Culture", 20277, "Blessed Book of Erudite Culture"
"Simple Book of Froglok Culture", 20278, "Blessed Book of Froglok Culture"
"Simple Book of Gnomish Culture", 20279, "Blessed Book of Gnomish Culture"
"Simple Book of Half Elven Culture", 20280, "Blessed Book of Half Elven Culture"
"Simple Book of Halfling Culture", 20281, "Blessed Book of Halfling Culture"
"Simple Book of High Elven Culture", 20282, "Blessed Book of High Elven Culture"
"Simple Book of Human Culture", 20283, "Blessed Book of Human Culture"
"Simple Book of Iksar Culture", 20284, "Blessed Book of Iksar Culture"
"Simple Book of Ogre Culture", 20285, "Blessed Book of Ogre Culture"
"Simple Book of Troll Culture", 20286, "Blessed Book of Troll Culture"
"Simple Book of Vah Shir Culture", 20287, "Blessed Book of Vah Shir Culture"
"Simple Book of Wood Elven Culture", 20288, "Blessed Book of Wood Elven Culture"
"Simple Crystalweave Helm", 26761, "Simple Crystalweave Cap"
"Simple Stargazer Helm", 18554, "Simple Stargazer Cap"
"Spell: Blessing of the Wild", 27204, "Spell: Sunscorch"
"Spell: Hand of Endeavor", 27330, "Spell: Fenegar's Mark"
"Spell: Leach", 24403, "Spell: Leech"
"Spell: Protection of Wishka", 27256, "Spell: Wishka's Favor"
"Spell: Rectitude", 27150, "Spell: Blessing of Purpose"
"Spell: Wildskin", 27173, "Spell: Blistering Sunray"
"Vale Sewing Kit", 2564, "Worn Vale Sewing Kit"


Below is a similar csv list of items whose sony id numbers are missing from your database
"name", "eqtc number", "sony number"
"Golden Dagger", 11011, 11424
"unfired deity", 4433, 16932
"Blood Treated Boruk Hide", 27779, 29490
"Coconut", 27541, 32044
"Decorative Carp", 27505, 32055
"Buttered Shark Fin", 27788, 33541
"Buttered Shark Fin Soup", 27787, 33572
"Buttered Shark Fin Sandwich", 28744, 33578
"Barbequed Shark Fin Soup", 27738, 33596
"Barbequed Shark Fin Pie", 27879, 33601
"Gruel", 27659, 33624
"Porridge", 27661, 33625
"Sweet Porridge", 27663, 33626
"Creamy Porridge", 27662, 33627
"Honey Porridge", 27907, 33628
"Buttered Porridge", 27666, 33629
"Freetide Punch", 27772, 33640
"Shiny Bundle of Super Conductive Wires", 27678, 34028
"Deluxe Gnomish Recharging Kit", 27762, 34030
"Crude Ancestral Acrylia Thread", 28701, 34262
"Fair Ancestral Acrylia Thread", 28702, 34277
"Malleable Iron Thread", 28698, 34287
"Malleable Ancestral Acrylia Thread", 28704, 34292
"Ossified Ancestral Acrylia Thread", 28705, 34322
"Indurate Ancestral Acrylia Thread", 28703, 34337
"Refractory Ancestral Acrylia Thread", 28706, 34352
"Fair Feir'Dal Mithril", 28525, 34373
"Malleable Feir'Dal Mithril", 28526, 34389
"Ductile Feir'Dal Mithril", 28527, 34405
"Ossified Feir'Dal Mithril", 28528, 34421
"Indurate Feir'Dal Mithril", 28529, 34437
"Refractory Feir'Dal Mithril", 28530, 34453
"Red Trader's Satchel", 27766, 35026
"Blue Trader's Satchel", 27769, 35030
"Black Trader's Satchel", 27764, 35033
"Brown Hand Made Backpack", 27763, 35044
"Hypericum", 27782, 35794
"Elegant Daybreaker Cuirass", 28772, 37067
"Elegant Stalwart Cuirass", 28865, 37078
"Elegant Daybreaker Greaves", 28773, 37111
"Elegant Stalwart Greaves", 28866, 37122
"Elegant Daybreaker Sleeves", 28774, 37199
"Elegant Stalwart Sleeves", 28867, 37210
"Elegant Daybreaker Armband", 28778, 37243
"Elegant Daybreaker Helm", 28776, 37331
"Ring Mold", 28847, 37798
"barbequed nest dragon jerky", 16933, 45518
"barbequed nest dragon kabob", 16934, 45521
"beer-battered nest dragon souffle", 16955, 45535
"pale gemmed dagger", 11135, 63360
"platinum dagger blade", 11384, 63370
"velium dagger hilt", 11531, 63388
"platinum inlaid long spear blade", 11445, 63430
"platinum inlaid long spear haft", 11446, 63433
"platinum gem-bladed long spear", 11391, 63440
"velium gem-hafted long spear", 11545, 63456
"gem-inlaid broad spear blade", 10963, 63461
"gem-inlaid broad spear haft", 10964, 63467
"pale gemmed broad spear", 11130, 63476
"pale platinum inlaid broad spear haft", 11272, 63490
"platinum broad spear", 11378, 63494
"gold-hafted morningstar", 11057, 63588
"gem-headed morningstar", 10955, 63593
"platinum morningstar head", 11481, 63602
"platinum morningstar haft", 11480, 63605
"platinum morningstar", 11479, 63610
"golden maul head", 11106, 63633
"gold-hafted maul", 11056, 63646
"velium-hafted maul", 11574, 63682
"golden warhammer head", 11118, 63691
"golden warhammer haft", 11117, 63697
"velium gem-hafted warhammer", 11549, 63746
"steel-reinforced cragbeast sack", 11670, 63818
"10 Dose Bitter Feedback", 27906, 72630
"chocolate mint golanda nut crunch", 16474, 75835
"round cut harmonagate velium ring", 1852, 95371
"round cut harmonagate palladium pendant", 1877, 95624
"pear cut harmonagate velium pendant", 1830, 95647
"Rough Papyrus", 4931, 97810
"runic papyrus", 27127, 97813
"alchemist charm", 26463, 97926
"mechanic charm", 26437, 97931
"Square Cut Taaffeite Velium Ring", 27895, 97966

[KyrosKrane]

All updated, thank you!

If you have any other numbers, go ahead and post them in a fresh post. A CSV list like this is fine; I can quickly convert it into the proper form for a mass update.