function Plate_Requester_Stoned(pUnit, event, player)
    pUnit:GossipCreateMenu(999999, player, 0)
    pUnit:GossipMenuAddItem(0, "I would like to buy some armour.", 246, 1)
    pUnit:GossipMenuAddItem(0, "Nevermind.", 250, 0)
    pUnit:GossipSendMenu(player)
end


function Plate_Requester_Stoned_Gossip(pUnit, event, player, id, intid, code)
    if(intid == 246) then
        if code ~= nil then
            local item = WorldDBQuery("SELECT `quality` FROM `items` WHERE `entry` = '"..code.."';")
            if item ~= nil then -- Check it exists
                item = item:GetColumn(0):GetString()
                if item == "2" or item == "1" or item == "0" then -- Quality
                    if WorldDBQuery("SELECT `class` FROM `items` WHERE `entry` = '"..code.."';"):GetColumn(0):GetString() == "4" then -- Armour
                        if WorldDBQuery("SELECT `subclass` FROM `items` WHERE `entry` = '"..code.."';"):GetColumn(0):GetString() == "3" or WorldDBQuery("SELECT `subclass` FROM `items` WHERE `entry` = '"..code.."';"):GetColumn(0):GetString() == "4" then -- Make sure it's plate or mail
                            if player:GetCoinage() > 200000 then -- In copper
                                local count = WorldDBQuery("SELECT `Amount` from `arequest_cooldown` WHERE `Name` = '"..player:GetName().."';")
                                if count == nil then
                                WorldDBQuery("INSERT INTO `arequest_cooldown` VALUES ('"..player:GetName().."', '1');")
                                player:DealGoldCost(200000) -- In copper
                                player:AddItem(code, 1)
                                else
                                    if count:GetColumn():GetString() == "15" then
                                    player:SendAreaTriggerMessage("|CFFff0000You have reached your limit of items you are allowed to request!|R")
                                    else
                                    count = count:GetColumn(0)
                                    count = count + 1
                                    WorldDBQuery("UPDATE `arequest_cooldown` SET `Amount` = '"..count.."';")
                                    player:DealGoldCost(200000) -- In copper
                                    player:AddItem(code, 1)
                                    end
                                end
                            else
                            player:SendAreaTriggerMessage("|CFFff0000You do not have enough gold!|R")
                            end
                        else
                        player:SendAreaTriggerMessage("|CFFff0000This blacksmith can only make mail and plate armour!|R")
                        end
                    else
                    player:SendAreaTriggerMessage("|CFFff0000That is not armour!|R")
                    end
                else
                player:SendAreaTriggerMessage("|CFFff0000That item is too rare!|R")
                end
            else
            player:SendAreaTriggerMessage("|CFFff0000That item does not exist!|R")
            end
        end
    player:GossipComplete()
    end
    if(intid == 250) then
    player:GossipComplete()
    end
end

RegisterUnitGossipEvent(31111, 1, "Plate_Requester_Stoned")
RegisterUnitGossipEvent(31111, 2, "Plate_Requester_Stoned_Gossip")