Changeset 1922 for trunk/bb-includes/functions.bb-topic-tags.php

Timestamp:

01/20/2009 02:09:24 AM (18 years ago)

Author:

sambauers

Message:

Move some functions into more logical locations.

File:

• trunk/bb-includes/functions.bb-topic-tags.php (modified) (1 diff)

trunk/bb-includes/functions.bb-topic-tags.php

@@ -381 +381 @@
         }
 }
+
+
+
+
+
+
+// TODO
+function bb_related_tags( $_tag = false, $number = 40 ) {
+        return array();
+
+        global $bbdb, $tag;
+        if ( false === $_tag )
+                $_tag = $tag;
+        else
+                $_tag = bb_get_tag( $_tag );
+
+        if ( !$_tag )
+                return false;
+
+        $number = (int) $number;
+
+        $sql = $bbdb->prepare(
+                "SELECT tag.tag_id, tag.tag, tag.raw_tag, COUNT(DISTINCT t.topic_id) AS tag_count
+                   FROM $bbdb->tagged AS t
+                   JOIN $bbdb->tagged AS tt  ON (t.topic_id = tt.topic_id)
+                   JOIN $bbdb->tags   AS tag ON (t.tag_id = tag.tag_id)
+                WHERE tt.tag_id = %d AND t.tag_id != %d GROUP BY t.tag_id ORDER BY tag_count DESC LIMIT %d",
+                $_tag->tag_id, $_tag->tag_id, $number
+        );
+
+        foreach ( (array) $tags = $bbdb->get_results( $sql ) as $_tag ) {
+                wp_cache_add( $tag->tag, $tag, 'bb_tag' );
+                wp_cache_add( $tag->tag_id, $tag->tag, 'bb_tag_id' );
+        }
+
+        return $tags;
+}
+