Siberian : terminate PDO connection to mysql

March 6th, 2019

There's a problem with connections from the Siberian site to the mysql database hanging around on the database forever.

Searching through the code, I see it's using PDO to connect to the database. A variable called $dbhCon is the PDO connection object. A variable called $dbhQuery is the query that is executed. The only instance I can find of $dbhQuery->execute() is line 16 of /include/search-results.php. The results of that query execution wind up in a php array called $rows. I've added a $dbhCon = NULL; line immediately following that assignment in an effort to force the connection on the mysql database to terminate, as it sometimes seems to hang around for weeks.

UVic AV streaming video to cascade site

March 6th, 2019

History department is doing a talk which is to be live streamed by AV. AV gave them this block of code to insert in their Cascade site. Presumably some of the connection arguments are specific to the stream and will vary with each instance.

When we put that code in and published the page, we got the player with a "error cross domain request denied" message. In consultation with Scott Thorpe, he said this is normal behaviour and the code will just work when the stream is enabled (about 15 minutes before the event actually starts).
There is no way to test this in advance.

<div style="width: 100%; max-width: 512px;">
<div style="border: 1px solid #000; position: relative; width: 100%; padding: 0;" id="VidPlayerPlaceholder_1243" class="videoplayer">
<script type="text/javascript" src="//"></script>
<script type="text/javascript">jwplayer.key="UJGcVouk597phvGZrziZMHAb3IRluP27vKFmTIMbWyw=";</script>
<script type="text/javascript">
var p = jwplayer('VidPlayerPlaceholder_1243').setup({
flashplayer: "//",
playlist: [
{ title: "", image: "//", sources: [{ file: "//"}]}
primary: 'html5',
hlshtml: 'true',
width: '100%',
aspectratio: '16:9',
autostart: 'false',
repeat: 'false',
controls: 'true',
logo: {
file: '//',
link: '',
position: 'top-left',
hide: 'false'
rtmp: {
bufferlength: '5'
<!-- Closes video player -->

TCCD: Editorial project info coming in

March 6th, 2019

Got the first editorial intro material from DH, and it sort of fits in the projectDesc, so I've created a new file called data/project/project.xml to host it. Eventually there will be a full editorialDecl in there, and I'll convert that stuff into an editorial info page on the site.

Latin site: fully updated version now built

March 4th, 2019

Wrote some XSLT to align and normalize all the Masher files, and was able to rebuild the whole site with the new HotPot 7. Posted it for a look by MN and LB. There may be a bit more work, but this is now mostly done, I think. The site builds quite rapidly (around 20 minutes) on my new machine.

Site for German drama

March 1st, 2019

Met with KS and EP to discuss building a site in support of the a German 400 course; this will be hosted on our server, data will live in our svn, and the site will be an XML/XHTML5 site like Keats and Close Reading. KS will organize and name the images, and build spreadsheets linking images to categories. When we start to receive that info, we'll start building out the site with browsable category pages, including categories for each of the four plays done so far.

Latin Wheelock exercises: building in validation

February 14th, 2019

I've now built validation into the repo for the HTML output, and tested it with units 1 and 2, which are now all valid; I've fixed a bunch of table resources that were using old attributes, in anticipation of being able to use a global class in the CSS; and I've nuked a bunch of obsolete materials from units 1 and 2, making everything a bit cleaner.

Close Reading: another tweak

February 14th, 2019

I think we're now good to go; waiting for KB to press the button.

Close Reading: final tweaks to layout etc.

February 13th, 2019

KB sent a list of changes, which I've done; what's left is to decide where to put the site, and what to do with the WordPress instance.

Latin Wheelock site + HotPot 7

February 12th, 2019

Hot Potatoes 7 is now at a point where it's ready to be put to real use, and the Latin site has been waiting for it, since the site needs a refresh, a new style, and support for audio. I started by creating an svn repo for it (svn/latin), into which I've put the current Wheelock materials, and future editing will be done using the repo, which makes everything a bit more robust. I've already created a customized index file page and one other custom file which adds a second keypad at the top of JCloze exercises. I built Unit 1 and posted it for some feedback from MN. One thing I'm running into is the issue that the source folder setting in the Masher is an absolute path; that's obviously not what anyone wants, because we need to be able to check out and build the site on multiple machines, so I've gone back to the Masher codebase in Delphi and I'm adding support for relative paths (making them the default, in fact). Once this is all working and tested, it should make building the site much easier, and in fact enable editors to build entire units themselves with the right source files to test their work.

Close Reading site work basically done

February 12th, 2019

I've finished porting all the Close Reading material over to an Oxygen-based editing format, and posted a test version of the site on the hcmc server; waiting on KB to let me know how he wants to proceed in terms of replacing the old site. More could be done on the documentation for editors, but if it turns out not much more editing is going to be done anyway, it may not be worth the time.