def login(res_path):
if res_path=="/login.html":
with open('static'+res_path,'rb') as r_file:
respone_content = r_file.read()
return respone_content
else:
re_data = re.findall(r"\/login\?(.*)", res_path)
data_list = re_data[0].split("&")
data_dict = dict([data_list[0].split("="), data_list[1].split("=")])
username = data_dict["username"]
password = data_dict["password"]
print(">>>>>>>>>>>",username,password)
# 用户填写的数据不全的时候
if not all([username, password]):
print("用户请求的数据不完成")
respone_content=index("/nothings.html")
return respone_content
result=db.get_info(username,password)
if result:
respone_content=index("/index.html")
return respone_content
else:
db.insert_info((username, password))
print("注册成功------" + username + "------" + password)
respone_content = index("/registered.html")
return respone_content
def GET(self):
int_id = web.input().IntID
kwargs = db.get_info(int_id)
timings = self.calcYAR(kwargs)
self.calcPed(kwargs, timings)
render = web.template.render("templates")
return render.output(kwargs, timings)
def alarm_contact_info_email_post():
"""
Generate email with link to confirm.
:return:
"""
# TODO: Authenticate Isadore Instance
# TODO: Limit number of times can confirm?
# TODO: Confirm expire date?
# TODO: Implement
info = db.get_info(email=email)
oneday = datetime.timedelta(days=1)
if info["email_verify"]:
last_try_date = info["email_verify"]["last_try"]
if datetime.datetime.now() - last_try_date < oneday:
abort(400)
confirm_code = hashlib.sha1()
confirm_code.update(os.urandom(24))
confirm_code = confirm_code.hexdigest()
email_verify = {"last_try": datetime.datetime.now(), "confirm_code": confirm_code}
db.update_info(info_update=email_verify, email=email)
urlparams = urllib.urlencode({"email": email, "confirm_code": email_verify["confirm_code"]})
msgtxt = twiml_messages.email_verify_txt % (urlparams, email_verify(["confirm_code"]))
msghtml = twiml_messages.email_verify_html % (urlparams, urlparams, email_verify["confirm_code"])
messaging.sendEmail(toemail=email, fromemail='*****@*****.**', messageTXT=msgtxt, messageHTML=msghtml)
return ('Sent', 204)
def showInfo():
# 取个人信息
glo_userID = glo.get_value('glo_userID')
glo_identity = glo.get_value('glo_identity')
# logger.info("<全局变量> glo_userID:"+glo_userID+" glo_identity:"+glo_identity)
db_info = db.get_info(glo_userID, glo_identity)
logger.info("<数据库传回> " + str(db_info))
return render_template('myinfo.html', identity=glo_identity, info=db_info)
def get_action(maze_id, action_id):
world = db.get_world(maze_id)
if action_id > world.client_counter:
world.client_counter = action_id
db.save_world(maze_id, world)
info = db.get_info(maze_id, action_id)
print "GETTING", maze_id, action_id
return info
def get_action(maze_id,action_id):
world = db.get_world(maze_id)
if action_id > world.client_counter:
world.client_counter = action_id
db.save_world(maze_id, world)
info = db.get_info(maze_id, action_id)
print "GETTING", maze_id, action_id
return info
def actions(bot, update):
global add_adm
# print(add_adm)
if add_adm:
if update.message.text == '/cancel':
add_adm = False
else:
for row in db.get_info():
if row[1] == update.message.text:
admins.add_message(row[0], row[1])
update.message.reply_text(str(update.message.text) + ' теперь админ.')
add_adm = False
return
update.message.reply_text('Неправильный username.')
global del_adm
if del_adm:
if update.message.text == '/cancel':
del_adm = False
else:
for row in db.get_info():
if row[1] == update.message.text:
if update.message.text != 'kirr_ya':
admins.del_message(row[0], row[1])
del_adm = False
update.message.reply_text(str(update.message.text) + ' теперь НЕ админ.')
return
update.message.reply_text('Неправильный username.')
global broad
if broad:
if update.message.text == '/cancel':
broad = False
else:
for row in db.get_info():
try:
bot.send_message(row[0], update.message.text)
except:
pass
broad = False
def index():
user_name = request.form.get('uname')
password = request.form.get('psw')
login_success = False
if user_name:
results = db.get_info(user_name, password)
login_success = bool(results)
if login_success:
return render_template('result.html', results=results)
else:
return render_template('index.html', user_name=user_name)
def lk(lktype, username, pwd, fields="", result_text="", additional=""):
return '''
<div hidden="true" id="card" class="lk-card">
<h1>Personal page</h1><br>
<p id="''' + lktype + '''" username="******" cookie="''' + pwd + '''"></p>
<p>Hello, ''' + db.get_info(
username, 'fullname') + '''! That's your personal employee page.</p>
<form id="select_from_employee_table" method="post">
<p>Please check if information in your personal card is correct. Following information is available: ''' + fields + '''</p>
<p><input type=text name=field placeholder="What do you want to search">
<p><input type=submit value=Search>
<p id="main_text">''' + result_text + '''</p>
</form>''' + additional + '''
def alarm_contact_confirm_sms_put():
"""
Confirm phone that was done through SMS.
:return:
"""
# TODO: Authenticate Isadore Instance
# TODO: Limit number of times can confirm?
# TODO: Confirm expire date?
info = db.get_info(phone=phone)
oneday = datetime.timedelta(days=1)
if info["phone_verify"] and info["phone_verify"]["last_try"] < oneday:
verify_key = request.form.get("confirm_code")
if info["phone_verify"]["confirm_code"] == verify_key:
db.set_verified(phone=phone)
return ('Verified', 204)
abort(400)
def alarm_contact_info_confirm_voice():
"""
Generate confirm code and send call voice phone number.
:return:
"""
# TODO: Authenticate Isadore Instance
# TODO: Limit number of times can confirm?
# TODO: Confirm expire date?
# TODO: Implement
info = db.get_info(phone=phone)
oneday = datetime.timedelta(days=1)
if info["phone_verify"]:
last_try_date = info["phone_verify"]["last_try"]
if datetime.datetime.now() - last_try_date < oneday:
abort(400)
phone_verify = {"last_try": datetime.datetime.now(), "confirm_code": None}
db.update_info(info_update=phone_verify, phone=phone)
messaging.makeCall(phone, 'https://alarms.example.com/alarm_contact_info_phone/confirm/voice2')
return ('Sent', 204)
def start(bot, update):
# print(update)
# print(update.message.chat.id)
user_id = update.message.chat.id
username = update.message.chat.username
update.message.reply_text(
"Держи свой чек-лист:\ndrive.google.com/fsjsdfjsjfkjs\n\n"
+ "Телеграм-канал, где Инна делится инсайтами по финансовой грамотности:\n\n"
+ "t.me/test_channel12312")
flag = False
for row in db.get_info():
if row[0] == user_id:
flag = True
if not flag:
db.add_message(int(user_id), username)
def alarm_contact_confirm_sms_post():
"""
Generate confirm code and send out confirm sms message.
:return:
"""
# TODO: Authenticate Isadore Instance
# TODO: Limit number of times can confirm?
# TODO: Confirm expire date?
# TODO: Implement
info = db.get_info(phone=phone)
oneday = datetime.timedelta(days=1)
if info["phone_verify"]:
last_try_date = info["phone_verify"]["last_try"]
if datetime.datetime.now() - last_try_date < oneday:
abort(400)
phone_verify = {"last_try": datetime.datetime.now(), "confirm_code": random.randint(100000, 999999)}
db.update_info(info_update=phone_verify, phone=phone)
msg = twiml_messages.sms_verify % (phone_verify["confirm_code"])
messaging.sendTxt(phone, msg)
return ('Sent', 204)
def get_text_messages(message):
s = message.text
if s == "🔥 Номера":
bot.send_message(message.chat.id, "Пожалуйста, выберете для каких целей вы хотите арендовать номер", reply_markup=num())
elif s == "🆘 Правила":
bot.send_message(message.chat.id, "1. Главное:\n1.1 Мы продаем номера, без инструкций к их использованию. Вся ответственность после покупки номеров только на вас.\n1.2 Если комментарий при оплате был указан неверно, администрация имеет полное право не делать замену\n1.3 Администрация оставляет за собой право вносить любые изменения и дополнения в Правила, без предупреждения!\n1.4 Администрация вправе обнулить ваш лицевой счет.\n\nФОРМА ОБРАЩЕНИЯ\n1) Переписка с ботом + скрины переписки + скрин оплаты\n2) Предоставляйте видеозапись проверки номера с момента покупки в магазине и проверки на офф.сайте сервиса, который купили. Видео должно быть одно и цельное. ( ОБЯЗАТЕЛЬНО ) Отклонения от формы будут игнорироваться!!!", reply_markup=menu())
elif s == "💰 Баланс":
b = db.get_balance(message.chat.id)
s = int(b) if int(b) == float(b) else float(b)
bot.send_message(message.chat.id, "Ваш баланс: " + str(s) + 'р.', reply_markup=balance())
bot.register_next_step_handler(message, money)
elif s == '💩 Помощь':
bot.send_message(message.chat.id, 'Обратитесь к @freddy_support ', reply_markup=menu())
elif s == "↪ В главное меню ↩":
bot.send_message(message.chat.id, "Вы в главном меню", reply_markup=menu())
elif s == "💼 Мой профиль":
lst = db.get_info(message.chat.id)
bot.send_message(message.chat.id, 'id: {}\nКоличество заказов: {}шт. \nСумма всех ваших покупок: {}р.'.format(message.chat.id, len(lst), sum(lst)))
else:
bot.send_message(message.chat.id, 'Воспользуйтесь клавиатурой', reply_markup=menu())
def found_result(username, text):
return text + " found for user " + username + ": " + str(
db.get_info(username, text))
def GET(self):
int_id = web.input().IntID
kwargs = db.get_info(int_id)
location = db.get_info()["location"]
render = web.template.render("templates", globals={"map": map, "str": str, "zip": zip})
return render.intersection(kwargs, location)
def GET(self):
render = web.template.render("templates")
location = db.get_info()["location"] or "Unknown"
return render.home(location)
def users_list(bot, update):
if check_for_admin(bot, update):
for row in db.get_info():
update.message.reply_text(row)
def alarm_contact_info():
# TODO: Authenticate
info = db.get_info(email=email)
return responseJSON(info[1])
# some_file.py
import sys
# insert at 1, 0 is the script path (or '' in REPL)
sys.path.insert(1, '/home/thelyolya/source/insecure/src/py')
import db
db.initialize_db("/home/thelyolya/source/insecure/test/test.db")
fields = db.get_available_fields_list()
signums = db.get_all_signums_list()
for user in signums:
for field in fields:
print(db.get_info(user, field))
print(db.get_info("demo", """ * FROM employee -- """))
def alarm_contact_info():
# TODO: Authenticate Isadore instance
info = db.get_info(phone=phone)
return responseJSON(info[1])
