WordPress.org
Get WordPress

Plugin Directory

Changeset 1313832


Ignore:
Timestamp:
12/21/2015 09:38:27 PM (10 years ago)
Author:
trackhs
Message:

1.9.8 fixes

Location:
track-connect/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • track-connect/trunk/includes/api/request.php

    r1313783 r1313832  
    249249                // Update the Amenities
    250250                foreach($unit->amenities as $amenity){
    251                     $term = $wpdb->get_row("SELECT term_id FROM wp_terms WHERE amenity_id = '".$amenity->id."' ;");
     251                    $term = $wpdb->get_row("SELECT term_taxonomy_id FROM wp_term_taxonomy
     252                    JOIN wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
     253                    WHERE amenity_id = '".$amenity->id."' ;");
    252254                    if($term){
    253                         $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id = '".$post_id."' AND term_taxonomy_id = '".$term->term_id."';");
     255                        $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id = '".$post_id."' AND term_taxonomy_id = '".$term->term_taxonomy_id."';");
    254256                        $wpdb->query("INSERT INTO wp_term_relationships set
    255257                            object_id = '".$post_id."',
    256                             term_taxonomy_id = '".$term->term_id."';");
     258                            term_taxonomy_id = '".$term->term_taxonomy_id."';");
    257259                    }
    258260                }
    … …  
    340342                if(isset($unit->amenities)){
    341343                    foreach($unit->amenities as $amenity){
    342                         $term = $wpdb->get_row("SELECT term_id FROM wp_terms WHERE amenity_id = '".$amenity->id."';");
     344                        $term = $wpdb->get_row("SELECT term_taxonomy_id FROM wp_term_taxonomy
     345                        JOIN wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
     346                        WHERE amenity_id = '".$amenity->id."';");
    343347                        if($term){
    344348                            $wpdb->insert( 'wp_term_relationships',
    345                                     array( 'object_id' => $post_id, 'term_taxonomy_id' => $term->term_id ), 
     349                                    array( 'object_id' => $post_id, 'term_taxonomy_id' => $term->term_taxonomy_id ), 
    346350                                    array( '%d', '%d' ) );
    347351                        }
    … …  
    465469                JOIN wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
    466470                WHERE node_id = '".$nodeId."' 
    467                 LIMIT 1;");
    468        
     471                LIMIT 1;");             
     472               
    469473                if($term){   
    470474                    if(isset($node->units)){     

  • track-connect/trunk/plugin.php

    r1313783 r1313832  
    77    Author URI: http://www.trackhs.com
    88
    9     Version: 1.9.7
     9    Version: 1.9.8
    1010
    1111    License: GNU General Public License v2.0 (or later)
    … …  
    5555
    5656    define( 'WP_LISTINGS_URL', plugin_dir_url( __FILE__ ) );
    57     define( 'WP_LISTINGS_VERSION', '1.9.7' );
     57    define( 'WP_LISTINGS_VERSION', '1.9.8' );
    5858
    5959    /** Load textdomain for translation */

  • track-connect/trunk/readme.txt

    r1313783 r1313832  
    44Requires at least: 3.7
    55Tested up to: 4.2.3
    6 Stable tag: 1.9.7
     6Stable tag: 1.9.8
    77
    88Creates and syncs listing-type posts from TRACK PM, a cloud-based property management system (www.trackhs.com).
Note: See TracChangeset for help on using the changeset viewer.