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
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
8325b2c0d1
Unwanted items commented out
2023-10-29 17:28:04 +00:00
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
ken_fallon
d1832ae619
Changes recommended by Dave - missing php and typo
2023-09-06 19:35:22 +02:00
ken_fallon
7009533e25
Fixing invalid links in the templates.
2023-09-03 17:51:03 +02:00
ken_fallon
726ac57989
Changes to get the site working
2023-06-17 22:04:35 +02:00
ken_fallon
c9510516f1
Change php_baseurl to hub_baseurl in the template files
2023-05-31 10:25:17 +02:00
db5774f642
Added support for having a different php FQDN location from the main site via php_baseurl
2023-05-29 16:11:59 +02:00
rho_n
e7fe824302
Fix calculation of the days until next available episode timeslot
...
Do all date calulation in DB instead of naively adding 1 to the
day that is returned.
2023-05-18 09:04:04 -04:00
rho_n
1c94855de2
Update location of comments
...
The listen_now MACRO formating changed, requiring an update to the postion of the comments reference.
2023-04-02 08:50:04 -04:00
rho_n
c6e909523f
Add requested audio links
...
Have links to an episodes auido files appear in the Last 5 weeks section of the index page, on the full index page, and on individual host pages.
2023-04-02 07:24:43 -04:00
5369bea657
This reflects the change to move the "play" button to the top of the episode
2023-03-31 14:02:49 +02:00
610e91ea9f
Added lazy loading attribute to images in show notes.
2023-03-19 22:51:21 +11:00
rho_n
aabeca44f5
Refactor templates to use show_avatar MACRO
2023-03-13 23:15:46 -04:00
ce4aefe828
Renamed macro get_avatar to get_avatar_src as per suggestion.
...
Moved host_thumb macro into shared avatar template file.
Made condition of lazy loading a parameter.
2023-03-12 18:48:51 +11:00
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
rho_n
927424901b
Add show_transcript MACRO to index and episode pages
2023-02-24 18:58:56 -05:00
rho_n
6f28bb2a16
Refactor MySQL database specific SQL
2022-11-27 13:54:14 -05:00
rho_n
4e8edf2640
Merge branch 'main' into MySQL
2022-11-11 20:27:47 -05:00
rho_n
f0fa21ae45
Implement call for shows feature
...
Add display_call_for_shows MACRO. Update index template to include
call to display_call_for_shows.
2022-11-10 22:14:55 -05:00
rho_n
aad77f3c78
Convert index page queries from SQLite to MySQL
2022-10-20 23:24:56 -04:00
rho_n
0837e11bfe
Include announcement template in index template
2022-10-16 18:56:13 -04:00
rho_n
1d4e6e15b7
Refactor templates to use media_path MACRO
2022-10-01 13:42:46 -04:00
rho_n
991b3dcec1
Update SQL query to order results by id
2022-09-21 21:18:48 -04:00
rho_n
c6e7a3c239
Refactor templates to use listen_now MACRO
2022-09-18 16:23:35 -04:00
rho_n
dbd9f8e973
Integrate twat episodes
...
Add twat shows to the full episodes index, the host pages.
Add individule twat episodes.
2022-09-17 17:28:39 -04:00
rho_n
38d2e7c363
Calculate date till next available episode slot
2022-09-05 20:26:12 -04:00
rho_n
67a8a2bfa4
Add MACRO display_listen_in
2022-09-02 18:21:15 -04:00
rho_n
cfd463d2b0
Add MACRO display_comments_tally
2022-09-01 23:05:59 -04:00
rho_n
91cbc81a12
Add MACRO display_tags
2022-09-01 22:58:24 -04:00
rho_n
76b976732b
Add comment tally to index page
2022-08-31 20:43:43 -04:00
rho_n
e2cf52af6e
Use MACRO display_episode_duration in templates
2022-08-29 21:59:24 -04:00
rho_n
02eb8313d3
Fix links in intro text of index page
2022-08-18 21:26:57 -04:00
rho_n
ff2ced6774
Fix capitalization of introduction text on index page
2022-08-18 21:19:32 -04:00
rho_n
af86b7114a
Remove references to Report missing tags page
...
This project is finished, and no longer relevant.
2022-08-16 18:39:05 -04:00
rho_n
b64ffe7f46
Fix path to correspondents pages
2022-08-07 20:04:20 -04:00
rho_n
1b9c3c080c
Add MACRO display_explicit
2022-08-07 19:54:47 -04:00
rho_n
a23ca24bd6
Fix MACRO show_series link to series page
2022-08-06 10:48:53 -04:00
rho_n
7eb308d741
Fix links to episodes and series pages
2022-08-05 17:50:03 -04:00
rho_n
69b3cb32b9
Hide default avatar logo
...
Don't use hpr logo when the host does not have an avatar photo.
2022-08-04 14:21:54 -04:00
rho_n
83d9156f17
Fix file existence logic for get_avatar MACRO
...
Test for existence on filesystem
2022-08-01 20:19:44 -04:00
rho_n
d4e8422677
Fix listing of shows on HPR front page
...
Fix the number of shows listed by quantity not date.
2022-08-01 18:54:01 -04:00
rho_n
c4b0361104
Add MACRO show_summary
...
Shared macro that generates standardized summary information about
an episode.
2022-07-31 23:09:00 -04:00
rho_n
f6318cd34f
Add get_avatar macro
...
Print hpr logo or host avatar filename.
2022-07-31 22:25:15 -04:00
rho_n
4e56289338
Display series if associated with episode
2022-07-20 23:09:03 -04:00
rho_n
c1ac9f69a0
Add dynamic generation of years, months, day since start of HPR
2022-07-18 18:25:25 -04:00
rho_n
30721efcf6
Update index template to use current HPR db schema
2022-07-17 21:13:46 -04:00
rho_n
d7bff1dd6a
Implement dynamic generation of last 5 weeks in index
2022-07-03 22:47:59 -04:00
rho_n
e4565a5168
Update dynamic generation of latest shows in index
2022-07-03 22:46:07 -04:00
Dave Morriss
ken_fallon
Ken Fallon
rho_n
Gordon Stanton