forum.module 26.3 KB
Newer Older
Dries Buytaert's avatar
   
Dries Buytaert committed
1
2
3
<?php
// $Id$

Dries Buytaert's avatar
   
Dries Buytaert committed
4
5
6
7
8
/**
 * @file
 * Enable threaded discussions about general topics.
 */

9
10
11
12
/**
 * Implementation of hook_help().
 */
function forum_help($section) {
Dries Buytaert's avatar
   
Dries Buytaert committed
13
14
  switch ($section) {
    case 'admin/help#forum':
15
      return t("
Dries Buytaert's avatar
   
Dries Buytaert committed
16
      <h3>Creating a forum</h3>
17
      <p>The forum module uses taxonomy to organize itself. To create a forum you first have to create a <a href=\"%taxonomy\">taxonomy vocabulary</a>. When doing this, choose a sensible name for it (such as \"fora\") and make sure under \"Types\" that \"forum\" is selected. Once you have done this, <a href=\"%taxo-terms\">add some terms</a> to it. Each term will become a forum. If you fill in the description field, users will be given additional information about the forum on the main forum page. For example: \"troubleshooting\" - \"Please ask your questions here.\"</p>
18
      <p>When you are happy with your vocabulary, go to <a href=\"%forums\">administer &raquo; settings &raquo; forum</a> and set <strong>Forum vocabulary</strong> to the one you have just created. There will now be fora active on the site. For users to access them they must have the \"access content\" <a href=\"%permission\">permission</a> and to create a topic they must have the \"create forum topics\" <a href=\"%permission\">permission</a>. These permissions can be set in the <a href=\"%permission\">permission</a> pages.</p>
Dries Buytaert's avatar
   
Dries Buytaert committed
19
      <h4>Icons</h4>
20
      <p>To disable icons, set the icon path as blank in <a href=\"%forums\">administer &raquo; settings &raquo; forum</a>.</p>
21
      <p>All files in the icon directory are assumed to be images. You may use images of whatever size you wish, but it is recommended to use 15x15 or 16x16.</p>", array("%taxonomy" => url('admin/taxonomy/add/vocabulary'), '%taxo-terms' => url('admin/taxonomy'), '%forums' => url('admin/settings/forum'), '%permission' => url('admin/user/configure/permission')));
Dries Buytaert's avatar
   
Dries Buytaert committed
22
    case 'admin/modules#description':
23
      return t('Enable threaded discussions about general topics.');
Dries Buytaert's avatar
   
Dries Buytaert committed
24
    case 'admin/settings/forum':
25
      return t("<p>Forums are threaded discussions based on the taxonomy system.  For the forums to work, the taxonomy module has to be installed and enabled.  When activated, a taxonomy vocabulary (eg. \"forums\") needs to be <a href=\"%created\">created</a> and bound to the node type \"forum topic\".</p>", array('%created' => url('admin/taxonomy/add/vocabulary')));
Dries Buytaert's avatar
   
Dries Buytaert committed
26
    case 'node/add#forum':
27
      return t('A forum is a threaded discussion, enabling users to communicate about a particular topic.');
Dries Buytaert's avatar
   
Dries Buytaert committed
28
29
30
  }
}

31
32
33
/**
 * Implementation of hook_node_name().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
34
function forum_node_name($node) {
Dries Buytaert's avatar
   
Dries Buytaert committed
35
  return t('forum topic');
Dries Buytaert's avatar
   
Dries Buytaert committed
36
37
}

38
39
40
/**
 * Implementation of hook_access().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
41
function forum_access($op, $node) {
Dries Buytaert's avatar
   
Dries Buytaert committed
42
43
  global $user;

Dries Buytaert's avatar
   
Dries Buytaert committed
44
45
  if ($op == 'create') {
    return user_access('create forum topics');
Dries Buytaert's avatar
   
Dries Buytaert committed
46
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
47
48
49
50
51
52

  if ($op == 'update' || $op == 'delete') {
    if (user_access('edit own forum topics') && ($user->uid == $node->uid)) {
      return TRUE;
    }
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
53
54
}

55
56
57
/**
 * Implementation of hook_perm().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
58
function forum_perm() {
Dries Buytaert's avatar
   
Dries Buytaert committed
59
  return array('create forum topics', 'edit own forum topics');
Dries Buytaert's avatar
   
Dries Buytaert committed
60
}
Dries Buytaert's avatar
   
Dries Buytaert committed
61

62
63
64
/**
 * Implementation of hook_settings().
 */
65
function forum_settings() {
Dries Buytaert's avatar
   
Dries Buytaert committed
66

Dries Buytaert's avatar
   
Dries Buytaert committed
67
68
69
  if (module_exist('taxonomy')) {
    $vocs[0] = '<'. t('none') .'>';
    foreach (taxonomy_get_vocabularies('forum') as $vid => $voc) {
Dries Buytaert's avatar
   
Dries Buytaert committed
70
71
72
      $vocs[$vid] = $voc->name;
    }

Dries Buytaert's avatar
   
Dries Buytaert committed
73
    if ($voc) {
74
      $group  = form_select(t('Forum vocabulary'), 'forum_nav_vocabulary', variable_get('forum_nav_vocabulary', ''), $vocs, t("The taxonomy vocabulary that will be used as the navigation tree.  The vocabulary's terms define the forums."));
75
      $group .= _taxonomy_term_select(t('Containers'), 'forum_containers', variable_get('forum_containers', array()), variable_get('forum_nav_vocabulary', ''), t('You can choose forums which will not have topics, but will be just containers for other forums.  This lets you both group and nest forums.'), 1, '<'. t('none') .'>');
Dries Buytaert's avatar
   
Dries Buytaert committed
76
      $output = form_group(t('Forum structure settings'), $group);
77

78
      $group .= form_textfield(t('Forum icon path'), 'forum_icon_path', variable_get('forum_icon_path', ''), 30, 255, t('The path to the forum icons.  Leave blank to disable icons.  Don\'t add a trailing slash.  Default icons are available in the "misc" directory.'));
79
80
81
      $group .= form_select(t('Hot topic threshold'), 'forum_hot_topic', variable_get('forum_hot_topic', 15), drupal_map_assoc(array(5, 10, 15, 20, 25, 30, 35, 40, 50, 60, 80, 100, 10000)), t('The number of posts a topic must have to be considered <strong>hot</strong>.'));
      $group .= form_select(t('Topics per page'), 'forum_per_page', variable_get('forum_per_page', 25), drupal_map_assoc(array(10, 25, 50, 75, 100)), t('The default number of topics displayed per page; links to browse older messages are automatically being displayed.'));
      $group .= form_radios(t('Default order'), 'forum_order', variable_get('forum_order', '1'), array(1 => t('Date - newest first'), 2 => t('Date - oldest first'), 3 => t('Posts - most active first'), 4=> t('Posts - least active first')), t('The default display order for topics.'));
Dries Buytaert's avatar
   
Dries Buytaert committed
82
      $output .= form_group(t('Forum viewing options'), $group);
Dries Buytaert's avatar
   
Dries Buytaert committed
83
84
    }
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
85

Dries Buytaert's avatar
   
Dries Buytaert committed
86
87
88
  return $output;
}

89
90
91
/**
 * Implementation of hook_taxonomy().
 */
Dries Buytaert's avatar
Dries Buytaert committed
92
function forum_taxonomy($op, $type, $object) {
Dries Buytaert's avatar
   
Dries Buytaert committed
93
94
  if ($type == 'vocabulary' && ($op == 'insert' || $op == 'update')) {
    if (variable_get('forum_nav_vocabulary', '') == '' && in_array('forum', $object['nodes'])) {
Dries Buytaert's avatar
Dries Buytaert committed
95
      // since none is already set, silently set this vocabulary as the navigation vocabulary
Dries Buytaert's avatar
   
Dries Buytaert committed
96
      variable_set('forum_nav_vocabulary', $object['vid']);
Dries Buytaert's avatar
Dries Buytaert committed
97
98
99
100
    }
  }
}

101
102
103
/**
 * Implementation of hook_load().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
104
function forum_load($node) {
Dries Buytaert's avatar
   
Dries Buytaert committed
105
  $forum = db_fetch_object(db_query('SELECT * FROM {forum} WHERE nid = %d', $node->nid));
Dries Buytaert's avatar
   
Dries Buytaert committed
106
107
108
109

  return $forum;
}

110
111
112
113
114
115
/**
 * Implementation of hook_block().
 *
 * Generates a block containing the currently active forum topics and the
 * most recently added forum topics.
 */
116
117
118
119
120
function forum_block($op = 'list', $delta = 0, $edit = array()) {
  switch ($op) {
    case 'list':
      $blocks[0]['info'] = t('Forum topics');
      return $blocks;
Dries Buytaert's avatar
   
Dries Buytaert committed
121

122
123
124
    case 'configure':
      $output = form_select(t('Number of topics in block'), 'forum_block_num', variable_get('forum_block_num', '5'), drupal_map_assoc(array(2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)));
      return $output;
Dries Buytaert's avatar
   
Dries Buytaert committed
125

126
127
128
    case 'save':
      variable_set('forum_block_num', $edit['forum_block_num']);
      break;
Dries Buytaert's avatar
   
Dries Buytaert committed
129

130
131
    case 'view':
      if (user_access('access content')) {
Dries Buytaert's avatar
   
Dries Buytaert committed
132
133
134
        $sql = "SELECT n.nid, n.title, l.last_comment_timestamp, l.comment_count FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.status = 1 AND n.type='forum' ORDER BY l.last_comment_timestamp DESC";
        $sql = node_rewrite_sql($sql);
        $content  = node_title_list(db_query_range($sql, 0, variable_get('forum_block_num', '5')), t('Active forum topics:'));
Dries Buytaert's avatar
   
Dries Buytaert committed
135

Dries Buytaert's avatar
   
Dries Buytaert committed
136
137
138
        $sql = "SELECT n.nid, n.title, l.comment_count FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid WHERE n.type = 'forum' AND n.status = 1 ORDER BY n.nid DESC";
        $sql = node_rewrite_sql($sql);
        $content .= node_title_list(db_query_range($sql, 0, variable_get('forum_block_num', '5')), t('New forum topics:'));
Dries Buytaert's avatar
   
Dries Buytaert committed
139

140
141
142
143
144
145
146
147
148
149
        if ($content) {
          $content .= '<div class="more-link">'. l(t('more'), 'forum', array('title' => t('Read the latest forum topics.'))) .'</div>';
        }

        $block['subject'] = t('Forum topics');
        $block['content'] = $content;

        return $block;
      }
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
150
151
}

Dries Buytaert's avatar
   
Dries Buytaert committed
152
153
154
/**
 * Implementation of hook_link().
 */
155
function forum_link($type, $node = 0, $main = 0) {
Dries Buytaert's avatar
Dries Buytaert committed
156
  global $user;
Dries Buytaert's avatar
   
Dries Buytaert committed
157

Dries Buytaert's avatar
   
Dries Buytaert committed
158
159
  $links = array();

Dries Buytaert's avatar
   
Dries Buytaert committed
160
  if (!$main && $type == 'node' && $node->type == 'forum') {
Dries Buytaert's avatar
   
Dries Buytaert committed
161
162
    // get previous and next topic

Steven Wittens's avatar
Steven Wittens committed
163
    $sql = "SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.status = 1 AND n.type = 'forum' ORDER BY n.sticky DESC, ". _forum_get_topic_order_sql(variable_get('forum_order', 1));
Dries Buytaert's avatar
   
Dries Buytaert committed
164
165
    $sql = node_rewrite_sql($sql);
    $result = db_query($sql, $node->tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
166
167
168

    while ($topic = db_fetch_object($result)) {
      if ($stop == 1) {
169
        $next = new StdClass();
Dries Buytaert's avatar
   
Dries Buytaert committed
170
171
172
173
174
175
176
177
        $next->nid = $topic->nid;
        $next->title = $topic->title;
        break;
      }
      if ($topic->nid == $node->nid) {
        $stop = 1;
      }
      else {
178
        $prev = new StdClass();
Dries Buytaert's avatar
   
Dries Buytaert committed
179
180
181
182
183
184
        $prev->nid = $topic->nid;
        $prev->title = $topic->title;
      }
    }

    if ($prev) {
Dries Buytaert's avatar
   
Dries Buytaert committed
185
      $links[] = l(t('previous forum topic'), "node/$prev->nid", array('title' => $prev->title));
Dries Buytaert's avatar
   
Dries Buytaert committed
186
187
188
    }

    if ($next) {
Dries Buytaert's avatar
   
Dries Buytaert committed
189
      $links[] = l(t('next forum topic'), "node/$next->nid", array('title' => $next->title));
Dries Buytaert's avatar
   
Dries Buytaert committed
190
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
191
192
  }

Dries Buytaert's avatar
   
Dries Buytaert committed
193
  return $links;
Dries Buytaert's avatar
   
Dries Buytaert committed
194
195
}

Dries Buytaert's avatar
   
Dries Buytaert committed
196
197
198
/**
 * Implementation of hook_menu().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
199
function forum_menu($may_cache) {
Dries Buytaert's avatar
   
Dries Buytaert committed
200
201
  $items = array();

Dries Buytaert's avatar
   
Dries Buytaert committed
202
203
204
205
206
207
  if ($may_cache) {
    $items[] = array('path' => 'node/add/forum', 'title' => t('forum topic'),
      'access' => user_access('create forum topics'));
    $items[] = array('path' => 'forum', 'title' => t('forums'),
      'callback' => 'forum_page',
      'access' => user_access('access content'),
208
      'type' => MENU_SUGGESTED_ITEM);
Dries Buytaert's avatar
   
Dries Buytaert committed
209
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
210
211
212
213

  return $items;
}

214
215
216
/**
 * Implementation of hook_view().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
217
function forum_view(&$node, $teaser = FALSE, $page = FALSE) {
Dries Buytaert's avatar
   
Dries Buytaert committed
218

Dries Buytaert's avatar
   
Dries Buytaert committed
219
  if ($page) {
Dries Buytaert's avatar
   
Dries Buytaert committed
220
    $vocabulary = taxonomy_get_vocabulary(variable_get('forum_nav_vocabulary', ''));
Dries Buytaert's avatar
   
Dries Buytaert committed
221
    // Breadcrumb navigation
Dries Buytaert's avatar
   
Dries Buytaert committed
222
223
    $breadcrumb = array();
    $breadcrumb[] = array('path' => 'forum', 'title' => $vocabulary->name);
Dries Buytaert's avatar
   
Dries Buytaert committed
224
    if ($parents = taxonomy_get_parents_all($node->tid)) {
Dries Buytaert's avatar
   
Dries Buytaert committed
225
226
      $parents = array_reverse($parents);
      foreach ($parents as $p) {
Dries Buytaert's avatar
   
Dries Buytaert committed
227
        $breadcrumb[] = array('path' => 'forum/'. $p->tid, 'title' => $p->name);
Dries Buytaert's avatar
   
Dries Buytaert committed
228
229
      }
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
230
231
    $breadcrumb[] = array('path' => 'node/'. $node->nid);
    menu_set_location($breadcrumb);
232
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
233

234
  $node = node_prepare($node, $teaser);
Dries Buytaert's avatar
   
Dries Buytaert committed
235
236
}

237
238
239
240
241
242
/**
 * Implementation of hook_validate().
 *
 * Check in particular that only a "leaf" term in the associated taxonomy
 * vocabulary is selected, not a "container" term.
 */
243
244
function forum_validate(&$node) {
  // Make sure all fields are set properly:
Dries Buytaert's avatar
   
Dries Buytaert committed
245
  $node->icon = $node->icon ? $node->icon : '';
Dries Buytaert's avatar
   
Dries Buytaert committed
246
247
248

  if ($node->taxonomy) {
    // Extract the node's proper topic ID.
Dries Buytaert's avatar
   
Dries Buytaert committed
249
    $vocabulary = variable_get('forum_nav_vocabulary', '');
250
    $containers = variable_get('forum_containers', array());
Dries Buytaert's avatar
   
Dries Buytaert committed
251
    foreach ($node->taxonomy as $term) {
Dries Buytaert's avatar
   
Dries Buytaert committed
252
      if (db_result(db_query('SELECT COUNT(*) FROM {term_data} WHERE tid = %d AND vid = %d', $term, $vocabulary))) {
253
254
        if (in_array($term, $containers)) {
          $term = taxonomy_get_term($term);
Dries Buytaert's avatar
   
Dries Buytaert committed
255
          form_set_error('taxonomy', t('The item %forum is only a container for forums. Please select one of the forums below it.', array('%forum' => "<em>$term->name</em>")));
256
257
258
259
        }
        else {
          $node->tid = $term;
        }
Dries Buytaert's avatar
   
Dries Buytaert committed
260
      }
261
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
262
263
264
265
266
267
268
    if ($node->tid && $node->shadow) {
      $terms = array_keys(taxonomy_node_get_terms($node->nid));
      if (!in_array($node->tid, $terms)) {
        $terms[] = $node->tid;
      }
      $node->taxonomy = $terms;
    }
Dries Buytaert's avatar
Dries Buytaert committed
269
270
271
  }
}

Dries Buytaert's avatar
   
Dries Buytaert committed
272
273
274
275
276
277
278
/**
 * Implementation of hook_update().
 */
function forum_update($node) {
  db_query('UPDATE {forum} SET tid = %d WHERE nid = %d', $node->tid, $node->nid);
}

279
280
281
/**
 * Implementation of hook_form().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
282
function forum_form(&$node) {
Dries Buytaert's avatar
   
Dries Buytaert committed
283
  if (!$node->nid) {
Dries Buytaert's avatar
Dries Buytaert committed
284
    // new topic
Dries Buytaert's avatar
   
Dries Buytaert committed
285
    $node->taxonomy[] = arg(3);
286
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
287
288
289
  else {
    $node->taxonomy = array($node->tid);
  }
290

Dries Buytaert's avatar
   
Dries Buytaert committed
291
  $output = implode('', taxonomy_node_form('forum', $node));
Dries Buytaert's avatar
Dries Buytaert committed
292
293
294

  if ($node->nid) {
    // if editing, give option to leave shadows
Dries Buytaert's avatar
   
Dries Buytaert committed
295
296
    $shadow = (count(taxonomy_node_get_terms($node->nid)) > 1);
    $output .= form_checkbox(t('Leave shadow copy'), 'shadow', 1, $shadow, t('If you move this topic, you can leave a link in the old forum to the new forum.'));
Dries Buytaert's avatar
Dries Buytaert committed
297
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
298

299
  $output .= form_textarea(t('Body'), 'body', $node->body, 60, 20, '');
300
  $output .= filter_form('format', $node->format);
Dries Buytaert's avatar
   
Dries Buytaert committed
301
302
303
304

  return $output;
}

305
306
307
/**
 * Implementation of hook_insert().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
308
function forum_insert($node) {
Dries Buytaert's avatar
   
Dries Buytaert committed
309
  db_query('INSERT INTO {forum} (nid, tid) VALUES (%d, %d)', $node->nid, $node->tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
310
311
}

312
313
314
/**
 * Implementation of hook_delete().
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
315
function forum_delete(&$node) {
Dries Buytaert's avatar
   
Dries Buytaert committed
316
  db_query('DELETE FROM {forum} WHERE nid = %d', $node->nid);
Dries Buytaert's avatar
   
Dries Buytaert committed
317
}
Dries Buytaert's avatar
   
Dries Buytaert committed
318

Dries Buytaert's avatar
   
Dries Buytaert committed
319
320
321
/**
 * Formats a topic for display
 *
322
 * @TODO Give a better description. Not sure where this function is used yet.
Dries Buytaert's avatar
   
Dries Buytaert committed
323
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
324
function _forum_format($topic) {
325
  if ($topic && $topic->timestamp) {
Dries Buytaert's avatar
   
Dries Buytaert committed
326
    return t('%time ago<br />by %author', array('%time' => format_interval(time() - $topic->timestamp), '%author' => format_name($topic)));
Dries Buytaert's avatar
   
Dries Buytaert committed
327
328
329
330
331
332
  }
  else {
    return message_na();
  }
}

Dries Buytaert's avatar
   
Dries Buytaert committed
333
334
335
/**
 * Returns a list of all forums for a given taxonomy id
 *
336
 * Forum objects contain the following fields
Dries Buytaert's avatar
   
Dries Buytaert committed
337
338
339
340
341
342
343
344
345
 * -num_topics Number of topics in the forum
 * -num_posts Total number of posts in all topics
 * -last_post Most recent post for the forum
 *
 * @param $tid
 *   Taxonomy ID of the vocabulary that holds the forum list.
 * @return
 *   Array of object containing the forum information.
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
346
function forum_get_forums($tid = 0) {
347

Dries Buytaert's avatar
   
Dries Buytaert committed
348
349
350
351
  if (!$tid) {
    $tid = 0;
  }

Dries Buytaert's avatar
   
Dries Buytaert committed
352
353
  $forums = array();
  $_forums = taxonomy_get_tree(variable_get('forum_nav_vocabulary', ''), $tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
354

Dries Buytaert's avatar
   
Dries Buytaert committed
355
  if (count($_forums)) {
Dries Buytaert's avatar
   
Dries Buytaert committed
356

Dries Buytaert's avatar
   
Dries Buytaert committed
357
358
    $counts = array();

Dries Buytaert's avatar
   
Dries Buytaert committed
359
360
361
    $sql = "SELECT r.tid, COUNT(n.nid) AS topic_count, SUM(l.comment_count) AS comment_count FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid INNER JOIN {term_node} r ON n.nid = r.nid WHERE n.status = 1 AND n.type = 'forum' GROUP BY r.tid";
    $sql = node_rewrite_sql($sql);
    $_counts = db_query($sql, $forum->tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
362
363
364
    while ($count = db_fetch_object($_counts)) {
      $counts[$count->tid] = $count;
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
365
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
366

Dries Buytaert's avatar
   
Dries Buytaert committed
367
368
369
370
  foreach ($_forums as $forum) {
    if (in_array($forum->tid, variable_get('forum_containers', array()))) {
      $forum->container = 1;
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
371

Dries Buytaert's avatar
   
Dries Buytaert committed
372
373
374
375
376
377
378
379
380
381
382
    if ($counts[$forum->tid]) {
      $forum->num_topics = $counts[$forum->tid]->topic_count;
      $forum->num_posts = $counts[$forum->tid]->topic_count + $counts[$forum->tid]->comment_count;
    }
    else {
      $forum->num_topics = 0;
      $forum->num_posts = 0;
    }

    // This query does not use full ANSI syntax since MySQL 3.x does not support
    // table1 INNER JOIN table2 INNER JOIN table3 ON table2_criteria ON table3_criteria
Dries Buytaert's avatar
   
Dries Buytaert committed
383
    // used to join node_comment_statistics to users.
Dries Buytaert's avatar
   
Dries Buytaert committed
384
385
386
    $sql = "SELECT n.nid, l.last_comment_timestamp, IF(l.last_comment_uid, cu.name, l.last_comment_name) as last_comment_name, l.last_comment_uid FROM {node} n, {node_comment_statistics} l /*! USE INDEX (node_comment_timestamp) */, {users} cu, {term_node} r WHERE  n.nid = r.nid AND r.tid = %d AND n.status = 1 AND n.type = 'forum' AND l.last_comment_uid = cu.uid AND n.nid = l.nid ORDER BY l.last_comment_timestamp DESC";
    $sql = node_rewrite_sql($sql);
    $topic = db_fetch_object(db_query_range($sql, $forum->tid, 0, 1));
387
388

    $last_post = new StdClass();
Dries Buytaert's avatar
   
Dries Buytaert committed
389
390
391
392
    $last_post->timestamp = $topic->last_comment_timestamp;
    $last_post->name = $topic->last_comment_name;
    $last_post->uid = $topic->last_comment_uid;
    $forum->last_post = $last_post;
Dries Buytaert's avatar
   
Dries Buytaert committed
393

Dries Buytaert's avatar
   
Dries Buytaert committed
394
395
396
397
    $forums[$forum->tid] = $forum;
  }

  return $forums;
Dries Buytaert's avatar
   
Dries Buytaert committed
398
399
}

400
401
402
403
function _forum_topics_read($term, $uid) {
  // Calculate the number of topics the user has read. Assume all entries older
  // than NODE_NEW_LIMIT are read, and include the recent posts that user has
  // read.
Dries Buytaert's avatar
   
Dries Buytaert committed
404
405
406
407
408
409
  $sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.created <= %d AND n.status = 1 AND n.type = 'forum'";
  $sql = node_rewrite_sql($sql);
  $ancient = db_result(db_query($sql, $term, NODE_NEW_LIMIT));
  $sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {history} h ON n.nid = h.nid AND h.uid = %d INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.status = 1 AND n.type = 'forum' AND n.created > %d";
  $sql = node_rewrite_sql($sql);
  $recent = db_result(db_query($sql, $uid, $term, NODE_NEW_LIMIT));
Dries Buytaert's avatar
   
Dries Buytaert committed
410

411
  return $ancient + $recent;
Dries Buytaert's avatar
   
Dries Buytaert committed
412
413
}

Dries Buytaert's avatar
Dries Buytaert committed
414
function forum_get_topics($tid, $sortby, $forum_per_page) {
Dries Buytaert's avatar
   
Dries Buytaert committed
415
  global $user, $forum_topic_list_header;
Dries Buytaert's avatar
   
Dries Buytaert committed
416

Dries Buytaert's avatar
   
Dries Buytaert committed
417
  $forum_topic_list_header = array(
Dries Buytaert's avatar
   
Dries Buytaert committed
418
419
    array('data' => '&nbsp;'),
    array('data' => t('Topic'), 'field' => 'n.title'),
Dries Buytaert's avatar
   
Dries Buytaert committed
420
    array('data' => t('Replies'), 'field' => 'l.comment_count'),
Dries Buytaert's avatar
   
Dries Buytaert committed
421
    array('data' => t('Created'), 'field' => 'n.created'),
Dries Buytaert's avatar
   
Dries Buytaert committed
422
    array('data' => t('Last reply'), 'field' => 'l.last_comment_timestamp'),
Dries Buytaert's avatar
   
Dries Buytaert committed
423
  );
Dries Buytaert's avatar
   
Dries Buytaert committed
424

Dries Buytaert's avatar
   
Dries Buytaert committed
425
  $order = _forum_get_topic_order($sortby);
Dries Buytaert's avatar
   
Dries Buytaert committed
426
  for ($i = 0; $i < count($forum_topic_list_header); $i++) {
Dries Buytaert's avatar
   
Dries Buytaert committed
427
428
    if ($forum_topic_list_header[$i]['field'] == $order['field']) {
      $forum_topic_list_header[$i]['sort'] = $order['sort'];
Dries Buytaert's avatar
   
Dries Buytaert committed
429
430
431
432
    }
  }

  $term = taxonomy_get_term($tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
433

434
  $sql = node_rewrite_sql("SELECT n.nid, f.tid, n.title, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments FROM {node} n, {node_comment_statistics} l, {users} cu, {term_node} r, {users} u, {forum} f WHERE n.status = 1 AND l.last_comment_uid = cu.uid AND n.nid = l.nid AND n.nid = r.nid AND r.tid = %d AND n.uid = u.uid AND n.nid = f.nid");
Dries Buytaert's avatar
   
Dries Buytaert committed
435
  $sql .= tablesort_sql($forum_topic_list_header, 'n.sticky DESC,');
Dries Buytaert's avatar
Dries Buytaert committed
436

437
  $sql_count = node_rewrite_sql("SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.status = 1 AND n.type = 'forum'");
Dries Buytaert's avatar
   
Dries Buytaert committed
438

Steven Wittens's avatar
Steven Wittens committed
439
  $result = pager_query($sql, $forum_per_page, 0, $sql_count, $tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
440
441

  while ($topic = db_fetch_object($result)) {
Dries Buytaert's avatar
Dries Buytaert committed
442
443
    if ($user->uid) {
      // folder is new if topic is new or there are new comments since last visit
Dries Buytaert's avatar
   
Dries Buytaert committed
444
      if ($topic->tid != $tid) {
Dries Buytaert's avatar
Dries Buytaert committed
445
        $topic->new = 0;
Dries Buytaert's avatar
   
Dries Buytaert committed
446
447
      }
      else {
Dries Buytaert's avatar
   
Dries Buytaert committed
448
        $history = _forum_user_last_visit($topic->nid);
Dries Buytaert's avatar
   
Dries Buytaert committed
449
        $topic->new_replies = comment_num_new($topic->nid, $history);
450
        $topic->new = $topic->new_replies || ($topic->timestamp > $history);
Dries Buytaert's avatar
   
Dries Buytaert committed
451
      }
452
453
    }
    else {
454
      // Do not track "new replies" status for topics if the user is anonymous.
Dries Buytaert's avatar
Dries Buytaert committed
455
456
      $topic->new_replies = 0;
      $topic->new = 0;
457
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
458

Dries Buytaert's avatar
   
Dries Buytaert committed
459
    if ($topic->num_comments > 0) {
460
      $last_reply = new StdClass();
Dries Buytaert's avatar
   
Dries Buytaert committed
461
462
463
464
465
      $last_reply->timestamp = $topic->last_comment_timestamp;
      $last_reply->name = $topic->last_comment_name;
      $last_reply->uid = $topic->last_comment_uid;
      $topic->last_reply = $last_reply;
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
466
467
468
    $topics[] = $topic;
  }

Dries Buytaert's avatar
Dries Buytaert committed
469
  return $topics;
Dries Buytaert's avatar
   
Dries Buytaert committed
470
471
}

Dries Buytaert's avatar
   
Dries Buytaert committed
472
473
474
/**
 * Finds the first unread node for a given forum.
 */
Dries Buytaert's avatar
Dries Buytaert committed
475
function _forum_new($tid) {
Dries Buytaert's avatar
   
Dries Buytaert committed
476
477
  global $user;

Dries Buytaert's avatar
   
Dries Buytaert committed
478
479
480
  $sql = "SELECT n.nid FROM {node} n LEFT JOIN {history} h ON n.nid = h.nid AND h.uid = %d INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.status = 1 AND n.type = 'forum' AND h.nid IS NULL AND n.created > %d ORDER BY created";
  $sql = node_rewrite_sql($sql);
  $nid = db_result(db_query_range($sql, $user->uid, $tid, NODE_NEW_LIMIT, 0, 1));
Dries Buytaert's avatar
   
Dries Buytaert committed
481
482
483
484

  return $nid ? $nid : 0;
}

485
/**
486
 * Menu callback; prints a forum listing.
487
 */
Dries Buytaert's avatar
Dries Buytaert committed
488
function forum_page($tid = 0) {
Dries Buytaert's avatar
   
Dries Buytaert committed
489
  global $user;
Dries Buytaert's avatar
   
Dries Buytaert committed
490

Dries Buytaert's avatar
   
Dries Buytaert committed
491
  if (module_exist('taxonomy')) {
Dries Buytaert's avatar
Dries Buytaert committed
492
493
    $forum_per_page = variable_get('forum_per_page', 25);
    $sortby = variable_get('forum_order', 1);
Dries Buytaert's avatar
   
Dries Buytaert committed
494

Dries Buytaert's avatar
Dries Buytaert committed
495
496
497
498
    $forums = forum_get_forums($tid);
    $parents = taxonomy_get_parents_all($tid);
    if ($tid && !in_array($tid, variable_get('forum_containers', array()))) {
      $topics = forum_get_topics($tid, $sortby, $forum_per_page);
Dries Buytaert's avatar
   
Dries Buytaert committed
499
    }
Dries Buytaert's avatar
Dries Buytaert committed
500

501
    print theme('page', theme('forum_display', $forums, $topics, $parents, $tid, $sortby, $forum_per_page));
Dries Buytaert's avatar
   
Dries Buytaert committed
502
503
  }
  else {
504
505
    drupal_set_title(t('Warning'));
    print theme('page', forum_help('admin/settings/forum'));
Dries Buytaert's avatar
   
Dries Buytaert committed
506
507
508
  }
}

Dries Buytaert's avatar
   
Dries Buytaert committed
509
/**
Dries Buytaert's avatar
   
Dries Buytaert committed
510
511
 * Format the forum body.
 *
Dries Buytaert's avatar
   
Dries Buytaert committed
512
 * @ingroup themeable
Dries Buytaert's avatar
   
Dries Buytaert committed
513
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
514
function theme_forum_display($forums, $topics, $parents, $tid, $sortby, $forum_per_page) {
Dries Buytaert's avatar
   
Dries Buytaert committed
515
  global $user;
Dries Buytaert's avatar
   
Dries Buytaert committed
516
  // forum list, topics list, topic browser and 'add new topic' link
Dries Buytaert's avatar
   
Dries Buytaert committed
517

Dries Buytaert's avatar
   
Dries Buytaert committed
518
  $vocabulary = taxonomy_get_vocabulary(variable_get('forum_nav_vocabulary', ''));
519
  drupal_set_title($title = $vocabulary->name);
Dries Buytaert's avatar
   
Dries Buytaert committed
520

Dries Buytaert's avatar
   
Dries Buytaert committed
521
522
  // Breadcrumb navigation:
  $breadcrumb = array();
Dries Buytaert's avatar
   
Dries Buytaert committed
523
  if ($tid) {
Dries Buytaert's avatar
   
Dries Buytaert committed
524
    $breadcrumb[] = array('path' => 'forum', 'title' => $title);
Dries Buytaert's avatar
   
Dries Buytaert committed
525
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
526
527

  if ($parents) {
Dries Buytaert's avatar
   
Dries Buytaert committed
528
529
    $parents = array_reverse($parents);
    foreach ($parents as $p) {
530
531
      if ($p->tid == $tid) {
        $title = $p->name;
Dries Buytaert's avatar
   
Dries Buytaert committed
532
533
      }
      else {
Dries Buytaert's avatar
   
Dries Buytaert committed
534
        $breadcrumb[] = array('path' => 'forum/'. $p->tid, 'title' => $p->name);
Dries Buytaert's avatar
   
Dries Buytaert committed
535
536
537
      }
    }
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
538
539
  $breadcrumb[] = array('path' => $_GET['q']);
  menu_set_location($breadcrumb);
Dries Buytaert's avatar
   
Dries Buytaert committed
540

Dries Buytaert's avatar
   
Dries Buytaert committed
541
  if (count($forums) || count($parents)) {
542
543
    $output  = '<div id="forum">';
    $output .= '<ul>';
Dries Buytaert's avatar
   
Dries Buytaert committed
544
545
546

    if (module_exist('tracker')) {
      if ($user->uid) {
Dries Buytaert's avatar
   
Dries Buytaert committed
547
        $output .= ' <li>'. l(t('My forum discussions.'), "tracker/$user->uid") .'</li>';
Dries Buytaert's avatar
   
Dries Buytaert committed
548
549
      }

Dries Buytaert's avatar
   
Dries Buytaert committed
550
      $output .= ' <li>'. l(t('Active forum discussions.'), 'tracker') .'</li>';
Dries Buytaert's avatar
   
Dries Buytaert committed
551
552
553
    }

    if (user_access('create forum topics')) {
554
      $output .= '<li>'. l(t('Post new forum topic.'), "node/add/forum/$tid") .'</li>';
Dries Buytaert's avatar
   
Dries Buytaert committed
555
556
    }
    else if ($user->uid) {
557
      $output .= '<li>'. t('You are not allowed to post a new forum topic.') .'</li>';
Dries Buytaert's avatar
   
Dries Buytaert committed
558
559
560
561
    }
    else {
      $output .= '<li>'. t('<a href="%login">Login</a> to post a new forum topic.', array('%login' => url('user/login'))) .'</li>';
    }
562
    $output .= '</ul>';
Dries Buytaert's avatar
   
Dries Buytaert committed
563

Dries Buytaert's avatar
   
Dries Buytaert committed
564
    $output .= theme('forum_list', $forums, $parents, $tid);
Dries Buytaert's avatar
   
Dries Buytaert committed
565

Dries Buytaert's avatar
   
Dries Buytaert committed
566
    if ($tid && !in_array($tid, variable_get('forum_containers', array()))) {
Dries Buytaert's avatar
   
Dries Buytaert committed
567
      $output .= theme('forum_topic_list', $tid, $topics, $sortby, $forum_per_page);
Dries Buytaert's avatar
   
Dries Buytaert committed
568
    }
569
    $output .= '</div>';
Dries Buytaert's avatar
   
Dries Buytaert committed
570
571
  }
  else {
572
    drupal_set_title(t('No forums defined'));
Dries Buytaert's avatar
   
Dries Buytaert committed
573
    $output = '';
Dries Buytaert's avatar
   
Dries Buytaert committed
574
575
  }

576
  return $output;
Dries Buytaert's avatar
   
Dries Buytaert committed
577
578
}

Dries Buytaert's avatar
   
Dries Buytaert committed
579
/**
Dries Buytaert's avatar
   
Dries Buytaert committed
580
581
 * Format the forum listing.
 *
Dries Buytaert's avatar
   
Dries Buytaert committed
582
 * @ingroup themeable
Dries Buytaert's avatar
   
Dries Buytaert committed
583
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
584
function theme_forum_list($forums, $parents, $tid) {
Dries Buytaert's avatar
   
Dries Buytaert committed
585
586
  global $user;

Dries Buytaert's avatar
   
Dries Buytaert committed
587
588
  if ($forums) {

Dries Buytaert's avatar
   
Dries Buytaert committed
589
    $header = array(t('Forum'), t('Topics'), t('Posts'), t('Last post'));
Dries Buytaert's avatar
   
Dries Buytaert committed
590
591

    foreach ($forums as $forum) {
Dries Buytaert's avatar
   
Dries Buytaert committed
592
      if ($forum->container) {
593
594
        $description  = '<div style="margin-left: '. ($forum->depth * 30) ."px;\">\n";
        $description .= ' <div class="name">'. l($forum->name, "forum/$forum->tid") ."</div>\n";
Dries Buytaert's avatar
   
Dries Buytaert committed
595
596
597
598
599
600

        if ($forum->description) {
          $description .= " <div class=\"description\">$forum->description</div>\n";
        }
        $description .= "</div>\n";

Dries Buytaert's avatar
   
Dries Buytaert committed
601
        $rows[] = array(array('data' => $description, 'class' => 'container', 'colspan' => '4'));
602
      }
Dries Buytaert's avatar
   
Dries Buytaert committed
603
      else {
604
        $forum->old_topics = _forum_topics_read($forum->tid, $user->uid);
Dries Buytaert's avatar
   
Dries Buytaert committed
605
606
607
        if ($user->uid) {
          $new_topics = $forum->num_topics - $forum->old_topics;
        }
Dries Buytaert's avatar
   
Dries Buytaert committed
608
609
610
        else {
          $new_topics = 0;
        }
Dries Buytaert's avatar
   
Dries Buytaert committed
611

612
613
        $description  = '<div style="margin-left: '. ($forum->depth * 30) ."px;\">\n";
        $description .= ' <div class="name">'. l($forum->name, "forum/$forum->tid") ."</div>\n";
Dries Buytaert's avatar
   
Dries Buytaert committed
614

Dries Buytaert's avatar
   
Dries Buytaert committed
615
616
617
618
        if ($forum->description) {
          $description .= " <div class=\"description\">$forum->description</div>\n";
        }
        $description .= "</div>\n";
Dries Buytaert's avatar
   
Dries Buytaert committed
619

Dries Buytaert's avatar
   
Dries Buytaert committed
620
        $rows[] = array(
Dries Buytaert's avatar
   
Dries Buytaert committed
621
          array('data' => $description, 'class' => 'forum'),
622
          array('data' => $forum->num_topics . ($new_topics ? '<br />'. l(t('%a new', array('%a' => $new_topics)), "forum/$forum->tid", NULL, NULL, 'new') : ''), 'class' => 'topics'),
Dries Buytaert's avatar
   
Dries Buytaert committed
623
624
          array('data' => $forum->num_posts, 'class' => 'posts'),
          array('data' => _forum_format($forum->last_post), 'class' => 'last-reply'));
Dries Buytaert's avatar
   
Dries Buytaert committed
625
      }
Dries Buytaert's avatar
   
Dries Buytaert committed
626
    }
Dries Buytaert's avatar
   
Dries Buytaert committed
627
628
629

    return theme('table', $header, $rows);

Dries Buytaert's avatar
   
Dries Buytaert committed
630
631
632
633
  }

}

Dries Buytaert's avatar
   
Dries Buytaert committed
634
/**
Dries Buytaert's avatar
   
Dries Buytaert committed
635
636
 * Format the topic listing.
 *
Dries Buytaert's avatar
   
Dries Buytaert committed
637
 * @ingroup themeable
Dries Buytaert's avatar
   
Dries Buytaert committed
638
 */
Dries Buytaert's avatar
   
Dries Buytaert committed
639
640
function theme_forum_topic_list($tid, $topics, $sortby, $forum_per_page) {
  global $forum_topic_list_header;
Dries Buytaert's avatar
   
Dries Buytaert committed
641
642

  if ($topics) {
Dries Buytaert's avatar
   
Dries Buytaert committed
643

Dries Buytaert's avatar
   
Dries Buytaert committed
644
645
    foreach ($topics as $topic) {
      // folder is new if topic is new or there are new comments since last visit
Dries Buytaert's avatar
Dries Buytaert committed
646
      if ($topic->tid != $tid) {
Dries Buytaert's avatar
   
Dries Buytaert committed
647
        $rows[] = array(
Dries Buytaert's avatar
   
Dries Buytaert committed
648
          array('data' => _forum_icon($topic->new, $topic->num_comments, $topic->comment_mode, $topic->sticky), 'class' => 'icon'),
Dries Buytaert's avatar
   
Dries Buytaert committed
649
650
          array('data' => $topic->title, 'class' => 'title'),
          array('data' => l(t('This topic has been moved'), "forum/$topic->tid"), 'colspan' => '3')
Dries Buytaert's avatar
   
Dries Buytaert committed
651
        );
Dries Buytaert's avatar
   
Dries Buytaert committed
652
653
      }
      else {
Dries Buytaert's avatar
   
Dries Buytaert committed
654
        $rows[] = array(
Dries Buytaert's avatar
   
Dries Buytaert committed
655
          array('data' => _forum_icon($topic->new, $topic->num_comments, $topic->comment_mode, $topic->sticky), 'class' => 'icon'),
Dries Buytaert's avatar
   
Dries Buytaert committed
656
657
          array('data' => l($topic->title, "node/$topic->nid"), 'class' => 'topic'),
          array('data' => $topic->num_comments . ($topic->new_replies ? '<br />'. l(t('%a new', array('%a' => $topic->new_replies)), "node/$topic->nid", NULL, NULL, 'new') : ''), 'class' => 'replies'),
Dries Buytaert's avatar
   
Dries Buytaert committed
658
659
          array('data' => _forum_format($topic), 'class' => 'created'),
          array('data' => _forum_format($topic->last_reply), 'class' => 'last-reply')
Dries Buytaert's avatar
   
Dries Buytaert committed
660
        );
Dries Buytaert's avatar
   
Dries Buytaert committed
661
662
663
      }
    }

Dries Buytaert's avatar
   
Dries Buytaert committed
664
665
    if ($pager = theme('pager', NULL, $forum_per_page, 0, tablesort_pager())) {
      $rows[] = array(array('data' => $pager, 'colspan' => '5', 'class' => 'pager'));
Dries Buytaert's avatar
   
Dries Buytaert committed
666
667
    }
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
668

Dries Buytaert's avatar
   
Dries Buytaert committed
669
  $output .= theme('table', $forum_topic_list_header, $rows);
Dries Buytaert's avatar
   
Dries Buytaert committed
670

Dries Buytaert's avatar
   
Dries Buytaert committed
671
672
673
  return $output;
}

Dries Buytaert's avatar
   
Dries Buytaert committed
674
function _forum_icon($new_posts, $num_posts = 0, $comment_mode = 0, $sticky = 0) {
Dries Buytaert's avatar
   
Dries Buytaert committed
675

Dries Buytaert's avatar
   
Dries Buytaert committed
676
  $base_path = variable_get('forum_icon_path', '');
Dries Buytaert's avatar
   
Dries Buytaert committed
677
  if ($base_path) {
Dries Buytaert's avatar
   
Dries Buytaert committed
678
679
    if ($num_posts > variable_get('forum_hot_topic', 15)) {
      $icon = $new_posts ? 'hot-new' : 'hot';
Dries Buytaert's avatar
   
Dries Buytaert committed
680
681
    }
    else {
Dries Buytaert's avatar
   
Dries Buytaert committed
682
      $icon = $new_posts ? 'new' : 'default';
Dries Buytaert's avatar
   
Dries Buytaert committed
683
684
685
    }

    if ($comment_mode == 1) {
Dries Buytaert's avatar
   
Dries Buytaert committed
686
      $icon = 'closed';
Dries Buytaert's avatar
   
Dries Buytaert committed
687
688
    }

Dries Buytaert's avatar
   
Dries Buytaert committed
689
690
691
692
    if ($sticky == 1) {
      $icon = 'sticky';
    }

Dries Buytaert's avatar
   
Dries Buytaert committed
693
    // default
Dries Buytaert's avatar
   
Dries Buytaert committed
694
    $file = "misc/forum-$icon.png";
Dries Buytaert's avatar
   
Dries Buytaert committed
695

Dries Buytaert's avatar
   
Dries Buytaert committed
696
    $output = theme('image', $file);
Dries Buytaert's avatar
   
Dries Buytaert committed
697
698
  }
  else {
Dries Buytaert's avatar
   
Dries Buytaert committed
699
    $output = '&nbsp;';
Dries Buytaert's avatar
   
Dries Buytaert committed
700
  }
Dries Buytaert's avatar
   
Dries Buytaert committed
701
702
703
704
705
706

  if ($new_posts) {
    $output = "<a name=\"new\">$output</a>";
  }

  return $output;
Dries Buytaert's avatar
   
Dries Buytaert committed
707
708
709
710
}

function _forum_user_last_visit($nid) {
  global $user;
711
712
713
  static $history = array();

  if (empty($history)) {
Dries Buytaert's avatar
   
Dries Buytaert committed
714
    $result = db_query('SELECT nid, timestamp FROM {history} WHERE uid = %d', $user->uid);
Dries Buytaert's avatar
   
Dries Buytaert committed
715
    while ($t = db_fetch_object($result)) {
716
      $history[$t->nid] = $t->timestamp > NODE_NEW_LIMIT ? $t->timestamp : NODE_NEW_LIMIT;
Dries Buytaert's avatar
   
Dries Buytaert committed
717
718
    }
  }
719
  return $history[$nid] ? $history[$nid] : NODE_NEW_LIMIT;
Dries Buytaert's avatar
   
Dries Buytaert committed
720
721
722
723
724
}

function _forum_get_topic_order($sortby) {
  switch ($sortby) {
    case 1:
Dries Buytaert's avatar
   
Dries Buytaert committed
725
      return array('field' => 'l.last_comment_timestamp', 'sort' => 'desc');
Dries Buytaert's avatar
   
Dries Buytaert committed
726
727
      break;
    case 2:
Dries Buytaert's avatar
   
Dries Buytaert committed
728
      return array('field' => 'l.last_comment_timestamp', 'sort' => 'asc');
Dries Buytaert's avatar
   
Dries Buytaert committed
729
730
      break;
    case 3:
Dries Buytaert's avatar
   
Dries Buytaert committed
731
      return array('field' => 'l.comment_count', 'sort' => 'desc');
Dries Buytaert's avatar
   
Dries Buytaert committed
732
733
      break;
    case 4:
Dries Buytaert's avatar
   
Dries Buytaert committed
734
      return array('field' => 'l.comment_count', 'sort' => 'asc');
Dries Buytaert's avatar
   
Dries Buytaert committed
735
736
737
738
      break;
  }
}

Dries Buytaert's avatar
   
Dries Buytaert committed
739
740
741
742
743
function _forum_get_topic_order_sql($sortby) {
  $order = _forum_get_topic_order($sortby);
  return $order['field'] .' '. $order['sort'];
}

Dries Buytaert's avatar
   
Dries Buytaert committed
744
?>