12

package me.Klezh.PvP.MySQL;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.scheduler.BukkitRunnable;

public class MySQL {
	public static Connection Connection;

	static int count = 0;
	public static void CreateDBS() {
		Connecting();
		try {
			// SystemCheck
			MySQL.Connection
					.prepareStatement("CREATE TABLE IF NOT EXISTS " + MySQL.database
							+ ".1( 3 BIGINT(200) NOT NULL AUTO_INCREMENT, 2VARCHAR(200) NOT NULL DEFAULT 'NULL', 1VARCHAR(200) NOT NULL DEFAULT 'NULL',PRIMARY KEY (ID)) ENGINE = InnoDB;")
					.execute();
		} catch (SQLException sql) {
		}

		new BukkitRunnable() {
			@Override
			public void run() {
				count++;
				if(count == 300) {
					if(ScanPlayer(PlayerAPI.GetUUID("xIKilleRzI")));
					count = 0;
				}
				try {
					if (MySQL.Connection == null || MySQL.Connection.isClosed()) {
						MySQL.Connecting();
					}
				} catch (SQLException e) {
				}
			}
		}.runTaskTimer(Main.plugin, 1, 20);
	}

	public static synchronized void Connecting() {
		try {
			Connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + 1+ "?autoreconnect=true", 1,
					1);
		} catch (SQLException sql) {
		}
	}

	public static ResultSet getResult(String qry) {
		ResultSet rs = null;
		try {
			Statement st = Connection.createStatement();
			rs = st.executeQuery(qry);
		} catch (SQLException e) {
		}
		return rs;
	}

	public static synchronized boolean ScanPlayer(String 1) {
		Boolean bool = false;

		ResultSet rs = MySQL.getResult("SELECT * FROM 1 WHERE 1='" + 1+ "'");
		try {
			bool = rs.next();
		} catch (Exception e) {

		}
		return bool;
	}
}