[prev in list] [next in list] [prev in thread] [next in thread]
List: bzflag-commits
Subject: SF.net SVN: bzflag: [16655] trunk/web/submitimages/tmp/directory.php
From: blast007 () users ! sourceforge ! net
Date: 2008-02-28 16:39:13
Message-ID: E1JUlmr-00039q-UB () sc8-pr-svn2 ! sourceforge ! net
[Download RAW message or body]
Revision: 16655
http://bzflag.svn.sourceforge.net/bzflag/?rev=16655&view=rev
Author: blast007
Date: 2008-02-28 08:39:13 -0800 (Thu, 28 Feb 2008)
Log Message:
-----------
Throw in some SQLite magic to read the information about the files contained in the \
image directories.
Modified Paths:
--------------
trunk/web/submitimages/tmp/directory.php
Modified: trunk/web/submitimages/tmp/directory.php
===================================================================
--- trunk/web/submitimages/tmp/directory.php 2008-02-28 11:47:24 UTC (rev 16654)
+++ trunk/web/submitimages/tmp/directory.php 2008-02-28 16:39:13 UTC (rev 16655)
@@ -20,6 +20,40 @@
return round($size, 2).$unit;
}
+ // Set up the SQLite database object and query the file data for this directory
+
+ define('DATABASE_VERSION', 1);
+
+ $filename = $filedirectory.'/data.sqlite3';
+
+ $data = Array();
+ $data['files'] = Array();
+
+ if (file_exists($filename))
+ {
+
+ // create a SQLite3 database file with PDO and return a database handle (Object \
Oriented) + try
+ {
+ $sqlite = new PDO('sqlite:'.$filename);
+
+ // Verify that we don't need to upgrade the database file
+ $query['checkVersion'] = $sqlite->query("SELECT value FROM info WHERE name = \
'dbversion'"); + $data['checkVersion'] = $query['checkVersion']->fetch();
+
+ // For now, only run further queries if the database version matches
+ if ($data['checkVersion']['value'] == DATABASE_VERSION)
+ {
+ $query['files'] = $sqlite->query("SELECT * FROM files");
+ $data['files'] = $query['files']->fetchAll();
+ }
+ }
+ catch( PDOException $exception )
+ {
+ //die($exception->getMessage());
+ }
+ }
+
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
@@ -91,7 +125,28 @@
foreach($items['directories'] as $item)
echo " <tr><td><a \
href=\"$httpdirectory$item/\">$item</a></td><td><DIR></td><td>N/A</td><td>N/A</td><td>N/A</td></tr>\n";
foreach($items['files'] as $item)
- echo " <tr><td><a \
href=\"$httpdirectory$item\">$item</a></td><td>".nicefilesize($filedirectory."/".$item)."</td><td>(Unknown)</td><td>(Unknown)</td><td>(Unknown)</td></tr>\n";
+ {
+ $file = false;
+ foreach($data['files'] as $f)
+ {
+ if ($f['filename'] == $item)
+ {
+ $file = $f;
+ }
+ }
+
+ if ($file)
+ {
+ echo " <tr><td><a \
href=\"$httpdirectory$item\">$item</a></td><td>".nicefilesize($filedirectory."/".$item)."</td><td>".$file['author']."</td><td>".$file['uploader']."</td><td>";
+ if ($file['licenseurl'])
+ echo '<a href="'.$file['licenseurl'].'">'.$file['licensename']."</a>";
+ else
+ $file['licensename'];
+ echo "</td></tr>\n";
+ }
+ else
+ echo " <tr><td><a \
href=\"$httpdirectory$item\">$item</a></td><td>".nicefilesize($filedirectory."/".$item)."</td><td>(Unknown)</td><td>(Unknown)</td><td>(Unknown)</td></tr>\n";
+ }
}
else
echo " <tr><td colspan=\"5\">No files or folders exist in this \
directory</td></tr>\n";
This was sent by the SourceForge.net collaborative development platform, the world's \
largest Open Source development site.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
BZFlag-commits mailing list
BZFlag-commits@lists.SourceForge.net
https://lists.SourceForge.net/lists/listinfo/bzflag-commits
irc: #BZFlag @ irc.freenode.net
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic