Lootlist Summoner Lossren

Get support with your problems on Storm

Moderators: Project Admin, Support Team

Post a reply

Lootlist Summoner Lossren

Postby Yay » Thu Sep 06, 2012 10:55 pm

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);
User avatar
Yay
Contributor
 
Posts: 174
Joined: Mon May 21, 2012 9:06 pm
Top

Re: Lootlist Summoner Lossren

Postby Arms » Mon Oct 01, 2012 1:51 am

Checkin these out now. Thanks, Yay!
My name is Inigo Montoya. You killed my father. Prepare to die.

Arms@Dracis
Arms
Server Team
 
Posts: 486
Joined: Mon May 19, 2008 3:16 am
Location: Escondido, CA
Top

Re: Lootlist Summoner Lossren

Postby Graveen » Mon Oct 01, 2012 7:14 pm

TY Arms ;) Ty Yay :)
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12661
Joined: Fri Oct 19, 2007 9:22 pm
Location: France
Top
Post a reply

Return to “%s” Support

Who is online

Users browsing this forum: No registered users and 0 guests

Website by Etaew - © 2012 Dawn of Light - Powered by phpBB © 2011 phpBB Group

Artwork and screen shots Copyright © 2001-2004 Mythic Entertainment, Inc. All rights reserved. Used with permission of Mythic Entertainment. Mythic Entertainment, the Mythic Entertainment logo, "Dark Age of Camelot," "Shrouded Isles," "Foundations," "New Frontiers," "Trials of Atlantis," "Catacombs," "Darkness Rising," the Dark Age of Camelot and subsequent logos, and the stylized Celtic knot are trademarks of Mythic Entertainment, Inc.