Articoli

Pubblicato il

The best blocking unwanted calls app

In Android 9 I found Stop Call Me the only one working. Without excessive ads, simple to configure, unlike other apps this one don’t tell you that a call is blocked (leaving it ringing), but it blocks effectively it.

Pubblicato il

true phone: the best android phone app

True Phone in my opinion is the best phone app: indeed without unnecessary special effects, it offers a remarkable range of features, including choosing the address books.

As an example, you can set davx (/nextcloud) as the main address book, instead of the google one.
Or you can view groups of contacts – which almost no other app does.

Obviously, you can set customized ringtone and sounds. Or easily modify contacts.

But there a lots of interesting features. It is undoubtedly worth trying.

Pubblicato il

how split a mkv with subtitles

You can use mkvtoolnix, then go to -> output, and -> splitting -> by parts based on timestamps -> and there you can write the beginning and the end of the part you want extract (without spaces: like 1:02:07-1:04:40, for example).

Pubblicato il

show “alt” attribute after an image

You can use a javascript, like this

<script type="text/javascript">
// img[style]').each(function(){
       $el = $(this);
       var style = $el.attr('style');
       $el.attr('style','');
       $el.parent().attr('style',style);
    }); //Moves the inline styles

      $("img").each(function(){
          var title = this.alt;
          $(this).after(''+ title +'');
      }); //Adds the dynamic captions.
 });
 //]]>
</script>

Pubblicato il

mysql convert a column to utf-8

You can use this mysql query code:

ALTER TABLE yourtable MODIFY
    yourcol VARCHAR(255)
      CHARACTER SET utf8
      COLLATE utf8_general_ci;

There are more problems with ENUM and SET type fields.

For ENUM you have to specify all the field values, no matter how many they are

ALTER TABLE yourtable MODIFY
    yourcol ENUM('val1','val2',etc)
      CHARACTER SET utf8
      COLLATE utf8_general_ci;

For SET the problems rise from the name SET, so you have to do this command

ALTER TABLE yourtable MODIFY
    yourcol CHAR(255)
      CHARACTER SET utf8
      COLLATE utf8_general_ci;

You will be able afterwards to modify CHAR to SET (with your previous values) without losing your data.

Pubblicato il

https and free hosting

It is a very serious problem: there are very good free hosting, but unfortunately without a free https service.