I realize it's not really the most popular/preferred thing for me to contribute to the project, but I'd probably have to figure out programming from scratch if I tried to go deeper, so...
There are two reasons for this post. One is to ask a couple questions about how things are set up so that I can provide the most accurate information possible, and the other is to confirm that the information is in a format desired by members of the project.
First off, several of the items in the AH (which I'd planned on getting to early on) operate in sets. Are there any entries in place in item_mods.sql to cause the set bonuses to function? I checked Moliones' Ring as a reference and all it has is the STR+4 entry.
Secondly, I would assume that a huge portion of the mods included on equipment are not yet implemented. My plan is to provide commented placeholder lines so that these effects can be added later.
Lastly, I created an Excel file that lets me enter simple descriptions and values and wind up with entries that can be pasted directly into the sql. I confirmed that the entries created worked in-game using my local test server. An example of the output as well as the format I plan on including in my contributions can be found below. The Excel file creates all of the lines automatically including comments except for the item title using two entries. The first line below was created as a paste entry from "def" and "114" for example.
An example of a commented/unknown effect is below, for an effect found on Mochi Chainmail +1.-- -------------------------------------------------------
-- Mochi Hakama +1
-- -------------------------------------------------------
INSERT INTO `item_mods` VALUES (27177, 1, 114); -- Defense + 114
INSERT INTO `item_mods` VALUES (27177, 2, 62); -- HP + 62
INSERT INTO `item_mods` VALUES (27177, 8, 32); -- STR + 32
INSERT INTO `item_mods` VALUES (27177, 10, 14); -- VIT + 14
INSERT INTO `item_mods` VALUES (27177, 11, 26); -- AGI + 26
INSERT INTO `item_mods` VALUES (27177, 12, 32); -- INT + 32
INSERT INTO `item_mods` VALUES (27177, 13, 17); -- MND + 17
INSERT INTO `item_mods` VALUES (27177, 14, 10); -- CHR + 10
INSERT INTO `item_mods` VALUES (27177, 68, 43); -- Evasion + 43
INSERT INTO `item_mods` VALUES (27177, 31, 64); -- Magic Evasion + 64
INSERT INTO `item_mods` VALUES (27177, 29, 3); -- Magic Defense Bonus + 3
INSERT INTO `item_mods` VALUES (27177, 384, 61); -- Haste + 61
INSERT INTO `item_mods` VALUES (27177, 259, 8); -- Dual Wield + 8
Is this the preferred format for my entries, or are there any changes I should make? If these results look good, I will update this first post with my plans on the order of things I will update, and would be willing to take requests for the sake of furthering development. I can also provide my Excel tool if it's something other people would find useful or would like to use to contribute.-- INSERT INTO `item_mods` VALUES (26825, ?, 10); -- Utsusemi spellcasting + 10
UPDATE: Excel file provided in my second post, two down.
My plan of attack prioritizes things as follows:
Current Auction House entries (armor, top to bottom, then weapons, top to bottom)
Relic weapons (all versions)
Salvage, Nyzul, Limbus, etc. sets.
Reforged AF1 (NQ and HQ)
Mythic weapons (all versions)
Reforged AF2 (NQ and HQ)
That should provide a nice spread for content up to Lv99 for server hosts to work with. Once that's done, I'd be willing to take requests and if I don't have any I'll start into AF3, salvage upgrades, etc.
