Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "steam_bot"
- });
- function RecordUsers() {
- console.log("Соединение установлено!");
- var sql = "UPDATE `users` SET name ='Test' WHERE steamid = '"+steamID+"'";
- con.query(sql, function (err, rows, result) {
- if (err) throw err;
- console.log("1 record update");
- if (rows[0] < 1) {
- var sql = "INSERT INTO `users`(name, steamid) VALUES ('Testovino','"+steamID+"')";
- con.query(sql, function (err, result) {
- console.log("1 record insert");
- });
- }
- });
- }
Add Comment
Please, Sign In to add comment