WD HearthStone

-- i dont know who made this but i found it in xXgrimXx's arcemu repack . so rep grim
-- i modified it for my realm
-- changed online store to VIP store
-- VIP store allows chars to purchase there next VIP level with mg rather than
-- earning it by votes count.
-- with a check so they dont keep buying levels even tho they are maxxed VIP

function Item_Trigger(item, event, player)
player:FullCastSpell(49308)
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, "Global GPS Teleport", 18, 0)
item:GossipMenuAddItem(2, "Eventable Zones", 6100, 0)
item:GossipMenuAddItem(2, "Hearthstone", 3773, 0)
item:GossipMenuAddItem(6, "Protection Bank", 54327, 0)
item:GossipMenuAddItem(8, "Gear Repair", 54328, 0)
item:GossipMenuAddItem(2, "Arena Team", 3775, 0)
item:GossipMenuAddItem(2, "Check MG", 3205, 0)
item:GossipMenuAddItem(2, "VIP Shop", 8090, 0)
item:GossipMenuAddItem(4, "|cffFF0000Mailbox Online", 8080, 0)
item:GossipMenuAddItem(7, "Other Services", 8073, 0)
item:GossipSendMenu(player)
end

function OnSelect(item, event, player, id, intid, code)

if(intid == 75) then
return Item_Trigger(item, event, player)
end

if(intid == 9999) then
player:GossipComplete()
end

if(intid == 8080) then
player:SendBroadcastMessage("at the moment unavailable. we will update later.")
player:GossipComplete()
end

if(intid == 7071) then
player:Teleport(0, -246.918533, 1532.947632, 77.121796)
player:GossipComplete()
end

if(intid == 12904) then
player:Teleport(0, -47343.663574, -3111.000977, 308.573029)
player:GossipComplete()
end

if(intid == 12905) then
player:Teleport(0, -4771.063965, -3525.218018, 303.590790)
player:GossipComplete()
end

if(intid == 29030) then
player:Teleport(1, 6500.379883, -2364.060059, 594.765686)
player:GossipComplete()
end

if(intid == 2904) then
player:Teleport(1, -6287.853516, -383.331238, -0.947034)
player:GossipComplete()
end

if(intid == 12903) then
player:Teleport(1, 1274.176392, -4331.429199, 33.097721)
player:GossipComplete()
end

if(intid == 2905) then
player:Teleport(1, -5660.225098, -3493.307617, -57.450867)
player:GossipComplete()
end

if(intid == 12905) then
player:Teleport(0, -11298.624023, -367.173950, 65.445702)
player:GossipComplete()
end

if(intid == 29103) then
player:Teleport(530, 6654.667969, -6458.312988, 29.2593025)
player:GossipComplete()
end

if(intid == 29101) then
player:Teleport(0, -11665.720703, -2371.583252, 0.551880)
player:GossipComplete()
end

if(intid == 29060) then
player:Teleport(1, 5479.136719, -3730.750000, 1593.439941)
player:GossipComplete()
end

if(intid == 90003) then
player:Teleport(1, -6212.604004, -3951.196777, -58.751427)
player:GossipComplete()
end

if(intid == 11500) then
player:Teleport(0, -8348.363281, 624.138550, 97.632553)
player:GossipComplete()
end

if(intid == 21222) then
player:SendBattlegroundWindow(player, 1)
player:GossipComplete()
end
if(intid == 21223) then
player:SendBattlegroundWindow(player, 2)
player:GossipComplete()
end
if(intid == 21224) then
player:SendBattlegroundWindow(player, 3)
player:GossipComplete()
end
if(intid == 21225) then
player:SendBattlegroundWindow(player, 4)
player:GossipComplete()
end

if(intid == 15000) then
player:Teleport(1, 7567.507324, -2891.146240, 460.661255)
player:GossipComplete()
end

if(intid == 2900) then
player:Teleport(1, -4285.628418, -785.919495, -52.691986)
player:GossipComplete()
end

if(intid == 2901) then
player:Teleport(1, -6286.524902, -385.810486, 1.208365)
player:GossipComplete()
end

if(intid == 6100) then
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "..return\n ", 75, 0)
if (player:GetTeam() == 0) then -- alliance
item:GossipMenuAddItem(2, "[Kill] Arathi Basin [A]\n ", 4780, 0)
elseif (player:GetTeam() == 1) then -- horde
item:GossipMenuAddItem(2, "[Kill] Arathi Basin [H]\n ", 4781, 0)
end
item:GossipMenuAddItem(2, "[Teleport] Azeroth (|cffFF0000Well of the forgoten|r) \n ", 4779, 0)
item:GossipMenuAddItem(2, "[Teleport] Oldhillsbrad (|cffFF0000FFA Battle|r)\n ", 4777, 0)
item:GossipMenuAddItem(2, "[Teleport] Oldhillsbrad (|cffFF00005V5 Arena|r)\n ", 4778, 0)
item:GossipSendMenu(player)
end

if(intid == 40) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, " [Eastern Kingdom Menu Page]\n ", 40, 0)
item:GossipMenuAddItem(0, "..Main Page\n ", 75, 0)
item:GossipMenuAddItem(2, "Alterac Mountains", 208, 0)
item:GossipMenuAddItem(2, "Badlands", 214, 0)
item:GossipMenuAddItem(2, "Blasted Lands", 222, 0)
item:GossipMenuAddItem(2, "Burning Steppes", 216, 0)
item:GossipMenuAddItem(2, "Deadwind Pass", 221, 0)
item:GossipMenuAddItem(2, "Dun Morogh", 212, 0)
item:GossipMenuAddItem(2, "Duskwood", 220, 0)
item:GossipMenuAddItem(2, "Eastern Plaguelands", 206, 0)
item:GossipMenuAddItem(2, "Elwynn Forest", 217, 0)
item:GossipMenuAddItem(2, "Eversong Woods", 201, 0)
item:GossipMenuAddItem(2, "Ghostlands", 202, 0)
item:GossipSendMenu(player)
end
end

if(intid == 8073) then
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "..Main Page\n ", 75, 0)
item:GossipMenuAddItem(2, "Bind location (Cost: 10 MG)", 3774, 0)
item:GossipMenuAddItem(2, "Character repair (Cost: 5g)", 54328, 0)
item:GossipMenuAddItem(2, "Combat Unstuck", 3206, 0)
item:GossipMenuAddItem(2, "Magic buffs (Cost: 20 MG)", 54321, 0)
item:GossipMenuAddItem(2, "Sickness removal", 9090, 0)
item:GossipMenuAddItem(2, "Reset talent points (Cost: 10g)", 54325, 0)
item:GossipMenuAddItem(2, "Weapon skills", 9997, 0)
item:GossipSendMenu(player)
end

if(intid == 8090) then
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "..Main Page\n ", 75, 0)
item:GossipMenuAddItem(0, "VIP level upgrade (Cost: 100,000 MG)", 8091, 0)
item:GossipSendMenu(player)
end

if(intid == 8091) then
local CheckmgforGtoken = WorldDBQuery("SELECT `mg` FROM logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
local CheckViplevels = WorldDBQuery("SELECT `vip` FROM logon.accounts WHERE `login` = '"..player:GetAccountName().."';");

local MagicGoldftgk = CheckmgforGtoken:GetColumn(0):GetLong()
local Viplevels = CheckViplevels:GetColumn(0):GetLong()

if (MagicGoldftgk < 50000) then -- not enough mg
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "you only have "..MagicGoldftgk.." Magic Gold. you need "..'50000' - MagicGoldftgk.." more.", 8090, 0)
item:GossipSendMenu(player)
else

if (Viplevels == 10) then -- max vip level cant upgrade anymore. current max level is 10
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "you are VIP"..Viplevels..". you cant upgrade anymore.", 8090, 0)
item:GossipSendMenu(player)
else
-- player:AddItem(44209, 990)
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "Congratulations you are now VIP"..Viplevels + '1'.."", 8090, 0)
item:GossipSendMenu(player)

WorldDBQuery("UPDATE logon.accounts SET `mg` = '"..MagicGoldftgk.."'-'50000' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
WorldDBQuery("UPDATE logon.accounts SET `votes` = `votes` + '125' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
WorldDBQuery("UPDATE logon.accounts SET `vip` = `vip` + '1' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
end
end
end
if(intid == 9997) then
    player:AdvanceSkill(43, 1000)
    player:AdvanceSkill(44, 1000)
    player:AdvanceSkill(45, 1000)
    player:AdvanceSkill(46, 1000)
    player:AdvanceSkill(54, 1000)
    player:AdvanceSkill(55, 1000)
    player:AdvanceSkill(95, 1000)
    player:AdvanceSkill(136, 1000)
    player:AdvanceSkill(160, 1000)
    player:AdvanceSkill(162, 1000)
    player:AdvanceSkill(172, 1000)
    player:AdvanceSkill(173, 1000)
    player:AdvanceSkill(176, 1000)
    player:AdvanceSkill(226, 1000)
    player:AdvanceSkill(228, 1000)
    player:AdvanceSkill(229, 1000)
    player:AdvanceSkill(473, 1000)
    player:AdvanceSkill(164, 1000)
    player:AdvanceSkill(165, 1000)
    player:AdvanceSkill(171, 1000)
    player:AdvanceSkill(182, 1000)
    player:AdvanceSkill(186, 1000)
    player:AdvanceSkill(197, 1000)
    player:AdvanceSkill(202, 1000)
    player:AdvanceSkill(333, 1000)
    player:AdvanceSkill(393, 1000)
    player:AdvanceSkill(755, 1000)
    player:AdvanceSkill(773, 1000)
    player:AdvanceSkill(129, 1000)
    player:AdvanceSkill(185, 1000)
    player:AdvanceSkill(356, 1000)
player:GossipComplete()
end

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

if(intid == 54328) 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 == 54325) then
player:GossipComplete()
player:GossipMiscAction(9, player, 1)
end

if(intid == 54321) then
local GetMagicGold = WorldDBQuery("SELECT `mg` FROM logon.accounts WHERE `login` = '"..player:GetAccountName().."';");

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

if (MagicGold < 20) then

player:SendBroadcastMessage("Not enough MG.")
player:GossipComplete()
else
    player:CastSpell(33077)
    player:CastSpell(33078)
    player:CastSpell(33079)
    player:CastSpell(33080)
    player:CastSpell(33081)
    player:CastSpell(33082)
    player:CastSpell(24705)
    player:CastSpell(26035)
WorldDBQuery("UPDATE logon.accounts SET `mg` = '"..MagicGold.."'-'20' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
item:GossipCreateMenu(110001, player, 0)
item:GossipMenuAddItem(0, "..Return\n", 75, 0)
item:GossipMenuAddItem(0, "Congratulations, you have been buffed.\n Tip: 20 mg spent.", 75, 0)
item:GossipSendMenu(player)
end
end

if(intid == 75002) then
player:Teleport(560, 2013.447632, 242.440292, 71.172020)
player:GossipComplete()
end

if(intid == 1000) then
player:Teleport(469, -7665.006348, -1102.048950, 399.679230)
player:GossipComplete()
end

if(intid == 1002) then
player:Teleport(530, 2891.586670, 1572.162720, 248.763815)
player:GossipComplete()
end

if(intid == 1500) then
player:Teleport(0, 334.382446, 372.605347, -38.309719)
player:GossipComplete()
end

if(intid == 1501) then
player:Teleport(0, -10428.820313, -422.008423, 44.391155)
player:GossipComplete()
end

if(intid == 1502) then
player:Teleport(0, -10428.820313, -422.008423, 44.391155)
player:GossipComplete()
end

if(intid == 834) then
player:Teleport(43, -161.737076, 132.046326, -73.882683)
player:GossipComplete()
end

if(intid == 1010) then
player:Teleport(1, 6925.790039, -2274.969971, 590.013000)
player:GossipComplete()
end

if(intid == 1011) then
player:Teleport(1, 4582.560059, -3820.830078, 978.575012)
player:GossipComplete()
end

if(intid == 1012) then
player:Teleport(1, 1814.668335, -4419.4147480, -18.812292)
player:GossipComplete()
end

if(intid == 835) then
player:Teleport(48, -151.889999, 106.959999, -39.869999)
player:GossipComplete()
end

if(intid == 836) then
player:Teleport(47, 1943.000000, 1544.630005, 81.997025)
player:GossipComplete()
end

if(intid == 837) then
player:Teleport(189, 1691.010010, 1053.744507, 18.677431)
player:GossipComplete()
end

if(intid == 838) then
player:Teleport(189, 862.380432, 1321.962036, 18.676479)
player:GossipComplete()
end

if(intid == 839) then
player:Teleport(189, 1614.569580, -323.615875, 18.675322)
player:GossipComplete()
end

if(intid == 820) then
player:Teleport(189, 257.482117, -209.070969, 18.677341)
player:GossipComplete()
end

if(intid == 821) then
player:Teleport(209, 1221.819946, 840.745972, 8.976506)
player:GossipComplete()
end

if(intid == 822) then
player:Teleport(0, -10265.416016, -3887.859131, -38.769176)
player:GossipComplete()
end

if(intid == 1) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, " [Raid Instances (page: 1)]\n ", 1, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "[Teleport] Auchenai Crypts", 435, 0)
item:GossipMenuAddItem(2, "[Teleport] Black Temple", 451, 0)
item:GossipMenuAddItem(2, "[Teleport] Blackrock", 24, 0)
item:GossipMenuAddItem(2, "[Teleport] Caverns Of Time", 29, 0)
item:GossipMenuAddItem(2, "[Teleport] The Deadmines", 3704, 0)
item:GossipMenuAddItem(2, "[Teleport] Gruul's Lair", 446, 0)
item:GossipMenuAddItem(2, "[Teleport] Hellfire Ramparts", 430, 0)
item:GossipMenuAddItem(2, "[Teleport] Hyjal Summit", 3705, 0)
item:GossipMenuAddItem(2, "[Teleport] Karazhan", 27, 0)
item:GossipMenuAddItem(2, "[Teleport] Molten Core", 26, 0)
item:GossipMenuAddItem(0, "\n Next Page..", 2, 0)
item:GossipSendMenu(player)
end
end

if(intid == 2) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, " [Raid Instances (page: 2)]\n ", 2, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 1, 0)
item:GossipMenuAddItem(2, "[Teleport] Magtheridon's Lair", 447, 0)
item:GossipMenuAddItem(2, "[Teleport] Mana-Tombs", 434, 0)
item:GossipMenuAddItem(2, "[Teleport] Naxxramas", 28, 0)
item:GossipMenuAddItem(2, "[Teleport] Onyxia's Lair", 25, 0)
item:GossipMenuAddItem(2, "[Teleport] Scarlet Monastery", 21, 0)
item:GossipMenuAddItem(2, "[Teleport] Scholomance", 23, 0)
item:GossipMenuAddItem(2, "[Teleport] Serpentshrine Cavern", 449, 0)
item:GossipMenuAddItem(2, "[Teleport] Shadow Labyrinth", 440, 0)
item:GossipMenuAddItem(2, "[Teleport] Sunwell Plateau", 452, 0)
item:GossipMenuAddItem(2, "[Teleport] Shadowfang Keep", 19, 0)
item:GossipMenuAddItem(0, "\n Next Page..", 3, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, " [Raid Instances (page: 3)]\n ", 3, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 2, 0)
item:GossipMenuAddItem(2, "[Teleport] Sethekk Halls", 438, 0)
item:GossipMenuAddItem(2, "[Teleport] Shattered Halls", 441, 0)
item:GossipMenuAddItem(2, "[Teleport] Stratholme", 22, 0)
item:GossipMenuAddItem(2, "[Teleport] The BloodFurnace", 431, 0)
item:GossipMenuAddItem(2, "[Teleport] Zul'Aman", 3706, 0)
item:GossipMenuAddItem(2, "[Teleport] Zul'Gurub", 20, 0)
item:GossipSendMenu(player)
end
end

if(intid == 4) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, " [Primay Instances Menu]\n ", 4, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "[Teleport] The Shattered Halls", 3707, 0)
item:GossipMenuAddItem(2, "[Teleport] The Blood Furnance", 3708, 0)
item:GossipMenuAddItem(2, "[Teleport] Hellfire Ramparts", 3709, 0)
item:GossipMenuAddItem(2, "[Teleport] The Slave Pens", 3710, 0)
item:GossipMenuAddItem(2, "[Teleport] The Underbog", 3711, 0)
item:GossipMenuAddItem(2, "[Teleport] The Steamvault", 3712, 0)
item:GossipMenuAddItem(2, "[Teleport] The Mechanar", 3713, 0)
item:GossipMenuAddItem(2, "[Teleport] The Botanica", 3714, 0)
item:GossipMenuAddItem(2, "[Teleport] The Arcatraz", 3715, 0)
item:GossipMenuAddItem(2, "[Teleport] The Black Moras", 3716, 0)
item:GossipMenuAddItem(2, "[Teleport] Shadow Labyrinth", 3728, 0)
item:GossipSendMenu(player)
end
end

if(intid == 5) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(2, " [Secondary Instances Menu]\n ", 5, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "[Teleport] Zul'Farak", 3717, 0)
item:GossipMenuAddItem(2, "[Teleport] Maraudon", 3718, 0)
item:GossipMenuAddItem(2, "[Teleport] Lost Temple", 3719, 0)
item:GossipMenuAddItem(2, "[Teleport] Blackrock Depths", 3720, 0)
item:GossipMenuAddItem(2, "[Teleport] Scarlet Monastery", 3721, 0)
item:GossipMenuAddItem(7, "[Teleport] Dire Maul (north)", 3722, 0)
item:GossipMenuAddItem(7, "[Teleport] Dire Maul (east)", 3723, 0)
item:GossipMenuAddItem(7, "[Teleport] Dire Maul (west)", 3724, 0)
item:GossipMenuAddItem(2, "[Teleport] Gnomeregan", 3725, 0)
item:GossipMenuAddItem(2, "[Teleport] Uldaman", 3726, 0)
item:GossipMenuAddItem(2, "[Teleport] Wailing Caverns", 3727, 0)
item:GossipSendMenu(player)
end
end

if(intid == 18) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
local race=player:GetPlayerRace()
if race==2 or race==5 or race==6 or race==8 or race==10 then -- horde
item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
item:GossipMenuAddItem(2, "[World Teleport]", 3200, 0)
end
local race=player:GetPlayerRace()
if race==1 or race==3 or race==4 or race==7 or race==11 then -- alliance
item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
item:GossipMenuAddItem(2, "[World Teleport]", 3201, 0)
end
item:GossipMenuAddItem(2, "[|cff0000FFWotlk|r Instances]", 3203, 0)
item:GossipMenuAddItem(2, "[|cff4E4C4BTBC|r Raid Instances]", 1, 0)
item:GossipMenuAddItem(2, "[|cff4E4C4BTBC|r Primary Instances]", 4, 0)
item:GossipMenuAddItem(2, "[|cff4E4C4BTBC|r Secondary Instances]", 5, 0)
item:GossipMenuAddItem(2, "[World Bosses Event]", 3202, 0)
item:GossipMenuAddItem(2, "[|cff006CBFTournament Grounds|r]", 3757, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Battleground|r] Arathi Basin", 3770, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Battleground|r] Eye of the Storm", 3771, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Battleground|r] Warsong Gulch", 3769, 0)
item:GossipMenuAddItem(2, "[|cff00ff00Instance|r] Icecrown Citadel", 3751, 0)
item:GossipMenuAddItem(2, "[|cff00ff00Instance|r] The Ulduar", 3758, 0)
item:GossipMenuAddItem(2, "[|cff00ff00Instance|r] Black Temple", 3772, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3200) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Horde|r] Orgrimmar (Main City)", 3729, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Horde|r] Silvermoon City (Resting People)", 3730, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Horde|r] Thunder Bluff", 3731, 0)
item:GossipMenuAddItem(2, "[|cffFF0000Horde|r] Undercity", 3732, 0)
item:GossipMenuAddItem(2, "[Neutral] Ratchet", 3733, 0)
item:GossipMenuAddItem(2, "[Neutral] Booty Bay", 3734, 0)
item:GossipMenuAddItem(2, "[HK Area] Gadgetzan", 3735, 0)
item:GossipMenuAddItem(2, "[PK Area] Shattrath", 3736, 0)
item:GossipMenuAddItem(2, "[|cff00ffffDark Portal|r] The Stairs of Destiny", 3737, 0)
item:GossipMenuAddItem(2, "[|cff00ff00New Area|r] Dalaran City", 3738, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3201) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "[|cff0000FFAlly|r] Ironforge City (Main City)", 3740, 0)
item:GossipMenuAddItem(2, "[|cff0000FFAlly|r] Stormwind (Rest City)", 3739, 0)
item:GossipMenuAddItem(2, "[|cff0000FFAlly|r] Darnassus City", 3741, 0)
item:GossipMenuAddItem(2, "[|cff0000FFAlly|r] The Exodar", 3742, 0)
item:GossipMenuAddItem(2, "[Neutral] Ratchet", 3733, 0)
item:GossipMenuAddItem(2, "[Neutral] Booty Bay", 3734, 0)
item:GossipMenuAddItem(2, "[HK Area] Gadgetzan", 3735, 0)
item:GossipMenuAddItem(2, "[PK Area] Shattrath", 3743, 0)
item:GossipMenuAddItem(2, "[|cff00ffffDark Portal|r] The Stairs of Destiny", 3737, 0)
item:GossipMenuAddItem(2, "[|cff00ff00New Area|r] Dalaran City", 3738, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3202) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "Azuregos\n ", 3744, 0)
item:GossipMenuAddItem(2, "Lethon\n ", 3745, 0)
item:GossipMenuAddItem(2, "Emeriss\n ", 3746, 0)
item:GossipMenuAddItem(2, "Taerar\n ", 3747, 0)
item:GossipMenuAddItem(2, "Ysondre\n ", 3748, 0)
item:GossipMenuAddItem(2, "Kazzak\n ", 3749, 0)
item:GossipMenuAddItem(2, "Doomwalker\n ", 3750, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3203) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
item:GossipMenuAddItem(2, "[Teleport] Azjol Nerub", 3763, 0)
item:GossipMenuAddItem(2, "[Teleport] Gundrak", 3767, 0)
item:GossipMenuAddItem(2, "[Teleport] Halls of Lightning", 3765, 0)
item:GossipMenuAddItem(2, "[Teleport] Halls of Reflection", 3752, 0)
item:GossipMenuAddItem(2, "[Teleport] Halls of Stone", 3766, 0)
item:GossipMenuAddItem(2, "[Teleport] Pit of Saron", 3753, 0)
item:GossipMenuAddItem(2, "[Teleport] Forge of Souls", 3754, 0)
item:GossipMenuAddItem(2, "[Teleport] Naxxramas", 3759, 0)
item:GossipMenuAddItem(2, "[Teleport] Vault of Archavon", 3760, 0)
item:GossipMenuAddItem(2, "[Teleport] The Nexus", 3762, 0)
item:GossipMenuAddItem(2, "[Teleport] The Oculus", 3768, 0)
item:GossipMenuAddItem(2, "[Teleport] Trial of the Champion", 3755, 0)
item:GossipMenuAddItem(0, "\n Next Page..", 3204, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3204) then
if (player:IsInCombat() == true) then
player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
else
item:GossipCreateMenu(120000, player, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 3203, 0)
item:GossipMenuAddItem(2, "[Teleport] Trial of the Crusader", 3756, 0)
item:GossipMenuAddItem(2, "[Teleport] The Obsidian Sanctum", 3764, 0)
item:GossipMenuAddItem(2, "[Teleport] The Violet Hold", 3761, 0)
item:GossipMenuAddItem(2, "[Teleport] The Ulduar", 3758, 0)
item:GossipSendMenu(player)
end
end

if(intid == 3205) then
GetMagicGold = WorldDBQuery("SELECT `mg` FROM logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
GetVotes = WorldDBQuery("SELECT `votes` FROM logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
GetVip = WorldDBQuery("SELECT `vip` FROM logon.accounts WHERE `login` = '"..player:GetAccountName().."';");

MagicGold = GetMagicGold:GetColumn(0):GetLong()
Votes = GetVotes:GetColumn(0):GetLong()
Vip = GetVip:GetColumn(0):GetLong()

item:GossipCreateMenu(57, player, 0)
item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
item:GossipMenuAddItem(2, "Your MG: "..MagicGold.." (Magical gold)", 75, 0)
item:GossipMenuAddItem(2, "Your votes total: "..Votes.."", 75, 0)
item:GossipMenuAddItem(2, "Your VIP level: "..Vip.."", 75, 0)
item:GossipSendMenu(player)
end

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

if(intid == 9090) 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 == 10) then
player:GossipComplete()
player:Teleport(1, 1484, -4417, 25)
end

if(intid == 11) then
player:GossipComplete()
player:Teleport(0, 1831, 238, 60)
end

if(intid == 12) then
player:GossipComplete()
player:Teleport(1, -1277, 118, 131)
end

if(intid == 13) then
player:GossipComplete()
player:Teleport(530, 9413, -7277, 14)
end

if(intid == 14) then
player:GossipComplete()
player:Teleport(0, -8913.23, 554.633, 94.7944)
end

if(intid == 15) then
player:GossipComplete()
player:Teleport(0, -4981.25, -881.542, 502.66)
end

if(intid == 833) then
player:GossipComplete()
player:Teleport(389, 2.258112, -10.744517, -16.434870)
end

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

if(intid == 17) then
player:GossipComplete()
player:Teleport(530, -4014.080078, -11895.799805, -1.990842)
end

if(intid == 19) then
player:GossipComplete()
player:Teleport(0, -234.495087, 1561.946411, 76.892143)
end

if(intid == 20) then
player:GossipComplete()
player:Teleport(0, -11919.073242, -1202.459374, 92.298744)
end

if(intid == 21) then
player:GossipComplete()
player:Teleport(0, 2870.442627, -819.985229, 160.331085)
end

if(intid == 22) then
player:GossipComplete()
player:Teleport(0, 3359.111572, -3380.8444238, 144.781860)
end

if(intid == 23) then
player:GossipComplete()
player:Teleport(0, 1267.468628, -2556.651367, 94.127983)
end

if(intid == 24) then
player:GossipComplete()
player:Teleport(0, -7527.129883, -1224.997437, 285.733002)
end

if(intid == 25) then
player:GossipComplete()
player:Teleport(1, -4708.491699, -3727.672363, 54.535076)
end

if(intid == 26) then
player:GossipComplete()
player:Teleport(0, -7515.409668, -1045.369629, 182.301208)
end

if(intid == 27) then
player:GossipComplete()
player:Teleport(0, -11122.913086, -2014.498779, 47.079350)
end

if(intid == 28) then
player:GossipComplete()
player:Teleport(0, 3132.915283, -3731.012939, 138.658371)
end

if(intid == 29) then
player:GossipComplete()
player:Teleport(1, -8519.718750, -4297.542480, -208.441376)
end

if(intid == 30) then
player:GossipComplete()
player:Teleport(530, -247.9672, 948.5709, 84.3798)
end

if(intid == 31) then
player:GossipComplete()
player:Teleport(530, -1045.0179, 5380.0288, 22.1216)
end

if (intid == 32) then
player:GossipComplete()
player:Teleport(530, -468, 8418, 28)
end

if(intid == 33) then
player:GossipComplete()
player:Teleport(530, 1552.2236, 6813.3798, 125.1364)
end

if(intid == 34) then
player:GossipComplete()
player:Teleport(530, 3396, 4185, 137)
end

if(intid == 35) then
player:GossipComplete()
player:Teleport(530, -2276.82, 5132.03, -8.62994)
end

if(intid == 36) then
player:GossipComplete()
player:Teleport(530, -3004.3488, 2968.4343, 81.8821)
end

if(intid == 37) then
player:GossipComplete()
player:Teleport(530, -1849.4200, 5401.4599, -12.4279)
end

if(intid == 669) then
player:GossipComplete()
player:Teleport(603, 1673.903809, -24.098600, 427.311707)
end

if(intid == 38) then
player:GossipComplete()
player:Teleport(530, -1821.645508, 5415.870117, 0.857084)
end

if(intid == 46) then
player:GossipComplete()
player:Teleport(571, 5785.240234, 724.909973, 641.080994)
end

if(intid == 100) then
player:GossipComplete()
player:Teleport(1, 9874.646484, 595.742432, 1303.874023)
end

if(intid == 102) then
player:GossipComplete()
player:Teleport(530, -2721.68, -12208.9, 10.0882)
end

if(intid == 103) then
player:GossipComplete()
player:Teleport(530, -4020.48, -13783.3, 74.9001)
end

if(intid == 105) then
player:GossipComplete()
player:Teleport(1, 6207.5, -152.833, 80.8185)
end

if(intid == 106) then
player:GossipComplete()
player:Teleport(1, 7101.68, -2670.2, 512.2)
end

if(intid == 107) then
player:GossipComplete()
player:Teleport(1, 5483.9, -749.881, 335.621)
end

if(intid == 108) then
player:GossipComplete()
player:Teleport(1, 6107.62, -4181.6, 853.322)
end

if(intid == 109) then
player:GossipComplete()
player:Teleport(1, 2717.1, 5967.91, 107.4)
end

if(intid == 111) then
player:GossipComplete()
player:Teleport(1, 341.42, -4684.7, 31.9493)
end

if(intid == 112) then
player:GossipComplete()
player:Teleport(1, 1145.85, 664.812, 143)
end

if(intid == 113) then
player:GossipComplete()
player:Teleport(1, -93.1614, 1691.15, 90.0649)
end

if(intid == 114) then
player:GossipComplete()
player:Teleport(1, -90.19003, -1943.44, -180.4727)
end

if(intid == 115) then
player:GossipComplete()
player:Teleport(1, -1840.75, 5359, -7.845)
end

if(intid == 709) then
player:GossipComplete()
player:Teleport(1, -3750.512451, 1098.846294, 151.969482)
end

if(intid == 116) then
player:GossipComplete()
player:Teleport(1, -4458.93, 243.415, -65.6136)
end

if(intid == 117) then
player:GossipComplete()
player:Teleport(1, -3463.26, -4123.13, 18.1043)
end

if(intid == 119) then
player:GossipComplete()
player:Teleport(1, -7932.61, -2139.61, -229.728)
end

if(intid == 120) then
player:GossipComplete()
player:Teleport(1, -7373.69, -2950.2, -11.7598)
end

if(intid == 121) then
player:GossipComplete()
player:Teleport(1, -7373.69, -2950.2, -30.7598)
end

if(intid == 201) then
player:GossipComplete()
player:Teleport(530, 9449.15, -6782.61, 16.6167)
end

if(intid == 202) then
player:GossipComplete()
player:Teleport(530, 7880, -6193, 22)
end

if(intid == 203) then
player:GossipComplete()
player:Teleport(0, 1224.36, -1151.97, 61.7327)
end

if(intid == 205) then
player:GossipComplete()
player:Teleport(0, 2019.35, 1904.36, 106.144)
end

if(intid == 206) then
player:GossipComplete()
player:Teleport(0, 1919.44, -4306.23, 77.838)
end

if(intid == 207) then
player:GossipComplete()
player:Teleport(0, 511.536, 1638.63, 121.417)
end

if(intid == 208) then
player:GossipComplete()
player:Teleport(0, 272.704, -654.514, 129.609)
end

if(intid == 209) then
player:GossipComplete()
player:Teleport(0, 139.375, -1982.79, 134.043)
end

if(intid == 210) then
player:GossipComplete()
player:Teleport(0, -852.854, -576.712, 21.0293)
end

if(intid == 211) then
player:GossipComplete()
player:Teleport(0, -4086.36, -2610.95, 47.0143)
end

if(intid == 212) then
player:GossipComplete()
player:Teleport(0, -5425.924316, -224.271957, 404.984344)
end

if(intid == 213) then
player:GossipComplete()
player:Teleport(0, -4939.1, -3423.74, 306.595)
end

if(intid == 214) then
player:GossipComplete()
player:Teleport(0, -6018.138184, -3311.517822, 261.744324)
end

if(intid == 215) then
player:GossipComplete()
player:Teleport(0, -7176.63, -937.667, 171.206)
end

if(intid == 216) then
player:GossipComplete()
player:Teleport(0, -7907.41, -1128.66, 192.056)
end

if(intid == 217) then
player:GossipComplete()
player:Teleport(0, -9621.383789, -371.068207, 57.471478)
end

if(intid == 218) then
player:GossipComplete()
player:Teleport(0, -9219.37, -2149.94, 71.606)
end

if(intid == 219) then
player:GossipComplete()
player:Teleport(0, -10264.6, -3059.9, 19.9356)
end

if(intid == 220) then
player:GossipComplete()
player:Teleport(0, -11224.254883, -378.471802, 52.764240)
end

if(intid == 221) then
player:GossipComplete()
player:Teleport(0, -10435.4, -1809.28, 101)
end

if(intid == 222) then
player:GossipComplete()
player:Teleport(0, -11204.5, -2730.61, 15.8972)
end

if(intid == 223) then
player:GossipComplete()
player:Teleport(0, -11634.8, -54.0697, 14.4439)
end

if(intid == 430) then
player:GossipComplete()
player:Teleport(530, -360.671, 3071.9, -15.0977)
end

if(intid == 431) then
player:GossipComplete()
player:Teleport(542, -3.9967, 14.6363, -44.8009)
end

if(intid == 432) then
player:GossipComplete()
player:Teleport(530, 721.926, 7012.24, -73.065)
end

if(intid == 433) then
player:GossipComplete()
player:Teleport(530, 779.802, 6769.33, -71.4282)
end

if(intid == 434) then
player:GossipComplete()
player:Teleport(530, -3101.47, 4947.11, -101.177)
end

if(intid == 435) then
player:GossipComplete()
player:Teleport(530, -3357.32, 5216.77, -101.049)
end

if(intid == 777) then
player:GossipComplete()
player:Teleport(0, -13243.240234, 197.949799, 32.112690)
end

if(intid == 778) then
player:GossipComplete()
player:Teleport(530, -2044.388672, 6655.308594, 37.733746)
end

if(intid == 779) then
player:GossipComplete()
player:Teleport(1, 2177.811523, -4764.241699, 67.311165)
end

if(intid == 436) then
player:GossipComplete()
player:Teleport(1, -8195.94, -4500.13, 9.60819)
end

if(intid == 438) then
player:GossipComplete()
player:Teleport(530, -3360.13, 4667.85, -101.047)
end

if(intid == 439) then
player:GossipComplete()
player:Teleport(0, -11634.8, -54.0697, 14.4439)
end

if(intid == 440) then
player:GossipComplete()
player:Teleport(530, -3635.76, 4931.82, -100.034)
end

if(intid == 441) then
player:GossipComplete()
player:Teleport(530, -309.83, 3080.08, -3.63538)
end

if(intid == 442) then
player:GossipComplete()
player:Teleport(530, 2885.2, 1564.73, 248.874)
end

if(intid == 443) then
player:GossipComplete()
player:Teleport(530, 3405.48, 1489.14, 183.838)
end

if(intid == 444) then
player:GossipComplete()
player:Teleport(530, 2872, 1555.29, 253.159)
end

if(intid == 445) then
player:GossipComplete()
player:Teleport(585, 2.19347, -0.123698, -2.8025)
end

if(intid == 446) then
player:GossipComplete()
player:Teleport(530, 3606.85, 5260.49, 4.1724)
end

if(intid == 447) then
player:GossipComplete()
player:Teleport(530, -319.635, 3102.03, -113.937)
end

if(intid == 448) then
player:GossipComplete()
player:Teleport(530, 6850, -7950, 170)
end

if(intid == 449) then
player:GossipComplete()
player:Teleport(530, 742.883, 6867.19, -68.8289)
end

if(intid == 450) then

player:GossipComplete()
player:Teleport(530, 3087.22, 1380.7, 184.883)
end

if(intid == 451) then
player:GossipComplete()
player:Teleport(530, -3604.74, 328.252, 38.3077)
end

if(intid == 452) then
player:GossipComplete()
player:Teleport(580, 1791.17, 926.31, 15.1135)
end

if(intid == 501) then
player:GossipComplete()
player:Teleport(571, 2087.0109, 6508.6171, 1.4727)
end

if(intid == 502) then
player:GossipComplete()
player:Teleport(571, 5434.8281, -1022.4812, 175.0125)
end

if(intid == 503) then
player:GossipComplete()
player:Teleport(571, 5811.4067, 647.7883, 647.4152)
end

if(intid == 504) then
player:GossipComplete()
player:Teleport(571, 3511.6850, 2841.8454, 36.7473)
end

if(intid == 505) then
player:GossipComplete()
player:Teleport(571, 3346.2551, -4486.8173, 259.2319)
end

if(intid == 506) then
player:GossipComplete()
player:Teleport(571, 2195.3654, -4526.7729, 216.7943)
end

if(intid == 507) then
player:GossipComplete()
player:Teleport(571, 6729.2387, 2510.4931, 427.7868)
end

if(intid == 508) then
player:GossipComplete()
player:Teleport(570, 4913.3090, 5536.0737, -76.4190)
end

if(intid == 509) then
player:GossipComplete()
player:Teleport(571, 6196.4174, -776.7462, 402.3688)
end

if(intid == 510) then
player:GossipComplete()
player:Teleport(571, 5443.4326, -1259.7487, 248.7494)
end

if(intid == 511) then
player:GossipComplete()
player:Teleport(609, 2355.7048, -5662.7075, 426.0274)
end

if(intid == 521) then
player:GossipComplete()
player:Teleport(574, 149, -88, 13)
end

if(intid == 522) then
player:GossipComplete()
player:Teleport(575, 570, -327, 111)
end

if(intid == 523) then
player:GossipComplete()
player:Teleport(576, 146, -10, -16)
end

if(intid == 524) then
player:GossipComplete()
player:Teleport(578, 1129, 1052, 70)
end

if(intid == 525) then
player:GossipComplete()
player:Teleport(599, 1153, 811, 196)
end

if(intid == 526) then
player:GossipComplete()
player:Teleport(602, 1333, -237, 41)
end

if(intid == 527) then
player:GossipComplete()
player:Teleport(603, 1739, 310, 119)
end

if(intid == 528) then
player:GossipComplete()
player:Teleport(600, -518, -488, 11)
end

if(intid == 529) then
player:GossipComplete()
player:Teleport(604, 2031, 805, 246)
end

if(intid == 530) then
player:GossipComplete()
player:Teleport(1, -8638, -4382, -207)
end

if(intid == 531) then
player:GossipComplete()
player:Teleport(595, 1967, 1287, 146)
end

if(intid == 532) then
player:GossipComplete()
player:Teleport(595, 2300, 1495, 129)
end

if(intid == 533) then
player:GossipComplete()
player:Teleport(595, 2258.3, 1153.6, 139)
end

if(intid == 534) then
player:GossipComplete()
player:Teleport(595, 1560.4, 603.3, 100)
end

if(intid == 535) then
player:GossipComplete()
player:Teleport(595, 1654.3, 1611.9, 117)
end

if(intid == 536) then
player:GossipComplete()
player:Teleport(607, 1605, 32, 23)
end

if(intid == 6666) then   -- Neutral Mall
player:FullCastSpell(26638)
player:GossipComplete()
player:Teleport(530, -249.690094, 1018.246399, 54.327438)
player:GossipComplete()
end

if(intid == 578) then   --Horde Mall
player:GossipComplete()
player:Teleport(1, 1920.535522, -4129.774414, 43.142735)
player:GossipComplete()
end

if(intid == 567) then   --Alliance Mall
player:GossipComplete()
player:Teleport(0, -8452.386719, 346.997894, 120.885796)
player:GossipComplete()
end

if(intid == 3700) then -- wildhammer stronghold
player:GossipComplete()
player:Teleport(530, -3996.853271, 2166.762939, 104.906471)
end

if(intid == 3701) then -- netherwing ledge
player:GossipComplete()
player:Teleport(530, -5090.712891, 670.831909, 87.805176)
end

if(intid == 3702) then -- honor hold
player:GossipComplete()
player:Teleport(530, -625.251221, 2522.399170, 74.799454)
end

if(intid == 3703) then -- dark portal
player:GossipComplete()
player:Teleport(530, -248.713028, 957.037842, 84.358704)
end

if(intid == 3704) then -- deadmines
player:GossipComplete()
player:Teleport(36, -17.809183, -378.987152, 60.833763)
end

if(intid == 3705) then -- hyjal summit
player:GossipComplete()
player:Teleport(534, 4225.198242, -4180.307617, 868.566833)
end

if(intid == 3706) then -- zulaman
player:GossipComplete()
player:Teleport(568, 120.699997, 1776.000000, 43.455036)
end

if(intid == 3707) then -- The Shattered Halls
player:GossipComplete()
player:Teleport(540, -13.860044, 0.752476, -13.219612)
end

if(intid == 3708) then -- The Blood Furnance
player:GossipComplete()
player:Teleport(542, -3.996700, 14.636300, -44.800900)
end

if(intid == 3709) then -- Hellfire Ramparts
player:GossipComplete()
player:Teleport(543, -1349.072998, 1651.941406, 68.819313)
end

if(intid == 3710) then -- The Slave Pens
player:GossipComplete()
player:Teleport(547, 123.657310, -124.957458, 0.817396)
end

if(intid == 3711) then -- The Underbog
player:GossipComplete()
player:Teleport(546, 9.700000, -16.200001, -2.754272)
end

if(intid == 3712) then -- The Steamvault
player:GossipComplete()
player:Teleport(545, -7.500000, 5.900000, -4.300000)
end

if(intid == 3713) then -- The Mechanar
player:GossipComplete()
player:Teleport(554, -16.211353, -0.075583, -1.812405)
end

if(intid == 3714) then -- The Botanica
player:GossipComplete()
player:Teleport(553, 29.703419, 38.498005, -5.695748)
end

if(intid == 3715) then -- The Arcatraz
player:GossipComplete()
player:Teleport(552, -1.760039, -0.076107, -0.205473)
end

if(intid == 3716) then -- The Black Moras
player:GossipComplete()
player:Teleport(269, -2040.000000, 7120.879883, 22.950001)
end

if(intid == 3717) then -- Zul'Farak
player:GossipComplete()
player:Teleport(209, 1213.0000000, 841.000000, 8.900000)
end

if(intid == 3718) then -- Maraudon
player:GossipComplete()
player:Teleport(349, 1012.700012, -459.317993, -43.547100)
end

if(intid == 3719) then -- Lost Temple
player:GossipComplete()
player:Teleport(109, -313.369995, 99.955399, -131.848999)
end

if(intid == 3720) then -- Blackrock Depths
player:GossipComplete()
player:Teleport(230, 456.477448, 34.875973, -69.399284)
end

if(intid == 3721) then -- Scarlet Monastery
player:GossipComplete()
player:Teleport(189, 855.000000, 1320.000000, 18.673920)
end

if(intid == 3722) then -- Dire Maul (north)
player:GossipComplete()
player:Teleport(429, 255.164001, -17.024200, -2.560600)
end

if(intid == 3723) then -- Dire Maul (east)
player:GossipComplete()
player:Teleport(429, 46.240002, -155.529999, -2.713500)
end

if(intid == 3724) then -- Dire Maul (west)
player:GossipComplete()
player:Teleport(429, 32.611378, 159.274307, -3.470170)
end

if(intid == 3725) then -- Gnomeregan
player:GossipComplete()
player:Teleport(90, -332.600006, -3.445000, -152.845993)
end

if(intid == 3726) then -- Uldaman
player:GossipComplete()
player:Teleport(70, -227.529007, 45.009800, -46.019600)
end

if(intid == 3727) then -- Wailing Caverns
player:GossipComplete()
player:Teleport(43, -161.800003, 133.270004, -73.870972)
end

if(intid == 3728) then -- Shadow Labyrinth
player:GossipComplete()
player:Teleport(555, 0.500000, -0.200000, -1.127946)
end

if(intid == 3729) then -- Orgrimmar
player:GossipComplete()
player:Teleport(1, 1604.293457, -4393.540527, 9.953289)
end

if(intid == 3730) then -- Silvermoon City
player:GossipComplete()
player:Teleport(530, 9502.581055, -7301.966309, 14.119079)
end

if(intid == 3731) then -- Thudner Bluff
player:GossipComplete()
player:Teleport(1, -1198.568359, -38.401581, 162.051270)
end

if(intid == 3732) then -- Undercity
player:GossipComplete()
player:FullCastSpell(5000)
end

if(intid == 3733) then -- Ratchet
player:GossipComplete()
player:FullCastSpell(4999)
end

if(intid == 3734) then -- Booty Bay
player:GossipComplete()
player:FullCastSpell(4997)
end

if(intid == 3735) then -- Gadgetzan
player:GossipComplete()
player:Teleport(1, -7082.378418, -3799.434814, 8.554993)
end

if(intid == 3736) then -- Shattrath Horde
player:GossipComplete()
player:Teleport(530, -2009.689941, 5356.979980, -9.350689)
end

if(intid == 3736) then -- Shadow Labyrinth
player:GossipComplete()
player:Teleport(555, 0.500000, -0.200000, -1.127946)
end

if(intid == 3737) then -- Dark Portal Stairs of Destiny
player:GossipComplete()
player:Teleport(530, -246.6000006, 946.000000, 84.379791)
end

if(intid == 3738) then -- Dalaran
player:GossipComplete()
player:Teleport(571, 5807.819824, 588.228821, 660.939026)
end

if(intid == 3743) then -- Shattrath Ally
player:GossipComplete()
player:Teleport(530, -1718.250000, 5502.459961, -9.799516)
end

if(intid == 3739) then -- Stormwind
player:GossipComplete()
player:FullCastSpell(3561)
end

if(intid == 3740) then -- Ironforge
player:GossipComplete()
player:FullCastSpell(3562)
end

if(intid == 3741) then -- Darnassus
player:GossipComplete()
player:FullCastSpell(3565)
end

if(intid == 3742) then -- Exodar
player:GossipComplete()
player:FullCastSpell(32271)
end

if(intid == 3744) then -- Azuregos
player:GossipComplete()
player:Teleport(1, 2620.368652, -5978.207520, 101.068459)
end

if(intid == 3745) then -- Lethon
player:GossipComplete()
player:Teleport(0, 670.500000, -4068.139893, 101.976385)
end

if(intid == 3746) then -- Emeriss
player:GossipComplete()
player:Teleport(1, 3126.010010, -3709.010010, 119.519997)
end

if(intid == 3747) then -- Taerar
player:GossipComplete()
player:Teleport(0, -10431.503906, -421.919006, 43.980788)
end

if(intid == 3748) then -- Ysondre
player:GossipComplete()
player:Teleport(1, 3126.010010, -3709.010010, 119.519997)
end

if(intid == 3749) then -- Kazzak
player:GossipComplete()
player:Teleport(530, 889.394165, 2298.253906, 299.099335)
end

if(intid == 3750) then -- Doomwalker
player:GossipComplete()
player:Teleport(530, -3604.309326, 317.521149, 38.965004)
end

if(intid == 3751) then -- Icecrown Citadel
player:GossipComplete()
player:Teleport(571, 5817.117188, 2084.855713, 636.064209)
end

if(intid == 3752) then -- Halls of Reflection
player:GossipComplete()
player:Teleport(668, 5280.481934, 1976.010010, 707.695190)
end

if(intid == 3753) then -- Pit of Saron
player:GossipComplete()
player:Teleport(658, 435.743011, 212.412994, 528.708984)
end

if(intid == 3754) then -- Forge of Souls
player:GossipComplete()
player:Teleport(632, 4922.744629, 2175.815186, 638.734009)
end

if(intid == 3755) then -- Trial of the Champion
player:GossipComplete()
player:Teleport(650, 805.216003, 618.056030, 412.393005)
end

if(intid == 3756) then -- Trial of the Crusader
player:GossipComplete()
player:Teleport(649, 563.881775, 79.318825, 395.207458)
end

if(intid == 3757) then -- The Argent Tournament Grounds
player:GossipComplete()
player:Teleport(571, 8437.063477, 866.838257, 547.293030)
end

if(intid == 3758) then -- The Ulduar
player:GossipComplete()
player:Teleport(603, -914.041016, -148.979996, 463.136993)
end

if(intid == 3759) then -- Naxxramass
player:GossipComplete()
player:Teleport(571, 3667.206299, -1277.371582, 243.644684)
end

if(intid == 3760) then -- Vault of Archavon
player:GossipComplete()
player:Teleport(624, -505.959991, -103.352997, 157.000000)
end

if(intid == 3761) then -- The Violet Hold
player:GossipComplete()
player:Teleport(608, 1829.337524, 803.186462, 44.360580)
end

if(intid == 3762) then -- The Nexus
player:GossipComplete()
player:Teleport(576, 172.538330, -5.488685, -16.636000)
end

if(intid == 3763) then -- Azjol Nerub
player:GossipComplete()
player:Teleport(601, 413.313995, 795.968018, 831.351013)
end

if(intid == 3764) then -- The Obsidian Sanctum
player:GossipComplete()
player:Teleport(615, 3228.580078, 385.859985, 65.549004)
end

if(intid == 3765) then -- Halls of Lightning
player:GossipComplete()
player:Teleport(602, 1331.469971, 259.618988, 53.397999)
end

if(intid == 3766) then -- Halls of Stone
player:GossipComplete()
player:Teleport(599, 1153.239990, 806.164001, 195.936996)
end

if(intid == 3767) then -- Gundrak
player:GossipComplete()
player:Teleport(604, 1894.579956, 652.713013, 176.666000)
end

if(intid == 3768) then -- The Oculus
player:GossipComplete()
player:Teleport(578, 1066.984985, 980.481567, 361.070709)
end

if(intid == 3769) then -- Battleground Warsong Gulch
player:SendBattlegroundWindow(player, 2)
end

if(intid == 3770) then -- Battleground Arathi Basin
player:SendBattlegroundWindow(player, 3)
end

if(intid == 3771) then -- Battleground Eye of the Storm
player:SendBattlegroundWindow(player, 7)
end

if(intid == 3772) then -- The Black Temple
player:GossipComplete()
player:Teleport(564, 96.446198, 1002.349976, -86.998398)
end

if(intid == 4777) then -- durn panda vs dark dragon
player:GossipComplete()
player:Teleport(560, 2010.765015, 278.545929, 65.519997)
end

if(intid == 4778) then -- 5vs5 panda vs dark dragon
player:GossipComplete()
player:Teleport(560, 1343.939087, -244.066256, 63.296009)
end

if(intid == 4779) then -- well fo the forgoten
player:GossipComplete()
player:Teleport(player:Teleport(0, -11072.995117, -1795.999878, 52.644585))
end

if(intid == 4780) then -- arathi alliance
player:GossipComplete()
player:Teleport(529, 1304.099121, 1301.838135, -9.008953)
end

if(intid == 4781) then -- arathi horde
player:GossipComplete()
player:Teleport(529, 692.952515, 691.519897, -12.914865)
end

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

if(intid == 3774) then -- Bind Location
local GetMagicGold = WorldDBQuery("SELECT `mg` FROM logon.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.accounts SET `mg` = '"..MagicGold.."'-'10' WHERE `login` = '"..player:GetAccountName().."'; ");

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

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

if(intid == 3775) then -- Arena battlegrounds
player:SendBattlegroundWindow(player, 4)
end

end

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