/[sudobot]/trunk/src/History.js
ViewVC logotype

Diff of /trunk/src/History.js

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 25 by rakin, Mon Jul 29 17:28:16 2024 UTC revision 37 by rakin, Mon Jul 29 17:28:18 2024 UTC
# Line 1  Line 1 
1  module.exports = class History {  module.exports = class History {
2      static get(user_id, guild, callback) {      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) => {          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) {              if (err) {
5                  console.log(err);                  console.log(err);
6              }              }
# Line 9  module.exports = class History { Line 9  module.exports = class History {
9          });          });
10      }      }
11    
12      static create(user_id, guild, type, mod, callback) {      static create(user_id, guild, type, mod, reason, 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) => {          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) {              if (err) {
15                  console.log(err);                  console.log(err);
16              }              }
Legend:
Removed from v.25  
changed lines
  Added in v.37
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26