(ingame)
+ Console as sender for command query
+ MySQl table datatype bugfix (Reason => LONGTEXT) [4 tables changed]
+ Logging unban and unmute in player history
(webpanel)
+ Small webpanel navigation
+ Chatlog ids based on current time millis
+ Optimized "other reports" page (reported by, chatlog-id)
+ List of banned players
+ List of muted players
+ Unban and unmute player at check if player is banned or muted
Code (Text):
CREATE TABLE IF NOT EXISTS AB_PlayerHistory (PlayerUUID VARCHAR(100),PlayerName VARCHAR(100),FromUUID VARCHAR(100),DateAndTime VARCHAR(100),Type VARCHAR(100),Reason LONGTEXT,End VARCHAR(100))
CREATE TABLE IF NOT EXISTS AB_Bans (PlayerUUID VARCHAR(100),PlayerIP VARCHAR(100),FromUUID VARCHAR(100),Reason LONGTEXT,End VARCHAR(100))
CREATE TABLE IF NOT EXISTS AB_Mutes (PlayerUUID VARCHAR(100),FromUUID VARCHAR(100),Reason LONGTEXT,End VARCHAR(100))
CREATE TABLE IF NOT EXISTS AB_Reports (PlayerUUID VARCHAR(100),FromUUID VARCHAR(100),DateAndTime VARCHAR(100),CurrentMillis VARCHAR(100),Server VARCHAR(100),Reason LONGTEXT)