Spam olarak listelediklerimizi  siliyoruz.

DELETE FROM pligg_links
WHERE link_status = 'spam'

Spam olarak listelenen yorumları siliyoruz.

DELETE FROM pligg_comments
WHERE comment_status = 'spam'

Aktif olmayan kullanıcıları siliyoruz

DELETE FROM pligg_users
WHERE pligg_users.user_id NOT
IN (
SELECT link_author
FROM pligg_links
)
AND pligg_users.user_id NOT
IN (
SELECT comment_user_id
FROM pligg_comments
)
AND pligg_users.user_id NOT
IN (
SELECT vote_user_id
FROM pligg_votes
)
AND pligg_users.user_level <>'god' 
AND pligg_users.user_level <>'admin' 

 Hepsini oto yaptırayım derseniz ,

DELETE FROM pligg_links WHERE link_status = ‘queued’;
DELETE FROM pligg_links WHERE link_status = ‘discard’;
DELETE FROM pligg_links WHERE link_status = ‘spam’;
DELETE FROM pligg_comments WHERE comment_status = ‘spam’;
UPDATE
pligg_users
SET
user_level = ‘Spammer’,
user_enabled = ’0′
WHERE
pligg_users.user_id NOT IN ( SELECT link_author FROM pligg_links )
AND pligg_users.user_id NOT IN ( SELECT comment_user_id FROM pligg_comments )
#AND pligg_users.user_id NOT IN ( SELECT vote_user_id FROM pligg_votes )
AND pligg_users.user_level ‘god’
AND pligg_users.user_level ‘admin’;
DELETE pligg_votes.* FROM pligg_votes INNER JOIN pligg_users ON pligg_users.user_id = pligg_votes.vote_user_id
WHERE pligg_users.user_level = ‘Spammer’;

Sorularınızı yorum olarak atabilirsiniz gençler.