The following upgrades have been completed:
All communication with the Grammar Captive database is now achieved through a single PHP class. This means that the database settings of all documents that communicate with the database can be changed by changing only one document. As this document is only visible to the webmaster, the entire site is now more flexible and secure as a result.
There are now 6 different ways to sign up for the Seven Gates newsletter including four on the Grammar Captive main page and two on the Grammar Captive Podcast host page. All of these avenues for subscription now use the same, secure, backend mechanism for communication with the Grammar Captive database — namely, MySQL prepared statements.
The offer of a free webinar is now independent of the Grammar Captive webinar series. The free webinar will become a regularly scheduled webinar available to new and potential Grammar Captive users to ask questions and become acquainted with Grammar Captive’s host. Sign-up for the webinar is now accessible via the Grammar Captive main page under the heading Introduction in the main page navigation bar.
In order to remove the bubbling effect when doing a search in the Concept and Form and Use podcast archives, the hover mechanism was changed to a click mechanism. The effect is slightly less dynamic, but much more stable.
The final two plus one remaining development projects are:
- the completion of the PHP class for counting user activity in regard to newsletter, podcast, and page hits,
- modification of the database to account for different language versions of the Seven Gates newsletter, and
- tweeking the PHP mass mailer to handle mass mail. Up until now it has only managed one email or newsletter at a time.
Surely there will be other important changes down the line, but not until after podcast production has been set into motion — say, in two to three weeks?
By the way, the Grammar Captive website (grammarcaptive.com) has now received just under 410,000 successful page requests since its inception in March 2017 for an average daily request rate of more than 1,750 requests. This is astounding in light of the fact that not a single podcast has yet to be published.
Where there is a need that I can satisfy, there is hope.