Recherche avancée

Sur d’autres sites (4967)

• 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 make words in ASS subtitles appear one at a time ?

  21 septembre 2022, par ThaDon

  I am trying to burn subtitles into a video such that they appear in a word-by-word fashion instead of all at once.

  



  What I mean by this is, a word will appear, then another word will appear next to it, and so on. Eventually the line will clear, then repeat.

  



  Example :

  



  

  



  I thought I could create an Advanced Substation Alpha file where subtitles share the same end-time but differing start times, however FFMPEG doesn't seem to cope very well when rendering the file :

  



  [Script Info]
; Script generated by FFmpeg/Lavc57.107.100
ScriptType: v4.00+
PlayResX: 384
PlayResY: 288

[V4+ Styles]
Format: Name, Fontname, Fontsize, PrimaryColour, SecondaryColour, OutlineColour, BackColour, Bold, Italic, Underline, StrikeOut, ScaleX, ScaleY, Spacing, Angle, BorderStyle, Outline, Shadow, Alignment, MarginL, MarginR, MarginV, Encoding
Style: Default,Arial,16,&Hffffff,&Hffffff,&H0,&H0,0,0,0,0,100,100,0,0,1,1,0,2,10,10,10,0

[Events]
Format: Layer, Start, End, Style, Name, MarginL, MarginR, MarginV, Effect, Text
Dialogue: 0,0:00:00.00,0:00:03.46,Default,,0,0,0,,I'm
Dialogue: 0,0:00:01.00,0:00:03.46,Default,,0,0,0,,a
Dialogue: 0,0:00:01.50,0:00:03.46,Default,,0,0,0,,subtitle


  



  The idea being that I'm would appear, then 1 second later a would show up next to it followed by subtitle a half second later

  


• How to make only words (not sentences) in SRT file by AssemblyAI

  19 avril 2024, par flip

  Okay... So Im trying to create a video making program thing and I'm basically finished but I wanted to change 1 key thing and don't know how to...
Here's the code :

  


  import assemblyai as aai
import colorama
from colorama import *
import time
import os

aai.settings.api_key = "(cant share)"

print('')
print('')
print(Fore.GREEN + 'Process 3: Creating subtitles...')
print('')
time.sleep(1)
print(Fore.YELLOW + '>> Creating subtitles...')
transcript = aai. Transcriber().transcribe("output/output-tts.mp3")

subtitles = transcript.export_subtitles_srt()
print('>> Created subtitles!')

f = open("subtitles.srt","a")
f.write(subtitles)
print('')
print('Program >> You are going to have to manually run the last python file [addsubtitles.py] because \n this program needs to close to write down the subtitles')
print('')
time.sleep(7)
f.close()


  


  when it exports the SRT it exports it something like this :

  


  1
00:00:00,160 --> 00:00:04,238
Put a finger down if you have ever kissed a

2
00:00:04,286 --> 00:00:05,374
goddamn dog.




  


  but i want it to go word by word but still synced with the time frame in the audio and then generate a srt file that has word by word and no sentences.
How could I do this ? because I have no idea how to implement that into the code.

  


  I tried watching or searching the internet for any ways on doing this because I can't figure it out but there are still no results. Would appreciate if anyone could help.