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

colak · 2006-07-29 16:41:31

Started using the plugin on http://www.morphogenesis.eu/main/ and I get <code><txp:rss_unlimited_categories_cloud limit=“100” cloudwraptag=”“ wraptag=”“ />-> Warning: Division by zero on line 222</code>. Any ideas?

colak · 2006-07-31 06:11:22

Anyone?

alexandra · 2006-07-31 13:16:28

On TXP Mag we use a slightly modified version of the plugin and call the cloud with <txp:rss_unlimited_categories_cloud usemessy="1" /> though TXP mag runs in clean url mode. maybe you have a try with that?

Austin · 2006-08-05 13:15:54

I love this plugin, but am completely ignorant of SQL. I want to migrate my old category designations, but got an error when I tried to enter the SQL commands. Can soemone point me to an easy tutorial, or tell me what to do? Thanks.

rayne · 2006-08-07 14:47:00

I’m having a minor issue. I can use the plugin just fine in Firefox, but if I try to write or edit an article in IE7beta3, I don’t get my multiple category list box. I think it’s an IE issue in general because it happened to me on a machine with IE6 on it. It’s sort of aggravating, because if I’m working in IE, I don’t want to have to switch to FF just to add a post to my blog.

Is anyone else getting this weird issue?

Last edited by rayne (2006-08-07 14:49:33)

Zanza · 2006-08-07 15:17:09

Look here

Bye

Z

rayne · 2006-08-07 15:21:52

Zanza….I’ve read through this whole thread and somehow missed that.

Thanks!

Zanza · 2006-08-07 15:37:21

Yeah, I’ve the same problem with other threads… in a while they become difficult to follow. We should mark the fundamental post (the ones with practical solution to common problems, I mean) with a tag and make them evident on the top of every page… well, I’m dreaming. :)

Bye

Z-

Austin · 2006-08-07 22:52:03

I’m still having trouble using the SQL commands to addign my old stories to the new category tables. I am not a programmer and I’m sorry if this has been covered.

I get this error:

SQL query: Documentation

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

wilshire · 2006-08-08 17:31:46

Long time no read this thread. Crap its long.

Zanza, thanks for the IE fix. I will include that in the next version.

I will also try to dig through the thread to incorporate the other suggestions people had. Feel free to post a link back to a previous post in this thread so I don’t miss it.

Algaris · 2006-08-09 08:13:16

Well one of the main things I am interested in is the fix for the rss_unlimited_categories_articles_list tag that april19 posted.

Clicky

Zanza · 2006-08-09 11:02:40

Welcome back! :)
Also, a major improvement is April19 sortdir and sortby adding. :)

Z-

Zanza · 2006-08-09 11:09:48

And I made another adding to April modified version to exclude the actual id from related article list. You may want this as an option/attribute, so feel free to modify it (ca va sans dir… ;-). I paste here the function. The adding I made are followed by a comment with MB initials (// MB aggiunta).

<pre><code> function rss_unlimited_categories_article_list($atts) { global $s, $c, $pg,$id,$thisarticle;// MB aggiunta extract(lAtts(array( ‘section’ => $s, ‘category’ => $c, ‘form’ => ‘default’, ‘limit’ => 999, ‘offset’ => 0, ‘sortby’ => ‘uPosted’, ‘sortdir’ => ‘desc’ ),$atts)); $actual_id = $id; // MB aggiunta foreach (explode(‘,’, $section) as $section) { $sctsql[] = “ (section = ‘” . doSlash($section) . “’) “; } $sections = ‘ AND (’ . join(’ OR ‘, $sctsql) . ‘) ‘;

foreach (explode(‘,’, $category) as $category) { if ($category) $catsql[] = “ cat.name = ‘” . urldecode($category) . “’ “; } $categories= isset($catsql) ? ‘ AND (’ . join(’ OR ‘, $catsql) . ‘) ‘ : “”;

$q = “SELECT DISTINCT t.ID, tc.category_id FROM “.PFX.“textpattern as t LEFT JOIN “.PFX.“textpattern_category as tc ON t.ID = tc.article_id LEFT JOIN “.PFX.“txp_category as cat ON cat.id = tc.category_id WHERE Status=4 “.$sections.” “.$categories; $rsc = getRows($q);

foreach ($rsc as $a) { extract($a); if ($ID !== $thisarticle[‘thisid’]) { $artsql[] = “ ID = ‘” . $ID . “’ “; } } $articles= isset($artsql) ? ‘ (’ . join(’ OR ‘, $artsql) . ‘) ‘ : “”;

$total = safe_count(‘textpattern’,“1=1 AND “ . $articles) – $offset; $numPages = ceil($total/$limit); $pg = (!$pg) ? 1 : $pg; $pgoffset = $offset + (($pg – 1) * $limit).’, ‘; // send paging info to txp:newer and txp:older $pageout[‘pg’] = $pg; $pageout[‘numPages’] = $numPages; $pageout[‘s’] = $s; $pageout[‘c’] = $c; $pageout[‘total’] = $total;

$GLOBALS[‘thispage’] = $pageout; $q2 = “1=1 AND “ . $articles . “ ORDER BY “.$sortby.” “ .$sortdir. “ limit “ . doSlash($pgoffset.$limit); $rs = safe_rows_start(“*, unix_timestamp(Posted) as uPosted”, “textpattern”, $q2);

if ($rs) { $articles = array(); while($a = nextRow($rs)) { $comparing = $a[‘ID’]; // MB aggiunta populateArticleData($a); // define the article form $article = fetch_form($form); if ($comparing != $actual_id) {$articles[] = parse($article);} // MB aggiunta unset($GLOBALS[‘thisarticle’]); unset($GLOBALS[‘theseatts’]);//Required? } return join(‘’,$articles); } }

// ——————————————————————————————- </code></pre>

Last edited by Zanza (2006-08-09 11:11:32)

wilshire · 2006-08-09 12:45:24

Ok, all good suggestions. I’ll take a look.

Also, no sense in waiting for another version to fix the IE issue so I updated the 0.3 download to include the fix.

wilshire · 2006-08-09 17:56:11

Ok folks, second big plugin update on the day. This version includes all of the fixes that some helpful forum members wrote (notably Zanza, April19 and bit) that I was able to find in this thread.

rss_unlimited_categories 0.4

Additions include:

IE DOM fix for multi select drop down – (Thanks Zanza)
Add time attribute to rss_unlimited_categories_article_list + rss_unlimited_categories_related as requested by Alexandra here
Allow for override forms in rss_unlimited_categories_article_list as requested by jonhicks here (Thanks bit)
Add sortby and sortdir as noted here (Thanks April19)
Exclude current article from rss_unlimited_categories_related listing as noted here (Thanks Zanza)
Add countlinked to rss_unlimited_categories_list to allow for moving count outside the category link as suggested by jonhicks here (Thanks April19)

Important

Version 0.4 of this plugin contains a change that was made after TXP 4.0.3 was released. If you are running off the latest version from SVN, you won’t have any problems. If you are running 4.0.3 or an SVN version that isn’t very recent, you will not see the multi-select drop down list on the article -> write tab. In order to fix the problem, find this word in the code:

article-col-2

and replace it with

articleside

Download

rss-unlimited-categories 0.4

Last edited by wilshire (2006-08-09 17:56:38)

Textpattern CMS

Textpattern CMS support forum

#211 2006-07-29 16:41:31

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

#212 2006-07-31 06:11:22

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

#213 2006-07-31 13:16:28

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

#214 2006-08-05 13:15:54

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

#215 2006-08-07 14:47:00

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

#216 2006-08-07 15:17:09

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

#217 2006-08-07 15:21:52

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

#218 2006-08-07 15:37:21

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

#219 2006-08-07 22:52:03

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

#220 2006-08-08 17:31:46

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

#221 2006-08-09 08:13:16

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

#222 2006-08-09 11:02:40

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

#223 2006-08-09 11:09:48

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

#224 2006-08-09 12:45:24

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

#225 2006-08-09 17:56:11

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

rss_unlimited_categories 0.4

Important

Download

Board footer