How to change the armor requirement on an item?

[Corosive720]

The title says it all, how do you change the the armor requirement a piece of armor requires to equip? I want to change plate items in the DB to have clothies be able to wear them visa versa. I already changed the Material column in the Items_template table, but all that changes is the in-game sound it makes when you equip it.

Btw im using TrinityCore if you didnt read the Prefix

[choweyiii]

You could always just have a gossip NPC that teaches plate (spell 750)

function On_Gossip(unit, event, player)
unit:GossipCreateMenu(50, player, 0)
unit:GossipMenuAddItem(0, "Learn Plate Mail", 1, 0)
unit:GossipSendMenu(player)
end

function Gossip_Submenus(unit, event, player, id, intid, code)
if(intid == 1) then
player:LearnSpell(750)
end

RegisterUnitGossipEvent(UNITIDHERE, 1, "On_Gossip")
RegisterUnitGossipEvent(UNITIDHERE, 2, "Gossip_Submenus")

OR for an even easier solution:

function LearnPlate(event, plr, message, pType, pLanguage, pMisc)
plr:LearnSpell(750)
end

RegisterServerHook(4, "LearnPlate")

This one will effect all new, and existing players.

Hope this helped.

[Corosive720]

You could always just have a gossip NPC that teaches plate (spell 750)

function On_Gossip(unit, event, player)
unit:GossipCreateMenu(50, player, 0)
unit:GossipMenuAddItem(0, "Learn Plate Mail", 1, 0)
unit:GossipSendMenu(player)
end

function Gossip_Submenus(unit, event, player, id, intid, code)
if(intid == 1) then
player:LearnSpell(750)
end

RegisterUnitGossipEvent(UNITIDHERE, 1, "On_Gossip")
RegisterUnitGossipEvent(UNITIDHERE, 2, "Gossip_Submenus")

OR for an even easier solution:

function LearnPlate(event, plr, message, pType, pLanguage, pMisc)
plr:LearnSpell(750)
end

RegisterServerHook(4, "LearnPlate")

This one will effect all new, and existing players.

Hope this helped.

Well i would do this but i am using Trinity and sadly they don't support LuA or even have an engine for it lol

[stoneharry]

Create a new C++ script -> hook on player enter world -> if !player has spell (plate) { player->learnspell(plate); }

You get the general idea... Better start learning C++, it's a simple script.

[Dynashock]

Those scripts are not what he's asking for, although it's an alternative. Whether hooking up a script to it is smart (as opposed to editing the playercreateinfo tables) is debatable. Anyway, he wants to change the armor requirements, which need to be done through the DB. This is relatively easy given you have a basic understanding of SQL, which every WoW server developer should have in the very least.
As not to discourage you, take a look at Item template tc2 - TrinityCore Wiki. On there you will find which columns you need to edit. I recommend you bookmark the site for future troubleshooting. Anyhow, if it's just a few items you need to edit I'd do it case by case; but you might want to change all of them at once. The query statement you need for this is UPDATE and a WHERE clause that selects only armor items. We wouldn't want to change every item to change to armor, right? I'll let you figure out the rest.
One last note, delete your cache and restart WoW once you have applied these changes, otherwise you still won't be able to equip plate as a clothie and vice versa.