If i want to remove Posts older then Certain Date is there any Querry ( Command ) for SQL to run ?
If i want to remove Members which are not active from last 30 days is there any Querry ( Command ) for SQL to run ?
Please help me with this issue
I believe there are 2 plugins available that do just that.
I'll see if I can dig them up.
Here's a plugin to Prune members:
http://www.mybbcentral.com/thread-1710.html
I can't find the one to prune the posts, but you could always use the
Automove plugin to move them to an unseen forum.
Someone with more SQL knowledge could probably help you more.
There would be no distinct SQL query. You would have to use PHP if() statement and then query the DB.
(2009-10-06, 06:17 PM)alirex Wrote: [ -> ]If i want to remove Members which are not active from last 30 days is there any Querry ( Command ) for SQL to run ?
Do you want to delete users who have been active in the past but not in the last 30 days or do you want to delete users who joined but were never active (such as spam bots)?
If it's the latter the feature is schedule for the 1.6 release.
http://ideas.mybboard.net/idea/deleting-...activation
Thanx for the help , i appreciate the helping nature of you guys.
My problem is actually. I stop allowing registration on my site due to Increase in size of Database. Second on my site around 200-250 posts everyday are coming and bcoz its a Video link site due to that 3 Month old posts are useless bcoz all the Video hosts are deleating those Videos which are older then 3 month. So i want to Remove unwanted users who never come back. Second i want to remove posts which are of 2008.
(2009-10-06, 07:10 PM)xiofire Wrote: [ -> ]There would be no distinct SQL query. You would have to use PHP if() statement and then query the DB.
I am not good in PHP or SQL if u can help its better for me.
(2009-10-06, 06:46 PM)Gordie Wrote: [ -> ]I believe there are 2 plugins available that do just that.
I'll see if I can dig them up.
Here's a plugin to Prune members:
http://www.mybbcentral.com/thread-1710.html
I can't find the one to prune the posts, but you could always use the Automove plugin to move them to an unseen forum.
Someone with more SQL knowledge could probably help you more.
that is subscriber forum site , i already lost $10 in subscribing such kind of site for Mod and site either sold out or Vanished from cyberspace. But i will ask
labrocca if he sell the only one mod to me.
He won't close it anytime soon, and he won't sell you the plugin individually.
If you want it, you pay the $10 for a lifetime subscription, plain and simple.