Differenze tra le versioni di "Cinque per mille/Technical documentation"

Da Wikimedia Italia.
Jump to navigation Jump to search
m (→‎SMS: fix)
(+info)
Riga 52: Riga 52:
  
 
<pre>
 
<pre>
www/wp-content/themes/wikimedia/inc
+
/var/www/cinquex1000/www/wp-content/themes/wikimedia/inc
 +
</pre>
 +
 
 +
== Database ==
 +
 
 +
<pre>
 +
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    |                |
 +
+-----------------------+--------------+------+-----+---------+----------------+
 
</pre>
 
</pre>
  
Riga 62: Riga 83:
  
 
<pre>
 
<pre>
/var/www/wmi/wp-content/themes/wikimedia/inc
+
/var/www/cinquex1000/www/wp-content/themes/wikimedia/inc
 
</pre>
 
</pre>

Versione delle 14:04, 27 mag 2021

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

It uses the provider 💼 vol.

The script is located here:

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