I haven't test, but thinking about the issue and things observed while developing the generator, when using the base tag then any relative src or href paths need to be relative to the href set in…
I see the issue. The <link href="./css/hpr.css" rel="stylesheet" /> should be <link href="/css/hpr.css" rel="stylesheet" /> (i.e. don't use a relative path but absolute path). That…
I do like DB solutions as I find I end up rewriting front end code more often than DB queries, but HPR code is probably more stable than other projects I have helped--so not as much an issue.
Yes, doing it from PHP like that is easy enough. The SQL from the first CTE, reserved_dates, gives you the list of dates to have been taken:
SELECT date AS 'reserve_date', id AS 'ep_num'
F…
Yes, I have been thinking of adding a "resources" folder to the templates folder. This would be for static content like the images and css which would go into git, and then copied over to…
Yes, the difficult part is generating the full range of dates. It could be simplified some by changing how the recursive function limit is generated. Instead of finding the number of days between…
The following UNIONS the existing episodes from the two tables from the current date forward. It generates a list of all dates from the current date to the furthest reserved date and then…