i kolejny problem
function(error, tradedata) {
if (!error) {
console.log(tradedata);
}
var datadec = tradedata;
for(var j=0; j < num; j++) {
var itemid = datadec[j].id;
var iconurl = datadec[j].icon_url;
var namekolor = datadec[j].name_color;
var cenaitema = mysqlConnection.query('SELECT `cost` FROM `items` WHERE `name` = \'' + itemn + '\'', function(err, row, fields) {
console.log(cenaitema);//tutaj zwraca caly czas undefined(0) tzn nie pobiera z bazy danych ceny , nie wiem jak to zrobic zeby pobieralo
});
;
mysqlConnection.query('INSERT INTO `game' + current_game + '` (`userid`,`username`,`item`,`color`,`value`,`avatar`,`itemid`,`image`,`from`
,`to`) VALUES (\'' + offer.steamid_other + '\',\'' + name + '\',\'' + itemn + '\',\'' + namekolor + '\',\'' + cenaitema+//tutaj chce miec wartosc z var cenaitema ale ciagle jest to 0
'\',\'' + avatar + '\',\'' + itemid + '\',\'' + iconurl + '\',\''+current_bank+'\'+\'0\',\''+current_bank+'\'+\''+cenaitema+'\')', function(err, row, fields) {});
mysqlConnection.query('UPDATE `games` SET `itemsnum`=`itemsnum`+1, `cost`=`cost`+\''+cenaitema+'\' WHERE `id` = \'' + current_game + '\'', function(err, row, fields) {});
console.log(itemid);
console.log(cenaitema);
itemsnum++;
current_bank = parseFloat(current_bank + cenaitema);
}
});
prosil bym o pomoc
for(var j=0; j < num; j++) {
var wgg[j].id = datadec[j].id;
var itemid = datadec[j].id;
var iconurl = datadec[j].icon_url;
var namekolor = datadec[j].name_color;
mysqlConnection.query('SELECT `cost` FROM `items` WHERE `name` = \'' + itemn + '\'', function(err, row, fields) {
console.log(cenaitema);
var cena = row[0].cost;
console.log(cost);
mysqlConnection.query('INSERT INTO `game' + current_game + '` (`userid`,`username`,`item`,`color`,`value`,`avatar`,`itemid`,`image`,`from`
,`to`) VALUES (\'' + offer.steamid_other + '\',\'' + name + '\',\'' + itemn + '\',\'' + namekolor + '\',\'' + cenaitema + '\',\'' + avatar + '\',\'' + itemid + '\',\'' + iconurl + '\',\''+current_bank+'\'+\'0\',\''+current_bank+'\'+\''+cenaitema+'\')', function(err, row, fields) {});
mysqlConnection.query('UPDATE `games` SET `itemsnum`=`itemsnum`+1, `cost`=`cost`+\''+cenaitema+'\' WHERE `id` = \'' + current_game + '\'', function(err, row, fields) {});
console.log(itemid);
console.log(cenaitema);
itemsnum++;
current_bank = parseFloat(current_bank + cenaitema);
});
jak ustawie takie cos to niby jest cena ale tylko dla j=0 ale np kilka razy }
juz rozwiazalem problem