Version 4.1.2 - Bug fixes: updater, news, server info, remote-access, trinityore commands

Fixed database updater bug

• Issue found when looking for remote SQL or PHP files. Also added some debug information for troubleshooting.

Fixed string escape issue in admin -> news

• No string escape function was used on the message and subject for news entries so adding a single or double quote would break the query.

Fixed more info link on frontpage under server info

• URL was pointing to a nonexistent page when clicking the more info link on the home page. Links now properly redirect to correct server statistics page.

Disabled remote-include for DB updater script

• Default settings do not allow include to point to remote (http / https) files. Disabled this feature to prevent errors.
• Remote SQL udpates do not appear to work properly, temporarily disabling.

Fixed database count() function

• The count, otherwise known as num_rows, was implemented incorrectly. Fixed the issue to return proper counts.

Fixed password display for realm remote-access

• Remote-access password was shown in cleartext, changed it to be a password field.

Fixed issue with TrinityCore server commands page

• Commands were not displayed properly. Updated the logic to pull the allowed commands based on user's current gmlevel.

Fixed issue with locked accounts

• When requiring account activation is true the user must follow the provided link in email to help prevent bots from creating many accounts. If an admin were to set a users account to activated, or "unlocked", the user still wasn't able to login due to bug in the logic.

Fixed remote-access issues

• Remote access was left out of SQL queries for adding / updateing realms.
• Rewrote the RA socket class to be more user friendly and work with the new database structure.