Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-11-28 22:07:00
- nzaccardi
- Member
- Registered: 2009-10-29
- Posts: 13
Month/category based archive, url help
I know this must have been asked before, it must have been!!
I have a section called /archives/ and after the section it could be /?c=design meaning display all the articles in the design category or it could be /2009-11 meaning display all the articles in 2009 for the month of november.
Can some one direct me to a location that can help me how to do this. Or if this question has never been asked before (which I doubt) can you explain a process to do this? I have been looking for days!
Offline
Re: Month/category based archive, url help
How would you link to the different categories? Are they all article categories?
adi_gps would be a good candidate for this if you need to check the URL first. I have some code somewhere for this I think – can put it up as a TXP Tip tomorrow maybe.
Offline
#3 2009-11-28 23:05:57
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Month/category based archive, url help
nzaccardi wrote:
or it could be /2009-11 meaning display all the articles in 2009 for the month of november.
That should be /?month=2009-11. But I’m not sure what exactly you are asking…
Offline
#4 2009-11-29 04:31:29
- nzaccardi
- Member
- Registered: 2009-10-29
- Posts: 13
Re: Month/category based archive, url help
To clarify,
The major question is how do I pull category or year/month specific article lists? All of the categories will be article categories.
Offline
Re: Month/category based archive, url help
nzaccardi, I knew I had written about this but could not find it until now – check this tip out – its for category based archives.
Offline
#6 2009-11-29 10:12:53
- nzaccardi
- Member
- Registered: 2009-10-29
- Posts: 13
Re: Month/category based archive, url help
jstubbs,
Exactly what I am looking for.
TO further this however, is there a way to expand this to dynamically pull the month as well.
You talk about doing this: category=’<txp:category />’
Is there anything to the extent of: month=”<txp:date />” Where data is the date specified in the URL
Thanks bunches
Offline
Re: Month/category based archive, url help
This other tip should be helpful, but I think what you need is the adi_gps plugin which enables you to extract a variable from the URL.
Offline
Re: Month/category based archive, url help
I don’t really understand if you need two different types of menu (like in this old and unmantained site – look right column: cat & months menus) or if you need the two things working together (cat&month listing).
Offline
#9 2009-11-29 10:52:35
- nzaccardi
- Member
- Registered: 2009-10-29
- Posts: 13
Re: Month/category based archive, url help
That is exactly what I am looking for. A perfect example. I want a list of categories, such that when you click on one it brings you to an archives page and ONLY shows you the entries in that category. Also I would like a list of dates (Sept-2009) such that when you click on it, the user is brought to the Archive page with ONLY the entries posted in that month. I do not need them nested such that it is broken up by category and month/year.
Offline
Re: Month/category based archive, url help
Ah, then you need upm_date_archive plugin. Check out this txp tip for a short tutorial.
Offline
#11 2009-11-29 11:04:04
- nzaccardi
- Member
- Registered: 2009-10-29
- Posts: 13
Re: Month/category based archive, url help
jstubbs,
Funny part is, I have that plug-in installed but could never figure out how to actually use it on the Archive page. However right now it is what is powering my sidebars.
I will look more into this.
Thanks!
Offline
Re: Month/category based archive, url help
Okay, here we go. I obtained this with the following code:
For the cat listing:
<txp:stw_category_tree start="argomenti" cssid="cat" section="archivio" count="true" onclass="attivo" />which rely on this old and useful plugin. I think I modified it a bit, but it was an older version than the one that’s online. So maybe modidication isn’t necessary. Please note that all my cats have cat ‘argomenti’ as parent.
For the date archive:
<txp:rss_suparchive_menu section="blog,articoli" linktosection="archivio" mode="MONTH" limit="20" />which uses this old plugin. The plugin seem not accessible, so I paste it below from my install (v. 0.15, working with txp 4.0.8).
I think this can be done with other plugin, like upm_date_archive. Look into it.
Here is the plugin code: you have to compile it for yourself (use this ied_plugin_composer with txp 4.2.0: I can’t use it because I still run 4.0.8 in that site).
// rss_suparchive article listing plugin
// by Rob Sable
// http://www.wilshireone.com
// Version 0.1 - 11/02/2004
// Full revision history at http://www.wilshireone.com/textpattern-plugins/rss-suparchive
// Version 0.12 - 03/22/2005 - Added showcatsonly to suparchive_bycat. Updated permlink calls to use new RC3 functions.
// Version 0.14 - 03/29/2005 - Added form to suparchive_bycat. Added filtering by day in addition to year and month to rss_suparchive. Fixed timeframe filter. Permlink/forms updates.
// Version 0.15 - 05/01/2005 - Added formwraptag, addbreak, showdate, dateformat, datesep, showexcerpt, showauthor, authorsep and date filtering to suparchive_bycat. Fixed jump to link on suparchive_bycat. Current article removed from related list using suparchive_bycat. Fixes for form usage on suparchive_bycat. Changed rssMenu id to a class.
function rss_suparchive_menu($atts) {
global $s, $pretext;
extract($atts);
extract($pretext);
$section = isset($section) ? $section : "article";
$linktosection = isset($linktosection) ? $linktosection : $s;
$timeframe= isset($timeframe) ? $timeframe: "PAST";
$limit = isset($limit) ? $limit : 6;
$showheader = isset($showheader) ? $showheader : "0";
$headerlabel = isset($headerlabel) ? $headerlabel : "Monthly Archives";
$headerlevel = isset($headerlevel) ? $headerlevel : "2";
$showcount = isset($showcount) ? $showcount : "1";
$countlabel = isset($countlabel) ? $countlabel : "";
$mode = isset($mode) ? $mode : "MONTH";
foreach (explode(',', $section) as $section) {
$sctsql[] = " (section = '" . doSlash($section) . "') ";
}
$sections = ' AND (' . join(' OR ', $sctsql) . ') ';
$posted= ($timeframe == "FUTURE") ? " AND Posted >= now() ORDER BY posted asc " : " AND posted < now() ORDER BY posted desc ";
$posted= isset($posted) ? $posted : " ORDER BY posted desc ";
$where = "status=4 $sections $posted";
$res = safe_rows("id, unix_timestamp(posted) as posted","textpattern", $where);
if( $res ) {
$dateformat = ($mode == "YEAR") ? "%Y" : "%B %Y";
$c=-1; $p=0; $lasto="";
$lastd = safe_strftime($dateformat,$res[0]["posted"]);
$output[] = ($showheader) ? '<h' .$headerlevel. '>' .$headerlabel. '</h' .$headerlevel. '>'.n : '';
$output[] = '<ul class="rssMenu">'.n;
foreach( $res as $a ) {
$date = safe_strftime($dateformat,$a["posted"]);
$datelink = ($mode == "YEAR") ? "/".safe_strftime('%Y',$lasto) : "/".safe_strftime('%Y',$lasto)."/".safe_strftime('%m',$lasto);
$c++;
$count = ($showcount) ? ' <span class="rssMonthCount">('.$c.$countlabel.')</span>' : '';
$output[] = ($lastd != $date && $p <= ($limit-1)) ? '<li><a href="'.hu.$linktosection.$datelink.'">'.$lastd.$count.'</a></li>'.n : "";
if ($p <= ($limit-1)) {
if ($lastd != $date) { $c=0; $p++; };
$lastd = $date;
$lasto = $a["posted"];
}
}
$datelink = ($mode == "YEAR") ? "/".safe_strftime('%Y',$lasto) : "/".safe_strftime('%Y',$lasto)."/".safe_strftime('%m',$lasto);
$count = ($showcount) ? ' <span class="rssMonthCount">('.($c+1).$countlabel.')</span>' : '';
$output[] = ($p <= ($limit-1)) ? '<li><a href="'.hu.$linktosection.$datelink.'">'.$lastd.$count.'</a></li>'.n : '';
$output[] = '</ul>'.n.n;
return implode( "", $output);
}
return;
}
function rss_suparchive($atts) {
global $siteurl, $c, $s, $url_mode, $pretext;
extract($atts);
extract($pretext);
$section = isset($section) ? $section : "article";
if (isset($category)) { $category = doSlash($category); }
else { $category = isset($nocatfilter) ? "" : $c ; }
$author = isset($author) ? $author : gps('author');
$dateformat = isset($dateformat) ? $dateformat : "F j, Y";
$showsection = isset($showsection) ? $showsection: "0";
$showcats= isset($showcats) ? $showcats: "0";
$showauthor= isset($showauthor) ? $showauthor: "0";
$showexcerpt= isset($showexcerpt) ? $showexcerpt: "0";
$secstart= isset($secstart) ? $secstart: "in";
$catstart= isset($catstart) ? $catstart: "under";
$catsep= isset($catsep) ? $catsep: "and";
$authorsep= isset($authorsep) ? $authorsep: "by";
$addbreak = isset($addbreak) ? $addbreak : "0";
$showsubdate = isset($showsubdate) ? $showsubdate: "0";
$subdateformat = isset($subdateformat) ? $subdateformat : "d";
$subdatesep= isset($subdatesep) ? $subdatesep : ": ";
$limit= isset($limit) ? $limit : "999999999";
$form= isset($form) ? $form : "";
$sortby= isset($sortby) ? $sortby : "";
$timeframe= isset($timeframe) ? $timeframe : "PAST";
foreach (explode(',', $section) as $section) {
$sctsql[] = " (section = '" . doSlash($section) . "') ";
}
$sections = ' AND (' . join(' OR ', $sctsql) . ') ';
foreach (explode(',', $category) as $category) {
if ($category) $catsql[] = " (category1 = '" . urldecode($category) . "') OR (category2 = '" . urldecode($category) . "') ";
}
$categories= isset($catsql) ? ' AND (' . join(' OR ', $catsql) . ') ' : "";
foreach (explode(',', $author) as $author) {
if ($author) $authsql[] = " (authorid = '" . $author . "') ";
}
$authors= isset($authsql) ? ' AND (' . join(' OR ', $authsql) . ') ' : "";
$offsetsql= isset($offset) ? 'LIMIT '.$offset.',9999999999' : "";
switch ($timeframe) {
case "FUTURE":
$posted = " AND posted >= now() ";
break;
case "PAST":
$posted = " AND posted < now() ";
break;
case "ALL":
$posted = "";
break;
case "RECENT":
$posted = " AND posted <= FROM_UNIXTIME(".$prev_posted.")";
break;
case "LATER":
$posted = " AND posted >= FROM_UNIXTIME(".$next_posted.")";
break;
default:
$posted = "";
}
$orderby= ($timeframe == "FUTURE") ? " ORDER BY posted asc " : " ORDER BY posted desc ";
$orderby= ($sortby == "RANDOM") ? " ORDER BY rand() " : $orderby ;
$subpath = preg_quote(preg_replace("/http:\/\/.*(\/.*)/Ui","$1",hu),"/");
$req = preg_replace("/^$subpath/i","/",serverSet('REQUEST_URI'));
extract(chopUrl($req));
$showY = ($u2 != "") ? $u2."-" : "";
$showM = ($u3 != "") ? $u3."-" : "";
$showD = ($u4 != "") ? $u4 : "";
if ($showY && is_numeric($u2)) $posted = " AND Posted LIKE '".$showY.$showM.$showD."%' ";
$where = "status=4 $sections $categories $authors $posted $orderby $offsetsql";
if ($form) {
// PAGING INFO
$total = getCount("textpattern", $where);
$numPages = ($total > 0 && $limit) ? ceil($total/$limit) : 1;
$pg = (!$pg) ? 1 : $pg;
$offset = ($pg - 1) * $limit;
$pageout['pg'] = $pg;
$pageout['numPages'] = $numPages;
$pageout['s'] = $s;
$pageout['c'] = $c;
$GLOBALS['thispage'] = $pageout;
$res = safe_rows("*, unix_timestamp(Posted) as uPosted", "textpattern", $where." LIMIT ".$offset.",".$limit);
if ($res) {
foreach($res as $a) {
extract($a);
populateArticleData($a);
$article = fetch('Form', 'txp_form', 'name', $form);
$articles[] = parse($article);
// FOR PAGING
$GLOBALS['uPosted'] = $uPosted;
$GLOBALS['limit'] = $limit;
unset($GLOBALS['thisarticle']);
}
return join('',$articles);
}
}
if ($limit) $where.= " LIMIT $limit";
$res = safe_rows("ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title, excerpt","textpattern", $where);
$lastd = date($dateformat, "0");
if ($res) {
$output[] = "<dl";
$output[] = isset($class) ? " class=\"$class\"" : "";
$output[] = isset($id) && ($id) ? " id=\"$id\"" : "";
$output[] = ">";
foreach($res as $a) {
$date = date($dateformat,$a["posted"]);
$subdate = date($subdateformat,$a["posted"]);
$title = ($a["url_title"]) ? $a["url_title"]: stripSpace($a["title"]);
$title = ($url_mode) ? $title : '';
$showtitle = $a["title"];
$section = $a["section"];
$id = $a["ID"];
$cat1 = $a["category1"];
$cat2 = $a["category2"];
$author = $a["authorid"];
$excerpt = $a["excerpt"];
$authres = safe_row("realname","txp_users", "name='$author'");
$arealname = $authres["realname"];
$permlink = permlinkurl($a);
$sectionlink = ($url_mode) ? urlencode($section) : '?s='.urlencode($section);
$cslink = ($url_mode) ? urlencode($s) : '?s='.urlencode($s);
$authorlink = ($url_mode) ? $cslink.'/?author='.urlencode($author) : $cslink.'&author='.urlencode($author);
$cat1link = ($url_mode) ? $sectionlink.'/?c='.urlencode($cat1) : $sectionlink.'&c='.urlencode($cat1);
$cat2link = ($url_mode) ? $sectionlink.'/?c='.urlencode($cat2) : $sectionlink.'&c='.urlencode($cat2);
$output[] = ($lastd != $date) ? "<dt>$date</dt>".n : "";
$output[] = "<dd>";
$output[] = ($showsubdate == "1") ? '<span class="rssSubdate">'.$subdate.$subdatesep.'</span>' : "";
$output[] = "<a href=\"$permlink\" title=\"Permanent link to $showtitle\" class=\"rssArticle";
$output[] = (++$count % 2) ? " rssAlt" : "";
$output[] = "\">";
$output[] = "$showtitle</a>";
$output[] = ($addbreak) ? "<br/>" : "";
$output[] = ($showauthor) ? " $authorsep <a href=\"$authorlink\" title=\"Link to articles by $author\" class=\"rssAuthor\">$arealname</a> " : "";
$output[] = ($showsection) ? " $secstart <a href=\"$sectionlink\" title=\"Link to $section section\" class=\"rssSection\">$section</a> " : "";
$catone = $showcats && $cat1;
$cattwo = $showcats && $cat2;
$output[] = ($catone) ? " $catstart <a href=\"$cat1link\" title=\"Link to $cat1\" class=\"rssCat\">$cat1</a> " : "";
$output[] = ($cattwo) ? " $catsep <a href=\"$cat2link\" title=\"Link to $cat2\" class=\"rssCat\">$cat2</a> " : "";
$output[] = ($showexcerpt) ? "<br/>$excerpt" : "";
$output[] = "</dd>".n;
$lastd = $date;
}
$output[] = "</dl>";
}
return ($output) ? implode('', $output) : '';
}
function rss_suparchive_bycat($atts) {
global $s, $c, $url_mode, $pretext, $siteurl, $id;
extract($atts);
$section = isset($section) ? $section : "";
$showheader = isset($showheader) ? $showheader: "0";
$headerlabel = isset($headerlabel) ? $headerlabel: "Articles By Category:";
$showmenu = isset($showmenu) ? $showmenu: "0";
$showcats = isset($showcats) ? $showcats: "1";
$showcatsonly = isset($showcatsonly) ? $showcatsonly: "0";
$showcatcount = isset($showcatcount) ? $showcatcount: "1";
$showsections = isset($showsections) ? $showsections: "0";
$showsectioncount = isset($showsectioncount) ? $showsectioncount: "0";
$showjump = isset($showjump) ? $showjump: "0";
$jumplabel = isset($jumplabel) ? $jumplabel: "^ back to top";
$useartcat1 = isset($useartcat1) ? $useartcat1: "0";
$useartcat2 = isset($useartcat2) ? $useartcat2: "0";
$useartcats = isset($useartcats) ? $useartcats: "0";
$limit= isset($limit) ? $limit: "999999999";
$timeframe= isset($timeframe) ? $timeframe: "PAST";
$linktosection = isset($linktosection) ? $linktosection."/" : "";
$form= isset($form) ? $form : "";
$formwraptag= isset($formwraptag) ? $formwraptag : "";
$addbreak = isset($addbreak) ? $addbreak : "0";
$showdate = isset($showdate) ? $showdate: "0";
$dateformat = isset($dateformat) ? $dateformat : "F j, Y";
$datesep= isset($subdatesep) ? $subdatesep : " » ";
$showexcerpt= isset($showexcerpt) ? $showexcerpt: "0";
$showauthor= isset($showauthor) ? $showauthor: "0";
$authorsep= isset($authorsep) ? $authorsep: "by ";
if ($useartcat1 || $useartcat2 || $useartcats) {
$ca = safe_row('category1, category2', 'textpattern', 'id='.$id);
extract($ca);
}
$catsql = ($useartcat1) ? " AND name = '".$category1."' " : "";
$catsql.= ($useartcat2) ? " AND name = '".$category2."' " : "";
if ($useartcats) {
$catsql = " AND (name = '".$category1."' OR name = '".$category2."') ";
} else {
if ($c && !$showcatsonly) $catsql = " AND name = '".$c."' ";
}
foreach (explode(',', $section) as $section) {
$sctsql[] = " (section = '" . doSlash($section) . "') ";
}
$secsql = ($section != null) ? ' AND (' . join(' OR ', $sctsql) . ') ' : '';
$subpath = preg_quote(preg_replace("/http:\/\/.*(\/.*)/Ui","$1",hu),"/");
$req = preg_replace("/^$subpath/i","/",serverSet('REQUEST_URI'));
extract(chopUrl($req));
$showY = ($u2 != "") ? $u2."-" : "";
$showM = ($u3 != "") ? $u3."-" : "";
$showD = ($u4 != "") ? $u4 : "";
$dateposted = ($showY && is_numeric($u3)) ? " AND Posted LIKE '".$showY.$showM.$showD."%' " : " AND posted < now()";
$q = 'SELECT DISTINCT name FROM '.PFX.'txp_category, '.PFX.'textpattern WHERE name !="default" and type="article" and (category1 = name or category2 = name) '. $catsql.$secsql .'AND status=4 '.$dateposted.' ORDER BY name';
$rsc = getRows($q,"");
if ($rsc && $showmenu) {
foreach($rsc as $r) {
extract($r);
$catname = $r["name"];
$cm[] = '<li><a href="#c_'.stripSpace($catname).'">'.$catname.'</a></li>'.n;
}
$catmenu = '<ul class="rssCatArchiveMenu">'.implode('', $cm).'</ul>'.n;
}
$out[] = (!$form) ? '<div id="rssCatArchive">'.n : '';
$out[] = ($showheader) ? '<div id="rssCatArchiveHeader">'.$headerlabel.'</div>'.n : '';
$out[] = ($showmenu) ? $catmenu : '';
$rs = getRows($q,"");
if ($rs) {
$out[] = (!$form) ? '<div id="rssCatList">'.n : '';
$out[] = ($showcatsonly && !$form) ? '<ul>' : '';
foreach($rs as $a) {
extract($a);
$catname = $a["name"];
switch ($timeframe) {
case "FUTURE":
$posted = " AND posted >= now() ";
break;
case "PAST":
$posted = " AND posted < now() ";
break;
case "ALL":
$posted = "";
break;
default:
$posted = "";
}
$posted = ($showY && is_numeric($u3)) ? " AND Posted LIKE '".$showY.$showM.$showD."%' " : $posted;
$noidsql = ($useartcat1 || $useartcat2 || $useartcats) ? "id <> ".$id." AND " : "";
$scsql = $noidsql. " (category1 = '" . doSlash($catname) . "' or category2 = '" . doSlash($catname) . "')" .$secsql. " AND status=4 $posted ORDER BY section, posted desc";
$rscnt = safe_rows("*, unix_timestamp(Posted) as uPosted, ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title","textpattern", $scsql);
$catcnt = ($showcats && $showcatcount) ? " (".count($rscnt).") " : "";
if ($showcatsonly && !$form) {
$out[] = ($showcats) ? '<li><a href="'.hu.$linktosection.'?c='.urlencode($catname).'" title="View all articles filed under '.$catname.'">'.$catname.'</a>'.$catcnt.'</li>'.n : '';
} else {
$out[] = ($showcats) ? '<div id="c_'.stripSpace($catname).'" class="rssCcat"><a href="'.hu.$linktosection.'?c='.urlencode($catname).'" title="View all articles filed under '.$catname.'">'.$catname.'</a>'.$catcnt.'</div>'.n : '';
}
if ($form) {
// PAGING INFO
$total = getCount("textpattern", $scsql);
$numPages = ($total > 0 && $limit) ? ceil($total/$limit) : 1;
$pg = (!$pg) ? 1 : $pg;
$offset = ($pg - 1) * $limit;
$pageout['pg'] = $pg;
$pageout['numPages'] = $numPages;
$pageout['s'] = $s;
$pageout['c'] = $c;
$GLOBALS['thispage'] = $pageout;
$frmWhere = $scsql." LIMIT ".$offset.",".$limit;
$res = safe_rows("*, unix_timestamp(Posted) as uPosted", "textpattern", $frmWhere);
if ($res) {
foreach($res as $b) {
extract($b);
populateArticleData($b);
$article = fetch('Form', 'txp_form', 'name', $form);
$articles[] = parse($article);
// FOR PAGING
$GLOBALS['uPosted'] = $uPosted;
$GLOBALS['limit'] = $limit;
unset($GLOBALS['thisarticle']);
}
}
$out[] = ($formwraptag) ? tag(join('',$articles), $formwraptag) : join('',$articles);
unset($articles);
}
if (!$form) {
if ($limit) $scsql.= " LIMIT $limit";
$rs3 = safe_rows("*, unix_timestamp(Posted) as uPosted, ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title","textpattern", $scsql);
$lasts = "";
}
if ($rs3 && !$showcatsonly && !$form) {
$out[] = '<ul>'.n;
foreach($rs3 as $d) {
$aid= $d["ID"];
$asection= $d["section"];
$title = ($d["url_title"]) ? $d["url_title"]: stripSpace($d["title"]);
$title = ($url_mode) ? $title : '';
$showtitle = $d["title"];
$postdate = date($dateformat,$d["posted"]);
$author = $d["authorid"];
$excerpt = $d["excerpt"];
$authres = safe_row("realname","txp_users", "name='$author'");
$arealname = $authres["realname"];
$permlink = permlinkurl($d);
if ($lasts != $asection && $showsections) {
$sctcnt = ($showsectioncount) ? " (".count($rs3).")" : "";
$out[] = '<li><div class="rssCsec">in <a href="'.hu.$asection.'/?c='.$catname.'" title="View articles filed under '.$catname.' in '.$asection.'">'.$asection.'</a>'.$sctcnt.'</div></li>'.n;
$cnt = 1;
}
$out[] = '<li class="rssCart">';
$out[] = '<a href="'.$permlink.'" title="Permanent link to '.$showtitle.'">'.$showtitle.'</a>';
$out[] = ($addbreak) ? "<br/>" : "";
$out[] = ($showauthor) ? $authorsep.$arealname : "";
$out[] = ($showdate) ? '<span class="rssSubdate">'.$datesep.$postdate.'</span>' : '';
$out[] = ($showexcerpt) ? "<br/>$excerpt" : "";
$out[] = '</li>'.n;
$cnt++;
$lasts = $asection;
}
$out[] = '</ul>'.n;
$out[] = ($showjump) ? '<div class="rssJump"><a href="#rssCatArchive">'. $jumplabel .'</a></div>' : '';
}
}
$out[] = ($showcatsonly && !$form) ? '</ul>' : '';
$out[] = (!$form) ? n.'</div>'.n.'</div>'.n : '';
}
return ($out) ? implode('', $out) : '';
}Offline