# Community Building **URL:** https://meta.discourse.org/c/community-building/65.md?ascending=true&page=70 [最新版本](https://meta.discourse.org/latest.md) · [分類](https://meta.discourse.org/categories.md) · [標簽](https://meta.discourse.org/tags.md) **Page:** 71 --- ## [I didn't realise how much I'd love it!](https://meta.discourse.org/t/i-didnt-realise-how-much-id-love-it/48155)
**Author:** [@peircej](https://meta.discourse.org/u/peircej)\ **回覆:** 0\ **Last updated:** [2016年八月3日 10:52 UTC](https://meta.discourse.org/t/i-didnt-realise-how-much-id-love-it/48155 "2016-08-03T10:52:59Z")
We’ve been using googlegroups for a long time for a software support forum and I was happy enough - it was easy, “did the job” and compared to the various BB options I didn’t feel the need to switch. Having spent a few… --- ## [在Discourse中实现Google Tag Manager](https://meta.discourse.org/t/implementing-google-tag-manager-with-discourse/36861)
**Author:** [@Jenn\_Briden](https://meta.discourse.org/u/Jenn_Briden)\ **回覆:** 23\ **Last updated:** [2016年七月14日 22:48 UTC](https://meta.discourse.org/t/implementing-google-tag-manager-with-discourse/36861 "2016-07-14T22:48:08Z")
我可以看到Discourse中有直接指定Universal Analytics追踪代码的设置。不过，我更倾向于使用Google Tag Manager (GTM)，因为我们在GTM中使用的其他设置…… --- ## [Discourse is Awesome!](https://meta.discourse.org/t/discourse-is-awesome/26521)
**Author:** [@rovo](https://meta.discourse.org/u/rovo)\ **回覆:** 8\ **Last updated:** [2016年七月20日 18:10 UTC](https://meta.discourse.org/t/discourse-is-awesome/26521 "2016-07-20T18:10:17Z")
Discourse does a great job harnessing EmberJS and Ruby. I’ve installed an instance of it, and I’m wildly impressed front to back. Are there any other known open source projects that are similarly making use of this stack… --- ## [Who is extensively using the badge system?](https://meta.discourse.org/t/who-is-extensively-using-the-badge-system/46770)
**Author:** [@Yetidragon](https://meta.discourse.org/u/Yetidragon)\ **回覆:** 13\ **Last updated:** [2016年七月19日 10:10 UTC](https://meta.discourse.org/t/who-is-extensively-using-the-badge-system/46770 "2016-07-19T10:10:55Z")
Our little community is loving the badge system, and we have made quite a few custom badges to reflect real-world actions. We are a car club, so we really wanted to gamify some of the real world stuff we do, like going … --- ## [Member Uploads](https://meta.discourse.org/t/member-uploads/275001)
**Author:** [@Mittineague](https://meta.discourse.org/u/Mittineague)\ **回覆:** 0\ **Last updated:** [2016年六月20日 18:14 UTC](https://meta.discourse.org/t/member-uploads/275001 "2016-06-20T18:14:23Z")
Member Uploads I put together this query to help find members that post a lot of uploads that potentially might lead to a problem. Ordered by total upload weight per member WITH heavy\_uploads AS ( SELECT ( SUM(u… --- ## [徽章无法工作](https://meta.discourse.org/t/badge-not-working/39426)
**Author:** [@zainab](https://meta.discourse.org/u/zainab)\ **回覆:** 3\ **Last updated:** [2016年六月9日 16:46 UTC](https://meta.discourse.org/t/badge-not-working/39426 "2016-06-09T16:46:56Z")
{ --- ## [Never wanting to go back](https://meta.discourse.org/t/never-wanting-to-go-back/45460)
**Author:** [@Scriblet](https://meta.discourse.org/u/Scriblet)\ **回覆:** 0\ **Last updated:** [2016年六月9日 09:03 UTC](https://meta.discourse.org/t/never-wanting-to-go-back/45460 "2016-06-09T09:03:04Z")
Oh god, I looked up some forums today to see what was out there for another forum I’m going to start. OH GOD IT BURNS. SUCH BAD. WOW. I’ve been very, very happy with the forums I started. Thanks to this Dark Theme I fi… --- ## [I Love Discourse](https://meta.discourse.org/t/i-love-discourse/45389)
**Author:** [@marcospreviato](https://meta.discourse.org/u/marcospreviato)\ **回覆:** 0\ **Last updated:** [2016年六月7日 16:59 UTC](https://meta.discourse.org/t/i-love-discourse/45389 "2016-06-07T16:59:32Z")
In recent years, I worked with many forum platforms and CMS and the Discourse was the one that made me happy, we have a few plugins but the support, the community and the platform is wonderful! I love this community all… --- ## [Kudos from Users on the "Timeline" feature](https://meta.discourse.org/t/kudos-from-users-on-the-timeline-feature/45329)
**Author:** [@BCHK](https://meta.discourse.org/u/BCHK)\ **回覆:** 2\ **Last updated:** [2016年六月6日 20:01 UTC](https://meta.discourse.org/t/kudos-from-users-on-the-timeline-feature/45329 "2016-06-06T20:01:08Z")
From my users: " Anxiety\_Orange June 6 I don’t know when this was added, but the “message timeline” on the right side of posts is really cool. Great job" --- ## [Off-topic posts that deserved their own topic](https://meta.discourse.org/t/off-topic-posts-that-deserved-their-own-topic/275139)
**Author:** [@Mittineague](https://meta.discourse.org/u/Mittineague)\ **回覆:** 0\ **Last updated:** [2016年五月27日 03:47 UTC](https://meta.discourse.org/t/off-topic-posts-that-deserved-their-own-topic/275139 "2016-05-27T03:47:44Z")
While working on this I was looking for a way to find topics that were created as a result of a moderator splitting posts into a new topic. (i.e. off-topic posts that deserved their own topic) It wasn’t as easy as I … --- ## ['Reply by email' badge](https://meta.discourse.org/t/reply-by-email-badge/276733)
**Author:** [@lrossouw](https://meta.discourse.org/u/lrossouw)\ **回覆:** 4\ **Last updated:** [2016年五月17日 08:33 UTC](https://meta.discourse.org/t/reply-by-email-badge/276733 "2016-05-17T08:33:46Z")
Anyone done a reply by email badge? --- ## [Awesome support](https://meta.discourse.org/t/awesome-support/44236)
**Author:** [@Primarypete](https://meta.discourse.org/u/Primarypete)\ **回覆:** 0\ **Last updated:** [2016年五月14日 12:00 UTC](https://meta.discourse.org/t/awesome-support/44236 "2016-05-14T12:00:07Z")
Just wanted to say that whilst I’m still waiting the mail settings to sort themselves out, I’m up and running with the rest of my Discourse instance. And it is awesome, as expected. But more importantly for any novices … --- ## [Social Architecture - Building On-line Communities](https://meta.discourse.org/t/social-architecture-building-on-line-communities/43871)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 6\ **Last updated:** [2016年五月13日 09:59 UTC](https://meta.discourse.org/t/social-architecture-building-on-line-communities/43871 "2016-05-13T09:59:01Z")
Came across this book which folks here may enjoy. It’s available to read for free online. (I haven’t read too much yet, but so far so good): Social Architecture - Building On-line Communities by Pieter Hintjens As S… --- ## [Recently Read Topics by User](https://meta.discourse.org/t/recently-read-topics-by-user/275000)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月4日 05:25 UTC](https://meta.discourse.org/t/recently-read-topics-by-user/275000 "2016-05-04T05:25:02Z")
Recently Read Topics by User Show the topics with that have been opened by a given user in the past N days, sorted by the amount of time the user has spent in that topic. (requested on feverbee) -- \[params\] -- integer :… --- ## [Kudos from My Users on Discourse - FYI](https://meta.discourse.org/t/kudos-from-my-users-on-discourse-fyi/43626)
**Author:** [@BCHK](https://meta.discourse.org/u/BCHK)\ **回覆:** 0\ **Last updated:** [2016年五月3日 18:23 UTC](https://meta.discourse.org/t/kudos-from-my-users-on-discourse-fyi/43626 "2016-05-03T18:23:37Z")
Thought the discourse team might like this - keep up the great work! From a user on my forum. " I love this forum because of the people on here, but I also love this forum because of the software. Discourse is amazing… --- ## [Likes by 'team'](https://meta.discourse.org/t/likes-by-team/274999)
**Author:** [@fefrei](https://meta.discourse.org/u/fefrei)\ **回覆:** 0\ **Last updated:** [2016年五月1日 18:48 UTC](https://meta.discourse.org/t/likes-by-team/274999 "2016-05-01T18:48:22Z")
Likes from the team This query assumes there is a group called team, and gives you the likes other users have received, split into likes from the team and likes from others: SELECT pl.user\_id, SUM(pl.team\_likes… --- ## [Last seen date updates with no other obvious activity (eg. posts read)](https://meta.discourse.org/t/last-seen-date-updates-with-no-other-obvious-activity-eg-posts-read/39854)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 10\ **Last updated:** [2016年五月1日 06:53 UTC](https://meta.discourse.org/t/last-seen-date-updates-with-no-other-obvious-activity-eg-posts-read/39854 "2016-05-01T06:53:41Z")
I’ve been trying to get a glimpse into engagement of users by peeking at the admin/users page every now and then. (I may post a larger topic on this sometime soon). One thing I’ve noticed is that the last\_seen\_date for… --- ## [Active Readers (Past Month)](https://meta.discourse.org/t/active-readers-past-month/275135)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月1日 05:15 UTC](https://meta.discourse.org/t/active-readers-past-month/275135 "2016-05-01T05:15:00Z")
Active Readers (Past Month) Users with the most visits that include reading activity select user\_id, count(1) as visits, sum(posts\_read) as posts\_read from user\_visits where posts\_read \> 0 and visited\_at \> CURR… --- ## [Posts Read Percentiles](https://meta.discourse.org/t/posts-read-percentiles/275134)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月1日 05:00 UTC](https://meta.discourse.org/t/posts-read-percentiles/275134 "2016-05-01T05:00:00Z")
Posts Read Percentiles Number of posts read for users in each percentile with tentiles as ( select posts\_read\_count as read, ntile(10) over (order by posts\_read\_count) as tentile from user\_stats ) sel… --- ## [Active Readers (Since N Days Ago)](https://meta.discourse.org/t/active-readers-since-n-days-ago/275136)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月1日 04:53 UTC](https://meta.discourse.org/t/active-readers-since-n-days-ago/275136 "2016-05-01T04:53:38Z")
Active Readers (Since N Days Ago) Number of users who have read at least 1 post since N days ago with intervals as ( select n as start\_time, CURRENT\_TIMESTAMP as end\_time from generate\_series(CU… --- ## [Posts Read (Daily)](https://meta.discourse.org/t/posts-read-daily/275133)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月1日 04:53 UTC](https://meta.discourse.org/t/posts-read-daily/275133 "2016-05-01T04:53:00Z")
Posts Read (Daily) Total number of new posts read by all users per day SELECT visited\_at as day, count(1) as users, sum(posts\_read) as posts\_read, sum(posts\_read) / count(1) as avg\_posts\_read\_per\_user FROM user\_visits … --- ## [Banner stats](https://meta.discourse.org/t/banner-stats/274998)
**Author:** [@Mittineague](https://meta.discourse.org/u/Mittineague)\ **回覆:** 0\ **Last updated:** [2016年五月1日 02:55 UTC](https://meta.discourse.org/t/banner-stats/274998 "2016-05-01T02:55:33Z")
Most of mine are “OK, but could be better” For example, this one works, but I don’t like the duplicate sub-query much Banner Stats WITH all\_users AS ( SELECT COUNT(users.id) AS user\_count FROM users WHERE users.… --- ## [Users Last Seen Since (Since N Days Ago)](https://meta.discourse.org/t/users-last-seen-since-since-n-days-ago/275130)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月1日 02:00 UTC](https://meta.discourse.org/t/users-last-seen-since-since-n-days-ago/275130 "2016-05-01T02:00:00Z")
Users Last Seen Since (Since N Days Ago) with intervals as ( select n as start\_time, CURRENT\_TIMESTAMP as end\_time from generate\_series(CURRENT\_TIMESTAMP - INTERVAL '30 days', … --- ## [Users Last Seen Since (Since N Weeks Ago)](https://meta.discourse.org/t/users-last-seen-since-since-n-weeks-ago/275128)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **回覆:** 0\ **Last updated:** [2016年五月1日 01:45 UTC](https://meta.discourse.org/t/users-last-seen-since-since-n-weeks-ago/275128 "2016-05-01T01:45:00Z")
Users Last Seen Since (Since N Weeks Ago) with intervals as ( select n as start\_time, CURRENT\_TIMESTAMP as end\_time from generate\_series(CURRENT\_TIMESTAMP - INTERVAL '140 days', … --- ## [Nice work on DFP plugin update](https://meta.discourse.org/t/nice-work-on-dfp-plugin-update/43422)
**Author:** [@charleswalter](https://meta.discourse.org/u/charleswalter)\ **回覆:** 6\ **Last updated:** [2016年四月29日 21:11 UTC](https://meta.discourse.org/t/nice-work-on-dfp-plugin-update/43422 "2016-04-29T21:11:49Z")
Just saw an update go live on our community today that shows ads every nth post. We have seen a nice boost in the number of ads without harming the user experience. Good job! --- ## [I like Discourse and the perf updates](https://meta.discourse.org/t/i-like-discourse-and-the-perf-updates/43056)
**Author:** [@Steven](https://meta.discourse.org/u/Steven)\ **回覆:** 2\ **Last updated:** [2016年四月24日 11:58 UTC](https://meta.discourse.org/t/i-like-discourse-and-the-perf-updates/43056 "2016-04-24T11:58:42Z")
I don’t know exactly what changed (I check all the commits, even if I don’t really understand anything :joy:) but my CPU and hardrive (the swap file I guess) can breathe a lot more since an upgrade on 04/21. We can see … --- ## [Great forum soft](https://meta.discourse.org/t/great-forum-soft/42670)
**Author:** [@jesus2099](https://meta.discourse.org/u/jesus2099)\ **回覆:** 2\ **Last updated:** [2016年四月17日 10:07 UTC](https://meta.discourse.org/t/great-forum-soft/42670 "2016-04-17T10:07:23Z")
I had been using a PunBB MusicBrainz forum for many years and when the Discourse MetaBrainz forum replaced it, I was very sceptical. It looked overly modern to my taste. Too much white colour all over the place. But I … --- ## [Wow, Discourse 1.5 is so snappy!](https://meta.discourse.org/t/wow-discourse-1-5-is-so-snappy/42265)
**Author:** [@holden](https://meta.discourse.org/u/holden)\ **回覆:** 0\ **Last updated:** [2016年四月8日 22:06 UTC](https://meta.discourse.org/t/wow-discourse-1-5-is-so-snappy/42265 "2016-04-08T22:06:25Z")
I just have to comment: Discourse is lightening fast now! You guys are doing an amazing job! Thank you! --- ## [Thank You So Much](https://meta.discourse.org/t/thank-you-so-much/39081)
**Author:** [@AnonymousPerson](https://meta.discourse.org/u/AnonymousPerson)\ **回覆:** 0\ **Last updated:** [2016年二月5日 02:32 UTC](https://meta.discourse.org/t/thank-you-so-much/39081 "2016-02-05T02:32:07Z")
▶ I'd like to say... @sam @codinghorror @admins --- ## [Love the support](https://meta.discourse.org/t/love-the-support/41854)
**Author:** [@govCMS.Admin](https://meta.discourse.org/u/govCMS.Admin)\ **回覆:** 2\ **Last updated:** [2016年四月7日 08:30 UTC](https://meta.discourse.org/t/love-the-support/41854 "2016-04-07T08:30:21Z")
Just wanted to say thank you for all the support and help everyone offers here. I am new to this and I don’t think I could have set up my community without you all. Thanks again. [上一頁](https://meta.discourse.org/c/community-building/65.md?ascending=true&page=69) [下一頁](https://meta.discourse.org/c/community-building/65.md?ascending=true&page=71)