X-Git-Url: https://git.openstreetmap.org/osqa.git/blobdiff_plain/febc8df810701062ed45c129c0e30c504db28849..094acc5f44c3a7779f42b3d84c86213ba6a1003c:/forum/views/admin.py diff --git a/forum/views/admin.py b/forum/views/admin.py index ddb4852..7b10f7c 100644 --- a/forum/views/admin.py +++ b/forum/views/admin.py @@ -3,11 +3,12 @@ import time from django.shortcuts import render_to_response, get_object_or_404 from django.core.urlresolvers import reverse -from django.http import HttpResponseRedirect, HttpResponse, HttpResponseForbidden, Http404 +from django.http import HttpResponseRedirect, HttpResponse, Http404 +from forum.http_responses import HttpResponseUnauthorized from django.template import RequestContext from django.utils.translation import ugettext as _ from django.utils import simplejson -from django.db.models import Sum +from django.db import models from forum.settings.base import Setting from forum.forms import MaintenanceModeForm, PageForm from forum.settings.forms import SettingsSetForm @@ -21,7 +22,7 @@ def super_user_required(fn): if request.user.is_authenticated() and request.user.is_superuser: return fn(request, *args, **kwargs) else: - return HttpResponseForbidden() + return HttpResponseUnauthorized(request) return wrapper @@ -35,14 +36,13 @@ def admin_page(fn): context['allsets'] = Setting.sets context['othersets'] = sorted( [s for s in Setting.sets.values() if not s.name in - ('basic', 'users', 'email', 'paths', 'extkeys', 'repgain', 'minrep', 'voting', 'badges', 'about', 'faq', 'sidebar', - 'form', 'moderation', 'css', 'headandfoot')] + ('basic', 'users', 'email', 'paths', 'extkeys', 'repgain', 'minrep', 'voting', 'accept', 'badges', 'about', 'faq', 'sidebar', + 'form', 'moderation', 'css', 'headandfoot', 'head', 'view', 'urls')] , lambda s1, s2: s1.weight - s2.weight) unsaved = request.session.get('previewing_settings', {}) context['unsaved'] = set([getattr(settings, s).set.name for s in unsaved.keys() if hasattr(settings, s)]) - return render_to_response(template, context, context_instance=RequestContext(request)) else: return res @@ -52,10 +52,10 @@ def admin_page(fn): @admin_page def dashboard(request): return ('osqaadmin/dashboard.html', { - 'settings_pack': unicode(settings.SETTINGS_PACK), - 'statistics': get_statistics(), - 'recent_activity': get_recent_activity(), - 'flagged_posts': get_flagged_posts(), + 'settings_pack': unicode(settings.SETTINGS_PACK), + 'statistics': get_statistics(), + 'recent_activity': get_recent_activity(), + 'flagged_posts': get_flagged_posts(), }) @super_user_required @@ -71,36 +71,37 @@ def statistics(request): last_month = today - timedelta(days=30) last_month_questions = Question.objects.filter_state(deleted=False).filter(added_at__gt=last_month - ).order_by('added_at').values_list('added_at', flat=True) + ).order_by('added_at').values_list( + 'added_at', flat=True) last_month_n_questions = Question.objects.filter_state(deleted=False).filter(added_at__lt=last_month).count() qgraph_data = simplejson.dumps([ - (time.mktime(d.timetuple()) * 1000, i + last_month_n_questions) - for i, d in enumerate(last_month_questions) + (time.mktime(d.timetuple()) * 1000, i + last_month_n_questions) + for i, d in enumerate(last_month_questions) ]) last_month_users = User.objects.filter(date_joined__gt=last_month - ).order_by('date_joined').values_list('date_joined', flat=True) + ).order_by('date_joined').values_list('date_joined', flat=True) last_month_n_users = User.objects.filter(date_joined__lt=last_month).count() ugraph_data = simplejson.dumps([ - (time.mktime(d.timetuple()) * 1000, i + last_month_n_users) - for i, d in enumerate(last_month_users) + (time.mktime(d.timetuple()) * 1000, i + last_month_n_users) + for i, d in enumerate(last_month_users) ]) return 'osqaadmin/statistics.html', { - 'graphs': [ + 'graphs': [ { - 'id': 'questions_graph', - 'caption': _("Questions Graph"), - 'data': qgraph_data - },{ - 'id': 'userss_graph', - 'caption': _("Users Graph"), - 'data': ugraph_data + 'id': 'questions_graph', + 'caption': _("Questions Graph"), + 'data': qgraph_data + }, { + 'id': 'userss_graph', + 'caption': _("Users Graph"), + 'data': ugraph_data } - ] + ] } @@ -139,8 +140,8 @@ def settings_set(request, set_name): form = SettingsSetForm(set, unsaved=current_preview) return 'osqaadmin/set.html', { - 'form': form, - 'markdown': set.markdown, + 'form': form, + 'markdown': set.markdown, } @super_user_required @@ -167,17 +168,19 @@ def get_flagged_posts(): def get_statistics(): return { - 'total_users': User.objects.all().count(), - 'users_last_24': User.objects.filter(date_joined__gt=(datetime.now() - timedelta(days=1))).count(), - 'total_questions': Question.objects.filter_state(deleted=False).count(), - 'questions_last_24': Question.objects.filter_state(deleted=False).filter(added_at__gt=(datetime.now() - timedelta(days=1))).count(), - 'total_answers': Answer.objects.filter_state(deleted=False).count(), - 'answers_last_24': Answer.objects.filter_state(deleted=False).filter(added_at__gt=(datetime.now() - timedelta(days=1))).count(), + 'total_users': User.objects.all().count(), + 'users_last_24': User.objects.filter(date_joined__gt=(datetime.now() - timedelta(days=1))).count(), + 'total_questions': Question.objects.filter_state(deleted=False).count(), + 'questions_last_24': Question.objects.filter_state(deleted=False).filter( + added_at__gt=(datetime.now() - timedelta(days=1))).count(), + 'total_answers': Answer.objects.filter_state(deleted=False).count(), + 'answers_last_24': Answer.objects.filter_state(deleted=False).filter( + added_at__gt=(datetime.now() - timedelta(days=1))).count(), } @super_user_required def go_bootstrap(request): - #todo: this is the quick and dirty way of implementing a bootstrap mode +#todo: this is the quick and dirty way of implementing a bootstrap mode try: from forum_modules.default_badges import settings as dbsets dbsets.POPULAR_QUESTION_VIEWS.set_value(100) @@ -256,12 +259,12 @@ def go_defaults(request): def recalculate_denormalized(request): for n in Node.objects.all(): n = n.leaf - n.score = n.votes.aggregate(score=Sum('value'))['score'] + n.score = n.votes.aggregate(score=models.Sum('value'))['score'] if not n.score: n.score = 0 n.save() for u in User.objects.all(): - u.reputation = u.reputes.aggregate(reputation=Sum('value'))['reputation'] + u.reputation = u.reputes.aggregate(reputation=models.Sum('value'))['reputation'] u.save() request.user.message_set.create(message=_('All values recalculated')) @@ -275,8 +278,8 @@ def maintenance(request): if form.is_valid(): settings.MAINTAINANCE_MODE.set_value({ - 'allow_ips': form.cleaned_data['ips'], - 'message': form.cleaned_data['message']}) + 'allow_ips': form.cleaned_data['ips'], + 'message': form.cleaned_data['message']}) if 'close' in request.POST: message = _('Maintenance mode enabled') @@ -294,13 +297,14 @@ def maintenance(request): form = MaintenanceModeForm(initial={'ips': request.META['REMOTE_ADDR'], 'message': _('Currently down for maintenance. We\'ll be back soon')}) - return ('osqaadmin/maintenance.html', {'form': form, 'in_maintenance': settings.MAINTAINANCE_MODE.value is not None}) + return ('osqaadmin/maintenance.html', {'form': form, 'in_maintenance': settings.MAINTAINANCE_MODE.value is not None + }) @admin_page def flagged_posts(request): return ('osqaadmin/flagged_posts.html', { - 'flagged_posts': get_flagged_posts(), + 'flagged_posts': get_flagged_posts(), }) @admin_page @@ -308,7 +312,7 @@ def static_pages(request): pages = Page.objects.all() return ('osqaadmin/static_pages.html', { - 'pages': pages, + 'pages': pages, }) @admin_page @@ -324,9 +328,11 @@ def edit_page(request, id=None): if form.is_valid(): if form.has_changed(): if not page: - page = NewPageAction(user=request.user, ip=request.META['REMOTE_ADDR']).save(data=form.cleaned_data).node + page = NewPageAction(user=request.user, ip=request.META['REMOTE_ADDR']).save(data=form.cleaned_data + ).node else: - EditPageAction(user=request.user, node=page, ip=request.META['REMOTE_ADDR']).save(data=form.cleaned_data) + EditPageAction(user=request.user, node=page, ip=request.META['REMOTE_ADDR']).save( + data=form.cleaned_data) if ('publish' in request.POST) and (not page.published): PublishAction(user=request.user, node=page, ip=request.META['REMOTE_ADDR']).save() @@ -344,10 +350,83 @@ def edit_page(request, id=None): published = False return ('osqaadmin/edit_page.html', { - 'page': page, - 'form': form, - 'published': published + 'page': page, + 'form': form, + 'published': published }) +@admin_page +def moderation(request): + if request.POST: + if not 'ids' in request.POST: + verify = None + else: + sort = { + 'high-rep': '-reputation', + 'newer': '-date_joined', + 'older': 'date_joined', + }.get(request.POST.get('sort'), None) + + if sort: + try: + limit = int(request.POST['limit']) + except: + limit = 5 + + verify = User.objects.order_by(sort)[:limit] + else: + verify = None + + if verify: + possible_cheaters = [] + verify = User.objects.order_by(sort)[:5] + + cheat_score_sort = lambda c1, c2: cmp(c2.fdata['fake_score'], c1.fdata['fake_score']) + + for user in verify: + possible_fakes = [] + affecters = User.objects.filter(actions__node__author=user, actions__canceled=False).annotate( + affect_count=models.Count('actions')).order_by('-affect_count') + user_ips = set(Action.objects.filter(user=user).values_list('ip', flat=True).distinct('ip')) + + for affecter in affecters: + if affecter == user: + continue + + data = {'affect_count': affecter.affect_count} + + total_actions = affecter.actions.filter(canceled=False).exclude(node=None).count() + ratio = (float(affecter.affect_count) / float(total_actions)) * 100 + + if total_actions > 10 and ratio > 50: + data['total_actions'] = total_actions + data['action_ratio'] = ratio + + affecter_ips = set( + Action.objects.filter(user=affecter).values_list('ip', flat=True).distinct('ip')) + cross_ips = len(user_ips & affecter_ips) + + data['cross_ip_count'] = cross_ips + data['total_ip_count'] = len(affecter_ips) + data['cross_ip_ratio'] = (float(data['cross_ip_count']) / float(data['total_ip_count'])) * 100 + + if affecter.email_isvalid: + email_score = 0 + else: + email_score = 50.0 + + data['fake_score'] = ((data['cross_ip_ratio'] + data['action_ratio'] + email_score) / 100) * 4 + + affecter.fdata = data + possible_fakes.append(affecter) + + if len(possible_fakes) > 0: + possible_fakes = sorted(possible_fakes, cheat_score_sort) + possible_cheaters.append((user, possible_fakes)) + + return ('osqaadmin/moderation.html', {'cheaters': possible_cheaters}) + + return ('osqaadmin/moderation.html', {}) +