random.php 618 Bytes
Newer Older
dmorley's avatar
dmorley committed
1
<?php
2 3
require_once __DIR__ . '/config.php';

dmorley's avatar
cleanup  
dmorley committed
4 5
$dbh = pg_connect("dbname=$pgdb user=$pguser password=$pgpass");
if (!$dbh) {
6
  die('Error in connection: ' . pg_last_error());
dmorley's avatar
cleanup  
dmorley committed
7 8 9 10
}
$sql = "SELECT * FROM pods WHERE adminrating <> -1 AND hidden <> 'yes' AND uptimelast7 > 95 AND masterversion = shortversion AND signup = 1 ORDER BY RANDOM() LIMIT 1";
$result = pg_query($dbh, $sql);
if (!$result) {
11
  die('Error in SQL query1: ' . pg_last_error());
dmorley's avatar
cleanup  
dmorley committed
12
}
dmorley's avatar
dmorley committed
13
$row = pg_fetch_all($result);
14 15
if ($row[0]['secure'] == 'true') {$ssl = 's';} else {$ssl = '';}
header('Location: http' . $ssl . '://' . $row[0]['domain'] . '/users/sign_up');