def change90(message):
try:
const.days90 = float(message.text)
bot.send_message(message.chat.id,
"Цена изменена",
reply_markup=markups.adminPanel())
except:
bot.send_message(message.chat.id,
"Неправильный формат",
reply_markup=markups.adminPanel())
def turn_off(call):
db = connect()
cur = db.cursor()
r = "SELECT state, days FROM demo"
cur.execute(r)
state, days = cur.fetchone()
db.close()
if state:
bot.send_message(call.message.chat.id, "Демо режим будет работать для пользователей еще %s дней" % str(days),
reply_markup=markups.adminPanel())
else:
bot.send_message(call.message.chat.id, "Демо режим выключен", reply_markup=markups.adminPanel())
def change_forever(message):
try:
db = connect()
cur = db.cursor()
r = "UPDATE prices SET price=%s WHERE days=0"
cur.execute(r, float(message.text))
db.commit()
db.close()
const.days_forever = float(message.text)
bot.send_message(message.chat.id, "Цена изменена", reply_markup=markups.adminPanel())
except ValueError:
bot.send_message(message.chat.id, "Неправильный формат", reply_markup=markups.adminPanel())
def handle_days(message):
try:
days = int(message.text)
db = connect()
cur = db.cursor()
r = "UPDATE demo SET state = 1"
cur.execute(r)
r = "UPDATE demo SET days = %s"
cur.execute(r, days)
r = "SELECT uid FROM users"
cur.execute(r)
ids = cur.fetchall()
today = str(datetime.datetime.now()).split(' ')[0]
end_day = str(parser.parse(today) + datetime.timedelta(days=days)).split(' ')[0]
for user in ids:
r = "SELECT * FROM payments WHERE uid = (%s)"
cur.execute(r, user)
if cur.fetchone():
continue
else:
request = "INSERT INTO payments (uid, end_date) VALUE (%s,%s)"
cur.execute(request, (user, end_day))
time.sleep(0.1)
db.commit()
db.close()
bot.send_message(message.chat.id, "Демо режим включен для всех пользователей на %s дней" % message.text,
reply_markup=markups.adminPanel())
except ValueError:
bot.send_message(message.chat.id, "Неправильный формат")
def confirm_date(message):
if len(message.text) == 10:
date = message.text.replace(".", "-")
db = connect()
cur = db.cursor()
r = "SELECT * FROM payments WHERE uid = %s"
cur.execute(r, const.chosenUserId)
if not cur.fetchone():
r = "INSERT INTO payments (end_date, uid) VALUE (%s,%s)"
else:
r = "UPDATE payments SET end_date = %s WHERE uid = %s"
cur.execute(r, (date, const.chosenUserId))
db.commit()
db.close()
bot.send_message(message.chat.id, "Срок подписки изменен", reply_markup=markups.adminPanel())
else:
bot.send_message(message.chat.id, "Неправильный формат ввода", reply_markup=markups.adminPanel())
def turn_on_demo(call):
db = connect()
cur = db.cursor()
r = "SELECT state from demo"
cur.execute(r)
state = int(cur.fetchone()[0])
if state:
bot.send_message(call.message.chat.id,
"Демо режим уже включен",
reply_markup=markups.adminPanel())
else:
msg = bot.send_message(
call.message.chat.id,
"Введите количество дней, на которое хотите включить")
bot.register_next_step_handler(msg, handle_days)
def admin2(call):
bot.edit_message_text("Админ-панель", call.message.chat.id, call.message.message_id)
bot.edit_message_reply_markup(call.message.chat.id, call.message.message_id, reply_markup=markups.adminPanel())
def admin(message):
if message.chat.id in const.admin:
bot.send_message(message.chat.id, "Админ-панель", reply_markup=markups.adminPanel())