var config = require('../config');
var app = require('http').createServer()
var io = require('socket.io')(app);
var fs = require('fs');
var mysql = require('mysql');

app.listen(config.serverPort);

console.log("Starting server on port " + config.serverPort);

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db'
});

connection.connect();

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

  var ip = socket.handshake.address;

  console.log("Ip of the user: " + ip);

  connection.query('SELECT  * FROM users WHERE users.ip = ' + ip, function(err, rows, fields) {
      if (err) throw err;

      if(rows.length > 0) { //the fucker payed up
        //rows[0].name to access attributes in db
        //the use that to change it in config
          }
    });

  socket.on('login', function(data) {
    console.log("User connected with id:" + data.uuid);
    socket.room = data.uuid;
    socket.join(data.uuid);

    if (data.type == "server") {
      io.sockets.in(socket.room).emit("force-login", "server-booted-up");
    }

  });

  socket.on('pos', function(data) {
    //console.log(socket.room + " : " + data);
    io.sockets.in(socket.room).emit('pos', data);
  });

  socket.on('cmd', function(data) {
    console.log(data);
    io.sockets.in(socket.room).emit('cmd', data);
  });

  socket.on("spawn-count", function(data) {
    io.sockets.in(socket.room).emit("spawn-count", data);
    });

  socket.emit("force-login", "startup");

});