Changeset 5110 for trunk/wp-admin/admin-functions.php

Timestamp:

03/26/2007 07:28:29 AM (19 years ago)

Author:

matt

Message:

A backend interface for tagging.

File:

• trunk/wp-admin/admin-functions.php (modified) (4 diffs)

trunk/wp-admin/admin-functions.php

@@ -648 +648 @@
 function return_categories_list( $parent = 0 ) {
     global $wpdb;
-    return $wpdb->get_col( "SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent AND ( link_count = 0 OR category_count != 0 OR ( link_count = 0 AND category_count = 0 ) ) ORDER BY category_count DESC" );
+    return $wpdb->get_col( "SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent AND ( ( link_count = 0 AND tag_count = 0 ) OR category_count != 0 OR ( link_count = 0 AND category_count = 0 AND tag_count = 0 ) ) ORDER BY category_count DESC" );
 }
 
@@ -658 +658 @@
 }
 
+function get_tags_to_edit( $post_id ) {
+    global $wpdb;
+
+    $post_id = (int) $post_id;
+    if ( !$post_id )
+        return false;
+
+    $tags = $wpdb->get_results( "
+             SELECT category_id, cat_name
+             FROM $wpdb->categories, $wpdb->post2cat
+             WHERE $wpdb->post2cat.category_id = cat_ID AND $wpdb->post2cat.post_id = '$post_id' AND rel_type = 'tag'
+             " );
+    if ( !$tags )
+        return false;
+
+    foreach ( $tags as $tag )
+        $tag_names[] = $tag->cat_name;
+    $tags_to_edit = join( ', ', $tag_names );
+    $tags_to_edit = attribute_escape( $tags_to_edit );
+    $tags_to_edit = apply_filters( 'tags_to_edit', $tags_to_edit );
+    return $tags_to_edit;
+}
+
 function get_nested_categories( $default = 0, $parent = 0 ) {
     global $post_ID, $link_id, $mode, $wpdb;
@@ -665 +688 @@
              SELECT category_id
              FROM $wpdb->categories, $wpdb->post2cat
-             WHERE $wpdb->post2cat.category_id = cat_ID AND $wpdb->post2cat.post_id = '$post_ID'
+             WHERE $wpdb->post2cat.category_id = cat_ID AND $wpdb->post2cat.post_id = '$post_ID' AND rel_type = 'category'
              " );
 
@@ -722 +745 @@
 function return_link_categories_list( $parent = 0 ) {
     global $wpdb;
-    return $wpdb->get_col( "SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent AND ( category_count = 0  OR link_count != 0 OR ( link_count = 0 AND category_count = 0 ) ) ORDER BY link_count DESC" );
+    return $wpdb->get_col( "SELECT cat_ID FROM $wpdb->categories WHERE category_parent = $parent AND ( ( category_count = 0 AND tag_count = 0 ) OR link_count != 0 OR ( link_count = 0 AND category_count = 0 AND tag_count = 0 ) ) ORDER BY link_count DESC" );
 }