Textpattern Forum

You are not logged in. Register | Login | Help

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

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

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

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.

Offline

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

rbl
Member
From: Portugal
Registered: 2004-02-25
Posts: 40

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

You mean like running a query in phpMyAdmin?

Offline

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

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

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

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.

Offline

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

rbl
Member
From: Portugal
Registered: 2004-02-25
Posts: 40

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

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)

Offline

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

steventer
Member
Registered: 2004-12-03
Posts: 56

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

> 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!

Offline

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

Jeremie
Member
From: Provence, France
Registered: 2004-08-11
Posts: 1,578
Website

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

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

Offline

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

Martagnan
Member
From: Humberside - uk
Registered: 2004-06-21
Posts: 90
Website

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

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!!

Offline

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

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

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

Nope, its not possible, sorry.

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

Offline

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

wilshire
Plugin Author
From: Akron, Ohio
Registered: 2004-08-27
Posts: 656
Website

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

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

Offline

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

soulship
Member
From: Always Sunny Charleston
Registered: 2004-04-30
Posts: 669
Website

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

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)

Offline

Board footer

Powered by FluxBB