How do I not include subforums in lastpostby?

[Ang]

I would like the "last post by" link on the main page of the forum to only link posts made in a 1st level forum, not its subforums. Is this possible?

[Xenon]

no it's not possible, without rewriting more scripts...

the lastpost is saved from within newreply.php
you can try to replace in newreply.php
this line:

PHP Code:

$DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid IN ($foruminfo[parentlist])"); 


with this one

PHP Code:

$DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid=$threadinfo[forumid]"); 


but i can't prove it'll work perfect

[Ang]

I tried that and it didn't seem to have any effect. Thank you though.

[Xenon]

it just have effect on new posts!

so leave it this way and test it with some new posts..

[Ang]

it just have effect on new posts!

so leave it this way and test it with some new posts..

That's what I did. I changed the code, uploaded it and made a new post in the subforum, and the new post showed up on the main forum page still.

[Xenon]

hmm, have you created a new thread?

just test it with new posts, for new thread you have to change newthread.php....

[Ang]

just test it with new posts, for new thread you have to change newthread.php....

Exactly what would I change in newthread? Also, thank you so far for your help.

[Xenon]

in newthread.php find:

PHP Code:

        $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid IN ($foruminfo[parentlist])"); 


change to:

PHP Code:

        $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost=IF(forumid=$forumid,'".time()."',lastpost),lastposter=IF(forumid=$forumid,'".addslashes($postusername)."',lastposter) WHERE forumid IN ($foruminfo[parentlist])"); 


also in newreply.php my mod is a bit wrong, use this one instead:

PHP Code:

$DB_site->query("UPDATE forum SET replycount=replycount+1,lastpost=IF(forumid=$threadinfo[forumid],'".time()."',lastpost),lastposter=IF(forumid=$threadinfo[forumid],'".addslashes($postusername)."',lastposter) WHERE forumid IN ($foruminfo[parentlist])");