LDON Leaderboard, Barter, Leadership AA, Corpse Detail, enhancements, performance, bugfixes, code cleanup

ENHANCEMENTS:

update the JS color selector

Modified the Actions Menu (left hand menu) to be resizeable and have a header.

Added a Leadership AA window. Accessed with the "Leader." button on the Action menu. This shows a characters Guild and Raid Abilities.

Added two versions of the Barter Window, one generic, and one personalized one. The generic one is accessed with the "Barter" link in the header. The personalized one is accessed with the "Barter" button in the Actions menu. The generic one just shows all the WTB items and their price, with some basic search criteria. The personalized one displays the current characters inventory (like in game) and uses their inventory as a filter for matching buyers. Searching with a "Seller" name also cross referenecs a characters inventory.

Added two versions of the LDON/Adventure Leaderboard. The generic one is accessed with the "LDON" link in the header, and the personalized on is viewed with the "LDON" button in the Actions menu. Both versions show 100 characters max (by default). When viewing the personalied one, your current characters row will show up below the scroll box, in gold, displaying that characters rank. The gold row will also show up in its correct order in the scroll box results.

Redesigned/beautified the corpses page. The corpses now display as avatar tiles, showing the date and zone of death. The avatar will show as gold and in-color if the corpse NEEDS to be rezzed, and gray if already rezzed. The avatar will be replaced by the Shadowhaven tombstoneif the character has been buried. If there are items or coin on the corpse a small bag icon will display by the avatar. Hovering over the avatar or bag icon will explain the meaning of the symbols.

Added a detail corpse view. You access it by clicking one of the avatar tiles on the corpses page. This new detail view shows the corpses inventory, specific details about where/when they died (unless moved), rezzed status, burried status, all items and coin on thecorpse, and links to the zone and a map of where the corpse is.

Enhanced the Bazaar. The window is resizeable and scrollable now. The items now display a small item icon next to the name.

Added the "&nohead" GET variable. When appended to the URL it hides the header completely, this is intended to be used by server admins with the in-game web browser.

PERFORMANCE:

The item icons have been replaced with sheets of spritesthat are 10x10, and some CSS to locate each item icon byits ID. This loads slightly slower at first for the user, but in the longrun it caches quicker and improves performance. It also greatly reduces the time taken to unzip/transfer the charbrowser files since the 6,869 individual icon files are replaced with 108 icon sheets.

Reduced the number of queries on the bot page. Took all the individual spell effect queries and consolidated them to one big "IN" clause.

The item and spell repository classes design still caused some redundant queries. Those were redesigned causing someperformance improvements. The bazaar page now only runs 3 queries instead of 2 plus 1 per spell effect on each item. The changes were implemented into the profile class, bot profile class, and the new corpse profile class. This further reduced the number of queries resulting in the character profile page loading about 20% faster.

Removed the alternate ability repository. During the multi-tenancy change over the repository was quikckly added to reduce the number of queries being done, but itreplicated the table caching feature already present in the profile class. It now uses that original system instead.

Did a general file cleanup of files that no longer seemed necessary.

Added a page-load timer to help monitor performance. It's displayed above the database performance data, and is enabled using the same DB_PERFORMANCE constant that the database performance output uses.

Removed too many notices/warnings to count

Moved the character permission into the profile class

gave classes a Charbrowser_ prefix for their name

gave all private elements a _ prefix

make sure array and array keys exist prior to referencing them

removed direct access to $_GET, $_POST and $_REQUEST and use a wrapper function preg_Get_Post() instead which is written to ensure array keys exist and to also use regex to validate all user input values

Tested/Updated the software to work on PHP 5.6 up to PHP 7.4

BUGFIX:

Fixed a bug that would display the header twice in some error cases.

Fixed an oversight that let users see the advanced faction data, even when it was disabled.

Altered the adventure board to use RANK() for newer versions of MySQL and variables for older versions

When theres no bazaar search results, we now show an empty bazaar window instead of a message box

repaired the leaderboard rankings. The query returned different results based on DB vendor/version. it now uses two different methods based on vender/version.

Bazaar Repair & Enhancement, Performance Upgrades

Added data preloading to improve load on the database delay jquery drag/resize to improve page load speed (Akkadius)
Added a new set of join, filter, sort functions to help integrate datasets across the multi-tenancy margin. Updated most pages to use these new functions.
Audited each page to remove redundant or unnecessary queries; improved loading for search, corpse, keys and bots.
Fixed the bazaar sorting, filtering and pagination, redesigned the querying to reduce db load
Added the ability to see and sort by a state in the bazaar (like you can in game)
Fixed an error in the join function that would overwrite rows if they joined on the same column value, mostly effected the bazaar by hiding peoples auctions if they were selling the same item as someone else.

Window display and graphics improvements, avatars, bots, multi-tenancy

Capped bagslots to 10
Made Bag Windows resizeable
Item Stat Windows resizeable
Cleaned up Settings Window appearance
Improved button graphics to include hover images
Improved corner graphics for standard windows
Added new window graphics for bank/inventory
Added Avatars of every character face graphic (old models)
Added the ability to add custom templates that wont get overwritten and which you can swap back and forth between styles (template directories) using the config file.
Improved window displays with hover transparency and drop shadow
First pass of displaying bots, some stats may be innacurate will be fixed in a future patch
First pass of implementing multi-tenancy. If you use it the bazaar wont work; fixed in a future patch.

New Front End and Views

Rewrote the HTML/CSS to make customzation easier, add popup windows that are dragable. Added a new guild and server view that shows character statistics. Modernized and displayed the stat calculations. Added a nwe self registration feature (defaulted to disabled) which lets you list your site in a public server registry at charbrowser.net

Popups & Shared Bank

Added the optional display of shared bank items and plat, and improved popups for items.

For testing automated update notofication

This release is only for testing github integration in charbrowser