package org.c4k3.PvPTeleport;

import java.sql.ResultSet;
import java.util.UUID;

import org.bukkit.Location;
import org.bukkit.entity.Player;

import lib.PatPeter.SQLibrary.SQLite;

public class SQL {

	private static SQLite sqlite;

	/** Opens the SQL connection */
	public static void sqlConnection() {

		sqlite = new SQLite(PvPTeleport.instance.getLogger(),
				"PvPWorld", // Database name
				"playerlocs", // Database filename
				PvPTeleport.instance.getDataFolder().getAbsolutePath());
		try {
			sqlite.open();

			/* Checks if the playerlocs table already exists, if it does not, create it */
			if ( sqlite.checkTable("playerlocs")) {
				return;
			} else {
				sqlite.query("CREATE TABLE playerlocs (id INT PRIMARY KEY, uuid BLOB, x DOUBLE, y DOUBLE, z DOUBLE);");
			}

		} catch (Exception e) {
			PvPTeleport.instance.getLogger().info(e.getMessage());
		}
	}

	/** Inserts the player's data into the database */
	public static void putPlayer(Player player) {

		Location pLoc = player.getLocation();
		int x = pLoc.getBlockX();
		int y = pLoc.getBlockY();
		int z = pLoc.getBlockZ();
		UUID uuid = player.getUniqueId();

		/* This is easier... */
		sqlite.query("DELETE FROM playerlocs WHERE uuid='" + uuid + "'");
		sqlite.query("INSERT INTO playerlocs(uuid, x, y, z) VALUES ('" + uuid + "', '" + x + "', '" + y + "', '" + z + "')");
	}

	/** Retrieves the player's location from the playerlocs table, and turns it into a Bukkit.Location
	 * Returns null if it was unable to properly retrieve the location
	 */
	public static Location getPlayer(UUID uuid) {

		ResultSet rs = null;

		try {
			rs = sqlite.query("SELECT * FROM playerlocs WHERE uuid = '" + uuid + "'");
			while (rs.next()) {

				double x = rs.getDouble("x") + 0.5;
				double y = rs.getDouble("y");
				double z = rs.getDouble("z") + 0.5;
				Location loc = new Location(PvPTeleport.instance.getServer().getWorld("world"), x, y, z);
				return loc;

			}
		} catch (Exception e) {
			e.printStackTrace();
		}

		finally {
			try {
				rs.close();
				sqlite.query("DELETE FROM playerlocs WHERE playername='" + uuid + "'");
			}
			catch (Exception e) {
				e.printStackTrace();
			}

		}

		return null;

	}

}
package org.c4k3.PvPTeleport;

import java.sql.ResultSet;
import java.util.UUID;

import org.bukkit.Location;
import org.bukkit.entity.Player;

import lib.PatPeter.SQLibrary.SQLite;

public class SQL {

	private static SQLite sqlite;

	/** Opens the SQL connection */
	public static void sqlConnection() {

		sqlite = new SQLite(PvPTeleport.instance.getLogger(),
				"PvPWorld", // Database name
				"playerlocs", // Database filename
				PvPTeleport.instance.getDataFolder().getAbsolutePath());
		try {
			sqlite.open();

			/* Checks if the playerlocs table already exists, if it does not, create it */
			if ( sqlite.checkTable("playerlocs")) {
				return;
			} else {
				sqlite.query("CREATE TABLE playerlocs (id INT PRIMARY KEY, uuid BLOB, x DOUBLE, y DOUBLE, z DOUBLE);");
			}

		} catch (Exception e) {
			PvPTeleport.instance.getLogger().info(e.getMessage());
		}
	}

	/** Inserts the player's data into the database */
	public static void putPlayer(Player player) {

		Location pLoc = player.getLocation();
		int x = pLoc.getBlockX();
		int y = pLoc.getBlockY();
		int z = pLoc.getBlockZ();
		UUID uuid = player.getUniqueId();

		/* This is easier... */
		sqlite.query("DELETE FROM playerlocs WHERE uuid='" + uuid + "'");
		sqlite.query("INSERT INTO playerlocs(uuid, x, y, z) VALUES ('" + uuid + "', '" + x + "', '" + y + "', '" + z + "')");
	}

	/** Retrieves the player's location from the playerlocs table, and turns it into a Bukkit.Location
	 * Returns null if it was unable to properly retrieve the location
	 */
	public static Location getPlayer(UUID uuid) {

		ResultSet rs = null;

		try {
			rs = sqlite.query("SELECT * FROM playerlocs WHERE uuid = '" + uuid + "'");
			while (rs.next()) {

				double x = rs.getDouble("x") + 0.5;
				double y = rs.getDouble("y");
				double z = rs.getDouble("z") + 0.5;
				Location loc = new Location(PvPTeleport.instance.getServer().getWorld("world"), x, y, z);
				return loc;

			}
		} catch (Exception e) {
			e.printStackTrace();
		}

		finally {
			try {
				rs.close();
				sqlite.query("DELETE FROM playerlocs WHERE uuid='" + uuid + "'");
			}
			catch (Exception e) {
				e.printStackTrace();
			}

		}

		return null;

	}

}
Fix wrong SQL