Changing the Code

Code Change
The code for our Sail Locker is changed by unlocking the code box on the wall and rearranging somewires. Ralph Jackson (ralphj@u.washington.edu) and Jim Seagren(seagren@uw.edu) know how to do this. Since Jim oversees the WAC so is busy, Ralph is generally a goodfirst choice. Let him know that you want to change the code, what codeyou want to change it to, and when you want the change to take place. You will then need to let the members know (keep reading! How To do this is below :D)

Picking a Code
Recall that the keypad has 12 buttons. Note that numbers 10, 11, and 6 donot work. The 4 numbers that we use must bedifferent--ie: no repeats.

Informing Members
This is a good time to remind members that Novice Ratings expire after6 months, and so they will not receive the code change. Sometimes thecode change email will get caught by spam filters, so you'll probablyget some emails asking for the code again.

Tolet all the members know of the combination change, we run a Perlscript on the database that will gather all the emails. Andrew Roberts(arobs@u.washington.edu) made a code that sent out the following emailto all members:

THIS IS AN AUTOMATED EMAIL SENT BY
THE WASHINGTON YACHT CLUB DATABASE.

Hello Jasmine,

The sail locker combo is about to change. The new combo is:

8 1 4 2

Please take a moment to write the new combo down. The new sail locker
combo will become effective on the evening of Friday, December 18.

Thank you.

Contact Andrew Roberts for the change. Matt MacAdam also knows theappropriate coding to get this done.

Perl Script History
In 2008, there was the followingdiscussion between Ben Widdon and Matt MacAdam:

Matt,
Below are some emails you sent to me about the last database query. Youmight have wanted to change the query to include out to sea members andrig ratings.

There's a perl script in our dante account: send_combo.pm, in the
home directory.

It uses this:

SELECT WYCDatabase.first, WYCDatabase.email
FROM WYCDatabase
WHERE WYCDatabase.WYCNumber IN
(SELECT DISTINCT wyc_ratings.member
FROM wyc_ratings
WHERE wyc_ratings.rating IN (3, 4, 7, 8, 10,
11, 14, 15, 18, 19, 24, 25, 26, 27, 28, 29,
"31, 32, 33)
OR (wyc_ratings.rating IN (2, 6, 13, 17)
"AND (wyc_ratings.date BETWEEN
DATE_SUB(CURRENT_DATE, INTERVAL 180 DAY) AND CURRENT_DATE))
OR (wyc_ratings.rating=30
AND (wyc_ratings.date BETWEEN
DATE_SUB(CURRENT_DATE, INTERVAL 365 DAY) AND CURRENT_DATE)))
AND (WYCDatabase.expireqtr=2 OR WYCDatabase.expireqtr
>= 40 AND out_to_sea=0)
ORDER BY WYCDatabase.WYCNumber

It's pretty similar to mine--main difference is mine didn't account for
expired novice or bravo ratings (should have thought of that!).