public static void setOfflineFamilyStatus(int familyid, int seniorid, int junior1, int junior2, int currentrep, int totalrep, int cid) {
        try {
            java.sql.Connection con = DatabaseConnection.getConnection();
            try (java.sql.PreparedStatement ps = con.prepareStatement("UPDATE characters SET familyid = ?, seniorid = ?, junior1 = ?, junior2 = ?, currentrep = ?, totalrep = ? WHERE id = ?")) {
                ps.setInt(1, familyid);
                ps.setInt(2, seniorid);
                ps.setInt(3, junior1);
                ps.setInt(4, junior2);
                ps.setInt(5, currentrep);
                ps.setInt(6, totalrep);
                ps.setInt(7, cid);
                ps.execute();
            }
        } catch (SQLException se) {
            System.out.println("SQLException: " + se.getLocalizedMessage());
        }
    }