Witam
Chciałbym pokazać na stronie głównej news.php panel Lates Article Panel ale z rozwinięciem tzn. tak jak widać je w articles.php
Nie wiem od której strony to ugryźć. Dziś próbuje przerobić ten panel tak więc mam standardowy kod:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: latest_articles_panel.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
openside($locale['global_030']);
$result = dbquery(
"SELECT ta.article_id, ta.article_subject, tac.article_cat_id, tac.article_cat_access FROM ".DB_ARTICLES." ta
INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id
".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access'))." AND article_draft='0' ORDER BY article_datestamp DESC LIMIT 0,5"
);
if (dbrows($result)) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['article_subject'], 23);
echo THEME_BULLET." <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a><br />\n";
}
} else {
echo "<div style='text-align:center'>".$locale['global_031']."</div>\n";
}
closeside();
?>
A może łatwiej będzie wyciągnąć coś z articles.php
_______________________________________
zmiany dokonane
Udało mi się zmodyfikować powyższy kod do wyświetlenia treści zapowiedzi artykułu.
W zapytaniu do bazy dodałem
"SELECT ta.article_id, ta.article_subject, [color=#006600]ta.article_snippet,[/color]
Pod
$itemsubject = trimlink($data['article_subject'], 23);
dodałem to
$data['article_snippet'] = trim(substr($data['article_snippet'],0,45));
a do wyświetlenia dodałem
echo "<div class='new'><div class='titles'> <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a></div><div class='zapowiedz'>".$data['article_snippet']."</div></div>\n";
Działa cudownie tak jak chciałem.
Teraz pojawiło się zapytanie jak przyciąć wyświetlanie artykułów do tylko jednej wybranej kategorii.
________________________
Zmiany końcowe Udało się wszystko zrobić
dokonałem zmiany końcowej w kodzie:
".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access'))." AND article_draft='0'[color=#006600] AND article_cat_id='3'[/color] ORDER BY article_datestamp DESC LIMIT 0,5"
Końcowa zawartość pliku może się komuś przyda:
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: articles_with_snippet_panel.php
| Author: Nick Jones (Digitanium) + modyfication Patrick Rozanski K@iTO
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
openside($locale['global_030']);
$result = dbquery(
"SELECT ta.article_id, ta.article_subject, ta.article_snippet, tac.article_cat_id, tac.article_cat_access FROM ".DB_ARTICLES." ta
INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id
".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access'))." AND article_draft='0' AND article_cat_id='3' ORDER BY article_datestamp DESC LIMIT 0,5"
);
if (dbrows($result)) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['article_subject'], 100);
//$itemsnippet = trimlink($data['article_snippet'], 150);
$data['article_snippet'] = trim(substr($data['article_snippet'],0,100));
echo "<div class='art new'><div class='titlus'> <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a></div><div class='text'>".$data['article_snippet']."</div></div>\n";
}
} else {
echo "<div style='text-align:center'>".$locale['global_031']."</div>\n";
}
closeside();
?>
Aby wybrać inną kategorię artykułów niż (w tym przypadku) 3, należy wyedytować tą linijkę
".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access'))." AND article_draft='0' AND article_cat_id='3' ORDER BY
a dokładnie:
article_cat_id='3'
Edytowane przez K@iTO dnia 06.10.2011 22:44:58
|
