hele vytvorila sem novyho portera na ID 664466 a prvni port ma id 996699 a kdyz to udelam vse a respavnu ve hre a portnu se portne me to na posledni misto v taxiku u druhyho nevim jak to jinak rict :-D
DELETE FROM `creature_questrelation` WHERE `quest` = 996699;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 996699;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 996699;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (664466, 996699);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 664466;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 996699;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 996699;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (664466, 996699);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=664466;
DELETE FROM `quest_end_scripts` WHERE `id`=996699;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datatext`, `x`, `y`, `z`, `o`) VALUES
(664466, 0, 6, 1, 0, '', 4607.707520, -3642.967041, 962.663025, 2.168871);
DELETE FROM `quest_template` WHERE `entry` = 996699;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `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`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (996699, 0, 0, 0, 0, 1791, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Leveling 50 - 100', '50 silver.', '50 silver.', '50 silver.', '50 silver.', '', '', '', '', '', 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, -5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 600014);
to datalong sem zkousel 0 aji 1 a nepomaha
souradnice kam chci aby to portovalo je : (664466, 0, 6, 1, 0, '', 4607.707520, -3642.967041, 962.663025, 2.168871);
Souradnice kam to portuje : (600014, 0, 6, 1, 0, '', 4624.926270, -3841.617676, 943.720396, 0.865110);