Changeset 5278

Timestamp:

04/07/2017 05:20:58 AM (8 years ago)

Author:

iandunn

Message:

Events: Only SELECT the columns that are actually used

File:

• sites/trunk/api.wordpress.org/public_html/events/1.0/index.php (modified) (2 diffs)

sites/trunk/api.wordpress.org/public_html/events/1.0/index.php

@@ -196 +196 @@
 
     $row = $wpdb->get_row( $wpdb->prepare( "
-        SELECT *
+        SELECT name, latitude, longitude, country
         FROM geoname
         WHERE
@@ -339 +339 @@
         return;
 
-    $row = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM ip2location WHERE ip_to >= %d ORDER BY ip_to ASC LIMIT 1", $long_ip ) );
+    $row = $wpdb->get_row( $wpdb->prepare( "
+        SELECT ip_city, ip_latitude, ip_longitude, country_short
+        FROM ip2location
+        WHERE ip_to >= %d
+        ORDER BY ip_to ASC
+        LIMIT 1",
+        $long_ip
+    ) );
+
     // Unknown location:
     if ( ! $row || '-' == $row->country_short ) {