Nu får du lige det hele... Det er længe siden jeg har kodet det, så det kan garanteret laves smartere!
<?php
echo "<div class='overskrift'>KALENDER</div><br>\n";
include("connect.php");
setlocale(LC_TIME, 'da_DK.ISO_8859-1');
function this_timestamp()
{
return mktime(0, 0, 0, $_GET['month'], $_GET['day'], $_GET['year']);
}
function weekday()
{
$day = date("w", this_timestamp());
return ($day ? $day : 7);
}
$todayArray = getdate();
$today = mktime(0,0,0,$todayArray['mon'],$todayArray['mday'],$todayArray['year'])."<br>";
if (!is_numeric($_GET['year']))
$_GET['year'] = date("Y");
if (!is_numeric($_GET['month']))
$_GET['month'] = date("n");
$_GET['day'] = 1;
$kampeEventQ = mysql_query("
SELECT
id,
hold,
unix_timestamp(date_format(datotid, '%Y-%m-%d')) AS unix,
unix_timestamp(datotid) AS unixTid
FROM kampe
WHERE YEAR(datotid)=".$_GET['year']."
AND MONTH(datotid)=".$_GET['month']."
ORDER BY datotid, hold
");
$kalenderEventQ = mysql_query("
SELECT
kalender.id AS kId,
kalender.overskrift AS kOverskrift,
unix_timestamp(date_format(datotid, '%Y-%m-%d')) AS unix,
brugere.nick AS bNick
FROM kalender, brugere
WHERE YEAR(datotid)=".$_GET['year']."
AND MONTH(datotid)=".$_GET['month']."
AND brugere.id = kalender.b_id
ORDER BY kalender.datotid, kalender.overskrift
");
$birthdayQ = mysql_query("
SELECT
nick, id,
unix_timestamp(date_format(birthday, '%Y-%m-%d')) AS unix
FROM brugere
WHERE MONTH(birthday)=".$_GET['month']."
ORDER BY DAYOFMONTH(birthday)
");
if ($_GET['month'] > 1)
{
$forrigeMonth = $_GET['month']-1;
$forrigeYear = $_GET['year'];
}
else
{
$forrigeMonth = 12;
$forrigeYear = $_GET['year']-1;
}
if ($_GET['month'] < 12)
{
$naesteMonth = $_GET['month']+1;
$naesteYear = $_GET['year'];
}
else
{
$naesteMonth = 1;
$naesteYear = $_GET['year']+1;
}
$kampeEventR = @mysql_fetch_assoc($kampeEventQ);
$kalenderEventR = @mysql_fetch_assoc($kalenderEventQ);
$birthdayR = @mysql_fetch_assoc($birthdayQ);
echo "<table class='standard'><tr>";
echo "<th class='left'><a href=".$_SERVER['PHP_SELF']."?month=".$forrigeMonth."&year=".$forrigeYear."><- Forrige </a></th>";
echo "<th>".strtoupper(strftime("%B",this_timestamp()))." ".date('Y', this_timestamp())."</th>";
echo "<th class='right'><a href=".$_SERVER['PHP_SELF']."?month=".$naesteMonth."&year=".$naesteYear.">Næste -></a></th>";
echo "</tr></table><br>";
echo "<table class='standard'>\n";
echo "<tr>\n";
echo "<th>Man</th>\n";
echo "<th>Tir</th>\n";
echo "<th>Ons</th>\n";
echo "<th>Tor</th>\n";
echo "<th>Fre</th>\n";
echo "<th>Lør</th>\n";
echo "<th>Søn</th>\n";
echo "</tr><tr class='calRow'>\n";
if (weekday() > 1)
{
for ($i = 1; $i < weekday(); $i++)
echo "<td class='calEmpty'><img src='images/trans.gif' alt='trans.gif'></td>\n";
}
$days = date("t", this_timestamp());
$missingDays = 42 - ((weekday() - 1) + $days);
for ($_GET['day'] = 1; $_GET['day'] <= $days; $_GET['day'] ++)
{
if ($today == this_timestamp())
{
echo "<td class='calCurrent'>";
}
else
{
echo "<td class='calDay'>";
}
?>
<table class="calDay"><tr><td class="left"><img src="images/trans.gif" alt="trans.gif"></td>
<?
echo "<td class='center'>".$_GET['day']."</td>";
echo "<td class='right'><td class='left'><img src='images/trans.gif' alt='trans.gif'></td></td>";
echo "</tr></table>";
if (@mysql_num_rows($kampeEventQ) > 0)
{
while($kampeEventR['unix'] == this_timestamp())
{
echo "<a onClick=\"java script:popUpWindow('kampinfo.php?kampid=".$kampeEventR['id']."')\" title='Kamp mod: ".$kampeEventR['hold']." - ".strftime('%H:%M', $kampeEventR['unixTid'])."' href='#'>Kamp</a><br>";
$kampeEventR = mysql_fetch_assoc($kampeEventQ);
}
}
if (@mysql_num_rows($birthdayQ) > 0)
{
while(strcmp(strftime("%d-%m",this_timestamp()),strftime("%d-%m",$birthdayR['unix'])) == 0)
{
$alder = strftime("%Y",this_timestamp()) - strftime("%Y",$birthdayR['unix']);
echo " <img src='/images/flag.jpg' alt='FLAG'> <a title='".$birthdayR['nick']." bliver ".$alder." år!' href='/spillerProfil.php?bid=".$birthdayR['id']."'>".$birthdayR['nick']."</a><br>";
$birthdayR = mysql_fetch_assoc($birthdayQ);
}
}
if (@mysql_num_rows($kalenderEventQ) > 0)
{
while($kalenderEventR['unix'] == this_timestamp())
{
echo "<a onClick=\"java script:popUpWindow('kalenderinfo.php?eventid=".$kalenderEventR['kId']."')\" title='Oprettet af: ".$kalenderEventR['bNick']."' href='#'>".$kalenderEventR['kOverskrift']."</a><br>";
$kalenderEventR = mysql_fetch_assoc($kalenderEventQ);
}
}
echo "</td>\n";
if (weekday() == 7)
echo "</tr><tr class='calRow'>\n";
}
$missingDays = $missingDays % 7;
for ($i = 0; $i < $missingDays; $i++)
{
echo "<td class='calEmpty'><img src='images/trans.gif' alt='trans.gif'></td>\n";
}
?>
