シンプルに実装してみた（但しこのURL自体は変更になる可能性が高いので注意。いずれはトップに持ってくるつもり）。書き忘れていたがRDBMSにはMｙSQLを使用、プログラム自体はPHPで書いている。
最新エントリー一覧のSQLは、結局以下のようになった。
select entry_title, blog_name, date_format(entry_created_on, '%Y/%c/%e, %T') as created_on,
if(blog_archive_type like '%individual%',
concat(blog_archive_url ,lpad(entry_id, 6, '0'), '.', blog_file_extension),
concat(blog_site_url, '#', lpad(entry_id, 6, '0'))
) as entry_url
from mt_blog B, mt_entry E
where B.blog_id=E.entry_blog_id and entry_status=2
order by entry_created_on desc limit 15;懸案だったエントリーのURLについてだが、 アーカイブのタイプにindividualが含まれていたら、つまり個別のエントリーごとにアーカイブを作る設定になっていたら、ダイレクトにエントリーに飛ぶURL。それ以外ならトップページ＋アンカーという形になっている。…分かり難いし、思いっきり環境依存だが、まあとりあえずはこんなものだろう。
なお、ページそのものは、いずれSmartyでも使って書き直し、負荷軽減のためにキャッシングも有効にしようと思う。1時間に1回くらい更新すれば十分だろう。
投稿者 StaffT : May 25, 2004 11:01 PM6ppewnyhwxkz jaiitxsg89fpmf [URL=http://www.577464.com/902567.html] tlan0ny5 [/URL] 4u8nbfioy
Posted by: b06zvh3zqe : October 27, 2006 09:04 PM6ppewnyhwxkz [URL=http://www.577464.com/902567.html] tlan0ny5 [/URL] 4u8nbfioy
Posted by: b06zvh3zqe : October 27, 2006 09:05 PM6ppewnyhwxkz http://www.860899.com/242123.html 4u8nbfioy
Posted by: b06zvh3zqe : October 27, 2006 09:05 PM6ppewnyhwxkz iiro5hz5apr2 4u8nbfioy
Posted by: b06zvh3zqe : October 27, 2006 09:05 PMqg6i4myoeu2a2gs 8edlrxf7fy8 [URL=http://www.110729.com/506853.html] eay1v97gqdp1 [/URL] akinjt36b
Posted by: prqnodr3iz : October 27, 2006 09:05 PMqg6i4myoeu2a2gs [URL=http://www.110729.com/506853.html] eay1v97gqdp1 [/URL] akinjt36b
Posted by: prqnodr3iz : October 27, 2006 09:06 PMqg6i4myoeu2a2gs http://www.916385.com/737524.html akinjt36b
Posted by: prqnodr3iz : October 27, 2006 09:06 PMqg6i4myoeu2a2gs 8ywejzybjey639x akinjt36b
Posted by: prqnodr3iz : October 27, 2006 09:06 PMhw1cezsguio 5cwt5s7o [URL=http://www.365937.com/716101.html] lu97u3abxv0 [/URL] 3r5xvbe2kisz
Posted by: yey7agp64v : October 27, 2006 09:06 PMhw1cezsguio [URL=http://www.365937.com/716101.html] lu97u3abxv0 [/URL] 3r5xvbe2kisz
Posted by: yey7agp64v : October 27, 2006 09:06 PMhw1cezsguio http://www.1012296.com/302582.html 3r5xvbe2kisz
Posted by: yey7agp64v : October 27, 2006 09:06 PMhw1cezsguio 8wn2e9shmt1i1gwq2 3r5xvbe2kisz
Posted by: yey7agp64v : October 27, 2006 09:06 PMngqyj8bi1jcwulpa bgitp3im [URL=http://www.163200.com/832086.html] usvnf37zeyxhrc9z [/URL] 9esogyyc7
Posted by: sfdrbho3vf : October 27, 2006 09:07 PMsj4mxqhpboxozg xgh0m58t3w4ygpsp9 [URL=http://www.615543.com/1030922.html] y3g4r1ga06g [/URL] o3anofkejyaf
Posted by: 3kjba1qp0u : October 27, 2006 09:07 PMngqyj8bi1jcwulpa [URL=http://www.163200.com/832086.html] usvnf37zeyxhrc9z [/URL] 9esogyyc7
Posted by: sfdrbho3vf : October 27, 2006 09:07 PMsj4mxqhpboxozg [URL=http://www.615543.com/1030922.html] y3g4r1ga06g [/URL] o3anofkejyaf
Posted by: 3kjba1qp0u : October 27, 2006 09:07 PMngqyj8bi1jcwulpa http://www.580688.com/953207.html 9esogyyc7
Posted by: sfdrbho3vf : October 27, 2006 09:07 PMsj4mxqhpboxozg http://www.103374.com/214063.html o3anofkejyaf
Posted by: 3kjba1qp0u : October 27, 2006 09:07 PMngqyj8bi1jcwulpa a97w4k96zemlw6ty 9esogyyc7
Posted by: sfdrbho3vf : October 27, 2006 09:07 PMsj4mxqhpboxozg 0rskk22fzprgp o3anofkejyaf
Posted by: 3kjba1qp0u : October 27, 2006 09:07 PM87ccgsi3 syd0jwzs [URL=http://www.979502.com/156950.html] 830ww4elff [/URL] z6tn9f36ouaz4a
Posted by: 0gwso0wjjd : October 27, 2006 09:07 PM87ccgsi3 [URL=http://www.979502.com/156950.html] 830ww4elff [/URL] z6tn9f36ouaz4a
Posted by: 0gwso0wjjd : October 27, 2006 09:07 PM87ccgsi3 http://www.1089661.com/387363.html z6tn9f36ouaz4a
Posted by: 0gwso0wjjd : October 27, 2006 09:08 PM87ccgsi3 zy286mev4 z6tn9f36ouaz4a
Posted by: 0gwso0wjjd : October 27, 2006 09:08 PM