vb.org Archive - Auto Delete Move Threads After X Day

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Auto Delete Move Threads After X Day (https://vborg.vbsupport.ru/showthread.php?t=113324)

HaMaDa4eVeR

04-17-2006 10:00 PM

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!

soulface

04-18-2006 10:36 AM

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

04-18-2006 03:21 PM

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

04-18-2006 07:56 PM

bug in your uninstall protion of the product xml

Code:

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

should be

Code:

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

thanks
- James

COBRAws

04-18-2006 08:35 PM

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

04-19-2006 05:14 PM

Quote:

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

Quote:

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 :)

Quote:

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

04-19-2006 10:42 PM

thanks:up:

COBRAws

04-20-2006 01:40 AM

Quote:

Originally Posted by HaMaDa4eVeR

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

04-20-2006 08:15 AM

Quote:

Originally Posted by COBRAws

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

04-20-2006 12:16 PM

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

COBRAws

04-20-2006 07:06 PM

Quote:

Originally Posted by HaMaDa4eVeR

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

04-21-2006 03:03 PM

Quote:

Originally Posted by alluidh

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

Quote:

Originally Posted by COBRAws

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

05-03-2006 09:55 PM

Quote:

Originally Posted by HaMaDa4eVeR

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

05-03-2006 10:05 PM

Quote:

Originally Posted by Quarterbore

I get the same.

HaMaDa4eVeR

05-10-2006 03:03 PM

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

05-14-2006 12:23 PM

Great update ;)

COBRAws

05-19-2006 12:11 PM

Quote:

Originally Posted by 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

No, Thank you!

coffee

05-19-2006 11:43 PM

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

05-21-2006 01:45 PM

thanks

HaMaDa4eVeR

05-22-2006 12:19 PM

Quote:

Originally Posted by 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".

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

05-22-2006 01:57 PM

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

05-25-2006 12:07 PM

WoW,
so nice
may allah bless you

**** installed :)

Sculli

05-27-2006 02:52 AM

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:

Code:

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

05-29-2006 05:54 PM

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

Code:

AND `replycount` = '0'

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

If I were to set the zero in

Code:

$threadman->set('sticky', 0);

to 1, then it would not move stickies?

HaMaDa4eVeR

05-30-2006 09:08 AM

Quote:

Originally Posted by Sculli

Code:

AND `replycount` = '0'

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

If I were to set the zero in

Code:

$threadman->set('sticky', 0);

to 1, then it would not move stickies?

yes you're right

Quote:

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 :

PHP Code:


		
			
$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

06-19-2006 05:29 PM

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

Slave

06-21-2006 07:37 AM

Quote:

If I were to remove

Code:

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

06-24-2006 11:33 AM

Quote:

Originally Posted by Slave

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

in next version

thanks you :)

KuJoe

07-17-2006 08:57 PM

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

07-17-2006 10:00 PM

Negative, still not working.

TheProphet

07-18-2006 06:54 PM

Is this removing sticky threads aswell ?

Simplicity

08-03-2006 07:37 AM

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

08-19-2006 11:21 AM

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

08-19-2006 11:29 PM

Quote:

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

Code:

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

08-19-2006 11:40 PM

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

Code:

//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

08-27-2006 07:01 AM

Quote:

Is this removing sticky threads aswell ?

I think that

Quote:

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

08-27-2006 07:03 AM

Quote:

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

08-27-2006 07:05 AM

Good Jop, louis_chypher

Dj. Gargamel

10-10-2006 07:35 PM

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

10-13-2006 12:47 AM

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

All times are GMT. The time now is 06:02 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06595 seconds Memory Usage 1,866KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (10)bbcode_code_printable (1)bbcode_php_printable (20)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: