Commit Graph

388 Commits

Author SHA1 Message Date
Roan Horning 0f4fdc2d46 Merge pull request 'Add lazy loading to host image' (#88) from I83_Lazy_load_host_images into main
Reviewed-on: #88
2023-03-04 22:00:52 +00:00
Roan Horning d3c2401e28 Merge branch 'main' into I83_Lazy_load_host_images 2023-03-04 22:00:21 +00:00
Gordon Stanton c744bdf175 Moved host thumbnail image tag to separate template file.
Added loading="lazy" to image tag.
Changed alt text to show host username.
2023-03-05 02:07:03 +11:00
Roan Horning 16d6cf99aa
Add instructions for cloning the repository 2023-03-04 09:27:56 -05:00
Roan Horning add4f338be
Add Getting Started tutorial
Currently a very high level outline of the document.
2023-03-04 09:10:06 -05:00
Roan Horning 444c05f8f9 Merge pull request '[I82] creating sqlite db from hpr.sql' (#86) from I82_creating-sqlite-db-from-hpr.sql into main
Reviewed-on: #86
2023-03-04 05:00:40 +00:00
Roan Horning 24a12a5af3
Update instructions for creating SQLite db
Update the main README file and the POD Installation section
of the site-configuration program.
2023-03-03 23:53:21 -05:00
Roan Horning add92ef20d
Add utility script to refresh the local website
This script  will download latest MySQL dump file from
hacckerpublicradio.org. Generate a new hpr.db SQLite file,
and then regenerate all of the website files.
2023-03-03 23:32:35 -05:00
Roan Horning f8e397d0bd
Add required script mysql2sqlite to repository
Converts MySQL dump to SQLite3 compatible dump
    (including MySQL KEY xxxxx statements from the CREATE block).

    Website: https://github.com/dumblob/mysql2sqlite
    The MIT License (MIT)
    Copyright (c) 2015 esperlu, 2016 dumblob
2023-03-03 23:00:50 -05:00
Roan Horning 6d588dc558
Merge branch 'main' into I82_creating-sqlite-db-from-hpr.sql 2023-03-03 22:52:21 -05:00
Roan Horning f0b0b5ea59 Merge pull request 'Fix database instructions in configuration file' (#85) from Fix_db_sqlite_settings into main
Reviewed-on: #85
2023-03-04 03:49:09 +00:00
Roan Horning a33fa197df
Fix database instructions in configuration file
Add back instructions for SQLite
2023-03-03 22:44:05 -05:00
Roan Horning e7e752f1e8
Improve function messages 2023-03-03 21:47:29 -05:00
Roan Horning 094287837c
Put variables into local scope of the function
Forgot to use the local keyword when declaring the variables.
2023-03-03 21:44:35 -05:00
Roan Horning a53f201842
Code formatting with no functional changes 2023-03-03 20:46:34 -05:00
Roan Horning 2ce1280cc0
Make functional stub function copy_to_public_dir 2023-03-03 20:45:16 -05:00
Roan Horning d45ca0de96
Make functional stub function make_hpr_sqlite_db 2023-03-03 20:42:42 -05:00
Roan Horning 13aeb647ad
Make functional stub function download_hpr_sql 2023-03-03 20:41:29 -05:00
Roan Horning ee6a4e601d
Fill out function clean_working_dir 2023-02-27 23:30:24 -05:00
Roan Horning b544687f0f
Fill out stub of make_working_dir function 2023-02-27 23:27:26 -05:00
Roan Horning 0ed7efe93b
Initial add of bash library for update utils
Stubs for functions to be used in update scripts.
2023-02-27 21:07:01 -05:00
Roan Horning b4e4187902 Merge pull request 'Fix URL's to series RSS feeds' (#80) from I78_Fix-link-to-series-RSS-links into main
Reviewed-on: #80
2023-02-26 04:13:06 +00:00
Roan Horning 431126e8a3
Fix URL's to series RSS feeds 2023-02-25 23:06:41 -05:00
Roan Horning 91ceefd88e Merge pull request '[I62] Hide display of future shows on series pages' (#79) from I62_Hide-display-of-future-shows-on-series-pages into main
Reviewed-on: #79
2023-02-25 20:11:11 +00:00
Roan Horning 8feb37e831
Hide display of future shows on series episodes page 2023-02-25 14:22:44 -05:00
Roan Horning 4a34496f24
Hide display of future shows on series listings page 2023-02-25 11:44:56 -05:00
Roan Horning f7e54233e2 Merge pull request '[I12] Implement comments_viewer page' (#77) from I12_Implement-comments-viewer into main
Reviewed-on: #77
2023-02-25 01:44:50 +00:00
Roan Horning 59875e772e
Implement comments_viewer page 2023-02-24 20:42:01 -05:00
Roan Horning f84ee71b7c Merge pull request '[I75] Fix missing show transcipts[' (#76) from I75_Fix-missing-show-transcipts into main
Reviewed-on: #76
2023-02-25 00:06:18 +00:00
Roan Horning 927424901b
Add show_transcript MACRO to index and episode pages 2023-02-24 18:58:56 -05:00
Roan Horning 27a84529c6
Create shared template for showing show transcripts
Used in main index page and individual episode pages.
2023-02-24 18:57:20 -05:00
Roan Horning 59549daa63
Fix archive.org paths in media_path MACRO 2023-02-24 18:55:37 -05:00
Roan Horning ec7a6ce379 Merge pull request 'Refactor RSS templates for either MySQL or SQLite' (#74) from I73-Fix_queries_for-RSS_feeds into main
Reviewed-on: #74
2023-02-21 03:41:55 +00:00
Roan Horning 756bdc0fa1
Refactor RSS templates for either MySQL or SQLite 2023-02-20 22:36:30 -05:00
Roan Horning b2eaea1eb8
Improve look of hosts table 2023-02-12 16:54:17 -05:00
Roan Horning fe9bf574cf Merge pull request 'Update sydication template text' (#69) from I67-Update_syndication_page into main
Reviewed-on: #69
2023-02-12 19:36:17 +00:00
Roan Horning 309ea05c15
Update sydication template text
Now matches what is in the syndication.php page on
hakerpublicradio.org
2023-02-12 13:46:11 -05:00
Roan Horning 649d6c3746 Merge pull request 'Make tags page menu link hard coded' (#68) from I63_Fix-menu-link-to-tags-page into main
Reviewed-on: #68
2023-02-12 18:10:12 +00:00
Roan Horning e41f6029aa
Make tags page menu link hard coded
Not implementing tags page in the static generator yet.
Make the link point to the php page on hackerpublicradio.org.
2023-02-12 13:07:06 -05:00
Roan Horning 4bd7c6f867 Merge pull request 'I64_Implement-Show-Transcript-section' (#66) from I64_Implement-Show-Transcript-section into main
Reviewed-on: #66
2023-02-12 16:07:47 +00:00
Roan Horning 138b0fdd1b
Add Show Transcript section to episode template 2023-02-12 10:58:43 -05:00
Roan Horning d437e66f0e
Update media_path MACRO for archive.org transciption files
The whisper transcription files are stored one directory
deeper on archive.org. Add checks and correct path when
passed txt, srt, or vtt media_type.
2023-02-12 10:53:50 -05:00
Roan Horning a213efa695 Merge pull request '[I57] MySQL implementation' (#65) from MySQL into main
Reviewed-on: #65
2023-02-12 12:59:13 +00:00
Roan Horning 314127441c Merge branch 'main' into MySQL 2023-02-12 12:57:38 +00:00
Roan Horning 2a486cb58b
Add SQLite specific query templates 2023-02-08 16:05:36 -05:00
Roan Horning 7c44f6b680
Remove New Year's Eve 2023 show announcement 2023-01-03 10:08:52 -05:00
Roan Horning 71a63e1beb
Merge branch 'main' into MySQL 2022-12-31 18:39:25 -05:00
Roan Horning 8e1232517a Update New Year's Eve show 2023 2022-12-31 15:55:39 -05:00
Roan Horning cb65d25cfc
Refactor MySQL database specific SQL 2022-11-28 22:47:53 -05:00
Roan Horning 2b4802508d
Remove superflous WHERE condition 2022-11-28 19:55:51 -05:00