$page_title"; #echo ""; /* Visa nyheterna */ $sql = "SELECT * FROM $dbtable ORDER BY date DESC limit 0, 3"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_assoc($result)) { /* Utskrift av nyheterna */ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo " ".$row["date"]." | ".$row["title"]." ".wordwrap(nl2br($row["text"]),120," \n")." "; echo " "; } /* Slut */ mysql_free_result($result); ?>

2035) { $year = 2035; } } if (isset($_GET['today'])) { $today = $_GET['today']; $today = ereg_replace ("[[:space:]]", "", $today); $today = ereg_replace ("[[:punct:]]", "", $today); $today = ereg_replace ("[[:alpha:]]", "", $today); } $month = (isset($month)) ? $month : date("n",time()); $year = (isset($year)) ? $year : date("Y",time()); $today = (isset($today))? $today : date("j", time()); $daylong = ucfirst( strftime("%A",mktime(1,1,1,$month,$today,$year)) ); $monthlong = ucfirst( strftime("%B",mktime(1,1,1,$month,$today,$year)) ); $dayone = date("w",mktime(1,1,1,$month,1,$year)); $numdays = date("t",mktime(1,1,1,$month,1,$year)); $alldays = array('Sön','Mon','Tis','Ons','Tors','Fre','Lör'); $next_year = $year + 1; $last_year = $year - 1; if ($today > $numdays) { $today--; } //Start spalten echo "   $year   Jan Feb Mar Apr Maj Jun Jul Aug Sep Okt Nov Dec \n"; //Visar månad namn echo "\n\n"; echo "\n"; echo "\n\n"; //Visar dag namn foreach($alldays as $value) { echo "\n"; } echo "\n\n"; //Visar blanka dagar som nbsp's for ($i = 0; $i < $dayone; $i++) { echo "\n"; } //Visar dagar for ($zz = 1; $zz <= $numdays; $zz++) { if ($i >= 7) { print("\n\n"); $i=0; } //kollar current dag efter aktivitet $result_found = 0; if ($zz == $today) { //mark todays cell regardless echo "\n"; $result_found = 1; } if ($result_found != 1) {//Letar efter aktivitet denna dag och markerar cell om titeln inte är tom $sql_currentday = "$year-$month-$zz"; $eventQuery = "SELECT title FROM cal WHERE eventdate = '$sql_currentday';"; $eventExec = mysql_query($eventQuery); while($row = mysql_fetch_array($eventExec)) { if (strlen($row["title"]) > 0) { echo "\n"; $result_found = 1; } } } if ($result_found != 1) {//Visar default cell style för dag echo "\n"; } $i++; $result_found = 0; } $create_emptys = 7 - (($dayone + $numdays) % 7); if ($create_emptys == 7) { $create_emptys = 0; } //Visar de blanka celler som finns kvar if ($create_emptys != 0) { echo "\n"; } echo "\n"; echo " " . ucfirst( strftime("%B",mktime(1,1,1,$month,1,$year))) . "\n $value   $zz $zz $zz \n"; echo "[Visa dagens datum]"; echo " \n"; //Visar veckor echo "\n\n"; echo "\n"; for ($i = $today; $i <= ($today + 6); $i++) { //Upptäcker om dagar går över i nästa månad $current_day = $i; $current_year = $year; $current_month = $month; if ($i > $numdays) { $current_day = ($i - $numdays); $current_month = $month + 1; if ($current_month > 12) { $current_month = 1; $current_year = $year + 1; } } $dayname = ucfirst( strftime("%A",mktime(1,1,1,$current_month,$current_day,$current_year)) ); $sql_currentday = "$current_year-$current_month-$current_day"; $eventQuery = "SELECT title FROM cal WHERE eventdate = '$sql_currentday';"; $eventExec = mysql_query($eventQuery); while($row = mysql_fetch_array($eventExec)) { if (strlen($row["title"]) > 0) { $this_days_title = stripslashes($row["title"]); $this_days_title = htmlspecialchars($this_days_title); } } //Visar dag titel om det finns någon if (strlen($this_days_title) > 0) { } echo "\n"; $this_days_title = ""; } echo "\n"; //Slut ytter table echo " $daylong $today $monthlong $year "; //Laddar och visar dag titel och innehåll i fältet $sql_date = "$year-$month-$today"; $eventQuery = "SELECT title, event, html FROM cal WHERE eventdate = '$sql_date';"; $eventExec = mysql_query($eventQuery); while($row = mysql_fetch_array($eventExec)) { $html_setting = $row["html"]; $event_title = stripslashes($row["title"]); $event_title = htmlspecialchars($event_title); $event_event = stripslashes($row["event"]); if ($html_setting != 1) { $event_event = htmlspecialchars($event_event); $event_event = ereg_replace ("\n", " \n", $event_event); } } echo "$event_title \n"; echo $event_event; echo " \n"; ?>