Updated Item

[Arms]

Fallen Soldiers Rage - Fixed Proc/Color/Effect

Code: Select all

UPDATE ItemTemplate SET `Id_nb` = 'Fallen_Soldiers_Rage', `Name` = 'Fallen Soldier\'s Rage', `Level` = '51', `Durability` = '50000', `MaxDurability` = '50000', `Condition` = '50000', `MaxCondition` = '50000', `Quality` = '100', `DPS_AF` = '165', `SPD_ABS` = '59', `Hand` = '1', `Type_Damage` = '3', `Object_Type` = '7', `Item_Type` = '12', `Color` = '143', `Emblem` = '0', `Effect` = '283', `Weight` = '45', `Model` = '3968', `Extension` = '0', `Bonus` = '35', `Bonus1` = '1', `Bonus2` = '1', `Bonus3` = '1', `Bonus4` = '1', `Bonus5` = '1', `ExtraBonus` = '0', `Bonus1Type` = '19', `Bonus2Type` = '17', `Bonus3Type` = '16', `Bonus4Type` = '15', `Bonus5Type` = '13', `ExtraBonusType` = '0', `IsPickable` = '1', `IsDropable` = '1', `Gold` = '78', `Silver` = '0', `Copper` = '0', `MaxCount` = '1', `PackSize` = '1', `Charges` = '0', `MaxCharges` = '0', `SpellID` = '0', `ProcSpellID` = '32304', `Realm` = '1', `IsTradable` = '1', `Bonus6` = '5', `Bonus7` = '22', `Bonus8` = '8', `Bonus9` = '4', `Bonus10` = '10', `Bonus6Type` = '164', `Bonus7Type` = '1', `Bonus8Type` = '204', `Bonus9Type` = '173', `Bonus10Type` = '201', `Charges1` = '0', `MaxCharges1` = NULL WHERE `Id_nb` = 'Fallen_Soldiers_Rage' LIMIT 1

[Phen]

by arms » Wed Jan 27, 2010 8:49 pm

Duskwood Desert Bullhorn Bow - Fixed Model/Stats

Code: Select all

UPDATE INTO `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `Gold`, `Silver`, `Copper`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `Platinum`, `CanDropAsLoot`, `AllowedClasses`, `ArtiID`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`) VALUES ('4996820d-ca37-466d-a606-f63169941cf9', 'Duskwood_Desert_Bullhorn_Bow2', 'Duskwood Desert Bullhorn Bow', '51', '50000', '50000', '50000', '50000', '100', '165', '59', '1', '3', '9', '13', '0', '0', '0', '35', '848', '0', '35', '30', '13', '1', '2', '1', '0', '2', '202', '174', '188', '154', '0', '1', '1', '78', '0', '0', '1', '1', '0', '0', '0', '45001', '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '0', '', NULL, NULL, NULL);

[Arms]

Duskwood Desert Bullhorn Bow - Fixed Model/Stats

Revision: Duskwood_Desert_Bullhorn_Bow2

[Arms]

Updated 1_Adamant_Tether_Breaker - Fixed: weight/model/level/effect/proc

Code: Select all

UPDATE `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `Gold`, `Silver`, `Copper`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `Platinum`, `CanDropAsLoot`, `AllowedClasses`, `ArtiID`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`) VALUES ('2ce2cb2c-8370-42c5-a7cf-eaea2199ea2e', '1_Adamant_Tether_Breaker', 'Adamant Tether Breaker', '49', '50000', '50000', '50000', '50000', '100', '165', '49', '1', '2', '6', '12', '0', '0', '22', '44', '841', '0', '35', '22', '4', '6', '4', '0', '0', '1', '20', '13', '40', '0', '0', '1', '1', '150', '0', '0', '1', '1', '0', '0', '0', '32030', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '', NULL, '0', '', NULL, NULL, NULL);

[Arms]

1_Ageless_Telamon_Sleeves - Fixed: Quality/Bonus%/Level

Code: Select all

UPDATE ItemTemplate SET `Id_nb` = '1_Ageless_Telamon_Sleeves', `Name` = 'Ageless Telamon Sleeves', `Level` = '48', `Durability` = '50000', `MaxDurability` = '50000', `Condition` = '50000', `MaxCondition` = '50000', `Quality` = '95', `DPS_AF` = '98', `SPD_ABS` = '19', `Hand` = '0', `Type_Damage` = '0', `Object_Type` = '34', `Item_Type` = '28', `Color` = '0', `Emblem` = '0', `Effect` = '0', `Weight` = '18', `Model` = '83', `Extension` = '0', `Bonus` = '15', `Bonus1` = '16', `Bonus2` = '6', `Bonus3` = '18', `Bonus4` = '0', `Bonus5` = '0', `ExtraBonus` = '0', `Bonus1Type` = '1', `Bonus2Type` = '4', `Bonus3Type` = '10', `Bonus4Type` = '0', `Bonus5Type` = '0', `ExtraBonusType` = '0', `IsPickable` = '1', `IsDropable` = '1', `Gold` = '0', `Silver` = '12', `Copper` = '0', `MaxCount` = '1', `PackSize` = '1', `Charges` = '0', `MaxCharges` = '0', `SpellID` = '0', `ProcSpellID` = '0', `Realm` = '1', `IsTradable` = '1', `Bonus6` = '0', `Bonus7` = '0', `Bonus8` = '0', `Bonus9` = '0', `Bonus10` = '0', `Bonus6Type` = '0', `Bonus7Type` = '0', `Bonus8Type` = '0', `Bonus9Type` = '0', `Bonus10Type` = '0', `Charges1` = NULL WHERE `Id_nb` = '1_Ageless_Telamon_Sleeves' LIMIT 1

[Arms]

1_Agmundrs_Foe_Slayer - Fixed: Weight/Wpn Type/Model/Effect/Proc

Code: Select all

UPDATE ItemTemplate SET `Id_nb` = '1_Agmundrs_Foe_Slayer', `Name` = 'Agmundr\'s Foe Slayer', `Level` = '50', `Durability` = '50000', `MaxDurability` = '50000', `Condition` = '50000', `MaxCondition` = '50000', `Quality` = '100', `DPS_AF` = '165', `SPD_ABS` = '57', `Hand` = '1', `Type_Damage` = '2', `Object_Type` = '11', `Item_Type` = '12', `Color` = '0', `Emblem` = '0', `Effect` = '276', `Weight` = '20', `Model` = '957', `Extension` = '0', `Bonus` = '35', `Bonus1` = '40', `Bonus2` = '6', `Bonus3` = '6', `Bonus4` = '0', `Bonus5` = '0', `ExtraBonus` = '5', `Bonus1Type` = '10', `Bonus2Type` = '19', `Bonus3Type` = '13', `Bonus4Type` = '0', `Bonus5Type` = '0', `ExtraBonusType` = '52', `IsPickable` = '1', `IsDropable` = '1', `Gold` = '105', `Silver` = '0', `Copper` = '0', `MaxCount` = '1', `PackSize` = '1', `Charges` = '0', `MaxCharges` = '0', `SpellID` = '0', `ProcSpellID` = '40022', `Realm` = '2', `IsTradable` = '1', `Bonus6` = '0', `Bonus7` = '0', `Bonus8` = '0', `Bonus9` = '0', `Bonus10` = '0', `Bonus6Type` = '0', `Bonus7Type` = '0', `Bonus8Type` = '0', `Bonus9Type` = '0', `Bonus10Type` = '0', `Charges1` = NULL WHERE `Id_nb` = '1_Agmundrs_Foe_Slayer' LIMIT 1

[Arms]

1_Ancient_Ebony_Sleeves - Fixed: Quality/Stats (Power Pool)

Code: Select all

UPDATE ItemTemplate SET `Id_nb` = '1_Ancient_Ebony_Sleeves', `Name` = 'Ancient Ebony Sleeves', `Level` = '48', `Durability` = '50000', `MaxDurability` = '50000', `Condition` = '50000', `MaxCondition` = '50000', `Quality` = '95', `DPS_AF` = '47', `SPD_ABS` = '0', `Hand` = '0', `Type_Damage` = '0', `Object_Type` = '32', `Item_Type` = '28', `Color` = '0', `Emblem` = '0', `Effect` = '0', `Weight` = '12', `Model` = '141', `Extension` = '0', `Bonus` = '35', `Bonus1` = '5', `Bonus2` = '3', `Bonus3` = '5', `Bonus4` = '21', `Bonus5` = '0', `ExtraBonus` = '0', `Bonus1Type` = '15', `Bonus2Type` = '196', `Bonus3Type` = '12', `Bonus4Type` = '5', `Bonus5Type` = '0', `ExtraBonusType` = '0', `IsPickable` = '1', `IsDropable` = '1', `Gold` = '0', `Silver` = '12', `Copper` = '0', `MaxCount` = '1', `PackSize` = '1', `Charges` = '0', `MaxCharges` = '0', `SpellID` = '0', `ProcSpellID` = '0', `Realm` = '1', `IsTradable` = NULL WHERE `Id_nb` = '1_Ancient_Ebony_Sleeves' LIMIT 1

[Arms]

Arcanium_Magma_Infused_Buckler1 - Fixed: Weight/Stats/Proc

Code: Select all

UPDATE `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `Gold`, `Silver`, `Copper`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `Platinum`, `CanDropAsLoot`, `AllowedClasses`, `ArtiID`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`) VALUES ('7dd3d64b-6074-4ce3-8437-89b6cd3c4b35', 'Arcanium_Magma_Infused_Buckler1', 'Arcanium Magma Infused Buckler', '49', '50000', '50000', '50000', '50000', '100', '159', '28', '2', '1', '42', '11', '0', '0', '0', '25', '59', '0', '35', '21', '3', '2', '18', '8', '0', '3', '163', '191', '148', '196', '0', '1', '1', '76', '44', '0', '1', '1', '0', '0', '0', '40003', '2', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '0', '', NULL, NULL, NULL);

[Graveen]

Thx a loot !

[Roozzz]

Either use UPDATE or INSERT INTO, a combination doesn't work so well

Also I would recommend only updating the fields you actually change, simply for clarity.

Thanks

[Arms]

Duskwood Desert Bullhorn Bow - Fixed Model/Stats

Code: Select all

UPDATE ItemTemplate SET `Id_nb` = 'Duskwood_Desert_Bullhorn_Bow2', `Name` = 'Duskwood Desert Bullhorn Bow', `Level` = '51', `Durability` = '50000', `MaxDurability` = '50000', `Condition` = '50000', `MaxCondition` = '50000', `Quality` = '100', `DPS_AF` = '165', `SPD_ABS` = '59', `Hand` = '1', `Type_Damage` = '3', `Object_Type` = '9', `Item_Type` = '13', `Color` = '0', `Emblem` = '0', `Effect` = '0', `Weight` = '35', `Model` = '848', `Extension` = '0', `Bonus` = '35', `Bonus1` = '30', `Bonus2` = '13', `Bonus3` = '1', `Bonus4` = '2', `Bonus5` = '1', `ExtraBonus` = '0', `Bonus1Type` = '2', `Bonus2Type` = '202', `Bonus3Type` = '174', `Bonus4Type` = '188', `Bonus5Type` = '154', `ExtraBonusType` = '0', `IsPickable` = '1', `IsDropable` = '1', `Gold` = '78', `Silver` = '0', `Copper` = '0', `MaxCount` = '1', `PackSize` = '1', `Charges` = '0', `MaxCharges` = '0', `SpellID` = '0', `ProcSpellID` = '45001', `Realm` = '1', `IsTradable` = '1', `Bonus6` = NULL WHERE `Id_nb` = 'Duskwood_Desert_Bullhorn_Bow2' LIMIT 1

[Graveen]

Not on Storm for now ? or can i include them ?

[Arms]

Yes, please add them if you can. Not sure which of these that i've fixed that you have added yet, but I'm going through it from A-Z for my database too, so I'm sure a lot will be fixed along the line...

[Arms]

1_Angel_Forged_Breastplate - Fixed: model/proc

Code: Select all

UPDATE `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `Gold`, `Silver`, `Copper`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `Platinum`, `CanDropAsLoot`, `AllowedClasses`, `ArtiID`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`) VALUES ('6ca69af3-6984-4684-bbd2-7660ac419b00', '1_Angel_Forged_Breastplate', 'Angel-Forged Breastplate', '50', '50000', '50000', '50000', '50000', '100', '102', '34', '0', '0', '36', '25', '0', '0', '0', '90', '693', '5', '35', '30', '30', '30', '0', '0', '0', '3', '2', '1', '0', '0', '0', '1', '1', '160', '0', '0', '1', '1', '0', '0', '0', '31029', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '', NULL, '0', '', NULL, NULL, NULL);

[Arms]

1_Apocalypse_Arms - Fixed: Proc

Code: Select all

UPDATE `itemtemplate` (`ItemTemplate_ID`, `Id_nb`, `Name`, `Level`, `Durability`, `MaxDurability`, `Condition`, `MaxCondition`, `Quality`, `DPS_AF`, `SPD_ABS`, `Hand`, `Type_Damage`, `Object_Type`, `Item_Type`, `Color`, `Emblem`, `Effect`, `Weight`, `Model`, `Extension`, `Bonus`, `Bonus1`, `Bonus2`, `Bonus3`, `Bonus4`, `Bonus5`, `ExtraBonus`, `Bonus1Type`, `Bonus2Type`, `Bonus3Type`, `Bonus4Type`, `Bonus5Type`, `ExtraBonusType`, `IsPickable`, `IsDropable`, `Gold`, `Silver`, `Copper`, `MaxCount`, `PackSize`, `Charges`, `MaxCharges`, `SpellID`, `ProcSpellID`, `Realm`, `IsTradable`, `Bonus6`, `Bonus7`, `Bonus8`, `Bonus9`, `Bonus10`, `Bonus6Type`, `Bonus7Type`, `Bonus8Type`, `Bonus9Type`, `Bonus10Type`, `Charges1`, `MaxCharges1`, `SpellID1`, `ProcSpellID1`, `PoisonSpellID`, `PoisonMaxCharges`, `PoisonCharges`, `Platinum`, `CanDropAsLoot`, `AllowedClasses`, `ArtiID`, `CanUseEvery`, `PackageID`, `Flags`, `BonusLevel`, `Description`) VALUES ('c0aad2e1-a1c4-4ba9-902c-9acef7c3d966', '1_Apocalypse_Arms', 'Apocalypse Arms', '50', '50000', '50000', '50000', '50000', '100', '102', '27', '0', '0', '35', '28', '0', '0', '0', '48', '183', '0', '35', '22', '22', '5', '6', '5', '0', '3', '4', '155', '203', '204', '0', '1', '1', '0', '12', '0', '1', '1', '0', '0', '0', '40006', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '', NULL, '0', '', NULL, NULL, NULL);