Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def bd(message, num):
- print('test 2')
- conn = sqlite3.connect("telegram_group.db")
- cursor = conn.cursor()
- nick = message.from_user.first_name
- print('test 5', message.from_user.id)
- user_id = message.from_user.id
- now = datetime.datetime.now()
- sql = f"SELECT * FROM users WHERE user_id = '{user_id}'"
- result = ''
- for result in cursor.execute(sql):
- print(result)
- sql = f"""
- SELECT last_message_date FROM users
- WHERE last_message_date <= '{now.year}-{now.month}-{now.day - 14}';
- """
- for old in cursor.execute(sql):
- print(old)
- print(old[0])
- sql = f"""
- SELECT count(id) FROM users;
- """
- for count in cursor.execute(sql):
- print(count)
- print(count[0])
- if not result:
- # Если нету в БД
- if not num:
- bot.kick_chat_member(message.chat.id, '{kickid}'.format(kickid=message.from_user.id))
- else:
- sql = f"""
- INSERT INTO users
- VALUES ({count[0]}, '{nick}', '{user_id}', '{now.year}-{now.month}-{now.day}');
- """
- cursor.execute(sql)
- conn.commit()
- group(message)
- else:
- # Если уже есть
- sql = f"""
- UPDATE users
- SET nick_name = '{nick}', last_message_date = '{now.year}-{now.month}-{now.day}'
- WHERE user_id = '{user_id}';
- """
- cursor.execute(sql)
- conn.commit()
- group(message)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement