<?php
/*
 * Common functions
 */
function logErrors($error) {
    $handle = fopen ( "err.txt", "a+" );
    fwrite ( $handle, $error . "\r\n" );
    fclose ( $handle );
}

function getSysDefaults() {
    global $dbh;
    $query = "select * from sys where id = 'def'";
    $result = mysqli_query($dbh,$query) or die ( 'login.inc - ' . mysqli_error ( $dbh ) );
    $row = $result->fetch_row();
}

function insert_error($program, $error) {
    global $dbh;
    $query = "insert into errors (program,error) values ('$program','$error')";
    $result = mysqli_query($dbh,$query) or logErrors ( 'login.inc', mysqli_error ( $dbh ) );
}

function formatDate($inDate) {
    if (!$inDate) { return 0; }
    list ( $yy, $mm, $dd ) = preg_split ( '/[-]+/', $inDate );
    $outDate = "$dd/$mm/$yy";
    return $outDate;
}

function formatTime($inTime) {
    if ($inTime != 0) {
        $outTime = sprintf( "%02d", ( int ) ($inTime / 60)) . ":";
        $outTime .= sprintf ( "%02d", ($inTime % 60) );
    } else {
        $outTime = $inTime;
    }
    return $outTime;
}

function reformatDate($inDate) {
    list ( $dd, $mm, $yy ) = preg_split ( '/[-.\/]/', $inDate );
    $outDate = "$yy-$mm-$dd";
    return $outDate;
}
/*
 * Main Routine to log in
 */
    include "config.inc";
    session_start ();
    $timezone = "Australia/NSW";
    date_default_timezone_set ( $timezone );
    $dbh = mysqli_connect($server,$user,$password,$db) or die ('Unable to connect to DB');
?>
