Создаю кв в трайсе при заливке в базу выдает кучу ошибок, но как скрипт заливается. В игре у нпса просто нету этого кв.. Сам скрипт:
DELETE FROM `creature_questrelation` WHERE `quest` = 500000; DELETE FROM `gameobject_questrelation` WHERE `quest` = 500000; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 500000; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800009, 500000); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 800009; DELETE FROM `creature_involvedrelation` WHERE `quest` = 500000; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 500000; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800009, 500000); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=800009; REPLACE INTO `quest_template` (`Method`, `ZoneOrSort`, `MinLevel`, `MaxLevel`, `Type`, `RequiredRaces`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `SpecialFlags`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `PointMapId`, `PointX`, `PointY`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (0, 1637, 0, 0, 0, 690, 0, 0, 0, 0, 0, 0, 0, 150, 0, 0, 0, 'Во славу Орды!', 'Во славу Орды! Юный войн, тебе предстоит доказать, что ты действительно предан своему народу, завоевать уважение наших лидеров и доказать, что ты истинный войн Орды.', 'Тебе предстоит уничтожить лидеров Альянса.$BЛидер Людей - Король Вариан Ринн$BЛидер Дворфов - Мурадин Бронзобород$BЛидер Ночных Эльфов - Верховная жрица Тиранда Шелест Ветра$BЛидер Дренеев – Пророк Велен$BВсе они находятся в столицах своего народа!$BУдачи тебе юный войн.', 'Хорошая работа. Прими эту награду в знак моей благодарности!', 'Возвращайся когда доделаешь задание!', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
Ошибки в скрипте
Warning: There is no one component assigned to field `entry`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `SkillOrClassMask`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `QuestLevel`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RequiredSkillValue`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RepObjectiveFaction`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RepObjectiveValue`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RepObjectiveFaction2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RepObjectiveValue2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `QuestFlags`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `CharTitleId`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `PlayersSlain`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `BonusTalents`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `NextQuestInChain`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewXPId`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `SrcItemId`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `SrcItemCount`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `SrcSpell`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemId1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemId2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemId3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemId4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemId5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemId6`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemCount1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemCount2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemCount3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemCount4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemCount5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqItemCount6`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceId1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceId2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceId3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceId4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceCount1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceCount2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceCount3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSourceCount4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOId1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOId2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOId3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOId4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOCount1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOCount2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOCount3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqCreatureOrGOCount4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSpellCast1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSpellCast2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSpellCast3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `ReqSpellCast4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemId1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemId2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemId3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemId4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemId5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemId6`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemCount1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemCount2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemCount3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemCount4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemCount5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewChoiceItemCount6`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemId1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemId2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemId3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemId4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemCount1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemCount2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemCount3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewItemCount4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepFaction1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepFaction2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepFaction3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepFaction4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepFaction5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValueId1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValueId2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValueId3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValueId4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValueId5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValue1`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValue2`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValue3`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValue4`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewRepValue5`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewHonorAddition`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewHonorMultiplier`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `unk0`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewOrReqMoney`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewMoneyMaxLevel`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewSpell`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewSpellCast`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewMailTemplateId`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `RewMailDelaySecs`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `PointOpt`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `IncompleteEmote`. It will assigned to default value if it has one. Warning: There is no one component assigned to field `CompleteEmote`. It will assigned to default value if it has one.
Ты в свой запрос посмотри и вникни в него, тогда отпадут все вопросы. Я в первый раз занимаюсь этим, гайдов на тринити я не нашел ! Что не так то, неужели трудно ответить?)
Добавлено (31.07.2014, 00:48) --------------------------------------------- Могу только предположить, что нужно проставить значения 1 в этих строчках где ошибки.. Верно?
Warning: There is no one component assigned to field Предупреждения: нет одного компонента назначено поле
Так сложно перевести и вникнуть? Либо у тебя нет данных колонок в quice\truice. Скорее всего в программе в колонках нет значений, и при заливке она не ставит "0", а пропускает эту таблицу, из-за чего ошибки и лезут
Какие скрины? У тебя проблема в том, что ты думаешь, что варнинг - это ошибка, и сам себе противоречишь, кстати.
ЦитатаBadsanta3 ()
при заливке в базу выдает кучу ошибок, но как скрипт заливается.
Либо заливается, либо нет, какие ошибки-то? Я уже в который раз спрашиваю, а ты все ответить не можешь. Видимо, не понимаешь вообще, как с этим работать.
Либо заливается, либо нет, какие ошибки-то? Я уже в который раз спрашиваю, а ты все ответить не можешь. Видимо, не понимаешь вообще, как с этим работать.
)
