Does any one have a mangos portal SQl file/install? There was one that came with a repack back when Mangos Server files was updated regularly. But, They've been no longer available.
Quake
Printable View
Does any one have a mangos portal SQl file/install? There was one that came with a repack back when Mangos Server files was updated regularly. But, They've been no longer available.
Quake
Enough, the dev section doesn't favor any emu. Keep it civil.
fair enuff Emrys
was simply trying to help :)
Then post something helpful next time, I mean if you would've adviced him to switch to ascent using some good arguments then I would be the last one to delete anyting.
But we simply don't favor emu's
A week or 2 back i have posted the way to make portals in an post . Dunno witch post it was anymore but try searching you might find it .
Finaly some mod that do somthing bout the stupid use ascent posts . In mangos topics ;)
Thanks Tr4shm4n, I'll search your post's and or topics also.
Only cause I had to bring it to that level. ;)
Edit: I searched out the threads and post and didn't come up with anything. Now as for the advanced, I didn't use. And now I don't have the time cause work is calling. Well, not calling but will be if I don't get going soon. Will check back later.
Quake
Edit:
Checked out them SQL's and not quite what I was looking for but usefull. Thanks tr4shm4n.
Its in this post : http://forum.ragezone.com/f114/need-...server-327637/
OK, I used them SQL inserts. I only have one problem. Horde can not use the portals. Whats the faction number that makes it so all can use and or interact with. Right now they are set to Faction 115 Alliance has no issues with that faction and thus leting them use the portals. But Horde can not. Need the faction ID.
Edit:
It's not 14, 15, 115
Edit:
I'll try 474. I believe that's the number i found when i had to redo the GM Island one time.
Gm Island Portals and Ship Portals. All GM Island portals are placed in the starting areas.
Quote:
delete from `gameobject` where `id` in (666500,666501,666502,666503,666504,666505,666506, 666507,666509,666510,666511,666512);
INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `loot`, `spawntimesecs`, `animprogress`, `dynflags`)
VALUES
(666500, 0, -12449.7, 214.1, 31.3, 3.1, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- grom to org
(666501, 1, 1323.9, -4655.2, 53.6, 0.8, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- org to uc
(666502, 1, 1355.6, -4635.4, 53.6, 1.4, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- org to grom
(666503, 1, -988.6, -3824.5, 5.7, 6.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Ratchet To Booty Bay
(666504, 0, -14280.3, 552.6, 8.9, 0.9, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Booty Bay To Ratchet
(666505, 1, -4002.1, -4728.1, 5.0, 1.3, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Theramore To Menethil
(666506, 0, -3732.3, -579.6, 6.1, 4.9, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Menethil Habor To Darkshore
(666507, 0, -3882.2, -598.0, 5.8, 1.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Menethil Habor To Theramore
(666509, 1, -4352.6, 2422.1, 7.5, 4.7, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- feralas to feathermoon
(666510, 1, -4220.0, 3288.8, 7.4, 3.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- feathermoon to feralas
(666511, 1, 6536.5, 924.9, 5.9, 4.7, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0); -- Darkshore To Exodar
--
-- Portals to GM Island
--
INSERT INTO `gameobject` VALUES (95000, 666512, 0, -8915.31, 490.438, 93.8604, 2.24825, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0); -- To GM Island / Stormwind
INSERT INTO `gameobject` VALUES (95001, 666512, 0, -8976.29, 565.413, 93.8615, 5.37021, 0, 0, 0.4408, -0.897605, 0, 25, 0, 0); -- To GM Island / Stormwind
INSERT INTO `gameobject` VALUES (95002, 666512, 1, 10332.1, 829.269, 1326.3, 2.39076, 0, 0, 0.930354, 0.366662, 0, 25, 0, 0); -- To GM Island / Darnassus
INSERT INTO `gameobject` VALUES (95003, 666512, 530, 10337.1, -6380.56, 35.8932, 2.06323, 0, 0, 0.858129, 0.513433, 0, 25, 0, 0); -- To GM Island / Eversong Woods
INSERT INTO `gameobject` VALUES (95004, 666512, 530, -3959.16, -13913.8, 101.259, 3.00964, 0, 0, 0.997824, 0.0659285, 0, 25, 0, 0); -- To GM Island / Azuremyst Isle
INSERT INTO `gameobject` VALUES (95005, 666512, 0, -6164.4, 368.344, 400.158, 2.8714, 0, 0, 0.990888, 0.134686, 0, 25, 0, 0); -- To GM Island / Dum Morogh
INSERT INTO `gameobject` VALUES (95006, 666512, 1, -638.86, -4242.95, 38.1346, 5.85514, 0, 0, 0.212392, -0.977184, 0, 25, 0, 0); -- To GM Island / Durotar
INSERT INTO `gameobject` VALUES (95007, 666512, 0, 1672.73, 1677.44, 138.602, 5.61795, 0, 0, 0.326518, -0.945191, 0, 25, 0, 0); -- To GM Island / Tirisfal Glades
INSERT INTO `gameobject` VALUES (95008, 666512, 1, -2912.5, -291.06, 54.1476, 1.38073, 0, 0, 0.636819, 0.771014, 0, 25, 0, 0); -- To GM Island / Mulgore
INSERT INTO `gameobject` VALUES (95009, 666512, 0, -8923.02, -145.159, 81.3003, 3.34816, 0, 0, 0.994671, -0.1031, 0, 25, 0, 0); -- To GM Island / Elwynn Forest
INSERT INTO `gameobject` VALUES (95010, 666512, 1, 16223.6, 16298.6, 38.8738, 0.172404, 0, 0, 0.0860953, 0.996287, 0, 25, 0, 0); -- To GM Island / GM Island
--
-- Portals from GM Island
--
INSERT INTO `gameobject` VALUES (96000, 300003, 1, 16233.5, 16273.1, 14.139, 4.60854, 0, 0, 0.742854, -0.669453, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96001, 666503, 1, 16237.3, 16275.7, 14.8204, 5.17422, 0, 0, 0.526505, -0.850172, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96002, 300005, 1, 16241.7, 16278.6, 14.5491, 5.08571, 0, 0, 0.563599, -0.826049, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96003, 176498, 1, 16247, 16279.7, 14.0509, 4.90762, 0, 0, 0.634825, -0.772656, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96004, 300006, 1, 16251.8, 16280.7, 14.0681, 4.90638, 0, 0, 0.635304, -0.772262, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96005, 182351, 1, 16257, 16281.1, 14.9841, 1.93101, 0, 0, 0.822337, 0.569001, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96006, 666511, 1, 16261.6, 16283.5, 14.7858, 1.93051, 0, 0, 0.822193, 0.569209, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96007, 176497, 1, 16264, 16286.5, 14.1863, 2.50155, 0, 0, 0.949228, 0.314588, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96008, 176296, 1, 16268.1, 16294.6, 15.0503, 3.00415, 0, 0, 0.99764, 0.0686688, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96009, 666507, 1, 16268.7, 16299.4, 14.7848, 2.95701, 0, 0, 0.995744, 0.0921581, 0, 25, 0, 0);
INSERT INTO `gameobject` VALUES (96010, 666500, 1, 16266.7, 16289.5, 14.3787, 2.57363, 0, 0, 0.959948, 0.280179, 0, 25, 0, 0);
--
-- GM Island Elevator
--
INSERT INTO `gameobject` VALUES (96043, 4171, 1, 16271.3, 16303.5, 14.8734, 3.28218, 0, 0, 0.99753, -0.0702376, 0, 25, 0, 0);
--
-- Portals
--
delete from `gameobject_template` where `entry` in (666500,666501,666502,666503,666504,666505,666506, 666507,666509,666510,666511,666512);
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `sound10`, `sound11`, `sound12`, `sound13`, `sound14`, `sound15`, `sound16`, `sound17`, `sound18`, `sound19`, `sound20`, `sound21`, `sound22`, `sound23`, `ScriptName`)
Values
(666500, 22, 4396, 'Portal to Orgrimmar', 474, 0, 1, 4996, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666501, 22, 4396, 'Portal to Undercity', 474, 0, 1, 5000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666502, 22, 4396, 'Portal to Grom Gol Base Camp', 474, 0, 1, 4998, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666503, 22, 4396, 'Portal to Booty Bay', 474, 0, 1, 4997, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666504, 22, 4396, 'Portal to Ratchet', 474, 0, 1, 4999, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666505, 22, 4396, 'Portal to Minithel Habour', 474, 0, 1, 6348, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666506, 22, 4396, 'Portal to Darkshore', 474, 0, 3, 42527, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666507, 22, 4396, 'Portal to Theramore Island', 474, 0, 1, 6719, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666509, 22, 4396, 'Portal to Feathermoon', 474, 0, 1, 6483, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666510, 22, 4396, 'Portal to Feralas', 474, 0, 1, 6484, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666511, 22, 4396, 'Portal to Exodar Habour', 474, 0, 1, 16787, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666512, 22, 4396, 'Portal to GM Island Shopping', 474, 0, 1, 4801, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
--
-- GM Island Portal
--
delete from `areatrigger_template` where `id` in (4801);
INSERT INTO `areatrigger_template` (id, name , required_level, required_item, 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
(4801, "Portal to GM Island Shopping", 0, 0, 1, 16201.510742, 16256.522461, 21.210, 1, 16201.510742, 16256.522461, 21.210, 0.314153);
Above script works for:
Server : Mangos
Version : Revision 4479
DBase type : Project SilverMoon
DBase version : 18
ScriptDev version : ScriptDev2 Revision 136
Client version : 2.1.3(6869)