Recherche avancée

Sur d’autres sites (12043)

• Anomalie #3930 : Moteur de recherche : combinaison de DEUX mots avec accents ne retourne rien

  18 septembre 2017, par - Equipement

  Je confirme que je constate le problème en SPIP 3.1.6 [23598] avec MYSQL 5.5.41 (tables MYISAM).

  En ajoutant, dans inc/recherche_to_array.php (ligne 57), le spip_log ci-dessous :
  

  spip_log("expression_recherche :".$methode.’ / ’.$q.’ / ’.$preg, _LOG_ERREUR) ;
  

  le résultat de la trace est :
  expression_recherche :REGEXP / ’secr.tariat g.n.ral|secr.tariat|g.n.ral’ / /secretariat general|secretariat|general/UimsSu

  Si dans inc/rechercher.php (SPIP 3.1.6 [23598]), je déplace les lignes suivantes :
  

          // tous les caracteres transliterables de $q sont remplaces par un joker
        // permet de matcher en SQL meme si on est sensible aux accents (SQLite)
        $q_t = $q ;
        for ($i = 0 ; $i < spip_strlen($q) ; $i++) 
            $char = spip_substr($q, $i, 1) ;
            if (!is_ascii($char)
                and $char_t = translitteration($char)
                and $char_t !== $char
            ) 
                $q_t = str_replace($char, $is_preg ? "." : "_", $q_t) ;
            
        
        $q = $q_t ;
  

  dans la condition (if) juste en dessous :
  

      if (isset($GLOBALS[’connexions’][$options[’serveur’] ? $options[’serveur’] : 0][’type’])
          and strncmp($GLOBALS[’connexions’][$options[’serveur’] ? $options[’serveur’] : 0][’type’], ’sqlite’, 6) == 0
      ) 

  la recherche sur secrétariat général fonctionne et le résultat de la trace est :
  expression_recherche :REGEXP / ’secrétariat général|secrétariat|général’ / /secretariat general|secretariat|general/UimsSu

• Calculate frames to remove to get timelapse of desired length

  12 juin 2016, par Espen Birk

  I’ve got lots of images stored on a server, and a reference in a MySQL database so that i can easily query it for image from specific dates/time.

  Images is taken with an interval of 7 images/hour.

  Lets say i want to create a timelapse from the last 4 days, and make a 5 sec movie. How can i calculate how to evenly drop frames to get to that desired length of 5 seconds ?

  This is what i got so far.

  Total images : 4 Days * 24 hours * 7 images/hour = 672 images
  Required images at 24 fps : 24 * 5 = 120 images

  Divide the total images with the required images to find out which/every frame i need to keep

  672 / 120 = 5.6

  Then i loop trough all 672 images, and every 5th or 6th time i store a reference to the image in an array.

  Here is my problem. If i round up i get a video thats longer than i want, and if i round down i get a video thats shorter.

  If i keep every 5th image when looping : 134 images / 24 fps = 5.6 sec video
  If i keep every 6th image when looping : 112 images / 24 fps = 4.6 sec video

  Is it possible to get it better, and still skip images evenly ?

  Solved this using xxfelixxx’s answer in PHP
  Heres the code in PHP :

  $start  = 1;
  
  $stop   = 672; // Total Images
  
  
  
  $dur    = 5;   // Video Duration
  
  $n      = 24 * $dur; // Required frames - 24 FPS * Duration
  
  $next   = $start;
  
  $step = ( $stop - $start ) / $n;
  
  
  
  $frames = array();
  
  
  
  for ($i = 1; $i <= $n; $i++) {
  
      $frames[] = round($next);
  
      $next += $step;
  
  };
  
  
  
  var_dump($frames);

• ffmpeg - continuous file streaming over RTMP

  1er mai 2013, par Sébastien Renauld

  I've been looking around for a simple (or perhaps not-so-simple) walkaround for a problem I am having in my set up for a simple test case : video streaming over red5 media server.

  I have built a small-ish library of FLV files scraped from YouTube and managed to play them in succession with the following perl script :

  use Cwd;
  
  use strict;
  
  use warnings;
  
  use DBI;
  
  use DBD::mysql;
  
  
  
  our $db = DBI->connect();
  
  my $dst = "/home/seb/youtube/";
  
  sub streamFile {
  
      my $r = $db->prepare("SELECT name FROM music_flvs ORDER BY RAND() LIMIT 1");
  
      $r->execute();
  
      my @data = $r->fetchrow_array();
  
      my $filename = $data[0]
  
      my $t = `ffmpeg -re -i '${dst}${filename}' -ab 48k -ac 1 -vcodec libx264 -crf 30 -s "640x480" -acodec libfaac -ar 44100 -threads 4 -f flv 'rtmp://server/oflaDemo/music'`;
  
      return 1;
  
  }
  
  while (&streamFile()) {
  
  }

  This script does its purpose extremely well : it plays files one by one through ffmpeg. However, it does so with a crucial problem : it causes an Unpublish event every time it swaps songs, which causes all the clients to disconnect. I would like to prevent this. The event manifests itself in ActionScript as this :

   16:33:54:209 - Playback - NetStream.Play.UnpublishNotify
  
   16:33:54:209 - Playback - NetStream.Play.PublishNotify

  I have seen the concat demuxer and believe that it might somewhat help me. The question is pretty simple : what is the best way to make ffmpeg stream a playlist to a RTMP server without ever causing an Unpublish event ?