'no' ORDER BY Hgitdate DESC, uptimelast7 DESC"; } else { $sql = "SELECT * FROM pods WHERE hidden <> 'yes' ORDER BY Hgitdate DESC, uptimelast7 DESC"; } if (!$result = $dbConnection->query($sql)) { if (DEBUG) { echo "Error in SQl Syntax. Error: ".$dbConnection->errorInfo[2]; } } else { foreach ($result->fetchAll() as $row) { echo "\n"; 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"; } $versionDiff = str_replace ( ".", "", $row ["masterversion"] ) - str_replace ( '.', '', $row ["shortversion"] ); $tip .= "This pod {$row["name"]} has been watched for {$row["monthsmonitored"]} months and its average ping time is {$row["responsetimelast7"]} with uptime of {$row["uptimelast7"]}% this month and was last checked on {$row["dateupdated"]}.
"; $tip .= "Code base is {$row["shortversion"]} and the current github base is {$row["masterversion"]}.
"; $tip .= "This pod is {$versionDiff} versions behind the current code. This pods IP {$row["ip"]} " . ($row ["ipv6"] == "yes" ? "has" : "does not have") . " IPv6 and is located in {$row["country"]}. On a score of -20 to +20 this pod is a {$row["score"]} right now, all data is checked every hour. Pod " . ($row ["signup"] == "1" ? "does" : "does not") . " allow new users.
"; echo " \n"; if (stristr ( $row ["shortversion"], 'head' )) { $version = ".dev code"; $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 " \n"; echo " \n"; $signup = $row["signup"]==1 ? "Open":"Closed"; echo " \n"; echo " \n"; echo " \n"; 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 " \n"; if ($row ["userrating"] > 6) { $userratingclass = "green"; } elseif ($row ["userrating"] <= 6) { $userratingclass = "yellow"; } elseif ($row ["userrating"] < 3) { $userratingclass = "red"; } echo " \n"; echo " \n"; echo "\n"; } } } ?>
Diaspora Pod? Version? Uptime.">? Signups? Users? Posts? Months Online? User Rating? Location?
{$version}
" . $row ["uptimelast7"] . "%" . $signup . "" . $row ["total_users"] . "" . $row ["local_posts"] . "
"; 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"] <= 6) { $adminratingclass = "yellow"; } elseif ($row ["adminrating"] < 3) { $adminratingclass = "red"; } echo "

"; for($iw = 0; $iw < $row ["adminrating"]; $iw ++) { echo "✪"; } echo "
" . $row ["country"] . "