| 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
|