async def num_start_message(client: Client, message: Message):
START_OTHER_USERS_TEXT = """⭕ Hello, {}! To get started, Send /mod and the name of the APK that you want MODDED. I will perform a search in moddingunited.xyz for you & give you the results quickly..\n\n⚠️ Make sure you Enter the name of the app correctly with no spelling mistakes 😁\n\n🥰You can also add me to your group and i'll send modded apps there!\nFor more info, type /help!""".format(
message.from_user.first_name)
await message.reply_text(START_OTHER_USERS_TEXT, quote=True)
q = check_user_in_db(message.from_user.id)
if q == False:
add_user_to_db(message.from_user.id, message.from_user.first_name,
message.from_user.username)
rows = int(SESSION.query(func.count(Users.chat_id)).scalar()) + 1753
print(rows)
await client.send_message(
chat_id=-499255509,
text="🆕 New User!\nTotal: {}\nName: {}".format(
rows, message.from_user.first_name))
print("🆕 New User!\nTotal: {}\nName: {}\nUsername: {}".format(
rows, message.from_user.first_name, message.from_user.username))
SESSION.close()
else:
print('User in DB.')
SESSION.close()
def rem_suggestions(id):
suggestion = SESSION.query(suggs).get(id)
SESSION.delete(suggestion)
SESSION.commit()
def get_suggestions_id(get_id):
try:
return SESSION.query(suggs).get(str(get_id))
finally:
SESSION.close()
def get_suggestions():
try:
return SESSION.query(suggs).all()
finally:
SESSION.close()
def add_suggestion(id, suggestion):
suggestion = suggs(str(id), suggestion)
SESSION.add(suggestion)
SESSION.commit()
def get_user_id(message_id):
try:
s__ = SESSION.query(Users).get(str(message_id))
return int(s__.chat_id), s__.um_id
finally:
SESSION.close()
def add_user_to_db(message_id, chat_id, um_id):
__user = Users(message_id, str(chat_id), um_id)
SESSION.add(__user)
SESSION.commit()
def rem_bugs(id):
bug = SESSION.query(bugs).get(id)
SESSION.delete(bug)
SESSION.commit()
def get_bug_id(get_id):
try:
return SESSION.query(bugs).get(str(get_id))
finally:
SESSION.close()
def get_bugs():
try:
return SESSION.query(bugs).all()
finally:
SESSION.close()
def add_bug(id, bug):
bug = bugs(str(id), bug)
SESSION.add(bug)
SESSION.commit()