cSrHi1vn

1const VkBot = require('node-vk-bot-api')
2const Markup = require('node-vk-bot-api/lib/markup');
3const api = require('node-vk-bot-api/lib/api');
4const execute = require('node-vk-bot-api/lib/methods/execute');
5const mysql = require('mysql')
6
7const connection = mysql.createConnection({
8  host     : 'localhost',
9  user     : 'root',
10  password : '',
11  database : 'vk'
12});
13
14connection.connect()
15
16const bot = new VkBot({
17	token: '',
18	group_id: 189182059
19})
20
21bot.startPolling()
22
23// ЭТО ДАХУЯ РАЗ ИЗМЕНЕННЫЙ КОСТЫЛЬ 
24bot.command('Начать', (ctx) =>{
25    let userID = ctx.message.from_id
26      connection.query(`SELECT id FROM users WHERE ${userID}`, function (err, results) {
27        if (err) throw err;
28        console.log(results)
29
30        if (results.id == userID) {
31          ctx.reply('КУ')
32        }      
33        else {
34          connection.query(`INSERT INTO users (id, balance) VALUES (${userID}, 0)`)
35          ctx.reply('КУ')
36        }
37
38       /* if (results != userID)  {
39          connection.query(`INSERT INTO users (id, balance) VALUES (22, 0)`)
40          ctx.reply('КУ')
41        }
42*/
43      })
44});
45
46/*bot.command('id', (ctx) => {
47	let userId = ctx.message.from_id
48	ctx.reply(`Твой id - ${userId}`)
49	console.log(connection.query('DROP TABLE k'))
50})
51*/
52
53/*bot.command('ку', (ctx) => {
54    let userId = ctx.message.from_id
55    connection.query("ALTER TABLE users ADD UNIQUE KEY id (id)", function (err, result) {
56      if (err) throw err;
57      console.log(result);
58    });
59    ctx.reply('Успешно')
60})
61*/