Teleport NPC/Portal Master For Mangos rev [10105]+

[Rochet2]

For Trinity and Mangos rev [10105]+
You do not need any c++ and there are no quests.
This is fully DB side, so just execute the script to your database.

Tele npc, gossip, teleports to 130 places (All dungeons, raids, leveling zones, main cities, gurubashi arena and booty bay)
Spawn points for the tele npc and rune circle to all main cities, gurub and bootybay
Summoning effect for the npc (check the end of the code to get the casting animation to the npc)

You only need one NPC to handle both factions.
All teleports have a level requirement according to the zone level or instance level requirement.

Run the code 1 time. If the options are in wrong order, run the code again.
You can also try running the delete code only and then the whole sql again.

Moved to github:
Portal Master | RochetCode

• ver 1.8
  Fixed level req and faction req for Zul'Aman
• ver 1.7
  Fixed an error that occurs in navicat
• ver 1.6
  Created teleporting scripts for zones
• ver 1.5
  Created zone teleport menus and options
• ver 1.4
  Updated with new condition, added "back" buttons,
  added "how many" number and added visual effect: Casting effect
• ver 1.3
  Fixed an error in deleting code and added visual effect: Summon circle
• ver 1.2
  Rewrote the sql code and made it clearer
• ver 1.1
  Created dungeon teleport menus, options and scripts
  and added Booty bay to main menu list
• ver 1.0
  Initial start. Created Portal Master and main city teleports

[myran2]

Interesting idea doing a teleporter entirely using SQL
+rep, cause this looks like a pretty damn nice idea.

[Rochet2]

nice work Rochet...
this is the best Teleport NPC for MaNGOS so far, +rep...

Ehh..

I just thought that now when there finally is an option to use gossip instead of quests
that Id do a teleporter. Kinda got to a larger project than i would have expected,
but id say the same as faddix there :3

*Teleport gameobject available
*Trinity teleport master available

Will prolly make one in c++ for mangos.
Also sooner or later creating a jukebox npc/GO

Just keep checking the site.

[Rochet2]

Released Jukebox and there have been alot updates to Trinity and some to mangos files.

[Rochet2]

Now supporting Arcemu, Trinity and Mangos.

+ Updates added during this time of absense.


(bump, new core support Arcemu.)

[Rochet2]

Ok, back here again.

I have now worked a lot today and finally finished up.
I Fixed the SQL to work on current arcemu structure, fixed the bugs that appeared ingame due to the SQL working only on older cores, fixed the lua to be for Luabridge, saved old LHA luascript to my computer, deleted it from the online creator and fixed couple bugs related to the top text display.

So, The teleporter for arcemu now works for current arcemu and Luabridge, but does not work on LHA anymore.

[Harambeqt]

How nice, I did exactly this for a server a couple of years back.
Would have been easier with a cheat sheet. lol.

[Rochet2]

So you did what? A teleporter?

And what do you mean by that cheat sheet thing?

[Harambeqt]

So you did what? A teleporter?

And what do you mean by that cheat sheet thing?

I made a SQL teleporter in 2009 for a Trinity 2.4.3 projct, when we closed the project we never bother releasing anything because we we're tired of the crap.
However Its good that someone made a template/released a sql-teleporter here on owned.
Im sure it helps alot of people who cannot/don't know how to code C++ or Lua.

[Rochet2]

Hmm .. somehow disabled my notifications ..

Well anyways:

Localization is now avaliable for MaNGOS and Trinity.
Localization | Project code

After running:
Open the realmlist table and set the timezone to your language number: Realmlist - UDB

Then open mangos.conf or worldserver.conf. Find line with RealmZone = 1 and change the value to your language number: Realmlist - UDB

[paff]

bump sryyyyyyy