I am wanting to run an sql query on my phpbb's database to remove an users with < 1 post who has been registered for 2 weeks or more.
I think I can work it out, all except working out how long they have been registed.
Thankfully phpbb give obvious names to their fields so I foudn the "user_regdate" field, however the dates in those fields looke like "1100538647"
So how do I write an sql statement to remove all users who are registered for more than 2 weeks and have a 0 post count?
Anyone help an SQL n00b?
I think I can work it out, all except working out how long they have been registed.
Thankfully phpbb give obvious names to their fields so I foudn the "user_regdate" field, however the dates in those fields looke like "1100538647"
So how do I write an sql statement to remove all users who are registered for more than 2 weeks and have a 0 post count?
Anyone help an SQL n00b?