Changeset 466

Timestamp:

03/06/2014 05:06:57 PM (12 years ago)

Author:

iandunn

Message:

Canonical Years: Exclude secondary language domains from search.

Previously a secondary domain like fr.2013.ottawa.wordcamp.org could be set as the canonical domain. This ensures that only domains with a format like 2014.ottawa.wordcamp.org will be considered canonical.

File:

• sites/trunk/wordcamp.org/public_html/wp-content/plugins/wc-canonical-years/wc-canonical-years.php (modified) (1 diff)

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wc-canonical-years/wc-canonical-years.php

@@ -36 +36 @@
         $city_domain = $matches[2];
 
-        $latest_domain = $wpdb->get_var( $wpdb->prepare( "SELECT domain FROM $wpdb->blogs WHERE domain LIKE %s ORDER BY domain DESC LIMIT 1;", "%.{$city_domain}" ) );
+        $latest_domain = $wpdb->get_var( $wpdb->prepare( "
+            SELECT domain
+            FROM $wpdb->blogs
+            WHERE
+                domain LIKE %s AND
+                SUBSTR( domain, 1, 4 ) REGEXP '^-?[0-9]+$' -- exclude secondary language domains like fr.2013.ottawa.wordcamp.org
+            ORDER BY domain
+            DESC LIMIT 1;",
+            "%.{$city_domain}"
+        ) );
+
         if ( $latest_domain != $current_domain && $latest_domain )
             printf( '<link rel="canonical" href="%s" />' . "\n", trailingslashit( esc_url( $latest_domain ) ) );