var Promise = require ('bluebird');
var SteamApi = require('steam-api');
var steam = require('steam-web');
var mysql = require('mysql');
var STEAM_API_KEY = "48CCAFE1F09793F723FF03F306169734";
var optionalSteamId = '76561198058632219';

var user = new SteamApi.User(STEAM_API_KEY, optionalSteamId);
var s = new steam({
    apiKey: '48CCAFE1F09793F723FF03F306169734',
    format: 'json'
});

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : '< MySQL username >',
  password : '< MySQL password >',
  database : '<your database name>'
});


let promiseGetFriendListIds = function () {

    return new Promise(function (resolve, reject) {
        user.GetFriendList(optionalRelationship = 'all', optionalSteamId).done(function (result) {
            let ArrayWithId = [];
            for (let i in result) {
                ArrayWithId.push(result[i]['steamId']);
            }
            resolve(ArrayWithId);
        });
    });
};
//ArrayWithId length = 100
let promiseGetAllSteamIds = function (ArrayWithId) {
    return new Promise(function (resolve,reject) {
        let NextArrayWithId  = [];
        connection.connect();
        for (let i = 0; i < ArrayWithId.length ; i++) {

            setTimeout( function () {
                s.getFriendList({
                    steamid: ArrayWithId[i],
                    relationship: 'all',
                    callback: function(err,res) {
                            var query = connection.query('INSERT INTO steamdata SET ?', res, function(err, result) {
                            // Neat!
                            });
                       // for (var j in res) {
                          //    NextArrayWithId.push(res[j].friends);
                         //     console.log(res[j]);
                         // }


                        resolve(res);

                    },
                })

                //user.GetFriendList(optionalRelationship = 'all', ArrayWithId[i]).done(function (res) {

                //})
            },1000)
        }
        connection.end();
    })
}


promiseGetFriendListIds()
    .then(promiseGetAllSteamIds)
    .then(function(res){
        console.log(res);
    });