Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var mysqlc = mysql.createConnection(
- {
- host:'localhost',// host of server
- user:'root',// MySQL user
- password:'root',// MySQL password
- database:'vicevdm'// MySQL database
- });
- mysqlc.connect(function(e)
- {
- if(e) {
- console.log("ERROR: Brak połączenia z bazą danych !" + e);
- }
- else {
- console.log('Połączono z bazą danych !');
- }
- });
- mp.events.addCommand('register', (player) => {
- console.log('Komenda /register wywołana.');
- if(mysqlc.connect) {
- console.log('Połączenie z bazą stabilne.');
- var playerName = player.name;
- console.log(playerName);
- var playerID = player.id;
- console.log(playerID);
- var sql = "INSERT INTO users (id, name) VALUES ('10', 'Highway 37')";
- mysqlc.query(sql, function (e, result){
- if(e) throw e;
- console.log('Dane wysłane.');
- })
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement