cuclock.prg

<?php
$monLibrary= dirname(__FILE__) . "/../library";
require_once("$monLibrary/cu_top.i");
require_once("$monLibrary/ck_hticket.i");

    if (!CheckPerm($link, $Hu, basename($_SERVER['SCRIPT_NAME']), $_SERVER['REMOTE_ADDR'])) {
        // ** Permissions failed
        // ** redirect to new page
        header("Location: /hcuadm/hcu_noperm.prg");
        exit;
    }
$dms_ok=array('cu'=>'string');
dms_import($dms_ok);

$localzone="US/Mountain";
$clock="";

$dbh = $link;
$sql = "select trim(tz) from cuadmin where user_name='$cu'";
$sth = db_query($sql,$dbh);
if($sth) { list($tz) =  db_fetch_array($sth,0); }
if ("$tz" == "") {
    $clock = "No Timezone";
} else {
        if(strpos("$tz","/") === false) $tz = "US/$tz";
    $sql = "set time zone '$tz'; select time(0) without time zone 'now';";
    $sth = db_query($sql,$dbh);
    if($sth) {
        list($clock) =  db_fetch_array($sth,0);
        // ** Format the time
        $clock = dateformat("g:i:s A", $clock);
    }
    $sth = db_query("set time zone '$localzone'",$dbh);

}
$clock = ("$clock" == "" ? "Clock Failed" : "<font face='Helvetica' size='3'><b>$clock</b></font>");
print "$clock";
?>