'no' AND score < 50 ORDER BY weightedscore"; $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.
Pod? | Version? | Uptime.">? | ms | Signups | Total? | Active 6? | Active 1? | Posts? | Comm? | Month? | Sc? | conn? | Delete?? | " . $row["domain"] . " ? | ";
"";
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 "{$version} | ";
echo "" . $row["uptimelast7"] . " | "; echo "" . $row["responsetimelast7"] . " | "; if ($row["signup"] == 1) {$signup="Open";} else {$signup="Closed";} echo "" . $signup . " | "; echo "" . $row["total_users"] . " | "; echo "" . $row["active_users_halfyear"] . " | "; echo "" . $row["active_users_monthly"] . " | "; echo "" . $row["local_posts"] . " | "; echo "" . $row["comment_counts"] . " | "; 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 ""; echo " | " . $row["score"] . " | \n"; echo "con info | \n";
?>
\n"; } pg_free_result($result); pg_close($dbh); ?> |
---|