10-6-2017 - I'm working on fixing resist SPA's that don't scale yet we have them currently trying to scale for some reason. So I'm setting them to not scale anymore and use the right values, either base or max value. - Gidono
10-7-2017 - I fixed a bunch of persistent effects, mapping them to their right spells. Thanks Barudin314 for listing those out. - Gidono
10-8-2017 - Took a break from working on spells and I'm working on adding some options to the advanced item search. I added a search option for heirloom items so far and fixed the advanced item search to default to Any Effect under the Effect drop down box. Also fixed spells listed on a NPC page will now show all 32 SPA slots instead of 12 if the spell has SPA's > than 12.- Gidono
10-8-2017 - Spells listed on a NPC page will now show all 32 SPA slots instead of 12 if the spell has SPA's > than 12. Fixed a bunch of persistent effects, mapping them to their right spells. - This code is live now. The persistent effects won't update until we run the spell parser again
10-8-2017 - Added Mana Regen to the advanced item search tool under Limit to items with stats: drop down boxes and Sort Items By: drop down boxes. Also added the stat where it actually shows as a stat when using the advanced item search. Also changed the way items are sorted by default. Primary sorting is now the only sorting by default now since using secondary ordering on anything other than none screws up primary sorting which people think the sorting doesn't work when they don't understand the weight settings. Also removed the score column on searches as it is taking up room we can be using for showing all the new stats I'll be adding.
10-8-2017 - Added Endurance Regen to the advanced item search tool just like above for Mana Regen.
10-9-2017 - Added HP Regeneration, same as above. - Gidono
10-9-2017 - Sorting changes are causing issues so not pushing this code until I fix it. - Gidono
10-10-2017 - Fixed a bunch of persistent effects thanks to Barudin314 for looking all the correct spells up. This code is now live but will need the spell parser ran again to correct all the spells. - Gidono
10-10-2017 - Changed up SPA 478 "Move to Bottom of Hatelist (%)" and corrected the chance to actually be a percentage instead of a number. This code is now live.
10-10-2017 - Worked on adding Ring of Scale as the new expansion. I think I got all the code done and database tables I need to update. I'll be testing this out.
10-11-2017 - Fixed allakhazam item page to actually show all 32 SPA slots on spells.
10-11-2017 - Fixed Advanced item sorting issue I had earlier. Also added Spell Damage, Heal Amount, Attack to the list of stats you will see on advance item searches. You can sort by them as well.
10-11-2017 - Added Clairvoyance as well.
10-12-2017 - Added in missing item loregroups for allakhazam. Lucy already had these loregroups.
10-15-2017 - Added SPA 471, 475, 480, 481, 483, 486.
10-16-2017 - Figured out a fix for the Everquest class forums. They are currently showing broken links on the forum links at the top. The class forums will be moved to actual class forums under our current Everquest forum in their own forums. I'm going to wait on this until the forum issues are fixed however.
10-17-2017 - Changed SPA 450 from DoT Guard (numberhere) to Absorb Dot Damage (percent).
10-18-2017 - Changed up the spell parser script to use low priority when running.
10-21-2017 - Working on optimizing the whole spell parser process.
10-22-2017 - Going through all the spell columns in the spell databases and marking which columns aren't even needed as we only display certain information anyways. This will help performance for the spell system. During this process I am fixing unknown columns with their actual names if we are going to keep them.
10-22-2017 - Also setting columns to their correct integers such as tinyint, smallint and etc.. Corrected Unknown130 through Unknown190.
10-23-2017 - All Unknown columns corrected. Still working on setting all columns to their correct data types and then will need to build a shell script to make all the database table changes.
10-26-2017 - Added item type Familiar to Lucy and Allakhazam. Illusion item type is showing Unknown#69 on Lucy for some reason even though code was released to fix that.
10-26-2017 - Changed max level to 110 in spells and other areas.
10-26-2017 - Submitted code to fix all the unknowns on the Spell tables and fix all the data types for all of them as well. This will need to be done while the site is down so it might get done tonight with the forum fixes.
11-6-2017 - Code is live for max level change and item type fixes.
11-16-2017 - Pushed code to exclude level 101 Shaman spell Unity of Doomscale from showing all it's sub spells on a spell search for shaman's.
11-16-2017 - Changed max level on item display for Lucy to 110. This is where you can change the level and the item stats change.
11-19-2017 - Added new currency for RoS, Ancient Draconic Coin and Bathezid Trade Gem.
11-21-2017 - Corrected several persistent effects for Ring of Scale spells.
11-22-2017 - New SPA's (498-510) posted today by Prathun have been added to the Lucy spells file but commented out until I can work on the code for them.
12-31-2017 - Filtered out all the non song/scroll/tome spells from the spell search tool for Ring of Scale. Such as procs of other spells and such.
1-16-2018 - Fixed a few things on the spell page for allakhazam that weren't showing endurance costs correctly or showing timers for abilities and such. Also bolded the different effects to stand out from the values. Also took out the indention of info in the small info box on the right of the page to allow for more info without wrapping information. I also added a bunch of Seeds of Destruction spells that aren't scribeable to the spell filter for the spell search tool.
1-18-2018 - Fixed SPA 457 and 486 to display spell information correctly. Delaying this fix until I can work on SPA 457 some more.
1-19-2018 - Added missing item icons for RoS items. There might be some others missing, let me know if you find any. This isn't fixed yet, still working on it.
1-26-2018 - Added 3 features to the recipe system. Admin tools to set recipes by expansion, if it counts toward 350 skill and to set the daybreak recipe id. This will show on the recipe page as well if any of those items are set. Added those options to the recipe search tool as well. Also added more spells to the spell filter for the spell search tool.
2-3-2018 - Corrected SPA 331 to show Tradeskill Item Recovery instead of Alchemy Item Recovery. This will be updated on the next full EQ patch when we run a spell update.
2-7-2018 - Fixed some issues with the advanced recipe search not pulling up records.
2-21-2018 - Added a missing item type for perfected augment distiller.
3-3-2018 - Added Tiger Claw to the advanced item search tool under Damage Plus Type.
3-24-2018 - Added Hraquis Hunter to list of illusions for illusion type 261. This will be updated the next time we run the spell parser for the next patch.
4-13-2018 - Fixed spell parser from wiping out expansions when updating spells.
4-14-2018 - Added Skull of Null item loregroup.
4-14-2018 - Fixed spell search tool. It was not allowing name searches for effects that were greater than 12 slots.
4-14-2018 - Fixed some HTML elements on the spell search page such as spacing between cells and alignment of text. Also changed the expansion drop down box to capitalize expansions with any --Any-- option.
4-20-2018 - Fixed advanced recipe search tool not pulling up certain recipes. Also added more search options and added those options to the actual recipe page and the admin tool.
4-22-2018 - Changed the item page for allakhazam to show "Zone(s) Found In:" instead of "Foraged or Found In:" to clear up some confusion.
4-22-2018 - Fixed SPA 368 to show how much faction is adjusted. This requires the spell parser to be ran again to update.
4-30-2018 - Made some cosmetic changes to the advanced item search page so it's easier to look at. Also added in some input limitations that were missing.
4-30-2018 - Fixed advanced recipe search tool being limited to 4 digits, it will now allow up to 99999 to be entered.
5-3-2018 - Fixed Physical and Corruption resist spell info missing in the spell table and spell history on lucy. This requires database tables changes and the spell parser ran again so will be corrected on the next eq patch.
5-19-2018 - Category column for spells was removed from the spells file in the May 2018 patch. I have fixed this in code and the spell database tables as well. We'll be running the spell update again sometime early next week.
5-20-2018 - Fixed item types from showing Unknown on the advanced item search type drop down. This should also fix lucy from showing Unknown item types for those items as well.
5-23-2018 - Fixed SPA 148 and identified some other issues regarding calcs. Identified many more calcs we never had added.
5-23-2018 - Fixed spell search tool not allowing certain characters. Changed regex pattern on input to allow 3 to 75 characters.
5-23-2018 - Fixed spell.html on allakhazam and lucy from not showing spells that can be dispellable. Also added Blockable, Focusable and Reflectable info to spells.
5-23-2018 - Added targettypes, 48 (Caster Next on Hatelist), 39 (No Pets), 35 (Special Muramites) and 21 (Undead) to spells.
5-24-2018 - Fixed lucy not showing Endurance Cost on the spell page for tomes.
6-2-2018 - Fixed spell info from showing wrong values for Blockable, Reflectable, Focusable, and Dispellable.
6-5-2018 - Fixed SPA 457 to show correctly as life tap percentages. Adjusted Blockable on spell info for spells that aren't necessarily labeled as having a class attached to it, but still only displays if the spelltype is Beneficial or Beneficial, Group Only. The SPA update will be fixed when we run the spell parser again with the next eq patch.
8-13-18 - Added Support link at the top of the site for logged in users.
8-13-18 - Corrected premium sign up link at the bottom of the lucy site for non premium logged in users.
8-18-18 - Added a limit of 100 records for a name search only on the spell search tool. Also added in a limit to pick a class when searching by expansion only.
8-21-18 - Added an expansion section on the infobox that is attached on the spell.html page for spells.
8-25-18 - Added an expansion section on the recipe info on the item page if the item has a recipe for it and if an expansion is set for that recipe.
8-27-18 - Fixed augmentations not showing the distiller they require in order to remove them since items are now storing the numerical value of the solvent instead of the itemid in that particular field. Certain augments might need to be ran through the item collector if they still don't show their distiller as they haven't been updated yet.
8-28-18 - The same issue above was fixed for lucy augments.
9-6-18 - Released some database table changes for the recipe search that fixes some search issues.
9-9-18 - Added color to heroic stats when viewing items with stats via the advanced item search.
9-9-18 - Added expendable and artifact to the search options for the advanced item search.
9-9-18 - Fixed searching for Legends server only items via advanced item search.
9-20-18 - Fixed SPA 457 to parse for all 7 different variations.
10-15-18 - Fixed issue with MS Edge freezing on the advanced item search page by clicking on some of the input boxes. This is a bug with MS Edge and its saved form entries feature.
10-15-18 - Made several changes to the allakhazam item page. Converted old HTML to HTML5 and added some inline CSS. Also added in titles to information under the item stats, to show more information if you mouse over the bolded text to most entries.
10-17-18 - Fixed augdistill value -1 to point to Perfected Augmentation Distiller on the item pages for alla and lucy.
10-18-18 - Fixed augments to show their correct augment solvents regardless if their augdistill value is the old item id or the new solvent tier value.
10-21-18 - Fixed SPA 64 for all spells that use it.
10-24-18 - Added the ability for admins to set expansions on NPC's and for expansions to show on the NPC pages if one is set.
10-24-18 - Changed the way adventure items are sold on NPC's by putting it in a table on the NPC page. Same with spells.
10-24-18 - Added an expansion column to the recipe search tool and added a edit link for admins.
10-24-18 - Added The Burning Lands to code and item db table.
10-24-18 - Fixed a bunch of missing code in the character tools such as missing expansions and updated the db table for the character tool as well.
10-29-18 - Added a expansion column to the NPC listing on zone pages, we'll get NPC's set to their expansions over time.
10-29-18 - Added in admin NPC edit page the timestamps of when a NPC was added and when it was last updated. The same thing has been added to NPC pages for all to view.
10-29-18 - Worked on CSS changes for the different tabs on the zone page. Tables will auto size to the information instead of spreading all the way across. Background texture image was removed from those tabs to make it easier to read the text.
10-30-18 - Fixed bug in the advanced item search script not showing intelligence and heroic intelligence stats on items. Also shortened up some stat names, put the stats right up against the stat names, changed the color of the stats in order to better distinguish between stats and shorted up how much space the stats are taking up. Also attached descriptions to the stats if you mouse over them.