Auto Delete/Move Thread After X days

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


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

Enjoy!

[projectego]

Awesome! I think I might just have a use for this... ;)

* projectego clicks install

[COBRAws]

Is there a way so I can set the time I want for specific threads?

[SCRIPT3R]

Can you set this up without any delete options? i just want to have threads moved to a new section after however many days.

[FunaGuy]

Can u make it also for move closed thread after X days... ?

[HaMaDa4eVeR]

Is there a way so I can set the time I want for specific threads?
you can specific forum only,
Can you set this up without any delete options? i just want to have threads moved to a new section after however many days.
Can u make it also for move closed thread after X days... ?
https://vborg.vbsupport.ru/external/2007/02/15.jpg
sure you can
User the delete thread or move the read or the both

[SCRIPT3R]

suggestions... ;)

ok, so delete type will only correspond w/ Auto Delete Thread After X days; could you move the Delete Type menu selection to within the Auto Delete Thread After X days fieldset.

could you set this up for multiple forums/archives; ie: Effected Forums A = Archive Forum A & Effected Forums B = Archive Forum B and so forth?

[Barteken]

could you make it with inactive threads, because its kinda useless moving a thread that is still active. It should be handy that when a thread is inactive and X days old is moved to an archive forum...

Grtz

[FunaGuy]

you can specific forum only,


https://vborg.vbsupport.ru/attachment.php?attachmentid=60699&d=1171727246
sure you can
User the delete thread or move the read or the both

Its moved all unreplied threads to Archive :mad:

I mean to say I want Its Move all closed threads to Archive not Unreplied :(

[HaMaDa4eVeR]

suggestions...

ok, so delete type will only correspond w/ Auto Delete Thread After X days; could you move the Delete Type menu selection to within the Auto Delete Thread After X days fieldset.
OK, I'll do it in next relase,
now you all (effected forums) >>> (archive)

could you make it with inactive threads, because its kinda useless moving a thread that is still active. It should be handy that when a thread is inactive and X days old is moved to an archive forum...
to do that you should change the /cron/cronautodelete.php file in line 31 :
find:
AND `replycount` = '0'
just delete it and it will delete/move the threads that created before X days ago.
I mean to say I want Its Move all closed threads to Archive not Unreplied
It need small change in mysql query,
to do that you should change the /cron/cronautodelete.php file in line 31 :
find:
AND `replycount` = '0'
replace it with:
AND `open` = '0'
Best Regards

[powerbook]

This can be very handy. I was looking for something that will move all threads that have been replied to in one forum to another... :up:

EDIT: I can't tell you how much this hack (with 2 changes to the cron query) solved a big headache I had for very long time... Thanks

[telc]

Great add-on, could you add the option to and have it configurable on a per-forum basis?

Ignore Stickies [yes no]
Ignore Closed Threads [yes no]
Move threads where the last reply is atleast X days ago
Configurable on a Per-forum Basis ( so each forum can be configured different)

Smiliar to the options in the Prune and Threads section of Admincp.

[Forumi Shqiptar]

can you add a feture to delete all the posts that has been Soft' deleted by the moderators???

Many thanks in advance (very nice mod anyway i clicked install)

[taxick]

I cant get it to work..

It dont create any on "Scheduled Tasks"...

And it dont move any Thread....

Can you help me?

And plz post the Scheduled Task info... So i can add it manuel.

Thx

[HaMaDa4eVeR]

I cant get it to work..

It dont create any on "Scheduled Tasks"...

And it dont move any Thread....

Can you help me?

And plz post the Scheduled Task info... So i can add it manuel.

Thx
run this query in your forum database :
INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')
make sure that you've uploaded the file cronautodelete.php in ./includes/cron/cronautodelete.php

and It should be working now...

thanks all for your suggestions,and It will be done soon

[littlematts]

Dear HaMaDa4eVeR,

Thank a bunch for this beautiful mod i was always looking for. I will be lot greatful if you can help me on how to make this mod delete threads "after x days of inactivity". ie; the thread will be deleted after x days of no reply.

To be specific, our forum moderators send "junk" or "spam" to a forum named "thrash" and we need to make the "thrash bin forum" work with your script so as it will delete the threads in that "thrash forum" after X days a thread stays in thrash.

is it possible with a mod in this mod??

hopefully waiting for your reply

regards
Matthew

[HaMaDa4eVeR]

Dear HaMaDa4eVeR,

Thank a bunch for this beautiful mod i was always looking for. I will be lot greatful if you can help me on how to make this mod delete threads "after x days of inactivity". ie; the thread will be deleted after x days of no reply.

To be specific, our forum moderators send "junk" or "spam" to a forum named "thrash" and we need to make the "thrash bin forum" work with your script so as it will delete the threads in that "thrash forum" after X days a thread stays in thrash.

is it possible with a mod in this mod??

hopefully waiting for your reply

regards
Matthew
O.K
I'm ready to help you..
but the support for installed members only :)

[littlematts]

O.K
I'm ready to help you..
but the support for installed members only :)

Let me say sorry for the long break. I was in a hurry to change my work profile that made me lag to reply for your prompt help u offered.

I will be only happy to install the mod if it can be made compatible with the thread deletion rule mentioned.. only very happy to..

Pls do reply if you are keeping track mate.. I will be prompt for now on..

Thank you once agn and sorry for incon caused

regards
Matts

[cmwg]

I can?t seem to get the SQL Query to work...

This is the dump of the "cron" table:

CREATE TABLE `cron` (
`cronid` int(10) unsigned NOT NULL auto_increment,
`nextrun` int(10) unsigned NOT NULL default '0',
`weekday` smallint(6) NOT NULL default '0',
`day` smallint(6) NOT NULL default '0',
`hour` smallint(6) NOT NULL default '0',
`minute` varchar(100) NOT NULL default '',
`filename` varchar(50) NOT NULL default '',
`loglevel` smallint(6) NOT NULL default '0',
`active` smallint(6) NOT NULL default '1',
`varname` varchar(100) NOT NULL default '',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`cronid`),
UNIQUE KEY `varname` (`varname`),
KEY `nextrun` (`nextrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cron`
--


/*!40000 ALTER TABLE `cron` DISABLE KEYS */;
LOCK TABLES `cron` WRITE;
INSERT INTO `cron` VALUES (1,1179093660,-1,-1,0,'a:1:{i:0;i:1;}','./includes/cron/birthday.php',1,1,'birthday',1,'vbulletin'),(2,117 9014160,-1,-1,-1,'a:1:{i:0;i:56;}','./includes/cron/threadviews.php',0,1,'threadviews',1,'vbulletin'), (3,1179012300,-1,-1,-1,'a:1:{i:0;i:25;}','./includes/cron/promotion.php',1,1,'promotion',1,'vbulletin'),(4,1 179093720,-1,-1,0,'a:1:{i:0;i:2;}','./includes/cron/digestdaily.php',1,1,'digestdaily',1,'vbulletin'), (5,1179095400,1,-1,0,'a:1:{i:0;i:30;}','./includes/cron/digestweekly.php',1,1,'digestweekly',1,'vbulletin' ),(6,1179093720,-1,-1,0,'a:1:{i:0;i:2;}','./includes/cron/subscriptions.php',1,1,'subscriptions',1,'vbulleti n'),(7,1179014700,-1,-1,-1,'a:1:{i:0;i:5;}','./includes/cron/cleanup.php',0,1,'cleanup',1,'vbulletin'),(8,11790 11400,-1,-1,-1,'a:1:{i:0;i:10;}','./includes/cron/attachmentviews.php',0,1,'attachmentviews',1,'vbul letin'),(9,1179093780,-1,-1,0,'a:1:{i:0;i:3;}','./includes/cron/activate.php',1,1,'activate',1,'vbulletin'),(10,11 79011700,-1,-1,-1,'a:1:{i:0;i:15;}','./includes/cron/removebans.php',1,1,'removebans',1,'vbulletin'),(1 1,1179012000,-1,-1,-1,'a:1:{i:0;i:20;}','./includes/cron/cleanup2.php',0,1,'cleanup2',1,'vbulletin'),(12,11 79093600,-1,-1,0,'a:1:{i:0;i:0;}','./includes/cron/stats.php',0,1,'stats',1,'vbulletin'),(13,11790123 00,-1,-1,-1,'a:2:{i:0;i:25;i:1;i:55;}','./includes/cron/reminder.php',0,1,'reminder',1,'vbulletin'),(14,11 79094200,-1,-1,0,'a:1:{i:0;i:10;}','./includes/cron/dailycleanup.php',0,1,'dailycleanup',1,'vbulletin' ),(15,1179012000,-1,-1,-1,'a:2:{i:0;i:20;i:1;i:50;}','./includes/cron/infractions.php',1,1,'infractions',1,'vbulletin'), (16,1179011400,-1,-1,-1,'a:1:{i:0;i:10;}','./includes/cron/ccbill.php',1,1,'ccbill',1,'vbulletin'),(17,117901 1400,-1,-1,-1,'a:6:{i:0;i:0;i:1;i:10;i:2;i:20;i:3;i:30;i:4;i:4 0;i:5;i:50;}','./includes/cron/rssposter.php',1,1,'rssposter',1,'vbulletin'),(18, 1179093900,-1,-1,0,'a:1:{i:0;i:5;}','./includes/cron/birthdaythread.php',1,1,'Automatic Birthday Thread',1,'vbulletin');



I just get the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '" . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varna' at line 1


after editing the query to:

INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')


i then get the error:


An error occurred while attempting to execute your query. The following information was returned.
error number: 1136
error desc: Column count doesn't match value count at row 1


what is wrong?

[louis_chypher]

CREATE TABLE `cron` (

table prefix?

The table prefix I use is "vb_"

thus I use

CREATE TABLE `vb_cron` (

*shrug*




INSERT INTO cron
(field1,field2,field3,...)
VALUES
(-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

see http://dev.mysql.com/doc/refman/5.0/en/insert.html for the proper syntax for the INSERT statement.

[Eagle Creek]

Very cool!
Any chance it will be supported (I ask because of the new vb-versions)?

1. Does it only work with 0 posts?
2. Do I have to make the cron myself?

[HaMaDa4eVeR]

1. Does it only work with 0 posts?
you can custom it :)
as you wish, just edit the attached file forum/includes/cron

[tandy]

INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

Give me

#1064 - Erreur de syntaxe pr賠de '" . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,logle' ࠬa ligne 1

[patrickstar]

very nice, will it work with 3.6.7?

does the timer start when the thread was created or when the last post was made?

[adc-arab]

thx alot ^^ but i don'est add any cron job in v 3.6.7 pl1 >.>

how can i add it manually without running sql Query

[TigerWare]

run this query in your forum database :
INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')
make sure that you've uploaded the file cronautodelete.php in ./includes/cron/cronautodelete.php

and It should be working now...


If I may, I'd like to point out that this SQL does not look right though I'm no expert.
(weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

There is an additional bracket after the column list.
The number of quoted columns (Ten) does not mach the number of values (Seven).
To me it looks like there are missing values for column active, varname and volatile.

I have no scheduled task in either 3.6.4 (mine) or on a 3.6.7PL1 (which I am co-admin).

Sorry if I'm being thick, but the SQL on the install code just doesn't look correct.

:confused:

[voclain]

Quick questions...I'm just about to install this...I will have it up in a few minutes.

But....what I want to know is once it's installed...and I have applied it to my specific forum that I want to apply it to.

WILL it then do the action to everything that is CURRENTLY in that FORUM??? or will it only do it to NEW THREADS/POST that come in AFTER the Hack is installed???

JUST WONDERING???

Kirk

[HaMaDa4eVeR]

thx alot ^^ but i don'est add any cron job in v 3.6.7 pl1 >.>

how can i add it manually without running sql Query
INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days');


INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

Give me

#1064 - Erreur de syntaxe pr賠de '" . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,logle' ࠬa ligne 1
try this:
INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days');
very nice, will it work with 3.6.7?

does the timer start when the thread was created or when the last post was made?
revire the mod. options, it will do it
Quick questions...I'm just about to install this...I will have it up in a few minutes.

But....what I want to know is once it's installed...and I have applied it to my specific forum that I want to apply it to.

WILL it then do the action to everything that is CURRENTLY in that FORUM??? or will it only do it to NEW THREADS/POST that come in AFTER the Hack is installed???

JUST WONDERING???

Kirk

he will work on the both :)
old/new topics

[luckid]

Tnx Good PlugIn:cool:

[voclain]

INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days');



try this:
INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days');

revire the mod. options, it will do it


he will work on the both :)
old/new topics



I did what you said here...and this is the message I got after running it:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1136
error desc: Column count doesn't match value count at row 1

Any suggestions????

Kirk

[voclain]

I got the SCHEDULED TASK situation fixed.....I read in post number: 10 the following:


could you make it with inactive threads, because its kinda useless moving a thread that is still active. It should be handy that when a thread is inactive and X days old is moved to an archive forum...

to do that you should change the /cron/cronautodelete.php file in line 31 :
find:


AND `replycount` = '0'
just delete it and it will delete/move the threads that created before X days ago.

==========

I did this and it only deleted threads that had ZERO posts in them.

What I want this to do is this.....

I have a forum where my members SELL stuff....and usually after 30 days...the stuff they are selling is OLD, SOLD, or they are not going to sell it.

So...I want all threads...and all posts....that are more than 30 days old to just be deleted...every night.....is that want this will do for me?

I have done what you suggested above...but it again....only deleted threads that had ZERO posts.

HELP!!!

Kirk

[AzzidReign]

How did you get the cron to work? I'm still having problems with it.

[voclain]

All I did was make a NEW SCHEDULED TASK and had it point to .php file that I uploaded into the "CRON" folder.

Just like that...it works.

But....I seriously, seriously, SERIOUSLY need to get this working so that it DELETES ALL threads....older than 35 days....even the ones that have posts to them....JUST like you do in the "PRUNE" section manually.

Kirk

[AzzidReign]

I think you put back what you deleted.
AND `replycount` = '0'

That seemed to work for me. I was testing it with moving the threads and it moved the threads with replies in it...but I didn't check to see if the reply date was x days old.

[voclain]

I think you put back what you deleted.
AND `replycount` = '0'

That seemed to work for me. I was testing it with moving the threads and it moved the threads with replies in it...but I didn't check to see if the reply date was x days old.
Azz:

I did not TEST to see if it work on MOVING THEM??? HUM??? That could be the answer??? All I did was test to see if it would work on me DELETING them...

I'm off to test that.

Kirk

[voclain]

I think you put back what you deleted.
AND `replycount` = '0'

That seemed to work for me. I was testing it with moving the threads and it moved the threads with replies in it...but I didn't check to see if the reply date was x days old.
Azz!!!!!!!

Thank you, THANK YOU!!!!

That did it...I had the "AUTO MOVE" feature OFF....and when I removed the "AND 'replycount' = '0' command....it did not apply to "DELETING"...only MOVING.

Which I can make work. I just set up a dummy forum....made it so nobody can see in it...and I'll just DELETE from it every now and then....EASY!!!!

Thank you, thank you thank you!!!!!

I vote that this be the best HaCK ever!

Kirk

[AzzidReign]

Your welcome! :)

That's what I've done...I've set up a "recycle bin" that I'll manually prune. I just got done pruning over 10k THREADS! It's almost like giving lipo to someone who weighed 300 lbs and now weighs 100 lol j/p But the site is loading much quicker now :)

[paulo_b]

After install I ran the Task manager and get this error message...
Invalid SQL:
SELECT * FROM `vbthread` Where forumid IN(11,40,25,29,12,17,27,15,22,18,30,26,19,44,24,23 ,28,20,) AND `replycount` = '0' AND `postuserid` NOT IN (1,2) AND `dateline` <= '1190175911';

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 `replycount` = '0' AND `postuserid` NOT IN (1,2) AND `da
Error Number : 1064

I have no idea what this means, please help

[paulo_b]

Anyone home??

[paulo_b]

I removed te trailing comma, 20,), that was the problem, seems to work now.

[AtoZ]

All I did was make a NEW SCHEDULED TASK and had it point to .php file that I uploaded into the "CRON" folder.

Just like that...it works.

Thank you for pointing this out. I wanted to emphasize it here in case anyone else is having trouble getting this set up. It was easy to overlook this important piece of information that you provided! All of the previous posts with the SQL code has incorrect syntax. :down:

Other than that, I think I am going to LOVE this plugin! I changed the replycount to > 59, so once a thread gets more than 59 posts, it will automatically be moved to my forum for long threads and debates. I am using another plugin (https://vborg.vbsupport.ru/showthread.php?t=130738) that will automatically close those threads to further posting. It's an awesome combo!

[Doctor Death]

Have been looking for something like this for several years. Looking forward to installing it.

Update: It is installed... I want it set up to delete a specific forum (#28) with any posts older than 7 days.

I did NOT see a chron job installed with this, although I might have missed it. Other than putting in the product and the configuration via CP, do I need to do anything else to have it delete threads older than 7 days routinely?

The Options in ADMINCP are not that intuitive...

Have it set currently to:


Turn on the (Auto Delete/Move Thread After X days) system "All Systems". NO
Turn on the (Auto Delete Thread After X days) system. YES
Please enter the user id that you don't want to delete there threads, Admins or Mods, comma seperated. 4
Turn on the (Auto Move Thread After X days) system. YES
Please enter the forum id that you want to apply this hack on it , comma seperated. 28
Please enter the forum id that you want set as archive . 28 (Although I dont want an archive)
Choose YES for physical delete and NO for soft delete YES
Thread must have been created earlier than X days. 7






Thanks!

[KuJoe]

I just finished installing this on my test board and I had to manually enter the Scheduled Task (set to run once a day) but as of now it is working perfectly. The only change I had to make was:
AND `replycount` = '0'
to
AND `replycount` > '0'
So it would leave all posts with 0 replies (mainly stickies) and would archive all posts with replies. This is perfect for my "Introduction" forum since after 30 days, a members tends to not be new anymore. :D

[R1D1]

as it seems, the cron-thing doesn't work. so i will drop it on standby the next weeks... perhaps the problem will be solved till then? :) would be wonderful... its a great mod-idea! thx.

[AtoZ]

as it seems, the cron-thing doesn't work. so i will drop it on standby the next weeks... perhaps the problem will be solved till then? :) would be wonderful... its a great mod-idea! thx.

This is the solution...

Originally Posted by voclain
All I did was make a NEW SCHEDULED TASK and had it point to .php file that I uploaded into the "CRON" folder.

Just like that...it works.

[R1D1]

fascinating! :D thx ;)

perhaps worth enoug to give it a short quote at the thread's startpost? ;)

[rammbs]

need help please. i get the error below when i run the scheduled task..


Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM `thread` Where forumid IN(23) AND `replycount` = '0' AND `postuserid` NOT IN () AND `dateline` <= '1194024543';

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` <= '1194024543'' at line 1
Error Number : 1064


i ran the query below too :

INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days');

[ETDC]

Does this work with 3.6.8 Patch Level 2?

:)

[TigerWare]

Does this work with 3.6.8 Patch Level 2?

If you have it running on 3.6.8 already, then yup, PL1/PL2 is fine.

[ETDC]

I don't have it installed yet.

[TigerWare]

I had some trouble with the install, as have a few others. See my post 27 (https://vborg.vbsupport.ru/showpost.php?p=1292135&postcount=27) note. I don't think the author has ever come back with an answer, or an update to this one that does keep popping up. I had to create the CRON job by hand for this mod to work. As it stands, once the CRON job is set, it runs beautifully.

[thepub]

how do you create the CRON job by hand? I'd like to install this on my forum but am not sure I understand what needs to be done to make it work properly.

[zappan]

i can report strange behavior when hard delete used... server hangs..

i modified queries in the php file to match my wanted settings (not stickies and filter by last post time, instead of date created), soft delete works, physical delete hangs the httpd process. strange.

[AWJunkies]

Works on 3.6.8 P2 when you create the task yourself cause he programed it all wrong for it to auto install.

[REVHEAD]

Any news on this updated cron or whatever you guys are talking about? I am not a coder and have just installed a rss feeder to my forums and would like this to work on 3.6.8.

Help appreciated

[fta2k]

Installed...

Super simple, thanks allot

https://vborg.vbsupport.ru/external/2008/02/4.jpg

[DieselMinded]

Can this be made to Close threads in my support forum if no reply in 10 days ?

[majordork82]

i'm having the same issue as someone above and I have NO idea how to fix it....Here is what it says when i go to run the scheduled task that I created:

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` <= '1206141687'' at line 2
Error Number : 1064

[majordork82]

nevermind, i figured it out. The program doesn't like it if you leave the protected users blank

[furnival]

Installed and added the cron via scheduled task manager.

Would prefer excluded user groups feature to just excluded user ids, but all in all a great hack. Thank you!

[AtoZ]

Anyone have this working in 3.7 or are there plans to update? Thanks.

[futuredood]

Works on 3.6.8 P2 when you create the task yourself cause he programed it all wrong for it to auto install.

Hi can you tell us more about how to get this to work, or where you found the answer? I installed it and need to know how to set up the cron job. Thanks.

[AtoZ]

futuredood, read back through the thread and you'll find the solution.

All I did was make a NEW SCHEDULED TASK and had it point to .php file that I uploaded into the "CRON" folder.

[tekguru]

Working for me on vB 3.7.1PL2. All I needed to do was set up the CRON job and modify the cronautodelete.php setting from `replycount` = '0' to `replycount` >= '0' and it now archives my 'News' into 'Old News' - superb!

[AtoZ]

Working for me on vB 3.7.1PL2. All I needed to do was set up the CRON job and modify the cronautodelete.php setting from `replycount` = '0' to `replycount` >= '0' and it now archives my 'News' into 'Old News' - superb!

Excellent. Thanks for the info!

[StreetTriple]

hi there,
i've 3,6,8 patch level 2 and the mod not function...
i've tryed to run this query in mysql:
INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After per days')

but i've received this error:

query SQL:
INSERT INTO forum_vbcron( weekday,
DAY , HOUR , minute, filename, loglevel, active, varname, volatile, product )
VALUES ( -1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After per days'
)
Messaggio di MySQL:
#1136 - Column count doesn't match value count at row 1

PLEASE HELP ME!

[RayJohns]

Very handy, thanks. A couple of notes about installation. I'm running on 3.7.3 PL1. I moved the files to the proper locations, and imported the XML. However, I had to manually add a cron job in order to get it working. It appears there is install code in the package to install a cron job, but I don't think it worked (at least not on my vb). I could be wrong, but after uploading the .php file and importing the XML, I did not see a scheduled task listed in the cron job section.

For anyone who has the same problem, here is how I setup my cron job (see attached).

Also, I wanted to point out that because the PHP code uses 86,400 (the number of seconds in a full day) as a multiplier when figuring out how old the threads are, you can actually specify something like .5 days if you want to delete/move threads every 12 hours. Or you could use .25 to delete threads every 6 hours for example. I was just about to hack the code to do this, because I needed to remove threads (once a day) that were older than 12 hours. However, since the code uses the # of seconds to figure it out, you can fine tune the time frame using a fractional value for the number of days in the settings. Very handy!

Nice job on the product - I just clicked the "installed" button for you :-)

Ray

[M.C.]

Thanks, Ray! I had same problem on 3.8 and after addin cron job manually it seems it working... ;)

[xlguy]

So this is working ok in 3.8 then?

[BlueNinjaGo]

Nvm

[R1lover]

can we get this fixed / ported to 3.8.2 please

[KevinL]

It works fine on 3.8

[Allen]

Is there anything like this hack but for posts?

I want users to have an option to auto delete their post after a set (by them or Admin) period of time.

[kyle]

Can this hack be setup to move/delete thread if the original poster doesn’t respond within a x amount of time?

[xlguy]

need help please. i get the error below when i run the scheduled task..

nevermind, i figured it out. The program doesn't like it if you leave the protected users blank

Ah interesting, thanks. I was getting an error in 3.8.x and think it might because I left out any input in the protected users part.

[danyz81]

mmmh not working for me.
I've 3.84. Created the cron manually with the modific by AtoZ (`replycount` = '0' to `replycount` >= '0' ) but nothing.
I try to run the cron, straight afterwards it tells me "Done" but nothing happends on the forum.

Any help?

[tonyzhou]

I have modified this hack to exclude stickies and to delete threads that haven't gotten replies in X days rather than ones that have been opened x days ago. It also disregards the amount of posts in that thread.

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

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


these are the modifications to the queries for anyone who needs this as well.

[Reef Man]

Does this work on vb 4.0.x ???

[MagicThemeParks]

Just to confirm: Do you have to add the manual cron to get this work?

[HolyKiller]

Does this work on vb 4.0.x ???

Same question ... anyone tryed this on vB 4.0.x ? (4.0.8 for me..)

[AshleyTwo]

When it states which forum it is applied to is that for Delete AND Move, or just Move? Its location in the settings makes it seem like its just for Move but wanted to check.

Thanks.

[Markos]

i have it on my 4.0.8 and seams to work fine

[Markco]

Please update for VB 4.1x
Thank you.

[Seductor]

Hello, I have updated this mod for vB 4.x.x

I'm supporting and improving it here:
https://vborg.vbsupport.ru/showthread.php?p=2276596

[Easy5s.net]

I want after the user buys the theme topics are moved to their previous position