dos2unix

12 files changed, 1001 insertions, 1001 deletions

diff --git a/forum/badges/__init__.py b/forum/badges/__init__.py
index 5ed245af..8d7cd097 100755
--- a/forum/badges/__init__.py
+++ b/forum/badges/__init__.py
@@ -1,10 +1,10 @@
-import re

-

-from forum.badges.base import BadgeImplementation

-from forum.modules import get_modules_script_classes

-

-ALL_BADGES = dict([

-            (re.sub('BadgeImpl', '', name).lower(), cls) for name, cls

-            in get_modules_script_classes('badges', BadgeImplementation).items()

-            if not re.search('AbstractBadgeImpl$', name)

+import re
+
+from forum.badges.base import BadgeImplementation
+from forum.modules import get_modules_script_classes
+
+ALL_BADGES = dict([
+            (re.sub('BadgeImpl', '', name).lower(), cls) for name, cls
+            in get_modules_script_classes('badges', BadgeImplementation).items()
+            if not re.search('AbstractBadgeImpl$', name)
         ])
\ No newline at end of file
diff --git a/forum/badges/base.py b/forum/badges/base.py
index 154d4dfd..03ef3565 100755
--- a/forum/badges/base.py
+++ b/forum/badges/base.py
@@ -1,11 +1,11 @@
-

-

-class BadgeImplementation(object):

-    name = ""

-    description = ""

-

-    def install(self):

-        pass

-

-    def process_job(self):

+
+
+class BadgeImplementation(object):
+    name = ""
+    description = ""
+
+    def install(self):
+        pass
+
+    def process_job(self):
         raise NotImplementedError
\ No newline at end of file
diff --git a/forum/management/commands/pg_base_command.py b/forum/management/commands/pg_base_command.py
index a314c9eb..b3167dcf 100755
--- a/forum/management/commands/pg_base_command.py
+++ b/forum/management/commands/pg_base_command.py
@@ -1,35 +1,35 @@
-#!/usr/bin/env python

-#encoding:utf-8

-#-------------------------------------------------------------------------------

-# Name:        Award badges command

-# Purpose:     This is a command file croning in background process regularly to

-#              query database and award badges for user's special acitivities.

-#

-# Author:      Mike, Sailing

-#

-# Created:     22/01/2009

-# Copyright:   (c) Mike 2009

-# Licence:     GPL V2

-#-------------------------------------------------------------------------------

-

-from datetime import datetime, date

-from django.core.management.base import NoArgsCommand

-from django.db import connection

-from django.shortcuts import get_object_or_404

-from django.contrib.contenttypes.models import ContentType

-

-from forum.models import *

-from forum.const import *

-

-class BaseCommand(NoArgsCommand):

-    def update_activities_auditted(self, cursor, activity_ids):

-        # update processed rows to auditted

-        if len(activity_ids):

-            query = "UPDATE activity SET is_auditted = TRUE WHERE id in (%s)"\

-                    % ','.join('%s' % item for item in activity_ids)

-            cursor.execute(query)

-

-

-

-

-

+#!/usr/bin/env python
+#encoding:utf-8
+#-------------------------------------------------------------------------------
+# Name:        Award badges command
+# Purpose:     This is a command file croning in background process regularly to
+#              query database and award badges for user's special acitivities.
+#
+# Author:      Mike, Sailing
+#
+# Created:     22/01/2009
+# Copyright:   (c) Mike 2009
+# Licence:     GPL V2
+#-------------------------------------------------------------------------------
+
+from datetime import datetime, date
+from django.core.management.base import NoArgsCommand
+from django.db import connection
+from django.shortcuts import get_object_or_404
+from django.contrib.contenttypes.models import ContentType
+
+from forum.models import *
+from forum.const import *
+
+class BaseCommand(NoArgsCommand):
+    def update_activities_auditted(self, cursor, activity_ids):
+        # update processed rows to auditted
+        if len(activity_ids):
+            query = "UPDATE activity SET is_auditted = TRUE WHERE id in (%s)"\
+                    % ','.join('%s' % item for item in activity_ids)
+            cursor.execute(query)
+
+
+
+
+
diff --git a/forum/management/commands/pg_clean_award_badges.py b/forum/management/commands/pg_clean_award_badges.py
index aa93e76b..b3925a68 100755
--- a/forum/management/commands/pg_clean_award_badges.py
+++ b/forum/management/commands/pg_clean_award_badges.py
@@ -1,59 +1,59 @@
-#-------------------------------------------------------------------------------

-# Name:        Award badges command

-# Purpose:     This is a command file croning in background process regularly to

-#              query database and award badges for user's special acitivities.

-#

-# Author:      Mike

-#

-# Created:     18/01/2009

-# Copyright:   (c) Mike 2009

-# Licence:     GPL V2

-#-------------------------------------------------------------------------------

-#!/usr/bin/env python

-#encoding:utf-8

-from django.core.management.base import NoArgsCommand

-from django.db import connection

-from django.shortcuts import get_object_or_404

-from django.contrib.contenttypes.models import ContentType

-

-from forum.models import *

-

-class Command(NoArgsCommand):

-    def handle_noargs(self, **options):

-        try:

-            try:

-                self.clean_awards()

-            except Exception, e:

-                print e

-        finally:

-            connection.close()

-

-    def clean_awards(self):

-        Award.objects.all().delete()

-

-        award_type =ContentType.objects.get_for_model(Award)

-        Activity.objects.filter(content_type=award_type).delete()

-

-        for user in User.objects.all():

-            user.gold = 0

-            user.silver = 0

-            user.bronze = 0

-            user.save()

-

-        for badge in Badge.objects.all():

-            badge.awarded_count = 0

-            badge.save()

-

-        query = "UPDATE activity SET is_auditted = FALSE"

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-        finally:

-            cursor.close()

-            connection.close()

-

-def main():

-    pass

-

-if __name__ == '__main__':

+#-------------------------------------------------------------------------------
+# Name:        Award badges command
+# Purpose:     This is a command file croning in background process regularly to
+#              query database and award badges for user's special acitivities.
+#
+# Author:      Mike
+#
+# Created:     18/01/2009
+# Copyright:   (c) Mike 2009
+# Licence:     GPL V2
+#-------------------------------------------------------------------------------
+#!/usr/bin/env python
+#encoding:utf-8
+from django.core.management.base import NoArgsCommand
+from django.db import connection
+from django.shortcuts import get_object_or_404
+from django.contrib.contenttypes.models import ContentType
+
+from forum.models import *
+
+class Command(NoArgsCommand):
+    def handle_noargs(self, **options):
+        try:
+            try:
+                self.clean_awards()
+            except Exception, e:
+                print e
+        finally:
+            connection.close()
+
+    def clean_awards(self):
+        Award.objects.all().delete()
+
+        award_type =ContentType.objects.get_for_model(Award)
+        Activity.objects.filter(content_type=award_type).delete()
+
+        for user in User.objects.all():
+            user.gold = 0
+            user.silver = 0
+            user.bronze = 0
+            user.save()
+
+        for badge in Badge.objects.all():
+            badge.awarded_count = 0
+            badge.save()
+
+        query = "UPDATE activity SET is_auditted = FALSE"
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+        finally:
+            cursor.close()
+            connection.close()
+
+def main():
+    pass
+
+if __name__ == '__main__':
     main()
\ No newline at end of file
diff --git a/forum/management/commands/pg_multi_award_badges.py b/forum/management/commands/pg_multi_award_badges.py
index 88bea762..75f84bfe 100755
--- a/forum/management/commands/pg_multi_award_badges.py
+++ b/forum/management/commands/pg_multi_award_badges.py
@@ -1,348 +1,348 @@
-#!/usr/bin/env python

-#encoding:utf-8

-#-------------------------------------------------------------------------------

-# Name:        Award badges command

-# Purpose:     This is a command file croning in background process regularly to

-#              query database and award badges for user's special acitivities.

-#

-# Author:      Mike, Sailing

-#

-# Created:     22/01/2009

-# Copyright:   (c) Mike 2009

-# Licence:     GPL V2

-#-------------------------------------------------------------------------------

-

-from datetime import datetime, date

-from django.core.management.base import NoArgsCommand

-from django.db import connection

-from django.shortcuts import get_object_or_404

-from django.contrib.contenttypes.models import ContentType

-

-from forum.models import *

-from forum.const import *

-from pg_base_command import BaseCommand

-"""

-(1, '????', 3, '????', '?????3?????????', 1, 0),

-(2, '????', 3, '????', '?????3?????????', 1, 0),

-(3, '????', 3, '????', '????10???', 1, 0),

-(4, '????', 3, '????', '????10???', 1, 0),

-(5, '???', 3, '???', '??10???', 0, 0),

-(6, '????', 3, '????', '????????1000??', 1, 0),

-(7, '???', 3, '???', '?????????', 0, 0),

-(8, '???', 3, '???', '???????', 0, 0),

-(9, '???', 3, '???', '??????', 0, 0),

-(10, '??', 3, '??', '???????', 0, 0),

-(11, '??', 3, '??', '???????', 0, 0),

-(12, '??', 3, '??', '???????', 0, 0),

-(13, '??', 3, '??', '???????????????', 0, 0),

-(14, '???', 3, '???', '??????', 0, 0),

-(15, '??', 3, '??', '??????????????????', 0, 0),

-(16, '????', 3, '????', '????????????', 0, 0),

-(17, '????', 3, '????', '??????????3??????', 1, 0),

-(18, '??????', 1, '??????', '????100????', 1, 0),

-(19, '??????', 1, '??????', '????100????', 1, 0),

-(20, '???', 1, '???', '???100?????', 1, 0),

-(21, '????', 1, '????', '????????10000??', 1, 0),

-(22, 'alpha??', 2, 'alpha??', '?????????', 0, 0),

-(23, '????', 2, '????', '????25????', 1, 0),

-(24, '????', 2, '????', '????25????', 1, 0),

-(25, '?????', 2, '?????', '???25?????', 1, 0),

-(26, '????', 2, '????', '??300???', 0, 0),

-(27, '????', 2, '????', '???100???', 0, 0),

-(28, '??', 2, '??', '?????????', 0, 0),

-(29, '??', 2, '??', '???????????', 0, 0),

-(30, '??', 2, '??', '?????????', 0, 0),

-(31, '??????', 2, '??????', '????????2500??', 1, 0),

-(32, '???', 2, '???', '??????????10???', 0, 0),

-(33, 'beta??', 2, 'beta??', 'beta??????', 0, 0),

-(34, '??', 2, '??', '?????????????40??', 1, 0),

-(35, '??', 2, '??', '???60??????????5???', 1, 0),

-(36, '????', 2, '????', '??????50???????', 1, 0);

-

-

-TYPE_ACTIVITY_ASK_QUESTION=1

-TYPE_ACTIVITY_ANSWER=2

-TYPE_ACTIVITY_COMMENT_QUESTION=3

-TYPE_ACTIVITY_COMMENT_ANSWER=4

-TYPE_ACTIVITY_UPDATE_QUESTION=5

-TYPE_ACTIVITY_UPDATE_ANSWER=6

-TYPE_ACTIVITY_PRIZE=7

-TYPE_ACTIVITY_MARK_ANSWER=8

-TYPE_ACTIVITY_VOTE_UP=9

-TYPE_ACTIVITY_VOTE_DOWN=10

-TYPE_ACTIVITY_CANCEL_VOTE=11

-TYPE_ACTIVITY_DELETE_QUESTION=12

-TYPE_ACTIVITY_DELETE_ANSWER=13

-TYPE_ACTIVITY_MARK_OFFENSIVE=14

-TYPE_ACTIVITY_UPDATE_TAGS=15

-TYPE_ACTIVITY_FAVORITE=16

-TYPE_ACTIVITY_USER_FULL_UPDATED = 17

-"""

-

-class Command(BaseCommand):

-    def handle_noargs(self, **options):

-        try:

-            try:

-                self.delete_question_be_voted_up_3()

-                self.delete_answer_be_voted_up_3()

-                self.delete_question_be_vote_down_3()

-                self.delete_answer_be_voted_down_3()

-                self.answer_be_voted_up_10()

-                self.question_be_voted_up_10()

-                self.question_view_1000()

-                self.answer_self_question_be_voted_up_3()

-                self.answer_be_voted_up_100()

-                self.question_be_voted_up_100()

-                self.question_be_favorited_100()

-                self.question_view_10000()

-                self.answer_be_voted_up_25()

-                self.question_be_voted_up_25()

-                self.question_be_favorited_25()

-                self.question_view_2500()

-                self.answer_be_accepted_and_voted_up_40()

-                self.question_be_answered_after_60_days_and_be_voted_up_5()

-                self.created_tag_be_used_in_question_50()

-            except Exception, e:

-                print e

-        finally:

-            connection.close()

-

-    def delete_question_be_voted_up_3(self):

-        """

-        (1, '????', 3, '????', '?????3?????????', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, question q WHERE act.object_id = q.id AND\

-                act.activity_type = %s AND\

-                q.vote_up_count >=3 AND \

-                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_QUESTION)

-        self.__process_activities_badge(query, 1, Question)

-

-    def delete_answer_be_voted_up_3(self):

-        """

-        (1, '????', 3, '????', '?????3?????????', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, answer an WHERE act.object_id = an.id AND\

-                act.activity_type = %s AND\

-                an.vote_up_count >=3 AND \

-                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_ANSWER)

-        self.__process_activities_badge(query, 1, Answer)

-

-    def delete_question_be_vote_down_3(self):

-        """

-        (2, '????', 3, '????', '?????3?????????', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, question q WHERE act.object_id = q.id AND\

-                act.activity_type = %s AND\

-                q.vote_down_count >=3 AND \

-                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_QUESTION)

-        content_type = ContentType.objects.get_for_model(Question)

-        self.__process_activities_badge(query, 2, Question)

-

-    def delete_answer_be_voted_down_3(self):

-        """

-        (2, '????', 3, '????', '?????3?????????', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, answer an WHERE act.object_id = an.id AND\

-                act.activity_type = %s AND\

-                an.vote_down_count >=3 AND \

-                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_ANSWER)

-        self.__process_activities_badge(query, 2, Answer)

-

-    def answer_be_voted_up_10(self):

-        """

-        (3, '????', 3, '????', '????10???', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM \

-                    activity act, answer a WHERE act.object_id = a.id AND\

-                    act.activity_type = %s AND \

-                    a.vote_up_count >= 10 AND\

-                    not act.is_auditted" % (TYPE_ACTIVITY_ANSWER)

-        self.__process_activities_badge(query, 3, Answer)

-

-    def question_be_voted_up_10(self):

-        """

-        (4, '????', 3, '????', '????10???', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM \

-                    activity act, question q WHERE act.object_id = q.id AND\

-                    act.activity_type = %s AND \

-                    q.vote_up_count >= 10 AND\

-                    not act.is_auditted" % (TYPE_ACTIVITY_ASK_QUESTION)

-        self.__process_activities_badge(query, 4, Question)

-

-    def question_view_1000(self):

-        """

-        (6, '????', 3, '????', '????????1000??', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM \

-                    activity act, question q WHERE act.activity_type = %s AND\

-                    act.object_id = q.id AND \

-                    q.view_count >= 1000 AND\

-                    act.object_id NOT IN \

-                        (SELECT object_id FROM award WHERE award.badge_id = %s)" % (TYPE_ACTIVITY_ASK_QUESTION, 6)

-        self.__process_activities_badge(query, 6, Question, False)

-

-    def answer_self_question_be_voted_up_3(self):

-        """

-        (17, '????', 3, '????', '??????????3??????', 1, 0),

-        """

-        query = "SELECT act.id, act.user_id, act.object_id FROM \

-                    activity act, answer an WHERE act.activity_type = %s AND\

-                    act.object_id = an.id AND\

-                    an.vote_up_count >= 3 AND\

-                    act.user_id = (SELECT user_id FROM question q WHERE q.id = an.question_id) AND\

-                    act.object_id NOT IN \

-                        (SELECT object_id FROM award WHERE award.badge_id = %s)" % (TYPE_ACTIVITY_ANSWER, 17)

-        self.__process_activities_badge(query, 17, Question, False)

-

-    def answer_be_voted_up_100(self):

-        """

-        (18, '??????', 1, '??????', '????100????', 1, 0),

-        """

-        query = "SELECT an.id, an.author_id FROM answer an WHERE an.vote_up_count >= 100 AND an.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (18)

-

-        self.__process_badge(query, 18, Answer)

-

-    def question_be_voted_up_100(self):

-        """

-        (19, '??????', 1, '??????', '????100????', 1, 0),

-        """

-        query = "SELECT q.id, q.author_id FROM question q WHERE q.vote_up_count >= 100 AND q.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (19)

-

-        self.__process_badge(query, 19, Question)

-

-    def question_be_favorited_100(self):

-        """

-        (20, '???', 1, '???', '???100?????', 1, 0),

-        """

-        query = "SELECT q.id, q.author_id FROM question q WHERE q.favourite_count >= 100 AND q.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (20)

-

-        self.__process_badge(query, 20, Question)

-

-    def question_view_10000(self):

-        """

-        (21, '????', 1, '????', '????????10000??', 1, 0),

-        """

-        query = "SELECT q.id, q.author_id FROM question q WHERE q.view_count >= 10000 AND q.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (21)

-

-        self.__process_badge(query, 21, Question)

-

-    def answer_be_voted_up_25(self):

-        """

-        (23, '????', 2, '????', '????25????', 1, 0),

-        """

-        query = "SELECT a.id, a.author_id FROM answer a WHERE a.vote_up_count >= 25 AND a.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (23)

-

-        self.__process_badge(query, 23, Answer)

-

-    def question_be_voted_up_25(self):

-        """

-        (24, '????', 2, '????', '????25????', 1, 0),

-        """

-        query = "SELECT q.id, q.author_id FROM question q WHERE q.vote_up_count >= 25 AND q.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (24)

-

-        self.__process_badge(query, 24, Question)

-

-    def question_be_favorited_25(self):

-        """

-        (25, '?????', 2, '?????', '???25?????', 1, 0),

-        """

-        query = "SELECT q.id, q.author_id FROM question q WHERE q.favourite_count >= 25 AND q.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (25)

-

-        self.__process_badge(query, 25, Question)

-

-    def question_view_2500(self):

-        """

-        (31, '??????', 2, '??????', '????????2500??', 1, 0),

-        """

-        query = "SELECT q.id, q.author_id FROM question q WHERE q.view_count >= 2500 AND q.id NOT IN \

-                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (31)

-

-        self.__process_badge(query, 31, Question)

-

-    def answer_be_accepted_and_voted_up_40(self):

-        """

-        (34, '??', 2, '??', '?????????????40??', 1, 0),

-        """

-        query = "SELECT a.id, a.author_id FROM answer a WHERE a.vote_up_count >= 40 AND\

-                    a.accepted AND\

-                    a.id NOT IN \

-                    (SELECT object_id FROM award WHERE award.badge_id = %s)" % (34)

-

-        self.__process_badge(query, 34, Answer)

-

-    def question_be_answered_after_60_days_and_be_voted_up_5(self):

-        """

-        (35, '??', 2, '??', '???60??????????5???', 1, 0),

-        """

-        query = "SELECT a.id, a.author_id FROM question q, answer a WHERE q.id = a.question_id AND\

-                    (a.added_at + '60 day'::INTERVAL) >= q.added_at AND\

-                    a.vote_up_count >= 5 AND \

-                    a.id NOT IN \

-                    (SELECT object_id FROM award WHERE award.badge_id = %s)" % (35)

-

-        self.__process_badge(query, 35, Answer)

-

-    def created_tag_be_used_in_question_50(self):

-        """

-        (36, '????', 2, '????', '??????50???????', 1, 0);

-        """

-        query = "SELECT t.id, t.created_by_id FROM tag t, auth_user u WHERE t.created_by_id = u.id AND \

-                    t. used_count >= 50 AND \

-                    t.id NOT IN \

-                    (SELECT object_id FROM award WHERE award.badge_id = %s)" % (36)

-

-        self.__process_badge(query, 36, Tag)

-

-    def __process_activities_badge(self, query, badge, content_object, update_auditted=True):

-        content_type = ContentType.objects.get_for_model(content_object)

-

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-

-            if update_auditted:

-                activity_ids = []

-            badge = get_object_or_404(Badge, id=badge)

-            for row in rows:

-                activity_id = row[0]

-                user_id = row[1]

-                object_id = row[2]

-

-                user = get_object_or_404(User, id=user_id)

-                award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)

-                award.save()

-

-                if update_auditted:

-                    activity_ids.append(activity_id)

-

-            if update_auditted:

-                self.update_activities_auditted(cursor, activity_ids)

-        finally:

-            cursor.close()

-

-    def __process_badge(self, query, badge, content_object):

-        content_type = ContentType.objects.get_for_model(Answer)

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-

-            badge = get_object_or_404(Badge, id=badge)

-            for row in rows:

-                object_id = row[0]

-                user_id = row[1]

-

-                user = get_object_or_404(User, id=user_id)

-                award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)

-                award.save()

-        finally:

-            cursor.close()

+#!/usr/bin/env python
+#encoding:utf-8
+#-------------------------------------------------------------------------------
+# Name:        Award badges command
+# Purpose:     This is a command file croning in background process regularly to
+#              query database and award badges for user's special acitivities.
+#
+# Author:      Mike, Sailing
+#
+# Created:     22/01/2009
+# Copyright:   (c) Mike 2009
+# Licence:     GPL V2
+#-------------------------------------------------------------------------------
+
+from datetime import datetime, date
+from django.core.management.base import NoArgsCommand
+from django.db import connection
+from django.shortcuts import get_object_or_404
+from django.contrib.contenttypes.models import ContentType
+
+from forum.models import *
+from forum.const import *
+from pg_base_command import BaseCommand
+"""
+(1, '????', 3, '????', '?????3?????????', 1, 0),
+(2, '????', 3, '????', '?????3?????????', 1, 0),
+(3, '????', 3, '????', '????10???', 1, 0),
+(4, '????', 3, '????', '????10???', 1, 0),
+(5, '???', 3, '???', '??10???', 0, 0),
+(6, '????', 3, '????', '????????1000??', 1, 0),
+(7, '???', 3, '???', '?????????', 0, 0),
+(8, '???', 3, '???', '???????', 0, 0),
+(9, '???', 3, '???', '??????', 0, 0),
+(10, '??', 3, '??', '???????', 0, 0),
+(11, '??', 3, '??', '???????', 0, 0),
+(12, '??', 3, '??', '???????', 0, 0),
+(13, '??', 3, '??', '???????????????', 0, 0),
+(14, '???', 3, '???', '??????', 0, 0),
+(15, '??', 3, '??', '??????????????????', 0, 0),
+(16, '????', 3, '????', '????????????', 0, 0),
+(17, '????', 3, '????', '??????????3??????', 1, 0),
+(18, '??????', 1, '??????', '????100????', 1, 0),
+(19, '??????', 1, '??????', '????100????', 1, 0),
+(20, '???', 1, '???', '???100?????', 1, 0),
+(21, '????', 1, '????', '????????10000??', 1, 0),
+(22, 'alpha??', 2, 'alpha??', '?????????', 0, 0),
+(23, '????', 2, '????', '????25????', 1, 0),
+(24, '????', 2, '????', '????25????', 1, 0),
+(25, '?????', 2, '?????', '???25?????', 1, 0),
+(26, '????', 2, '????', '??300???', 0, 0),
+(27, '????', 2, '????', '???100???', 0, 0),
+(28, '??', 2, '??', '?????????', 0, 0),
+(29, '??', 2, '??', '???????????', 0, 0),
+(30, '??', 2, '??', '?????????', 0, 0),
+(31, '??????', 2, '??????', '????????2500??', 1, 0),
+(32, '???', 2, '???', '??????????10???', 0, 0),
+(33, 'beta??', 2, 'beta??', 'beta??????', 0, 0),
+(34, '??', 2, '??', '?????????????40??', 1, 0),
+(35, '??', 2, '??', '???60??????????5???', 1, 0),
+(36, '????', 2, '????', '??????50???????', 1, 0);
+
+
+TYPE_ACTIVITY_ASK_QUESTION=1
+TYPE_ACTIVITY_ANSWER=2
+TYPE_ACTIVITY_COMMENT_QUESTION=3
+TYPE_ACTIVITY_COMMENT_ANSWER=4
+TYPE_ACTIVITY_UPDATE_QUESTION=5
+TYPE_ACTIVITY_UPDATE_ANSWER=6
+TYPE_ACTIVITY_PRIZE=7
+TYPE_ACTIVITY_MARK_ANSWER=8
+TYPE_ACTIVITY_VOTE_UP=9
+TYPE_ACTIVITY_VOTE_DOWN=10
+TYPE_ACTIVITY_CANCEL_VOTE=11
+TYPE_ACTIVITY_DELETE_QUESTION=12
+TYPE_ACTIVITY_DELETE_ANSWER=13
+TYPE_ACTIVITY_MARK_OFFENSIVE=14
+TYPE_ACTIVITY_UPDATE_TAGS=15
+TYPE_ACTIVITY_FAVORITE=16
+TYPE_ACTIVITY_USER_FULL_UPDATED = 17
+"""
+
+class Command(BaseCommand):
+    def handle_noargs(self, **options):
+        try:
+            try:
+                self.delete_question_be_voted_up_3()
+                self.delete_answer_be_voted_up_3()
+                self.delete_question_be_vote_down_3()
+                self.delete_answer_be_voted_down_3()
+                self.answer_be_voted_up_10()
+                self.question_be_voted_up_10()
+                self.question_view_1000()
+                self.answer_self_question_be_voted_up_3()
+                self.answer_be_voted_up_100()
+                self.question_be_voted_up_100()
+                self.question_be_favorited_100()
+                self.question_view_10000()
+                self.answer_be_voted_up_25()
+                self.question_be_voted_up_25()
+                self.question_be_favorited_25()
+                self.question_view_2500()
+                self.answer_be_accepted_and_voted_up_40()
+                self.question_be_answered_after_60_days_and_be_voted_up_5()
+                self.created_tag_be_used_in_question_50()
+            except Exception, e:
+                print e
+        finally:
+            connection.close()
+
+    def delete_question_be_voted_up_3(self):
+        """
+        (1, '????', 3, '????', '?????3?????????', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, question q WHERE act.object_id = q.id AND\
+                act.activity_type = %s AND\
+                q.vote_up_count >=3 AND \
+                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_QUESTION)
+        self.__process_activities_badge(query, 1, Question)
+
+    def delete_answer_be_voted_up_3(self):
+        """
+        (1, '????', 3, '????', '?????3?????????', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, answer an WHERE act.object_id = an.id AND\
+                act.activity_type = %s AND\
+                an.vote_up_count >=3 AND \
+                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_ANSWER)
+        self.__process_activities_badge(query, 1, Answer)
+
+    def delete_question_be_vote_down_3(self):
+        """
+        (2, '????', 3, '????', '?????3?????????', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, question q WHERE act.object_id = q.id AND\
+                act.activity_type = %s AND\
+                q.vote_down_count >=3 AND \
+                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_QUESTION)
+        content_type = ContentType.objects.get_for_model(Question)
+        self.__process_activities_badge(query, 2, Question)
+
+    def delete_answer_be_voted_down_3(self):
+        """
+        (2, '????', 3, '????', '?????3?????????', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM activity act, answer an WHERE act.object_id = an.id AND\
+                act.activity_type = %s AND\
+                an.vote_down_count >=3 AND \
+                not act.is_auditted" % (TYPE_ACTIVITY_DELETE_ANSWER)
+        self.__process_activities_badge(query, 2, Answer)
+
+    def answer_be_voted_up_10(self):
+        """
+        (3, '????', 3, '????', '????10???', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM \
+                    activity act, answer a WHERE act.object_id = a.id AND\
+                    act.activity_type = %s AND \
+                    a.vote_up_count >= 10 AND\
+                    not act.is_auditted" % (TYPE_ACTIVITY_ANSWER)
+        self.__process_activities_badge(query, 3, Answer)
+
+    def question_be_voted_up_10(self):
+        """
+        (4, '????', 3, '????', '????10???', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM \
+                    activity act, question q WHERE act.object_id = q.id AND\
+                    act.activity_type = %s AND \
+                    q.vote_up_count >= 10 AND\
+                    not act.is_auditted" % (TYPE_ACTIVITY_ASK_QUESTION)
+        self.__process_activities_badge(query, 4, Question)
+
+    def question_view_1000(self):
+        """
+        (6, '????', 3, '????', '????????1000??', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM \
+                    activity act, question q WHERE act.activity_type = %s AND\
+                    act.object_id = q.id AND \
+                    q.view_count >= 1000 AND\
+                    act.object_id NOT IN \
+                        (SELECT object_id FROM award WHERE award.badge_id = %s)" % (TYPE_ACTIVITY_ASK_QUESTION, 6)
+        self.__process_activities_badge(query, 6, Question, False)
+
+    def answer_self_question_be_voted_up_3(self):
+        """
+        (17, '????', 3, '????', '??????????3??????', 1, 0),
+        """
+        query = "SELECT act.id, act.user_id, act.object_id FROM \
+                    activity act, answer an WHERE act.activity_type = %s AND\
+                    act.object_id = an.id AND\
+                    an.vote_up_count >= 3 AND\
+                    act.user_id = (SELECT user_id FROM question q WHERE q.id = an.question_id) AND\
+                    act.object_id NOT IN \
+                        (SELECT object_id FROM award WHERE award.badge_id = %s)" % (TYPE_ACTIVITY_ANSWER, 17)
+        self.__process_activities_badge(query, 17, Question, False)
+
+    def answer_be_voted_up_100(self):
+        """
+        (18, '??????', 1, '??????', '????100????', 1, 0),
+        """
+        query = "SELECT an.id, an.author_id FROM answer an WHERE an.vote_up_count >= 100 AND an.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (18)
+
+        self.__process_badge(query, 18, Answer)
+
+    def question_be_voted_up_100(self):
+        """
+        (19, '??????', 1, '??????', '????100????', 1, 0),
+        """
+        query = "SELECT q.id, q.author_id FROM question q WHERE q.vote_up_count >= 100 AND q.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (19)
+
+        self.__process_badge(query, 19, Question)
+
+    def question_be_favorited_100(self):
+        """
+        (20, '???', 1, '???', '???100?????', 1, 0),
+        """
+        query = "SELECT q.id, q.author_id FROM question q WHERE q.favourite_count >= 100 AND q.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (20)
+
+        self.__process_badge(query, 20, Question)
+
+    def question_view_10000(self):
+        """
+        (21, '????', 1, '????', '????????10000??', 1, 0),
+        """
+        query = "SELECT q.id, q.author_id FROM question q WHERE q.view_count >= 10000 AND q.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (21)
+
+        self.__process_badge(query, 21, Question)
+
+    def answer_be_voted_up_25(self):
+        """
+        (23, '????', 2, '????', '????25????', 1, 0),
+        """
+        query = "SELECT a.id, a.author_id FROM answer a WHERE a.vote_up_count >= 25 AND a.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (23)
+
+        self.__process_badge(query, 23, Answer)
+
+    def question_be_voted_up_25(self):
+        """
+        (24, '????', 2, '????', '????25????', 1, 0),
+        """
+        query = "SELECT q.id, q.author_id FROM question q WHERE q.vote_up_count >= 25 AND q.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (24)
+
+        self.__process_badge(query, 24, Question)
+
+    def question_be_favorited_25(self):
+        """
+        (25, '?????', 2, '?????', '???25?????', 1, 0),
+        """
+        query = "SELECT q.id, q.author_id FROM question q WHERE q.favourite_count >= 25 AND q.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (25)
+
+        self.__process_badge(query, 25, Question)
+
+    def question_view_2500(self):
+        """
+        (31, '??????', 2, '??????', '????????2500??', 1, 0),
+        """
+        query = "SELECT q.id, q.author_id FROM question q WHERE q.view_count >= 2500 AND q.id NOT IN \
+                (SELECT object_id FROM award WHERE award.badge_id = %s)" % (31)
+
+        self.__process_badge(query, 31, Question)
+
+    def answer_be_accepted_and_voted_up_40(self):
+        """
+        (34, '??', 2, '??', '?????????????40??', 1, 0),
+        """
+        query = "SELECT a.id, a.author_id FROM answer a WHERE a.vote_up_count >= 40 AND\
+                    a.accepted AND\
+                    a.id NOT IN \
+                    (SELECT object_id FROM award WHERE award.badge_id = %s)" % (34)
+
+        self.__process_badge(query, 34, Answer)
+
+    def question_be_answered_after_60_days_and_be_voted_up_5(self):
+        """
+        (35, '??', 2, '??', '???60??????????5???', 1, 0),
+        """
+        query = "SELECT a.id, a.author_id FROM question q, answer a WHERE q.id = a.question_id AND\
+                    (a.added_at + '60 day'::INTERVAL) >= q.added_at AND\
+                    a.vote_up_count >= 5 AND \
+                    a.id NOT IN \
+                    (SELECT object_id FROM award WHERE award.badge_id = %s)" % (35)
+
+        self.__process_badge(query, 35, Answer)
+
+    def created_tag_be_used_in_question_50(self):
+        """
+        (36, '????', 2, '????', '??????50???????', 1, 0);
+        """
+        query = "SELECT t.id, t.created_by_id FROM tag t, auth_user u WHERE t.created_by_id = u.id AND \
+                    t. used_count >= 50 AND \
+                    t.id NOT IN \
+                    (SELECT object_id FROM award WHERE award.badge_id = %s)" % (36)
+
+        self.__process_badge(query, 36, Tag)
+
+    def __process_activities_badge(self, query, badge, content_object, update_auditted=True):
+        content_type = ContentType.objects.get_for_model(content_object)
+
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+
+            if update_auditted:
+                activity_ids = []
+            badge = get_object_or_404(Badge, id=badge)
+            for row in rows:
+                activity_id = row[0]
+                user_id = row[1]
+                object_id = row[2]
+
+                user = get_object_or_404(User, id=user_id)
+                award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)
+                award.save()
+
+                if update_auditted:
+                    activity_ids.append(activity_id)
+
+            if update_auditted:
+                self.update_activities_auditted(cursor, activity_ids)
+        finally:
+            cursor.close()
+
+    def __process_badge(self, query, badge, content_object):
+        content_type = ContentType.objects.get_for_model(Answer)
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+
+            badge = get_object_or_404(Badge, id=badge)
+            for row in rows:
+                object_id = row[0]
+                user_id = row[1]
+
+                user = get_object_or_404(User, id=user_id)
+                award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)
+                award.save()
+        finally:
+            cursor.close()
diff --git a/forum/management/commands/pg_once_award_badges.py b/forum/management/commands/pg_once_award_badges.py
index 3dd6646c..b2f79363 100755
--- a/forum/management/commands/pg_once_award_badges.py
+++ b/forum/management/commands/pg_once_award_badges.py
@@ -1,350 +1,350 @@
-#!/usr/bin/env python

-#encoding:utf-8

-#-------------------------------------------------------------------------------

-# Name:        Award badges command

-# Purpose:     This is a command file croning in background process regularly to

-#              query database and award badges for user's special acitivities.

-#

-# Author:      Mike, Sailing

-#

-# Created:     18/01/2009

-# Copyright:   (c) Mike 2009

-# Licence:     GPL V2

-#-------------------------------------------------------------------------------

-

-from datetime import datetime, date

-from django.db import connection

-from django.shortcuts import get_object_or_404

-from django.contrib.contenttypes.models import ContentType

-

-from forum.models import *

-from forum.const import *

-from pg_base_command import BaseCommand

-"""

-(1, '????', 3, '????', '?????3?????????', 1, 0),

-(2, '????', 3, '????', '?????3?????????', 1, 0),

-(3, '????', 3, '????', '????10???', 1, 0),

-(4, '????', 3, '????', '????10???', 1, 0),

-(5, '???', 3, '???', '??10???', 0, 0),

-(6, '????', 3, '????', '????????1000??', 1, 0),

-(7, '???', 3, '???', '?????????', 0, 0),

-(8, '???', 3, '???', '???????', 0, 0),

-(9, '???', 3, '???', '??????', 0, 0),

-(10, '??', 3, '??', '???????', 0, 0),

-(11, '??', 3, '??', '???????', 0, 0),

-(12, '??', 3, '??', '???????', 0, 0),

-(13, '??', 3, '??', '???????????????', 0, 0),

-(14, '???', 3, '???', '??????', 0, 0),

-(15, '??', 3, '??', '??????????????????', 0, 0),

-(16, '????', 3, '????', '????????????', 0, 0),

-(17, '????', 3, '????', '??????????3??????', 1, 0),

-(18, '??????', 1, '??????', '????100????', 1, 0),

-(19, '??????', 1, '??????', '????100????', 1, 0),

-(20, '???', 1, '???', '???100?????', 1, 0),

-(21, '????', 1, '????', '????????10000??', 1, 0),

-(22, 'alpha??', 2, 'alpha??', '?????????', 0, 0),

-(23, '????', 2, '????', '????25????', 1, 0),

-(24, '????', 2, '????', '????25????', 1, 0),

-(25, '?????', 2, '?????', '???25?????', 1, 0),

-(26, '????', 2, '????', '??300???', 0, 0),

-(27, '????', 2, '????', '???100???', 0, 0),

-(28, '??', 2, '??', '?????????', 0, 0),

-(29, '??', 2, '??', '???????????', 0, 0),

-(30, '??', 2, '??', '?????????', 0, 0),

-(31, '??????', 2, '??????', '????????2500??', 1, 0),

-(32, '???', 2, '???', '??????????10???', 0, 0),

-(33, 'beta??', 2, 'beta??', 'beta??????', 0, 0),

-(34, '??', 2, '??', '?????????????40??', 1, 0),

-(35, '??', 2, '??', '???60??????????5???', 1, 0),

-(36, '????', 2, '????', '??????50???????', 1, 0);

-

-

-TYPE_ACTIVITY_ASK_QUESTION=1

-TYPE_ACTIVITY_ANSWER=2

-TYPE_ACTIVITY_COMMENT_QUESTION=3

-TYPE_ACTIVITY_COMMENT_ANSWER=4

-TYPE_ACTIVITY_UPDATE_QUESTION=5

-TYPE_ACTIVITY_UPDATE_ANSWER=6

-TYPE_ACTIVITY_PRIZE=7

-TYPE_ACTIVITY_MARK_ANSWER=8

-TYPE_ACTIVITY_VOTE_UP=9

-TYPE_ACTIVITY_VOTE_DOWN=10

-TYPE_ACTIVITY_CANCEL_VOTE=11

-TYPE_ACTIVITY_DELETE_QUESTION=12

-TYPE_ACTIVITY_DELETE_ANSWER=13

-TYPE_ACTIVITY_MARK_OFFENSIVE=14

-TYPE_ACTIVITY_UPDATE_TAGS=15

-TYPE_ACTIVITY_FAVORITE=16

-TYPE_ACTIVITY_USER_FULL_UPDATED = 17

-"""

-

-BADGE_AWARD_TYPE_FIRST = {

-    TYPE_ACTIVITY_MARK_OFFENSIVE : 7,

-    TYPE_ACTIVITY_CANCEL_VOTE: 8,

-    TYPE_ACTIVITY_VOTE_DOWN : 9,

-    TYPE_ACTIVITY_UPDATE_QUESTION : 10,

-    TYPE_ACTIVITY_UPDATE_ANSWER : 10,

-    TYPE_ACTIVITY_UPDATE_TAGS : 11,

-    TYPE_ACTIVITY_MARK_ANSWER : 12,

-    TYPE_ACTIVITY_VOTE_UP : 14,

-    TYPE_ACTIVITY_USER_FULL_UPDATED: 16

-

-}

-

-class Command(BaseCommand):

-    def handle_noargs(self, **options):

-        try:

-            try:

-                self.alpha_user()

-                self.beta_user()

-                self.first_type_award()

-                self.first_ask_be_voted()

-                self.first_answer_be_voted()

-                self.first_answer_be_voted_10()

-                self.vote_count_300()

-                self.edit_count_100()

-                self.comment_count_10()

-            except Exception, e:

-                print e

-        finally:

-            connection.close()

-

-    def alpha_user(self):

-        """

-        Before Jan 25, 2009(Chinese New Year Eve and enter into Beta for CNProg), every registered user

-        will be awarded the "Alpha" badge if he has any activities.

-        """

-        alpha_end_date = date(2009, 1, 25)

-        if date.today() < alpha_end_date:

-            badge = get_object_or_404(Badge, id=22)

-            for user in User.objects.all():

-                award = Award.objects.filter(user=user, badge=badge)

-                if award and not badge.multiple:

-                    continue

-                activities = Activity.objects.filter(user=user)

-                if len(activities) > 0:

-                    new_award = Award(user=user, badge=badge)

-                    new_award.save()

-

-    def beta_user(self):

-        """

-        Before Feb 25, 2009, every registered user

-        will be awarded the "Beta" badge if he has any activities.

-        """

-        beta_end_date = date(2009, 2, 25)

-        if date.today() < beta_end_date:

-            badge = get_object_or_404(Badge, id=33)

-            for user in User.objects.all():

-                award = Award.objects.filter(user=user, badge=badge)

-                if award and not badge.multiple:

-                    continue

-                activities = Activity.objects.filter(user=user)

-                if len(activities) > 0:

-                    new_award = Award(user=user, badge=badge)

-                    new_award.save()

-

-    def first_type_award(self):

-        """

-        This will award below badges for users first behaviors:

-

-        (7, '???', 3, '???', '?????????', 0, 0),

-        (8, '???', 3, '???', '???????', 0, 0),

-        (9, '???', 3, '???', '??????', 0, 0),

-        (10, '??', 3, '??', '???????', 0, 0),

-        (11, '??', 3, '??', '???????', 0, 0),

-        (12, '??', 3, '??', '???????', 0, 0),

-        (14, '???', 3, '???', '??????', 0, 0),

-        (16, '????', 3, '????', '????????????', 0, 0),

-        """

-        activity_types = ','.join('%s' % item for item in BADGE_AWARD_TYPE_FIRST.keys())

-        # ORDER BY user_id, activity_type

-        query = "SELECT id, user_id, activity_type, content_type_id, object_id FROM activity WHERE not is_auditted AND activity_type IN (%s) ORDER BY user_id, activity_type" % activity_types

-

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-            # collect activity_id in current process

-            activity_ids = []

-            last_user_id = 0

-            last_activity_type = 0

-            for row in rows:

-                activity_ids.append(row[0])

-                user_id = row[1]

-                activity_type = row[2]

-                content_type_id = row[3]

-                object_id = row[4]

-

-                # if the user and activity are same as the last, continue

-                if user_id == last_user_id and activity_type == last_activity_type:

-                    continue;

-

-                user = get_object_or_404(User, id=user_id)

-                badge = get_object_or_404(Badge, id=BADGE_AWARD_TYPE_FIRST[activity_type])

-                content_type = get_object_or_404(ContentType, id=content_type_id)

-

-                count = Award.objects.filter(user=user, badge=badge).count()

-                if count and not badge.multiple:

-                    continue

-                else:

-                    # new award

-                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)

-                    award.save()

-

-                # set the current user_id and activity_type to last

-                last_user_id = user_id

-                last_activity_type = activity_type

-

-            # update processed rows to auditted

-            self.update_activities_auditted(cursor, activity_ids)

-        finally:

-            cursor.close()

-

-    def first_ask_be_voted(self):

-        """

-        For user asked question and got first upvote, we award him following badge:

-

-        (13, '??', 3, '??', '???????????????', 0, 0),

-        """

-        query = "SELECT act.user_id, q.vote_up_count, act.object_id FROM " \

-                    "activity act, question q WHERE act.activity_type = %s AND " \

-                    "act.object_id = q.id AND " \

-                    "act.user_id NOT IN (SELECT distinct user_id FROM award WHERE badge_id = %s)" % (TYPE_ACTIVITY_ASK_QUESTION, 13)

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-

-            badge = get_object_or_404(Badge, id=13)

-            content_type = ContentType.objects.get_for_model(Question)

-            awarded_users = []

-            for row in rows:

-                user_id = row[0]

-                vote_up_count = row[1]

-                object_id = row[2]

-                if vote_up_count > 0 and user_id not in awarded_users:

-                    user = get_object_or_404(User, id=user_id)

-                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)

-                    award.save()

-                    awarded_users.append(user_id)

-        finally:

-            cursor.close()

-

-    def first_answer_be_voted(self):

-        """

-        When user answerd questions and got first upvote, we award him following badge:

-

-        (15, '??', 3, '??', '??????????????????', 0, 0),

-        """

-        query = "SELECT act.user_id, a.vote_up_count, act.object_id FROM " \

-                    "activity act, answer a WHERE act.activity_type = %s AND " \

-                    "act.object_id = a.id AND " \

-                    "act.user_id NOT IN (SELECT distinct user_id FROM award WHERE badge_id = %s)" % (TYPE_ACTIVITY_ANSWER, 15)

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-

-            awarded_users = []

-            badge = get_object_or_404(Badge, id=15)

-            content_type = ContentType.objects.get_for_model(Answer)

-            for row in rows:

-                user_id = row[0]

-                vote_up_count = row[1]

-                object_id = row[2]

-                if vote_up_count > 0 and user_id not in awarded_users:

-                    user = get_object_or_404(User, id=user_id)

-                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)

-                    award.save()

-                    awarded_users.append(user_id)

-        finally:

-            cursor.close()

-

-    def first_answer_be_voted_10(self):

-        """

-        (32, '???', 2, '???', '??????????10???', 0, 0)

-        """

-        query = "SELECT act.user_id, act.object_id FROM " \

-                    "activity act, answer a WHERE act.object_id = a.id AND " \

-                    "act.activity_type = %s AND " \

-                    "a.vote_up_count >= 10 AND " \

-                    "act.user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s)" % (TYPE_ACTIVITY_ANSWER, 32)

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-

-            awarded_users = []

-            badge = get_object_or_404(Badge, id=32)

-            content_type = ContentType.objects.get_for_model(Answer)

-            for row in rows:

-                user_id = row[0]

-                if user_id not in awarded_users:

-                    user = get_object_or_404(User, id=user_id)

-                    object_id = row[1]

-                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)

-                    award.save()

-                    awarded_users.append(user_id)

-        finally:

-            cursor.close()

-

-    def vote_count_300(self):

-        """

-        (26, '????', 2, '????', '??300???', 0, 0)

-        """

-        query = "SELECT count(*) as vote_count, user_id FROM activity WHERE " \

-                    "activity_type = %s OR " \

-                    "activity_type = %s AND " \

-                    "user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s) " \

-                    "GROUP BY user_id HAVING count(*) >= 300" % (TYPE_ACTIVITY_VOTE_UP, TYPE_ACTIVITY_VOTE_DOWN, 26)

-

-        self.__award_for_count_num(query, 26)

-

-    def edit_count_100(self):

-        """

-        (27, '????', 2, '????', '???100???', 0, 0)

-        """

-        query = "SELECT count(*) as vote_count, user_id FROM activity WHERE " \

-                    "activity_type = %s OR " \

-                    "activity_type = %s AND " \

-                    "user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s) " \

-                    "GROUP BY user_id HAVING count(*) >= 100" % (TYPE_ACTIVITY_UPDATE_QUESTION, TYPE_ACTIVITY_UPDATE_ANSWER, 27)

-

-        self.__award_for_count_num(query, 27)

-

-    def comment_count_10(self):

-        """

-        (5, '???', 3, '???', '??10???', 0, 0),

-        """

-        query = "SELECT count(*) as vote_count, user_id FROM activity WHERE " \

-                    "activity_type = %s OR " \

-                    "activity_type = %s AND " \

-                    "user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s) " \

-                    "GROUP BY user_id HAVING count(*) >= 10" % (TYPE_ACTIVITY_COMMENT_QUESTION, TYPE_ACTIVITY_COMMENT_ANSWER, 5)

-        self.__award_for_count_num(query, 5)

-

-    def __award_for_count_num(self, query, badge):

-        cursor = connection.cursor()

-        try:

-            cursor.execute(query)

-            rows = cursor.fetchall()

-

-            awarded_users = []

-            badge = get_object_or_404(Badge, id=badge)

-            for row in rows:

-                vote_count = row[0]

-                user_id = row[1]

-

-                if user_id not in awarded_users:

-                    user = get_object_or_404(User, id=user_id)

-                    award = Award(user=user, badge=badge)

-                    award.save()

-                    awarded_users.append(user_id)

-        finally:

-            cursor.close()

-

-def main():

-    pass

-

-if __name__ == '__main__':

-    main()

+#!/usr/bin/env python
+#encoding:utf-8
+#-------------------------------------------------------------------------------
+# Name:        Award badges command
+# Purpose:     This is a command file croning in background process regularly to
+#              query database and award badges for user's special acitivities.
+#
+# Author:      Mike, Sailing
+#
+# Created:     18/01/2009
+# Copyright:   (c) Mike 2009
+# Licence:     GPL V2
+#-------------------------------------------------------------------------------
+
+from datetime import datetime, date
+from django.db import connection
+from django.shortcuts import get_object_or_404
+from django.contrib.contenttypes.models import ContentType
+
+from forum.models import *
+from forum.const import *
+from pg_base_command import BaseCommand
+"""
+(1, '????', 3, '????', '?????3?????????', 1, 0),
+(2, '????', 3, '????', '?????3?????????', 1, 0),
+(3, '????', 3, '????', '????10???', 1, 0),
+(4, '????', 3, '????', '????10???', 1, 0),
+(5, '???', 3, '???', '??10???', 0, 0),
+(6, '????', 3, '????', '????????1000??', 1, 0),
+(7, '???', 3, '???', '?????????', 0, 0),
+(8, '???', 3, '???', '???????', 0, 0),
+(9, '???', 3, '???', '??????', 0, 0),
+(10, '??', 3, '??', '???????', 0, 0),
+(11, '??', 3, '??', '???????', 0, 0),
+(12, '??', 3, '??', '???????', 0, 0),
+(13, '??', 3, '??', '???????????????', 0, 0),
+(14, '???', 3, '???', '??????', 0, 0),
+(15, '??', 3, '??', '??????????????????', 0, 0),
+(16, '????', 3, '????', '????????????', 0, 0),
+(17, '????', 3, '????', '??????????3??????', 1, 0),
+(18, '??????', 1, '??????', '????100????', 1, 0),
+(19, '??????', 1, '??????', '????100????', 1, 0),
+(20, '???', 1, '???', '???100?????', 1, 0),
+(21, '????', 1, '????', '????????10000??', 1, 0),
+(22, 'alpha??', 2, 'alpha??', '?????????', 0, 0),
+(23, '????', 2, '????', '????25????', 1, 0),
+(24, '????', 2, '????', '????25????', 1, 0),
+(25, '?????', 2, '?????', '???25?????', 1, 0),
+(26, '????', 2, '????', '??300???', 0, 0),
+(27, '????', 2, '????', '???100???', 0, 0),
+(28, '??', 2, '??', '?????????', 0, 0),
+(29, '??', 2, '??', '???????????', 0, 0),
+(30, '??', 2, '??', '?????????', 0, 0),
+(31, '??????', 2, '??????', '????????2500??', 1, 0),
+(32, '???', 2, '???', '??????????10???', 0, 0),
+(33, 'beta??', 2, 'beta??', 'beta??????', 0, 0),
+(34, '??', 2, '??', '?????????????40??', 1, 0),
+(35, '??', 2, '??', '???60??????????5???', 1, 0),
+(36, '????', 2, '????', '??????50???????', 1, 0);
+
+
+TYPE_ACTIVITY_ASK_QUESTION=1
+TYPE_ACTIVITY_ANSWER=2
+TYPE_ACTIVITY_COMMENT_QUESTION=3
+TYPE_ACTIVITY_COMMENT_ANSWER=4
+TYPE_ACTIVITY_UPDATE_QUESTION=5
+TYPE_ACTIVITY_UPDATE_ANSWER=6
+TYPE_ACTIVITY_PRIZE=7
+TYPE_ACTIVITY_MARK_ANSWER=8
+TYPE_ACTIVITY_VOTE_UP=9
+TYPE_ACTIVITY_VOTE_DOWN=10
+TYPE_ACTIVITY_CANCEL_VOTE=11
+TYPE_ACTIVITY_DELETE_QUESTION=12
+TYPE_ACTIVITY_DELETE_ANSWER=13
+TYPE_ACTIVITY_MARK_OFFENSIVE=14
+TYPE_ACTIVITY_UPDATE_TAGS=15
+TYPE_ACTIVITY_FAVORITE=16
+TYPE_ACTIVITY_USER_FULL_UPDATED = 17
+"""
+
+BADGE_AWARD_TYPE_FIRST = {
+    TYPE_ACTIVITY_MARK_OFFENSIVE : 7,
+    TYPE_ACTIVITY_CANCEL_VOTE: 8,
+    TYPE_ACTIVITY_VOTE_DOWN : 9,
+    TYPE_ACTIVITY_UPDATE_QUESTION : 10,
+    TYPE_ACTIVITY_UPDATE_ANSWER : 10,
+    TYPE_ACTIVITY_UPDATE_TAGS : 11,
+    TYPE_ACTIVITY_MARK_ANSWER : 12,
+    TYPE_ACTIVITY_VOTE_UP : 14,
+    TYPE_ACTIVITY_USER_FULL_UPDATED: 16
+
+}
+
+class Command(BaseCommand):
+    def handle_noargs(self, **options):
+        try:
+            try:
+                self.alpha_user()
+                self.beta_user()
+                self.first_type_award()
+                self.first_ask_be_voted()
+                self.first_answer_be_voted()
+                self.first_answer_be_voted_10()
+                self.vote_count_300()
+                self.edit_count_100()
+                self.comment_count_10()
+            except Exception, e:
+                print e
+        finally:
+            connection.close()
+
+    def alpha_user(self):
+        """
+        Before Jan 25, 2009(Chinese New Year Eve and enter into Beta for CNProg), every registered user
+        will be awarded the "Alpha" badge if he has any activities.
+        """
+        alpha_end_date = date(2009, 1, 25)
+        if date.today() < alpha_end_date:
+            badge = get_object_or_404(Badge, id=22)
+            for user in User.objects.all():
+                award = Award.objects.filter(user=user, badge=badge)
+                if award and not badge.multiple:
+                    continue
+                activities = Activity.objects.filter(user=user)
+                if len(activities) > 0:
+                    new_award = Award(user=user, badge=badge)
+                    new_award.save()
+
+    def beta_user(self):
+        """
+        Before Feb 25, 2009, every registered user
+        will be awarded the "Beta" badge if he has any activities.
+        """
+        beta_end_date = date(2009, 2, 25)
+        if date.today() < beta_end_date:
+            badge = get_object_or_404(Badge, id=33)
+            for user in User.objects.all():
+                award = Award.objects.filter(user=user, badge=badge)
+                if award and not badge.multiple:
+                    continue
+                activities = Activity.objects.filter(user=user)
+                if len(activities) > 0:
+                    new_award = Award(user=user, badge=badge)
+                    new_award.save()
+
+    def first_type_award(self):
+        """
+        This will award below badges for users first behaviors:
+
+        (7, '???', 3, '???', '?????????', 0, 0),
+        (8, '???', 3, '???', '???????', 0, 0),
+        (9, '???', 3, '???', '??????', 0, 0),
+        (10, '??', 3, '??', '???????', 0, 0),
+        (11, '??', 3, '??', '???????', 0, 0),
+        (12, '??', 3, '??', '???????', 0, 0),
+        (14, '???', 3, '???', '??????', 0, 0),
+        (16, '????', 3, '????', '????????????', 0, 0),
+        """
+        activity_types = ','.join('%s' % item for item in BADGE_AWARD_TYPE_FIRST.keys())
+        # ORDER BY user_id, activity_type
+        query = "SELECT id, user_id, activity_type, content_type_id, object_id FROM activity WHERE not is_auditted AND activity_type IN (%s) ORDER BY user_id, activity_type" % activity_types
+
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+            # collect activity_id in current process
+            activity_ids = []
+            last_user_id = 0
+            last_activity_type = 0
+            for row in rows:
+                activity_ids.append(row[0])
+                user_id = row[1]
+                activity_type = row[2]
+                content_type_id = row[3]
+                object_id = row[4]
+
+                # if the user and activity are same as the last, continue
+                if user_id == last_user_id and activity_type == last_activity_type:
+                    continue;
+
+                user = get_object_or_404(User, id=user_id)
+                badge = get_object_or_404(Badge, id=BADGE_AWARD_TYPE_FIRST[activity_type])
+                content_type = get_object_or_404(ContentType, id=content_type_id)
+
+                count = Award.objects.filter(user=user, badge=badge).count()
+                if count and not badge.multiple:
+                    continue
+                else:
+                    # new award
+                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)
+                    award.save()
+
+                # set the current user_id and activity_type to last
+                last_user_id = user_id
+                last_activity_type = activity_type
+
+            # update processed rows to auditted
+            self.update_activities_auditted(cursor, activity_ids)
+        finally:
+            cursor.close()
+
+    def first_ask_be_voted(self):
+        """
+        For user asked question and got first upvote, we award him following badge:
+
+        (13, '??', 3, '??', '???????????????', 0, 0),
+        """
+        query = "SELECT act.user_id, q.vote_up_count, act.object_id FROM " \
+                    "activity act, question q WHERE act.activity_type = %s AND " \
+                    "act.object_id = q.id AND " \
+                    "act.user_id NOT IN (SELECT distinct user_id FROM award WHERE badge_id = %s)" % (TYPE_ACTIVITY_ASK_QUESTION, 13)
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+
+            badge = get_object_or_404(Badge, id=13)
+            content_type = ContentType.objects.get_for_model(Question)
+            awarded_users = []
+            for row in rows:
+                user_id = row[0]
+                vote_up_count = row[1]
+                object_id = row[2]
+                if vote_up_count > 0 and user_id not in awarded_users:
+                    user = get_object_or_404(User, id=user_id)
+                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)
+                    award.save()
+                    awarded_users.append(user_id)
+        finally:
+            cursor.close()
+
+    def first_answer_be_voted(self):
+        """
+        When user answerd questions and got first upvote, we award him following badge:
+
+        (15, '??', 3, '??', '??????????????????', 0, 0),
+        """
+        query = "SELECT act.user_id, a.vote_up_count, act.object_id FROM " \
+                    "activity act, answer a WHERE act.activity_type = %s AND " \
+                    "act.object_id = a.id AND " \
+                    "act.user_id NOT IN (SELECT distinct user_id FROM award WHERE badge_id = %s)" % (TYPE_ACTIVITY_ANSWER, 15)
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+
+            awarded_users = []
+            badge = get_object_or_404(Badge, id=15)
+            content_type = ContentType.objects.get_for_model(Answer)
+            for row in rows:
+                user_id = row[0]
+                vote_up_count = row[1]
+                object_id = row[2]
+                if vote_up_count > 0 and user_id not in awarded_users:
+                    user = get_object_or_404(User, id=user_id)
+                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)
+                    award.save()
+                    awarded_users.append(user_id)
+        finally:
+            cursor.close()
+
+    def first_answer_be_voted_10(self):
+        """
+        (32, '???', 2, '???', '??????????10???', 0, 0)
+        """
+        query = "SELECT act.user_id, act.object_id FROM " \
+                    "activity act, answer a WHERE act.object_id = a.id AND " \
+                    "act.activity_type = %s AND " \
+                    "a.vote_up_count >= 10 AND " \
+                    "act.user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s)" % (TYPE_ACTIVITY_ANSWER, 32)
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+
+            awarded_users = []
+            badge = get_object_or_404(Badge, id=32)
+            content_type = ContentType.objects.get_for_model(Answer)
+            for row in rows:
+                user_id = row[0]
+                if user_id not in awarded_users:
+                    user = get_object_or_404(User, id=user_id)
+                    object_id = row[1]
+                    award = Award(user=user, badge=badge, content_type=content_type, object_id=object_id)
+                    award.save()
+                    awarded_users.append(user_id)
+        finally:
+            cursor.close()
+
+    def vote_count_300(self):
+        """
+        (26, '????', 2, '????', '??300???', 0, 0)
+        """
+        query = "SELECT count(*) as vote_count, user_id FROM activity WHERE " \
+                    "activity_type = %s OR " \
+                    "activity_type = %s AND " \
+                    "user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s) " \
+                    "GROUP BY user_id HAVING count(*) >= 300" % (TYPE_ACTIVITY_VOTE_UP, TYPE_ACTIVITY_VOTE_DOWN, 26)
+
+        self.__award_for_count_num(query, 26)
+
+    def edit_count_100(self):
+        """
+        (27, '????', 2, '????', '???100???', 0, 0)
+        """
+        query = "SELECT count(*) as vote_count, user_id FROM activity WHERE " \
+                    "activity_type = %s OR " \
+                    "activity_type = %s AND " \
+                    "user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s) " \
+                    "GROUP BY user_id HAVING count(*) >= 100" % (TYPE_ACTIVITY_UPDATE_QUESTION, TYPE_ACTIVITY_UPDATE_ANSWER, 27)
+
+        self.__award_for_count_num(query, 27)
+
+    def comment_count_10(self):
+        """
+        (5, '???', 3, '???', '??10???', 0, 0),
+        """
+        query = "SELECT count(*) as vote_count, user_id FROM activity WHERE " \
+                    "activity_type = %s OR " \
+                    "activity_type = %s AND " \
+                    "user_id NOT IN (SELECT user_id FROM award WHERE badge_id = %s) " \
+                    "GROUP BY user_id HAVING count(*) >= 10" % (TYPE_ACTIVITY_COMMENT_QUESTION, TYPE_ACTIVITY_COMMENT_ANSWER, 5)
+        self.__award_for_count_num(query, 5)
+
+    def __award_for_count_num(self, query, badge):
+        cursor = connection.cursor()
+        try:
+            cursor.execute(query)
+            rows = cursor.fetchall()
+
+            awarded_users = []
+            badge = get_object_or_404(Badge, id=badge)
+            for row in rows:
+                vote_count = row[0]
+                user_id = row[1]
+
+                if user_id not in awarded_users:
+                    user = get_object_or_404(User, id=user_id)
+                    award = Award(user=user, badge=badge)
+                    award.save()
+                    awarded_users.append(user_id)
+        finally:
+            cursor.close()
+
+def main():
+    pass
+
+if __name__ == '__main__':
+    main()
diff --git a/forum/management/commands/sximport.py b/forum/management/commands/sximport.py
index 5a0bb96a..f6af4e90 100755
--- a/forum/management/commands/sximport.py
+++ b/forum/management/commands/sximport.py
@@ -1,109 +1,109 @@
-from django.core.management.base import LabelCommand

-from zipfile import ZipFile

-from xml.dom import minidom as dom

-import datetime

-

-from forum.models import User

-

-class Command(LabelCommand):

-    def handle_label(self, label, **options):

-        zip = ZipFile(label)

-

-        map = {}

-

-        map['users'] = self.import_users(zip.open("Users.xml"))

-        map['questions'], map['answers'] = self.import_posts(zip.open("Posts.xml"))

-

-

-    def row_to_dic(self, row):

-        return dict([

-            (child.localName.lower(),

-            " ".join([t.nodeValue for t in child.childNodes if t.nodeType == t.TEXT_NODE]))

-            for child in row.childNodes

-            if child.nodeType == child.ELEMENT_NODE

-        ])

-

-    def from_sx_time(self, timestring):

-        if timestring is None:

-            return timestring

-

-        try:

-            return datetime.datetime.strptime(timestring, '%Y-%m-%dT%H:%M:%S')

-        except:

-            return datetime.datetime.strptime(timestring, '%Y-%m-%dT%H:%M:%S.%f')

-

-

-    def import_users(self, users):

-        pkey_map = {}

-        doc = dom.parse(users)

-

-        rows = doc.getElementsByTagName('row')

-        unknown_count = 0

-

-        added_names = []

-

-        for row in rows:

-            values = self.row_to_dic(row)

-

-            username = values.get('displayname',

-                            values.get('realname',

-                                values.get('email', None)))

-

-            if username is None:

-                unknown_count += 1

-                username = 'Unknown User %d' % unknown_count

-

-            if username in added_names:

-                cnt = 1

-                new_username = "%s %d" % (username, cnt)

-                while new_username in added_names:

-                    cnt += 1

-                    new_username = "%s %d" % (username, cnt)

-

-                username = new_username

-

-            added_names.append(username)

-

-            user = User(username=username, email=values.get('email', ''))

-

-            user.reputation = values['reputation']

-            user.last_seen = self.from_sx_time(values['lastaccessdate'])

-

-            user.real_name = values.get('realname', '')

-            user.about = values.get('aboutme', '')

-            user.website = values.get('websiteurl', '')

-            user.date_of_birth = self.from_sx_time(values.get('birthday', None))

-            user.location = values.get('location', '')

-

-            user.is_active = True

-            user.email_isvalid = True

-

-

-            if int(values['usertypeid']) == 5:

-                user.is_superuser = True

-

-            if int(values['usertypeid']) == 5:

-                user.is_staff = True

-

-            user.save()

-

-            pkey_map[values['id']] = user

-

-        return users

-

-    def import_posts(self, posts, map):

-        pkey_map = {}

-        doc = dom.parse(posts)

-

-        rows = doc.getElementsByTagName('row')

-

-        for row in rows:

-            map = {

-                'title': row['']    

-            }

-

-            pass

-        pass

-            

-        

-        

+from django.core.management.base import LabelCommand
+from zipfile import ZipFile
+from xml.dom import minidom as dom
+import datetime
+
+from forum.models import User
+
+class Command(LabelCommand):
+    def handle_label(self, label, **options):
+        zip = ZipFile(label)
+
+        map = {}
+
+        map['users'] = self.import_users(zip.open("Users.xml"))
+        map['questions'], map['answers'] = self.import_posts(zip.open("Posts.xml"))
+
+
+    def row_to_dic(self, row):
+        return dict([
+            (child.localName.lower(),
+            " ".join([t.nodeValue for t in child.childNodes if t.nodeType == t.TEXT_NODE]))
+            for child in row.childNodes
+            if child.nodeType == child.ELEMENT_NODE
+        ])
+
+    def from_sx_time(self, timestring):
+        if timestring is None:
+            return timestring
+
+        try:
+            return datetime.datetime.strptime(timestring, '%Y-%m-%dT%H:%M:%S')
+        except:
+            return datetime.datetime.strptime(timestring, '%Y-%m-%dT%H:%M:%S.%f')
+
+
+    def import_users(self, users):
+        pkey_map = {}
+        doc = dom.parse(users)
+
+        rows = doc.getElementsByTagName('row')
+        unknown_count = 0
+
+        added_names = []
+
+        for row in rows:
+            values = self.row_to_dic(row)
+
+            username = values.get('displayname',
+                            values.get('realname',
+                                values.get('email', None)))
+
+            if username is None:
+                unknown_count += 1
+                username = 'Unknown User %d' % unknown_count
+
+            if username in added_names:
+                cnt = 1
+                new_username = "%s %d" % (username, cnt)
+                while new_username in added_names:
+                    cnt += 1
+                    new_username = "%s %d" % (username, cnt)
+
+                username = new_username
+
+            added_names.append(username)
+
+            user = User(username=username, email=values.get('email', ''))
+
+            user.reputation = values['reputation']
+            user.last_seen = self.from_sx_time(values['lastaccessdate'])
+
+            user.real_name = values.get('realname', '')
+            user.about = values.get('aboutme', '')
+            user.website = values.get('websiteurl', '')
+            user.date_of_birth = self.from_sx_time(values.get('birthday', None))
+            user.location = values.get('location', '')
+
+            user.is_active = True
+            user.email_isvalid = True
+
+
+            if int(values['usertypeid']) == 5:
+                user.is_superuser = True
+
+            if int(values['usertypeid']) == 5:
+                user.is_staff = True
+
+            user.save()
+
+            pkey_map[values['id']] = user
+
+        return users
+
+    def import_posts(self, posts, map):
+        pkey_map = {}
+        doc = dom.parse(posts)
+
+        rows = doc.getElementsByTagName('row')
+
+        for row in rows:
+            map = {
+                'title': row['']    
+            }
+
+            pass
+        pass
+            
+        
+        
diff --git a/forum/settings.py b/forum/settings.py
index f3a665b2..04a7c399 100755
--- a/forum/settings.py
+++ b/forum/settings.py
@@ -1,51 +1,51 @@
-import os

-

-

-INSTALLED_APPS = ['forum']

-

-MIDDLEWARE_CLASSES = [

-    'django.contrib.sessions.middleware.SessionMiddleware',

-    'django.middleware.common.CommonMiddleware',

-    'django.contrib.auth.middleware.AuthenticationMiddleware',

-    'forum.middleware.anon_user.ConnectToSessionMessagesMiddleware',

-    'forum.middleware.pagesize.QuestionsPageSizeMiddleware',

-    'forum.middleware.cancel.CancelActionMiddleware',

-    'django.middleware.transaction.TransactionMiddleware',

-]

-

-TEMPLATE_LOADERS = [

-    'django.template.loaders.filesystem.load_template_source',

-    'django.template.loaders.app_directories.load_template_source',

-    'forum.modules.module_templates_loader',

-    'forum.skins.load_template_source',

-]

-

-TEMPLATE_CONTEXT_PROCESSORS = [

-    'django.core.context_processors.request',

-    'forum.context.application_settings',

-    'forum.user_messages.context_processors.user_messages',

-    'django.core.context_processors.auth',

-]

-

-TEMPLATE_DIRS = [

-    os.path.join(os.path.dirname(__file__),'skins').replace('\\','/'),

-]

-

-def setup_settings(settings):

-

-    if (hasattr(settings, 'DEBUG') and getattr(settings, 'DEBUG')):

-        try:

-            import debug_toolbar

-            INSTALLED_APPS.append('debug_toolbar')

-            MIDDLEWARE_CLASSES.append('debug_toolbar.middleware.DebugToolbarMiddleware')

-        except:

-            pass

-

-

-    settings.INSTALLED_APPS = set(settings.INSTALLED_APPS) | set(INSTALLED_APPS)

-    settings.MIDDLEWARE_CLASSES = set(settings.MIDDLEWARE_CLASSES) | set(MIDDLEWARE_CLASSES)

-    settings.TEMPLATE_LOADERS = set(settings.TEMPLATE_LOADERS) | set(TEMPLATE_LOADERS)

-    settings.TEMPLATE_CONTEXT_PROCESSORS = set(settings.TEMPLATE_CONTEXT_PROCESSORS) | set(TEMPLATE_CONTEXT_PROCESSORS)

-    settings.TEMPLATE_DIRS = set(settings.TEMPLATE_DIRS) | set(TEMPLATE_DIRS)

-

+import os
+
+
+INSTALLED_APPS = ['forum']
+
+MIDDLEWARE_CLASSES = [
+    'django.contrib.sessions.middleware.SessionMiddleware',
+    'django.middleware.common.CommonMiddleware',
+    'django.contrib.auth.middleware.AuthenticationMiddleware',
+    'forum.middleware.anon_user.ConnectToSessionMessagesMiddleware',
+    'forum.middleware.pagesize.QuestionsPageSizeMiddleware',
+    'forum.middleware.cancel.CancelActionMiddleware',
+    'django.middleware.transaction.TransactionMiddleware',
+]
+
+TEMPLATE_LOADERS = [
+    'django.template.loaders.filesystem.load_template_source',
+    'django.template.loaders.app_directories.load_template_source',
+    'forum.modules.module_templates_loader',
+    'forum.skins.load_template_source',
+]
+
+TEMPLATE_CONTEXT_PROCESSORS = [
+    'django.core.context_processors.request',
+    'forum.context.application_settings',
+    'forum.user_messages.context_processors.user_messages',
+    'django.core.context_processors.auth',
+]
+
+TEMPLATE_DIRS = [
+    os.path.join(os.path.dirname(__file__),'skins').replace('\\','/'),
+]
+
+def setup_settings(settings):
+
+    if (hasattr(settings, 'DEBUG') and getattr(settings, 'DEBUG')):
+        try:
+            import debug_toolbar
+            INSTALLED_APPS.append('debug_toolbar')
+            MIDDLEWARE_CLASSES.append('debug_toolbar.middleware.DebugToolbarMiddleware')
+        except:
+            pass
+
+
+    settings.INSTALLED_APPS = set(settings.INSTALLED_APPS) | set(INSTALLED_APPS)
+    settings.MIDDLEWARE_CLASSES = set(settings.MIDDLEWARE_CLASSES) | set(MIDDLEWARE_CLASSES)
+    settings.TEMPLATE_LOADERS = set(settings.TEMPLATE_LOADERS) | set(TEMPLATE_LOADERS)
+    settings.TEMPLATE_CONTEXT_PROCESSORS = set(settings.TEMPLATE_CONTEXT_PROCESSORS) | set(TEMPLATE_CONTEXT_PROCESSORS)
+    settings.TEMPLATE_DIRS = set(settings.TEMPLATE_DIRS) | set(TEMPLATE_DIRS)
+
  
\ No newline at end of file
diff --git a/forum/utils/email.py b/forum/utils/email.py
index a6ea1087..dc712572 100755
--- a/forum/utils/email.py
+++ b/forum/utils/email.py
@@ -1,21 +1,21 @@
-from django.core.mail import send_mail, EmailMultiAlternatives

-from django.conf import settings

-from django.template import loader, Context

-from django.utils.html import strip_tags

-from threading import Thread

-

-def send_email(subject, recipients, template, context={}, sender=settings.DEFAULT_FROM_EMAIL, txt_template=None):

-    context['settings'] = settings

-    html_body = loader.get_template(template).render(Context(context))

-

-    if txt_template is None:

-        txt_body = strip_tags(html_body)

-    else:

-        txt_body = loader.get_template(txt_template).render(Context(context))

-

-    msg = EmailMultiAlternatives(subject, txt_body, sender, recipients)

-    msg.attach_alternative(html_body, "text/html")

-

-    thread = Thread(target=EmailMultiAlternatives.send,  args=[msg])

-    thread.setDaemon(True)

-    thread.start()

+from django.core.mail import send_mail, EmailMultiAlternatives
+from django.conf import settings
+from django.template import loader, Context
+from django.utils.html import strip_tags
+from threading import Thread
+
+def send_email(subject, recipients, template, context={}, sender=settings.DEFAULT_FROM_EMAIL, txt_template=None):
+    context['settings'] = settings
+    html_body = loader.get_template(template).render(Context(context))
+
+    if txt_template is None:
+        txt_body = strip_tags(html_body)
+    else:
+        txt_body = loader.get_template(txt_template).render(Context(context))
+
+    msg = EmailMultiAlternatives(subject, txt_body, sender, recipients)
+    msg.attach_alternative(html_body, "text/html")
+
+    thread = Thread(target=EmailMultiAlternatives.send,  args=[msg])
+    thread.setDaemon(True)
+    thread.start()
diff --git a/forum/utils/time.py b/forum/utils/time.py
index 5fd15e24..39e01d0f 100755
--- a/forum/utils/time.py
+++ b/forum/utils/time.py
@@ -1,4 +1,4 @@
-import datetime

-

-def one_day_from_now():

-    return datetime.datetime.now() + datetime.timedelta(days=1)

+import datetime
+
+def one_day_from_now():
+    return datetime.datetime.now() + datetime.timedelta(days=1)
diff --git a/forum_modules/robotstxt/templates/robots.txt b/forum_modules/robotstxt/templates/robots.txt
index 97d769f1..574fc315 100755
--- a/forum_modules/robotstxt/templates/robots.txt
+++ b/forum_modules/robotstxt/templates/robots.txt
@@ -1,2 +1,2 @@
-User-agent: *

+User-agent: *
 Disallow: / 
\ No newline at end of file
diff --git a/forum_modules/robotstxt/urls.py b/forum_modules/robotstxt/urls.py
index 83915456..79a6d84c 100755
--- a/forum_modules/robotstxt/urls.py
+++ b/forum_modules/robotstxt/urls.py
@@ -1,6 +1,6 @@
-from django.conf.urls.defaults import *

-from django.views.generic.simple import direct_to_template

-

-urlpatterns = patterns('',

-    (r'^robots.txt$',  direct_to_template,  {'template': 'modules/robotsdennyall/robots.txt'}),

-)

+from django.conf.urls.defaults import *
+from django.views.generic.simple import direct_to_template
+
+urlpatterns = patterns('',
+    (r'^robots.txt$',  direct_to_template,  {'template': 'modules/robotsdennyall/robots.txt'}),
+)