package com.chrisgward.IRC.Tab;

import java.net.*;
import java.io.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;

import com.mysql.jdbc.*;

public class Tab {

	/**
	 * @param args
	 * @throws IOException
	 * @throws SQLException
	 * @throws ClassNotFoundException
	 */
	public static void main(String[] args) throws IOException, SQLException, ClassNotFoundException {
		// TODO Auto-generated method stub

		Class.forName("com.mysql.jdbc.Driver");
		String sentence;
		Socket clientSocket = new Socket("irc.esper.net", 6667);
		DataOutputStream writer = new DataOutputStream(clientSocket.getOutputStream());
		BufferedReader reader = new BufferedReader(new InputStreamReader(clientSocket.getInputStream()));
		writer.writeBytes("USER Tab 0 * :Tab IRC Bot\n");
		writer.writeBytes("NICK Tab\n");
		Boolean nickserv = true;
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Tab", "root", "");
		while(true)
		{
			if(reader.ready())
			{
				String read = reader.readLine();
				System.out.println(read);
				if(read.startsWith("PING"))
					writer.writeBytes("PONG " + read.split(" ")[1] + "\n");
				else if (read.startsWith(":NickServ!NickServ@services.esper.net") && nickserv)
				{
					writer.writeBytes("PRIVMSG NickServ :ID \n");
					writer.writeBytes("JOIN #bananacode\n");
					nickserv = false;
				}

				String command = read.split(" ")[1];
				if(command.contains("PRIVMSG") || command.contains("QUIT") || command.contains("PART") || command.contains("MODE") || command.contains("KICK") || command.contains("NICK"))
				{PreparedStatement stmt = conn.prepareStatement("INSERT INTO data VALUES (?, ?);");
					stmt.setString(1, read);
					java.util.Date date = new java.util.Date();
					stmt.setTimestamp(2, (new java.sql.Timestamp(date.getYear(), date.getMonth(), date.getDate(), date.getHours(), date.getMinutes(), date.getSeconds(), 0)));
					stmt.executeUpdate();
				}

			}
		}
		//clientSocket.close();
	}

}