[plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

freaky · 2006-09-06 09:43:00

Hello!

I’m runniung TXP 4.0.3 and want to use the newest rss_unlimited_categories. The thing is that a can’t find “article-col-2” in the source code of my installation – so the categorylist dosn’t appear. What the hell I’m doing wrong? I’ve upgraded from 0.3.

Thanks for helping me :)

playpiggy · 2006-09-06 11:26:50

freaky wrote:

I’m runniung TXP 4.0.3 and want to use the newest rss_unlimited_categories. The thing is that a can’t find “article-col-2” in the source code of my installation – so the categorylist dosn’t appear. What the hell I’m doing wrong? I’ve upgraded from 0.3.

You need to upgrade Textpattern to 4.0.4 pre-release, 4.0-20060831.zip.

freaky · 2006-09-06 12:09:51

Thanks! Now it works pretty well!! :)

brian.zollinhofer · 2006-09-07 00:06:13

Can someone tell me how I can tell if my categories are actually “taking”? I’m assigning them, but I have a weird feeling that they aren’t actually connecting with the article. For instance, if I have a category called art, how would I display all the titles of all the articles with the category “art”? I’ve read through the 12 pages of stuff, but got myself quite confused.

I’m also using this in conjunction with ied_if_domain which may be messing things up. I don’t know….

(I’m using TXP 4.0.3 and rss_unlimited_categories 0.3 as well as rss_superarchive 0.16.1 if somehow that matters)

Last edited by brian.zollinhofer (2006-09-07 00:12:31)

mstwntd · 2006-09-07 10:55:45

Brian,

Did you look through http://www.wilshireone.com/textpattern-plugins/rss-unlimited-categories? The usage is explained pretty clearly.

To see if the categories are attached, use rss_unlimited_categories_filedunder in an article form. To pull a list of articles filed under a specific category, use rss_unlimited_categories_article_list in a page template.

Page:

<h3>Art:</h3>
<ul>
<txp:rss_unlimited_categories_article_list section="mysection" category="art" limit="10" form="cheese" />
<ul>

cheese article form:

<li><txp:permalink><txp:title /></txp:permalink></li>

Good luck.

brian.zollinhofer · 2006-09-08 01:25:06

Thanks for your help. I’m not sure why I was having such a hard time with that concept… I think I’ve got it working now though…

mstwntd · 2006-09-08 05:16:13

brian.zollinhofer wrote:
I think I’ve got it working now though…

Glad to hear it. :)

ankar · 2006-09-09 17:10:23

Hi everyone,

after I upgraded to 0.5 from 0.3 the rss_unlimited_categories_related tag does not work. I get the most recent articles instead. My textpattern version is 4.0.3.

I use the tag inside a <txp:if_individual_article> section like this: <txp:rss_unlimited_categories_related form="related_article_links" label="My Label:" limit="10" offset="1" />

Anyone with a similar problem?

Last edited by ankar (2006-09-09 19:37:11)

guitarman · 2006-09-10 00:17:32

Read this post by wilshire.

Hope this helps.

Otherwise, you could post the code used in the form.

Last edited by guitarman (2006-09-10 00:22:23)

M_i · 2006-09-10 07:46:37

ankar wrote:

after I upgraded to 0.5 from 0.3 the rss_unlimited_categories_related tag does not work. I get the most recent articles instead. My textpattern version is 4.0.3. <br><br>I use the tag inside a <txp:if_individual_article> section like this: <txp:rss_unlimited_categories_related form="related_article_links" label="My Label:" limit="10" offset="1" /><br><br>Anyone with a similar problem?

I had the same problem as long as I put the rss_unlimited_categories_related on the page (i.e. where the chh_related_articles tag I was replacing had always functioned perfectly).
In debugging mode, I got this error message:

<code>
tag_error <txp:rss_unlimited_categories_related sortby=“title” section=“mysection” form=“myform” /> -> Textpattern Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 3
SELECT c.title, c.name FROM textpattern_category as tc LEFT JOIN txp_category as c ON tc.category_id = c.id WHERE article_id= on line 61
</code><br/>

It works fine now that I’ve moved rss_unlimited_categories_related to the form instead (the form that turns out the article it’s relating to). But of course that won’t work in every layout.

PS:

If it helps, this is the process as shown in the source code:

<code> <txp:rss_unlimited_categories_related sortby=“title” section=“mysection” form=“myform” /> [SQL (0.002049): SELECT c.title, c.name FROM textpattern_category as tc LEFT JOIN txp_category as c ON tc.category_id = c.id WHERE article_id=] [SQL (0.004145): SELECT DISTINCT t.ID FROM textpattern as t LEFT JOIN textpattern_category as tc ON t.ID = tc.article_id LEFT JOIN txp_category as cat ON cat.id = tc.category_id WHERE Status=4 and Posted <= now() AND ( (section = ‘mysection’) ) ]
</code><br>

With rss_unlimited_categories in the form, it turns out this:

<code>
<txp:rss_unlimited_categories_related sortby=“title” section=“mysection” form=“myform” /> [SQL (0.000186): SELECT c.title, c.name FROM textpattern_category as tc LEFT JOIN txp_category as c ON tc.category_id = c.id WHERE article_id=5] [SQL (0.000373): SELECT DISTINCT t.ID FROM textpattern as t LEFT JOIN textpattern_category as tc ON t.ID = tc.article_id LEFT JOIN txp_category as cat ON cat.id = tc.category_id WHERE Status=4 and Posted <= now() AND ( (section = ‘mysection’) ) AND ( cat.name = ‘mycategory’ ) ]
</code><br>

Sooo… when I use rss_unlimited_categories_related on a page, it doesn’t seem to pick up on the category of the article, and causes a syntax error. It shows this on my local installation as well as on my hosted site. I first thought I had somehow missed the instruction that this tag is only to be used in forms, and not on pages like you can do with related_articles (and chh_related_articles), but if used to be possible in 0.3, then there might be a bug here…

Last edited by M_i (2006-09-10 08:15:26)

ankar · 2006-09-10 08:26:27

@guitarman
Thanks for your response.

@M_i
I tried the debugging mode and I get the same error. I will try to do something similar. Thanks a lot!

The 0.3 version worked fine when I used the tag outside a form, directly in the page layout. The new behaviour could be a bug of the 0.5 version.

Last edited by ankar (2006-09-10 08:34:53)

RafaNevarez · 2006-09-15 18:59:17

This is another Custom Mod i made to the plugin :

I added this when You want to create a “Popup List” and then use Javascript to change the page location, lets say:
<code>
<select onChange=“location.replace(this.value)”>
<option value=”/path/to/category”>Category Name</option>
<option value=”/path/to/category2”>Category 2 Name</option>
</select>
</code>

I edited the rss_unlimited_categories_list function (to use: Edit this part of the Plugin and replace)

Hope this helps someone :)

function rss_unlimited_categories_list($atts) { extract(lAtts(array( ‘section’ => ‘’, ‘time’ => ‘past’, ‘parent’ => ‘’, ‘showcount’ => 1, ‘countlinked’ => 1, ‘linktosection’ => ‘article’, ‘listwraptag’ => ‘’, ‘break’ => ‘li’, ‘wraptag’ => ‘ul’, ‘label’ => ‘’, ‘labeltag’ => ‘’, ‘class’ => ‘’, ‘breakclass’ => ‘’, ‘sortdir’ => ‘asc’, ‘activeclass’ => ‘’ ),$atts));

$sections=rssBuildSctSql($section); $time = rssBuildTimeSql($time);

$prnt = ($parent) ? “ WHERE parent = ‘$parent’ “ : “”; $rsc = getRows(“SELECT distinct c.id, c.name, c.title FROM “.PFX.“textpattern_category as tc LEFT JOIN “.PFX.“txp_category as c ON tc.category_id = c.id “.$prnt.“ORDER BY c.name “ .$sortdir);

if ($rsc) { global $c; // Custom Mods by Rafael Nevarez

$row = array(); foreach ($rsc as $a=>$b) { $aq= “SELECT *, unix_timestamp(Posted) as uPosted FROM “.PFX.“textpattern as t LEFT JOIN “.PFX.“textpattern_category as c ON t.ID = c.article_id WHERE “.$sections.” c.category_id = ‘“.$b[‘id’].”’ and t.Status = 4 “.$time.” ORDER BY t.title”; $rsa = getRows($aq); if ($rsa) { $path = hu.$linktosection.”/”.strtolower($b[‘name’]); $count = ($showcount) ? “ (“.count($rsa).”) ” : “”;

// Rafael Nevarez: Added condition for “option” break (PopupList list) if ( $break==“option” ) { $row[] = tag(htmlspecialchars($b[‘title’]),‘option’,’ class=”’. ($c $b['name'] ? $activeclass : '') .'" value="' . $path . '" title="' . htmlspecialchars($b['title']) . '"'); } else{ $row[]=($countlinked) ? tag(htmlspecialchars($b['title'].$count),'a',' class="'. ($c$b[‘name’] ? $activeclass : ‘’) .’” href=”’.$path.’” title=”’.htmlspecialchars($b[‘title’]).’”’) : tag(htmlspecialchars($b[‘title’]),‘a’,’ class=”’. ($c==$b[‘name’] ? $activeclass : ‘’) .’” href=”’ . $path . ‘” title=”’ . htmlspecialchars($b[‘title’]) . ‘”’) . $count; } } }

$break = ( $break == “option” ? ‘’ : $break ); // PopupList CleanUp return doTag(doLabel($label, $labeltag).doWrap($row, $wraptag, $break, $class, $breakclass), $listwraptag).n; } return ‘’; }

Last edited by RafaNevarez (2006-09-15 20:02:30)

Textpattern CMS

Textpattern CMS support forum

#277 2006-09-06 09:43:00

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#278 2006-09-06 11:26:50

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#279 2006-09-06 12:09:51

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#280 2006-09-07 00:06:13

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#281 2006-09-07 10:55:45

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#282 2006-09-08 01:25:06

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#283 2006-09-08 05:16:13

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#284 2006-09-09 17:10:23

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#285 2006-09-10 00:17:32

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#286 2006-09-10 07:46:37

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#287 2006-09-10 08:26:27

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

#288 2006-09-15 18:59:17

Re: [plugin] [ORPHAN] rss_unlimited_categories - Unltd. Article Categories

Board footer