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

[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

[MentaL]

[axaver]

thanks for sharing info with us

[agua]

This is a great job.

[Rochet2]

Ofc it is :P

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

*Note that there is now a teleport gameobject available and a master for trinity.

[goofzzaur]

How do i spawn it ?

[Rochet2]

.npc add 300000

[goofzzaur]

It doesn't work :( It tells me the "Syntax: .npc add #creatureid" thing.... :(

[Rochet2]

should work, if you have not changed the sql there ..

Try .lookup crea Portal master
or if you got the gob then .lookup obj teleport

and use the number or link.

[goofzzaur]

I've solved it ! I had to restart the server. lol :))

[Rochet2]

lol

Basic if you are new or sleepy

[Rochet2]

Now supporting Arcemu.

[juani2010]

gracias x el material , vere si lo puedo implementar ya que me hace falta los portales!

[Rochet2]

Yo no hablo español, pero usted dice que algo le faltaba?

ps. Google Traductor ftw

[TheAxion]

very nice

[Rochet2]

very nice

Thanks

[Rochet2]

Changed Portal master (teleporter) to use SmartAI on Trinity.
This fixes the buggy menus on newer revisions (they messed the gossip script system).
The teleport option creator is currently disabled.

This is not needed for mangos as gossip scripts work great on mangos.

This fix is also needed for the Jukebox, but I will do it later.

[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.

[Rochet2]

Localization is now avaliable for Portal Master on 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

[DJmaxx]

i got a SQL Error when i try to put it in my mysql db it says

SQL Error (1062): Duplicate entry '4-3703-1' for key 'unique_conditions'

what am i doing wrong?

[Hurkulez]

Original post is 3yrs old...

[Tidan12]

Would this work with oregoncore 2.4.3?

[Cluster]

Realy nice work

[runto2006]

thanks a lot!