18 lines
573 B
JavaScript
18 lines
573 B
JavaScript
|
const sql = require('./mysql')
|
||
|
|
|
||
|
|
function setExpired(userAccount) {
|
||
|
|
console.log(userAccount.username + ' ' + userAccount.stream + ' Expired on ' + userAccount.expiaryDate.toLocaleDateString(undefined, { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' }))
|
||
|
|
let result
|
||
|
|
try {
|
||
|
|
result = sql.query(`UPDATE userAccounts SET expiaryDate = "0" WHERE username = "${userAccount.username}" AND password = "${userAccount.password}"; `);
|
||
|
|
} catch (error) {
|
||
|
|
console.log(error)
|
||
|
|
}
|
||
|
|
return result
|
||
|
|
}
|
||
|
|
|
||
|
|
module.exports = {
|
||
|
|
setExpired
|
||
|
|
}
|
||
|
|
|