var mysql = require("mysql"),
    colors = require("colors"),
    fs = require("fs"),
    crypto = require('crypto'),
    socket = require("socket.io").listen(8001);

// Creating connection to database
var config = {
    host: "localhost",
    user: "root",
    password: "password",
    database: "game"
};

function rid() {
    return Math.random().toString(36).substring(2);
}

function log(text, color) {
    var d = new Date();
    var h = d.getHours();
    var m = d.getMinutes();
    var ap = "AM";
    if (h > 12) {
        h -= 12;
        var ap = "PM";
    }
    if (m < 10) {
        m = "0" + m;
    }
    time = h + ":" + m + " " + ap;

    if (typeof(color) == "undefined") {
        display = colors.grey(time) + ": " + text;
        console.log(display);
    } else {
        console.log(colors.grey(time) + ": " + colors[color](text));
    }
}

// Handling MySQL disconnects
var con;
function handleConnection() {
    con = mysql.createConnection(config);

    // Connecting to the database
    con.connect(function(err) {
        if (err) {
            log("Failure to establish connection to database.", "red");
            log(err, "red");
            setTimeout(handleConnection, 2000);
        } else {
            log("Successfully connected to database.", "green");
        }
    });

    // Reconnect on connection lost
    con.on("error", function(err) {
        log("Failure to establish connection to database.", "red");
        log(err, "red");
        if (err.code === "PROTOCOL_CONNECTION_LOST") {
            handleConnection();
        } else {
            throw err;
        }
    });
}

handleConnection(); // Connect and start disconnect handler

socket.on('connection', function(socket) {
    log("Client successfully connected.", "yellow");
});

socket.on('hey', function() {
    log("Received hey.", "cyan");
});

var users = {};

socket.on('ridfetch', function(data) {
    log("GOT RID FETCH ADDRESS REQUEST", "cyan");
});