Wise
23-03-17, 10:17 AM
Hey all! I've been doing a good bit of work on this project. Bringing things up to date, fixing lots of issues, adding some new features that were missing.
Credits wilson for the base and meowmix2 for the updates
Latest branch (master) with all fixes: https://github.com/paintballrefjosh/MaNGOSWebV4
Live demo with real servers running: Mistvale Terms of Service (http://www.mistvale.com)
Roadmap of features and fixes to be completed: https://github.com/paintballrefjosh/...4/wiki/Roadmap
Check out the list of recent changes:
Version 4.0.8
Fixed XSS exploit issue in install script
Added Mists of Pandaria template
Added Burning Crusade template
Fixed a few broken images
Version 4.0.6
Realm Players Online
From the frontpage you can click on the number of users online for any given realm. This should take you to the usersonline page and show the respectful realm. The function to check, or set the current realm based on the link was missing so this was added.
General
Identified several broken class references between Config & Core. This update fixes that and cleans up the variables and functions.
SQL installation file
Added Server Statistics page link
Reordered entries for fp_links
Removed hard set item ID from insert statements, used NULL instead so DB will auto_increment
Server Statistics
Removed unused lines of code
Cleaned up top menu breadcrumb links
Players Online
Cleaned up top menu breadcrumb links
Admin In Game Email & Character Tools
Cleaned up the way the realm names were listed
Version 4.0.5
Installation Script
Converted old style commands to new mysqli. Added appropriate links and variables to support new structure.Removed old DB scripts.
Database Cleanup
Removed server info pages since backend functions did not exist.
Added a 4.X to 4.0.5 migration SQL script.
Modified full_install.sql to reflect the DB optimizations.
Fixed server -> statistics page to properly pull and show images and character stats.
Screen Shot of the Day
SSOTD random screenshot on the home page did not show an image due to some outdated or incorrect code. Fixed null issues and changed date to use unix timestamp.
DB Optimization & Account Creation Bug Fix
Optimized DB install .sql file adding unsigned to most ID's and other INT columns.
Also modified inc\account\account.login.php to check mw_account_extend to make sure account exists in this table at time of login. If you create an account in the game's console they weren't replicated to this table which caused login issues.
Version 4.0.4
RSS function was broken. Cleaned it up to get it passing RSS validation.
Fixed Top Kills page - background was solid black for some reason. Updated it to be more clean using the standard table design and background.
Moved main content down to prevent login button from being covered up.
Version 4.0.3
Added ability to send in game mail to characters.
Fixed bug in remote access send() function.
Moved Tiny MCE initalization to email page so it is not available for in game mail (plain text only allowed).
Version 4.0.2
Admin Pages
Ban account for period of time.
Add ban IP option.
Account list page -> clean up active (aka suspend) / banned status.
Created Ban List page showing all current account and IP bans in the database.
Credits wilson for the base and meowmix2 for the updates
Latest branch (master) with all fixes: https://github.com/paintballrefjosh/MaNGOSWebV4
Live demo with real servers running: Mistvale Terms of Service (http://www.mistvale.com)
Roadmap of features and fixes to be completed: https://github.com/paintballrefjosh/...4/wiki/Roadmap
Check out the list of recent changes:
Version 4.0.8
Fixed XSS exploit issue in install script
Added Mists of Pandaria template
Added Burning Crusade template
Fixed a few broken images
Version 4.0.6
Realm Players Online
From the frontpage you can click on the number of users online for any given realm. This should take you to the usersonline page and show the respectful realm. The function to check, or set the current realm based on the link was missing so this was added.
General
Identified several broken class references between Config & Core. This update fixes that and cleans up the variables and functions.
SQL installation file
Added Server Statistics page link
Reordered entries for fp_links
Removed hard set item ID from insert statements, used NULL instead so DB will auto_increment
Server Statistics
Removed unused lines of code
Cleaned up top menu breadcrumb links
Players Online
Cleaned up top menu breadcrumb links
Admin In Game Email & Character Tools
Cleaned up the way the realm names were listed
Version 4.0.5
Installation Script
Converted old style commands to new mysqli. Added appropriate links and variables to support new structure.Removed old DB scripts.
Database Cleanup
Removed server info pages since backend functions did not exist.
Added a 4.X to 4.0.5 migration SQL script.
Modified full_install.sql to reflect the DB optimizations.
Fixed server -> statistics page to properly pull and show images and character stats.
Screen Shot of the Day
SSOTD random screenshot on the home page did not show an image due to some outdated or incorrect code. Fixed null issues and changed date to use unix timestamp.
DB Optimization & Account Creation Bug Fix
Optimized DB install .sql file adding unsigned to most ID's and other INT columns.
Also modified inc\account\account.login.php to check mw_account_extend to make sure account exists in this table at time of login. If you create an account in the game's console they weren't replicated to this table which caused login issues.
Version 4.0.4
RSS function was broken. Cleaned it up to get it passing RSS validation.
Fixed Top Kills page - background was solid black for some reason. Updated it to be more clean using the standard table design and background.
Moved main content down to prevent login button from being covered up.
Version 4.0.3
Added ability to send in game mail to characters.
Fixed bug in remote access send() function.
Moved Tiny MCE initalization to email page so it is not available for in game mail (plain text only allowed).
Version 4.0.2
Admin Pages
Ban account for period of time.
Add ban IP option.
Account list page -> clean up active (aka suspend) / banned status.
Created Ban List page showing all current account and IP bans in the database.