lydiaralph/e17site

Private project

e17sermons

e17site's Issues

Hide .php extensions: http://www.w3.org/Provider/Style/URI.html

Display of date - low priority

Use this http://symfony.com/doc/current/book/forms.html

URGENT: Should 'exit' after FB::error be 'return' instead? as currently not outputting flush. Danger that connections will not be closed.

Implement checking for duplicates of records

Header should resemble parent site

Use enum instead of $row[1] to make code more scalable

Research good practice PHP

Store date in database as 'date', not 'string'

URGENT: Check fall out from rejig of mysqlLists.php

mysqlLists has been renamed to readDbRecords.php

It has been split into several functions:
openConnection
[perform task]
closeConnection

Check it is being called anywhere it needs to be, e.g. sermons.php, createNewRecords.php, processInput.php

Check variables which have been replaced:

• $field_names
• All generated lists ($preacher_list, $series_list, $bible_book_list, $date_list, $time_list which are used by filterPanel.php)
• $full_database
• $columns_result
  Replace with (eg) $field_names = readDbRecords('get_lists'); ?? or does this need to be imploded to obtain correct array? as readDbRecords returns associative array of results by task

Check $mysql_queries which has been replaced by $requiredLists - hopefully localised change

Better error logging & messages

JS Filter buttons

Test in different browsers: Chrome, IE, Firefox, Safari (tablet), phone

Encrypt passwords: https://crackstation.net/hashing-security.htm

Automatically populate form input from mp3 file properties (artist, etc.)

Get FirePHP working

Speed up file upload process

Document everything

URGENT: getAuthorisedDbConnection needs to die and regenerate headers so user can enter password

Replace all hardcoded strings

Populate arrays with variables pulled from DB

Beware that not all names will match, e.g. date needs to be day + month + year
Bible ref = ch + verse

Mp3 links: 'Not currently available' if not there. Check file path of mp3 file being loaded.

Link should not be 'http://walthamstowsermons.org.uk/mp3//hermes/waloraweb047/b1352/moo.walthamstowsermonsor/mp3/2023'

Should be Link should not be 'http://walthamstowsermons.org.uk/mp3/[date]-[time]-[title]'

If log in fails, redirect to sermons page

Date filter does not work yet

Implement proper error checking

Proper log in and log out link in top corner

Styling

Create new record - JS validation

Replace all instances of 'alert()' in PHP with echo 'alert'...

Check sermons.php after changing several core libs

Populate page_header.php to appear like walthamstowchurch.org header

Filter: more than option [0] to be displayed

Genericons icon should have hyperlink

Set default date to last Sunday

Add field showing length of mp3 file

Implement checking for possible duplicates of preachers, series, etc. using Lucene

Use a PHP.ini file