'no' ORDER BY active_users_halfyear DESC NULLS LAST, uptimelast7 DESC NULLS LAST"; } else { $sql = "SELECT * FROM pods WHERE adminrating <> -1 AND hidden <> 'yes' 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 tracked right 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 {$version=$row["shortversion"];$pre="This pod runs production code";} if ($row["shortversion"] == $row["masterversion"] && $row["shortversion"] != "") {$classver = "green";} elseif ($verdiff > 6) {$classver = "red";} else {$classver = "black";} echo ""; echo ""; if ($row["signup"] == 1) {$signup="Open";} else {$signup="Closed";} echo ""; echo ""; echo ""; echo ""; echo ""; if (strpos($row["pingdomurl"], "pingdom.com")) {$moreurl = $row["pingdomurl"];} else {$moreurl = "http://api.uptimerobot.com/getMonitors?format=json&customUptimeRatio=7-30-60-90&apiKey=".$row["pingdomurl"];} echo ""; if ($row["userrating"] >6) {$userratingclass="green";} elseif ($row["userrating"] <7) {$userratingclass="yellow";} elseif ($row["userrating"] <3) {$userratingclass="red";} 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? Version? Uptime.">? Signups? Total Users? Active Users? Posts? Comments? Months? Rating? Location? Services?
" . $row["domain"] . "
?
{$version}
" . $row["uptimelast7"] . "%" . $signup . "" . $row["total_users"] . "" . $row["active_users_halfyear"] . "" . $row["local_posts"] . "" . $row["comment_counts"] . "
" . $row["monthsmonitored"] . "
"; if ($row["userrating"] == 0) {echo "no rating yet";} for ($i = 0; $i < $row["userrating"]; $i++) { echo "✪"; } if ($row["adminrating"] >6) {$adminratingclass="green";} elseif ($row["adminrating"] <7) {$adminratingclass="yellow";} elseif ($row["adminrating"] <3) {$adminratingclass="red";} echo "

"; for ($iw = 0; $iw < $row["adminrating"]; $iw++) { echo "✪"; } echo "
" . $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 "