// LEESMIJ.txt
//
// SST - SOFTSKILLS TESTS
//
// -- Bron data (testen en kleuren en teksten) staan bij google in SOFTSKILLS_TEKSTEN_BRON
// -- Deze kunnen geïmporteerd worden naar YODA SERVER database nlhr01_softskills
// De datum van de laatste wijziging bij GOOGLE wordt getoond
// De datum wanneer de laatste synchronisatie was wordt getoond
// Indien de data biuj google nieuwer is dan is een update zinvol, dit wordt aangegeven
//
// SYSTEMOWNER kan dit via sst_gamehost.php, ANDEREN NIET
// DATABASES op NLHR01 die nodig zijn
nlhr01_accounts Hier staan alle accounts voor de nlhr01 omgeving
TABLE accounts
+------------------+-------------+------+-----+-------------------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+-------------------+-------------------+
| acs_email | varchar(50) | NO | PRI | NULL | |
| acs_firstname | varchar(20) | YES | | NULL | |
| acs_lastname | varchar(20) | YES | | NULL | |
| acs_gender | varchar(1) | YES | | NULL | |
| acs_registration | timestamp | YES | | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| acs_password | varchar(60) | YES | | NULL | |
| acs_secret | varchar(60) | YES | | NULL | |
| acs_validated | int | YES | | NULL | |
| acs_login_count | int | YES | | NULL | |
| acs_last_login | timestamp | YES | | NULL | |
| acs_gamehost | text | YES | | NULL | | |TEG|ICG|SST|
| acs_systemowner | text | YES | | NULL | | |TEG|ICG|SST|
+------------------+-------------+------+-----+-------------------+-------------------+
nlhr01_softskills Hier staan de van google geïmporteerde teksten in de verschillende talen
Tevens worden in deze database de resusltaten bewaard
En deze database bevat ook de interface teksten in NL, DE en GB
TABLE language - talen NE GB DE voor de user interface NIET de testen zelf, dat komt van google
+-----------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+-------+
| lge_country | varchar(3) | NO | PRI | NULL | | NL GB DE
| lge_description | text | YES | | NULL | | OMSCHRIJVING WAT HET IS
| lge_id | int | NO | PRI | NULL | | UNIEKE ID VOOR VERVANGING
| lge_text | text | YES | | NULL | | DE TEKST IN DE BETREFFENDE TAAL
+-----------------+------------+------+-----+---------+-------+
TABLE management - laatste wijzigings datum in seconds since Epoch
+-----------+------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------+------+-----+---------+-------+
| mnm_epoch | int | YES | | NULL | | seconden sinds epoch
+-----------+------+------+-----+---------+-------+
TABLE iso_languages - talen die er zijn volgens ISO -- create table iso_languages (isl_iso639_1 varchar(2), isl_name_gb TEXT, isl_name_native TEXT, PRIMARY KEY(isl_iso639_1));
+-----------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+-------+
| isl_iso639_1 | varchar(2) | NO | PRI | NULL | |
| isl_name_gb | text | YES | | NULL | |
| isl_name_native | text | YES | | NULL | |
+-----------------+------------+------+-----+---------+-------+
TABLE iso_countries - landen die er zijn volgens ISO -- create table iso_countries (isc_iso3166_1 varchar(2), isc_name_gb TEXT, isc_name_native TEXT, isc_flag_svg TEXT, PRIMARY KEY(isl_iso639_1));
+-----------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+-------+
| isc_iso3166_1 | varchar(2) | NO | PRI | NULL | |
| isc_name_gb | text | YES | | NULL | |
| isc_name_native | text | YES | | NULL | |
| isc_flag_svg | text | YES | | NULL | |
+-----------------+------------+------+-----+---------+-------+
TABLE countries_languages - talen per land volgens ISO
+-------------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------------+------+-----+---------+-------+
| ctl_isc_iso3166_1 | varchar(2) | NO | PRI | NULL | |
| ctl_isc_iso639_1 | json | YES | | NULL | |
+-------------------+------------+------+-----+---------+-------+
TABLE tests_source - test inhoud opgehaald van google gsheet -- create table tests_source (tsc_tabname varchar(30), tsc_isl_iso639_1 varchar(2), tsc_google_row varchar(4), tsc_google_text TEXT, PRIMARY KEY(tsc_tabname,tsc_isl_iso639_1,tsc_google_row))
+------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| tsc_tabname | varchar(30) | NO | PRI | NULL | |
| tsc_isl_iso639_1 | varchar(2) | NO | PRI | NULL | |
| tsc_google_row | varchar(4) | NO | PRI | NULL | |
| tsc_google_text | text | YES | | NULL | |
+------------------+-------------+------+-----+---------+-------+
DROP TABLE IF EXISTS scans;
CREATE TABLE scans (scs_email VARCHAR(50), scs_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP, scs_iso639_1 VARCHAR(2), scs_tabname VARCHAR(30), scs_b_q1 TINYINT, scs_b_q2 TINYINT, scs_b_q3 TINYINT, scs_b_q4 TINYINT, scs_b_q5 TINYINT, scs_b_q6 TINYINT, scs_b_q7 TINYINT, scs_b_q8 TINYINT, scs_b_q9 TINYINT, scs_b_q10 TINYINT, scs_b_q11 TINYINT, scs_b_q12 TINYINT, scs_b_q13 TINYINT, scs_b_q14 TINYINT, scs_b_q15 TINYINT, scs_b_q16 TINYINT, scs_b_q17 TINYINT, scs_b_q18 TINYINT, scs_b_q19 TINYINT, scs_b_q20 TINYINT, scs_b_q21 TINYINT, scs_b_q22 TINYINT, scs_b_q23 TINYINT, scs_b_q24 TINYINT, scs_b_q25 TINYINT, scs_b_q26 TINYINT, scs_b_q27 TINYINT, scs_b_q28 TINYINT, scs_b_q29 TINYINT, scs_b_q30 TINYINT, scs_b_q31 TINYINT, scs_b_q32 TINYINT, scs_b_q33 TINYINT, scs_b_q34 TINYINT, scs_b_q35 TINYINT, scs_b_q36 TINYINT, scs_b_q37 TINYINT, scs_b_q38 TINYINT, scs_b_q39 TINYINT, scs_b_q40 TINYINT, scs_r_q1 TINYINT, scs_r_q2 TINYINT, scs_r_q3 TINYINT, scs_r_q4 TINYINT, scs_r_q5 TINYINT, scs_r_q6 TINYINT, scs_r_q7 TINYINT, scs_r_q8 TINYINT, scs_r_q9 TINYINT, scs_r_q10 TINYINT, scs_r_q11 TINYINT, scs_r_q12 TINYINT, scs_r_q13 TINYINT, scs_r_q14 TINYINT, scs_r_q15 TINYINT, scs_r_q16 TINYINT, scs_r_q17 TINYINT, scs_r_q18 TINYINT, scs_r_q19 TINYINT, scs_r_q20 TINYINT, scs_r_q21 TINYINT, scs_r_q22 TINYINT, scs_r_q23 TINYINT, scs_r_q24 TINYINT, scs_r_q25 TINYINT, scs_r_q26 TINYINT, scs_r_q27 TINYINT, scs_r_q28 TINYINT, scs_r_q29 TINYINT, scs_r_q30 TINYINT, scs_r_q31 TINYINT, scs_r_q32 TINYINT, scs_r_q33 TINYINT, scs_r_q34 TINYINT, scs_r_q35 TINYINT, scs_r_q36 TINYINT, scs_r_q37 TINYINT, scs_r_q38 TINYINT, scs_r_q39 TINYINT, scs_r_q40 TINYINT, PRIMARY KEY (scs_email ASC, scs_timestamp ASC, scs_iso639_1 ASC));
TABLE scans -- contains the results from earlier scans
+---------------+-------------+------+-----+-------------------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+-------------------+-------------------+
| scs_email | varchar(50) | NO | PRI | NULL | |
| scs_timestamp | timestamp | NO | PRI | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| scs_iso639_1 | varchar(2) | NO | PRI | NULL | |
| scs_tabname | varchar(30) | YES | | NULL | |
| scs_b_q1 | tinyint | YES | | NULL | |
| scs_b_q2 | tinyint | YES | | NULL | |
| scs_b_q3 | tinyint | YES | | NULL | |
| scs_b_q4 | tinyint | YES | | NULL | |
| scs_b_q5 | tinyint | YES | | NULL | |
| scs_b_q6 | tinyint | YES | | NULL | |
| scs_b_q7 | tinyint | YES | | NULL | |
| scs_b_q8 | tinyint | YES | | NULL | |
| scs_b_q9 | tinyint | YES | | NULL | |
| scs_b_q10 | tinyint | YES | | NULL | |
| scs_b_q11 | tinyint | YES | | NULL | |
| scs_b_q12 | tinyint | YES | | NULL | |
| scs_b_q13 | tinyint | YES | | NULL | |
| scs_b_q14 | tinyint | YES | | NULL | |
| scs_b_q15 | tinyint | YES | | NULL | |
| scs_b_q16 | tinyint | YES | | NULL | |
| scs_b_q17 | tinyint | YES | | NULL | |
| scs_b_q18 | tinyint | YES | | NULL | |
| scs_b_q19 | tinyint | YES | | NULL | |
| scs_b_q20 | tinyint | YES | | NULL | |
| scs_b_q21 | tinyint | YES | | NULL | |
| scs_b_q22 | tinyint | YES | | NULL | |
| scs_b_q23 | tinyint | YES | | NULL | |
| scs_b_q24 | tinyint | YES | | NULL | |
| scs_b_q25 | tinyint | YES | | NULL | |
| scs_b_q26 | tinyint | YES | | NULL | |
| scs_b_q27 | tinyint | YES | | NULL | |
| scs_b_q28 | tinyint | YES | | NULL | |
| scs_b_q29 | tinyint | YES | | NULL | |
| scs_b_q30 | tinyint | YES | | NULL | |
| scs_b_q31 | tinyint | YES | | NULL | |
| scs_b_q32 | tinyint | YES | | NULL | |
| scs_b_q33 | tinyint | YES | | NULL | |
| scs_b_q34 | tinyint | YES | | NULL | |
| scs_b_q35 | tinyint | YES | | NULL | |
| scs_b_q36 | tinyint | YES | | NULL | |
| scs_b_q37 | tinyint | YES | | NULL | |
| scs_b_q38 | tinyint | YES | | NULL | |
| scs_b_q39 | tinyint | YES | | NULL | |
| scs_b_q40 | tinyint | YES | | NULL | |
| scs_r_q1 | tinyint | YES | | NULL | |
| scs_r_q2 | tinyint | YES | | NULL | |
| scs_r_q3 | tinyint | YES | | NULL | |
| scs_r_q4 | tinyint | YES | | NULL | |
| scs_r_q5 | tinyint | YES | | NULL | |
| scs_r_q6 | tinyint | YES | | NULL | |
| scs_r_q7 | tinyint | YES | | NULL | |
| scs_r_q8 | tinyint | YES | | NULL | |
| scs_r_q9 | tinyint | YES | | NULL | |
| scs_r_q10 | tinyint | YES | | NULL | |
| scs_r_q11 | tinyint | YES | | NULL | |
| scs_r_q12 | tinyint | YES | | NULL | |
| scs_r_q13 | tinyint | YES | | NULL | |
| scs_r_q14 | tinyint | YES | | NULL | |
| scs_r_q15 | tinyint | YES | | NULL | |
| scs_r_q16 | tinyint | YES | | NULL | |
| scs_r_q17 | tinyint | YES | | NULL | |
| scs_r_q18 | tinyint | YES | | NULL | |
| scs_r_q19 | tinyint | YES | | NULL | |
| scs_r_q20 | tinyint | YES | | NULL | |
| scs_r_q21 | tinyint | YES | | NULL | |
| scs_r_q22 | tinyint | YES | | NULL | |
| scs_r_q23 | tinyint | YES | | NULL | |
| scs_r_q24 | tinyint | YES | | NULL | |
| scs_r_q25 | tinyint | YES | | NULL | |
| scs_r_q26 | tinyint | YES | | NULL | |
| scs_r_q27 | tinyint | YES | | NULL | |
| scs_r_q28 | tinyint | YES | | NULL | |
| scs_r_q29 | tinyint | YES | | NULL | |
| scs_r_q30 | tinyint | YES | | NULL | |
| scs_r_q31 | tinyint | YES | | NULL | |
| scs_r_q32 | tinyint | YES | | NULL | |
| scs_r_q33 | tinyint | YES | | NULL | |
| scs_r_q34 | tinyint | YES | | NULL | |
| scs_r_q35 | tinyint | YES | | NULL | |
| scs_r_q36 | tinyint | YES | | NULL | |
| scs_r_q37 | tinyint | YES | | NULL | |
| scs_r_q38 | tinyint | YES | | NULL | |
| scs_r_q39 | tinyint | YES | | NULL | |
| scs_r_q40 | tinyint | YES | | NULL | |
| scs_gamecode | varchar(5) | YES | | NULL | |
| scs_b_sum_q1 | int | YES | | NULL | |
| scs_b_sum_q2 | int | YES | | NULL | |
| scs_b_sum_q3 | int | YES | | NULL | |
| scs_b_sum_q4 | int | YES | | NULL | |
| scs_r_sum_q1 | int | YES | | NULL | |
| scs_r_sum_q2 | int | YES | | NULL | |
| scs_r_sum_q3 | int | YES | | NULL | |
| scs_r_sum_q4 | int | YES | | NULL | |
+---------------+-------------+------+-----+-------------------+-------------------+
USE nlhr01_softskills;
DROP TABLE IF EXISTS colours;
CREATE TABLE colours (cls_tabname VARCHAR(30), cls_q1 VARCHAR(7), cls_q2 VARCHAR(7), cls_q3 VARCHAR(7), cls_q4 VARCHAR(7), PRIMARY KEY (cls_tabname ASC));
// DIRECTORY STRUCTUUR OP DE SERVER
/var/www/nlhr01/public/sst/
php hulp programma's
animations de eventuele animaties (gif)
images de afbeeldingen (png)
LEESMIJ.text DIT BESTAND
sst_login.php Inloggen voor test invullers
sst_gamehost.php Inloggen voor GameHost en SystemOwner
// LOGIC
Er is geen game, resultaten worden opgeslagen met emailaddress en timestamp
// LANGUAGES -- SQL -- RE-ENTRANT CODE, DELETES THE TABLE FIRST AND CREATES IT AAIN WITH NEW CONTENT
//
USE nlhr01_softskills;
DROP TABLE IF EXISTS `language`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `language` (
`lge_country` varchar(3) NOT NULL,
`lge_description` text,
`lge_id` int NOT NULL,
`lge_text` text,
PRIMARY KEY (`lge_country`,`lge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/**********************************************************/
/* VOOR HANDMATIGE UPDATE 'languages': KOPIEER VANAF HIER */
/**********************************************************/
/* ------------------------------------------------------------------------------------------------------------------------------------------------------ */
/* NL - NEDERLANDS */
/* ------------------------------------------------------------------------------------------------------------------------------------------------------ */
USE nlhr01_softskills;
DELETE FROM language;
INSERT INTO language VALUES
('NL','modal_message - header', 100001, 'LOGGING IN'),
('NL','modal_message - message', 100002, 'Controleren toegangsgegevens'),
('NL','modal_message - footer', 100003, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100011, 'CONTROLEREN OP UPDATES'),
('NL','modal_message - message', 100012, 'Vaststellen of de data in de google sheet nieuwer is.'),
('NL','modal_message - footer', 100013, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100021, 'OPHALEN VAN DE NAMEN VAN DE TESTEN'),
('NL','modal_message - message', 100022, 'De namen van de testen waaruit u kunt kiezen worden nu opghehaald.'),
('NL','modal_message - footer', 100023, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100031, 'BIJWERKEN VAN DE DATABASE'),
('NL','modal_message - message', 100032, 'De database met beschikbare testen wordt nu bijgewerkt inclusief de bijbehorende kleuren.'),
('NL','modal_message - footer', 100033, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100041, ' - BEREKENEN HISTOGRAMMEN'),
('NL','modal_message - message', 100042, 'De frequenties per waarde voor elk kwadrant en de frequenties per waarde voor elk woord worden nu berekend.'),
('NL','modal_message - footer', 100043, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100051, '- BEREKENEN HISTOGRAMMEN'),
('NL','modal_message - message', 100052, 'De frequenties per gemiddelde voor elk kwadrant met het aangegeven aantal klasses worden nu berekend'),
('NL','modal_message - footer', 100053, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100061, 'SPELCODE GENEREREN'),
('NL','modal_message - message', 100062, 'Een actieve code voor toegang tot de softskills testen wordt nu gegenereerd.'),
('NL','modal_message - footer', 100063, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100071, 'OPHALEN VAN ALLE GAMECODES'),
('NL','modal_message - message', 100072, 'Alle codes van alle eerder gespeelde games van alle gamehosts worden nu opgehaald.'),
('NL','modal_message - footer', 100073, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100081, 'OPHALEN VAN UW GAMECODES'),
('NL','modal_message - message', 100082, 'Alle codes van alle eerder door u gespeelde games worden nu opgehaald.'),
('NL','modal_message - footer', 100083, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100091, '- WIJZIGEN VAN DE STATUS'),
('NL','modal_message - message', 100092, 'De status wordt gewijzigd.'),
('NL','modal_message - footer', 100093, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100101, 'OPHALEN TEST NAMEN'),
('NL','modal_message - message', 100102, 'Ophalen van de testnamen in de huidige taal.'),
('NL','modal_message - footer', 100103, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100201, 'OPHALEN BESCHIKBARE TALEN'),
('NL','modal_message - message', 100202, 'Vaststellen in welke talen de test beschikbaar is.'),
('NL','modal_message - footer', 100203, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100301, 'OPHALEN VAN DE TEST'),
('NL','modal_message - message', 100302, 'De test wordt opgehaald in de door u gekozen taal.'),
('NL','modal_message - footer', 100303, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100401, 'OPSLAAN VAN DE RESULTATEN'),
('NL','modal_message - message', 100402, 'Uw resultaten worden nu bewaard.'),
('NL','modal_message - footer', 100403, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100501, 'AANMAKEN VAN DE PDF'),
('NL','modal_message - message', 100502, 'Van uw resultaten wordt nu een PDF bestand gemaakt.'),
('NL','modal_message - footer', 100503, 'Een ogenblik geduld a.u.b.'),
('NL','modal_message - header', 100601, 'MAILEN VAN DE PDF'),
('NL','modal_message - message', 100602, 'Wij gaan de resultaten NU mailen.'),
('NL','modal_message - footer', 100603, 'Een ogenblik geduld a.u.b.'),
('NL','modal_whoops - header', 200001, 'ER GING IETS MIS (state 5)'),
('NL','modal_whoops - message', 200002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200011, 'ER GING IETS MIS (state 7)'),
('NL','modal_whoops - message', 200012, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200013, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200021, 'ER GING IETS MIS (state 9)'),
('NL','modal_whoops - message', 200022, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200023, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200031, 'ER GING IETS MIS (state 21)'),
('NL','modal_whoops - message', 200032, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200033, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200041, 'ER GING IETS MIS (state 23)'),
('NL','modal_whoops - message', 200042, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200043, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200051, 'ER GING IETS MIS (state 901)'),
('NL','modal_whoops - message', 200052, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200053, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200061, 'ER GING IETS MIS (state 904)'),
('NL','modal_whoops - message', 200062, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200063, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200071, 'ER GING IETS MIS (state 907)'),
('NL','modal_whoops - message', 200072, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200073, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200081, 'ER GING IETS MIS (state 909)'),
('NL','modal_whoops - message', 200082, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200083, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200091, 'ER GING IETS MIS (state 911)'),
('NL','modal_whoops - message', 200092, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200093, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200101, 'ER GING IETS MIS (state 913)'),
('NL','modal_whoops - message', 200102, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200103, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200201, 'ER GING IETS MIS (state 915)'),
('NL','modal_whoops - message', 200202, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200203, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200301, 'ER GING IETS MIS (state 1001)'),
('NL','modal_whoops - message', 200302, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200303, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200401, 'ER GING IETS MIS (state 1003)'),
('NL','modal_whoops - message', 200402, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200403, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200501, 'ER GING IETS MIS (state 1006)'),
('NL','modal_whoops - message', 200502, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200503, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200601, 'ER GING IETS MIS (state 2001)'),
('NL','modal_whoops - message', 200602, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200603, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200701, 'ER GING IETS MIS (state 2003)'),
('NL','modal_whoops - message', 200702, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200703, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200801, 'ER GING IETS MIS (state 3001)'),
('NL','modal_whoops - message', 200802, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200803, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 200901, 'ER GING IETS MIS (state 3006)'),
('NL','modal_whoops - message', 200902, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 200903, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 201001, 'ER GING IETS MIS (state 3011)'),
('NL','modal_whoops - message', 201002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 201003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 202001, 'ER GING IETS MIS (state 10001)'),
('NL','modal_whoops - message', 202002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 202003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 203001, 'ER GING IETS MIS (state 10003)'),
('NL','modal_whoops - message', 203002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 203003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 204001, 'ER GING IETS MIS (state 10011)'),
('NL','modal_whoops - message', 204002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 204003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 205001, 'ER GING IETS MIS (state 10018)'),
('NL','modal_whoops - message', 205002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 205003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 206001, 'ER GING IETS MIS (state 10024)'),
('NL','modal_whoops - message', 206002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 206003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 207001, 'ER GING IETS MIS (state 10026)'),
('NL','modal_whoops - message', 207002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 207003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_whoops - header', 208001, 'ER GING IETS MIS (state 10027)'),
('NL','modal_whoops - message', 208002, 'gAnswer.msg van backend wordt gebruikt'),
('NL','modal_whoops - footer', 208003, 'Maak a.u.b. een screenshot van deze fout en stuur deze naar ons zodat wij dit kunnen onderzoeken.'),
('NL','modal_ask - header', 300001, 'VERDACHTE AFWIJKING GEVONDEN'),
('NL','modal_ask - message', 300002, 'Hebt u bij de laatste lijst inderdaad de MEESTE (max. 10) punten toegekend aan wat bij u het SLECHTSTE past?
Dit is namelijk anders dan bij de eerste lijst!
Als u NEE kiest, dan kunt u uw antwoorden nog aanpassen.
Als u JA kies worden de resulaten bewaard en krijgt u de resultaten te zien.'),
('NL','modal_ask - false button', 300004, 'NEE'),
('NL','modal_ask - true button', 300003, 'JA'),
('NL','email pdf - subject', 400001, 'LEARNGAMES - Resultaten van uw Softskills Test'),
('NL','email pdf - body', 400002, "LEARNGAMES RESULTATEN
Beste |||NAME|||,
Hier zijn de resultaten van uw Softskills Test die door u op |||DATE||| hebt ingevuld.
Met vriendelijke groet,
LEARNGAMES door LE-Network
"),
('NL','login_screen', 1000, 'GAMEHOST'),
('NL','login_screen', 1001, 'Softskills testen'),
('NL','login_screen', 1002, 'EMAIL ADRES'),
('NL','login_screen', 1003, 'WACHTWOORD'),
('NL','login_screen', 1004, 'GEEN AUTORISATIE VOOR GAMEHOST'),
('NL','not_authorised_screen', 1100, 'NORMALE GEBRUIKER'),
('NL','not_authorised_screen', 1101, 'NIET GEMACHTIGD VOOR GAMEHOST'),
('NL','not_authorised_screen', 1102, 'NEEM CONTACT OP MET LE-NETWORK VOOR EEN MACHTIGING'),
('NL','control_screen_system_owner', 1200, 'SYSTEEM EIGENAAR'),
('NL','control_screen_system_owner', 1201, 'Systeem Onderhoud Functies'),
('NL','START synchronisation block', 1202, 'SYNCHRONISATIE MET GOOGLE BRON'),
('NL','START synchronisation block', 1203, 'SERVER'),
('NL','START synchronisation block', 1204, 'BRON'),
('NL','START synchronisation block', 1205, 'SYNCHRONISATIE IS NODIG'),
('NL','START synchronisation block', 1206, 'SYNCHRONISEER NU'),
('NL','START synchronisation block', 1207, 'SYNCHRONISATIE IS NIET NODIG'),
('NL','START SYNCHRONISING BLOCK', 1210, 'SYNCHRONISATIE PROCES'),
('NL','START SYNCHRONISING BLOCK', 1211, 'START'),
('NL','START SYNCHRONISING BLOCK', 1212, 'DUUR'),
('NL','validation_buttons_quadrants_words', 1220, 'DYNAMISCHE VALIDATIE KWADRANTEN EN WOORDEN'),
('NL','validation_buttons_quadrants_words', 1221, 'Deze grafieken tonen per kwadrant de frequenties van de waarden en per woord de frequenties van de waarden.'),
('NL','validation_quadrants_block', 1230, 'DYNAMISCHE VALIDATIE KWADRANTEN'),
('NL','validation_quadrants_block', 1231, 'BASIS STIJL: Deze grafieken tonen het aantal keren (Y-as) dat een waarde (X-as) voorkomt per kwadrant (Q1 Q2 Q3 Q4).'),
('NL','validation_quadrants_block', 1232, 'Basis Q1'),
('NL','validation_quadrants_block', 1233, 'Basis Q2'),
('NL','validation_quadrants_block', 1234, 'Basis Q3'),
('NL','validation_quadrants_block', 1235, 'Basis Q4'),
('NL','validation_quadrants_block', 1236, 'RESPONS STIJL: Deze grafieken tonen het aantal keren (Y-as) dat een waarde (X-as) voorkomt per kwadrant (Q1 Q2 Q3 Q4).'),
('NL','validation_quadrants_block', 1237, 'Respons Q1'),
('NL','validation_quadrants_block', 1238, 'Respons Q2'),
('NL','validation_quadrants_block', 1239, 'Respons Q3'),
('NL','validation_quadrants_block', 1240, 'Respons Q4'),
('NL','validation_quadrants_words_block', 1250, 'DYNAMISCHE VALIDATIE KWADRANTEN -- WOORDEN'),
('NL','validation_quadrants_words_block', 1251, 'BASIS STIJL: Deze grafieken tonen het aantal keren (Y-as) dat een waarde (X-as) voorkomt per kwadrant (Q1 Q2 Q3 Q4), per woord (1..10).'),
('NL','validation_quadrants_words_block', 1252, 'RESPONS STIJL: Deze grafieken tonen het aantal keren (Y-as) dat een waarde (X-as) voorkomt per kwadrant (Q1 Q2 Q3 Q4), per woord (1..10).'),
('NL','validation_quadrants_averages_block', 1260, 'DYNAMISCHE VALIDATIE KWADRANTEN -- GEMIDDELDEN GEKOZEN AANTAL KLASSEN'),
('NL','validation_quadrants_averages_block', 1261, 'Deze grafieken tonen per kwadrant de frequenties van de kwadrant gemiddelden. Er zijn in totaal [0..100] mogelijke gemiddelden.
Het aantal klassen kan een waarde zijn van [5..25].
Er zijn 101 mogelijke gemiddelden. Aangezien 101 een priemgetal is en omdat de gemiddelden integers zijn, is het gegarandeerd dat klassen niet overlappen.'),
('NL','setClassCount()', 1262, 'KLASSE BREEDTE'),
('NL','validation_quadrants_averages_block_results', 1270, 'Basis Q1'),
('NL','validation_quadrants_averages_block_results', 1271, 'Basis Q2'),
('NL','validation_quadrants_averages_block_results', 1272, 'Basis Q3'),
('NL','validation_quadrants_averages_block_results', 1273, 'Basis Q4'),
('NL','validation_quadrants_averages_block_results', 1274, 'Respons Q1'),
('NL','validation_quadrants_averages_block_results', 1275, 'Respons Q2'),
('NL','validation_quadrants_averages_block_results', 1276, 'Respons Q3'),
('NL','validation_quadrants_averages_block_results', 1277, 'Respons Q4'),
('NL','gamehost_screen', 1300, 'GAMEHOST'),
('NL','gamehost_screen', 1301, 'Gamehost Functies'),
('NL','gamehost_screen', 1310, 'SOFTSKILLSTEST TOEGANGSCODE'),
('NL','gamehost_screen', 1311, 'Om een Softskillstest te kunnen invullen moet de invuller een LEARNGAMES account hebben (eMail) en een code genenereerd door de GameHost.
De door de GameHost gegenereerde code blijft geldig tot de GameHost deze deactiveert.'),
('NL','gamehost_screen', 1312, 'Genereer een code'),
('NL','gamehost_screen', 1313, 'Activeer/de-activeer een code'),
('NL','gamehost_screen', 1314, 'Toon testen'),
('NL','gamehost_codes_block', 1320, 'UW CODES'),
('NL','gamehost_codes_block', 1321, 'Codes gemarkeerd met een groene circel zijn aktief en kunnen gebruikt worden om een test in te vullen.
Klik op een code om deze te activeren of te de-activeren.'),
('NL','tests_screen', 1400, 'KIES DE TEST DIE U WILT INVULLEN'),
('NL','tests_screen', 1401, 'Hieronder ziet u de tests waaruit u kunt kiezen
Nadat u een test hebt gekozen verschijnt een lijst met de talen waarin deze test beschikbaar is.
Wij adviseren om de test in uw moedertaal te doen indien deze beschikbaar is.
Kom nog eens terug, in de toekomst worden er nog meer testen toegevoegd.'),
('NL','tests_screen', 1402, 'KIES UW TAAL (NL) ↓'),
('NL','tests_screen', 1403, 'TERUG'),
('NL','tests_screen', 1404, 'TEST INVULLEN'),
('NL','softskills_entry', 1410, 'SOFTSKILLSTEST'),
('NL','softskills_entry', 1411, 'Hieronder staat het test invoer scherm, de test wordt bewaard onder uw email adres met code TEST.'),
('NL','softskills_entry', 1412, 'Bewaren'),
/* ------------------------------------------------------------------------------------------------------------------------------------------------------ */
/* GB - ENGELS */
/* ------------------------------------------------------------------------------------------------------------------------------------------------------ */
('EN','modal_message - header', 100001, 'LOGGING IN'),
('EN','modal_message - message', 100002, 'Checking your credentials'),
('EN','modal_message - footer', 100003, 'One moment please.'),
('EN','modal_message - header', 100011, 'CHECKING FOR UPDATES'),
('EN','modal_message - message', 100012, 'Check if the data in the google source sheet is newer.'),
('EN','modal_message - footer', 100013, 'One moment please.'),
('EN','modal_message - header', 100021, 'FETCHING TEST NAMES'),
('EN','modal_message - message', 100022, 'The names of the tests you can choose from are now being fetched.'),
('EN','modal_message - footer', 100023, 'One moment please.'),
('EN','modal_message - header', 100031, 'UPDATE DATABASE'),
('EN','modal_message - message', 100032, 'The database with available tests is now being updated including the colours.'),
('EN','modal_message - footer', 100033, 'One moment please.'),
('EN','modal_message - header', 100041, ' - CALCULATING HISTOGRAMS'),
('EN','modal_message - message', 100042, 'The frequencies per value for each quadrant and the frequencies per value for each word are being calculated.'),
('EN','modal_message - footer', 100043, 'One moment please.'),
('EN','modal_message - header', 100051, '- CALCULATING HISTOGRAMS'),
('EN','modal_message - message', 100052, 'The frequencies per average for each quadrant with the chosen number of classes are being calculated.'),
('EN','modal_message - footer', 100053, 'One moment please.'),
('EN','modal_message - header', 100061, 'GENERATE GAMECODE'),
('EN','modal_message - message', 100062, 'An active code for access to the softskills tests is being generated.'),
('EN','modal_message - footer', 100063, 'One moment please.'),
('EN','modal_message - header', 100071, 'RETRIEVING ALL GAMECODES'),
('EN','modal_message - message', 100072, 'All codes from all games that have been played before (all gamehosts) are being fetched now.'),
('EN','modal_message - footer', 100073, 'One moment please.'),
('EN','modal_message - header', 100081, 'RETRIEVING YOUR GAMECODES'),
('EN','modal_message - message', 100082, 'All codes from all games that have been played before by you are being fetched now.'),
('EN','modal_message - footer', 100083, 'One moment please.'),
('EN','modal_message - header', 100091, '- CHANGE THE STATUS'),
('EN','modal_message - message', 100092, 'The status is being changed.'),
('EN','modal_message - footer', 100093, 'One moment please.'),
('EN','modal_message - header', 100101, 'FETCHING TEST NAMES'),
('EN','modal_message - message', 100102, 'Fetching the testnames in the current language.'),
('EN','modal_message - footer', 100103, 'One moment please.'),
('EN','modal_message - header', 100201, 'FETCHING AVAILABLE TEST LANGUAGES'),
('EN','modal_message - message', 100202, 'Determining in which languages the test is available.'),
('EN','modal_message - footer', 100203, 'One moment please.'),
('EN','modal_message - header', 100301, 'FETCHING THE TEST'),
('EN','modal_message - message', 100302, 'The test is being fetched in the selected language.'),
('EN','modal_message - footer', 100303, 'One moment please.'),
('EN','modal_message - header', 100401, 'STORING THE RESULTS'),
('EN','modal_message - message', 100402, 'Your results are being stored.'),
('EN','modal_message - footer', 100403, 'One moment please.'),
('EN','modal_message - header', 100501, 'CREATING THE PDF'),
('EN','modal_message - message', 100502, 'Your results are now being converted into a PDF file.'),
('EN','modal_message - footer', 100503, 'One moment please.'),
('EN','modal_message - header', 100601, 'MAILING THE PDF'),
('EN','modal_message - message', 100602, 'We will NOW send you an email with the results.'),
('EN','modal_message - footer', 100603, 'One moment please.'),
('EN','modal_whoops - header', 200001, 'SOMETHING WENT WRONG (state 5)'),
('EN','modal_whoops - message', 200002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200011, 'SOMETHING WENT WRONG (state 7)'),
('EN','modal_whoops - message', 200012, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200013, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200021, 'SOMETHING WENT WRONG (state 9)'),
('EN','modal_whoops - message', 200022, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200023, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200031, 'SOMETHING WENT WRONG (state 21)'),
('EN','modal_whoops - message', 200032, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200033, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200041, 'SOMETHING WENT WRONG (state 23)'),
('EN','modal_whoops - message', 200042, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200043, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200051, 'SOMETHING WENT WRONG (state 901)'),
('EN','modal_whoops - message', 200052, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200053, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200061, 'SOMETHING WENT WRONG (state 904)'),
('EN','modal_whoops - message', 200062, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200063, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200071, 'SOMETHING WENT WRONG (state 907)'),
('EN','modal_whoops - message', 200072, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200073, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200081, 'SOMETHING WENT WRONG (state 909)'),
('EN','modal_whoops - message', 200082, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200083, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200091, 'SOMETHING WENT WRONG (state 911)'),
('EN','modal_whoops - message', 200092, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200093, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200101, 'SOMETHING WENT WRONG (state 913)'),
('EN','modal_whoops - message', 200102, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200103, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200201, 'SOMETHING WENT WRONG (state 915)'),
('EN','modal_whoops - message', 200202, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200203, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200301, 'SOMETHING WENT WRONG (state 1001)'),
('EN','modal_whoops - message', 200302, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200303, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200401, 'SOMETHING WENT WRONG (state 1003)'),
('EN','modal_whoops - message', 200402, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200403, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200501, 'SOMETHING WENT WRONG (state 1006)'),
('EN','modal_whoops - message', 200502, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200503, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200601, 'SOMETHING WENT WRONG (state 2001)'),
('EN','modal_whoops - message', 200602, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200603, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200701, 'SOMETHING WENT WRONG (state 2003)'),
('EN','modal_whoops - message', 200702, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200703, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200801, 'SOMETHING WENT WRONG (state 3001)'),
('EN','modal_whoops - message', 200802, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200803, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 200901, 'SOMETHING WENT WRONG (state 3006)'),
('EN','modal_whoops - message', 200902, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 200903, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 201001, 'SOMETHING WENT WRONG (state 3011)'),
('EN','modal_whoops - message', 201002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 201003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 202001, 'SOMETHING WENT WRONG (state 10001)'),
('EN','modal_whoops - message', 202002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 202003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 203001, 'SOMETHING WENT WRONG (state 10003)'),
('EN','modal_whoops - message', 203002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 203003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 204001, 'SOMETHING WENT WRONG (state 10011)'),
('EN','modal_whoops - message', 204002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 204003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 205001, 'SOMETHING WENT WRONG (state 10018)'),
('EN','modal_whoops - message', 205002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 205003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 206001, 'SOMETHING WENT WRONG (state 10024)'),
('EN','modal_whoops - message', 206002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 206003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 207001, 'SOMETHING WENT WRONG (state 10026)'),
('EN','modal_whoops - message', 207002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 207003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_whoops - header', 208001, 'SOMETHING WENT WRONG (state 10027)'),
('EN','modal_whoops - message', 208002, 'gAnswer.msg van backend wordt gebruikt'),
('EN','modal_whoops - footer', 208003, 'Please make a screenshot of this error and send it to us so we can research what went wrong.'),
('EN','modal_ask - header', 300001, 'SUSPICIOUS DEVIATION DETECTED'),
('EN','modal_ask - message', 300002, 'Did you indeed assign the MOST (up to 10) points to what LEAST suits you in the last list?
This is different from the first list!
If you choose NO, you can modify your answers.
If you choose YES, the results will be saved and you will see the results.'),
('EN','modal_ask - false button', 300004, 'NO'),
('EN','modal_ask - true button', 300003, 'YES'),
('EN','email pdf - subject', 400001, 'LEARNGAMES - Results of your Softskills Test'),
('EN','email pdf - body', 400002, "LEARNGAMES RESULTS
Dear |||NAME|||,
Here are the results from you Softskills Test that you took on |||DATE|||.
Kind regards,
LEARNGAMES by LE-Network
"),
('EN','login_screen', 1000, 'GAMEHOST'),
('EN','login_screen', 1001, 'Softskills tests'),
('EN','login_screen', 1002, 'EMAIL ADRESS'),
('EN','login_screen', 1003, 'PASSWORD'),
('EN','login_screen', 1004, 'NO AUTHORISATION FOR GAMEHOST'),
('EN','not_authorised_screen', 1100, 'STANDARD USER'),
('EN','not_authorised_screen', 1101, 'NOT AUTHORISED FOR THE ROLE OF GAMEHOST'),
('EN','not_authorised_screen', 1102, 'PLEASE CONTACT LE-NETWORK FOR AUTHORISATION'),
('EN','control_screen_system_owner', 1200, 'SYSTEM OWNER'),
('EN','control_screen_system_owner', 1201, 'System Maintenance Functions'),
('EN','START synchronisation block', 1202, 'SYNCHRONISATION WITH GOOGLE SOURCE'),
('EN','START synchronisation block', 1203, 'SERVER'),
('EN','START synchronisation block', 1204, 'SOURCE'),
('EN','START synchronisation block', 1205, 'SYNCHRONISATION IS NECESSARY'),
('EN','START synchronisation block', 1206, 'SYNCHRONISE NOW'),
('EN','START synchronisation block', 1207, 'SYNCHRONISATION IS NOT NECESSARY'),
('EN','START SYNCHRONISING BLOCK', 1210, 'SYNCHRONISATION PROCESS'),
('EN','START SYNCHRONISING BLOCK', 1211, 'START'),
('EN','START SYNCHRONISING BLOCK', 1212, 'DURATION'),
('EN','validation_buttons_quadrants_words', 1220, 'DYNAMIC VALIDATION QUADRANTS AND WORDS'),
('EN','validation_buttons_quadrants_words', 1221, 'These graphs show per quadrant the frequencies of the values and per word de frequencies of the values.'),
('EN','validation_quadrants_block', 1230, 'DYNAMIC VALIDATION QUADRANTS'),
('EN','validation_quadrants_block', 1231, 'BASIC STYLE: These graphs show the number of times (Y-axis) that a value (X-axis) occurs per quadrant (Q1 Q2 Q3 Q4).'),
('EN','validation_quadrants_block', 1232, 'Basic Q1'),
('EN','validation_quadrants_block', 1233, 'Basic Q2'),
('EN','validation_quadrants_block', 1234, 'Basic Q3'),
('EN','validation_quadrants_block', 1235, 'Basic Q4'),
('EN','validation_quadrants_block', 1236, 'RESPONSE STYLE: These graphs show the number of times (Y-axis) that a value (X-axis) occurs per quadrant (Q1 Q2 Q3 Q4).'),
('EN','validation_quadrants_block', 1237, 'Response Q1'),
('EN','validation_quadrants_block', 1238, 'Response Q2'),
('EN','validation_quadrants_block', 1239, 'Response Q3'),
('EN','validation_quadrants_block', 1240, 'Response Q4'),
('EN','validation_quadrants_words_block', 1250, 'DYNAMIC VALIDATION QUADRANTS -- WORDS'),
('EN','validation_quadrants_words_block', 1251, 'BASIC STYLE: These graphs show the number of times (Y-axis) that a value (X-axis) occurs per quadrant (Q1 Q2 Q3 Q4), per word (1..10).'),
('EN','validation_quadrants_words_block', 1252, 'RESPONSE STYLE: These graphs show the number of times (Y-axis) that a value (X-axis) occurs per quadrant (Q1 Q2 Q3 Q4), per word (1..10).'),
('EN','validation_quadrants_averages_block', 1260, 'DYNAMIC VALIDATION QUADRANTS -- AVERAGES CHOSEN NUMBER OF CLASSES'),
('EN','validation_quadrants_averages_block', 1261, 'These graphs display the frequencies of quadrant averages per quadrant. There are a total of [0..100] possible averages.
The number of classes can be a value between [5..25].
There are 101 possible averages. Since 101 is a prime number and because the averages are integers, it is guaranteed that classes do not overlap.'),
('EN','setClassCount()', 1262, 'CLASS WIDTH'),
('EN','validation_quadrants_averages_block_results', 1270, 'Basic Q1'),
('EN','validation_quadrants_averages_block_results', 1271, 'Basic Q2'),
('EN','validation_quadrants_averages_block_results', 1272, 'Basic Q3'),
('EN','validation_quadrants_averages_block_results', 1273, 'Basic Q4'),
('EN','validation_quadrants_averages_block_results', 1274, 'Response Q1'),
('EN','validation_quadrants_averages_block_results', 1275, 'Response Q2'),
('EN','validation_quadrants_averages_block_results', 1276, 'Response Q3'),
('EN','validation_quadrants_averages_block_results', 1277, 'Response Q4'),
('EN','gamehost_screen', 1300, 'GAMEHOST'),
('EN','gamehost_screen', 1301, 'Gamehost Functions'),
('EN','gamehost_screen', 1310, 'SOFTSKILLSTEST ACCESSCODE'),
('EN','gamehost_screen', 1311, 'To complete a Soft Skills Test, the participant must have a LEARNGAMES account (email) and a code generated by the GameHost.
The code generated by the GameHost remains valid until the GameHost deactivates it.'),
('EN','gamehost_screen', 1312, 'Generate a code'),
('EN','gamehost_screen', 1313, 'Activate/de-activate a code'),
('EN','gamehost_screen', 1314, 'Show tests'),
('EN','gamehost_codes_block', 1320, 'YOUR CODES'),
('EN','gamehost_codes_block', 1321, 'Codes marked with a green circle are active and can be used to complete a test.
Click on a code to activate or deactivate it.'),
('EN','tests_screen', 1400, 'CHOOSE THE TEST YOU WANT TO DO'),
('EN','tests_screen', 1401, 'Below you will see the tests you can choose from.
After you have selected a test, a list of the languages in which this test is available will appear.
We recommend taking the test in your native language if it is available.
Come back again, more tests will be added in the future.'),
('EN','tests_screen', 1402, 'CHOOSE YOUR LANGUAGE (EN) ↓'),
('EN','tests_screen', 1403, 'BACK'),
('EN','tests_screen', 1404, 'TAKE TEST'),
('EN','softskills_entry', 1410, 'SOFTSKILLSTEST'),
('EN','softskills_entry', 1411, 'Below is the test input screen; the test will be saved under your email address with the code TEST.'),
('EN','softskills_entry', 1412, 'Save'),
/* ------------------------------------------------------------------------------------------------------------------------------------------------------ */
/* DE - DUITS -- MOET NOG, EERST MAAR IN HET ENGELS */
/* ------------------------------------------------------------------------------------------------------------------------------------------------------ */
('DE','modal_message - header', 100001, 'EINLOGGEN'),
('DE','modal_message - message', 100002, 'Überprüfe deine Anmeldedaten.'),
('DE','modal_message - footer', 100003, 'Einen Moment bitte.'),
('DE','modal_message - header', 100011, 'AUF UPDATES ÜBERPRÜFEN'),
('DE','modal_message - message', 100012, 'Überprüfen ob die Daten in der Google-Quellentabelle neuer sind.'),
('DE','modal_message - footer', 100013, 'Einen Moment bitte.'),
('DE','modal_message - header', 100021, 'FETCHING TEST NAMES'),
('DE','modal_message - message', 100022, 'The names of the tests you can choose from are now being fetched.'),
('DE','modal_message - footer', 100023, 'Einen Moment bitte.'),
('DE','modal_message - header', 100031, 'UPDATE DATABASE'),
('DE','modal_message - message', 100032, 'The database with available tests is now being updated including the colours.'),
('DE','modal_message - footer', 100033, 'Einen Moment bitte.'),
('DE','modal_message - header', 100041, ' - HISTOGRAMME BERECHNEN'),
('DE','modal_message - message', 100042, 'Die Häufigkeiten pro Wert für jeden Quadranten und die Häufigkeiten pro Wert für jedes Wort werden berechnet.'),
('DE','modal_message - footer', 100043, 'Einen Moment bitte.'),
('DE','modal_message - header', 100051, '- HISTOGRAMME BERECHNEN'),
('DE','modal_message - message', 100052, 'Die Häufigkeiten pro Durchschnitt für jeden Quadranten mit der gewählten Anzahl von Klassen werden berechnet.'),
('DE','modal_message - footer', 100053, 'Einen Moment bitte.'),
('DE','modal_message - header', 100061, 'SPIELCODE GENERIEREN'),
('DE','modal_message - message', 100062, 'Ein aktiver Code für den Zugang zu den Softskills-Tests wird generiert.'),
('DE','modal_message - footer', 100063, 'Einen Moment bitte.'),
('DE','modal_message - header', 100071, 'ALLE SPIELCODES ABRUFEN'),
('DE','modal_message - message', 100072, 'Alle Codes aus allen zuvor gespielten Spielen (von allen Spielleitern) werden jetzt abgerufen.'),
('DE','modal_message - footer', 100073, 'Einen Moment bitte.'),
('DE','modal_message - header', 100081, 'DEINE SPIELCODES ABRUFEN'),
('DE','modal_message - message', 100082, 'Alle Codes aus allen zuvor von dir gespielten Spielen werden jetzt abgerufen.'),
('DE','modal_message - footer', 100083, 'Einen Moment bitte.'),
('DE','modal_message - header', 100091, '- DEN STATUS ÄNDERN'),
('DE','modal_message - message', 100092, 'Der Status wird geändert.'),
('DE','modal_message - footer', 100093, 'Einen Moment bitte.'),
('DE','modal_message - header', 100101, 'TESTNAMEN ABRUFEN'),
('DE','modal_message - message', 100102, 'Die Testnamen in der aktuellen Sprache werden abgerufen.'),
('DE','modal_message - footer', 100103, 'Einen Moment bitte.'),
('DE','modal_message - header', 100201, 'VERFÜGBARE TESTSPRACHEN ABRUFEN'),
('DE','modal_message - message', 100202, 'Feststellen, in welchen Sprachen der Test verfügbar ist.'),
('DE','modal_message - footer', 100203, 'Einen Moment bitte.'),
('DE','modal_message - header', 100301, 'DEN TEST ABRUFEN'),
('DE','modal_message - message', 100302, 'Der Test wird in der ausgewählten Sprache abgerufen.'),
('DE','modal_message - footer', 100303, 'Einen Moment bitte.'),
('DE','modal_message - header', 100401, 'DIE ERGEBNISSE SPEICHERN'),
('DE','modal_message - message', 100402, 'Deine Ergebnisse werden gespeichert.'),
('DE','modal_message - footer', 100403, 'Einen Moment bitte.'),
('DE','modal_message - header', 100501, 'PDF ERSTELLEN'),
('DE','modal_message - message', 100502, 'Deine Ergebnisse werden nun in eine PDF-Datei umgewandelt.'),
('DE','modal_message - footer', 100503, 'Einen Moment bitte.'),
('DE','modal_message - header', 100601, 'PDF VERSAND'),
('DE','modal_message - message', 100602, 'Wir werden dir JETZT eine E-Mail mit den Ergebnissen senden.'),
('DE','modal_message - footer', 100603, 'Einen Moment bitte.'),
('DE','modal_whoops - header', 200001, 'ETWAS IST SCHIEFGELAUFEN (state 5)'),
('DE','modal_whoops - message', 200002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200011, 'ETWAS IST SCHIEFGELAUFEN (state 7)'),
('DE','modal_whoops - message', 200012, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200013, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200021, 'ETWAS IST SCHIEFGELAUFEN (state 9)'),
('DE','modal_whoops - message', 200022, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200023, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200031, 'ETWAS IST SCHIEFGELAUFEN (state 21)'),
('DE','modal_whoops - message', 200032, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200033, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200041, 'ETWAS IST SCHIEFGELAUFEN (state 23)'),
('DE','modal_whoops - message', 200042, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200043, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200051, 'ETWAS IST SCHIEFGELAUFEN (state 901)'),
('DE','modal_whoops - message', 200052, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200053, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200061, 'ETWAS IST SCHIEFGELAUFEN (state 904)'),
('DE','modal_whoops - message', 200062, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200063, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200071, 'ETWAS IST SCHIEFGELAUFEN (state 907)'),
('DE','modal_whoops - message', 200072, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200073, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200081, 'ETWAS IST SCHIEFGELAUFEN (state 909)'),
('DE','modal_whoops - message', 200082, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200083, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200091, 'ETWAS IST SCHIEFGELAUFEN (state 911)'),
('DE','modal_whoops - message', 200092, 'gAnswer.MESSAGE van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200093, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200101, 'ETWAS IST SCHIEFGELAUFEN (state 913)'),
('DE','modal_whoops - message', 200102, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200103, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200201, 'ETWAS IST SCHIEFGELAUFEN (state 915)'),
('DE','modal_whoops - message', 200202, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200203, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200301, 'ETWAS IST SCHIEFGELAUFEN (state 1001)'),
('DE','modal_whoops - message', 200302, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200303, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200401, 'ETWAS IST SCHIEFGELAUFEN (state 1003)'),
('DE','modal_whoops - message', 200402, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200403, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200501, 'ETWAS IST SCHIEFGELAUFEN (state 1006)'),
('DE','modal_whoops - message', 200502, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200503, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200601, 'ETWAS IST SCHIEFGELAUFEN (state 2001)'),
('DE','modal_whoops - message', 200602, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200603, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200701, 'ETWAS IST SCHIEFGELAUFEN (state 2003)'),
('DE','modal_whoops - message', 200702, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200703, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200801, 'ETWAS IST SCHIEFGELAUFEN (state 3001)'),
('DE','modal_whoops - message', 200802, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200803, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 200901, 'ETWAS IST SCHIEFGELAUFEN (state 3006)'),
('DE','modal_whoops - message', 200902, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 200903, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 201001, 'ETWAS IST SCHIEFGELAUFEN (state 3011)'),
('DE','modal_whoops - message', 201002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 201003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 202001, 'ETWAS IST SCHIEFGELAUFEN (state 10001)'),
('DE','modal_whoops - message', 202002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 202003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 203001, 'ETWAS IST SCHIEFGELAUFEN (state 10003)'),
('DE','modal_whoops - message', 203002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 203003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 204001, 'ETWAS IST SCHIEFGELAUFEN (state 10011)'),
('DE','modal_whoops - message', 204002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 204003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 205001, 'ETWAS IST SCHIEFGELAUFEN (state 10018)'),
('DE','modal_whoops - message', 205002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 205003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 206001, 'ETWAS IST SCHIEFGELAUFEN (state 10024)'),
('DE','modal_whoops - message', 206002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 206003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 207001, 'ETWAS IST SCHIEFGELAUFEN (state 10026)'),
('DE','modal_whoops - message', 207002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 207003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_whoops - header', 208001, 'ETWAS IST SCHIEFGELAUFEN (state 10027)'),
('DE','modal_whoops - message', 208002, 'gAnswer.msg van backend wordt gebruikt'),
('DE','modal_whoops - footer', 208003, 'Bitte erstellen Sie einen Screenshot von diesem Fehler und senden Sie ihn uns, damit wir untersuchen können, was schief gelaufen ist.'),
('DE','modal_ask - header', 300001, 'VERDÄCHTIGE ABWEICHUNG FESTGESTELLT'),
('DE','modal_ask - message', 300002, 'Haben Sie tatsächlich die MEISTEN (bis zu 10) Punkte demjenigen gegeben, was Ihnen am WENIGSTEN entspricht, in der letzten Liste?
Dies unterscheidet sich von der ersten Liste!
Wenn Sie NEIN wählen, können Sie Ihre Antworten ändern.
Wenn Sie JA wählen, werden die Ergebnisse gespeichert und Sie werden die Ergebnisse sehen.'),
('DE','modal_ask - false button', 300004, 'NEIN'),
('DE','modal_ask - true button', 300003, 'JA'),
('DE','email pdf - subject', 400001, 'LEARNGAMES - Resultate von deinem Softskills Test'),
('DE','email pdf - body', 400002, "LEARNGAMES RESULTATE
Geachte |||NAME|||,
Hier sind die Resultate von deinem Softskills Test den du am |||DATE||| getan hast.
Mit freundlichem Gruß,
LEARNGAMES von LE-Network
"),
('DE','login_screen', 1000, 'SPIELLEITER'),
('DE','login_screen', 1001, 'Softskills tests'),
('DE','login_screen', 1002, 'E-MAIL-ADRESSE'),
('DE','login_screen', 1003, 'PASSWORT'),
('DE','login_screen', 1004, 'KEINE BERECHTIGUNG FÜR SPIELLEITER'),
('DE','not_authorised_screen', 1100, 'STANDARDNUTZER'),
('DE','not_authorised_screen', 1101, 'NICHT BERECHTIGT FÜR DIE ROLLE DES SPIELLEITERS'),
('DE','not_authorised_screen', 1102, 'BITTE SETZEN SIE SICH MIT LE-NETWORK IN VERBINDUNG, UM BERECHTIGUNG ZU ERHALTEN'),
('DE','control_screen_system_owner', 1200, 'SYSTEMEIGENTÜMER'),
('DE','control_screen_system_owner', 1201, 'Funktionen zur Systemwartung'),
('DE','START synchronisation block', 1202, 'SYNCHRONISIERUNG MIT GOOGLE-QUELLE'),
('DE','START synchronisation block', 1203, 'SERVER'),
('DE','START synchronisation block', 1204, 'BRUNNEN'),
('DE','START synchronisation block', 1205, 'SYNCHRONISATION IST ERFORDERLICH'),
('DE','START synchronisation block', 1206, 'JETZT SYNCHRONISIEREN'),
('DE','START synchronisation block', 1207, 'SYNCHRONISATION IST NICHT ERFORDERLICH'),
('DE','START SYNCHRONISING BLOCK', 1210, 'SYNCHRONISATIONSPROZESS'),
('DE','START SYNCHRONISING BLOCK', 1211, 'START'),
('DE','START SYNCHRONISING BLOCK', 1212, 'DAUER'),
('DE','validation_buttons_quadrants_words', 1220, 'DYNAMISCHE VALIDIERUNG VON QUADRANTEN UND WÖRTERN'),
('DE','validation_buttons_quadrants_words', 1221, 'Diese Grafiken zeigen pro Quadranten die Häufigkeiten der Werte und pro Wort die Häufigkeiten der Werte.'),
('DE','validation_quadrants_block', 1230, 'DYNAMISCHE VALIDIERUNG VON QUADRANTEN'),
('DE','validation_quadrants_block', 1231, 'BASISSTIL: Diese Grafiken zeigen die Anzahl der Male (Y-Achse), wie oft ein Wert (X-Achse) pro Quadranten (Q1 Q2 Q3 Q4) auftritt.'),
('DE','validation_quadrants_block', 1232, 'Basis Q1'),
('DE','validation_quadrants_block', 1233, 'Basis Q2'),
('DE','validation_quadrants_block', 1234, 'Basis Q3'),
('DE','validation_quadrants_block', 1235, 'Basis Q4'),
('DE','validation_quadrants_block', 1236, 'RESPONSTIL: Diese Grafiken zeigen die Anzahl der Male (Y-Achse), wie oft ein Wert (X-Achse) pro Quadranten (Q1 Q2 Q3 Q4) auftritt.'),
('DE','validation_quadrants_block', 1237, 'Respons Q1'),
('DE','validation_quadrants_block', 1238, 'Respons Q2'),
('DE','validation_quadrants_block', 1239, 'Respons Q3'),
('DE','validation_quadrants_block', 1240, 'Respons Q4'),
('DE','validation_quadrants_words_block', 1250, 'DYNAMISCHE VALIDIERUNG VON QUADRANTEN - WÖRTER'),
('DE','validation_quadrants_words_block', 1251, 'BASISSTIL: Diese Grafiken zeigen die Anzahl der Male (Y-Achse), wie oft ein Wert (X-Achse) pro Quadranten (Q1 Q2 Q3 Q4) und pro Wort (1..10) auftritt.'),
('DE','validation_quadrants_words_block', 1252, 'ANTWORTSTIL: Diese Grafiken zeigen die Anzahl der Male (Y-Achse), wie oft ein Wert (X-Achse) pro Quadranten (Q1 Q2 Q3 Q4) und pro Wort (1..10) auftritt.'),
('DE','validation_quadrants_averages_block', 1260, 'DYNAMISCHE VALIDIERUNG VON QUADRANTEN - DURCHSCHNITTE GEWÄHLTE ANZAHL VON KLASSEN'),
('DE','validation_quadrants_averages_block', 1261, 'Diese Grafiken zeigen die Häufigkeiten der Quadrantdurchschnittswerte pro Quadranten an. Es gibt insgesamt [0..100] mögliche Durchschnittswerte.
Die Anzahl der Klassen kann einen Wert zwischen [5..25] haben.
Es gibt 101 mögliche Durchschnittswerte. Da 101 eine Primzahl ist und die Durchschnittswerte ganzzahlig sind, ist garantiert, dass die Klassen nicht überlappen.'),
('DE','setClassCount()', 1262, 'KLASSENBREITE'),
('DE','validation_quadrants_averages_block_results', 1270, 'Basis Q1'),
('DE','validation_quadrants_averages_block_results', 1271, 'Basis Q2'),
('DE','validation_quadrants_averages_block_results', 1272, 'Basis Q3'),
('DE','validation_quadrants_averages_block_results', 1273, 'Basis Q4'),
('DE','validation_quadrants_averages_block_results', 1274, 'Respons Q1'),
('DE','validation_quadrants_averages_block_results', 1275, 'Respons Q2'),
('DE','validation_quadrants_averages_block_results', 1276, 'Respons Q3'),
('DE','validation_quadrants_averages_block_results', 1277, 'Respons Q4'),
('DE','gamehost_screen', 1300, 'SPIELLEITER'),
('DE','gamehost_screen', 1301, 'SPIELLEITER-FUNKTIONEN'),
('DE','gamehost_screen', 1310, 'ZUGRIFFSCODE FÜR SOFTSKILLSTEST'),
('DE','gamehost_screen', 1311, 'Um einen Soft Skills Test abzuschließen, muss der Teilnehmer über ein LEARNGAMES-Konto (E-Mail) verfügen und einen vom Spielleiter generierten Code haben.
Der vom Spielleiter generierte Code bleibt gültig, bis der Spielleiter ihn deaktiviert.'),
('DE','gamehost_screen', 1312, 'Einen Code generieren'),
('DE','gamehost_screen', 1313, 'Einen Code aktivieren/deaktivieren'),
('DE','gamehost_screen', 1314, 'Tests anzeigen'),
('DE','gamehost_codes_block', 1320, 'DEINE CODES'),
('DE','gamehost_codes_block', 1321, 'Codes, die mit einem grünen Kreis markiert sind, sind aktiv und können verwendet werden, um einen Test abzuschließen.
Klicken Sie auf einen Code, um ihn zu aktivieren oder zu deaktivieren.'),
('DE','tests_screen', 1400, 'WÄHLEN SIE DEN TEST AUS, DEN SIE AUSFÜLLEN MÖCHTEN'),
('DE','tests_screen', 1401, 'Unten sehen Sie die Tests, aus denen Sie wählen können.
Nachdem Sie einen Test ausgewählt haben, wird eine Liste der Sprachen angezeigt, in denen dieser Test verfügbar ist.
Wir empfehlen, den Test in Ihrer Muttersprache abzulegen, wenn dies möglich ist.
Kommen Sie bald wieder, es werden in Zukunft mehr Tests hinzugefügt.'),
('DE','tests_screen', 1402, 'WÄHLEN SIE IHRE SPRACHE (DE) ↓'),
('DE','tests_screen', 1403, 'ZURÜCK'),
('DE','tests_screen', 1404, 'TEST BEGINNEN'),
('DE','softskills_entry', 1410, 'SOFTSKILLSTEST'),
('DE','softskills_entry', 1411, 'Unten sehen Sie den Eingabebildschirm für den Test; der Test wird unter Ihrer E-Mail-Adresse mit dem Code TEST gespeichert.'),
('DE','softskills_entry', 1412, 'Speichern');
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// iso_languages -- ISO TALEN TABEL VULLEN ISO639-1 -- Uitzondering is NL2 voor extra synoniemen
// ------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO iso_languages VALUES
('aa', 'Afar', 'Afaraf'),
('ab', 'Abkhazian', 'аҧсуа бызшәа, аҧсшәа'),
('ae', 'Avestan', 'avesta'),
('af', 'Afrikaans', 'Afrikaans'),
('ak', 'Akan', 'Akan'),
('am', 'Amharic', 'አማርኛ'),
('an', 'Aragonese', 'aragonés'),
('ar', 'Arabic', 'العربية'),
('as', 'Assamese', 'অসমীয়া'),
('av', 'Avaric', 'авар мацӀ, магӀарул мацӀ'),
('ay', 'Aymara', 'aymar aru'),
('az', 'Azerbaijani', 'azərbaycan dili'),
('ba', 'Bashkir', 'башҡорт теле'),
('be', 'Belarusian', 'беларуская мова'),
('bg', 'Bulgarian', 'български език'),
('bh', 'Bihari languages', 'भोजपुरी'),
('bi', 'Bislama', 'Bislama'),
('bm', 'Bambara', 'bamanankan'),
('bn', 'Bengali, Bangla', 'বাংলা'),
('bo', 'Tibetan', 'བོད་ཡིག'),
('br', 'Breton', 'brezhoneg'),
('bs', 'Bosnian', 'bosanski jezik'),
('ca', 'Catalan, Valencian', 'català, valencià'),
('ce', 'Chechen', 'нохчийн мотт'),
('ch', 'Chamorro', 'Chamoru'),
('co', 'Corsican', 'corsu, lingua corsa'),
('cr', 'Cree', 'ᓀᐦᐃᔭᐍᐏᐣ'),
('cs', 'Czech', 'čeština, český jazyk'),
('cu', 'Church Slavic, Old Slavonic, Church Slavonic, Old Bulgarian, Old Church Slavonic', 'ѩзыкъ словѣньскъ'),
('cv', 'Chuvash', 'чӑваш чӗлхи'),
('cy', 'Welsh', 'Cymraeg'),
('da', 'Danish', 'dansk'),
('de', 'German', 'Deutsch'),
('dv', 'Divehi, Dhivehi, Maldivian', 'ދިވެހި'),
('dz', 'Dzongkha', 'རྫོང་ཁ'),
('ee', 'Ewe', 'Eʋegbe'),
('el', 'Greek, Modern (1453-)', 'ελληνικά'),
('en', 'English', 'English'),
('eo', 'Esperanto', 'Esperanto'),
('es', 'Spanish, Castilian', 'español, castellano'),
('et', 'Estonian', 'eesti, eesti keel'),
('eu', 'Basque', 'euskara, euskera'),
('fa', 'Persian', 'فارسی'),
('ff', 'Fulah', 'Fulfulde, Pulaar, Pular'),
('fi', 'Finnish', 'suomi, suomen kieli'),
('fj', 'Fijian', 'vosa Vakaviti'),
('fo', 'Faroese', 'føroyskt'),
('fr', 'French', 'français, langue française'),
('fy', 'Western Frisian', 'Frysk'),
('ga', 'Irish', 'Gaeilge'),
('gd', 'Gaelic, Scottish Gaelic', 'Gàidhlig'),
('gl', 'Galician', 'Galego'),
('gn', 'Guarani', "Avañe'ẽ"),
('gu', 'Gujarati', 'ગુજરાતી'),
('gv', 'Manx', 'Gaelg, Gailck'),
('ha', 'Hausa', 'هَوُسَ'),
('he', 'Hebrew', 'עִבְרִית'),
('hi', 'Hindi', 'हिन्दी, हिंदी'),
('ho', 'Hiri Motu', 'Hiri Motu'),
('hr', 'Croatian', 'hrvatski jezik'),
('ht', 'Haitian, Haitian Creole', 'Kreyòl ayisyen'),
('hu', 'Hungarian', 'magyar'),
('hy', 'Armenian', 'Հայերեն'),
('hz', 'Herero', 'Otjiherero'),
('ia', 'Interlingua (International Auxiliary Language Association)', 'Interlingua'),
('id', 'Indonesian', 'Bahasa Indonesia'),
('ie', 'Interlingue, Occidental', 'Interlingue'),
('ig', 'Igbo', 'Asụsụ Igbo'),
('ii', 'Sichuan Yi, Nuosu', 'ꆇꉙ'),
('ik', 'Inupiaq', 'Iñupiaq, Iñupiatun'),
('io', 'Ido', 'Ido'),
('is', 'Icelandic', 'Íslenska'),
('it', 'Italian', 'Italiano'),
('iu', 'Inuktitut', 'ᐃᓄᒃᑎᑐᑦ'),
('ja', 'Japanese', '日本語 (にほんご)'),
('jv', 'Javanese', 'basa Jawa'),
('ka', 'Georgian', 'ქართული'),
('kg', 'Kongo', 'Kikongo'),
('ki', 'Kikuyu, Gikuyu', 'Gĩkũyũ'),
('kj', 'Kuanyama, Kwanyama', 'Kuanyama'),
('kk', 'Kazakh', 'қазақ тілі'),
('kl', 'Kalaallisut, Greenlandic', 'kalaallisut, kalaallit oqaasii'),
('km', 'Central Khmer', 'ខ្មែរ'),
('kn', 'Kannada', 'ಕನ್ನಡ'),
('ko', 'Korean', '한국어'),
('kr', 'Kanuri', 'Kanuri'),
('ks', 'Kashmiri', 'कश्मीरी, كشميري'),
('ku', 'Kurdish', 'Kurdî, كوردی'),
('kv', 'Komi', 'коми кыв'),
('kw', 'Cornish', 'Kernewek'),
('ky', 'Kirghiz, Kyrgyz', 'Кыргызча, Кыргыз тили'),
('la', 'Latin', 'latine, lingua latina'),
('lb', 'Luxembourgish, Letzeburgesch', 'Lëtzebuergesch'),
('lg', 'Ganda', 'Luganda'),
('li', 'Limburgan, Limburger, Limburgish', 'Limburgs'),
('ln', 'Lingala', 'Lingála'),
('lo', 'Lao', 'ພາສາລາວ'),
('lt', 'Lithuanian', 'lietuvių kalba'),
('lu', 'Luba-Katanga', 'Kiluba'),
('lv', 'Latvian', 'latviešu valoda'),
('mg', 'Malagasy', 'fiteny malagasy'),
('mh', 'Marshallese', 'Kajin M̧ajeļ'),
('mi', 'Maori', 'te reo Māori'),
('mk', 'Macedonian', 'македонски јазик'),
('ml', 'Malayalam', 'മലയാളം'),
('mn', 'Mongolian', 'Монгол хэл'),
('mr', 'Marathi', 'मराठी'),
('ms', 'Malay', 'Bahasa Melayu, بهاس ملايو'),
('mt', 'Maltese', 'Malti'),
('my', 'Burmese', 'ဗမာစာ'),
('na', 'Nauru', 'Ekakairũ Naoero'),
('nb', 'Norwegian Bokmål', 'Norsk bokmål'),
('nd', 'North Ndebele', 'isiNdebele'),
('ne', 'Nepali', 'नेपाली'),
('ng', 'Ndonga', 'Owambo'),
('nl', 'Dutch, Flemish', 'Nederlands, Vlaams'),
('n2', 'Dutch, Flemish (simple)', 'Nederlands, Vlaams (eenvoudig)'),
('n3', 'Ducth, Drents', 'Nederland Drents'),
('n4', 'Dutch, Twents', 'Nederland Twents')
('nn', 'Norwegian Nynorsk', 'Norsk nynorsk'),
('no', 'Norwegian', 'Norsk'),
('nr', 'South Ndebele', 'isiNdebele'),
('nv', 'Navajo, Navaho', 'Diné bizaad'),
('ny', 'Chichewa, Chewa, Nyanja', 'chiCheŵa, chinyanja'),
('oc', 'Occitan', "occitan, lenga d'òc"),
('oj', 'Ojibwe', 'ᐊᓂᔑᓈᐯᒧᐎᓐ'),
('om', 'Oromo', 'Afaan Oromoo'),
('or', 'Oriya', 'ଓଡ଼ିଆ'),
('os', 'Ossetian, Ossetic', 'ирон æвзаг'),
('pa', 'Panjabi, Punjabi', 'ਪੰਜਾਬੀ, پنجابی'),
('pi', 'Pali', 'पालि, पाळि'),
('pl', 'Polish', 'polski'),
('ps', 'Pashto, Pushto', 'پښتو'),
('pt', 'Portuguese', 'português'),
('qu', 'Quechua', 'Runa Simi, Kichwa'),
('rm', 'Romansh', 'rumantsch grischun'),
('rn', 'Rundi', 'Ikirundi'),
('ro', 'Romanian, Moldavian', 'română'),
('ru', 'Russian', 'русский язык'),
('rw', 'Kinyarwanda', 'Ikinyarwanda'),
('sa', 'Sanskrit', 'संस्कृतम्'),
('sc', 'Sardinian', 'sardu'),
('sd', 'Sindhi', 'सिन्धी, سنڌي، سندھی'),
('se', 'Northern Sami', 'Davvisámegiella'),
('sg', 'Sango', 'yângâ tî sängö'),
('si', 'Sinhala, Sinhalese', 'සිංහල'),
('sk', 'Slovak', 'slovenčina'),
('sl', 'Slovenian', 'slovenščina'),
('sm', 'Samoan', "gagana fa'a Samoa"),
('sn', 'Shona', 'chiShona'),
('so', 'Somali', 'Soomaaliga, af Soomaali'),
('sq', 'Albanian', 'Shqip'),
('sr', 'Serbian', 'српски језик'),
('ss', 'Swati', 'SiSwati'),
('st', 'Southern Sotho', 'Sesotho'),
('su', 'Sundanese', 'Basa Sunda'),
('sv', 'Swedish', 'svenska'),
('sw', 'Swahili', 'Kiswahili'),
('ta', 'Tamil', 'தமிழ்'),
('te', 'Telugu', 'తెలుగు'),
('tg', 'Tajik', 'тоҷикӣ, toğikī, تاجیکی'),
('th', 'Thai', 'ไทย'),
('ti', 'Tigrinya', 'ትግርኛ'),
('tk', 'Turkmen', 'Türkmen, Түркмен'),
('tl', 'Tagalog', 'Wikang Tagalog'),
('tn', 'Tswana', 'Setswana'),
('to', 'Tonga (Tonga Islands)', 'faka Tonga'),
('tr', 'Turkish', 'Türkçe'),
('ts', 'Tsonga', 'Xitsonga'),
('tt', 'Tatar', 'татарча, tatarça, تاتارچا'),
('tw', 'Twi', 'Twi'),
('ty', 'Tahitian', 'Reo Tahiti'),
('ug', 'Uighur, Uyghur', 'Uyƣurqə, ئۇيغۇرچە'),
('uk', 'Ukrainian', 'українська'),
('ur', 'Urdu', 'اردو'),
('uz', 'Uzbek', 'zbek, Ўзбек, أۇزبېك'),
('ve', 'Venda', 'Tshivenḓa'),
('vi', 'Vietnamese', 'Tiếng Việt'),
('vo', 'Volapük', 'Volapük'),
('wa', 'Walloon', 'Walon'),
('wo', 'Wolof', 'Wollof'),
('xh', 'Xhosa', 'isiXhosa'),
('yi', 'Yiddish', 'ייִדיש'),
('yo', 'Yoruba', 'Yorùbá'),
('za', 'Zhuang, Chuang', 'Saɯ cueŋƅ, Saw cuengh'),
('zh', 'Chinese', '中国語'),
('zu', 'Zulu', 'isiZulu');
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// iso_countries -- ISO LANDEN TABEL VULLEN
// ------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO iso_countries (isc_iso3166_1, isc_name_gb, isc_name_native)
VALUES
('AD', 'Andorra', 'Andorra'),
('AE', 'United Arab Emirates', 'الإمارات العربية المتحدة'),
('AF', 'Afghanistan', 'افغانستان'),
('AG', 'Antigua and Barbuda', 'Antigua and Barbuda'),
('AI', 'Anguilla', 'Anguilla'),
('AL', 'Albania', 'Shqipëria'),
('AM', 'Armenia', 'Հայաստան'),
('AO', 'Angola', 'Angola'),
('AQ', 'Antarctica', 'Antarctica'),
('AR', 'Argentina', 'Argentina'),
('AS', 'American Samoa', 'American Samoa'),
('AT', 'Austria', 'Österreich'),
('AU', 'Australia', 'Australia'),
('AW', 'Aruba', 'Aruba'),
('AX', 'Åland Islands', 'Åland'),
('AZ', 'Azerbaijan', 'Azərbaycan'),
('BA', 'Bosnia and Herzegovina', 'Bosna i Hercegovina'),
('BB', 'Barbados', 'Barbados'),
('BD', 'Bangladesh', 'Bangladesh'),
('BE', 'Belgium', 'België/Belgique/Belgien'),
('BF', 'Burkina Faso', 'Burkina Faso'),
('BG', 'Bulgaria', 'България'),
('BH', 'Bahrain', 'البحرين'),
('BI', 'Burundi', 'Burundi'),
('BJ', 'Benin', 'Bénin'),
('BL', 'Saint Barthélemy', 'Saint-Barthélemy'),
('BM', 'Bermuda', 'Bermuda'),
('BN', 'Brunei Darussalam', 'Negara Brunei Darussalam'),
('BO', 'Bolivia', 'Bolivia'),
('BQ', 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius en Saba'),
('BR', 'Brazil', 'Brasil'),
('BS', 'Bahamas', 'Bahamas'),
('BT', 'Bhutan', 'འབྲུག་ཡུལ།'),
('BV', 'Bouvet Island', 'Bouvetøya'),
('BW', 'Botswana', 'Botswana'),
('BY', 'Belarus', 'Беларусь'),
('BZ', 'Belize', 'Belize'),
('CA', 'Canada', 'Canada'),
('CC', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands'),
('CD', 'Democratic Republic of the Congo', 'République démocratique du Congo'),
('CF', 'Central African Republic', 'République centrafricaine'),
('CG', 'Congo', 'Congo'),
('CH', 'Switzerland', 'Schweiz/Suisse/Svizzera/Svizra'),
('CI', 'Côte d\'Ivoire', 'Côte d\'Ivoire'),
('CK', 'Cook Islands', 'Cook Islands'),
('CL', 'Chile', 'Chile'),
('CM', 'Cameroon', 'Cameroun'),
('CN', 'China', '中国'),
('CO', 'Colombia', 'Colombia'),
('CR', 'Costa Rica', 'Costa Rica'),
('CU', 'Cuba', 'Cuba'),
('CV', 'Cabo Verde', 'Cabo Verde'),
('CW', 'Curaçao', 'Curaçao'),
('CX', 'Christmas Island', 'Christmas Island'),
('CY', 'Cyprus', 'Κύπρος/Kıbrıs'),
('CZ', 'Czech Republic', 'Česká republika'),
('DE', 'Germany', 'Deutschland'),
('DJ', 'Djibouti', 'Djibouti'),
('DK', 'Denmark', 'Danmark'),
('DM', 'Dominica', 'Dominica'),
('DO', 'Dominican Republic', 'República Dominicana'),
('DZ', 'Algeria', 'الجزائر'),
('EC', 'Ecuador', 'Ecuador'),
('EE', 'Estonia', 'Eesti'),
('EG', 'Egypt', 'مصر'),
('EH', 'Western Sahara', 'الصحراء الغربية'),
('ER', 'Eritrea', 'ኤርትራ'),
('ES', 'Spain', 'España'),
('ET', 'Ethiopia', 'ኢትዮጵያ'),
('FI', 'Finland', 'Suomi'),
('FJ', 'Fiji', 'Fiji'),
('FK', 'Falkland Islands (Malvinas)', 'Falkland Islands (Malvinas)'),
('FM', 'Micronesia (Federated States of)', 'Micronesia (Federated States of)'),
('FO', 'Faroe Islands', 'Føroyar'),
('FR', 'France', 'France'),
('GA', 'Gabon', 'Gabon'),
('GB', 'United Kingdom of Great Britain and Northern Ireland', 'United Kingdom of Great Britain and Northern Ireland'),
('GD', 'Grenada', 'Grenada'),
('GE', 'Georgia', 'საქართველო'),
('GF', 'French Guiana', 'Guyane française'),
('GG', 'Guernsey', 'Guernsey'),
('GH', 'Ghana', 'Ghana'),
('GI', 'Gibraltar', 'Gibraltar'),
('GL', 'Greenland', 'Kalaallit Nunaat'),
('GM', 'Gambia', 'Gambia'),
('GN', 'Guinea', 'Guinée'),
('GP', 'Guadeloupe', 'Guadeloupe'),
('GQ', 'Equatorial Guinea', 'Guinea Ecuatorial'),
('GR', 'Greece', 'Ελλάδα'),
('GS', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands'),
('GT', 'Guatemala', 'Guatemala'),
('GU', 'Guam', 'Guam'),
('GW', 'Guinea-Bissau', 'Guiné-Bissau'),
('GY', 'Guyana', 'Guyana'),
('HK', 'Hong Kong', '香港'),
('HM', 'Heard Island and McDonald Islands', 'Heard Island and McDonald Islands'),
('HN', 'Honduras', 'Honduras'),
('HR', 'Croatia', 'Hrvatska'),
('HT', 'Haiti', 'Haïti'),
('HU', 'Hungary', 'Magyarország'),
('ID', 'Indonesia', 'Indonesia'),
('IE', 'Ireland', 'Ireland'),
('IL', 'Israel', 'יִשְׂרָאֵל'),
('IM', 'Isle of Man', 'Isle of Man'),
('IN', 'India', 'भारत'),
('IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory'),
('IQ', 'Iraq', 'العراق'),
('IR', 'Iran (Islamic Republic of)', 'ایران'),
('IS', 'Iceland', 'Ísland'),
('IT', 'Italy', 'Italia'),
('JE', 'Jersey', 'Jersey'),
('JM', 'Jamaica', 'Jamaica'),
('JO', 'Jordan', 'الأردن'),
('JP', 'Japan', '日本'),
('KE', 'Kenya', 'Kenya'),
('KG', 'Kyrgyzstan', 'Кыргызстан'),
('KH', 'Cambodia', 'កម្ពុជា'),
('KI', 'Kiribati', 'Kiribati'),
('KM', 'Comoros', 'Comores'),
('KN', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis'),
('KP', 'Korea (Democratic People\'s Republic of)', '북한'),
('KR', 'Korea, Republic of', '대한민국'),
('KW', 'Kuwait', 'الكويت'),
('KY', 'Cayman Islands', 'Cayman Islands'),
('KZ', 'Kazakhstan', 'Қазақстан'),
('LA', 'Lao People\'s Democratic Republic', 'ສປປລາວ'),
('LB', 'Lebanon', 'لبنان'),
('LC', 'Saint Lucia', 'Saint Lucia'),
('LI', 'Liechtenstein', 'Liechtenstein'),
('LK', 'Sri Lanka', 'ශ්රී ලංකාව'),
('LR', 'Liberia', 'Liberia'),
('LS', 'Lesotho', 'Lesotho'),
('LT', 'Lithuania', 'Lietuva'),
('LU', 'Luxembourg', 'Luxembourg'),
('LV', 'Latvia', 'Latvija'),
('LY', 'Libya', 'ليبيا'),
('MA', 'Morocco', 'المغرب'),
('MC', 'Monaco', 'Monaco'),
('MD', 'Moldova, Republic of', 'Republica Moldova'),
('ME', 'Montenegro', 'Crna Gora'),
('MF', 'Saint Martin (French part)', 'Saint-Martin (partie française)'),
('MG', 'Madagascar', 'Madagasikara'),
('MH', 'Marshall Islands', 'Marshall Islands'),
('MK', 'North Macedonia', 'Северна Македонија'),
('ML', 'Mali', 'Mali'),
('MM', 'Myanmar', 'မြန်မာ'),
('MN', 'Mongolia', 'Монгол улс'),
('MO', 'Macao', '澳門'),
('MP', 'Northern Mariana Islands', 'Northern Mariana Islands'),
('MQ', 'Martinique', 'Martinique'),
('MR', 'Mauritania', 'موريتانيا'),
('MS', 'Montserrat', 'Montserrat'),
('MT', 'Malta', 'Malta'),
('MU', 'Mauritius', 'Mauritius'),
('MV', 'Maldives', 'ދިވެހިރާއްޖެ'),
('MW', 'Malawi', 'Malawi'),
('MX', 'Mexico', 'México'),
('MY', 'Malaysia', 'Malaysia'),
('MZ', 'Mozambique', 'Moçambique'),
('NA', 'Namibia', 'Namibia'),
('NC', 'New Caledonia', 'Nouvelle-Calédonie'),
('NE', 'Niger', 'Niger'),
('NF', 'Norfolk Island', 'Norfolk Island'),
('NG', 'Nigeria', 'Nigeria'),
('NI', 'Nicaragua', 'Nicaragua'),
('NL', 'Netherlands', 'Nederland'),
('NO', 'Norway', 'Norge'),
('NP', 'Nepal', 'नेपाल'),
('NR', 'Nauru', 'Nauru'),
('NU', 'Niue', 'Niue'),
('NZ', 'New Zealand', 'New Zealand'),
('OM', 'Oman', 'عُمان'),
('PA', 'Panama', 'Panamá'),
('PE', 'Peru', 'Perú'),
('PF', 'French Polynesia', 'Polynésie française'),
('PG', 'Papua New Guinea', 'Papua Niugini'),
('PH', 'Philippines', 'Pilipinas'),
('PK', 'Pakistan', 'پاکستان'),
('PL', 'Poland', 'Polska'),
('PM', 'Saint Pierre and Miquelon', 'Saint-Pierre-et-Miquelon'),
('PN', 'Pitcairn', 'Pitcairn Islands'),
('PR', 'Puerto Rico', 'Puerto Rico'),
('PS', 'Palestine, State of', 'فلسطين'),
('PT', 'Portugal', 'Portugal'),
('PW', 'Palau', 'Palau'),
('PY', 'Paraguay', 'Paraguay'),
('QA', 'Qatar', 'قطر'),
('RE', 'Réunion', 'La Réunion'),
('RO', 'Romania', 'România'),
('RS', 'Serbia', 'Србија'),
('RU', 'Russian Federation', 'Россия'),
('RW', 'Rwanda', 'Rwanda'),
('SA', 'Saudi Arabia', 'المملكة العربية السعودية'),
('SB', 'Solomon Islands', 'Solomon Islands'),
('SC', 'Seychelles', 'Seychelles'),
('SD', 'Sudan', 'السودان'),
('SE', 'Sweden', 'Sverige'),
('SG', 'Singapore', 'Singapore'),
('SH', 'Saint Helena, Ascension and Tristan da Cunha', 'Saint Helena, Ascension and Tristan da Cunha'),
('SI', 'Slovenia', 'Slovenija'),
('SJ', 'Svalbard and Jan Mayen', 'Svalbard og Jan Mayen'),
('SK', 'Slovakia', 'Slovensko'),
('SL', 'Sierra Leone', 'Sierra Leone'),
('SM', 'San Marino', 'San Marino'),
('SN', 'Senegal', 'Sénégal'),
('SO', 'Somalia', 'Soomaaliya'),
('SR', 'Suriname', 'Suriname'),
('SS', 'South Sudan', 'South Sudan'),
('ST', 'Sao Tome and Principe', 'São Tomé e Príncipe'),
('SV', 'El Salvador', 'El Salvador'),
('SX', 'Sint Maarten (Dutch part)', 'Sint Maarten'),
('SY', 'Syrian Arab Republic', 'سوريا'),
('SZ', 'Eswatini', 'Eswatini'),
('TC', 'Turks and Caicos Islands', 'Turks and Caicos Islands'),
('TD', 'Chad', 'Tchad'),
('TF', 'French Southern Territories', 'Terres australes françaises'),
('TG', 'Togo', 'Togo'),
('TH', 'Thailand', 'ไทย'),
('TJ', 'Tajikistan', 'Тоҷикистон'),
('TK', 'Tokelau', 'Tokelau'),
('TL', 'Timor-Leste', 'Timor-Leste'),
('TM', 'Turkmenistan', 'Türkmenistan'),
('TN', 'Tunisia', 'تونس'),
('TO', 'Tonga', 'Tonga'),
('TR', 'Turkey', 'Türkiye'),
('TT', 'Trinidad and Tobago', 'Trinidad and Tobago'),
('TV', 'Tuvalu', 'Tuvalu'),
('TW', 'Taiwan, Province of China', '臺灣'),
('TZ', 'Tanzania, United Republic of', 'Tanzania'),
('UA', 'Ukraine', 'Україна'),
('UG', 'Uganda', 'Uganda'),
('UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands'),
('US', 'United States of America', 'United States of America'),
('UY', 'Uruguay', 'Uruguay'),
('UZ', 'Uzbekistan', 'O‘zbekiston'),
('VA', 'Holy See', 'Città del Vaticano'),
('VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines'),
('VE', 'Venezuela (Bolivarian Republic of)', 'Venezuela'),
('VG', 'Virgin Islands (British)', 'British Virgin Islands'),
('VI', 'Virgin Islands (U.S.)', 'United States Virgin Islands'),
('VN', 'Viet Nam', 'Việt Nam'),
('VU', 'Vanuatu', 'Vanuatu'),
('WF', 'Wallis and Futuna', 'Wallis et Futuna'),
('WS', 'Samoa', 'Samoa'),
('YE', 'Yemen', 'اليمن'),
('YT', 'Mayotte', 'Mayotte'),
('ZA', 'South-Africa', 'South-Africa'),
('ZM', 'Zambia', 'Zambia'),
('ZW', 'Zimbabwe', 'Zimbabwe');
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// countries_languages -- ISO TALEN PER LAND
// ------------------------------------------------------------------------------------------------------------------------------------------------------
INSERT INTO countries_languages VALUES
('AD', '["ca"]'),
('AE', '["ar"]'),
('AF', '["ps","uz","tk","fa"]'),
('AG', '["en"]'),
('AI', '["en"]'),
('AL', '["sq"]'),
('AM', '["hy"]'),
('AO', '["pt"]'),
('AQ', '[]'),
('AR', '["es"]'),
('AS', '["en","sm"]'),
('AT', '["de"]'),
('AU', '["en"]'),
('AW', '["nl","pap"]'),
('AX', '["sv","fi"]'),
('AZ', '["az"]'),
('BA', '["bs","hr","sr"]'),
('BB', '["en"]'),
('BD', '["bn"]'),
('BE', '["nl","fr","de"]'),
('BF', '["fr","mos"]'),
('BG', '["bg"]'),
('BH', '["ar"]'),
('BI', '["rn","fr"]'),
('BJ', '["fr"]'),
('BL', '["fr"]'),
('BM', '["en"]'),
('BN', '["ms"]'),
('BO', '["es","qu","ay"]'),
('BQ', '["nl","en"]'),
('BR', '["pt"]'),
('BS', '["en"]'),
('BT', '["dz"]'),
('BV', '[]'),
('BW', '["en","tn"]'),
('BY', '["be","ru"]'),
('BZ', '["en","es"]'),
('CA', '["en","fr"]'),
('CC', '["ms","en"]'),
('CD', '["fr","ln","kg","sw","lu"]'),
('CF', '["fr","sg"]'),
('CG', '["fr","kg","ln"]'),
('CH', '["de","fr","it","rm"]'),
('CI', '["fr"]'),
('CK', '["en","mi"]'),
('CL', '["es"]'),
('CM', '["en","fr"]'),
('CN', '["zh"]'),
('CO', '["es"]'),
('CR', '["es"]'),
('CU', '["es"]'),
('CV', '["pt"]'),
('CW', '["nl","pa","en"]'),
('CX', '["en"]'),
('CY', '["el","tr"]'),
('CZ', '["cs"]'),
('DE', '["de"]'),
('DJ', '["fr","ar","so"]'),
('DK', '["da"]'),
('DM', '["en"]'),
('DO', '["es"]'),
('DZ', '["ar","fr"]'),
('EC', '["es"]'),
('EE', '["et"]'),
('EG', '["ar"]'),
('EH', '["ar"]'),
('ER', '["aa","ti","kun","ar"]'),
('ES', '["es","ca","gl","eu"]'),
('ET', '["am","om","ti"]'),
('FI', '["fi","sv"]'),
('FJ', '["en","fj","hi","ur"]'),
('FK', '["en"]'),
('FM', '["en"]'),
('FO', '["fo","da"]'),
('FR', '["fr"]'),
('GA', '["fr"]'),
('GB', '["en"]'),
('GD', '["en"]'),
('GE', '["ka"]'),
('GF', '["fr"]'),
('GG', '["en","fr"]'),
('GH', '["ak","ee","en"]'),
('GI', '["en"]'),
('GL', '["kl","da"]'),
('GM', '["en"]'),
('GN', '["fr"]'),
('GP', '["fr"]'),
('GQ', '["es","fr","pt"]'),
('GR', '["el"]'),
('GS', '["en"]'),
('GT', '["es"]'),
('GU', '["en"]'),
('GW', '["pt"]'),
('GY', '["en"]'),
('HK', '["zh","en"]'),
('HM', '["en"]'),
('HN', '["es"]'),
('HR', '["hr"]'),
('HT', '["fr","ht"]'),
('HU', '["hu"]'),
('ID', '["id"]'),
('IE', '["en","ga"]'),
('IL', '["he","ar"]'),
('IM', '["en","gv"]'),
('IN', '["hi","en"]'),
('IO', '["en"]'),
('IQ', '["ar","ku"]'),
('IR', '["fa"]'),
('IS', '["is"]'),
('IT', '["it"]'),
('JE', '["en","fr"]'),
('JM', '["en"]'),
('JO', '["ar"]'),
('JP', '["ja"]'),
('KE', '["en","sw"]'),
('KG', '["ky","ru"]'),
('KH', '["km"]'),
('KI', '["en","gil"]'),
('KM', '["ar","fr"]'),
('KN', '["en"]'),
('KP', '["ko"]'),
('KR', '["ko"]'),
('KW', '["ar"]'),
('KY', '["en"]'),
('KZ', '["kk","ru"]'),
('LA', '["lo"]'),
('LB', '["ar"]'),
('LC', '["en"]'),
('LI', '["de"]'),
('LK', '["si","ta"]'),
('LR', '["en"]'),
('LS', '["en","st"]'),
('LT', '["lt"]'),
('LU', '["lb","fr","de"]'),
('LV', '["lv"]'),
('LY', '["ar"]'),
('MA', '["ar"]'),
('MC', '["fr"]'),
('MD', '["ro"]'),
('ME', '["srp","bsc"]'),
('MF', '["fra"]'),
('MG', '["mlg","fra"]'),
('MH', '["mah","en"]'),
('MK', '["mkd"]'),
('ML', '["fra","bam"]'),
('MM', '["mya"]'),
('MN', '["mon"]'),
('MO', '["zho","por"]'),
('MP', '["cha","eng"]'),
('MQ', '["fra"]'),
('MR', '["mey","fra"]'),
('MS', '["eng"]'),
('MT', '["mlt","eng"]'),
('MU', '["mfe","frs","eng"]'),
('MV', '["div"]'),
('MW', '["nya","eng"]'),
('MX', '["spa"]'),
('MY', '["msa","eng"]'),
('MZ', '["por"]'),
('NA', '["eng","afr"]'),
('NC', '["fra"]'),
('NE', '["fra"]'),
('NF', '["eng"]'),
('NG', '["eng"]'),
('NI', '["spa"]'),
('NL', '["nld"]'),
('NO', '["nor"]'),
('NP', '["nep"]'),
('NR', '["nau","eng"]'),
('NU', '["niu","eng"]'),
('NZ', '["eng","mri"]'),
('OM', '["ara"]'),
('PA', '["spa"]'),
('PE', '["spa","aym","que"]'),
('PF', '["fra"]'),
('PG', '["eng","tpi","hoi"]'),
('PH', '["fil","eng"]'),
('PK', '["urd","eng"]'),
('PL', '["pol"]'),
('PM', '["fra"]'),
('PN', '["eng"]'),
('PR', '["spa","eng"]'),
('PS', '["ara"]'),
('PT', '["por"]'),
('PW', '["pau","eng"]'),
('PY', '["spa","grn"]'),
('QA', '["ara"]'),
('RE', '["fra"]'),
('RO', '["ron"]'),
('RS', '["srp"]'),
('RU', '["rus"]'),
('RW', '["kin","eng","fra"]'),
('SA', '["ara"]'),
('SB', '["eng"]'),
('SC', '["crs","eng","fra"]'),
('SD', '["ara","eng"]'),
('SE', '["swe"]'),
('SG', '["zho","tam","msa","eng"]'),
('SH', '["en"]'),
('SI', '["sl"]'),
('SJ', '["nor"]'),
('SK', '["sk"]'),
('SL', '["en"]'),
('SM', '["it"]'),
('SN', '["fr"]'),
('SO', '["so","ar"]'),
('SR', '["nl"]'),
('SS', '["en"]'),
('ST', '["pt"]'),
('SV', '["es"]'),
('SX', '["nl"]'),
('SY', '["ar"]'),
('SZ', '["en","ss"]'),
('TC', '["en"]'),
('TD', '["fr","ar"]'),
('TF', '["fr"]'),
('TG', '["fr"]'),
('TH', '["th"]'),
('TJ', '["tg"]'),
('TK', '["tkl","en"]'),
('TL', '["pt","tet"]'),
('TM', '["tk"]'),
('TN', '["ar"]'),
('TO', '["to","en"]'),
('TR', '["tr"]'),
('TT', '["en"]'),
('TV', '["tvl","en"]'),
('TW', '["zh"]'),
('TZ', '["sw","en"]'),
('UA', '["uk"]'),
('UG', '["en","sw"]'),
('UM', '["en"]'),
('US', '["en","es"]'),
('UY', '["es"]'),
('UZ', '["uz"]'),
('VA', '["la","it"]'),
('VC', '["en"]'),
('VE', '["es"]'),
('VG', '["en"]'),
('VI', '["en"]'),
('VN', '["vi"]'),
('VU', '["bi","en","fr"]'),
('WF', '["fr"]'),
('WS', '["sm","en"]'),
('YE', '["ar"]'),
('YT', '["fr"]'),
('ZA', '["af","en","zu","xh"]'),
('ZM', '["en"]'),
('ZW', '["en","sn"]');
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// MacBook - Bash script om XX.pmg om te zetten naar base64 en tevens een update statement te genereren in sql
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// 1) Haal de namen van alle xx.png bestanden waarbij xx de 2 letter landen code is dat ook in isc_iso3166_1 staat in de tabel
// ls -1 | egrep -e '^[A-Z][A-Z]\.'
//
// 2) We willen UPDATE iso_countries SET isc_flag_png='';
//
// 2.a) Maak de base64 output
// openssl base64 -A -in XX.png -out XX.base64
//
// 2.b) echo "UPDATE iso_countries SET isc_flag_png=\"" >> update.sql
// 2.c) echo XX.base64 >> update.sql
// 2.d) echo "\"" >> update.sql
// N.B.: WEL EVEN bash command interpretor starten voordat ./was wordt uitgevoerd.
# Haal alle bestandsnamen die de iso3166-1 lettercode bevatten .png
bestandsnamen=( $(ls -1 | grep -E '^[A-Z][A-Z]\.png') )
# Per gevonden bestandsnaam voeren we uit
for bestandsnaam in "${bestandsnamen[@]}"
do
# neem de eerste twee letters
tweeletters=${bestandsnaam:0:2}
# converteer het .png bestaqnd naar base64 zonder linefeeds
openssl base64 -A -in ${tweeletters}.png -out ${tweeletters}.base64
echo "${tweeletters}.base64" created
# BUILD sql statement to table_update.sql
echo "UPDATE iso_countries SET isc_flag_png=\"" >> table_update.sql
cat "${tweeletters}.base64" >> table_update.sql
echo "\" WHERE isc_iso3166_1=\""${tweeletters}"\";" >> table_update.sql
echo "${tweeletters} done."
echo -e "\n\n"
done
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// QUERIES FREQUENTIES PER WOORD - BASIS en RESPONSE - VOOR OPGEGEVEN TABNAME
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// Gewenste output:
// 'BQ1..40", VALUE, COUNT
// 'RQ1..40', VALUE, COUNT
"SELECT 'BQ1' AS QX, scs_b_q1 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q1" .
"UNION" .
"SELECT 'BQ2' AS QX, scs_b_q2 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q2" .
"UNION" .
"SELECT 'BQ3' AS QX, scs_b_q3 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q3" .
"UNION" .
"SELECT 'BQ4' AS QX, scs_b_q4 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q4" .
"UNION" .
"SELECT 'BQ5' AS QX, scs_b_q5 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q5" .
"UNION" .
"SELECT 'BQ6' AS QX, scs_b_q6 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q6" .
"UNION" .
"SELECT 'BQ7' AS QX, scs_b_q7 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q7" .
"UNION" .
"SELECT 'BQ8' AS QX, scs_b_q8 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q8" .
"UNION" .
"SELECT 'BQ9' AS QX, scs_b_q9 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q9" .
"UNION" .
"SELECT 'BQ10' AS QX, scs_b_q10 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q10" .
"UNION" .
"SELECT 'BQ11' AS QX, scs_b_q11 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q11" .
"UNION" .
"SELECT 'BQ12' AS QX, scs_b_q12 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q12" .
"UNION" .
"SELECT 'BQ13' AS QX, scs_b_q13 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q13" .
"UNION" .
"SELECT 'BQ14' AS QX, scs_b_q14 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q14" .
"UNION" .
"SELECT 'BQ15' AS QX, scs_b_q15 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q15" .
"UNION" .
"SELECT 'BQ16' AS QX, scs_b_q16 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q16" .
"UNION" .
"SELECT 'BQ17' AS QX, scs_b_q17 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q17" .
"UNION" .
"SELECT 'BQ18' AS QX, scs_b_q18 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q18" .
"UNION" .
"SELECT 'BQ19' AS QX, scs_b_q19 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q19" .
"UNION" .
"SELECT 'BQ20' AS QX, scs_b_q20 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q20" .
"UNION" .
"SELECT 'BQ21' AS QX, scs_b_q21 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q21" .
"UNION" .
"SELECT 'BQ22' AS QX, scs_b_q22 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q22" .
"UNION" .
"SELECT 'BQ23' AS QX, scs_b_q23 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q23" .
"UNION" .
"SELECT 'BQ24' AS QX, scs_b_q24 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q24" .
"UNION" .
"SELECT 'BQ25' AS QX, scs_b_q25 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q25" .
"UNION" .
"SELECT 'BQ26' AS QX, scs_b_q26 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q26" .
"UNION" .
"SELECT 'BQ27' AS QX, scs_b_q27 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q27" .
"UNION" .
"SELECT 'BQ28' AS QX, scs_b_q28 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q28" .
"UNION" .
"SELECT 'BQ29' AS QX, scs_b_q29 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q29" .
"UNION" .
"SELECT 'BQ30' AS QX, scs_b_q30 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q30" .
"UNION" .
"SELECT 'BQ31' AS QX, scs_b_q31 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q31" .
"UNION" .
"SELECT 'BQ32' AS QX, scs_b_q32 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q32" .
"UNION" .
"SELECT 'BQ33' AS QX, scs_b_q33 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q33" .
"UNION" .
"SELECT 'BQ34' AS QX, scs_b_q34 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q34" .
"UNION" .
"SELECT 'BQ35' AS QX, scs_b_q35 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q35" .
"UNION" .
"SELECT 'BQ36' AS QX, scs_b_q36 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q36" .
"UNION" .
"SELECT 'BQ37' AS QX, scs_b_q37 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q37" .
"UNION" .
"SELECT 'BQ38' AS QX, scs_b_q38 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q38" .
"UNION" .
"SELECT 'BQ39' AS QX, scs_b_q39 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q39" .
"UNION" .
"SELECT 'BQ40' AS QX, scs_b_q40 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_b_q40" .
"UNION" .
"SELECT 'RQ1' AS QX, scs_r_q1 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q1" .
"UNION" .
"SELECT 'RQ2' AS QX, scs_r_q2 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q2" .
"UNION" .
"SELECT 'RQ3' AS QX, scs_r_q3 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q3" .
"UNION" .
"SELECT 'RQ4' AS QX, scs_r_q4 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q4" .
"UNION" .
"SELECT 'RQ5' AS QX, scs_r_q5 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q5" .
"UNION" .
"SELECT 'RQ6' AS QX, scs_r_q6 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q6" .
"UNION" .
"SELECT 'RQ7' AS QX, scs_r_q7 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q7" .
"UNION" .
"SELECT 'RQ8' AS QX, scs_r_q8 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q8" .
"UNION" .
"SELECT 'RQ9' AS QX, scs_r_q9 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q9" .
"UNION" .
"SELECT 'RQ10' AS QX, scs_r_q10 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q10" .
"UNION" .
"SELECT 'RQ11' AS QX, scs_r_q11 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q11" .
"UNION" .
"SELECT 'RQ12' AS QX, scs_r_q12 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q12" .
"UNION" .
"SELECT 'RQ13' AS QX, scs_r_q13 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q13" .
"UNION" .
"SELECT 'RQ14' AS QX, scs_r_q14 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q14" .
"UNION" .
"SELECT 'RQ15' AS QX, scs_r_q15 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q15" .
"UNION" .
"SELECT 'RQ16' AS QX, scs_r_q16 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q16" .
"UNION" .
"SELECT 'RQ17' AS QX, scs_r_q17 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q17" .
"UNION" .
"SELECT 'RQ18' AS QX, scs_r_q18 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q18" .
"UNION" .
"SELECT 'RQ19' AS QX, scs_r_q19 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q19" .
"UNION" .
"SELECT 'RQ20' AS QX, scs_r_q20 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q20" .
"UNION" .
"SELECT 'RQ21' AS QX, scs_r_q21 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q21" .
"UNION" .
"SELECT 'RQ22' AS QX, scs_r_q22 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q22" .
"UNION" .
"SELECT 'RQ23' AS QX, scs_r_q23 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q23" .
"UNION" .
"SELECT 'RQ24' AS QX, scs_r_q24 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q24" .
"UNION" .
"SELECT 'RQ25' AS QX, scs_r_q25 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q25" .
"UNION" .
"SELECT 'RQ26' AS QX, scs_r_q26 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q26" .
"UNION" .
"SELECT 'RQ27' AS QX, scs_r_q27 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q27" .
"UNION" .
"SELECT 'RQ28' AS QX, scs_r_q28 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q28" .
"UNION" .
"SELECT 'RQ29' AS QX, scs_r_q29 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q29" .
"UNION" .
"SELECT 'RQ30' AS QX, scs_r_q30 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q30" .
"UNION" .
"SELECT 'RQ31' AS QX, scs_r_q31 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q31" .
"UNION" .
"SELECT 'RQ32' AS QX, scs_r_q32 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q32" .
"UNION" .
"SELECT 'RQ33' AS QX, scs_r_q33 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q33" .
"UNION" .
"SELECT 'RQ34' AS QX, scs_r_q34 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q34" .
"UNION" .
"SELECT 'RQ35' AS QX, scs_r_q35 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q35" .
"UNION" .
"SELECT 'RQ36' AS QX, scs_r_q36 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q36" .
"UNION" .
"SELECT 'RQ37' AS QX, scs_r_q37 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q37" .
"UNION" .
"SELECT 'RQ38' AS QX, scs_r_q38 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q38" .
"UNION" .
"SELECT 'RQ39' AS QX, scs_r_q39 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q39" .
"UNION" .
"SELECT 'RQ40' AS QX, scs_r_q40 AS value, COUNT(*) as count FROM scans WHERE (scs_tabname='{$fTest}') GROUP BY scs_r_q40;";
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// QUERIES FREQUENTIES PER WOORD - BASIS en RESPONSE -
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// Dit zit reeds in bovenstaande query, we hebben echter de woorden nodig van de test en de 4 as teksten
//
// AS TEKSTEN
// Q4_Q1 R65
// Q3_Q2 R66
// Q4_Q3 R64
// Q1_Q2 R63
//
// BASIC STYLE SCAN DE 40 WOORDEN
// W1..W40 R17..R56
SELECT tsc_google_row AS R, tsc_google_text AS T
FROM tests_source
WHERE (
(tsc_tabname='Behavior') AND (tsc_isl_iso639_1='NL') AND
(
((CAST(SUBSTRING(tsc_google_row, 2) AS UNSIGNED) >= 17) AND (CAST(SUBSTRING(tsc_google_row, 2) AS UNSIGNED) <= 56)) OR
((CAST(SUBSTRING(tsc_google_row, 2) AS UNSIGNED) >= 63) AND (CAST(SUBSTRING(tsc_google_row,2) AS UNSIGNED) <= 66))
)
) ORDER BY tsc_google_row ASC;
// ------------------------------------------------------------------------------------------------------------------------------------------------------
// QUERIES FREQUENTIES VAN DE QUADRANT GEMIDDELDEN PER TEST - BASIS en RESPONSE - VARIABELE KLASSEBREEDTE VAN [1..15]
tsc_google_text
// ------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT (scs_b_q1 + scs_b_q5 + scs_b_q9 + scs_b_q13 + scs_b_q17 + scs_b_q21 + scs_b_q25 + scs_b_q29 + scs_b_q33 + scs_b_q37) AS SUM_B_Q1,
(scs_b_q2 + scs_b_q6 + scs_b_q10 + scs_b_q14 + scs_b_q18 + scs_b_q22 + scs_b_q26 + scs_b_q30 + scs_b_q34 + scs_b_q38) AS SUM_B_Q2,
(scs_b_q3 + scs_b_q7 + scs_b_q11 + scs_b_q15 + scs_b_q19 + scs_b_q23 + scs_b_q27 + scs_b_q31 + scs_b_q35 + scs_b_q39) AS SUM_B_Q3,
(scs_b_q4 + scs_b_q8 + scs_b_q12 + scs_b_q16 + scs_b_q20 + scs_b_q24 + scs_b_q28 + scs_b_q32 + scs_b_q36 + scs_b_q40) AS SUM_B_Q4,
(scs_r_q1 + scs_r_q5 + scs_r_q9 + scs_r_q13 + scs_r_q17 + scs_r_q21 + scs_r_q25 + scs_r_q29 + scs_r_q33 + scs_r_q37) AS SUM_R_Q1,
(scs_r_q2 + scs_r_q6 + scs_r_q10 + scs_r_q14 + scs_r_q18 + scs_r_q22 + scs_r_q26 + scs_r_q30 + scs_r_q34 + scs_r_q38) AS SUM_R_Q2,
(scs_r_q3 + scs_r_q7 + scs_r_q11 + scs_r_q15 + scs_r_q19 + scs_r_q23 + scs_r_q27 + scs_r_q31 + scs_r_q35 + scs_r_q39) AS SUM_R_Q3,
(scs_r_q4 + scs_r_q8 + scs_r_q12 + scs_r_q16 + scs_r_q20 + scs_r_q24 + scs_r_q28 + scs_r_q32 + scs_r_q36 + scs_r_q40) AS SUM_R_Q4
FROM scans WHERE (scs_tabname='{$fTest}');
GRAFIEKEN - DYNAMISCHE VALIDATIE - OBJECT VOOR EEN GRAFIEK
De volgende data is nodig voor het plotten van de histogrammen met svg
- De 11 frequenties voor de waarden 0..10
- De kleur van de histogrammen rood geel blauw groen voor behavior
- We gaan voor de 16:9 verhouding, dus maxX = 1600 en maxY = 900
- Rondom de grafiek svg wordt een padding van 10 pixels gehanteerd