PunBB Forums — how about add button next or previous topic ?

Re: how about add button next or previous topic ?

null@example.com (PanBB.Ru) — Wed, 28 Sep 2016 03:22:52 +0000

http://punbb.ru/topic6223-reliz-linker.html

Re: how about add button next or previous topic ?

null@example.com (kerlinrao) — Wed, 28 Sep 2016 00:09:56 +0000

PanBB.Ru wrote:

Разберешься?

    $bquery = array(
        'SELECT'    => 'MIN(bt.id), bt.subject',
        'FROM'        => 'topics AS bt',
        'WHERE'        => 'bt.id>'.$id,
    );
    $bresult = $forum_db->query_build($bquery) or error(__FILE__, __LINE__);
    $back = $forum_db->fetch_assoc($bresult);
    
    if(isset($back['MIN(bt.id)']))
        $tback = ''.$back['subject'].'';
    
    $nquery = array(
        'SELECT'    => 'MAX(nt.id), nt.subject',
        'FROM'        => 'topics AS nt',
        'WHERE'        => 'nt.id<'.$id,
    );
    $nresult = $forum_db->query_build($nquery) or error(__FILE__, __LINE__);
    $next = $forum_db->fetch_assoc($nresult);
    
    if(isset($next['MAX(nt.id)']))
        $tnext = ''.$next['subject'].'';
        
    echo $tback;
    echo $tnext;

will you understand?

Or second embodiment:

    $query = array(
        'SELECT'    => 't.id, t.subject',
        'FROM'        => 'topics AS t',
        'WHERE'        => 't.forum_id='.$cur_topic['forum_id']
    );
    $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
    
    $back = array();
    $next = array();
    while($topics = $forum_db->fetch_assoc($result))
    {
        if($topics['id'] < $id)
            $back[$topics['id']] = $topics['subject'];
        else if ($topics['id'] > $id)
            $next[$topics['id']] = $topics['subject'];
    }
    
    $back_id = max(array_keys($back));
    $back_subject = $back[$back_id];
    
    $next_id = min(array_keys($next));
    $next_subject = $next[$next_id];
    
    $tback = !empty($back_id) ? ''.$back_subject.' ◄◄ ' : '';
    
    $tnext = !empty($next_id) ? ' ►► '.$next_subject.'' : '';

I have tried it but i messed up at then end. Is there any alternate route to do so.....!
Infantigo

Re: how about add button next or previous topic ?

null@example.com (PanBB.Ru) — Sun, 21 Aug 2016 19:09:42 +0000

well, well... then it is better use the extension. see above.

Re: how about add button next or previous topic ?

null@example.com (kudataz) — Sun, 21 Aug 2016 18:01:13 +0000

PanBB.Ru wrote:

Разберешься?
will you understand?
Or second embodiment:

No.. where i must place this?

Re: how about add button next or previous topic ?

null@example.com (PanBB.Ru) — Thu, 11 Aug 2016 11:27:15 +0000

Разберешься?

    $bquery = array(
        'SELECT'    => 'MIN(bt.id), bt.subject',
        'FROM'        => 'topics AS bt',
        'WHERE'        => 'bt.id>'.$id,
    );
    $bresult = $forum_db->query_build($bquery) or error(__FILE__, __LINE__);
    $back = $forum_db->fetch_assoc($bresult);
    
    if(isset($back['MIN(bt.id)']))
        $tback = ''.$back['subject'].'';
    
    $nquery = array(
        'SELECT'    => 'MAX(nt.id), nt.subject',
        'FROM'        => 'topics AS nt',
        'WHERE'        => 'nt.id<'.$id,
    );
    $nresult = $forum_db->query_build($nquery) or error(__FILE__, __LINE__);
    $next = $forum_db->fetch_assoc($nresult);
    
    if(isset($next['MAX(nt.id)']))
        $tnext = ''.$next['subject'].'';
        
    echo $tback;
    echo $tnext;

will you understand?

Or second embodiment:

    $query = array(
        'SELECT'    => 't.id, t.subject',
        'FROM'        => 'topics AS t',
        'WHERE'        => 't.forum_id='.$cur_topic['forum_id']
    );
    $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
    
    $back = array();
    $next = array();
    while($topics = $forum_db->fetch_assoc($result))
    {
        if($topics['id'] < $id)
            $back[$topics['id']] = $topics['subject'];
        else if ($topics['id'] > $id)
            $next[$topics['id']] = $topics['subject'];
    }
    
    $back_id = max(array_keys($back));
    $back_subject = $back[$back_id];
    
    $next_id = min(array_keys($next));
    $next_subject = $next[$next_id];
    
    $tback = !empty($back_id) ? ''.$back_subject.' ◄◄ ' : '';
    
    $tnext = !empty($next_id) ? ' ►► '.$next_subject.'' : '';

Re: how about add button next or previous topic ?

null@example.com (sempai) — Thu, 11 Aug 2016 10:15:09 +0000

Look here: link

how about add button next or previous topic ?

null@example.com (kudataz) — Thu, 11 Aug 2016 08:18:48 +0000

i think this optional will make easy user read topic without back to viewforum or index to see other topics
hwo to create coding like this?