SimplePortal

Customization => Custom Coding => Topic started by: amopro on June 12, 2010, 01:19:45 AM

Title: sticky article
Post by: amopro on June 12, 2010, 01:19:45 AM

How do I stick the article that i want on top of first page because of after i add new article the new one will replace it. thanks

Title: Re: sticky article
Post by: Nathaniel on June 13, 2010, 09:45:16 PM

Moved to the Custom Coding board.

The edit below will mean that any topics that are stickied within their boards (and are also articles of course), will be shown at the topic of the articles list.

Code: ("Find (Sources/PortalArticles.php)") [Select]

ORDER BY a.id_message DESC' . (empty($modSettings['articleperpage']) ? '' : '

Code: ("Replace") [Select]

ORDER BY t.is_sticky DESC, a.id_message DESC' . (empty($modSettings['articleperpage']) ? '' : '

Title: Re: sticky article
Post by: amopro on June 19, 2010, 10:22:24 PM

Thanks very much but will it have a problem when I update new version of simpleportal?

Title: Re: sticky article
Post by: Nathaniel on June 19, 2010, 10:30:01 PM

You will need to make the edit again when you next update SimplePortal. If the edit doesn't work for a new version. you can always ask for an updated edit.

Title: Re: sticky article
Post by: velorooms on October 30, 2012, 10:02:46 AM

doesnt work on 2.3.4 with 2.0.2

Quote

Unknown column 't.is_sticky' in 'order clause'
File: /home/vrforum/public_html/Sources/PortalArticles.php
Line: 97