WordPress MU

Is there a way to have WPMU clean up bloggs that havent had any activity for a month or so? I know its probably just a simple php script (wish I knew what it was). Its just a nice way to remove all those blogs people have setup to test your blogging website.

Well, the following suggestion isn't automated, but it is a feature I overlooked (what with all the menu options to pick from I got distracted).

Along the top of the list of blogs there are headings:
ID Blog Name Last Updated Registered

I finally noticed they are clickable and you can sort the list by each option. *blushes* So I could quickly check on never-updated blogs without having to scan the list.

Or maybe everyone else already saw it and I'm just revealing how dense I can be ocasionally. ;)

To delete entries in the database automatically, you would need to set up a cronjob. PHP in itself can not be automated to run scripts at say a weekly basis.

If you do not want to delete those blogs by hand, you should either set up a cronjob or program a PHP script that will do the thing for you (and you would have to run it manually).

andrea you have been dreamy? Just pullin ya leg.

Anyway when i sort Users under Site Admin > Blogs

I get a SQL error.

WordPress database 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 'ASC LIMIT 0, 60' at line 3]
SELECT * FROM wp_blogs WHERE site_id = '1' ASC LIMIT 0, 60

Anyone has that problem?

:D Lemme check.... yep, I get the same error. Also, when I click on 'actions" All other sort-by options worked though.

I think you need an ORDER BY in there for limit to work.

Then that would be a bug in the code itself.

Agreed but wouldn't it be cool up submit the fix yourself to them? :)

Touche. :D

(brain fuzzies today)

That's fine. I know others do like the idea of getting in there and working with the code. I'm just used to it.

-dr(Sitting here trying to convert the phpBB Aqua theme over)mike

Rather than setting it up as a cron job (dont know how :) ) couldnt it be added to each admin page, or possibly the updade site (or a new page) so it would run when you accessed the page? ie, another button on the site admin page that would run the php script required to delete the inactive blogs.

Yeah! I found a buggy... Thanks for verification andrea. Anyone submitted the bug?

Maybe we should start working on the php script first to delete inactive blogs. What say you guys?

Sounds good :) if only I could programme php :) I have to rely on all the nice programmers out there to do all the work - Thanks Guys ! You know who you are :)

I logged an feature request - please second it if you agree (any additional features appreciated)!

http://mu.wordpress.org/forums/topic.php?id=1581&replies=1#post-8907