'no' ORDER BY weightedscore DESC"; } else { $sql = "SELECT * FROM pods WHERE adminrating <> -1 AND hidden <> 'yes' AND signup = 1 ORDER BY weightedscore DESC"; } $result = pg_query($dbh, $sql); if (!$result) { die("Error in SQL query: " . pg_last_error()); } $numrows = pg_num_rows($result); echo ""; echo $numrows; ?> pods that are open for signup now. Click column names to sort and find a pod. Show as: Map | Simple Table | Advanced Table "; ""; echo ""; echo ""; if ($country_code == $row["country"]) { echo "\n"; } else { echo "\n"; } echo "\n"; if ($tt == 4) { echo << EOF; } } pg_free_result($result); pg_close($dbh); ?>
Federated Pod? Uptime %.">? Active Users? Location? Services Offered?
" . $row["domain"] . "
?
" . $row["uptimelast7"] . "%" . $row["active_users_halfyear"] . "" . $row["country"] . "" . $row["country"] . ""; if ($row["service_facebook"] == "t") {echo "";} if ($row["service_twitter"] == "t") {echo "";} if ($row["service_tumblr"] == "t") {echo "";} if ($row["service_wordpress"] == "t") {echo "";} if ($row["xmpp"] == "t") {echo "
XMPP chat server
";} echo "