1.12 Consolidation 1

Order

1.10

Status

::PROTO::

Location Status

No reservation needed; president of neighborhood association, Mark Scardina, has said it's okay

GC Point of Contact

Erik

Location Notes

Urbano Sundial

Type

Mandatory Puzzle

Plot Setup

Players have managed to help Doctor When "fix the timeline" by sending back the letter...but apparently there's one more technical fix they have to help with before Doctor When can be returned to the present.

Props

• Leaderboard display
• Server(s) for submitting solutions

Short Description

Final fix before Doctor can be returned to the present.

Technical Setup

USE trenchwood;

• Clean out the solved puzzle table
  • Log in to mysql on wei-Hwa's server (username: laboratory, password: forscience), then run:

TRUNCATE TABLE solves;
TRUNCATE TABLE requests;
TRUNCATE TABLE released;
TRUNCATE TABLE assignments;

• Clean out the log

rm /home/www/doctorwhen/trenchwood.com/public_html/keypad/log/*

• If you need to regenerate the team information:
  • Make sure /home/whuang/public_html/nodir/doctorwhen/gross/teams.csv is correct
  • run this SQL:

TRUNCATE TABLE solvers;
LOAD DATA INFILE '/home/whuang/public_html/nodir/doctorwhen/gross/teams.csv'
 INTO TABLE solvers
 FIELDS TERMINATED BY ','
 OPTIONALLY ENCLOSED BY '"'
 LINES TERMINATED BY '\n'
  IGNORE 1 LINES (solver_id, name, role_id, passcode, present, fake);

• If you need to regenerate the puzzle information (god I hope not), this will recreate the release_info and scores tables:

 mysql -Dpeachfrontier -u laboratory --password=forscience < /home/whuang/prog/keypad/puzinfo.sql

How To Give To Teams

Lab assistant over the phone says words to the effect of,

Success is in our grasp. But the temporal flux lines have shifted. To watch the live feed from the View-O-Scope of us finally rescuing Doctor When you need to meet up with the lab assistant at the Urbano Sundial across the street from 30 Entrada Court in San Francisco.

SUPPLEMENTAL EMAIL

Research Project Title: View The Rescue Of Doctor When

Objective: Travel to where the View-O-Scope Computer Remote Access Program can pick up the signal of Doctor When finally being rescued

Location: Urbano Sundial (a/k/a Ingleside Terraces Sundial), 30 Entrada Court, San Francisco

Upon Completion: Speak with any lab assistant on site

Parking: Street

Bathrooms At Location: No

Food At Location: No

Teams then travel to location.

Lab assistant on site says,

Thank heavens you're here. For some reason, sending the envelope back to Doctor When in 1986 blew out almost all of the tachyon midi ether co-keypads.

Now that we have access to the Brain-O-Matic 9000 supercomputer (thank you very much!) we got it to compute starting specifications for all of them. But we need everyone's help to complete the designs and get the time machine working again.

Please grab a schematic and get to it. When you finish, please grab another. As soon as we finish them all, we'll be able to restart the time machine and finally rescue Doctor When. You can see our overall progress on the screen.

Puzzle Answer

The event is over when all co-keypad puzzles are solved. GC will regulate the pace by having "lab assistants" artificially solve some puzzles, timing it to end shortly after the last team arrives.

Puzzle Solution

Same as Co-Keypad A event.

Manager

Wei-Hwa

Response to Correct Answer

Lab assistant on site says words to the effect of:

Hooray, you've done it! By working together you've rescued Doctor When. Let's watch.

The Act I Scenes 3 & 4 are played on the big screen. Then lab assistant announces:

Hooray, you've rescued Doctor When! Now it's time to return to the lab for debriefing.

Hold it...there's a bit of residual tachyonic radiation at the lab...probably wouldn't cause sterility.

Well, those darn OSHA government regulators might object. Why don't you just let it die down a bit. Wait till 9 PM. Perhaps you could get yourself some dinner between now and then--here's a list of nearby restaurants.

But definitely don't go back before 9 PM.

To Do

• Design server software.
• Test deployment with LAN.