Changeset 25 for types

Timestamp:

Nov 20, 2008, 12:19:52 PM (16 years ago)

Author:

george

Message:

• Upraveno: Data přijatých souborů neukládat přímo do databáze, ale ponechat je na disku.

Location:

types/File

Files:

• File.php (modified) (3 diffs)
• FileDownload.php (modified) (1 diff)

types/File/File.php

@@ -7 +7 @@
     global $Database;
 
-    $DbResult = $Database->query('SELECT `Name`, LENGTH(`Content`) FROM `SystemFile` WHERE `Id`='.$Item['Value']);
+    $DbResult = $Database->query('SELECT `Name`, `Size` FROM `SystemFile` WHERE `Id`='.$Item['Value']);
     if($DbResult->num_rows > 0)
     {
       $DbRow = $DbResult->fetch_assoc();
-      return('<a href="types/File/FileDownload.php?Id='.$Item['Value'].'">'.$DbRow['Name'].'</a> ('.HumanSize($DbRow['LENGTH(`Content`)']).')');
+      return('<a href="types/File/FileDownload.php?Id='.$Item['Value'].'">'.$DbRow['Name'].'</a> ('.HumanSize($DbRow['Size']).')');
     } else return('');
   }
@@ -26 +26 @@
   function OnLoad($Item)
   {
-    global $Database;
+    global $Database, $Config;
 
     $Result = 0;
@@ -34 +34 @@
       if(file_exists($_FILES[$Item['Name']]['tmp_name']))
       {
-        $Content = file_get_contents($_FILES[$Item['Name']]['tmp_name']);
         $FileName = substr($_FILES[$Item['Name']]['name'], strrpos($_FILES[$Item['Name']]['name'], '/'));
-        $Database->query('INSERT INTO SystemFile (`Name`, `Content`) VALUES ("'.$FileName.'", 0x'.bin2hex($Content).')');
+        $Database->query('INSERT INTO SystemFile (`Name`, `Size`) VALUES ("'.$FileName.'", '.filesize($_FILES[$Item['Name']]['tmp_name']).')');
         $Result = $Database->insert_id;
-        unlink($_FILES[$Item['Name']]['tmp_name']);
+        if(!move_uploaded_file($_FILES[$Item['Name']]['tmp_name'], $Config['UploadFileFolder'].'/'.$Result)) SystemMessage('Nahrání souboru', 'Cílová složka není dostupná!');
       }
     }

types/File/FileDownload.php

@@ -18 +18 @@
   Header('Content-Type: '.DetectMimeType($DbRow['Name']));
   Header('Content-Disposition: attachment; filename="'.$DbRow['Name'].'"');
-  echo($DbRow['Content']);
+  echo(file_get_contents($Config['UploadFileFolder'].'/'.$DbRow['Id']));
 } else echo('Soubor nenalezen!');