lua hearthstone

function Item_Trigger(unit, event, player)
unit:GossipCreateMenu(130, player, 0)
unit:GossipMenuAddItem(1, "Batlleground", 1,  0)
unit:GossipMenuAddItem(0, "Bind Hearthstone(10mg)", 2, 0)
unit:GossipMenuAddItem(1, "Use Hearhstone", 3, 0)
unit:GossipMenuAddItem(1, "Repair", 4,  0)
unit:GossipMenuAddItem(1, "Bank", 5,  0)
unit:GossipMenuAddItem(0, "Combat Unstuck", 7, 0)
unit:GossipMenuAddItem(0, "Buffs", 8, 0)
unit:GossipMenuAddItem(0, "Sickness remover", 9, 0)
unit:GossipSendMenu(player)
end

function OnSelect(unit, event, player, id, intid, code)
if(intid == 75) then
unit:GossipCreateMenu(130, player, 0)
unit:GossipCreateMenu(130, player, 0)
unit:GossipMenuAddItem(1, "Batlleground", 1,  0)
unit:GossipMenuAddItem(0, "Bind Hearthstone(10mg)", 2, 0)
unit:GossipMenuAddItem(1, "Use Hearthstone", 3, 0)
unit:GossipMenuAddItem(1, "Repair", 4,  0)
unit:GossipMenuAddItem(1, "Bank", 5,  0)
unit:GossipMenuAddItem(0, "Combat Unstuck", 7, 0)
unit:GossipMenuAddItem(0, "Buffs", 8, 0)
unit:GossipMenuAddItem(0, "Sickness remover", 9, 0)
unit:GossipSendMenu(player)
end

if(intid == 1) then
unit:GossipCreateMenu(51, player, 0)
unit:GossipMenuAddItem(1, "BG 1", 10, 0)
unit:GossipMenuAddItem(1, "BG 2", 11, 0)
unit:GossipMenuAddItem(1, "BG 3", 12, 0)
unit:GossipMenuAddItem(1, "BG 4", 13, 0)
unit:GossipMenuAddItem(0, "[Main Menu]", 75, 0)
unit:GossipSendMenu(player)
end


if(intid == 4) then
if(player:GetCoinage() < 10) then
player:SendBroadcastMessage("Not enough copper (10 required).")
player:GossipComplete()
else
player:RepairAllPlayerItems()
player:GossipComplete()
player:SendBroadcastMessage("|cff82CAFFRepair Cost: |cff00ff0010 coins of copper|r (Items repaired).")
player:DealGoldCost(10)
end
end

if(intid == 5) then
player:SendBankWindow(player)
player:GossipComplete()
end

if(intid == 7) then
player:DisableCombat()
player:SetOutOfCombatRange(range)
player:SendBroadcastMessage("|cffEC3131Unstucked from combat.|r")
player:GossipComplete()
end

if(intid == 9) then
if (player:HasAura(15007) == true) then
player:SendBroadcastMessage("|cff00ff00Your Sickness has been removed.")
player:RemoveAura(15007)
player:GossipComplete()
else
player:SendAreaTriggerMessage("|cffff0000Aura not found.")
player:GossipComplete()
end
end

if(intid == 8) then
player:SendBroadcastMessage("buff")
	player:CastSpell(33077)
	player:CastSpell(33078)
	player:CastSpell(33079)
	player:CastSpell(33080)
	player:CastSpell(33081)
	player:CastSpell(33082)
	player:CastSpell(24705)
	player:CastSpell(26035)
item:GossipCreateMenu(110001, player, 0)
item:GossipMenuAddItem(0, "..Return", 75, 0)
item:GossipMenuAddItem(0, " you have been buffed", 75, 0)
item:GossipSendMenu(player)
end


if(intid == 10) then
player:SendBattlegroundWindow(player, 1)
player:GossipComplete()
end
if(intid == 11) then
player:SendBattlegroundWindow(player, 2)
player:GossipComplete()
end
if(intid == 12) then
player:SendBattlegroundWindow(player, 3)
player:GossipComplete()
end
if(intid == 13) then
player:SendBattlegroundWindow(player, 4)
player:GossipComplete()
end

if(intid == 16) then
player:Teleport(1, 9948, 2413, 1327)
end

if(intid == 3) then -- Hearthstone unstuck
player:ClearCooldownForSpell(7355)
player:FullCastSpell(7355)
player:GossipComplete()
end

if(intid == 2) then -- Bind Location
local GetMagicGold = WorldDBQuery("SELECT `mg` FROM logon_git.accounts WHERE `login` = '"..player:GetAccountName().."';");

local MagicGold = GetMagicGold:GetColumn(0):GetLong()

if (MagicGold < 10) then
player:SendBroadcastMessage("Not enough MG.")
player:GossipComplete()

else

WorldDBQuery("UPDATE logon_git.accounts SET `mg` = '"..MagicGold.."'-'10' WHERE `login` = '"..player:GetAccountName().."'; ");

player:FullCastSpell(3286)
local GetMagicGoldLeft = WorldDBQuery("SELECT `mg` FROM logon_git.accounts WHERE `login` = '"..player:GetAccountName().."';");

local MagicGoldLeftz = GetMagicGoldLeft:GetColumn(0):GetString()
player:SendBroadcastMessage("|cffEC3131Spent 10 MG, total left: "..MagicGoldLeftz..".|r")
player:GossipComplete()
end
end


RegisterItemGossipEvent(6948,1,"Item_Trigger")
RegisterItemGossipEvent(6948,2,"OnSelect")