All pastes #753728 Raw Edit

Untitled

public text v1 · immutable
#753728 ·published 2007-10-29 14:30 UTC
rendered paste body
[Err] 1062 - Duplicate entry '11404' for key 1
[Err] INSERT INTO quest_template (entry, ZoneOrSort,  MinLevel, QuestLevel, Type, RequiredRaces, SuggestedPlayers, RequiredSkillValue, RequiredMinRepFaction, RequiredMinRepValue, LimitTime, SpecialFlags, PrevQuestId, NextQuestId, ExclusiveGroup, NextQuestInChain, SrcItemId, SrcItemCount, SrcSpell, Title, Details, Objectives, OfferRewardText, RequestItemsText, EndText, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, ReqItemId1, ReqItemId2, ReqItemId3, ReqItemId4, ReqItemCount1, ReqItemCount2, ReqItemCount3, ReqItemCount4, ReqSourceId1, ReqSourceId2, ReqSourceId3, ReqSourceId4, ReqSourceCount1, ReqSourceCount2, ReqSourceCount3, ReqSourceCount4, ReqSourceRef1, ReqSourceRef2, ReqSourceRef3, ReqSourceRef4, 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, RewRepValue1, RewRepValue2, RewRepValue3, RewRepValue4, RewRepValue5, RewOrReqMoney, RewXpOrMoney, RewSpell, PointMapId, PointX, PointY, PointOpt, DetailsEmote1, DetailsEmote2, DetailsEmote3, DetailsEmote4, IncompleteEmote, CompleteEmote, OfferRewardEmote1, OfferRewardEmote2, OfferRewardEmote3, OfferRewardEmote4, StartScript, CompleteScript, Repeatable) VALUES
(11404, -22, 0, 70, 87, 0, 5, 1, 0, 0, 0, 4096, 0, 0, 0, 0, 33985, 0, 0, "Call the Headless Horseman", "Many dreary candles adorn this pumpkin shrine, which grins, taunting...", "Take a Dreary Candle to the Loosely Turned Soil.", "NULL", "NULL", "", "", "", "", "", 33985, 0, 0, 0, 1, 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, 7500, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0);
[Err] 1062 - Duplicate entry '24519' for key 1
[Err] -- creature template
INSERT INTO creature_template (entry, name, subname, flag1, type, family, rank, modelid_A, modelid_A2, modelid_H, modelid_H2, civilian, RacialLeader, minlevel,maxlevel,minhealth,maxhealth,faction_A,faction_H) VALUES
(24519, "Costumed Orphan Matron", "", 0, 7, 0, 0, 22504, 0, 22504, 0, 1, 0,1,1,8,8,35,35);
[Err] 1064 - 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 '--Mana Spring Totem V
UPDATE `creature_template` SET `spell1` = '25569' WHERE `' at line 1
[Err] --Mana Spring Totem V
UPDATE `creature_template` SET `spell1` = '25569' WHERE `creature_template`.`entry` =15489 LIMIT 1 ;
[Err] 1064 - 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 '--Fire Resistance Totem IV
UPDATE `creature_template` SET `spell1` = '25562' WH' at line 1
[Err] --Fire Resistance Totem IV
UPDATE `creature_template` SET `spell1` = '25562' WHERE `creature_template`.`entry` =15487 LIMIT 1 ;
[Err] 1064 - 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 '--Stoneskin Totem VII
UPDATE `creature_template` SET `spell1` = '25506' WHERE `' at line 1
[Err] --Stoneskin Totem VII
UPDATE `creature_template` SET `spell1` = '25506' WHERE `creature_template`.`entry` =15470 LIMIT 1 ;
[Err] 1064 - 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 '--Stoneskin Totem VIII
UPDATE `creature_template` SET `spell1` = '25507' WHERE ' at line 1
[Err] --Stoneskin Totem VIII
UPDATE `creature_template` SET `spell1` = '25507' WHERE `creature_template`.`entry` =15474 LIMIT 1 ;
[Err] 1064 - 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 '--Windwall Totem IV
UPDATE `creature_template` SET `spell1` = '25576' WHERE `cr' at line 1
[Err] --Windwall Totem IV
UPDATE `creature_template` SET `spell1` = '25576' WHERE `creature_template`.`entry` =15492 LIMIT 1 ;
[Err] 1064 - 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 '--Wrath of Air Totem
UPDATE `creature_template` SET `spell1` = '2895' WHERE `cr' at line 1
[Err] --Wrath of Air Totem
UPDATE `creature_template` SET `spell1` = '2895' WHERE `creature_template`.`entry` =15447 LIMIT 1 ;
[Err] 1064 - 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 '--Magma Totem V
UPDATE `creature_template` SET `spell1` = '25551' WHERE `creatu' at line 1
[Err] --Magma Totem V
UPDATE `creature_template` SET `spell1` = '25551' WHERE `creature_template`.`entry` =15484 LIMIT 1 ;
[Err] 1064 - 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 '--Magtheridon
DELETE FROM `creature_loot_template` WHERE entry=17257 AND item I' at line 1
[Err] --Magtheridon
DELETE FROM `creature_loot_template` WHERE entry=17257 AND item IN (28774,28775,28776,28777,28778,28779,28780,28781,28782,28783,28789,29458,29753,2754,29755);
[Err] 1064 - 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 '--Gruul
DELETE FROM creature_loot_template WHERE entry=19044 AND item IN (28794' at line 1
[Err] --Gruul
DELETE FROM creature_loot_template WHERE entry=19044 AND item IN (28794,28802,28803,28804,28810,28822,28823,28824,28825,28826,28827,28828,28830,2765,29766,29767);
[Err] 1064 - 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 '--Maulgar
DELETE FROM `creature_loot_template` WHERE entry=18831 AND item IN (2' at line 1
[Err] --Maulgar
DELETE FROM `creature_loot_template` WHERE entry=18831 AND item IN (28795,28796,28797,28799,28800,28801,29762,29763,29764);
[Err] 1062 - Duplicate entry '18831-28795' for key 1
[Err] insert into `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `quest_freeforall`) values
('18831','28795','16','-2','1','1','1'),
('18831','28796','16','-2','1','1','1'),
('18831','28797','17','-2','1','1','1'),
('18831','28799','17','-2','1','1','1'),
('18831','28800','17','-2','1','1','1'),
('18831','28801','17','-2','1','1','1'),
('18831','29762','33','-1','1','1','1'),
('18831','29763','33','-1','1','1','1'),
('18831','29764','34','-1','1','1','1');
[Msg] Finished - Unsuccessfully
--------------------------------------------------