Hai Sentito il Terremoto?

impostate insieme, nella versione di sviluppo, tutte le modifiche da fare sul db.
va cambiata la procedura di salvataggio cosi' fa fissare le modifiche per ogni questionario compilato

modificato metodo php che memorizza i questionari nel db aggiungendo il reset dei campi, al valore di default, quando trova un valore non valido

aggiornato db con le seguenti modifiche (le riporto tutte, visto che sono molte e molto invasive)

delete from questionnaire where mcs = -8 and obs_place = 100;
update questionnaire set obs_place = 4 where floor = 402 and obs_place = 100;
update questionnaire set obs_place = 4 where tot_floors = 413 and obs_place = 100;
update questionnaire set obs_place = 4 where obs_place = 100;

update questionnaire set fireplace = 264 where fireplace = 263;

delete from questionnaire where adverted = 0;

delete from questionnaire where
    intensity = 0 and
    e_reaction = 0 and
    equilibry = 0 and
    animal_reac = 0 and
    lights = 0 and
    plates = 0 and
    ornaments = 0 and
    doors = 0 and
    liquids = 0 and 
    pictures = 0 and
    closet = 0 and
    plants = 0 and
    acous_effect = 0 and
    when_acous = 0 and
    where_acous = 0 and 
    adverted = 31;

update questionnaire set
    intensity = 41 ,
    e_reaction = 51 ,
    equilibry = 71 ,
    animal_reac = 91 ,
    lights = 101,
    plates = 111 ,
    ornaments = 121,
    doors = 131 ,
    liquids = 141 , 
    pictures = 151 ,
    closet = 161 ,
    plants = 191 ,
    acous_effect = 201 ,
    when_acous = 211 ,
    where_acous = 221
where
    intensity = 0 and
    e_reaction = 0 and
    equilibry = 0 and
    animal_reac = 0 and
    lights = 0 and
    plates = 0 and
    ornaments = 0 and
    doors = 0 and
    liquids = 0 and 
    pictures = 0 and
    closet = 0 and
    plants = 0 and
    acous_effect = 0 and
    when_acous = 0 and
    where_acous = 0 and 
    adverted = 32;

update questionnaire set intensity = 41 where intensity = 40;
update questionnaire set intensity = 41 where intensity = 0;
update questionnaire set e_reaction = 51 where e_reaction = 0;
update questionnaire set equilibry = 71 where equilibry = 0;
update questionnaire set animal_reac = 91 where animal_reac = 0;
update questionnaire set lights = 101 where lights = 0;
update questionnaire set ornaments = 121 where ornaments = 0;
update questionnaire set liquids = 141 where liquids = 0;
update questionnaire set pictures = 151 where pictures = 0;
update questionnaire set closet = 161 where closet = 0;
update questionnaire set plants = 191 where plants = 0;
update questionnaire set acous_effect = 201 where acous_effect = 0;
update questionnaire set when_acous = 211 where when_acous = 0;
update questionnaire set where_acous = 221 where where_acous = 0;
update questionnaire set buildings = 271 where buildings = 0;
update questionnaire set damages = 231 where damages = 0;
update questionnaire set walls = 241 where walls = 0;
update questionnaire set roofs = 251 where roofs = 0;
update questionnaire set fireplace = 261 where fireplace = 0;

update questionnaire set intensity_duration = NULL where intensity_duration = 0 and version = 2;

update questionnaire set when_acous_end = 291 where when_acous_end = 0;
update questionnaire set when_acous_end = 291 where when_acous_end is null and version in (2,3);

update questionnaire set acous_intensity = 301 where acous_intensity = 0;
update questionnaire set acous_intensity = 301 where acous_intensity is null and version in (2,3);

update questionnaire set acous_similitude = 1001 where acous_similitude = 0;
update questionnaire set acous_similitude = 1001 where acous_similitude is null and version in (2,3);

update questionnaire set light_effects = NULL where light_effects = 0 and version = 2;
update questionnaire set light_effects = 331 where light_effects = 0 and version = 3;
update questionnaire set light_effects = 331 where light_effects is null and version = 3;

update questionnaire set light_effects_similitude = NULL where light_effects_similitude = 0 and version = 2;
update questionnaire set light_effects_similitude = 341 where light_effects_similitude = 0 and version = 3;
update questionnaire set light_effects_similitude = 341 where light_effects_similitude IS NULL and version = 3;

update questionnaire set light_effects_start = NULL where light_effects_start = 0 and version = 2;
update questionnaire set light_effects_start = 351 where light_effects_start = 0 and version = 3;
update questionnaire set light_effects_start = 351 where light_effects_start is null and version = 3;

update questionnaire set light_duration = NULL where light_duration = 0 and version = 2;
update questionnaire set light_duration = 361 where light_duration = 0 and version = 3;
update questionnaire set light_duration = 361 where light_duration is null and version = 3;

update questionnaire set light_color = NULL where light_color = 0 and version = 2;
update questionnaire set light_color = 371 where light_color = 0 and version = 3;
update questionnaire set light_color = 371 where light_color is null and version = 3;