Portals rather than taxi's ( MaNGOS )

[BazookaJoe]

I had gotten fed up with the zepp's and ship's not working correctly in the older versions of Mangos, users weren't able to get around without a GM's help, so I made portals to take their place.

The Hyjal entrance and exit are from Trashman ( thank you very much ), the rest are my own. I figured I'd share them if they can help anyone. They are all tested and working, I currently use them on my own server.

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20010, "Custom Portal to Hyjal", 1, "4613,01", "-3862,19", "944,181", 1, "4613,01", "-3862,19", "944,181", "1,14669");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20011, "Custom Portal Hyjal Exit", 1, "4564,43", "-3930,55", "942,134", 1, "4564,43", "-3930,55", "942,134", "0,77755");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20012, "Custom Portal Booty Bay", 0, "-14280.4", "551.14", "8.904", 0, "-14280.4", "551.14", "8.904", "0,77755");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20013, "Custom Portal Ratchet", 1, "-988", "-3826", "5.633", 1, "-988", "-3826", "5.633", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20014, "Custom Portal Menethil Harbor A", 0, "-3735.145", "-576.944", "6.01", 0, "-3735.145", "-576.944", "6.01", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20015, "Custom Portal Menethil Harbor B", 0, "-3879.044", "-596.364", "5.896", 0, "-3879.044", "-596.364", "5.896", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20016, "Custom Portal Theramore Isle", 1, "-4003.83", "-4729.847", "5.167", 1, "-4003.83", "-4729.847", "5.167", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20017, "Custom Portal Auberdine", 1, "6539.33", "915.22", "5.69", 1, "6539.33", "915.22", "5.69", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20018, "Custom Portal Teldrassil", 1, "8553.778", "1021.741", "5.53", 1, "8553.778", "1021.741", "5.53", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20019, "Custom Portal Tirisfal Glades A", 0, "2060.284", "239.846", "99.78", 0, "2060.284", "239.846", "99.78", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20020, "Custom Portal Tirisfal Glades B", 0, "2070.09", "286.148", "97.033", 0, "2070.09", "286.148", "97.033", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20021, "Custom Portal Durotar A", 1, "1326.187", "-4643.18", "53.98", 1, "1326.187", "-4643.18", "53.98", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20022, "Custom Portal Durotar B", 1, "1356.96", "-4635.63", "53.57", 1, "1356.96", "-4635.63", "53.57", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20023, "Custom Portal Grom'gol Base Camp A", 0, "-12411.688", "213.803", "31.315", 0, "-12411", "213.803", "31.315", "0,0");

INSERT INTO areatrigger_template
(id, name, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(20024, "Custom Portal Grom'gol Base Camp B", 0, "-12442.206", "222.765", "31.737", 0, "-12442.206", "222.765", "31.737", "0,0");

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300010, 27, 1327, "Hyjal Entrance", 0, 64, 1, 20010, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300011, 27, 1327, "Hyjal Exit", 0, 64, 1, 20011, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300012, 27, 1327, "Booty Bay", 0, 64, 1, 20012, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300013, 27, 1327, "Ratchet", 0, 64, 1, 20013, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300014, 27, 1327, "Menethil Harbor", 0, 64, 1, 20014, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300015, 27, 1327, "Menethil Harbor", 0, 64, 1, 20015, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300016, 27, 1327, "Theramore Isle", 0, 64, 1, 20016, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300017, 27, 1327, "Auberdine", 0, 64, 1, 20017, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300018, 27, 1327, "Teldrassil", 0, 64, 1, 20018, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300019, 27, 1327, "Tirisfal Glades", 0, 64, 1, 20019, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300020, 27, 1327, "Tirisfal Glades", 0, 64, 1, 20020, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300021, 27, 1327, "Durotar", 0, 64, 1, 20021, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300022, 27, 1327, "Durotar", 0, 64, 1, 20022, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300023, 27, 1327, "Grom'gol Base Camp", 0, 64, 1, 20023, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, ScriptName, castsSpell)
VALUES
(300024, 27, 1327, "Grom'gol Base Camp", 0, 64, 1, 20024, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0);

[MentaL]

[kennythekid]

nice work but can u make portals for the city? like ogrimmar - undercity
stormwind - darnasuss and so one :)

edit: how do u add them ? or are spawn directly at the xyz cords wen u insert them in db ? i don't know this one ...need assistance :D
and commands if there are for those to add

[tr4shm4n]

to place go's in mangos just use .gameobject objectnumber
to target is .target
to del is .delobject GUILDNUMBER << You will get that number after targeting the object >>

[kennythekid]

i manage to do that the delete part its a little ununderstanding cuz i can't select the portal or nothing happends

another question ... when i was trying to put the portal by mistake i delete one npc the windmaster from ogrimmar ... now i found it i put it there but it doesn't work ... what seems to be the problem ... here u have to do something alse for adding masters npc or something i did .delobject and the npc disapeard with msg Creature deleted ... and i didn't selected or something how do i make it to work again ?

[kennythekid]

Portals to all the Capitol cities already exist in DB, Their ID numbers are as follows.

Stormwind - 176296
IronForge - 176497
Darnassus - 176498
Ogrimaar - 176499
Thunder Bluff - 176500
Undercity - 176501

The command to add gameobjects is .addgo <ID#>

So if you want a portal to booty bay you'd type .addgo 300012 ( assuming you have already added custom portals to your MaNGOS DB)
Created Gameobjects do not stay permanent until the server has been reset. This means that after you make a chest or portal or statue or whatever, it will disappear soon after and stay gone until the server has been reset. The same goes for NPCs.

to delete gamejects, stand close to them and type .targetgo
then type .delobject <GUID#>

No these do not appear automatically at the coord's you have to put them there yourself using the .addgo command.

If not sure how to add the script to your db, just copy and paste the script listed in the first post into a custom_portals.txt file. Then rename the file to Custom_portals.sql

Open Navicat select MaNGOS DB and execute batch file.
browse to custom_portals.sql

These Portals teleport you to the docks and towers where you'd normally get on and off the zepps and ships. So I therefore created more than one portal for the Zepplin Tower near Undercity, Durotar and Grom'Gol aswell as Menethil Harbor, because ithey all have 2 points of departure and 2 points of arrival, aptly named A and B. Play around with them, you'll see what I mean.

I hope this helps.

u have alot of errors in the sql files the aria_triggers zone because of the ",' insted of "."

[BazookaJoe]

Portals to all the Capitol cities already exist in DB, Their ID numbers are as follows.

Stormwind - 176296
IronForge - 176497
Darnassus - 176498
Ogrimaar - 176499
Thunder Bluff - 176500
Undercity - 176501

The command to add gameobjects is .addgo <ID#>

So if you want a portal to booty bay you'd type .addgo 300012 ( assuming you have already added custom portals to your MaNGOS DB)
Created Gameobjects do not stay permanent until the server has been reset. This means that after you make a chest or portal or statue or whatever, it will disappear soon after and stay gone until the server has been reset. The same goes for NPCs.

to delete gamejects, stand close to them and type .targetgo
then type .delobject <GUID#>

No these do not appear automatically at the coord's you have to put them there yourself using the .addgo command.

If not sure how to add the script to your db, just copy and paste the script listed in the first post into a custom_portals.txt file. Then rename the file to Custom_portals.sql

Open Navicat select MaNGOS DB and execute batch file.
browse to custom_portals.sql

These Portals teleport you to the docks and towers where you'd normally get on and off the zepps and ships. So I therefore created more than one portal for the Zepplin Tower near Undercity, Durotar and Grom'Gol aswell as Menethil Harbor, because ithey all have 2 points of departure and 2 points of arrival, aptly named A and B. Play around with them, you'll see what I mean.

I hope this helps.

[Zer0xe]

That was really good. Thanks alot.


Signed,
Zer0xe

[BazookaJoe]

u have alot of errors in the sql files the aria_triggers zone because of the ",' insted of "."

Hmm, thats strange Kenny, I have run this script on 3 seperate servers, since you posted, and I have not recieved a single error.
Also had a friend try it on her server, she said they worked fine also.
I used the same syntax as Trashman by the way and nobody posted that it was full of errors. ( thanks again, Trashman )

Sorry if they didn't work for you Kenny, I suspect maybe you have a differant version of MYSQL perhaps. Or maybe your clothes are haunted?

[m75mpm]

If not sure how to add the script to your db, just copy and paste the script listed in the first post into a custom_portals.txt file. Then rename the file to Custom_portals.sql

Open Navicat select MaNGOS DB and execute batch file.
browse to custom_portals.sql

I'm having this error: "1265 - Data truncated for column 'trigger_position_x' at row 1" :|

[denile]

Well I added the portal for Hyjal to my DB.. I put it in place in stormwind.. It sends me to hyjal just fine.. but the portal wont STAY where i put it. It just vanishes. Anyone?

[Phoenixdk]

denile... Did you reset your server after adding the portal like BazookaJoe said?

[genemnc]

does any one have id #for the bc