package pl.raz4r.skycore.data;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Formatter;

import org.bukkit.configuration.file.FileConfiguration;
import org.bukkit.entity.Player;

import pl.raz4r.skycore.Main;



public class DataPlec {

    static String  url= DataMysql.getUrl();
    static String baza = DataMysql.getBaza();
    static String login = DataMysql.getLogin();
    static String password = DataMysql.getHaslo();

    public static void PrzypiszDane(FileConfiguration config){
         String  url= "jdbc:mysql://37.187.171.224:3306/";
         String baza = "edb_41051";
         String login = "edb_41051";
         String password = "uJwe8E7Evr";
    }


    public static boolean czyToPan(Player p) {
         try {
          Connection conn = DriverManager.getConnection(url+baza, login, password);
          Statement st = conn.createStatement();
          String nick_do_wczytania = p.getName();
           try {
              ResultSet rs = st.executeQuery("SELECT * FROM authme WHERE Username='"+nick_do_wczytania+"'");
              while(rs.next()){
                int plec = rs.getInt("Plec");
                if(plec==0)
                {
                    return true;
                }
                else{
                    return false;
                }
               }
           } catch (SQLException e) {
              System.out.println("Uwaga! Problem z wczytaniem pani");
           }
           conn.close();
         } catch (SQLException e) {
          System.out.println("Uwaga! Mamy problemy z połączeniem!");
         }
        return (Boolean) null;

        }
    public static boolean czyToPani(Player p) {
         try {
          Connection conn = DriverManager.getConnection(url+baza, login, password);
          Statement st = conn.createStatement();
          String nick_do_wczytania = p.getName();
           try {
              ResultSet rs = st.executeQuery("SELECT * FROM authme WHERE Username='"+nick_do_wczytania+"'");
              while(rs.next()){
                int plec = rs.getInt("Plec");
                if(plec==1)
                {
                    return true;
                }
                else{
                    return false;
                }
               }
           } catch (SQLException e) {
              System.out.println("Uwaga! Problem z wczytaniem pani");
           }
           conn.close();
         } catch (SQLException e) {
          System.out.println("Uwaga! Mamy problemy z połączeniem!");
         }
        return (Boolean) null;

        }

/*
    public static void PrzypiszDane(){
        url = "jdbc:mysql://SQL09.FREEMYSQL.NET:3306/";
        baza = "serwmc";
        login = "grzegorz2047";
        password = "kuwerty";
    }

         public static void main(String[] args) {
             PrzypiszDane();
             stworzBaze();
             stworzTabele();
             dodajRekord();
             wczytajBaze();
             usunRekord();
             dodajRekord();
             aktualizujRekord();

         }
         */


}