Document the YEC counter start date update procedure authored by kez's avatar kez
......@@ -379,6 +379,25 @@ documentation](#mysql-backup-system).
The folks at GiantRabbit probably have their own documentation.
### Updating the YEC donation match counter
At the end of every year we have our year-end campaign. As part of this campaign,
we have a donation match, where every donation made during the YEC is matched up
to a certain dollar amount. This match campaign displays three counters on the
donate site: "Number of Donations", "Total Donated", and "Total Raised with
Friends of Tor's Match". These counters are controlled by a start date variable
in mysql on crm-int-01. To update this donation counter start time, use the SQL
example below:
```sql
UPDATE variable SET value = 's:16:"2023-11-27T00:00";' WHERE name = 'tor_donation_counter_start_time';
```
This variable is a serialized PHP value. The value is serialized as `<type>:<length>:"<time>";`,
where type is `s` (for string), length is `16` (this datetime format is always 16 characters long),
and time is some kind of not-quite-ISO8601 (it's ISO8601 without the trailing `Z` on the end);
**note quotes around the datetime string, and the semicolon at the end of the serialized representation**.
# Discussion
This section is reserved for future large changes proposed to this
......
......