Last post on forum home, working version

I had tried a version suggested by someone else instead of my own and well, all it did was send the load average up by about 10 times what it was.

This version inserts the last title into the forum database when it is updating the last post name and time. There is no difference in loading time as everything is called normally by vBulletin.

This works on 2.0.x and 2.2.x

Updated at 11:34 GMT on 28th September 2002

Thanks to floren for the latest update.

[bigmo]

OK THX...

My last question:

in which file at which position I must add/change the

PHP:

$trueperm['canview'] = $forumperms['canview'];

???

[Wayne2k1.com]

It doesn't work 4 me.



The hack works perfectly, but it shows last post for private forums, too...and that's baaaad.

[bigmo]

Yes I tested it vesterday (I changed the index.php und the forumdisplay.php) and it dont work for me too. The lastpost is still displayed at forums the user dont have the right to access...

Some other solutions ???

THX

[Harvey]

ok, here is an better but still untested!!! version.

It looks up, if a registered user can view a forum.
if Yes: put the title into the forum and the patents.
if No: put "(private message)" into the forum and the patents.

This design is because IMHO it is impossible to look up if the title is from a private subforum without doing a query.

First apply the changes from PPN
then my changes
then post dummy threads in the private forums.

Sorry for not testing, I currently have no testforum.

[Wayne2k1.com]

Doesn't work.

Invalid SQL: max(canview) as cveiw ,count(canview) as cnt from forumpermission where usergroupid=2 and forumid=5
mysql error: You have an error in your SQL syntax near 'max(canview) as cveiw ,count(canview) as cnt from forumpermission where usergrou' at line 1

That's the error.

[Harvey]

ups - forgotten "select "

Thank you

[Wayne2k1.com]

I guessed that...but I see you just noticed by yourself

It works...but it still gives an error in "Update Counters" --> "Forum Info"

SELECT max(canview) as cveiw ,count(canview) as cnt from forumpermission where usergroupid=2 and forumid=
mysql error: You have an error in your SQL syntax near '' at line 1

I think it's because from misc.php it doesn't have the

.$getchildforum[forumid]

variable.

[Harvey]

ok, I dont understand the reason for it (I don't think it's from misc.php). I have to create a test system, but this week I have no time.

[Scott MacVicar]

Harvey you decide if it should set the thread title if they can view it, what if they can't view the forum, why would they be posting in it

This is done in vBulletin 3 anyway, why can't you all just hide private forums within the general settings part of the admin panel.

[Harvey]

PPN, the actual problem is, if you have a privat subforum inside a nonprivate mainforum, everybody can see the the title in the mainforum, if the latest thread is in the private forum. No matter if you hide the private forum or not. You can see it, because it's the same with last time and last poster.

Sorry that my solution does not work yet, I tried it in theorie because I have currently not the time to test it. Perhaps with the hope, that I find a Betatester My boss wants that I install your hack, and we can live with the decision if a new post belongs to a thread a registered user may see or not.

I hope you can understand me, I can't translate your first sentence because of my terrible english. Perhaps I can learn by posting in your forum.

PS: Great hack.

[JTMON]

Parse error: parse error in /usr/local/plesk/apache/vhosts/whatthefrag.com/httpdocs/forums/admin/functions.php on line 1892

Fatal error: Call to undefined function: makelogincode() in /usr/local/plesk/apache/vhosts/whatthefrag.com/httpdocs/forums/global.php on line 337

I'm running 2.2.5. This happens when I upload functions with the changes

[infamous one]

ALTER TABLE `forum` ADD `lasttitle` VARCHAR(100) NOT NULL AFTER `lastposter`

How would I go about removing this from my table?

[Harvey]

alter table forum drop column lasttitle

[kms]

hi anybody tested this on v2.25 ?

TIA

[Wayne2k1.com]

Originally posted by kms
hi anybody tested this on v2.25 ?

TIA

Yep.

It works perfectly. (even the Omero sub-hack...look at it if you need to hide thread titles from private forums).

:laugh: