Commit Graph

15 Commits

Author SHA1 Message Date
3349ea882d kind of working 2025-04-11 11:06:01 +02:00
Milan
a55301bcfe set-podcast-url.sh: add only basename to URL 2024-03-28 23:29:55 +01:00
Milan
18709215ef tools/cleanup-archive.pl: add
Remove files older than a year and links older than a week in the
directory provided as the first argument.
2023-09-23 00:23:29 +02:00
Milan
2bad47df5f tools/remove-recordings.pl: print simple list of files w/o special line format 2023-05-31 20:31:30 +02:00
Milan
cdc0b1dd77 tools/remove-recordings.pl: support more audio file extensions 2023-05-31 20:31:27 +02:00
Milan
2db84415bb config: add audio-upload-hooks
Hooks can be used to automate the process of updating database columns
when new audio files are uploaded.  A hook command reads the path of an
audio file and output a list of database columns to be updated with
their respective values.  Currently, the only supported database tables
are calcms_events and calcms_audio_recordings.  Some examples are
included
2023-03-24 23:01:05 +01:00
Milan
a93a09e554 Remove past recordings
This commit adds a tool that removes all recordings that have been
played out in the past. The tool scans the database for recordings that
have a play time in the past and removes them from the system to free up
storage space and prevent outdated recordings from being played again.
This helps to ensure that only current and relevant recordings are
available for playback.
2023-03-21 22:23:53 +01:00
Milan
feb936ed15 remove sync_jobs 2023-02-26 23:06:58 +01:00
Milan
3ee57b448e remove sync_cms
sync from google calendar is not used anymore
2023-02-26 23:02:18 +01:00
Milan
4521c3ed6c remove debug 2023-02-26 22:28:12 +01:00
Milan
f77556908a compress_templates.cgi: remove obsolete 2020-11-15 20:29:16 +01:00
Milan
655957922e fixup! copy current state of medienstaatsvertrag.org, to be verified 2020-11-15 20:29:16 +01:00
Milan
b442bf0fc8 update_program.pl: refactor 2020-11-15 20:29:16 +01:00
Milan
56881b92d0 rewrite Export to Google Calendar
In the past Google Calendar exports were done by first removing all
events of a day and then create new ones. This takes a lot of time for
export and runs into Google Calendar usage limits after some time.

By now content will be compared before removing/creating a single event
one. To be able to do so, all other sync sources and targets have been
removed, so its only possible to export from database to Google Calendar
by this change.

To trigger an export you need to create a trigger file.
run_jobs.pl runs periodically e.g. started by cron and checks if a
trigger file exists and start sync_cms.pl to export the selected events
to the Google Calendar. Trigger files and jobs are configured at
jobs.config. Each job has a source and target file containing the access
data for calcms and the calendar.

Configuration files have been cleaned up. Old Accounts and passwords have
been removed. They hopefully should have been not active for a long time ;-)
2018-09-22 23:09:03 +02:00
Milan
69e5d0e4c6 copy current state of medienstaatsvertrag.org, to be verified 2017-12-18 10:58:50 +01:00