· 4 years ago · May 18, 2021, 05:22 PM
1import telebot
2from random import randint
3from random import choice
4import sqlite3
5
6
7
8bot = telebot.TeleBot("1623151197:AAF47y5y7nq5DMwCmLde8wJ-7_2PgRuF4WE")
9
10
11
12@bot.message_handler( commands = ["anonim"] )
13def start_anonim(message):
14 with sqlite3.connect("anonimus.db") as db:
15 cursor = db.cursor()
16 cursor.execute(f""" SELECT id3 FROM name_id WHERE id3 = {message.from_user.id} """)
17 if cursor.fetchall():
18
19 mes = bot.send_message(message.from_user.id, ".")
20 bot.register_next_step_handler(mes, sending)
21
22 else:
23 bot.send_message(message.from_user.id, "Вас нет в базе данных! Зарегистрируйтесь, с помощью команды <a>/sign</a>.", parse_mode = "html")
24
25
26@bot.message_handler(commands = ["sign"])
27def eeeee(message):
28 with sqlite3.connect("anonimus.db") as db:
29 cursor = db.cursor()
30 cursor.execute(f""" SELECT id3 FROM name_id WHERE id3 = {message.from_user.id} """)
31
32 if cursor.fetchall():
33 bot.send_message(message.from_user.id, "Вы уже зарегистрированы!")
34 else:
35
36 rett = bot.send_message(message.from_user.id, "Введи свое имя:")
37 bot.register_next_step_handler(rett, reg)
38
39
40def reg(message):
41 with sqlite3.connect("anonimus.db") as db:
42 cursor = db.cursor()
43 listt = [message.text, message.from_user.id]
44 cursor.execute(""" CREATE TABLE IF NOT EXISTS name_id (name3 TEXT, id3 INTEGER) """)
45
46 cursor.execute(""" INSERT INTO name_id VALUES (?, ?); """, listt)
47 bot.send_message(message.from_user.id, f"Вы успешно зарегистрировались под именем {message.text}!")
48
49
50def sending(message):
51 with sqlite3.connect("anonimus.db") as db:
52 cursor = db.cursor()
53 cursor.execute(""" SELECT id3 FROM name_id """)
54 iop = []
55 listen = cursor.fetchall()
56
57 for ii in range(len(listen)):
58 iop.append(listen[ii][0])
59 ran_id = choice(iop)
60
61 while ran_id == message.from_user.id:
62 ran_id = choice(iop)
63
64 bot.send_message(ran_id, f"{message.from_user.first_name}: {message.text}")
65 start_anonim(message)
66
67
68 db.commit()
69
70
71bot.polling()