Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Witam
Wczoraj skompilowalem ze zrodelm mplayera. Zrobilem wszystko wg instruckji. W katalogu /usr/lib stworzylem katalog codecs, do ktorego rozpakowalem kodeki. Nastepnie wydalem polecenie
./configure --language=pl --enable-gui
Jako, ze nei bylo zadnych bledow to nastepnie wpisalem
make make install
Potem do katalogu /home/nocturn/.mplayer przekopiowalem pliki codecs.conf i input.conf
Wszystko ladnie pieknie i mplayer ladnie smiga. Jednakze, chcialem rowniez miec wersje okienkowa. Wiec sciagnalem sobie skorke i odpalilem gmplayera. Pojawia sie okienko i wszystko ladnie pieknie wyglada, jednakze nie moge odtwarzac zadnych filmow gdyz wyrzuca blad
Blad przy otwieraniu/inicjalizacji wybranego urzadzenia video (-vo)
WYdaje mi sie to co najmniej dziwne, skoro gmplayer to tylko nakladka graficzna na mplayera wiec ustawienia konfiguracyjne powinein miec takie same.
Aha w katalogu /home/nocturn/.mplayer znajduje sie plik konfiguracyjny config, jednak jest on pusty. Znajduje sie tam rowniez plik konfiguracyjny gui.conf, ktorego zawartosc wyglada nastepujaco.
enable_audio_equ = "no" vo_panscan = "0.000000" vo_doublebuffering = "yes" vo_direct_render = "no" v_framedrop = "0" v_flip = "-1" v_ni = "no" v_idx = "-1" vf_pp = "no" vf_autoq = "0" vf_lavc = "no" ao_volnorm = "no" softvol = "no" ao_surround = "no" ao_extra_stereo = "no" ao_extra_stereo_coefficient = "1.000000" osd_level = "1" sub_auto_load = "yes" sub_unicode = "no" ass_enabled = "no" ass_use_margins = "no" ass_top_margin = "0" ass_bottom_margin = "0" sub_pos = "100" sub_overlap = "no" font_factor = "0.750000" font_text_scale = "5.000000" font_osd_scale = "6.000000" font_blur = "2.000000" font_outline = "2.000000" font_autoscale = "3" cache = "no" cache_size = "2048" playbar = "yes" load_fullscreen = "no" show_videowin = "yes" stopxscreensaver = "no" autosync = "no" autosync_size = "0" gui_skin = "Ater" gui_save_pos = "yes" gui_main_pos_x = "631" gui_main_pos_y = "624" gui_video_out_pos_x = "192" gui_video_out_pos_y = "144" equ_band_00 = "0.000000" equ_band_01 = "0.000000" equ_band_02 = "0.000000" equ_band_03 = "0.000000" equ_band_04 = "0.000000" equ_band_05 = "0.000000" equ_band_06 = "0.000000" equ_band_07 = "0.000000" equ_band_08 = "0.000000" equ_band_09 = "0.000000" equ_band_10 = "0.000000" equ_band_11 = "0.000000" equ_band_12 = "0.000000" equ_band_13 = "0.000000" equ_band_14 = "0.000000" equ_band_15 = "0.000000" equ_band_16 = "0.000000" equ_band_17 = "0.000000" equ_band_18 = "0.000000" equ_band_19 = "0.000000" equ_band_20 = "0.000000" equ_band_21 = "0.000000" equ_band_22 = "0.000000" equ_band_23 = "0.000000" equ_band_24 = "0.000000" equ_band_25 = "0.000000" equ_band_26 = "0.000000" equ_band_27 = "0.000000" equ_band_28 = "0.000000" equ_band_29 = "0.000000" equ_band_30 = "0.000000" equ_band_31 = "0.000000" equ_band_32 = "0.000000" equ_band_33 = "0.000000" equ_band_34 = "0.000000" equ_band_35 = "0.000000" equ_band_36 = "0.000000" equ_band_37 = "0.000000" equ_band_38 = "0.000000" equ_band_39 = "0.000000" equ_band_40 = "0.000000" equ_band_41 = "0.000000" equ_band_42 = "0.000000" equ_band_43 = "0.000000" equ_band_44 = "0.000000" equ_band_45 = "0.000000" equ_band_46 = "0.000000" equ_band_47 = "0.000000" equ_band_48 = "0.000000" equ_band_49 = "0.000000" equ_band_50 = "0.000000" equ_band_51 = "0.000000" equ_band_52 = "0.000000" equ_band_53 = "0.000000" equ_band_54 = "0.000000" equ_band_55 = "0.000000" equ_band_56 = "0.000000" equ_band_57 = "0.000000" equ_band_58 = "0.000000" equ_band_59 = "0.000000"
Offline
To co najważniejsze w tym logu obciąleś. :)
Ustaw sobie sterownik video w gmplayerze na taki jakiego mplayer używa.
Mozesz to wyklikać.
Domyślam się ze musisz ustawić na x11.
Pewnie nie mialeś odpowiednich bibliotek przy kompilacji aby inne sterowniki skompilować.
Trzeba czytać co configure na koniec wypluwa jakie są dostępne wyjscia video i kodeki.
Ostatnio edytowany przez ilin (2009-06-26 14:16:48)
Offline
Wlasnie, ale jak mam sprawdzic jakiego kodeka uzywa mplayer skoro wszystkie configi mplayera sa puste ?
Tutaj wyjscie na konsoli z gmplayer -v film
CPU: Intel(R) Pentium(R) Dual CPU T3200 @ 2.00GHz (Family: 6, Model: 15, Stepping: 13) CPUflags: MMX: 1 MMX2: 1 3DNow: 0 3DNow2: 0 SSE: 1 SSE2: 1 Skompilowano dla procesora x86 z rozszerzeniami: MMX MMX2 SSE SSE2 The -gui option will only work as the first command line argument. X11 opening display: :0.0 vo: X11 color mask: FFFF (R:F800 G:7E0 B:1F) vo: X11 running at 1024x768 with depth 16 and 16 bpp (":0.0" => local display) [x11] Detected wm supports NetWM. [x11] Detected wm supports FULLSCREEN state. [x11] Detected wm supports ABOVE state. [x11] Detected wm supports BELOW state. [x11] Current fstype setting honours FULLSCREEN ABOVE BELOW X atoms Adding filename Scrubs_S1E15.avi && pathname /home/nocturn/Desktop get_path('codecs.conf') -> '/home/nocturn/.mplayer/codecs.conf' Wczytuję /home/nocturn/.mplayer/codecs.conf: kodeki audio 115 & video 237 Configuration: --language=pl --enable-gui WierszPoleceń: '-v' 'Scrubs_S1E15.avi' init_freetype get_path('font/font.desc') -> '/home/nocturn/.mplayer/font/font.desc' font: can't open file: /home/nocturn/.mplayer/font/font.desc font: can't open file: /usr/local/share/mplayer/font/font.desc Using MMX (with tiny bit MMX2) Optimized OnScreenDisplay get_path('fonts') -> '/home/nocturn/.mplayer/fonts' Using nanosleep() timing get_path('input.conf') -> '/home/nocturn/.mplayer/input.conf' Parsing input config file /home/nocturn/.mplayer/input.conf Input config file /home/nocturn/.mplayer/input.conf parsed: 81 binds vo: X11 truecolor visual 0x22, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x23, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x24, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x25, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x3e, depth 32, R:FF0000 G:FF00 B:FF get_path('skins') -> '/home/nocturn/.mplayer/skins' get_path('Skin') -> '/home/nocturn/.mplayer/Skin' SKIN dir 1: '/home/nocturn/.mplayer/skins' SKIN dir 1 (obsolete): '/home/nocturn/.mplayer/Skin' SKIN dir 2: '/usr/local/share/mplayer/skins' SKIN dir 2 (obsolete): '/usr/local/share/mplayer/Skin' vo: X11 truecolor visual 0x22, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x23, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x24, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x25, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x3e, depth 32, R:FF0000 G:FF00 B:FF vo: X11 truecolor visual 0x22, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x23, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x24, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x25, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x3e, depth 32, R:FF0000 G:FF00 B:FF vo: X11 truecolor visual 0x22, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x23, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x24, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x25, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x3e, depth 32, R:FF0000 G:FF00 B:FF vo: X11 truecolor visual 0x22, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x23, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x24, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x25, depth 16, R:F800 G:7E0 B:1F vo: X11 truecolor visual 0x3e, depth 32, R:FF0000 G:FF00 B:FF get_path('subfont.ttf') -> '/home/nocturn/.mplayer/subfont.ttf' [x11] NET style stay on top (layer 0). Using state _NET_WM_STATE_ABOVE. New_Face failed. Maybe the font path is wrong. Please supply the text font file (~/.mplayer/subfont.ttf). subtitle font: load_sub_face failed. get_path('Scrubs_S1E15.avi.conf') -> '/home/nocturn/.mplayer/Scrubs_S1E15.avi.conf' get_path('subfont.ttf') -> '/home/nocturn/.mplayer/subfont.ttf' [x11] NET style stay on top (layer 0). Using state _NET_WM_STATE_ABOVE. New_Face failed. Maybe the font path is wrong. Please supply the text font file (~/.mplayer/subfont.ttf). subtitle font: load_sub_face failed. Odtwarzam /home/nocturn/Desktop/Scrubs_S1E15.avi. get_path('sub/') -> '/home/nocturn/.mplayer/sub/' [file] File size is 183316480 bytes STREAM: [file] /home/nocturn/Desktop/Scrubs_S1E15.avi STREAM: Description: File STREAM: Author: Albeu STREAM: Comment: based on the code from ??? (probably Arpi) LAVF_check: avi format Wykryto format pliku AVI. list_end=0x2292 ======= AVI Header ======= us/frame: 40000 (fps=25.000) max bytes/sec: 0 padding: 0 MainAVIHeader.dwFlags: (272) HAS_INDEX IS_INTERLEAVED frames total: 40765 initial: 0 streams: 2 Suggested BufferSize: 0 Size: 512 x 368 ========================== list_end=0x10F4 ==> Znalazłem strumień video: 0 [aviheader] Video stream found, -vid 0 ====== STREAM Header ===== Type: vids FCC: xvid (64697678) Flags: 0 Priority: 0 Language: 0 InitialFrames: 0 Rate: 25/1 = 25.000 Start: 0 Len: 40765 Suggested BufferSize: 24793 Quality -1 Sample size: 0 ========================== Znalazłem 'bih', 40 bajtów z 40 ======= VIDEO Format ====== biSize 40 biWidth 512 biHeight 368 biPlanes 1 biBitCount 12 biCompression 1145656920='XVID' biSizeImage 1130496 =========================== Regeneruję tabelę klatek kluczowych dla MPEG-4 video. list_end=0x2186 ==> Znalazłem strumień audio: 1 [aviheader] Audio stream found, -aid 1 ====== STREAM Header ===== Type: auds FCC: (0) Flags: 0 Priority: 0 Language: 0 InitialFrames: 1 Rate: 16000/384 = 41.667 Start: 0 Len: 67942 Suggested BufferSize: 8064 Quality -1 Sample size: 384 ========================== Znalazłem 'wf', 30 bajtów z 18 ======= WAVE Format ======= Format Tag: 85 (0x55) Channels: 2 Samplerate: 48000 avg byte/sec: 16000 Block align: 384 bits/sample: 0 cbSize: 12 mp3.wID=1 mp3.fdwFlags=0x2 mp3.nBlockSize=384 mp3.nFramesPerBlock=1 mp3.nCodecDelay=0 ========================================================================== list_end=0x2292 AVI: znalazłem dmlh (rozmiar=248) (razem_klatek=40765) list_end=0x22D0 hdr=Software size=42 Software : FairUse Wizard - http://fairusewizard.com list_end=0xAD94614 Znalazłem film na pozycji 0x280C - 0xAD94614 Czytam blok INDEX, 81519 kawałków na 40765 klatek (fpos=182011420). AVI index offset: 0x2808 (movi=0x280C idx0=0x4 idx1=0x1F8C) Auto-selected AVI audio ID = 1 Auto-selected AVI video ID = 0 AVI: Searching for audio stream (id:1) AVI video size=155238898 (40765) audio size=26089728 (67942) VIDEO: [XVID] 512x368 12bpp 25.000 fps 761.6 kbps (93.0 kbyte/s) [V] filefmt:3 fourcc:0x44495658 size:512x368 fps:25.00 ftime:=0.0400 Informacje o klipie: Software: FairUse Wizard - http://fairusewizard.com get_path('sub/') -> '/home/nocturn/.mplayer/sub/' [x11] NET style stay on top (layer 0). Using state _NET_WM_STATE_ABOVE. [VO_XV] It seems there is no Xvideo support for your video card available. [VO_XV] Run 'xvinfo' to verify its Xv support and read [VO_XV] DOCS/HTML/en/video.html#xv! [VO_XV] See 'mplayer -vo help' for other (non-xv) video out drivers. [VO_XV] Try -vo x11. [x11] NET style stay on top (layer 0). Using state _NET_WM_STATE_ABOVE. Błąd przy otwieraniu/inicjalizacji wybranego urządzenia video (-vo). ========================================================================== Otwieram dekoder audio: [mp3lib] MPEG layer-2, layer-3 dec_audio: Alokuję 4608 + 65536 = 70144 bajtów na bufor wyjściowy. mp3lib: using SSE optimized decore! MP3lib: init layer2&3 finished, tables done MPEG 1.0, Layer III, 48000 Hz 128 kbit Joint-Stereo, BPF: 384 Channels: 2, copyright: No, original: Yes, CRC: No, emphasis: 0 AUDIO: 48000 Hz, 2 ch, s16le, 128.0 kbit/8.33% (ratio: 16000->192000) Wybrany kodek audio: [mp3] afm: mp3lib (mp3lib MPEG layer-2, layer-3) ========================================================================== Tworzę łańcuch filtrów audio dla 48000Hz/2ch/s16le -> 0Hz/0ch/??... [libaf] Adding filter dummy [dummy] Was reinitialized: 48000Hz/2ch/s16le [dummy] Was reinitialized: 48000Hz/2ch/s16le ao2: 48000 Hz 2 chans s16le audio_setup: using '/dev/dsp' dsp device audio_setup: using '/dev/mixer' mixer device audio_setup: using 'pcm' mixer device audio_setup: sample format: s16le (requested: s16le) audio_setup: using 2 channels (requested: 2) audio_setup: using 48000 Hz samplerate (requested: 48000) audio_setup: frags: 16/16 (4096 bytes/frag) free: 65536 AO: [oss] 48000Hz 2ch s16le (2 bytes per sample) AO: Description: OSS/ioctl audio output AO: Author: A'rpi Tworzę łańcuch filtrów audio dla 48000Hz/2ch/s16le -> 48000Hz/2ch/s16le... [dummy] Was reinitialized: 48000Hz/2ch/s16le [dummy] Was reinitialized: 48000Hz/2ch/s16le Wideo: brak obrazu Freeing 0 unused video chunks. Odtwarzam... XXX initial v_pts=0.000 a_pos=8064 (0.504) A: 9.2 (09.2) of 11375.1 ( 3:09:35.0) 1.3% ===== PAUZA =====
Ostatnio edytowany przez nocturn (2009-06-26 14:51:56)
Offline
Co tu dużo kombinowac.
Dla testu
mplayer film.avi -vo x11
mplayer film.avi -vo xv
Na ktorym pójdzie taki ustaw w gmplayerze.
Offline
Ok zadzialal na x11 :) Jednak nastepny problem ejst, nie mam full screena. Wyglada to tak,ze po wlaczeniu full screena dalej mam maly kwadracik z filmem a reszta jest czarne. Dodalem do pliku konfiguracyjnego zoom=1 , ale to nic nie pomogllo. Sprawdzalem na innych kodekach, ale tylko na X11 mam obraz.Co mozna jeszcez zrobic?
Offline
Dopisz sobie do pliku
[b]~/.mplayer/config[/b]
zoom=1
Offline
[quote=nocturn]Dodalem do pliku konfiguracyjnego zoom=1 , ale to nic nie pomogllo.?[/quote]
Mam dopisany juz:) Fullscreen nie dziala tylko z avi, natomaist na dvd chodzi dobrze
EDIT
Jednak dziala
Offline
Musi dzialać.
Zobacz jak ja mam w configu
adam@debian:~$ cat ~/.mplayer/config # Write your default config options here! ##really-quiet=1 vo=x11 slang=1 alang=pl softvol=1 ao=oss zoom=1 subcp=cp1250 aspect=4:3 subfont-text-scale=3.5 unicode=1 autosync=30 osdlevel=3 monitoraspect=4:3 stop-xscreensaver=1 nojoystick=1 nolirc=1 channels=6 cache=1000 #afm=realaud #vf=expand=0:-120:0 #vf=pp,expand=0:-70:0:0 subfont-osd-scale=3 ##ass=1 ##embeddedfonts=1 ##ass-color=55ff0000 ##ass-font-scale=1.5 stop-xscreensaver=1 tv=device=/dev/video0:driver=v4l2:outfmt=yuy2:normid=5:fps=25:width=768:height=578:brightness=20:contrast=0:saturation=100:channels=51-TVP1,25-TVP2,48-TV4,59-Polsat,42-Wroclaw,31-Poznan,36-CT1,50-CT2,53-NOVA:adevice=/dev/dsp:amode=1
Oczywiście wybierz potrzebne opcje.
Offline
Dzieki wielkie za pomoc. Jeszcze jedno pytanie mam. Gmplayer wspiera wyswietlanie menu w filmach dvd?? W kazdym filmie pomija mi reklamy poczatkowe, ostrzezenia o kopiowaniu itp i od razu wlacza film.
Offline
Tak.
Mplayer tak ma.
Chyba ze wejdziesz na sciezkę z tymi bzdurami.
Ostatnio wprowadza się obslugę dvdnav do mplayera ale jak ostatnio sprawdzalem to nie bardzo sobie to jeszcze radziło.
Warto zainstalować sobie programik [b]lsdvd[/b] za jego pomoca można zobaczyć jakie ściezki posiada dana płyta.
Offline
Troszke szkoda, ze nie zostalo to zaimplementowane. Bede musial uzywac VLC do DVD :)
Jezeli chodzi o sprawdzenie tego dvdnav to pewnie musze przekompilwac mplayera i dociagnac jakies biblioteki ?:)
Offline
Sprawdź
mplayer dvdnav://
Offline
Takie cos wyrzucil
Odtwarzam dvdnav://. No stream found to handle url dvdnav://
Offline
Sprawdź na innej płycie.
U mnie działa.
Ale muszę odpalać tak
mplayer dvdnav:// -nocache
bo cache mam w configu podbite dla sieciowych strumieni bo mam wolne lącze.
Offline
Dobra narazie nei bede sie tym bawil, bo juz mam dosc:) Jeszce jedno mam pytanie teraz odnosnie VLC(zeby nie robic dwoch tematow). Chodzi o to, ze VLC nie trzyma ustawien.
Odpalam VLC wchodze w ustawienia->preferencje potem w interfejs, wybieram tam glowne interfejsy, nastepnie zaznaczam interfejs uzywajacy skory. Daje zapisz, potem zmieniam skorke wychodze z vlc, wlaczam na nowo i juz wszystko wrocilo do ustawien domyslnych. Skora wrocila podstawowa, w ustawienia->preferencje juz nie jest zaznaczone interfejs uzywajacy skory. Plik konfiguracyjny jest w /home/nocturn/.vlc i mam do niego prawa zapisu wiec nie wiem czemu nie trzyma ustawien :(
Offline
Co do vlc to nie wiem nie używam.
Jeśli mogę zasugerować to wypróbuj repowego mplayera z debian-multimedia.
Powinien mieć wkompilowane dvdnav.
Offline
Jeszcze mam jeden problem z mplayerem. Chodzi o odtwarzanie filmow rmvb. Jak chce wlaczyc film rmvb wyrzuca blad "nie moge otworzyc wymaganego kodeka DirectShow drvc.dll". Dziwne ejst to , ze ten kodek jest w katalogu codecs, ponadto mimo tego bledu filmy odtwarzaja sie dobrze. Jedynie ten blad jest troche denerwujacy podczas wlaczania filmow rmvb.
Offline
Dopisz sobie do [b]~/.mplayer/config[/b]
vfm=ffmpeg
Offline
Niestety nie pomoglo
Offline
Czy kosolowy mplayer też Ci w terminalu ten komunikat wypisuje?
Jesli nie to wywal ~/.mplayer/gui.conf
Offline
Mój config:
# Write your default config options here!
vo=xv
ao=alsa
fs=no
zoom=1
fontconfig=yes
subcp = "cp1250"
font = "/usr/share/fonts/truetype/msttcorefonts/ariali.ttf"
subfont-encoding = "unicode"
subfont-text-scale = 4
vf=pp,expand=0:-100:0[/quote]
oraz gui.confenable_audio_equ = "no"
vo_driver = "xv"
vo_panscan = "0.000000"
vo_doublebuffering = "yes"
vo_direct_render = "no"
vo_dxr3_device = "/dev/em8300-0"
v_framedrop = "1"
v_flip = "0"
v_ni = "no"
v_idx = "-1"
v_vfm = "ffmpeg"
a_afm = "liba52"
vf_pp = "no"
vf_autoq = "0"
vf_lavc = "no"
ao_driver = "alsa"
ao_volnorm = "no"
softvol = "no"
ao_surround = "no"
ao_extra_stereo = "no"
ao_extra_stereo_coefficient = "1.000000"
dvd_device = "/dev/dvd"
cdrom_device = "/dev/cdrom"
osd_level = "3"
sub_auto_load = "yes"
sub_unicode = "no"
ass_enabled = "no"
ass_use_margins = "no"
ass_top_margin = "0"
ass_bottom_margin = "0"
sub_pos = "99"
sub_overlap = "no"
sub_cp = "CP1250"
font_factor = "0.750000"
font_name = "/usr/share/fonts/truetype/msttcorefonts/ariali.ttf"
font_encoding = "unicode"
font_text_scale = "6.270000"
font_osd_scale = "6.000000"
font_blur = "2.000000"
font_outline = "2.000000"
font_autoscale = "1"
cache = "no"
cache_size = "1024"
playbar = "yes"
load_fullscreen = "no"
show_videowin = "yes"
stopxscreensaver = "yes"
autosync = "no"
autosync_size = "0"
gui_skin = "default"
gui_save_pos = "yes"
gui_main_pos_x = "664"
gui_main_pos_y = "621"
gui_video_out_pos_x = "308"
gui_video_out_pos_y = "145"
equ_band_00 = "0.000000"
equ_band_01 = "0.000000"
equ_band_02 = "0.000000"
equ_band_03 = "0.000000"
equ_band_04 = "0.000000"
equ_band_05 = "0.000000"
equ_band_06 = "0.000000"
equ_band_07 = "0.000000"
equ_band_08 = "0.000000"
equ_band_09 = "0.000000"
equ_band_10 = "0.000000"
equ_band_11 = "0.000000"
equ_band_12 = "0.000000"
equ_band_13 = "0.000000"
equ_band_14 = "0.000000"
equ_band_15 = "0.000000"
equ_band_16 = "0.000000"
equ_band_17 = "0.000000"
equ_band_18 = "0.000000"
equ_band_19 = "0.000000"
equ_band_20 = "0.000000"
equ_band_21 = "0.000000"
equ_band_22 = "0.000000"
equ_band_23 = "0.000000"
equ_band_24 = "0.000000"
equ_band_25 = "0.000000"
equ_band_26 = "0.000000"
equ_band_27 = "0.000000"
equ_band_28 = "0.000000"
equ_band_29 = "0.000000"
equ_band_30 = "0.000000"
equ_band_31 = "0.000000"
equ_band_32 = "0.000000"
equ_band_33 = "0.000000"
equ_band_34 = "0.000000"
equ_band_35 = "0.000000"
equ_band_36 = "0.000000"
equ_band_37 = "0.000000"
equ_band_38 = "0.000000"
equ_band_39 = "0.000000"
equ_band_40 = "0.000000"
equ_band_41 = "0.000000"
equ_band_42 = "0.000000"
equ_band_43 = "0.000000"
equ_band_44 = "0.000000"
equ_band_45 = "0.000000"
equ_band_46 = "0.000000"
equ_band_47 = "0.000000"
equ_band_48 = "0.000000"
equ_band_49 = "0.000000"
equ_band_50 = "0.000000"
equ_band_51 = "0.000000"
equ_band_52 = "0.000000"
equ_band_53 = "0.000000"
equ_band_54 = "0.000000"
equ_band_55 = "0.000000"
equ_band_56 = "0.000000"
equ_band_57 = "0.000000"
equ_band_58 = "0.000000"
equ_band_59 = "0.000000"[/quote]
Spróbuj na tych ustawieniach.
...software is like sex
it's better when it's free..Offline
Time (s) | Query |
---|---|
0.00011 | SET CHARSET latin2 |
0.00006 | SET NAMES latin2 |
0.00111 | 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='18.117.172.189' WHERE u.id=1 |
0.00072 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '18.117.172.189', 1732552336) |
0.00042 | SELECT * FROM punbb_online WHERE logged<1732552036 |
0.00048 | SELECT topic_id FROM punbb_posts WHERE id=122075 |
0.00006 | SELECT id FROM punbb_posts WHERE topic_id=14485 ORDER BY posted |
0.00052 | 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=14485 AND t.moved_to IS NULL |
0.00006 | SELECT search_for, replace_with FROM punbb_censoring |
0.00102 | 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=14485 ORDER BY p.id LIMIT 0,25 |
0.00081 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=14485 |
Total query time: 0.00537 s |