Changes
Page history
Document the YEC counter start date update procedure
authored
Dec 07, 2023
by
kez
Hide whitespace changes
Inline
Side-by-side
service/crm.md
View page @
5a2ab43f
...
...
@@ -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
...
...
...
...