BBCodeBox3

prosilver | subsilver2

Willkommen und Guten Morgen, Guest  Beim nächsten Piep ist es zwischen 7:00 und 8:00 Uhr

It is currently Sun 23. Feb 2025, 08:59

All times are UTC + 1 hour [ DST ]




Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
PostPosted: Tue 18. May 2010, 18:36 
Administrator
User avatar

Posts: 427

Last 3 Topics:
Tabmenu Test
[Snippet] Avatar Ev...
[DEV] Zero and X-P...

Joined:
Sun 13. Jan 2008, 23:44

Last 3 Topics v.0.0.1

Request by: pirro
Request Thread: http://www.phpbb.com/community/viewtopi ... &t=2091247

With this snippet u can see the last 3 topics made by each user in viewtopic under user-information

prosilver: http://4seven.bplaced.net/phpbb3/viewtopic. ... 1135#p1135 (english: 'Last 3 Topics:')
subsilver2: http://4seven.bplaced.net/phpbb3/viewtopic. ... 1135#p1135 (english: 'Last 3 Topics:')



Instruction

download package

Attachment:

copy

root/styles/prosilver/templates/*.* > styles/prosilver/templates/*.*
root/styles/subsilver2/templates/*.* > styles/subsilver2/templates/*.*

open

viewtopic.php

find

Code:
    //
    $postrow = array(   


before add

Code:
                // Last 3 Topics v.0.0.1 / 4seven / 2010
                // Enter here the max. Signs of Short Topic Title 
                $topic_title_length = 25;
                // Full Topic Title will shown in Mouseover ;)
          
                $forum_ary 
= array();
                $forum_read_ary = $auth->acl_getf('f_read');

                foreach ($forum_read_ary as $forum_id => $allowed){
                if ($allowed['f_read']){
                $forum_ary[] = (int) $forum_id;}}

                $forum_ary = array_intersect(array_keys($auth->acl_getf('f_read', true)), array_keys($auth->acl_getf('f_download', true)));

                $sql_x_1 = 'SELECT f.forum_name, t.topic_id, t.forum_id, t.topic_title, t.topic_time
                FROM '
 . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t
                WHERE t.topic_poster = '
 . (int) $poster_id . '
                AND f.forum_id = t.forum_id
                AND '
 . $db->sql_in_set('t.forum_id', $forum_ary) . 
                ORDER BY topic_time DESC'
;
                $result_x_1 = $db->sql_query_limit($sql_x_1, 3);
                $rows_x_1   = $db->sql_fetchrowset($result_x_1);                
                $db
->sql_freeresult($result_x_1);
                
                $topic_title_count 
= count($rows_x_1);
                // Last 3 Topics v.0.0.1 / 4seven / 2010        


find again

Code:
    //
    $postrow = array(   


after add

Code:
        // Last 3 Topics v.0.0.1 / 4seven / 2010
        'LAST_X_TOPICS_COUNT_O_1' => ($topic_title_count == 1) ? $user->lang['LAST'] . ' ' . $user->lang['TOPIC'] : '',    
        
'LAST_X_TOPICS_COUNT_U_2' => ($topic_title_count > 1) ? $user->lang['LATEST'] . ' ' . count($rows_x_1) . ' ' . $user->lang['TOPICS'] : '',
        'LAST_X_TOPICS_COUNT_U_1' => ($topic_title_count == 0) ? $user->lang['NO_LATEST'] . ' ' . $user->lang['TOPICS'] : '',
        
        
'LAST_X_TOPICS_EXIST_1'  => (isset($rows_x_1[0]['forum_name'])) ? true : false,
        'LAST_X_TOPICS_SHORT_1'  => (isset($rows_x_1[0]['forum_name'])) ? (strlen(censor_text($rows_x_1[0]['topic_title'])) < $topic_title_length) ? censor_text($rows_x_1[0]['topic_title']) : substr(stripslashes(censor_text($rows_x_1[0]['topic_title'])), 0, $topic_title_length) . '...' : '',
        'LAST_X_TOPICS_LONG_1'   => (isset($rows_x_1[0]['forum_name'])) ? censor_text($rows_x_1[0]['topic_title']) : '',
        'LAST_X_TOPICS_LINK_1'   => (isset($rows_x_1[0]['forum_name'])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $rows_x_1[0]['forum_id']) . '&amp;t=' . $rows_x_1[0]['topic_id'] : '',
        'LAST_X_FORUMS_LONG_1'   => (isset($rows_x_1[0]['forum_name'])) ? censor_text($rows_x_1[0]['forum_name']) : '',
        'LAST_X_DATE_TIME_1'     => (isset($rows_x_1[0]['forum_name'])) ? $user->format_date($rows_x_1[0]['topic_time']) : '',    
        
        
'LAST_X_TOPICS_EXIST_2'  => (isset($rows_x_1[1]['forum_name'])) ? true : false,
        'LAST_X_TOPICS_SHORT_2'  => (isset($rows_x_1[1]['forum_name'])) ? (strlen(censor_text($rows_x_1[1]['topic_title'])) < $topic_title_length) ? censor_text($rows_x_1[1]['topic_title']) : substr(stripslashes(censor_text($rows_x_1[1]['topic_title'])), 0, $topic_title_length) . '...' : '',
        'LAST_X_TOPICS_LONG_2'   => (isset($rows_x_1[1]['forum_name'])) ? censor_text($rows_x_1[1]['topic_title']) : '',
        'LAST_X_TOPICS_LINK_2'   => (isset($rows_x_1[1]['forum_name'])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $rows_x_1[1]['forum_id']) . '&amp;t=' . $rows_x_1[1]['topic_id'] : '',
        'LAST_X_FORUMS_LONG_2'   => (isset($rows_x_1[1]['forum_name'])) ? censor_text($rows_x_1[1]['forum_name']) : '',
        'LAST_X_DATE_TIME_2'     => (isset($rows_x_1[1]['forum_name'])) ? $user->format_date($rows_x_1[1]['topic_time']) : '',
        
        
'LAST_X_TOPICS_EXIST_3'  => (isset($rows_x_1[2]['forum_name'])) ? true : false,
        'LAST_X_TOPICS_SHORT_3'  => (isset($rows_x_1[2]['forum_name'])) ? (strlen(censor_text($rows_x_1[2]['topic_title'])) < $topic_title_length) ? censor_text($rows_x_1[2]['topic_title']) : substr(stripslashes(censor_text($rows_x_1[2]['topic_title'])), 0, $topic_title_length) . '...' : '',
        'LAST_X_TOPICS_LONG_3'   => (isset($rows_x_1[2]['forum_name'])) ? censor_text($rows_x_1[2]['topic_title']) : '',
        'LAST_X_TOPICS_LINK_3'   => (isset($rows_x_1[2]['forum_name'])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $rows_x_1[2]['forum_id']) . '&amp;t=' . $rows_x_1[2]['topic_id'] : '',
        'LAST_X_FORUMS_LONG_3'   => (isset($rows_x_1[2]['forum_name'])) ? censor_text($rows_x_1[2]['forum_name']) : '',
        'LAST_X_DATE_TIME_3'     => (isset($rows_x_1[2]['forum_name'])) ? $user->format_date($rows_x_1[2]['topic_time']) : '',
        // Last 3 Topics v.0.0.1 / 4seven / 2010              


open

language/en/viewtopic.php

find

Code:
$lang = array_merge($lang, array(  


after add

Code:
    // Last 3 Topics v.0.0.1 / 4seven / 2010
    'LAST'                  => 'Last', 
    
'LATEST'                => 'Last', 
    
'NO_LATEST'             => 'No',
    // Last 3 Topics v.0.0.1 / 4seven / 2010                 


open

language/de/viewtopic.php

find

Code:
$lang = array_merge($lang, array(   


after add

Code:
    // Last 3 Topics v.0.0.1 / 4seven / 2010
    'LAST'                  => 'Letztes', 
    
'LATEST'                => 'Letzte', 
    
'NO_LATEST'             => 'Keine',
    // Last 3 Topics v.0.0.1 / 4seven / 2010                  


open

styles/prosilver/templates/overall_header.html

find

Code:
<body id="phpbb" class="section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}"> 


after add

Code:
<script type="text/javascript" src="{T_TEMPLATE_PATH}/wz_tooltip.js"></script>


open

styles/prosilver/templates/viewtopic_body.html

find

Code:
        <!-- IF postrow.POSTER_JOINED -->   


before add

Code:
        <!-- IF postrow.LAST_X_TOPICS_EXIST_1 -->
        <dd style="color:black;">{postrow.LAST_X_TOPICS_COUNT_O_1}{postrow.LAST_X_TOPICS_COUNT_U_2}:</dd>
        <dd><a onmouseover="Tip('{L_TOPIC}: {postrow.LAST_X_TOPICS_LONG_1} &lt;br /&gt; {L_FORUM}: {postrow.LAST_X_FORUMS_LONG_1} &lt;br /&gt; {L_POST_TIME}: {postrow.LAST_X_DATE_TIME_1}', PADDING, 4, BGCOLOR, '#F6F4D0', BORDERCOLOR, '#027AB7', OFFSETX, 100, OFFSETY, 21)" onmouseout="UnTip()" style="font-weight:500;" href="{postrow.LAST_X_TOPICS_LINK_1}">{postrow.LAST_X_TOPICS_SHORT_1}</a></dd>
        <!-- IF postrow.LAST_X_TOPICS_EXIST_2 -->
        <dd><a onmouseover="Tip('{L_TOPIC}: {postrow.LAST_X_TOPICS_LONG_2} &lt;br /&gt; {L_FORUM}: {postrow.LAST_X_FORUMS_LONG_2} &lt;br /&gt; {L_POST_TIME}: {postrow.LAST_X_DATE_TIME_2}', PADDING, 4, BGCOLOR, '#F6F4D0', BORDERCOLOR, '#027AB7', OFFSETX, 100, OFFSETY, 21)" onmouseout="UnTip()" style="font-weight:500;" href="{postrow.LAST_X_TOPICS_LINK_2}">{postrow.LAST_X_TOPICS_SHORT_2}</a></dd>    
        
<!-- IF postrow.LAST_X_TOPICS_EXIST_3 -->
        <dd><a onmouseover="Tip('{L_TOPIC}: {postrow.LAST_X_TOPICS_LONG_3} &lt;br /&gt; {L_FORUM}: {postrow.LAST_X_FORUMS_LONG_3} &lt;br /&gt; {L_POST_TIME}: {postrow.LAST_X_DATE_TIME_3}', PADDING, 4, BGCOLOR, '#F6F4D0', BORDERCOLOR, '#027AB7', OFFSETX, 100, OFFSETY, 21)" onmouseout="UnTip()" style="font-weight:500;" href="{postrow.LAST_X_TOPICS_LINK_3}">{postrow.LAST_X_TOPICS_SHORT_3}</a></dd>
        <!-- ENDIF -->    
        
<!-- ENDIF -->
        <!-- ELSE -->
        <dd style="color:black;">{postrow.LAST_X_TOPICS_COUNT_U_1}</dd>
        <!-- ENDIF -->
        <dd>&nbsp;</dd> 


open

styles/subsilver2/templates/overall_header.html

find

Code:
<body class="{S_CONTENT_DIRECTION}"> 


after add

Code:
<script type="text/javascript" src="{T_TEMPLATE_PATH}/wz_tooltip.js"></script>


open

styles/subsilver2/templates/viewtopic_body.html

find

Code:
                    <!-- IF postrow.POSTER_POSTS != '' --><br /><b>{L_POSTS}:</b> {postrow.POSTER_POSTS}<br /><!-- ENDIF -->   


after add

Code:
                    <!-- IF postrow.LAST_X_TOPICS_EXIST_1 -->
                    <br /><b>{postrow.LAST_X_TOPICS_COUNT_O_1}{postrow.LAST_X_TOPICS_COUNT_U_2}:</b>
                    <br /><a onmouseover="Tip('{L_TOPIC}: {postrow.LAST_X_TOPICS_LONG_1} &lt;br /&gt; {L_FORUM}: {postrow.LAST_X_FORUMS_LONG_1} &lt;br /&gt; {L_POST_TIME}: {postrow.LAST_X_DATE_TIME_1}', PADDING, 4, BGCOLOR, '#F6F4D0', BORDERCOLOR, '#027AB7', OFFSETX, -100, OFFSETY, 21)" onmouseout="UnTip()" style="font-weight:500;" href="{postrow.LAST_X_TOPICS_LINK_1}">{postrow.LAST_X_TOPICS_SHORT_1}</a>
                    <!-- IF postrow.LAST_X_TOPICS_EXIST_2 -->
                    <br /><a onmouseover="Tip('{L_TOPIC}: {postrow.LAST_X_TOPICS_LONG_2} &lt;br /&gt; {L_FORUM}: {postrow.LAST_X_FORUMS_LONG_2} &lt;br /&gt; {L_POST_TIME}: {postrow.LAST_X_DATE_TIME_2}', PADDING, 4, BGCOLOR, '#F6F4D0', BORDERCOLOR, '#027AB7', OFFSETX, -100, OFFSETY, 21)" onmouseout="UnTip()" style="font-weight:500;" href="{postrow.LAST_X_TOPICS_LINK_2}">{postrow.LAST_X_TOPICS_SHORT_2}</a>    
                    
<!-- IF postrow.LAST_X_TOPICS_EXIST_3 -->
                    <br /><a onmouseover="Tip('{L_TOPIC}: {postrow.LAST_X_TOPICS_LONG_3} &lt;br /&gt; {L_FORUM}: {postrow.LAST_X_FORUMS_LONG_3} &lt;br /&gt; {L_POST_TIME}: {postrow.LAST_X_DATE_TIME_3}', PADDING, 4, BGCOLOR, '#F6F4D0', BORDERCOLOR, '#027AB7', OFFSETX, -100, OFFSETY, 21)" onmouseout="UnTip()" style="font-weight:500;" href="{postrow.LAST_X_TOPICS_LINK_3}">{postrow.LAST_X_TOPICS_SHORT_3}</a>
                    <!-- ENDIF -->
                    <!-- ENDIF -->
                    <!-- ELSE -->
                    <br /><b>{postrow.LAST_X_TOPICS_COUNT_U_1}</b>    
                    
<!-- ENDIF -->                    
                    
<br /><br /> 


Clear all Board- and Browser-Caches


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
POWERED_BY
[ Time : 0.017s | 19 Queries | GZIP : Off | Board-Version: 3.0.7 PL1 ]