[mirrorbrain-commits] [opensuse-svn] r6332 - trunk/tools/download-redirector-v2/mod_mirrorbrain

Author: poeml
Date: 2009-02-03 02:35:41 -0700 (Tue, 03 Feb 2009)
New Revision: 6332

Modified:
   trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf
Log:
mod_mirrorbrain config example: update the commented SQL statement


Modified: trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf
===================================================================
--- trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf	2009-02-03 09:34:31 UTC (rev 6331)
+++ trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf	2009-02-03 09:35:41 UTC (rev 6332)
@@ -60,12 +60,14 @@
     # Caveat: the fields are accessed by index. Thus, the order here must not change.
     #
     #MirrorBrainDBDQuery "\
-    #SELECT file_server.serverid, server.identifier, server.country, server.region, server.score, server.baseurl, \
-    #       server.country_only, server.region_only, server.other_countries \
-    #FROM file_server \
+    #SELECT file_server.serverid, server.identifier, server.country,  server.region, server.score, server.baseurl,  \
+    #       server.country_only, server.region_only, server.other_countries,  server.file_maxsize \
+    #FROM file \
+    #LEFT JOIN file_server \
+    #ON file.id = file_server.fileid \
     #LEFT JOIN server \
-    #ON file_server.serverid = server.id \
-    #WHERE file_server.path_md5=%s AND server.enabled=1 AND server.status_baseurl=1 AND server.score > 0"
+    #ON file_server.serverid = server.id  \
+    #HERE file.path=%s  AND server.enabled  AND server.status_baseurl  AND server.score > 0"
 
 
     <Directory /srv/www/htdocs/base_dir>

_______________________________________________
Opensuse-svn mailing list
Opensuse-svn_at_forge.novell.com
http://forge.novell.com/mailman/listinfo/opensuse-svn


_______________________________________________
mirrorbrain-commits mailing list

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org