\n";
while ($row = mysql_fetch_object($rq)) {
$id = $row->id;
// Anzeigepriorität: gewählte Sprache, englisch, deutsch
$q = "SELECT * FROM newsletter WHERE refid=$id AND (sprache='$la')";
$rn = mysql_query($q, $cid);
if (mysql_num_rows($rn) != 1) {
mysql_free_result($rn);
$q = "SELECT * FROM newsletter WHERE refid=$id AND (sprache='en')";
$rn = mysql_query($q, $cid);
}
if (mysql_num_rows($rn) != 1) {
mysql_free_result($rn);
$q = "SELECT * FROM newsletter WHERE refid=$id AND (sprache='de')";
$rn = mysql_query($q, $cid);
}
if (mysql_num_rows($rn) == 1) {
$id = mysql_result($rn,0,"id");
$datum = shortdate(mysql_result($rn,0,"pdate"));
$titel = urldecode(mysql_result($rn,0,"titel"));
$sprache = mysql_result($rn,0, "sprache");
mysql_free_result($rn);
// Nummerierung vereinheitlichen: Leerzeichen zw. "Nr." und Nummer
$p = strrpos($titel,".");
if ($p > 0) {
$titel = substr($titel,0,$p+1) . " " . trim(substr($titel,$p+1));
}
// Abstract laden
$q = "SELECT * FROM newsletterabstract WHERE id=$id";
$ra = mysql_query($q, $cid);
$row = mysql_fetch_object($ra);
// odbc_binmode($ra,1);
// odbc_longreadlen($ra,65536);
$abstract = $row->text;
mysql_free_result($ra);
echo "";
echo "$titel";
// if ($sprache != $la) { echo " ($_sprachen[$sprache])"; }
echo "
\n$abstract";
echo " | $datum |
\n";
echo "| |
\n";
}
}
mysql_free_result($rq);
echo "
\n";
} else {
// Parameter ID wurde angegeben, diesen Newsletter anzeigen
if ($code != "") {
decode($code);
// erstmal checken, ob evtl. nach gynaktuell gesprungen werden muss.
$q = "SELECT sprache FROM users WHERE uid=$decodeduid";
$r = mysql_query($q, $cid);
if (mysql_result($r,0,1) == "de") {
Header("Status: 302");
Header("Location: http://www.gynaktuell.de/newsletter.php3?code=$code");
exit;
}
$cdate = substr($decodedtimestamp,0,4) ."-". substr($decodedtimestamp,4,2) ."-". substr($decodedtimestamp,6,2) ." ".
substr($decodedtimestamp,8,2) .":". substr($decodedtimestamp,10,2) .":". substr($decodedtimestamp,12,2);
if (strlen($cdate) == 19) {
$q = "SELECT * FROM newsletter WHERE (cdate='$cdate')";
} else {
// falls der Newsletter nicht mehr existiert, muß man halt auf
// die Homepage verwiesen werden...
// 2000-09-17 storck nach Problemen...
Header("Status: 302");
Header("Location: http://www.ferticon.de/newsletter.php3");
exit;
}
}
$q = "SELECT * FROM newsletter WHERE (id=$id)";
$rn = mysql_query($q, $cid);
// falls der Newsletter nicht mehr existiert, muß man halt auf
// die Homepage verwiesen werden...
// 2000-09-17 storck nach Problemen...
if (mysql_num_rows($rn) == 0) {
Header("Status: 302");
Header("Location: /");
exit;
}
$row = mysql_fetch_object($rn);
// odbc_binmode($rn,1);
// odbc_longreadlen($rn,65536);
$id = $row->id;
$refid = $row->refid;
$datum = shortdate($row->pdate);
$titel = urldecode($row->titel);
$sprache = $row->sprache;
$text = $row->text;
$mdate = shortdate($row->mdate);
$muser = $row->muser;
// Zugriffsstatistik aktualisieren
if ($decodeduid == "") { $decodeduid="0"; }
$sysdate = sysdate();
// Zugriffe von storck.net ignorieren
if (substr($REMOTE_ADDR,0,strlen($DSD_NET)) != $DSD_NET) {
$q = "SELECT max(id) FROM newsstat";
$rs = mysql_query($q, $cid);
$sid = 1 + mysql_result($rs,0,0);
mysql_free_result($rs);
$q = "INSERT INTO newsstat "
. " (id, uid, newsid, sprache, cdate) "
. " VALUES ($sid,$decodeduid,$id,'$la','$sysdate')";
mysql_query($q, $cid);
}
// Ende Zugriffsstatistik
include("header.inc");
?>
0) {
$pid = mysql_result($rp,0,"id");
} else {
$pid = "";
}
$q = "SELECT * FROM newsletter WHERE pdate > '$adatum' AND id <> $id AND sprache='$la' ORDER BY pdate";
$rn = mysql_query($q, $cid);
if (mysql_num_rows($rn) > 0) {
$nid = mysql_result($rn,0,"id");
} else {
$nid = "";
}
if ($pid != "") {
echo "![](\"/images/pfeil-l.gif\")
$_back[$la]";
echo " ";
}
if ($nid != "") {
echo "![](\"/images/pfeil-r.gif\")
$_next[$la]";
}
?>
0) {
$pid = mysql_result($rp,0,"id");
} else {
$pid = "";
}
$q = "SELECT * FROM newsletter WHERE pdate > '$adatum' AND id <> $id AND sprache='$la' ORDER BY pdate";
$rn = mysql_query($q, $cid);
if (mysql_num_rows($rn) > 0) {
$nid = mysql_result($rn,0,"id");
} else {
$nid = "";
}
if ($pid != "") {
echo " $_back[$la]";
echo " ";
}
if ($nid != "") {
echo " $_next[$la]";
}
}
mysql_close($cid);
include("footer.inc");
?>