close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

News Articles like PowerStore but using cms builder

Thread began 1/23/2012 10:26 am by saf01 | Last modified 2/24/2014 1:44 pm by Jason Byrnes | 1542 views | 19 replies |

saf01

News Articles like PowerStore but using cms builder

Hi,

I would like to add the function you have for news articles on your PowerStore home page that shows articles and a read more link automatically appearing after a few lines of the news article to view full news - how would I get this kind of thing done for my CMS builder pages. Ive setup my news page as a template page - please advise.

Thx

Sign in to reply to this post

Jason ByrnesWebAssist

this will take some custom coding to accomplish.

in the CMS Admin pane, create a new content area named "News", set it to be a template.

If you examine the power store webassist/plugins/cms_templates/news.php page you should be able to get a good idea how to display the news articles.


on that page, there is a recordset named "CMStoRS" using the following query:
SELECT C2.ContentGroup, C2.ContentPageSetOrder
FROM ps4_contents AS C1 LEFT OUTER JOIN ps4_contents AS C2 ON C2.ContentPagesetParentID = C1.ContentID
WHERE C1.ContentGroup = 'News' AND C2.ContentPageSetOrder IS NOT NULL
GROUP BY C2.ContentPageSetOrder
ORDER BY C2.ContentPageSetOrder DESC

this returns the news articles.


there is a repeat region to loop through the recordset and the cms code to display the news article header and content.

Sign in to reply to this post

saf01

Thx for info Jason, I only own Powerstore 3, however, Im not sure about how to approach this - I just wish to have the same news displayed as on Powerstore 4.5

Which ticket should I submit to have you create this for me?

Sign in to reply to this post

Jason ByrnesWebAssist

we coud help you accomplish this in a Premier Ticket appointment.

Sign in to reply to this post

saf01

Ive submitted a Premier Ticket.

Sign in to reply to this post

saf01

Hi

Did you receive my support ticket? I checked my mail but no support ticket information was received. Please can I get this organised as soon as possible.

Sign in to reply to this post

Jason ByrnesWebAssist

the sales department will be calling today to set up the appointment with you.

Sign in to reply to this post

saf01

Cheers - I look forward to it.

Sign in to reply to this post

JamieEff

Hey Jason

Is there an example of what the output of this sort of set up would be please? I would be interested in learnign how to do it but would ideally like to see what one could expect in the first instance?

Cheers

Jamie

Sign in to reply to this post

Jason ByrnesWebAssist

I'm not sure what you are asking for. you could access the database directly on the server and use the SQL window of PHPMyAdmin to test the SQL and see the output.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...