var mysql      = require('mysql');
var CryptoJS = require("crypto-js");
var bigInt = require("big-integer");

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'DBAdmin',
  password : 'DBAdmin'
});

connection.connect();

connection.query('SELECT playerid from arma3life.players;', function(err, rows, fields) {
    if (err) throw err;
    for (var i = 0; i < rows.length; i++) {
        console.log(rows[i].playerid);
        console.log(uid2guid(rows[i].playerid));
        connection.query("UPDATE arma3life.players set guid = '" + uid2guid(rows[i].playerid) + "' where playerid = '" + rows[i].playerid + "';" , function(err, rows, fields) {
        });
    }
});

var uid2guid = function(uid) {
  if (!uid) {
    return;
  }

  var steamId = bigInt(uid);
  var parts = [0x42,0x45,0,0,0,0,0,0,0,0];

  for (var i = 2; i < 10; i++) {
    var res = steamId.divmod(256);
    steamId = res.quotient;
    parts[i] = res.remainder.toJSNumber();
  }
  var wordArray = CryptoJS.lib.WordArray.create(new Uint8Array(parts));
  var hash = CryptoJS.MD5(wordArray);
  return hash.toString();
};