You are not logged in.
2005-05-02 12:29:58
Re: [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
2005-05-02 15:52:28
- rbl
- Member
- gamma
- Real name: Ricardo Lamego
- From: Portugal
Re: [ORPHAN] rss_suparchive_bycat - related articles by category
You mean like running a query in phpMyAdmin?
Offline
2005-05-02 16:24:10
Re: [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
2005-05-02 16:57:31
- rbl
- Member
- gamma
- Real name: Ricardo Lamego
- From: Portugal
Re: [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
2005-05-02 17:00:19
- steventer
- Member
- delta
Re: [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
2005-05-04 05:32:24
Re: [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
2005-05-12 15:35:24
Re: [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
2005-05-12 16:04:28
Re: [ORPHAN] rss_suparchive_bycat - related articles by category
Nope, its not possible, sorry.
The plugin doesn’t deal with sub-categories at all.
Offline
2005-05-12 18:23:26
Re: [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
2005-05-12 19:33:13
Re: [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