> 0) { $q="select description from sitemap where id=$rub and status='freigegeben'"; # $rset=mysql_query($q,$conn); $rset=mysqli_query($conn,$q); # if ($row=mysql_fetch_array($rset)) { if ($row=mysqli_fetch_array($rset)) { if ($row['description']) { $rubtext=$row['description']." - Rad am Rhein / ADFC"; } } } $arttext=""; if (isset($art)) { $q="select headline,abstract from article where id=$art and status='freigegeben'"; # $rset=mysql_query($q,$conn); $rset=mysqli_query($conn,$q); # if ($row=mysql_fetch_array($rset)) { if ($row=mysqli_fetch_array($rset)) { if ($row['headline']) { $arttext=$row['headline']." - "; } if ($row['abstract']!='') { $description=$row['abstract']; $description=preg_replace("//","",$description); } } } $title=""; if ($arttext) { $title.=$arttext; } if ($rubtext) { $title.=$rubtext; } # # normale HTML-Seite ausgeben # ?> <?=$title?>
ADFC Kreis Neuss Fahrradportal Mönchengladbach ADFC Kreis Mettmann ADFC Krefeld / Kreis Viersen ADFC Düsseldorf
 
>
suchen
\n"; echo "\n"; #$rset1=mysql_query("select id,description,extlink from sitemap where pid=1 and status='freigegeben' order by pos,id desc",$conn); $rset1=mysqli_query($conn,"select id,description,extlink from sitemap where pid=1 and status='freigegeben' order by pos,id desc"); #for ($n1=1;$n1<=mysql_num_rows($rset1);$n1++) { for ($n1=1;$n1<=mysqli_num_rows($rset1);$n1++) { # $row1=mysql_fetch_array($rset1); $row1=mysqli_fetch_array($rset1); $desc1[$n1]=$row1['description']; $extl1[$n1]=$row1['extlink']; $id1[$n1]=$row1['id']; # $rset2=mysql_query("select id,description,extlink from sitemap where $rset2=mysqli_query($conn,"select id,description,extlink from sitemap where pid=$row1[id] and status='freigegeben' order by pos,id desc"); # for ($n2[$n1]=1;$n2[$n1]<=mysql_num_rows($rset2);$n2[$n1]++) { for ($n2[$n1]=1;$n2[$n1]<=mysqli_num_rows($rset2);$n2[$n1]++) { # $row2=mysql_fetch_array($rset2); $row2=mysqli_fetch_array($rset2); $desc2[$n1][$n2[$n1]]=$row2['description']; $extl2[$n1][$n2[$n1]]=$row2['extlink']; $id2[$n1][$n2[$n1]]=$row2['id']; } } for ($n1--,$i=1;$i<=$n1;$i++) { # $rset=mysql_query("select count(*) from _join where to_table='sitemap' and to_id=".$id1[$i],$conn); $rset=mysqli_query($conn,"select count(*) from _join where to_table='sitemap' and to_id=".$id1[$i]); # $row=mysql_fetch_row($rset); $row=mysqli_fetch_row($rset); $class=$rub==$id1[$i]?"nav1_vis":"nav1"; echo "\n"; } else { echo "".$desc1[$i].""; } if ($id1[$i]==$rub||tree_is_ancestor($id1[$i],$rub,"id","pid","sitemap",$conn)) { for ($n2[$i]--,$j=1;$j<=$n2[$i];$j++) { # $rset=mysql_query("select count(*) from _join where to_table='sitemap' and to_id=".$id2[$i][$j],$conn); $rset=mysqli_query($conn,"select count(*) from _join where to_table='sitemap' and to_id=".$id2[$i][$j]); # $row=mysql_fetch_row($rset); $row=mysqli_fetch_row($rset); $class=$rub==$id2[$i][$j]?"nav2_vis":"nav2"; echo "\n":"\n"; } else { echo "".$desc2[$i][$j].""; } } } } ?>
 
 
"; if (!$extl1[$i]) { echo ""; echo $desc1[$i]; echo ""; echo "
 
"; if (!$extl2[$i][$j]) { echo $row[0]>0?"":""; echo $desc2[$i][$j]; echo $row[0]>0?"
Rad am Rhein ist umgezogen. Nach zehn Jahren erfolgreicher Zusammenarbeit probieren die Kreisverbände links und rechts des Rheins seit Früjahr 2011 unterschiedliche Wege. Das Magazin der Düsseldorfer ADFC heißt weiter Rad am Rhein und ist jetzt hier zu finden. Die ADFC-Verbände Rhein-Kreis Neuss und Krefeld/Viersen haben ein eigenes Magazin "Rad am Niederrhein" aufgelegt, das Sie hier finden können. # if ($suchtext=="") { # # # ... abstract-Feld aus Tabelle "nonarticle" ... # $q="select a.id,a.headline,a.abstract from nonarticle a,_join r where r.from_table='nonarticle' and r.from_id=a.id and r.to_table='sitemap' and r.to_id=$rub and a.status='freigegeben' order by r.pos,a.id desc"; # $rset=mysql_query($q,$conn); $rset=mysqli_query($conn,$q); # while ($row=mysql_fetch_array($rset)) { while ($row=mysqli_fetch_array($rset)) { check4img($row['headline'],"nonarticle",$row['id'],"bindata"); echo "

".$row['headline']."

"; check4par($row['abstract']); echo "
".$row['abstract']."
"; } # #
# $q="select a.id,a.headline,a.abstract,a.text,a.author,r.to_id as rub from article a,_join r where r.from_table='article' and r.from_id=a.id and r.to_table='sitemap' and r.to_id=$rub and a.status='freigegeben' and r.pos<1000 order by r.pos,id desc"; } else { $q="select distinct a.id,a.headline,a.abstract,a.text,a.author,r.to_id as rub from article a,_join r where (a.headline like '%$suchtext%' or a.byline like '%$suchtext%' or a.abstract like '%$suchtext%' or a.text like '%$suchtext%' or a.author like '%$suchtext%') and r.from_table='article' and r.from_id=a.id and r.to_table='sitemap' and a.status='freigegeben' order by r.pos,id desc"; echo "
Suchergebnis - Alle Artikel, in denen $suchtext vorkommt:
\n"; } # $rset=mysql_query($q,$conn); $rset=mysqli_query($conn,$q); # while ($row=mysql_fetch_array($rset)) { while ($row=mysqli_fetch_array($rset)) { if ($rub==1) {# nach Zweitbuchung in anderer Rubrik suchen $q2=preg_replace("/and r.to_id=1/","and r.to_id>1 and a.id=$row[id]",$q); # $rset2=mysql_query($q2,$conn); $rset2=mysqli_query($conn,$q2); # if ($row2=mysql_fetch_array($rset2)) { if ($row2=mysqli_fetch_array($rset2)) { $row=$row2; } } if ($suchtext) { mark_string($suchtext,$row['headline']); mark_string($suchtext,$row['abstract']); mark_string($suchtext,$row['text']); } if ($row['text']) { if ($suchtext=="") { echo "

$row[headline]

\n"; } else { echo "\n"; } } else { echo "

$row[headline]

\n"; } if ($row['abstract']!="") { $abstract=$row['abstract']; } else { $abstract=substr($row['text'],0,200); $abstract=preg_replace("/(.*)\s.*?$/","\\1",$abstract); } $art=$row['id']; check4par($abstract); if ($suchtext=="") { check4img($abstract,"article",$art,"bindata"); } if ($row['text']) { # $abstract.=" ... weiterlesen"; $abstract=preg_replace("/<\/p>\s*$/"," » weiterlesen

",$abstract); } echo "
$abstract
\n"; if (!$row['text']&&$row['author']) { echo "
$row[author]
\n"; } echo getf_related($row['id'],$row['rub']); } $q="select w.id,w.title,w.url,w.javascript,w.abstract from weblink w,_join r where r.from_table='weblink' and r.from_id=w.id and r.to_table='sitemap' and r.to_id=$rub and w.status='freigegeben' order by r.pos,w.id desc"; # $rset=mysql_query($q,$conn); $rset=mysqli_query($conn,$q); # while ($row=mysql_fetch_array($rset)) { while ($row=mysqli_fetch_array($rset)) { if ($row['javascript']) { $atag=""; } else { $atag=""; } echo "

$atag$row[title]

\n"; echo "
$row[abstract]
\n"; } # # # } elseif (isset($art)) { # # # $query="select headline,byline,abstract,text,author from article where id=$art and status='freigegeben'"; # $rset=mysql_query($query,$conn); $rset=mysqli_query($conn,$query); # $row=mysql_fetch_array($rset); $row=mysqli_fetch_array($rset); if ($suchtext) { mark_string($suchtext,$row['headline']); mark_string($suchtext,$row['abstract']); mark_string($suchtext,$row['text']); mark_string($suchtext,$row['author']); } echo "

$row[headline]

\n"; if ($row['byline']!="") { echo "\n"; } if ($row['abstract']!="") { check4par($row['abstract']); check4img($row['abstract'],"article",$art,"bindata"); echo "
$row[abstract]
\n"; } check4par($row['text']); check4img($row['text'],"article",$art,"bindata"); echo "
$row[text]
\n"; echo "
$row[author]
\n"; # #
# } else { # # # echo "
Willkommen auf den Dokumentationsseiten von MyCMS. Die zuletzt geänderten oder neu hinzugekommenen Artikel sind:
"; $rset=mysql_query("select a.id,a.headline,a.abstract,a.mtime,j.to_id from article a, _join j where a.status='freigegeben' and a.id=j.from_id and j.to_table='sitemap' order by a.mtime desc limit 3",$conn); while ($row=mysql_fetch_array($rset)) { echo "\n"; echo "
$row[abstract]
\n"; } # #
# } ?>
\n

",$text); $text="

".$text."

"; $text=preg_replace("/

\s*(