def show_board(request,board_id,board_name=""): try: page = int(request.GET.get('page', '1')) except ValueError: page = 1 try: group = request.user.groups.all()[0] except: group = auth.models.Group.objects.get(name='Gast') board = Board.objects.get(pk=board_id) boards = Board.objects.filter(parent=None,boardrights__group=group,boardrights__can_view=True) rights = BoardRights.objects.get(board= board_id,group=get_group(request.user)) if rights.can_view: threads = Thread.objects.raw('''SELECT t.`id`,`closed`,`moved_from_id`,`board_id`,`author_id`,`posts`,t.`name`, max(p.time_created) time FROM `board_thread` t, `board_post` p WHERE t.id = p.thread_id AND (`board_id` =%s OR `moved_from_id` =%s) GROUP BY t.`id`,`closed`,`moved_from_id`,`board_id`,`author_id`,`posts`,t.`name` ORDER BY max(p.time_created) DESC ''',[board_id,board_id]) pages = Paginator(list(threads), 10) return render_to_response('board.html',{'board':board,'threads':pages.page(page),'rights':rights,'boards':boards},context_instance=RequestContext(request)) else: return HttpResponseForbidden
def show_thread(request,thread_id,thread_name=""): try: thread = Thread.objects.prefetch_related('author').get(pk=thread_id) except: raise Http404 rights = BoardRights.objects.get(board= thread.board_id,group=get_group(request.user)) mod_form = ThreadModForm() try: group = request.user.groups.all()[0] except: group = auth.models.Group.objects.get(name='Gast') boards = Board.objects.filter(parent=None,boardrights__group=group,boardrights__can_view=True) page = 1 try: page = int(request.GET.get('page','1')) except Exception as e: page = 1 #mod_form.initial = if rights.can_view: thread.views = thread.views+1 thread.save() _posts = Post.objects.select_related().filter(thread=thread_id).order_by('time_created') posts = Paginator(_posts,10) ppage = posts.page(page) mark_read(request, thread.board_id, False) return render_to_response('thread.html',{'thread':thread, 't_posts':ppage, 'rights':rights, 'moderation':mod_form, 'boards':boards} ,context_instance=RequestContext(request)) else: return HttpResponseForbidden()
def show_thread(request,thread_id,thread_name=""): try: thread = Thread.objects.get(pk=thread_id) except: raise Http404 rights = BoardRights.objects.get(board= thread.board_id,group=get_group(request.user)) mod_form = ThreadModForm() try: group = request.user.groups.all()[0] except: group = auth.models.Group.objects.get(name='Gast') boards = Board.objects.filter(parent=None,boardrights__group=group,boardrights__can_view=True) page = 1 try: page = int(request.GET.get('page','1')) except Exception,e: page = 1