\n"; echo "Estado:\n"; $q = mysqli_query($con, "SELECT * FROM festival WHERE year = $year;"); if (mysqli_num_rows($q) == 0){ echo " No se ha definido una cabecera\n"; } else{ $r = mysqli_fetch_array($q); echo "

Texto castellano: OK
Traducción inglés: "; if ($r['text_en'] == $r['text_es'] || strlen($r['text_en']) == 0){ echo "NO\n"; } else{ echo "OK\n"; } echo "
Traducción euskera: "; if ($r['text_eu'] == $r['text_es'] || strlen($r['text_eu']) == 0){ echo "NO\n"; } else{ echo "OK\n"; } echo "
Cartel: "; if (strlen($r['img']) == 0){ echo "NO\n"; } else{ echo "OK\n"; } echo "

\n"; } break; //Calculate prices progress section. case 'pricesprogress': echo "Estado:

\n"; $q = mysqli_query($con, "SELECT * FROM festival_day WHERE year(date) = '$year' AND price > 0;"); if (mysqli_num_rows($q) != 6){ echo " No se han establecido precios\n"; } else{ echo "Precios establecidos: OK\n"; } echo "
\n"; $prices_wrong = 0; while ($r = mysqli_fetch_array($q)){ if ($r['price'] <= 0 || $r['price'] > 200){ $prices_wrong ++; } } if ($prices_wrong == 0){ echo "Precios válidos: " . (6 - $prices_wrong) . "/6\n"; } else{ echo "Precios válidos: " . (6 - $prices_wrong) . "/6\n"; } echo "
\n"; $q = mysqli_query($con, "SELECT id FROM festival_offer WHERE year = $year AND price > 0;"); if (mysqli_num_rows($q) > 0){ echo "Número de ofertas: " . mysqli_num_rows($q) . "\n"; } else{ echo "Número de ofertas: " . mysqli_num_rows($q) . "\n"; } echo "

\n"; break; //Calculate offers window case 'pricesoffers': echo "

Ofertas:

\n"; $q_offer = mysqli_query($con, "SELECT * FROM festival_offer WHERE year = $year"); if (mysqli_num_rows($q_offer) == 0){ echo "No se han configurado ofertas
\n"; } else{ echo ""; echo ""; echo "\n"; while ($r_offer = mysqli_fetch_array($q_offer)){ if ($r_offer['name_en'] == $r_offer['name_es']){ $en = ''; } else{ $en = $r_offer['name_en']; } if ($r_offer['name_eu'] == $r_offer['name_es']){ $eu = ''; } else{ $eu = $r_offer['name_eu']; } if ($r_offer['description_en'] == $r_offer['description_es']){ $den = ''; } else{ $den = $r_offer['description_en']; } if ($r_offer['description_eu'] == $r_offer['description_es']){ $deu = ''; } else{ $deu = $r_offer['description_eu']; } echo "\n"; //TODO onchange echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; //TODO onclick } echo "

Castellano	Inglés	Euskera	Días	Precio	Acción
\n"; echo "$r_offer[description_es]	\n"; echo "$den	\n"; echo "$deu		€

\n"; } echo "\n"; break; case 'schedule': echo("\n"); $q_day = mysqli_query($con, "SELECT DISTINCT date(date_sub(start, INTERVAL 6 HOUR)) AS day FROM festival_event WHERE gm = 1 AND year(start) = $year;"); while ($r_day = mysqli_fetch_array($q_day)){ $q = mysqli_query($con, "SELECT festival_event.id AS id, title_es, title_en, title_eu, description_es, description_en, description_eu, start, end, place, place.name_es AS placename, place.address_es AS address FROM festival_event, place WHERE place = place.id AND date(date_sub(start, INTERVAL 6 HOUR)) = str_to_date('$r_day[day]', '%Y-%m-%d') AND gm = 1"); while ($r = mysqli_fetch_array($q)){ $id = $r['id']; $title_es = $r['title_es']; $title_en = $r['title_en']; if ($title_en == $title_es){ $title_en = ""; } $title_eu = $r['title_eu']; if ($title_eu == $title_es){ $title_eu = ""; } $description_es = $r['description_es']; $description_en = $r['description_en']; if ($description_en == $description_es){ $description_en = ""; } $description_eu = $r['description_eu']; if ($description_eu == $description_es){ $description_eu = ""; } $placeid = $r['place']; $place = $r['placename']; $address = $r['address']; $month = substr($r_day['day'], 5, 2); $day = substr($r_day['day'], 8, 2); $start_h = substr($r['start'], 11, 2); $start_m = substr($r['start'], 14, 2); $end = $r['end']; $end_h = ""; $end_m = ""; if (strlen($end) > 0){ $end_h = substr($r['start'], 11, 2); $end_m = substr($r['start'], 14, 2); } ?> \n"); break; } } ?>

de
Empieza: :
Termina: :

Nombre:

Description:

Lugar: