var CensusQuery = require('dbgcensus').Query;
var request = require('request');
var query = new CensusQuery('outfit', 'ps2:v2', 'conchubair');
var mysql = require('mysql');
var j, i;

var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'cuck420',
    database: 'learning',
});

connection.connect(function (err) {
    if (err) {
        console.error('error connecting: ' + err.stack);
        return;
    }

    console.log('connected as id ' + connection.threadId);
});

function GatherData(TAG) {
    var request = require('request');
    request('https://census.daybreakgames.com/s:conchubair/get/ps2/outfit/?alias_lower=' + TAG + '&c:resolve=member_character_name&c:join=characters_item^on:members.character_id^to:character_id^inject_at:items^list:1', function (error, response, body) {
        if (!error && response.statusCode == 200) {
            var data = JSON.parse(body);
            processMembers(data);
        }
    });
}
var outfitlist = ['ac', 'cl0p', 'lacl'];
for (var i = 0; i < outfitlist.length; i++) {
    GatherData(outfitlist[i]);
}

function processMembers(data) {
    console.log(data);

    //console.log(data);
    //console.log(data.outfit_list[0].members);
    for (var j = 0; j < data.outfit_list[0].members.length; j++) {
        try {
            var fuckyou = data.outfit_list[0].members[j].name.first_lower === 'undefined';
        }
        catch (err) {
            console.log("skip");
            continue;
        }
        for (var i = 0; i < data.outfit_list[0].members[j].items.length; i++) {
            if (typeof data.outfit_list[0].members[j].items[i].account_level == 'undefined') {
                data.outfit_list[0].members[j].items[i].account_level = 0;
            }
            else {
                data.outfit_list[0].members[j].items[i].account_level = 1;
            }
            if (typeof data.outfit_list[0].members[j].items[i].stack_count == 'undefined') {
                data.outfit_list[0].members[j].items[i].stack_count = 1;
            }
            connection.query('INSERT INTO ac_items (char_id, item_id, account_level, stack_count) VALUES (' + data.outfit_list[0].members[j].items[i].character_id + ', ' + data.outfit_list[0].members[j].items[i].item_id + ', ' + data.outfit_list[0].members[j].items[i].account_level + ', 1)', function (err, result) {
                if (!err) {
                    //console.log('Query complete');
                }
                else {
                    console.log('Error');
                    console.log(err);

                };//closes commit
            });
        }
        console.log("Completed appending " + data.outfit_list[0].members[j].name.first + "'s items");
    }
}