Back to top

Autore Topic: Modulo Newsflash, cambio query  (Letto 1166 volte)

Offline alexanderover

  • Nuovo arrivato
  • *
  • Post: 14
    • Mostra profilo
Modulo Newsflash, cambio query
« il: 11 Lug 2007, 18:51:20 »
Salve.. oggi ho tentato in vano di modificare il modolo Newsflash in modo tale facesse vedere gli ultimi articoli (e non solo i titoli come latestnews) di più categorie
Modificandolo in questo modo, dove sbaglio?:
Codice: [Seleziona]
$whereCatid = '';
if ($catid) {
$catids = explode( ',', $catid );
mosArrayToInts( $catids );
$whereCatid = "\n AND ( a.catid=" . implode( " OR a.catid=", $catids ) . " )";
}
$query = "SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state"
."\n FROM #__content AS a"
."\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
."\n INNER JOIN #__sections AS s ON s.id = a.sectionid"
."\n WHERE a.state = 1"
. ( $noauth ? "\n AND a.access <= " . (int) $my->gid . " AND cc.access <= " . (int) $my->gid . " AND s.access <= " . (int) $my->gid : '' )
."\n AND (a.publish_up = " . $database->Quote( $nullDate ) . " OR a.publish_up <= " . $database->Quote( $now ) . " ) "
."\n AND (a.publish_down = " . $database->Quote( $nullDate ) . " OR a.publish_down >= " . $database->Quote( $now ) . " )"
. $whereCatid
."\n AND cc.published = 1"
."\n AND s.published = 1"
."\n ORDER BY a.ordering"
;

 



Web Design Bolzano Kreatif