'no' ORDER BY Hgitdate DESC, uptimelast7 DESC"; } else { $sql = "SELECT * FROM pods WHERE adminrating <> -1 AND hidden <> 'yes' ORDER BY Hgitdate DESC, uptimelast7 DESC"; } $result = pg_query($dbh, $sql); if (!$result) { die("Error in SQL query: " . pg_last_error()); } $numrows = pg_num_rows($result); while ($row = pg_fetch_array($result)) { $tt=$tt+1; if ($row["secure"] == "true") {$method = "https://";$class="green";$tip="This pod uses SSL encryption for traffic.";} else {$method = "http://";$class="red";$tip="This pod does not offer SSL";} //if ($tt == "3") {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 ""; echo "\n"; echo "\n"; } pg_free_result($result); pg_close($dbh); ?>
Diaspora Pod? Live Status? Last Code Pull? Uptime.">? Months? Rating? Response Time.">? Ipv6? Location?
" . $row["status"] . "
" . strtotime($row["hgitdate"]) . "
" . $row["uptimelast7"] . "
"; 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["responsetimelast7"] . "" . $row["ipv6"] . "" . $row["country"] . "