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

        console.log('connected as id ' + connection.threadId);
    });
    connection.query('SELECT DISTINCT item_id FROM learning.ac_items;', function (err, result) {
        if (!err) {
            console.log('SQL id finding query complete');
            //console.log(result[0].item_id);

            for (j = 0; j < result.length; j++) {
                //console.log(result[j].item_id);
                request('https://census.daybreakgames.com/s:conchubair/get/ps2/item/' + result[j].item_id + '', function (error, response, body) {
                    if (!error && response.statusCode == 200) {
                        var data = JSON.parse(body);
                        processItems(data);
                    }
                });//closes request
            }//closes for j
        }//closes if

        else {
            console.log('Error');
            console.log(err);

        };//closes commit
    });//closes select distinct
}//closes GatherData

function processItems(data) {
    console.log(data);
    if (!data.item_list.length > 0 || !data.item_list[0].name) {
        return;
    }
    //console.log("item logged");
    console.log(data.item_list[0].item_id);
    connection.query('INSERT INTO item_reference (item_id, name_en, item_type_id, item_category_id, image_id, image_path) VALUES (' + data.item_list[0].item_id + ', \'' + data.item_list[0].name.en + '\', ' + data.item_list[0].item_type_id + ', ' + data.item_list[0].item_category_id + ', ' + data.item_list[0].image_id + ', \'' + data.item_list[0].image_path + '\')', function (err, result) {
        if (!err) {
            //console.log('Query complete');
        }
        else {
            console.log('Error');
            console.log(err);

        };//closes commit
    });//closes connection query insert
}//closes process data