Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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[0].members[j].first_lower == "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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement