Method remov the spam comments that not yet in approve.

If blog the friend us wordpress pantastico with hosting paid, and by chance plenty of spam comments that entered, and very annoying until thousands koment, so as if the friend remov him one by one, then very very tiring. so as to be able to spend time, the power and thoughts.
Supervis this had whichever picture the figure comments my spam that not yet in approve or is agre to has reach 3760.


comments spam like that is indicated, with the second arrow above, the contents comments spam is take the form of link whichever the sender meant to get the back link from the owner blog that is comments on, to his site could easily is index in search emgine, and if being seen by us from the contents comments him really is not connect with the contents.
Along with had the method to remove comments spam automatically among them.
1. Please the friend login before dicpanel the friend, the example www.namedomain.com\cpanel
2. Klik phpmyadmin

3. Then will be seen as the picture is supervis this

If the friend had blog more than one, please chose blog whatever that will be remov cooment his spam. like for example me chose blog I that the number of one.
After the friend of the clique blog wordpress number 1, then will appear form like that is indicat to the picture with the arrow number 2.
Please input the sentence is supervis this, is written is supervis the article run sql query queries on server “localhost”:

DELETE from wp_comments WHERE comment_approved = ‘0′;

Further the clique five available in form sql the right-hand low corner and will emerge ordered, you want to remov comments that not yet in aprove, along with his picture.

When we the clique OK, then will appear the notification that comments-comments that not yet in aprove is removed, like in blog I who is remov totalling 3760 comments.

So many previously yes the friend of his tutorial it is hop is useful, and is safe tried.

Language Indonesia

This entry was posted on Sunday, December 27th, 2009 at 12:12 am and is filed under Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

36 Responses to “Method remov the spam comments that not yet in approve.”

  1. mas doyok Says:

    saya tetep gak make nih kang :D
    biar deh komen di saya loststtststtts

  2. Marno Says:

    Terima kasih mas, telah koment.

  3. Hidup untuk Berbagi Says:

    wah ga ngerti nih

  4. mercon Says:

    waduh pake england languange :P

    ane kagak mudeng nii sob… padahal info yg bagus neeh…

    senggol balik ya sob :D

  5. Marno Says:

    Thanks mercon telah koment , ngga apa2 ngga ngerti juga , yang penting mau senggol anunya dah. terima kasih

  6. Yanfutaki Says:

    wah itu buat kita bisa maen di joomla ya??
    ada php myadmin segala??
    nice article…

  7. Blog Informasi Says:

    i think spam comment is useless so this method is very usefull for me

  8. Pepi Says:

    Hard to realize.. I didn’t understood.. about it.. heheheh…

  9. Marno Says:

    Terima kasih yanfutaki selamt mencoba

  10. Blog Informasi Says:

    i think spam comment is very useless so i want to try this method

  11. miftah Says:

    makasih informasinya ya,,

  12. asep canda Says:

    makasih atas infonya ya kang hehehehh :D

  13. still wish Says:

    owh dari cpanel ya kang caranya

  14. noock Says:

    nice 1.. maybe i can apply to my WP blog.. its very useful.. :)

  15. rofi Says:

    hai sob aq sudah gabung d blog km, jgn lupa gabung juga yup… http://www.ropiuddin.co.cc
    oiya trimakasih ilmunya :)

  16. Oemar Says:

    Kalau saya kubiarkan saja.. ehehe.. soalnya masih pake hosting gratisan.. jadi gak terlalu khawatir.. :D

    Terima kasih tips nya.. ;)

  17. Kang Suroto Says:

    Info yang bermanfaat sekali sahabat, thanks ya

  18. Kang Marno Says:

    Terima kasih sahabat. atas komentnya

  19. faisal Says:

    nice artikel . . .

  20. amir Says:

    blog nya bagus sekali kang, sy mo belajar :)

  21. asep canda Says:

    mantap nih infonya kang :D

  22. HAPIA Mesir Says:

    mantaaf…ni buat yg pake hosting ya sob..biar g boros…

  23. rae_zen Says:

    hehehe..q pake blogger yg gratis sob..tapi ni tip bagus banget sob

  24. Marno Says:

    Terima kasih Sobat Rae , telah bersedia koment di tempat saya

  25. Aryanto AJ Says:

    terima kasih nih…infonya

  26. etikmusrifah Says:

    kang,,,,semangat terusssss
    good ertikel

  27. miftah Says:

    terimakasih ya,, semangat

  28. asep canda Says:

    makasih atas infonya ya kang :D

  29. BEBEN Says:

    what is this trick….for wordprett?
    hmmm…i can’t understand with english language..i am the BODO man..hehuehuheueh
    nice article.:)

  30. pujangga cinta Says:

    wow, this is a great article. I find this article from the first. thanks for making this article

  31. gons Says:

    wah saya belum pake nih, tapi tar bisa di coba thanks nice info sob

  32. ompol dewa Says:

    sebenarnya aku pengen comment tapi aku pasif inggrisnya jadi comment kaya gini aje ye?berharap comment balik

  33. wiyono Says:

    secerah hatiku ketika membaca blog ini

  34. Aku Cuma Seorang Blogger Yang Cinta Seo Says:

    aq tdk memoderasi komnetar2 di blogku bro

  35. como ganar ruleta Says:

    This brings me to an idea:…

  36. Boldy Says:

    Nombre de adsmyblog.com a GoogleReader!

    Boldy

 

Leave a Reply