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