Administrative and Maintenance Tools - Expired Threads

Expired Threads

====================
Author: Ken 'LiveWire' Iovino
Site: www.initialz.com
Version: 1.1
====================

Updates

• Threads expired in days not seconds

Exitising Users Please Read
Open the file update_1.0_to_1.1.txt


WetWired Gets credit for the original idea, i saw this created on his forums long ago, and finaly decided to code it. and share with vBulletin.

What this does
This will allow you as the admin to set a time limit till a thread is considered expired. If the thread happens to be expired, the user will see a error message. But a staff member (ie, mod, sup-mod, and admin) can unexpire the thread by posting in it, then the counter will start over again. This will prevent those anoyying thread digger members we all seem to dislike.

This works as a per forum basis. You can turn on/off any forum you want.


To do list...

• Time to install: 5-10 minutes
• Queries to run: 1
• File Mods: 2
  • /admincp/forum.php
  • /forums/newreply.php
• Templates to edit: 0
• Templates to add: 0
• New Phrases: 4

Please read carefully and make all the necessary changes as stated. This is will work if installed properly.
PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN! If you like this hack

Click It

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here.

Please post bugs and errors here. Hope you like, feedback welcomed.

Special Thanks to:
-nexialys

[clearchannel]

I'd like to remove this hack. I installed this hack in VB 3.06 and am now receiving database errors. How do I remove the database quary?

database error.

Database error in vBulletin 3.0.6:

Invalid SQL: 
  SELECT 
  
  thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  , thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 12243)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(70,3,23,14,16,102,103,15,20,17,10,122,13,11,9,12,21,104,25,68,55,4,19,100,27,123,5,52,99,8,121,69,29,22,124,125,120,105,117,119,108,114,118,107,109,113,116,7,110,30,54,47,111,60,65,61,66,64,62,63,72,112,90,75,85,84,86,87,93,92,48,115,101,83,91,97,98,78,79,80,81,82,95,94,96,88,51,53,49,50,28,24,18,71,26,56,73,69,29,22,124,125) Array AND deletionlog.primaryid IS NULL 
ORDER BY lastpost DESC 
LIMIT 10

mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL 
ORDER BY lastpost DESC 
LIMIT 10
' at line 15

mysql error number: 1064

Date: Friday 11th of February 2005 08:49:58 AM
Script: http://www.yourdomain.com/
Referer: 
Username: anonymous
IP Address: xxx.x.xxx.xx

[Logikos]

Originally Posted by clearchannel

I'd like to remove this hack. I installed this hack in VB 3.06 and am now receiving database errors. How do I remove the database quary?

database error.

Database error in vBulletin 3.0.6:

Invalid SQL: 
  SELECT 
  
  thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  , thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 12243)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(70,3,23,14,16,102,103,15,20,17,10,122,13,11,9,12,21,104,25,68,55,4,19,100,27,123,5,52,99,8,121,69,29,22,124,125,120,105,117,119,108,114,118,107,109,113,116,7,110,30,54,47,111,60,65,61,66,64,62,63,72,112,90,75,85,84,86,87,93,92,48,115,101,83,91,97,98,78,79,80,81,82,95,94,96,88,51,53,49,50,28,24,18,71,26,56,73,69,29,22,124,125) Array AND deletionlog.primaryid IS NULL 
ORDER BY lastpost DESC 
LIMIT 10

mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL 
ORDER BY lastpost DESC 
LIMIT 10
' at line 15

mysql error number: 1064

Date: Friday 11th of February 2005 08:49:58 AM
Script: http://www.yourdomain.com/
Referer: 
Username: anonymous
IP Address: xxx.x.xxx.xx

That query error isn't caused by my hack.

[clearchannel]

Originally Posted by Live Wire

That query error isn't caused by my hack.

I'm not claiming it is. This is the only hack I installed before I started receiving the error messages.

I contacted support at vbulletin and was told they could not provide support with a hack installed.

I would like to uninstall this hack and see if I can duplicate the error. If I can duplicate the database error, I can go back to support at vbulletin, but first, I have to uninstall the hack.

I can make the file changes, I need help removing the table I added to the database in order to install this hack.

Thank you in advance.

[ThePimp]

Installed, and all I get is a blank screen when I go to Forum Manager.

[ThePimp]

Originally Posted by ThePimp

Installed, and all I get is a blank screen when I go to Forum Manager.

Nevermind, I fixed the problem. Your syntax was off, and you had a misspelling in your instructions with capitalization.

Anyhow, I installed this, and set the days to expire, as well as turned it on. However, it didn't seem to do anything. I set the expire time to be 7 days, and then went to the very first thread ever started (nearly 7 months ago) and could still reply.

Does anyone have an explaination for this?

[ThePimp]

Nevermind... as "Admin" you can still reply to old threads.

[007]

There is a pretty bad typo in the forums.php instructions. It should be:

PHP Code:

        print_input_row($vbphrase['how_many_days_till_expire'], 'forum[daysexpired]', $forum['daysexpired']); 


Other than that everything works fine.

[high]* 007 licks the install button! [/high]

[kobescoresagain]

Do you actually get to pick the thread that you want to expire or do you have to do it to all in a certain forum? Also how easy would it be to change it to a certain day. For instance, I would want it to expire on 3/1/06 Instead of having to figure out how many days it is until then (which would be an extreme hassel, I would like to just type in that date and it would show up expired on the beinging (or end) of that day?

[Logikos]

Originally Posted by kobescoresagain

Do you actually get to pick the thread that you want to expire or do you have to do it to all in a certain forum? Also how easy would it be to change it to a certain day. For instance, I would want it to expire on 3/1/06 Instead of having to figure out how many days it is until then (which would be an extreme hassel, I would like to just type in that date and it would show up expired on the beinging (or end) of that day?

No you can't pick which thread can expire on a certain date. This allows all threads in a certain fourm to expire after x days of no replies. If there is a thread that no has replied to for 90 days, chances are its done with and this hack is to stop thread diggers from bummping old threads.

[rjordan]

Originally Posted by Live Wire

No you can't pick which thread can expire on a certain date. This allows all threads in a certain fourm to expire after x days of no replies. If there is a thread that no has replied to for 90 days, chances are its done with and this hack is to stop thread diggers from bummping old threads.

Darn, I was hoping it would do this too. We post messages with time limits on responses, but not all and not all for the same time frame.