修訂時間:20100726, 20081212
緣起:應用wordpress 在教學時,若需方便確認同學是否作分析討論,可先請同學依規定格式設定暱稱,再將「如何顯示您的大名:」設成暱稱,再修改迴響顯示排序的方式即可。
資料庫有關comment的格式如下:
wp-content/themes/目前的theme路徑下的comments.php
找到下行:
$comments = $wpdb->get_results(”SELECT * FROM $tablecomments WHERE comment_post_ID = ‘$id’ AND comment_approved = ‘1′ ORDER BY comment_date”);
將 ORDER BY comment_date 改成ORDER BY comment_author即可依顯示名稱排序,方便追蹤同學是否有作分析討論。
修改後如下行:
$comments = $wpdb->get_results(”SELECT * FROM $tablecomments WHERE comment_post_ID = ‘$id’ AND comment_approved = ‘1′ ORDER BY comment_author”);
註:若要依時間由新到舊排序,可改為如下:$comments = $wpdb->get_results(”SELECT * FROM $tablecomments WHERE comment_post_ID = ‘$id’ AND comment_approved = ‘1′ ORDER BY comment_date DESC”);若要依時間由舊到新排序,可改為如下:$comments = $wpdb->get_results(”SELECT * FROM $tablecomments WHERE comment_post_ID = ‘$id’ AND comment_approved = ‘1′ ORDER BY comment_date”);

