|
   |
| Модератор форума: No_MaTTeR, staford11 |
| Форум » CMaNGOS » [CMaNGOS] Help » Ошибка при создании телепорта(кв) |
| Ошибка при создании телепорта(кв) |
Решил сделать квестовый телепорт через Quice. Нашел видео-урок . Все сделал, вписал все, что требуется. Перехожу в SQL-Скрипт выдает Warning: There is no one component assigned to field `SkillOrClass`. It will assigned to default value if it has one. , нажимаю выполнить скрипт пишет: SQL Error: 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 ' , , , '', '', '', '', 1369.48, -4203.59, 157.121, 1.17602, '')' at line 2
Подскажите в чем может быть проблема? |
jungler1, ошибка синтаксиса. Добавьте сюда код, который Вы пытаетесь залить.
Сообщение # 2 написано 27.02.2014 в 19:37
|
Код DELETE FROM `creature_questrelation` WHERE `quest` = 555005; DELETE FROM `gameobject_questrelation` WHERE `quest` = 555005; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 555005; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (999005, 555005); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 999005; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (999013, 555005); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 999013; DELETE FROM `creature_involvedrelation` WHERE `quest` = 555005; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 555005; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (999005, 555005); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=999005; DELETE FROM `quest_end_scripts` WHERE `id`=0; INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`,`dataint`,`dataint2`,`dataint3`,`dataint4`, `x`, `y`, `z`, `o`,`comments`) VALUES (555005, 0, 6, 1, , , , , '', '', '', '', 1369.48, -4203.59, 157.121, 1.17602, ''); REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `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 (555005, 2, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Teleport to Zul`Farrak', 'Teleport to Zul`Farrak', 'Teleport to Zul`Farrak', 'Are you sure?', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, -6798, -2877, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Сообщение # 3 написано 27.02.2014 в 19:47
|
jungler1, пробуйте:
Код DELETE FROM `creature_questrelation` WHERE `quest` = 555005; DELETE FROM `gameobject_questrelation` WHERE `quest` = 555005; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 555005; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (999005, 555005); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 999005; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (999013, 555005); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 999013; DELETE FROM `creature_involvedrelation` WHERE `quest` = 555005; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 555005; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (999005, 555005); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=999005; DELETE FROM `quest_end_scripts` WHERE `id`=0; INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`,`dataint`,`dataint2`,`dataint3`,`dataint4`, `x`, `y`, `z`, `o`,`comments`) VALUES (555005, 0, 6, 1, '', '', '', '', '', '', '', '', 1369.48, -4203.59, 157.121, 1.17602, ''); REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `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 (555005, 2, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Teleport to Zul`Farrak', 'Teleport to Zul`Farrak', 'Teleport to Zul`Farrak', 'Are you sure?', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, -6798, -2877, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Сообщение # 4 написано 27.02.2014 в 19:57
|
Стаффорд ваш запрос тоже не подойдёт. Почему?
Ответ: Цитата DELETE FROM `quest_end_scripts` WHERE `id`=0; INSERT INTO `quest_end_scripts` Таблицы эти уже давно переименовали в dbscripts_on_quest_end. Код dbscripts_on_creature_death Creature entry dbscripts_on_creature_movement DB project self defined id dbscripts_on_event Event id. Several sources: spell effect 61, taxi/transport nodes, gameobject_template data dbscripts_on_go_use Gameobject guid dbscripts_on_go_template_use Gameobject entry dbscripts_on_gossip DB project self defined id dbscripts_on_quest_end DB project self defined id (generally quest entry) dbscripts_on_quest_start DB project self defined id (generally quest entry) dbscripts_on_spell Spell id Так-что меняйте запросы.
Льву не ходить по улицам Нью-Йорка.
Сообщение # 5 написано 27.02.2014 в 23:51
|
Shadowfire, а вдруг у ТСа старая рева, где эти таблицы еще не переименованы?
Сообщение # 6 написано 28.02.2014 в 12:56
|
Пробую залить код, выдает ошибку:
Код SQL Error: Unknown column 'dataint2' in 'field list' Если же убрать dataint2 то выдает старую ошибку: SQL Error: 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 ') VALUES (555005, 0, 6, 1, '', '', '', '', 1369.48, -4203.59, 157.121, 1.176' at line 1
Сообщение # 7 написано 01.03.2014 в 19:34
|
Цитата jungler1 (  )dataint2 INSERT INTO `dbscripts_on_quest_end ` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`, `comments`) VALUES (555005, 0, 6, 1, 1369.48, -4203.59, 157.121, 1.17602, ''); пробуй. Это координаты для твоего квеста. Надеюсь разницу ты увидел. Добавлено (28.03.2014, 15:45) Цитата M1sTerY ( )INSERT INTO `dbscripts_on_quest_end ` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`, `comments`) VALUES (555005, 0, 6, 1, 1369,48, -4203,59, 157,121, 1,17602, ''); пробуй, варианты уже дали.
EvolutiON-WoW 3.3.5 - Тык
Видео сервера EvolutiON-WoW.Ru Часть 1. Видео сервера EvolutiON-WoW.Ru Часть 2. |
| |||
| |||