$value) {
if(intval($ftp["mark"][$key])) {
$ftp["file"][$key] = base64_decode($ftp["file"][$key]);
} else {
unset($ftp["mark"][$key]);
unset($ftp["file"][$key]);
}
}
if(!count($ftp["mark"])) $ftp["error"] = 1;
} else {
$ftp["error"] = 1;
}
?>
phpwcms: creating thumbnail
'application/mac-binhex40',
'cpt' => 'application/mac-compactpro',
'doc' => 'application/msword',
'pdf' => 'application/pdf',
'ai' => 'application/postscript',
'eps' => 'application/postscript',
'ps' => 'application/postscript',
'bcpio' => 'application/x-bcpio',
'bz2' => 'application/x-bzip2',
'csh' => 'application/x-csh',
'gtar' => 'application/x-gtar',
'gz' => 'application/x-gzip',
'tgz' => 'application/x-gzip',
'kwd' => 'application/x-kword',
'kwt' => 'application/x-kword',
'ksp' => 'application/x-kspread',
'kpr' => 'application/x-kpresenter',
'kpt' => 'application/x-kpresenter',
'chrt' => 'application/x-kchart',
'latex' => 'application/x-latex',
'sh' => 'application/x-sh',
'shar' => 'application/x-shar',
'swf' => 'application/x-shockwave-flash',
'tar' => 'application/x-tar',
'tcl' => 'application/x-tcl',
'tex' => 'application/x-tex',
'texinfo' => 'application/x-texinfo',
'texi' => 'application/x-texinfo',
't' => 'application/x-troff',
'tr' => 'application/x-troff',
'roff' => 'application/x-troff',
'man' => 'application/x-troff-man',
'zip' => 'application/zip',
'mpga' => 'audio/mpeg',
'mp2' => 'audio/mpeg',
'mp3' => 'audio/mpeg',
'aif' => 'audio/x-aiff',
'aiff' => 'audio/x-aiff',
'aifc' => 'audio/x-aiff',
'wav' => 'audio/x-wav',
'gif' => 'image/gif',
'ief' => 'image/ief',
'jpeg' => 'image/jpeg',
'jpg' => 'image/jpeg',
'jpe' => 'image/jpeg',
'png' => 'image/png',
'tiff' => 'image/tiff',
'tif' => 'image/tiff',
'asc' => 'text/plain',
'txt' => 'text/plain',
'c' => 'text/plain',
'c++' => 'text/plain',
'pl' => 'text/plain',
'cc' => 'text/plain',
'h' => 'text/plain',
'sgml' => 'text/sgml',
'sgm' => 'text/sgml',
'xml' => 'text/xml',
'mpeg' => 'video/mpeg',
'mpg' => 'video/mpeg',
'mpe' => 'video/mpeg',
'avi' => 'video/x-msvideo',
'html' => 'text/html',
'htm' => 'text/html',
'rtf' => 'application/rtf',
'talk' => 'text/x-speech',
'css' => 'text/css',
'xbm' => 'image/x-xbitmap',
'xpm' => 'image/x-xpixmap',
'rgb' => 'image/rgb',
'g3f' => 'image/g3fax',
'xwd' => 'image/x-xwindowdump',
'pict' => 'image/x-pict',
'ppm' => 'image/x-portable-pixmap',
'pgm' => 'image/x-portable-graymap',
'pbm' => 'image/x-portable-bitmap',
'pnm' => 'image/x-portable-anymap',
'bmp' => 'image/x-ms-bmp',
'ras' => 'image/x-cmu-raster',
'pcd' => 'image/x-photo-cd',
'cgm' => 'image/cgm',
'mil' => 'image/x-cals',
'cal' => 'image/x-cals',
'fif' => 'image/fif',
'dsf' => 'image/x-mgx-dsf',
'cmx' => 'image/x-cmx',
'wi' => 'image/wavelet',
'dwg' => 'image/x-dwg',
'dxf' => 'image/x-dxf',
'svf' => 'vector/x-svf',
'au' => 'audio/basic',
'snd' => 'audio/basic',
'mpa' => 'audio/x-mpeg',
'abs' => 'audio/x-mpeg',
'mpega' => 'audio/x-mpeg',
'mp2a' => 'audio/x-mpeg-2',
'mpa2' => 'audio/x-mpeg-2',
'es' => 'audio/echospeech',
'vox' => 'audio/voxware',
'lcc' => 'application/fastman',
'ra' => 'application/x-pn-realaudio',
'ram' => 'application/x-pn-realaudio',
'mmid' => 'x-music/x-midi',
'mid' => 'x-music/x-midi',
'skp' => 'application/x-koan',
'mpv2' => 'video/mpeg-2',
'mp2v' => 'video/mpeg-2',
'qt' => 'video/quicktime',
'mov' => 'video/quicktime',
'video' => 'video/x-msvideo',
'movie' => 'video/x-sgi-movie',
'vdo' => 'video/vdo',
'viv' => 'video/vivo',
'pac' => 'application/x-ns-proxy-autoconfig',
'ice' => 'x-conference/x-cooltalk',
'pdf' => 'application/pdf',
'mif' => 'application/x-mif',
'me' => 'application/x-troff-me',
'ms' => 'application/x-troff-ms',
'dvi' => 'application/x-dvi',
'dot' => 'application/msword',
'wp' => 'application/wordperfect5.1',
'oda' => 'application/oda',
'evy' => 'application/envoy',
'fm' => 'application/x-framemaker',
'frm' => 'application/x-framemaker',
'frame' => 'application/x-framemaker',
'ustar' => 'application/x-ustar',
'cpio' => 'application/x-cpio',
'sit' => 'application/x-stuffit',
'sea' => 'application/x-stuffit',
'bin' => 'application/octet-stream',
'uu' => 'application/octet-stream',
'exe' => 'application/octet-stream',
'dll' => 'application/octet-stream',
'com' => 'application/octet-stream',
'src' => 'application/x-wais-source',
'wsrc' => 'application/x-wais-source',
'hdf' => 'application/hdf',
'js' => 'text/javascript',
'ls' => 'text/javascript',
'mocha' => 'text/javascript',
'vbs' => 'text/vbscript',
'sh' => 'application/x-sh',
'csh' => 'application/x-csh',
'ppt' => 'application/mspowerpoint',
'axs' => 'application/x-olescript',
'xls' => 'application/msexcel',
'3dmf' => 'x-world/x-3dmf',
'dwf' => 'drawing/x-dwf',
'php' => 'text/plain',
'phps' => 'text/plain',
'rtx' => 'text/richtext'
);
$ftp["dir"] = intval($_POST["file_dir"]);
$ftp["short_info"] = clean_slweg($_POST["file_shortinfo"]);
$ftp["aktiv"] = empty($_POST["file_aktiv"]) ? 0 : 1;
$ftp["public"] = empty($_POST["file_public"]) ? 0 : 1;
$ftp["replace"] = empty($_POST["file_replace"]) ? 0 : 1;
$ftp["long_info"] = clean_slweg($_POST["file_longinfo"]);
$ftp["copyright"] = clean_slweg($_POST["file_copyright"]);
$ftp["tags"] = trim( trim( clean_slweg($_POST["file_tags"]), ',') );
$ftp["keywords"] = isset($_POST["file_keywords"]) ? $_POST["file_keywords"] : array();
$ftp["keys"] = "";
if(is_array($ftp["keywords"]) && count($ftp["keywords"])) {
foreach($ftp["keywords"] as $key => $value) {
unset($ftp["keywords"][$key]);
$key = intval($key);
if($value != "0_1") {
$ftp["keys"] .= (($ftp["keys"]) ? ":" : "").$key."_".intval($value);
$ftp["keywords"][$key] = intval($value);
} else {
$file_error["keywords"][$key] = 1;
}
}
}
?>
selected files uploaded via ftp will be taken over!
";
flush();
foreach($ftp["mark"] as $key => $value) {
if(!ini_get('safe_mode') && function_exists('set_time_limit')) set_time_limit(60);
$file = $ftp["file"][$key];
$file_path = PHPWCMS_ROOT.$phpwcms["ftp_path"].$file;
if(file_exists($file_path)) {
$file_type = '';
$file_error["upload"] = 0;
$file_size = filesize($file_path);
$file_ext = check_image_extension($file_path);
$file_ext = (false === $file_ext) ? which_ext($file) : $file_ext;
$file_name = clearfilename( PHPWCMS_CHARSET != 'utf-8' && seems_utf8($file) ? utf8_decode($file) : $file);
$file_hash = md5( $file_name . microtime() );
if(!trim($file_type)) {
//check file_type
if($ext_mime_type[$file_ext]) {
$file_type = $ext_mime_type[$file_ext];
} else {
$file_check = getimagesize($file_path);
if(version_compare("4.3.0", phpversion(), ">=") && $file_check) {
$file_type = image_type_to_mime_type($file_check[2]);
}
if(!trim($file_type)) {
$file_type = 'application/force-download';
}
}
}
$sql = "INSERT INTO ".DB_PREPEND."phpwcms_file (".
"f_pid, f_uid, f_kid, f_aktiv, f_public, f_name, f_created, f_size, f_type, f_ext, ".
"f_shortinfo, f_longinfo, f_keywords, f_hash, f_copyright, f_tags) VALUES (".
$ftp["dir"].", ".intval($_SESSION["wcs_user_id"]).", 1, ".$ftp["aktiv"].", ".$ftp["public"].", '".
aporeplace($file_name)."', '".time()."', '".$file_size."', '".aporeplace($file_type)."', '".
aporeplace($file_ext)."', '".aporeplace($ftp["short_info"])."', '".
aporeplace($ftp["long_info"])."', '".$ftp["keys"]."', '".$file_hash."', '".
aporeplace($ftp["copyright"])."', '".aporeplace($ftp["tags"])."')";
if($result = mysql_query($sql, $db) or die("error while insert file information")) {
$new_fileId = mysql_insert_id($db); //Festlegen der aktuellen File-ID
$_file_extension = ($file_ext) ? '.'.$file_ext : '';
$wcs_newfilename = $file_hash . $_file_extension;
// changed for using hashed file names
$userftppath = PHPWCMS_ROOT.$phpwcms["ftp_path"];
$useruploadpath = PHPWCMS_ROOT.$phpwcms["file_path"];
$usernewfile = $useruploadpath.$wcs_newfilename;
$oldumask = umask(0);
if ($dir = @opendir($useruploadpath)) {
if(@copy($userftppath.$file, $usernewfile)) {
@unlink($userftppath.$file);
// store tags
_dbSaveCategories($ftp["tags"], 'file', $new_fileId, ',');
} else {
$file_error["upload"] = "Error while writing file to storage (1).";
}
}
}
if(empty($file_error["upload"])) {
// now try to find 1st file having same named and replace it if related mark is set
if($ftp["replace"]) {
$rsql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE ";
$rsql .= "f_name='".aporeplace($file_name)."' AND f_kid=1 ";
$rsql .= "AND f_pid=".$ftp["dir"]." AND f_trash=0 AND f_id != ".$new_fileId." LIMIT 1";
if($rresult = mysql_query($rsql, $db)) {
if($rrow = mysql_fetch_assoc($rresult)) {
$oldFileID = $rrow['f_id'];
$oldFileHash = $rrow['f_hash'];
$oldFileNewHash = md5( $file_name . microtime() . time() );
// now update new file by old file information of same named
$nsql = "UPDATE ".DB_PREPEND."phpwcms_file SET ";
$nsql .= "f_refid=".$oldFileID.", f_trash=5, f_size=".$rrow['f_size'].', ';
$nsql .= "f_type='".$rrow['f_type']."', f_changed=".now().', ';
$nsql .= "f_hash='".aporeplace($oldFileNewHash)."' WHERE f_id=".$new_fileId;
if(mysql_query($nsql, $db)) {
// yepp both files are updated in db
// now change hash of file storage files
rename($useruploadpath.$oldFileHash.$_file_extension, $useruploadpath.$oldFileNewHash.$_file_extension);
rename($usernewfile, $useruploadpath.$oldFileHash.$_file_extension);
// update file size of old file with new filesize
_dbUpdate('phpwcms_file', array('f_type'=>$file_type, 'f_size'=>$file_size, 'f_changed'=>now()), 'f_id='.$oldFileID);
//now try to delete all temp images if available
$isql = "SELECT imgcache_imgname FROM ".DB_PREPEND."phpwcms_imgcache WHERE imgcache_hash='".aporeplace($oldFileHash)."'";
if($iresult = mysql_query($isql, $db)) {
$cImagePath = PHPWCMS_ROOT . '/' . PHPWCMS_IMAGES;
while($irow = mysql_fetch_row($iresult)) {
if(file_exists($cImagePath.$irow[0])) {
@unlink($cImagePath.$irow[0]);
}
}
}
}
}
mysql_free_result($rresult);
}
}
flush();
echo $file." [OK!]
";
} else {
echo $file." (".$file_error["upload"].")
";
mysql_query("DELETE FROM ".DB_PREPEND."phpwcms_file WHERE f_id=".$new_fileId." AND f_uid=".$_SESSION["wcs_user_id"], $db);
}
} else {
echo $file." not exists
";
}
flush();
}
echo "\n";
}
if(empty($file_error["upload"]) && empty($ftp["error"])) {
echo "every selected file was taken over
\n";
echo "click here to go back (if no automatic redirect)
\n";
echo "\n";
} else {
echo "error while file take over
\n";
echo "click here to go back
\n";
}
echo "\n\n";
if(isset($oldumask)) {
umask($oldumask);
}
?>