• Страница 1 из 1
  • 1
Архив - только для чтения
Модератор форума: andycrowz  
Телепортер
staford11
^s†af0rd f0rever^
Всем доброго времени суток.
Я начал работу над своей фан сборкой и мне нужен телепортер. Стандартного, увы, немогу скачать. С помощью поиска ничего не нашел. Телепортер должен портовать ко ВСЕМ инстам и во ВСЕ столицы. Тоесть ЦЛК, ИК и ИЧ, Ульдуар, Ульдаман, Монастырь Алого Ордена, Марадон (короче все инсты). С меня +6 тому кто сделает. Желательно что бы не квестами а как на сборка Jorda и на серваке Wardream (скрипты в scriptdev2).
Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340

Исправительные работы: в наличии.
Сообщение # 1 написано 12.08.2010 в 20:08
staford11
^s†af0rd f0rever^
Saybb, читай внимательно, НЕ квестами.

Добавлено (12.08.2010, 21:29)
---------------------------------------------
Ап

Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340

Исправительные работы: в наличии.
Сообщение # 2 написано 12.08.2010 в 21:29
Avatar01
Клиенто-Каратель
Сообщение # 3 написано 12.08.2010 в 21:47
staford11
^s†af0rd f0rever^
Avatar01, да я в курсе что на мангосе тоже возможно, просто мне нужны скрипты, который я собирался скачать со scriptdev2.com, регнулся там а всеравно пишет что типо ссылки могу видеть только зарегестрированные пользователи. Может кинете мне готовые скрипты а дальше я и сам постараюсь.
Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340

Исправительные работы: в наличии.
Сообщение # 4 написано 13.08.2010 в 11:01
armeol
The Last Lied
http://wowjp.net/forum/40-82197-1
в моем патче есть то что ты ищеш)
Сообщение # 5 написано 13.08.2010 в 11:26
lanc
The Hurt Locker
armeol, он старый!
staford11,
Code
Index: scripts/custom/teleguy.cpp
===================================================================
--- scripts/custom/teleguy    (revision 1735)
+++ scripts/custom/teleguy    (working copy)
@@ -125,2 +125,5 @@
    player->ADD_GOSSIP_ITEM( 5, "Naxxramas. 20 Gold"                           , GOSSIP_SENDER_MAIN, 4029);
+player->ADD_GOSSIP_ITEM( 5, "IceCrown Citadel. 20 Gold"                    , GOSSIP_SENDER_MAIN, 4030);
+player->ADD_GOSSIP_ITEM( 5, "Crusaders Coliseum. 20 Gold"                  , GOSSIP_SENDER_MAIN, 4031);
+player->ADD_GOSSIP_ITEM( 5, "Ruby Sanctrum. 20 Gold"                       , GOSSIP_SENDER_MAIN, 4032);
    player->ADD_GOSSIP_ITEM( 7, "<- [Back]"          , GOSSIP_SENDER_MAIN, 5550);
@@ -848,10 +848,55 @@
            player->CLOSE_GOSSIP_MENU();
            _Creature->MonsterSay("You must be at least level 80!", LANG_UNIVERSAL, NULL);
        }
           
    break;
       
+case 4030:// ICC
+
+    if (player->getLevel() >= 80)
+           
+    {
+        player->CLOSE_GOSSIP_MENU();
+        player->TeleportTo(571, 5790.019f, 2071.480f, 636.06f, 0.45f);
+        player->ModifyMoney(-400*costo);
+    } else {
+        player->CLOSE_GOSSIP_MENU();
+        _Creature->MonsterSay("You must be at least level 80!", LANG_UNIVERSAL, NULL);
+    }
+       
+break;
+
+case 4031:// Crusaders Coliseum
+
+    if (player->getLevel() >= 80)
+           
+    {
+        player->CLOSE_GOSSIP_MENU();
+        player->TeleportTo(571, 8515.460f, 728.920f, 558.30f, 0.45f);
+        player->ModifyMoney(-400*costo);
+    } else {
+        player->CLOSE_GOSSIP_MENU();
+        _Creature->MonsterSay("You must be at least level 80!", LANG_UNIVERSAL, NULL);
+    }
+       
+break;
+
+case 4032:// Ruby Sanctrum
+
+    if (player->getLevel() >= 80)
+           
+    {
+        player->CLOSE_GOSSIP_MENU();
+        player->TeleportTo(571, 3625.780f, 280.40f, -120.14f, 3.25f);
+        player->ModifyMoney(-400*costo);
+    } else {
+        player->CLOSE_GOSSIP_MENU();
+        _Creature->MonsterSay("You must be at least level 80!", LANG_UNIVERSAL, NULL);
+    }
+       
+break;
+
    }
       
       
    }

пробуй (скачай стандартный телегай, можна у карателя) и пропатч, по идее будет работать
добавил телепорт в ЦЛК ко входу, ИК ко входу, и в Рубиновое Святилище ко входу

Сообщение # 6 отредактировано lanc - Пятница, 13.08.2010, 13:27
staford11
^s†af0rd f0rever^
lanc, не думаю что мне удасться пропатчить твое ядро.

Добавлено (13.08.2010, 14:05)
---------------------------------------------
Вот скрипты на телегая, но тему я не могу просмотреть, пишет что типо надо регится. Ну я регнулся а все рвано такаяже фигня, как будто я не зашел.

Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340

Исправительные работы: в наличии.
Сообщение # 7 написано 13.08.2010 в 14:05
lanc
The Hurt Locker
staford11, у меня там есть телегай правдо без цлк, ик, рс (кстати рс можна использовать обсидианово хранилище) а по теме если надо в базе то вот
Code
REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('12885', 'Portal to Crusaders',  '571', '8515.460', '728.920', 558.30', '0');

REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('12885', '571', '8515.460', '728.920', 558.30', '0');

REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('13142', 'Portal to ICC',  '571', '5790.019', '2071.480', '636.06', '0');

REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('13142', '571', '5790.019', '2071.480', '636.06', '0');

DELETE FROM `creature_questrelation` WHERE `quest` = 88888;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 88888;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 88888;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99001, 88888);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99001;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 88888;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 88888;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99001, 88888);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99001;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `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`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (88888, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 65536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13142, 'Teleport to IcecrownCItadel', '', '', '', '', '', '', '', '', '', '', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 88889;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 88889;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 88889;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99001, 88889);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99001;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 88889;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 88889;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99001, 88889);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99001;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `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`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (88889, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 65536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12885, 'Teleport to Crusaders Coliseum', '', '', '', '', '', '', '', '', '', '', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

добавит по мимо основных тепортов два квеста с автозавершением и телепортом в нужные тебе места (по другому через базу не выйдет)

Сообщение # 8 отредактировано lanc - Пятница, 13.08.2010, 18:55
staford11
^s†af0rd f0rever^
lanc, и на том спс. А какой ид моба телегая?

Добавлено (13.08.2010, 14:39)
---------------------------------------------
[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 '' '0');
Не льется

Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340

Исправительные работы: в наличии.
Сообщение # 9 написано 13.08.2010 в 14:39
lanc
The Hurt Locker
Code
REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('12885', 'Portal to Crusaders',  '571', '8515.460', '728.920', 558.30', '0');

REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('12885', '571', '8515.460', '728.920', 558.30', '0');

REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('13142', 'Portal to ICC',  '571', '5790.019', '2071.480', '636.06', '0');

REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('13142', '571', '5790.019', '2071.480', '636.06', '0');

DELETE FROM `creature_questrelation` WHERE `quest` = 88888;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 88888;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 88888;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99001, 88888);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99001;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 88888;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 88888;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99001, 88888);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99001;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `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`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (88888, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 65536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13142, 'Teleport to IcecrownCItadel', '', '', '', '', '', '', '', '', '', '', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 88889;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 88889;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 88889;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99001, 88889);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99001;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 88889;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 88889;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99001, 88889);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99001;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `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`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (88889, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 65536, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12885, 'Teleport to Crusaders Coliseum', '', '', '', '', '', '', '', '', '', '', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

пропустил запятую с кем не бывает smile добавил квесты телегаю ид = 99001

Сообщение # 10 отредактировано lanc - Пятница, 13.08.2010, 18:53
staford11
^s†af0rd f0rever^
lanc, спс, попозже тестану, ща гулять пошел.

Добавлено (13.08.2010, 15:56)
---------------------------------------------
Ошибки:
[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 '' '0');

REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_po' at line 2
[Err] REPLACE INTO `areatrigger_teleport` (`id`, `name`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('12885', 'Portal to Crusaders', '571', '8515.460', '728.920', 558.30' '0');

Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340

Исправительные работы: в наличии.
Сообщение # 11 написано 13.08.2010 в 15:56
lanc
The Hurt Locker
отредактировал проверяйте! теперь если опять не упустил гдето запятую то будет работать (все мы люди запрос писал на скорую руку и упустил несколько запятых)
Сообщение # 12 написано 13.08.2010 в 18:54
INFERNOS
Данная тема была перемещена из раздела Патчи / Моды / Фиксы MaNGOS.
Причина перемещения: Не актуально

Переместил: INFERNOS.
Модерко 4pda
Сообщение # 13 написано 18.02.2013 в 17:56
  • Страница 1 из 1
  • 1
Поиск: