Changeset 760423

Timestamp:

08/21/2013 10:53:23 PM (13 years ago)

Author:

yorman

Message:

Fixed Last-Login SQL query to use LEFT Join

File:

• sucuri-scanner/trunk/sucuri.php (modified) (1 diff)

sucuri-scanner/trunk/sucuri.php

@@ -712 +712 @@
         $table_name = SUCURISCAN_LASTLOGINS_TABLENAME;
 
-        $sql = "SELECT * FROM {$table_name} RIGHT JOIN {$wpdb->prefix}users ON {$table_name}.user_id = {$wpdb->prefix}users.ID";
+        $sql = "SELECT * FROM {$table_name} LEFT JOIN {$wpdb->prefix}users ON {$table_name}.user_id = {$wpdb->prefix}users.ID";
         if( !is_admin() ){
             $current_user = wp_get_current_user();