require_once("kannan_avaus.php");
if ($p == "") { $p = "etusivu"; }
if ($p != "kaikkienaikojenylilyonti") {
?>
} ?> switch ($p) { case 'taaviikko': if ($s == "arkisto") { ?> Täältä löydät aiempien viikkojen jutut. $query = "SELECT DISTINCT vko FROM taaviikko WHERE pvm<='".date("Y-m-d")."' AND vko!='".date("Y").".".date("W")."' ORDER BY pvm DESC"; $result = mysql_query ($query) or die (" Invalid query\n");
while ($row = mysql_fetch_array($result)) {
print "viikko ";
$vko = explode(".", $row["vko"]);
print $vko[1];
print "/";
print $vko[0];
print " if ($vko == "") { $query = "SELECT vko FROM taaviikko ORDER BY pvm DESC LIMIT 1"; $result = mysql_query ($query) or die (" Invalid query\n"); $row = mysql_fetch_array($result); $vko = $row["vko"]; } $vko = explode(".", $vko); $query = "SELECT t.pvm,t.title,i.filename,t.body FROM taaviikko t LEFT JOIN images i ON t.image=i.ID WHERE t.vko='".$vko[0].".".$vko[1]."' ORDER BY t.pvm DESC,t.ID DESC"; $result = mysql_query ($query) or die (" Invalid query\n"); while ($row = mysql_fetch_array($result)) { print " \n";
print $row["title"];
print " Pressiklubi tuntee vastuunsa median ylilyöntien kirjaajana ja julkaisee suomalaisen journalismin historian suurimman ylilyönnin Kansan Tahto -lehdestä vuodelta 1983.
break; case 'arkisto': if ($d == "") { $query = "SELECT v,kk,p,body FROM arkisto ORDER BY v DESC,kk DESC,p DESC LIMIT 1"; } else { $query = "SELECT v,kk,p,body FROM arkisto WHERE p=".substr($d, 0, 2)." AND kk=".substr($d, 2, 2)." AND v=".substr($d, 4); } $result = mysql_query ($query) or die (" Invalid query\n"); $row = mysql_fetch_array($result); $d = substr("0".$row["p"], -2).substr("0".$row["kk"], -2).substr("0".$row["v"], -2); ?> Klikkaa Pressiklubin aikaisemmat lähetykset ruudullesi.
Perjantaina
=$row["p"]?>.=$row["kk"]?>.=2000 + $row["v"]?> Invalid query\n");
while ($row = mysql_fetch_array($result)) {
$temp = substr("0".$row["p"], -2).substr("0".$row["kk"], -2).substr("0".$row["v"], -2);
if ($temp == $d) { continue; }
?>
Perjantaina
=$row["p"]?>.=$row["kk"]?>.=2000 + $row["v"]?> Täältä löydät aiempien aamujen lehdet. if ($kkv == "") { $kkv = date("n"); $kkv .= "."; $kkv .= date("Y")-2000; } $kkv = explode(".", $kkv); $query = "SELECT v,kk,p FROM aamunlehti WHERE kk=".$kkv[0]." AND v=".$kkv[1]." ORDER BY v DESC,kk DESC,p DESC"; $result = mysql_query ($query) or die (" Invalid query\n");
// Ohitetaan uusin
$row = mysql_fetch_array($result);
while ($row = mysql_fetch_array($result)) {
$temp = substr("0".$row["p"], -2).substr("0".$row["kk"], -2).substr("0".$row["v"], -2);
print "Aamun lehti ";
print $row["p"];
print ".";
print $row["kk"];
print ".";
print 2000 + $row["v"];
print " >>> $query = "SELECT DISTINCT kk,v FROM aamunlehti WHERE kk!=".$kkv[0]." OR v!=".$kkv[1]." ORDER BY v DESC,kk DESC"; $result = mysql_query ($query) or die (" Invalid query\n");
while ($row = mysql_fetch_array($result)) {
print "";
print $row["kk"];
print "/";
print 2000+$row["v"];
print " Invalid query\n");
$row = mysql_fetch_array($result);
?>
Pressiklubi on pyytänyt 18 ihmistä lukemaan aamun Helsingin Sanomat ja antamaan lehdestä arvionsa.
Tuore tuomio on luettavissa tällä sivulla joka ikinen arkiaamu kello 10 - aina vappuun asti.
=nl2br($row["writer"])?>
}
break;
case 'ihankototta':
if ($s == "arkisto") {
?>
Täältä löydät aiempien viikkojen viikon ylilyönnit ja niiden äänestystulokset. $query = "SELECT v,kk,p FROM ihankototta ORDER BY v DESC,kk DESC,p DESC"; $result = mysql_query ($query) or die (" Invalid query\n");
// Ohitetaan uusin
$row = mysql_fetch_array($result);
while ($row = mysql_fetch_array($result)) {
$temp = substr("0".$row["p"], -2).substr("0".$row["kk"], -2).substr("0".$row["v"], -2);
print "perjantain ";
print $row["p"];
print ".";
print $row["kk"];
print ".";
print 2000 + $row["v"];
print " viikon ylilyönti >>> Error while updating data.\n"); } $recipient = "pressiklubi@yle.fi"; $subject = "IHANKO TOTTA- kilpailun vastaus"; $message = "Valinta:\n"; $message .= strtoupper($valinta)."\n\n"; $message .= "Oma ehdotus:\n"; $message .= "$palaute\n\n"; $message .= "Perustelut:\n"; $message .= "$perustelut\n\n"; $message .= "Nimi:\n"; $message .= "$nimi\n\n"; $message .= "Sähköposti:\n"; $message .= "$email\n\n"; if ($email=="") { $extra="From: pressiklubi@yle.fi\r\n"; } else { $extra="From: ".$email."\r\n"."Reply-To: ".$email."\r\n"; } if (!mail($recipient, $subject, $message, $extra)) { print "Valitettavasti lähettäminen epäonnistui. Ole hyvä ja yritä hetken kuluttua uudelleen."; } } if ($submit != "" || $d != "") { if ($submit != "") { $query = "SELECT a,b,c FROM ihankototta_aanet WHERE p=".$pkkv[0]." AND kk=".$pkkv[1]." AND v=".$pkkv[2]; } else { $query = "SELECT a,b,c FROM ihankototta_aanet WHERE p=".substr($d, 0, 2)." AND kk=".substr($d, 2, 2)." AND v=".substr($d, 4); } $result = mysql_query ($query) or die (" Invalid query.\n"); $row = mysql_fetch_array($result); $sum = $row["a"] + $row["b"] + $row["c"]; if ($sum == 0) { $sum = 1; } // Jos ääniä ei vielä ole jakajaksi tulee nolla $a = round($row["a"] * 1000 / $sum) / 10; $b = round($row["b"] * 1000 / $sum) / 10; $c = round($row["c"] * 1000 / $sum) / 10; ?>
} $query = "SELECT p,kk,v,". "ika.filename AS a_kohu_k,ika.info AS a_kohu_i,a_kohu_t,iva.filename AS a_vaite_k,iva.info AS a_vaite_i,a_vaite_t,". "ita.filename AS a_totta_k,ita.info AS a_totta_i,a_totta_t,iia.filename AS a_ilon_k,iia.info AS a_ilon_i,a_ilon_t,". "ikb.filename AS b_kohu_k,ikb.info AS b_kohu_i,b_kohu_t,ivb.filename AS b_vaite_k,ivb.info AS b_vaite_i,b_vaite_t,". "itb.filename AS b_totta_k,itb.info AS b_totta_i,b_totta_t,iib.filename AS b_ilon_k,iib.info AS b_ilon_i,b_ilon_t,". "ikc.filename AS c_kohu_k,ikc.info AS c_kohu_i,c_kohu_t,ivc.filename AS c_vaite_k,ivc.info AS c_vaite_i,c_vaite_t,". "itc.filename AS c_totta_k,itc.info AS c_totta_i,c_totta_t,iic.filename AS c_ilon_k,iic.info AS c_ilon_i,c_ilon_t ". "FROM ihankototta AS t ". "LEFT JOIN images AS ika ON t.a_kohu_k=ika.ID LEFT JOIN images AS iva ON t.a_vaite_k=iva.ID ". "LEFT JOIN images AS ita ON t.a_totta_k=ita.ID LEFT JOIN images AS iia ON t.a_ilon_k=iia.ID ". "LEFT JOIN images AS ikb ON t.b_kohu_k=ikb.ID LEFT JOIN images AS ivb ON t.b_vaite_k=ivb.ID ". "LEFT JOIN images AS itb ON t.b_totta_k=itb.ID LEFT JOIN images AS iib ON t.b_ilon_k=iib.ID ". "LEFT JOIN images AS ikc ON t.c_kohu_k=ikc.ID LEFT JOIN images AS ivc ON t.c_vaite_k=ivc.ID ". "LEFT JOIN images AS itc ON t.c_totta_k=itc.ID LEFT JOIN images AS iic ON t.c_ilon_k=iic.ID "; if ($d == "") { $query .= "ORDER BY v DESC,kk DESC,p DESC LIMIT 1"; } else { $query .= "WHERE p=".substr($d, 0, 2)." AND kk=".substr($d, 2, 2)." AND v=".substr($d, 4); } $result = mysql_query ($query) or die (" Invalid query\n");
$row = mysql_fetch_array($result);
?>
} break; default: $query = "SELECT filename,info,postit_image FROM front_page AS fp,images AS i WHERE fp.main_image=i.ID"; $result = mysql_query ($query) or die (" Invalid query\n"); $row = mysql_fetch_array($result); ?> " width="160" height="128" border="2" alt="=$row["info"]?>"> if ($row["postit_image"] != 0) { $query = "SELECT filename,info FROM front_page AS fp,images AS i WHERE fp.postit_image=i.ID"; $result = mysql_query ($query) or die (" Invalid query\n");
$row = mysql_fetch_array($result);
?>
" width="165" height="160" border="0" hspace="90" alt="=$row["info"]?>"> $query = "SELECT body FROM front_page"; $result = mysql_query ($query) or die (" Invalid query\n"); $row = mysql_fetch_array($result); print nl2br($row["body"]); ?> break; } ?> |