NODEJS – Chyba výpisu MYSQL a následnou podmínkou

mysqlConnection.query('SELECT `ajdy` FROM `tradeid` WHERE `ajdy` = ''+offer.tradeofferid+'' LIMIT 1', function(err, row, fields) {

var ajdy = (row.ajdy);

if(offer.tradeofferid == row.ajdy){

console.log('To zde již máme');

return;

}

});

TypeError: Cannot read property 'ajdy' of undefined /root/node_modules/mysql/lib/protocol/Parser.js:82

null []

/root/node_modules/mysql/lib/protocol/Parser.js:82

throw err;

^

TypeError: Cannot read property 'ajdy' of undefined

at Query._callback (/root/node_modules/steam-tradeoffers/examples/tradebot.j

s:414:20)

at Query.Sequence.end (/root/node_modules/mysql/lib/protocol/sequences/Seque

nce.js:96:24)

at Query._handleFinalResultPacket (/root/node_modules/mysql/lib/protocol/seq

uences/Query.js:144:8)

at Query.EofPacket (/root/node_modules/mysql/lib/protocol/sequences/Query.js

:128:8)

at Protocol._parsePacket (/root/node_modules/mysql/lib/protocol/Protocol.js:

271:23)

at Parser.write (/root/node_modules/mysql/lib/protocol/Parser.js:77:12)

at Protocol.write (/root/node_modules/mysql/lib/protocol/Protocol.js:39:16)

at Socket. (/root/node_modules/mysql/lib/Connection.js:96:28)

at Socket.emit (events.js:107:17)

at readableAddChunk (_stream_readable.js:163:16)

///////////////////////////////////ZACATEK PODMINKY//////////////

mysqlConnection.query('SELECT `value` FROM `info` WHERE `name`='current_game'', function(err, row, fields) {

var current_game = (row.value);

mysqlConnection.query('SELECT `cost`,`itemsnum` FROM `games` WHERE `id`=''+current_game+''', function(err, row, fields) {

var current_bank = parseFloat(row.cost);

var itemsnum = row.itemsnum;

if(itemsnum > 0){

mysqlConnection.query('UPDATE `games` SET `starttime`=UNIX_TIMESTAMP() WHERE `id` = '' + current_game + '' AND `starttime`= '2147483647'', function(err, row, fields) {});

}

for(var j=0; j < num; j++) {

mysqlConnection.query('INSERT INTO `game' + current_game + '` (`userid`,`username`,`item`,`color`,`value`,`avatar`,`image`,`from`,`to`) VALUES ('' + offer.steamid_other + '','' + name + '','' + wgg.market_name + '','' + wgg.name_color + '','' + wgg.cost + '','' + avatar + '','' + wgg.icon_url + '',''+current_bank+''+'0',''+current_bank+''+''+wgg.cost+'')', function(err, row, fields) {});

mysqlConnection.query('UPDATE `games` SET `itemsnum`=`itemsnum`+1, `cost`=`cost`+''+wgg.cost+'' WHERE `id` = '' + current_game + ''', function(err, row, fields) {});

current_bank = parseFloat(current_bank + wgg.cost);

itemsnum++;

}

if(itemsnum > 100) {

proceedWinners();

}

///////////////////////////////////KONEC PODMINKY//////////////

mysqlConnection.query('SELECT ajdy FROM tradeid WHERE ajdy = ? LIMIT 1', , function(err, row) {

if(err) throw err; // popř. return callback(err);

if(!row.length)

return console.log("Záznam neexistuje");

var ajdy = row.ajdy;

if(offer.tradeofferid == ajdy)

return console.log('To zde již máme');

});

steamuserinfo.getUserInfo(offer.steamid_other, function(error, data){

if(error) throw error;

var datadec = JSON.parse(JSON.stringify(data.response));

var name = datadec.players.personaname;

var avatar = datadec.players.avatarfull;

if(num == 0) return;

console.log('To '+ pustit +'');

///////////////////////////////////ZDE UKONCIT POKUD JIZ JE//////////////

mysqlConnection.query('SELECT `value` FROM `info` WHERE `name`='current_game'', function(err, row, fields) {

var current_game = (row.value);

mysqlConnection.query('SELECT `cost`,`itemsnum` FROM `games` WHERE `id`=''+current_game+''', function(err, row, fields) {

var current_bank = parseFloat(row.cost);

var itemsnum = row.itemsnum;

if(itemsnum > 0){

mysqlConnection.query('UPDATE `games` SET `starttime`=UNIX_TIMESTAMP() WHERE `id` = '' + current_game + '' AND `starttime`= '2147483647'', function(err, row, fields) {});

}

for(var j=0; j < num; j++) {

mysqlConnection.query('INSERT INTO `game' + current_game + '` (`userid`,`username`,`item`,`color`,`value`,`avatar`,`image`,`from`,`to`) VALUES ('' + offer.steamid_other + '','' + name + '','' + wgg.market_name + '','' + wgg.name_color + '','' + wgg.cost + '','' + avatar + '','' + wgg.icon_url + '',''+current_bank+''+'0',''+current_bank+''+''+wgg.cost+'')', function(err, row, fields) {});

mysqlConnection.query('UPDATE `games` SET `itemsnum`=`itemsnum`+1, `cost`=`cost`+''+wgg.cost+'' WHERE `id` = '' + current_game + ''', function(err, row, fields) {});

current_bank = parseFloat(current_bank + wgg.cost);

itemsnum++;

}

if(itemsnum > 100) {

proceedWinners();

}

offers.acceptOffer({tradeOfferId: offer.tradeofferid});

mysqlConnection.query('INSERT INTO `tradeid` (`ajdy`) VALUES ('' + offer.tradeofferid + '')', function(err, row, fields) {});

console.log('Accepted trade offer #'+offer.tradeofferid+' by '+name+' ('+offer.steamid_other+')');

});

});