def run(url, environ, start_response): #start_response(b'200 OK', [(b'Content-Type', b'text/html')]) import cgi header_set = False msg = "<div class='readable'>" fname = "" form = cgi.FieldStorage(fp=environ['wsgi.input'], environ=environ, keep_blank_values=True) try: exists = False lg = form['logname'].file.read().translate(str.maketrans({"'": r"''"})) pw = form['passwrd'].file.read().translate(str.maketrans({"'": r"''"})) #msg += str(lg) + "<br>" #msg += str(pw) + "<br>" cu = myu.get_conn().cursor() cu.execute("SELECT id FROM usersdata WHERE name = '" + (lg) + "'") #cu.execute("SELECT * FROM usersdata WHERE id > 20") try: for ln in cu: exists = True break except Exception as inst: msg += "Error?<br>" #msg += lg + "<br>" #msg += pw + "<br>" if exists: msg += "Sorry, such user already exists. *weeps in corner*" else: cu.execute("INSERT INTO usersdata (name, pass_word) VALUES ('" + (lg) + "','" + (pw) + "')") cu.commit() header_set = myu.usr_login(lg, pw, start_response) msg += myu.gen_logmsg(header_set, lg) except Exception as inst: #msg += "<br>ERROR-1: " + str(inst) msg += "Error occured. A doggo died!" + "<br>ERROR-1: " + str(inst) msg += "</div>" #msg += "<div><a href='pages/login.html'><button>← Back</button></a></div>" try: msg = myu.get_insides("assets/header.html") + msg msg += myu.get_insides("assets/bottom.html") except Exception as inst: msg += "<br>ERROR-2: " + str(inst) if not header_set: start_response(b'200 OK', [(b'Content-Type', b'text/html')]) return msg
def run(url, env, start_response): myu.cooker(start_response, 'id', '12', 1 / 24.0) result = "" result += myu.get_insides("assets/header.html") result += myu.get_insides("assets/bottom.html") return result
def run(url, env, start_response): start_response(b'200 OK', [(b'Content-Type', b'text/html')]) result = "" result += myu.get_insides("assets/header.html") result += "<form action='/answer.py' method='post' enctype='multipart/form-data'>" result += "<div class='readable'>" try: conn = myu.get_conn() cu1 = conn.cursor() cu1.execute("SELECT TOP 1 * FROM questions_answers ORDER BY NEWID()") for row in cu1: quid = myu.get_sqlval(row, 0) result += myu.get_sqlval(row, 1) + "<br><hr/>" #result += myu.get_sqlval(row, 4) + "<br>" catid = myu.get_sqlval(row, 2) truid = myu.get_sqlval(row, 3) #result += myu.get_sqlval(str(row), 3) + "<br>" #result += "<hr/>" + str(row) + "<br>" all_ans = [] cu_answ = myu.get_conn().cursor() cu_anst = myu.get_conn().cursor() cu_answ.execute("SELECT TOP 3 * FROM answers WHERE id_category = " + catid + " AND NOT id = " + truid + " ORDER BY NEWID()") cu_anst.execute("SELECT * FROM answers WHERE id = " + truid) for row_ans in cu_anst: all_ans.append({"txt": myu.get_sqlval(row_ans, 1), "id": myu.get_sqlval(row_ans, 0)}) for row_ans in cu_answ: all_ans.append({"txt": myu.get_sqlval(row_ans, 1), "id": myu.get_sqlval(row_ans, 0)}) random.shuffle(all_ans) for ans in all_ans: result += "<input type='radio' id='" + str(ans["id"]) + "' name='ans_id' value='" + str(ans["id"]) + "'>" result += "<label for='" + str(ans["id"]) + "'>" + str(ans["txt"]) + "</label><br>" #result += "<br>" + str(ans["txt"]) result += "<br>" result += "<input style='display: none;' id='answer' type='text' value='"+quid+"' name='que_id'>" except Exception as inst: result += "<br>ERROR-1: " + str(inst) result += "</div>" result += "<div class='centered'>" result += "<input id='answer' type='submit' value='Answer' name='submit'>" result += "</div>" result += "</form>" result += myu.get_insides("assets/bottom.html") return result
def run(url, environ, start_response): start_response(b'200 OK', [(b'Content-Type', b'text/html')]) import cgi msg = "<div class='readable'>" fname = "" #form = cgi.FieldStorage(fp=environ['wsgi.input'], environ=environ, keep_blank_values=True) form = myu.get_form(environ) catid = "" try: fname = load(form) if fname != "": catid = myu.get_posttxt(form, "catid") resp = azurimg(fname) tbl = gen_tbl(resp) if not "Sorry" in tbl: msg += gen_shame(resp, catid) msg += tbl #os.remove(fname) except Exception as inst: #msg += "<br>ERROR-1: " + str(inst) msg += "Error occured. Please try loading the file again!" + "<br>ERROR-1: " + str( inst) msg += "</div>" if catid == "": msg += "<div><a href='pages/upload_image.html'><button>← Back</button></a></div>" else: msg += "<div><a href='pages/task.html'><button>← Back</button></a></div>" try: msg = myu.get_insides("assets/header.html") + msg msg += myu.get_insides("assets/bottom.html") except Exception as inst: msg += "<br>ERROR-2: " + str(inst) return msg
def run(url, environ, start_response): start_response(b'200 OK', [(b'Content-Type', b'text/html')]) result = "" result += myu.get_insides("assets/header.html") result += "<div class = 'readable'>" form = myu.get_form(environ) result += myu.get_posttxt(form, "catid") #result += myu.get_posttxt(environ, "blahblah") result += myu.get_posttxt(form, "tst1") result += myu.get_posttxt(form, "tst2") result += "</div>" result += myu.get_insides("assets/bottom.html") return result
def run(url, env, start_response): start_response(b'200 OK', [(b'Content-Type', b'text/html')]) uid = myu.get_cookie(env, 'id') psw = myu.get_cookie(env, 'passwd') cu = myu.get_conn().cursor() cu.execute("SELECT name,e,series FROM usersdata WHERE id = '" + (uid) + "' AND pass_word = '" + (psw) + "'") msg = myu.get_insides("assets/header.html") msg += "<div class='readable'>" if cu.rowcount != 0: row = cu.fetchone() nm = myu.get_sqlval(row, 0) sc = myu.get_sqlval(row, 1) st = myu.get_sqlval(row, 2) msg += "<b>You are: </b>" + nm + "<br>" msg += "<b>Score: </b>" + sc + "<br>" msg += "<b>Strike: </b>" + st + "<br>" cu.execute("SELECT COUNT(id) FROM usersdata WHERE e > " + sc) plc = 0 if cu.rowcount != 0: cnt = cu.fetchone() plc = int(myu.get_sqlval(cnt, 0)) msg += "<b>Your place: </b>" + str(plc + 1) + "<br>" try: cu.execute( "SELECT TOP 10 name,e,series FROM usersdata ORDER BY e DESC") msg += "<br>" msg += "<table>" msg += "<tr class='header'>" msg += "<th class='header'>Name</th>" msg += "<th class='header'>Score</th>" msg += "<th class='header'>Strike</th>" msg += "</tr>" for row in cu: msg += "<tr>" msg += "<th>" msg += myu.get_sqlval(row, 0) msg += "</th>" msg += "<th>" msg += myu.get_sqlval(row, 1) msg += "</th>" msg += "<th>" msg += myu.get_sqlval(row, 2) msg += "</th>" msg += "</tr>" msg += "</table>" except Exception as inst: msg += "<br>ERROR: " + str(inst) msg += "</div>" msg += myu.get_insides("assets/bottom.html") return msg