BGames
Olá visitante! Seja bem vindo á BGames!

Para ter total acesso ao nosso fórum é preciso que você se registre.

Registre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!


BGames
Olá visitante! Seja bem vindo á BGames!

Para ter total acesso ao nosso fórum é preciso que você se registre.

Registre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!

BGames
Gostaria de reagir a esta mensagem? Crie uma conta em poucos cliques ou inicie sessão para continuar.

BGamesEntrar

Fórum de Desenvolvimento de Jogos e Programação


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

more_horiz
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.

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

more_horiz
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);

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

more_horiz
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'

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

more_horiz
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);

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

more_horiz
Vlw manim meu +rep pra vc

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

more_horiz


Tópico resolvido e movido para sua área correspondente

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

more_horiz
privacy_tip Permissões neste sub-fórum
Não podes responder a tópicos