session_start();
header("Cache-control: private");
include ('include/glsettings.php');
include ('include/connect_db.php');
$jahr = $_GET['jahr'];
echo "
Vereinsleben";
$keinjahr = false;
$lowlimit = 0;
$highlimit = 0;
if ($jahr == "")
{
$jahr = date("Y", time());
$keinjahr = true;
$aktzeit = time();
$highlimit = $aktzeit;
$lowlimit = $aktzeit - 30000000;
}
else
{
$lowlimit = mktime(0, 0, 0, 1, 1, $jahr);
$highlimit = mktime(23, 59, 59, 12, 31, $jahr);
echo " aus dem Jahr $jahr";
}
echo "
";
$zzj = date("Y", time());
while ($zzj >= 2005)
{
if (($jahr == $zzj) && !$keinjahr)
{
echo "$zzj ";
}
else
{
echo "$zzj ";
}
$zzj--;
}
echo "
";
$rows = mysql_query("select datum, titel, aktiv, inhalt, id from $socialnews_table where datum >= $lowlimit and datum <= $highlimit order by datum desc, zeitstempel desc") or DIE (mysql_error());
$num_rows = mysql_num_rows($rows);
setlocale ("LC_TIME", "de_DE");
$rowcount = 0;
while (($row = mysql_fetch_row($rows)) && ($rowcount < 8))
{
if ($row[2] == 1)
{
if ($keinjahr)
{
$rowcount++;
}
echo "";
echo "";
echo "";
echo "".strftime("%A, %e. %B %Y", $row[0])." | ";
echo "";
echo "$row[1]";
echo " | ";
echo "
";
if ($row[3] != "")
{
echo "";
echo "";
echo nl2br($row[3]);
echo " |
";
}
$picrows = mysql_query("select id from $socialpics_table where vereinsleben_id = '".$row[4]."' order by id asc") or DIE (mysql_error());
$num_picrows = mysql_num_rows($picrows);
if ($num_picrows > 0)
{
echo "";
echo "";
$i = 0;
while ($picrow = mysql_fetch_row($picrows))
{
if (file_exists("vereinsleben/".$picrow[0].".jpg") && file_exists("vereinsleben/".$picrow[0]."g.jpg"))
{
if (($i % 4) == 0)
{
echo "";
}
echo "";
$imagedata = getimagesize("vereinsleben/".$picrow[0]."g.jpg");
$winx = $imagedata[0] + 40;
$winy = $imagedata[1] + 90;
echo " ";
echo " | ";
if (($i % 4) == 3)
{
echo " ";
}
$i++;
}
}
echo " ";
echo " |
";
}
echo "
";
echo "
";
}
}
echo "
";
$zzj = date("Y", time());
while ($zzj >= 2005)
{
if (($jahr == $zzj) && !$keinjahr)
{
echo "$zzj ";
}
else
{
echo "$zzj ";
}
$zzj--;
}
echo "
";
if ($keinjahr)
{
echo "
";
}
else
{
if ($jahr < date("Y", time()))
{
$njahr = $jahr + 1;
echo "
";
}
else
{
echo "
";
}
}
if ($keinjahr)
{
echo "
";
}
else
{
echo "
";
}
echo "
";
echo "
";
if ($keinjahr)
{
echo "
";
}
else
{
echo "
";
}
if ($keinjahr)
{
echo "
";
}
else
{
if ($jahr > 2005)
{
$njahr = $jahr - 1;
echo "
";
}
else
{
echo "
";
}
}
echo "
";
echo "
";
?>