Changeset 74

Timestamp:

03/18/2005 07:05:50 PM (21 years ago)

Author:

matt

Message:

Sticky support

Location:

trunk

Files:

• bb-admin/sticky.php (added)
• bb-admin/upgrade-schema.php (modified) (1 diff)
• bb-includes/functions.php (modified) (3 diffs)
• bb-includes/template-functions.php (modified) (1 diff)
• bb-templates/forum.php (modified) (1 diff)
• bb-templates/topic.php (modified) (2 diffs)
• forum.php (modified) (1 diff)

trunk/bb-admin/upgrade-schema.php

@@ -38 +38 @@
   topic_open tinyint(1) NOT NULL default '1',
   topic_last_post_id bigint(20) NOT NULL default '1',
+  topic_sticky tinyint(1) NOT NULL default '0',
   topic_posts bigint(20) NOT NULL default '0',
   PRIMARY KEY  (topic_id),

trunk/bb-includes/functions.php

@@ -50 +50 @@
         $limit = ($limit * $page) . ", $limit";
     return $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE topic_status = 0 $where ORDER BY topic_time DESC LIMIT $limit");
+}
+
+function get_sticky_topics( $forum = 0, $page = 0 ) {
+    global $bbdb, $bb;
+    $where = '';
+    if ( $forum )
+        $where = "AND forum_id = $forum";
+    return $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE topic_status = 0 AND topic_sticky = '1' $where ORDER BY topic_time DESC");
 }
 
@@ -419 +427 @@
 }
 
+function bb_stick_topic ( $topic_id ) {
+    global $bbdb;
+    bb_do_action('stick_topic', $topic_id);
+    return $bbdb->query("UPDATE $bbdb->topics SET topic_sticky = '1' WHERE topic_id = $topic_id");
+}
+
+function bb_unstick_topic ( $topic_id ) {
+    global $bbdb;
+    bb_do_action('unstick_topic', $topic_id);
+    return $bbdb->query("UPDATE $bbdb->topics SET topic_sticky = '0' WHERE topic_id = $topic_id");
+}
+
 function bb_update_post( $post, $post_id ) {
     global $bbdb, $current_user;
@@ -507 +527 @@
     $topic = get_topic( $topic_id );
     if ( 1 == $topic->topic_open )
+        return true;
+    else
+        return false;
+}
+
+function topic_is_sticky ( $topic_id ) {
+    $topic = get_topic( $topic_id );
+    if ( 1 == $topic->topic_sticky )
         return true;
     else

trunk/bb-includes/template-functions.php

@@ -369 +369 @@
     }
 }
+
+function topic_sticky_link() {
+    global $current_user;
+    if ( $current_user->user_type > 1 ) {
+        if ( topic_is_sticky( get_topic_id() ) )
+            $text = 'Unstick topic';
+        else
+            $text = 'Stick topic';
+        echo "<a href='" . bb_get_option('uri') . 'bb-admin/sticky.php?id=' . get_topic_id() . "'>$text</a>";
+    }
+}
+
 
 function post_author_id() {

trunk/bb-templates/forum.php

@@ -19 +19 @@
 </tr>
 
+<?php if ( $stickies) : foreach ( $stickies as $topic ) : ?>
+<tr<?php alt_class('topic'); ?>>
+    <td>Sticky: <a href="<?php topic_link(); ?>"><?php topic_title(); ?></a></td>
+    <td class="num"><?php topic_posts(); ?></td>
+    <td class="num"><?php topic_last_poster(); ?></td>
+    <td class="num"><small><?php topic_time(); ?></small></td>
+</tr>
+<?php endforeach; endif; ?>
 
 <?php foreach ( $topics as $topic ) : ?>

trunk/bb-templates/topic.php

@@ -5 +5 @@
 <h3><a href="<?php option('uri'); ?>"><?php option('name'); ?></a> &raquo; <a href="<?php forum_link(); ?>"><?php forum_name(); ?></a></h3>
 <h2><?php topic_title(); ?></h2>
+<?php bb_do_action('under_title', ''); ?>
 <?php if ($posts) : ?>
 <div class="nav">
@@ -41 +42 @@
 <?php endif; ?>
 <div class="admin">
-<?php topic_delete_link(); ?> <?php topic_close_link(); ?>
+<?php topic_delete_link(); ?> <?php topic_close_link(); ?> <?php topic_sticky_link(); ?>
 </div>
 <?php get_footer(); ?>

trunk/forum.php

@@ -15 +15 @@
     die('Forum not found.');
 
-$topics = get_latest_topics( $forum_id, $page );
+$topics   = get_latest_topics( $forum_id, $page );
+$stickies = get_sticky_topics( $forum_id );
 
 include('bb-templates/forum.php');