//carrega as dependencias, instalar as necessarias
var io = require('socket.io')(process.env.PORT || 4567);
var shortid = require('shortid');
var mysql = require('mysql');
var colors = require('colors');
var util = require('util');

//conecta ao banco de dados
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'gamac123',
    database: 'sockets'
})

connection.connect(function(err) {
    if (err) {
        throw err
        var mysqlstatus = err;
    } else {
        var mysqlstatus = 'database connection successful';
    }

})

var players = [];


//limpa o console
util.print("\u001b[2J\u001b[0;0H");
//mostra o status do servidor
console.log('-------------------------------------\n-----------SERVER STARTED------------\n-------DATABASE CONNECTION OK--------\n-------------------------------------'.green);

io.on('connection', function(socket){

    var thisClient = shortid.generate();
    players.push({id : thisClient}); // coloca o shortid do novo player no registro
    console.log('Client '+ thisClient +' Connected'.blue);

    socket.on('move', function(data) {
    });

    socket.on('disconnect',function () {
        console.log('client disconnected');

        delete players[thisPlayerId];

        socket.broadcast.emit('disconnected', { id: thisPlayerId });
    });

})

function showPlayers(){
    for(i=0;i< players.length;i++){
        console.log(players[i].id);
    }
}
//faz um teste de conexão
connection.query('SELECT * FROM users', function(err, results){
    if (err) { throw err; }
    else {
        if (results.length > 0) {
            for(var i = 0; i< results.length; i++){
    //          console.log(results[i].id+' - '+results[i].name+' - '+results[i].email+' - '+results[i].password);
            }
        } else {
            console.log('Database is empty');
        }
    }
})