Limit # of old issues listed in mod_magazine_issues

billnguyen · Joined: 01 Jan 1970 Posts: 30

Can I limit the number of past issues (in mod_magazine_issues)? Currently it is listing ALL of them. How can I limit the number of past issues to be display?

Thanks
Bill Nguyen

Robbo · Joined: 28 Feb 2007 Posts: 47

Hi Bill,
sure you can, but the module doesn't have an otion to do it at this time.

I can tell you which file and which line to change though.
/modules/mod_magazine_issues.php
Go to line 151.
You should see on this line:
. "\n WHERE A.section='".$section_id."' ".$qdef."AND A.published=1 AND C.published=1 AND A.section=C.id AND A.access <my>gid." ORDER BY A.ordering ASC;

Change it to:
. "\n WHERE A.section='".$section_id."' ".$qdef."AND A.published=1 AND C.published=1 AND A.section=C.id AND A.access <my>gid." ORDER BY A.ordering ASC Limit 2;

Where the limit 2 at the end, is the max number of issues to you want to display.

I hope this helps.

billnguyen · Joined: 01 Jan 1970 Posts: 30

Dear Merav;

This will work.
However, how can I list ALL issues again? Can I call the mod the 2nd time with the "LIMIT" removed?

Thanks again

Bill

Robbo · Joined: 28 Feb 2007 Posts: 47

hi Bill,
the solution I gave you was a permanent one.
We havn't built this feature into our modules yet.
Perhaps inthe future.

billnguyen · Joined: 01 Jan 1970 Posts: 30

Rob;

I am curious if we, as ijoomla users, can invoke a module twice, even if we have to copy the module to a different name? In this case, mod_magazine_issues. I love to be able to do that so we can modify the query to serve different purposes.

Thanks

Bill

Recent Usability Tests

Shopping Cart

Satisfaction Guarantee

Get it FREE!

Member Login