Dawn of Light

Dawn of Light - Your Portal to DAoC Emulation
http://dolserver.sourceforge.net/

Public Database Server

http://dolserver.sourceforge.net/viewtopic.php?t=20068

Page 3 of 4

Re: Public Database Server

PostPosted: Mon Jan 30, 2012 12:51 pm
by 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..

Re: Public Database Server

PostPosted: Mon Jan 30, 2012 1:04 pm
by 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.

Re: Public Database Server

PostPosted: Mon Jan 30, 2012 2:33 pm
by Graveen
Not sure if Storm's one 'll be better, but it worths a try !

Re: Public Database Server

PostPosted: Mon Jan 30, 2012 4:26 pm
by 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 ;)

Re: Public Database Server

PostPosted: Mon Jan 30, 2012 4:39 pm
by Phen
we are still missing handlers for the resist buffs on equip for them iirc

Re: Public Database Server

PostPosted: Tue Jan 31, 2012 11:52 pm
by 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);

Re: Public Database Server

PostPosted: Tue Jan 31, 2012 11:54 pm
by 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

Re: Public Database Server

PostPosted: Wed Feb 01, 2012 7:02 am
by viper1805
thanks deathwish
-> imported

Re: Public Database Server

PostPosted: Fri Feb 03, 2012 11:05 pm
by 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

Re: Public Database Server

PostPosted: Sun Feb 05, 2012 6:31 pm
by 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 :)

Re: Public Database Server

PostPosted: Sun Feb 05, 2012 6:46 pm
by viper1805
you can use appeal ... some already did that

Re: Public Database Server

PostPosted: Thu Feb 09, 2012 11:31 pm
by stephenxpimentel
Updated Epics ;) Enjoy.

They all have their procs/charges, models, stats. :)
EpicArmor.txt
(407.42 KiB) Downloaded 143 times

Re: Public Database Server

PostPosted: Fri Feb 10, 2012 6:46 am
by viper1805
Thanks ;)

-> added to pubdb server

Re: Public Database Server

PostPosted: Fri Feb 10, 2012 7:56 am
by 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.

Re: Public Database Server

PostPosted: Fri Feb 10, 2012 1:01 pm
by 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;
All times are UTC
Page 3 of 4
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/