Public Database Server

[geshi]

The dragon weapons are a mess! I'm so tempted to delete them all and make them all from scratch! Press on....done ranting.

Yep.. there is a public release of them but the procs are messed up and I can't remember if they have stats or not..

[mattress]

I'm running into about 3-6 copies of each, none are perfect. Models, colors, effects, missing/incorrect procs, I don't think I've seen any that are spot on yet.

[Graveen]

Not sure if Storm's one 'll be better, but it worths a try !

[Roozzz]

Not sure if Storm's one 'll be better, but it worths a try !

It is. I think they are fully correct at this point. Go grab them Viper

[Phen]

we are still missing handlers for the resist buffs on equip for them iirc

[deathwish]

dont no if you ever got around to updating the new df items, but i did make a start but i been so busy i not been able to finish, but heres what merchants i have done and the new spells to match, hope it can be some help.

Spell update:

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, 'updated', 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, 'updated', 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, 'updated', 0);

-- Pico alb dia seals

Code: Select all

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, 'updated', 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, 'updated', 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, 'updated', 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, 'updated', 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, 'updated', 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, 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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, 'updated', 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, 'updated', 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', 'updated', 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, 'updated', 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, 'updated', 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, 'updated', 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, 'updated', 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, 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 21);

[deathwish]

-- Suno alb dia armor

Code: Select all

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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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, 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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, 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 18);

-- EMPO Alb Sapp Weapons

Code: Select all

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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 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, 'updated', 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, 'updated', 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', 'updated', 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', 'updated', 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, 'updated', 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', 'updated', 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', 'updated', 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', 'updated', 34);

Hope that can be of some help

[viper1805]

thanks deathwish
-> imported

[VladDracula]

i am testing on this server for you guys ... and i would like to know is there a way to /report ( or something to the like ) .. for this server ?

Thank you

[deathwish]

/report ( or something to the like )

Depending on the server, there maybe different ways to report bugs depending what systems are active, best thing to do is use the /cmd command ingame and view what commands are available to you

[viper1805]

you can use appeal ... some already did that

[stephenxpimentel]

Updated Epics Enjoy.

They all have their procs/charges, models, stats.

EpicArmor.txt

(407.42 KiB) Downloaded 143 times

[viper1805]

Thanks

-> added to pubdb server

[Ephemeral]

Code: Select all

UPDATE `spell` SET `Spell_ID`=`Bainshee RR5 Verst` WHERE `SpellID`=`36003`;

Run it, thank me later because there's some odd characters in the Spell_ID of that spell that cause some issues when opening it.

[Argo]

Code: Select all

UPDATE `spell` SET `Spell_ID`=`Bainshee RR5 Verst` WHERE `SpellID`=`36003`;

Run it, thank me later because there's some odd characters in the Spell_ID of that spell that cause some issues when opening it.

try it with this one, since the upper syntax causes problems if you try to run it

Code: Select all

UPDATE spell SET Spell_ID = "Bainshee RR5 Verst" WHERE SpellID = 36003;