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

wilshire · 2006-08-10 21:24:52

Cool. That’s a deal.

Unfortunately, you won’t be able to bring the drinks on the plane. And possibly the cheese.

jonhicks · 2006-08-10 21:37:59

They always let cheese through, it promotes good, peace loving vibes

Austin · 2006-08-10 23:34:35

Thanks again for the great plugin. I’m still having trouble, though. I couldn’t get the SQL commands to assign my old articles to the new tables, and if I manually re-assign them categories at the “write” tab, the new commands like rss_unlimited_categories_article_list don’t output them. Only new articles are outputted.

Sorry for my ignorance. I’m very new at this. But any help would be great.

wilshire · 2006-08-11 12:01:54

Austin- Can you show the SQL you’re trying to use? Is it failing? Or it just doesn’t seem to do anything?

Austin · 2006-08-11 15:02:50

Rob, I put your SQL statements

INSERT INTO textpattern_category (article_id, category_id) SELECT t.id, c.id FROM textpattern t LEFT JOIN txp_category c on t.category1 = c.name where c.type = ‘article’ and t.category1 != ‘’;

INSERT INTO textpattern_category (article_id, category_id) SELECT t.id, c.id FROM textpattern t LEFT JOIN txp_category c on t.category2 = c.name where c.type = ‘article’ and t.category2 != ‘’;

into the query box for the textpattern database and got this error:

SELECT *
FROM
WHERE CONCAT_WS( ”-”, article_id, category_id ) = “1-68”
ORDER BY article_id, category_id

MySQL said: Documentation

– 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 ‘WHERE CONCAT_WS(”-”, article_id, category_id)
= “1-68”’ at line 3

I’ve never done any SQL so I’m not sure what I’m doing. Thanks. and thanks again for your plugins.

alexwest · 2006-08-13 16:20:01

Hi,

These two lines (around line 177) in rss_unlimited_categories_list seem to be producing a double <code>li</code> in the output.

<blockquote>
$row[]=($countlinked) ? tag(htmlspecialchars($b[‘title’].$count),‘a’,’ href=”’.$path.’” title=”’.htmlspecialchars($b[‘title’]).’”’) : ‘’;
$row[]=(!$countlinked) ? tag(htmlspecialchars($b[‘title’]),‘a’,’ href=”’ . $path . ‘” title=”’ . htmlspecialchars($b[‘title’]) . ‘”’) . $count : ‘’;
</blockquote>

Also, I can’t seem to limit the output of rss_unlimited_categories_article_list to the specified section in the relevant attribute.

Thanks,
Alex

EDIT: Maybe not those two lines, but i get a double <code>li</code> in the output of the tag. Depending on countlinked one or the other <code>li</code> receives the output of the plugin.

Last edited by alexwest (2006-08-13 16:30:21)

squaredeye · 2006-08-13 18:06:05

Rob,
I mentioned this in my last email, but unless other’s object, I’d love to see this plugin hide the default category dropdowns (the twin dropdowns) since they become redundant, or is that something that other’s use simultaneously? If so, is it difficult to add it as an pref?

Just a thought man, thanks,

Matthew

wilshire · 2006-08-14 02:56:00

Matthew – I never wanted to assume that people didn’t want to see the original category dropdowns because they were using the plugin which is why they’re still there. I just saw this post for ied_hide_in_admin which looks like it should help you remove those and other unwanted fields.

alexwest – Can you post how you’re calling the plugin?

Austin – What version of MySQL are you using? Have you checked to see if there are any records in the textpattern_category table?

alexwest · 2006-08-14 12:04:35

Hi Rob,

This is what I am doing.

On this page, i am calling rss_unlimited_categories_list like this:
<code>
<txp:rss_unlimited_categories_list linktosection=“calendario” parent=“calendario” showcount=“1” countlinked=“0” />
</code>

This is where i get the double <code>li</code>

<br/>

On any of the pages linked to from the previous, like this for example, i am calling rss_unlimited_categories_related and rss_unlimited_categories_article_list like this:
<code>
<txp:rss_unlimited_categories_related section=“calendario” category=“raids-btt” form=“article_list” sortby=“custom_1” sortdir=“asc” />
<txp:rss_unlimited_categories_article_list form=“article_single” section=“calendario” limit=“1” sortby=“custom_1” sortdir=“asc”/>
</code>

This is where i can’t restrict it to the given section.

<br/>

I’ve set the page to debug mode, in case it helps.

Thanks.

wilshire · 2006-08-14 14:55:37

alexwest – Can you download 0.4 again, reinstall it, and let me know if that fixes the problems?

Also, the way you’re calling rss_unlimited_categories_related is not right. There is no category attribute on the tag but you’re including one.

<txp:rss_unlimited_categories_related section="calendario" category="raids-btt" form="article_list" sortby="custom_1" sortdir="asc" />

alexwest · 2006-08-14 15:32:13

Hi,

Yes! that fixed the the double <code>li</code> issue… and the restriction by the section attribute of the other tags.

One more question? Are the links created by rss_unlimited_categories_related and rss_unlimited_categories_article_list sensitive to the category being browsed? I mean, would they output URLs like site.com/section/category/title… this seems not to be the case now. I believe that would be handy in the case of this site.

Thanks for your help Rob. Cheers,
Alex

wilshire · 2006-08-14 15:45:00

Good, glad that worked.

No, the article links are not generated using /section/category/title URLs but I would think you could use another plugin to do that.

Textpattern CMS

Textpattern CMS support forum

#229 2006-08-10 21:24:52

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

#230 2006-08-10 21:37:59

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

#231 2006-08-10 23:34:35

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

#232 2006-08-11 12:01:54

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

#233 2006-08-11 15:02:50

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

#234 2006-08-13 16:20:01

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

#235 2006-08-13 18:06:05

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

#236 2006-08-14 02:56:00

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

#237 2006-08-14 12:04:35

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

#238 2006-08-14 14:55:37

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

#239 2006-08-14 15:32:13

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

#240 2006-08-14 15:45:00

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

Board footer