From 32e74abbda0012b4099201b644f55883571e1f04 Mon Sep 17 00:00:00 2001
From: shizuki <shizuki@1ca29b6e-896d-4ea0-84a5-967f57386b96>
Date: Wed, 4 Feb 2009 06:12:49 +0000
Subject: [PATCH] git-svn-id:
 https://svn.sourceforge.jp/svnroot/nucleus-jp/plugin@898
 1ca29b6e-896d-4ea0-84a5-967f57386b96

---
 .../branches/ver-06/NP_ArchiveListEX.php           | 269 ++++++++++++++++++++
 NP_ArchiveListEX/trunk/NP_ArchiveListEX.php        | 275 +++++++--------------
 NP_ArchiveListEX/trunk/sharedlibs/miniajax.js      |  12 +
 3 files changed, 376 insertions(+), 180 deletions(-)
 create mode 100644 NP_ArchiveListEX/branches/ver-06/NP_ArchiveListEX.php
 create mode 100644 NP_ArchiveListEX/trunk/sharedlibs/miniajax.js

diff --git a/NP_ArchiveListEX/branches/ver-06/NP_ArchiveListEX.php b/NP_ArchiveListEX/branches/ver-06/NP_ArchiveListEX.php
new file mode 100644
index 0000000..1bc45e8
--- /dev/null
+++ b/NP_ArchiveListEX/branches/ver-06/NP_ArchiveListEX.php
@@ -0,0 +1,269 @@
+<?
+
+class NP_ArchiveListEX extends NucleusPlugin {
+
+	// name of plugin
+	function getName() {
+		return 'ArchiveListEX'; 
+	}
+	
+	// author of plugin
+	function getAuthor()  { 
+		return 'nakahara21'; 
+	}
+	
+	// an URL to the plugin website
+	function getURL() 
+	{
+		return 'http://xx.nakahara21.net/'; 
+	}
+	
+	// version of the plugin
+	function getVersion() {
+		return '0.6'; 
+	}
+	
+	// a description to be shown on the installed plugins listing
+	function getDescription() { 
+		return 'Show all item title on each archive list. <br />[Required] template: name of the template to use <br />[Optional] mode: [month]shows an entry for each month , [day]shows an entry for each day  <br />[Optional] limit:  limits the amount of links shown (e.g. if you only want to show links to the past 3 months)<br /><br />Usage1: &lt;%ArchiveListEX(default)%&gt; or &lt;%ArchiveListEX(default,month)%&gt; instead of &lt;%archivelist(default)%&gt;,<br />Usage2:  &lt;%ArchiveListEX(default,day,5)%&gt; instead of &lt;%archivedaylist(default,5)%&gt;,<br />Usage3:  &lt;%ArchiveListEX(default,5)%&gt;';
+	}
+
+   function doSkinVar($skinType, $template = 'default', $mode = 'month', $limit = 0) { 
+		global $manager, $blog, $CONF, $catid, $itemid; 
+
+		$params = func_get_args();
+		if ($params[1]){ $template = $params[1]; }
+		if ($params[2]){
+			if ($params[2] == 'month' | $params[2] == 'day'){ $mode = $params[2]; }
+			else{ $limit = intval($params[2]); }
+		}
+		if ($params[3]){ $limit = intval($params[3]); }
+
+	if ($blog) { 
+		$b =& $blog; 
+	} else { 
+		$b =& $manager->getBlog($CONF['DefaultBlog']); 
+	} 
+	$blogid = $b->getID();
+
+		if ($catid) {
+			$this->linkparams = array('catid' => $catid);
+		}
+
+switch($skinType) { 
+	case 'archivelist': 
+
+//**********************************************
+if($_REQUEST['mode'] == "remarks"){
+
+		$numberOfWritebacks   = 50; // defaults to 50
+
+		// select
+        $query = "SELECT c.cnumber, c.cuser, c.cbody, c.citem, c.cmember, c.ctime ,UNIX_TIMESTAMP(c.ctime) as ctimest ,i.inumber, i.ititle 
+        FROM nucleus_comment c ,nucleus_item i 
+        WHERE c.citem = i.inumber 
+        ORDER by ctime DESC 
+        LIMIT 0,".$numberOfWritebacks;
+
+        $comments = mysql_query($query);
+//             echo ' <ul class="nobullets"> ';
+
+        while($row = mysql_fetch_object($comments)) {
+             $cid  = $row->cnumber;
+             $ititle  = htmlspecialchars(strip_tags($row->ititle));
+             $ct  = $row->ctimest;
+             $ctst  = date("Y-m-d H:i",$ct);
+             $ctext  = $row->cbody;
+//             $ctext  = strip_tags($text);
+//             $ctext = substr($text, 0, $numberOfCharacters);
+//             $ctext = mb_substr($ctext, 0, -1);
+
+             if (!$row->cmember) $myname = $row->cuser;
+             else {
+                   $mem = new MEMBER;
+                   $mem->readFromID(intval($row->cmember));
+                   $myname = $mem->getDisplayName();
+             }
+             $itemid= $row->citem;
+             $itemlink = createItemLink($row->citem, '');
+             $l_comments =  "<li class=itembody>¢£ <span class=\"iteminfo\"><a href=\"".$b->getURL().$itemlink."#c".$cid."\">¡Ø".$ititle."¡Ù ¤Ø¤Î¥³¥á¥ó¥È</a></span><br />".$ctext."<br /><span class=\"iteminfo\">".$myname." posted on $ctst</span></li>" ;
+//             echo $l_comments;
+             
+				if(!$arr_res){$arr_res = array();}
+//				array_push($arr_res,array($ct => $l_comments));
+             $arr_res[$ct] = $l_comments;
+             
+         }
+
+
+//=========================
+
+        $query = "SELECT t.title, t.excerpt, t.tb_id, t.blog_name, t.timestamp ,UNIX_TIMESTAMP(t.timestamp) as ttimest ,t.url ,i.inumber, i.ititle 
+        FROM nucleus_plugin_tb t ,nucleus_item i 
+        WHERE t.tb_id = i.inumber 
+        ORDER by timestamp DESC 
+        LIMIT 0,".$numberOfWritebacks;
+
+        $comments = mysql_query($query);
+
+        while($row = mysql_fetch_object($comments)) {
+             $text  = $row->excerpt;
+//             $text  = strip_tags($text);
+//             $ctext = mb_substr($text, 0, $numberOfCharacters);
+
+             $title = $row->title;
+//             $ctitle = substr($title, 0, $numberOfTitleCharacters+1);
+//             $ctitle = mb_substr($ctitle, 0, -1);
+
+             $blogname = $row->blog_name;
+             $tbtime = $row->ttimest;
+             $ititle  = htmlspecialchars(strip_tags($row->ititle));
+             $url = $row->url;
+             $ttst  = date("Y-m-d H:i",$tbtime);
+
+             $itemlink = createItemLink($row->tb_id, '');
+//             echo "<li><a href=\"".$b->getURL().$itemlink."#trackback\">¢£".$tbtime.":";
+//             echo $blogname."¤«¤é";
+//             echo $ctitle.$ctext;
+//             echo "....</a></li>";
+             
+             $l_tbs = "<li class=itembody>¢¡ <span class=\"iteminfo\"><a href=\"".$b->getURL().$itemlink."#trackback\">¡Ø".$ititle."¡Ù¤Ø¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯</a></span><br />## ".$title." ##<br />".$text."<br /><span class=\"iteminfo\">¡Ø<a href=\"$url\">{$blogname}</a>¡Ù pinged on ".$ttst."</span></li>";
+
+//				if(!$arr_res){$arr_res = array();}
+//				array_push($arr_res,$l_tbs);
+             $arr_res[$tbtime] = $l_tbs;
+
+
+
+         }
+//=========================
+
+
+
+krsort ($arr_res);
+$output = array_slice ($arr_res, 0, $numberOfWritebacks);
+//             print_r($output);
+
+		echo '<h3>¥³¥á¥ó¥È¤È¥È¥é¥Ã¥¯¥Ð¥Ã¥¯ ºÇ¿·'.$numberOfWritebacks.'·ï</h3>';
+		echo ' <ul class="nobullets"> ';
+
+		foreach($output as $key => $value){
+			echo $value."\n";
+		}
+		echo " </ul> ";
+
+//**********************************************
+}else{
+
+		$template = TEMPLATE::read($template);
+		$data['blogid'] = $blogid;
+//===================================
+		echo TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
+//===================================
+		echo '<a href="http://'.$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'].'">HOME</a> ';
+		if($catid){
+			$catName = $blog->getCategoryName($catid);	//¥«¥Æ¥´¥ê¤Î̾Á°¤òget
+//			$catName = $blog->getCategoryDesc($catid);	//¥«¥Æ¥´¥ê¤ÎÀâÌÀ¤òget
+			$archivealllistlink = createArchiveListLink($blogid,"");
+			echo ' > <a href="'.$archivealllistlink.'">Archive List</a>';
+			echo ' > Category : <u> '.$catName.' </u> ';
+		}else{
+//			echo 'Category : ÁªÂò¤·¤Æ¤¤¤Þ¤»¤ó';
+			echo ' > Archive List';
+			echo '';
+		}
+//===================================
+		echo TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
+//===================================
+		echo TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
+		$now = time();
+		$query = 'SELECT UNIX_TIMESTAMP(itime) as itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM nucleus_item'
+		. ' WHERE iblog=' . $blogid
+		. ' and UNIX_TIMESTAMP(itime)<=' . $now	// don't show future items!
+		. ' and idraft=0'; // don't show draft items
+		
+		if ($catid)
+			$query .= ' and icat=' . intval($catid);
+		
+		$query .= ' GROUP BY Year, Month';
+		if ($mode == 'day')
+			$query .= ', Day';
+		
+			
+//		$query .= ' ORDER BY itime ASC';	//¥¢¡¼¥«¥¤¥Ö¥ê¥¹¥È¾º½ç
+		$query .= ' ORDER BY itime DESC';	//¥¢¡¼¥«¥¤¥Ö¥ê¥¹¥È¹ß½ç
+		
+		if ($limit > 0) 
+			$query .= ' LIMIT ' . $limit;
+		
+		$res = sql_query($query);
+
+		while ($current = mysql_fetch_object($res)) {
+			if ($mode == 'day') {
+				$archivedate = date('Y-m-d',$current->itime);
+				$archive['day'] = date('d',$current->itime);
+			} else {
+				$archivedate = date('Y-m',$current->itime);			
+			}
+			$data['month'] = date('m',$current->itime);
+			$data['year'] = date('Y',$current->itime);
+			$data['archivelink'] = createArchiveLink($blogid,$archivedate,$this->linkparams);
+
+			$temp = TEMPLATE::fill($template['ARCHIVELIST_LISTITEM'],$data);
+			echo strftime($temp,$current->itime);
+			
+	//======================================================		
+	echo '<ul>';
+		$adquery = 'SELECT inumber, ititle, icat FROM nucleus_item'
+		. ' WHERE iblog=' . $blogid
+		. ' and UNIX_TIMESTAMP(itime)<=' . $now	// don't show future items!
+		. ' and idraft=0' // don't show draft items
+		. ' and SUBSTRING(itime,1,4)=' . $data['year']	// year
+		. ' and SUBSTRING(itime,6,2)=' . $data['month'];	// month
+		if ($mode == 'day')
+			$adquery .= ' and SUBSTRING(itime,9,2)=' . $archive['day']; //day
+		
+		if ($catid)
+			$adquery .= ' and icat=' . intval($catid);
+		
+//		$adquery .= ' ORDER BY itime ASC';	//¥¿¥¤¥È¥ë°ìÍ÷¾º½ç
+		$adquery .= ' ORDER BY itime DESC';	//¥¿¥¤¥È¥ë°ìÍ÷¹ß½ç
+		
+//		if ($limit > 0) 
+//			$adquery .= ' LIMIT ' . $limit;
+		
+		$adres = sql_query($adquery);
+		
+		while ($adcurrent = mysql_fetch_object($adres)) {
+			$ititle = htmlspecialchars(strip_tags($adcurrent->ititle));
+			$inumber = $adcurrent->inumber;
+			$itemlink = createItemLink($inumber,$this->linkparams);
+
+			if($catid){
+			echo '<li><a href="'.$itemlink.'">'. $ititle . '</a></li>'."\n";
+			}else{
+			$icatName = $blog->getCategoryName($adcurrent->icat);	//¥«¥Æ¥´¥ê¤Î̾Á°¤òget
+//			$icatName = $blog->getCategoryDesc($adcurrent->icat);	//¥«¥Æ¥´¥ê¤ÎÀâÌÀ¤òget
+			//¥¿¥¤¥È¥ë°ìÍ÷¤Ë³¤¤¤Æ¥«¥Æ¥´¥ê̾¤òɽ¼¨
+//			echo '<li><a href="'.$itemlink.'">'. $ititle . ' <small>::' . $icatName .'</small></a></li>'."\n";
+			//¥¿¥¤¥È¥ë°ìÍ÷¤Ë¥Þ¥¦¥¹¤ò¤¢¤ï¤»¤ë¤È¥«¥Æ¥´¥ê̾¤ò¥Õ¥í¡¼¥Èɽ¼¨
+			echo '<li><a href="'.$itemlink.'" title="Category:'.$icatName.'">'. $ititle . '</a></li>'."\n";
+			}
+		}
+		mysql_free_result($adres);
+	echo '</ul>';
+	//======================================================
+		}
+		mysql_free_result($res);
+		echo TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
+
+}
+
+		break;
+//===================================
+	default: 
+//				echo "tttt";
+		} 
+	}
+}
+?>
\ No newline at end of file
diff --git a/NP_ArchiveListEX/trunk/NP_ArchiveListEX.php b/NP_ArchiveListEX/trunk/NP_ArchiveListEX.php
index 1bc45e8..367eaa3 100644
--- a/NP_ArchiveListEX/trunk/NP_ArchiveListEX.php
+++ b/NP_ArchiveListEX/trunk/NP_ArchiveListEX.php
@@ -15,20 +15,69 @@ class NP_ArchiveListEX extends NucleusPlugin {
 	// an URL to the plugin website
 	function getURL() 
 	{
-		return 'http://xx.nakahara21.net/'; 
+		return 'http://nakahara21.com/'; 
 	}
 	
 	// version of the plugin
 	function getVersion() {
-		return '0.6'; 
+		return '1.01'; 
 	}
 	
+	function supportsFeature($what) { 
+		switch($what){ 
+			case 'SqlTablePrefix': 
+				return 1; 
+			default: 
+				return 0; 
+		} 
+	}
+
 	// a description to be shown on the installed plugins listing
 	function getDescription() { 
-		return 'Show all item title on each archive list. <br />[Required] template: name of the template to use <br />[Optional] mode: [month]shows an entry for each month , [day]shows an entry for each day  <br />[Optional] limit:  limits the amount of links shown (e.g. if you only want to show links to the past 3 months)<br /><br />Usage1: &lt;%ArchiveListEX(default)%&gt; or &lt;%ArchiveListEX(default,month)%&gt; instead of &lt;%archivelist(default)%&gt;,<br />Usage2:  &lt;%ArchiveListEX(default,day,5)%&gt; instead of &lt;%archivedaylist(default,5)%&gt;,<br />Usage3:  &lt;%ArchiveListEX(default,5)%&gt;';
+		return 'Show all item title on each archive list. ';
+	}
+
+	function doAction($type) {
+		
+		$archiveMonth = intRequestVar('a');
+		$bid = intRequestVar('b');
+		$tid = intRequestVar('t');
+
+		switch ($type) {
+			case 'ga' :
+				echo '<ul>'.$this->getArchives($tid, $bid, $archiveMonth).'</ul>';
+				break;
+			default :
+				return 'No such action';
+				break;
+		}
+	}
+
+	function getArchives($tid, $bid, $archiveMonth){
+		global $manager;
+		$b =& $manager->getBlog($bid);
+		
+		list($year, $month) = sscanf($archiveMonth, "%4s%2s");
+
+		$extraQuery = ' and SUBSTRING(itime,1,4)=' . $year
+					. ' and SUBSTRING(itime,6,2)=' . $month;
+		
+		$template = TEMPLATE::getNameFromId($tid);
+
+		ob_start();
+		$b->readLogAmount($template, 0, $extraQuery, 0, 1, 0);
+		$contents =  ob_get_contents();
+		ob_end_clean();
+
+		if (_CHARSET != 'UTF-8'){
+			$contents = mb_convert_encoding($contents, 'UTF-8', _CHARSET);
+		}
+		
+		return $contents;
 	}
 
-   function doSkinVar($skinType, $template = 'default', $mode = 'month', $limit = 0) { 
+
+	function doSkinVar($skinType, $template = 'default/index', $mode = 'month', $limit = 0) { 
 		global $manager, $blog, $CONF, $catid, $itemid; 
 
 		$params = func_get_args();
@@ -44,161 +93,56 @@ class NP_ArchiveListEX extends NucleusPlugin {
 	} else { 
 		$b =& $manager->getBlog($CONF['DefaultBlog']); 
 	} 
-	$blogid = $b->getID();
 
 		if ($catid) {
 			$this->linkparams = array('catid' => $catid);
 		}
 
-switch($skinType) { 
-	case 'archivelist': 
-
-//**********************************************
-if($_REQUEST['mode'] == "remarks"){
-
-		$numberOfWritebacks   = 50; // defaults to 50
-
-		// select
-        $query = "SELECT c.cnumber, c.cuser, c.cbody, c.citem, c.cmember, c.ctime ,UNIX_TIMESTAMP(c.ctime) as ctimest ,i.inumber, i.ititle 
-        FROM nucleus_comment c ,nucleus_item i 
-        WHERE c.citem = i.inumber 
-        ORDER by ctime DESC 
-        LIMIT 0,".$numberOfWritebacks;
-
-        $comments = mysql_query($query);
-//             echo ' <ul class="nobullets"> ';
-
-        while($row = mysql_fetch_object($comments)) {
-             $cid  = $row->cnumber;
-             $ititle  = htmlspecialchars(strip_tags($row->ititle));
-             $ct  = $row->ctimest;
-             $ctst  = date("Y-m-d H:i",$ct);
-             $ctext  = $row->cbody;
-//             $ctext  = strip_tags($text);
-//             $ctext = substr($text, 0, $numberOfCharacters);
-//             $ctext = mb_substr($ctext, 0, -1);
-
-             if (!$row->cmember) $myname = $row->cuser;
-             else {
-                   $mem = new MEMBER;
-                   $mem->readFromID(intval($row->cmember));
-                   $myname = $mem->getDisplayName();
-             }
-             $itemid= $row->citem;
-             $itemlink = createItemLink($row->citem, '');
-             $l_comments =  "<li class=itembody>¢£ <span class=\"iteminfo\"><a href=\"".$b->getURL().$itemlink."#c".$cid."\">¡Ø".$ititle."¡Ù ¤Ø¤Î¥³¥á¥ó¥È</a></span><br />".$ctext."<br /><span class=\"iteminfo\">".$myname." posted on $ctst</span></li>" ;
-//             echo $l_comments;
-             
-				if(!$arr_res){$arr_res = array();}
-//				array_push($arr_res,array($ct => $l_comments));
-             $arr_res[$ct] = $l_comments;
-             
-         }
-
-
-//=========================
-
-        $query = "SELECT t.title, t.excerpt, t.tb_id, t.blog_name, t.timestamp ,UNIX_TIMESTAMP(t.timestamp) as ttimest ,t.url ,i.inumber, i.ititle 
-        FROM nucleus_plugin_tb t ,nucleus_item i 
-        WHERE t.tb_id = i.inumber 
-        ORDER by timestamp DESC 
-        LIMIT 0,".$numberOfWritebacks;
-
-        $comments = mysql_query($query);
-
-        while($row = mysql_fetch_object($comments)) {
-             $text  = $row->excerpt;
-//             $text  = strip_tags($text);
-//             $ctext = mb_substr($text, 0, $numberOfCharacters);
-
-             $title = $row->title;
-//             $ctitle = substr($title, 0, $numberOfTitleCharacters+1);
-//             $ctitle = mb_substr($ctitle, 0, -1);
-
-             $blogname = $row->blog_name;
-             $tbtime = $row->ttimest;
-             $ititle  = htmlspecialchars(strip_tags($row->ititle));
-             $url = $row->url;
-             $ttst  = date("Y-m-d H:i",$tbtime);
-
-             $itemlink = createItemLink($row->tb_id, '');
-//             echo "<li><a href=\"".$b->getURL().$itemlink."#trackback\">¢£".$tbtime.":";
-//             echo $blogname."¤«¤é";
-//             echo $ctitle.$ctext;
-//             echo "....</a></li>";
-             
-             $l_tbs = "<li class=itembody>¢¡ <span class=\"iteminfo\"><a href=\"".$b->getURL().$itemlink."#trackback\">¡Ø".$ititle."¡Ù¤Ø¤Î¥È¥é¥Ã¥¯¥Ð¥Ã¥¯</a></span><br />## ".$title." ##<br />".$text."<br /><span class=\"iteminfo\">¡Ø<a href=\"$url\">{$blogname}</a>¡Ù pinged on ".$ttst."</span></li>";
-
-//				if(!$arr_res){$arr_res = array();}
-//				array_push($arr_res,$l_tbs);
-             $arr_res[$tbtime] = $l_tbs;
+//switch($skinType) { 
+//	case 'archivelist': 
 
+		$tid = TEMPLATE::getIdFromName($template);
+		$template = TEMPLATE::read($template);
+		$data['blogid'] = $b->getID();
 
+		$jshref = $CONF['PluginURL'].'sharedlibs/miniajax.js';
+		$href = htmlspecialchars($CONF['ActionURL'], ENT_QUOTES) . '?action=plugin&name=ArchiveListEX&type=ga&t='.$tid.'&b='.$b->getID().'&a=';
 
-         }
-//=========================
-
-
-
-krsort ($arr_res);
-$output = array_slice ($arr_res, 0, $numberOfWritebacks);
-//             print_r($output);
-
-		echo '<h3>¥³¥á¥ó¥È¤È¥È¥é¥Ã¥¯¥Ð¥Ã¥¯ ºÇ¿·'.$numberOfWritebacks.'·ï</h3>';
-		echo ' <ul class="nobullets"> ';
-
-		foreach($output as $key => $value){
-			echo $value."\n";
-		}
-		echo " </ul> ";
 
-//**********************************************
-}else{
+?>
+<script type="text/javascript" src="<?php echo $jshref; ?>"></script>
+<script type="text/javascript"><!--
+function getData(id){
+	ajax.update("<?php echo $href; ?>"+id, "result"+id);
+}
+// --></script>
+<?php
 
-		$template = TEMPLATE::read($template);
-		$data['blogid'] = $blogid;
-//===================================
-		echo TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
-//===================================
-		echo '<a href="http://'.$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'].'">HOME</a> ';
-		if($catid){
-			$catName = $blog->getCategoryName($catid);	//¥«¥Æ¥´¥ê¤Î̾Á°¤òget
-//			$catName = $blog->getCategoryDesc($catid);	//¥«¥Æ¥´¥ê¤ÎÀâÌÀ¤òget
-			$archivealllistlink = createArchiveListLink($blogid,"");
-			echo ' > <a href="'.$archivealllistlink.'">Archive List</a>';
-			echo ' > Category : <u> '.$catName.' </u> ';
-		}else{
-//			echo 'Category : ÁªÂò¤·¤Æ¤¤¤Þ¤»¤ó';
-			echo ' > Archive List';
-			echo '';
-		}
 //===================================
-		echo TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
-//===================================
-		echo TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
-		$now = time();
-		$query = 'SELECT UNIX_TIMESTAMP(itime) as itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM nucleus_item'
-		. ' WHERE iblog=' . $blogid
-		. ' and UNIX_TIMESTAMP(itime)<=' . $now	// don't show future items!
+		$query = 'SELECT count(*) as sum, itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM '.sql_table('item')
+		. ' WHERE iblog=' . $b->getID()
+		. ' and itime <=' . mysqldate($b->getCorrectTime())	// don't show future items!
 		. ' and idraft=0'; // don't show draft items
 		
 		if ($catid)
 			$query .= ' and icat=' . intval($catid);
-		
+/**/		
 		$query .= ' GROUP BY Year, Month';
 		if ($mode == 'day')
 			$query .= ', Day';
 		
 			
-//		$query .= ' ORDER BY itime ASC';	//¥¢¡¼¥«¥¤¥Ö¥ê¥¹¥È¾º½ç
-		$query .= ' ORDER BY itime DESC';	//¥¢¡¼¥«¥¤¥Ö¥ê¥¹¥È¹ß½ç
+//		$query .= ' ORDER BY itime ASC';	
+		$query .= ' ORDER BY itime DESC';	
 		
 		if ($limit > 0) 
 			$query .= ' LIMIT ' . $limit;
 		
 		$res = sql_query($query);
 
+		$oldYear = 0;
 		while ($current = mysql_fetch_object($res)) {
+			$current->itime = strtotime($current->itime);	// string time -> unix timestamp
 			if ($mode == 'day') {
 				$archivedate = date('Y-m-d',$current->itime);
 				$archive['day'] = date('d',$current->itime);
@@ -207,63 +151,34 @@ $output = array_slice ($arr_res, 0, $numberOfWritebacks);
 			}
 			$data['month'] = date('m',$current->itime);
 			$data['year'] = date('Y',$current->itime);
-			$data['archivelink'] = createArchiveLink($blogid,$archivedate,$this->linkparams);
+			$data['archivelink'] = createArchiveLink($b->getID(),$archivedate,$this->linkparams);
+			$data['sum'] = $current->sum;
+			$data['monthid'] = $current->Year.$current->Month;
+			
+			if($oldYear && $data['year'] != $oldYear){
+				$tempf = TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
+				echo $lastFooter = strftime($tempf,$current->itime);
+			}
+
+			if($data['year'] != $oldYear){
+				$temph = TEMPLATE::fill($template['ARCHIVELIST_HEADER'],$data);
+				echo strftime($temph,$current->itime);
+			}
 
 			$temp = TEMPLATE::fill($template['ARCHIVELIST_LISTITEM'],$data);
 			echo strftime($temp,$current->itime);
-			
-	//======================================================		
-	echo '<ul>';
-		$adquery = 'SELECT inumber, ititle, icat FROM nucleus_item'
-		. ' WHERE iblog=' . $blogid
-		. ' and UNIX_TIMESTAMP(itime)<=' . $now	// don't show future items!
-		. ' and idraft=0' // don't show draft items
-		. ' and SUBSTRING(itime,1,4)=' . $data['year']	// year
-		. ' and SUBSTRING(itime,6,2)=' . $data['month'];	// month
-		if ($mode == 'day')
-			$adquery .= ' and SUBSTRING(itime,9,2)=' . $archive['day']; //day
-		
-		if ($catid)
-			$adquery .= ' and icat=' . intval($catid);
-		
-//		$adquery .= ' ORDER BY itime ASC';	//¥¿¥¤¥È¥ë°ìÍ÷¾º½ç
-		$adquery .= ' ORDER BY itime DESC';	//¥¿¥¤¥È¥ë°ìÍ÷¹ß½ç
-		
-//		if ($limit > 0) 
-//			$adquery .= ' LIMIT ' . $limit;
-		
-		$adres = sql_query($adquery);
-		
-		while ($adcurrent = mysql_fetch_object($adres)) {
-			$ititle = htmlspecialchars(strip_tags($adcurrent->ititle));
-			$inumber = $adcurrent->inumber;
-			$itemlink = createItemLink($inumber,$this->linkparams);
 
-			if($catid){
-			echo '<li><a href="'.$itemlink.'">'. $ititle . '</a></li>'."\n";
-			}else{
-			$icatName = $blog->getCategoryName($adcurrent->icat);	//¥«¥Æ¥´¥ê¤Î̾Á°¤òget
-//			$icatName = $blog->getCategoryDesc($adcurrent->icat);	//¥«¥Æ¥´¥ê¤ÎÀâÌÀ¤òget
-			//¥¿¥¤¥È¥ë°ìÍ÷¤Ë³¤¤¤Æ¥«¥Æ¥´¥ê̾¤òɽ¼¨
-//			echo '<li><a href="'.$itemlink.'">'. $ititle . ' <small>::' . $icatName .'</small></a></li>'."\n";
-			//¥¿¥¤¥È¥ë°ìÍ÷¤Ë¥Þ¥¦¥¹¤ò¤¢¤ï¤»¤ë¤È¥«¥Æ¥´¥ê̾¤ò¥Õ¥í¡¼¥Èɽ¼¨
-			echo '<li><a href="'.$itemlink.'" title="Category:'.$icatName.'">'. $ititle . '</a></li>'."\n";
-			}
-		}
-		mysql_free_result($adres);
-	echo '</ul>';
-	//======================================================
+			$oldYear = $data['year'];
+
 		}
 		mysql_free_result($res);
-		echo TEMPLATE::fill($template['ARCHIVELIST_FOOTER'],$data);
-
-}
+		echo $lastFooter;
 
-		break;
+//		break;
 //===================================
-	default: 
+//	default: 
 //				echo "tttt";
-		} 
+//		} 
 	}
 }
 ?>
\ No newline at end of file
diff --git a/NP_ArchiveListEX/trunk/sharedlibs/miniajax.js b/NP_ArchiveListEX/trunk/sharedlibs/miniajax.js
new file mode 100644
index 0000000..6186968
--- /dev/null
+++ b/NP_ArchiveListEX/trunk/sharedlibs/miniajax.js
@@ -0,0 +1,12 @@
+function $(e){if(typeof e=='string')e=document.getElementById(e);return e};
+function collect(a,f){var n=[];for(var i=0;i<a.length;i++){var v=f(a[i]);if(v!=null)n.push(v)}return n};
+
+ajax={};
+ajax.x=function(){try{return new ActiveXObject('Msxml2.XMLHTTP')}catch(e){try{return new ActiveXObject('Microsoft.XMLHTTP')}catch(e){return new XMLHttpRequest()}}};
+ajax.serialize=function(f){var g=function(n){return f.getElementsByTagName(n)};var nv=function(e){if(e.name)return encodeURIComponent(e.name)+'='+encodeURIComponent(e.value);else return ''};var i=collect(g('input'),function(i){if((i.type!='radio'&&i.type!='checkbox')||i.checked)return nv(i)});var s=collect(g('select'),nv);var t=collect(g('textarea'),nv);return i.concat(s).concat(t).join('&');};
+ajax.send=function(u,f,m,a){var x=ajax.x();x.open(m,u,true);x.onreadystatechange=function(){if(x.readyState==4)f(x.responseText)};if(m=='POST')x.setRequestHeader('Content-type','application/x-www-form-urlencoded');x.send(a)};
+ajax.get=function(url,func){ajax.send(url,func,'GET')};
+ajax.gets=function(url){var x=ajax.x();x.open('GET',url,false);x.send(null);return x.responseText};
+ajax.post=function(url,func,args){ajax.send(url,func,'POST',args)};
+ajax.update=function(url,elm){var e=$(elm);var f=function(r){e.innerHTML=r};ajax.get(url,f)};
+ajax.submit=function(url,elm,frm){var e=$(elm);var f=function(r){e.innerHTML=r};ajax.post(url,f,ajax.serialize(frm))};
-- 
2.11.0