';
//echo ' | ';
//include ("izq.php");
//echo ' | ';
echo ' ';
include("notaagenda.php");
function mostrarResultados($cal, $sql, $buscador, $week){
$link = mysql_connect($cal->SERVER, $cal->USER, $cal->PASSWORD);
mysql_select_db($cal->DATABASE, $link);
//echo $sql;
$result = mysql_query($sql, $link);
$encontrados = mysql_num_rows($result);
//echo "encontrados= ".$encontrados;
echo '';
echo '';
echo ''."\n";
echo ' '."\n";
echo ' | '."\n";
echo ' '."\n";
if ($buscador)
echo " Resultados de la búsqueda\n";
else{
if ($week != true)
echo " ".$_GET['day']. " de " . $cal->getMonthName($_GET['month']) . " de " .$_GET['year']."\n";
else {
$temp = $_GET['day'] + 7;
$daysInMonth = array(31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
$month = $_GET['month'];
if ($temp > $daysInMonth[$month]){
$day1 = $temp - ($daysInMonth[$month-1]);
echo " Mostrando del ".$_GET['day']. " de " . $cal->getMonthName($_GET['month']) ." al ".$day1. " de " . $cal->getMonthName($_GET['month']+1) . " de " .$_GET['year']."\n";
}
else {
//$day += 7;
echo " Mostrando del ".$_GET['day']. " al " .$temp." de ".$cal->getMonthName($_GET['month']) . " de " .$_GET['year']."\n";
}
}
}
echo ' | '."\n";
echo ' | '."\n";
echo ' '."\n";
echo ' '."\n";
if ($encontrados>0){
echo ' '."\n";
echo '
'."\n";
echo ' '."\n";
echo ' '."\n";
echo ' | '."\n";
echo ' Fecha | '."\n";
echo ' Artista | '."\n";
echo ' Recinto | '."\n";
echo ' Ciudad | '."\n";
echo ' + Info | '."\n";
echo ' | '."\n";
}
else
echo ' No se ha encontrado ninguna actuación para el día seleccionado. | '."\n";
echo ' '."\n";
$j=0;
while ($row = mysql_fetch_array($result))
{
if (!mysql_data_seek ($result, $j))
{
printf ("Cannot seek to row %d\n", $j);
continue;
}
if(!($row = mysql_fetch_object ($result)))
continue;
echo ' '."\n";
echo " | \n";
echo " ".$row->day."/".$row->month."/".$row->year." | \n";
echo " ".$row->artista." | \n";
echo " ".$row->recinto." | \n";
echo " ".$row->ciudad." | \n";
echo " + info | \n";
echo " | \n";
echo ' '."\n";
$j++;
}
mysql_free_result ($result);
if ($encontrados>0){
echo ' '."\n";
echo ' | '."\n";
echo ' '."\n";
}
echo ' '."\n";
echo "
Popes80 no se hace responsable de la veracidad de las actuaciones publicadas en esta guía.\n";
echo ' | ';
$cal->mostrarBuscador();
echo $cal->getMonthView($_GET['month'], $_GET['year']);
echo ' | ';
echo ' ';
}
/*if ($month == NULL){
$date = getdate(time());
if ($day == NULL)
$day = $date['mday'];
$month = $date['mon'];
$year = $date['year'];
}*/
if (isset($_POST['buscar'])){
$buscar = $_POST['buscar'];
$select = $_POST['select'];
//echo $buscar."
";
//echo $select."
";
$sql = "SELECT * FROM ".$cal->TABLE." WHERE (".$select." LIKE '%$buscar%') AND (year=$year)";
mostrarResultados($cal, $sql, true, false);
}
else if ($day != NULL){
if ($week != true){
$sql = "SELECT * FROM ".$cal->TABLE." WHERE (day=$day) AND (month=$month) AND (year=$year)";
mostrarResultados($cal, $sql, false, false);
}
else {
$temp = $day+7;
$daysInMonth = array(31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
if ($temp > $daysInMonth[$month-1]){
$day1 = $temp - ($daysInMonth[$month-1]);
$sql = "SELECT * FROM ".$cal->TABLE." WHERE ((day BETWEEN $day AND ".$daysInMonth[$month-1].") AND (month=".($month).") AND (year=$year)) UNION SELECT * FROM ".$cal->TABLE." WHERE ((day BETWEEN 1 AND $day1 AND (month=".($month+1).")) AND (year=$year)) order by month,year,day";
}
else {
//$day += 7;
$sql = "SELECT * FROM ".$cal->TABLE." WHERE (day BETWEEN $day AND $temp) AND (month=$month) AND (year=$year) ORDER BY day, month, year";
}
//$sql = "SELECT * FROM ".$cal->TABLE." WHERE (day BETWEEN ($day - 7) AND ($day)) AND (month=$month) AND (year=$year) ORDER BY day, month, year";
//echo $sql."
";
mostrarResultados($cal, $sql, false, true);
// continue 1;
}
}
else{
echo '';
echo '';
echo ''."\n";
echo ' '."\n";
echo ' | '."\n";
echo ' '."\n";
echo " ". $cal->getMonthName($month) . " de " . $year."\n";
echo ' | '."\n";
echo ' | '."\n";
echo ' '."\n";
echo ' '."\n";
// echo ' '."\n";
// echo ' '."\n";
// echo ' '."\n";
echo ' | Seleccione un día en el calendario | '."\n";
// echo ' '."\n";
// echo ' '."\n";
// echo ' | '."\n";
echo ' '."\n";
echo ' '."\n";
echo ' | ';
$cal->mostrarBuscador();
echo $cal->getMonthView($_GET['month'], $_GET['year']);
echo ' | ';
echo ' ';
}
echo ' | ';
echo '
';
echo '