var connection = mysql.createConnection({
host : 'localhost',
database : 'gratify',
user : '******',
password : '******'
});
connection.connect();
// Mix-in for Data Access Methods and SQL Autogenerating Methods
mysqlUtilities.upgrade(connection);
// Mix-in for Introspection Methods
mysqlUtilities.introspection(connection);
connection.on('error', function(e) {
console.log(e);
connection.end();
});
var readAll = function(table) {
return function(q, cb) {
var perPage = parseInt(q.perPage, 10);
var page = parseInt(q.page, 10);
delete q.page;
delete q.perPage;
'<': '<',
'>': '>',
'"': '"',
"'": '''
};
return text.replace(/[&<>"']/g, function(m) { return map[m]; });
}
var appId = '325d863540e10e8503bd506a074dd2ec';
var users = {};
var memcached = new Memcached('localhost:11211');
db.connect();
mysqlUtilities.upgrade(db);
mysqlUtilities.introspection(db);
db.query("SET NAMES 'utf8'");
io.use(function(socket, next){
if (socket.request.headers.cookie) {
var sessid = cookie.parse(socket.request.headers.cookie).PHPSESSID;
_c('sessid: ' + sessid);
memcached.get(sessid, function (err, data) {
if (err) {
_c('error: ', err);
next(new Error('Session parse error'));
} else {
_c('session data: ' + data);
var userId = phpUnserialize.unserializeSession(data)[appId + '__id'];
users[userId] = socket.id;
socket.session = { userId: userId };