Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static String[] getHome(String player,String world) {
- String query = ("SELECT `x`,`y`,`z`,`yaw`,`pitch` FROM `enHome` WHERE player='" + player + "' AND world='" + world + "' LIMIT 1");
- int i = 0;
- String[] getHome = null;
- try {
- if (connection.isClosed()) {
- connect();
- }
- ResultSet rs = statement.executeQuery(query);
- while (rs.next()) {
- i++;
- getHome[0] = rs.getString(1);
- getHome[1] = rs.getString(2);
- getHome[2] = rs.getString(3);
- getHome[3] = rs.getString(4);
- getHome[4] = rs.getString(5);
- if (i == 4) return getHome;
- }
- } catch (SQLException e) {
- log.warning("[MySQL] getHome problems!");
- log.warning(e.getMessage());
- return null;
- }
- return null;
- }
Add Comment
Please, Sign In to add comment