def paste(paste): getPaste = d2_paste.query.filter(d2_paste.paste_id == paste).first() subheading = ['<a href="/pastebin/">Pastebin</a>'] if getPaste: return syndbb.render_template('pastebin.html', paste=getPaste, title="" + getPaste.title, subheading=subheading) else: return syndbb.render_template('invalid.html', title="Invalid Paste", subheading=subheading)
def view_post(post): isInline = syndbb.request.args.get('inlinecontent', '') postcheck = d2_activity.query.filter_by(id=post).first() if postcheck: if postcheck.title: thread_title = ( postcheck.title[:75] + '...') if len(postcheck.title) > 75 else postcheck.title postvars = postcheck else: threadcheck = d2_activity.query.filter_by( id=postcheck.replyto).first() thread_title = ( threadcheck.title[:75] + '...') if len(threadcheck.title) > 75 else threadcheck.title postvars = threadcheck forumcheck = d2_forums.query.filter_by(id=postvars.category).first() if ('logged_in' in syndbb.session and checkSession( str(syndbb.session['logged_in']))) or not forumcheck.auth: return syndbb.render_template( 'view_post.html', isInline=isInline, post=postcheck, title="#" + forumcheck.short_name + " • " + thread_title + " • " + forumcheck.name, forumtitle="<a href='/" + forumcheck.short_name + "/" + str(postvars.id) + "'>" + thread_title + "</a>") else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in") else: return syndbb.render_template('invalid.html', title=" • No post found")
def submit_emoticon(): if 'logged_in' in syndbb.session: dynamic_js_footer = ["js/lazyload.transpiled.min.js", "js/bootbox.min.js", "js/delete.js"] emote_list = get_submitted_emote() return syndbb.render_template('submit-emoticon.html', emote_list=emote_list, dynamic_js_footer=dynamic_js_footer, title="Submit Emoticon", subheading=["Emoticons"]) else: return syndbb.render_template('error_not_logged_in.html', title="Submit Emoticon", subheading=["Emoticons"])
def delete_file(): ufile = syndbb.request.args.get('file', '') uniqid = syndbb.request.args.get('uniqid', '') uploader = syndbb.request.args.get('uploader', '') if 'logged_in' in syndbb.session: userid = check_session_by_id(str(uniqid)) if userid: user = d2_user.query.filter_by(user_id=userid).first() if uploader == "upload_anon": uploaded_file = syndbb.app.static_folder + "/data/uploads/" + d2_hash( user.username + user.password)[:10] + "/" + ufile else: uploaded_file = syndbb.app.static_folder + "/data/uploads/" + user.username + "/" + ufile if syndbb.os.path.isfile(uploaded_file): syndbb.os.system("shred -u " + uploaded_file) syndbb.flash('File deleted successfully.', 'success') syndbb.cache.delete_memoized( syndbb.views.upload.get_user_files) return syndbb.redirect(syndbb.url_for(uploader)) else: syndbb.flash('No such file exists.', 'danger') return syndbb.redirect(syndbb.url_for(uploader)) else: return syndbb.render_template('error_not_logged_in.html', title="Upload") else: return syndbb.render_template('error_not_logged_in.html', title="Upload")
def view_user_posts(user): if 'logged_in' in syndbb.session: userid = checkSession(str(syndbb.session['logged_in'])) if userid: dynamic_css_header = ["css/bbcode_editor.css"] isInline = syndbb.request.args.get('inlinecontent', '') postcheck = d2_activity.query.filter_by(user_id=user).filter( d2_activity.replyto != 0).filter( d2_activity.anonymous != 1).order_by( d2_activity.time.desc()).all() usercheck = d2_user.query.filter_by(user_id=user).first() if usercheck: if postcheck: subheading = [] subheading.append('<a href="/user/' + usercheck.username + '">' + usercheck.username + '</a>') return syndbb.render_template('view_user_posts.html', isInline=isInline, posts=postcheck, title="All posts by " + usercheck.username, subheading=subheading) else: return syndbb.render_template( 'invalid.html', title=" • No posts found") else: return syndbb.render_template('invalid.html', title=" • No user found") else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in")
def edit_post(post): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: isInline = syndbb.request.args.get('inlinecontent', '') postcheck = d2_activity.query.filter_by(id=post).first() if postcheck: if postcheck.title: thread_title = (postcheck.title[:75] + '...') if len(postcheck.title) > 75 else postcheck.title postvars = postcheck else: threadcheck = get_thread_contents(postcheck.replyto) thread_title = (threadcheck.title[:75] + '...') if len(threadcheck.title) > 75 else threadcheck.title postvars = threadcheck channelcheck = d2_channels.query.filter_by(id=postvars.category).first() if not check_channel_auth(channelcheck): return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") dynamic_css_header = ["css/bbcode_editor.css"] dynamic_js_footer = ["js/jquery.rangyinputs.js", "js/bbcode_editor_channels.js", "js/editing.js", "js/bootbox.min.js"] subheading = [] subheading.append("<a href='/" + channelcheck.short_name + "/'>" + channelcheck.name + "</a>") subheading.append("<a href='/" + channelcheck.short_name + "/"+str(postvars.id)+"'>" + thread_title + "</a>") return syndbb.render_template('edit_post.html', isInline=isInline, post=postcheck, dynamic_css_header=dynamic_css_header, dynamic_js_footer=dynamic_js_footer, title="#"+channelcheck.short_name + " • " + thread_title + " • " + channelcheck.name, channeltitle="Editing Post", subheading=subheading) else: return syndbb.render_template('invalid.html', title=" • No post found") else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in")
def logout(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: uniqid = syndbb.request.args.get('uniqid', '') if str(uniqid) == str(syndbb.session['logged_in']): check_session = d2_ip.query.filter_by(sessionid=uniqid).filter_by(ip=gdpr_check(syndbb.request.remote_addr)).first() if check_session: syndbb.db.session.delete(check_session) syndbb.db.session.commit() syndbb.session.pop('logged_in', None) syndbb.flash('You have been logged out.', 'warning') return syndbb.redirect(syndbb.url_for('home')) else: syndbb.flash('Invalid request.', 'warning') syndbb.session.pop('logged_in', None) return syndbb.redirect(syndbb.url_for('home')) else: syndbb.flash('Invalid session.', 'warning') syndbb.session.pop('logged_in', None) return syndbb.redirect(syndbb.url_for('home')) else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in") else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in")
def siteadmin_emoticons(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 100: emote_list = [] emotfolder = syndbb.app.static_folder + "/data/emoticons/" if not syndbb.os.path.exists(emotfolder): syndbb.os.makedirs(emotfolder) for emote in glob.glob(emotfolder+"**", recursive=True): filepath = emote.replace(emotfolder, "") if syndbb.os.path.isfile(emote): addtime = int(syndbb.os.stat(emote).st_mtime) code = syndbb.os.path.splitext(emote)[0] code = ":" + syndbb.re.sub(r'.*/', '', code) + ":" emote_list.append([filepath, code]) emote_list.sort(reverse=False) return syndbb.render_template('admin_emoticons.html', emote_list=emote_list, title="Administration • Emoticon List") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def upload_anon(): page = syndbb.request.args.get('page', type=int, default=1) per_page = syndbb.request.args.get('amount', type=int, default=25) dynamic_css_header = [] dynamic_js_footer = [ "js/bootstrap-filestyle.min.js", "js/bootbox.min.js", "js/delete.js", "js/lazyload.transpiled.min.js" ] if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: cached_list = get_user_files(userid, anon=1) file_list = cached_list['file_list'] page_count = math.ceil(len(file_list) / per_page) pagination = Pagination(page=page, per_page=per_page, css_framework='bootstrap3', total=len(file_list)) amount_options = ["25", "50", "100", "500", "1000", "1500", "2000"] countselector = '' for amount in amount_options: if str(per_page) == amount: countselector += '<option value="' + amount + '" selected>' + amount + '</option>' else: countselector += '<option value="' + amount + '">' + amount + '</option>' start_index = (page * per_page) - per_page end_index = start_index + per_page if end_index > len(file_list): end_index = len(file_list) file_list = file_list[start_index:end_index] return syndbb.render_template( 'upload_anon.html', uploadurl=cached_list['uploadurl'], filecount=cached_list['file_count'], file_list=file_list, pagination=pagination, countselector=countselector, total_size=cached_list['total_size'], uploader_name=cached_list['user_name'], dynamic_js_footer=dynamic_js_footer, dynamic_css_header=dynamic_css_header, title="Anonymous Upload", subheading=['<a href="/upload/">Upload</a>']) else: return syndbb.render_template( 'error_not_logged_in.html', title="Anonymous Upload", subheading=['<a href="/upload/">Upload</a>']) else: return syndbb.render_template('error_not_logged_in.html', title="Upload", subheading=[""])
def request_forum(): if 'logged_in' in syndbb.session: return syndbb.render_template('request_forum.html', title="New Channel", subheading=[""]) else: return syndbb.render_template('error_not_logged_in.html', title="New Channel", subheading=[""])
def profile(username): isInline = syndbb.request.args.get('inlinecontent', '') user = get_user_profile(username) if user: subheading = [] subheading.append("User Profile") dynamic_js_footer = ["js/bootbox.min.js", "js/delete.js", "js/profileAvatar.js"] return syndbb.render_template('profile.html', isInline=isInline, dynamic_js_footer=dynamic_js_footer, profile=user, title=user.username, subheading=subheading) else: return syndbb.render_template('invalid.html', isInline=isInline, title="Invalid User")
def pastebin(): if 'logged_in' in syndbb.session: dynamic_js_footer = ["js/bootbox.min.js", "js/delete.js"] userid = checkSession(str(syndbb.session['logged_in'])) if userid: getPastes = d2_paste.query.filter(d2_paste.user_id == userid).order_by(syndbb.db.desc(d2_paste.time)).all() return syndbb.render_template('pastebin.html', dynamic_js_footer=dynamic_js_footer, paste_list=getPastes, title="Pastebin", subheading=[""]) else: return syndbb.render_template('error_not_logged_in.html', title="Pastebin", subheading=[""]) else: return syndbb.render_template('error_not_logged_in.html', title="Pastebin", subheading=[""])
def view_thread(category, thread): forumcheck = d2_forums.query.filter_by(short_name=category).first() forumlogo = "" if forumcheck: if ('logged_in' in syndbb.session and checkSession( str(syndbb.session['logged_in']))) or not forumcheck.auth: topbuttons = '<a href="/' + forumcheck.short_name + '/' + thread + '/gallery" title="Gallery View" style="float:right;"><i class="silk-icon icon_application_view_tile" aria-hidden="true"></i></a>' dynamic_css_header = ["css/bbcode_editor.css"] dynamic_js_footer = [ "js/bootstrap-filestyle.min.js", "js/jquery.rangyinputs.js", "js/bbcode_editor_forums.js", "js/posts.js", "js/post_ratings.js", "js/bootbox.min.js", "js/delete.js", "js/inline.js" ] # if forumcheck.short_name == "yiff": # dynamic_css_header.append("css/oify.css") if (forumcheck.nsfw) and ('nsfwAllow' not in syndbb.request.cookies): dynamic_js_footer.append("js/nsfwprompt.js") dynamic_css_header.append("css/nsfw_fill.css") logo_file = syndbb.app.static_folder + "/images/logos/" + forumcheck.short_name + ".png" if syndbb.os.path.isfile(logo_file): forumlogo = '<img src="' + cdn_path( ) + '/images/logos/' + forumcheck.short_name + '.png" alt="D2K5" class="sitelogo mask">' threadcheck = d2_activity.query.filter_by(id=thread).first() if threadcheck: subheading = [] subheading.append('<a href="/' + forumcheck.short_name + '">' + forumcheck.name + '</a>') thread_title = (threadcheck.title[:75] + '...') if len( threadcheck.title) > 75 else threadcheck.title replycheck = d2_activity.query.filter_by(replyto=thread).all() return syndbb.render_template( 'view_thread.html', forum=forumcheck, replies=replycheck, thread=threadcheck, forumlogo=forumlogo, dynamic_css_header=dynamic_css_header, dynamic_js_footer=dynamic_js_footer, title="#" + forumcheck.short_name + " • " + thread_title + " • " + forumcheck.name, forumtitle=thread_title, topbuttons=topbuttons, subheading=subheading) else: return syndbb.render_template('invalid.html', title="No thread found") else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in") else: return syndbb.render_template('invalid.html', title="No page found")
def register(): if 'logged_in' in syndbb.session: userid = checkSession(str(syndbb.session['logged_in'])) if userid: return syndbb.render_template('error_already_logged_in.html', title="Registration") dynamic_js_footer = [ "js/crypt.js", "js/auth/auth_regd.js", "js/bootbox.min.js" ] return syndbb.render_template('register.html', dynamic_js_footer=dynamic_js_footer, title="Registration")
def login(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: return syndbb.render_template('error_already_logged_in.html', title="Log In") dynamic_js_footer = ["js/crypt.js", "js/bootbox.min.js"] if syndbb.core_config['ldap']['enabled'] : dynamic_js_footer.append("js/auth_plain/auth_login.js") else: dynamic_js_footer.append("js/auth_hash/auth_login.js") return syndbb.render_template('login.html', dynamic_js_footer=dynamic_js_footer, title="Log In")
def change_password(): if 'logged_in' in syndbb.session: userid = checkSession(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() dynamic_js_footer = ["js/crypt.js", "js/auth/auth_chpw.js", "js/bootbox.min.js"] subheading = [] subheading.append("<a href='/user/" + user.username + "'>" + user.username + "</a>") return syndbb.render_template('change_password.html', dynamic_js_footer=dynamic_js_footer, title="Change Password", subheading=subheading) else: return syndbb.render_template('error_not_logged_in.html', title="Change Password") else: return syndbb.render_template('error_not_logged_in.html', title="Change Password")
def login_history(): if 'logged_in' in syndbb.session: userid = checkSession(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() logins = d2_ip.query.filter_by(user_id=userid).order_by(d2_ip.time.desc()).all() subheading = [] subheading.append("<a href='/user/" + user.username + "'>" + user.username + "</a>") return syndbb.render_template('login_info.html', logins=logins, title="Login History", subheading=subheading) else: return syndbb.render_template('error_not_logged_in.html', title="Login History") else: return syndbb.render_template('error_not_logged_in.html', title="Login History")
def siteadmin_logins(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 900: return syndbb.render_template('admin_logins.html', logins=get_all_logins(), title="Administration • Login History") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def siteadmin_rank(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 500: rankuser = syndbb.request.args.get('user', '') return syndbb.render_template('admin_rank.html', rankuser=rankuser, title="Administration • Change Rank") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def siteadmin_channels(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 100: unapproved = d2_channels.query.filter(d2_channels.approved == 0).all() return syndbb.render_template('admin_channels.html', unapproved=unapproved, title="Administration • Unapproved Channels") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def siteadmin_users(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 500: dynamic_js_footer = ["js/bootbox.min.js", "js/delete.js"] users = d2_user.query.order_by(d2_user.rank.desc()).order_by(d2_user.join_date.asc()).all() return syndbb.render_template('admin_users.html', dynamic_js_footer=dynamic_js_footer, users=users, title="Administration • User List") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def siteadmin_invites(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 100: dynamic_js_footer = ["js/bootbox.min.js", "js/delete.js"] invites = d2_requests.query.all() return syndbb.render_template('admin_invites.html', dynamic_js_footer=dynamic_js_footer, invites=invites, title="Administration • Requested Invites") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def register(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: return syndbb.render_template('error_already_logged_in.html', title="Registration") dynamic_js_footer = ["js/crypt.js", "js/bootbox.min.js", "js/random_name.js"] if syndbb.core_config['ldap']['enabled'] : dynamic_js_footer.append("js/auth_plain/auth_regd.js") else: dynamic_js_footer.append("js/auth_hash/auth_regd.js") reg_template = "register_invite.html" if syndbb.core_config['site']['invite_only'] else "register.html" if not syndbb.core_config['site']['registration'] : reg_template = "register_disabled.html" return syndbb.render_template(reg_template, dynamic_js_footer=dynamic_js_footer, invite_code='', title="Registration")
def profiles(): linked_users = [] if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user: if user.user_auth and user.user_auth != "": linked_users = d2_user.query.filter_by(user_auth=user.user_auth).all() subheading = [] subheading.append("<a href='/user/" + user.username + "'>" + user.username + "</a>") return syndbb.render_template('profiles.html', linked_users=linked_users, title="My Profiles", subheading=subheading) else: return syndbb.render_template('error_not_logged_in.html', title="My Profiles") else: return syndbb.render_template('error_not_logged_in.html', title="My Profiles")
def siteadmin_ban(): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 500: banuser = syndbb.request.args.get('user', '') banpost = syndbb.request.args.get('post_id', '') isbanned = check_ban_by_id(banuser) return syndbb.render_template('admin_ban.html', isbanned=isbanned, banuser=banuser, banpost=banpost, title="Administration • Ban User") else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return syndbb.render_template('error_not_logged_in.html', title="Administration") else: return syndbb.render_template('error_not_logged_in.html', title="Administration")
def do_rank_user(): rankuser = syndbb.request.form['user_id'] rank = syndbb.request.form['rank'] uniqid = syndbb.request.form['uniqid'] if rankuser and rank and uniqid: userid = check_session_by_id(uniqid) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 500: changeuser = d2_user.query.filter_by(user_id=rankuser).first() changeuser.rank = rank syndbb.db.session.commit() syndbb.cache.delete_memoized(syndbb.models.users.get_title_by_id) syndbb.cache.delete_memoized(syndbb.models.users.get_group_style_by_id) syndbb.flash('User rank changed successfully.', 'success') return syndbb.redirect(syndbb.url_for('siteadmin_users')) else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return "Invalid Session" else: return "Invalid Request"
def approve_emoticon(): emote = syndbb.request.args.get('file', '') uniqid = syndbb.request.args.get('uniqid', '') if uniqid: userid = check_session_by_id(uniqid) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 500: emotepath = syndbb.app.static_folder + "/data/emoticons/" + emote destpath = syndbb.app.static_folder + "/images/emots/" if syndbb.os.path.isfile(emotepath): shutil.copy2(emotepath, destpath) syndbb.os.remove(emotepath) syndbb.flash('Emoticon approved successfully.', 'success') return syndbb.redirect(syndbb.url_for('siteadmin_emoticons')) else: syndbb.flash('No such emoticon exists.', 'danger') return syndbb.redirect(syndbb.url_for('siteadmin_emoticons')) else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return "Invalid Session" else: return "Invalid Request"
def view_post(post): isInline = syndbb.request.args.get('inlinecontent', '') postcheck = d2_activity.query.filter_by(id=post).first() if postcheck: if postcheck.title: thread_title = (postcheck.title[:75] + '...') if len(postcheck.title) > 75 else postcheck.title postvars = postcheck else: threadcheck = get_thread_contents(postcheck.replyto) thread_title = (threadcheck.title[:75] + '...') if len(threadcheck.title) > 75 else threadcheck.title postvars = threadcheck channelcheck = d2_channels.query.filter_by(id=postvars.category).first() if not check_channel_auth(channelcheck): return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") return syndbb.render_template('view_post.html', isInline=isInline, post=postcheck, title="#"+channelcheck.short_name + " • " + thread_title + " • " + channelcheck.name, channeltitle="<a href='/" + channelcheck.short_name + "/"+str(postvars.id)+"'>" + thread_title + "</a>") else: return syndbb.render_template('invalid.html', title=" • No post found")
def do_unban_user(): banuser = syndbb.request.form['user_id'] uniqid = syndbb.request.form['uniqid'] if banuser and uniqid: userid = check_session_by_id(uniqid) if userid: user = d2_user.query.filter_by(user_id=userid).first() if user.rank >= 500: ban = d2_bans.query.filter_by(banned_id=banuser).order_by(d2_bans.time.desc()).first() if ban.length == 0: ban.length = "-1" ban.expires = unix_time_current() syndbb.db.session.commit() syndbb.cache.delete_memoized(syndbb.models.users.get_title_by_id) syndbb.cache.delete_memoized(syndbb.models.users.get_group_style_by_id) syndbb.cache.delete_memoized(syndbb.models.activity.ban_list) syndbb.flash('User unbanned successfully.', 'success') return syndbb.redirect(syndbb.url_for('siteadmin_ban')) else: return syndbb.render_template('error_insufficient_permissions.html', title="Insufficient permission") else: return "Invalid Session" else: return "Invalid Request"
def view_user_threads(user): if 'logged_in' in syndbb.session: userid = check_session_by_id(str(syndbb.session['logged_in'])) if userid: dynamic_css_header = ["css/bbcode_editor.css"] isInline = syndbb.request.args.get('inlinecontent', '') threadcheck = d2_activity.query.filter_by(user_id=user).filter(d2_activity.replyto == 0).filter(d2_activity.anonymous != 1).order_by(d2_activity.time.desc()).all() usercheck = d2_user.query.filter_by(user_id=user).first() if usercheck: if threadcheck: thread_list = "" for thread in threadcheck: channelcheck = d2_channels.query.filter_by(id=thread.category).first() if channelcheck and check_channel_auth(channelcheck): if thread.reply_count == 1: replystr = "reply" else: replystr = "replies" lastpost = d2_activity.query.filter_by(replyto=thread.id).order_by(d2_activity.time.desc()).first() if lastpost: latest = lastpost.id latestreplier = lastpost else: latest = thread.id latestreplier = thread thread_list += '''<tr> <td class="home-channel home-channel-icon"><img src="'''+cdn_path()+'''/images/posticons/'''+str(thread.post_icon)+'''.png" alt=""/></td> <td class="home-channel"> <span class="small" style="float:right; text-align: right;"> <span class="timedisplay">'''+recent_date(thread.reply_time)+'''</span><br/> by <a href="/user/'''+get_username_by_id(latestreplier.user_id)+'''" class="profile-inline">'''+get_username_by_id(latestreplier.user_id)+'''</a> <a href="/'''+str(channelcheck.short_name)+'''/'''+str(thread.id)+'''#'''+str(latest)+'''"><img src="'''+cdn_path()+'''/icons/thread_new.png" style="margin-top: -2px;"/></a> </span> <a href="/'''+str(channelcheck.short_name)+'''/'''+str(thread.id)+'''"><b>'''+thread.title+'''</b></a> <span class="small"><br/> <a href="/user/'''+get_username_by_id(thread.user_id)+'''" class="profile-inline">'''+get_username_by_id(thread.user_id)+'''</a>, <span class="timedisplay">'''+recent_date(thread.time)+'''</span> </span> </td> </tr>''' subheading = [] subheading.append('<a href="/user/'+usercheck.username+'">'+usercheck.username+'</a>') return syndbb.render_template('view_user_threads.html', dynamic_css_header=dynamic_css_header, isInline=isInline, thread_list=thread_list, title="All threads by " + usercheck.username, subheading=subheading) else: return syndbb.render_template('invalid.html', title=" • No threads found") else: return syndbb.render_template('invalid.html', title=" • No threads found") else: return syndbb.render_template('error_not_logged_in.html', title="Not logged in")