def Register(connect, username, password, email, license_type, state=0):
if not reg_username.match(username):
return {'result': False, 'user_id': 0}
if len(password) < 5:
return {'result': False, 'user_id': 0}
cur = connect.cursor()
cur.execute('SELECT uname FROM UserInfo WHERE uname = %s;', (username,))
rows = cur.fetchall()
if len(rows) != 0:
cur.close()
return {'result': False, 'user_id': 0}
d = datetime.datetime.today()
cur.execute('INSERT INTO UserInfo (uname,passwd,registration_date,email,state,license_type) VALUES(%s,%s,%s,%s,%s,%s);',(username, md5.new(password).hexdigest(), d.strftime("%Y-%m-%d"), Util.myencode(email), state, license_type, ))
user_id = cur.lastrowid
connect.commit()
cur.close()
return {'result': True, 'user_id': user_id}
