This shows you the differences between two versions of the page.
| Both sides previous revision
Previous revision
Next revision
|
Previous revision
Next revision
Both sides next revision
|
en:public_servers [2021/09/21 11:34]
jomat |
en:public_servers [2021/11/06 20:18]
jomat |
| | Please remove my server | See Contact | | | Please remove my server | See Contact | |
| | Contact? | #public_servers:asra.gr | | | Contact? | #public_servers:asra.gr | |
| | |
| | Other lists: |
| | - [[https://austinhuang.me/matrix-homeservers.html]] |
| | |
| | ---- |
| |
| <searchtable> | <searchtable> |
| <sortable> | <sortable> |
| <sql db="pgsql://matrixservers:jnhEfk3zSPiT4BkaC6xOja9Omq77Bu@172.23.216.251/matrixservers" display="block" wikitext="disable"> select domain as "Name", c2s as "Server", daemon as "Software", daemonver as "Version", to_timestamp(lastupdate) as "Last Check" from servers where reg=1 and federation=1 ORDER BY RANDOM(); </sql> | <sql db="pgsql://matrixservers:jnhEfk3zSPiT4BkaC6xOja9Omq77Bu@172.23.216.251/matrixservers" display="block" wikitext="disable"> select domain as "Name", c2s as "Server", daemon as "Software", daemonver as "Version", to_timestamp(lastupdate) as "Last Check" from servers where reg=1 and federation=1 and (domain, lastupdate) in (select domain, max(lastupdate) from servers group by domain) ORDER BY RANDOM(); </sql> |
| </sortable> | </sortable> |
| </searchtable> | </searchtable> |