\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
\n
• Traducción inglés: "; if ($r['text_en'] == $r['text_es'] || strlen($r['text_en']) == 0){ echo "NO\n"; } else{ echo "OK\n"; } echo "
\n
• Traducción euskera: "; if ($r['text_eu'] == $r['text_es'] || strlen($r['text_eu']) == 0){ echo "NO\n"; } else{ echo "OK\n"; } echo "
\n
• 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': $day = $_GET('day'); switch($day){ case '25': $q = mysqli_query($con, "SELECT * FROM festival_event WHERE gm = 1 AND start > str_to_date('$year-07-25 08:00:00', '%Y-%m-%d %T') AND start < str_to_date('$year-07-26 07:59:59', '%Y-%m-%d %T');"); break; case '5': break; case '6': break; case '7': break; case '8': break; case '9': break; default: exit(-1); } //Load schedule tables echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; break; } } ?>