Constant Field Values

Contents

fr.Alphart.*

  • fr.Alphart.BAT.database.SQLQueries.Ban
    Modifier and Type
    Constant Field
    Value
    public static final String
    createBan
    "INSERT INTO `BAT_ban`(UUID, ban_staff, ban_server, ban_end, ban_reason) VALUES (?, ?, ?, ?, ?);"
    public static final String
    createBanIP
    "INSERT INTO `BAT_ban`(ban_ip, ban_staff, ban_server, ban_end, ban_reason) VALUES (?, ?, ?, ?, ?);"
    public static final String
    createTable
    "CREATE TABLE IF NOT EXISTS `BAT_ban` (`ban_id` INTEGER PRIMARY KEY AUTO_INCREMENT,`UUID` varchar(100) NULL,`ban_ip` varchar(50) NULL,`ban_staff` varchar(30) NOT NULL,`ban_reason` varchar(100) NULL,`ban_server` varchar(30) NOT NULL,`ban_begin` timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,`ban_end` timestamp NULL,`ban_state` bool NOT NULL default 1,`ban_unbandate` timestamp NULL,`ban_unbanstaff` varchar(30) NULL,`ban_unbanreason` varchar(100) NULL,INDEX(UUID),INDEX(ban_ip)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"
    public static final String
    getBan
    "SELECT * FROM `BAT_ban` WHERE UUID = ? ORDER BY ban_state DESC, ban_end DESC;"
    public static final String
    getBanIP
    "SELECT * FROM `BAT_ban` WHERE ban_ip = ? AND UUID IS NULL ORDER BY ban_state DESC, ban_end DESC;"
    public static final String
    getBanMessage
    "SELECT ban_reason, ban_end, ban_staff, ban_begin FROM `BAT_ban` WHERE (UUID = ? OR ban_ip = ?) AND ban_state = 1 AND ban_server = ?;"
    public static final String
    getManagedBan
    "SELECT * FROM `BAT_ban` WHERE ban_staff = ? OR ban_unbanstaff = ? ORDER BY ban_state DESC, ban_end DESC;"
    public static final String
    isBan
    "SELECT ban_id FROM `BAT_ban` WHERE ban_state = 1 AND UUID = ?;"
    public static final String
    isBanIP
    "SELECT ban_id FROM `BAT_ban` WHERE ban_state = 1 AND ban_ip = ? AND UUID IS NULL;"
    public static final String
    isBanServer
    "SELECT ban_id FROM `BAT_ban` WHERE ban_state = 1 AND UUID = ? AND ban_server = ?;"
    public static final String
    isBanServerIP
    "SELECT ban_id FROM `BAT_ban` WHERE ban_state = 1 AND ban_ip = ? AND ban_server = ? AND UUID IS NULL;"
    public static final String
    table
    "BAT_ban"
    public static final String
    unBan
    "UPDATE `BAT_ban` SET ban_state = 0, ban_unbanreason = ?, ban_unbanstaff = ?, ban_unbandate = NOW() WHERE UUID = ? AND ban_state = 1;"
    public static final String
    unBanIP
    "UPDATE `BAT_ban` SET ban_state = 0, ban_unbanreason = ?, ban_unbanstaff = ?, ban_unbandate = NOW() WHERE ban_ip = ? AND UUID IS NULL;"
    public static final String
    unBanIPServer
    "UPDATE `BAT_ban` SET ban_state = 0, ban_unbanreason = ?, ban_unbanstaff = ?, ban_unbandate = NOW() WHERE ban_ip = ? AND ban_server = ? AND UUID IS NULL;"
    public static final String
    unBanServer
    "UPDATE `BAT_ban` SET ban_state = 0, ban_unbanreason = ?, ban_unbanstaff = ?, ban_unbandate = NOW() WHERE UUID = ? AND ban_server = ? AND ban_state = 1;"
    public static final String
    updateExpiredBan
    "UPDATE `BAT_ban` SET ban_state = 0 WHERE ban_state = 1 AND (ban_end != 0 AND ban_end < NOW());"
  • fr.Alphart.BAT.database.SQLQueries.Comments
    Modifier and Type
    Constant Field
    Value
    public static final String
    clearByID
    "DELETE FROM `bat_comments` WHERE entity = ? AND id = ?;"
    public static final String
    clearEntries
    "DELETE FROM `bat_comments` WHERE entity = ?;"
    public static final String
    createTable
    "CREATE TABLE IF NOT EXISTS `bat_comments` (`id` int(11) NOT NULL AUTO_INCREMENT,`entity` varchar(100) NOT NULL,`note` varchar(255) NOT NULL,`type` varchar(7) NOT NULL,`staff` varchar(30) NOT NULL,`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`id`),INDEX(entity)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"
    public static final String
    getEntries
    "SELECT id, note, type, staff, date FROM `bat_comments` WHERE entity = ? ORDER BY date DESC;"
    public static final String
    getManagedEntries
    "SELECT id, note, type, date, entity FROM `bat_comments` WHERE staff = ? ORDER BY date DESC;"
    public static final String
    getMostRecentCommentDate
    "SELECT date FROM `bat_comments` WHERE entity = ? ORDER BY date DESC"
    public static final String
    insertEntry
    "INSERT INTO `bat_comments` (entity, note, type, staff)VALUES (?, ?, ?, ?);"
    public static final String
    patternTriggerCheck
    "SELECT COUNT(*) FROM `bat_comments` WHERE entity = ? && note LIKE ?;"
    public static final String
    simpleTriggerCheck
    "SELECT COUNT(*) FROM `bat_comments` WHERE entity = ?;"
    public static final String
    table
    "bat_comments"
  • fr.Alphart.BAT.database.SQLQueries.Core
    Modifier and Type
    Constant Field
    Value
    public static final String
    createTable
    "CREATE TABLE IF NOT EXISTS `BAT_players` (`BAT_player` varchar(30) UNIQUE NOT NULL,`UUID` varchar(100) UNIQUE NOT NULL,`lastip` varchar(50) NOT NULL,`firstlogin` timestamp NULL,`lastlogin` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
    public static final String
    getIP
    "SELECT lastip FROM `BAT_players` WHERE UUID = ?;"
    public static final String
    getIpUsers
    "SELECT BAT_player FROM `BAT_players` WHERE lastip = ?"
    public static final String
    getPlayerData
    "SELECT lastip, firstlogin, lastlogin FROM `BAT_players` WHERE UUID = ?;"
    public static final String
    getPlayerName
    "SELECT BAT_player FROM `BAT_players` WHERE UUID = ?;"
    public static final String
    getUUID
    "SELECT UUID FROM `BAT_players` WHERE BAT_player = ?;"
    public static final String
    table
    "BAT_players"
    public static final String
    updateIPUUID
    "INSERT INTO `BAT_players` (BAT_player, lastip, firstlogin, UUID) VALUES (?, ?, NOW(), ?) ON DUPLICATE KEY UPDATE lastip = ?, lastlogin = NOW(), BAT_player = ?;"
  • fr.Alphart.BAT.database.SQLQueries.Kick
    Modifier and Type
    Constant Field
    Value
    public static final String
    createTable
    "CREATE TABLE IF NOT EXISTS `BAT_kick` (`kick_id` INTEGER PRIMARY KEY AUTO_INCREMENT,`UUID` varchar(100) NOT NULL,`kick_staff` varchar(30) NOT NULL,`kick_reason` varchar(100) NULL, `kick_server` varchar(30) NOT NULL,`kick_date` timestamp NOT NULL,INDEX(UUID)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
    public static final String
    getKick
    "SELECT kick_server, kick_reason, kick_staff, kick_date FROM `BAT_kick` WHERE UUID = ? ORDER BY kick_date DESC;"
    public static final String
    getManagedKick
    "SELECT kick_server, kick_reason, UUID, kick_date FROM `BAT_kick` WHERE kick_staff = ? ORDER BY kick_date DESC;"
    public static final String
    kickPlayer
    "INSERT INTO `BAT_kick`(UUID, kick_staff, kick_reason, kick_server, kick_date) VALUES (?, ?, ?, ?, NOW());"
    public static final String
    table
    "BAT_kick"
  • fr.Alphart.BAT.database.SQLQueries.Mute
    Modifier and Type
    Constant Field
    Value
    public static final String
    createMute
    "INSERT INTO `BAT_mute`(UUID, mute_staff, mute_server, mute_end, mute_reason) VALUES (?, ?, ?, ?, ?);"
    public static final String
    createMuteIP
    "INSERT INTO `BAT_mute`(mute_ip, mute_staff, mute_server, mute_end, mute_reason) VALUES (?, ?, ?, ?, ?);"
    public static final String
    createTable
    "CREATE TABLE IF NOT EXISTS `BAT_mute` (`mute_id` INTEGER PRIMARY KEY AUTO_INCREMENT,`UUID` varchar(100) NULL,`mute_ip` varchar(50) NULL,`mute_staff` varchar(30) NOT NULL,`mute_reason` varchar(100) NULL,`mute_server` varchar(30) NOT NULL,`mute_begin` timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,`mute_end` timestamp NULL,`mute_state` bool NOT NULL default 1,`mute_unmutedate` timestamp NULL,`mute_unmutestaff` varchar(30) NULL,`mute_unmutereason` varchar(100) NULL,INDEX(UUID),INDEX(mute_ip)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"
    public static final String
    getManagedMute
    "SELECT * FROM `BAT_mute` WHERE mute_staff = ? OR mute_unmutestaff = ? ORDER BY mute_state DESC, mute_end DESC;"
    public static final String
    getMute
    "SELECT * FROM `BAT_mute` WHERE UUID = ? ORDER BY mute_state DESC, mute_end DESC;"
    public static final String
    getMuteIP
    "SELECT * FROM `BAT_mute` WHERE mute_ip = ? AND UUID IS NULL ORDER BY mute_state DESC, mute_end DESC;"
    public static final String
    getMuteMessage
    "SELECT mute_reason, mute_end, mute_staff, mute_begin FROM `BAT_mute` WHERE (UUID = ? OR mute_ip = ?) AND mute_state = 1 AND mute_server = ?;"
    public static final String
    isMute
    "SELECT mute_id FROM `BAT_mute` WHERE mute_state = 1 AND UUID = ?;"
    public static final String
    isMuteIP
    "SELECT mute_id FROM `BAT_mute` WHERE mute_state = 1 AND mute_ip = ? AND UUID IS NULL;"
    public static final String
    isMuteServer
    "SELECT mute_id FROM `BAT_mute` WHERE mute_state = 1 AND UUID = ? AND mute_server = ?;"
    public static final String
    isMuteServerIP
    "SELECT mute_id FROM `BAT_mute` WHERE mute_state = 1 AND mute_ip = ? AND mute_server = ? AND UUID IS NULL;"
    public static final String
    table
    "BAT_mute"
    public static final String
    unMute
    "UPDATE `BAT_mute` SET mute_state = 0, mute_unmutereason = ?, mute_unmutestaff = ?, mute_unmutedate = NOW() WHERE UUID = ? AND mute_state = 1;"
    public static final String
    unMuteIP
    "UPDATE `BAT_mute` SET mute_state = 0, mute_unmutereason = ?, mute_unmutestaff = ?, mute_unmutedate = NOW() WHERE mute_ip = ? AND UUID IS NULL;"
    public static final String
    unMuteIPServer
    "UPDATE `BAT_mute` SET mute_state = 0, mute_unmutereason = ?, mute_unmutestaff = ?, mute_unmutedate = NOW() WHERE mute_ip = ? AND mute_server = ? AND UUID IS NULL;"
    public static final String
    unMuteServer
    "UPDATE `BAT_mute` SET mute_state = 0, mute_unmutereason = ?, mute_unmutestaff = ?, mute_unmutedate = NOW() WHERE UUID = ? AND mute_server = ? AND mute_state = 1;"
    public static final String
    updateExpiredMute
    "UPDATE `BAT_mute` SET mute_state = 0 WHERE mute_state = 1 AND (mute_end != 0 AND mute_end < NOW());"