Hallo,
Wenn ich die Topics a, b, c und d anlege
wie kann ich nur eine Zusammenfassung der Artikel eines bestimmten Topics anzeigen lassen?
z.b.: mein Topic ,a' enthält ,artikel_fsfd','atikel_azad' und ,artikel_dfdf', Topic ,b' enthält ,artikel efze','article_dsddsd'
wie schaffe ich es durch Aufruf des Links www.meineseite.web/modules.php?name=Topics nur die Zusammenfassung der Artikel des Topics ,a' aufzurufen ?
ich habe mich falsch ausgedrückt
Wenn ich die Topics news07, news08, news09, blabla01, blabla02, blabla3 anlege.
Wie schaffe ich es die Zusammenfassung der Artikel bestimmter topics nicht anzuzeigen?
z.b.: mein topic ,news07' enthält ,artikel_a','artikel_b','artikel_c', und topic ,news08' enthält ,artikel_d', ,artikel_e'
wie schaffe ich es durch Aufruf von www.meineseite.web/modules.php?name=Topics (http://www.meineseite.web/modules.php?name=Topics)) nur die Zusammenfassung der Artikel von 'news07', 'news08' et 'news09' anzuzeigen?
Wenn ich nämlich www.meineseite.web/modules.php?name=Topics (http://www.meineseite.web/modules.php?name=Topics)) aufrufe , wird standardmässig die Zusammenfassung der Artikel aller Topics angezeigt.
Ok, ich habe es mir selber zusammengebastelt.
Man kann jetzt zu dem ,,Topics" Modul eine Variable topn1->topn4 eingeben , welche dann die Liste der gewollten Topics anzeigt.
Zum Beispiel: modules.php?name=Topics&topn1=News07&topn2=News08
der 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";
}
}
}
}
}
}