Advertisement
Guest User

sqlhard

a guest
Nov 5th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. app.post("/reg", (req, res) => {
  2. var username = req.body.username;
  3. var password = req.body.password;
  4. if (!username || !password || username.length < 4 || password.length < 4) {
  5. return res.end("Bye");
  6. }
  7.  
  8. password = crypto.createHash("md5").update(password).digest("hex");
  9. var sql = `INSERT INTO users(username, password) VALUES('${username}', '${password}') ON CONFLICT (username) DO NOTHING`;
  10. return client.query(sql.split(";")[0], (err, rows) => {
  11. if (rows && rows.rowCount == 1) {
  12. return res.end("Reg OK");
  13. } else {
  14. return res.end("User taken");
  15. }
  16. });
  17. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement