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