Administrative and Maintenance Tools - Auto Purge Threads

What does this hack do ?
This tool is based on Auto Delete/Move tool by HaMaDa4eVeR for vBulletin 3.6.4.

This hack can delete the threads that was created before X days in your specific forums or it can move threads to specific(Archive) through scheduled task.

Features:
Turn On the plugin
Turn On/Off Move system.
Turn On/Off Delete system.
Specific forums for move and delete.
Specific "Archive Forum".
Protected Users.
Delete Type (soft/hard).
Automatically update counters.
Choose to delete/move stickies.
Set how old must a thread be.
NO Code Modifications needed!

Installation:
1. Unzip the download package and copy the contents of the folder UPLOAD to your forum root
2. Go to the VB AdminCP->Plugins & Products click "Manage Products". Then click
"Add/Import Product" at the bottom of the page.
3. Click "Browse" button and point to the installation XML file included in this ZIP package.
4. Click "Import"
5. Once the gallery import is complete, you can setup your Auto Purge. Go to VB AdminCP -> Options -> Auto Purge Threads to setup the Auto Purge.
Also, you can change the cron setup in the task manager.

NOTE:
The default settings are:
- Soft delete for the threads that have been created before 15 days ago.
- Protected user that have id 1 & 2.
- It will running everyday at 5.00 AM.

Updates:

-------
v1.00
It is now vBulletin 4.x.x compatible.
Cron task added successfully. Removed some old SQL queries.
Removed the zero replies thread search.
Spanish translation added.

v1.01
You can set if you want to remove stickies.
If you move your threads, you can set if you want to unstick them if they are sticky.
XML tidied.

v1.02
You can set if you want to manually update your forum counters.
PHP tidied and optimized.

v1.03
Now you can move and/or delete different forums.
v1.03b
Fixed a MYSQL error.
v1.03c
Fixed a bug related to Protected users.

v1.04
Fixed a bug (thanks gocreate).
You can set if you want to remove locked threads.
You can set if you want to remove only threads without replies that match your other conditions.

v1.04b
Now you can protect some threads from moving/deletion.

v1.04d
Some bugs fixed.

v1.05
You can send PM when AutoPurge finish its work.

Next updates:
(sighs)

Special thanks to BirdOPrey5

Any donation?
I'm not begging but If you want, I would be glad to receive a small donation. There are 4.4 million unemployed in my country and It is hard to be employed.

[THX_Ultra]

Hi, I don't know why, but it seems that the Plugin does not work anymore since the 1.03b update.
Just for my understanding - If I want to move threads after 3 days from one forum to another.
I enter at "Thread must have been created earlier than X days." the number 3 - right?

So everything worked fine until I updated to 1.03b - now It doesn't move threads anymore, even If i start the cron job manually.

Do I have to completely uninstall the addon before updating, or is there anything I missed?

I'd appreciate your help, because the addon would be extremely helpful for me.

[Seductor]

It seems to be broken. However, it works If I run it manually.

The cron path seems to be right. The scheduled hour seems to be okay too.

@THX_Ultra could you help me? Go to Scheduled Tasks > Scheduled Task Log and check if there is any Auto Purge Threads action. I have one everyday at 5 AM. Do you have any?

Btw, I have edited the AutoPurge options, perhaps you should recheck them. Do you have Enable Plugin set to "yes" and Move threads and/or Delete threads to "yes" too?

@Trangalleiro: I have received your PM, however you have set you don't want to receive PMs. I can't answer you through private messaging.

[OldSchoolDSL]

This is the error I got on every version of this modification. The error happen only when I enabled this.

 Invalid SQL:
SELECT * from `thread`
                               Where  forumid  IN(2)
                               AND `postuserid` NOT IN ()
                               AND `dateline` <= '1323405149';

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 ')
                               AND `dateline` <= '1323405149'' at line 3

Disabling this resolved the issue.

[THX_Ultra]

Originally Posted by Seductor

@THX_Ultra could you help me? Go to Scheduled Tasks > Scheduled Task Log and check if there is any Auto Purge Threads action. I have one everyday at 5 AM. Do you have any?

Yes it is, but i switched back to 1.0.2 and everything works fine now. It was also working with 1.0.3 but since switching to the 1.0.3b it didn't...

One more thing - I realised that the field for protected users have to be filled with something, but for moving threads, I do not want to have any user protected. Can I enter 0 instead of eg. 1 or any other userid?
Does this affect the addon?

[Seductor]

Oh, @OldSchoolDSL, It is an easy error. I have never tought that Protected Users could be void. I will fix it but, meanwhile, have you seen any other bug?

Originally Posted by THX_Ultra

Yes it is, but i switched back to 4.0.2 and everything works fine now. It was also working with 4.0.3 but since switching to the 4.0.3b it didn't...

1.03 worked? That is odd, 1.03b only fixes a SQL sentence, but it is almost the same as 1.03. As OldSchoolDSL pointed, have you got Protected users void?

[OldSchoolDSL]

Originally Posted by Seductor

Oh, @OldSchoolDSL, It is an easy error. I have never tought that Protected Users could be void. I will fix it but, meanwhile, have you seen any other bug?



1.03 worked? That is odd, 1.03b only fixes a SQL sentence, but it is almost the same as 1.03. As OldSchoolDSL pointed, have you got Protected users void?

That's the thing. I didn't have any protected users. Wanted this mod to apply to all.

Because of the error, nothing ever happen... ie... The modification to my knowledge didn't work. I never did see the error on my screen, only got the e-mails about it.

[THX_Ultra]

Yes 1.03 worked fine - when I use 1.03b and leave everything unchanged - it doesnt. If i start it manually it just does not move threads.
I have one protected user, but i just use it because I get an error messag if I leave it blank.

[Seductor]

Now (1.03c) you can void Protected users.

I have changed the SQL sentences and now it is easier to edit the them. Now it works like:

		$query = "SELECT * from `" . TABLE_PREFIX . "thread` Where  forumid  IN($frommove) AND `dateline` <= '" . (TIMENOW - ($whencreated * 86400)) . "'";
		if(!$deletesticky)
		{
			$query .= " AND NOT `sticky`";
		}

		if(!empty($idadmin))
		{
			$query .= " AND `postuserid` NOT IN (".$idadmin.")";
		}

If you have not protected users, empty($idadmin) will be true and then the condition AND `postuserid` NOT IN ( ) will not be added. You will not have the SQL error because of it.

It seems to work for me. I have not Protected users and I don't want to move stickies. I have enabled the debug mode and it shows this:


So it seems to work perfectly.


FYI: 1.04 will have "Protected threads". I'm working on it.

[micro image]

Installing this, will report soon. GREAT mod, thank you!

[spillage]

Option request; Last post X days as move/delete criteria.