Auto Delete Move Threads After X Day

What does this hack do ?
This is second version of Auto Delete/Move Hacks, this hack can delete the zero post threads that was created before X days in your specific forums or it can move the zero post threads to specific(Archive) through scheduled task, by defualt delete the zero post every ten days, sure you can change the period as you want,
this is where the Auto Delete After X Days comes in handy!

Features:

• Turn On/Off system "All system".
• Turn On/Off Move system.
• Turn On/Off Delete system.
• Specific forums "this hack will work on this forums only".
• Specific forums " Archive Forums".
• Protected Users.
• Delete Type (soft/hard).
• Created days.
• NO Code Modifications needed!

Install instructions:

1- Upload the file to forum/includes/cron.
2- Import the Product XML file through your Admincp.
3- Enjoy.

NOTE:
Do not forget to review the hacks options in vBulletin options under "Auto Delete/Move After X Days " to set it as you want, the defualt setting are:-
- Soft delete for the threads that have zero replay and created before 30 days ago.
- protected user that have id 1 & 2.
- it will running every ten days.
- check the attachments.

History

• 19-04-2006 Fix Uninstallation bug.
• 22-04-2006 adding update counter for forums.
• 09-05-2006 version 2.0
  - Enable Hack to work in Specific forums.
  - Adding Move threads options with On/Off System.
  - Specific forums " Archive Forums".
  
  Features:.
  
  
  

that's all
Any questions, comments, suggestions, pleaes let me know

Enjoy!

[TheProphet]

Is this removing sticky threads aswell ?

[Simplicity]

How would I go about setting this hack up so that it moves a thread which has replies but not been active for 14 days?

[Simplicity]

Just to clarify, this moves a thread which has had no reply posts at all or moves a thread which has had replies but not for x days?

[louis_chypher]

Originally Posted by Simplicity

Just to clarify, this moves a thread which has had no reply posts at all or moves a thread which has had replies but not for x days?

The query is

SELECT * from `" . TABLE_PREFIX . "thread` 
						Where  forumid  =" . $forumid_from . " AND `postuserid` NOT IN (".$vbulletin->options['Admin'].") AND `dateline` <= '" . (TIMENOW - ( 45 * 86400)) . "'");

Which is a selection of threads that have not had any activity for, in the case of this query, 45 days. Those selected threads are the threads that are moved.

[louis_chypher]

I changed the move code, starting at line 11 to:

//comma delimited
$from=$vbulletin->options['forumids'];

// do not edit below
if ($vbulletin->options['automovemode'])
{

	//if $from is empty then do not continue 
	if (!(empty($from)))
	{ 
		$array_from=split(",",$from);
		
		//comma delimited 
		$to=$vbulletin->options['forumarchive']; //retrive the forum archive ID's								   
		$array_to=split(",",$to); //split the forum archive id on the ","
		$i=0;
		$arraycount=count($array_to); //get the count of the array 
		$default_to=$array_to[$i];	//place the first array item into storage
									//the first array item is the default forum id to use in case 
									//any forum id place hodler are blank 
		
		//do not do if $default_to is empty 
		if (!(empty($default_to)))
		{
		
			echo $to . " in if statement</ br>";
	
			foreach($array_from as $forumid_from) 
			{
	
				echo "retreiving forum info for forum: " . $forumid_from;
	
				//select a single forum ID to move
				$check=$vbulletin->db->query_read("
					SELECT * from `" . TABLE_PREFIX . "thread` 
						Where  forumid  =" . $forumid_from . " AND `postuserid` NOT IN (".$vbulletin->options['Admin'].") AND `dateline` <= '" . (TIMENOW - ( 45 * 86400)) . "'");			  
	

				while ($check2 = $vbulletin->db->fetch_array($check))
				{				
					require_once('./includes/functions_databuild.php');		
					$threadman=&datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost');
					$threadman->set_existing($check2);
					$threadman->set('forumid', $array_to[$i]);
					$threadman->set('sticky', 1);
					$threadman->save();
					build_forum_counters($check2['forumid']);
					if ($array_to[$i] == "")
						{build_forum_counters($default_to);}
					else
						{build_forum_counters($array_to[$i]);}
					echo "Auto Move Threads:<i>".$check2[title]."</a></i><br>";
					log_cron_action('Auto Move Threads', $nextitem);
				}

				//if only one archive place desired then do not increment forum_to index 	
				if ($arraycount > 1) 
				{$i +=1;}	
			}
		}	
	}
}

What I get with the code change is I can move multiple target forums to their own spicific destination forums.

Such as in the options for Effected Forums if I entered 1,2,3,4
and in Archive Forums I put 20,21,,21

Then forums 1 and 3 gets moved to forum 20 and forums 3 and 4 gets moved to forums 21

If I entered Effected Forums if I entered 1,2,3,4
and in Archive Forums I put 20 then all forums get moved into 20

enojoy!

[HaMaDa4eVeR]

Is this removing sticky threads aswell ?

I think that

How would I go about setting this hack up so that it moves a thread which has replies but not been active for 14 days?

[IMG]https://vborg.vbsupport.ru/attachment.php?
attachmentid=47281&stc=1&thumb=1&d=[/IMG]
it only move/delete in X days and the thread that have 0 post ,

[HaMaDa4eVeR]

Just to clarify, this moves a thread which has had no reply posts at all or moves a thread which has had replies but not for x days?

it move thereads has zero reply in X days ago

[HaMaDa4eVeR]

Good Jop, louis_chypher

[Dj. Gargamel]

when I am trying to use this mod manually though cp - cron (hard deletion settings) I am getting this error
Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM `vbulthread` Where forumid IN(96 , 97) AND `replycount` = '0' AND `postuserid` NOT IN () AND `dateline` <= '1160512459';

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` <= '1160512459'' at line 1
Error Number : 1064
Date : Tuesday, October 10th 2006 @ 10:34:19 PM
Script : http://www.americasarmy.pl/forum/adm...cron&cronid=25
Referrer : http://www.americasarmy.pl/forum/adm....php?do=modify
IP Address : xx.xx.xx.xx
Username : Dj. Gargamel
Classname : vb_database

using soft deletion is working correctly

[RidinHighSpeeds]

It didn't say in the readme file, but should I create a new scheduled task for this hack??