????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.216.37 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/icad.astacus.se/archive/ |
Upload File : |
<?php
$CustomerId = "1219";
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
function listFolderFiles($dir){
$ffs = scandir($dir);
$files_arr = array();
unset($ffs[array_search('.', $ffs, true)]);
unset($ffs[array_search('..', $ffs, true)]);
// prevent empty ordered elements
if (count($ffs) < 1)
return;
foreach($ffs as $ff){
if(is_dir($dir.'/'.$ff)){
$arr = listFolderFiles($dir.'/'.$ff);
foreach($arr as $f){
array_push($files_arr,$f);
}
}
else{
// echo($dir.'/'.$ff."<br>");
$files_arr[] = $dir.'/'.$ff;
};
}
return $files_arr;
}
$dir = "/var/www/icad_files/$CustomerId/archive/Ritningsarkiv";
$files_arr = listFolderFiles($dir);
//print_r($files_arr);
foreach($files_arr as $FilePath){
$Filename = basename($FilePath);
$FileHash = md5($FilePath);
$sql2= "SELECT * FROM ICADARCHIVEGroups, ICADARCHIVEParameters WHERE ICADARCHIVEGroups.GroupId = ICADARCHIVEParameters.ParameterGroupId and CompanyId = ".$CustomerId;
$result = mysql_query($sql2);
while ($row = mysql_fetch_assoc($result)){
$ParameterId = $row['ParameterId'];
$Value = $row['ParameterDefaultValue'];
$sql3= "SELECT * FROM ICADARCHIVEParameterData WHERE FileHash = '$FileHash' ";
$result2 = mysql_query($sql3);
$found = false;
while ($row2 = mysql_fetch_assoc($result2)){
$found = true;
}
if($found == false){
$sql = "INSERT INTO ICADARCHIVEParameterData VALUES (NULL,'$FileHash',$ParameterId,'$Value','$Filename','$FilePath');";
echo($sql);
}
//mysql_query($sql);
}
}
/*
foreach($_FILES as $myFile){
$clientRelativePath = $_POST["SelectedPath_".$i];
$clientRelativePath = iconv("UTF-8", $target_encoding, $clientRelativePath);
if($Path == ""){
$File = "/var/www/icad_files/$CustomerId/archive/".dirname($clientRelativePath)."/";
}else{
$File = "/var/www/icad_files/$CustomerId/archive/$Path/".dirname($clientRelativePath)."/";
}
if(substr($File,strlen($File)-2,1) == "."){
$File = substr($File,0,strlen($File)-2);
}
$filename = str_replace("&", "_och_", $File.iconv("UTF-8", $target_encoding, $myFile['name']));
// Add Paraemters in ParametersData
// $FilePath = str_replace("//","/",($Path."/".$filename));
$FilePath = str_replace("//","/",($filename));
$FilePath = str_replace("//","/",($filename));
$Filename = basename($FilePath);
$FileHash = md5($FilePath);
$sql2= "SELECT * FROM ICADARCHIVEGroups, ICADARCHIVEParameters WHERE ICADARCHIVEGroups.GroupId = ICADARCHIVEParameters.ParameterGroupId and CompanyId = ".$CustomerId;
$result = mysql_query($sql2);
while ($row = mysql_fetch_assoc($result)){
$ParameterId = $row['ParameterId'];
$Value = $row['ParameterDefaultValue'];
$sql = "INSERT INTO ICADARCHIVEParameterData VALUES (NULL,'$FileHash',$ParameterId,'$Value','$Filename','$FilePath');";
mysql_query($sql);
}
$i++;
}
*/
// Add alla parameters to all files
?>