package events;

import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.User;
import net.dv8tion.jda.core.events.guild.member.GuildMemberJoinEvent;
import net.dv8tion.jda.core.events.message.guild.GuildMessageReceivedEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;

import java.sql.*;

public class RegisterUser extends ListenerAdapter{

    public void onGuildMessageRecieved(GuildMessageReceivedEvent event){

        String member = event.getMember().toString();

        String[] messageSent = event.getMessage().getContentRaw().split(" ");


        try {
            Class.forName("com.mysql.cj.jdbc.Driver"); //This statement may be different depending on driver version
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/matchmaking", "kanedu", "kanedu");

            //Statement stmt = con.createStatement();
            //ResultSet matchmaking = stmt.executeQuery("select * from userdata;");
            if(messageSent[0].equalsIgnoreCase("!f") && messageSent[1].equalsIgnoreCase("register")){
                PreparedStatement pstmt = con.prepareStatement("insert into userdata values(?, ?)");
                pstmt.setString(1, member);
                pstmt.setInt(2, 1000);
                pstmt.execute();
                System.out.println(member + " is registered and their points is set to " + 1000);

                pstmt.close();
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        catch (SQLException e) {
            e.printStackTrace();
        }

    }



}