9 replies to this topic

[mmmarriott]

What is the sql code to delete any member from the member group who has not visited my board in the last 12 months?

[Michael]

You should never delete members by running SQL queries. In the Members tab of the Admin CP, you can use the advanced search to find and remove these members. You'll want to do it that way, as that's the only clean way to delete members.

[mmmarriott]

The search results don't show the 'last visited date' which I need to see to make sure that the right data has been extrapolated thus enabling me to delete those members who haven't visited in the last year.

[Michael]

Yes, it does:

[mmmarriott]

I know it shows it in the search parameters BUT it does not show it in the results!

[mmmarriott]

Oops, I forgot the images.

 capture1.jpg   53.96K   7 downloads

 capture2.jpg   8.9K   6 downloads

[Michael]

Why do you need it in the search results? Aren't you just deleting anyone who fits the criteria you want? The results will be what you searched for.

[mmmarriott]

Yes that's true; but I would have liked to have seen that parameter displayed in the results; its a sort of confirmation really. Is it something I can add in a file edit and can you tell me what it is and where to insert it? In any event, thank you very much for your help Michael.

[mmmarriott]

Hold on!!

'Last visited between' is the wrong parameter. I need to know the opposite. I need to know those members who have not visited in the last year. The search facility does not offer what I need.

[Michael]

Yes, it does, use the board start date or something even earlier for the first box, and use the date one year ago in the second box.