| Revisão | d29203e66b5fad6d611967d5396ec83c39413b80 (tree) |
|---|---|
| Hora | 2007-12-05 10:28:41 |
| Autor | kmorimatsu <kmorimatsu@1ca2...> |
| Commiter | kmorimatsu |
Bug fix: archiveprevexists, archivenextexists
git-svn-id: https://svn.sourceforge.jp/svnroot/nucleus-jp/nucleus-jp/branches/branch-3-3@358 1ca29b6e-896d-4ea0-84a5-967f57386b96
utf8/nucleus/libs/globalfunctions.php (diff)| @@ -13,8 +13,8 @@ | ||
| 13 | 13 | /** |
| 14 | 14 | * @license http://nucleuscms.org/license.txt GNU General Public License |
| 15 | 15 | * @copyright Copyright (C) 2002-2007 The Nucleus Group |
| 16 | - * @version $Id: globalfunctions.php,v 1.23.2.4 2007-12-02 23:49:30 kmorimatsu Exp $ | |
| 17 | - * $NucleusJP: globalfunctions.php,v 1.23.2.3 2007/10/30 19:05:20 kmorimatsu Exp $ | |
| 16 | + * @version $Id: globalfunctions.php,v 1.23.2.5 2007-12-05 01:28:41 kmorimatsu Exp $ | |
| 17 | + * $NucleusJP: globalfunctions.php,v 1.23.2.4 2007/12/02 23:49:30 kmorimatsu Exp $ | |
| 18 | 18 | */ |
| 19 | 19 | |
| 20 | 20 | // needed if we include globalfunctions from install.php |
| @@ -843,10 +843,10 @@ function selector() { | ||
| 843 | 843 | global $archivenext, $archiveprev, $archivetype, $archivenextexists, $archiveprevexists; |
| 844 | 844 | |
| 845 | 845 | // sql queries for the timestamp of the first and the last published item |
| 846 | - $query = "SELECT UNIX_TIMESTAMP(itime) as result FROM ".sql_table('item')." WHERE idraft=0 ORDER BY itime ASC"; | |
| 847 | - $first_timestamp=quickQuery ($query); | |
| 848 | - $query = "SELECT UNIX_TIMESTAMP(itime) as result FROM ".sql_table('item')." WHERE idraft=0 ORDER BY itime DESC"; | |
| 849 | - $last_timestamp=quickQuery ($query); | |
| 846 | + $query = "SELECT UNIX_TIMESTAMP(itime) as result FROM ".sql_table('item')." WHERE idraft=0 AND iblog=".(int)($blogid ? $blogid : $CONF['DefaultBlog'])." ORDER BY itime ASC"; | |
| 847 | + $first_timestamp=quickQuery ($query); | |
| 848 | + $query = "SELECT UNIX_TIMESTAMP(itime) as result FROM ".sql_table('item')." WHERE idraft=0 AND iblog=".(int)($blogid ? $blogid : $CONF['DefaultBlog'])." ORDER BY itime DESC"; | |
| 849 | + $last_timestamp=quickQuery ($query); | |
| 850 | 850 | |
| 851 | 851 | sscanf($archive, '%d-%d-%d', $y, $m, $d); |
| 852 | 852 |
Fork