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!

Ogłoszenie

Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.

#1  2014-09-26 19:16:21

  misioooo - Członek DUG

misioooo
Członek DUG
Skąd: Wrocław
Zarejestrowany: 2006-06-10

Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Hej!
Szybciutko:

Kod:

root@sauron:/home/misio# lspci -k | grep -A3 VGA
01:05.0 VGA compatible controller: Advanced Micro Devices, Inc. [AMD/ATI] RS690M [Radeon Xpress 1200/1250/1270]
    Subsystem: Fujitsu Technology Solutions Device 111d
    Kernel driver in use: radeon
08:00.0 Ethernet controller: Realtek Semiconductor Co., Ltd. RTL8111/8168/8411 PCI Express Gigabit Ethernet Controller (rev 02)

Sterownik mam (chyba). Mplayera mam zainstalowanego, w ASCII odtwarza filmy ;)
Jak odpalić film "normalnie" (np. we buforze ramki)?

W grubie ustawiłem sobie rozdzielczość 1280x1024 i działa - tak mi TV pokazuje jak się konsola odpali po restarcie.
W /dev/fb0 istnieje.
Polecenie mplayer -vo fb0 film.avi wywala błąd - nie może się podłączyć do video output...


[img]https://wiki.debian.org/DebianArt/Themes/Lines?action=AttachFile&do=get&target=banner.png[/img]

Offline

 

#2  2014-09-26 19:36:29

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/urandom
Zarejestrowany: 2008-01-07

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Pokaż wynik:

Kod:

mplayer -vo help

Potem wybierz wyjście framebuffera, które znajdziesz w wyniku tego polecenia.

EDIT:
Jeśli ma to wkompilowane, to powinien pójść na wyjściu

Kod:

directfb

Ostatnio edytowany przez Jacekalex (2014-09-26 19:38:54)


W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

#3  2014-09-26 19:54:22

  misioooo - Członek DUG

misioooo
Członek DUG
Skąd: Wrocław
Zarejestrowany: 2006-06-10

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Nie bangla...

Kod:

root@sauron:/home/misio/hdd/filmy/short# mplayer -vo directfb demo_720p.mp4 
MPlayer2 2.0-728-g2c378c7-2+b2 (C) 2000-2012 MPlayer Team
Cannot open file '/root/.mplayer/input.conf': No such file or directory
Failed to open /root/.mplayer/input.conf.
Cannot open file '/etc/mplayer/input.conf': No such file or directory
Failed to open /etc/mplayer/input.conf.

Playing demo_720p.mp4.
Detected file format: QuickTime / MOV (libavformat)
[lavf] stream 0: video (h264), -vid 0
[lavf] stream 1: audio (aac), -aid 0, -alang eng
Clip info:
 major_brand: isom
 minor_version: 1
 compatible_brands: isomavc1
 creation_time: 2014-09-15 01:52:27
Load subtitles in .
commandline read: mplayer
commandline read: -vo
commandline read: directfb
commandline read: demo_720p.mp4

   ~~~~~~~~~~~~~~~~~~~~~~~~~~| DirectFB 1.2.10 |~~~~~~~~~~~~~~~~~~~~~~~~~~
        (c) 2001-2008  The world wide DirectFB Open Source Community
        (c) 2000-2004  Convergence (integrated media) GmbH
      ----------------------------------------------------------------

(*) DirectFB/Core: Single Application Core. (2012-05-20 13:17) 
(*) Direct/Thread: Started 'VT Switcher' (-1) [CRITICAL OTHER/OTHER 0/0] <8388608>...
(*) Direct/Thread: Started 'PS/2 Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: IMPS/2 Mouse (1) 1.0 (directfb.org)
(*) Direct/Thread: Started 'PS/2 Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: IMPS/2 Mouse (2) 1.0 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: Power Button (1) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: Power Button (2) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: PC Speaker (3) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Front Headphone (4) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Line Out (5) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Line (6) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Mic (7) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Keyboard Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: Keyboard 0.9 (directfb.org)
(*) DirectFB/Genefx: MMX detected and enabled
(*) DirectFB/Graphics: MMX Software Rasterizer 0.6 (directfb.org)
(*) DirectFB/Core/WM: Default 0.3 (directfb.org)
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 0) at offset 0 and pitch 4096.
Opening video filter: [scale]
[ass] auto-open
Selected video codec: H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10 [libavcodec]
Selected audio codec: AAC (Advanced Audio Coding) [libavcodec]
AUDIO: 48000 Hz, 2 ch, floatle, 93.8 kbit/3.05% (ratio: 11724->384000)
AO: [pulse] Init failed: Connection refused
AO: [alsa] 48000Hz 2ch floatle (4 bytes per sample)
Starting playback...
VIDEO:  1280x536  23.976 fps  931.0 kbps (116.4 kB/s)
[swscaler @ 0xb6109aa0]using unscaled yuv420p -> bgra special converter
VO: [directfb] 1280x536 => 1280x536 BGRA 
 (!!!)  *** WARNING [letting unprivileged IDirectFBDisplayLayer::GetSurface() call pass until cooperative level handling is finished] *** [../../../src/display/idirectfbdisplaylayer.c:174 in IDirectFBDisplayLayer_GetSurface()]
(*) FBDev/Mode: Setting 640x480 RGB32
(*) FBDev/Mode: Switched to 640x480 (virtual 640x480) at 32 bit (RGB32), pitch 4096
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 0) at offset 0 and pitch 4096.
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 0) at offset 0 and pitch 4096.
(*) FBDev/Mode: Setting 640x480 RGB32
(*) FBDev/Mode: Switched to 640x480 (virtual 640x960) at 32 bit (RGB32), pitch 4096
 (!!!)  *** WARNING [unable to adjust heap offset] *** [../../../systems/fbdev/surfacemanager.c:167 in dfb_surfacemanager_adjust_heap_offset()]
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 1) at offset 1966080 and pitch 4096.
(!) DirectFB/FBDev: Panning display failed (x=0 y=480 ywrap=0 vbl=0)!
    --> Invalid argument
(!) [ 2414:    0.000] --> Caught signal 11 (at 0xb16b7000, invalid permissions) <--
 (!!!)  *** WARNING [still objects in 'Layer Region Pool'] *** [../../../lib/fusion/object.c:241 in fusion_object_pool_destroy()]
 (!!!)  *** WARNING [still objects in 'Layer Context Pool'] *** [../../../lib/fusion/object.c:241 in fusion_object_pool_destroy()]
 (!!!)  *** WARNING [still objects in 'Surface Pool'] *** [../../../lib/fusion/object.c:241 in fusion_object_pool_destroy()
MPlayer interrupted by signal 6 in module: check_framedrop
- MPlayer crashed. This shouldn't happen.
  It can be a bug in the MPlayer code _or_ in your drivers _or_ in your
  gcc version. If you think it's MPlayer's fault, please read
  DOCS/HTML/en/bugreports.html and follow the instructions there. We can't and
  won't help unless you provide this information when reporting a possible bug.

Po poleceniu mplayer -vo help mam jeszcze gl, gl3 i kilka innych... Na innych wogóle nie może się "podłączyć". Tylko directfb zwraca takie coś.
Z konta pacjenta normalnego nie działa wogóle, na starcie directfb się wykrzacza - ale to nie problem, pewnie trzeba usera do jakiejś grupy dodać. Najpierw niech wogóle ruszy ;P


[img]https://wiki.debian.org/DebianArt/Themes/Lines?action=AttachFile&do=get&target=banner.png[/img]

Offline

 

#4  2014-09-27 15:18:07

  Renia - Użytkownik

Renia
Użytkownik
Zarejestrowany: 2014-08-29

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Masz zainstalowany xserver-xorg-video-fbdev? Jeśli tak wtedy spróbuj: 

Kod:

mplayer -vo fbdev2 demo_720p.mp4

Działa w konsoli na wersji MPlayer SVN-r37242 bez problemu, na innych nie sprawdzałam.


Instalacja E-Deklaracje na Debianie 64-bit:
https://forum.dug.net.pl/viewtopic.php?pid=301794#p301794

Offline

 

#5  2014-09-28 10:08:10

  misioooo - Członek DUG

misioooo
Członek DUG
Skąd: Wrocław
Zarejestrowany: 2006-06-10

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

No cała sztuczka polega na tym, że nie mam Xorga wogóle ;)


[img]https://wiki.debian.org/DebianArt/Themes/Lines?action=AttachFile&do=get&target=banner.png[/img]

Offline

 

#6  2014-09-28 11:17:42

  mati75 - Psuj

mati75
Psuj
Skąd: default city
Zarejestrowany: 2010-03-14
Serwis

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Pokaż:

Kod:

mplayer -vo help

Ostatnio edytowany przez mati75 (2014-09-29 08:39:11)


[img]https://l0calh0st.pl/obrazki/userbar.png[/img]

Offline

 

#7  2014-09-29 08:20:42

  qluk - Pan inż. Cyc

qluk
Pan inż. Cyc
Skąd: Katowice
Zarejestrowany: 2006-05-22

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Trzeba by przekompilować mplayera przy czym -fb zostało chyba porzucone w mplayer2.

Offline

 

#8  2014-09-29 08:39:32

  mati75 - Psuj

mati75
Psuj
Skąd: default city
Zarejestrowany: 2010-03-14
Serwis

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Ja mam takie:

Kod:

MPlayer2 2.0-728-g2c378c7-2+b2 (C) 2000-2012 MPlayer Team
Available video output drivers:
    vdpau    VDPAU with X11
    xv    X11/Xv
    gl3    OpenGL 3.x
    gl    OpenGL
    x11    X11 ( XImage/Shm )
    sdl    SDL YUV/RGB/BGR renderer (SDL v1.1.7+ only!)
    caca    libcaca
    v4l2    V4L2 MPEG Video Decoder Output
    null    Null video output
    directfb    Direct Framebuffer Device
    yuv4mpeg    yuv4mpeg output for mjpegtools
    png    PNG file
    jpeg    JPEG file
    gif89a    animated GIF output
    tga    Targa output
    pnm    PPM/PGM/PGMYUV file
    md5sum    md5sum of each frame
    gl_nosw    OpenGL no software rendering

[img]https://l0calh0st.pl/obrazki/userbar.png[/img]

Offline

 

#9  2014-09-29 09:52:08

  misioooo - Członek DUG

misioooo
Członek DUG
Skąd: Wrocław
Zarejestrowany: 2006-06-10

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

U mnie tak samo to wygląda.


[img]https://wiki.debian.org/DebianArt/Themes/Lines?action=AttachFile&do=get&target=banner.png[/img]

Offline

 

#10  2014-09-29 10:58:07

  mati75 - Psuj

mati75
Psuj
Skąd: default city
Zarejestrowany: 2010-03-14
Serwis

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Kod:

mplayer -vo directfb *

Spróbuj


[img]https://l0calh0st.pl/obrazki/userbar.png[/img]

Offline

 

#11  2014-09-29 12:02:52

  misioooo - Członek DUG

misioooo
Członek DUG
Skąd: Wrocław
Zarejestrowany: 2006-06-10

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Już to robiłem, nie bangla...
[quote=misioooo]Nie bangla...

Kod:

root@sauron:/home/misio/hdd/filmy/short# mplayer -vo directfb demo_720p.mp4 
MPlayer2 2.0-728-g2c378c7-2+b2 (C) 2000-2012 MPlayer Team
Cannot open file '/root/.mplayer/input.conf': No such file or directory
Failed to open /root/.mplayer/input.conf.
Cannot open file '/etc/mplayer/input.conf': No such file or directory
Failed to open /etc/mplayer/input.conf.

Playing demo_720p.mp4.
Detected file format: QuickTime / MOV (libavformat)
[lavf] stream 0: video (h264), -vid 0
[lavf] stream 1: audio (aac), -aid 0, -alang eng
Clip info:
 major_brand: isom
 minor_version: 1
 compatible_brands: isomavc1
 creation_time: 2014-09-15 01:52:27
Load subtitles in .
commandline read: mplayer
commandline read: -vo
commandline read: directfb
commandline read: demo_720p.mp4

   ~~~~~~~~~~~~~~~~~~~~~~~~~~| DirectFB 1.2.10 |~~~~~~~~~~~~~~~~~~~~~~~~~~
        (c) 2001-2008  The world wide DirectFB Open Source Community
        (c) 2000-2004  Convergence (integrated media) GmbH
      ----------------------------------------------------------------

(*) DirectFB/Core: Single Application Core. (2012-05-20 13:17) 
(*) Direct/Thread: Started 'VT Switcher' (-1) [CRITICAL OTHER/OTHER 0/0] <8388608>...
(*) Direct/Thread: Started 'PS/2 Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: IMPS/2 Mouse (1) 1.0 (directfb.org)
(*) Direct/Thread: Started 'PS/2 Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: IMPS/2 Mouse (2) 1.0 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: Power Button (1) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: Power Button (2) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: PC Speaker (3) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Front Headphone (4) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Line Out (5) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Line (6) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Linux Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: HDA ATI SB Mic (7) 0.1 (directfb.org)
(*) Direct/Thread: Started 'Keyboard Input' (-1) [INPUT OTHER/OTHER 0/0] <8388608>...
(*) DirectFB/Input: Keyboard 0.9 (directfb.org)
(*) DirectFB/Genefx: MMX detected and enabled
(*) DirectFB/Graphics: MMX Software Rasterizer 0.6 (directfb.org)
(*) DirectFB/Core/WM: Default 0.3 (directfb.org)
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 0) at offset 0 and pitch 4096.
Opening video filter: [scale]
[ass] auto-open
Selected video codec: H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10 [libavcodec]
Selected audio codec: AAC (Advanced Audio Coding) [libavcodec]
AUDIO: 48000 Hz, 2 ch, floatle, 93.8 kbit/3.05% (ratio: 11724->384000)
AO: [pulse] Init failed: Connection refused
AO: [alsa] 48000Hz 2ch floatle (4 bytes per sample)
Starting playback...
VIDEO:  1280x536  23.976 fps  931.0 kbps (116.4 kB/s)
[swscaler @ 0xb6109aa0]using unscaled yuv420p -> bgra special converter
VO: [directfb] 1280x536 => 1280x536 BGRA 
 (!!!)  *** WARNING [letting unprivileged IDirectFBDisplayLayer::GetSurface() call pass until cooperative level handling is finished] *** [../../../src/display/idirectfbdisplaylayer.c:174 in IDirectFBDisplayLayer_GetSurface()]
(*) FBDev/Mode: Setting 640x480 RGB32
(*) FBDev/Mode: Switched to 640x480 (virtual 640x480) at 32 bit (RGB32), pitch 4096
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 0) at offset 0 and pitch 4096.
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 0) at offset 0 and pitch 4096.
(*) FBDev/Mode: Setting 640x480 RGB32
(*) FBDev/Mode: Switched to 640x480 (virtual 640x960) at 32 bit (RGB32), pitch 4096
 (!!!)  *** WARNING [unable to adjust heap offset] *** [../../../systems/fbdev/surfacemanager.c:167 in dfb_surfacemanager_adjust_heap_offset()]
(*) FBDev/Surface: Allocated 640x480 32 bit RGB32 buffer (index 1) at offset 1966080 and pitch 4096.
(!) DirectFB/FBDev: Panning display failed (x=0 y=480 ywrap=0 vbl=0)!
    --> Invalid argument
(!) [ 2414:    0.000] --> Caught signal 11 (at 0xb16b7000, invalid permissions) <--
 (!!!)  *** WARNING [still objects in 'Layer Region Pool'] *** [../../../lib/fusion/object.c:241 in fusion_object_pool_destroy()]
 (!!!)  *** WARNING [still objects in 'Layer Context Pool'] *** [../../../lib/fusion/object.c:241 in fusion_object_pool_destroy()]
 (!!!)  *** WARNING [still objects in 'Surface Pool'] *** [../../../lib/fusion/object.c:241 in fusion_object_pool_destroy()
MPlayer interrupted by signal 6 in module: check_framedrop
- MPlayer crashed. This shouldn't happen.
  It can be a bug in the MPlayer code _or_ in your drivers _or_ in your
  gcc version. If you think it's MPlayer's fault, please read
  DOCS/HTML/en/bugreports.html and follow the instructions there. We can't and
  won't help unless you provide this information when reporting a possible bug.

Po poleceniu mplayer -vo help mam jeszcze gl, gl3 i kilka innych... Na innych wogóle nie może się "podłączyć". Tylko directfb zwraca takie coś.
Z konta pacjenta normalnego nie działa wogóle, na starcie directfb się wykrzacza - ale to nie problem, pewnie trzeba usera do jakiejś grupy dodać. Najpierw niech wogóle ruszy ;P[/quote]


[img]https://wiki.debian.org/DebianArt/Themes/Lines?action=AttachFile&do=get&target=banner.png[/img]

Offline

 

#12  2014-09-29 12:09:17

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/urandom
Zarejestrowany: 2008-01-07

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

Spróbuj w konsoli odpalić magiczne polecenie [b]nvlc[/b] albo samego - to konsolowy klient [b]Vlc[/b] na ncurses.
Może radykalnie pomóc, choć Mplayerem nie jest.

Względnie w konsoli:

Kod:

vlc {film}

U mnie automatycznie wstaje na DirectFB i chodzi - wersja Vlc-3.0 z git.

Ostatnio edytowany przez Jacekalex (2014-09-29 14:47:09)


W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

#13  2014-09-29 13:43:02

  qluk - Pan inż. Cyc

qluk
Pan inż. Cyc
Skąd: Katowice
Zarejestrowany: 2006-05-22

Re: Odtwarzanie filmów mplayer w konsoli (bez x-servera)

directfb != framebuffer

[quote="http://directfb.org/"]DirectFB is a thin library that provides hardware graphics acceleration, input device handling and abstraction, integrated windowing system with support for translucent windows and multiple display layers, not only on top of the Linux Framebuffer Device. It is a complete hardware abstraction layer with software fallbacks for every graphics operation that is not supported by the underlying hardware. DirectFB adds graphical power to embedded systems and sets a new standard for graphics under Linux.[/quote]

Offline

 

Stopka forum

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson
To nie jest tylko forum, to nasza mała ojczyzna ;-)

[ Generated in 0.011 seconds, 10 queries executed ]

Informacje debugowania

Time (s) Query
0.00013 SET CHARSET latin2
0.00004 SET NAMES latin2
0.00163 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.118.100.48' WHERE u.id=1
0.00079 REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '18.118.100.48', 1715322327)
0.00046 SELECT * FROM punbb_online WHERE logged<1715322027
0.00073 DELETE FROM punbb_online WHERE ident='54.36.148.57'
0.00035 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=26472 AND t.moved_to IS NULL
0.00024 SELECT search_for, replace_with FROM punbb_censoring
0.00284 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=26472 ORDER BY p.id LIMIT 0,25
0.00117 UPDATE punbb_topics SET num_views=num_views+1 WHERE id=26472
Total query time: 0.00838 s