Exemple #1
0
import functions
import json
import os
import sys
import codecs
import datetime

# Note this line. It's the important one
sys.stdout = codecs.getwriter("utf-8")(sys.stdout.detach())

print("Content-Type: text/plain; charset=UTF-8\n\n")

try:
    uid=functions.get_user_id()
    sid = functions.get_cookie_value('LoggedIn')

    if not functions.check_logged():
        json_res = {"ok": False, "data": []}
        print(json.dumps(json_res, indent=4, default=str, ensure_ascii=False).encode('utf-8').decode())
        sys.exit()
    
    list_friends_query = "SELECT friend1 FROM friends WHERE   status = 2 AND  friend2 = '"+str(uid)+"' UNION SELECT friend2 FROM friends WHERE  status = 2 AND  friend1 = '"+str(uid)+"' "
    sql = "SELECT id, nickname, picture_number FROM users WHERE id  IN ("+list_friends_query+") "
    mydb = functions.connect()
    mycursor = mydb.cursor()
    mycursor.execute(sql)
    all_details = mycursor.fetchall()
    
    friend = []
    list_of_columens = [i[0] for i in mycursor.description]
Exemple #2
0
#!/home/mefath5/.local/bin/python3
# print("Content-Type: text/plain\n\n")

import os
import sys
import datetime
import functions

try:

    sid = functions.get_cookie_value("LoggedIn")
    if not sid:
        print("location: login.html")
        print("")
        sys.exit()

    db = functions.connect()

    sql = "SELECT `update_time`, `logged_out` FROM sessions WHERE sid = '" + sid + "'"

    time_before = (datetime.datetime.now() - datetime.timedelta(minutes=10))

    session_cursor = db.cursor()
    session_cursor.execute(sql)

    session = session_cursor.fetchall()
    if len(session) < 1:
        time = time_before
        logged = 0
    else:
        time, logged = session[0]