将pureftpd.passwd文件的内容转换成sql语句,导入到mysql
pureftp.passwd格式:
<account>:<password>:<uid>:<gid>:<gecos>:<home directory>:<upload bandwidth>:
<download bandwidth>:<upload ratio>:<download ratio>:<max number of connections>:
<files quota>:<size quota>:<authorized local IPs>:<refused local IPs>:
<authorized client IPs>:<refused client IPs>:<time restrictions>
<?php
// 将pureftpd.passwd转换成sql语句
pureftp();
function pureftp() {
$filename = "pureftpd.passwd";
$fd = fopen($filename, "r");
while (!feof($fd)) {
$line = fgets($fd);
// echo $line ;
if (trim($line) != "")
handle_lines($line);
}
}
function handle_lines($line) {
$user_info = explode(":", $line);
$username = $user_info[0];
$password = $user_info[1];
$uid = $user_info[2];
$gid = $user_info[3];
$gecos = $user_info[4];
$home = $user_info[5];
$sql = "INSERT INTO `ftpd` (`User`, `status`, `Password`, `Uid`, `Gid`, `Dir`) " . " VALUES ('{$username}', '1', '{$password}', " . "'{$uid}', '{$gid}'," . "'{$home}');";
echo "$sql\n";
}
?>