OK, here is how i have hidden spammers from users, as well also new users until they have been approved by admin
Please do this on your own risk
File functions.php, there is function to find data from db "
function get_db_stat($mode)" it is just in beginning there in file, look for:
case 'newestuser':
$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_id DESC
LIMIT 1";
break;
replace boded row with:
WHERE user_active = 1
So instead looking newest users fromm all users, it looks only newest active user
File memberlist.php somewhere line 150, depending of your version, there is lines which pick up data from db:
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_lastvisit, user_session_time, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY $order_by";
Replace bolded line with :
WHERE user_active = 1
This will limit visibility of users in memeberlist to only active members
No, this is not coding corner, but we wait for snow
almost deleted your profile ! hehe
we are still getting few registrations time-to-time but it is easy filter out bad ones.
