Untitled
plain_text
a month ago
1.8 kB
1
Indexable
Never
updateRole: (req) => { return new Promise((resolve, reject) => { const sql = `UPDATE role SET position = (?), open_webcam =(?), open_micro =(?), open_share_screen =(?), send_message =(?), see_user_ip =(?), kick_user =(?), ban_user=(?), send_private=(?), can_be_invisible=(?), edit_message=(?) where room = (?) AND role =(?)`; const values = [req.data.position , req.data.open_webcam, req.data.open_micro, req.data.open_share_screen, req.data.send_message, req.data.see_user_ip, req.data.kick_user, req.data.ban_user, req.data.send_private, req.data.can_be_invisble, req.data.edit_message, req.room, req.data.role ]; poolQuery(sql, values) .then((value) => { console.log(value.affectedRows) if (value.affectedRows === 1) resolve({message:'reussis'}) }) .catch((err) => reject(err)); }); }, }