Cinque per mille/Technical documentation

Da Wikimedia Italia.
Pagina legata al server ⚙️ intreccio

Technical documentation about the website for the cinque per mille:

Overview

The website was designed to inform about how to donate to Wikimedia Italia.

  1. user submits the phone number or the email address to receive a notification with donation instructions.
  2. data is stored in a table in the WordPress site
  3. user receives a notification via mail/#SMS

Note: the #SMS is not sent twice.

The data can be downloaded from the "Download XLS Lead" button here:

Users

These users are allowed to access:

Access

ssh intreccio.wikimedia.it

See Infrastruttura.

Filesystem

Document root:

/var/www/cinquex1000/www

WordPress theme:

/var/www/cinquex1000/www/wp-content/themes/wikimedia

Custom scripts:

/var/www/cinquex1000/www/wp-content/themes/wikimedia/inc

Database

mysql cinquexmille_new

DESCRIBE wp_newsite_lead_users;
+-----------------------+--------------+------+-----+---------+----------------+
| Field                 | Type         | Null | Key | Default | Extra          |
+-----------------------+--------------+------+-----+---------+----------------+
| id                    | int(11)      | NO   | PRI | NULL    | auto_increment |
| user_id               | varchar(50)  | NO   |     | NULL    |                |
| nome                  | varchar(255) | NO   |     | NULL    |                |
| cognome               | varchar(255) | NO   |     | NULL    |                |
| email                 | varchar(255) | NO   |     | NULL    |                |
| tel                   | varchar(255) | NO   |     | NULL    |                |
| privacy               | tinyint(4)   | NO   |     | NULL    |                |
| materiale_informativo | tinyint(4)   | NO   |     | NULL    |                |
| created               | datetime     | NO   |     | NULL    |                |
+-----------------------+--------------+------+-----+---------+----------------+

SMS

The SMS are sent via an SMS gateway provided by 💼 vol.

The related source code with a modified version of their SDK is located here:

/var/www/cinquex1000/www/wp-content/themes/wikimedia/inc