[Release] Teleporter NPC

[TheMagic]

A teleporter I recently finished! I think I did a pretty good job on it, it includes:


- 3.1.3 Support
- All Azeroth Zones
- All Outland Zones
- Major Cities
- Editable Locations


http://img123.imageshack.us/img123/6051/teleporter.th.png (http://img123.imageshack.us/img123/6051/teleporter.png)

To add to server! Instructions....

1. Extract the .ZIP folder
2. Put the Teleporter.lua file in the scripts folder where your core is located (If you are using a repack this should be located in /ArcEmu/scripts)
3. Execute the SQL file into your Database
4. Restart your server.
(you cannot just reload the tables you need the LUA scripts to reload)

5. You should now be able to spawn the teleporter

To add your own locations!:
(found under Other Locations)

Open the file Teleporter.lua with Notepad
1. Scroll down until you see the text:

if(intid == 99999) then
pUnit:GossipCreateMenu(99, player, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here!", 1000, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here 2!", 1001, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here 3!", 1002, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here 4!", 1003, 0)
pUnit:GossipMenuAddItem(0, "[Back]", 999, 0)
pUnit:GossipSendMenu(player)
end

http://img123.imageshack.us/img123/6051/teleporter.th.png (http://img123.imageshack.us/img123/6051/teleporter.png)

2. Change what is red to the name of your new location:

if(intid == 99999) then
pUnit:GossipCreateMenu(99, player, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here!", 1000, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here 2!", 1001, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here 3!", 1002, 0)
pUnit:GossipMenuAddItem(1, "Your Location Here 4!", 1003, 0)
pUnit:GossipMenuAddItem(0, "[Back]", 999, 0)
pUnit:GossipSendMenu(player)
end

3. Now scroll almost all the way to end until you find:

if(intid == 1000) then --Your Location Here!
player:Teleport(1, -8625, -1155, 13)
pUnit:GossipComplete(player)
end

if(intid == 1001) then --Your Location Here 2!
player:Teleport(1, -8625, -1155, 13)
pUnit:GossipComplete(player)
end

if(intid == 1002) then --Your Location Here 3!
player:Teleport(1, -8625, -1155, 13)
pUnit:GossipComplete(player)
end

if(intid == 1003) then --Your Location Here 4!
player:Teleport(1, -8625, -1155, 13)
pUnit:GossipComplete(player)
end

4. Again change what is red to:



if(intid == 1000) then --Name of location
player:Teleport(MapID, X, Y, Z)
pUnit:GossipComplete(player)
end

if(intid == 1001) then --Name of location
player:Teleport(MapID, X, Y, Z)
pUnit:GossipComplete(player)
end

if(intid == 1002) then --Name of location
player:Teleport(MapID, X, Y, Z)
pUnit:GossipComplete(player)
end

if(intid == 1003) then --Name of location
player:Teleport(MapID, X, Y, Z)
pUnit:GossipComplete(player)
end


5. Congrats, you have now added your own custom locations to the teleporter!

Notes:

Again remember this is found under Other Locations :D
This will also need a restart :P


Important info!

http://img123.imageshack.us/img123/6051/teleporter.th.png (http://img123.imageshack.us/img123/6051/teleporter.png)

The spawn ID for the teleporter is 90780!


Download! (http://www.mediafire.com/download.php?jgzdzjk2yid)

[SandersP]

This is Epic thank-you! :D

[TheMagic]

Your welcome :P

[qweqweqweqwe]

I Cant speak to the teleporter. :eek:

[TheMagic]

Did you execute the SQL's properly?

I tested it right before I uploaded it and it worked fine

[$PearBear- AKA -PeRRy$]

DAwg go to ur creature spawns.look for the npc and change his npc uhm thingy from 0 to 1

[TheMagic]

Yeah that should already be done in the SQL file though

[judgedread88]

ty so much this is awesome
would no how to make a hearthstone a menu for teleporting pm :)

[TheMagic]

I'm glad you like it :D




I could make one later on but you can try out Myzerz' Superstone you should be able to find it with search.

no how to make a hearthstone a menu for teleporting

[dodixd]

nice +rep we will test it today

[Stojkan]

nice teleporter +rep

[mozdi]

sql quarry dont work using NCDB48_AE2294

[TheMagic]

Oh this was released at rev47 which most people won't have until it's posted here: http://nc-db.info/showthread.php?tid=792 as Soon as they update the thread I'll make a new SQL :D Until then all you have do is use it with any NPC and it will work. Also NCDB keeps updating their SVN constantly now Revision 51: / (http://nc-db.info/svn/ncdb/) there on rev51 already so I'll just wait until the next stable rev is out :P

[mozdi]

Evererithing worked fine but i need some teleport cordinates

stormwind ,stormwind harbour,orgrimmar,stormwind old town

[TheMagic]

Do you know how to use the .gps command? :P

Here's the Coords for you:

Stormwind - .worldport 0 -8913 554 95
Stormwind Harbor - .worldport 0 -8292 1232 7
Old Town - .worldport 0 -8752 388 103
Orgrimmar - .worldport 1 1502 -4415 23

And I was even nice enough to plug-in the coords for in Other Locations :D

if(intid == 99999) then
pUnit:GossipCreateMenu(99, player, 0)
pUnit:GossipMenuAddItem(1, "Stormwind", 1000, 0)
pUnit:GossipMenuAddItem(1, "Stormwind Harbor", 1001, 0)
pUnit:GossipMenuAddItem(1, "Old Town", 1002, 0)
pUnit:GossipMenuAddItem(1, "Orgrimmar", 1003, 0)
pUnit:GossipMenuAddItem(0, "[Back]", 999, 0)
pUnit:GossipSendMenu(player)
end



if(intid == 1000) then --Stormwind
player:Teleport(0, -8913, 554, 95)
pUnit:GossipComplete(player)
end

if(intid == 1001) then --Stormwind Harbor
player:Teleport(0, -8292, 1232, 7)
pUnit:GossipComplete(player)
end

if(intid == 1002) then --Old Town
player:Teleport(0, -8752, 388, 103)
pUnit:GossipComplete(player)
end

if(intid == 1003) then --Orgrimmar
player:Teleport(1, 1502, -4415, 23)
pUnit:GossipComplete(player)
end

[lordcranberry3]

i get an error when i am executing the sql file it says it has a problem with mysql/sql +rep to the person who helps me

[TheMagic]

Well if it says there's a problem with the MySQL server then it's your MySQL's server fault, if you just get an error like "Column count does not match at row 1" or something when your try to Execute it I may be able to help you. Please post and say if it's just an error with the SQL code or if it's an actual error with the server, I'd prefer you try to do it in Navicat because that's what I know best :P , If it is a server error good luck idk what to tell you...

[Noxorion]

Please help me. Im getting crazy!
When i will put the .sql file in my database i will get this error:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 23907, 23907, 0, 0, 1, 1, 1, )' at line 4
[Err] REPLACE INTO creature_names
(`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(90780, 'Teleporter', '', '', 0, 7, 0, 0, 0, , 23907, 23907, 0, 0, 1, 1, 1, );
[Msg] Finished - Unsuccessfully
--------------------------------------------------

What the hell does it mean? please help me.

[TheMagic]

Try this it should help ;)

... oh this was released at rev47 which most people won't have until it's posted here: The preconverted databases thread (http://nc-db.info/showthread.php?tid=792) ... Until then all you have do is use it with any NPC and it will work ...

[lordcranberry3]

same problem Noxorion. idk whats wrong.

[Zenro45]

just to say... try do .cpp because lua can only do basics but .cpp is more advanced

[TheMagic]

You mean in C++? I don't need it more advanced it does what it's supposed to :P I don't need it to anything else

[amanh]

Rep because rep

[abyssdepot]

I had to modify it to work with my server/database. Here are the changes I made (using Keazain's 2289 with some updated ncdb changes).

Teleporter.sql

INSERT INTO creature_names VALUES (90780, 'Teleporter', '', '', 0, 7, 0, 0, 0,'', 23907, 23907, 0, 0, 1, 1, 1,'');
REPLACE INTO creature_proto VALUES (90780, 255, 255, 35, 1000000, 1000000, 1000000, 1, 3, 1800, 0, 150, 250, 0, 1800, 500, 650, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'MEMO', 0, 0, 0, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0);


Teleporter.lua (had to modify the 1001, 1002... custom ports to 900, 901, 902 because it wouldn't work when clicked) Here are my changes to the custom ports script section.


if(intid == 99999) then
pUnit:GossipCreateMenu(99, player, 0)
pUnit:GossipMenuAddItem(1, "The Dark Portal", 900, 0)
pUnit:GossipMenuAddItem(1, "The Stair of Destiny", 901, 0)
pUnit:GossipMenuAddItem(1, "Thrallmar Horde", 902, 0)
pUnit:GossipMenuAddItem(1, "Honor Hold Alliance", 903, 0)
pUnit:GossipMenuAddItem(0, "[Back]", 999, 0)
pUnit:GossipSendMenu(player)
end


if(intid == 900) then --The Dark Portal
player:Teleport(0, -11805, -3201, 30)
pUnit:GossipComplete(player)
end

if(intid == 901) then --The Stair of Destiny
player:Teleport(530, -248, 965, 86)
pUnit:GossipComplete(player)
end

if(intid == 902) then --Thrallmar Flight Master Horde
player:Teleport(530, 206, 2635, 89)
pUnit:GossipComplete(player)
end

if(intid == 903) then --Honor Hold Flight Master Alliance
player:Teleport(530, -673, 2711, 96)
pUnit:GossipComplete(player)
end


I also modified the 'scale' of the npc as he was set to 5 originally and way too damn big.

[TheMagic]

Thank-you very much for the new SQL +rep, mind if I reupload it with your new SQL?, The intid's being in the 1000's should work fine though, and for the scale I like the teleporter huge people can see it :P

[abyssdepot]

Thank-you very much for the new SQL +rep, mind if I reupload it with your new SQL?, The intid's being in the 1000's should work fine though, and for the scale I like the teleporter huge people can see it :P

I don't mind if you use it. I just modified your original work :). As for the scale, it was just a personal preference for my server. Thanks for the great addon!

[TheMagic]

Your welcome and thank-you :D , Hopefully I'll get an SQL working for NCDB r60+ pretty soon, and I have 1 fix I have to add to the teleporter,

I forgot Isle of Qual' Danas under Eastern Kingdoms :P

[patfay]

i get an error it says: You have in error in your SQL syntax;check the manual that corresponds to your mysql server version for the right syntax to use around ')' line 4

Its when im exacuting it here is the file

REPLACE INTO creature_names
(`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(90780, 'Teleporter', '', '', 0, 7, 0, 0, 0, 23907, 23907, 0, 0, 1, 1, 1, );

REPLACE INTO creature_proto
(`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
VALUES
(90780, 255, 255, 35, 1000000, 1000000, 1000000, 5, 3, 1800, 0, 150, 250, 0, 1800, 500, 650, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'MEMO', 0, 0, 0, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0);

[emerica52618]

Hey i tried changing the model ID and it still didnt upload, This is exacly what i did,
1)Extract the program to my desktop.
2) Make it a SQL file.
3) open up NaviCat. and when to World, then went to execute.
4) then found the Teleporter.SQL
5) uploaded it and it said unsuccessfull which it should normally do.
6) tried running it but still didn't work so i edit'd it and changed the NPC modelID. then tried executing it and still didn't work.
7) I have ncdb61_arc2321 so you said above just change the modelID.
Someone please explain. Will give +Rep to whoever will explain step by step[/COLOR]

[B1G R3D]

Hmm I will try this today ann let u know if I find anything wrong with it +rep for release:P

[Xeelix]

Thank you, this was really helpful =)

[Rhark]

Gah theres like 5000 working teleporters !!

[TheMagic]

So?

[expo]

@patfay

Luckily I know a ton of SQL, your error is on line 4 at the end before the parenthesis. here is an extra comma after the last one.

REPLACE INTO creature_names
(`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
VALUES
(90780, 'Teleporter', '', '', 0, 7, 0, 0, 0, 23907, 23907, 0, 0, 1, 1, 1);

Execute this to see if it works.

[TheMagic]

Please note that was a very old post :P

[expo]

And your garage is filled with people who care.

[TheMagic]

What kind of burn is that? :confused: