Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
open:en:alv [2018/05/31 22:16]
Gerben Gieling
open:en:alv [2019/09/12 17:18]
Gerben Gieling
Line 8: Line 8:
     select event_id,​detail,​date_format(start_date,'​%d-%m-%Y'​) as alv_date     select event_id,​detail,​date_format(start_date,'​%d-%m-%Y'​) as alv_date
     from agenda_events     from agenda_events
-    where event_type_id='​a'​ and datediff(start_date,​now()) >= 0+    where event_type_id='​a'​ and datediff(start_date,​curdate()) >= 0
     order by detail asc     order by detail asc
     limit 1     limit 1
Line 19: Line 19:
       echo "​====== ALV ($alv_no), $alv_date ======\n";​       echo "​====== ALV ($alv_no), $alv_date ======\n";​
       echo "​^Start:​|10.00 a.m. (reception and coffee 09.30 - 10.00)|\n";​       echo "​^Start:​|10.00 a.m. (reception and coffee 09.30 - 10.00)|\n";​
-      echo "​^Location:​|[[http://www.jaarbeursutrecht.nl/Adres%20en%20route%22|Jaarbeurs Utrecht]], Jaarbeursplein (room information in \"​Beatrixgebouw\"​)|\n";​ +      echo "​^Location:​|[[https://www.jaarbeurs.nl/en/​accessibility|Jaarbeurs Utrecht]], Jaarbeursplein (room information in \"​Beatrixgebouw\"​)|\n";​ 
-      echo "​Registration via the website is possible for logged-in members only.\n";​ +      ​if (file_exists($_SERVER['​DOCUMENT_ROOT'​]."/​content/​data/​pages/​archief/​alv/​alv_{$alv_no}.txt"​)) { 
-      echo "​{{page>​leden:​registreerlink&​noheader}}\n";​ +        ​echo "​Registration via the website is possible for logged-in members only.\n";​ 
-      echo "===== Agenda =====\n";​ +        echo "​{{page>​leden:​registreerlink&​noheader}}\n";​ 
-      echo '​{{page>​archief:​alv:​alv_'​.$alv_no."&​noheader}}\n";​+        echo "===== Agenda =====\n";​ 
 +        echo '​{{page>​archief:​alv:​alv_'​.$alv_no."&​noheader}}\n";​ 
 +      } else {echo "​Agenda to be announced.\n";​}
     }     }
   }   }
 </​phpwikify>​ </​phpwikify>​