Commit Graph

466 Commits

Author SHA1 Message Date
Ken Fallon
d34064d787 update to about anonymous post 2024-01-04 15:41:22 +00:00
Ken Fallon
4287028e25 IA donation drive and NYS are over 2024-01-02 11:56:54 +00:00
Ken Fallon
67f28d43e3 Updates for the NYE show 2023-12-30 17:56:32 +00:00
Ken Fallon
dc36d9de86 last few stray references to php 2023-12-29 13:04:39 +00:00
Ken Fallon
96642bc69f more typos 2023-12-29 12:56:18 +00:00
Ken Fallon
f432954891 Added missing escapes for tt2 2023-12-29 12:42:41 +00:00
Ken Fallon
3f32a39301 Fixing links and formatting 2023-12-29 12:12:10 +00:00
Ken Fallon
7d8af97f7d Merge pull request 'The links to the page itself were not working - used to quickly add links to about page to questions' (#179) from I121_Fix_anchor_links_on_about_page into main
Reviewed-on: rho_n/hpr_generator#179
2023-12-20 11:58:50 +00:00
130f603748 The links to the page itself were not working - used to quickly add links to about page to questions 2023-12-20 12:56:25 +01:00
Dave Morriss
eba235c503 Adjustments to the index page announcements 2023-12-19 21:56:02 +00:00
Ken Fallon
8bcf6bd0e8 new year show update
Added the hpr new yearshow updates
2023-12-10 15:11:46 +00:00
Ken Fallon
15cd9018b0 Merge pull request 'A further fix to the free slot algorithm' (#178) from fix4_next_available_episode into main
Reviewed-on: rho_n/hpr_generator#178
2023-11-18 20:56:20 +00:00
Dave Morriss
e5b5aac104 A further fix to the free slot algorithm
templates/content-index.tpl.html: the `TT²` algorithm can be simplified
    because the new query returns less. We get the date of the show
    before the free slot, and can increment it differently depending on
    whether the previous show is on a Friday or not - catering for
    weekends in other words!

templates/queries-index-mysql.tpl.html,
templates/queries-index-sqlite.tpl.html: using a 'find unused index
    numbers' query available in many places on the Internet, but
    modified to return the id number and date for the show *before* the
    next free slot.
2023-11-17 18:23:22 +00:00
Ken Fallon
0ef92840c8 Added an explanation as to why 2023-11-02 08:39:56 +00:00
Dave Morriss
79a788bda9 Added content to the announcement section 2023-11-01 16:00:33 +00:00
Ken Fallon
2e151ebae9 Merge pull request 'fix3_next_available_episode' (#176) from fix3_next_available_episode into main
Reviewed-on: rho_n/hpr_generator#176
2023-10-29 18:16:46 +00:00
Dave Morriss
097b50b30b Next free slot algorithm now in TT² form
templates/content-index.tpl.html: Now contains TT² code and an in-built
    query to determine the next free slot. No need for an external
    query. Old code that used to use this has been deleted.

templates/queries-index-mysql.tpl.html,
templates/queries-index-sqlite.tpl.html: Old queries called
    'query_next_available_episode' removed since no longer needed.
2023-10-29 17:32:02 +00:00
Dave Morriss
8325b2c0d1 Unwanted items commented out 2023-10-29 17:28:04 +00:00
Ken Fallon
a49bd6b08d Merge pull request 'fix2_next_available_episode' (#175) from fix2_next_available_episode into main
Reviewed-on: rho_n/hpr_generator#175
2023-10-20 14:23:03 +00:00
Dave Morriss
c8135d811d Bug fix of query to find days to next free slot
templates/queries-index-mysql.tpl.html,
templates/queries-index-sqlite.tpl.html:
    Rather than driving the search from the eps table itself, this
    version makes a counter that generates slot numbers from the current
    show number to the highest show number in the system. The counter is
    used to interrogate the eps table to find the first empty slot. This
    sems to be a more reliable approach (but time will tell).
2023-10-20 13:37:37 +01:00
Dave Morriss
dab80f1772 Using even more complex CTE query for testing 2023-10-16 23:01:30 +01:00
Dave Morriss
3ccd6101ee Removed unnecessary computations from query_next_available_episode 2023-10-12 19:36:03 +01:00
Dave Morriss
51d328203b Merge pull request 'Fixing days to next free slot' (#174) from fix_next_available_episode into main
Reviewed-on: rho_n/hpr_generator#174
2023-10-10 19:43:45 +00:00
Dave Morriss
366729a827 Fixing days to next free slot
templates/queries-index-mysql.tpl.html,
templates/queries-index-sqlite.tpl.html: Enhanced the query that finds
    the next free slot (query_next_available_episode). Also made it
    compute the days to the slot from the current day. The query returns
    data for calling Date::Calc to compute the number of days, but this
    calculation is no longer necessary. Next release will remove this.

templates/content-index.tpl.html: The number of days to the next free
    slot is reported here. The original Date::Calc computation which did
    this is no longer needed and has been removed since the query
    (query_next_available_episode) does it.
2023-10-10 17:55:44 +01:00
Dave Morriss
faac8c202e Updated README.md 2023-10-06 15:47:09 +01:00
Ken Fallon
3cf2f3a8e1 Merge pull request 'Making good an oversight in the IA_link PR' (#171) from IA_link_fix into main
Reviewed-on: rho_n/hpr_generator#171
2023-09-29 11:24:00 +00:00
Dave Morriss
83bb04f25c Making good an oversight in the IA_link PR 2023-09-29 10:56:56 +01:00
Ken Fallon
383ef45bb7 Merge pull request 'Added a link to the IA copy of the show' (#170) from IA_link into main
Reviewed-on: rho_n/hpr_generator#170
2023-09-29 08:15:21 +00:00
Dave Morriss
68c5e91552 Added a link to the IA copy of the show
site-generator: removed a subroutine prototype

templates/content-episode.tpl.html: added a new IA show link
2023-09-28 23:16:04 +01:00
Dave Morriss
35fa97e120 Cleaning up after bad merge 2023-09-09 23:26:15 +01:00
Dave Morriss
47a7493ef2 Merge branch '167_Several_templates_use_non-existent_absolute_url'
Somehow stuff got deleted - no idea why!
2023-09-09 23:10:07 +01:00
Dave Morriss
b4448caf16 Fixing 'absolute_url'
site-generator:

    Added all the modules that the script and the templates use to make
    it explicit what is required.

templates/shared-utils.tpl.html:

    Added a new TT² macro called 'absolute_url' which takes two
    arguments, the base and  the path or relative URL. It's fairly
    primitive but seems to work.

templates/content-about.tpl.html,
templates/content-recording.tpl.html,
templates/content-request_a_slot.tpl.html,
templates/content-requested_topics.tpl.html,
templates/page.tpl.html:

    All calls to 'absolute_url' changed to use two arguments, and the
    link definitions adjusted to match this change.
2023-09-09 17:54:19 +01:00
Dave Morriss
8e6c44c46c Merge branch 'main' of https://repo.anhonesthost.net/rho_n/hpr_generator 2023-09-06 18:51:56 +01:00
Dave Morriss
aba463099c Merge branch 'I162_Fix_broken_links_in_template_files' 2023-09-06 18:50:19 +01:00
Dave Morriss
3396413321 Merge pull request 'I162_Fix_broken_links_in_template_files' (#166) from I162_Fix_broken_links_in_template_files into main
Reviewed-on: rho_n/hpr_generator#166
2023-09-06 17:43:42 +00:00
d1832ae619 Changes recommended by Dave - missing php and typo 2023-09-06 19:35:22 +02:00
4c239f4f67 Cleaned up the temp cruft 2023-09-05 20:39:25 +02:00
796ee598e9 Added press information that was missing and updated the FAQ for wikipedia 2023-09-05 20:31:46 +02:00
4b2a030a5b Missed a reference to <!--% baseurl %--> 2023-09-03 18:02:09 +02:00
7009533e25 Fixing invalid links in the templates. 2023-09-03 17:51:03 +02:00
Dave Morriss
5a73e94cf7 Merge branch 'norrist-main'
Amendment from 'norrist' received with thanks.
2023-08-28 12:53:57 +01:00
norrist
99a54d5543 Add libtemplate-plugin-html-strip-perl to getting started
Corresponding commit for my automated build
14d3217274
2023-08-28 11:41:44 +00:00
Ken Fallon
f87199bd92 Merge pull request 'Fixed miscalculation triggering 'Call for shows'' (#161) from I160_Call_for_shows_section_shown_inappropriately into main
Reviewed-on: rho_n/hpr_generator#161
2023-08-27 15:44:13 +00:00
Dave Morriss
ccc1982c6c Fixed miscalculation triggering 'Call for shows'
templates/shared-call_for_shows.tpl.html:
    - Cosmetic change

templates/queries-call_for_shows-mysql.tpl.html:
templates/queries-call_for_shows-sqlite.tpl.html:
    - In a period of 10 days the minimum number of weekday-only shows
      is 6, not 7. Adjusted the queries appropriately.
2023-08-27 16:00:00 +01:00
Ken Fallon
d9392bad6c Merge pull request 'Fixing Unicode problems' (#159) from I158_Problems_with_Unicode_in_the_site-generator into main
Reviewed-on: rho_n/hpr_generator#159
2023-08-27 13:42:33 +00:00
Dave Morriss
d519936f98 Fixing Unicode problems
site-generator:
    - Modification to the POD documentation
    - Addition of 'use 5.012' which enables various later Perl features
    - Addition of "use open ':encoding(UTF-8)'" which forces 'utf8' for
      all IO
    - Addition of 'use Template::Plugin::HTML::Strip' for consistency
    - Removal of other methods of making the default 'utf8' for IO
    - Removal of "'ENCODING => 'utf8'" when setting up a new template
      object. This allows template files to contain Unicode, but doesn't
      seem to be necessary
    - Changes to subroutine 'parse_csv': more comments, clarification of
      warning message, explicit conversion of tags which are marked as
      'utf8' to this format using 'utf8::encode' from core Perl.
2023-08-27 13:22:11 +01:00
Ken Fallon
f1480d742f Merge pull request 'Add new perl modules to getting-started' (#156) from norrist/hpr_generator:main into main
Reviewed-on: rho_n/hpr_generator#156
2023-08-21 18:24:36 +00:00
norrist
7d1968c60b Add new perl modules to getting-started 2023-08-21 14:56:14 +00:00
Ken Fallon
c263646cf2 Merge pull request 'Fixing issue #140' (#155) from I140_Convert_the_RSS_feeds_from_php_to_the_static_site into main
Reviewed-on: rho_n/hpr_generator#155
2023-08-20 15:07:33 +00:00
Dave Morriss
dc138596ea Fixing issue #140
site-generator:

    Cosmetic adjustments. Additions to the POD documentation.
    Additions to module list.
    Additions to work better with UTF-8.
    Addition of functions 'parse_csv' and 'xml_entity'

templates/queries-episodes-sqlite.tpl.html:
templates/shared-utils.tpl.html:

    Cosmetic changes

templates/rss-query-hpr-mysql.tpl.xml:
templates/rss-query-hpr-sqlite.tpl.xml:
templates/rss-query-hpr_total-mysql.tpl.xml:
templates/rss-query-hpr_total-sqlite.tpl.xml:

    Enhancements to allow the query to collect the audio length from the
    'assets' table. The audio file extension is passed as an argument to
    the 'execute' statement.

templates/rss.tpl.xml:

    Cosmetic changes
    Changed one 'php' URL to 'html'.

templates/shared-episode-summary.tpl.html:

    Change to 'display_tags' macro to turn the 'eps.tags' field into
    a list of links. This works, but needs further development because
    using the tag strings as anchor ids is not reliable.

templates/shared-item.tpl.xml:

    Cosmetic changes.
    Addition of filter 'HTML.strip' which is used as a means of removing
    HTML tags from '<itunes:summary>' strings.
    Using new filter 'xml_entity' which converts all non-ASCII
    characters in the notes to numeric hexadecimal entities for
    '<itunes:summary>'.
    The '<enclosure>' tag now uses 'episode.length' rather than
    'episode.duration' which has been extracted from the 'assets' table.
2023-08-19 13:34:50 +01:00