vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Latest Threads On Forum Home (https://vborg.vbsupport.ru/showthread.php?t=83230)

criscokid 08-29-2006 04:59 PM

How can I get the usernames sisplayed in the 'Latest forum threads' section when clicked on to open in a new window?

shaynehammy 08-31-2006 04:01 AM

If i want to change the display name to "The latest 20 threads" or similar would i change the phrase after CDATA below?

<phrase name="latest_threads"><![CDATA[Latest Threads]]></phrase>
</phrasetype>
</phrases>
<options>
</options>
</product>

Nick0r 08-31-2006 07:50 AM

Unfortately Onkel_Tom, that made no difference. On 3.6 guests can still see private threads showing up in the 'Latest threads' section of the homepage.

aveon 09-03-2006 02:08 AM

does anybody know how to make this hack visible on all pages???

Pathor 09-03-2006 03:11 PM

<a href="http://www.vbulletin.com/forum/showthread.php?t=198968" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=198968</a>

That´s also possible with this hack.

aeroguy 09-04-2006 04:48 AM

could some add a join table function as to also enable to show what forum the threads are in. The get thread function within the mod already sees the forum id just need a join to get the name from the id.

Onkel_Tom 09-04-2006 09:50 AM

Quote:

Originally Posted by aeroguy
could some add a join table function as to also enable to show what forum the threads are in. The get thread function within the mod already sees the forum id just need a join to get the name from the id.

Should be done with:
PHP Code:

## GET LATEST THREADS ##
$getthreads $db->query_read("
    SELECT forum.title AS forumtitle, thread.*, thread.iconid AS threadiconid 
$previewfield
    FROM " 
TABLE_PREFIX "thread AS thread
            LEFT JOIN " 
TABLE_PREFIX "deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
            LEFT JOIN " 
TABLE_PREFIX "forum AS forum ON (forum.forumid = thread.forumid)
            
$previewjoin
            WHERE thread.open = '1'
            AND thread.forumid NOT IN (0
$limitfids)
            AND thread.visible = '1'
            AND deletionlog.primaryid IS NULL
            ORDER BY lastpost
            DESC LIMIT 10"
); 

and to restrict the lenght add after:
PHP Code:

$thread['title'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 55)); 

PHP Code:

$thread['forumtitle'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['forumtitle']), 50)); 

To show the name of the forum you have to change the Template forumhome_latestthreadbit, add
PHP Code:

<a href="forumdisplay.php?$session[sessionurl]f=$thread[forumid]title="go to $thread[forumtitle]">$thread[forumtitle

or something like that.

aveon 09-04-2006 01:22 PM

hey Tom it didnt work mate or did i do something wrong i added the codes where you wanted me to add them and the latest posts still only visible on forum home how can i set permissions and make it visivle on all pages helpme please and i will come up with a really good design for side column...

putergirl 09-04-2006 02:41 PM

Hello, I am having problems viewing the latest threads. Sometimes I can see it and sometimes I can't. I've tried clearing my cache and the cookies to no avail. Just when I give up, it will show again briefly, then poof, gone again. I mean, I had resined myself to not being able to see it, and it showed up an hour later after I did nothing. Any ideas what could be causing that? The same thing happens with my users, some can see it, some can't, and we didn't have this problem till I upgraded to 3.6. Thanks.

I have also tried re-importing the product and allowed overwrite.

aeroguy 09-04-2006 04:07 PM

i am too getting an mysql error

Invalid SQL:

## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM CT_thread AS thread
LEFT JOIN CT_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN CT_forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN CT_post AS post ON(post.postid = thread.firstpostid)
WHERE open <> 10
AND forumid NOT IN (0)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost


All times are GMT. The time now is 10:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01338 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete