# Community Building **URL:** https://meta.discourse.org/c/community-building/65.md?ascending=true&page=69 [最新版本](https://meta.discourse.org/latest.md) · [分類](https://meta.discourse.org/categories.md) · [標簽](https://meta.discourse.org/tags.md) **Page:** 70 --- ## [Out Of Curiosity](https://meta.discourse.org/t/out-of-curiosity/56190)
**Author:** [@anon28163865](https://meta.discourse.org/u/anon28163865)\ **回覆:** 2\ **Last updated:** [2017年一月23日 06:53 UTC](https://meta.discourse.org/t/out-of-curiosity/56190 "2017-01-23T06:53:44Z")
I just want to know out of curiosity that what is this in discourse, which is an amazing piece of undisputed software, 2017-01-23\_1205 - TechSmith Screencast Scroll-bar or parallax or something else? --- ## [Discourse - firmly my favourite forum platform!](https://meta.discourse.org/t/discourse-firmly-my-favourite-forum-platform/55381)
**Author:** [@AstonJ](https://meta.discourse.org/u/AstonJ)\ **回覆:** 0\ **Last updated:** [2017年一月9日 00:41 UTC](https://meta.discourse.org/t/discourse-firmly-my-favourite-forum-platform/55381 "2017-01-09T00:41:31Z")
Recently I been spending quite a bit of time on a forum that is running different forum software… and I found it to be quite irritating! Having to scroll all the way back up to the top to go elsewhere Having to scroll … --- ## [Great forum update :)](https://meta.discourse.org/t/great-forum-update/53819)
**Author:** [@Aztralita](https://meta.discourse.org/u/Aztralita)\ **回覆:** 0\ **Last updated:** [2016年十二月6日 00:01 UTC](https://meta.discourse.org/t/great-forum-update/53819 "2016-12-06T00:01:36Z")
nice forums update :slight\_smile: goodjob :slight\_smile: --- ## [Outstanding support from the team at Discourse.com](https://meta.discourse.org/t/outstanding-support-from-the-team-at-discourse-com/53106)
**Author:** [@PeterButton](https://meta.discourse.org/u/PeterButton)\ **回覆:** 0\ **Last updated:** [2016年十一月19日 07:37 UTC](https://meta.discourse.org/t/outstanding-support-from-the-team-at-discourse-com/53106 "2016-11-19T07:37:52Z")
Back in April last year I started a Discourse community for a client. We chose to use Discourse.org for hosting. Things started well with the community, but for a number of reasons momentum was lost. I contacted the sup… --- ## [Vote for Discourse in the CMS Critic Awards 2016](https://meta.discourse.org/t/vote-for-discourse-in-the-cms-critic-awards-2016/50898)
**Author:** [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)\ **回覆:** 3\ **Last updated:** [2016年十一月19日 17:07 UTC](https://meta.discourse.org/t/vote-for-discourse-in-the-cms-critic-awards-2016/50898 "2016-11-19T17:07:53Z")
Continuing the discussion from Nominate Discourse for CMS Critic Awards 2016: If you like Discourse, please take a moment aside to vote for us in the CMS Critic Awards. Thanks! :heart\_eyes: --- ## [How can I count posts in last month by a specific group of users?](https://meta.discourse.org/t/how-can-i-count-posts-in-last-month-by-a-specific-group-of-users/52489)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **回覆:** 4\ **Last updated:** [2016年十一月9日 19:14 UTC](https://meta.discourse.org/t/how-can-i-count-posts-in-last-month-by-a-specific-group-of-users/52489 "2016-11-09T19:14:07Z")
Do you have any query for Data explorer? I need to calculate the impact of my ambassador group --- ## [Email statistics](https://meta.discourse.org/t/email-statistics/52478)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **回覆:** 1\ **Last updated:** [2016年十一月5日 19:00 UTC](https://meta.discourse.org/t/email-statistics/52478 "2016-11-05T19:00:55Z")
I run into 100k / mo emails limit of a free SparkPost account. To better understand what type of email exactly I have to tackle, I had to write an SQL query which calculates email statistics by email type. Sharing it wi… --- ## [Drafts and multiple platforms – love it!](https://meta.discourse.org/t/drafts-and-multiple-platforms-love-it/52452)
**Author:** [@Silvanus](https://meta.discourse.org/u/Silvanus)\ **回覆:** 1\ **Last updated:** [2016年十一月3日 16:50 UTC](https://meta.discourse.org/t/drafts-and-multiple-platforms-love-it/52452 "2016-11-03T16:50:51Z")
I actually noticed this the other day. I started writing a message on desktop, but soon realized I’d have to draw a small diagram and include it to the message. I drew the diagram on paper, switched to mobile, took a pi… --- ## [Great Team - Great Software](https://meta.discourse.org/t/great-team-great-software/52179)
**Author:** [@GSeven](https://meta.discourse.org/u/GSeven)\ **回覆:** 0\ **Last updated:** [2016年十月28日 21:04 UTC](https://meta.discourse.org/t/great-team-great-software/52179 "2016-10-28T21:04:52Z")
‘everyone of you deserves a medal’ --- ## [Freakin loving Discourse](https://meta.discourse.org/t/freakin-loving-discourse/51703)
**Author:** [@SouperC](https://meta.discourse.org/u/SouperC)\ **回覆:** 0\ **Last updated:** [2016年十月18日 18:23 UTC](https://meta.discourse.org/t/freakin-loving-discourse/51703 "2016-10-18T18:23:47Z")
A thoughtful, progressive and pragmatic combination of tech and social science. Clean UI on both the user and admin/manager side. Kudos --- ## [特定月份的活跃用户数](https://meta.discourse.org/t/active-users-for-specific-months/51495)
**Author:** [@alehandrof](https://meta.discourse.org/u/alehandrof)\ **回覆:** 5\ **Last updated:** [2016年十月17日 21:45 UTC](https://meta.discourse.org/t/active-users-for-specific-months/51495 "2016-10-17T21:45:03Z")
我正在尝试找到两组数据：我社区在2016年4月和2016年9月的活跃用户数\*。 \* 活跃用户 = 在该时间段内至少发过1个主题或回复。 Mo… --- ## [A query for users with a custom title?](https://meta.discourse.org/t/a-query-for-users-with-a-custom-title/275004)
**Author:** [@jomaxro](https://meta.discourse.org/u/jomaxro)\ **回覆:** 4\ **Last updated:** [2016年十月15日 18:07 UTC](https://meta.discourse.org/t/a-query-for-users-with-a-custom-title/275004 "2016-10-15T18:07:24Z")
Anyone able to provide the query for all users with a custom title (not a badge granted title)? --- ## [How to kick start a community?](https://meta.discourse.org/t/how-to-kick-start-a-community/51295)
**Author:** [@Salomon\_Ptasevich](https://meta.discourse.org/u/Salomon_Ptasevich)\ **回覆:** 5\ **Last updated:** [2016年十月13日 12:30 UTC](https://meta.discourse.org/t/how-to-kick-start-a-community/51295 "2016-10-13T12:30:28Z")
Hi everybody, I am in thinking about starting a community for my magazine, It is a girls magazine with very good content and design and has already some heavy traffic. My question is what would be the best way to do it … --- ## [Thank You Discourse from Ben's Friends](https://meta.discourse.org/t/thank-you-discourse-from-bens-friends/50691)
**Author:** [@scottorn](https://meta.discourse.org/u/scottorn)\ **回覆:** 0\ **Last updated:** [2016年九月26日 21:54 UTC](https://meta.discourse.org/t/thank-you-discourse-from-bens-friends/50691 "2016-09-26T21:54:08Z")
I posted this Explanation & Thank You on Ben’s Friends blog. We are eternally grateful to Jeff Atwood, Erlend Sogge Heggen, Neil Lalonde, and Arpit Jalan of Discourse. I wanted to explain why we moved from Ning to Discou… --- ## [Discourse has an Amazing CSS Editor](https://meta.discourse.org/t/discourse-has-an-amazing-css-editor/50973)
**Author:** [@keith1](https://meta.discourse.org/u/keith1)\ **回覆:** 1\ **Last updated:** [2016年十月6日 11:52 UTC](https://meta.discourse.org/t/discourse-has-an-amazing-css-editor/50973 "2016-10-06T11:52:08Z")
The bar is pretty low for me when it comes to web based script editors, but I just realized that I can multi-select lines by using Ctrl + Alt + Up/Down and I felt the need to say thanks for implementing such a great edit… --- ## [How do I make my own badge query?](https://meta.discourse.org/t/how-do-i-make-my-own-badge-query/50946)
**Author:** [@keith1](https://meta.discourse.org/u/keith1)\ **回覆:** 4\ **Last updated:** [2016年十月1日 17:18 UTC](https://meta.discourse.org/t/how-do-i-make-my-own-badge-query/50946 "2016-10-01T17:18:20Z")
I’m feeling quite silly for having to ask, but I’m finding tons of great resources for making my own badges, but I can’t figure out where exactly to put all of these badge queries. Can someone just point me in the right… --- ## [Nominate Discourse for CMS Critic Awards 2016](https://meta.discourse.org/t/nominate-discourse-for-cms-critic-awards-2016/46807)
**Author:** [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)\ **回覆:** 4\ **Last updated:** [2016年九月30日 08:36 UTC](https://meta.discourse.org/t/nominate-discourse-for-cms-critic-awards-2016/46807 "2016-09-30T08:36:55Z")
Please take 2 minutes aside and go nominate Discourse for the CMS Critic Awards 2016! It seems we forgot about this in 2015, so let’s have a proper go at it this time around. There’s really just one category to conce… --- ## [Is there a Non-default-but-recommend plugins list?](https://meta.discourse.org/t/is-there-a-non-default-but-recommend-plugins-list/50856)
**Author:** [@xiasummer](https://meta.discourse.org/u/xiasummer)\ **回覆:** 4\ **Last updated:** [2016年九月30日 03:23 UTC](https://meta.discourse.org/t/is-there-a-non-default-but-recommend-plugins-list/50856 "2016-09-30T03:23:37Z")
As a beginner of discourse, there seems to be too many plugins and most of them are non-default. Truely I think some of them are fully-developed (you know, no bugs and very helpful. ) and can improve the forum service ve… --- ## [Create a "Diary writer" badge](https://meta.discourse.org/t/create-a-diary-writer-badge/50844)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **回覆:** 0\ **Last updated:** [2016年九月29日 03:05 UTC](https://meta.discourse.org/t/create-a-diary-writer-badge/50844 "2016-09-29T03:05:45Z")
:warning: Badge SQL is disabled by default. See: Enable Badge SQL In our goat farmers forum, people love to write Diaries about anything - a long-term experiment, travelling experience, their new hobby etc. So we dev… --- ## [Super impressed with Discourse's development cycle](https://meta.discourse.org/t/super-impressed-with-discourses-development-cycle/50465)
**Author:** [@DanielMarquard](https://meta.discourse.org/u/DanielMarquard)\ **回覆:** 0\ **Last updated:** [2016年九月21日 20:18 UTC](https://meta.discourse.org/t/super-impressed-with-discourses-development-cycle/50465 "2016-09-21T20:18:34Z")
I just wanted to add that I am super impressed with Discourse’s development cycle and the work everyone does for it. I discovered a bug yesterday, reported it last night, and today the bug fix is already live on my websi… --- ## [旧站URL导入Discourse后可轻松重定向](https://meta.discourse.org/t/urls-from-old-site-easily-redirected-when-imported-to-discourse/50348)
**Author:** [@pfaffman](https://meta.discourse.org/u/pfaffman)\ **回覆:** 0\ **Last updated:** [2016年九月19日 17:41 UTC](https://meta.discourse.org/t/urls-from-old-site-easily-redirected-when-imported-to-discourse/50348 "2016-09-19T17:41:01Z")
继续之前关于“以数字开头的 slug 被解析为 ID”的讨论： 这样一来，作为一个完全的新手，我找不到原因也会觉得好受些。:slight\_smile: 谢谢！ 这毕竟是一个极端的边缘情况，因为它确实很重要（据我所知… --- ## [List of all Members of a Group with Custom Field](https://meta.discourse.org/t/list-of-all-members-of-a-group-with-custom-field/275003)
**Author:** [@fefrei](https://meta.discourse.org/u/fefrei)\ **回覆:** 0\ **Last updated:** [2016年九月15日 16:11 UTC](https://meta.discourse.org/t/list-of-all-members-of-a-group-with-custom-field/275003 "2016-09-15T16:11:41Z")
List of all Members of a Group with Custom Field We use this query to get a list of the name and matriculation number of all team members: SELECT users.name, user\_custom\_fields.value as matriculation FROM users JOIN gro… --- ## [Posts created for period](https://meta.discourse.org/t/posts-created-for-period/275138)
**Author:** [@HAWK](https://meta.discourse.org/u/HAWK)\ **回覆:** 0\ **Last updated:** [2016年九月14日 21:54 UTC](https://meta.discourse.org/t/posts-created-for-period/275138 "2016-09-14T21:54:25Z")
Posts created for period Got what I need (thanks @meglio) so updating this for future posterity. -- \[params\] -- date :date\_from -- date :date\_to -- int :min\_posts = 1 WITH user\_activity AS ( SELECT p.user\_id, cou… --- ## [Does civilized discourse entail tone policing?](https://meta.discourse.org/t/does-civilized-discourse-entail-tone-policing/50039)
**Author:** [@dfabulich](https://meta.discourse.org/u/dfabulich)\ **回覆:** 23\ **Last updated:** [2016年九月13日 21:53 UTC](https://meta.discourse.org/t/does-civilized-discourse-entail-tone-policing/50039 "2016-09-13T21:53:06Z")
The company that runs Discourse is “Civilized Discourse Construction Kit, Inc.” One of the primary roles of Discourse is to help promote civilized discourse, especially as expressed in the default FAQ. This is a Civili… --- ## [Good Job Discourse!](https://meta.discourse.org/t/good-job-discourse/49816)
**Author:** [@FlyingSwitzerland](https://meta.discourse.org/u/FlyingSwitzerland)\ **回覆:** 0\ **Last updated:** [2016年九月7日 10:58 UTC](https://meta.discourse.org/t/good-job-discourse/49816 "2016-09-07T10:58:54Z")
Hello all ! I’m new here but old on the IF Community, and I want to thank you all for your great and awesome work ! It’s just amazing how this community/forum work, how structured etc… When I compare to other forum ho… --- ## [Active users in the last 30 days](https://meta.discourse.org/t/active-users-in-the-last-30-days/275140)
**Author:** [@riking](https://meta.discourse.org/u/riking)\ **回覆:** 3\ **Last updated:** [2016年九月5日 21:47 UTC](https://meta.discourse.org/t/active-users-in-the-last-30-days/275140 "2016-09-05T21:47:07Z")
Active users in the last 30 days select username from users where last\_posted\_at \> current\_timestamp - interval '30' day --- ## [话语、性别与网络论坛](https://meta.discourse.org/t/discourse-gender-and-online-forums/48317)
**Author:** [@sujato](https://meta.discourse.org/u/sujato)\ **回覆:** 34\ **Last updated:** [2016年九月5日 03:33 UTC](https://meta.discourse.org/t/discourse-gender-and-online-forums/48317 "2016-09-05T03:33:56Z")
I’m running a Discourse forum on Buddhism, and we have noticed that there are few women participating. As the forum runner (and a bloke) I’ve tried to encourage women to participate, and ensured that the moderators were … --- ## [Absence of Staff Notes in a particular category](https://meta.discourse.org/t/absence-of-staff-notes-in-a-particular-category/275168)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **回覆:** 0\ **Last updated:** [2016年八月30日 17:57 UTC](https://meta.discourse.org/t/absence-of-staff-notes-in-a-particular-category/275168 "2016-08-30T17:57:30Z")
Here is a use-case I solved with the query you’ll find below. I have a special category where users create their “personal pages” (for their goat farms). Now we’re creating a map with all these farms placed on it. Once… --- ## ['Seen in last X days' badge?](https://meta.discourse.org/t/seen-in-last-x-days-badge/276735)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **回覆:** 12\ **Last updated:** [2016年八月26日 22:56 UTC](https://meta.discourse.org/t/seen-in-last-x-days-badge/276735 "2016-08-26T22:56:59Z")
What about a badge like “Seen here last 30 days” or “Seen here last 60 days” Clearly, you can lose it in case you haven’t visited discourse recently. --- ## [RGSoC 2016: Visual Forum Analytics Community Discussion](https://meta.discourse.org/t/rgsoc-2016-visual-forum-analytics-community-discussion/46905)
**Author:** [@saintsebastian](https://meta.discourse.org/u/saintsebastian)\ **回覆:** 12\ **Last updated:** [2016年八月18日 17:04 UTC](https://meta.discourse.org/t/rgsoc-2016-visual-forum-analytics-community-discussion/46905 "2016-08-18T17:04:42Z")
Hey everyone! I am one of two people who is planing to provide you with informative graphs and charts on user, post etc statistics. We are doing this as our project for Rails Girls Summer of Code and this is our introdu… [上一頁](https://meta.discourse.org/c/community-building/65.md?ascending=true&page=68) [下一頁](https://meta.discourse.org/c/community-building/65.md?ascending=true&page=70)