a fh @sddlmZmZmZmZddlmZddlmZddl m Z ddl m Z m Z mZddlmZeZeddZe e Zejd ed ed d d ee feedddZdS)) APIRouterRequestDependsQuery) HTMLResponse)Jinja2Templates)get_current_user)get_pingconf_varsget_mysql_creds open_mysql) xor_bytes templates) directoryz /mailread)response_class.zPrivate Mail Number) description)requestPMNc CsT|s ddiSd}tt}|jdd}d}||||df|}|durrtd||ddWdS|d }|d d krd } || ||df||d pd} t| j ddd} |d|d|d|drt|dj dddnd|drt|dj dddnd| d}Wdn1s60Ytd|||dS)NerrorzNot authenticatedT) dictionarya SELECT p.PMailNum, p.FromHandleID, h.Handle AS FromName, p.ToLine, p.PostDate, p.Subject, p.MailBodyBlob, pp.ToHandleID, pp.Folder, pp.MailStatus FROM PrivateMail p JOIN PrivateMailPing pp ON pp.PMailNum = p.PMailNum JOIN Handles h ON h.HandleID = p.FromHandleID WHERE p.PMailNum = %s AND pp.ToHandleID = %s idz mailread.html)ruserZ unauthorizedrZ MailStatusNz UPDATE PrivateMailPing SET MailStatus = 'R' WHERE PMailNum = %s AND ToHandleID = %s AND MailStatus= "N" MailBodyBlobzutf-8replace)errorsPMailNumPostDateFromNameToLineSubject)rrrToNamesr!ZMailBody)rrmessage) r mysql_credscursorexecutefetchallr TemplateResponsecommitr decode) rrrr#connr%sqlrowsrow update_sql body_bytes body_textr2+/wd/v2025.freedom4um.com/routes/mailread.py mailread_pages>      "&  r4N)fastapirrrrfastapi.responsesrfastapi.templatingr utils.authrutils.pingdatar r r utils.xorr routerr r$getintr4r2r2r2r3s