Lawula izimvo zeWordPress ngemiyalelo ye-MySQL

Ago ngexesha elithile eladlulayo ndakubonisa indlela yokulawula iisayithi zeWordPress ngemiyalelo, yayihamba ngeskripthi perl. Kule meko, ndiza kukubonisa ngokuthe ngqo ukuba ungazilawula njani izimvo zeWordPress usebenzisa imibuzo ye-SQL, Oko kukuthi, usebenzisa imiyalelo kwikhonsoli ye-MySQL.

Into yokuqala emele igcinwe engqondweni kukuba kufuneka babe nokufikelela kwi-terminal ye-MySQL okanye ikhonsoli, ukuba singena kwiserver nge-SSH kwaye ngaphakathi siyabhala:

mysql -u impande -p

Nje ukuba oku kubhalwe kwaye kucinezelwe faka izakucela ipassword yalomsebenzisi we-MySQL, bayibhale, baphinde bacinezele faka kunye ne-voila, baya kuba sele befikelela:

Nje ukuba ngaphakathi kwegobolondo le-MySQL kufuneka sibonise ukuba yeyiphi indawo esiza kuyisebenzisa, ungabona iziseko zedatha ezikhoyo:

bonisa iziseko zedatha;

Oku kuyakubonisa njengoko benditshilo iziseko zedatha ezikhoyo, cinga oyifunayo ubizwa cbcindle, masiyisebenzise:

sebenzisa i-sitewordpress;

Makhe sijonge ukuba zibizwa njani iitafile:

bonisa iitafile;

Oku kuyakusixelela amagama etafile, kubaluleke kakhulu kuba kufuneka sibone ukuba leliphi igama leetafile elihambelana nezimvo:

Ihlala ibizwa ngokuba yi-wp_comments okanye ngokufanayo, into ebalulekileyo kukuba ihlala iphela ngo: Izimvo

Cima izimvo ze-SPAM

Ngale layini zonke izimvo eziphawulwe njenge-SPAM ziya kucinywa:

CIMA kwi-wp_comments APHO uluvo_okuvunywa = 'ugaxekile';

Cima zonke izimvo zilinde ukumodareyithwa

SUSA KWI-wp_comments APHO i-comment_approved = '0';

Guqula isicatshulwa kuwo onke amagqabantshintshi

Masithi sifuna ukukhangela onke amagqabantshintshi ngegama "lezopolitiko" kwaye sithathe indawo yalo "lonakele", inokuba:

UKUHLAZIYA i-wp_comments SET `comment_content` = REPLACE (` comment_content`, 'politicos', 'corruption');

Cima izimvo ezisekwe kwi-URL yendawo yombhali

Masithi ngesizathu esithile sifuna ukususa onke amagqabantshintshi kuye nawuphi na umsebenzisi othi, ngelixa ephawula, achaze kwifom yefomathi yedatha (igama, indawo kunye ne-imeyile) ukuba indawo yabo yayiyi-http: //taringa.com (ukukhankanya umzekelo ), iya kuba yile:

SUSA kwi-wp_comments APHO uphawula_author_url NJENGO 'http://taringa.com';

Vala amagqabantshintshi ngamanqaku amadala

Ndiyazi ngabantu abafuna ukuvala amagqabantshintshi kwizithuba ezindala kwiisayithi zabo, ke kufuneka bahlele izithuba nganye nganye ukuze bangasebenzi "izimvo zivunyelwe" ukhetho kulowo nalowo, lo mgca uza kusombulula ubomi babo:

UPHANDO wp_post SET comment_status = 'closed' WHERE post_date <'2010-02-10' AND post_status = 'publish';

Njengoko ubona, embindini womgca ngumhla, 2010-02-10, oku kuthetha ukuba zonke izithuba ezipapashiweyo kwaye zinomhla wokupapashwa ongaphantsi koFebruwari 10, 2010 (Oko kukuthi, zipapashiwe ngaphambili ) ziya kuvala iikhomenti, akukho mntu uya kuba nakho ukubeka izimvo kuzo kwakhona.

Vala amagqabantshintshi kuwo onke amanqaku

Kwimeko apho ungafuni ukuvala amagqabantshintshi kuphela kwizithuba ezithile kodwa kuko konke, lo mgca uya kukunceda:

UKUHLAZIYA i-wp_post SET comment_status = 'ivaliwe', ping_status = 'ivaliwe' APHO i-comment_status = 'ivulekile';

Ukuba ufuna ukuyibuyisela umva le nto, tshintsha ivaliwe ukuze uvule kwaye kungenjalo, kwaye voila, uphinde wenze umgca kunye notshintsho.

Cima amagqabantshintshi enziwe ngexesha elithile

Masithi sifuna ukucima onke amagqabantshintshi enziwe ngo-Epreli 1, 2014, phakathi ko-4: 15 emva kwemini nango-10: 40 ebusuku, umgca uya kuba:

SUSA KWI-wp_comments LAPHO ubeke ingxelo_ngomhla> '2014-04-01 16:15:00' KUNYE nokuchaza_umhla <= '2014-04-01 22:40:00';

Njengoko ubona, ixesha likwifomathi yeeyure ezingama-24, Oko kukuthi, ixesha lomkhosi.

Isiphelo!

Ewe, akukho nto ingako yokongeza, ndiyazi ukuba ngaphezulu kwesinye kuya kukufumana oku kunomdla.

Phendula nge quote