db.query('SELECT UserJoinTime AS lastJoinTime FROM UserData WHERE UserID=?', user.id, function (err, result) {
if (err) {
foxbot.handleDisconnect(db);
}
else {
foxbot.foxy.userData.lastJoinTime = result[0].lastJoinTime;
}
});
db.query('SELECT UserID AS userCountDB FROM UserData WHERE UserOnline=?', 1, function (err, result){
if (err) {
foxbot.handleDisconnect(db);
}
else {
foxbot.foxy.roomData.userCount = result.length;
}
});
db.on('error', function (err) {
if (!err.fatal) return;
if (err.code !== 'PROTOCOL_CONNECTION_LOST') throw err;
foxbot.log(foxbot.console.info + 'Re-connecting lost MySQL connection: ' + err.stack);
db = mysql.createConnection(dbconfig);
foxbot.handleDisconnect(db);
db.connect();
});
db.query('SELECT UserName AS username FROM UserData WHERE UserID=?', user.id, function (err, result) {
if (err) {
foxbot.handleDisconnect(db);
}
else {
var username = result[0].username;
foxbot.log(foxbot.console.leave + username + ' left the room');
}
});
db.query('UPDATE UserData SET UserOnline=? WHERE UserID=?', [0,user.id], function (err) {
if (err) {
foxbot.handleDisconnect(db);
}
});
db.query('UPDATE UserData SET ? WHERE UserID=?',[updateUser, user.id], function (err) {
if (err) {
foxbot.handleDisconnect(db);
}
});
db.query('INSERT INTO UserData SET ? ON DUPLICATE KEY UPDATE ?', [require('merge')({UserID: user.id}, updateUser), updateUser], function (err) {
if (err) {
foxbot.handleDisconnect(db);
}
});