";
$links = "";
include("/var/www/PHPwebsite/olde_header.php");
global $CameraTestArray;
$appName = "sroot";
require_once($_SERVER['DOCUMENT_ROOT'].'/zdata/sugar/route_setup.php');
setDetails(); // this adds test camera array
//echo "
";
//print_r($CameraTestArray);
//echo "
";
?>
What the picture's name is.
*/
$manuf_array = Array(
'AMAG' => 'amag64x32.jpg',
'American Direct' => 'AD.png',
'CEM' => 'cem-logo.png',
'Brivo' => 'brivo-logo.png',
'Continental_Access' => 'Napco.png',
'CDVI' => 'CDVI-logo.png',
'DSX' => 'dsx47x33.jpg',
'G4S' => 'g4s30.jpg',
'HartmannControls' => 'HartmannControls.jpg',
'Gallagher' => 'gallagher.png',
'ICT' => 'ictnew-24.jpg',
'Identicard' => 'identicard25.jpg',
'Infinias' => 'infinias30.jpg',
'Inner_Range' => 'ir32.jpg',
'Kantech' => 'kantech.png',
'Keyscan' => 'keyscan34.jpg',
'Lenel' => 'lenel113x20.jpg',
'Maxxess' => 'maxxess33.jpg',
'Open_Options' => 'open-options.png',
'Paxton' => 'paxton29.gif',
'PCSC' => 'pcsc23.jpg',
'Quintron' => 'quintron_logo.png',
'RBHAccess' => 'RBH-Access-Logo.png',
'RedCloud' => 'redcloud20.jpg',
'RS2' => 'rs2-93x30.jpg',
'SoftwareHouse' => 'Software-House.png',
'S2' => 's2-31.jpg'
);
// if the manufacturer field is not filled in
if (@!$_REQUEST['manufacturer']){
$q = "select * from exacq_access_control WHERE deleted=0 and (supported='supported' or supported='basicsupported' or supported='untested') and name not like '%legacy%' ORDER BY manufacturer ASC";
$q2 = "select * from exacq_access_control WHERE deleted=0 and (supported='supported' or supported='basicsupported' or supported='untested') and name like '%legacy%' ORDER BY manufacturer ASC";
}
else{
$q = "select * from exacq_access_control where deleted=0 and (supported='supported' or supported='basicsupported' or supported='untested') and id='".$_REQUEST['manufacturer']."' ORDER BY name ASC";
}
$p = $db->prepare($q);
$p->execute();
$results = $p->fetchAll(PDO::FETCH_ASSOC);
$resultAmt = $p->rowCount();
if (@!$_REQUEST['manufacturer']){
$p2 = $db->prepare($q2);
$p2->execute();
$results2 = $p2->fetchAll(PDO::FETCH_ASSOC);
$resultAmt2 = $p2->rowCount();
?>
Supported Manufacturers
Legacy Manufacturers
";
/*$db = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dateq = "select date_modified from exacq_access_control_tests where display_on_web = 1 order by date_modified DESC";
$datep = $db->prepare($dateq);
$datep->execute();
$date = $datep->fetchColumn();
echo "
updated ".date("d M Y", strtotime($date))."
";*/
include("/var/www/PHPwebsite/footer.php");
function buildTable($results, $resultAmt, $fullList = true) {
global $CameraTestArray;
global $manuf_array;
$string = "
";
foreach ($results as $row) {
@$resultCount++;
if ($fullList) {
$productName = str_replace(" - LEGACY", "", $row['name']);
} else {
$productName = $row['name'];
}
/*
Grabs the manufacturer name and outputs the manufacturer's logo and displays at top left.
This also displays the model link and the details about the model to the right of the manufacturer's logo.
*/
$string .= "
";
//if ($row['manufacturer'] == "Kantech") echo "";
// if exacq supports vca display the approval icon.
if (@$row['vca'] == 'supported') {
$string .= "
VCA Approved
";
}
if ($TestedByExacq) {
$string .= "
";
}
$string .= "
";
$string .= "
";
// Separates all the links into an array.
$links = explode(',', $row['links']);
// $linkAmt = count($links);
/*
Grabs links and displays them.
*/
$string .= "
";
if ($row['links']) {
$count = 0;
foreach ($links as $l) {
$count++;
// Separates the link from the link name.
$pair = explode('~', $l);
if (@$pair[0])
$string .= "
![](https://cdn.exacq.com/images/partners/" . $manuf_array[$row[)
";
// if exacq supports vca display the approval icon.
if (@$row['vca'] == 'supported') {
$string .= "
