<?
if (!$n)
$n=20;
if ($recent){
$sql = "SELECT Changes.CustomerID, DATE_FORMAT(ChangeDate,'%b %D %k:%i') as nd,ChangeText, ChangeUser, FirstName, LastName
FROM Changes, MasterAccounts
WHERE Changes.CustomerID=MasterAccounts.CustomerID ";
if ($user)
$sql.="AND ChangeUser='$user' ";
$sql.="ORDER BY ChangeDate DESC LIMIT $n";
}else{
if ($CustomerID)
$sql="SELECT DATE_FORMAT(ChangeDate,'%b %D %k:%i') as nd, ChangeText, ChangeUser
FROM Changes
WHERE CustomerID=$CustomerID
ORDER BY nd DESC";
else{
header("Location: frmain.php");
exit;
}
}
include "mysql.inc.php";
$result=mysql_query($sql);
?><HTML>
<HEAD>
<TITLE>Changes</TITLE>
</HEAD>
<BODY bgcolor=white>
<BR><BR>
<FORM>View <INPUT TYPE=TEXT NAME=n SIZE=4 VALUE=<? echo $n ?>> Changes.
Written by <SELECT NAME=user><OPTION VALUE="">(All)</option>
<?
$nasql="SELECT DISTINCT ChangeUser FROM Changes ORDER BY ChangeUser";
$nares=mysql_query($nasql);
while ($narow=mysql_fetch_row($nares)){
print "<option";
if ($author == $narow[0]) print " selected";
print ">$narow[0]</option>\n";
}
?></SELECT>
<INPUT TYPE=HIDDEN NAME=recent VALUE=<? echo $recent ?>>
<INPUT TYPE=SUBMIT VALUE=Go>
</FORM>
<BR>
<TABLE>
<?
while ($row=mysql_fetch_array($result)){
$i++;
if ($i%2)
$bg= "#EEEEEE";
else
$bg= "#DDDDDD";
print "<TR bgcolor=$bg><TD colspan=2><A HREF=\"user.php?ID=$row[CustomerID]\">$row[FirstName] $row[LastName]</A> $row[nd]</TD>";
print "<TD rowspan=2>";
print ereg_replace("\n","<BR>",$row[ChangeText]);
print "</TD></TR>";
print "<TR bgcolor=$bg><TD colspan=2>$row[ChangeUser]</TD></TR>";
}
?>
</TABLE>
</BODY>
</HTML>
