'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); ?> |
---|