Dawn of Light

PostPosted: **Wed Feb 17, 2010 6:21 pm**

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.

PostPosted: **Wed Feb 17, 2010 8:48 pm**

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

PostPosted: **Wed Feb 17, 2010 9:46 pm**

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);

PostPosted: **Wed Feb 17, 2010 10:23 pm**

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);

PostPosted: **Fri Feb 19, 2010 8:52 am**

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);

PostPosted: **Fri Feb 19, 2010 8:52 am**

Delete this plz, it's a double.

PostPosted: **Fri Feb 19, 2010 9:24 am**

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);

PostPosted: **Fri Feb 19, 2010 8:37 pm**

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);

PostPosted: **Fri Feb 19, 2010 10:00 pm**

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);

PostPosted: **Sat Feb 20, 2010 2:13 am**

arms, you rock dude

PostPosted: **Sat Feb 20, 2010 6:33 am**

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.

PostPosted: **Sat Feb 20, 2010 8:45 am**

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

PostPosted: **Sat Feb 20, 2010 8:54 am**

All on Storm, TY

PostPosted: **Sat Feb 20, 2010 8:56 am**

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 ?

PostPosted: **Sat Feb 20, 2010 9:17 am**

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

Dawn of Light

Updated Item

Re: Updated Item

Re: Updated Item

Updated Item

Updated Item

Updated Item

Delete this post plz, it's a double.

Updated Item

Updated Item

Updated Item

Re: Updated Item

Re: Updated Item

Re: Updated Item

Re: Updated Item

Re: Updated Item

Re: Updated Item