def _RenderPosts(self, tid=0, loggedin=False):
parent_Post = Database.Database().Execute(
query="SELECT * FROM pythobb_threads WHERE tid=?",
variables=(tid, ),
commit=False,
doReturn=True)[0]
pPost = {
"post": parent_Post[4],
"poster": parent_Post[5].split(":")[0]
}
posts = Database.Database().Execute(
query="SELECT * FROM pythobb_posts WHERE parent=?",
variables=(tid, ),
commit=False,
doReturn=True)
post_String = ""
pid = parent_Post[5].split(":")[2]
getAvatar = Database.Database().Execute(
query="SELECT * FROM pythobb_user_data2 WHERE uid=?",
variables=(Database.Database().Execute(
query="SELECT * FROM pythobb_users WHERE username=?",
variables=(pPost["poster"], ),
commit=False,
doReturn=True)[0][0], ),
commit=False,
doReturn=True)[0][2]
if getAvatar != "":
getAvatar = "<br/><img src=\"" + getAvatar + "\" class=\"userimg\" style=\"height:75px;width:75px;margin-top:10px;\">"
post_String += self._Render(name="post_display").replace(
"{[username]}",
pPost["poster"]).replace("{[content]}", pPost["post"]).replace(
"{[postoptions]}",
self._PostOpt(pid=pid, loggedin=loggedin)).replace(
"{[useravatar]}", getAvatar)
def getUser(uid=None):
return str(Database.Database().Execute(
query="SELECT * FROM pythobb_users WHERE uid=?",
variables=(uid, ),
commit=False,
doReturn=True)[0][1])
for c in posts:
avatar = Database.Database().Execute(
query="SELECT * FROM pythobb_user_data2 WHERE uid=?",
variables=(c[3], ),
commit=False,
doReturn=True)[0][2]
if avatar != "":
avatar = "<br/><img src=\"" + avatar + "\" class=\"userimg\" style=\"height:75px;width:75px;margin-top:10px;\">"
post_String += self._Render(name="post_display").replace(
"{[username]}", getUser(uid=c[3])).replace(
"{[content]}",
Misc.PBBCode()._Parse(content=c[2])).replace(
"{[postoptions]}",
self._PostOpt(pid=c[0], loggedin=loggedin)).replace(
"{[useravatar]}", avatar)
return post_String
