wordpress如何實現讀者墻

<?php   /*  Template Name: Reader wall  */  ?>

<!-- start 讀者墻 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?!=?'改成你的郵箱賬號'?AND?post_password=''?AND?comment_approved='1'?AND?comment_type='')?AS?tempcmt?GROUP?BY?comment_author_email?ORDER?BY?cnt?DESC?LIMIT?39";// ?&gt;

<?php   $wall = $wpdb->get_results($query);? $maxNum?=?$wall[0]-&gt;cnt;? foreach?($wall?as?$comment)? {? $width?=?round(40?/?($maxNum?/?$comment-&gt;cnt),2);//此處是對應的血條的寬度? 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?=?"

.readers-list{line-height:18px;text-align:left;overflow:hidden;_zoom:1}? .readers-list?li{width:200px;float:left;*margin-right:-1px}? .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)}? .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}? .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}? .readers-list?img{width:36px;height:36px;float:left;margin:0?8px?0?-40px;border-radius:2px}? .readers-list?em{color:#666;font-style:normal;margin-right:10px}? .readers-list?strong{color:#ddd;width:40px;text-align:right;position:absolute;right:6px;top:4px;font:bold?14px/16px?microsoft?yahei}? .readers-list?a:hover{border-color:#bbb;box-shadow:#ccc?0?0?2px;background-color:#fff;background-image:none}? .readers-list?a:hover?img{opacity:.6;margin-left:0}? .readers-list?a:hover?em{color:#EE8B17;font:bold?12px/36px?microsoft?yahei}? .readers-list?a:hover?strong{color:#EE8B17;right:150px;top:0;text-align:center;border-right:#ccc?1px?solid;height:44px;line-height:40px}