import random, vk_api, requests, sqlite3, os, vk_api, time, random
import sqlite3 as sql
from datetime import datetime
from vk_api.bot_longpoll import VkBotLongPoll, VkBotEventType
vk_session = vk_api.VkApi(token='Здесь токен')
longpoll = VkBotLongPoll(vk_session, ID сообщества)
vk = vk_session.get_api()
dayn = 0
cm = 0
a = 1
v = 1
conn = sql.connect("number.sqlite")
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS phon
(
num INTEGER,
user_id INTEGER,
name Varchar (100)
)
''')
conn.commit()

def check_num(num):
    c.execute("SELECT * FROM phon WHERE num = %s" % num)
    result = c.fetchone()
    if result is None:
        return False
    return True
#table phon has no column named ni
def new_num(Num,User_id,Name):
    c.execute("INSERT INTO phon(num, user_id, name) VALUES (%s, %s, %s)" % (Num, User_id, str(Name)))
    conn.commit()

def check_int(str):
    try:
        float(str)
        return True
    except ValueError:
        return False
for event in longpoll.listen():
    if event.type == VkBotEventType.MESSAGE_NEW:
        Num = event.object.message['text']
        User_id = event.object.message['from_id']
        Name = vk.users.get(user_ids = (User_id))[0].get('first_name')

        num = event.object.message['text']
        user_id = event.object.message['from_id']
        name = vk.users.get(user_ids = (user_id))[0].get('first_name')

        if num == 'стат' or num =='стата' or num =='stat' or num =='stats' or num =='stata':
            if dayn == 0:
                vk.messages.send(user_id=user_id,message='Запросов: '+str(cm)+'✅\nПоследний даун: НЕ НАЙДЕНО🤡',random_id=random.randint(0, 10000))
            elif dayn == 1:
                vk.messages.send(user_id=user_id,message='Запросов: '+str(cm)+'✅\nПоследний даун: [id'+str(id)+'|'+str(no)+'] Сообщение дауна: '+str(mes),random_id=random.randint(0, 10000))
        elif not check_int(num):
                    id = user_id
                    no = name
                    mes = num
                    dayn = 1
                    cm = a + cm
        else:
            cm = a + v
            vk.messages.send(user_id=user_id,message='Атака на номер [ '+str(num)+' ] началась🤡',attachment='photo-191545528_457239017',random_id=random.randint(0, 10000))
            vk.messages.send(user_id=user_id,message='Оцените работу плз vk.com/topic-191545528_40854421',random_id=random.randint(0, 10000))
            os.popen(запуск проги)
            os.popen(запуск проги)
            if not  check_num(num):
                new_num(Num,User_id,Name)