Updated Item

[bluraven]

On live you can get encounter credit even if you don't qualify for the artifact. I like it that way because it's sort of an achievement list for your character, you might not actually be able to get or use the artifact, but you can have a record that you've done the encounter. Currently, ours does not work this way.

[Arms]

Orions_Belt_Credit - Fixed: Problem with not being able to turn in for SB.

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`, `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 ('toa_orions_belt_credit', 'orions_belt_credit', 'Orion\'s Belt Credit', 0, 50000, 50000, 50000, 50000, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1884, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, NULL, 'Artifact Credits', NULL, NULL, NULL);

Arms, Please avoid changing anything related to artifact credit. In this case you zeroed the credit cost, so the credit was free and also modified the item type. Artifact usage is decided by classes lists on the artifacts themselves, not the credits. Anyone can buy a credit, but upon turning it checks the artifacts for class type and only grants credit if their is a version usable by the class.

Thanks tola, I value the information you just gave me.
I'm still learning, so any assistance you guys provide me with is greatly appreciated!


- Jared

[Arms]

Basalt Great Sword of Bedlam - Fixed: Effect/Color/Stats

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`, `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 ('ulung127', 'Basalt_Great_Sword_of_Bedlam', 'Basalt Great Sword of Bedlam', 50, 50000, 50000, 50000, 50000, 100, 165, 55, 1, 1, 6, 12, 43, 0, 33, 54, 7, 0, 35, 2, 5, 15, 7, 5, 0, 164, 204, 4, 16, 201, 0, 1, 1, 15, 0, 0, 1, 1, 0, 0, 0, 32210, 1, 1, 0, 15, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 32124, 0, 0, 0, 0, 1, '', NULL, 0, '', NULL, NULL, NULL);

[Arms]

Basalt Bow of Bedlam (MID) - Fixed: Model/Color

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`, `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 ('ulung120', 'basalt_bow_of_bedlam2', 'Basalt Bow of Bedlam', 50, 50000, 50000, 50000, 50000, 100, 165, 53, 1, 3, 15, 13, 9, 0, 0, 36, 564, 0, 35, 2, 25, 0, 7, 5, 0, 168, 2, 0, 16, 12, 0, 1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 32304, 2, 1, 5, 0, 0, 0, 0, 202, 0, 0, 0, 0, 0, 0, 0, 40002, 0, 0, 0, 0, 1, '', NULL, 0, '', NULL, NULL, NULL);

[Arms]

Arcanium Scintillating Blade - Fixed: Weight/Dmg Type/Model/Effect

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`, `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 ('c5d2e556-6e0b-4774-936d-4b8fc8e61ef4', 'Arcanium_Scintillating_Blade', 'Arcanium Scintillating Blade', 49, 50000, 50000, 50000, 50000, 97, 165, 41, 0, 2, 3, 10, 0, 0, 15, 30, 2203, 0, 35, 4, 6, 60, 2, 60, 0, 44, 18, 10, 155, 210, 0, 1, 1, 19, 11, 0, 1, 1, 0, 0, 0, 32210, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', NULL, NULL, NULL);

[Arms]

Delete this plz, it's a double.

[Arms]

Arcanium Trident of the Pure - Fixed: Model/Effect/Color

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`, `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 ('49e6d3c9-5840-43db-a214-9b0fa7c74a21', 'Arcanium_Trident_of_the_Pure', 'Arcanium Trident of the Pure', 51, 50000, 50000, 50000, 50000, 100, 165, 41, 0, 3, 4, 10, 48, 0, 83, 30, 1004, 0, 35, 5, 40, 15, 8, 2, 0, 50, 10, 2, 202, 155, 0, 1, 1, 78, 0, 0, 1, 1, 0, 0, 0, 40019, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', NULL, NULL, NULL);

[Arms]

Dragonstorm - Fixed: Stats/Model/Effect/Proc

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`, `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 ('b75646f7-edda-44e9-9e31-4b7a0c55eb58', 'Dragonstorm', 'Dragonstorm', 50, 50000, 50000, 50000, 50000, 100, 165, 60, 1, 1, 12, 12, 0, 0, 39, 55, 3922, 0, 35, 30, 1, 1, 1, 1, 0, 1, 12, 13, 11, 17, 0, 1, 1, 39, 0, 0, 1, 1, 0, 0, 0, 32202, 2, 1, 1, 5, 10, 4, 10, 19, 164, 148, 173, 201, 0, 0, 0, 3012, 0, 0, 0, 0, 1, '', 0, 0, '', NULL, NULL, NULL);

[Arms]

Arcanium Helm of the Cryth (ALB) - Fixed: Model

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`, `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 ('0ed0201f-c39f-48a0-855a-671c14998bff', 'Arcanium_Helm_of_the_Cryth', 'Arcanium Helm of the Cryth', 51, 50000, 50000, 50000, 50000, 100, 102, 34, 0, 0, 36, 21, 0, 0, 0, 30, 2428, 4, 35, 5, 56, 9, 2, 40, 0, 13, 10, 15, 155, 210, 0, 1, 1, 78, 0, 0, 1, 1, 0, 0, 0, 32030, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', NULL, NULL, NULL);

[Argo]

arms, you rock dude

[Sand]

This thread is getting rather long which is a good thing, as your providing a lot of fixes for the server but thinking maybe we should consider if there is a better way to handle this.

I don't have on offhand but just a thought.

[Graveen]

What was the process used for allowing Thania to perform changes on the db ? could be interesting to push to Arms.

[Graveen]

All on Storm, TY

[Graveen]

What was the process used for allowing Thania to perform changes on the db ? could be interesting to push to Arms.

On this point, who was merging the DB entries Thalia produced into Storm ?

[Graveen]

Well it is interesting to review the way it is working. the problem is to validate and commit user entries

1) possible to work from any sql tool on this database
2) track the changes
3) update the changes

Arms, i'm sending you a guide