The Arcive of vBulletin Modifications Site. |
|
Restrict prune by forum? Details »»
|
|||||||||||||||||||||||||
Sorry if this is in the wrong forum -- please move if appropriate!
Before I write a SQL script to do this, I thought I would float this idea out to y'all and see if anyone has already done it (a search didn't turn up anything). I have certain forums (links, questions, etc...) that I don't want to prune, and it takes a mountain of time through the ACP to manually select and prune the others individually. Has anyone seen a .php hack that would allow for selective pruning of forums based on date? If not, is there a MySQL script flying around that does this? Last question -- are we allowed to post SQL scripts that we write, even those aren't real "hacks"? Thanks to anyone who can help!! Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
The "Spin Threads" hack might be something you could use.
|
|
#3
|
||||
|
||||
|
you can post sql queries, but not in full releases, as there they wouldn't make sense...
also delete a thread is not done with just one sql query, you have to deltete the posts, attachments... belonging to that thread, too |
|
#4
|
||||
|
||||
|
I will take a look at that spin threads hack and see what its all about~ Thanks for the heads up.
Thanks also, Xenon -- maybe it would be best if I pass anything like that onto an admin who can decide if its OK. As far as the query, yea, it is a bit complicated but can be done, albeit a little messy! It just takes so loooong to do this stuff through the ACP that if I can just hit the database directly, things fly (like IP address searches). |
|
#5
|
||||
|
||||
|
of course, you can send me or another admin or mod those things if you are not sure if and where to put
|
![]() |
|
|