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
Index
- 1 Cima izimvo ze-SPAM
- 2 Cima zonke izimvo zilinde ukumodareyithwa
- 3 Guqula isicatshulwa kuwo onke amagqabantshintshi
- 4 Cima izimvo ezisekwe kwi-URL yendawo yombhali
- 5 Vala amagqabantshintshi ngamanqaku amadala
- 6 Vala amagqabantshintshi kuwo onke amanqaku
- 7 Cima amagqabantshintshi enziwe ngexesha elithile
- 8 Isiphelo!
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
Izimvo ezi-7, shiya ezakho
Ndicinga ukuba ugqobele i-desdelinux ungakhange uyiqonde hahaha
Kwenzeka ntoni kwinkangeleko yeli nqaku? Oku kubonakala ngathi kukuziphatha.
lungile. zilungisiwe.
le alejandro ...
haha! yeka ukwenza ikaka alejandro!
xa ndikubamba….
Kwaye ayinakuba sifundo se-MySQL senza ingqiqo? Okanye, ukuba into oyifunayo ngu "Lawula uluvo lwamagama asuka kwiConsole" ubuncinci ube nomhlobiso wokubonisa iskripthi esisebenza ngayo yonke le mibuzo.
Ngapha koko, ukunciphisa umrhumo kwigalelo lam (yeyiphi inoveli!)
Ukulayisha i-WordPress database kwaye uyenze umhlaba:
IZAZISO ZOKUTSHULA;
Ndiyathemba ukuba iluncedo ...
Iya kuba banzi ngakumbi isifundo se-MySQL, ii-querys kunye nezinye ... kodwa, kwabo bafuna ukwenza utshintsho oluthile kwizimvo zeWordPress, ngekhe kube nokwenzeka, abanakuqonda okuninzi.
Malunga nomcimbi wokuba ungazihombisi, yiza kuWillian, uqala unikele ngento emva koko ugxeke igalelo labanye kulungile 😉
Iphi indawo yakho / ibhlog eluncedo kuluntu? Ndiyabuza kutheni, kufuneka ubenesihombiso kunye nesidima, akunjalo? ^ _ ^
Elona candelo lilungileyo leposi…. abezopolitiko abonakeleyo
+1