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 = ?', [guild.id, user_id], (err, data) => {
            if (err) {
                console.log(err);
            }

            callback(data);
        });
    }

    static create(user_id, guild, type, mod, callback) {
        app.db.get('INSERT INTO history(type, user_id, guild_id, date, mod_id) VALUES(?, ?, ?, ?, ?)', [type, user_id, guild.id, new Date().toISOString(), mod], (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	rakin	25	module.exports = class History {
2			static get(user_id, guild, callback) {
3			app.db.all('SELECT * FROM history WHERE guild_id = ? AND user_id = ?', [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, callback) {
13			app.db.get('INSERT INTO history(type, user_id, guild_id, date, mod_id) VALUES(?, ?, ?, ?, ?)', [type, user_id, guild.id, new Date().toISOString(), mod], (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			};