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

Author: poeml
Date: 2009-03-01 14:12:42 -0700 (Sun, 01 Mar 2009)
New Revision: 6632

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

Modified: trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf
===================================================================
--- trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf	2009-03-01 21:12:02 UTC (rev 6631)
+++ trunk/tools/download-redirector-v2/mod_mirrorbrain/mod_mirrorbrain.conf	2009-03-01 21:12:42 UTC (rev 6632)
_at_@ -59,15 +59,15 @@
     #
     # 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,  server.file_maxsize \
-    #FROM file \
-    #LEFT JOIN file_server \
-    #ON file.id = file_server.fileid \
-    #LEFT JOIN server \
-    #ON file_server.serverid = server.id  \
-    #HERE file.path=%s  AND server.enabled  AND server.status_baseurl  AND server.score > 0"
+    # MirrorBrainDBDQuery "\
+    # SELECT id, identifier, region, country, asn, prefix, score, \
+    #        baseurl, region_only, country_only, as_only, prefix_only, \
+    #        other_countries, file_maxsize \
+    # FROM server \
+    # WHERE id::smallint = any( \
+    #     (SELECT mirrors FROM filearr WHERE path = %s)::smallint[] \
+    # ) \
+    # AND enabled AND status_baseurl AND 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