{"id":30816,"date":"2024-11-25T15:59:26","date_gmt":"2024-11-25T07:59:26","guid":{"rendered":"https:\/\/fwq.ai\/blog\/30816\/"},"modified":"2024-11-25T15:59:26","modified_gmt":"2024-11-25T07:59:26","slug":"wordpress%e5%a6%82%e4%bd%95%e5%ae%9e%e7%8e%b0%e8%af%bb%e8%80%85%e5%a2%99","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/30816\/","title":{"rendered":"wordpress\u5982\u4f55\u5b9e\u73b0\u8bfb\u8005\u5899"},"content":{"rendered":"

\"wordpress\u5982\u4f55\u5b9e\u73b0\u8bfb\u8005\u5899\u63d2\u56fe\"<\/strong><\/p>\n

\u5982\u4f55\u5b9e\u73b0\u8bfb\u8005\u5899\uff1f<\/strong><\/p>\n

\u672c\u6587\u5b9e\u4f8b\u8bb2\u8ff0\u4e86wordpress\u5b9e\u73b0\u8bfb\u8005\u5899\u7684\u65b9\u6cd5\u3002\u5206\u4eab\u7ed9\u5927\u5bb6\u4f9b\u5927\u5bb6\u53c2\u8003\u3002\u5177\u4f53\u5b9e\u73b0\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n

\u63a8\u8350\uff1a\u300a\u300b<\/p>\n

1.\u590d\u5236PAGE.php\u9875\u9762,\u6539\u540d\u4e3areaderwall.php,\u7136\u540e\u5728\u5176\u9876\u90e8\u6dfb\u52a0\u5982\u4e0b\u4ee3\u7801:<\/p>\n

\u4ee3\u7801\u5982\u4e0b:<\/p>\n

<?php  \n\/* \nTemplate Name: Reader wall \n*\/ \n?><\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u63d0\u793a:\u4f60\u53ef\u4ee5\u5148\u4fee\u6539\u90e8\u5206\u4ee3\u7801\u518d\u8fd0\u884c\u3002<\/p>\n
2.\u5728\u9700\u8981\u6dfb\u52a0\u8bfb\u8005\u5899\u7684\u4f4d\u7f6e\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801:<\/p>\n
\u4ee3\u7801\u5982\u4e0b:<\/p>\n
<!-- start \u8bfb\u8005\u5899 Edited By iSayme--> \n<?php  \n$query=\"SELECT COUNT(comment_ID) AS cnt, comment_author, comment_author_url, comment_author_email FROM (SELECT * FROM $wpdb->comments LEFT OUTER JOIN $wpdb-&gt;posts ON ($wpdb-&gt;posts.ID=$wpdb-&gt;comments.comment_post_ID) WHERE comment_date &gt; date_sub( NOW(), INTERVAL 24 MONTH ) AND user_id='0' AND comment_author_email != '\u6539\u6210\u4f60\u7684\u90ae\u7bb1\u8d26\u53f7' AND post_password='' AND comment_approved='1' AND comment_type='') AS tempcmt GROUP BY comment_author_email ORDER BY cnt DESC LIMIT 39\";\/\/\n?&gt;<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u5927\u5bb6\u628a\u7ba1\u7406\u5458\u7684\u90ae\u7bb1\u6539\u6210\u4f60\u7684,\u6700\u540e\u7684\u8fd9\u4e2a39\u662f\u9009\u53d6\u591a\u5c11\u4e2a\u5934\u50cf,\u5927\u5bb6\u53ef\u4ee5\u6309\u7167\u81ea\u5df1\u7684\u4e3b\u9898\u8fdb\u884c\u4fee\u6539,\u6765\u9002\u5408\u4e3b\u9898\u5bbd\u5ea6,\u4ee3\u7801\u5982\u4e0b:<\/p>\n
\u4ee3\u7801\u5982\u4e0b:<\/p>\n
<?php  \n$wall = $wpdb->get_results($query); \n$maxNum = $wall[0]-&gt;cnt; \nforeach ($wall as $comment) \n{ \n$width = round(40 \/ ($maxNum \/ $comment-&gt;cnt),2);\/\/\u6b64\u5904\u662f\u5bf9\u5e94\u7684\u8840\u6761\u7684\u5bbd\u5ea6 \nif( $comment-&gt;comment_author_url ) \n$url = $comment-&gt;comment_author_url; \nelse $url=\"#\"; \n$avatar = get_avatar( $comment-&gt;comment_author_email, $size = '36', $default = get_bloginfo('wpurl').'\/avatar\/default.jpg' ); \n$tmp = \"<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
  • <\/li>\n
    “;  $output .= $tmp;  }  $output = ” <\/p>\n
      \n  “.$output.”\n<\/ul>\n
      “;  echo $output ;  ?>  <\/p>\n
      \u63d0\u793a:\u4f60\u53ef\u4ee5\u5148\u4fee\u6539\u90e8\u5206\u4ee3\u7801\u518d\u8fd0\u884c\u3002<\/p>\n
      3.\u5728\u4e3b\u9898\u76ee\u5f55\u4e2dstyle.css\u6dfb\u52a0\u4ee5\u4e0b\u6837\u5f0f:<\/p>\n
      \u4ee3\u7801\u5982\u4e0b:<\/p>\n
      .readers-list{line-height:18px;text-align:left;overflow:hidden;_zoom:1} \n.readers-list li{width:200px;float:left;*margin-right:-1px} \n.readers-list a,.readers-list a:hover strong{background-color:#f2f2f2;background-image:-webkit-linear-gradient(#f8f8f8,#f2f2f2);background-image:-moz-linear-gradient(#f8f8f8,#f2f2f2);background-image:linear-gradient(#f8f8f8,#f2f2f2)} \n.readers-list a{position:relative;display:block;height:36px;margin:4px;padding:4px 4px 4px 44px;color:#999;overflow:hidden;border:#ccc 1px solid;border-radius:2px;box-shadow:#eee 0 0 2px} \n.readers-list img,.readers-list em,.readers-list strong{-webkit-transition:all .2s ease-out;-moz-transition:all .2s ease-out;transition:all .2s ease-out} \n.readers-list img{width:36px;height:36px;float:left;margin:0 8px 0 -40px;border-radius:2px} \n.readers-list em{color:#666;font-style:normal;margin-right:10px} \n.readers-list strong{color:#ddd;width:40px;text-align:right;position:absolute;right:6px;top:4px;font:bold 14px\/16px microsoft yahei} \n.readers-list a:hover{border-color:#bbb;box-shadow:#ccc 0 0 2px;background-color:#fff;background-image:none} \n.readers-list a:hover img{opacity:.6;margin-left:0} \n.readers-list a:hover em{color:#EE8B17;font:bold 12px\/36px microsoft yahei} \n.readers-list a:hover strong{color:#EE8B17;right:150px;top:0;text-align:center;border-right:#ccc 1px solid;height:44px;line-height:40px}<\/pre>\n
       \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
      \u63d0\u793a\uff1a\u4f60\u53ef\u4ee5\u5148\u4fee\u6539\u90e8\u5206\u4ee3\u7801\u518d\u8fd0\u884c.<\/p>\n
      \u5e0c\u671b\u672c\u6587\u6240\u8ff0\u5bf9\u5927\u5bb6\u7684WordPress\u5efa\u7ad9\u6709\u6240\u5e2e\u52a9\u3002<\/p>\n
      \u4ee5\u4e0a\u5c31\u662f\u5982\u4f55\u5b9e\u73b0\u8bfb\u8005\u5899\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
      \u5982\u4f55\u5b9e\u73b0\u8bfb\u8005\u5899\uff1f \u672c\u6587\u5b9e\u4f8b\u8bb2\u8ff0\u4e86wordpress\u5b9e\u73b0\u8bfb\u8005\u5899\u7684\u65b9\u6cd5\u3002\u5206\u4eab\u7ed9\u5927\u5bb6\u4f9b\u5927\u5bb6\u53c2\u8003\u3002\u5177\u4f53\u5b9e\u73b0\u65b9\u6cd5\u5982\u4e0b\uff1a \u63a8\u8350\uff1a\u300a\u300b 1.\u590d\u5236PAGE.php\u9875\u9762,\u6539\u540d\u4e3areaderwall.php,\u7136\u540e\u5728\u5176\u9876\u90e8\u6dfb\u52a0\u5982\u4e0b\u4ee3\u7801: \u4ee3\u7801\u5982\u4e0b: <?php \/* Template Name: Reader wall *\/ ?> \u767b\u5f55\u540e\u590d\u5236 \u63d0\u793a:\u4f60\u53ef\u4ee5\u5148\u4fee\u6539\u90e8\u5206\u4ee3\u7801\u518d\u8fd0\u884c\u3002 2.\u5728\u9700\u8981\u6dfb\u52a0\u8bfb\u8005\u5899\u7684\u4f4d\u7f6e\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801: \u4ee3\u7801\u5982\u4e0b: <!– start \u8bfb\u8005\u5899 Edited By iSayme–>  <?php $query=”SELECT COUNT(comment_ID) AS cnt, comment_author, comment_author_url, comment_author_email FROM (SELECT * FROM $wpdb->comments LEFT OUTER JOIN $wpdb-&gt;posts ON ($wpdb-&gt;posts.ID=$wpdb-&gt;comments.comment_post_ID) WHERE comment_date &gt; date_sub( NOW(), INTERVAL 24 MONTH ) AND user_id=’0′ AND comment_author_email != ‘\u6539\u6210\u4f60\u7684\u90ae\u7bb1\u8d26\u53f7’ AND post_password=” AND comment_approved=’1′ AND comment_type=”) AS tempcmt GROUP BY comment_author_email ORDER BY cnt DESC LIMIT 39″;\/\/ ?&gt; \u767b\u5f55\u540e\u590d\u5236 \u5927\u5bb6\u628a\u7ba1\u7406\u5458\u7684\u90ae\u7bb1\u6539\u6210\u4f60\u7684,\u6700\u540e\u7684\u8fd9\u4e2a39\u662f\u9009\u53d6\u591a\u5c11\u4e2a\u5934\u50cf,\u5927\u5bb6\u53ef\u4ee5\u6309\u7167\u81ea\u5df1\u7684\u4e3b\u9898\u8fdb\u884c\u4fee\u6539,\u6765\u9002\u5408\u4e3b\u9898\u5bbd\u5ea6,\u4ee3\u7801\u5982\u4e0b: \u4ee3\u7801\u5982\u4e0b: <?php $wall = $wpdb->get_results($query);  $maxNum = $wall[0]-&gt;cnt;  foreach ($wall as $comment)  {  $width = round(40 \/ ($maxNum \/ $comment-&gt;cnt),2);\/\/\u6b64\u5904\u662f\u5bf9\u5e94\u7684\u8840\u6761\u7684\u5bbd\u5ea6  if( $comment-&gt;comment_author_url )  $url = $comment-&gt;comment_author_url;  else $url=”#”;  $avatar = get_avatar( $comment-&gt;comment_author_email, $size = ’36’, $default = get_bloginfo(‘wpurl’).’\/avatar\/default.jpg’ );  $tmp = ” \u767b\u5f55\u540e\u590d\u5236 “;  […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-30816","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=30816"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30816\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=30816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=30816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=30816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}