Auto Delete Move Threads After X Day

[HaMaDa4eVeR]

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!

[soulface]

OK this is what i was looking for. but is there any way that, i want to auto deleted thread of a specific forum. not all forum ? thx

[Quarterbore]

I would love to see this work on a per forum basis as well.

Also, any way to use this script to identify and transfer a post to an archive database before deleting?

[PHPGeek2k3]

bug in your uninstall protion of the product xml


$db->query_write("DELETE FROM ". TABLE_PREFIX." WHERE filename='./includes/cron/autodelete.php'");


should be


$db->query_write("DELETE FROM ". TABLE_PREFIX."cron WHERE filename='./includes/cron/autodelete.php'");


thanks
- James

[COBRAws]

I thought about something similar for my board, but im no coder, at least not a pro.

Im wondering if you can make something similar to a Move after X days hack but not for 0 replys thread.

let me know,
cheers

[HaMaDa4eVeR]

OK this is what i was looking for. but is there any way that, i want to auto deleted thread of a specific forum. not all forum ? thx
well, I'll include this option in the next version
thanks
I would love to see this work on a per forum basis as well.

Also, any way to use this script to identify and transfer a post to an archive database before deleting?
please explain more, I didn't get your point

PHPGeek2k3 : I'll fix it ,,thanks :)
I thought about something similar for my board, but im no coder, at least not a pro.

Im wondering if you can make something similar to a Move after X days hack but not for 0 replys thread.

let me know,
cheers
dear I'll provide to you the XML file can delete threads depending of days amount.
thanks all

[ahmed-samara]

thanks:up:

[COBRAws]

dear I'll provide to you the XML file can delete threads depending of days amount.
thanks all

Ummm, I was asking if you could make a hack based in what I ask. I already know what this Extension does. But in your PM you told me to write here...

[HaMaDa4eVeR]

Ummm, I was asking if you could make a hack based in what I ask. I already know what this Extension does. But in your PM you told me to write here...
check the attachment and upload the file to /includes/cron directory, now the hack will delete all threads after X day not zero post only, let me know if you need help.
ahmed-samara: :) thank you :rolleyes:

[alluidh]

Hope your next version for specific forum(s) will come soon, because I need it much :D

[COBRAws]

check the attachment and upload the file to /includes/cron directory, now the hack will delete all threads after X day not zero post only, let me know if you need help.
ahmed-samara: :) thank you :rolleyes:
Im really sorry for wasting your time :S What I ment, was that I was looking for a hack to automatically move any thread after X days, to a different forum.

Sorry Mohammed :S

[HaMaDa4eVeR]

Hope your next version for specific forum(s) will come soon, because I need it much

Currently I'm working on it, may I relase it 2moro

Im really sorry for wasting your time :S What I ment, was that I was looking for a hack to automatically move any thread after X days, to a different forum.

Sorry Mohammed :S
In the next version I'll include this option too,
not at all Jack, you're welcome :) and if you've more suggestions please feel free and put it here

[Quarterbore]

new version relased today get it here
https://vborg.vbsupport.ru/showthread.php?t=113748
thanks

Is that link correct? I get a no-permissions error :confused:

I would like to know if your new mod might work with an idea like this:

https://vborg.vbsupport.ru/showthread.php?t=114702?

I never got to explain what I was trying to do above so I started a new thread...

[COBRAws]

Is that link correct? I get a no-permissions error :confused:

I would like to know if your new mod might work with an idea like this:

https://vborg.vbsupport.ru/showthread.php?t=114702?

I never got to explain what I was trying to do above so I started a new thread...
I get the same.

[HaMaDa4eVeR]

Quarterbore and COBRAws I updated my hack today, feel free do install it and make sure that you read the new features
COBRAws thanks you again

[Developer]

Great update ;)

[COBRAws]

Quarterbore and COBRAws I updated my hack today, feel free do install it and make sure that you read the new features
COBRAws thanks you again
No, Thank you!

[coffee]

Thank you very much brother Hamada_For_Ever :)

Notes:
I had to edit line#3 of the file "product_autodeletemove.xml" to deactivate the script prior to installation.
Delete/Move after "x" days won't work! Unfotunatly it deleted/moved all threads from my test forum regardless of their date (some were created same day). So I simply updated it through editing line#20 in the file: "includes/cron/autodelete.php".

[elrafei]

thanks

[HaMaDa4eVeR]

Thank you very much brother Hamada_For_Ever :)

Notes:
I had to edit line#3 of the file "product_autodeletemove.xml" to deactivate the script prior to installation.
Delete/Move after "x" days won't work! Unfotunatly it deleted/moved all threads from my test forum regardless of their date (some were created same day). So I simply updated it through editing line#20 in the file: "includes/cron/autodelete.php".

sorry I did't get your changes, please explain more and give me the code that you had changed
thank u so much :)
elrafei thank you :)

[louis_chypher]

Thanks! Worked as advertised. I'm not using the delete functions, just the move.

Now for a "request". A forum pair setting for the move function. This way I can create seperate "archive" forums. The syntax for the setting could be "(X,Y)(X1,Y1)" where "()" designates the pairs, "X" is the souruce forum and "Y" is the destination forum. In this way I could 'archive' My forums into their respective archives without dumping all the forums into one archive forum.

[NilinHost]

WoW,
so nice
may allah bless you

**** installed :)

[Sculli]

Installed this hack, this is awesome, however, small problem that I may be able to fix on my own if someone could tell me how:


Fatal error: Maximum execution time of 30 seconds exceeded in /home/qcdnorg/public_html/includes/class_core.php on line 666


Error on line 666! Creepy!

Edit:
Also a suggestion, it would be nice if sticky threads were excluded from the move/delete. Or at least if there was an option to exclude stickies.

Edit2::
I think I figured it out. PHP problem, doesn't have anything to do with the hack.

[Sculli]

I have installed this and got it to work, but not quite as I expected, it moves threads that are not older than the 7 days that I specified, i.e. it moved a thread from today with zero replies.

I have a couple of questions:

If I were to remove
AND `replycount` = '0'
from autodelete.php, then it would also move threads that have replies, right?

If I were to set the zero in
$threadman->set('sticky', 0); to 1, then it would not move stickies?

[HaMaDa4eVeR]

I have installed this and got it to work, but not quite as I expected, it moves threads that are not older than the 7 days that I specified, i.e. it moved a thread from today with zero replies.

I have a couple of questions:

If I were to remove
AND `replycount` = '0'
from autodelete.php, then it would also move threads that have replies, right?

If I were to set the zero in
$threadman->set('sticky', 0); to 1, then it would not move stickies?
yes you're right

but not quite as I expected, it moves threads that are not older than the 7 days that I specified, i.e. it moved a thread from today with zero replies.
make sure you don't put zero in created date option
this is sql query :

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

thank you so much :)

[Losha]

Thanks dear for this hack , i`v been rated toy ,
Regards

[Slave]

If I were to remove

AND `replycount` = '0'

from autodelete.php, then it would also move threads that have replies, right?

Any chance you could make this an option within the acp?

[HaMaDa4eVeR]

Any chance you could make this an option within the acp?
in next version

thanks you :)

[KuJoe]

I can't figure out why this isn't working for me. I installed and set it up, but so far the schedule hasn't run and when I click on "Run Now" it says "Done" but I have threads in the "Effected Forum" that the created date is older than 30 days (what I have it set for). Also, according to my Scheduled Task logs this cron job has not run since I installed it 2 months ago. Any ideas? I'm going to try uninstalling it and reinstalling it to see if it fixes it, but has anybody else had this kind of trouble?

[KuJoe]

Negative, still not working.

[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]

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?https://vborg.vbsupport.ru/attachment.php?
attachmentid=47281&stc=1&thumb=1&d=
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/admincp/cronadmin.php?do=runcron&cronid=25
Referrer : http://www.americasarmy.pl/forum/admincp/cronadmin.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??

[SCRIPT3R]

are there still plans for an updated version... 3.6.x - or would you allow a port?

[HaMaDa4eVeR]

It didn't say in the readme file, but should I create a new scheduled task for this hack??
you don't need to add new scheduled task, Installation script will add it automatically.

are there still plans for an updated version... 3.6.x - or would you allow a port?
I'll port it soon

[SCRIPT3R]

I'll port it soon
thnx, looking forward to it. i was working on a port, but i haven't touched it in a few weeks and now i won't worry about it. i'm more interested in just the ability to move threads after however many days. i have a bit of discussion inside the coders forum if you want to read what's been discussed thus far. when you port, please secure the ability to just move threads without the post count coming into play.

[Derekclarke]

I have installed this today, however when i looked in the sheduled tasks, so i could run the script immediatly. I found their is no autodelete shedule.

I am using the Latest version of VB. not sure if their is an issue on this version.

please can you advise.

Thanks

[Rop]

Another vote here for a port to v3.6.4!

Looks like this would be exactly what I'm looking for: I have an RSS feed that auto-creates news articles pumped into a special forum as new threads. Those are then displayed on the portal through vBadvanced's 'news' module. This mod would help auto-delete all old news articles.

Suggestion: Add an option to leave sticky threads in place (or remove them, as set by the option).

Thanks HaMaDa4eVeR!

-Rob-

[vauge]

bump for 3.6.4 port request.

[tuanluu]

me too

[bts420]

I installed this in 3.6.4 (only version I have)

It wasn't working, it would delete all posts regardless of the number of days you specified in the options.

Modified autodelete.php

Changed
(".$vbulletin->options['created']." * 86400)
to
($vbulletin->options['created'] * 86400)

In 2 places within the PHP script.
I also had to manually setup the cron job. Not sure why thats not installing. Now the script works fine.

[SCRIPT3R]

I'll port it soon
is your port still going to happen? if so, can you give me an idea as to what "soon" means? thnx.
thnx, looking forward to it. i was working on a port, but i haven't touched it in a few weeks and now i won't worry about it. i'm more interested in just the ability to move threads after however many days. i have a bit of discussion inside the coders forum if you want to read what's been discussed thus far. when you port, please secure the ability to just move threads without the post count coming into play.

[stinger2]

another vote for porting this....thx

[HaMaDa4eVeR]

bump for 3.6.4 port request.
Here you can get it
https://vborg.vbsupport.ru/showthread.php?t=139646

[lostgirl815]

Is there any chance at all that this can be changed to delete threads that have posts? Instead of just the zero-post threads?

[fishhub]

Will this delete sticky threads which are more than X days to delete off normal threads?

[bartek24m]

i have a problem with useing this hack on my 3.6.10 PL3 version

when i try to run cron job manually

i can see

Auto Delete/Move Thread After X days

Fatal error: Existing data passed is not an array
Called set_existing in /includes/functions_databuild.php on line 200
Called build_forum_counters in /includes/cron/cronautodelete.php on line 45
Called include_once in /admincp/cronadmin.php on line 110
in /includes/class_dm.php on line 235

anyone know whats wrong with that /