Recherche avancée

Sur d’autres sites (6283)

• Anomalie #3894 : Jointures (erronées ?) avec les boucles documents et leurs critères

  26 janvier 2017, par tcharlss (*´_ゝ｀)

  J’ai testé avec divers objets que j’avais sous la main pour voir, on reprenant le même procédé :

  • un document attaché à 2 objets, vu=oui pour le N°1, et vu=non pour le N°2
  • id_patate=1 dans l’URL
  • {id_patate?}{vu=non} dans la boucle

  Ça n’a fait la bonne jointure que pour 1 seul objet, donc c’est plutôt une exception on dirait.
  Rigolo : le nom de la jointure superflue s’incrémente entre chaque test, j’ai fini à L8 ! (L5 je l’ai enlevé, c’était sur les auteurs, donc même ambiguïté que pour les mots clés)

  Album [OK] :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L1.id_objet = 1)
      AND (L1.objet = ’album’)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

  Brève [PAS OK] :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_documents_liens AS L2 ON ( L2.id_document = documents.id_document ) 
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L2.id_objet = 1)
      AND (L2.objet = ’breve’)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

  Forum [PAS OK] :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_documents_liens AS L3 ON ( L3.id_document = documents.id_document ) 
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L3.id_objet = 1)
      AND (L3.objet = ’forum’)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

  Mot [PAS OK] (là c’est un peu spécial car il y a une ambiguïté avec mots_liens) :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_mots_liens AS L4 ON ( L4.id_objet = documents.id_document AND L4.objet=’document’) 
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L4.id_mot = 1)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

  Abonnement [PAS OK] :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_documents_liens AS L6 ON ( L6.id_document = documents.id_document ) 
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L6.id_objet = 1)
      AND (L6.objet = ’abonnement’)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

  Ticket [PAS OK] :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_documents_liens AS L7 ON ( L7.id_document = documents.id_document ) 
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L7.id_objet = 1)
      AND (L7.objet = ’ticket’)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

  Adresse [PAS OK] :¶

  SELECT documents.fichier
  FROM spip_documents AS `documents`  
  INNER JOIN spip_documents_liens AS L8 ON ( L8.id_document = documents.id_document ) 
  INNER JOIN spip_documents_liens AS L1 ON ( L1.id_document = documents.id_document )
  WHERE (documents.taille > 0 OR documents.distant=’oui’)
      AND (L8.id_objet = 1)
      AND (L8.objet = ’adresse’)
      AND (L1.vu = ’non’)
  GROUP BY documents.id_document
  

• How to convert mp4 to HLS and add subtitles to master playlist with ffmpeg

  26 septembre 2023, par light01

  I'm trying to use ffmpeg to convert an mp4 file to HLS, add subtitles, and have them in the master playlist.

  



  I managed to get it to create index_vtt.m3u8 files that contain the subtitles, but it doesn't want to add the stream to the master playlist.
I'm new to this so I don't fully understand how the whole ffmpeg works (I'm mainly just trying out bunch of resources I found on the net)

  



  I'm using the following command :

  



  ../ffmpeg-4.2.1/ffmpeg -i ../input.mp4 -i ../subtitile.vtt -c:s webvtt -profile:v baseline -level 21 -s 1280x720 -start_number 0 -hls_playlist_type vod -hls_time 10 -hls_list_size 3 -f hls -master_pl_name master.m3u8 index.m3u8`


  



  It generates master.m3u8

  



  #EXTM3U
#EXT-X-VERSION:3
#EXT-X-STREAM-INF:BANDWIDTH=140800,RESOLUTION=1280x720,CODECS="avc1.42c015,mp4a.40.2"
index.m3u8


  



  I can play it in vlc, but it doesn't recognize any subtitles.
Then I modify the master.m3u8 so it looks like this :

  



  #EXTM3U
#EXT-X-VERSION:6

#EXT-X-MEDIA:TYPE=SUBTITLES,URI="index_vtt.m3u8",GROUP-ID="default-text-group",LANGUAGE="hr",NAME="Croatian",AUTOSELECT=YES

#EXT-X-STREAM-INF:BANDWIDTH=140800,RESOLUTION=1280x720,CODECS="avc1.42c01e,mp4a.40.2",SUBTITLES="default-text-group"
index.m3u8


  



  And everything is fine. How can I tell ffmpeg to do this for me ?

  


• Why can I not change the number of frames (nframes) in a gganimate animation ?

  26 décembre 2022, par Gekin

  I have produced an animation per gganimate and rendered it per ffmpeg. It works just fine, but only, if I do not change the number of frames. If I do set the number of frames, I get this error message :

  


  nframes and fps adjusted to match transition
Error parsing framerate 8,4.                           
Error: Rendering with ffmpeg failed


  


  I produced the gganim MonthlyAveragePrecipitationMap the following way :

  


  options(scipen = 999, OutDec  =  ",")

MonthlyAveragePrecipitationMap = ggplot(MonthlyAverageExtremePrecipitation) + 
  geom_path(data = map_data("world","Germany"),
            aes(x = long, y = lat, group = group)) +
  coord_fixed(xlim = c(6,15),
              ylim = c(47,55)) + 
  geom_point(aes(x=lon, y=lat, 
                 colour = ShareOfExtremePrecipitationEvents,
                 group = MonthOfYear),
             size = 3) + 
  scale_color_gradient(low="blue", high="yellow") + 
  xlab("Longitude (degree)") +
  ylab("Latitude (degree)") + 
  theme_bw() +
  transition_manual(frames = MonthOfYear) + 
  labs(title = '{unique(MonthlyAverageExtremePrecipitation$MonthOfYear)[as.integer(frame)]}', 
       color = paste0("Share of Extreme Precipitation Events \namong all Precipitation Events")) 


  


  I call the animation the following way :

  


  animate(MonthlyAveragePrecipitationMap,
        nframes = 300,
        renderer =
          ffmpeg_renderer(
            format = "auto",
            ffmpeg = NULL,
            options = list(pix_fmt = "yuv420p")))



  


  I used this exact code just a few days ago and it worked fine.

  


  Has someone had similar experiences ?
Thanks in advance.