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 10:44]
jomat |
en:public_servers [2021/09/23 12:47]
jomat |
| | I'm unhappy with my server | Migrate your account to a new one with https://ems.element.io/tools/matrix-migration | | | I'm unhappy with my server | Migrate your account to a new one with https://ems.element.io/tools/matrix-migration | |
| | Source code? Raw data set? | Sooon… | | | Source code? Raw data set? | Sooon… | |
| | | Please remove my server | See Contact | |
| | Contact? | #public_servers:asra.gr | | | Contact? | #public_servers:asra.gr | |
| |
| <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> |