from datetime import datetime, timedelta
import time
-from django.shortcuts import render_to_response
+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.settings.forms import SettingsSetForm, MaintenanceModeForm
+from forum.forms import MaintenanceModeForm, PageForm
+from forum.settings.forms import SettingsSetForm
-from forum.models import Question, Answer, User, Node, Action
+from forum.models import Question, Answer, User, Node, Action, Page
+from forum.actions import NewPageAction, EditPageAction, PublishAction
from forum import settings
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
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')]
+ 'form', 'moderation', 'css', 'headandfoot', 'head', 'view')]
, 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
@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
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
}
- ]
+ ]
}
@admin_page
def settings_set(request, set_name):
- set = Setting.sets.get(set_name, None)
+ set = Setting.sets.get(set_name, {})
+ current_preview = request.session.get('previewing_settings', {})
if set is None:
raise Http404
form = SettingsSetForm(set, data=request.POST, files=request.FILES)
if form.is_valid():
- form.save()
- request.user.message_set.create(message=_("'%s' settings saved succesfully") % set_name)
+ if 'preview' in request.POST:
+ current_preview.update(form.cleaned_data)
+ request.session['previewing_settings'] = current_preview
+
+ return HttpResponseRedirect(reverse('index'))
+ else:
+ for s in set:
+ current_preview.pop(s.name, None)
+
+ request.session['previewing_settings'] = current_preview
+
+ if not 'reset' in request.POST:
+ form.save()
+ request.user.message_set.create(message=_("'%s' settings saved succesfully") % set_name)
- if set_name in ('minrep', 'badges', 'repgain'):
- settings.SETTINGS_PACK.set_value("custom")
+ if set_name in ('minrep', 'badges', 'repgain'):
+ settings.SETTINGS_PACK.set_value("custom")
- return HttpResponseRedirect(reverse('admin_set', args=[set_name]))
+ return HttpResponseRedirect(reverse('admin_set', args=[set_name]))
else:
- form = SettingsSetForm(set)
+ form = SettingsSetForm(set, unsaved=current_preview)
return 'osqaadmin/set.html', {
- 'form': form,
- 'markdown': set.markdown,
+ 'form': form,
+ 'markdown': set.markdown,
}
@super_user_required
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)
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'))
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')
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
+def static_pages(request):
+ pages = Page.objects.all()
+
+ return ('osqaadmin/static_pages.html', {
+ 'pages': pages,
+ })
+
+@admin_page
+def edit_page(request, id=None):
+ if id:
+ page = get_object_or_404(Page, id=id)
+ else:
+ page = None
+
+ if request.POST:
+ form = PageForm(page, request.POST)
+
+ 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
+ else:
+ 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()
+ elif ('unpublish' in request.POST) and page.published:
+ page.nstate.published.cancel(ip=request.META['REMOTE_ADDR'])
+
+ return HttpResponseRedirect(reverse('admin_edit_page', kwargs={'id': page.id}))
+
+ else:
+ form = PageForm(page)
+
+ if page:
+ published = page.published
+ else:
+ published = False
+
+ return ('osqaadmin/edit_page.html', {
+ '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', {})
+
+