Thread: V4 Updates with MaNGOS Web by meowmix2

Original credits of this CMS to wilson and
Credits to meowmix2 for continuing the project !

Originally Posted by meowmix2

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.

Latest branch (master) with all fixes:

GitHub - paintballrefjosh/MaNGOSWebV4: This is a continuation of the MaNGOSWebV3 project.

Live demo with real servers running:

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 to meowmix2 for continuing the project !

---

› See More: V4 Updates with MaNGOS Web by meowmix2

I'll be checking this out. Thanks for sharing, Wise! And credits to wilson and meowmix2 as well.