java

var CensusQuery = require('dbgcensus').Query;
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',
});

query.where('alias_lower').equals('ini'); //2 person outfit is 1mvs 1 person outfit is tsar bhot is 49 //1mvs gives non leader char, bhot gives barondizzy (newest member)
query.addResolve(['member_characters_stat_history', 'member_character_name']);
query.get(function (error, data) {
    connection.connect(function (err) {
        if (err) {
            console.error('error connecting: ' + err.stack);
            return;
        }

        console.log('connected as id ' + connection.threadId);
    });
    console.log(data);
    console.log(data[0].members);
    //console.log(data[0].members[0].character_id);
    for (var j = 0; j < data[0].members.length; j++) {
        if (typeof data.character_id !== "undefined"){
        continue;
        }
        console.log("Character: " + data[0].members[j].name.first_lower);
        var query2 = new CensusQuery('character', 'ps2:v2', 'conchubair');
        //var chara_id = data[0].members[j].character_id;
        //console.log(chara_id);
        query2.where('character_id').equals(data[0].members[j].character_id);
        query2.addResolve(['item']);
        query2.get(function (error, data2) {
            //console.log(data);
            //console.log(data[0].items);
            //console.log(data[0].items[0].item_id);
            for (var i = 0; i < data2[0].items.length; i++) {
                //var itemData = data[0].items[i];
                if (typeof data2[0].items[i].account_level == 'undefined') {
                    data2[0].items[i].account_level = 0;
                }
                else {
                    data2[0].items[i].account_level = 1;
                }
                if (typeof data2[0].items[i].stack_count == 'undefined') {
                    data2[0].items[i].stack_count = 1;
                }
                //console.log("Logging " + data2[0].name.first_lower + " 's data to SQL");
                connection.query('INSERT INTO ac_items (char_id, item_id, account_level, stack_count) VALUES (' + data2[0].character_id + ', ' + data2[0].items[i].item_id + ', ' + data2[0].items[i].account_level + ', 1)', function (err, result) {
                    if (!err) {
                        //console.log('Query complete');
                    }
                    else {
                        console.log('Error in: Selecting All Players');
                        console.log(err);

                    };//closes commit
                });
            }//closes for loop
        })//cloes query2
    }//closes for loop
});//closes query