![]() |
subject of last post???
1 Attachment(s)
Hi there
Im looking for subject of last post, but i cant search it, please help me i can where do i get thread??? the same attachment thanks for your help :chinese: |
I have make some changes of this hack,
Thanks for Firefly's idea. It's work better now.. I have test this new ver on my board. http://www.kelvinlo.net/vbb/ Before --> 88 queries Now --> 33 queries Step 1: Change index.php & forumdisplay.php Find this code in BOTH files: PHP Code:
PHP Code:
Change the templates forumhome_lastpostby: found this code: PHP Code:
PHP Code:
|
Just thought you should know this will add *4* queries for every forum you have...
|
heh, yes it make more queries..
It specialy takes heavy queries on the index.. Page generated in 0.7211850 seconds (15.79% PHP - 84.21% MySQL) with 87 queries. |
Then why use it? And you have 4 queries there that can be done with only one:
Code:
$lastpostinfo = $DB_site->query_first(" |
Thanks Firefly, I have make a little change of that code now.. wish it work better. I am going to test it on my board tonight, I have this hack work on my test board :squareeyed:
Current know problem: It will show the thread title from the private forums if you turn your private forum visible to others. |
PPN already released a hack that does this with no extra queries, it just stores the last thread title in the forum table.
|
Can you post the link here?
|
Look at PPN's profile, you can find it there.
|
Thanks! I got it now :classic:
|
All times are GMT. The time now is 01:41 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:
|