trunk/src/History.js

module.exports = class History {
    static get(user_id, guild, callback) {
        app.db.all('SELECT * FROM history WHERE guild_id = ? AND user_id = ? ORDER BY id DESC', [guild.id, user_id], (err, data) => {
            if (err) {
                console.log(err);
            }

            callback(data);
        });
    }

    static create(user_id, guild, type, mod, reason, callback) {
        app.db.get('INSERT INTO history(type, user_id, guild_id, date, mod_id, reason) VALUES(?, ?, ?, ?, ?, ?)', [type, user_id, guild.id, new Date().toISOString(), mod, reason], (err) => {
            if (err) {
                console.log(err);
            }

            app.db.get("SELECT * FROM history WHERE type = ? AND user_id = ? AND guild_id = ? ORDER BY id DESC LIMIT 0, 1", [type, user_id, guild.id], (err, data) => {
                if (err) {
                    console.log(err);
                }
                
                callback(data);
            });
        });
    }
};
1	module.exports = class History {
2	static get(user_id, guild, callback) {
3	app.db.all('SELECT * FROM history WHERE guild_id = ? AND user_id = ? ORDER BY id DESC', [guild.id, user_id], (err, data) => {
4	if (err) {
5	console.log(err);
6	}
7
8	callback(data);
9	});
10	}
11
12	static create(user_id, guild, type, mod, reason, callback) {
13	app.db.get('INSERT INTO history(type, user_id, guild_id, date, mod_id, reason) VALUES(?, ?, ?, ?, ?, ?)', [type, user_id, guild.id, new Date().toISOString(), mod, reason], (err) => {
14	if (err) {
15	console.log(err);
16	}
17
18	app.db.get("SELECT * FROM history WHERE type = ? AND user_id = ? AND guild_id = ? ORDER BY id DESC LIMIT 0, 1", [type, user_id, guild.id], (err, data) => {
19	if (err) {
20	console.log(err);
21	}
22
23	callback(data);
24	});
25	});
26	}
27	};