Upgrated DF items

A place to submit .patch fixes for the DOL SVN

Moderator: Developer Team

Re: Upgrated DF items

Postby deathwish » Tue Jul 20, 2010 11:53 pm

only thing i could think of that be nice, if you could make Visible effects and colours, bring up a image of the colour or effect and if you are feeling really skill full, add a merchantitems page too 8) that be really helpful, but just hard work to make i guess or someone would of done it by now
- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 483
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex

Re: Upgrated DF items

Postby deathwish » Wed Jul 21, 2010 12:51 am

if anyone gets bored and wants to help, here what i have done sofar, :( after having to restart lol
Part 1 of 2
Code: Select all
REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('b41cf28e-54f0-434c-bab2-ff9ad677e491', 32030, 4054, 0, 'ProcDirectDamageHeat49', 'Damages the target.', 'Enemy', 1500, 0, 0, 71, 13, 'DirectDamage', 0, 0, 0, 0, 350, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0);
REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('17fdb326-891a-4243-a200-a45d09c3a1ba', 32126, 4070, 0, 'ProcDirectDamageEnergy47', 'Damages the target.', 'Enemy', 1500, 0, 0, 95, 12, 'DirectDamage', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0);
REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('b41frthge-54f0-434c-bab2-ff9ad677e491', 32032, 4054, 0, 'ProcDirectDamageHeat49', 'Damages the target.', 'Enemy', 1500, 0, 2, 331, 13, 'DirectDamage', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0);



-- Pico alb dia seals

REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('b76fe614-cfcc-430f-ad42-433c2dfe1880', 'Exquisite_Avernal_Malison_Longsword', 'Exquisite Avernal Malison Longsword', 50, 50000, 50000, 50000, 50000, 100, 165, 35, 2, 3, 10, 26, 11, 23, 4, 30, 15, 15, 5, 6, 4, 1, 44, 201, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 15);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('1dd2525a-8cb4-46c3-99f9-cdeb7a5f42c2', 'Exquisite_Avernal_Malison_Short_Sword', 'Exquisite Avernal Malison Short Sword', 50, 50000, 50000, 50000, 50000, 100, 165, 28, 2, 2, 3, 11, 26, 72, 18, 3, 30, 15, 15, 5, 6, 4, 1, 28, 201, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 16);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('b4627c57-c0c0-47ea-b9e0-46226870184f', 'Exquisite_Avernal_Malison_Mace', 'Exquisite Avernal Malison Mace', 50, 50000, 50000, 50000, 50000, 100, 165, 34, 1, 2, 10, 26, 52, 32, 14, 30, 7, 7, 6, 6, 3, 2, 25, 202, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 17);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('cc11de54-c23a-454c-abc1-7cb74c43511a', 'Exquisite_Avernal_Malison_Hammer', 'Exquisite Avernal Malison Hammer', 50, 50000, 50000, 50000, 50000, 100, 165, 30, 2, 1, 2, 11, 26, 34, 24, 12, 30, 15, 15, 5, 6, 2, 3, 28, 202, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 17);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('6bca41ad-a740-4359-be83-be6bf3df546a', 'Exquisite_Avernal_Malison_Rapier', 'Exquisite Avernal Malison Rapier', 50, 50000, 50000, 50000, 50000, 100, 165, 31, 3, 4, 10, 26, 12, 17, 22, 30, 5, 15, 15, 6, 50, 3, 2, 201, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 19);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('aa349bcb-efbd-4902-84da-701507d20a16', 'Exquisite_Avernal_Malison_Dirk', 'Exquisite Avernal Malison Dirk', 50, 50000, 50000, 50000, 50000, 100, 165, 22, 2, 3, 4, 11, 26, 72, 8, 71, 30, 15, 15, 5, 6, 3, 2, 28, 201, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 21);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('7750fa1b-bf0b-47a1-b8dd-cbb84a28c5d0', 'Exquisite_Avernal_Malison_Great_Sword', 'Exquisite Avernal Malison Great Sword', 50, 50000, 50000, 50000, 50000, 100, 165, 51, 1, 2, 6, 12, 26, 33, 56, 7, 30, 15, 15, 5, 6, 3, 2, 20, 204, 1, 1, 0, 1, 1, 1, 32030, 1, '2;1', 'Public_DB', 15);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('879ab16b-2999-40af-9c85-70b4fb93240c', 'Exquisite_Avernal_Malison_Great_Hammer', 'Exquisite Avernal Malison Great Hammer', 50, 50000, 50000, 50000, 50000, 100, 165, 48, 1, 1, 6, 12, 26, 34, 52, 17, 30, 15, 15, 5, 6, 3, 2, 20, 204, 1, 1, 0, 1, 1, 1, 32030, 1, '2;1', 'Public_DB', 16);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('3f0569b5-6b4f-45e0-934b-0afedf2d1c69', 'Exquisite_Avernal_Malison_War_Mattock', 'Exquisite Avernal Malison War Mattock', 50, 50000, 50000, 50000, 50000, 100, 165, 37, 1, 3, 6, 12, 26, 53, 40, 16, 30, 7, 7, 6, 6, 3, 2, 20, 204, 1, 1, 0, 1, 1, 1, 32030, 1, '2;1', 'Public_DB', 17);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('3d3e3dfe-17d0-4adc-b57d-08329e3d7468', 'Exquisite_Avernal_Malison_Lochaber_Axe', 'Exquisite Avernal Malison Lochaber Axe', 50, 50000, 50000, 50000, 50000, 100, 166, 48, 1, 2, 7, 12, 26, 52, 50, 68, 30, 7, 7, 6, 6, 3, 2, 41, 204, 1, 1, 0, 1, 1, 1, 32030, 1, '2', 'Public_DB', 17);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('a8c93126-7594-4a9d-8ec2-23a1701f1b37', 'Exquisite_Avernal_Malison_Pike', 'Exquisite Avernal Malison Pike', 50, 50000, 50000, 50000, 50000, 100, 165, 43, 1, 3, 7, 12, 26, 72, 45, 69, 30, 15, 15, 5, 6, 3, 2, 41, 204, 1, 1, 0, 1, 1, 1, 32030, 1, '2', 'Public_DB', 19);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('8f4e0aee-9e2f-4347-a4e2-c93075c1eedc', 'Exquisite_Avernal_Malison_Lucerne_Hammer', 'Exquisite Avernal Malison Lucerne Hammer', 50, 50000, 50000, 50000, 50000, 100, 165, 56, 1, 1, 7, 12, 26, 75, 60, 70, 30, 15, 15, 5, 6, 3, 2, 41, 204, 1, 1, 0, 1, 1, 1, 32030, 1, '2', 'Public_DB', 21);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('b5e01c22-e0ca-4a0b-87f7-e06506601aea', 'Exquisite_Avernal_Malison_Crossbow', 'Exquisite Avernal Malison Crossbow', 50, 50000, 50000, 50000, 50000, 100, 162, 40, 1, 3, 10, 13, 26, 40, 226, 30, 7, 7, 6, 3, 2, 24, 1, 1, 0, 1, 1, 1, 1, '2;9', 'Public_DB', 15);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus2`, `Bonus3`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('95d03b6a-f923-4c33-8f70-fce35a9ccee4', 'Exquisite_Avernal_Malison_Short_Bow', 'Exquisite Avernal Malison Short Bow', 50, 50000, 50000, 50000, 50000, 100, 165, 40, 1, 3, 5, 13, 26, 23, 569, 30, 36, 36, 2, 1, 1, 1, 0, 1, 1, 1, 1, '11', 'Public_DB', 16);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('2f2cd054-c91d-4c2d-9a2b-1fdd7c3e4014', 'Exquisite_Avernal_Malison_Long_Bow', 'Exquisite Avernal Malison Long Bow', 50, 50000, 50000, 50000, 50000, 100, 165, 54, 1, 3, 9, 13, 26, 31, 570, 30, 6, 9, 16, 4, 168, 4, 2, 174, 1, 1, 0, 1, 1, 1, 32126, 1, '3', 'Public_DB', 17);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('e15cd073-eb2c-4563-b287-2d26288c8841', 'Exquisite_Avernal_Malison_Barbed_Whip', 'Exquisite Avernal Malison Barbed Whip', 50, 50000, 50000, 50000, 50000, 100, 165, 35, 2, 24, 10, 26, 52, 23, 865, 30, 15, 15, 5, 6, 4, 1, 33, 201, 1, 1, 0, 1, 1, 1, 32030, 1, '33;19', 'Public_DB', 15);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('0c1438a5-f422-4c33-9a22-2ef18acff1a2', 'Exquisite_Avernal_Malison_Flail', 'Exquisite Avernal Malison Flail', 50, 50000, 50000, 50000, 50000, 100, 165, 35, 1, 24, 10, 26, 53, 24, 861, 30, 7, 7, 6, 6, 3, 2, 33, 202, 1, 1, 0, 1, 1, 1, 32030, 1, '33;19', 'Public_DB', 17);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('8c629772-dbde-47ff-a77f-ec5d64b5b6c2', 'Exquisite_Avernal_Malison_Fist_Wrap', 'Exquisite Avernal Malison Fist Wrap', 50, 50000, 50000, 50000, 50000, 100, 165, 35, 1, 27, 10, 26, 23, 3477, 30, 15, 15, 5, 1, 4, 110, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 15);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('83e0c1ee-596f-4da6-b13f-42392215b70c', 'Exquisite_Avernal_Malison_Hand_Wrap', 'Exquisite Avernal Malison Hand Wrap', 50, 50000, 50000, 50000, 50000, 100, 165, 28, 2, 1, 27, 11, 26, 18, 3477, 30, 15, 15, 5, 6, 1, 4, 110, 201, 1, 1, 0, 1, 1, 1, 32030, 1, 'Public_DB', 16);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('e414097b-d8e5-40ca-9bcc-318cf3276894', 'Exquisite_Avernal_Malison_Quarterstaff', 'Exquisite Avernal Malison Quarterstaff', 50, 50000, 50000, 50000, 50000, 100, 165, 30, 1, 1, 8, 12, 26, 94, 45, 567, 30, 7, 7, 6, 6, 3, 2, 48, 202, 1, 1, 0, 1, 1, 1, 32030, 1, '10', 'Public_DB', 17);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `PackageID`, `Price`) VALUES ('6d9eb24e-f88f-4d77-8325-1f411ec47760', 'Exquisite_Avernal_Malison_Staff', 'Exquisite Avernal Malison Staff', 50, 50000, 50000, 50000, 50000, 100, 165, 44, 1, 1, 8, 12, 26, 52, 45, 19, 30, 5, 15, 15, 50, 6, 163, 156, 2, 165, 209, 1, 1, 0, 1, 1, 1, 10, 10, 32032, 1, 'Public_DB', 19);
REPLACE 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`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('e6a0ce65-2286-42e4-9c94-36a5cd827c9f', 'Exquisite_Avernal_Malison_Mauler_Staff', 'Exquisite Avernal Malison Mauler Staff', 50, 50000, 50000, 50000, 50000, 100, 165, 30, 1, 1, 28, 12, 26, 94, 45, 567, 30, 6, 7, 7, 6, 109, 3, 1, 201, 1, 1, 1, 1, 1, 1, 32030, 1, 'Public_DB', 17);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `PackageID`, `Price`) VALUES ('4f76f9c4-877d-422e-b8de-d97fc32665c0', 'Exquisite_Avernal_Malison_Protector', 'Exquisite Avernal Malison Protector', 50, 50000, 50000, 50000, 50000, 100, 164, 26, 1, 42, 11, 26, 31, 59, 30, 18, 9, 9, 6, 2, 11, 15, 204, 1, 1, 0, 1, 1, 1, 5, 5, 32126, 1, 'Public_DB', 15);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `PackageID`, `Price`) VALUES ('b31c56bb-8583-4f00-8809-37356dfd5311', 'Exquisite_Avernal_Malison_Defender', 'Exquisite Avernal Malison Defender', 50, 50000, 50000, 50000, 50000, 100, 164, 36, 2, 42, 11, 26, 35, 61, 30, 18, 9, 9, 6, 2, 15, 11, 204, 1, 1, 0, 1, 1, 1, 5, 5, 32126, 1, 'Public_DB', 16);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `PackageID`, `Price`) VALUES ('65a096a4-632e-4b0c-9cd1-356456177284', 'Exquisite_Avernal_Malison_Bladestopper', 'Exquisite Avernal Malison Bladestopper', 50, 50000, 50000, 50000, 50000, 100, 164, 46, 3, 42, 11, 26, 41, 79, 30, 16, 10, 8, 8, 6, 4, 1, 11, 15, 204, 1, 1, 0, 1, 1, 1, 5, 5, 32126, 1, 'Public_DB', 17);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('5c6e72b1-e07b-476d-991f-3899b2cf07ed', 'Exquisite_Avernal_Malison_Lute', 'Exquisite Avernal Malison Lute', 45, 50000, 50000, 50000, 50000, 100, 2, 45, 12, 26, 52, 15, 2976, 30, 15, 15, 5, 8, 3, 35, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 17);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('ef61ad0b-e042-41ac-9326-d7ca2ba9961a', 'Exquisite_Avernal_Malison_Drum', 'Exquisite Avernal Malison Drum', 45, 50000, 50000, 50000, 50000, 100, 1, 45, 12, 26, 52, 15, 2977, 30, 15, 15, 5, 8, 3, 35, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 19);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Effect`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('257a8a4a-a4db-4c98-9bc5-dd18e1198ab1', 'Exquisite_Avernal_Malison_Flute', 'Exquisite Avernal Malison Flute', 45, 50000, 50000, 50000, 50000, 100, 3, 45, 12, 26, 52, 10, 2978, 30, 15, 15, 5, 8, 3, 35, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 21);

-- Suno alb dia armor

REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus6`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `Bonus6Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('24ae4cb1-8265-4d6e-bec7-304d7ca8e38a', 'Exquisite_Abysmal_Breastplate', 'Exquisite Abysmal Breastplate', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 25, 80, 60, 86, 5, 30, 18, 18, 40, 8, 4, 30, 3, 1, 10, 15, 173, 210, 1, 1, 0, 1, 1, 1, 1, '1', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('c4312bf9-334c-4567-a054-7b4f67d006f0', 'Exquisite_Abysmal_Plate_Legs', 'Exquisite Abysmal Plate Legs', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 27, 80, 42, 87, 30, 16, 15, 16, 8, 6, 3, 2, 4, 12, 202, 1, 1, 0, 1, 1, 1, 1, '2;1', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('91c2a279-4113-4440-938e-8813865c59fb', 'Exquisite_Abysmal_Plate_Arms', 'Exquisite Abysmal Plate Arms', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 28, 80, 36, 88, 30, 15, 15, 18, 8, 6, 3, 2, 1, 16, 201, 1, 1, 0, 1, 1, 1, 1, '2;1', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('e69e1150-e3d0-47ee-afad-a8be713931ab', 'Exquisite_Abysmal_Plate_Gauntlets', 'Exquisite Abysmal Plate Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 22, 80, 24, 89, 4, 30, 4, 12, 12, 8, 6, 40, 1, 4, 18, 204, 1, 1, 0, 1, 1, 1, 1, '1', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('7f207e3e-d403-4762-8abc-832eac9a4656', 'Exquisite_Abysmal_Plate_Helm', 'Exquisite Abysmal Plate Helm', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 21, 80, 24, 93, 30, 16, 16, 60, 8, 40, 3, 2, 10, 11, 210, 1, 1, 0, 1, 1, 1, 1, '1', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('667e1f2f-caff-464e-a40c-eb51736dd217', 'Exquisite_Abysmal_Plate_Boots', 'Exquisite Abysmal Plate Boots', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 23, 80, 24, 90, 5, 30, 18, 18, 15, 8, 4, 2, 4, 1, 14, 200, 1, 1, 0, 1, 1, 1, 1, '2;1', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('924606ec-220b-4780-8361-409161f2966a', 'Exquisite_Corrupt_Abysmal_Breastplate', 'Exquisite Corrupt Abysmal Breastplate', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 25, 80, 60, 86, 5, 30, 19, 19, 40, 8, 4, 4, 1, 10, 15, 155, 1, 1, 0, 1, 1, 1, 1, '2', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('9de95dbe-d2cd-40a9-93b8-9144b6a46fc5', 'Exquisite_Corrupt_Abysmal_Gauntlets', 'Exquisite Corrupt Abysmal Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 22, 80, 24, 89, 4, 30, 12, 12, 4, 8, 6, 4, 1, 20, 18, 1, 1, 1, 0, 1, 1, 1, 1, '2', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('9f3b5a7d-42f1-46be-a15d-055c5e63df47', 'Exquisite_Corrupt_Abysmal_Plate_Helm', 'Exquisite Corrupt Abysmal Plate Helm', 49, 50000, 50000, 50000, 50000, 100, 100, 34, 36, 21, 80, 24, 93, 30, 15, 16, 16, 8, 6, 2, 4, 1, 11, 2, 1, 1, 0, 1, 1, 1, 1, '2', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('83b8a48b-762a-4041-8865-09559308be26', 'Exquisite_Diabolic_Boots', 'Exquisite Diabolic Boots', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 23, 80, 32, 185, 4, 30, 16, 16, 15, 8, 6, 2, 4, 1, 14, 4, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('3a3a9738-251c-4557-abf1-c1a3eb709a61', 'Exquisite_Diabolic_Gauntlets', 'Exquisite Diabolic Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 22, 80, 32, 184, 5, 30, 12, 12, 4, 8, 6, 6, 4, 45, 18, 209, 1, 1, 0, 1, 1, 1, 1, '6', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('0ad7da70-31ee-4989-8049-c407820c94b2', 'Exquisite_Diabolical_Gauntlets', 'Exquisite Diabolical Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 22, 80, 32, 184, 5, 30, 12, 12, 4, 8, 6, 8, 4, 35, 18, 207, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('f8db8ddd-19b0-4f98-992c-890c94661180', 'Exquisite_Diabolical_Forged_Gauntlets', 'Exquisite Diabolical Forged Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 22, 80, 32, 184, 5, 30, 12, 12, 4, 8, 6, 2, 4, 28, 18, 202, 1, 1, 0, 1, 1, 1, 1, '11', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('c407524a-677d-4058-8c28-6c2088754687', 'Exquisite_Diabolic_Coif', 'Exquisite Diabolic Coif', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 21, 80, 32, 63, 30, 15, 15, 18, 8, 6, 3, 2, 156, 11, 202, 1, 1, 0, 1, 1, 1, 1, '6', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('51485646-e4f9-48dc-89e0-b13b58a06fdf', 'Exquisite_Diabolical_Coif', 'Exquisite Diabolical Coif', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 21, 80, 32, 63, 30, 18, 15, 15, 8, 6, 8, 3, 2, 11, 202, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('acd5b27f-210f-4d9d-ae7c-7c51823f0c08', 'Exquisite_Diabolical_Forged_Coif', 'Exquisite Diabolical Forged Coif', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 21, 80, 32, 63, 30, 15, 18, 15, 8, 6, 3, 2, 4, 11, 203, 1, 1, 0, 1, 1, 1, 1, '11', 'Public_DB', 20);#
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Extension`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `MaxCount`, `PackSize`, `Realm`, `Price`) VALUES ('b53cd7b9-2716-4c0d-970c-7949b045e214', 'Exquisite_Diabolic_Sleeves', 'Exquisite Diabolic Sleeves', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 28, 48, 183, 5, 18, 15, 15, 8, 6, 1, 3, 2, 16, 201, 1, 1, 1, 1, 1, 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('1f263f24-3db0-4dad-a4ee-39d6ea2bf9f6', 'Exquisite_Diabolic_Leggings', 'Exquisite Diabolic Leggings', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 27, 80, 56, 182, 30, 16, 15, 16, 8, 6, 3, 2, 4, 12, 3, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('6517eadd-27e5-4bfa-8c59-db80d16ce768', 'Exquisite_Diabolic_Hauberk', 'Exquisite Diabolic Hauberk', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 25, 80, 80, 181, 4, 30, 16, 16, 40, 8, 6, 156, 1, 10, 15, 1, 1, 1, 0, 1, 1, 1, 1, '6', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('616b7772-3b34-40bd-9aa8-73e0f5bee9d1', 'Exquisite_Diabolical_Hauberk', 'Exquisite Diabolical Hauberk', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 25, 80, 80, 181, 4, 30, 16, 18, 40, 8, 6, 1, 8, 10, 15, 8, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('d0dcf864-cfe1-4169-bdb2-3c12b9aa7def', 'Exquisite_Diabolical_Forged_Hauberk', 'Exquisite Diabolical Forged Hauberk', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 25, 80, 80, 181, 4, 30, 16, 16, 40, 8, 6, 2, 1, 10, 15, 1, 1, 1, 0, 1, 1, 1, 1, '11', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('ec35fe39-23a6-475c-9b95-a134964cb99e', 'Exquisite_Diabolic_Soul_Gauntlets', 'Exquisite Diabolic Soul Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 22, 80, 32, 184, 5, 30, 12, 12, 4, 8, 6, 156, 4, 163, 18, 204, 1, 1, 0, 1, 1, 1, 1, '19', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('2b160c52-7786-4ba3-8adb-2c239e8fc1ea', 'Exquisite_Diabolic_Soul_Coif', 'Exquisite Diabolic Soul Coif', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 21, 80, 32, 63, 30, 15, 18, 15, 8, 6, 3, 156, 2, 11, 203, 1, 1, 0, 1, 1, 1, 1, '19', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('8c42f273-424f-4bf8-bf52-3292a962f849', 'Exquisite_Diabolic_Soul_Hauberk', 'Exquisite Diabolic Soul Hauberk', 49, 50000, 50000, 50000, 50000, 100, 100, 27, 35, 25, 80, 80, 181, 4, 30, 16, 16, 40, 8, 6, 156, 1, 10, 15, 209, 1, 1, 0, 1, 1, 1, 1, '19', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('d6a3c552-c881-4daa-ae98-09b1ae3bb3e2', 'Exquisite_Infernal_Torment_Vest', 'Exquisite Infernal Torment Vest', 49, 50000, 50000, 50000, 50000, 100, 100, 19, 34, 25, 80, 60, 51, 4, 30, 16, 18, 40, 8, 6, 2, 1, 10, 15, 1, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('1d7c59bc-3d0c-443a-9c19-0c2a9db082de', 'Exquisite_Infernal_Torment_Leggings', 'Exquisite Infernal Torment Leggings', 49, 50000, 50000, 50000, 50000, 100, 100, 19, 34, 27, 80, 42, 52, 30, 16, 15, 16, 8, 6, 3, 2, 4, 12, 203, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('7b536627-773c-47f5-ba78-279b668bf9b7', 'Exquisite_Infernal_Torment_Sleeves', 'Exquisite Infernal Torment Sleeves', 49, 50000, 50000, 50000, 50000, 100, 100, 19, 34, 28, 80, 36, 53, 30, 15, 15, 18, 8, 6, 3, 2, 1, 16, 202, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('e0134b38-e2b5-4111-92d7-53b190a0cd20', 'Exquisite_Infernal_Torment_Gauntlets', 'Exquisite Infernal Torment Gauntlets', 49, 50000, 50000, 50000, 50000, 100, 100, 19, 34, 22, 80, 24, 80, 30, 15, 15, 4, 8, 4, 2, 4, 168, 18, 188, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 20);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('41aaf622-b06e-419a-934e-b9c40d923e64', 'Exquisite_Infernal_Torment_Boots', 'Exquisite Infernal Torment Boots', 49, 50000, 50000, 50000, 50000, 100, 100, 19, 34, 23, 80, 24, 54, 30, 18, 18, 15, 8, 4, 2, 4, 1, 14, 155, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 18);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('14a5ff6e-26c4-449a-9f59-fa322b70b6d7', 'Exquisite_Infernal_Torment_Helm', 'Exquisite Infernal Torment Helm', 49, 50000, 50000, 50000, 50000, 100, 100, 19, 34, 21, 80, 24, 824, 30, 15, 18, 15, 8, 6, 3, 2, 4, 11, 202, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 18);



only 3 merchants lol + spells
- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 483
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex

Re: Upgrated DF items

Postby deathwish » Wed Jul 21, 2010 12:53 am

part 2
Code: Select all
-- Ulo Alb Sapp Armor - items

REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Price`) VALUES ('Ulodem1', 'Superior_Demoniac_Turmoil_Boots', 'Superior Demoniac Turmoil Boots', 46, 50000, 50000, 50000, 50000, 99, 92, 10, 33, 23, 16, 40, 5, 25, 15, 24, 15, 3, 3, 2, 4, 202, 1, 1, 1, 1, 1, 1, 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `Price`) VALUES ('Ulodem3', 'Superior_Demoniac_Turmoil_Gauntlets', 'Superior Demoniac Turmoil Gauntlets', 46, 50000, 50000, 50000, 50000, 99, 92, 10, 33, 22, 16, 39, 5, 25, 15, 15, 4, 3, 2, 4, 28, 204, 1, 1, 1, 1, 1, 1, 1, '9', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('e3ac0ee0-08e1-4195-b57c-9d675fe503a0', 'Superior_Demonic_Turmoil_Gauntlets', 'Superior Demonic Turmoil Gauntlets', 46, 50000, 50000, 50000, 50000, 99, 92, 10, 33, 22, 57, 16, 39, 25, 13, 15, 4, 5, 2, 4, 42, 195, 1, 1, 0, 1, 1, 1, 1, '10', 'Public_DB', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('6adbc1c7-4ab1-4166-87a1-af87b3ffcff6', 'Superior_Demonic_Turmoil_Helm', 'Superior Demonic Turmoil Helm', 47, 50000, 50000, 50000, 50000, 99, 94, 10, 33, 21, 57, 16, 62, 25, 12, 12, 24, 3, 2, 10, 1, 1, 0, 1, 1, 1, 1, '10', 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `Price`) VALUES ('Ulodem4', 'Superior_Demoniac_Turmoil_Helm', 'Superior Demoniac Turmoil Helm', 47, 50000, 50000, 50000, 50000, 99, 94, 10, 33, 21, 16, 62, 25, 19, 19, 19, 3, 3, 2, 4, 203, 1, 1, 1, 1, 1, 1, 1, '9', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('6adbc1c7-4ab1-4166-87a1-af87b3ffcff6', 'Superior_Demonic_Turmoil_Helm', 'Superior Demonic Turmoil Helm', 47, 50000, 50000, 50000, 50000, 99, 94, 10, 33, 21, 57, 16, 62, 25, 24, 12, 12, 5, 6, 3, 2, 190, 1, 1, 0, 1, 1, 1, 1, '10', 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('38133c9c-f5e7-4722-9807-79c868c095d9', 'Superior_Demoniac_Turmoil_Sleeves', 'Superior Demoniac Turmoil Sleeves', 47, 50000, 50000, 50000, 50000, 99, 94, 10, 33, 28, 57, 24, 38, 25, 15, 19, 48, 48, 2, 1, 10, 210, 1, 1, 0, 1, 1, 1, 1, '10;9', 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('c627164a-8c22-42aa-9aeb-5a668d6ec441', 'Superior_Demoniac_Turmoil_Leggings', 'Superior Demoniac Turmoil Leggings', 48, 50000, 50000, 50000, 50000, 99, 96, 10, 33, 27, 57, 28, 37, 25, 24, 15, 15, 3, 3, 2, 4, 210, 1, 1, 0, 1, 1, 1, 1, '10;9', 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('b5021da3-941a-4483-9d51-1133b350705d', 'Superior_Demoniac_Turmoil_Jerkin', 'Superior Demoniac Turmoil Jerkin', 48, 50000, 50000, 50000, 50000, 99, 96, 10, 33, 25, 57, 40, 36, 3, 25, 48, 18, 18, 48, 10, 2, 1, 210, 1, 1, 0, 1, 1, 1, 1, '9', 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('d7bcb884-fcd9-4f09-af8f-2e06affb3819', 'Superior_Demoniac_Turmoil_Frock', 'Superior Demoniac Turmoil Frock', 48, 50000, 50000, 50000, 50000, 99, 96, 10, 33, 25, 20, 686, 3, 25, 18, 18, 48, 48, 2, 6, 10, 210, 1, 1, 0, 1, 1, 1, 1, '10', 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('707f12f6-053c-4c95-8534-41d6fec47a4f', 'Superior_Demoniac_Brigand_Gauntlets', 'Superior Demoniac Brigand Gauntlets', 46, 50000, 50000, 50000, 50000, 99, 92, 10, 33, 22, 57, 16, 39, 25, 16, 16, 4, 3, 2, 4, 110, 204, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('2570885a-6ba2-45cb-be3a-a102bc0de4f5', 'Superior_Gossamer_Soultorn_Boots', 'Superior Gossamer Soultorn Boots', 46, 50000, 50000, 50000, 50000, 99, 46, 32, 23, 57, 8, 143, 25, 15, 24, 15, 3, 3, 2, 1, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('63b63479-fd46-4e8a-b105-5c30610a6344', 'Superior_Gossamer_Soultorn_Gloves', 'Superior Gossamer Soultorn Gloves', 46, 50000, 50000, 50000, 50000, 99, 46, 32, 22, 57, 8, 142, 25, 18, 18, 48, 3, 24, 5, 4, 10, 209, 210, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `Price`) VALUES ('Ulogoss16', 'Superior_Gossamer_Spirit-torn_Cap', 'Superior Gossamer Spirit-torn Cap', 47, 50000, 50000, 50000, 50000, 99, 47, 32, 21, 8, 823, 25, 15, 18, 4, 3, 3, 156, 163, 203, 1, 1, 1, 1, 1, 1, 1, '13', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `Price`) VALUES ('Ulogoss10', 'Superior_Gossamer_Mind-torn_Cap', 'Superior Gossamer Mind-torn Cap', 47, 50000, 50000, 50000, 50000, 99, 47, 32, 21, 8, 823, 25, 15, 18, 4, 3, 3, 156, 163, 209, 1, 1, 1, 1, 1, 1, 1, '8', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('be21976f-8164-4f29-9d18-8c2bee9271fa', 'Superior_Gossamer_Aer_Cap', 'Superior Gossamer Aer Cap', 47, 50000, 50000, 50000, 50000, 99, 47, 32, 21, 57, 8, 822, 25, 15, 18, 4, 3, 3, 156, 163, 196, 1, 1, 0, 1, 1, 1, 1, '5', 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('1577b538-d013-42dc-b967-911df76050df', 'Superior_Gossamer_Soultorn_Sleeves', 'Superior Gossamer Soultorn Sleeves', 47, 50000, 50000, 50000, 50000, 99, 47, 32, 28, 57, 12, 141, 25, 15, 15, 15, 48, 3, 2, 156, 1, 10, 1, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('dd033e8c-5476-4027-914d-c937bf23c376', 'Superior_Gossamer_Soultorn_Pants', 'Superior Gossamer Soultorn Pants', 48, 50000, 50000, 50000, 50000, 99, 48, 32, 27, 57, 14, 140, 25, 24, 24, 5, 3, 2, 196, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('eb0cfcfa-bdc7-426a-8364-2765d0bf9a2e', 'superior_gossamer_bodytorn_vest', 'Superior Gossamer Body-torn Vest', 48, 50000, 50000, 50000, 50000, 99, 48, 32, 25, 57, 20, 139, 2, 25, 48, 19, 2, 3, 48, 10, 156, 163, 209, 210, 1, 1, 0, 1, 1, 1, 1, '13;8', 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('03cc2165-267d-4a74-85e4-bd541737356d', 'Superior_Gossamer_Dissident_Gloves', 'Superior Gossamer Dissident Gloves', 46, 50000, 50000, 50000, 50000, 99, 46, 32, 22, 57, 8, 142, 25, 12, 21, 48, 3, 6, 4, 10, 204, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('1394e14b-cec1-478b-a74a-f767beec3f3c', 'Superior_Gossamer_Dissident_Cap', 'Superior Gossamer Dissident Cap', 47, 50000, 50000, 50000, 50000, 99, 47, 32, 21, 57, 8, 822, 25, 15, 18, 4, 3, 3, 6, 42, 195, 1, 1, 0, 1, 1, 1, 1, '33', 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('6fb35a5b-83c6-4577-a4de-05a2c2cee913', 'Superior_Gossamer_Dissident_Sleeves', 'Superior Gossamer Dissident Sleeves', 47, 50000, 50000, 50000, 50000, 99, 47, 32, 28, 57, 12, 141, 25, 15, 15, 15, 48, 3, 1, 2, 6, 10, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('dc2c9563-ae3f-4630-aef8-fb6f03eb1fa9', 'Superior_Gossamer_Dissident_Vest', 'Superior Gossamer Dissident Vest', 48, 50000, 50000, 50000, 50000, 99, 48, 32, 25, 57, 20, 139, 2, 25, 21, 2, 2, 48, 5, 6, 164, 42, 10, 196, 1, 1, 0, 1, 1, 1, 1, '33', 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('227e190f-6362-4e80-bcb6-b48180a9a73b', 'Superior_Accursed_Ring_of_Devotion', 'Superior Accursed Ring of Devotion', 42, 50000, 50000, 50000, 50000, 99, 41, 35, 1, 103, 25, 19, 25, 2, 3, 2, 6, 196, 206, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 22);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('64520663-bea5-4981-981a-a3dcd0882494', 'Superior_Accursed_Bracer_of_Skill', 'Superior Accursed Bracer of Skill', 43, 50000, 50000, 50000, 50000, 99, 41, 33, 5, 598, 25, 24, 3, 3, 3, 2, 28, 49, 202, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 24);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('7abd4d03-3356-49ba-a5f6-316165bc5d90', 'Superior_Accursed_Belt_of_Might', 'Superior Accursed Belt of Might', 44, 50000, 50000, 50000, 50000, 99, 41, 32, 8, 597, 25, 13, 6, 7, 6, 3, 1, 11, 13, 17, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 25);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('143df968-2e09-49cb-8aa3-2260a5a01153', 'Superior_Accursed_Cloak_of_Shadows', 'Superior Accursed Cloak of Shadows', 45, 50000, 50000, 50000, 50000, 99, 41, 26, 74, 15, 557, 25, 16, 16, 4, 3, 3, 2, 49, 203, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 27);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('ad12cedf-b673-4bea-8caf-16edebd5e49d', 'Superior_Accursed_Jewel_of_Arms', 'Superior Accursed Jewel of Arms', 46, 50000, 50000, 50000, 50000, 95, 41, 24, 3, 118, 25, 3, 6, 6, 6, 9, 164, 19, 13, 17, 148, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 28);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('7e848bc3-3c6d-4020-89a0-ad3674b71dbf', 'Superior_Accursed_Necklace_of_Devotion', 'Superior Accursed Necklace of Devotion', 47, 50000, 50000, 50000, 50000, 99, 41, 29, 3, 101, 25, 18, 8, 7, 3, 156, 11, 18, 209, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 30);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('0f9ef90a-4c91-4b69-91eb-00ef83f62a77', 'Superior_Accursed_Daemon_Ring', 'Superior Accursed Daemon Ring', 48, 50000, 50000, 50000, 50000, 99, 41, 35, 1, 103, 25, 18, 18, 48, 48, 2, 1, 10, 210, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 32);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('7be313df-98f1-4850-a9ad-4c748e946383', 'Superior_Accursed_Daemon_Bracer', 'Superior Accursed Daemon Bracer', 49, 50000, 50000, 50000, 50000, 99, 41, 33, 5, 598, 25, 16, 19, 8, 3, 6, 1, 13, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 34);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('04579f0d-e893-4117-8355-0c778eeee892', 'Superior_Accursed_Daemon_Belt', 'Superior Accursed Daemon Belt', 50, 50000, 50000, 50000, 50000, 99, 41, 32, 8, 597, 25, 19, 19, 19, 3, 3, 5, 1, 203, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 36);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('aa6c19a8-fe06-47ea-8cdb-9685d75dc52c', 'Superior_Accursed_Daemon_Cloak', 'Superior Accursed Daemon Cloak', 50, 50000, 50000, 50000, 50000, 99, 41, 26, 74, 15, 557, 25, 16, 16, 6, 6, 3, 8, 3, 11, 15, 207, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 38);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('d7fcebe1-ec1a-4238-b440-090ed5910d57', 'Superior_Accursed_Scroll', 'Superior Accursed Scroll', 50, 50000, 50000, 50000, 50000, 99, 41, 24, 1, 498, 25, 30, 6, 3, 156, 196, 209, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 40);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('b8eee9b7-af83-402c-99d1-b3b6c19f158c', 'Superior_Accursed_Daemon_Necklace', 'Superior Accursed Daemon Necklace', 50, 50000, 50000, 50000, 50000, 99, 41, 29, 4, 101, 25, 19, 19, 19, 3, 8, 3, 1, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 43);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('bae448d9-1a80-4112-8688-91656201f33b', 'Superior_Accursed_Bone_Ring', 'Superior Accursed Bone Ring', 50, 50000, 50000, 50000, 50000, 99, 41, 35, 1, 103, 25, 15, 3, 3, 5, 6, 6, 19, 163, 196, 190, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 45);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('446961bf-f2d0-4f7b-88bd-b2c0bba59305', 'Superior_Accursed_Bone_Bracer', 'Superior Accursed Bone Bracer', 50, 50000, 50000, 50000, 50000, 99, 41, 33, 5, 598, 25, 19, 3, 32, 3, 3, 2, 43, 10, 40, 202, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 48);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('42024a69-9cd9-4b9f-94dd-35662c93eb17', 'Superior_Accursed_Bone_Belt', 'Superior Accursed Bone Belt', 50, 50000, 50000, 50000, 50000, 99, 41, 32, 5, 597, 25, 15, 15, 15, 16, 3, 3, 2, 4, 1, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 51);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('923af7e1-91cb-4604-87c3-94f3a82fcbf9', 'Superior_Accursed_Bracer_of_Souls', 'Superior Accursed Bracer of Souls', 43, 50000, 50000, 50000, 50000, 99, 41, 33, 5, 598, 25, 24, 3, 3, 3, 2, 164, 163, 202, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 24);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('60fc02f1-e055-4f52-92f9-353332be67e3', 'Superior_Accursed_Bracer_of_Aptitude', 'Superior Accursed Bracer of Aptitude', 43, 50000, 50000, 50000, 50000, 99, 41, 33, 5, 598, 25, 24, 3, 3, 3, 2, 164, 163, 201, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 24);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('13ea7f39-12b3-46e5-a4a4-c37769bb5103', 'Superior_Accursed_Cloak_of_Bruising', 'Superior Accursed Cloak of Bruising', 45, 50000, 50000, 50000, 50000, 99, 41, 26, 74, 15, 557, 25, 16, 16, 4, 3, 3, 2, 164, 203, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 27);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `Object_Type`, `Item_Type`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `PackageID`, `Price`) VALUES ('dce21d6f-7cc5-4e7e-885e-da26c8bc4dc8', 'Superior_Accursed_Bracer_of_Precision', 'Superior Accursed Bracer of Precision', 43, 50000, 50000, 50000, 50000, 99, 41, 33, 5, 598, 25, 21, 3, 3, 5, 2, 164, 163, 196, 1, 1, 0, 1, 1, 1, 1, 'Public_DB', 24);

- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 483
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex

Re: Upgrated DF items

Postby deathwish » Wed Jul 21, 2010 2:34 pm

Updated EMPO items.

Code: Select all
-- EMPO Alb Sapp Weapons

REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `Price`) VALUES ('ef67ffbb-7c5d-40eb-905c-e69f223ca978', 'Superior_Accursed_Avernal_Staff', 'Superior Accursed Avernal Staff', 45, 50000, 50000, 50000, 50000, 99, 150, 44, 1, 1, 8, 12, 49, 45, 19, 25, 5, 15, 50, 2, 3, 163, 156, 165, 198, 209, 1, 1, 0, 1, 1, 1, 10, 10, 32005, 1, 21);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('d5c26e06-e0a1-48e9-a987-99c9dea213dd', 'Superior_Accursed_Avernal_Longsword', 'Superior Accursed Avernal Longsword', 41, 50000, 50000, 50000, 50000, 99, 139, 35, 2, 3, 10, 49, 23, 4, 25, 5, 15, 3, 2, 164, 1, 1, 155, 1, 1, 0, 1, 1, 1, 32003, 1, 22);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('bc2272da-292e-48bd-9279-bcead1b6922f', 'Superior_Accursed_Avernal_Short_Sword', 'Superior Accursed Avernal Short Sword', 42, 50000, 50000, 50000, 50000, 99, 144, 27, 2, 2, 3, 11, 49, 18, 3, 25, 5, 15, 3, 2, 164, 4, 204, 155, 1, 1, 0, 1, 1, 1, 32003, 1, 24);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('59e6b7ec-8243-47be-9450-eb6cb71ed3ce', 'Superior_Accursed_Avernal_Mace', 'Superior Accursed Avernal Mace', 43, 50000, 50000, 50000, 50000, 99, 145, 34, 1, 2, 10, 49, 32, 14, 25, 15, 5, 3, 2, 1, 164, 201, 173, 1, 1, 0, 1, 1, 1, 32003, 1, 25);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('83a1b9d9-906c-404f-b30b-574bf383359e', 'Superior_Accursed_Avernal_Hammer', 'Superior Accursed Avernal Hammer', 44, 50000, 50000, 50000, 50000, 99, 148, 30, 2, 1, 2, 11, 49, 24, 12, 25, 15, 5, 3, 2, 4, 28, 204, 173, 1, 1, 0, 1, 1, 1, 32003, 1, 27);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('2350eb53-9cc3-462d-8366-4b333fe7228e', 'Superior_Accursed_Avernal_Rapier', 'Superior Accursed Avernal Rapier', 45, 50000, 50000, 50000, 50000, 99, 151, 32, 3, 4, 10, 49, 17, 22, 25, 15, 15, 4, 3, 2, 2, 4, 50, 202, 155, 1, 1, 0, 1, 1, 1, 32005, 1, 34);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('454ce76a-d080-4671-acf2-6ead0ba0908c', 'Superior_Accursed_Avernal_Dirk', 'Superior Accursed Avernal Dirk', 49, 50000, 50000, 50000, 50000, 99, 165, 22, 2, 3, 4, 11, 49, 8, 21, 25, 15, 15, 4, 3, 2, 2, 1, 28, 202, 155, 1, 1, 0, 1, 1, 1, 32005, 1, 21);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('1cbd0b8c-688a-411f-bb4d-19917f229804', 'Superior_Accursed_Avernal_Great_Sword', 'Superior Accursed Avernal Great Sword', 39, 50000, 50000, 50000, 50000, 99, 129, 51, 1, 2, 6, 12, 49, 56, 7, 25, 15, 5, 3, 2, 4, 20, 204, 155, 1, 1, 0, 1, 1, 1, 32003, 1, 21);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `Price`) VALUES ('fcade58c-7ee2-45ac-a696-8c404f25a18d', 'Superior_Accursed_Avernal_Great_Hammer', 'Superior Accursed Avernal Great Hammer', 42, 50000, 50000, 50000, 50000, 99, 141, 47, 1, 1, 6, 12, 49, 52, 17, 25, 15, 5, 3, 2, 4, 20, 204, 155, 1, 1, 0, 1, 1, 1, 32003, 1, '22');
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('f96bdcc8-8cea-44b6-a0f7-b5ac1b660b0e', 'Superior_Accursed_Avernal_War_Mattock', 'Superior Accursed Avernal War Mattock', 43, 50000, 50000, 50000, 50000, 99, 144, 38, 1, 3, 6, 12, 49, 40, 16, 25, 5, 15, 3, 2, 20, 4, 204, 155, 1, 1, 0, 1, 1, 1, 32003, 1, '2;1', 'Public_DB', 24);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('76adb27b-4e21-4a63-bb52-269f2e036037', 'Superior_Accursed_Avernal_Lochaber_Axe', 'Superior Accursed Avernal Lochaber Axe', 37, 50000, 50000, 50000, 50000, 99, 126, 48, 1, 2, 7, 12, 49, 50, 68, 25, 5, 15, 3, 2, 41, 1, 201, 155, 1, 1, 0, 1, 1, 1, 32003, 1, '2', 'Public_DB', 25);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('82ca141f-7535-4956-baee-3452f069f85f', 'Superior_Accursed_Avernal_Pike', 'Superior Accursed Avernal Pike', 45, 50000, 50000, 50000, 50000, 99, 147, 44, 1, 3, 7, 12, 49, 45, 69, 25, 15, 15, 4, 3, 2, 3, 1, 41, 201, 173, 1, 1, 0, 1, 1, 1, 32005, 1, '2', 'Public_DB', 27);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('536d226e-46f5-4400-8079-f08ec2ea3f5b', 'Superior_Accursed_Avernal_Lucerne_Hammer', 'Superior Accursed Avernal Lucerne Hammer', 49, 50000, 50000, 50000, 50000, 99, 161, 56, 1, 1, 7, 12, 49, 60, 70, 25, 15, 15, 4, 3, 2, 4, 1, 41, 201, 173, 1, 1, 0, 1, 1, 1, 32006, 1, '2', 'Public_DB', 34);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus1Type`, `Bonus2Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('52a3ac46-196a-49bb-aede-f42ca9074d68', 'Superior_Accursed_Avernal_Crossbow', 'Superior Accursed Avernal Crossbow', 42, 50000, 50000, 50000, 50000, 99, 141, 40, 1, 3, 10, 13, 49, 40, 226, 25, 12, 6, 2, 24, 1, 1, 0, 1, 1, 1, 1, '2;9', 'Public_DB', 21);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus1Type`, `Bonus2Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('37997e61-7be1-4770-89c3-76435b9bc1ac', 'Superior_Accursed_Avernal_Short_Bow', 'Superior Accursed Avernal Short Bow', 43, 50000, 50000, 50000, 50000, 95, 144, 40, 1, 3, 5, 13, 49, 23, 569, 25, 28, 28, 2, 4, 1, 1, 0, 1, 1, 1, 1, '11', 'Public_DB', 22);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('3c0656f4-5582-4b5a-a726-db948e2f9744', 'Superior_Accursed_Avernal_Long_Bow', 'Superior Accursed Avernal Long Bow', 44, 50000, 50000, 50000, 50000, 99, 146, 54, 1, 3, 9, 13, 49, 31, 570, 25, 22, 5, 3, 2, 168, 188, 1, 1, 0, 1, 1, 1, 1, '3', 'Public_DB', 24);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('3c7e6784-d32e-4475-ad68-01fe437a32fa', 'Superior_Accursed_Avernal_Barbed_Whip', 'Superior Accursed Avernal Barbed Whip', 41, 50000, 50000, 50000, 50000, 99, 139, 35, 2, 24, 10, 49, 23, 865, 25, 15, 5, 3, 2, 1, 33, 201, 173, 1, 1, 0, 1, 1, 1, 32003, 1, '33;19', 'Public_DB', 21);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('5df08d06-c59b-453f-ab28-c25f38d76a95', 'Superior_Accursed_Avernal_Flail', 'Superior Accursed Avernal Flail', 44, 50000, 50000, 50000, 50000, 99, 148, 35, 1, 24, 10, 49, 24, 861, 25, 15, 5, 3, 2, 4, 33, 204, 173, 1, 1, 0, 1, 1, 1, 32003, 1, '33;19', 'Public_DB', 25);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('4fd24fd6-4467-40fe-8779-be4eebb97722', 'Superior_Accursed_Avernal_Fist_Wrap', 'Superior Accursed Avernal Fist Wrap', 41, 50000, 50000, 50000, 50000, 99, 139, 35, 1, 27, 10, 49, 23, 3477, 25, 15, 5, 3, 2, 1, 110, 1, 173, 1, 1, 1, 1, 1, 1, 32003, 1, 'Public_DB', 21);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `PackageID`, `Price`) VALUES ('dd107b1b-0f58-4f59-be74-cf946c978a24', 'Superior_Accursed_Avernal_Hand_Wrap', 'Superior Accursed Avernal Hand Wrap', 42, 50000, 50000, 50000, 50000, 99, 143, 27, 2, 1, 27, 11, 49, 18, 3477, 25, 15, 5, 3, 2, 4, 110, 204, 173, 1, 1, 1, 1, 1, 1, 32003, 1, 'Public_DB', 22);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('1677c47b-6dbd-4c92-a203-50fcd98156e6', 'Superior_Accursed_Avernal_Quarterstaff', 'Superior Accursed Avernal Quarterstaff', 44, 50000, 50000, 50000, 50000, 99, 148, 30, 1, 1, 8, 12, 49, 45, 567, 25, 15, 5, 3, 2, 6, 48, 206, 173, 1, 1, 0, 1, 1, 1, 32003, 1, '10', 'Public_DB', 25);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `ProcSpellID`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('5a04e4af-4742-4dbb-8d0f-5d59618f23fa', 'Superior_Accursed_Avernal_Mauler_Staff', 'Superior Accursed Avernal Mauler Staff', 44, 50000, 50000, 50000, 50000, 99, 148, 30, 1, 1, 28, 12, 49, 45, 567, 25, 15, 5, 3, 2, 1, 109, 201, 173, 1, 1, 1, 1, 1, 1, 32003, 1, '60;62;61', 'Public_DB', 25);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `PackageID`, `Price`) VALUES ('d80173f8-99a3-4ff0-a931-8aef5664795a', 'Superior_Accursed_Avernal_Protector', 'Superior Accursed Avernal Protector', 35, 50000, 50000, 50000, 50000, 99, 117, 26, 1, 42, 11, 49, 31, 59, 25, 16, 16, 6, 6, 3, 4, 2, 17, 19, 204, 1, 1, 0, 1, 1, 1, 3, 3, 16003, 1, 'Public_DB', 21);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `Price`) VALUES ('avernaldefender', '2_Superior_Accursed_Avernal_Defender', 'Superior Accursed Avernal Defender', 43, 50000, 50000, 50000, 50000, 99, 145, 35, 2, 2, 42, 11, 49, 38, 60, 25, 16, 16, 6, 6, 3, 4, 2, 13, 17, 204, 1, 1, 1, 1, 1, 1, 3, 3, 32003, 2, 27);
REPLACE 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`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `Realm`, `Price`) VALUES ('avernalblock', '2_Superior_Accursed_Avernal_Bladeblocker', 'Superior Accursed Avernal Bladeblocker', 47, 50000, 50000, 50000, 50000, 99, 162, 45, 2, 3, 42, 11, 49, 41, 1144, 25, 16, 16, 6, 6, 3, 4, 2, 17, 19, 204, 1, 1, 1, 1, 1, 1, 3, 3, 32005, 2, 34);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('0cee86d9-a8a7-48f9-b90d-98b177923ad2', 'Superior_Accursed_Avernal_Lute', 'Superior Accursed Avernal Lute', 40, 50000, 50000, 50000, 50000, 99, 2, 45, 12, 49, 15, 2970, 25, 5, 15, 2, 3, 35, 8, 173, 207, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 25);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('ef27048b-76e2-43bc-8862-b91572da1b0b', 'Superior_Accursed_Avernal_Drum', 'Superior Accursed Avernal Drum', 40, 50000, 50000, 50000, 50000, 99, 1, 45, 12, 49, 15, 2971, 25, 5, 15, 2, 3, 35, 8, 173, 207, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 27);
REPLACE INTO ItemTemplate (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `Object_Type`, `Item_Type`, `Color`, `Weight`, `Model`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `IsPickable`, `IsDropable`, `CanDropAsLoot`, `IsTradable`, `MaxCount`, `PackSize`, `Realm`, `AllowedClasses`, `PackageID`, `Price`) VALUES ('bbbf70a6-4d7b-4117-a0d4-dd261f3926e2', 'Superior_Accursed_Avernal_Flute', 'Superior Accursed Avernal Flute', 45, 50000, 50000, 50000, 50000, 99, 3, 45, 12, 49, 10, 2978, 25, 5, 15, 2, 3, 35, 8, 173, 207, 1, 1, 0, 1, 1, 1, 1, '4', 'Public_DB', 34);


- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 483
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex


Return to “%s” DOL Code Contributions

Who is online

Users browsing this forum: No registered users and 1 guest