Mangos ships and zeppelins?

[teacher4]

Hi, I set up my mangos...everything good I'm just looking for minor bugs:

I noticed that the ship Teldrassil - Darkshore and the zeppelin Undercity - Grom'gol work fine.
All other ships don't work (thay sail out and stop where they should teleport, after ages they teleport exactly where they are and go back to the starting port)
The other zeppelins don't even show up.
Bottom line is: Zeppelins and ships on the same continent work, all the others which are coast to coast (teleport) don't work.
I can't find any proper table on my SQL db to fix it, not even the taxi node/path/pathnodes tables.
Can anyone help me?

p.s. I' don't really know which mangos version I have, it took me a while to get the right dev and revision to properly work together...

If you know anything, ANYTHING please tell me
Thanx

[MentaL]

[tr4shm4n]

It sould help if we knew reversion i for example have solve that problem by plasing customise portals to the towns those ships and zaps would go .

But then i need to know what version u use so i can help out with it and tell ya how to do it ;)

[teacher4]

The .rar I extracted my SQL database is called Mangos Base and is about 77MB. I already tried to download SDB 0.5 and 0.5.1 with updates and tried dev 2383 up to 2440...I always had the same problem. The mangosd would not load quest definitions and creature templates...all other things are ok. In the end I use dev 2115 (or 2117?) with this "mangos base" SQL and everything works well...so I'm looking for any non-essential bugs it may have and the ship and zeppelin thing is one of them. I know I could use teleports instead but I would like to have the proper transports! :)
Of course I still need to learn how to get about mangos, I' ve only had it for about a month, before I had a wowemu 4735.1.9
If you could help in any way that would be great! Even a hint or an idea...the fun part of having an emu is fixing it and customise it!!!
Again, thanx

[eddy69]

On the older versions the zepplins stop where thay should teleport for up to 5 mins then ( jump to desination) maybe it is still the same :)

[teacher4]

Actually I may find a way to get around the problem...getting the updates to work. I already have 0.5.1 SDB...but dev2393, 2440, 2468 won't load the quest definitions nor the creature templates. I can actually tele to che creatures guid but there aren't any!! Obviously because the emu loads the creatures on the world but not the template.
I'm pretty sure the ships and zeppelins are fixed on newer devs (correct me if Iìm wrong)...but how come SQL and proper devs won't work together?

[merzliakov]

Ships and zeppelins to another continent not work (not implemented)
Ships and zeppelins at same continent work fine.

[Tharo]

There is allready a smal patch out that fix ships and zeppelins. Just wait im sure it will be added soon.

[teacher4]

Thanx for the replies guys! While I wait (like many others I guess) for the patch, which table do I change to make teleports? In wowemu I had the same problem, so I made the ship and zeppelin masters teleport to the proper coordinates by speaking to them, but TCL is much simpler! Which column/table do I change in SQL?

[merzliakov]

There is allready a smal patch out that fix ships and zeppelins. Just wait im sure it will be added soon

Suggested patch is workaround. It teleport to target harbor from last ship movement point at original continent map. This is not real fix and will not added to mangos sources.

Transports to another continent implementes now in mangos in [2622] revision.

Required install mangos sql updates + sql update:

INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (20808, "Ratchet and Booty Bay", 350818);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (176244, "Teldrassil and Auberdine", 316251);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (176231, "Menethil Harbor and Theramore Isle", 329313);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (176310, "Menethil Harbor and Auberdine", 295579);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (177233, "Forgotton Coast and Feathermoon Stronghold", 317038);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (164871, "Orgrimmar and Undercity", 356284);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (175080, "Grom'Gol Base Camp and Orgrimmar", 303463);
INSERT INTO `transports` (`entry`, `name`, `period`)
VALUES (176495, "Grom'Gol Base Camp and Undercity", 333044);
UPDATE `gameobject_template` SET `sound0` = '241' WHERE `entry` =20808 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '302' WHERE `entry` =164871 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '285' WHERE `entry` =175080 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '292' WHERE `entry` =176231 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '293' WHERE `entry` =176244 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '295' WHERE `entry` =176310 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '301' WHERE `entry` =176495 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '303' WHERE `entry` =177233 LIMIT 1;

[Kyle12345]

Did you make that up yourself? Or is that from the mangos team. Cause their change log states "Transport support (ships) added. You must obtain data for the transport table. You gameobject and gameobject_template tables might require some cleaning, too. Expect bugs, this is a very major change. Enjoy!"

[merzliakov]

Provided Sql update is

obtain data for the transport table. You gameobject and gameobject_template tables might require some cleaning, too

;)

Work great! After some fixes added in next revisions. Recommend use [2629] or later.

[kennythekid]

that fix is for the ships for the moment zeps still bugged :)

[merzliakov]

This fix for both but some bugs can still exist...