recaptcha for conventional registration\n\

simpler email subscription form at registration\n\
fixed urls in rss feed\n\
added experimental remote password login api (cleartext password for remote site entered locally)\n\
included example for Mediawiki Authentication plugin\n\
very simple message to everyone management command

2 files changed, 41 insertions, 0 deletions

diff --git a/sql_scripts/100108_upgrade_ef.sql b/sql_scripts/100108_upgrade_ef.sql
new file mode 100644
index 00000000..1c9a5c1c
--- /dev/null
+++ b/sql_scripts/100108_upgrade_ef.sql
@@ -0,0 +1,4 @@
+alter table auth_user add column hide_ignored_questions tinyint(1) not NULL;
+update auth_user set hide_ignored_questions=0;
+alter table auth_user add column tag_filter_setting varchar(16) not NULL;
+update auth_user set tag_filter_setting='ignored';
diff --git a/sql_scripts/badges.sql b/sql_scripts/badges.sql
new file mode 100644
index 00000000..f47e067a
--- /dev/null
+++ b/sql_scripts/badges.sql
@@ -0,0 +1,37 @@
+INSERT INTO `badge` ( `id`, `name`, `type`, `slug`, `description`, `multiple`, `awarded_count`) VALUES
+(1, 'Disciplined', 3, 'disciplined', 'Deleted own post with score of 3 or higher', 1, 0),
+(2, 'Peer Pressure', 3, 'peer-pressure', 'Deleted own post with score of -3 or lower', 1, 0),
+(3, 'Nice answer', 3, 'nice-answer', 'Answer voted up 10 times', 1, 0),
+(4, 'Nice Question', 3, 'nice-question', 'Question voted up 10 times', 1, 0),
+(5, 'Pundit', 3, 'pundit', 'Left 10 comments with score of 10 or more', 0, 0),
+(6, 'Popular Question', 3, 'popular-question', 'Asked a question with 1,000 views', 1, 0),
+(7, 'Citizen patrol', 3, 'citizen-patrol', 'First flagged post', 0, 0),
+(8, 'Cleanup', 3, 'cleanup', 'First rollback', 0, 0),
+(9, 'Critic', 3, 'critic', 'First down vote', 0, 0),
+(10, 'Editor', 3, 'editor', 'First edit', 0, 0),
+(11, 'Organizer', 3, 'organizer', 'First retag', 0, 0),
+(12, 'Scholar', 3, 'scholar', 'First accepted answer on your own question', 0, 0),
+(13, 'Student', 3, 'student', 'Asked first question with at least one up vote', 0, 0),
+(14, 'Supporter', 3, 'supporter', 'First up vote', 0, 0),
+(15, 'Teacher', 3, 'teacher', 'Answered first question with at least one up vote', 0, 0),
+(16, 'Autobiographer', 3, 'autobiographer', 'Completed all user profile fields', 0, 0),
+(17, 'Self-Learner', 3, 'self-learner', 'Answered your own question with at least 3 up votes', 1, 0),
+(18, 'Great Answer', 1, 'great-answer', 'Answer voted up 100 times', 1, 0),
+(19, 'Great Question', 1, 'great-question', 'Question voted up 100 times', 1, 0),
+(20, 'Stellar Question', 1, 'stellar-question', 'Question favorited by 100 users', 1, 0),
+(21, 'Famous question', 1, 'famous-question', 'Asked a question with 10,000 views', 1, 0),
+(22, 'Alpha', 2, 'alpha', 'Actively participated in the private alpha', 0, 0),
+(23, 'Good Answer', 2, 'good-answer', 'Answer voted up 25 times', 1, 0),
+(24, 'Good Question', 2, 'good-question', 'Question voted up 25 times', 1, 0),
+(25, 'Favorite Question', 2, 'favorite-question', 'Question favorited by 25 users', 1, 0),
+(26, 'Civic duty', 2, 'civic-duty', 'Voted 300 times', 0, 0),
+(27, 'Strunk & White', 2, 'strunk-and-white', 'Edited 100 entries', 0, 0),
+(28, 'Generalist', 2, 'generalist', 'Active in many different tags', 0, 0),
+(29, 'Expert', 2, 'export', 'Very active in one tag', 0, 0),
+(30, 'Yearling', 2, 'yearling', 'Active member for a year', 0, 0),
+(31, 'Notable Question', 2, 'notable-question', 'Asked a question with 2,500 views', 1, 0),
+(32, 'Enlightened', 2, 'enlightened', 'First answer was accepted with at least 10 up votes', 0, 0),
+(33, 'Beta', 2, 'beta', 'Actively participated in the private beta', 0, 0),
+(34, 'Guru', 2, 'guru', 'Accepted answer and voted up 40 times', 1, 0),
+(35, 'Necromancer', 2, 'necromancer', 'Answered a question more than 60 days later with at least 5 votes', 1, 0),
+(36, 'Taxonomist', 2, 'taxonomist', 'Created a tag used by 50 questions', 1, 0);