| User | Yard | Target | Actions | Dates |
|---|
0) { #-----------
$WHERA = "where a.pID='$_POST[pID]' AND ";
} else {
$WHERA = "where ";
}
if ($_POST['uselimt'] == 'days') {
$WHERA .= "b.updated >= DATE_SUB(CURDATE(), INTERVAL $_POST[daysback] DAY)";
} elseif ($_POST['uselimt'] == 'span') {
$WHERA .= "(b.updated > '$beday' AND b.updated < '$enday')";
} else {
$WHERA .= "b.updated >= DATE_SUB(CURDATE(), INTERVAL 10 DAY)";
}
if ($_POST['inctm'] == 'y') { #---------
$timfmt = "%Y-%m-%d %h:%m";
} elseif ($_POST['inctm'] == 'n') {
$timfmt = "%Y-%m-%d";
}
#---------------------------------------------------------------
$qlog="select a.name_first, a.name_last, b.target_name, b.target_uid, b.action,
DATE_FORMAT(b.updated,'$timfmt') as udate
from person a RIGHT JOIN activLog b ON a.pID=b.cuid $WHERA
order by udate desc, a.name_last";
##- debug: print "$qlog\n";
$qlogd = mysql_query($qlog, $connect);
while (list($fnm,$lnm,$yard,$targ,$actn,$date) = mysql_fetch_array($qlogd)) {
if ((preg_match('/person/',$yard))&&(preg_match('/^\d+$/',$targ))) {
$qtarg = "select name_first, name_last from person where pID='$targ'";
$qtaract=mysql_query($qtarg, $connect);
list($fnm,$lnm)=mysql_fetch_array($qtaract);
$qured="$fnm $lnm";
} elseif ((preg_match('/institutes/',$yard))&&(preg_match('/^\d+$/',$targ))) {
$qtarg = "select name from institutes where iID='$targ'";
$qtaract=mysql_query($qtarg, $connect);
list($inm)=mysql_fetch_array($qtaract);
$qured=substr($inm,0,20);
} elseif ((preg_match('/country/',$yard))&&(preg_match('/^\d+$/',$targ))) {
$qtarg = "select ctryname from countries where cID='$targ'";
$qtaract=mysql_query($qtarg, $connect);
list($cnm)=mysql_fetch_array($qtaract);
$qured=substr($cnm,0,20)."...";
} elseif ((preg_match('/relationships/',$yard))&&(preg_match('/^\d+$/',$targ))) {
$qtarg = "select b.name_last, c.name_last
from relationships a
JOIN person b ON a.person_a_id=b.pID
JOIN person c ON a.person_b_id=c.pID
JOIN relationships d ON a.reltype_id=d.reID
where a.reID='$targ'";
$qtaract=mysql_query($qtarg, $connect);
list($pera,$perb)=mysql_fetch_array($qtaract);
$qured="$pera <=> $perb";
} else {
unset($qtarg); unset($qured);
}
print "
| $fnm $lnm | $yard | \n";
print " $qured | $actn | $date | \n";
print "
\n";
}
?>