WordPress.org
Get WordPress

Plugin Directory

Changeset 1667635


Ignore:
Timestamp:
05/31/2017 11:25:02 AM (9 years ago)
Author:
Moridrin
Message:

3.1.4 prefix bugfix

Location:
ssv-users/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • ssv-users/trunk/functions.php

    r1660274 r1667635  
    7575    global $wpdb;
    7676    $customFieldsTag = SSV_Users::TAG_PROFILE_FIELDS;
    77     $results         = $wpdb->get_results("SELECT * FROM wp_posts WHERE post_content LIKE '%$customFieldsTag%'");
     77    $table = $wpdb->prefix . 'posts';
     78    $results         = $wpdb->get_results("SELECT * FROM $table WHERE post_content LIKE '%$customFieldsTag%'");
    7879    foreach ($results as $key => $row) {
    7980        wp_delete_post($row->ID);

  • ssv-users/trunk/readme.txt

    r1666688 r1667635  
    3131
    3232== Changelog ==
     33= 3.1.4 =
     34* Adding prefix (for multi-site) to all database searches.
     35
    3336= 3.1.3 =
    3437* Updating name fields disabled (due to possible bugs)

  • ssv-users/trunk/ssv-users.php

    r1666688 r1667635  
    99 * - Etc.
    1010 * This plugin is fully compatible with the SSV library which can add functionality like: MailChimp, Events, etc.
    11  * Version: 3.1.3
     11 * Version: 3.1.4
    1212 * Author: moridrin
    1313 * Author URI: http://nl.linkedin.com/in/jberkvens/
    … …  
    135135        /** @var \wpdb $wpdb */
    136136        global $wpdb;
    137         return $wpdb->get_results("SELECT * FROM wp_posts WHERE post_content LIKE '%$customFieldsTag%'");
     137        $table = $wpdb->prefix . 'posts';
     138        return $wpdb->get_results("SELECT * FROM $table WHERE post_content LIKE '%$customFieldsTag%'");
    138139    }
    139140
    … …  
    147148        /** @var \wpdb $wpdb */
    148149        global $wpdb;
    149         $results = $wpdb->get_results("SELECT ID FROM wp_posts WHERE post_content LIKE '%$customFieldsTag%'");
     150        $table = $wpdb->prefix . 'posts';
     151        $results = $wpdb->get_results("SELECT ID FROM $table WHERE post_content LIKE '%$customFieldsTag%'");
    150152        return array_column($results, 'ID');
    151153    }
Note: See TracChangeset for help on using the changeset viewer.