en:public_servers

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:public_servers [2021/09/23 12:47]
jomat
en:public_servers [2021/09/23 12:47] (current)
jomat
Line 12: Line 12:
 <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 and domain like '%2air%' and (domain, lastupdate) in (select domain, max(lastupdate) from servers group by domain) 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>
  • en/public_servers.txt
  • Last modified: 2021/09/23 12:47
  • by jomat