back to WRENS Help last update of this page: Friday 24.04.2015 15:02

Setting up WRENS

most of this will be done by Advent Systems

Database

• Create a database for current year and populate with prior year (2015:done)
• Create a folder and subdomain for current year and populate with prior year's files (2015:done)

Data

event facts

Update the event facts with the prior years winners (best done immediately after a regatta, while the current database is still populated)

The SQL is

select event, clubname, t_entries.name from t_timetable left join t_racelane on t_timetable.raceno = t_racelane.raceno left join t_events on t_timetable.eventno = t_events.eventno left join t_entries on t_racelane.crewno = t_entries.crewno left join t_clubcodes on t_entries.club = t_clubcodes.club where roundno = 4 and pos = 1

and then mangle this to create the “INSERT INTO t_eventfacts…” SQL.

Maybe enhance the above SQL to do the mangling.

BarCode Software

Software lives in /barcode/ (top level), and the help file provides a link to download it.

No changes should be needed; the program talks to http://year.wallingford-regatta.org/ where year is the current year…….

However, need to makes sure it is installed on all registration user PC's.

Front page (index.php)

Make sure your root folder in Dreamweaver is the top level of the domain and NOT the current years subfolder.

• Adjust Index.php to introduce the current year, but point to the prior year system for viewing, and the test system for playing (2015:done)
• The night before the regatta, point to the current live system

Passwords and users

Users are maintained in the Wrens Database, for which you need MySQL access. The relevant tables are

t_usergroups
t_users

By convention the passwords should be updated each year to make sure the right system is being accessed.

Check if updates are needed to the authentication table (information only)

Copyright year in footer

Now auto-updated.

DidWeWin

Make sure your local Dreamweaver copy of the DidweWin website is up-to-date

• Adjust connections\rowing.php to point to database for the year.
• Update Templates\mobile.dwt with correct year in footer and home page link. Review logo.
• Review event groups in index.tpl
• PUT all the changed files in smartydir\templates
• Remember to upload the revised Dreamweaver template file to the server

Backup

Change the backup script to the current year database and current backup location

Update the Cron job to run backups hourly before the event, and every 15 mins on the day

Setup a complete backup on another server.

Server Time

Make sure the clock on the server is accurate - update it in WHM (Server Config > Server Time > Synch with time server)