Bom este o Sql da Quest:
SET @ID := 90001;
SET @NPC := 28474;
SET @GUID := 900001;
DELETE FROM `quest_template` WHERE `entry` = @ID;
INSERT INTO `quest_template` (`Entry`, `Method`, `ZoneOrSort`, `MinLevel`, `MaxLevel`, `Type`, `RequiredRaces`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `SpecialFlags`, `BonusTalents`, `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
(@ID, 2, 0, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 'Quest DK', 'Pegue e complete esta Quest para ganhar +46 Talents', '', '', '', 'Pronto vc agora ta com 71 talentos...', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
DELETE FROM `creature_questrelation` WHERE `id` = @NPC;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES(@NPC,@ID);
DELETE FROM `creature_involvedrelation` WHERE `id` = @NPC;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES(@NPC,@ID);
-- NPC
DELETE FROM creature WHERE guid = @GUID;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID,@NPC,'609','1','1','25480','0','2362.79','-5670.7','425.985','2.63738','300','0','0','126000','0','0','0','0','0');
-- Add spell "Death Gate"
REPLACE INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(@NPC, 50977, 2000, 0, 0, 55);
So que quando eu tnto upar ele no repack (Jeuties Blizzlike Repack 10.00) da o seguinte Error:
Query:
DELETE FROM `quest_template` WHERE `entry` = @ID
Error occured at:2012-09-25 10:07:52
Line no.:5
Error Code: 1054 - Unknown column 'entry' in 'where clause'
Se alguem puder corrigir a quest para que eu possa add nesse repack ficarei imensamente grato. Se tiver outra melhor para a mesma finalidade de elevar os pontos dos Dk de 25 para 71 tbem agradecerei.
SET @ID := 90001;
SET @NPC := 28474;
SET @GUID := 900001;
DELETE FROM `quest_template` WHERE `entry` = @ID;
INSERT INTO `quest_template` (`Entry`, `Method`, `ZoneOrSort`, `MinLevel`, `MaxLevel`, `Type`, `RequiredRaces`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `SpecialFlags`, `BonusTalents`, `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
(@ID, 2, 0, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 'Quest DK', 'Pegue e complete esta Quest para ganhar +46 Talents', '', '', '', 'Pronto vc agora ta com 71 talentos...', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
DELETE FROM `creature_questrelation` WHERE `id` = @NPC;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES(@NPC,@ID);
DELETE FROM `creature_involvedrelation` WHERE `id` = @NPC;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES(@NPC,@ID);
-- NPC
DELETE FROM creature WHERE guid = @GUID;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID,@NPC,'609','1','1','25480','0','2362.79','-5670.7','425.985','2.63738','300','0','0','126000','0','0','0','0','0');
-- Add spell "Death Gate"
REPLACE INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(@NPC, 50977, 2000, 0, 0, 55);
So que quando eu tnto upar ele no repack (Jeuties Blizzlike Repack 10.00) da o seguinte Error:
Query:
DELETE FROM `quest_template` WHERE `entry` = @ID
Error occured at:2012-09-25 10:07:52
Line no.:5
Error Code: 1054 - Unknown column 'entry' in 'where clause'
Se alguem puder corrigir a quest para que eu possa add nesse repack ficarei imensamente grato. Se tiver outra melhor para a mesma finalidade de elevar os pontos dos Dk de 25 para 71 tbem agradecerei.