Search options (Page 33 of 38)

  <?xml version="1.0" encoding="utf-8" ?> 
- <extension engine="1.0">
  <id>subject_index</id> 
  <title>Last Post Subject on Forum Index</title> 
  <version>1.0</version> 
  <description>This will add the subject of the last post under the last post column on the index page.</description> 
  <author>StevenBullen (Ju of CtrlAltSuppr.com)</author> 
  <minversion>1.3 Beta</minversion> 
  <maxtestedon>1.3 Beta</maxtestedon> 
- <hooks>
- <hook id="in_qr_get_cats_and_forums">
- <![CDATA[ 
        $query['SELECT'] .= ', t.subject';
        $query['JOINS'][] = array(
            'LEFT JOIN'    => 'topics AS t',
            'ON'        => 't.last_post_id=f.last_post_id'
        );
    

  ]]> 
  </hook>
- <hook id="in_row_pre_display">
- <![CDATA[ 
        if ($cur_forum['last_post'] != '')
        {
            unset($pun_page['item_last_post']);
        
            $idm = $cur_forum['subject'];
            if(strlen($idm) > 30) {
                $idmComp = str_replace('"', "''", $idm);
                $idm = substr($idm, 0, 30).'...';
            } else
                $idmComp = '';
         
            $idmT = (isset($idmComp)) ? ' title="'.$idmComp.'"' : '';

            $pun_page['item_last_post'][] = '<a href="'.pun_link($pun_url['post'], $cur_forum['last_post_id']).'"'.$idmT.'><span>'.$idm.'</span></a>';
            $pun_page['item_last_post'][] =    '<span class="byuser">'.sprintf($lang_common['By user'], htmlspecialchars($cur_forum['last_poster'])).'</span>';
        }
    

  ]]> 
  </hook>
  </hooks>
  </extension>

index.php 
Line 42, replace 

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE fp.read_forum IS NULL OR fp.read_forum=1 ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());With 

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, t.subject FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'topics AS t ON t.last_post_id=f.last_post_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE fp.read_forum IS NULL OR fp.read_forum=1 ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());Line 109, replace 

    // If there is a last_post/last_poster.
    if ($cur_forum['last_post'] != '')
        $last_post = '<a href="viewtopic.php?pid='.$cur_forum['last_post_id'].'#p'.$cur_forum['last_post_id'].'">'.format_time($cur_forum['last_post']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_forum['last_poster']).'</span>';
    else
        $last_post = ' ';With 

    // Display the last topic
    $idm = $cur_forum['subject'];
    if(strlen($idm) > 30) {
        $idmComp = str_replace('"', "''", $idm);
        $idm = substr($idm, 0, 30).'...';
    } else
        $idmComp = '';
 
    // If there is a last_post/last_poster.
    if ($cur_forum['last_post'] != '') {
        $idmT = (isset($idmComp)) ? ' title="'.$idmComp.'"' : '';
        $last_post = format_time($cur_forum['last_post']).'<br />dans <a href="viewtopic.php?pid='.$cur_forum['last_post_id'].'#p'.$cur_forum['last_post_id'].'"'.$idmT.'><em>'.$idm.'</em></a><br /><span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_forum['last_poster']).'</span>';
    } else
        $last_post = ' ';Save and upload.