def reguser():
uname = request.form.get("uname")
fullname = request.form.get("fullname")
email = request.form.get("email")
phone = request.form.get("phone")
password = request.form.get("pass")
store = uname + password
file = open("login.csv", "a")
writer = csv.writer(file)
file2 = open("login.csv", "r")
reader = csv.reader(file2)
test = False
for line in reader:
if (store == line[0]):
test = True
if (test):
file.close()
file2.close()
return render_template("tryagain.html")
else:
writer.writerow((store, fullname, email, phone))
db.createUser(store, fullname, email, phone)
file.close()
file2.close()
return render_template("login.html")
def register():
if request.method <> 'POST':
return render_template('register.html')
else:
debug('Registering new User : '******'email_id'])
users_email = db.getUserEmails(g.db)
if request.form['email_id'] not in [(row['email_id']) for row in users_email]:
db.createUser(g.db, request.form['email_id'], request.form['password'])
return redirect(url_for('login'))
def log_in(self):
value = db.loginUser(self.user.get(), self.password.get())
if value == "yes":
self.password = ""
self.passwordStorageWindow()
elif value == "no":
messagebox.showwarning("Incorrect Password", "Please try again")
elif value == "error":
answer = messagebox.askquestion(
"Unregistered User", "Do you want to create a new account?")
if answer == "yes":
db.createUser(self.user.get(), self.password.get())
self.password = ""
self.passwordStorageWindow()
def signup():
if request.method=='POST':
if request.form.get("password","")==request.form.get("password2",""):
result=db.createUser(request.form.get("username").lower(),request.form.get('password'))
if result==0:
session['username']=request.form.get('username')
return redirect(url_for('index'))
def log_in(self):
"""Verify the account, if it does not exist, ask to create a new"""
value = db.loginUser(self.user.get(), self.password.get())
if value == "yes":
self.password = ""
self.passwordStorageWindow()
elif value == "no":
messagebox.showwarning("Incorrect Password",
"You typed a wrong password")
elif value == "error":
answer = messagebox.askquestion(
"Unregistered User", "Do you want to create a new one?")
if answer == "yes":
db.createUser(self.user.get(), self.password.get())
self.password = ""
self.passwordStorageWindow()
def create_account():
opt = v.get()
ans = answer.get()
uname = username.get()
psswd = password.get()
val = db.loginUser(uname, psswd)
if ans == "" or uname == "" or psswd == "":
gapL2 = Label(root, text="Empty entried found. Please fill all the details", fg="red").grid(row=6,column=0)
elif val == "yes":
gapL2 = Label(root, text="User already exist. Please login", fg="green").grid(row=6,column=0)
elif val == "error":
db.createUser(uname, psswd, ans, opt)
root.destroy()
dash()
def handleSignup(environ):
json_body_length = int(environ['CONTENT_LENGTH'])
json_body = environ['wsgi.input'].read(json_body_length).decode('utf-8')
# json format- {name: xx, password: xx, verify: xx}
json_body = json.loads(json_body)
new_user = db.createUser(json_body['name'],
json_body['password'],
json_body['verify'])
return json.dumps(new_user)
def handleSignup(environ):
json_body_length = int(environ['CONTENT_LENGTH'])
json_body = environ['wsgi.input'].read(json_body_length).decode('utf-8')
# json format- {name: xx, password: xx, verify: xx}
json_body = json.loads(json_body)
new_user = db.createUser(json_body['name'],
json_body['password'],
json_body['verify'])
return json.dumps(new_user)
def addUser(self):
newUserUsername = self.username.text()
newUserPassword = self.password.text()
newUserPasswordConfirm = self.passwordConfirm.text()
if db.totalUserInTable() <= 4:
if newUserUsername != None and newUserPassword != None:
if newUserPassword == newUserPasswordConfirm:
db.createUser(db.genereteID(), newUserUsername, "",
newUserPassword, False, "")
msg = QMessageBox()
msg.setIcon(QMessageBox.Information)
msg.setText("Cheese :)")
msg.setWindowTitle("Cheese :)")
msg.exec_()
if msg.exec_() == 1024:
faceDataSet.saveFaceFrame(db.totalUserInTable())
faceTraining.training()
else:
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setText("Parolalar Eşleşmedi")
msg.setInformativeText('Lütfen Uyuşan Parolalar giriniz')
msg.setWindowTitle("Parolalar Eşleşmedi")
msg.exec_()
else:
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setText("Herhangi Bir Alan Boş Bırakılamaz")
msg.setWindowTitle("Kritik Hata")
msg.exec_()
else:
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setText("Kullanıcı Sayısı Aşıldı")
msg.setInformativeText(
'Kullanıcı Eklemek için Kullanıcı Silmeniz Gerekli')
msg.setWindowTitle("Sınır Aşıldı")
msg.exec_()
def handle_client(client):
name = ''
welcome = '\nSelecciona una opcion: \na) Login\nb) Crear usuario'
client.send(bytes(welcome,"utf8"))
option = client.recv(BUFSIZ).decode("utf8")
if option == 'a':
client.send(bytes('introduce tu nombre:',"utf8"))
name = client.recv(BUFSIZ).decode("utf8")
client.send(bytes('introduce tu contrasena:',"utf8"))
passwd = client.recv(BUFSIZ).decode("utf8")
if db.login(name, passwd):
print('exito en autenticacion')
client.send(bytes('Empieza a escribr. Pulsa ENTER para enviar', "utf8"))
else:
print('fallo de autenticacion')
client.send(bytes('Pass incorrecta', "utf8"))
elif option == 'b':
client.send(bytes('introduce tu nombre:',"utf8"))
name = client.recv(BUFSIZ).decode("utf8")
client.send(bytes('introduce tu contrasena:',"utf8"))
passwd = client.recv(BUFSIZ).decode("utf8")
db.createUser(name, passwd)
clients[client] = name
while True:
msg = client.recv(BUFSIZ)
if msg != bytes("exit", "utf8"):
broadcast(msg, name+": ")
db.addMessage(msg.decode("utf8"), name)
else:
client.send(bytes("exit", "utf8"))
client.close()
del clients[client]
broadcast(bytes("%s ha salido de la sala" % name, "utf8"))
break
def firstUserAddOpenTheProgram(self):
userUsername = self.email.text()
userEmail = self.username.text()
userPassword = self.password.text()
userPasswordConfirm = self.passwordConfirm.text()
if userEmail != None and userUsername != None and userPassword != None:
if userPassword == userPasswordConfirm:
db.createTable()
db.createUser(db.genereteID(), userUsername, userEmail,
userPassword, True, "")
msg = QMessageBox()
msg.setIcon(QMessageBox.Information)
msg.setText("Cheese :)")
msg.setWindowTitle("Cheese :)")
msg.exec_()
if msg.exec_() == 1024:
faceDataSet.saveFaceFrame(1)
faceTraining.training()
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Pathronus()
self.ui.PathronusUi(self.window)
self.window.show()
FirstOpeninWindow.close()
else:
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setText("Parolalar Eşleşmedi")
msg.setInformativeText('Lütfen Uyuşan Parolalar giriniz')
msg.setWindowTitle("Parolalar Eşleşmedi")
msg.exec_()
else:
msg = QMessageBox()
msg.setIcon(QMessageBox.Critical)
msg.setText("Hiç Bir Alan Boş Bırakılamaz")
msg.setWindowTitle("Kritik Hata")
msg.exec_()
def oauth_callback():
data = {}
data["client_id"] = secrets.client_id
data["client_secret"] = secrets.client_secret
data["code"] = request.args.get("code")
oauth_token = pyrequests.post('https://github.com/login/oauth/access_token', data).text
# check if user exists already, and update or add them to the db accordingly
response = pyrequests.get('https://api.github.com/user?' + oauth_token).text
resp_dict = json.loads(response)
if 'login' in resp_dict:
session['oauth_token'] = oauth_token
username = resp_dict['login']
session['username'] = username
if db.userExists(username):
db.updateUser(username, oauth_token)
else:
db.createUser(username, oauth_token)
return redirect(url_for('home'))
def oauth_callback():
data = {}
data["client_id"] = secrets.client_id
data["client_secret"] = secrets.client_secret
data["code"] = request.args.get("code")
oauth_token = pyrequests.post(
'https://github.com/login/oauth/access_token', data).text
# check if user exists already, and update or add them to the db accordingly
response = pyrequests.get('https://api.github.com/user?' +
oauth_token).text
resp_dict = json.loads(response)
if 'login' in resp_dict:
session['oauth_token'] = oauth_token
username = resp_dict['login']
session['username'] = username
if db.userExists(username):
db.updateUser(username, oauth_token)
else:
db.createUser(username, oauth_token)
return redirect(url_for('home'))
def getUserInfo():
userIdHash = hash(str(request.remote_addr))
userInfo = db.getUserInfo(userIdHash)
if (userInfo is None):
userInfo = db.createUser(userIdHash)
return jsonify(userInfo)
def createUser():
username = input("Username: ")
password = getpass()
db.createUser(username, password)
import db
username = "******"
password = "******"
if __name__ == "__main__":
db.createUser()
print "Successfully create user table."
db.createCraft()
print "Successfully create craft table."
db.insertUser(username, password)
print "Successfully insert user."
db.insertCraft()
print "All done.Now you can run Shakespeare.py."
async def finishGame(callback, message, user_id):
result = callback[5:]
db.createUser(user_id, result)
await message.answer(
'Тест закончен\nПришли свою фотографию и произойдёт магия')
