Compartilhe
Ir em baixo
avatar

Mensagens : 84
Pontos : 343
Evolução : 2

Ver perfil do usuáriohttp://repackangelwow.hol.es/

[Resolvido]Quest de DK para Pegar +46 Pontos de talentos

em Ter 25 Set 2012 - 10:08
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.
avatar

Mensagens : 619
Pontos : 2179
Evolução : 5

Ver perfil do usuáriohttp://www.mthsena.info

Re: [Resolvido]Quest de DK para Pegar +46 Pontos de talentos

em Ter 25 Set 2012 - 15:08
priestzinho o erro é na coluna `entry` da tabela `quest_template`, o correto seria `id`.

-Correção-
Código:

SET @ID := 90001;
SET @NPC := 28474;
SET @GUID := 900001;

DELETE FROM `quest_template` WHERE `Id` = @ID;
INSERT INTO `quest_template` (`Id`, `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);
avatar

Mensagens : 84
Pontos : 343
Evolução : 2

Ver perfil do usuáriohttp://repackangelwow.hol.es/

Re: [Resolvido]Quest de DK para Pegar +46 Pontos de talentos

em Ter 25 Set 2012 - 18:28
Continua dando este erro

Query:
INSERT INTO `quest_template` (`Id`, `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)

Error occured at:2012-09-25 18:26:56
Line no.:7
Error Code: 1054 - Unknown column 'BonusTalents' in 'field list'
avatar

Mensagens : 619
Pontos : 2179
Evolução : 5

Ver perfil do usuáriohttp://www.mthsena.info

Re: [Resolvido]Quest de DK para Pegar +46 Pontos de talentos

em Ter 25 Set 2012 - 18:32
Tenta esse agora.

Código:

SET @ID := 90001;
SET @NPC := 28474;
SET @GUID := 900001;

DELETE FROM `quest_template` WHERE `Id` = @ID;
INSERT INTO `quest_template` (`Id`, `Method`, `ZoneOrSort`, `MinLevel`, `MaxLevel`, `Type`, `RequiredRaces`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `SpecialFlags`, `RewardTalents`, `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);
avatar

Mensagens : 84
Pontos : 343
Evolução : 2

Ver perfil do usuáriohttp://repackangelwow.hol.es/

Re: [Resolvido]Quest de DK para Pegar +46 Pontos de talentos

em Ter 25 Set 2012 - 23:52
Vlw manim meu +rep pra vc
avatar

Mensagens : 1912
Pontos : 11718
Evolução : 50

Ver perfil do usuário

Re: [Resolvido]Quest de DK para Pegar +46 Pontos de talentos

em Qua 26 Set 2012 - 9:39


Tópico resolvido e movido para sua área correspondente
Conteúdo patrocinado

Re: [Resolvido]Quest de DK para Pegar +46 Pontos de talentos

Voltar ao Topo
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum