保哥笔记_张文保的博客

WordPress通过标签添加相关文章功能

WordPress默认的模板没有相关文章的功能，将下面的代码放在文章页模板文章结束位置即可实现相关文章的功能。原理是获取当前文章的标签，输出该标签下最近的10篇文章，如果该标签下不够10篇文章则补充最新文章凑成10篇。$post_num后面的数值就是要调用的文章数量。

<h3>相关文章</h3><ul class="related_posts"><?php$post_num = 10;$exclude_id = $post->ID;$posttags = get_the_tags(); $i = 0;if ( $posttags ) {$tags = ''; foreach ( $posttags as $tag ) $tags .= $tag->term_id . ',';$args = array('post_status' => 'publish','tag__in' => explode(',', $tags),'post__not_in' => explode(',', $exclude_id),'caller_get_posts' => 1,'orderby' => 'comment_date','posts_per_page' => $post_num,);query_posts($args);while( have_posts() ) { the_post(); ?><li><a rel="bookmark" href="<?php the_permalink(); ?>" title="<?php the_title(); ?>" target="_blank"><?php the_title(); ?></a></li><?php$exclude_id .= ',' . $post->ID; $i ++;} wp_reset_query();}if ( $i < $post_num ) {$cats = ''; foreach ( get_the_category() as $cat ) $cats .= $cat->cat_ID . ',';$args = array('category__in' => explode(',', $cats),'post__not_in' => explode(',', $exclude_id),'caller_get_posts' => 1,'orderby' => 'comment_date','posts_per_page' => $post_num - $i);query_posts($args);while( have_posts() ) { the_post(); ?><li><a rel="bookmark" href="<?php the_permalink(); ?>"  title="<?php the_title(); ?>" target="_blank"><?php the_title(); ?></a></li><?php $i++;} wp_reset_query();}if ( $i  == 0 )  echo '<li>没有相关文章!</li>';?></ul>

<?php

$post_num = 10;

$exclude_id = $post->ID;

$posttags = get_the_tags(); $i = 0;

if ( $posttags ) {

$tags = ''; foreach ( $posttags as $tag ) $tags .= $tag->term_id . ',';

$args = array(

'post_status' => 'publish',

'tag__in' => explode(',', $tags),

'post__not_in' => explode(',', $exclude_id),

'caller_get_posts' => 1,

'orderby' => 'comment_date',

'posts_per_page' => $post_num,

);

query_posts($args);

while( have_posts() ) { the_post(); ?>

<li><a rel="bookmark" href="<?php the_permalink(); ?>" title="<?php the_title(); ?>" target="_blank"><?php the_title(); ?></a></li>

<?php

$exclude_id .= ',' . $post->ID; $i ++;

} wp_reset_query();

}

if ( $i < $post_num ) {

$cats = ''; foreach ( get_the_category() as $cat ) $cats .= $cat->cat_ID . ',';

$args = array(

'category__in' => explode(',', $cats),

'post__not_in' => explode(',', $exclude_id),

'caller_get_posts' => 1,

'orderby' => 'comment_date',

'posts_per_page' => $post_num - $i

);

query_posts($args);

while( have_posts() ) { the_post(); ?>

<li><a rel="bookmark" href="<?php the_permalink(); ?>" title="<?php the_title(); ?>" target="_blank"><?php the_title(); ?></a></li>

<?php $i++;

} wp_reset_query();

}

if ( $i == 0 ) echo '<li>没有相关文章!</li>';

</ul>

WordPress禁止HTTP_USER_AGENT恶意采集与攻击

很多采集程序和SQL注入工具都是利用空USER_AGENT来获取信息，屏蔽恶意HTTP_USER_AGENT既可以防采集还可以在一定程度防攻击。直接复制以下代码，粘贴到你当前主题模板的functions.php里：

$ua = $_SERVER['HTTP_USER_AGENT'];$now_ua = array('FeedDemon ','ZmEu','Indy Library','oBot','jaunty'); //将恶意USER_AGENT存入数组if(!$ua) { //禁止空USER_AGENT，dedecms等主流采集程序都是空USER_AGENT，部分sql注入工具也是空USER_AGENTheader("Content-type: text/html; charset=utf-8");wp_die('请勿采集本站！');}else{    foreach($now_ua as $value )    if(eregi($value,$ua)) {    header("Content-type: text/html; charset=utf-8");    wp_die('请勿采集本站！');    }}

$ua = $_SERVER['HTTP_USER_AGENT'];

$now_ua = array('FeedDemon ','ZmEu','Indy Library','oBot','jaunty'); //将恶意USER_AGENT存入数组

if(!$ua) { //禁止空USER_AGENT，dedecms等主流采集程序都是空USER_AGENT，部分sql注入工具也是空USER_AGENT

header("Content-type: text/html; charset=utf-8");

wp_die('请勿采集本站！');

}else{

foreach($now_ua as $value )

if(eregi($value,$ua)) {

header("Content-type: text/html; charset=utf-8");

wp_die('请勿采集本站！');

}

$now_ua里面的数组是一些恶意采集软件的HTTP_USER_AGENT标识，下面还有更多： FeedDemon … 继续阅读WordPress禁止HTTP_USER_AGENT恶意采集与攻击

WordPress压缩html代码提升网页加载速度

对WordPress进行html代码压缩可以实现WordPress加速，此处保哥分享的是免Gzip插件来实现。压缩代码分为两部分，第一部分是压缩html代码，第二部分是解决代码压缩后导致html里的注释挤到一行，使很多代码失效，特别是部分js代码失效。在当前主题模板下的functions.php中加以下代码：

/**压缩html代码**/function wp_compress_html(){function wp_compress_html_main ($buffer){$initial=strlen($buffer);$buffer=explode("<!--wp-compress-html-->", $buffer);$count=count ($buffer);for ($i = 0; $i <= $count; $i++){if (stristr($buffer[$i], '<!--wp-compress-html no compression-->')) {$buffer[$i]=(str_replace("<!--wp-compress-html no compression-->", " ", $buffer[$i]));} else {$buffer[$i]=(str_replace("\t", " ", $buffer[$i]));$buffer[$i]=(str_replace("\n\n", "\n", $buffer[$i]));$buffer[$i]=(str_replace("\n", "", $buffer[$i]));$buffer[$i]=(str_replace("\r", "", $buffer[$i]));while (stristr($buffer[$i], ' ')) {$buffer[$i]=(str_replace(" ", " ", $buffer[$i]));}}$buffer_out.=$buffer[$i];}$final=strlen($buffer_out);$savings=($initial-$final)/$initial*100;$savings=round($savings, 2);$buffer_out.="\n<!--压缩前: $initial bytes; 压缩后: $final bytes; 节约：$savings% -->";return $buffer_out;}ob_start("wp_compress_html_main");}add_action('get_header', 'wp_compress_html');/**自动在存在高亮代码的文章收尾插入免压缩注释**/function Code_Box($content) {$matches = array();/**以下是匹配高亮代码的关键词，本代码适用于 Crayon Syntax Highlighter 插件，其他插件请自行分析关键词即可**/$c = "/(crayon-|<\/pre>)/i";if(preg_match_all($c, $content, $matches) && is_single()) {$content = '<!--wp-compress-html--><!--wp-compress-html no compression-->'.$content;$content.= '<!--wp-compress-html no compression--><!--wp-compress-html-->';}return $content;}add_filter( "the_content", "Code_Box" );

/**压缩html代码**/

function wp_compress_html(){

function wp_compress_html_main ($buffer){

$initial=strlen($buffer);

$buffer=explode("", $buffer);

$count=count ($buffer);

for ($i = 0; $i <= $count; $i++){

if (stristr($buffer[$i], '')) {

$buffer[$i]=(str_replace("", " ", $buffer[$i]));

} else {

$buffer[$i]=(str_replace("\t", " ", $buffer[$i]));

$buffer[$i]=(str_replace("\n\n", "\n", $buffer[$i]));

$buffer[$i]=(str_replace("\n", "", $buffer[$i]));

$buffer[$i]=(str_replace("\r", "", $buffer[$i]));

while (stristr($buffer[$i], ' ')) {

$buffer[$i]=(str_replace(" ", " ", $buffer[$i]));

}

$buffer_out.=$buffer[$i];

}

$final=strlen($buffer_out);

$savings=($initial-$final)/$initial*100;

$savings=round($savings, 2);

$buffer_out.="\n";

return $buffer_out;

}

ob_start("wp_compress_html_main");

}

add_action('get_header', 'wp_compress_html');

/**自动在存在高亮代码的文章收尾插入免压缩注释**/

function Code_Box($content) {

$matches = array();

/**以下是匹配高亮代码的关键词，本代码适用于 Crayon Syntax Highlighter 插件，其他插件请自行分析关键词即可**/

$c = "/(crayon-|<\/pre>)/i";

if(preg_match_all($c, $content, $matches) && is_single()) {

$content = ''.$content;

$content.= '';

}

return $content;

}

add_filter( "the_content", "Code_Box" );

WordPress修改评论区模板Cookies提示文字并设置默认勾选状态

WordPress中自带的Twenty Fifteen主题，默认的评论区有一处保存Cookies的提示英文没有汉化：Save my name, email, and website in this browser for the next time I comment.翻译过来的中文意思是“保存姓名、电子邮件和站点信息，便于下次发表评论” 解决方法：编辑器打开wp-includes目录下的comm … 继续阅读WordPress修改评论区模板Cookies提示文字并设置默认勾选状态

修改WordPress默认字体为微软雅黑

WordPress默认自带的模板主题以及一些国外的WordPress模板里的中文字体很模糊特别难看，不符合国人的审美，下面提供一行简单的CSS代码，即可解决整站字体，而且不影响Font awsome图标。复制以下代码：

*:not([class*="icon"]):not(i) {font-family: Segoe UI, "Microsoft Yahei" !important;}

1	:not([class="icon"]):not(i) {font-family: Segoe UI, "Microsoft Yahei" !important;}

粘贴到主题自定义里面的额外CSS里，发布后即可生效，保哥笔记用的这是这段代码，只需要一行，轻松搞定。

WordPress头部代码优化：去除window._wpemojiSettings代码

查看Wordpress源文件的时候，会看到head头部加载了一大片window._wpemojiSettings开头的JS和CSS代码，这是用于支持emjo表情的脚本。对于大部分国内站长来说，这个是十分鸡肋的功能，不仅使用的机会少，放在网站头部的JS代码太多对网站的优化也很不好，而且还会影响网站的加载速度。

<script type="text/javascript">window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/2.4\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/2.4\/svg\/","svgExt":".svg","source":{"concatemoji":"http:\/\/zhangwenbao.com\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.9.6"}};!function(a,b,c){function d(a,b){var c=String.fromCharCode;l.clearRect(0,0,k.width,k.height),l.fillText(c.apply(this,a),0,0);var d=k.toDataURL();l.clearRect(0,0,k.width,k.height),l.fillText(c.apply(this,b),0,0);var e=k.toDataURL();return d===e}function e(a){var b;if(!l||!l.fillText)return!1;switch(l.textBaseline="top",l.font="600 32px Arial",a){case"flag":return!(b=d([55356,56826,55356,56819],[55356,56826,8203,55356,56819]))&&(b=d([55356,57332,56128,56423,56128,56418,56128,56421,56128,56430,56128,56423,56128,56447],[55356,57332,8203,56128,56423,8203,56128,56418,8203,56128,56421,8203,56128,56430,8203,56128,56423,8203,56128,56447]),!b);case"emoji":return b=d([55357,56692,8205,9792,65039],[55357,56692,8203,9792,65039]),!b}return!1}function f(a){var c=b.createElement("script");c.src=a,c.defer=c.type="text/javascript",b.getElementsByTagName("head")[0].appendChild(c)}var g,h,i,j,k=b.createElement("canvas"),l=k.getContext&&k.getContext("2d");for(j=Array("flag","emoji"),c.supports={everything:!0,everythingExceptFlag:!0},i=0;i<j.length;i++)c.supports[j[i]]=e(j[i]),c.supports.everything=c.supports.everything&&c.supports[j[i]],"flag"!==j[i]&&(c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&c.supports[j[i]]);c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&!c.supports.flag,c.DOMReady=!1,c.readyCallback=function(){c.DOMReady=!0},c.supports.everything||(h=function(){c.readyCallback()},b.addEventListener?(b.addEventListener("DOMContentLoaded",h,!1),a.addEventListener("load",h,!1)):(a.attachEvent("onload",h),b.attachEvent("onreadystatechange",function(){"complete"===b.readyState&&c.readyCallback()})),g=c.source||{},g.concatemoji?f(g.concatemoji):g.wpemoji&&g.twemoji&&(f(g.twemoji),f(g.wpemoji)))}(window,document,window._wpemojiSettings);</script><style type="text/css">img.wp-smiley,img.emoji {display: inline !important;border: none !important;box-shadow: none !important;height: 1em !important;width: 1em !important;margin: 0 .07em !important;vertical-align: -0.1em !important;background: none !important;padding: 0 !important;}</style>

window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/2.4\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/2.4\/svg\/","svgExt":".svg","source":{"concatemoji":"http:\/\/zhangwenbao.com\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.9.6"}};

</script>

img.wp-smiley,

img.emoji {

display: inline !important;

border: none !important;

box-shadow: none !important;

height: 1em !important;

width: 1em !important;

margin: 0 .07em !important;

vertical-align: -0.1em !important;

background: none !important;

padding: 0 !important;

}

</style>

清除以上的window. … 继续阅读WordPress头部代码优化：去除window._wpemojiSettings代码

去除WordPress自带的twentyfifteen模板中的Google字体链接

WordPress在使用自带的twentyfifteen模板时，头部会加载以下的Google字体链接URL，国内是访问不了的，需要去除以提升网站加载速度。

<link rel='stylesheet' id='twentyfifteen-fonts-css' href='//fonts.googleapis.com/css?family=Noto+Sans%3A400italic%2C700italic%2C400%2C700%7CNoto+Serif%3A400italic%2C700italic%2C400%2C700%7CInconsolata%3A400%2C700&#038;subset=latin%2Clatin-ext' type='text/css' media='all' />

1	<link rel='stylesheet' id='twentyfifteen-fonts-css' href='//fonts.googleapis.com/css?family=Noto+Sans%3A400italic%2C700italic%2C400%2C700%7CNoto+Serif%3A400italic%2C700italic%2C400%2C700%7CInconsolata%3A400%2C700&subset=latin%2Clatin-ext' type='text/css' media='all' />

清除方法是复制下面的代码粘贴到Twenty Fifteen模板里的functions.php里，更新文件即可。

/**去除当前twentyfifteen模板头部加载的Google字体**/function wpse_dequeue_google_fonts() {wp_dequeue_style( 'twentyfifteen-fonts' );}add_action( 'wp_enqueue_scripts', 'wpse_dequeue_google_fonts', 20 );

/**去除当前twentyfifteen模板头部加载的Google字体**/

function wpse_dequeue_google_fonts() {

wp_dequeue_style( 'twentyfifteen-fonts' );

}

add_action( 'wp_enqueue_scripts', 'wpse_dequeue_google_fonts', 20 );

… 继续阅读去除WordPress自带的twentyfifteen模板中的Google字体链接

去除WordPress加载的JS和CSS链接后的版本号

WordPress头部加载的JS和CSS链接URL后都有版本号，这样就泄露了你正在使用的WP的版本了，去除方法是将下面的代码复制粘贴到你当前主题模板的functions.php里即可清除所有URL中的版本号。

/**去除JS和CSS链接后的版本号**/function wpdaxue_remove_cssjs_ver( $src ) {if( strpos( $src, 'ver=' ) )$src = remove_query_arg( 'ver', $src );return $src;}add_filter( 'style_loader_src', 'wpdaxue_remove_cssjs_ver', 999 );add_filter( 'script_loader_src', 'wpdaxue_remove_cssjs_ver', 999 );

/**去除JS和CSS链接后的版本号**/

function wpdaxue_remove_cssjs_ver( $src ) {

if( strpos( $src, 'ver=' ) )

$src = remove_query_arg( 'ver', $src );

return $src;

}

add_filter( 'style_loader_src', 'wpdaxue_remove_cssjs_ver', 999 );

add_filter( 'script_loader_src', 'wpdaxue_remove_cssjs_ver', 999 );

EXCEL批量在数字前加半角单引号

我们在EXCEL中经常会遇到将身份证号、手机号之类超长数字进行处理，在前面加上单引号，特别是在使用VLOOKUP函数批量查询的时候，如果数字前没有加单引号是查询不了的，需要先批量在数字前加半角单引号’ 具体操作步骤如下：先选取数字所在列或所在行中第一个单元格,比如选择B2单元格,在该单元格中的数据前加入半角英文单引号’，此时该单元格前左上角会有一个绿色小三角标记，要让所有 … 继续阅读EXCEL批量在数字前加半角单引号

利用.htaccess设置WordPress防盗链

站长都清楚，如果文章被转载到其它网站，甚至文章图片的链接地址都不改，直接远程链接图片，对自己网站的流量和带宽会有大量消耗，所以WordPress设置图片防盗链是非常有必要的。本方法适用于Apache环境，需要开启mod_rewrite模块以支持htaccess规则，以下是具体的.htaccess文件里的代码：

# BEGIN WordPress<IfModule mod_rewrite.c>RewriteEngine OnRewriteBase /RewriteCond %{REQUEST_FILENAME} !-fRewriteCond %{REQUEST_FILENAME} !-dRewriteRule . /index.php [L]RewriteBase /wp-content/uploads/RewriteCond %{HTTP_REFERER} !^$ [NC]RewriteCond %{HTTP_REFERER} !zhangwenbao.com [NC]RewriteCond %{HTTP_REFERER} !bing.com [NC]RewriteCond %{HTTP_REFERER} !zhuaxia.com [NC]RewriteCond %{HTTP_REFERER} !so.com [NC]RewriteCond %{HTTP_REFERER} !google.com [NC]RewriteCond %{HTTP_REFERER} !yahoo.com [NC]RewriteCond %{HTTP_REFERER} !sm.cn [NC]RewriteCond %{HTTP_REFERER} !baidu.com [NC]RewriteRule .*\.(gif|jpg|png|rar)$ http://zhangwenbao.com/wp-content/uploads/2018/06/logo.png [L]</IfModule># END WordPress

# BEGIN WordPress

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /index.php [L]

RewriteBase /wp-content/uploads/

RewriteCond %{HTTP_REFERER} !^$ [NC]

RewriteCond %{HTTP_REFERER} !zhangwenbao.com [NC]

RewriteCond %{HTTP_REFERER} !bing.com [NC]

RewriteCond %{HTTP_REFERER} !zhuaxia.com [NC]

RewriteCond %{HTTP_REFERER} !so.com [NC]

RewriteCond %{HTTP_REFERER} !google.com [NC]

RewriteCond %{HTTP_REFERER} !yahoo.com [NC]

RewriteCond %{HTTP_REFERER} !sm.cn [NC]

RewriteCond %{HTTP_REFERER} !baidu.com [NC]

RewriteRule .*\.(gif|jpg|png|rar)$ http://zhangwenbao.com/wp-content/uploads/2018/06/logo.png [L]

</IfModule>

# END WordPress

将以上代码保存为.h … 继续阅读利用.htaccess设置WordPress防盗链