Tachy goes to Coventry on Recent Threads

[sully02]

I am sure I'm not the only person who uses the "Tachy goes to Coventry" feature with vBulletin. However, the purpose of using it is somewhat defeated if said users's threads still show up on the front page of the CMPS.

Would it be possible to have this work with Tachy goes to Coventry?

[Brian]

This will be added in the next release. Unfortunatly though I don't think there's going to be a way to prevent the threads from being displayed when a tachy'd user was the last one to reply to the thread since vB does not store the last poster's userid in the threads table. It will not display any threads started by that user though.

[sully02]

That's perfectly fine. All I wanted was tachy'd user started threads off the recent threads list.

[ConqSoft]

Brian,

I don't know the details, but I think they have fixed the problem with the Tachy user showing up as the last poster in vBulletin itself. It might be something you can carry over to CMPS.

[Brian]

Do you know which version by chance? I'm still running 3.5.1 on my localhost and it shows tachy'd users as the last poster on the main forum page and the forumdisplay page.

[ConqSoft]

3.5.0

They don't show on mine... Unless the post was made before I added them to Tachy. (And a few Update Counters fixes those for me.)

[Brian]

Originally Posted by ConqSoft

Unless the post was made before I added them to Tachy. (And a few Update Counters fixes those for me.)

That's probably why it's showing up on my localhost. Thanks for pointing me in the right direction.

*Edit*

Yup, that's why it was still showing them as the last poster. Updated the thread counters and it seems to be working fine in the forums and CMPS now.

[kall]

I just got spammed...

Adding the User to Tachy caused the following sql error on my cmps:

Invalid SQL:

SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , voteoption
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 6)
WHERE open <> 10 AND visible = 1 AND active = 1
AND thread.dateline > 1139454722AND thread.postuserid NOT IN(1412)


AND thread.forumid NOT IN(23)
ORDER BY RAND() DESC;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'thread.postuserid NOT IN(1412)


AND thread.forumid NO

[kall]

Ahh. it was in currentpoll.php...

Changed

PHP Code:

iif($ignusers, 'AND thread.postuserid NOT IN(' . $ignusers . ')') . " 


to

PHP Code:

iif($ignusers, ' AND thread.postuserid NOT IN(' . $ignusers . ')') . " 


(added a space before AND)