![]() |
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. |
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 |
thanks PPN. :) i'm curious to find out the results.
|
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 |
BTW what's the purpose of this code?
Code:
(forum.lastpost-forum.daysprune) |
firefly, i tried this:
PHP Code:
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. |
Using = is just fine.
|
@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 |
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'); 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. |
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|