diff options
| author | MadLittleMods <MadLittleMods@users.noreply.github.com> | 2023-06-07 17:51:27 +0000 |
|---|---|---|
| committer | MadLittleMods <MadLittleMods@users.noreply.github.com> | 2023-06-07 17:51:27 +0000 |
| commit | 61f04d8b5488935f4c3d8b92cf38692e63a84fa4 (patch) | |
| tree | db0d5a39ba8d0444f49510c9b7410e805e316e49 /develop/print.html | |
| parent | deploy: ec71214243eac58a4a6d272c15441a6405f6ae9c (diff) | |
| download | synapse-61f04d8b5488935f4c3d8b92cf38692e63a84fa4.tar.xz | |
deploy: 195b6a298d509518bf16d5a421d706ecb2ccdce6
Diffstat (limited to 'develop/print.html')
| -rw-r--r-- | develop/print.html | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/develop/print.html b/develop/print.html index cb46829b48..0a99a87584 100644 --- a/develop/print.html +++ b/develop/print.html @@ -15653,9 +15653,8 @@ to make further changes.</p> <h2 id="what-servers-are-currently-participating-in-this-room"><a class="header" href="#what-servers-are-currently-participating-in-this-room">What servers are currently participating in this room?</a></h2> <p>Run this sql query on your db:</p> <pre><code class="language-sql">SELECT DISTINCT split_part(state_key, ':', 2) - FROM current_state_events AS c - INNER JOIN room_memberships AS m USING (room_id, event_id) - WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join'; +FROM current_state_events +WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join'; </code></pre> <h2 id="what-users-are-registered-on-my-server"><a class="header" href="#what-users-are-registered-on-my-server">What users are registered on my server?</a></h2> <pre><code class="language-sql">SELECT NAME from users; |