[plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

wilshire · 2005-05-02 12:29:58

rbl – Have you tried to echo the query (or the where clause) for the queries that you’re running? If you can do that it would help me know where to look.

steventer – The latest version of the plugin is out and it will exclude the current article from the related listing.

rbl · 2005-05-02 15:52:28

You mean like running a query in phpMyAdmin?

wilshire · 2005-05-02 16:24:10

I’m not sure how familiar you are with PHP but what I mean is to output the query to the screen so you can see whats being run. You could then take that and run it in phpMyAdmin to see if you get any results. The query itself might help to show what the problem is too.

Look for a line near the bottom of the plugin that start with <code>$rs3 = safe_rows(“</code>. Right before that line, add a line that reads <code>echo $scsql;</code>. When you reload your page, the where clause for the sql will be displayed on top. See if anything stands out as blantly incorrect. Email me or post the results if you want me to take a look.

rbl · 2005-05-02 16:57:31

If there are no results, the clause does not appear. Here’s the output of one of the pages where there are results:
id <> 26 AND (category1 = ‘Iluminação’ or category2 = ‘Iluminação’) AND ( (section = ‘produtos’) ) AND status=4 AND posted < now() ORDER BY section, posted desc LIMIT 999999999

btw, when there are no results, div id=“rssCatArchive” is not closed, breaking all my layout.

Last edited by rbl (2005-05-02 16:59:50)

steventer · 2005-05-02 17:00:19

> wilshire wrote:

steventer – The latest version of the plugin is out and it will exclude the current article from the related listing.

You’re an absolute star! Thanks so much — this plugin is a “must have” and now it just got better!

Jeremie · 2005-05-04 05:32:24

Wilshire, there is a bug in the last version, with showexcerpt. The excerpt is not parsed by Textile.

Martagnan · 2005-05-12 15:35:24

It may already be possible to do this, if so, how?

Section = Engine Parts
Category = Air Filters
Sub Category = Many

When I go to the Air Filters category I want to have a list of the Sub Categories of Air Filters displayed (NOT all the articles belonging to the parent Air Filters. Clicking on one of these Sub Categories will then take me to a page listing ONLY the articles that belong to that Sub Category

Any help appreciated very, very much!!

wilshire · 2005-05-12 16:04:28

Nope, its not possible, sorry.

The plugin doesn’t deal with sub-categories at all.

wilshire · 2005-05-12 18:23:26

Ok, well, you might be able to do something close. It took someone reminding me of what you can do with the plugin.

soulship · 2005-05-12 19:33:13

Yeah, but subcats you would really still have to fake a little bit through the ul/li listing. This can work, I have done it with an older version of the plugin, but I could’nt tell you how off the top of m head other than with a buch of time tinkering with the way the navigation was displayed. I will look and see if I have an old version of a clients site that subcats was working on and get back.

EDIT:

I cant find the form I was using, it has been deleted. I had it so that it was outputing subcats though, I wish I could find it for you ‘cause it took a good bit of time to get it just right. Sorry.

Last edited by soulship (2005-05-12 19:45:51)

Martagnan · 2005-05-13 07:16:46

Doh! Thanks for your help fellas! Time is short on this one so i’m going to tinker a little while longer before I may have to consider other options (wp). :(

soulship · 2005-05-13 13:54:13

What rev# are you using? If you are pre344 (actually it may be rc1 not sure) you might want to look at stw_category_tree. I have another site that subcats are working on using that plugin. Again it is really tied to the css. It is working as a click on cat and subcats are revealed. Again you have to have at least one article in each subcat for it to display though.

Martagnan · 2005-05-14 14:15:31

Thanks Soulship, i’ll give that a go!

Maleika E.A. · 2005-05-16 00:00:32

This is a wonderful plugin. Thank you so much for the hard work you’ve put into it. :)

I do have one question, however. Is there a possibility to separate the markup from the actual plugin?

I have taken a peek into the php code and it has quite a few rss css classes hardcoded into it. Is there a way I can completely turn that off? Or would I have to modify the plugin itself and remove these classes manually? I have no clue about php, so I’m a bit cautious with playing around with the plugin code.

Thanks in advance,

Maleika

EDIT: I managed to remove all the css markup from the plugin code. Seems to have worked. :)

Last edited by Maleika E.A. (2005-05-16 00:42:12)

Moondreamer · 2005-06-21 22:34:22

There are some problem with the timeframe option. None off the switches are working! I hope someone has a solution!

What wrong here ….

Textpattern CMS

Textpattern CMS support forum

#31 2005-05-02 12:29:58

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#32 2005-05-02 15:52:28

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#33 2005-05-02 16:24:10

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#34 2005-05-02 16:57:31

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#35 2005-05-02 17:00:19

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#36 2005-05-04 05:32:24

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#37 2005-05-12 15:35:24

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#38 2005-05-12 16:04:28

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#39 2005-05-12 18:23:26

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#40 2005-05-12 19:33:13

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#41 2005-05-13 07:16:46

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#42 2005-05-13 13:54:13

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#43 2005-05-14 14:15:31

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#44 2005-05-16 00:00:32

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

#45 2005-06-21 22:34:22

Re: [plugin] [ORPHAN] rss_suparchive_bycat - related articles by category

Board footer