class.ftp.php:
<?php
include_once "db_mysql.ftp.php";
class FTP
{
var $dbh;
function FTP()
{
$this->dbh = new DBH();
}
function index()
{
$user = "";
$string = "<h1>Administration af FTP-brugere</h1>";
$sth = $this->dbh->prepare('SELECT id,userid FROM usertable');
$sth->execute();
if($sth->rows() > 0)
$string .= "<table><tr><th><b>Bruger</b></th></tr>";
while (list($id,$userid) = $sth->fetch_one_row() )
{
$string .= '<tr><td><a href="show.php?id='.$id.'">'.$userid.'</a></td>';
$string .= '<td><form action="removefromlog.php?id='.$id.'" method="post"><input type="submit" value="Slet log"></input></form></td>';
$string .= '<td><form action="edit.php?id='.$id.'" method="post"><input type="submit" value="Rediger"></input></form></td>';
$string .= '<td><form action="delete.php?id='.$id.'" method="post"><input type="submit" value="Slet"></input></form></td>';
$string .= "</tr>";
}
$string .= '<tr><td><form action="edit.php?id=-1" method="post"><input type="submit" value="Opret"></input></form></td><td></td></tr></table>';
return $string;
}
function showUserData($id)
{
$string = "<h1>Administration af FTP-brugere</h1>";
$sth = $this->dbh->prepare('SELECT userid,passwd,homedir,shell,uid,gid,LoginAllowed,count,last_login, last_logout FROM usertable WHERE id=?');
$sth->execute($id);
while (list($userid,$passwd,$homedir,$shell,$uid,$gid,$LoginAllowed,$count,$last_login,$last_logout) = $sth->fetch_one_row() )
{
$user = $userid;
$string .= '<table><tr><th><b>Data</b></th><th></th></tr>';
$string .= '<tr><td>Bruger:</td><td>'.$userid.'</td></tr>';
$string .= '<tr><td>Homedir:</td><td>'.$homedir.'</td></tr>';
$string .= '<tr><td>Sheel:</td><td>'.$shell.'</td></tr>';
$string .= '<tr><td>Uid:</td><td>'.$uid.'</td></tr>';
$string .= '<tr><td>Gid:</td><td>'.$gid.'</td></tr>';
if($LoginAllowed == 1)
{
$open = "<FONT class='authgood'>Aktiv</FONT>";
}
else
{
$open = "<FONT class='authbad'>Inaktiv</FONT>";
}
$string .= '<tr><td>Konto:</td><td>'.$open.'</td></tr>';
$string .= '<tr><td>Logins:</td><td>'.$count.'</td></tr>';
$string .= '<tr><td>Sidste login:</td><td>'.$last_login.'</td></tr>';
$string .= '<tr><td>Sidste logout:</td><td>'.$last_logout.'</td></tr>';
$string .= '</table>';
}
echo $userid;
$sth1 = $this->dbh->prepare('SELECT file,bytes,host,ip,cmd,transfer_time,time,status FROM xfer_stats WHERE usr=?');
$sth1->execute($user);
if($sth1->rows() > 0)
{
$string .= "<hr /><table border><tr><th>File</th><th>Størrelse</th><th>Host</th><th>Ip</th><th>Cmd</th><th>Overførselstid</th><th>Tid</th><th>Status</th></tr>";
while (list($file,$bytes,$host,$ip,$cmd,$transfer_time,$time,$status) = $sth1->fetch_one_row() )
{
$string .= "<tr><td>".$file."</td>";
$string .= "<td>".$bytes."</td>";
$string .= "<td>".$host."</td>";
$string .= "<td>".$ip."</td>";
$string .= "<td>".$cmd."</td>";
$string .= "<td>".$transfer_time."</td>";
$string .= "<td>".$time."</td>";
$string .= "<td>".$status."</td></tr>";
}
$string .= '</table>';
}
$string .= '<form action="index.php" method="post"><input type="submit" value="Tilbage"></input></form>';
return $string;
}
function createUser($data)
{
$string = '<h1>FTP-bruger</h1>';
$string .='<p>De indtastede data er blevet gemt i databasen. <br /><a href="./">Hop til oversigten</a>.';
$query = "INSERT INTO usertable (userid,passwd,homedir,shell,uid,gid,LoginAllowed) VALUES (?,Password(?),?,?,?,?,?)";
$sth = $this->dbh->prepare($query);
$sth->execute($data[0],$data[1],$data[2],$data[3],$data[4],$data[5],$data[6]);
return $string;
}
function editUser($data)
{
$string = '<h1>Ændringer gemt</h1>';
$string .='<p>De indtastede data er blevet gemt i databasen. <br /><a href="./">Hop til oversigten</a>.';
$sth = $this->dbh->prepare('UPDATE usertable SET userid=?,passwd=?,homedir=?,shell=?,uid=?,gid=?,LoginAllowed=? WHERE id=?');
$sth->execute($data[0],$data[1],$data[2],$data[3],$data[4],$data[5],$data[6],$data[7]);
return $string;
}
function getUserData($id)
{
$sth = $this->dbh->prepare('SELECT userid,passwd,homedir,shell,uid,gid,LoginAllowed,id FROM usertable WHERE id=?');
$sth->execute($id);
list($userid,$passwd,$homedir,$shell,$uid,$gid,$LoginAllowed,$id) = $sth->fetch_one_row();
$data = array($userid,$passwd,$homedir,$shell,$uid,$gid,$LoginAllowed,$id);
return $data;
}
function deleteUser($id,$files)
{
$sth = $this->dbh->prepare('DELETE FROM usertable WHERE id=?');
$sth->execute($id);
$string = "<h1>FTP-bruger slettet</h1>";
$string .= "<p>FTP-brugeren er slettet. <br /><a href=\"./\">Hop til oversigten</a>.</p>";
return $string;
}
function showDeleteUser($id)
{
$sth = $this->dbh->prepare('SELECT userid FROM usertable WHERE id=?');
$sth->execute($id);
list($userid) = $sth->fetch_one_row();
$string = "<h1>Sletning af FTP-bruger</h1>";
$string .= '<p>Er du sikker på at du vil slette følgende FTP-bruger:</p>';
$string .= "<p>".$userid."</p>";
$string .= '<form action="delete.php" method="post"><table>';
$string .= '<tr><td>Slet filer:</td><td>Ja:<input type="radio" name="files" checked value="1"> Nej:<input type="radio" name="files" value="0"></td></tr></table>';
$string .= '<input type="hidden" name="delete" value="true"></input><input type="hidden" name="id" value="'.$id.'"></input><input type="submit" name="submit" value="Bekræft"></input></form>';
return $string;
}
function removeUserLog($id)
{
$sth = $this->dbh->prepare('SELECT userid FROM usertable WHERE id=?');
$sth->execute($id);
list($userid) = $sth->fetch_one_row();
$sth = $this->dbh->prepare('DELETE FROM xfer_stats where usr=?');
$sth->execute($userid);
$string = "<h1>Log slettet</h1>";
$string .= '<p>Loggen for '.$userid.' blev slettet!</p>';
$string .= '<form action="index.php" method="post"><input type="submit" value="Tilbage"></input></form>';
return $string;
}
}
$ftp = new FTP();
?>
