Constant Field Values

Contents

dev.plex.*

  • dev.plex.storage.player.SQLPlayerData
    Modifier and Type
    Constant Field
    Value
    private final String
    INSERT
    "INSERT INTO `players` (`uuid`, `name`, `login_msg`, `prefix`, `ips`, `coins`, `vanished`, `commandspy`) VALUES (?, ?, ?, ?, ?, ?, ?, ?);"
    private final String
    SELECT
    "SELECT * FROM `players` WHERE uuid=?"
    private final String
    UPDATE
    "UPDATE `players` SET name=?, login_msg=?, prefix=?, ips=?, coins=?, vanished=?, commandspy=? WHERE uuid=?"
  • dev.plex.storage.punishment.SQLNotes
    Modifier and Type
    Constant Field
    Value
    private static final String
    DELETE
    "DELETE FROM `notes` WHERE uuid=? AND id=?"
    private static final String
    INSERT
    "INSERT INTO `notes` (`id`, `uuid`, `written_by`, `note`, `timestamp`) VALUES(?, ?, ?, ?, ?)"
    private static final String
    SELECT
    "SELECT * FROM `notes` WHERE uuid=?"
  • dev.plex.storage.punishment.SQLPunishment
    Modifier and Type
    Constant Field
    Value
    private static final String
    INSERT
    "INSERT INTO `punishments` (`punished`, `punisher`, `punishedUsername`, `ip`, `type`, `reason`, `customTime`, `active`, `endDate`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)"
    private static final String
    SELECT
    "SELECT * FROM `punishments` WHERE punished=?"
    private static final String
    SELECT_BY
    "SELECT * FROM `punishments` WHERE punisher=?"
    private static final String
    SELECT_BY_IP
    "SELECT * FROM `punishments` WHERE ip=?"
    private static final String
    UPDATE_PUNISHMENT
    "UPDATE `punishments` SET active=? WHERE punished=? AND type=?"