package com.GlassGaming.MySQL_Data;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.bukkit.entity.Player;

public class Queries {

    public static MySQL_Data plugin;
    public Queries(MySQL_Data MySQL_Data){
        plugin = MySQL_Data;
    }



    public static Long getTimePlayed(final Player p){
        try{
            PreparedStatement ps = plugin.MySQL.openConnection().prepareStatement("SELECT playtime FROM users WHERE UUID='"+p.getUniqueId().toString()+"'");
            ResultSet rs = ps.executeQuery();
            if(!rs.next()){
                return 0L;
            }
            Long playtime = rs.getLong("playtime");
            rs.close();
            return playtime;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return 0L;
    }

}