Teleporter | Jukebox for Arcemu, Mangos 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

[Apple]

nice woRk

[Rochet2]

:P
Maybe I should do something new and not just post this in every new forum I get to :3

thnx

[Laladin]

Nice work! Thanks for sharing!

[Roignus]

thanks

[rampeixe]

i'm getting this error "SQL Error (1062): Duplicate entry '999666' for key 1".. can u help me?? i'm using Monster 4.1.0 Cataclysm Repack v3 and is database

[Rochet2]

That is only the error with no details about what happened when it occurred.
You should have posted the full error log or error (usually contains the whereabouts of the error)

The core is Skyfire, which is trinity btw.

The download has an NPC in it and I assume you didnt use an unique entry ID for the NPC.

The error indicates that one or more of the key Entries in the SQL were already taken.
The only basic possibilities of the error are:
NPC Entry
Text ID / Entry
Gossip MenuID

But it is most probably the NPC entry, check that it is an unique, unused Entry you are using. (for the NPC)

[rampeixe]

was for add a NPC, but i used the command DELETE FROM creature_template WHERE entry='999666' before the add one, and the error was fixed.. thanks anyway for the tips they where helpfull too

[Rochet2]

was for add a NPC, but i used the command DELETE FROM creature_template WHERE entry='999666' before the add one

You should also know, if you alredy didnt, that you lost one NPC there and then replaced it with another one (the teleporter).
Everyone on the server should clear their cache cause they see the teleporter as its name would be the name of the old NPC (if they saw the old NPC before you used the delete from statement and restarted the server)

[rampeixe]

the server isn't live yet , but your info will be helpfull when i did it.. thank you

Btw the portal master didn't work well ( some errors put up) for me on my Monster 4.1.0 Cataclysm Repack v3 server, so i edit him to this one

http://www.mediafire.com/?coayt81i561h8hy

, and work fine now, and can be used for Galactic Cataclsym 4.1.0 repack & +4.0.6 repack too.. have fun , and i don't wanna credits for this edit...