1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

services:
  postgresql:
    image: bitnami/postgresql:latest
    volumes:
      - "postgresql_data:/bitnami/postgresql"
    environment:
      # ALLOW_EMPTY_PASSWORD is recommended only for development.
      - ALLOW_EMPTY_PASSWORD=yes
      - POSTGRESQL_USERNAME=bn_discourse
      - POSTGRESQL_DATABASE=bitnami_discourse
  redis:
    image: bitnami/redis:latest
    environment:
      # ALLOW_EMPTY_PASSWORD is recommended only for development.
      - ALLOW_EMPTY_PASSWORD=yes
    volumes:
      - "redis_data:/bitnami/redis"
  discourse:
    image: bitnami/discourse:3
    ports:
      - "80:3000"
    volumes:
      - "discourse_data:/bitnami/discourse"
    depends_on:
      - postgresql
      - redis
    environment:
      # ALLOW_EMPTY_PASSWORD is recommended only for development.
      - ALLOW_EMPTY_PASSWORD=yes
      - DISCOURSE_HOST=127.0.0.1
      - DISCOURSE_DATABASE_HOST=postgresql
      - DISCOURSE_DATABASE_PORT_NUMBER=5432
      - DISCOURSE_DATABASE_USER=bn_discourse
      - DISCOURSE_DATABASE_NAME=bitnami_discourse
      - DISCOURSE_REDIS_HOST=redis
      - DISCOURSE_REDIS_PORT_NUMBER=6379
  sidekiq:
    image: bitnami/discourse:3
    depends_on:
      - discourse
    volumes:
      - "sidekiq_data:/bitnami/discourse"
    command: /opt/bitnami/scripts/discourse-sidekiq/run.sh
    environment:
      # ALLOW_EMPTY_PASSWORD is recommended only for development.
      - ALLOW_EMPTY_PASSWORD=yes
      - DISCOURSE_HOST=127.0.0.1
      - DISCOURSE_DATABASE_HOST=postgresql
      - DISCOURSE_DATABASE_PORT_NUMBER=5432
      - DISCOURSE_DATABASE_USER=bn_discourse
      - DISCOURSE_DATABASE_NAME=bitnami_discourse
      - DISCOURSE_REDIS_HOST=redis
      - DISCOURSE_REDIS_PORT_NUMBER=6379
volumes:
  postgresql_data:
    driver: local
  redis_data:
    driver: local
  discourse_data:
    driver: local
  sidekiq_data:
    driver: local

1
2
3
4

sudo -s
git clone https://github.com/discourse/discourse_docker.git /var/discourse
cd /var/discourse
chmod 700 containers

1

./discourse-setup

1

./launcher bootstrap app

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

params:
  redis_io_threads: "1"
  redis_port: "6379"
  redis_password: "*******"

run:
    #.....
    # Add port configuration
  - replace:
      filename: "/etc/redis/redis.conf"
      from: /^port.*$/
      to: "port $redis_port"

  # Add password configuration
  - replace:
      filename: "/etc/redis/redis.conf"
      from: /^# requirepass.*$/
      to: "requirepass $redis_password"

1
2
3
4
5
6
7
8
9
10

params:
  db_port: "5432"

run:
  #......
  # 配置端口
  - replace:
      filename: "/etc/postgresql/15/main/postgresql.conf"
      from: /#?port *=.*/
      to: "port = $db_port"

1

su postgres -c "psql $db_name -c \"ALTER USER postgres WITH PASSWORD 'your_new_password'\";

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

# A container for all things Data, be sure to set a secret password for
# discourse account, SOME_SECRET is just an example
#

templates:
  - "templates/postgres.template.yml"
  - "templates/redis.template.yml"

# any extra arguments for Docker?
# docker_args:

params:
  db_default_text_search_config: "pg_catalog.english"

  ## Set db_shared_buffers to a max of 25% of the total memory.
  ## will be set automatically by bootstrap based on detected RAM, or you can override
  #db_shared_buffers: "256MB"

  ## can improve sorting performance, but adds memory usage per-connection
  #db_work_mem: "40MB"

expose:
  - "5432:5432"   # http
  - "6379:6379" # https

env:
  # ensure locale exists in container, you may need to install it
  LC_ALL: en_US.UTF-8
  LANG: en_US.UTF-8
  LANGUAGE: en_US.UTF-8

  #......省略

volumes:
  - volume:
        host: /var/discourse/shared/data
        guest: /shared
  - volume:
        host: /var/discourse/shared/data/log/var-log
        guest: /var/log

# TODO: SOME_SECRET to a password for the discourse user
hooks:
  after_postgres:
    - exec:
        stdin: |
          alter user discourse with password 'SOME_SECRET';
        cmd: su - postgres -c 'psql discourse'

        raise_on_fail: false

1

./launcher rebuild db

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Usage: launcher COMMAND CONFIG [--skip-prereqs] [--docker-args STRING]
Commands:
    start:       Start/initialize a container
    stop:        Stop a running container
    restart:     Restart a container
    destroy:     Stop and remove a container
    enter:       Open a shell to run commands inside the container
    logs:        View the Docker logs for a container
    bootstrap:   Bootstrap a container for the config based on a template
    run:         Run the given command with the config in the context of the last bootstrapped image
    rebuild:     Rebuild a container (destroy old, bootstrap, start new)
    cleanup:     Remove all containers that have stopped for > 24 hours
    start-cmd:   Generate docker command used to start container

Options:
    --skip-prereqs             Don't check launcher prerequisites
    --docker-args              Extra arguments to pass when running docker
    --skip-mac-address         Don't assign a mac address
    --run-image                Override the image used for running the container

1
2

./launcher rebuild app

1
2

./launcher start app
./launcher stop app

1

./launcher enter app

1

rake admin:create

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

env:
  ...
  DISCOURSE_RELATIVE_URL_ROOT: /forum

run:
    - exec:
        cd: $home
        cmd:
          - mkdir -p public/forum
          - cd public/forum && ln -s ../uploads && ln -s ../backups
    - replace:
       global: true
       filename: /etc/nginx/conf.d/discourse.conf
       from: proxy_pass http://discourse;
       to: |
          rewrite ^/(.*)$ /forum/$1 break;
          proxy_pass http://discourse;
    - replace:
       filename: /etc/nginx/conf.d/discourse.conf
       from: etag off;
       to: |
          etag off;
          location /forum {
             rewrite ^/forum/?(.*)$ /$1;
          }
    - replace:
         filename: /etc/nginx/conf.d/discourse.conf
         from: $proxy_add_x_forwarded_for
         to: $http_your_original_ip_header
         global: true

1
2

./launcher enter app
RAILS_ENV=production bundle exec script/discourse remap '/uploads' '/forum/uploads'

1
2
3
4
5
6
7
8

env:
  ...
  http_proxy: http://xxxx
  https_proxy: http://xxxx
  no_proxy: "127.0.0.1,localhost,.demo.com"
  HTTPS_PROXY: http://xxxx
  HTTP_PROXY: http://xxxx
  NO_PROXY: "127.0.0.1,localhost,.demo.com"

1
2
3
4
5
6
7
8
9
10

hooks:
  before_exec:
    - exec: "ulimit -v 2097152"
  after_code:
    - exec:
        cd: $home/plugins
        cmd:
          - git clone https://github.com/discourse/discourse-oauth2-basic
          - git clone https://github.com/discourse/discourse-restricted-replies
          - git clone https://github.com/discourse/discourse-templates

1
2
3
4
5
6
7
8
9
10
11
12
13
14

env:
  ...
  DISCOURSE_USE_S3: true
  DISCOURSE_S3_REGION: us-east1
  DISCOURSE_S3_INSTALL_CORS_RULE: false
  FORCE_S3_UPLOADS: 1
  DISCOURSE_S3_ENDPOINT: https://storage.googleapis.com
  DISCOURSE_S3_ACCESS_KEY_ID: myaccesskey
  DISCOURSE_S3_SECRET_ACCESS_KEY: mysecretkey
  DISCOURSE_S3_CDN_URL: https://falcoland-files-cdn.falco.dev
  DISCOURSE_S3_BUCKET: falcoland-files
  #DISCOURSE_S3_BACKUP_BUCKET: falcoland-files/backup
  #DISCOURSE_BACKUP_LOCATION: s3

1
2
3
4
5
6
7
8

hooks:
  after_assets_precompile:
    - exec:
        cd: $home
        cmd:
          - sudo -E -u discourse bundle exec rake s3:upload_assets
          # - sudo -E -u discourse bundle exec rake s3:expire_missing_assets  --trace 正常来说需要该步操作，但是目前执行会报错，可以手动在页面上删除。

1
2
3

DISCOURSE_MAX_REQS_PER_IP_MODE: none
DISCOURSE_MAX_ADMIN_API_REQS_PER_MINUTE: 600000

1
2
3
4

cd /opt/bitnami/discourse
git config --global http.sslVerify false
export http_proxy=http://xxxxxxxxx:1080
export https_proxy=http://xxxxxxxxx:1080

1
2

RAILS_ENV=production bundle exec rake plugin:install repo=https://github.com/discourse/discourse-oauth2-basic
RAILS_ENV=production bundle exec rake assets:precompile

1
2
3
4
5

echo "redditish:
  url: https://github.com/discourse/discourse-redditish-theme
  add_to_all_themes: true" | tee my_theme.yml > /dev/null
RAILS_ENV=production bundle exec rake themes:install > my_theme.yml
RAILS_ENV=production bundle exec rake themes:update assets:precompile

1

https://{host}/categories.json

1
2

https://{host}/c/{id}.json
https://{host}/c/10.json

1

https://{host}/about.json

1
2
3
4
5
6
7
8

SELECT * FROM users WHERE admin = true;


SELECT id, email FROM user_emails WHERE user_id = 1;--user@example.com


UPDATE user_emails SET email = 'user@example.com', updated_at = NOW() WHERE user_id = 1;

1
2

gzip gamer-community-2025-04-09-052308-v20250321143553-1.tar.gz
tar -zczvf gamer-community-2025-04-09-052308-v20250321143553-1.tar.gz ./*

1
2
3
4

rake site_settings:export > saved_settings.yml

rake site_settings:import < saved_settings.yml

1
2
3

rake export:category_structure
rake import:file["category-structure-export-2025-05-09-025650.json"]

1
2

git clone https://github.com/discourse/discourse.git
cd discourse

1
2
3
4
5
6
7
8
9
10
11

d/boot_dev --init
    # wait while:
    #   - dependencies are installed,
    #   - the database is migrated, and
    #   - an admin user is created (you'll need to interact with this)

# In one terminal:
d/rails s

# And in a separate terminal
d/ember-cli

1
2
3
4
5
6
7
8

---
C:/Users/truman/Desktop/discourse-redditish-theme:
  url: https://gamertest.xxxx.org
  components: none
  theme_id: 16
api_keys:
  https://gamertest.xxxx.org:
  xxxxxxxxxxxxx

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

export default class ProfileCustomLink extends Component {
  @service site;
  @service api;

  @tracked customLinkUrl;
  @tracked customLinkFieldId;
  @tracked showCustomLink = false;
  @tracked user = this.args.model.username;
  @tracked userId = this.args.model.id;
  @tracked userFields = this.args.model.user_fields;

  constructor() {
    super(...arguments);
    console.info("[Custom Profile Link] model", this.args.model);
    this.fetchExternalIds().then((oauth2BasicId) => {
      const url = settings.profile_custom_link_prefix + (oauth2BasicId == null ? '' : oauth2BasicId);
      this.customLinkUrl = url;
      this.showCustomLink = true;
    });
  }

  async fetchExternalIds() {
    try {
      const response = await ajax(`/admin/users/${this.userId}.json`, {
        headers: {
          "Api-Key": settings.profile_custom_link_api_key,
          "Api-Username": settings.profile_custom_link_api_username
        }
      });
      const oauth2BasicId = response.external_ids?.oauth2_basic;
      return oauth2BasicId
    } catch (error) {
      console.error("[Custom Profile Link] Error fetching external IDs:", error);
    }
  }
}

1
2
3
4
5
6
7
8
9

import { apiInitializer } from "discourse/lib/api";

export default apiInitializer((api) => {
  api.onPageChange(() =>{
      customFuntion();
  });

});

1

{{log "Theme settings:" settings}}

1
2
3

get mappings() {
        console.log("Bullet points mappings:", settings.bullet_points_mappings);
    }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

.
├── Gemfile
├── Gemfile.lock
├── LICENSE
├── README.md
├── app
│   └── controllers # 增加后端API 入口
│       └── discourse_profile
│           └── profile_controller.rb
├── assets
│   ├── javascripts
│   │   └── discourse
│   │       ├── components # 前端组件
│   │       │   └── profile-link.js
│   │       ├── connectors # 页面注入槽点
│   │       │   ├── user-card-post-names # 槽点
│   │       │   │   └── profile-link.hbs
│   │       │   └── user-location-and-website # 槽点
│   │       │       └── profile-link.hbs
│   │       └── templates
│   │           └── components
│   │               └── profile-link.hbs # 页面模板文件
│   └── stylesheets
│       └── common
│           └── profile.scss
├── config
│   ├── locales
│   │   └── client.en.yml # 国际化
│   ├── routes.rb # 路由配置
│   └── settings.yml # 配置参数
├── db
├── eslint.config.mjs
├── lib
│   └── profile_link
│       └── engine.rb
├── package.json
├── plugin.rb    # 插件注册和配置的入口
├── pnpm-lock.yaml
├── spec
│   └── system
│       └── core_features_spec.rb
├── stylelint.config.mjs
└── test
    └── javascripts

1
2
3
4
5

# name: discourse-profile
# about: Add Profile Link to User Profile
# version: 1.0.0
# authors: Truman
# url: https://xxxxx.xxxx.xxxxx

1
2
3
4
5
6
7
8
9
10
11

plugins:
  profile_link_enabled:
    default: true
    type: bool
    client: true
  profile_link_label:
    default: "Truman Profile"
    client: true
    type: text
  ......

1
2

enabled_site_setting :profile_link_enabled

1
2
3
4
5
6
7
8
9
10
11

after_initialize do
  # 注册设置
   settings = %w[
    label
    debug
  ]

  settings.each do |setting|
    SiteSetting.set("profile_link_#{setting}", SiteSetting.defaults["profile_link_#{setting}"] || nil)
  end
end

1
2
3
4
5
6
7
8
9
10

import Component from "@glimmer/component";
import { inject as service } from "@ember/service";

export default class ProfileLink extends Component {
    @service siteSettings;

    get linkLabel() {
        return this.siteSettings.profile_link_label;
    }
}

1

{{this.siteSettings.profile_link_label}}

1

SiteSetting.profile_link_label

1
2
3
4
5

category_resources:
  category_resources_enabled:
    default: true
    client: true
    description: "启用分类资源边栏功能"

1
2
3
4
5
6
7
8
9
10

en:
  admin_js:
    admin:
      site_settings:
        categories:
          category_resources: "Category Resources"
  js:
    category_resources:
      title: Category Resources

1
2
3
4
5
6
7
8
9
10
11
12
13
14

.user-card-location-and-website-outlet {
  margin-inline: 0.5em;

  .external-user-link {
    a {
      color: var(--primary);
      text-decoration: underline;
    }

    svg {
      margin-right: 0.25em;
    }
  }
}

1

register_asset "stylesheets/common/profile.scss"

1
2
3
4
5
6
7
8
9
10
11

import Component from "@glimmer/component";
import { service } from '@ember/service';

export default class ProfileLink extends Component {
    @service siteSettings;

    get linkLabel() {
        return this.siteSettings.profile_link_label;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

import Component from "@glimmer/component";
import { inject as service } from "@ember/service";
import { hbs } from "ember-cli-htmlbars";


export default class CategoryResources extends Component {
    @service router;
    @service siteSettings;

    constructor() {
        super(...arguments);
    }

    get categoryResources() {

        try {
            ....
        } catch (error) {
            console.error("...", error);
            return [];
        }
    }



    <template>
          <div class="resources-grid">
                        {{#each this.categoryResources as |resource|}}
                            <a href={{resource.url}}
                               target="_blank"
                               rel="noopener noreferrer"
                               class="resource-item"
                               title={{resource.description}}>
                                {{resource.name}}
                            </a>
                        {{/each}}
                    </div>
    </template>
}

1

<ProfileLink @user={{@outletArgs.user}}/>

1
2
3
4
5

require_relative "lib/profile_link/engine"

module ::DiscourseProfile
  PLUGIN_NAME = "discourse-profile"
end

1
2
3
4
5
6
7
8

# frozen_string_literal: true

module ::DiscourseProfile
  class Engine < ::Rails::Engine
    engine_name PLUGIN_NAME
    isolate_namespace DiscourseProfile
  end
end

1
2
3
4
5
6
7
8
9

# frozen_string_literal: true

DiscourseProfile::Engine.routes.draw do
  get "/profile_link/:user_id" => "profile#show", as: :profile_link
end

Discourse::Application.routes.draw do
  mount ::DiscourseProfile::Engine, at: "profile_link"
end

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

module DiscourseProfile
  class ProfileController < ::ApplicationController
    requires_plugin DiscourseProfile::PLUGIN_NAME

    def show
      if SiteSetting.profile_link_debug
        Rails.logger.info "Processing profile request for user_id: #{params[:user_id]}"
      end

      raise Discourse::InvalidAccess.new unless current_user


      user = User.find_by(id: params[:user_id])
      raise Discourse::NotFound unless user

      result = fetch_profile(user)



      render json: result
    end

    private

    def fetch_profile(user)
      {
        profile_url: 'test_url'
        username: user.username,
        nid: nid
      }
    end
  end
end