⌈⌋ branch:  freshcode


Check-in [39f671788e]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
SHA1:39f671788e439c8d9a51f7e4c61b2660d964a71d
Date: 2014-12-29 14:08:33
User: mario
Comment:Forum: threads with new submissions order on top now.
Tags And Properties
  • branch=trunk inherited from [82405bb421]
  • sym-trunk inherited from [82405bb421]
Context
2014-12-29
14:10
[1c0b6ac0e7] Detect other Twitter URL variations. (user: mario, tags: trunk)
14:08
[39f671788e] Forum: threads with new submissions order on top now. (user: mario, tags: trunk)
2014-12-23
05:11
[f8bc06e188] Prevent recollapsing of forum entries when editing within the reply/form fields. (user: mario, tags: trunk)
Changes

Changes to lib/forum.php.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
..
29
30
31
32
33
34
35







36









37

38
39
40
41
42
43
44
..
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96


97
98
99
100
101
102
103
<?php
/**
 * api: php
 * type: handler
 * title: Follow The Thread
 * description: Straightforward threaded discussion forum
 * version: 0.2
 * category: discussion
 * depends: HTMLPurifier
 * config:
 *    <var name="forum_cfg[categories]" type="list" default="discussion,documentation" help="Comma-separated list of thread classifiers"/>
 *
 *
 * Implements a minimalistic web forum.
 * Primary goals are:
 *   → Threaded discussions in place of bulletin board blabber.
................................................................................
 *    [excerpt] TEXT,
 *    [author] VARCHAR (0, 80),
 *    [miniature] TEXT,
 *    [t_published] INT NOT NULL,
 *    [edit_token] VARCHAR (16, 64)
 *
 * Templating







 * Behaviour









 * Configuration

 *
 *
 *
 */


/**
................................................................................
     * Show forum listing
     *
     */
    function index($page=0) {
    
        // Fetch thread groups (attached to root gid=0)
        $entries = db("
            SELECT *
              FROM forum
             WHERE gid
                IN ( SELECT id
                       FROM forum
                      WHERE pid = 0
                   ORDER BY t_published DESC
                      LIMIT 50
                     OFFSET ?*50 )
          ORDER BY gid DESC,
                   t_published ASC
        ", $page);


        
        // Iterate over groups
        $last = 0;
        $group = array();
        foreach ($entries as $e) {
            if ($e["gid"] != $last) {
                $this->show_thread($group);






|

|







 







>
>
>
>
>
>
>

>
>
>
>
>
>
>
>
>

>







 







|
|
|
|
|
|
|
|
|
|
|
|
>
>







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
..
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
..
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<?php
/**
 * api: php
 * type: handler
 * title: Follow The Thread
 * description: Straightforward threaded discussion forum
 * version: 0.3
 * category: discussion
 * depends: HTMLPurifier, input
 * config:
 *    <var name="forum_cfg[categories]" type="list" default="discussion,documentation" help="Comma-separated list of thread classifiers"/>
 *
 *
 * Implements a minimalistic web forum.
 * Primary goals are:
 *   → Threaded discussions in place of bulletin board blabber.
................................................................................
 *    [excerpt] TEXT,
 *    [author] VARCHAR (0, 80),
 *    [miniature] TEXT,
 *    [t_published] INT NOT NULL,
 *    [edit_token] VARCHAR (16, 64)
 *
 * Templating
 *   → Requires a template wrapper with <ul class=forum> prepared.
 *   → Index page must provide a quirky switch block, to dispatch depending
 *     on $_GET[name] function (one of post, edit, submit).
 *   → But just $forum->index() for output.
 *   → forum_entry.php for rendering a table entry.
 *   → forum_submit_form.php for post editing.
 *
 * Behaviour
 *   → Forum index is grouped by threads. Threads with new additions go on top now.
 *     But within threads the oldest entries come first.
 *   → Editing token is valid for 48 hours.
 *   → Admin settings must be inported manually from main application (->$is_admin).
 *
 * Javascript
 *   → AJAX is mainly used for submission to divert spambots.
 *   → Posts are folded to an excerpt, until clicked.
 *
 * Configuration
 *   → Basically just the categories are configurable.
 *
 *
 *
 */


/**
................................................................................
     * Show forum listing
     *
     */
    function index($page=0) {
    
        // Fetch thread groups (attached to root gid=0)
        $entries = db("
          WITH grouped
            AS (SELECT gid, (MAX(t_published) + gid/1000) AS gid_group
                  FROM forum
              GROUP BY gid
                 LIMIT 50
                OFFSET ?*50
          )
          SELECT *
            FROM forum
       LEFT JOIN grouped
              ON forum.gid=grouped.gid
        ORDER BY gid_group DESC, forum.gid DESC, t_published ASC;
        ", $page);

        
        // Iterate over groups
        $last = 0;
        $group = array();
        foreach ($entries as $e) {
            if ($e["gid"] != $last) {
                $this->show_thread($group);