@@ -131,7 +134,9 @@ $sort_cols = array( 'menu_order', 'id', - 'post_title' + 'post_title', + 'post_author', + 'post_modified' ); $sort_orders = array( @@ -142,7 +147,7 @@ $orderby = (!array_key_exists('orderby', $_GET) || !in_array(strtolower($_GET['orderby']), $sort_cols)) ? 'menu_order' : $_GET['orderby']; $sortorder = (!array_key_exists('sortorder', $_GET) || !in_array(strtolower($_GET['sortorder']), $sort_orders)) ? 'ASC' : $_GET['sortorder']; - $sql = "SELECT ID, menu_order, post_title, post_name, guid FROM $wpdb->posts WHERE post_parent = $parent_id AND post_status = 'static' ORDER BY $orderby $sortorder"; + $sql = "SELECT ID, menu_order, post_title, post_name, guid, post_author, post_modified FROM $wpdb->posts WHERE post_parent = $parent_id AND post_status = 'static' ORDER BY $orderby $sortorder"; $rows = $wpdb->get_results($sql); $num_rows = count($rows); ?> @@ -166,6 +171,18 @@ < ?php } else { ?> Title < ?php } ?> + | + < ?php if($orderby != 'post_author') {?> + <a href="<?php echo pp_link_self($parent_id, array('orderby'=>'post_author')); ?>" title="Order by Author">Author</a> + < ?php } else { ?> + Author + < ?php } ?> + | + < ?php if($orderby != 'post_modified') {?> + <a href="<?php echo pp_link_self($parent_id, array('orderby'=>'post_modified')); ?>" title="Order by mod-time">Upd Time</a> + < ?php } else { ?> + Upd Time + < ?php } ?> <br /> <strong>Sort order:</strong> < ?php if($sortorder != 'ASC') {?> @@ -193,7 +210,8 @@ <th scope="col">Order</th> <th scope="col">Title</th> - <th scope="col">Slug</th> + <th scope="col">Owner</th> + <th scope="col">Updated</th> <th scope="col"></th> <th scope="col"></th> <th scope="col"></th> @@ -222,7 +240,8 @@ } else { echo "<td>$row->post_title</td>n"; } - echo "<td>$row->post_name</td>n"; + echo "<td>" . get_author_name($row->post_author) . "</td>n"; + echo "<td>$row->post_modified</td>n"; if(function_exists(get_guid)) { // if available, makes use of the 'Guid Rebuild' plugin (also by me!)
Pages+プラグイン
複数の人間で(staticな)ページを書いていると、いつ書き換えられたかわかりにくい。管理画面で更新日時順にできればいいのだが、と思ってプラグインを探してみた。そのものではないが Pages+ をほんの少し直せば目的に合いそうだ。slug は要らないので削って、post_author, post_modified をつけ加えた。