WordPress.org
Get WordPress

Plugin Directory

Changeset 1313783


Ignore:
Timestamp:
12/21/2015 07:53:37 PM (10 years ago)
Author:
trackhs
Message:

1.9.7 fixes

Location:
track-connect/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

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

    r1312190 r1313783  
    3535        global $wpdb;
    3636       
    37         $term = $wpdb->get_row("SELECT term_id FROM wp_terms WHERE slug = 'active' LIMIT 1;");
    38         $wpdb->delete( 'wp_term_relationships', array('term_taxonomy_id' => $term->term_id));
     37        $term = $wpdb->get_row("SELECT term_taxonomy_id FROM wp_term_taxonomy
     38        JOIN wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
     39        WHERE slug = 'active'
     40        LIMIT 1;");
     41        $wpdb->delete( 'wp_term_relationships', array('term_taxonomy_id' => $term->term_taxonomy_id));
    3942    }
    4043       
    … …  
    8083        }*/
    8184       
    82         $term = $wpdb->get_row("SELECT term_id FROM wp_terms WHERE slug = 'active' LIMIT 1;");
     85        $term = $wpdb->get_row("SELECT term_taxonomy_id FROM wp_term_taxonomy
     86        JOIN wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
     87        WHERE slug = 'active'
     88        LIMIT 1;");
    8389        $wpdb->delete( 'wp_term_relationships', array('term_taxonomy_id' => 0));
    8490        $wpdb->delete( 'wp_term_relationships', array('object_id' => 0));
    85         $activeTerm = $term->term_id;
     91        $activeTerm = $term->term_taxonomy_id;
    8692               
    8793        $unitsRemoved = 0;
    … …  
    430436                    array( 'term_id' => $termId, 'taxonomy' => 'locations', 'parent' => 0 ), 
    431437                    array( '%d', '%s', '%d' ) );
     438                $term_taxonomy_id = $wpdb->insert_id;
    432439                   
    433440               
    … …  
    435442                    $post = $wpdb->get_row("SELECT ID FROM wp_posts WHERE unit_id = '".$unitId."';");
    436443                    if($post){
    437                         $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id = '".$post->ID."' AND term_taxonomy_id = '".$termId."';");
     444                        $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id = '".$post->ID."' AND term_taxonomy_id = '".$term_taxonomy_id."';");
    438445                        $wpdb->insert( 'wp_term_relationships',
    439                             array( 'object_id' => $post->ID, 'term_taxonomy_id' => $termId ), 
     446                            array( 'object_id' => $post->ID, 'term_taxonomy_id' => $term_taxonomy_id ), 
    440447                            array( '%d', '%d' ) );
    441448                    }
    … …  
    455462                */
    456463               
    457                 $term = $wpdb->get_row("SELECT term_id FROM wp_terms WHERE node_id = '".$nodeId."';");
    458                
     464                $term = $wpdb->get_row("SELECT term_taxonomy_id FROM wp_term_taxonomy
     465                JOIN wp_terms ON wp_terms.term_id = wp_term_taxonomy.term_id
     466                WHERE node_id = '".$nodeId."' 
     467                LIMIT 1;");
     468       
    459469                if($term){   
    460470                    if(isset($node->units)){     
    … …  
    462472                            $post = $wpdb->get_row("SELECT ID FROM wp_posts WHERE unit_id = '".$unitId."';");
    463473                            if($post){
    464                                 $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id = '".$post->ID."' AND term_taxonomy_id = '".$term->term_id."';");
     474                                $wpdb->query("DELETE FROM wp_term_relationships WHERE object_id = '".$post->ID."' AND term_taxonomy_id = '".$term->term_taxonomy_id."';");
    465475                                $wpdb->insert( 'wp_term_relationships',
    466                                     array( 'object_id' => $post->ID, 'term_taxonomy_id' => $term->term_id ), 
     476                                    array( 'object_id' => $post->ID, 'term_taxonomy_id' => $term->term_taxonomy_id ), 
    467477                                    array( '%d', '%d' ) );
    468478                            }

  • track-connect/trunk/plugin.php

    r1312190 r1313783  
    77    Author URI: http://www.trackhs.com
    88
    9     Version: 1.9.6
     9    Version: 1.9.7
    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.6' );
     57    define( 'WP_LISTINGS_VERSION', '1.9.7' );
    5858
    5959    /** Load textdomain for translation */

  • track-connect/trunk/readme.txt

    r1312190 r1313783  
    44Requires at least: 3.7
    55Tested up to: 4.2.3
    6 Stable tag: 1.9.6
     6Stable tag: 1.9.7
    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.