def decode(code):
    #print(code)
    connection = sqlite3.connect("/root/bots/ptpinfo/ptpinfo-spoilers.db")
    sql = connection.cursor()
    decoderesult = sql.execute("SELECT from1, note FROM spoilers WHERE code = :code", {"code": code}).fetchone()
    connection.close()
    if decoderesult == None:
        return "ERROR"
    else:
        from2, decode1 = decoderesult
        decodesplit = decode1.split()
        ## premsg split
        premsg = ""
        codemsg = ""
        premsgtest = False
        indexword1 = 0
        for word in decodesplit:
            if word == "||":
                premsgtest = True
                if len(decodesplit) > indexword1+1:
                    test1indx = indexword1 + 1
                    codemsg = decodesplit[test1indx:]
                    codemsg = ' '.join(codemsg)
                    premsg = decodesplit[:test1indx]
                    premsg = ' '.join(premsg)
                break
            indexword1 = indexword1 + 1
        if premsgtest == False:
            codemsg = decode1
        rottype = int(code[0:2])
        #print(rottype)
        rot = ""
        abc = "abcdefghijklmnopqrstuvwxyz"
        ABC = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
        for char in codemsg:
            if (ord(char)) in range(65,91):
              rot += ABC[((ABC.find(char)) + rottype) % 26]
            elif ord(char) in range(97,123):
              rot += abc[((abc.find(char)) + rottype) % 26]
            else:
              rot += char
        #print(rot)
        if premsg != "":
            decoded = premsg+" "+rot
        else: decoded = rot
        return from2, decoded