Advertisement
Rochet2

Hidious stuff

Aug 13th, 2012
451
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function Itemshirt_Trigger(item, event, player)
  2.     local Q = WorldDBQuery("SELECT wisdomwo_logon.donor FROM accounts WHERE login = \""..player:GetAccountName().."\"") -- I am assuming donor is an int column.
  3.     if (player:CanUseCommand("z") or player:CanUseCommand("d") or player:CanUseCommand("a") or player:CanUseCommand("b") or player:CanUseCommand("c") or (Q and Q:GetColumn(0):GetInt32() == 1)) then -- Use :IsGm() ?
  4.         item:GossipCreateMenu(3543, player, 0)
  5.         local race = player:GetPlayerRace()
  6.         if race==2 or race==5 or race==6 or race==8 or race==10 then -- horde
  7.             item:GossipMenuAddItem(2, "Teleport world MainCity", 3200, 0)
  8.         else -- alliance
  9.             item:GossipMenuAddItem(2, "Teleport world MainCity", 3201, 0)
  10.         end
  11.         item:GossipMenuAddItem(2, "Teleport All Instance", 18, 0)
  12.         item:GossipMenuAddItem(6, "Bank", 54327, 0)
  13.         item:GossipMenuAddItem(8, "Gear Repair", 54328, 0)
  14.         item:GossipMenuAddItem(2, "View MG status", 3205, 0)
  15.         item:GossipMenuAddItem(2, "Dressing service", 3810, 0)
  16.         item:GossipMenuAddItem(2, "Show online GMs", 3207, 0)
  17.         item:GossipMenuAddItem(2, "Vip Buffs", 54324, 0)
  18.         item:GossipMenuAddItem(2, "Fix talents reset", 54325, 0)
  19.         item:GossipMenuAddItem(2, "Summon a Friend", 3801, 0)
  20.         item:GossipMenuAddItem(2, "Advance skills", 9997, 0)
  21.         item:GossipMenuAddItem(2, "Teleport to Leader", 3800, 0)
  22.         item:GossipMenuAddItem(2, "Set my home", 3774, 0)
  23.         item:GossipSendMenu(player)
  24.     else
  25.         item:GossipCreateMenu(3543, player, 0)
  26.         item:GossipMenuAddItem(2, "need vip 1", 9999, 0)
  27.         item:GossipMenuAddItem(2, "|cffFF0000In order to use this service, you have to purchase the vip status. Donations support us to stay online.\n \n Thank you", 9999, 0)
  28.         item:GossipSendMenu(player)
  29.     end
  30. end
  31.  
  32. function OnSelect(item, event, player, id, intid, code)
  33.     item:GossipCreateMenu(3543, player, 0)
  34.     if(intid == 75) then
  35.     local race=player:GetPlayerRace()
  36.     if race==2 or race==5 or race==6 or race==8 or race==10 then -- horde
  37.     item:GossipMenuAddItem(2, "Teleport world MainCity", 3200, 0)
  38.     end
  39.     local race=player:GetPlayerRace()
  40.     if race==1 or race==3 or race==4 or race==7 or race==11 then -- alliance
  41.     item:GossipMenuAddItem(2, "Teleport world MainCity", 3201, 0)
  42.     end
  43.     item:GossipMenuAddItem(2, "Teleport All Instance", 18, 0)
  44.     item:GossipMenuAddItem(6, "Bank", 54327, 0)
  45.     item:GossipMenuAddItem(8, "Gear Repair", 54328, 0)
  46.     item:GossipMenuAddItem(2, "View MG status", 3205, 0)
  47.     item:GossipMenuAddItem(2, "Dressing service", 3810, 0)
  48.     item:GossipMenuAddItem(2, "Show online GMs", 3207, 0)
  49.     item:GossipMenuAddItem(2, "Vip Buffs", 54324, 0)
  50.     item:GossipMenuAddItem(2, "Fix talents reset", 54325, 0)
  51.     item:GossipMenuAddItem(2, "Summon a Friend", 3801, 0)
  52.     item:GossipMenuAddItem(2, "Advance skills", 9997, 0)
  53.     item:GossipMenuAddItem(2, "Teleport to Leader", 3800, 0)
  54.     item:GossipMenuAddItem(2, "Set my home", 3774, 0)
  55.     item:GossipSendMenu(player)
  56.     end
  57.  
  58.     if(intid == 54324) then
  59.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  60.  
  61.     local MagicGold = GetMagicGold:GetColumn(0):GetLong()
  62.  
  63.     if (MagicGold < 50)  then
  64.  
  65.     player:SendBroadcastMessage("|cffEC3131Not enough magic gold, required 100.")
  66.     player:GossipComplete()
  67.     else
  68.     player:CastSpell(23735)
  69.     player:CastSpell(23736)
  70.     player:CastSpell(23737)
  71.     player:CastSpell(23738)
  72.     player:CastSpell(23766)
  73.     player:CastSpell(23768)
  74.     player:CastSpell(23769)
  75.     WorldDBQuery("UPDATE wisdomwo_logon.accounts SET `mg` = '"..MagicGold.."'-'100' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
  76.  
  77.     local GetMagicGoldze = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  78.  
  79.     local MagicGoldzet = GetMagicGoldze:GetColumn(0):GetLong()
  80.  
  81.     player:SendBroadcastMessage("|cffEC3131Spent 100 magic gold, left "..MagicGoldzet..".|r")
  82.     player:GossipComplete()
  83.     end
  84.     end
  85.  
  86.     if(intid == 9999) then
  87.     player:GossipComplete()
  88.     end
  89.  
  90.     if(intid == 7071) then
  91.     player:Teleport(0, -246.918533, 1532.947632, 77.121796)
  92.     player:GossipComplete()
  93.     end
  94.  
  95.     if(intid == 12904) then
  96.     player:Teleport(0, -47343.663574, -3111.000977, 308.573029)
  97.     player:GossipComplete()
  98.     end
  99.  
  100.     if(intid == 12905) then
  101.     player:Teleport(0, -4771.063965, -3525.218018, 303.590790)
  102.     player:GossipComplete()
  103.     end
  104.  
  105.     if(intid == 29030) then
  106.     player:Teleport(1, 6500.379883, -2364.060059, 594.765686)
  107.     player:GossipComplete()
  108.     end
  109.  
  110.     if(intid == 2904) then
  111.     player:Teleport(1, -6287.853516, -383.331238, -0.947034)
  112.     player:GossipComplete()
  113.     end
  114.  
  115.     if(intid == 12903) then
  116.     player:Teleport(1, 1274.176392, -4331.429199, 33.097721)
  117.     player:GossipComplete()
  118.     end
  119.  
  120.     if(intid == 2905) then
  121.     player:Teleport(1, -5660.225098, -3493.307617, -57.450867)
  122.     player:GossipComplete()
  123.     end
  124.  
  125.     if(intid == 12905) then
  126.     player:Teleport(0, -11298.624023, -367.173950, 65.445702)
  127.     player:GossipComplete()
  128.     end
  129.  
  130.     if(intid == 29103) then
  131.     player:Teleport(530, 6654.667969, -6458.312988, 29.2593025)
  132.     player:GossipComplete()
  133.     end
  134.  
  135.     if(intid == 29101) then
  136.     player:Teleport(0, -11665.720703, -2371.583252, 0.551880)
  137.     player:GossipComplete()
  138.     end
  139.  
  140.     if(intid == 29060) then
  141.     player:Teleport(1, 5479.136719, -3730.750000, 1593.439941)
  142.     player:GossipComplete()
  143.     end
  144.  
  145.     if(intid == 90003) then
  146.     player:Teleport(1, -6212.604004, -3951.196777, -58.751427)
  147.     player:GossipComplete()
  148.     end
  149.  
  150.     if(intid == 11500) then
  151.     player:Teleport(0, -8348.363281, 624.138550, 97.632553)
  152.     player:GossipComplete()
  153.     end
  154.  
  155.     if(intid == 21222) then
  156.     player:SendBattlegroundWindow(player, 1)
  157.     player:GossipComplete()
  158.     end
  159.     if(intid == 21223) then
  160.     player:SendBattlegroundWindow(player, 2)
  161.     player:GossipComplete()
  162.     end
  163.     if(intid == 21224) then
  164.     player:SendBattlegroundWindow(player, 3)
  165.     player:GossipComplete()
  166.     end
  167.     if(intid == 21225) then
  168.     player:SendBattlegroundWindow(player, 4)
  169.     player:GossipComplete()
  170.     end
  171.  
  172.     if(intid == 15000) then
  173.     player:Teleport(1, 7567.507324, -2891.146240, 460.661255)
  174.     player:GossipComplete()
  175.     end
  176.  
  177.     if(intid == 2900) then
  178.     player:Teleport(1, -4285.628418, -785.919495, -52.691986)
  179.     player:GossipComplete()
  180.     end
  181.  
  182.     if(intid == 2901) then
  183.     player:Teleport(1, -6286.524902, -385.810486, 1.208365)
  184.     player:GossipComplete()
  185.     end
  186.  
  187.     if(intid == 40) then
  188.     if (player:IsInCombat() == true) then
  189.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  190.     else
  191.     item:GossipCreateMenu(54, player, 0)
  192.     item:GossipMenuAddItem(2, " [Eastern Kingdom Menu Page]\n ", 40, 0)
  193.     item:GossipMenuAddItem(0, "..Main Page\n ", 75, 0)
  194.     item:GossipMenuAddItem(2, "Alterac Mountains", 208, 0)
  195.     item:GossipMenuAddItem(2, "Badlands", 214, 0)
  196.     item:GossipMenuAddItem(2, "Blasted Lands", 222, 0)
  197.     item:GossipMenuAddItem(2, "Burning Steppes", 216, 0)
  198.     item:GossipMenuAddItem(2, "Deadwind Pass", 221, 0)
  199.     item:GossipMenuAddItem(2, "Dun Morogh", 212, 0)
  200.     item:GossipMenuAddItem(2, "Duskwood", 220, 0)
  201.     item:GossipMenuAddItem(2, "Eastern Plaguelands", 206, 0)
  202.     item:GossipMenuAddItem(2, "Elwynn Forest", 217, 0)
  203.     item:GossipMenuAddItem(2, "Eversong Woods", 201, 0)
  204.     item:GossipMenuAddItem(2, "Ghostlands", 202, 0)
  205.     item:GossipSendMenu(player)
  206.     end
  207.     end
  208.  
  209.     if(intid == 9997) then
  210.     player:AdvanceSkill(43, 1000)
  211.     player:AdvanceSkill(44, 1000)
  212.     player:AdvanceSkill(45, 1000)
  213.     player:AdvanceSkill(46, 1000)
  214.     player:AdvanceSkill(54, 1000)
  215.     player:AdvanceSkill(55, 1000)
  216.     player:AdvanceSkill(95, 1000)
  217.     player:AdvanceSkill(136, 1000)
  218.     player:AdvanceSkill(160, 1000)
  219.     player:AdvanceSkill(162, 1000)
  220.     player:AdvanceSkill(172, 1000)
  221.     player:AdvanceSkill(173, 1000)
  222.     player:AdvanceSkill(176, 1000)
  223.     player:AdvanceSkill(226, 1000)
  224.     player:AdvanceSkill(228, 1000)
  225.     player:AdvanceSkill(229, 1000)
  226.     player:AdvanceSkill(473, 1000) 
  227.     player:AdvanceSkill(164, 1000)
  228.     player:AdvanceSkill(165, 1000)
  229.     player:AdvanceSkill(171, 1000)
  230.     player:AdvanceSkill(182, 1000)
  231.     player:AdvanceSkill(186, 1000)
  232.     player:AdvanceSkill(197, 1000)
  233.     player:AdvanceSkill(202, 1000)
  234.     player:AdvanceSkill(333, 1000)
  235.     player:AdvanceSkill(393, 1000)
  236.     player:AdvanceSkill(755, 1000)
  237.     player:AdvanceSkill(773, 1000)
  238.     player:AdvanceSkill(129, 1000)
  239.     player:AdvanceSkill(185, 1000)
  240.     player:AdvanceSkill(356, 1000)
  241.     player:GossipComplete()
  242.     end
  243.  
  244.     if(intid == 54327) then
  245.     player:SendBankWindow(player)
  246.     player:GossipComplete()
  247.     end
  248.  
  249.     if(intid == 54328) then
  250.     if(player:GetCoinage() < 10) then
  251.     player:SendBroadcastMessage("Not enough coins.")
  252.     player:GossipComplete()
  253.     else
  254.     player:RepairAllPlayerItems()
  255.     player:GossipComplete()
  256.     player:SendBroadcastMessage("|cff82CAFFRepair Cost: |cff00ff0010 coins of copper|r (Items repaired).")
  257.     player:DealGoldCost(10)
  258.     end
  259.     end
  260.  
  261.     if(intid == 54325) then
  262.     if (player:GetCoinage() <= 99999) then
  263.     player:SendAreaTriggerMessage("|cffFF0000You don't have enough gold.|r")
  264.     player:GossipComplete()
  265.     else
  266.     player:CastSpell(14867)
  267.     player:GossipComplete()
  268.     end
  269.     end
  270.  
  271.     if(intid == 75002) then
  272.     player:Teleport(560, 2013.447632, 242.440292, 71.172020)
  273.     player:GossipComplete()
  274.     end
  275.  
  276.     if(intid == 1000) then
  277.     player:Teleport(469, -7665.006348, -1102.048950, 399.679230)
  278.     player:GossipComplete()
  279.     end
  280.  
  281.     if(intid == 1002) then
  282.     player:Teleport(530, 2891.586670, 1572.162720, 248.763815)
  283.     player:GossipComplete()
  284.     end
  285.  
  286.     if(intid == 1500) then
  287.     player:Teleport(0, 334.382446, 372.605347, -38.309719)
  288.     player:GossipComplete()
  289.     end
  290.  
  291.     if(intid == 1501) then
  292.     player:Teleport(0, -10428.820313, -422.008423, 44.391155)
  293.     player:GossipComplete()
  294.     end
  295.  
  296.     if(intid == 1502) then
  297.     player:Teleport(0, -10428.820313, -422.008423, 44.391155)
  298.     player:GossipComplete()
  299.     end
  300.  
  301.     if(intid == 834) then
  302.     player:Teleport(43, -161.737076, 132.046326, -73.882683)
  303.     player:GossipComplete()
  304.     end
  305.  
  306.     if(intid == 1010) then
  307.     player:Teleport(1, 6925.790039, -2274.969971, 590.013000)
  308.     player:GossipComplete()
  309.     end
  310.  
  311.     if(intid == 1011) then
  312.     player:Teleport(1, 4582.560059, -3820.830078, 978.575012)
  313.     player:GossipComplete()
  314.     end
  315.  
  316.     if(intid == 1012) then
  317.     player:Teleport(1, 1814.668335, -4419.4147480, -18.812292)
  318.     player:GossipComplete()
  319.     end
  320.  
  321.     if(intid == 835) then
  322.     player:Teleport(48, -151.889999, 106.959999, -39.869999)
  323.     player:GossipComplete()
  324.     end
  325.  
  326.     if(intid == 836) then
  327.     player:Teleport(47, 1943.000000, 1544.630005, 81.997025)
  328.     player:GossipComplete()
  329.     end
  330.  
  331.     if(intid == 837) then
  332.     player:Teleport(189, 1691.010010, 1053.744507, 18.677431)
  333.     player:GossipComplete()
  334.     end
  335.  
  336.     if(intid == 838) then
  337.     player:Teleport(189, 862.380432, 1321.962036, 18.676479)
  338.     player:GossipComplete()
  339.     end
  340.  
  341.     if(intid == 839) then
  342.     player:Teleport(189, 1614.569580, -323.615875, 18.675322)
  343.     player:GossipComplete()
  344.     end
  345.  
  346.     if(intid == 820) then
  347.     player:Teleport(189, 257.482117, -209.070969, 18.677341)
  348.     player:GossipComplete()
  349.     end
  350.  
  351.     if(intid == 821) then
  352.     player:Teleport(209, 1221.819946, 840.745972, 8.976506)
  353.     player:GossipComplete()
  354.     end
  355.  
  356.     if(intid == 822) then
  357.     player:Teleport(0, -10265.416016, -3887.859131, -38.769176)
  358.     player:GossipComplete()
  359.     end
  360.  
  361.     if(intid == 1) then
  362.     if (player:IsInCombat() == true) then
  363.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  364.     else
  365.     item:GossipCreateMenu(56, player, 0)
  366.     item:GossipMenuAddItem(2, " [Raid Instances (page: 1)]\n ", 1, 0)
  367.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
  368.     item:GossipMenuAddItem(2, "[Teleport] Auchenai Crypts", 435, 0)
  369.     item:GossipMenuAddItem(2, "[Teleport] Black Temple", 451, 0)
  370.     item:GossipMenuAddItem(2, "[Teleport] Blackrock", 24, 0)
  371.     item:GossipMenuAddItem(2, "[Teleport] Caverns Of Time", 29, 0)
  372.     item:GossipMenuAddItem(2, "[Teleport] The Deadmines", 3704, 0)
  373.     item:GossipMenuAddItem(2, "[Teleport] Gruul's Lair", 446, 0)
  374.     item:GossipMenuAddItem(2, "[Teleport] Hellfire Ramparts", 430, 0)
  375.     item:GossipMenuAddItem(2, "[Teleport] Hyjal Summit", 3705, 0)
  376.     item:GossipMenuAddItem(2, "[Teleport] Karazhan", 27, 0)
  377.     item:GossipMenuAddItem(2, "[Teleport] Molten Core", 26, 0)
  378.     item:GossipMenuAddItem(0, "\n Next Page..", 2, 0)
  379.     item:GossipSendMenu(player)
  380.     end
  381.     end
  382.  
  383.     if(intid == 2) then
  384.     if (player:IsInCombat() == true) then
  385.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  386.     else
  387.     item:GossipCreateMenu(56, player, 0)
  388.     item:GossipMenuAddItem(2, " [Raid Instances (page: 2)]\n ", 2, 0)
  389.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 1, 0)
  390.     item:GossipMenuAddItem(2, "[Teleport] Magtheridon's Lair", 447, 0)
  391.     item:GossipMenuAddItem(2, "[Teleport] Mana-Tombs", 434, 0)
  392.     item:GossipMenuAddItem(2, "[Teleport] Naxxramas", 28, 0)
  393.     item:GossipMenuAddItem(2, "[Teleport] Onyxia's Lair", 25, 0)
  394.     item:GossipMenuAddItem(2, "[Teleport] Scarlet Monastery", 21, 0)
  395.     item:GossipMenuAddItem(2, "[Teleport] Scholomance", 23, 0)
  396.     item:GossipMenuAddItem(2, "[Teleport] Serpentshrine Cavern", 449, 0)
  397.     item:GossipMenuAddItem(2, "[Teleport] Shadow Labyrinth", 440, 0)
  398.     item:GossipMenuAddItem(2, "[Teleport] Sunwell Plateau", 452, 0)
  399.     item:GossipMenuAddItem(2, "[Teleport] Shadowfang Keep", 19, 0)
  400.     item:GossipMenuAddItem(0, "\n Next Page..", 3, 0)
  401.     item:GossipSendMenu(player)
  402.     end
  403.     end
  404.  
  405.     if(intid == 3) then
  406.     if (player:IsInCombat() == true) then
  407.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  408.     else
  409.     item:GossipCreateMenu(56, player, 0)
  410.     item:GossipMenuAddItem(2, " [Raid Instances (page: 3)]\n ", 3, 0)
  411.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 2, 0)
  412.     item:GossipMenuAddItem(2, "[Teleport] Sethekk Halls", 438, 0)
  413.     item:GossipMenuAddItem(2, "[Teleport] Shattered Halls", 441, 0)
  414.     item:GossipMenuAddItem(2, "[Teleport] Stratholme", 22, 0)
  415.     item:GossipMenuAddItem(2, "[Teleport] The BloodFurnace", 431, 0)
  416.     item:GossipMenuAddItem(2, "[Teleport] Zul'Aman", 3706, 0)
  417.     item:GossipMenuAddItem(2, "[Teleport] Zul'Gurub", 20, 0)
  418.     item:GossipSendMenu(player)
  419.     end
  420.     end
  421.  
  422.     if(intid == 4) then
  423.     if (player:IsInCombat() == true) then
  424.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  425.     else
  426.     item:GossipCreateMenu(56, player, 0)
  427.     item:GossipMenuAddItem(2, " [Primay Instances Menu]\n ", 4, 0)
  428.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
  429.     item:GossipMenuAddItem(2, "[Teleport] The Shattered Halls", 3707, 0)
  430.     item:GossipMenuAddItem(2, "[Teleport] The Blood Furnance", 3708, 0)
  431.     item:GossipMenuAddItem(2, "[Teleport] Hellfire Ramparts", 3709, 0)
  432.     item:GossipMenuAddItem(2, "[Teleport] The Slave Pens", 3710, 0)
  433.     item:GossipMenuAddItem(2, "[Teleport] The Underbog", 3711, 0)
  434.     item:GossipMenuAddItem(2, "[Teleport] The Steamvault", 3712, 0)
  435.     item:GossipMenuAddItem(2, "[Teleport] The Mechanar", 3713, 0)
  436.     item:GossipMenuAddItem(2, "[Teleport] The Botanica", 3714, 0)
  437.     item:GossipMenuAddItem(2, "[Teleport] The Arcatraz", 3715, 0)
  438.     item:GossipMenuAddItem(2, "[Teleport] The Black Moras", 3716, 0)
  439.     item:GossipMenuAddItem(2, "[Teleport] Shadow Labyrinth", 3728, 0)
  440.     item:GossipSendMenu(player)
  441.     end
  442.     end
  443.  
  444.     if(intid == 5) then
  445.     if (player:IsInCombat() == true) then
  446.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  447.     else
  448.     item:GossipCreateMenu(56, player, 0)
  449.     item:GossipMenuAddItem(2, " [Secondary Instances Menu]\n ", 5, 0)
  450.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
  451.     item:GossipMenuAddItem(2, "[Teleport] Zul'Farak", 3717, 0)
  452.     item:GossipMenuAddItem(2, "[Teleport] Maraudon", 3718, 0)
  453.     item:GossipMenuAddItem(2, "[Teleport] Lost Temple", 3719, 0)
  454.     item:GossipMenuAddItem(2, "[Teleport] Blackrock Depths", 3720, 0)
  455.     item:GossipMenuAddItem(2, "[Teleport] Scarlet Monastery", 3721, 0)
  456.     item:GossipMenuAddItem(7, "[Teleport] Dire Maul (north)", 3722, 0)
  457.     item:GossipMenuAddItem(7, "[Teleport] Dire Maul (east)", 3723, 0)
  458.     item:GossipMenuAddItem(7, "[Teleport] Dire Maul (west)", 3724, 0)
  459.     item:GossipMenuAddItem(2, "[Teleport] Gnomeregan", 3725, 0)
  460.     item:GossipMenuAddItem(2, "[Teleport] Uldaman", 3726, 0)
  461.     item:GossipMenuAddItem(2, "[Teleport] Wailing Caverns", 3727, 0)
  462.     item:GossipSendMenu(player)
  463.     end
  464.     end
  465.  
  466.     if(intid == 18) then
  467.     if (player:IsInCombat() == true) then
  468.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  469.     else
  470.     item:GossipCreateMenu(57, player, 0)
  471.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
  472.     item:GossipMenuAddItem(2, "Wrath of the Lich King Instances", 3203, 0)
  473.     item:GossipMenuAddItem(2, "The Burning Crusade raid Instances", 1, 0)
  474.     item:GossipMenuAddItem(2, "The Burning Crusade primary Instances", 4, 0)
  475.     item:GossipMenuAddItem(2, "The Burning Crusade secondary Instances", 5, 0)
  476.     item:GossipMenuAddItem(2, "[Quick Tele] Icecrown Citadel", 3751, 0)
  477.     item:GossipMenuAddItem(2, "[Quick Tele] The Ulduar", 3758, 0)
  478.     item:GossipMenuAddItem(2, "[Quick Tele] Black Temple", 3772, 0)
  479.     item:GossipMenuAddItem(2, "World player vs. Elite BOSS", 3202, 0)
  480.     item:GossipMenuAddItem(2, "[Join] Arathi Basin", 3770, 0)
  481.     item:GossipMenuAddItem(2, "[Join] Eye of the Storm", 3771, 0)
  482.     item:GossipMenuAddItem(2, "[Join] Warsong Gulch", 3769, 0)
  483.     item:GossipMenuAddItem(2, "Argent tournament grounds", 3757, 0)
  484.     item:GossipSendMenu(player)
  485.     end
  486.     end
  487.  
  488.     if(intid == 3200) then
  489.     if (player:IsInCombat() == true) then
  490.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  491.     else
  492.     item:GossipCreateMenu(57, player, 0)
  493.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
  494.     item:GossipMenuAddItem(2, "Orgrimmar (Main City)", 3729, 0)
  495.     item:GossipMenuAddItem(2, "Silvermoon City (Fresher city)", 3730, 0)
  496.     item:GossipMenuAddItem(2, "Thunder Bluff", 3731, 0)
  497.     item:GossipMenuAddItem(2, "Undercity", 3732, 0)
  498.     item:GossipMenuAddItem(2, "Neutral Ratchet", 3733, 0)
  499.     item:GossipMenuAddItem(2, "Neutral Booty Bay", 3734, 0)
  500.     item:GossipMenuAddItem(2, "Gadgetzan", 3735, 0)
  501.     item:GossipMenuAddItem(2, "Shattrath", 3736, 0)
  502.     item:GossipMenuAddItem(2, "The Stairs of Destiny", 3737, 0)
  503.     item:GossipMenuAddItem(2, "Dalaran City", 3738, 0)
  504.     item:GossipSendMenu(player)
  505.     end
  506.     end
  507.  
  508.     if(intid == 3201) then
  509.     if (player:IsInCombat() == true) then
  510.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  511.     else
  512.     item:GossipCreateMenu(57, player, 0)
  513.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
  514.     item:GossipMenuAddItem(2, "Stormwind (Main City)", 3739, 0)
  515.     item:GossipMenuAddItem(2, "Ironforge City (Fresher)", 3740, 0)
  516.     item:GossipMenuAddItem(2, "Darnassus City", 3741, 0)
  517.     item:GossipMenuAddItem(2, "The Exodar", 3742, 0)
  518.     item:GossipMenuAddItem(2, "NeutralRatchet", 3733, 0)
  519.     item:GossipMenuAddItem(2, "Neutral Booty Bay", 3734, 0)
  520.     item:GossipMenuAddItem(2, "Gadgetzan", 3735, 0)
  521.     item:GossipMenuAddItem(2, "Shattrath", 3743, 0)
  522.     item:GossipMenuAddItem(2, "The Stairs of Destiny", 3737, 0)
  523.     item:GossipMenuAddItem(2, "Dalaran City", 3738, 0)
  524.     item:GossipSendMenu(player)
  525.     end
  526.     end
  527.  
  528.     if(intid == 3202) then
  529.     if (player:IsInCombat() == true) then
  530.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  531.     else
  532.     item:GossipCreateMenu(57, player, 0)
  533.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
  534.     item:GossipMenuAddItem(2, "Azuregos\n ", 3744, 0)
  535.     item:GossipMenuAddItem(2, "Lethon\n ", 3745, 0)
  536.     item:GossipMenuAddItem(2, "Emeriss\n ", 3746, 0)
  537.     item:GossipMenuAddItem(2, "Taerar\n ", 3747, 0)
  538.     item:GossipMenuAddItem(2, "Ysondre\n ", 3748, 0)
  539.     item:GossipMenuAddItem(2, "Kazzak\n ", 3749, 0)
  540.     item:GossipMenuAddItem(2, "Doomwalker\n ", 3750, 0)
  541.     item:GossipSendMenu(player)
  542.     end
  543.     end
  544.  
  545.     if(intid == 3203) then
  546.     if (player:IsInCombat() == true) then
  547.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  548.     else
  549.     item:GossipCreateMenu(57, player, 0)
  550.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 18, 0)
  551.     item:GossipMenuAddItem(2, "[Teleport] Azjol Nerub", 3763, 0)
  552.     item:GossipMenuAddItem(2, "[Teleport] Gundrak", 3767, 0)
  553.     item:GossipMenuAddItem(2, "[Teleport] Halls of Lightning", 3765, 0)
  554.     item:GossipMenuAddItem(2, "[Teleport] Halls of Reflection", 3752, 0)
  555.     item:GossipMenuAddItem(2, "[Teleport] Halls of Stone", 3766, 0)
  556.     item:GossipMenuAddItem(2, "[Teleport] Pit of Saron", 3753, 0)
  557.     item:GossipMenuAddItem(2, "[Teleport] Forge of Souls", 3754, 0)
  558.     item:GossipMenuAddItem(2, "[Teleport] Naxxramas", 3759, 0)
  559.     item:GossipMenuAddItem(2, "[Teleport] Vault of Archavon", 3760, 0)
  560.     item:GossipMenuAddItem(2, "[Teleport] The Nexus", 3762, 0)
  561.     item:GossipMenuAddItem(2, "[Teleport] The Oculus", 3768, 0)
  562.     item:GossipMenuAddItem(2, "[Teleport] Trial of the Champion", 3755, 0)
  563.     item:GossipMenuAddItem(0, "\n Next Page..", 3204, 0)
  564.     item:GossipSendMenu(player)
  565.     end
  566.     end
  567.  
  568.     if(intid == 3204) then
  569.     if (player:IsInCombat() == true) then
  570.     player:SendAreaTriggerMessage("|cffFF0000You can't use that in combat.")
  571.     else
  572.     item:GossipCreateMenu(57, player, 0)
  573.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 3203, 0)
  574.     item:GossipMenuAddItem(2, "[Teleport] Trial of the Crusader", 3756, 0)
  575.     item:GossipMenuAddItem(2, "[Teleport] The Obsidian Sanctum", 3764, 0)
  576.     item:GossipMenuAddItem(2, "[Teleport] The Violet Hold", 3761, 0)
  577.     item:GossipMenuAddItem(2, "[Teleport] The Ulduar", 3758, 0)
  578.     item:GossipSendMenu(player)
  579.     end
  580.     end
  581.  
  582.     if(intid == 3205) then
  583.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  584.  
  585.     local MagicGold = GetMagicGold:GetColumn(0):GetString()
  586.     item:GossipCreateMenu(57, player, 0)
  587.     item:GossipMenuAddItem(0, "|cff573838..Return\n", 75, 0)
  588.     item:GossipMenuAddItem(2, "Check your chatbox string", 75, 0)
  589.     item:GossipSendMenu(player)
  590.     player:SendBroadcastMessage("|cff00ff00Your total magic gold: "..MagicGold..".|r")
  591.     end
  592.  
  593.     if(intid == 3206) then
  594.     player:DisableCombat()
  595.     player:SendBroadcastMessage("|cffC0052BUnstucked from combat.|r")
  596.     player:GossipComplete()
  597.     end
  598.  
  599.     if(intid == 3207) then
  600.     player:SendBroadcastMessage("|cff00ff00There are following active GMs on this server:\n ")
  601.     for k,v in pairs(GetPlayersInWorld()) do
  602.     local name = {}
  603.     name[k] = v:GetName()
  604.     if v:CanUseCommand("q") or v:CanUseCommand("w") or v:CanUseCommand("e") or v:CanUseCommand("t") then
  605.     player:SendBroadcastMessage("|cff00ff00"..name[k].." |r[]")
  606.     player:GossipComplete()
  607.     else
  608.     player:GossipComplete()
  609.     end
  610.     end
  611.     end
  612.  
  613.     if(intid == 9090) then
  614.     if (player:HasAura(15007) == true) then
  615.     player:SendBroadcastMessage("|cff00ff00Your Sickness has been removed.")
  616.     player:RemoveAura(15007)
  617.     player:GossipComplete()
  618.     else
  619.     player:SendAreaTriggerMessage("|cffff0000Aura not found.")
  620.     player:GossipComplete()
  621.     end
  622.     end
  623.  
  624.     if(intid == 10) then
  625.     player:GossipComplete()
  626.     player:Teleport(1, 1484, -4417, 25)
  627.     end
  628.  
  629.     if(intid == 11) then
  630.     player:GossipComplete()
  631.     player:Teleport(0, 1831, 238, 60)
  632.     end
  633.  
  634.     if(intid == 12) then
  635.     player:GossipComplete()
  636.     player:Teleport(1, -1277, 118, 131)
  637.     end
  638.  
  639.     if(intid == 13) then
  640.     player:GossipComplete()
  641.     player:Teleport(530, 9413, -7277, 14)
  642.     end
  643.  
  644.     if(intid == 14) then
  645.     player:GossipComplete()
  646.     player:Teleport(0, -8913.23, 554.633, 94.7944)
  647.     end
  648.  
  649.     if(intid == 15) then
  650.     player:GossipComplete()
  651.     player:Teleport(0, -4981.25, -881.542, 502.66)
  652.     end
  653.  
  654.     if(intid == 833) then
  655.     player:GossipComplete()
  656.     player:Teleport(389, 2.258112, -10.744517, -16.434870)
  657.     end
  658.  
  659.     if(intid == 16) then
  660.     player:GossipComplete()
  661.     player:Teleport(1, 9948, 2413, 1327)
  662.     end
  663.  
  664.     if(intid == 17) then
  665.     player:GossipComplete()
  666.     player:Teleport(530, -4014.080078, -11895.799805, -1.990842)
  667.     end
  668.  
  669.     if(intid == 19) then
  670.     player:GossipComplete()
  671.     player:Teleport(0, -234.495087, 1561.946411, 76.892143)
  672.     end
  673.  
  674.     if(intid == 20) then
  675.     player:GossipComplete()
  676.     player:Teleport(0, -11919.073242, -1202.459374, 92.298744)
  677.     end
  678.  
  679.     if(intid == 21) then
  680.     player:GossipComplete()
  681.     player:Teleport(0, 2870.442627, -819.985229, 160.331085)
  682.     end
  683.  
  684.     if(intid == 22) then
  685.     player:GossipComplete()
  686.     player:Teleport(0, 3359.111572, -3380.8444238, 144.781860)
  687.     end
  688.  
  689.     if(intid == 23) then
  690.     player:GossipComplete()
  691.     player:Teleport(0, 1267.468628, -2556.651367, 94.127983)
  692.     end
  693.  
  694.     if(intid == 24) then
  695.     player:GossipComplete()
  696.     player:Teleport(0, -7527.129883, -1224.997437, 285.733002)
  697.     end
  698.  
  699.     if(intid == 25) then
  700.     player:GossipComplete()
  701.     player:Teleport(1, -4708.491699, -3727.672363, 54.535076)
  702.     end
  703.  
  704.     if(intid == 26) then
  705.     player:GossipComplete()
  706.     player:Teleport(0, -7515.409668, -1045.369629, 182.301208)
  707.     end
  708.  
  709.     if(intid == 27) then
  710.     player:GossipComplete()
  711.     player:Teleport(0, -11122.913086, -2014.498779, 47.079350)
  712.     end
  713.  
  714.     if(intid == 28) then
  715.     player:GossipComplete()
  716.     player:Teleport(0, 3132.915283, -3731.012939, 138.658371)
  717.     end
  718.  
  719.     if(intid == 29) then
  720.     player:GossipComplete()
  721.     player:Teleport(1, -8519.718750, -4297.542480, -208.441376)
  722.     end
  723.  
  724.     if(intid == 30) then
  725.     player:GossipComplete()
  726.     player:Teleport(530, -247.9672, 948.5709, 84.3798)
  727.     end
  728.  
  729.     if(intid == 31) then
  730.     player:GossipComplete()
  731.     player:Teleport(530, -1045.0179, 5380.0288, 22.1216)
  732.     end
  733.  
  734.     if (intid == 32) then
  735.     player:GossipComplete()
  736.     player:Teleport(530, -468, 8418, 28)
  737.     end
  738.  
  739.     if(intid == 33) then
  740.     player:GossipComplete()
  741.     player:Teleport(530, 1552.2236, 6813.3798, 125.1364)
  742.     end
  743.  
  744.     if(intid == 34) then
  745.     player:GossipComplete()
  746.     player:Teleport(530, 3396, 4185, 137)
  747.     end
  748.  
  749.     if(intid == 35) then
  750.     player:GossipComplete()
  751.     player:Teleport(530, -2276.82, 5132.03, -8.62994)
  752.     end
  753.  
  754.     if(intid == 36) then
  755.     player:GossipComplete()
  756.     player:Teleport(530, -3004.3488, 2968.4343, 81.8821)
  757.     end
  758.  
  759.     if(intid == 37) then
  760.     player:GossipComplete()
  761.     player:Teleport(530, -1849.4200, 5401.4599, -12.4279)
  762.     end
  763.  
  764.     if(intid == 669) then
  765.     player:GossipComplete()
  766.     player:Teleport(603, 1673.903809, -24.098600, 427.311707)
  767.     end
  768.  
  769.     if(intid == 38) then
  770.     player:GossipComplete()
  771.     player:Teleport(530, -1821.645508, 5415.870117, 0.857084)
  772.     end
  773.  
  774.     if(intid == 46) then
  775.     player:GossipComplete()
  776.     player:Teleport(571, 5785.240234, 724.909973, 641.080994)
  777.     end
  778.  
  779.     if(intid == 100) then
  780.     player:GossipComplete()
  781.     player:Teleport(1, 9874.646484, 595.742432, 1303.874023)
  782.     end
  783.  
  784.     if(intid == 102) then
  785.     player:GossipComplete()
  786.     player:Teleport(530, -2721.68, -12208.9, 10.0882)
  787.     end
  788.  
  789.     if(intid == 103) then
  790.     player:GossipComplete()
  791.     player:Teleport(530, -4020.48, -13783.3, 74.9001)
  792.     end
  793.  
  794.     if(intid == 105) then
  795.     player:GossipComplete()
  796.     player:Teleport(1, 6207.5, -152.833, 80.8185)
  797.     end
  798.  
  799.     if(intid == 106) then
  800.     player:GossipComplete()
  801.     player:Teleport(1, 7101.68, -2670.2, 512.2)
  802.     end
  803.  
  804.     if(intid == 107) then
  805.     player:GossipComplete()
  806.     player:Teleport(1, 5483.9, -749.881, 335.621)
  807.     end
  808.  
  809.     if(intid == 108) then
  810.     player:GossipComplete()
  811.     player:Teleport(1, 6107.62, -4181.6, 853.322)
  812.     end
  813.  
  814.     if(intid == 109) then
  815.     player:GossipComplete()
  816.     player:Teleport(1, 2717.1, 5967.91, 107.4)
  817.     end
  818.  
  819.     if(intid == 111) then
  820.     player:GossipComplete()
  821.     player:Teleport(1, 341.42, -4684.7, 31.9493)
  822.     end
  823.  
  824.     if(intid == 112) then
  825.     player:GossipComplete()
  826.     player:Teleport(1, 1145.85, 664.812, 143)
  827.     end
  828.  
  829.     if(intid == 113) then
  830.     player:GossipComplete()
  831.     player:Teleport(1, -93.1614, 1691.15, 90.0649)
  832.     end
  833.  
  834.     if(intid == 114) then
  835.     player:GossipComplete()
  836.     player:Teleport(1, -90.19003, -1943.44, -180.4727)
  837.     end
  838.  
  839.     if(intid == 115) then
  840.     player:GossipComplete()
  841.     player:Teleport(1, -1840.75, 5359, -7.845)
  842.     end
  843.  
  844.     if(intid == 709) then
  845.     player:GossipComplete()
  846.     player:Teleport(1, -3750.512451, 1098.846294, 151.969482)
  847.     end
  848.  
  849.     if(intid == 116) then
  850.     player:GossipComplete()
  851.     player:Teleport(1, -4458.93, 243.415, -65.6136)
  852.     end
  853.  
  854.     if(intid == 117) then
  855.     player:GossipComplete()
  856.     player:Teleport(1, -3463.26, -4123.13, 18.1043)
  857.     end
  858.  
  859.     if(intid == 119) then
  860.     player:GossipComplete()
  861.     player:Teleport(1, -7932.61, -2139.61, -229.728)
  862.     end
  863.  
  864.     if(intid == 120) then
  865.     player:GossipComplete()
  866.     player:Teleport(1, -7373.69, -2950.2, -11.7598)
  867.     end
  868.  
  869.     if(intid == 121) then
  870.     player:GossipComplete()
  871.     player:Teleport(1, -7373.69, -2950.2, -30.7598)
  872.     end
  873.  
  874.     if(intid == 201) then
  875.     player:GossipComplete()
  876.     player:Teleport(530, 9449.15, -6782.61, 16.6167)
  877.     end
  878.  
  879.     if(intid == 202) then
  880.     player:GossipComplete()
  881.     player:Teleport(530, 7880, -6193, 22)
  882.     end
  883.  
  884.     if(intid == 203) then
  885.     player:GossipComplete()
  886.     player:Teleport(0, 1224.36, -1151.97, 61.7327)
  887.     end
  888.  
  889.     if(intid == 205) then
  890.     player:GossipComplete()
  891.     player:Teleport(0, 2019.35, 1904.36, 106.144)
  892.     end
  893.  
  894.     if(intid == 206) then
  895.     player:GossipComplete()
  896.     player:Teleport(0, 1919.44, -4306.23, 77.838)
  897.     end
  898.  
  899.     if(intid == 207) then
  900.     player:GossipComplete()
  901.     player:Teleport(0, 511.536, 1638.63, 121.417)
  902.     end
  903.  
  904.     if(intid == 208) then
  905.     player:GossipComplete()
  906.     player:Teleport(0, 272.704, -654.514, 129.609)
  907.     end
  908.  
  909.     if(intid == 209) then
  910.     player:GossipComplete()
  911.     player:Teleport(0, 139.375, -1982.79, 134.043)
  912.     end
  913.  
  914.     if(intid == 210) then
  915.     player:GossipComplete()
  916.     player:Teleport(0, -852.854, -576.712, 21.0293)
  917.     end
  918.  
  919.     if(intid == 211) then
  920.     player:GossipComplete()
  921.     player:Teleport(0, -4086.36, -2610.95, 47.0143)
  922.     end
  923.  
  924.     if(intid == 212) then
  925.     player:GossipComplete()
  926.     player:Teleport(0, -5425.924316, -224.271957, 404.984344)
  927.     end
  928.  
  929.     if(intid == 213) then
  930.     player:GossipComplete()
  931.     player:Teleport(0, -4939.1, -3423.74, 306.595)
  932.     end
  933.  
  934.     if(intid == 214) then
  935.     player:GossipComplete()
  936.     player:Teleport(0, -6018.138184, -3311.517822, 261.744324)
  937.     end
  938.  
  939.     if(intid == 215) then
  940.     player:GossipComplete()
  941.     player:Teleport(0, -7176.63, -937.667, 171.206)
  942.     end
  943.  
  944.     if(intid == 216) then
  945.     player:GossipComplete()
  946.     player:Teleport(0, -7907.41, -1128.66, 192.056)
  947.     end
  948.  
  949.     if(intid == 217) then
  950.     player:GossipComplete()
  951.     player:Teleport(0, -9621.383789, -371.068207, 57.471478)
  952.     end
  953.  
  954.     if(intid == 218) then
  955.     player:GossipComplete()
  956.     player:Teleport(0, -9219.37, -2149.94, 71.606)
  957.     end
  958.  
  959.     if(intid == 219) then
  960.     player:GossipComplete()
  961.     player:Teleport(0, -10264.6, -3059.9, 19.9356)
  962.     end                        
  963.  
  964.     if(intid == 220) then
  965.     player:GossipComplete()
  966.     player:Teleport(0, -11224.254883, -378.471802, 52.764240)
  967.     end
  968.  
  969.     if(intid == 221) then
  970.     player:GossipComplete()
  971.     player:Teleport(0, -10435.4, -1809.28, 101)
  972.     end
  973.  
  974.     if(intid == 222) then
  975.     player:GossipComplete()
  976.     player:Teleport(0, -11204.5, -2730.61, 15.8972)
  977.     end
  978.  
  979.     if(intid == 223) then
  980.     player:GossipComplete()
  981.     player:Teleport(0, -11634.8, -54.0697, 14.4439)
  982.     end
  983.  
  984.     if(intid == 430) then
  985.     player:GossipComplete()
  986.     player:Teleport(530, -360.671, 3071.9, -15.0977)
  987.     end
  988.  
  989.     if(intid == 431) then
  990.     player:GossipComplete()
  991.     player:Teleport(542, -3.9967, 14.6363, -44.8009)
  992.     end
  993.  
  994.     if(intid == 432) then
  995.     player:GossipComplete()
  996.     player:Teleport(530, 721.926, 7012.24, -73.065)
  997.     end
  998.  
  999.     if(intid == 433) then
  1000.     player:GossipComplete()
  1001.     player:Teleport(530, 779.802, 6769.33, -71.4282)
  1002.     end
  1003.  
  1004.     if(intid == 434) then
  1005.     player:GossipComplete()
  1006.     player:Teleport(530, -3101.47, 4947.11, -101.177)
  1007.     end
  1008.  
  1009.     if(intid == 435) then
  1010.     player:GossipComplete()
  1011.     player:Teleport(530, -3357.32, 5216.77, -101.049)
  1012.     end
  1013.  
  1014.     if(intid == 777) then
  1015.     player:GossipComplete()
  1016.     player:Teleport(0, -13243.240234, 197.949799, 32.112690)
  1017.     end
  1018.  
  1019.     if(intid == 778) then
  1020.     player:GossipComplete()
  1021.     player:Teleport(530, -2044.388672, 6655.308594, 37.733746)
  1022.     end
  1023.  
  1024.     if(intid == 779) then
  1025.     player:GossipComplete()
  1026.     player:Teleport(1, 2177.811523, -4764.241699, 67.311165)
  1027.     end
  1028.  
  1029.     if(intid == 436) then
  1030.     player:GossipComplete()
  1031.     player:Teleport(1, -8195.94, -4500.13, 9.60819)
  1032.     end
  1033.  
  1034.     if(intid == 438) then
  1035.     player:GossipComplete()
  1036.     player:Teleport(530, -3360.13, 4667.85, -101.047)
  1037.     end
  1038.  
  1039.     if(intid == 439) then
  1040.     player:GossipComplete()
  1041.     player:Teleport(0, -11634.8, -54.0697, 14.4439)
  1042.     end
  1043.  
  1044.     if(intid == 440) then
  1045.     player:GossipComplete()
  1046.     player:Teleport(530, -3635.76, 4931.82, -100.034)
  1047.     end
  1048.  
  1049.     if(intid == 441) then
  1050.     player:GossipComplete()
  1051.     player:Teleport(530, -309.83, 3080.08, -3.63538)
  1052.     end
  1053.  
  1054.     if(intid == 442) then
  1055.     player:GossipComplete()
  1056.     player:Teleport(530, 2885.2, 1564.73, 248.874)
  1057.     end
  1058.  
  1059.     if(intid == 443) then
  1060.     player:GossipComplete()
  1061.     player:Teleport(530, 3405.48, 1489.14, 183.838)
  1062.     end
  1063.  
  1064.     if(intid == 444) then
  1065.     player:GossipComplete()
  1066.     player:Teleport(530, 2872, 1555.29, 253.159)
  1067.     end
  1068.  
  1069.     if(intid == 445) then
  1070.     player:GossipComplete()
  1071.     player:Teleport(585, 2.19347, -0.123698, -2.8025)
  1072.     end
  1073.  
  1074.     if(intid == 446) then
  1075.     player:GossipComplete()
  1076.     player:Teleport(530, 3606.85, 5260.49, 4.1724)
  1077.     end
  1078.  
  1079.     if(intid == 447) then
  1080.     player:GossipComplete()
  1081.     player:Teleport(530, -319.635, 3102.03, -113.937)
  1082.     end
  1083.  
  1084.     if(intid == 448) then
  1085.     player:GossipComplete()
  1086.     player:Teleport(530, 6850, -7950, 170)
  1087.     end
  1088.  
  1089.     if(intid == 449) then
  1090.     player:GossipComplete()
  1091.     player:Teleport(530, 742.883, 6867.19, -68.8289)
  1092.     end
  1093.  
  1094.     if(intid == 450) then
  1095.     player:GossipComplete()
  1096.     player:Teleport(530, 3087.22, 1380.7, 184.883)
  1097.     end
  1098.  
  1099.     if(intid == 451) then
  1100.     player:GossipComplete()
  1101.     player:Teleport(530, -3604.74, 328.252, 38.3077)
  1102.     end
  1103.  
  1104.     if(intid == 452) then
  1105.     player:GossipComplete()
  1106.     player:Teleport(580, 1791.17, 926.31, 15.1135)
  1107.     end
  1108.  
  1109.     if(intid == 501) then
  1110.     player:GossipComplete()
  1111.     player:Teleport(571, 2087.0109, 6508.6171, 1.4727)
  1112.     end
  1113.  
  1114.     if(intid == 502) then
  1115.     player:GossipComplete()
  1116.     player:Teleport(571, 5434.8281, -1022.4812, 175.0125)
  1117.     end
  1118.  
  1119.     if(intid == 503) then
  1120.     player:GossipComplete()
  1121.     player:Teleport(571, 5811.4067, 647.7883, 647.4152)
  1122.     end
  1123.  
  1124.     if(intid == 504) then
  1125.     player:GossipComplete()
  1126.     player:Teleport(571, 3511.6850, 2841.8454, 36.7473)
  1127.     end
  1128.  
  1129.     if(intid == 505) then
  1130.     player:GossipComplete()
  1131.     player:Teleport(571, 3346.2551, -4486.8173, 259.2319)
  1132.     end
  1133.  
  1134.     if(intid == 506) then
  1135.     player:GossipComplete()
  1136.     player:Teleport(571, 2195.3654, -4526.7729, 216.7943)
  1137.     end
  1138.  
  1139.     if(intid == 507) then
  1140.     player:GossipComplete()
  1141.     player:Teleport(571, 6729.2387, 2510.4931, 427.7868)
  1142.     end
  1143.  
  1144.     if(intid == 508) then
  1145.     player:GossipComplete()
  1146.     player:Teleport(570, 4913.3090, 5536.0737, -76.4190)
  1147.     end
  1148.  
  1149.     if(intid == 509) then
  1150.     player:GossipComplete()
  1151.     player:Teleport(571, 6196.4174, -776.7462, 402.3688)
  1152.     end
  1153.  
  1154.     if(intid == 510) then
  1155.     player:GossipComplete()
  1156.     player:Teleport(571, 5443.4326, -1259.7487, 248.7494)
  1157.     end
  1158.  
  1159.     if(intid == 511) then
  1160.     player:GossipComplete()
  1161.     player:Teleport(609, 2355.7048, -5662.7075, 426.0274)
  1162.     end
  1163.  
  1164.     if(intid == 521) then
  1165.     player:GossipComplete()
  1166.     player:Teleport(574, 149, -88, 13)
  1167.     end
  1168.  
  1169.     if(intid == 522) then
  1170.     player:GossipComplete()
  1171.     player:Teleport(575, 570, -327, 111)
  1172.     end
  1173.  
  1174.     if(intid == 523) then
  1175.     player:GossipComplete()
  1176.     player:Teleport(576, 146, -10, -16)
  1177.     end
  1178.  
  1179.     if(intid == 524) then
  1180.     player:GossipComplete()
  1181.     player:Teleport(578, 1129, 1052, 70)
  1182.     end
  1183.  
  1184.     if(intid == 525) then
  1185.     player:GossipComplete()
  1186.     player:Teleport(599, 1153, 811, 196)
  1187.     end
  1188.  
  1189.     if(intid == 526) then
  1190.     player:GossipComplete()
  1191.     player:Teleport(602, 1333, -237, 41)
  1192.     end
  1193.  
  1194.     if(intid == 527) then
  1195.     player:GossipComplete()
  1196.     player:Teleport(603, 1739, 310, 119)
  1197.     end
  1198.  
  1199.     if(intid == 528) then
  1200.     player:GossipComplete()
  1201.     player:Teleport(600, -518, -488, 11)
  1202.     end
  1203.  
  1204.     if(intid == 529) then
  1205.     player:GossipComplete()
  1206.     player:Teleport(604, 2031, 805, 246)
  1207.     end
  1208.  
  1209.     if(intid == 530) then
  1210.     player:GossipComplete()
  1211.     player:Teleport(1, -8638, -4382, -207)
  1212.     end
  1213.  
  1214.     if(intid == 531) then
  1215.     player:GossipComplete()
  1216.     player:Teleport(595, 1967, 1287, 146)
  1217.     end
  1218.  
  1219.     if(intid == 532) then
  1220.     player:GossipComplete()
  1221.     player:Teleport(595, 2300, 1495, 129)
  1222.     end
  1223.  
  1224.     if(intid == 533) then
  1225.     player:GossipComplete()
  1226.     player:Teleport(595, 2258.3, 1153.6, 139)
  1227.     end
  1228.  
  1229.     if(intid == 534) then
  1230.     player:GossipComplete()
  1231.     player:Teleport(595, 1560.4, 603.3, 100)
  1232.     end
  1233.  
  1234.     if(intid == 535) then
  1235.     player:GossipComplete()
  1236.     player:Teleport(595, 1654.3, 1611.9, 117)
  1237.     end
  1238.  
  1239.     if(intid == 536) then
  1240.     player:GossipComplete()
  1241.     player:Teleport(607, 1605, 32, 23)
  1242.     end
  1243.  
  1244.     if(intid == 6666) then   -- Neutral Mall
  1245.     player:FullCastSpell(26638)
  1246.     player:GossipComplete()
  1247.     player:Teleport(530, -249.690094, 1018.246399, 54.327438)
  1248.     player:GossipComplete()
  1249.     end
  1250.  
  1251.     if(intid == 578) then   --Horde Mall
  1252.     player:GossipComplete()
  1253.     player:Teleport(1, 1920.535522, -4129.774414, 43.142735)
  1254.     player:GossipComplete()
  1255.     end
  1256.  
  1257.     if(intid == 567) then   --Alliance Mall
  1258.     player:GossipComplete()
  1259.     player:Teleport(0, -8452.386719, 346.997894, 120.885796)
  1260.     player:GossipComplete()
  1261.     end
  1262.  
  1263.     if(intid == 3700) then -- wildhammer stronghold
  1264.     player:GossipComplete()
  1265.     player:Teleport(530, -3996.853271, 2166.762939, 104.906471)
  1266.     end
  1267.  
  1268.     if(intid == 3701) then -- netherwing ledge
  1269.     player:GossipComplete()
  1270.     player:Teleport(530, -5090.712891, 670.831909, 87.805176)
  1271.     end
  1272.  
  1273.     if(intid == 3702) then -- honor hold
  1274.     player:GossipComplete()
  1275.     player:Teleport(530, -625.251221, 2522.399170, 74.799454)
  1276.     end
  1277.  
  1278.     if(intid == 3703) then -- dark portal
  1279.     player:GossipComplete()
  1280.     player:Teleport(530, -248.713028, 957.037842, 84.358704)
  1281.     end
  1282.  
  1283.     if(intid == 3704) then -- deadmines
  1284.     player:GossipComplete()
  1285.     player:Teleport(36, -17.809183, -378.987152, 60.833763)
  1286.     end
  1287.  
  1288.     if(intid == 3705) then -- hyjal summit
  1289.     player:GossipComplete()
  1290.     player:Teleport(534, 4225.198242, -4180.307617, 868.566833)
  1291.     end
  1292.  
  1293.     if(intid == 3706) then -- zulaman
  1294.     player:GossipComplete()
  1295.     player:Teleport(568, 120.699997, 1776.000000, 43.455036)
  1296.     end
  1297.  
  1298.     if(intid == 3707) then -- The Shattered Halls
  1299.     player:GossipComplete()
  1300.     player:Teleport(540, -13.860044, 0.752476, -13.219612)
  1301.     end
  1302.  
  1303.     if(intid == 3708) then -- The Blood Furnance
  1304.     player:GossipComplete()
  1305.     player:Teleport(542, -3.996700, 14.636300, -44.800900)
  1306.     end
  1307.  
  1308.     if(intid == 3709) then -- Hellfire Ramparts
  1309.     player:GossipComplete()
  1310.     player:Teleport(543, -1349.072998, 1651.941406, 68.819313)
  1311.     end
  1312.  
  1313.     if(intid == 3710) then -- The Slave Pens
  1314.     player:GossipComplete()
  1315.     player:Teleport(547, 123.657310, -124.957458, 0.817396)
  1316.     end
  1317.  
  1318.     if(intid == 3711) then -- The Underbog
  1319.     player:GossipComplete()
  1320.     player:Teleport(546, 9.700000, -16.200001, -2.754272)
  1321.     end
  1322.  
  1323.     if(intid == 3712) then -- The Steamvault
  1324.     player:GossipComplete()
  1325.     player:Teleport(545, -7.500000, 5.900000, -4.300000)
  1326.     end
  1327.  
  1328.     if(intid == 3713) then -- The Mechanar
  1329.     player:GossipComplete()
  1330.     player:Teleport(554, -16.211353, -0.075583, -1.812405)
  1331.     end
  1332.  
  1333.     if(intid == 3714) then -- The Botanica
  1334.     player:GossipComplete()
  1335.     player:Teleport(553, 29.703419, 38.498005, -5.695748)
  1336.     end
  1337.  
  1338.     if(intid == 3715) then -- The Arcatraz
  1339.     player:GossipComplete()
  1340.     player:Teleport(552, -1.760039, -0.076107, -0.205473)
  1341.     end
  1342.  
  1343.     if(intid == 3716) then -- The Black Moras
  1344.     player:GossipComplete()
  1345.     player:Teleport(269, -2040.000000, 7120.879883, 22.950001)
  1346.     end
  1347.  
  1348.     if(intid == 3717) then -- Zul'Farak
  1349.     player:GossipComplete()
  1350.     player:Teleport(209, 1213.0000000, 841.000000, 8.900000)
  1351.     end
  1352.  
  1353.     if(intid == 3718) then -- Maraudon
  1354.     player:GossipComplete()
  1355.     player:Teleport(349, 1012.700012, -459.317993, -43.547100)
  1356.     end
  1357.  
  1358.     if(intid == 3719) then -- Lost Temple
  1359.     player:GossipComplete()
  1360.     player:Teleport(109, -313.369995, 99.955399, -131.848999)
  1361.     end
  1362.  
  1363.     if(intid == 3720) then -- Blackrock Depths
  1364.     player:GossipComplete()
  1365.     player:Teleport(230, 456.477448, 34.875973, -69.399284)
  1366.     end
  1367.  
  1368.     if(intid == 3721) then -- Scarlet Monastery
  1369.     player:GossipComplete()
  1370.     player:Teleport(189, 855.000000, 1320.000000, 18.673920)
  1371.     end
  1372.  
  1373.     if(intid == 3722) then -- Dire Maul (north)
  1374.     player:GossipComplete()
  1375.     player:Teleport(429, 255.164001, -17.024200, -2.560600)
  1376.     end
  1377.  
  1378.     if(intid == 3723) then -- Dire Maul (east)
  1379.     player:GossipComplete()
  1380.     player:Teleport(429, 46.240002, -155.529999, -2.713500)
  1381.     end
  1382.  
  1383.     if(intid == 3724) then -- Dire Maul (west)
  1384.     player:GossipComplete()
  1385.     player:Teleport(429, 32.611378, 159.274307, -3.470170)
  1386.     end
  1387.  
  1388.     if(intid == 3725) then -- Gnomeregan
  1389.     player:GossipComplete()
  1390.     player:Teleport(90, -332.600006, -3.445000, -152.845993)
  1391.     end
  1392.  
  1393.     if(intid == 3726) then -- Uldaman
  1394.     player:GossipComplete()
  1395.     player:Teleport(70, -227.529007, 45.009800, -46.019600)
  1396.     end
  1397.  
  1398.     if(intid == 3727) then -- Wailing Caverns
  1399.     player:GossipComplete()
  1400.     player:Teleport(43, -161.800003, 133.270004, -73.870972)
  1401.     end
  1402.  
  1403.     if(intid == 3728) then -- Shadow Labyrinth
  1404.     player:GossipComplete()
  1405.     player:Teleport(555, 0.500000, -0.200000, -1.127946)
  1406.     end
  1407.  
  1408.     if(intid == 3729) then -- Orgrimmar
  1409.     player:GossipComplete()
  1410.     player:Teleport(1, 1600.349976, -4395.850098, 8.755000)
  1411.     end
  1412.  
  1413.     if(intid == 3730) then -- Silvermoon City
  1414.     player:GossipComplete()
  1415.     player:Teleport(530, 9518.440430, -7132.660156, 14.104518)
  1416.     end
  1417.  
  1418.     if(intid == 3731) then -- Thudner Bluff
  1419.     player:GossipComplete()
  1420.     player:Teleport(1, -1257.983032, 64.188904, 127.849998)
  1421.     end
  1422.  
  1423.     if(intid == 3732) then -- Undercity
  1424.     player:GossipComplete()
  1425.     player:Teleport(0, 1892.430054, 238.121994, 56.512295)
  1426.     end
  1427.  
  1428.     if(intid == 3733) then -- Ratchet
  1429.     player:GossipComplete()
  1430.     player:Teleport(1, -977.000000, -3788.000000, 5.277020)
  1431.     end
  1432.  
  1433.     if(intid == 3734) then -- Booty Bay
  1434.     player:GossipComplete()
  1435.     player:Teleport(0, -14302.000000, 518.000000, 8.687919)
  1436.     end
  1437.  
  1438.     if(intid == 3735) then -- Gadgetzan
  1439.     player:GossipComplete()
  1440.     player:Teleport(1, -7036.729980, -3781.659912, 10.410000)
  1441.     end
  1442.  
  1443.     if(intid == 3736) then -- Shattrath Horde
  1444.     player:GossipComplete()
  1445.     player:Teleport(530, -2009.689941, 5356.979980, -9.350689)
  1446.     end
  1447.  
  1448.     if(intid == 3736) then -- Shadow Labyrinth
  1449.     player:GossipComplete()
  1450.     player:Teleport(555, 0.500000, -0.200000, -1.127946)
  1451.     end
  1452.  
  1453.     if(intid == 3737) then -- Dark Portal Stairs of Destiny
  1454.     player:GossipComplete()
  1455.     player:Teleport(530, -246.6000006, 946.000000, 84.379791)
  1456.     end
  1457.  
  1458.     if(intid == 3738) then -- Dalaran
  1459.     player:GossipComplete()
  1460.     player:Teleport(571, 5807.819824, 588.228821, 660.939026)
  1461.     end
  1462.  
  1463.     if(intid == 3743) then -- Shattrath Ally
  1464.     player:GossipComplete()
  1465.     player:Teleport(530, -1718.250000, 5502.459961, -9.799516)
  1466.     end
  1467.  
  1468.     if(intid == 3739) then -- Stormwind
  1469.     player:GossipComplete()
  1470.     player:Teleport(0, -8815.979492, 628.598328, 94.125565)
  1471.     end
  1472.  
  1473.     if(intid == 3740) then -- Ironforge
  1474.     player:GossipComplete()
  1475.     player:Teleport(0, -4921.830078, -953.710022, 501.520569)
  1476.     end
  1477.  
  1478.     if(intid == 3741) then -- Darnassus
  1479.     player:GossipComplete()
  1480.     player:Teleport(1, 9952.660156, 2260.639893, 1337.163452)
  1481.     end
  1482.  
  1483.     if(intid == 3742) then -- Exodar
  1484.     player:GossipComplete()
  1485.     player:Teleport(530, -3954.610107, -11614.410156, -138.652832)
  1486.     end
  1487.  
  1488.     if(intid == 3744) then -- Azuregos
  1489.     player:GossipComplete()
  1490.     player:Teleport(1, 2620.368652, -5978.207520, 101.068459)
  1491.     end
  1492.  
  1493.     if(intid == 3745) then -- Lethon
  1494.     player:GossipComplete()
  1495.     player:Teleport(0, 670.500000, -4068.139893, 101.976385)
  1496.     end
  1497.  
  1498.     if(intid == 3746) then -- Emeriss
  1499.     player:GossipComplete()
  1500.     player:Teleport(1, 3126.010010, -3709.010010, 119.519997)
  1501.     end
  1502.  
  1503.     if(intid == 3747) then -- Taerar
  1504.     player:GossipComplete()
  1505.     player:Teleport(0, -10431.503906, -421.919006, 43.980788)
  1506.     end
  1507.  
  1508.     if(intid == 3748) then -- Ysondre
  1509.     player:GossipComplete()
  1510.     player:Teleport(1, 3126.010010, -3709.010010, 119.519997)
  1511.     end
  1512.  
  1513.     if(intid == 3749) then -- Kazzak
  1514.     player:GossipComplete()
  1515.     player:Teleport(530, 889.394165, 2298.253906, 299.099335)
  1516.     end
  1517.  
  1518.     if(intid == 3750) then -- Doomwalker
  1519.     player:GossipComplete()
  1520.     player:Teleport(530, -3604.309326, 317.521149, 38.965004)
  1521.     end
  1522.  
  1523.     if(intid == 3751) then -- Icecrown Citadel
  1524.     player:GossipComplete()
  1525.     player:Teleport(571, 5817.117188, 2084.855713, 636.064209)
  1526.     end
  1527.  
  1528.     if(intid == 3752) then -- Halls of Reflection
  1529.     player:GossipComplete()
  1530.     player:Teleport(668, 5280.481934, 1976.010010, 707.695190)
  1531.     end
  1532.  
  1533.     if(intid == 3753) then -- Pit of Saron
  1534.     player:GossipComplete()
  1535.     player:Teleport(658, 435.743011, 212.412994, 528.708984)
  1536.     end
  1537.  
  1538.     if(intid == 3754) then -- Forge of Souls
  1539.     player:GossipComplete()
  1540.     player:Teleport(632, 4922.744629, 2175.815186, 638.734009)
  1541.     end
  1542.  
  1543.     if(intid == 3755) then -- Trial of the Champion
  1544.     player:GossipComplete()
  1545.     player:Teleport(650, 805.216003, 618.056030, 412.393005)
  1546.     end
  1547.  
  1548.     if(intid == 3756) then -- Trial of the Crusader
  1549.     player:GossipComplete()
  1550.     player:Teleport(649, 563.881775, 79.318825, 395.207458)
  1551.     end
  1552.  
  1553.     if(intid == 3757) then -- The Argent Tournament Grounds
  1554.     player:GossipComplete()
  1555.     player:Teleport(571, 8437.063477, 866.838257, 547.293030)
  1556.     end
  1557.  
  1558.     if(intid == 3758) then -- The Ulduar
  1559.     player:GossipComplete()
  1560.     player:Teleport(603, -914.041016, -148.979996, 463.136993)
  1561.     end
  1562.  
  1563.     if(intid == 3759) then -- Naxxramass
  1564.     player:GossipComplete()
  1565.     player:Teleport(571, 3667.206299, -1277.371582, 243.644684)
  1566.     end
  1567.  
  1568.     if(intid == 3760) then -- Vault of Archavon
  1569.     player:GossipComplete()
  1570.     player:Teleport(624, -505.959991, -103.352997, 157.000000)
  1571.     end
  1572.  
  1573.     if(intid == 3761) then -- The Violet Hold
  1574.     player:GossipComplete()
  1575.     player:Teleport(608, 1829.337524, 803.186462, 44.360580)
  1576.     end
  1577.  
  1578.     if(intid == 3762) then -- The Nexus
  1579.     player:GossipComplete()
  1580.     player:Teleport(576, 172.538330, -5.488685, -16.636000)
  1581.     end
  1582.  
  1583.     if(intid == 3763) then -- Azjol Nerub
  1584.     player:GossipComplete()
  1585.     player:Teleport(601, 413.313995, 795.968018, 831.351013)
  1586.     end
  1587.  
  1588.     if(intid == 3764) then -- The Obsidian Sanctum
  1589.     player:GossipComplete()
  1590.     player:Teleport(615, 3228.580078, 385.859985, 65.549004)
  1591.     end
  1592.  
  1593.     if(intid == 3765) then -- Halls of Lightning
  1594.     player:GossipComplete()
  1595.     player:Teleport(602, 1331.469971, 259.618988, 53.397999)
  1596.     end
  1597.  
  1598.     if(intid == 3766) then -- Halls of Stone
  1599.     player:GossipComplete()
  1600.     player:Teleport(599, 1153.239990, 806.164001, 195.936996)
  1601.     end
  1602.  
  1603.     if(intid == 3767) then -- Gundrak
  1604.     player:GossipComplete()
  1605.     player:Teleport(604, 1894.579956, 652.713013, 176.666000)
  1606.     end
  1607.  
  1608.     if(intid == 3768) then -- The Oculus
  1609.     player:GossipComplete()
  1610.     player:Teleport(578, 1066.984985, 980.481567, 361.070709)
  1611.     end
  1612.  
  1613.     if(intid == 3769) then -- Battleground Warsong Gulch
  1614.     player:SendBattlegroundWindow(player, 2)
  1615.     end
  1616.  
  1617.     if(intid == 3770) then -- Battleground Arathi Basin
  1618.     player:SendBattlegroundWindow(player, 3)
  1619.     end
  1620.  
  1621.     if(intid == 3771) then -- Battleground Eye of the Storm
  1622.     player:SendBattlegroundWindow(player, 7)
  1623.     end
  1624.  
  1625.     if(intid == 3772) then -- The Black Temple
  1626.     player:GossipComplete()
  1627.     player:Teleport(564, 96.446198, 1002.349976, -86.998398)
  1628.     end
  1629.  
  1630.     if(intid == 3774) then -- Bind Location
  1631.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1632.  
  1633.     local MagicGold = GetMagicGold:GetColumn(0):GetLong()
  1634.  
  1635.     if (MagicGold < 10) then
  1636.     player:SendBroadcastMessage("Not enough MG.")
  1637.     player:GossipComplete()
  1638.  
  1639.     else
  1640.  
  1641.     WorldDBQuery("UPDATE wisdomwo_logon.accounts SET `mg` = '"..MagicGold.."'-'10' WHERE `login` = '"..player:GetAccountName().."'; ");
  1642.  
  1643.     player:FullCastSpell(3286)
  1644.     local GetMagicGoldLeft = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1645.  
  1646.     local MagicGoldLeftz = GetMagicGoldLeft:GetColumn(0):GetString()
  1647.     player:SendBroadcastMessage("|cffEC3131Spent 10 MG, total left: "..MagicGoldLeftz..".|r")
  1648.     player:GossipComplete()
  1649.     end
  1650.     end
  1651.  
  1652.     if(intid == 3800) then -- teleport to team leader
  1653.     if player:IsInGroup() then
  1654.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1655.  
  1656.     local MagicGold = GetMagicGold:GetColumn(0):GetLong()
  1657.  
  1658.     if (MagicGold <= 49) then
  1659.     player:SendBroadcastMessage("cffEC3131Not enough MG, required 50.|r")
  1660.     player:GossipComplete()
  1661.     else
  1662.     WorldDBQuery("UPDATE wisdomwo_logon.accounts SET `mg` = '"..MagicGold.."'-'50' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
  1663.     local Leader = player:GetGroupLeader()
  1664.     local Lmap = Leader:GetMapId()
  1665.     local Lx = Leader:GetX()
  1666.     local Ly = Leader:GetY()
  1667.     local Lz = Leader:GetZ()
  1668.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1669.  
  1670.     local MagicGoldLeft = GetMagicGold:GetColumn(0):GetString()
  1671.     player:SendBroadcastMessage("|cffEC3131Teleporting to group leader: |Hplayer:"..Leader:GetName().."|h["..Leader:GetName().."]|h. Spent 50, total left: "..MagicGoldLeft.." mg|r.")
  1672.     player:Teleport(Lmap, Lx, Ly, Lz)
  1673.     player:GossipComplete()
  1674.     end
  1675.     elseif (player:IsInGroup() == false) then
  1676.     player:SendBroadcastMessage("your not in any group")
  1677.     player:GossipComplete()
  1678.     end
  1679.     end
  1680.  
  1681.     if(intid == 3801) then
  1682.     item:GossipCreateMenu(54, player, 0)
  1683.     item:GossipMenuAddItem(7, "..Main page\n ", 75, 0)
  1684.     item:GossipMenuAddItem(2, "summon (type summoner name)\n This service costs 500 MG & name should be like \'\'Name\'\'", 3802, 1)
  1685.     item:GossipSendMenu(player)
  1686.     end
  1687.  
  1688.     if(intid == 3802) then -- summon a player
  1689.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1690.  
  1691.     local MagicGold = GetMagicGold:GetColumn(0):GetLong()
  1692.  
  1693.     if(GetPlayer(code) == false) or (MagicGold < 500) then
  1694.     player:SendBroadcastMessage("|cffEC3131This person is either offline or not enough mg.|r")
  1695.     player:GossipComplete()
  1696.     -----
  1697.     elseif (GetPlayer(code):IsInCombat() == true) then
  1698.     player:SendBroadcastMessage("|cffEC3131The target is in combat.|r")
  1699.     player:GossipComplete()
  1700.     -----
  1701.     elseif (GetPlayer(code):CanUseCommand("q")) then
  1702.     player:SendBroadcastMessage("|cffEC3131You should not summon GMs.|r")
  1703.     player:GossipComplete()
  1704.  
  1705.     else
  1706.     local GetMagicGold = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1707.  
  1708.     local MagicGold = GetMagicGold:GetColumn(0):GetString()
  1709.  
  1710.     WorldDBQuery("UPDATE wisdomwo_logon.accounts SET `mg` = '"..MagicGold.."'-'500' WHERE `login` = '"..player:GetAccountName().."' LIMIT 1; ");
  1711.  
  1712.     plr = GetPlayer(code)
  1713.     local Lmap = player:GetMapId()
  1714.     local Lx = player:GetX()
  1715.     local Ly = player:GetY()
  1716.     local Lz = player:GetZ()
  1717.  
  1718.     plr:SendBroadcastMessage("Vip: "..player:GetName().." is summoning you.")
  1719.     plr:Teleport(Lmap, Lx, Ly, Lz)
  1720.  
  1721.     local GetMagicGoldish = WorldDBQuery("SELECT `mg` FROM wisdomwo_logon.accounts WHERE `login` = '"..player:GetAccountName().."';");
  1722.  
  1723.     local MagicGoldLeft = GetMagicGoldish:GetColumn(0):GetString()
  1724.  
  1725.     player:SendBroadcastMessage("|cffEC3131You are porting |Hplayer:"
  1726.     ..plr:GetName().."|h["..plr:GetName().."]|h. Spent 500, total left "..MagicGoldLeft.." mg.|r")
  1727.  
  1728.     logcol(11)
  1729.     print ("Vip "..player:GetName().." has summoned player "..code..".")
  1730.     player:GossipComplete()
  1731.     end
  1732.     end
  1733.  
  1734.  
  1735.  
  1736.     if(intid == 3810) then
  1737.     item:GossipCreateMenu(54, player, 0)
  1738.     item:GossipMenuAddItem(7, "..Main page\n ", 75, 0)
  1739.     item:GossipMenuAddItem(2, "undress (normal clothes)\n ", 3809, 0)
  1740.     item:GossipMenuAddItem(2, "fix scale (back to 1)\n ", 3815, 0)
  1741.     item:GossipMenuAddItem(2, "dressing room\n", 3811, 0)
  1742.     item:GossipMenuAddItem(2, "zoom in / out\n", 3812, 0)
  1743.     item:GossipSendMenu(player)
  1744.     end
  1745.  
  1746.     if(intid == 3809) then
  1747.     player:DeMorph()
  1748.     player:GossipComplete()
  1749.     end
  1750.  
  1751.     if(intid == 3811) then
  1752.     item:GossipCreateMenu(54, player, 0)
  1753.     item:GossipMenuAddItem(0, "..return\n", 3810, 0)
  1754.     item:GossipMenuAddItem(2, "tyrande", 60001, 0)
  1755.     item:GossipMenuAddItem(2, "thrall", 60002, 0)
  1756.     item:GossipMenuAddItem(2, "jaina", 60003, 0)
  1757.     item:GossipMenuAddItem(2, "sylvanas", 60004, 0)
  1758.     item:GossipMenuAddItem(2, "rexxar", 60005, 0)
  1759.     item:GossipMenuAddItem(2, "archimonde", 60006, 0)
  1760.     item:GossipMenuAddItem(2, "medivh", 60007, 0)
  1761.     item:GossipMenuAddItem(2, "malfurion", 60008, 0)
  1762.     item:GossipMenuAddItem(2, "illidan", 60009, 0)
  1763.     item:GossipMenuAddItem(2, "lich king", 60010, 0)
  1764.     item:GossipSendMenu(player)
  1765.     end
  1766.  
  1767.     if(intid == 3812) then
  1768.     item:GossipCreateMenu(54, player, 0)
  1769.     item:GossipMenuAddItem(0, "..return\n", 3810, 0)
  1770.     item:GossipMenuAddItem(2, "zoom in\n ", 3813, 0)
  1771.     item:GossipMenuAddItem(2, "zoom out\n ", 3814, 0)
  1772.     item:GossipSendMenu(player)
  1773.     end
  1774.  
  1775.     if(intid == 3813) then
  1776.     player:GossipComplete()
  1777.     if(player:GetCoinage() <= 9999) then
  1778.     player:SendBroadcastMessage("Not enough gold.")
  1779.     item:GossipCreateMenu(100, player, 0)
  1780.     item:GossipMenuAddItem(9, "..Return", 8080, 0)
  1781.     item:GossipSendMenu(player)
  1782.     else
  1783.     player:GossipComplete()
  1784.     player:DealGoldCost(10000)
  1785.     player:SetScale(1.5)
  1786.     item:GossipCreateMenu(55, player, 0)
  1787.     item:GossipMenuAddItem(10, "Go Next+1", 51002, 0)
  1788.     item:GossipSendMenu(player)
  1789.     end
  1790.     end
  1791.  
  1792.     if(intid == 51002) then
  1793.     item:GossipCreateMenu(55, player, 0)
  1794.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1795.     item:GossipMenuAddItem(2, "Zoom In", 51003, 0)
  1796.     item:GossipMenuAddItem(2, " ", 51003, 0)
  1797.     item:GossipSendMenu(player)
  1798.     end
  1799.  
  1800.     if(intid == 51003) then
  1801.     player:GossipComplete()
  1802.     if(player:GetCoinage() <= 9999) then
  1803.     player:SendBroadcastMessage("Not enough gold.")
  1804.     item:GossipCreateMenu(100, player, 0)
  1805.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1806.     item:GossipSendMenu(player)
  1807.     else
  1808.     player:GossipComplete()
  1809.     player:DealGoldCost(10000)
  1810.     player:SetScale(2)
  1811.     item:GossipCreateMenu(55, player, 0)
  1812.     item:GossipMenuAddItem(10, "Go Next+2", 51004, 0)
  1813.     item:GossipSendMenu(player)
  1814.     end
  1815.     end
  1816.  
  1817.     if(intid == 51004) then
  1818.     item:GossipCreateMenu(55, player, 0)
  1819.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1820.     item:GossipMenuAddItem(2, "Zoom In", 51005, 0)
  1821.     item:GossipMenuAddItem(2, " ", 51005, 0)
  1822.     item:GossipSendMenu(player)
  1823.     end
  1824.  
  1825.     if(intid == 51005) then
  1826.     player:GossipComplete()
  1827.     if(player:GetCoinage() <= 9999) then
  1828.     player:SendBroadcastMessage("Not enough gold.")
  1829.     item:GossipCreateMenu(100, player, 0)
  1830.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1831.     item:GossipSendMenu(player)
  1832.     else
  1833.     player:GossipComplete()
  1834.     player:DealGoldCost(10000)
  1835.     player:SetScale(2.5)
  1836.     item:GossipCreateMenu(55, player, 0)
  1837.     item:GossipMenuAddItem(10, "Go Next+3", 51006, 0)
  1838.     item:GossipSendMenu(player)
  1839.     end
  1840.     end
  1841.  
  1842.     if(intid == 51006) then
  1843.     item:GossipCreateMenu(55, player, 0)
  1844.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1845.     item:GossipMenuAddItem(2, "Zoom In", 51007, 0)
  1846.     item:GossipMenuAddItem(2, " ", 51007, 0)
  1847.     item:GossipSendMenu(player)
  1848.     end
  1849.  
  1850.     if(intid == 51007) then
  1851.     player:GossipComplete()
  1852.     if(player:GetCoinage() <= 9999) then
  1853.     player:SendBroadcastMessage("Not enough gold.")
  1854.     item:GossipCreateMenu(100, player, 0)
  1855.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1856.     item:GossipSendMenu(player)
  1857.     else
  1858.     player:GossipComplete()
  1859.     player:DealGoldCost(10000)
  1860.     player:SetScale(3)
  1861.     item:GossipCreateMenu(55, player, 0)
  1862.     item:GossipMenuAddItem(10, "Go Next+3", 51008, 0)
  1863.     item:GossipSendMenu(player)
  1864.     end
  1865.     end
  1866.  
  1867.     if(intid == 51008) then
  1868.     item:GossipCreateMenu(55, player, 0)
  1869.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1870.     item:GossipMenuAddItem(2, "Zoom In", 51009, 0)
  1871.     item:GossipMenuAddItem(2, " ", 51009, 0)
  1872.     item:GossipSendMenu(player)
  1873.     end
  1874.  
  1875.     if(intid == 51009) then
  1876.     player:GossipComplete()
  1877.     if(player:GetCoinage() <= 9999) then
  1878.     player:SendBroadcastMessage("Not enough gold.")
  1879.     item:GossipCreateMenu(100, player, 0)
  1880.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1881.     item:GossipSendMenu(player)
  1882.     else
  1883.     player:GossipComplete()
  1884.     player:DealGoldCost(10000)
  1885.     player:SetScale(3.5)
  1886.     item:GossipCreateMenu(55, player, 0)
  1887.     item:GossipMenuAddItem(10, "Go Next+3", 51010, 0)
  1888.     item:GossipSendMenu(player)
  1889.     end
  1890.     end
  1891.  
  1892.     if(intid == 51010) then
  1893.     item:GossipCreateMenu(55, player, 0)
  1894.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1895.     item:GossipMenuAddItem(2, "cannot zoom in (click to return)", 75, 0)
  1896.     item:GossipMenuAddItem(2, " ", 75, 0)
  1897.     item:GossipSendMenu(player)
  1898.     end
  1899.  
  1900.     if(intid == 3814) then
  1901.     player:GossipComplete()
  1902.     if(player:GetCoinage() <= 9999) then
  1903.     player:SendBroadcastMessage("Not enough gold.")
  1904.     item:GossipCreateMenu(100, player, 0)
  1905.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1906.     item:GossipSendMenu(player)
  1907.     else
  1908.     player:GossipComplete()
  1909.     player:DealGoldCost(10000)
  1910.     player:SetScale(0.9)
  1911.     item:GossipCreateMenu(55, player, 0)
  1912.     item:GossipMenuAddItem(10, "Go Next -1", 51012, 0)
  1913.     item:GossipSendMenu(player)
  1914.     end
  1915.     end
  1916.  
  1917.     if(intid == 51012) then
  1918.     player:GossipComplete()
  1919.     item:GossipCreateMenu(55, player, 0)
  1920.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1921.     item:GossipMenuAddItem(2, "Zoom Out", 51013, 0)
  1922.     item:GossipMenuAddItem(2, " ", 51013, 0)
  1923.     item:GossipSendMenu(player)
  1924.     end
  1925.  
  1926.     if(intid == 51013) then
  1927.     player:GossipComplete()
  1928.     if(player:GetCoinage() <= 9999) then
  1929.     player:SendBroadcastMessage("Not enough gold.")
  1930.     item:GossipCreateMenu(100, player, 0)
  1931.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1932.     item:GossipSendMenu(player)
  1933.     else
  1934.     player:GossipComplete()
  1935.     player:DealGoldCost(10000)
  1936.     player:SetScale(0.8)
  1937.     item:GossipCreateMenu(55, player, 0)
  1938.     item:GossipMenuAddItem(10, "Go Next -2", 51015, 0)
  1939.     item:GossipSendMenu(player)
  1940.     end
  1941.     end
  1942.  
  1943.     if(intid == 51015) then
  1944.     item:GossipCreateMenu(55, player, 0)
  1945.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1946.     item:GossipMenuAddItem(2, "Zoom Out", 51016, 0)
  1947.     item:GossipMenuAddItem(2, " ", 51016, 0)
  1948.     item:GossipSendMenu(player)
  1949.     end
  1950.  
  1951.     if(intid == 51016) then
  1952.     player:GossipComplete()
  1953.     if(player:GetCoinage() <= 9999) then
  1954.     player:SendBroadcastMessage("Not enough gold.")
  1955.     item:GossipCreateMenu(100, player, 0)
  1956.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1957.     item:GossipSendMenu(player)
  1958.     else
  1959.     player:GossipComplete()
  1960.     player:DealGoldCost(10000)
  1961.     player:SetScale(0.7)
  1962.     item:GossipCreateMenu(55, player, 0)
  1963.     item:GossipMenuAddItem(10, "Go Next -3", 51017, 0)
  1964.     item:GossipSendMenu(player)
  1965.     end
  1966.     end
  1967.  
  1968.     if(intid == 51017) then
  1969.     item:GossipCreateMenu(55, player, 0)
  1970.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1971.     item:GossipMenuAddItem(2, "Zoom Out", 51018, 0)
  1972.     item:GossipMenuAddItem(2, " ", 51018, 0)
  1973.     item:GossipSendMenu(player)
  1974.     end
  1975.  
  1976.     if(intid == 51018) then
  1977.     player:GossipComplete()
  1978.     if(player:GetCoinage() <= 9999) then
  1979.     player:SendBroadcastMessage("Not enough gold.")
  1980.     item:GossipCreateMenu(100, player, 0)
  1981.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  1982.     item:GossipSendMenu(player)
  1983.     else
  1984.     player:GossipComplete()
  1985.     player:DealGoldCost(10000)
  1986.     player:SetScale(0.6)
  1987.     item:GossipCreateMenu(55, player, 0)
  1988.     item:GossipMenuAddItem(10, "Go Next -4", 51019, 0)
  1989.     item:GossipSendMenu(player)
  1990.     end
  1991.     end
  1992.  
  1993.     if(intid == 51019) then
  1994.     item:GossipCreateMenu(55, player, 0)
  1995.     item:GossipMenuAddItem(2, "..Return", 3810, 0)
  1996.     item:GossipMenuAddItem(2, "Zoom Out", 51020, 0)
  1997.     item:GossipMenuAddItem(2, " ", 51020, 0)
  1998.     item:GossipSendMenu(player)
  1999.     end
  2000.  
  2001.     if(intid == 51020) then
  2002.     player:GossipComplete()
  2003.     if(player:GetCoinage() <= 9999) then
  2004.     player:SendBroadcastMessage("Not enough gold.")
  2005.     item:GossipCreateMenu(100, player, 0)
  2006.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2007.     item:GossipSendMenu(player)
  2008.     else
  2009.     player:GossipComplete()
  2010.     player:DealGoldCost(10000)
  2011.     player:SetScale(0.5)
  2012.     item:GossipCreateMenu(55, player, 0)
  2013.     item:GossipMenuAddItem(10, "Go Next -5", 51021, 0)
  2014.     item:GossipSendMenu(player)
  2015.     end
  2016.     end
  2017.  
  2018.     if(intid == 51021) then
  2019.     item:GossipCreateMenu(55, player, 0)
  2020.     item:GossipMenuAddItem(2, "..Return", 75, 0)
  2021.     item:GossipMenuAddItem(2, "cannot zoom out (click to return)", 75, 0)
  2022.     item:GossipMenuAddItem(2, " ", 75, 0)
  2023.     item:GossipSendMenu(player)
  2024.     end
  2025.  
  2026.     if(intid == 60001) then
  2027.     player:GossipComplete()
  2028.     if(player:GetCoinage() <= 9999) then
  2029.     item:GossipCreateMenu(100, player, 0)
  2030.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2031.     item:GossipSendMenu(player)
  2032.     else
  2033.     player:DealGoldCost(10000)
  2034.     player:SetModel(7274)
  2035.     player:GossipComplete()
  2036.     end
  2037.     end
  2038.  
  2039.     if(intid == 60002) then
  2040.     player:GossipComplete()
  2041.     if(player:GetCoinage() <= 9999) then
  2042.     item:GossipCreateMenu(100, player, 0)
  2043.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2044.     item:GossipSendMenu(player)
  2045.     else
  2046.     player:DealGoldCost(10000)
  2047.     player:SetModel(19015)
  2048.     player:GossipComplete()
  2049.     end
  2050.     end
  2051.  
  2052.     if(intid == 60003) then
  2053.     player:GossipComplete()
  2054.     if(player:GetCoinage() <= 9999) then
  2055.     item:GossipCreateMenu(100, player, 0)
  2056.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2057.     item:GossipSendMenu(player)
  2058.     else
  2059.     player:DealGoldCost(10000)
  2060.     player:SetModel(30865)
  2061.     player:GossipComplete()
  2062.     end
  2063.     end
  2064.  
  2065.     if(intid == 60004) then
  2066.     player:GossipComplete()
  2067.     if(player:GetCoinage() <= 9999) then
  2068.     item:GossipCreateMenu(100, player, 0)
  2069.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2070.     item:GossipSendMenu(player)
  2071.     else
  2072.     player:DealGoldCost(10000)
  2073.     player:SetModel(28213)
  2074.     player:GossipComplete()
  2075.     end
  2076.     end
  2077.  
  2078.     if(intid == 60005) then
  2079.     player:GossipComplete()
  2080.     if(player:GetCoinage() <= 9999) then
  2081.     item:GossipCreateMenu(100, player, 0)
  2082.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2083.     item:GossipSendMenu(player)
  2084.     else
  2085.     player:DealGoldCost(10000)
  2086.     player:SetModel(20918)
  2087.     player:GossipComplete()
  2088.     end
  2089.     end
  2090.  
  2091.     if(intid == 60006) then
  2092.     player:GossipComplete()
  2093.     if(player:GetCoinage() <= 9999) then
  2094.     item:GossipCreateMenu(100, player, 0)
  2095.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2096.     item:GossipSendMenu(player)
  2097.     else
  2098.     player:DealGoldCost(10000)
  2099.     player:SetModel(20330)
  2100.     player:GossipComplete()
  2101.     end
  2102.     end
  2103.  
  2104.     if(intid == 60007) then
  2105.     player:GossipComplete()
  2106.     if(player:GetCoinage() <= 9999) then
  2107.     item:GossipCreateMenu(100, player, 0)
  2108.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2109.     item:GossipSendMenu(player)
  2110.     else
  2111.     player:DealGoldCost(10000)
  2112.     player:SetModel(18718)
  2113.     player:GossipComplete()
  2114.     end
  2115.     end
  2116.  
  2117.     if(intid == 60008) then
  2118.     player:GossipComplete()
  2119.     if(player:GetCoinage() <= 9999) then
  2120.     item:GossipCreateMenu(100, player, 0)
  2121.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2122.     item:GossipSendMenu(player)
  2123.     else
  2124.     player:DealGoldCost(10000)
  2125.     player:SetModel(15399)
  2126.     player:GossipComplete()
  2127.     end
  2128.     end
  2129.  
  2130.     if(intid == 60009) then
  2131.     player:GossipComplete()
  2132.     if(player:GetCoinage() <= 9999) then
  2133.     item:GossipCreateMenu(100, player, 0)
  2134.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2135.     item:GossipSendMenu(player)
  2136.     else
  2137.     player:DealGoldCost(10000)
  2138.     player:SetModel(25277)
  2139.     player:GossipComplete()
  2140.     end
  2141.     end
  2142.  
  2143.     if(intid == 60010) then
  2144.     player:GossipComplete()
  2145.     if(player:GetCoinage() <= 9999) then
  2146.     item:GossipCreateMenu(100, player, 0)
  2147.     item:GossipMenuAddItem(9, "Back to service", 8080, 0)
  2148.     item:GossipSendMenu(player)
  2149.     else
  2150.     player:DealGoldCost(10000)
  2151.     player:SetModel(24191)
  2152.     player:GossipComplete()
  2153.     end
  2154.     end
  2155.  
  2156.     if(intid == 3815) then
  2157.     player:SetScale(1)
  2158.     player:GossipComplete()
  2159.     end
  2160. end
  2161.  
  2162. RegisterItemGossipEvent(150000, 1, "Itemshirt_Trigger")
  2163. RegisterItemGossipEvent(150000, 2, "OnSelect")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement