Willkommen und Guten Tag, Guest  Beim nächsten Piep ist es zwischen 15:00 und 16:00 Uhr

[Snippet] Last 3 Topics v.0.0.1 (en/de)

DEV-Area for phpBB 3.0.x
Topic locked

[Snippet] Last 3 Topics v.0.0.1 (en/de)

Postby 4seven » Tue 18. May 2010, 18:36 | Userzeit: +1.00 / Di 18. Mai 2010, 19:36

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

Last_3_Topics_v.0.0.1.zip
(24.9 KiB) Downloaded 148 times

copy

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

open

viewtopic.php

find

Code: Select all
    //
    $postrow = array(   


before add

Code: Select all
                // 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: Select all
    //
    $postrow = array(   


after add

Code: Select all
        // 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: Select all
$lang = array_merge($lang, array(  


after add

Code: Select all
    // 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: Select all
$lang = array_merge($lang, array(   


after add

Code: Select all
    // 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: Select all
<body id="phpbb" class="section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}"> 


after add

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


open

styles/prosilver/templates/viewtopic_body.html

find

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


before add

Code: Select all
        <!-- 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: Select all
<body class="{S_CONTENT_DIRECTION}"> 


after add

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


open

styles/subsilver2/templates/viewtopic_body.html

find

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


after add

Code: Select all
                    <!-- 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
User avatar
4seven
Administrator
 
Posts: 427
 
Last 3 Topics:
Tabmenu Test
[Snippet] Avatar Ev...
[DEV] Zero and X-P...
 
Joined:
Sun 13. Jan 2008, 23:44
 
Letzter Login:
Mon 1. Aug 2022, 16:40
 
Posted:
Tue 18. May 2010, 18:36 +1.00
Userzeit: Di 18. Mai 2010, 19:36
Top
Topic locked

Return to [DEV] Mods for 3.0.x



Who is online

Users browsing this forum: No registered users and 0 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Time : 0.062s | 20 Queries | GZIP : Off | Board-Version: 3.0.14
cron