News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Removing profiles with no visits

Started by KirkhamsEbooks, March 04, 2015, 11:14:08 PM

Previous topic - Next topic

KirkhamsEbooks

There's probably one or two thousand of these.

I'll be upgrading to the latest version of smf as of 4-4-2015

I can download the sql from my host, but how should I delete all those profiles?

Rick

Sir Osis of Liver

2.1 is beta 1, not recommended for production forums.
"The best laid schemes o' mice an' men / Gang aft a-gley." - Robert Burns

Kindred

You must have installed with no spam protection...

You will have to mass delete accounts in the admin memberlist functions.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

KirkhamsEbooks

Yeah when I first opened the forum I did. I started by charging a small monthly fee to post which stopped the spam posts, but didn't stop the registering until I setup the capcha. Still happens to some degree. Sounds like there's no way to do that by modifying the sql database after downloading them. Too bad.

Rick

margarett

You shouldn't remove them from the database directly.
However it is possible. You need to fetch all user IDs whose last visit is 0 then pass these IDs to function deleteMembers (Subs-Members.php)
This can be done with some small coding, methinks ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Kindred

why bother?

The mass delete fro the admin memberlist can do 50 at a time....
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: