Light-weight related articles mod for sNews 1.7

Matt

Thu, 17 May 2012 15:43:00 +0000

Hi Rakesh,

It shouldn't show the article you're currently reading. If you look on line 91 of the php file, it should be

[php]
AND a.id != '".$_ID."'
[/php]

that should exclude the ID of the article you're viewing.

Are you using sNews 1.7?

Rakesh Jain

Thu, 17 May 2012 15:31:23 +0000

HI Matt
Thanks for your sNews Mods , They are wonderful.
I really appreciate your hard work.

There is small isse with "Light-weight related articles mod ", First link show in article page is always same as the article itself.
[b]For Example :[/b]
On Article 1 , it shows the related articles as
Article1
Article2
Article3
Article4
Article5

Is there any ways you can exclude Article 1 is related article section ?

Matt

Thu, 22 Mar 2012 17:28:42 +0000

Hi John,

This site is no longer running sNews CMS, though I do still use it. sNews CMS has no default way to associate an image with an article the way I have here.

A "hacky" way to do it, is to upload a .jpg thumbnail to your files directory, and name the file the id # of the article, then you could add it into the code, such like;

[php]
if (file_exists('file_directory/'.$r['aid'].'.jpg')) {
$list .= '

'.$r['title'].''.$show_cat.'

';
} else {
$list .= '

'.$r['title'].''.$show_cat.'

';
}
?>
[/php]

This is just an untested rough example, you'll need to wteak the HTML/CSS a bit to get it looking similar to mine. Don't forget to upload a default.jpg thumbnail in case the article doesn't have one associated.

Jonathan

Thu, 22 Mar 2012 17:14:52 +0000

Hi Matt,
Does the mod implemented in your site uses same code or different ?
Would you mind sharing how to display the article image of related articles.

---Jonathan

Matt

Thu, 12 Jan 2012 10:05:39 +0000

Haha, if it works, it works, can't complain about that!

BS0D

Thu, 12 Jan 2012 02:18:33 +0000

Hi Matt,

I don't think that will be necessary, I fixed it myself. Quite simply actually... I just changed the line

[code]if ($infoline == true && $_catID != 0)[/code]

to

[code]if (empty($currentPage) && $infoline == true && $_catID != 0)[/code]

It might be a horrible way to fix that, I am no PHP expert and only have the basics, but it works fine on my site. I don't seem to have lost any functionalities and have noticed no bugs so far (I tried that locally first of course) :)
If you can suggest a better fix of course I'll take it!

Matt

Tue, 10 Jan 2012 13:11:59 +0000

BS0D,

Something didn't go quite right it seems, as the related articles should only show on an article when it's being viewed full-page.

Do you have a link, I'd like to take a look at the source? You can send it to me through the contact form if you don't want to post it publicly.

BS0D

Tue, 10 Jan 2012 03:23:07 +0000

OK I'm sorry to bother you again Matt, but now that I got my database to work for this mod, the related links appear in the categories themselves.

Only the last article appears with the related div underneath, but it hides all the previous articles in that category.

Did I miss something? Did I do something wrong?

BS0D

Tue, 10 Jan 2012 02:21:01 +0000

Oops, nevermind... my online research paid off. I changed the table type to MYISAM and it works now.

I was a bit hesitant at first because I don't know much about mySQL and I'm not sure if it has an impact on the speed/consistency of the database. Didn't want my site to lose its functionalities or get it messed up!

BS0D

Tue, 10 Jan 2012 01:59:15 +0000

Hi Matt,

I'm getting the following error message: "#1214 - The used table type doesn't support FULLTEXT indexes"

I don't know how to fix that... does that mean i already have fulltext set up, or just that I cannot set it up at all?