"; echo $numrows; echo " #Diaspora Pods listed, Come see the privacy aware social network.

'no' ORDER BY active_users_halfyear DESC NULLS LAST, uptimelast7 DESC NULLS LAST"; } else { $sql = "SELECT * FROM pods WHERE adminrating <> -1 AND hidden <> 'yes' AND signup = 1 ORDER BY active_users_halfyear DESC NULLS LAST, uptimelast7 DESC NULLS LAST"; } $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 Table "; ""; if (stristr($row["shortversion"],'head')) {$version=".dev";$pre = "This pod runs pre release development code";} elseif (!$row["shortversion"]) {$version="0";$pre = "This pod runs unknown code";} else echo ""; echo ""; echo "\n"; echo "\n"; if ($tt == 5) { echo << EOF; } } pg_free_result($result); pg_close($dbh); $country_code = $_SERVER["HTTP_CF_IPCOUNTRY"]; //echo $country_code; ?>

Diaspora Pod?	Uptime %.">?	Active Users?	Location?	Services Offered?
" . $row["domain"] . " ?	" . $row["uptimelast7"] . "%	" . $row["active_users_halfyear"] . "	" . $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 " ";} echo "