SMF Support > Install and Upgrade Help

Pruning inactive members + upgrading to a newer version

<< < (3/7) > >>

Yoshi:
Most mods and themes have updated versions already that work with the latest versions :)

Kitarist:
Can you please change the topic to something like upgrading the forums and also deleting users who never logged in. Because some have their accounts activated but they never logged in.

Also do you maybe know how to run a command in phpmyadmin to delete those members? Or also deleting members with signature who have 0 posts.

Thanks!!!

Yoshi:
Sure, changed in a second :)

I don't know any command in phpMyAdmin that could do this, though, sorry :(

Doctor Deejay:
Try these ones:

--- Code: ---DELETE FROM smf_members WHERE posts=0 AND signature != ''
--- End code ---

--- Code: ---DELETE FROM smf_members WHERE last_login=0
--- End code ---
Read my sig though.

Yoshi:
Of course replacing "smf_" with your own prefix :)

Navigation

[0] Message Index

[#] Next page

[*] Previous page