Dawn of Light

Many of them are implemented bur most are outdated and I don't know which of them so I replace em all.

Delete old items (with caution as usual, maybe better look the names up before):

Code: Select all

DELETE FROM `itemtemplate` WHERE name='Band of Eternity' LIMIT 1;
DELETE FROM `itemtemplate` WHERE name='Dagger of Dangerous Tidings' LIMIT 1;
DELETE FROM `itemtemplate` WHERE name='Ribbon of Flesh' LIMIT 3;
DELETE FROM `itemtemplate` WHERE name='Cudgel of the Undead' LIMIT 3;
DELETE FROM `itemtemplate` WHERE name='Sleeves of Strife' LIMIT 3;

Item queries:

Code: Select all

INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('6c83cef0-3cb5-47d0-8284-51e16430761c', 'Band_of_Eternity', 'Band of Eternity', 50, 50000, 50000, 50000, 50000, 100, 0, 0, 0, 0, 41, 35, 0, 0, 0, 2, 103, 0, 35, 21, 7, 60, 7, 7, 0, 3, 13, 10, 15, 14, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 164, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL) WHERE name='Band of Eternity' LIMIT 1;
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('6de85110-2dac-45f7-a478-8461e47f91fd', 'Cape_of_Legerdemain', 'Cape of Legerdemain', 50, 50000, 50000, 50000, 50000, 100, 0, 0, 0, 0, 41, 26, 0, 0, 0, 20, 1724, 0, 35, 5, 21, 3, 9, 4, 0, 12, 3, 163, 19, 191, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 4, 8, 0, 0, 0, 153, 196, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('58d84139-bd7d-4366-a152-810a0d9aebb7', 'Cudgel_of_the_Undead_Alb', 'Cudgel of the Undead', 51, 50000, 50000, 50000, 50000, 100, 165, 35, 0, 1, 2, 10, 0, 0, 0, 25, 2205, 0, 35, 21, 8, 8, 21, 4, 0, 156, 14, 19, 2, 199, 0, 1, 1, 1, 1, 10, 10,32175, 0, 1, 1, 5, 4, 0, 0, 0, 202, 198, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('49264bd7-02f4-496d-9147-fa8df5da6051', 'Cudgel_of_the_Undead_Hib', 'Cudgel of the Undead', 51, 50000, 50000, 50000, 50000, 100, 165, 35, 0, 1, 20, 10, 0, 0, 0, 40, 2205, 0, 35, 21, 8, 8, 21, 5, 0, 2, 19, 14, 156, 202, 0, 1, 1, 1, 1, 10, 10,32175, 0, 3, 1, 4, 4, 0, 0, 0, 198, 199, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('c84ac5ee-3514-433d-aff0-f7a71d01c385', 'Cudgel_of_the_Undead_Mid', 'Cudgel of the Undead', 51, 50000, 50000, 50000, 50000, 100, 165, 35, 0, 1, 12, 10, 0, 0, 0, 49, 2206, 0, 35, 21, 8, 8, 21, 5, 0, 2, 19, 14, 156, 202, 0, 1, 1, 1, 1, 10, 10,32175, 0, 2, 1, 4, 4, 0, 0, 0, 198, 199, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('f68b20eb-cd87-4dee-8737-1afe53abf277', 'Dagger_of_Dangerous_Tidings_Hib', 'Dagger of Dangerous Tidings', 51, 50000, 50000, 50000, 50000, 100, 165, 32, 2, 3, 21, 10, 0, 0, 0, 10, 895, 0, 35, 19, 19, 4, 4, 5, 0, 2, 4, 164, 167, 202, 0, 1, 1, 1, 1, 0, 0, 0, 45000, 3, 1, 5, 0, 0, 0, 0, 204, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('84784d01-baa5-4bdb-b181-056366d5b88c', 'Ribbon_of_Flesh_All', 'Ribbon of Flesh', 51, 50000, 50000, 50000, 50000, 100, 102, 10, 0, 0, 33, 21, 0, 0, 0, 16, 1297, 0, 35, 21, 21, 9, 6, 48, 0, 3, 4, 17, 12, 10, 0, 1, 1, 1, 1, 0, 0, 0, 31012, 0, 1, 5, 0, 0, 0, 0, 203, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `CanDropAsLoot`, `AllowedClasses`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`, `IsIndestructible`, `IsNotLosingDur`, `LevelRequirement`, `Price`, `ClassType`, `ProcChance`, `SalvageYieldID`, `TranslationId`, `ExamineArticle`, `MessageArticle`) VALUES ('f53e166e-2adf-4aa9-8b06-4478cf4d42ca', 'Sleeves_of_Strife_All', 'Sleeves of Strife', 51, 50000, 50000, 50000, 50000, 100, 51, 0, 0, 0, 32, 28, 0, 0, 0, 12, 2229, 0, 35, 8, 6, 8, 6, 60, 0, 17, 15, 13, 12, 10, 0, 1, 1, 1, 1, 0, 0, 0, 32300, 0, 1, 8, 0, 0, 0, 0, 19, 0, 0, 0, 0, 0, 0, 0, 32153, 0, 0, 0, 1, '', NULL, 'ZAM', NULL, NULL, NULL, NULL, NULL, NULL, 50000, NULL, NULL, NULL, NULL, NULL, NULL);

Checkin these out now. Thanks, Yay!

TY Arms Ty Yay