修改友链显示

最近本博的友链数量是越来越多了,之前是看到的喜欢的就加上了,好长一段时间没有去整理了,今天看看有些博客已经很久没有更新了,就去后台把友链设为私有,暂时不显示出来。但是设置之后还是显示出来了,用的wp-multicollinks插件,去看看插件的代码。

image

在core.php中看到这样一句:

// SQL 查找数据集合
if ( $args['category'] == '' ) {
 // 显示所有分类的数据集合
 $links = $wpdb->get_results("SELECT T1.link_name AS name,T1.link_url AS url,T1.link_description AS description,T1.link_target AS target,T1.link_rating AS rating FROM $wpdb->links T1 ORDER BY " . $args['orderby'] . " " . $args['order'] . $limit);
 }
else {
   // 只显示指定分类的数据集合
   $links = $wpdb->get_results("SELECT T1.link_name AS name,T1.link_url AS url,T1.link_description AS description,T1.link_target AS target,T1.link_rating AS rating FROM $wpdb->links T1,$wpdb->term_relationships T2,$wpdb->term_taxonomy T3,$wpdb->terms T4 WHERE link_visible='Y' AND T1.link_id = T2.object_id AND T2.term_taxonomy_id = T3.term_taxonomy_id AND T3.term_id = T4.term_id AND T4.name='" . $args['category'] . "' ORDER BY " . $args['orderby'] . " " . $args['order'] . $limit);
}

分析下,只有在第一个sql里面加上一个限制只显示visible=Y的友链就行,因此修改之后变成

// SQL 查找数据集合
if ( $args['category'] == '' ) {
 // 显示所有分类的数据集合
 $links = $wpdb->get_results("SELECT T1.link_name AS name,T1.link_url AS url,T1.link_description AS description,T1.link_target AS target,T1.link_rating AS rating FROM $wpdb->links T1 WHERE link_visible='Y' ORDER BY " . $args['orderby'] . " " . $args['order'] . $limit);
 }

这样就完成了将长期不是怎么更新的友链下架的目的了。

无觅相关文章插件,快速提升流量

Leave a comment

8 Comments.

  1. @阿七
    一厢情愿就多了,呵呵

  2. 我的友情链接暂时还不是很多。 :wink:

  3. @hesiway
    哈哈,感觉还不错,呵呵

  4. @glwzu
    是的,当然你可以加入更多的筛选条件,比如之类的。呵呵

  5. @P.H
    呵呵,有一部分都是一厢情愿的,就当做收藏夹了

  6. :mrgreen: 还好不麻烦,加上这句 WHERE link_visible=’Y’ OK啦,这是选择显示的条件吧。

  7. :shock: 即使是這樣 還是密密麻麻的~ 呵呵·


发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

*


您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Bad Behavior has blocked 1476 access attempts in the last 7 days.

site tracking with Asynchronous Google Analytics plugin for Multisite by WordPress Expert at Web Design Jakarta.

serial corel draw 11

serial corel draw 11 serials

free corel photoshop download

free corel photoshop download keygen

adobe free

adobe free

key office 2010

office 2010 key

download photo shop free

photo shop serial

free winrar download for xp

download winrar for xp for free

windows 7 free

windows 7 crack

cs5 serialz

cs5 serialz free

free corel downloads

free corel downloads cracked

office 2010 free

office 2010 key

winrar password cracker serial

wirar password cracker

serial winzip 11

serial winzip 11 key

photoshop key

photoshop key

windows key

windows key

corel dvd moviefactory 6

corel dvd moviefactory 6 downloads

office 2010 professional key

office 2010 key

photo shop key

photo shop key

winrar 3 download

winrar 3 download freedownload

windows 7 key

windows 7 key