#!/usr/bin/php
<?php

# Copyright (c) 2010-2015 Yubico AB
# All rights reserved.
#
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are
# met:
#
#   * Redistributions of source code must retain the above copyright
#     notice, this list of conditions and the following disclaimer.
#
#   * Redistributions in binary form must reproduce the above
#     copyright notice, this list of conditions and the following
#     disclaimer in the documentation and/or other materials provided
#     with the distribution.
#
# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
# "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
# LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
# A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
# OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
# DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
# THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
# (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
# OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

$verbose = 0;
if (isset($argv[1])) {
    if ($argv[1] == "-h" || $argv[1] == "--help") {
        print "Usage: " . $argv[0] . " [-h|--help] [-v]\n";
        exit(1);
    }

    if ($argv[1] && $argv[1] != "-v") {
        print $argv[0] . ": invalid option -- '" . $argv[0] . "'\n";
        print "Try `" . $argv[0] . " --help' for more information.\n";
        exit(1);
    }

    $verbose = $argv[1] == "-v";
}

set_include_path(implode(PATH_SEPARATOR, array(
	get_include_path(),
	'/usr/share/yubikey-val',
	'/etc/yubico/val',
)));

require_once 'ykval-config.php';
require_once 'ykval-db.php';

$logname="ykval-checksum-clients";
$myLog = new Log($logname);

$db = Db::GetDatabaseHandle($baseParams, $logname);

if (!$db->connect()) {
    $myLog->log(LOG_WARNING, "Could not connect to database");
    exit(1);
}

$everything = "";
$result=$db->customQuery("SELECT id, active, secret ".
                         "FROM clients ".
                         "ORDER BY id");
while($row = $db->fetchArray($result)) {
    $active = $row['active'];
    if ($active == "") {
        # For some reason PostgreSQL returns empty strings for false values?!
        $active = "0";
    }
    $everything .=
                $row['id'] . "\t" . $active . "\t" .
                $row['secret'] . "\n";
}

$db->closeCursor($result);
$hash = sha1 ($everything);

if ($verbose) {
    print $everything;
}
print substr ($hash, 0, 10) . "\n";

$result=null;
$db=null;