def register(user_id):
connection = get_connection()
try:
with connection.cursor() as cursor:
result = cursor.execute(
f"SELECT * FROM account WHERE uid={user_id}")
row = cursor.fetchone()
if result != 0:
return '0'
else:
ni = nik()
id = RanID()
cursor.execute(
f"INSERT INTO account(nik, uid, id) VALUES('{ni}', {user_id}, '{id}')"
)
connection.commit()
cursor.execute(f"SELECT * FROM account WHERE uid={user_id}")
row = cursor.fetchone()
cursor.execute(
f"INSERT INTO limitt(limit1, id, limit2, limit3, limit4, limit5, limit6, limit7) VALUES('0', {row[1]}, '0', '0', '0', '0', '0', '0')"
)
connection.commit()
cursor.execute(f"SELECT * FROM account WHERE uid={user_id}")
row = cursor.fetchone()
cursor.execute(
f"INSERT INTO UserAnime(id, pros_count, zap_count, pere_count, look_count, brosh_count) VALUES({row[1]}, '0', '0', '0', '0', '0')"
)
connection.commit()
finally:
connection.close()
def Anime():
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT COUNT(*) FROM Animebd")
return cursor.fetchone()[0]
finally:
connection.close()
def a(id):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM Animebd WHERE id = '{int(id) + 1}'")
row = cursor.fetchone()
return row
finally:
connection.close()
def nik():
count = random.randint(1, 99999)
connction = get_connection()
try:
with connction.cursor() as cursor:
result = cursor.execute(f"SELECT * FROM account WHERE nik={count}")
if str(count) not in str(result):
return f"user{count}"
finally:
connction.close()
def ran_anime(count):
connection = get_connection()
try:
with connection.cursor() as cursor:
ran = random.randint(1, int(count))
cursor.execute(f"SELECT * FROM Animebd WHERE id = '{ran}'")
row = cursor.fetchone()
return row
finally:
connection.close()
def inumimi(text):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM Untitledd WHERE name = 'Инумими'")
row = cursor.fetchone()
two = row[1] + ', ' + text
cursor.execute(f"UPDATE Untitledd SET text = '{two}' WHERE name = 'Инумими'")
connection.commit()
finally:
connection.close()
def check_animebd(name):
connection = get_connection()
try:
with connection.cursor() as cursor:
result = cursor.execute(f"SELECT * FROM Animebd WHERE Поиск = '{name}'")
cursor.fetchone()
if result == 1:
return '1'
else:
return '0'
finally:
connection.close()
def add_studia_anime(text, name):
print(name)
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM Animebd WHERE Названия = '{name}'")
row = cursor.fetchone()[0]
cursor.execute(
f"UPDATE Animebd SET studio = '{text}' WHERE id = '{row}'")
connection.commit()
finally:
connection.close()
def limit_nik(user_id):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM limitt WHERE id={user_id}")
row = cursor.fetchone()[6]
if int(row) == 1:
return '1'
else:
return '0'
finally:
connection.close()
def RanID():
while True:
count = random.randint(1, 999999)
connection = get_connection()
try:
with connection.cursor() as cursor:
result = cursor.execute(
f"SELECT * FROM account WHERE id={count}")
if count != result:
return count
finally:
connection.close()
def name(user_id):
connection = get_connection()
try:
with connection.cursor() as cursor:
if user_id == str:
cursor.execute(f"SELECT * FROM account WHERE nik = {user_id}")
return cursor.fetchone()[0]
else:
cursor.execute(f"SELECT * FROM account WHERE id = {user_id}")
return cursor.fetchone()[0]
finally:
connection.close()
def register(user_id):
connection = get_connection()
try:
with connection.cursor() as cursor:
result = cursor.execute(f"SELECT * FROM admins WHERE uid={user_id}")
row = cursor.fetchone()
if result != 0:
return row
else:
cursor.execute(f"INSERT INTO admins(admin_name, uid) VALUES('{nik()}', {user_id})")
connection.commit()
finally:
connection.close()
def nekomimi():
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM Untitledd WHERE name = 'Некомими'")
row = cursor.fetchone()[1]
print(row)
one = row.split(', ')
print(one)
ran = random.choice(one)
return ran
finally:
connection.close()
def check_two(text):
connection = get_connection()
try:
with connection.cursor() as cursor:
result = cursor.execute(
f"SELECT * FROM Animebd WHERE Поиск = '{text}'")
row = cursor.fetchone()
print(row)
if result == 1:
return row
else:
return '0'
finally:
connection.close()
def check_player_to_in_the_bd(user_id):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM account WHERE uid={user_id}")
id = cursor.fetchone()
print(id)
if user_id in id:
return '1'
else:
return '0'
finally:
connection.close()
def add_box_text_anime(text, name):
print(name)
connection = get_connection()
try:
with connection.cursor() as cursor:
print("+", text)
cursor.execute(f"SELECT * FROM Animebd WHERE Названия = '{name}'")
row = cursor.fetchone()
cursor.execute(
f"UPDATE Animebd SET box_text = '{text}' WHERE id = '{row[0]}'"
)
connection.commit()
finally:
connection.close()
def add_name_anime(text):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT COUNT(*) FROM Animebd")
count = cursor.fetchone()
print(count)
count = int(count[0]) + 1
print(count)
cursor.execute(
f"INSERT INTO Animebd(Названия, id) VALUES('{text}', '{count}')"
)
connection.commit()
finally:
connection.close()
def add_aniback_limit(user, count):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM account WHERE nik = '{user}'")
row = cursor.fetchone()
print(row)
nam = row[2]
num = row[3]
print(nam, num)
num += int(count)
print(nam)
cursor.execute(f"UPDATE account SET money = '{num}' WHERE uid = {nam}")
connection.commit()
finally:
connection.close()
def check_anime(text):
connection = get_connection()
try:
with connection.cursor() as cursor:
result = cursor.execute(f"SELECT COUNT(id) FROM Animebd")
row = cursor.fetchone()
print(result)
print(*row)
for i in range(int(*row)):
print(i)
cursor.execute(f"SELECT Поиск FROM Animebd WHERE id = {i + 1}")
anim = cursor.fetchone()
print(anim)
if text in str(anim).split(', '):
return f"1, {i}"
return '0'
finally:
connection.close()
def set_name(user_id, name):
connection = get_connection()
try:
with connection.cursor() as cursor:
cursor.execute(f"SELECT * FROM account WHERE uid={user_id}")
ro = cursor.fetchone()[1]
cursor.execute(
f"UPDATE account SET nik = '{name}' WHERE uid = {user_id}")
connection.commit()
cursor.execute(f"UPDATE limitt SET limit6 = '1' WHERE id = {ro}")
connection.commit()
cursor.execute(f"SELECT * FROM account WHERE uid={user_id}")
row = cursor.fetchone()
return row[0]
finally:
connection.close()
def id_2(user_id):
connection = get_connection()
try:
with connection.cursor() as cursor:
name_titul = "Тлько начало"
cursor.execute(f"SELECT name_titul FROM Titul WHERE id={user_id}")
tituls = cursor.fetchone()
if name_titul not in str(*tituls):
if tituls != None:
tit = str(*tituls) + ', ' + name_titul
print(tit)
cursor.execute(
f"UPDATE Titul SET name_titul = '{tit}' WHERE id = {user_id}"
)
connection.commit()
else:
cursor.execute(
f"UPDATE Titul SET name_titul = '{name_titul}' WHERE id = {user_id}"
)
connection.commit()
else:
return '0'
finally:
connection.close()
def reset_limit():
connction = get_connection()
