vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Latest Thread (in index and forumdisplay) (https://vborg.vbsupport.ru/showthread.php?t=37952)

TECK 04-28-2002 10:36 AM

i cannot answer you on this firefly. as you know, i do all my hacks on localhost. before i posted the hack, i had Zzed testing it. wooolF also test it on his board. he usually have over 100 members online.

can you please explain us why you think the query is not reliable?
maybe you could try it only temporarely at vB.org just to see it's stability. thanks.

Scott MacVicar 04-28-2002 10:38 AM

I'll try it on my local board, has alot of forums on the forum home and 90,000 posts should be ok for a test.

See if it brings my computer to its knees :D

TECK 04-28-2002 10:40 AM

thanks PPN. :) i'm curious to find out the results.

adtestvb 04-28-2002 10:44 AM

its not showing anything :( i had all the code the install file said to find. edited the index and forumdisplay and the template

i tried it on 2.2.2 and 2.2.5

Admin 04-28-2002 10:55 AM

BTW what's the purpose of this code?
Code:

(forum.lastpost-forum.daysprune)
You don't need to substract daysprune from it, the units are not even the same (lastpost is in UNIX time stamp, daysprune is a number of days).

TECK 04-28-2002 11:02 AM

firefly, i tried this:
PHP Code:

LEFT JOIN thread ON (thread.forumid=forum.forumid AND thread.lastpost=forum.lastpost

and i encountered one problem:
if the post is made other then today, it will not show. so i went with the logic and added a value to the default days that the forum is pruned.

this is the only way i could think of it. let me know if you have in mind something that will pull the trick better.

Admin 04-28-2002 11:05 AM

Using = is just fine.

Chris M 04-28-2002 11:10 AM

@nakkid - Does this provide a link to the Topic itself, or is it just the name and who created it?

Other than that question, great hack...

Satan

TECK 04-28-2002 11:13 AM

i try it.. it didn't work well on wooolF's live board, but it did ok on my local one.
so you recommend me to keep the query like this?
Code:

$forums=$DB_site->query('SELECT forum.*, thread.title AS threadtitle FROM forum LEFT JOIN thread ON (thread.forumid=forum.forumid AND thread.lastpost=(forum.lastpost-forum.daysprune)) WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder');
let me know please.

satan, it doesnt provide a link to the thread because it would add extra queries, wich is not recommended on a large board. i think the link to the latest post will do just fine. the title of the post is more informative, for the users to see what is going on in that forum.
let us know what you think.

Chris M 04-28-2002 11:19 AM

Ok will do...

I'll get back to you after I see how the guys like it...

Satan


All times are GMT. The time now is 06:14 AM.

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.01210 seconds
  • Memory Usage 1,732KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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