Affichage trié des topics

[Invité]

Bienvenue, Invité. Veuillez vous connecter ou vous inscrire.

Connexion avec identifiant et mot de passe

[alvoryx]

Bonjour,

Si je crée les topics news07, news08, news09, blabla01, blabla02, blabla3

comment faire pour n'afficher le résumé des articles de certains topics ?


par exemple, si mon topic 'news07' contient 'article_a', 'article_b', 'article_c', que le topic 'news08' contient 'article_d', 'article_e'


comment faire (en appelant www.monsite.web/modules.php?name=Topics) pour n'afficher que le résumé des articles des topic 'news07', 'news08' et 'news09' ?



Puisque par défaut, si j'appelle www.monsite.web/modules.php?name=Topics, je vais afficher le résumé de tous les articles de tous les topics !

[alvoryx]

J'ai modifié moi même le code du module topics

maintenant en appelant (par exemple) modules.php?name=Topics&topn1=News08&topn2=News07

on aura un résumé des topics News08 et News07

Code:

$tid = (empty($_REQUEST['tid'])) ? 0 : (int)$_REQUEST['tid'];

$topn1 = (empty($_REQUEST['topn1'])) ? 0 : (string)$_REQUEST['topn1'];
$topn2 = (empty($_REQUEST['topn2'])) ? 0 : (string)$_REQUEST['topn2'];
$topn3 = (empty($_REQUEST['topn3'])) ? 0 : (string)$_REQUEST['topn3'];
$topn4 = (empty($_REQUEST['topn4'])) ? 0 : (string)$_REQUEST['topn4'];


if (empty($tid) && empty($topn1) && empty($topn2))
{
    $qry1 = "SELECT topicid, topicimage, topictext, Count(${prefix}_stories.sid) AS sidcount, Sum(${prefix}_stories.counter) AS allreads
        FROM ${prefix}_topics
LEFT JOIN ${prefix}_stories ON ${prefix}_topics.topicid = ${prefix}_stories.topic
        $qrylang1
        GROUP BY topicid, topicimage, topictext
        HAVING Count(${prefix}_stories.sid) > 0
ORDER BY topictext";
}
else
{
if(isset($topn1) && isset($topn2) && isset($topn3) && isset($topn4))
{
    $headlinecount = $headlinecount_topic;
    $columnscount = 1;
    $qry1 = "SELECT topicid, topicimage, topictext, topicname, Sum(${prefix}_stories.counter) AS allreads, Count(${prefix}_stories.sid) AS sidcount
         FROM ${prefix}_topics LEFT JOIN ${prefix}_stories ON ${prefix}_topics.topicid = ${prefix}_stories.topic
         WHERE (${prefix}_topics.topicname='" . $topn1 . "' OR ${prefix}_topics.topicname='" . $topn2 . "' OR ${prefix}_topics.topicname='" . $topn3 . "' OR ${prefix}_topics.topicname='" . $topn4 . "' AND ${prefix}_stories.time <= now() " . $qrylang2 . ")
         GROUP BY ${prefix}_topics.topicid, ${prefix}_topics.topicimage, ${prefix}_topics.topictext";
  }
  else
{
if(isset($topn1) && isset($topn2) && isset($topn3))
{
    $headlinecount = $headlinecount_topic;
    $columnscount = 1;
    $qry1 = "SELECT topicid, topicimage, topictext, topicname, Sum(${prefix}_stories.counter) AS allreads, Count(${prefix}_stories.sid) AS sidcount
         FROM ${prefix}_topics LEFT JOIN ${prefix}_stories ON ${prefix}_topics.topicid = ${prefix}_stories.topic
         WHERE (${prefix}_topics.topicname='" . $topn1 . "' OR ${prefix}_topics.topicname='" . $topn2 . "' OR ${prefix}_topics.topicname='" . $topn3 . "' AND ${prefix}_stories.time <= now() " . $qrylang2 . ")
         GROUP BY ${prefix}_topics.topicid, ${prefix}_topics.topicimage, ${prefix}_topics.topictext";
  }
  else
  {
if(isset($topn1) && isset($topn2))
{
    $headlinecount = $headlinecount_topic;
    $columnscount = 1;
    $qry1 = "SELECT topicid, topicimage, topictext, topicname, Sum(${prefix}_stories.counter) AS allreads, Count(${prefix}_stories.sid) AS sidcount
         FROM ${prefix}_topics LEFT JOIN ${prefix}_stories ON ${prefix}_topics.topicid = ${prefix}_stories.topic
         WHERE (${prefix}_topics.topicname='" . $topn1 . "' OR ${prefix}_topics.topicname='" . $topn2 . "' AND ${prefix}_stories.time <= now() " . $qrylang2 . ")
         GROUP BY ${prefix}_topics.topicid, ${prefix}_topics.topicimage, ${prefix}_topics.topictext";
  }
  else
  {
if(isset($topn1))
{
    $headlinecount = $headlinecount_topic;
    $columnscount = 1;
    $qry1 = "SELECT topicid, topicimage, topictext, topicname, Sum(${prefix}_stories.counter) AS allreads, Count(${prefix}_stories.sid) AS sidcount
         FROM ${prefix}_topics LEFT JOIN ${prefix}_stories ON ${prefix}_topics.topicid = ${prefix}_stories.topic
         WHERE (${prefix}_topics.topicname='" . $topn1 . "' AND ${prefix}_stories.time <= now() " . $qrylang2 . ")
         GROUP BY ${prefix}_topics.topicid, ${prefix}_topics.topicimage, ${prefix}_topics.topictext";
  }
  else
  {
if(isset($tid))
{
    $headlinecount = $headlinecount_topic;
    $columnscount = 1;
    $qry1 = "SELECT topicid, topicimage, topictext, Sum(${prefix}_stories.counter) AS allreads, Count(${prefix}_stories.sid) AS sidcount
         FROM ${prefix}_topics LEFT JOIN ${prefix}_stories ON ${prefix}_topics.topicid = ${prefix}_stories.topic
         WHERE (${prefix}_topics.topicid=" . $tid . " AND ${prefix}_stories.time <= now() " . $qrylang2 . ")
         GROUP BY ${prefix}_topics.topicid, ${prefix}_topics.topicimage, ${prefix}_topics.topictext";
  }  
  }
}
}
}
}