[mod] Another article menu

[Joost]

This menu displays articles in the current category.

Past the following code in sNews.php

Code:

<?php
function menu_articles_incat(){
 global $categorySEF, $subcatSEF,$_catID, $_ID, $_XNAME;
 if( isset($_catID) ){
$link  = (!empty($categorySEF) ? $categorySEF.'/' : '');
if( isset($_XNAME)) $link .= ((!empty($subcatSEF)) ? $subcatSEF.'/' : '');
$source = mysql_query('SELECT id,title,seftitle FROM '.
_PRE.'articles WHERE category ='.$_catID.' AND visible=\'YES\' AND published=1 ORDER BY artorder,`date`');
$list = '';
while($r = mysql_fetch_assoc($source)){
 if( $_ID === $r['id']) $list .= sprintf('<li id="here">%s</li>',$r['title']);
 else  $list .= sprintf('<li><a href="%s%s/">%s</a></li>',$link,$r['seftitle'],$r['title']);
}
 }
 if($list) echo "\n<ul>$list</ul>\n";
}
?>

Paste

Code:

<?php menu_articles_incat(); ?>

....in index.php

[rubenam]

Hi, great mod.
I have changed '.$_catID.' for the number ID of a category, because I want that the articles of this category always apperars. The poblem is that when I click on the link of the article,dont works. Only works if I am in the correct category.

What i need to change to have a correct link to the article content from another category?.

Thank you

[H.A.C]

Because the global var $subcatSEF will always refer to the current category, if your desired cat is not the current cat, the article's hyperlink will be wrong. So I think if you want to show articles in a specified category! the query string must also return its has subcat or not.

Code:

<?php
function article_menu_id($yourcat, $size) {
$r = mysql_query('SELECT
title, a.seftitle AS asef,  
c.seftitle AS csef,
x.seftitle AS xsef
FROM '._PRE.'articles'.' AS a
LEFT OUTER JOIN '._PRE.'categories'.' as c ON category = c.id
LEFT OUTER JOIN '._PRE.'categories'.' as x ON c.subcat = x.id AND x.published =\'YES\'
WHERE position = 1 '.$yourcat.' AND a.published = 1 AND c.published =\'YES\'
ORDER BY `date`
LIMIT '.$size);
while ($r = mysql_fetch_array($result)) {
if ($r['csef']) $uri = $r['xsef'] ? $r['xsef'].'/'.$r['csef'] :  $r['csef'];
else $uri = $r['csef'];
echo '<li>'.'<a href="'._SITE.$uri.'/'.$r['asef'].'/">'.$r['title'].'</a></li>';
}
}
?>

i did not test the function above. just a fast idea!

[Joost]

Because the global var $subcatSEF will always refer to the current category,

Maybe that solution works in this particular situation, but I am afraid it more complicated than that. $subcatSEF refers to the second part of a uri: /seftitle/seftitle/
So it can be:
- An article
- a subcategory
- A commentpage ( /seftitle/c_2/)
- A category page ( /seftitle/p_2/)


Anyway, a (quick and dirty) solution might be the following function:

Code:

function menu_special() {
$_cat = 1;
$query = 'SELECT
title,a.seftitle AS asef,date,
c.name AS name,c.seftitle AS csef,
x.name AS xname,x.seftitle AS xsef
FROM '._PRE.'articles'.' AS a
LEFT OUTER JOIN '._PRE.'categories'.' as c
ON category = c.id
LEFT OUTER JOIN '._PRE.'categories'.' as x
ON c.subcat =  x.id AND x.published =\'YES\'
WHERE position = 1
AND a.published = 1
AND c.published =\'YES\'
AND a.visible = \'YES\'
AND a.category = '.$_cat.'
ORDER BY artorder,date DESC';
$result = mysql_query($query);
while ($r = mysql_fetch_array($result)) {
$date = date(s('date_format'), strtotime($r['date']));
$link = isset($r['xsef']) ? $r['xsef'].'/'.$r['csef'] : $r['csef'];
echo  '<li><a href="'._SITE.$link.'/'.$r['asef'].'/"
title="'.$r['name'].' / '.$r['title'].' ('.$date.')">'.$r['title'].'</a>
</li>';
}
}

Past <?php menu_special(); ?> somewhere in index.php and change $_cat= 1 to the number you want.

[adsnew]

tks Joost  for this mod .

QST :

if in the title of this menu i need the courant categories name ?


tks for answer me

[rubenam]

Thank you very much for your solutions Joost. I was busy implementing it, and works great.

Category name is not needed. Only is necesary to put the number of the category. You can see the number of each category in phpmyadmin.

Regards,

Ruben

[sibas]

how to display only the articles and not also the extras
the main mod by Joost display also and "extras", is any easy way to avoid that?

[Keyrocks]

how to display only the articles and not also the extras
the main mod by Joost display also and "extras", is any easy way to avoid that?

If you are using the one in Joost's post at the top of this thread, it would display articles, extras and pages because the query is not written to specifically filter out extras and pages. Try this one, with AND position=1 added to the query so it should only SELECT articles, which are always assigned position 1.

Code:

<?php

function menu_articles_incat(){
    global $categorySEF, $subcatSEF,$_catID, $_ID, $_XNAME;
    if( isset($_catID) ){
$link  = (!empty($categorySEF) ? $categorySEF.'/' : '');
if( isset($_XNAME)) $link .= ((!empty($subcatSEF)) ? $subcatSEF.'/' : '');
$source = mysql_query('SELECT id,title,seftitle FROM '.
_PRE.'articles WHERE category ='.$_catID.' AND visible=\'YES\' AND published=1 AND position=1 ORDER BY artorder,`date`');
$list = '';
while($r = mysql_fetch_assoc($source)){
 if( $_ID === $r['id']) $list .= sprintf('<li id="here">%s</li>',$r['title']);
 else  $list .= sprintf('<li><a href="%s%s/">%s</a></li>',$link,$r['seftitle'],$r['title']);
}
    }
    if($list) echo "\n<ul>$list</ul>\n";
}

?>

[sibas]

Thank you Keyrocks, that was easy 
I use so many time Snews and still don't know the basics 

[sibas]

I play with the last mod of Joost “menu_special()”
and end it with this

Code:

function menu_special($yourcat, $size) {
$query = 'SELECT
title,a.seftitle AS asef,date,
c.name AS name,c.seftitle AS csef,
x.name AS xname,x.seftitle AS xsef
FROM '._PRE.'articles'.' AS a
LEFT OUTER JOIN '._PRE.'categories'.' as c ON category = c.id
LEFT OUTER JOIN '._PRE.'categories'.' as x ON c.subcat =  x.id AND x.published =\'YES\'
WHERE position = 1
AND a.published = 1
AND c.published =\'YES\'
AND a.visible = \'YES\'
AND a.category = '.$yourcat.'
ORDER BY artorder,date DESC';
$query .=" LIMIT $size";
$result = mysql_query($query);
while ($r = mysql_fetch_array($result)) {
$date = date(s('date_format'), strtotime($r['date']));
$link = isset($r['xsef']) ? $r['xsef'].'/'.$r['csef'] : $r['csef'];
echo  '<li><a href="'._SITE.$link.'/'.$r['asef'].'/"
title="'.$r['name'].' / '.$r['title'].' ('.$date.')">'.$r['title'].'</a>
</li>';
}
}

how can I display the last articles, if i try menu_special(6,2); display always the first ones!

[Keyrocks]

Your function only displays the article links for the category defined by its ID - the first number.
If you use menu_special(6,2); in index.php, it will display only the first two article links for the category with ID of 6.
It will always display the same two article links for that category no matter what site page you view.

In the last line of your function's $query you have the ORDER defined as ORDER BY artorder,date DESC';
This line determines the order in which the $query SELECTS the data and how it will be displayed by the function itself.

Notice that you have 2 ORDER parameters set there: - 1) first by the artorder and 2) by date DESC - by date in descending order. You only need to set one parameter there, as the first - artorder - always over-rides the second one.

This means the article links will display in the order you set them to by changing the order of articles in any category (or sub-category) group in the Admin's Articles - View Panel. There, you can number the order in which you want the articles to display. Set an article as "0" and its link will always show as the first in the list, followed by 1, 2, 3 and so on. If you have 10 articles in the category group, number them as you wish from "0" to "9".

You can change the ORDER in the $query to suit the order you wish to display links in.
      1) ORDER by date, oldest to newest: ORDER BY date ASC'; // ascending order, artorder settings do not apply
      2) ORDER by date, newest to oldest: ORDER BY date DESC'; // descending order, artorder settings do not apply
      3) ORDER by article-order settings: ORDER BY artorder'; // as set in the Articles - View panel, date order does not apply

[sibas]

First of all is not my function, is Joost function and just modifying a little bit with H.A.C function above 
I need to display 6-8 different categories with their articles links in index

ORDER BY date DESC'; did the trick 

Thanks for the help to explain what and how to do ++karma to you!

[Keyrocks]

Thanks for the help to explain what and how to do ++karma to you!

Glad you have the solution. Thanks for the +K.