Ejemplo n.º 1
0
def showRank():
    Players=getPlayer()
    for player in Players:
        player['TeamName'] = TEAMS[ player['TeamID'] -1 ][1]

    return render_template('score_personal_message.html',TEAMS=TEAMS,Players=Players)
Ejemplo n.º 2
0
def upload():
    ## POST
    if request.method == 'POST':
        file = request.files['image']
        if not facebook.getUID(request.cookies.get('fbToken')):
            return "session已過期"

        elif not lookupAdmin(facebook.getUID(request.cookies.get('fbToken'))):
            return "您不是管理員,滾!!"

        elif not request.form.get('song'):
            return "您沒有選擇歌曲!!"

        elif not request.form.get('Rate'):
            return "您沒有輸入達成率!!"

        elif not request.form.get('PlayerID'):
            return "您沒有選擇玩家!!"

        elif not file:
            return "你沒有選擇檔案!!"

        elif not allowed_file(file.filename):
            return "檔案格式錯誤!!"

        else:
            try:
                ## 整理資訊
                song    = request.form.get('song')
                rate    = request.form.get('Rate')
                PlayerID= request.form.get('PlayerID')
                fileExt = '.'+getExt(file.filename)
                ## 未來再實做的功能
                #remeber = request.form.get('remeber',False)

            except:
               return render_template('upload_msg.html',TEAMS=config.TEAMS,message="欄位輸入不完整")

            try:
                ## 產生暫存的檔名
                temp_filename = "temp-"+str(random.randint(1,10000))+fileExt
                temp_fullpath = os.path.join(UPLOAD_FOLDER, temp_filename)
                file.save(temp_fullpath)
            
                ## 歸位--動態網頁用
    
                ## 產生sha1
                BLOCKSIZE = 65536
                hasher = hashlib.sha1()
                with open(temp_fullpath,'rb') as afile:
                    buf = afile.read(BLOCKSIZE)
                    while len(buf) > 0:
                        hasher.update(buf)
                        buf = afile.read(BLOCKSIZE)
                sha1=hasher.hexdigest()
                
                fullpath = os.path.join(UPLOAD_FOLDER,sha1+fileExt)
                shutil.copy2(temp_fullpath,fullpath)

                ## 歸位--靜態網頁用
                folder = os.path.join(UPLOAD_FOLDER, 'player-'+str(PlayerID))
                if not os.path.exists(folder) :
                    os.makedirs(folder)

                fullpath = os.path.join(folder,'song-'+song+fileExt)
                shutil.copy2(temp_fullpath,fullpath)
                
                ## 刪除暫存檔案
                os.remove(temp_fullpath)

            except:
                return render_template('upload_msg.html',message="存檔有問題,可能硬碟滿了,請通知管理員。")

               # return "upload Sucesfull file tempory as " + temp_filename +\
               #     " md5 is " + hasher.hexdigest() + " and Player is " + player

            try:
                insScoreAdmin(PlayerID,song,sha1,fileExt,rate,facebook.getUID(request.cookies.get('fbToken')))

            except:
                return render_template('upload_msg.html',message="資料庫有點毛病,請晚點再來試試看(圖片已經上傳成功)")

            return render_template('upload_msg.html',message='存檔成功,<a href="/upload">返回上傳介面</a>')

    ## GET METHOD
    else:
        code = request.args.get('code',False)
        if code:
            Res=facebook.getToken(request.base_url,code)
            if Res[0]:
                AdminUID=facebook.getUID(Res[1])
                AdminInfo=lookupAdmin(AdminUID)
                if AdminInfo:
                    resp = make_response(redirect(request.base_url))
                    #resp = make_response("寫入Cookie中......"+PlayerUID+PlayerInfo['CardName'])
                    resp.set_cookie(key='fbToken',value=Res[1],max_age=int(Res[2]),\
                            secure=SERVER_WITH_HTTPS)
                    resp.set_cookie(key='AdminName',value=AdminInfo['AdminName'],max_age=int(Res[2]),\
                            secure=SERVER_WITH_HTTPS)
                    return resp

                else:
                    return render_template('upload_msg.html',TEAMS=TEAMS,message="您似乎不是管理員,如果有什麼誤會請回報你的FacenookID:"+AdminUID)
                
            else:
                return render_template('upload_msg.html',TEAMS=TEAMS,message="登入失敗,請重試,錯誤訊息:"+Res[1])
            
        else:
            if request.cookies.get('fbToken'):
                fbToken=request.cookies.get('fbToken')
                AdminName=request.cookies.get('AdminName')
                
                if lookupAdmin(facebook.getUID(fbToken)):
                    songinfo = getSong()
                    playerinfo = getPlayer()
                    return render_template('upload_by_admin.html',TEAMS=TEAMS,AdminName=AdminName,songs=songinfo,players=playerinfo)
                else:
                    if not facebook.getUID(fbToken):
                        return render_template('upload_msg.html',TEAMS=TEAMS, \
                                message='Token過期,請重新登入:'+"<a href=\""+facebook.genGetCodeURL(request.base_url)+"\">使用facebook登入</a>")
                    else:
                        return render_template('upload_msg.html',TEAMS=TEAMS,message='Token有效,但是您不是管理員!!\
			您的FBID:'+facebook.getUID(fbToken))

            else:
                LoginURL=facebook.genGetCodeURL(request.base_url)
                msg='上傳界面僅供管理員使用,如果您是管理員請<a href=\"'+LoginURL+'\">使用facebook登入</a>。<br />如果您不是管理員,請離開本頁面。'
                return render_template('upload_msg.html',TEAMS=TEAMS,message=msg)