[Release] Mangos WOTLK Tele NPC (NO CORE EDITS!)

[cristi13]

Can you pm me the .sql of this please??? I'm kind of newb and I know only to execute batch =D . thanks in advantage

[orrebrink]

can u make me so i can get to shattrath , Warsong Hold etc + all major citys ?


many thx in advance

Btw i tested this one with wotlk rel beta 9061 and it works u only need to change the model id

im using the Razorspine Mangos WotLK r6744 p19.4 SD2 678 pFdb3g release from here

[TheNlghtmare]

This looks good. I'll have to try this when I get home from work.

[keazain]

Realy nice and most wanted, great work m8 +rep

[Stabatha]

PM sent!

Could you PM me it too please or post it =)

+Rep good job

[Shao111]

Will update this post and respond to you all once I get off work tonight. Took a little break from emulation. Think I'll get back into it soon though.

[kattfish]

Hello,

First post so here it goes. First of all, thanks to Shao111 for the sweet post. I did some modifications to it, including the npc char I use. Nothing too interesting. What I have figured out however is how to add new locations to the quest giver. Essentially all you have to do is take the sections I have included below and modify the bold areas. With the quest_template, I choose a high number that wasn't used (91244). I then made the CompleteScript field also 91244 which is nice for tracking when you edit the quest_end_scripts table. Finally I edited the creature_questrelation, and the creature_involvedrelation to correlate the NPC 91220 to 91224. The submission below is Hyjal, to get the coords, simply put your GM there (make sure to disable the raid requirement) and go to a point in Hyjal. This location is the Alliance Base. Once I had this data updated, I simply cut and pasted it into the SQL and F9'd it. Now my Teleport NPC sends me to Hyjal! Let me know if you have any troubles with this. Also note, the 534 is the 'Map' Entry when you do your .gps. This number goes into the quest_end_scripts in the datalong field.

INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`,
`ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`,
`RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`,
`DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`)

values('91244','876','0','1','70','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0' ,'0','0','0','0','0','0','Teleport to Hyjal','So

you want to teleport?','Speak with the Teleport Master again.','Are you sure, you\'re ready to
teleport?',NULL,NULL,NULL,NULL,NULL,NULL,'0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',
'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','
0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','91244');

INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datatext`, `x`, `y`, `z`, `o`)
values('91244','0','6','534','0','','4980.458','-1879.851','1322.354','6.2572');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91220', '91244');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91220', '91244');

[Etna]

Nice NPC Teleporter !! i will use this to my Server ! +rep x2

[micheal101]

hey can someone help me out plz I just started.. a server up and running I need an npc 2 tele please help me out 3.0.3

[bslayer15]

i have problem with it: [Err] 1054 - Unknown column 'flags' in 'field list'

[vintvlad]

pls poste one good telporter for mangos pls

[pryd]

I have a request if possible please, since this is a wonderful Mangos Teleporter.

Is it possible to make the npc an item instead?
Or possibly an item that calls this NPC where ever the player is?
So that essentially all players could use the teleporter at any time, and in any place.

Of course that would mean the npc when called is on a timer,
which I've seen done in the past, but really I don't have the experience to code this.

Looking forward to your feedback and +Rep for the Mangos teleporter, it's about time we had one


Edit- Took some work but I recoded this for my repacks, added more to it..
glad someone brought this post back to life.

[collision]

this one is outdated.. update needed..
same error as bslayer15 and more.. few things changed in the database, so need update..

[pryd]

this one is outdated.. update needed..
same error as bslayer15 and more.. few things changed in the database, so need update..

I'll release my updated teleporter which is based on this. Just recoded for the new table structure etc. Look for a new release from me soon.

If this post is deleted I will post all my NPC teleporters for All to enjoy on a new thread.

[karal]

thanks very much