def create_workshop(wname, name, email, phone, stuid):
sname = wname.strip().lower()
username = sname + "@workshops"
password = codecs.encode(os.urandom(16), 'hex').decode()
res = conn.runQuery(
"INSERT INTO admins(username, password, name, mail, phone, collegeid, totp_setup, totp_secret, priority) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
(username, Hash(password), name, email, phone, stuid, 0, '', 5))
ID = get_user_id(username)
if ID != None:
res = conn.runQuery(
"INSERT INTO workshops(workshop_name, login_creds, deleted) VALUES (%s, %s, %s)",
(wname, ID, 0))
link = create_passwd_reset_link(ID)
if link != None:
send_password_reset_link(ID, link)
def create_event(ename, name, email, phone, stuid):
sname = ename.strip().lower()
username = sname + "@events"
password = codecs.encode(os.urandom(16), 'hex').decode()
print("Inserting Event Credentails ", username)
res = conn.runQuery(
"INSERT INTO admins(username, password, name, mail, phone, collegeid, totp_setup, totp_secret, priority) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
(username, Hash(password), name, email, phone, stuid, 0, '', 3))
ID = get_user_id(username)
print(username, ID, "create_event")
if ID != None:
res = conn.runQuery(
"INSERT INTO events(event_name, dept_id, login_creds, deleted) VALUES (%s, %s, %s, %s)",
(ename, session['dept_id'], ID, 0))
link = create_passwd_reset_link(ID)
if link != None:
send_password_reset_link(ID, link)
def get_workshop_notifications(num=None):
if num == None: num = session['workshop_id']
res = conn.runQuery(
"SELECT id, title, content, time_stamp FROM workshop_notifications WHERE workshopid = %s ORDER BY id DESC",
(num))
for item in res:
item['post_time'] = datetime.fromtimestamp(
item['time_stamp']).strftime("%b-%d [ %I:%M:%p ]")
return res
def check_login(username, password):
res = conn.runQuery(
"SELECT id, priority FROM admins WHERE username = %s AND password = %s",
(username, Hash(password)))
if len(res) == 1:
priority = res[0]['priority']
Id = res[0]['id']
if priority == 2:
res = conn.runQuery(
"SELECT id, dept_name FROM departments WHERE login_creds = %s AND deleted = 0",
(Id))
if len(res) != 1:
return False
session['dept_id'] = res[0]['id']
session['dept_name'] = res[0]['dept_name']
elif priority == 3:
res = conn.runQuery(
"SELECT id, event_name FROM events WHERE login_creds = %s AND deleted = 0",
(Id))
if len(res) != 1:
return False
session['event_id'] = res[0]['id']
session['event_name'] = res[0]['event_name']
elif priority == 5:
res = conn.runQuery(
"SELECT id, workshop_name FROM workshops WHERE login_creds = %s AND deleted = 0",
(Id))
if len(res) != 1:
return False
session['workshop_id'] = res[0]['id']
session['workshop_name'] = res[0]['workshop_name']
session['username'] = username
session['isLogin'] = 1
session['priority'] = priority
return True
else:
return False
def delete_workshop_contact(num):
res = conn.runQuery(
"DELETE FROM workshop_contacts WHERE id = %s AND workshopid = %s",
(num, session['workshop_id']))
def activate_event(Id):
res = conn.runQuery("SELECT id FROM events WHERE id = %s", (Id))
if len(res) == 1 and str(res[0]['id']) == Id:
conn.runQuery("UPDATE events SET deleted = 0 WHERE id = %s", (Id))
def get_event_about(num=None):
if num == None: num = session['event_id']
res = conn.runQuery("SELECT about FROM events WHERE id = %s", (num))
if len(res) != 1: return ""
return res[0]['about']
def set_workshop_topics(data, num=None):
if num == None: num = session['workshop_id']
conn.runQuery("UPDATE workshops SET topics = %s WHERE id = %s",
(data, num))
def get_workshop_about(num=None):
if num == None: num = session['workshop_id']
res = conn.runQuery("SELECT about FROM workshops WHERE id = %s", (num))
if len(res) != 1: return ""
return res[0]['about']
def activate_workshop(Id):
res = conn.runQuery("SELECT id FROM workshops WHERE id = %s", (Id))
if len(res) == 1 and str(res[0]['id']) == Id:
conn.runQuery("UPDATE workshops SET deleted = 0 WHERE id = %s", (Id))
def delete_event_contact(num):
res = conn.runQuery(
"DELETE FROM event_contacts WHERE id = %s AND eveid = %s",
(num, session['event_id']))
def set_event_contact(name, phone, email):
res = conn.runQuery(
"INSERT INTO event_contacts(eveid, name, phone, email) VALUES (%s, %s, %s, %s)",
(session['event_id'], name, phone, email))
def get_event_contacts(num=None):
if num == None: num = session['event_id']
res = conn.runQuery(
"SELECT id, name, phone, email FROM event_contacts WHERE eveid = %s",
(num))
return res
def set_team_size(Min, Max):
res = conn.runQuery(
"UPDATE events SET min_part = %s, max_part = %s WHERE id = %s",
(Min, Max, session['event_id']))
def get_team_size(num=None):
if num == None: num = session['event_id']
res = conn.runQuery("SELECT min_part, max_part FROM events WHERE id = %s",
(num))
return [res[0]['min_part'], res[0]['max_part']]
def get_event_rules(num=None):
if num == None: num = session['event_id']
res = conn.runQuery("SELECT id, rules FROM event_rules WHERE eveid = %s",
(num))
return res
def set_workshop_notification(title, content):
tm = int(datetime.now().timestamp())
res = conn.runQuery(
"INSERT INTO workshop_notifications(workshopid, title, content, time_stamp) VALUES (%s, %s, %s, %s)",
(session['workshop_id'], title, content, tm))
def set_event_notification(title, content):
tm = int(datetime.now().timestamp())
res = conn.runQuery(
"INSERT INTO event_notifications(eveid, title, content, time_stamp) VALUES (%s, %s, %s, %s)",
(session['event_id'], title, content, tm))
def delete_workshop_notification(num):
res = conn.runQuery(
"DELETE FROM workshop_notifications WHERE id = %s AND workshopid = %s",
(num, session['workshop_id']))
def delete_event_notification(num):
res = conn.runQuery(
"DELETE FROM event_notifications WHERE id = %s AND eveid = %s",
(num, session['event_id']))
def get_workshop_rules(num=None):
if num == None: num = session['workshop_id']
res = conn.runQuery(
"SELECT id, rules FROM workshop_rules WHERE workshopid = %s", (num))
return res
def disable_event(num):
res = conn.runQuery("UPDATE events SET visible = 0 WHERE id = %s", (num))
def get_workshop_topics(num=None):
if num == None: num = session['workshop_id']
res = conn.runQuery("SELECT topics FROM workshops WHERE id = %s", (num))
if len(res) != 1: return ""
return res[0]['topics']
def get_totp_setup():
res = conn.runQuery("SELECT totp_setup FROM admins WHERE username = %s",
(session['username']))
return res[0]['totp_setup']
def get_event_image_name(num=None):
if num == None: num = session['event_id']
res = conn.runQuery("SELECT event_name FROM events WHERE id = %s", (num))
if len(res) != 1: return ''
img = MD5("photo_save_67668" + res[0]['event_name'])
return img
def set_event_about(data):
conn.runQuery("UPDATE events SET about = %s WHERE id = %s",
(data, session['event_id']))
def set_priority(num, priority):
res = conn.runQuery("UPDATE events SET prior = %s WHERE id = %s ",
(priority, num))
def get_workshop_contacts(num=None):
if num == None: num = session['workshop_id']
res = conn.runQuery(
"SELECT id, name, phone, email FROM workshop_contacts WHERE workshopid = %s",
(num))
return res
def get_user_mail():
res = conn.runQuery("SELECT mail FROM admins WHERE username = %s",
(session['username']))
if len(res) != 1:
return "-----"
return res[0]['mail']
def set_workshop_contact(name, phone, email):
res = conn.runQuery(
"INSERT INTO workshop_contacts(workshopid, name, phone, email) VALUES (%s, %s, %s, %s)",
(session['workshop_id'], name, phone, email))
