Plugin Directory

Changeset 1965327


Ignore:
Timestamp:
10/29/2018 06:58:22 PM (7 years ago)
Author:
colorlibplugins
Message:

Update to 2.3.4

Location:
simple-custom-post-order
Files:
23 added
2 edited

Legend:

Unmodified
Added
Removed
  • simple-custom-post-order/trunk/settings.php

    r1616546 r1965327  
    66
    77<div class="wrap">
    8     <?php screen_icon('plugins'); ?>
    98    <h2><?php _e('Simple Custom Post Order Settings', 'scporder'); ?></h2>
    109    <?php if (isset($_GET['msg'])) : ?>
     
    2524                <tbody>
    2625                    <tr valign="top">
    27                         <th scope="row"><?php _e('Check to Sort Post Types', 'scporder') ?></th> 
     26                        <th scope="row"><?php _e('Check to Sort Post Types', 'scporder') ?></th>
    2827                        <td>
    2928                            <label><input type="checkbox" id="scporder_allcheck_objects"> <?php _e('Check All', 'scporder') ?></label><br>
     
    6059                <tbody>
    6160                    <tr valign="top">
    62                         <th scope="row"><?php _e('Check to Sort Taxonomies', 'scporder') ?></th> 
     61                        <th scope="row"><?php _e('Check to Sort Taxonomies', 'scporder') ?></th>
    6362                        <td>
    6463                            <label><input type="checkbox" id="scporder_allcheck_tags"> <?php _e('Check All', 'scporder') ?></label><br>
     
    8786            </table>
    8887
    89         </div> 
     88        </div>
    9089        <p class="submit">
    9190            <input type="submit" class="button-primary" name="scporder_submit" value="<?php _e('Update', 'scporder'); ?>">
  • simple-custom-post-order/trunk/simple-custom-post-order.php

    r1960607 r1965327  
    55  Plugin URI: https://wordpress.org/plugins-wp/simple-custom-post-order/
    66  Description: Order Items (Posts, Pages, and Custom Post Types) using a Drag and Drop Sortable JavaScript.
    7   Version: 2.3.3
     7  Version: 2.3.4
    88  Author: Colorlib
    99  Author URI: https://colorlib.com/wp/
     
    1313define('SCPORDER_URL', plugins_url('', __FILE__));
    1414define('SCPORDER_DIR', plugin_dir_path(__FILE__));
    15  
     15
    1616$scporder = new SCPO_Engine();
    1717
     
    110110            foreach ($objects as $object) {
    111111                $result = $wpdb->get_results("
    112                     SELECT count(*) as cnt, max(menu_order) as max, min(menu_order) as min 
    113                     FROM $wpdb->posts 
     112                    SELECT count(*) as cnt, max(menu_order) as max, min(menu_order) as min
     113                    FROM $wpdb->posts
    114114                    WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
    115115                ");
     
    118118
    119119                $results = $wpdb->get_results("
    120                     SELECT ID 
    121                     FROM $wpdb->posts 
    122                     WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future') 
     120                    SELECT ID
     121                    FROM $wpdb->posts
     122                    WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
    123123                    ORDER BY menu_order ASC
    124124                ");
     
    132132            foreach ($tags as $taxonomy) {
    133133                $result = $wpdb->get_results("
    134                     SELECT count(*) as cnt, max(term_order) as max, min(term_order) as min 
    135                     FROM $wpdb->terms AS terms 
    136                     INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id ) 
     134                    SELECT count(*) as cnt, max(term_order) as max, min(term_order) as min
     135                    FROM $wpdb->terms AS terms
     136                    INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id )
    137137                    WHERE term_taxonomy.taxonomy = '" . $taxonomy . "'
    138138                ");
     
    141141
    142142                $results = $wpdb->get_results("
    143                     SELECT terms.term_id 
    144                     FROM $wpdb->terms AS terms 
    145                     INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id ) 
    146                     WHERE term_taxonomy.taxonomy = '" . $taxonomy . "' 
     143                    SELECT terms.term_id
     144                    FROM $wpdb->terms AS terms
     145                    INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id )
     146                    WHERE term_taxonomy.taxonomy = '" . $taxonomy . "'
    147147                    ORDER BY term_order ASC
    148148                ");
     
    237237            foreach ($objects as $object) {
    238238                $result = $wpdb->get_results("
    239                     SELECT count(*) as cnt, max(menu_order) as max, min(menu_order) as min 
    240                     FROM $wpdb->posts 
     239                    SELECT count(*) as cnt, max(menu_order) as max, min(menu_order) as min
     240                    FROM $wpdb->posts
    241241                    WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
    242242                ");
     
    246246                if ($object == 'page') {
    247247                    $results = $wpdb->get_results("
    248                         SELECT ID 
    249                         FROM $wpdb->posts 
    250                         WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future') 
     248                        SELECT ID
     249                        FROM $wpdb->posts
     250                        WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
    251251                        ORDER BY post_title ASC
    252252                    ");
    253253                } else {
    254254                    $results = $wpdb->get_results("
    255                         SELECT ID 
    256                         FROM $wpdb->posts 
    257                         WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future') 
     255                        SELECT ID
     256                        FROM $wpdb->posts
     257                        WHERE post_type = '" . $object . "' AND post_status IN ('publish', 'pending', 'draft', 'private', 'future')
    258258                        ORDER BY post_date DESC
    259259                    ");
     
    268268            foreach ($tags as $taxonomy) {
    269269                $result = $wpdb->get_results("
    270                     SELECT count(*) as cnt, max(term_order) as max, min(term_order) as min 
    271                     FROM $wpdb->terms AS terms 
    272                     INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id ) 
     270                    SELECT count(*) as cnt, max(term_order) as max, min(term_order) as min
     271                    FROM $wpdb->terms AS terms
     272                    INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id )
    273273                    WHERE term_taxonomy.taxonomy = '" . $taxonomy . "'
    274274                ");
     
    277277
    278278                $results = $wpdb->get_results("
    279                     SELECT terms.term_id 
    280                     FROM $wpdb->terms AS terms 
    281                     INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id ) 
    282                     WHERE term_taxonomy.taxonomy = '" . $taxonomy . "' 
     279                    SELECT terms.term_id
     280                    FROM $wpdb->terms AS terms
     281                    INNER JOIN $wpdb->term_taxonomy AS term_taxonomy ON ( terms.term_id = term_taxonomy.term_id )
     282                    WHERE term_taxonomy.taxonomy = '" . $taxonomy . "'
    283283                    ORDER BY name ASC
    284284                ");
Note: See TracChangeset for help on using the changeset viewer.