Forum Debian Users Gang

Graffi · 2010-02-17 22:04:58

hej hej

jak już niektórzy na #errorze zdążyli mieć mnie dosyć postawiłem sobie gentoo na jednym kompie... no i walczę tam z różnymi rzeczami, ostatnio wpadłem na pomysł że skoro olimpiada jest po drugiej stronie ziemi to może warto zaprzęgnąć chodzący 24h/d komp do nagrywania czegoś nocami w celu obejrzenia w dzień :)

no i...
zainstalowałem kartę TV

zainstalowałem mplayera (póki co tak jak poniżej widać):

Kod:

 U I                                                                      
 - - 3dnow               : Adds support for 3dnow multimedia processor instructions
 - - 3dnowext            : Enable 3dnowext cpu instructions                        
 - + X                   : Adds support for X11                                    
 - + a52                 : Enables support for decoding ATSC A/52 streams used in DVD
 - + aac                 : Enables support for MPEG-4 AAC Audio                      
 - - aalib               : Adds support for media-libs/aalib (ASCII-Graphics Library)
 + + alsa                : Adds support for media-libs/alsa-lib (Advanced Linux Sound Architecture)
 - - altivec             : Adds support for optimizations for G4 and G5/ppc970 processors          
 - + ass                 : Internal SRT/SSA/ASS (SubRip / SubStation Alpha) subtitle support       
 - - bidi                : Enables bidirectional language support                                  
 - - bindist             : Flag to enable or disable options for prebuilt (GRP)  packages (eg. due to licensing issues)
 - - bl                  : Blinkenlights video output                                                                  
 - - bs2b                : Enable Bauer stereophonic-to-binaural headphone filter                                      
 - + cddb                : Access cddb servers to retrieve and submit information about compact disks                  
 - + cdio                : Use libcdio for CD support (instead of cdparanoia)                                          
 - - cdparanoia          : Enables cdparanoia (audio CD ripper) support                                                
 - - cpudetection        : Enables runtime cpudetection (useful for bindist, compatability on other CPUs)              
 - - custom-cpuopts      : Fine-tune custom CPU optimizations (UNSUPPORTED)                                            
 - - debug               : Enable extra debug codepaths, like asserts and extra output. If you want to get meaningful backtraces see http://www.gentoo.org/proj/en/qa/backtraces.xml                                                                                                                          
 - - dga                 : Adds DGA (Direct Graphic Access) support for X                                                                              
 - + dirac               : Enable Dirac video support (an advanced royalty-free video compression format) via the reference library: dirac.            
 - - directfb            : Adds support for DirectFB layer (library for FB devices)                                                                    
 - - doc                 : Adds extra documentation (API, Javadoc, etc)                                                                                
 - + dts                 : Enables DTS Coherent Acoustics decoder support                                                                              
 - + dv                  : Enables support for a codec used by many camcorders                                                                         
 - - dvb                 : Adds support for DVB (Digital Video Broadcasting)                                                                           
 - + dvd                 : Adds support for DVDs                                                                                                       
 - + dvdnav              : Use forked libdvdnav, navigate menus in GUIs                                                                                
 - - dxr3                : Enable DXR3/H+ video output                                                                                                 
 - + enca                : Enables support for charset discovery and conversion                                                                        
 - + encode              : Adds support for encoding of audio or video files                                                                           
 - - esd                 : Adds support for media-sound/esound (Enlightened Sound Daemon)                                                              
 - + faac                : Use external faac library for AAC encoding                                                                                  
 - + faad                : Use external faad library for AAC decoding                                                                                  
 - - fbcon               : Adds framebuffer support for the console, via the kernel                                                                    
 - - ftp                 : Adds FTP (File Transfer Protocol) support                                                                                   
 - - ggi                 : Adds support for media-libs/libggi (non-X video api/drivers)                                                                
 - - gif                 : Adds GIF image support                                                                                                      
 - - gmplayer            : Build gmplayer, a GTK+ MPlayer gui (UNSUPPORTED)                                                                            
 + + iconv               : Enable support for the iconv character set conversion library                                                               
 + - ipv6                : Adds support for IP version 6                                                                                               
 - - jack                : Adds support for the JACK Audio Connection Kit                                                                              
 - - joystick            : Add support for joysticks in all packages                                                                                   
 - - jpeg                : Adds JPEG image support                                                                                                     
 + + kernel_linux        : KERNEL setting for system using the Linux kernel                                                                            
 - - ladspa              : Enables the ability to support ladspa plugins                                                                               
 - - libcaca             : Add support for colored ASCII-art graphics                                                                                  
 - + lirc                : Adds support for lirc (Linux's Infra-Red Remote Control)                                                                    
 - + live                : Enables live.com streaming media support                                                                                    
 - - lzo                 : Enables support for lzo compression                                                                                         
 - - mad                 : Adds support for mad (high-quality mp3 decoder library and cli frontend)                                                    
 - - md5sum              : Enables md5sum video output                                                                                                 
 - + mmx                 : Adds support for optimizations for Pentium MMX and Athlon class processors                                                  
 - - mmxext              : Enables mmx2 support                                                                                                        
 - - mng                 : Adds support for libmng (MNG images)                                                                                        
 - + mp3                 : Add support for reading mp3 files                                                                                           
 - - nas                 : Adds support for network audio sound                                                                                        
 - + network             : Enables network streaming support                                                                                           
 - - nut                 : Enables support for the NUT container format                                                                                
 - - openal              : Adds support for the Open Audio Library                                                                                     
 - - opencore-amr        : Enables Adaptive Multi-Rate format support                                                                                  
 - + opengl              : Adds support for OpenGL (3D graphics)                                                                                       
 - + osdmenu             : Enables support for on-screen display (OSD) menus                                                                           
 - - oss                 : Adds support for OSS (Open Sound System)                                                                                    
 - - png                 : Adds support for libpng (PNG images)                                                                                        
 - - pnm                 : Add PNM video output option, to create PPM/PGM/PGMYUV images                                                                
 - - pulseaudio          : Adds support for PulseAudio sound server                                                                                    
 - - pvr                 : Enable Video4Linux2 MPEG PVR                                                                                                
 - + quicktime           : Adds support for OpenQuickTime                                                                                              
 - - radio               : Enable V4L2 radio interface and support                                                                                     
 - + rar                 : Enable Unique RAR File Library                                                                                              
 - + real                : Adds real audo/video support                                                                                                
 - + rtc                 : Enables usage of the linux real time clock. The alternative is software emulation of rtc                                    
 - - samba               : Adds support for SAMBA (Windows File and Printer sharing)                                                                   
 - + schroedinger        : Enable Dirac video support (an advanced royalty-free video compression format) via libschroedinger (high-speed implementation in C of the Dirac codec).                                                                                                                            
 - - sdl                 : Adds support for Simple Direct Layer (media library)                                                                        
 - + shm                 : Enable support for shm                                                                                                      
 - + speex               : Adds support for the speex audio codec (used for speech)                                                                    
 - - sse                 : fast floating point optimization for PentiumIII+ class chips                                                                
 - - sse2                : faster floating point optimization for SSE2 capable chips                                                                   
 - - ssse3               : faster floating point optimization for SSSE3 capable chips (Intel Core 2 and later chips)                                   
 - - svga                : Adds support for SVGAlib (graphics library)                                                                                 
 - - teletext            : Support for TV teletext interface                                                                                           
 - - tga                 : Enables Targa video output                                                                                                  
 - + theora              : Adds support for the Theora Video Compression Codec                                                                         
 - + toolame             : Enable toolame MPEG-2 encoding
 - + tremor              : Enable internal support for Vorbis
 - + truetype            : Adds support for FreeType and/or FreeType2 fonts
 - + twolame             : Enable twolame MPEG-2 encoding
 + + unicode             : Adds support for Unicode
 - - v4l                 : Enables video4linux support
 - + v4l2                : Enable video4linux2 support
 - - vdpau               : Enables experimental VDPAU support (requires nVidia video cards) to offload MPEG2/MPEG4/VC1/WMV CPU processing to video card
 - - video_cards_mga     : VIDEO_CARDS setting to build driver for mga video cards
 - - video_cards_nvidia  : VIDEO_CARDS setting to build driver for nvidia video cards
 - - video_cards_s3virge : VIDEO_CARDS setting to build driver for s3virge video cards
 - - video_cards_tdfx    : VIDEO_CARDS setting to build driver for tdfx video cards
 - - vidix               : Support for vidix video output
 - + vorbis              : Adds support for the OggVorbis audio codec
 - - win32codecs         : use win32codecs package for dll avi decoding support (wmv and what not)
 - + x264                : Enable h264 encoding using x264
 - - xanim               : Enables support for xanim based codecs
 - - xinerama            : Add support for the xinerama X11 extension, which allows you to stretch your display across multiple monitors
 - + xscreensaver        : Adds support for XScreenSaver extension
 - + xv                  : Adds in optional support for the Xvideo extension (an X API for video playback)
 - + xvid                : Adds support for xvid.org's open-source mpeg-4 codec
 - - xvmc                : Enables X-Video Motion Compensation support
 - - zoran               : Enables ZR360[56]7/ZR36060 video output

no i zapuszczam nagrywanie tak:

Kod:

mencoder tv:// -tv driver=v4l2:device=/dev/video0:input=0:freq=215,25:norm=PAL-DK:width=720:height=480:outfmt=yuy2 brightness=50:contrast=10:saturation=60:hue=60 alsa:forceaudio:volume=90 -o /home/users/graffi/comp.avi -ofps 25 -vf-add scale=320:240 -vf-add expand=320:240:-1:-1:1 -srate 44100 -ovc xvid -xvidencopts bitrate=1000:max_bframes=0:quant_type=h263:me_quality=4 -oac lavc -lavcopts acodec=mp2:abitrate=128

tak żeby było łatwiej w kanały trafić to korzystałem z tego: http://www.dipol.com.pl/wykaz_czestotliwosci_kanalow_tv_bib02.htm
jak również z ręcznego przełączania kanałów w mplayerze poprzez h/l po odpaleniu

Kod:

mplayer tv://

gdzie też w nic nie trafiłem... - coś jest z tunerem źle?
wkompilowany mam tylko v4l2 (odpuściłem sobie v4l) - czy to błąd?

moja karta TV to:
00:06.0 Multimedia video controller: Conexant Systems, Inc. CX23880/1/2/3 PCI Video and Audio Decoder (rev 05)
i za starych czasów gdy moim normalnym komputerem był "blaszak" a nie laptop chodziła aż milo :)
(czyli całkiem niedawno bo ok. pół roku temu)

hmm... coś jeszcze potrzebne może?
to piszcie...

błąd nagrywania mam następujący:

Kod:

drekmore ~ $ mencoder tv:// -tv driver=v4l2:device=/dev/video0:input=0:freq=215,00:norm=PAL-DK:width=720:height=480:outfmt=yuy2 brightness=50:contrast=10:saturation=60:hue=60 alsa:forceaudio:volume=90 -o /home/users/graffi/comp.avi -ofps 25 -vf-add scale=320:240 -vf-add expand=320:240:-1:-1:1 -srate 44100 -ovc xvid -xvidencopts bitrate=1000:max_bframes=0:quant_type=h263:me_quality=4 -oac lavc -lavcopts acodec=mp2:abitrate=128                        
MEncoder SVN-r29796-4.3.4 (C) 2000-2009 MPlayer Team
success: format: 9  data: 0x0 - 0x0
TV file format detected.
Selected driver: v4l2
 name: Video 4 Linux 2 input
 author: Martin Olschewski <olschewski@zpr.uni-koeln.de>
 comment: first try, more to come ;-)
Selected device: Leadtek Winfast 2000XP Expert
 Tuner cap: STEREO LANG1 LANG2
 Tuner rxs: MONO
 Capabilites:  video capture  VBI capture device  tuner  read/write  streaming
 supported norms: 0 = NTSC-M; 1 = NTSC-M-JP; 2 = NTSC-443; 3 = PAL-BG; 4 = PAL-I; 5 = PAL-DK; 6 = PAL-M; 7 = PAL-N; 8 = PAL-Nc; 9 = PAL-60; 10 = SECAM-B; 11 = SECAM-G; 12 = SECAM-H; 13 = SECAM-DK; 14 = SECAM-L;
 inputs: 0 = Television; 1 = Composite1; 2 = S-Video;
 Current input: 0
 Current format: BGR24
v4l2: current audio mode is : MONO
v4l2: 0 frames successfully processed, 0 frames dropped.
============ Sorry, this file format is not recognized/supported =============
=== If this file is an AVI, ASF or MPEG stream, please contact the author! ===
Cannot open demuxer.

Exiting...
drekmore ~ $

i teraz pytanie: [b]co spieprzyłem?[/b]

ilin · 2010-02-17 22:12:25

Zacznij od uruchomienia tv np poprzez xawtv.

Jak to zrobisz to pomyślimy.

Dla przykładu daję moje działające polecenie

Kod:

 mencoder -quiet tv:// -tv device=/dev/video0:driver=v4l2:outfmt=yuy2:normid=5:fps=25:width=768:height=578:brightness=20:contrast=0:saturation=100:freq=711.600:fps=25:audiorate=48000:amode=1:alsa:adevice=default -vf scale=512:384,pp=de -ffourcc DX50 -ovc lavc -lavcopts vcodec=mpeg4:vbitrate=2000:keyint=250  -oac mp3lame -lameopts cbr:br=128:mode=0 -o /home/adam/XDTV/tvp1_`date "+%s"`.avi

Graffi · 2010-02-17 22:19:41

dzięki za polecenie, ale wiedzieć trzeba że ten komp na którym ma być to nagrywane to komp stojący w zaciszu za kwiatkiem za łóżkiem w rogu pokoju, który nie ma ani monitora, ani klawiatury ani nic takiego...
nie ma tam żadnych okienek...
robi mi w domu za:
- serwer Samby
- serwer CUPS
- poligon do zabawy
- i wiele innych użytecznych rzeczy o których tutaj pisać nie chce mi się

ale jeżeli zainstalowanie okienek będzie konieczne to nie będę miał innego wyjścia jak widzę :(

do rzeczy:
1. twoje polecenie jeszcze większą ilością błędów sypnęło :>
2. co mnie zastanawia to zawsze mam

Kod:

Cannot open demuxer.

- co to jest?
czegoś nie wkompilowałem w mplayerze?
hmm... bo to mnie zastanawia
chwilę googlałem ale nie wiem nadal co to "demuxer" :(

EDIT:
może moje stwierdzenie że używałem mplayera i oceniam że nie odbierał mi TV oceniłem po tym że na słuchawkach nie słyszałem głosu ;)
obrazu nie widziałem albo przekierowywałem do MPGa w celu obejrzenia po chwili

Ostatnio edytowany przez Graffi (2010-02-17 22:29:52)

ilin · 2010-02-17 22:33:31

http://encyclopedia2.thefreedictionary.com/Demuxer

W twoim poleceniu jest

Kod:

Current format: BGR24

Spróbuj ustawić to zamiast yuy2

Graffi · 2010-02-17 22:53:34

dalej to samo :(

obawiam się że jakiejś flagi USE nie użyłem :(
nie wiem... pogooglam jutro w robocie trochę, może coś się da wykombinować...

ale słuchaj, odpalając w konsoli

Kod:

mplayer tv://

i przełączając się pomiędzy kanałami powinienem na głos trafić - no nie? bo znajdę program w TV no i mogę sobie go posłuchać...
jezeli tego nie osiągnę to nie mam co się nagrywaniem zajmować? czy źle rozumuję?

ilin · 2010-02-17 23:05:51

Raczej nie trafisz.
Co najwyżej szum.

I mnie przy takiej operacji kanały sie przełączają ale jak sie nie zdefiniuje innych parametrów to raczej bieda.
Głosu nie ma nawet na kanałach które powinny dzialać.

Graffi · 2010-02-18 07:31:53

jest pewien progres :]

a mianowicie ttv odbiera normalnie TV :D
tzn. normalnie w przypadku oglądania tego po konsoli jest pewnego rodzaju nadużyciem słowa "normalnie" jednakże głos jest i porównując mozaikę znaczków z ekranem TV stwierdzam że to to samo...

no super, ale czemu nadal mencoder jak zaklęty nie nagrywa? :(

ilin · 2010-02-18 08:40:26

Pokaż co pluje moje polecenie.
Tylko omiń w nim tę opcję quiet

Rozumiem że masz kartę na cx8800.

Graffi · 2010-02-18 08:57:42

Kod:

mencoder tv:// -tv device=/dev/video0:driver=v4l2:outfmt=yuy2:normid=5:fps=25:width=768:height=578:brightness=20:contrast=0:saturation=100:freq=225.250:fps=25:audiorate=48000:amode=1:alsa:adevice=default -vf scale=512:384,pp=de -ffourcc DX50 -ovc lavc -lavcopts vcodec=mpeg4:vbitrate=2000:keyint=250  -oac mp3lame -lameopts cbr:br=128:mode=0 -o /home/users/graffi/tvp1_`date "+%s"`.avi                                                
MEncoder SVN-r30554-4.3.4 (C) 2000-2010 MPlayer Team                                                                                            
success: format: 9  data: 0x0 - 0x0                                                                                                             
TV file format detected.                                                                                                                        
Selected driver: v4l2                                                                                                                           
 name: Video 4 Linux 2 input                                                                                                                    
 author: Martin Olschewski <olschewski@zpr.uni-koeln.de>                                                                                        
 comment: first try, more to come ;-)                                                                                                           
Selected device: Leadtek Winfast 2000XP Expert                                                                                                  
 Tuner cap: STEREO LANG1 LANG2                                                                                                                  
 Tuner rxs: MONO STEREO                                                                                                                         
 Capabilites:  video capture  VBI capture device  tuner  read/write  streaming                                                                  
 supported norms: 0 = NTSC-M; 1 = NTSC-M-JP; 2 = NTSC-443; 3 = PAL-BG; 4 = PAL-I; 5 = PAL-DK; 6 = PAL-M; 7 = PAL-N; 8 = PAL-Nc; 9 = PAL-60; 10 = SECAM-B; 11 = SECAM-G; 12 = SECAM-H; 13 = SECAM-DK; 14 = SECAM-L;                                                                                            
 inputs: 0 = Television; 1 = Composite1; 2 = S-Video;                                                                                                  
 Current input: 0                                                                                                                                      
 Current format: BGR24                                                                                                                                 
v4l2: current audio mode is : STEREO                                                                                                                   
ALSA lib confmisc.c:768:(parse_card) cannot find card '0'                                                                                              
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_card_driver returned error: No such file or directory                                    
ALSA lib confmisc.c:392:(snd_func_concat) error evaluating strings                                                                                     
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_concat returned error: No such file or directory                                         
ALSA lib confmisc.c:1251:(snd_func_refer) error evaluating name                                                                                        
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_refer returned error: No such file or directory                                          
ALSA lib conf.c:4633:(snd_config_expand) Evaluate error: No such file or directory                                                                     
ALSA lib pcm.c:2211:(snd_pcm_open_noupdate) Unknown PCM default                                                                                        
Error opening audio: No such file or directory                                                                                                         
ALSA lib confmisc.c:768:(parse_card) cannot find card '0'                                                                                              
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_card_driver returned error: No such file or directory
ALSA lib confmisc.c:392:(snd_func_concat) error evaluating strings
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_concat returned error: No such file or directory
ALSA lib confmisc.c:1251:(snd_func_refer) error evaluating name
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_refer returned error: No such file or directory
ALSA lib conf.c:4633:(snd_config_expand) Evaluate error: No such file or directory
ALSA lib pcm.c:2211:(snd_pcm_open_noupdate) Unknown PCM default
Error opening audio: No such file or directory
ALSA lib confmisc.c:768:(parse_card) cannot find card '0'
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_card_driver returned error: No such file or directory
ALSA lib confmisc.c:392:(snd_func_concat) error evaluating strings
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_concat returned error: No such file or directory
ALSA lib confmisc.c:1251:(snd_func_refer) error evaluating name
ALSA lib conf.c:4154:(_snd_config_evaluate) function snd_func_refer returned error: No such file or directory
ALSA lib conf.c:4633:(snd_config_expand) Evaluate error: No such file or directory
ALSA lib pcm.c:2211:(snd_pcm_open_noupdate) Unknown PCM default
Error opening audio: No such file or directory
v4l2: 0 frames successfully processed, 0 frames dropped.
============ Sorry, this file format is not recognized/supported =============
=== If this file is an AVI, ASF or MPEG stream, please contact the author! ===
Cannot open demuxer.

Exiting...
drekmore ~ $

karta chodzi mi na sterowniku: Conexant 2388x
a dokładnie co pluje lspci masz w pierwszej mojej wypowiedzi :)

ilin · 2010-02-18 09:06:52

Pomijając kłopoty z alsą.

Pokaż

Kod:

mencoder -ovc help

Oraz

Kod:

mencoder -vf help

Graffi · 2010-02-18 20:40:45

Kod:

drekmore ~ $ mencoder -ovc help                 
MEncoder SVN-r30554-4.3.4 (C) 2000-2010 MPlayer Team

Available codecs:
   copy     - frame copy, without re-encoding. Doesn't work with filters.
   frameno  - special audio-only file for 3-pass encoding, see DOCS.     
   raw      - uncompressed video. Use fourcc option to set format explicitly.
   lavc     - libavcodec codecs - best quality!                              
   vfw      - VfW DLLs, read DOCS/HTML/en/encoding-guide.html.               
   qtvideo  - QuickTime DLLs, currently only SVQ1/3 are supported.           
   libdv    - DV encoding with libdv v0.9.5                                  
   xvid     - XviD encoding                                                  
   x264     - H.264 encoding

i...

Kod:

drekmore ~ $ mencoder -vf help
Available video filters:      
  rectangle      : draw rectangle
  bmovl          : Read bitmaps from a FIFO and display them in window
  crop           : cropping                                           
  expand         : expanding & osd                                    
  pp             : postprocessing                                     
  scale          : software scaling                                   
  vo             : libvo wrapper                                      
  format         : force output format                                
  noformat       : disallow one output format                         
  yuy2           : fast YV12/Y422p -> YUY2 conversion                 
  flip           : flip image upside-down                             
  rgb2bgr        : fast 24/32bpp RGB<->BGR conversion                 
  rotate         : rotate                                             
  mirror         : horizontal mirror                                  
  palette        : 8bpp indexed (using palette) -> BGR 15/16/24/32 conversion
  pp7            : postprocess 7                                             
  lavc           : realtime mpeg1 encoding with libavcodec                   
  lavcdeint      : libavcodec's deinterlacing filter                         
  screenshot     : screenshot to file                                        
  dvbscale       : calc Y scaling for DVB card                               
  cropdetect     : autodetect crop size                                      
  test           : test pattern generator                                    
  noise          : noise generator                                           
  yvu9           : fast YVU9->YV12 conversion                                
  eq             : soft video equalizer                                      
  eq2            : Software equalizer                                        
  gradfun        : gradient deband                                           
  halfpack       : yuv planar 4:2:0 -> packed 4:2:2, half height             
  dint           : drop interlaced frames                                    
  1bpp           : 1bpp bitmap -> YUV/BGR 8/15/16/32 conversion              
  2xsai          : 2xSai BGR bitmap 2x scaler                                
  unsharp        : unsharp mask & gaussian blur                              
  swapuv         : UV swapper                                                
  il             : (de)interleave                                            
  fil            : fast (de)interleaver                                      
  boxblur        : box blur                                                  
  sab            : shape adaptive blur                                       
  smartblur      : smart blur                                                
  perspective    : perspective correcture                                    
  down3dright    : convert stereo movie from top-bottom to left-right field  
  field          : extract single field                                      
  denoise3d      : 3D Denoiser (variable lowpass filter)                     
  hqdn3d         : High Quality 3D Denoiser                                  
  detc           : de-telecine filter                                        
  telecine       : telecine filter                                           
  tinterlace     : temporal field interlacing                                
  tfields        : temporal field separation                                 
  ivtc           : inverse telecine, take 2                                  
  ilpack         : 4:2:0 planar -> 4:2:2 packed reinterlacer                 
  dsize          : reset displaysize/aspect                                  
  decimate       : near-duplicate frame remover                              
  softpulldown   : mpeg2 soft 3:2 pulldown                                   
  pullup         : pullup (from field sequence to frames)                    
  filmdint       : Advanced inverse telecine filer                           
  framestep      : Dump one every n / key frames                             
  tile           : Make a single image tiling x/y images                     
  delogo         : simple logo remover                                       
  remove-logo    : Removes a tv logo based on a mask image.                  
  hue            : hue changer                                               
  spp            : simple postprocess                                        
  uspp           : ultra simple/slow postprocess                             
  fspp           : fast simple postprocess                                   
  qp             : QP changer                                                
  mcdeint        : motion compensating deinterlacer                          
  geq            : generic equation filter                                   
  yuvcsp         : yuv colorspace converter                                  
  kerndeint      : Kernel Deinterlacer                                       
  rgbtest        : rgbtest                                                   
  phase          : phase shift fields                                        
  divtc          : inverse telecine for deinterlaced video                   
  harddup        : resubmit duplicate frames for encoding                    
  softskip       : soft (post-filter) frame skipping for encoding            
  ass            : Render ASS/SSA subtitles                                  
  yadif          : Yet Another DeInterlacing Filter                          
  blackframe     : detects black frames                                      
  ow             : overcomplete wavelet denoiser                             

MEncoder SVN-r30554-4.3.4 (C) 2000-2010 MPlayer Team
Available video filters:                            
  rectangle      : draw rectangle                   
  bmovl          : Read bitmaps from a FIFO and display them in window
  crop           : cropping                                           
  expand         : expanding & osd                                    
  pp             : postprocessing                                     
  scale          : software scaling                                   
  vo             : libvo wrapper                                      
  format         : force output format                                
  noformat       : disallow one output format                         
  yuy2           : fast YV12/Y422p -> YUY2 conversion                 
  flip           : flip image upside-down                             
  rgb2bgr        : fast 24/32bpp RGB<->BGR conversion                 
  rotate         : rotate                                             
  mirror         : horizontal mirror                                  
  palette        : 8bpp indexed (using palette) -> BGR 15/16/24/32 conversion
  pp7            : postprocess 7                                             
  lavc           : realtime mpeg1 encoding with libavcodec                   
  lavcdeint      : libavcodec's deinterlacing filter                         
  screenshot     : screenshot to file                                        
  dvbscale       : calc Y scaling for DVB card                               
  cropdetect     : autodetect crop size                                      
  test           : test pattern generator                                    
  noise          : noise generator                                           
  yvu9           : fast YVU9->YV12 conversion                                
  eq             : soft video equalizer                                      
  eq2            : Software equalizer                                        
  gradfun        : gradient deband                                           
  halfpack       : yuv planar 4:2:0 -> packed 4:2:2, half height             
  dint           : drop interlaced frames                                    
  1bpp           : 1bpp bitmap -> YUV/BGR 8/15/16/32 conversion              
  2xsai          : 2xSai BGR bitmap 2x scaler                                
  unsharp        : unsharp mask & gaussian blur                              
  swapuv         : UV swapper                                                
  il             : (de)interleave                                            
  fil            : fast (de)interleaver                                      
  boxblur        : box blur                                                  
  sab            : shape adaptive blur                                       
  smartblur      : smart blur                                                
  perspective    : perspective correcture                                    
  down3dright    : convert stereo movie from top-bottom to left-right field  
  field          : extract single field                                      
  denoise3d      : 3D Denoiser (variable lowpass filter)                     
  hqdn3d         : High Quality 3D Denoiser                                  
  detc           : de-telecine filter                                        
  telecine       : telecine filter                                           
  tinterlace     : temporal field interlacing                                
  tfields        : temporal field separation                                 
  ivtc           : inverse telecine, take 2                                  
  ilpack         : 4:2:0 planar -> 4:2:2 packed reinterlacer                 
  dsize          : reset displaysize/aspect                                  
  decimate       : near-duplicate frame remover                              
  softpulldown   : mpeg2 soft 3:2 pulldown                                   
  pullup         : pullup (from field sequence to frames)                    
  filmdint       : Advanced inverse telecine filer                           
  framestep      : Dump one every n / key frames
  tile           : Make a single image tiling x/y images
  delogo         : simple logo remover
  remove-logo    : Removes a tv logo based on a mask image.
  hue            : hue changer
  spp            : simple postprocess
  uspp           : ultra simple/slow postprocess
  fspp           : fast simple postprocess
  qp             : QP changer
  mcdeint        : motion compensating deinterlacer
  geq            : generic equation filter
  yuvcsp         : yuv colorspace converter
  kerndeint      : Kernel Deinterlacer
  rgbtest        : rgbtest
  phase          : phase shift fields
  divtc          : inverse telecine for deinterlaced video
  harddup        : resubmit duplicate frames for encoding
  softskip       : soft (post-filter) frame skipping for encoding
  ass            : Render ASS/SSA subtitles
  yadif          : Yet Another DeInterlacing Filter
  blackframe     : detects black frames
  ow             : overcomplete wavelet denoiser

ilin · 2010-02-18 21:31:11

Nie rozumiem dlaczego to nie działa.
Kodeki i filtry są u mnie tak samo.
Sam zobacz.

Kod:

ilin@debian ~/Desktop % mencoder -ovc help
MPlayer SVN-r30075 (C) 2000-2009 MPlayer Team

Available codecs:
   copy     - frame copy, without re-encoding. Doesn't work with filters.
   frameno  - special audio-only file for 3-pass encoding, see DOCS.
   raw      - uncompressed video. Use fourcc option to set format explicitly.
   nuv      - nuppel video
   lavc     - libavcodec codecs - best quality!
   vfw      - VfW DLLs, read DOCS/HTML/en/encoding-guide.html.
   qtvideo  - QuickTime DLLs, currently only SVQ1/3 are supported.
   libdv    - DV encoding with libdv v0.9.5
   xvid     - XviD encoding
   x264     - H.264 encoding

Kod:

ilin@debian ~/Desktop % mencoder -vf help
Available video filters:
  rectangle      : draw rectangle
  bmovl          : Read bitmaps from a FIFO and display them in window
  crop           : cropping
  expand         : expanding & osd
  pp             : postprocessing
  scale          : software scaling
  vo             : libvo wrapper
  format         : force output format
  noformat       : disallow one output format
  yuy2           : fast YV12/Y422p -> YUY2 conversion
  flip           : flip image upside-down
  rgb2bgr        : fast 24/32bpp RGB<->BGR conversion
  rotate         : rotate
  mirror         : horizontal mirror
  palette        : 8bpp indexed (using palette) -> BGR 15/16/24/32 conversion
  pp7            : postprocess 7
  lavc           : realtime mpeg1 encoding with libavcodec
  lavcdeint      : libavcodec's deinterlacing filter
  screenshot     : screenshot to file
  zrmjpeg        : realtime zoran MJPEG encoding
  dvbscale       : calc Y scaling for DVB card
  cropdetect     : autodetect crop size
  test           : test pattern generator
  noise          : noise generator
  yvu9           : fast YVU9->YV12 conversion
  eq             : soft video equalizer
  eq2            : Software equalizer
  gradfun        : gradient deband
  halfpack       : yuv planar 4:2:0 -> packed 4:2:2, half height
  dint           : drop interlaced frames
  1bpp           : 1bpp bitmap -> YUV/BGR 8/15/16/32 conversion
  2xsai          : 2xSai BGR bitmap 2x scaler
  unsharp        : unsharp mask & gaussian blur
  swapuv         : UV swapper
  il             : (de)interleave
  fil            : fast (de)interleaver
  boxblur        : box blur
  sab            : shape adaptive blur
  smartblur      : smart blur
  perspective    : perspective correcture
  down3dright    : convert stereo movie from top-bottom to left-right field
  field          : extract single field
  denoise3d      : 3D Denoiser (variable lowpass filter)
  hqdn3d         : High Quality 3D Denoiser
  detc           : de-telecine filter
  telecine       : telecine filter
  tinterlace     : temporal field interlacing
  tfields        : temporal field separation
  ivtc           : inverse telecine, take 2
  ilpack         : 4:2:0 planar -> 4:2:2 packed reinterlacer
  dsize          : reset displaysize/aspect
  decimate       : near-duplicate frame remover
  softpulldown   : mpeg2 soft 3:2 pulldown
  pullup         : pullup (from field sequence to frames)
  filmdint       : Advanced inverse telecine filer
  framestep      : Dump one every n / key frames
  tile           : Make a single image tiling x/y images
  delogo         : simple logo remover
  remove-logo    : Removes a tv logo based on a mask image.
  hue            : hue changer
  spp            : simple postprocess
  uspp           : ultra simple/slow postprocess
  fspp           : fast simple postprocess
  qp             : QP changer
  mcdeint        : motion compensating deinterlacer
  geq            : generic equation filter
  yuvcsp         : yuv colorspace converter
  kerndeint      : Kernel Deinterlacer
  rgbtest        : rgbtest
  phase          : phase shift fields
  divtc          : inverse telecine for deinterlaced video
  harddup        : resubmit duplicate frames for encoding
  softskip       : soft (post-filter) frame skipping for encoding
  ass            : Render ASS/SSA subtitles
  yadif          : Yet Another DeInterlacing Filter
  blackframe     : detects black frames
  ow             : overcomplete wavelet denoiser

MPlayer SVN-r30075 (C) 2000-2009 MPlayer Team
Available video filters:
  rectangle      : draw rectangle
  bmovl          : Read bitmaps from a FIFO and display them in window
  crop           : cropping
  expand         : expanding & osd
  pp             : postprocessing
  scale          : software scaling
  vo             : libvo wrapper
  format         : force output format
  noformat       : disallow one output format
  yuy2           : fast YV12/Y422p -> YUY2 conversion
  flip           : flip image upside-down
  rgb2bgr        : fast 24/32bpp RGB<->BGR conversion
  rotate         : rotate
  mirror         : horizontal mirror
  palette        : 8bpp indexed (using palette) -> BGR 15/16/24/32 conversion
  pp7            : postprocess 7
  lavc           : realtime mpeg1 encoding with libavcodec
  lavcdeint      : libavcodec's deinterlacing filter
  screenshot     : screenshot to file
  zrmjpeg        : realtime zoran MJPEG encoding
  dvbscale       : calc Y scaling for DVB card
  cropdetect     : autodetect crop size
  test           : test pattern generator
  noise          : noise generator
  yvu9           : fast YVU9->YV12 conversion
  eq             : soft video equalizer
  eq2            : Software equalizer
  gradfun        : gradient deband
  halfpack       : yuv planar 4:2:0 -> packed 4:2:2, half height
  dint           : drop interlaced frames
  1bpp           : 1bpp bitmap -> YUV/BGR 8/15/16/32 conversion
  2xsai          : 2xSai BGR bitmap 2x scaler
  unsharp        : unsharp mask & gaussian blur
  swapuv         : UV swapper
  il             : (de)interleave
  fil            : fast (de)interleaver
  boxblur        : box blur
  sab            : shape adaptive blur
  smartblur      : smart blur
  perspective    : perspective correcture
  down3dright    : convert stereo movie from top-bottom to left-right field
  field          : extract single field
  denoise3d      : 3D Denoiser (variable lowpass filter)
  hqdn3d         : High Quality 3D Denoiser
  detc           : de-telecine filter
  telecine       : telecine filter
  tinterlace     : temporal field interlacing
  tfields        : temporal field separation
  ivtc           : inverse telecine, take 2
  ilpack         : 4:2:0 planar -> 4:2:2 packed reinterlacer
  dsize          : reset displaysize/aspect
  decimate       : near-duplicate frame remover
  softpulldown   : mpeg2 soft 3:2 pulldown
  pullup         : pullup (from field sequence to frames)
  filmdint       : Advanced inverse telecine filer
  framestep      : Dump one every n / key frames
  tile           : Make a single image tiling x/y images
  delogo         : simple logo remover
  remove-logo    : Removes a tv logo based on a mask image.
  hue            : hue changer
  spp            : simple postprocess
  uspp           : ultra simple/slow postprocess
  fspp           : fast simple postprocess
  qp             : QP changer
  mcdeint        : motion compensating deinterlacer
  geq            : generic equation filter
  yuvcsp         : yuv colorspace converter
  kerndeint      : Kernel Deinterlacer
  rgbtest        : rgbtest
  phase          : phase shift fields
  divtc          : inverse telecine for deinterlaced video
  harddup        : resubmit duplicate frames for encoding
  softskip       : soft (post-filter) frame skipping for encoding
  ass            : Render ASS/SSA subtitles
  yadif          : Yet Another DeInterlacing Filter
  blackframe     : detects black frames
  ow             : overcomplete wavelet denoiser

Nagrywanie zaś.

Kod:

ilin@debian ~/XDTV % mencoder tv:// -tv device=/dev/video0:driver=v4l2:outfmt=yuy2:normid=5:fps=25:width=768:height=578:brightness=20:contrast=0:saturation=100:freq=711.600:fps=25:audiorate=48000:amode=1:alsa:adevice=default -vf scale=512:384,pp=de -ffourcc DX50 -ovc lavc -lavcopts vcodec=mpeg4:vbitrate=2000:keyint=250  -oac mp3lame -lameopts cbr:br=128:mode=0 -o /home/ilin/XDTV/tvp1_`date "+%s"`.avi
MPlayer SVN-r30075 (C) 2000-2009 MPlayer Team
success: format: 9  data: 0x0 - 0x0
TV file format detected.
Selected driver: v4l2
 name: Video 4 Linux 2 input
 author: Martin Olschewski <olschewski@zpr.uni-koeln.de>
 comment: first try, more to come ;-)
Selected device: PixelView PlayTV Ultra Pro (Ste
 Tuner cap: STEREO LANG1 LANG2
 Tuner rxs: MONO STEREO
 Capabilites:  video capture  VBI capture device  tuner  read/write  streaming
 supported norms: 0 = NTSC-M; 1 = NTSC-M-JP; 2 = NTSC-443; 3 = PAL-BG; 4 = PAL-I; 5 = PAL-DK; 6 = PAL-M; 7 = PAL-N; 8 = PAL-Nc; 9 = PAL-60; 10 = SECAM-B; 11 = SECAM-G; 12 = SECAM-H; 13 = SECAM-DK; 14 = SECAM-L;
 inputs: 0 = Television; 1 = Composite1; 2 = S-Video;
 Current input: 0
 Current format: BGR24
v4l2: current audio mode is : STEREO
[V] filefmt:9  fourcc:0x32595559  size:768x576  fps:25.000  ftime:=0.0400
==========================================================================
Opening audio decoder: [pcm] Uncompressed PCM audio decoder
AUDIO: 48000 Hz, 2 ch, s16le, 1536.0 kbit/100.00% (ratio: 192000->192000)
Selected audio codec: [pcm] afm: pcm (Uncompressed PCM)
==========================================================================
Opening video filter: [expand osd=1]
Expand: -1 x -1, -1 ; -1, osd: 1, aspect: 0.000000, round: 1
Opening video filter: [pp=de]
Opening video filter: [scale w=512 h=384]
==========================================================================
Opening video decoder: [raw] RAW Uncompressed Video
[PP] Using external postprocessing filter, max q = 6.
Movie-Aspect is undefined - no prescaling applied.
[swscaler @ 0xab65ca0]BICUBIC scaler, from yuyv422 to yuv420p using MMX2
videocodec: libavcodec (512x384 fourcc=34504d46 [FMP4])
Selected video codec: [rawyuy2] vfm: raw (RAW YUY2)
==========================================================================
Forcing output FourCC to 30355844 [DX50].
MP3 audio selected.
Forcing audio preload to 0, max pts correction to 0.
Writing header...1f ( 0%)  0.00fps Trem:   0min   0mb  A-V:0.000 [0:0]
ODML: Aspect information not (yet?) available or unspecified, not writing vprp header.
Writing header...
ODML: Aspect information not (yet?) available or unspecified, not writing vprp header.
^CPos:  31.4s    785f ( 0%) 24.90fps Trem:   0min   0mb  A-V:0.000 [1992:128]
Flushing video frames.
Writing index...
Writing header...
ODML: Aspect information not (yet?) available or unspecified, not writing vprp header.

Video stream: 1992.452 kbit/s  (249056 B/s)  size: 7820376 bytes  31.400 secs  785 frames

Audio stream:  128.000 kbit/s  (16000 B/s)  size: 501888 bytes  31.368 secs
v4l2: 788 frames successfully processed, 0 frames dropped.
mencoder tv:// -tv  -vf scale=512:384,pp=de -ffourcc DX50 -ovc lavc -lavcopts  22,21s user 2,69s system 77% cpu 32,135 total

Śmiga.

Graffi · 2010-02-18 21:37:25

kurde... :(

ja nie wiem czemu mplayer jakby wogóle TV nie umiał oglądać :>
bo w ttv mogę sobie kanały zmieniać, na głośniki idzie mi głos więc karta działa, a w mplayerze mam cały czas szum i szym...
(to pomijając nienagrywanie, ale wogóle nie otwiera TV dobrze)

ilin · 2010-02-18 21:39:19

Jeśli mplayer nie odtworzy to i mencoder nie nagra.
Może jest bug jakiś w tej wersji mplayera.

Ja mam jak widać ciut starszą debianową wersję.

sal_i · 2010-02-19 08:10:19

a skoro to gentoo to z flagami USE dla mplayera wszystko okej?

Graffi · 2010-02-19 08:17:55

pytałem o to samo, ogólnie to tak wysypałem wczoraj podczas aktualizacji to gentoo że jak sobie nie poradzę z poinstalowaniem pakietów to sformatuję go na debiana pewnie

rulezdc · 2010-02-20 21:50:51

Witam
Tak się podłącze pod wątek. Wrzuciłem sobie polecenie mencoder-a od ilina do siebie i niestety nie mam dźwięku gdy już puszczam sobie nagrany materiał, jednak podczas nagrywania słyszę dźwięk
Moja karta jest następująca:

Kod:

 01:09.0 Multimedia video controller: Conexant CX23880/1/2/3 PCI Video and Audio Decoder (rev 05)

po poleceniu ilina mam takie dane na konsoli:

Kod:

MEncoder dev-SVN-r26940 (C) 2000-2008 MPlayer Team
CPU: AMD Athlon(tm) Dual Core Processor 4850e (Family: 15, Model: 107, Stepping: 2)
CPUflags: Type: 15 MMX: 1 MMX2: 1 3DNow: 1 3DNow2: 1 SSE: 1 SSE2: 1
Compiled with runtime CPU detection.
success: format: 9  data: 0x0 - 0x0
TV file format detected.
Selected driver: v4l2
 name: Video 4 Linux 2 input
 author: Martin Olschewski <olschewski@zpr.uni-koeln.de>
 comment: first try, more to come ;-)
Selected device: AverTV Studio 303 (M126)
 Tuner cap:
 Tuner rxs:
 Capabilites:  video capture  VBI capture device  tuner  read/write  streaming
 supported norms: 0 = NTSC-M; 1 = NTSC-M-JP; 2 = NTSC-443; 3 = PAL-BG; 4 = PAL-I; 5 = PAL-DK; 6 = PAL-M; 7 = PAL-N; 8 = PAL-Nc; 9 = PAL-60; 10 = SECAM-DK; 11 = SECAM-L;
 inputs: 0 = Television; 1 = Composite1; 2 = S-Video;
 Current input: 0
 Current format: BGR24
v4l2: current audio mode is : STEREO
Audio block size too low, setting to 16384!
[V] filefmt:9  fourcc:0x32595559  size:768x576  fps:25.000  ftime:=0.0400
==========================================================================
Opening audio decoder: [pcm] Uncompressed PCM audio decoder
AUDIO: 48000 Hz, 2 ch, s16le, 1536.0 kbit/100.00% (ratio: 192000->192000)
Selected audio codec: [pcm] afm: pcm (Uncompressed PCM)
==========================================================================
Opening video filter: [expand osd=1]
Expand: -1 x -1, -1 ; -1, osd: 1, aspect: 0.000000, round: 1
Opening video filter: [pp=de]
Opening video filter: [scale w=512 h=384]
==========================================================================
Opening video decoder: [raw] RAW Uncompressed Video
VDec: vo config request - 768 x 576 (preferred colorspace: Packed YUY2)
[PP] Using external postprocessing filter, max q = 6.
VDec: using Packed YUY2 as output csp (no 0)
Movie-Aspect is undefined - no prescaling applied.
SwScaler: reducing / aligning filtersize 7 -> 8
SwScaler: reducing / aligning filtersize 7 -> 8
SwScaler: reducing / aligning filtersize 7 -> 6
SwScaler: reducing / aligning filtersize 13 -> 11
[swscaler @ 0xa1e810]BICUBIC scaler, from yuyv422 to yuv420p using MMX2
[swscaler @ 0xa1e810]using 8-tap MMX scaler for horizontal luminance scaling
[swscaler @ 0xa1e810]using 8-tap MMX scaler for horizontal chrominance scaling
[swscaler @ 0xa1e810]using n-tap MMX scaler for vertical scaling (YV12 like)
[swscaler @ 0xa1e810]768x576 -> 512x384
videocodec: libavcodec (512x384 fourcc=34504d46 [FMP4])
Selected video codec: [rawyuy2] vfm: raw (RAW YUY2)
==========================================================================
Forcing output FourCC to 30355844 [DX50].
MP3 audio selected.
Forcing audio preload to 0, max pts correction to 0.
New_Face failed. Maybe the font path is wrong.
Please supply the text font file (~/.mplayer/subfont.ttf).
subtitle font: load_sub_face failed.
New_Face failed. Maybe the font path is wrong.
Please supply the text font file (~/.mplayer/subfont.ttf).
subtitle font: load_sub_face failed.
Writing header...
ODML: Aspect information not (yet?) available or unspecified, not writing vprp header.
Writing header...
ODML: Aspect information not (yet?) available or unspecified, not writing vprp header.
^C
Flushing video frames.
Writing index...
Writing header...
ODML: Aspect information not (yet?) available or unspecified, not writing vprp header.

Video stream: 1981.491 kbit/s  (247686 B/s)  size: 8817635 bytes  35.600 secs  889 frames

Audio stream:  128.000 kbit/s  (16000 B/s)  size: 569088 bytes  35.568 secs
v4l2: 892 frames successfully processed, -890 frames dropped.

próbowałem już zmieniać ustawienia dźwięku z alsa:adevice=default na adevice=/dev/dsp i zawsze to samo
Dźwięk podczas nagrywania słyszę, podczas odtwarzania nie, jednak zauważyłem,że przy odtwarzaniu słyszę dźwięk z mikrofonu i to mnie dziwi
Może specu ilin się wypowie
Pozdrawiam

ilin · 2010-02-20 23:03:19

Musisz pobawić się alsamixerem.

Od nagrywania suwak to nie ten od glośnosci.
Jest to pod inną pozycją i sam musisz wyczuć który za to odpowiada.
U mnie obecnie jest suwak Capture ale na poprzedniej karcie dźwiękowej inaczej się on nazywał

Graffi · 2010-02-21 20:46:13

masz tam w alsamikser karty z suwakami
F3 - odtwarzanie
F4 - nagrywanie
F5 - wszystkie

jak wejdziesz na F4 to spacją wybierasz z którego kanału ma Ci nagrywać ;)
przynajmniej tak to u mnie działa

aha...
przeinstralowałem Gentoo na Debiana póki co...
zdobędę sobie drugą taką samą płytę główną jak na tym kompie tutaj co opisywałem problemy z mplayerem i powalczę z Gentoo na maszynie która nie jest dla mnie "produkcyjna" ;)

Graffi · 2010-03-19 21:14:01

no i ponownie zainstalowałem Gentoo....
namęczyłem sie już dużo dużo...
mam (miałem :> ) od nowa dosyć tego wszystkiego...
no i [żarówa] oświeciło mnie [świetłówka energooszczędna zawierająca rtęć - ponoć to ekologiczne :P ] a mianowicie użytkownik "graffi" nie miał praw do dostępu do urządzenia audio ;( wystarczyło dodać mnie to grupy audio i zaczął mencoder nagrywać :D

rozwiązanie problemu u mnie:

Kod:

usermod -G graffi audio

tak jakby się to miało komuś przydać może :)
a może mi kiedyś... ;)

a przy okazji, jak użytkownika dodać do kilku grup?
bo jak sobie się dodam do audio to mnie wywala z video :(
problem rozwiązałem tymczasowo tak że dałem 666 dla /dev/video0 ale to nie jest ładnie rozwiązane...
polecenie [b]usermod -G[/b] niby mnie dodaje do jakieś grupy ale przy okazji wywala z innej... :>

Kod:

drekmore ~ $ id
uid=1000(graffi) gid=100(users) groups=18(audio),100(users)
drekmore ~ $

ilin · 2010-03-19 21:25:39

Nie wiem jak to w gentoo jest ale dopisz sie ręcznie gdzies tam w /etc
W debianie w /etc/group

sal_i · 2010-03-20 08:23:26

Kod:

# usermod -aG <grupa> <login>

ewentualnie można wymienić wszystkie grupy do których user już należy (po przecinku i bez spacji) ale to jest głupie rozwiązanie

Graffi · 2010-03-20 12:33:21

przeedytowałem /etc/group ;)
wydało się to najprostrze na chwilą obecną (na szybko :] )

Time (s)	Query
0.00022	SET CHARSET latin2
0.00007	SET NAMES latin2
0.00194	SELECT u., g., o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='3.15.221.67' WHERE u.id=1
0.00325	REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.15.221.67', 1714225987)
0.00039	SELECT * FROM punbb_online WHERE logged<1714225687
0.00120	DELETE FROM punbb_online WHERE ident='47.128.119.234'
0.00037	SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=16139 AND t.moved_to IS NULL
0.00033	SELECT search_for, replace_with FROM punbb_censoring
0.00502	SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=16139 ORDER BY p.id LIMIT 0,25
0.00174	UPDATE punbb_topics SET num_views=num_views+1 WHERE id=16139
Total query time: 0.01453 s

Forum Debian Users Gang

Ogłoszenie

#1 2010-02-17 22:04:58

Graffi - Użytkownik

gentoo / mencoder / TV

Kod:

Kod:

Kod:

Kod:

#2 2010-02-17 22:12:25

ilin - Palacz

Re: gentoo / mencoder / TV

Kod:

#3 2010-02-17 22:19:41

Graffi - Użytkownik

Re: gentoo / mencoder / TV

Kod:

#4 2010-02-17 22:33:31

ilin - Palacz

Re: gentoo / mencoder / TV

Kod:

#5 2010-02-17 22:53:34

Graffi - Użytkownik

Re: gentoo / mencoder / TV

Kod:

#6 2010-02-17 23:05:51

ilin - Palacz

Re: gentoo / mencoder / TV

#7 2010-02-18 07:31:53

Graffi - Użytkownik

Re: gentoo / mencoder / TV

#8 2010-02-18 08:40:26

ilin - Palacz

Re: gentoo / mencoder / TV

#9 2010-02-18 08:57:42

Graffi - Użytkownik

Re: gentoo / mencoder / TV

Kod:

#10 2010-02-18 09:06:52

ilin - Palacz

Re: gentoo / mencoder / TV

Kod:

Kod:

#11 2010-02-18 20:40:45

Graffi - Użytkownik

Re: gentoo / mencoder / TV

Kod:

Kod:

#12 2010-02-18 21:31:11

ilin - Palacz

Re: gentoo / mencoder / TV

Kod:

Kod:

Kod:

#13 2010-02-18 21:37:25

Graffi - Użytkownik

Re: gentoo / mencoder / TV

#14 2010-02-18 21:39:19

ilin - Palacz

Re: gentoo / mencoder / TV

#15 2010-02-19 08:10:19

sal_i - Członek DUG

Re: gentoo / mencoder / TV

#16 2010-02-19 08:17:55

Graffi - Użytkownik

Re: gentoo / mencoder / TV

#17 2010-02-20 21:50:51

rulezdc - Członek DUG

Re: gentoo / mencoder / TV

Kod:

Kod:

#18 2010-02-20 23:03:19

ilin - Palacz

Re: gentoo / mencoder / TV

#19 2010-02-21 20:46:13

Graffi - Użytkownik

Re: gentoo / mencoder / TV

#20 2010-03-19 21:14:01

Graffi - Użytkownik

Re: gentoo / mencoder / TV