vb.org Archive - Administrative and Maintenance Tools

Page 1 of 2

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

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - Auto Purge Threads (https://vborg.vbsupport.ru/showthread.php?t=275314)

Seductor

12-09-2011 11:00 PM

Auto Purge Threads

1 Attachment(s)

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

Any donation?https://vborg.vbsupport.ru/external/2011/12/12.gif
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.

karlm

12-11-2011 12:12 AM

looks good... will look into it shortly :)

mitch84

12-11-2011 07:13 AM

nice idea!

Seductor

12-11-2011 02:21 PM

Any suggestion?

THX_Ultra

01-01-2012 07:59 PM

Great! This is EXACTLY what I was searching for - a cron job that automatically moves threads from one subforum to another after a certain period of time! ;)

kingMOB

01-01-2012 10:06 PM

Nice idea =)

Could be an option to mark threads to be auto purged? So after some days from the creation date the thread would be moved to another forum?

OldSchoolDSL

01-01-2012 11:33 PM

Wonderful.

I have a forum that is dedicated for "post testing". So as you can expect it fills with junk. This will be a good way to clear this out.

Seductor

01-02-2012 11:41 AM

Quote:

Originally Posted by kingMOB (Post 2282898)

Nice idea =)

Could be an option to mark threads to be auto purged? So after some days from the creation date the thread would be moved to another forum?

Do you mean to mark them manually? I do not think it could be possible at the moment. It would require to add a lot of code, but I'll keep it in mind.

OldSchoolDSL

01-02-2012 05:25 PM

Quote:

Originally Posted by OldSchoolDSL (Post 2282912)

Wonderful.

I have a forum that is dedicated for "post testing". So as you can expect it fills with junk. This will be a good way to clear this out.

Working in 4.1.10 Alpha 2

Request: In a future version, can you please have it so I can ID more than 1 forum with more than 1 function?

That is to say, I'd like this to delete everything in forum "X" (the forum people use to test post), but move other post from from Y,W,Z into an archive forum.

As it stands now, I can only do one or the other and not both.

Seductor

01-05-2012 12:54 PM

@OldSchoolDSL, I think you are able to do it now. Please, If you find any bug, report it and I'll fix it.

@Seductor (autonote): Remove only threads without replies.

1.0.3b released: I have fixed a MYSQL error. Sorry guys, it was a silly mistake.

THX_Ultra

01-08-2012 09:36 AM

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

01-09-2012 05:16 PM

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

01-09-2012 05:52 PM

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

Code:

 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

01-09-2012 06:42 PM

Quote:

Originally Posted by Seductor (Post 2285587)

@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

01-09-2012 06:43 PM

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?

Quote:

Originally Posted by THX_Ultra (Post 2285633)

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

01-09-2012 06:56 PM

Quote:

Originally Posted by Seductor (Post 2285635)

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

01-09-2012 07:02 PM

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

01-09-2012 10:28 PM

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:

Code:

                $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:
https://vborg.vbsupport.ru/external/2012/01/57.png

So it seems to work perfectly.

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

micro image

01-31-2012 07:32 PM

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

spillage

02-01-2012 01:34 AM

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

GrabMyWrist

02-01-2012 04:06 PM

Option request; Move locked threads to specified forum or delete.

Fuzzy Orange

02-19-2012 09:24 AM

Quote:

Originally Posted by spillage (Post 2294829)

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

I'd love this as well - it's nice to be able to delete all my for sale threads after 90 days, but it would be nicer to delete them when they've not had a reply in 30 days :)

Seductor

02-19-2012 11:45 AM

I was trying to rebuil all the whole system, but taking in cout the many request you are writing, perhaps I should focus on them.

ludachris

03-13-2012 07:11 PM

Any chance this mod would work in 3.8.x?

Seductor

03-13-2012 08:07 PM

Quote:

Originally Posted by ludachris (Post 2309163)

Any chance this mod would work in 3.8.x?

I think it could work properly in 3.8.X, but I didn't test it.

copjend

03-17-2012 06:52 AM

I tried to install in my vBulletin 4.1.7 Patch Level 2, but is not working

Seductor

03-17-2012 12:21 PM

Quote:

Originally Posted by copjend (Post 2310325)

I tried to install in my vBulletin 4.1.7 Patch Level 2, but is not working

Did you get any error?

gocreate

04-10-2012 07:43 AM

There is a small error in script:

PHP Code:


		
			

    $fromdelete = $vbulletin->options['forudelete'];

Schould be:

PHP Code:


		
			
$fromdelete = $vbulletin->options['forumdelete'];

Seductor

04-10-2012 08:52 AM

Thanks gocreate! I'm going to fix it.

Seductor

04-10-2012 09:48 AM

I've add some features and I've fixed the forumdelete bug. Thanks again, gocreate.

NOTE: Please, don't upgrade it yet, I've found some small bugs. I'm going to fix them when I'm back at home

Trangalleiro

04-10-2012 10:31 AM

Thanks Seductor

Seductor

04-10-2012 02:20 PM

Fixed and added a new feature.

/me waves at Trangalleiro

sweetpotato

04-16-2012 06:18 AM

Installed and waiting to see it working. Can you add an option to move moderated thread also?
Thanks,

Seductor

04-16-2012 02:44 PM

Quote:

Originally Posted by sweetpotato (Post 2320536)

Installed and waiting to see it working. Can you add an option to move moderated thread also?
Thanks,

Sure I will add it in the next release.

Hostboard

04-30-2012 11:17 PM

Request: Some sort of log file to show from, to and how many threads were moved/deleted and make it searchable say by date via the ACP. OR even simpler a PM or email notification at the least.

Seductor

05-01-2012 07:43 AM

Quote:

Originally Posted by Hostboard (Post 2325062)

Request: Some sort of log file to show from, to and how many threads were moved/deleted and make it searchable say by date via the ACP. OR even simpler a PM or email notification at the least.

It is a good idea. Meanwhile, you can use the debug mode set in the php file.

sweetpotato

05-08-2012 01:32 AM

It seems not work on my site. Do I have more config please?
Error:

Quote:

Database error in vBulletin 4.1.12:

Invalid SQL:
SELECT * from `thread` Where forumid IN(34,39,43) AND `dateline` <= '1333852516' AND NOT `sticky` AND `replycount` = 0 AND `postuserid` NOT IN (1,82,4461,7269) AND `threadid` NOT IN ();

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 ')' at line 1
Error Number : 1064
Request Date : Monday, May 7th 2012 @ 07:35:16 PM
Error Date : Monday, May 7th 2012 @ 07:35:18 PM
Script : cronadmin.php?do=runcron&cronid=214
Referrer : /cronadmin.php?do=modify

Classname : vB_Database
MySQL Version : 5.0.92-log

Seductor

05-14-2012 09:26 AM

Quote:

Originally Posted by sweetpotato (Post 2327215)

It seems not work on my site. Do I have more config please?
Error:

Sweetpotato, update your plugin to the latest version, I have done some fixes.

sweetpotato

05-14-2012 03:05 PM

Just updated, run the task and see no error. I would be nice if you could add protected user groups.
Thanks,

Easy5s.net

05-18-2012 02:55 AM

I'm using with this mod
https://vborg.vbsupport.ru/showthread.php?t=116605
and I want after the user buys the theme topics are moved to their previous position.

All times are GMT. The time now is 06:21 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.01441 seconds Memory Usage 1,839KB 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 (2)bbcode_code_printable (2)bbcode_php_printable (12)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: