'no' AND score < 50 ORDER BY weightedscore"; $result = pg_query($dbh, $sql); $result || die('Error in SQL query: ' . pg_last_error()); $numrows = pg_num_rows($result); ?> 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'] . ' | '; echo '' . ($row['signup'] === '1' ? 'Open' : 'Closed') . ' | '; 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 = 'https://api.uptimerobot.com/getMonitors?format=json&customUptimeRatio=7-30-60-90&apiKey=' . $row['pingdomurl']; } echo ''; echo ' | ' . $row['score'] . ' | '; echo 'con info | ';
?>
'; } pg_free_result($result); pg_close($dbh); ?> |
---|