Fixes for the EQ1 site and future fixesFollow

There are some changes in the pipeline that will be coming in the future.

I've been working hard on fixing certain things on the site. I was working on the posting issue where we are double/triple posting. That is caused by some very large tables in the Everquest database for the forums. These forum tables where several gigs in size so some pruning had to happen and then partitioned the tables like a hard drive. All those changes were tested on my machine and have been sent off to ZAM. However ZAM is waiting until they move the allakhazam platform to a upgraded data center. This should happen within this quarter I've been told. So once the site is established there, ZAM should get to work on what I sent them to correct the posting issues.

Here are some of the things I have changed so far, mainly just fluff changes as I have been working on the database stuff.

- The character edit tool now has the current list of servers.
- The recipe search tool now alpha sorts classes.
- Changed Orum currency to Orux.
- Changed the description for items where it shows what zone the item is found in. That description also sometimes is for foraged items only and it can be confusing if the item is dropped and foraged in the same zone as well. So now it will say "Foraged in or Found in:"
- Fixed item type for Illusions (Unknown #69) on allakhazam site.
- Added a bunch more NPC types.
- Added player spells to the list of spells NPC's can use, admins will have to add those spells in per NPC.
- Fixed LoN items from showing "LoN: This item is is a reward from Legends of Norrath." Now it will be "LoN: This item is a reward from Legends of Norrath."
- Changed how the expansion tag for Legends server items display. Instead of the old "Required: Yes", it is now "Server Only Item" to show it is a server only item.
- Changed the max amount of posts on any forum (actual forums, items, quests, zones, etc..) to 25 per page. This will help non forum pages load up quicker that have a ton of posts.

Also some other stuff has been worked on back behind the scenes.

Right now, I am working on all the spell issues with missing SPA slots and spells showing unknown for info. I have all the SPA slots added on my dev environment and am currently working on fixing unknowns and then add the rest of the missing SPA's we never added through the past few expansions. I need to test each change to make sure everything works like it's supposed to but hopefully I'll be rolling those changes out soonish.

Anyways, just thought I'd let everyone know the site isn't dead, we're still here and working on it!

Edited, Sep 20th 2017 7:15pm by Gidono