--- a/lib/common.inc.php +++ b/lib/common.inc.php @@ -1,291 +1,336 @@ -mode) { - $openid->required = array('contact/email'); - $openid->identity = 'https://www.google.com/accounts/o8/id'; - header('Location: ' . $openid->authUrl()); - } -} - -function auth() { - global $openid; - if ($_SESSION['authed'] == true) { - return true; - } - - if ($openid->mode) { - $attr = $openid->getAttributes(); - if ($attr['contact/email'] != 'maxious@gmail.com') { - die('Access Denied'); - } else { - $_SESSION['authed'] = true; - } - } else { - login(); - } -} - -// $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); -function databaseError($errMsg) { - if ($errMsg[2] != "") { - echo '
"; - } -} - -function ucsmart($str) { - $shortWords = Array("The", "Pty", "Ltd", "Inc", "Red", "Oil", "A", "An", "And", "At", "For", "In" - , "Of", "On", "Or", "The", "To", "With"); - $strArray = explode(" ", preg_replace("/(?<=(? $value) - $totale += array_sum_all($value); - return $totale; -} - -// magic query modifiers -$agency = filter_var($_REQUEST['agency'], FILTER_SANITIZE_STRING); -if ($agency != "") - $agencyQ = "agencyName = '" . $agency . "' AND "; - -$supplier = filter_var($_REQUEST['supplier'], FILTER_SANITIZE_STRING); -if ($supplier != "") { - $supplierParts = explode("-", $supplier); - $supplierName = "%" . $supplierParts[1] . "%"; - $supplierABN = $supplierParts[0]; - if ($supplierParts[0] > 0) - $supplierQ = ' "supplierABN" = :supplierABN AND '; - else - $supplierQ = ' "supplierName" LIKE :supplierName AND '; -} - -$startYear = 2007; -$year = filter_var($_REQUEST['year'], FILTER_SANITIZE_NUMBER_INT); -if ($year != "") { - $yearQ = "YEAR(publishDate) = " . $year . " AND "; -} -$standardQ = ' "childCN" is null '; // AND YEAR(contractStart) >= 2007 AND YEAR(contractStart) <= 2010'; -$start = 0.0; - -function local_url() { - return "http://" . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/"; -} - -function include_header($title) { - global $start; - ?> - - - -