Recherche avancée

Sur d’autres sites (11444)

• Anomalie #4737 : Erreur recherche dans les forums dans le privé

  9 juillet 2021, par JLuc -

  Avec ou sans "plat", le SQL généré est :
  

  <span class="CodeRay"><span class="class">SELECT</span> forum.id_forum, resultats.points <span class="keyword">AS</span> points, forum.statut
  <span class="keyword">FROM</span> spip_forum <span class="keyword">AS</span> <span class="string"><span class="delimiter">`</span><span class="content">forum</span><span class="delimiter">`</span></span>  
  <span class="keyword">INNER</span> <span class="keyword">JOIN</span> spip_resultats <span class="keyword">AS</span> resultats <span class="keyword">ON</span> ( resultats.id = forum.id_forum )
  <span class="keyword">WHERE</span> <span class="keyword">NOT</span>((forum.statut <span class="keyword">LIKE</span> <span class="string"><span class="delimiter">'</span><span class="content">priv%</span><span class="delimiter">'</span></span>))
      <span class="keyword">AND</span> (resultats.recherche=<span class="string"><span class="delimiter">'</span><span class="content">c7b4cacf770e2915</span><span class="delimiter">'</span></span> <span class="keyword">AND</span> resultats.table_objet=<span class="string"><span class="delimiter">'</span><span class="content">forum</span><span class="delimiter">'</span></span> <span class="keyword">AND</span> resultats.serveur=<span class="string"><span class="delimiter">'</span><span class="delimiter">'</span></span>)
  <span class="keyword">GROUP</span> <span class="keyword">BY</span> forum.id_forum
  <span class="keyword">ORDER</span> <span class="keyword">BY</span> forum.id_forum <span class="directive">DESC</span>
  </span>
  Télécharger

  Le pb vient du fait que c’est le forum id_thread qui est enregistré dans la table spip_resultats.

• target_link_libraries in CMAKE using android studio 2.2.2

  22 novembre 2016, par fadi

  I am facing a weird issue and it’s difficult to know why because the compiler doesnt give any errors.

  I created a new project in android studio 2.2.2 with C++ support.
  I edited the .cpp file inside src/main/cpp and compiled the project to obtain (.so) file that i can use as a shared library. To this point everything works perfect.

  Here is where the problem occurs :

  I am trying to link prebuild shared libraries from ffmpeg. I have already build the libraries in .so format and all I need to do is link them to my .cpp file.

  To link the libraries, I opened the CMakeLists.txt inside android studio and told cmake to link those prebuild shared libraries using the following code :

  add_library(libavformat SHARED IMPORTED)

  set_target_properties(libavformat PROPERTIES IMPORTED_LOCATION  C:/Android  /SDK/MyProjects/ffmpeg_to_jpg/P3/app/src/main/jniLibs/libavformat-55.so)

  include_directories(src/main/cpp/include/)

  target_link_libraries(native-lib  libavformat)

  This code basically links libavformat to native-lib (which is created from my .cpp file)

  The linking process works fine, the reason is because the compiler doesn’t cry about any dependencies.

  However, my original shared library (native-lib) stops working, and by that I mean, I cannot call any functions from within it.

  If i remove the linking line

  target_link_libraries(native-lib  libavformat)

  The native-lib.so works fine and I can call any function from within that does not depend on libavformat.

  I am not sure what is going on, like I said the compiler doesnt issue any warnings or errors. it is almost like after the linking process the content of native-lib is overwritten by libavformat !!!!

  any ideas ?

• ffmpeg's segment_atclocktime cuts at inaccurate times for audio

  3 mai 2023, par Ross Richardson

  I am using ffmpeg's segment format to save files of an AAC stream to disk in hourly segments.
The segmenting works well, but the files are segmented/cut at different times in the clock each hour using segment_atclocktime

  


  I would like each to be exactly on the hour, e.g. 12:00:00, 13:00:00 etc. Or at least, beginning after the hour and not before, e.g. 12:00:00, 13:00:01, 14:00:00 etc.

  


  I am using ffmpeg-python to process the AAC stream and send to two outputs : stdout and these segments.
Here's the code :

  


  out1 = ffmpeg.input(stream, loglevel="panic").output("pipe:",
                                                     format="s16le", 
                                                     acodec="pcm_s16le", 
                                                     ac="1", 
                                                     ar="16000")

out2 = ffmpeg.input(stream, loglevel="info").output("rec/%Y-%m-%d-%H%M%S.aac",
                                                     acodec="copy",
                                                     format="segment",
                                                     segment_time="3600",
                                                     segment_atclocktime="1",
                                                     reset_timestamps="1",
                                                     strftime="1")
            
ffmpeg.merge_outputs(out1, out2)
      .run_async(pipe_stdout=True, overwrite_output=True)


  


  Most files are produced at the desired time : 05:00:00, 06:00:00, 07:00:00, but one or two each day start at 08:59:59 (where 09:00:00 would be desired), or even 16:00:24.

  


  I understand the segment needs to begin on a audio sample so it can't be perfect to the hour, but wondering how I can make it more consistent. Ideally, each hour's recording would begin at 00:00 or later, and not begin before the hour.

  


  I have tried using min_seg_duration 3600, reset_timestamps 1
I am not sure how exactly to use segment_clocktime_wrap_duration for audio, or whether segment_time_delta applies to audio.

  


  I'd appreciate any advice or understanding of how segment_atclocktime works with audio, as much on the internet seems video-focused.