Update of /cvsroot/fink/web/pdb
In directory sc8-pr-cvs5.sourceforge.net:/tmp/cvs-serv18501

Modified Files:
      Tag: redesign_pdb
        header.inc index.php 
Log Message:
Get latest change of pdb from db, using the newest date of the info files
in the db. 'timestamp.inc' no longer necessary.


Index: header.inc
===================================================================
RCS file: /cvsroot/fink/web/pdb/header.inc,v
retrieving revision 1.10.2.3
retrieving revision 1.10.2.4
diff -u -d -r1.10.2.3 -r1.10.2.4
--- header.inc  9 Feb 2007 17:31:21 -0000       1.10.2.3
+++ header.inc  17 Feb 2007 19:42:09 -0000      1.10.2.4
@@ -43,7 +43,6 @@
   "pdb/browse.php?nolist=on", "Search",
   "pdb/help.php", "Help needed"
 );
-include "timestamp.inc";
 
 $fsroot = "../";
 if (substr($root,0,1) == "-") {

Index: index.php
===================================================================
RCS file: /cvsroot/fink/web/pdb/index.php,v
retrieving revision 1.20.2.2
retrieving revision 1.20.2.3
diff -u -d -r1.20.2.2 -r1.20.2.3
--- index.php   9 Feb 2007 17:31:21 -0000       1.20.2.2
+++ index.php   17 Feb 2007 19:42:09 -0000      1.20.2.3
@@ -43,6 +43,16 @@
   $pkgcount = $pkgcount[0];
 }
 
+$q = "SELECT MAX(UNIX_TIMESTAMP(infofilechanged)) FROM package";
+$rs = mysql_query($q, $dbh);
+if (!$rs) {
+  print '<p><b>error during query:</b> '.mysql_error().'</p>';
+  $dyndate = '';
+} else {
+  $dyndate = mysql_fetch_array($rs);
+  $dyndate = $dyndate[0];
+}
+
 $q = "SELECT * FROM sections ORDER BY name ASC";
 $rs = mysql_query($q, $dbh);
 if (!$rs) {


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Fink-commits mailing list
Fink-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-commits

Reply via email to