Guest User

Untitled

a guest
Nov 30th, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. var mysql = require('mysql');
  2.  
  3. var con = mysql.createConnection({
  4. host: "localhost",
  5. user: "root",
  6. password: "",
  7. database: "steam_bot"
  8. });
  9.  
  10. function RecordUsers() {
  11. console.log("Соединение установлено!");
  12. var sql = "UPDATE `users` SET name ='Test' WHERE steamid = '"+steamID+"'";
  13. con.query(sql, function (err, rows, result) {
  14. if (err) throw err;
  15. console.log("1 record update");
  16. if (rows[0] < 1) {
  17. var sql = "INSERT INTO `users`(name, steamid) VALUES ('Testovino','"+steamID+"')";
  18. con.query(sql, function (err, result) {
  19. console.log("1 record insert");
  20. });
  21. }
  22. });
  23. }
Add Comment
Please, Sign In to add comment