[Sitracker-devel] SF.net SVN: sitracker: [3510] trunk/htdocs/incident/files.inc.php

[<kie...@us...>]

Revision: 3510
          http://sitracker.svn.sourceforge.net/sitracker/?rev=3510&view=rev
Author:   kieran_hogg
Date:     2008-06-10 08:06:41 -0700 (Tue, 10 Jun 2008)

Log Message:
-----------
fix download links, needs testing

Modified Paths:
--------------
    trunk/htdocs/incident/files.inc.php

Modified: trunk/htdocs/incident/files.inc.php
===================================================================
--- trunk/htdocs/incident/files.inc.php	2008-06-10 15:01:13 UTC (rev 3509)
+++ trunk/htdocs/incident/files.inc.php	2008-06-10 15:06:41 UTC (rev 3510)
@@ -204,9 +204,17 @@
         $mime_type = '';
     }
 
+    $updateid = str_replace("u", "", $filedir);
+    $sql = "SELECT f.id FROM `{$GLOBALS['dbLinks']}`, `{$GLOBALS['dbFiles']}` AS f  ";
+    $sql .= "WHERE linktype = '5' AND origcolref='$updateid' ";
+    $sql .= "AND f.id = linkcolref AND f.filename='$filename'";
+    $result = mysql_query($sql);
+    $fileobj = mysql_fetch_object($result);
+    $fileid = $fileobj->id;
 
     // FIXME url
-    $url = "download.php?file=".urlencode($filename)."&incidentid={$incidentid}&p={$path}";
+    
+    $url = "download.php?id=$fileid";
 
     $html = "<tr>";
     $html .= "<td align='right' width='5%'>";


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.