\n";
echo "
$lng[activities_upcoming]
\n";
$q_upcoming = mysqli_query($con, "SELECT id, permalink, date, DATE_FORMAT(date, '%Y-%m-%d') AS isodate, title_$lang AS title, text_$lang AS text, price, inscription, people, max_people, user, dtime, comments, city FROM activity WHERE visible = 1 AND date > now() ORDER BY date;");
if (mysqli_num_rows($q_upcoming) > 0){
while ($r_activity = mysqli_fetch_array($q_upcoming)){
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "
\n";
echo "
$r_activity[title] - " . formatDate($r_activity['date'], $lang, false) . "
\n";
//Table with details
echo "
\n";
//If image, show it
$q_activity_image = mysqli_query($con, "SELECT image FROM activity_image WHERE activity = $r_activity[id] ORDER BY idx LIMIT 1;");
if (mysqli_num_rows($q_activity_image) > 0){
$r_activity_image = mysqli_fetch_array($q_activity_image);
echo " | \n";
}
echo "\n\n";
echo "| $lng[activities_date] | " . formatDate($r_activity['date'], $lang, false) . " | \n";
if ($r_activity['price'] == 0){
echo "| $lng[activities_price] | \n";
echo "\n";
echo "$lng[activities_price_0] | \n";
}
else{
echo "| $lng[activities_price] | \n";
echo "\n";
echo "$r_activity[price]€; | \n";
}
if ($r_activity['max_people'] != 0){
echo "| $lng[activities_maxpeople] | $r_activity[max_people] | \n";
}
//Show link to schedule (if any)
$q_itinerary = mysqli_query($con, "SELECT id FROM activity_itinerary WHERE activity = $r_activity[id];");
if (mysqli_num_rows($q_itinerary) > 0){
echo " | $lng[activities_see_itinerary] | \n";
}
echo " ";
echo " |
\n";
echo "
". cutText($r_activity['text'], 300, "$lng[index_read_more]", "http://$http_host/actividades/$r_activity[permalink]") . "
\n";
echo "
\n";
}
echo "
\n";
}
else{ //No upcoming activities
echo("
\n$lng[activities_no_upcoming]\n
\n");
}
echo "
\n";
echo "
$lng[activities_past]
\n";
$i = 0;
while ($r_past = mysqli_fetch_array($q_past)){
echo "
\n";
$q_activity_image = mysqli_query($con, "SELECT image FROM activity_image WHERE activity = $r_past[id] ORDER BY idx LIMIT 1;");
if ($i == 0 && mysqli_num_rows($q_upcoming) == 0){
echo "
$r_past[title] - " . formatDate($r_past['date'], $lang, false) . "
\n"; //TODO clickable TODO Slider onClick
echo "
\n";
}
else{
echo "
$r_past[title] - " . formatDate($r_past['date'], $lang, false) . "
\n"; //TODO clickable TODO Slider onClick
echo "
\n";
}
$i ++;
echo "
\n";
if (mysqli_num_rows($q_activity_image) > 0){
$r_activity_image = mysqli_fetch_array($q_activity_image);
echo " | \n";
}
echo "\n";
if (strlen($r_past['text']) > 0){
echo " ". cutText($r_past['text'], 300, "$lng[index_read_more]", "http://$http_host/actividades/$r_past[permalink]") . " \n";
}
else{
echo " ". cutText($r_past['alt_text'], 300, "$lng[index_read_more]", "http://$http_host/actividades/$r_past[permalink]") . " \n";
}
echo " |
\n";
//TODO show footer with price, maxpeople, etc
echo "
\n"; //past_activity_details
echo "
\n"; //past_activity
}
echo "
\n";
}
?>
![$r_activity[title]](http://$http_host/img/actividades/preview/$r_activity_image[image])
\n";
echo "\n";
echo "![$r_past[title]](http://$http_host/img/actividades/miniature/$r_activity_image[image])
\n";
echo "