I needed once the IDs of all TBC patterns, recipes and such for a character transfer script.
SunwellPlateu
Study of Advanced Smelting spell=46353
Plans: Hard Khorium Battlefists spell=46141
Pattern: Fletcher's Gloves of the Phoenix spell=46133
Pattern: Hands of Eternal Light spell=46129
Pattern: Sun-Drenched Scale Chestguard spell=46139
Schematic: Surestrike Goggles v3.0 spell=46113
Design: Hard Khorium Choker spell=46127
Pattern: Sun-Drenched Scale Gloves spell=46135
Plans: Sunblessed Gauntlets spell=46140
Schematic: Hyper-Magnified Moon Specs spell=46109
Plans: Hard Khorium Battleplate spell=46144
Schematic: Annihilator Holo-Gogs spell=46111
Pattern: Carapace of Sun and Shadow spell=46138
Pattern: Sunfire Robe spell=46130
Schematic: Lightning Etched Specs spell=46112
Design: Hard Khorium Band spell=46124
Design: Loop of Forged Power spell=46122
Design: Pendant of Sunfire spell=46125
Design: Ring of Flowing Life spell=46127
Pattern: Robe of Eternal Light spell=46131
Pattern: Sunfire Handwraps spell=46128
Plans: Sunblessed Breastplate spell=46142
Schematic: Justicebringer 3000 Specs spell=46107
Schematic: Quad Deathblow X44 Goggles spell=46116
Design: Amulet of Flowing Life spell=46126
Pattern: Gloves of Immortal Dusk spell=46134
Pattern: Leather Gauntlets of the Sun spell=46132
Schematic: Hard Khorium Goggles spell=46115
Schematic: Powerheal 9000 Lens spell=46108
Hyjal Summit
Design: Flashing Crimson Spinel spell=39714
Design: Inscribed Pyrestone spell=39733
Design: Mystic Lionseye spell=39724
Design: Rigid Empyrean Sapphire spell=39721
Design: Shifting Shadowsong Amethyst spell=39728
Design: Sovereign Shadowsong Amethyst spell=39727
Design: Stormy Empyrean Sapphire spell=39718
Design: Veiled Shadowsong Amethyst spell=39737
Pattern: Bindings of Lightning Reflexes spell=41161
Pattern: Swiftheal Wraps spell=41207
Pattern: Swiftstrike Bracers spell=41158
Plans: Swiftsteel Bracers spell=41132
Kharazhan
Pattern: Soulcloth Shoulders spell=26780
Pattern: Soulcloth Vest spell=26781
Formula: Enchant Weapon - Mongoose spell=27984
Formula: Enchant Weapon - Soulfrost spell=27982
Formula: Enchant Weapon - Sunfire spell=27981
Schematic: Stabilized Eternium Scope spell=30334
Formula: Enchant Boots - Surefooted spell=27954
Zul'aman
Formula: Enchant Weapon - Executioner spell=46974
Black Temple
Pattern: Bracers of Nimble Thought spell=41205
Pattern: Bracers of Renewed Life spell=41156
Pattern: Living Earth Bindings spell=41163
Plans: Dawnsteel Bracers spell=41134
Serpentshrine Cavern (SSC)
Pattern: Belt of Blasting spell=36315
Pattern: Belt of Deep Shadow spell=36351
Pattern: Belt of Natural Power spell=36349
Pattern: Belt of the Black Eagle spell=36352
Pattern: Belt of the Long Road spell=36316
Pattern: Monsoon Belt spell=36353
Plans: Belt of the Guardian spell=36389
Plans: Red Belt of Battle spell=36390
TK: The Eye
none1
Normal inis and heroics:
The Arcatraz
Pattern: Whitemend Pants spell=31451
Plans: Felsteel Leggings spell=29620
Formula: Enchant 2H Weapon - Major Agility spell=27977
Pattern: Arcanoweave Bracers spell=26782
Pattern: Flame Armor Kit spell=25416
The Botanica
Pattern: Battlecast Pants spell=31453
Pattern: Whitemend Hood spell=31454
Plans: Earthpeace Breastplate spell=29649
The Mechanar
Schematic: Rocket Boots Xtreme Lite spell=46697
Pattern: Arcanoweave Robe spell=26784
Recipe: Major Fire Protection Potion spell=28571
The Slave Pens
Formula: Enchant Weapon - Deathfrost spell=46578
The Steamvault
Schematic: Rocket Boots Xtreme spell=30556
Formula: Enchant Bracer - Fortitude spell=27914
Pattern: Frost Armor Kit spell=35522
Pattern: Battlecast Hood spell=31456
The Underbog & Hellfire Ramparts & The Blood Furnace &
none
The Shattered Halls
Pattern: Spellstrike Hood spell=31455
Formula: Enchant 2H Weapon - Savagery spell=27971
Auchenai Crypts
Plans: Felsteel Gloves spell=29619
Formula: Enchant Boots - Dexterity spell=27951
Mana-Tombs
Formula: Enchant Boots - Fortitude spell=27950
Sethekk Halls
Design: Khorium Inferno Band spell=31055
Shadow Labyrinth
Pattern: Spellstrike Pants spell=31452
Pattern: Stylin' Purple Hat spell=32485
Old Hillsbrad Foothills
Design: Circlet of Arcane Might spell=32980
The Black Morass
Pattern: Arcane Armor Kit spell=35524
##############
World drops
Recipe: Destruction Potion spell=28508
Recipe: Elixir of Major Shadow Power spell=28558
Recipe: Haste Potion spell=28564
Recipe: Heroic Potion spell=28563
Recipe: Fel Regeneration Potion spell=38962
Recipe: Fel Strength Elixir spell=38960
Recipe: Elixir of the Searching Eye spell=28552
Recipe: Insane Strength Potion spell=28550
Recipe: Flask of Chromatic Resistance spell=17638
Recipe: Flask of the Titans spell=17635
Recipe: Flask of Distilled Wisdom spell=17636
Recipe: Flask of Supreme Power spell=17637
Recipe: Potion of Petrification spell=17634
Recipe: Greater Arcane Protection Potion spell=17577
Recipe: Greater Fire Protection Potion spell=17574
Recipe: Elixir of the Mongoose spell=17571
Pattern: Living Earth Shoulders spell=41164
Pattern: Mantle of Nimble Thought spell=41206
Pattern: Shoulderpads of Renewed Life spell=41157
Formula: Enchant Gloves - Angler spell=71692
Formula: Enchant Cloak - Dodge spell=25086
Formula: Enchant Cloak - Stealth spell=25083
Formula: Enchant Gloves - Fire Power spell=25078
Formula: Enchant Gloves - Frost Power spell=25074
Formula: Enchant Gloves - Healing Power spell=25079
Formula: Enchant Gloves - Shadow Power spell=25073
Formula: Enchant Gloves - Superior Agility spell=25080
Formula: Enchant Weapon - Potency spell=27972
Formula: Enchant Chest - Major Resilience spell=33992
Formula: Enchant Shield - Shield Block spell=27946
Formula: Enchant Weapon - Major Intellect spell=27968
Formula: Enchant Cloak - Major Resistance spell=27962
Formula: Enchant Weapon - Lifestealing spell=20032
Formula: Enchant Weapon - Healing Power spell=22750
Formula: Enchant Weapon - Spellpower spell=22749
Formula: Enchant Weapon - Crusader spell=20034
Formula: Enchant Boots - Vitality spell=27948
Design: Brilliant Living Ruby spell=31088
Design: Rigid Star of Elune spell=31098
Design: Delicate Living Ruby spell=31085
Formula: Enchant Boots - Cat's Swiftness spell=34007
Design: Solid Star of Elune spell=31092
Formula: Enchant Boots - Boar's Speed spell=34008
Pattern: Unyielding Girdle spell=31442
Recipe: Elixir of Empowerment spell=28578
Pattern: Cobrascale Gloves spell=35559
Pattern: Unyielding Bracers spell=31434
Schematic: Healing Potion Injector spell=30551
Schematic: Mana Potion Injector spell=30552
Pattern: Netherdrake Gloves spell=35573
Plans: Adamantite Weapon Chain spell=42688
Pattern: Gloves of the Living Touch spell=35562
Pattern: Windstrike Gloves spell=35568
Pattern: Swiftheal Mantle spell=41208
Plans: Swiftsteel Shoulders spell=41133
Pattern: Swiftstrike Shoulders spell=41160
Pattern: Shoulders of Lightning Reflexes spell=41162
