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/.
Strony: 1
witam! postawilem sobie firewala na debianie no i liquid weather nie pobiera mi danych z serwera, chodzi o to jak wylistowac jaki program na jakim porcie nasluchuje(bo moze za duzo poblokowałem :-D). No i aby nie zasmiecac forum jeszcze jedno pytanko: jak wylistowac liste zainstalowanych pakietow?? Z gory dzieki
Offline
Wylistować zainstalowane pakiety można przez :
dpkg -l | less
lub używając aptitude.
By sprawdzić reguły iptables można wydać polecenie :
iptables -L
Sprawdzenie jaki program nasłuchuje na jakim porcie można przez :
netstat -a
Offline
no ale dalej nie wiem na ktorym porcie pracuje liquid weather. dałem netstat -a i otrzymałem to:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 *:1550 *:* LISTEN
tcp 0 0 *:sunrpc *:* LISTEN
tcp 0 0 *:40081 *:* LISTEN
tcp 0 0 *:auth *:* LISTEN
tcp 0 0 *:smtp *:* LISTEN
tcp 0 0 192.168.5.58:55264 unused-21701704514:8074 ESTABLISHED
tcp 0 726 192.168.5.58:48832 dug.net.pl:www ESTABLISHED
tcp 0 774 192.168.5.58:48831 dug.net.pl:www ESTABLISHED
tcp6 0 0 *:smtp *:* LISTEN
udp 0 0 *:32768 *:*
udp 0 0 *:32769 *:*
udp 0 0 *:975 *:*
udp 0 0 *:sunrpc *:*
Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 7837 /tmp/.X11-unix/X0
unix 2 [ ACC ] STREAM LISTENING 8098 /tmp/ssh-qVeVGq2592/agent.2592
unix 2 [ ACC ] STREAM LISTENING 8153 /tmp/ksocket-siarka/kdeinit__0
unix 2 [ ACC ] STREAM LISTENING 8155 /tmp/ksocket-siarka/kdeinit-:0
unix 2 [ ACC ] STREAM LISTENING 8168 /tmp/.ICE-unix/dcop2666-1163320093
unix 2 [ ACC ] STREAM LISTENING 8269 /tmp/.ICE-unix/2677
unix 2 [ ACC ] STREAM LISTENING 8190 /tmp/ksocket-siarka/klauncherowTEBa.slave-socket
unix 2 [ ACC ] STREAM LISTENING 6142 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 8375 /tmp/ksocket-siarka/debian-0a7c-4556db26
unix 2 [ ACC ] STREAM LISTENING 6129 /var/run/acpid.socket
unix 2 [ ACC ] STREAM LISTENING 8103 @/tmp/dbus-2rW5TJtFdF
unix 2 [ ACC ] STREAM LISTENING 11079 @/var/run/hald/dbus-QK7vZgMEnR
unix 2 [ ] DGRAM 3434 @/org/kernel/udev/udevd
unix 2 [ ACC ] STREAM LISTENING 11080 @/var/run/hald/dbus-B0VuYrxL4E
unix 2 [ ACC ] STREAM LISTENING 7803 /dev/gpmctl
unix 2 [ ACC ] STREAM LISTENING 18757 /tmp/orbit-siarka/linc-105a-0-7eab0eb22c4e4
unix 2 [ ACC ] STREAM LISTENING 18766 /tmp/orbit-siarka/linc-104c-0-6601a7bf3348a
unix 2 [ ] DGRAM 11088 @/org/freedesktop/hal/udev_event
unix 9 [ ] DGRAM 6060 /dev/log
unix 2 [ ACC ] STREAM LISTENING 7821 /var/run/xdmctl/dmctl/socket
unix 2 [ ACC ] STREAM LISTENING 7846 /var/run/xdmctl/dmctl-:0/socket
unix 2 [ ACC ] STREAM LISTENING 7667 /dev/printer
unix 3 [ ] STREAM CONNECTED 18921 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 18920
unix 3 [ ] STREAM CONNECTED 18916 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 18915
unix 3 [ ] STREAM CONNECTED 18914 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 18913
unix 3 [ ] STREAM CONNECTED 18823 /tmp/ksocket-siarka/klauncherowTEBa.slave-socket
unix 3 [ ] STREAM CONNECTED 18822
unix 3 [ ] STREAM CONNECTED 18770 /tmp/orbit-siarka/linc-104c-0-6601a7bf3348a
unix 3 [ ] STREAM CONNECTED 18769
unix 3 [ ] STREAM CONNECTED 18768 /tmp/orbit-siarka/linc-105a-0-7eab0eb22c4e4
unix 3 [ ] STREAM CONNECTED 18765
unix 2 [ ] DGRAM 18753
unix 3 [ ] STREAM CONNECTED 18721 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 18720
unix 3 [ ] STREAM CONNECTED 15895 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 15894
unix 3 [ ] STREAM CONNECTED 14450 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 14449
unix 3 [ ] STREAM CONNECTED 14444 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 14443
unix 3 [ ] STREAM CONNECTED 14442 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 14441
unix 2 [ ] STREAM CONNECTED 14435 /tmp/ksocket-siarka/kdeinit__0
unix 3 [ ] STREAM CONNECTED 11902 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 11901
unix 3 [ ] STREAM CONNECTED 11899 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 11898
unix 3 [ ] STREAM CONNECTED 11894 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 11893
unix 3 [ ] STREAM CONNECTED 11593 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 11592
unix 3 [ ] STREAM CONNECTED 11232 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 11231
unix 3 [ ] STREAM CONNECTED 11202 @/var/run/hald/dbus-QK7vZgMEnR
unix 3 [ ] STREAM CONNECTED 11201
unix 3 [ ] STREAM CONNECTED 11142 @/var/run/hald/dbus-QK7vZgMEnR
unix 3 [ ] STREAM CONNECTED 11138
unix 3 [ ] STREAM CONNECTED 11135 /var/run/acpid.socket
unix 3 [ ] STREAM CONNECTED 11134
unix 3 [ ] STREAM CONNECTED 11124 @/var/run/hald/dbus-QK7vZgMEnR
unix 3 [ ] STREAM CONNECTED 11122
unix 3 [ ] STREAM CONNECTED 11083 @/var/run/hald/dbus-B0VuYrxL4E
unix 3 [ ] STREAM CONNECTED 11082
unix 2 [ ] DGRAM 9462
unix 2 [ ] DGRAM 9419
unix 3 [ ] STREAM CONNECTED 9335 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 9334
unix 3 [ ] STREAM CONNECTED 9330 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 9329
unix 3 [ ] STREAM CONNECTED 9328 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 9327
unix 3 [ ] STREAM CONNECTED 8598 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8597
unix 3 [ ] STREAM CONNECTED 8573 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8572
unix 3 [ ] STREAM CONNECTED 8571 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8570
unix 3 [ ] STREAM CONNECTED 8537 /tmp/ksocket-siarka/debian-0a7c-4556db26
unix 3 [ ] STREAM CONNECTED 8536
unix 3 [ ] STREAM CONNECTED 8527 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8526
unix 3 [ ] STREAM CONNECTED 8525 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8524
unix 3 [ ] STREAM CONNECTED 8522 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8521
unix 3 [ ] STREAM CONNECTED 8489 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8485
unix 3 [ ] STREAM CONNECTED 8484 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8483
unix 3 [ ] STREAM CONNECTED 8479 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8478
unix 3 [ ] STREAM CONNECTED 8465 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8464
unix 3 [ ] STREAM CONNECTED 8451 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8450
unix 3 [ ] STREAM CONNECTED 8449 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8448
unix 3 [ ] STREAM CONNECTED 8441 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8427
unix 3 [ ] STREAM CONNECTED 8426 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8425
unix 3 [ ] STREAM CONNECTED 8423 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8422
unix 3 [ ] STREAM CONNECTED 8410 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8409
unix 3 [ ] STREAM CONNECTED 8321 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8320
unix 3 [ ] STREAM CONNECTED 8319 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8318
unix 3 [ ] STREAM CONNECTED 8314 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8313
unix 3 [ ] STREAM CONNECTED 8302 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8301
unix 3 [ ] STREAM CONNECTED 8298 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8297
unix 3 [ ] STREAM CONNECTED 8293 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8292
unix 3 [ ] STREAM CONNECTED 8285 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8284
unix 3 [ ] STREAM CONNECTED 8283 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8282
unix 3 [ ] STREAM CONNECTED 8278 /tmp/.ICE-unix/2677
unix 3 [ ] STREAM CONNECTED 8277
unix 3 [ ] STREAM CONNECTED 8276 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8275
unix 3 [ ] STREAM CONNECTED 8268 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8267
unix 3 [ ] STREAM CONNECTED 8262 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8261
unix 3 [ ] STREAM CONNECTED 8253 /tmp/ksocket-siarka/kdeinit__0
unix 3 [ ] STREAM CONNECTED 8252
unix 3 [ ] STREAM CONNECTED 8241 /var/run/dbus/system_bus_socket
unix 3 [ ] STREAM CONNECTED 8240
unix 3 [ ] STREAM CONNECTED 8210 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8209
unix 3 [ ] STREAM CONNECTED 8207 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8206
unix 3 [ ] STREAM CONNECTED 8193 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8192
unix 3 [ ] STREAM CONNECTED 8184 /tmp/.ICE-unix/dcop2666-1163320093
unix 3 [ ] STREAM CONNECTED 8183
unix 3 [ ] STREAM CONNECTED 8179
unix 3 [ ] STREAM CONNECTED 8178
unix 3 [ ] STREAM CONNECTED 8107 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 8106
unix 3 [ ] STREAM CONNECTED 8105
unix 3 [ ] STREAM CONNECTED 8104
unix 2 [ ] DGRAM 8066
unix 3 [ ] STREAM CONNECTED 7866 /var/run/acpid.socket
unix 3 [ ] STREAM CONNECTED 7865
unix 4 [ ] STREAM CONNECTED 8000 /tmp/.X11-unix/X0
unix 3 [ ] STREAM CONNECTED 7854
unix 2 [ ] DGRAM 7745
unix 2 [ ] DGRAM 7664
unix 2 [ ] STREAM CONNECTED 7010 /var/run/acpid.socket
unix 3 [ ] STREAM CONNECTED 6145
unix 3 [ ] STREAM CONNECTED 6144
unix 2 [ ] DGRAM 6072
za wiele z tego nie odczytam. Chodziło mi raczej o polecenie typu .....| grep superkaramba albo jakies inne bardziej przejrzyste polecenie. pozdro
Offline
Wybór=U=Nieznany/I=Instalacja/R=Usunięcie/P=Wyczyszczenie/H=Zatrzymanie
| Stan=N=Brak/I=Zainst./C=Skonfig./U=Rozpakowany/F=Nieskonfig./H=Wpół-zainst.
|/ Błędy?=(brak)/H=Wstrzym./R=Do przeinst./X=Obydwa (Stan,Błędy:wielk.lit.=źle)
||/ Nazwa Wersja Opis
+++-==================================-===============================-================================================================
ii a2ps 4.13b.dfsg.1-1 GNU a2ps - 'Anything to PostScript' converter and pretty-printer
ii acpid 1.0.4-5 Utilities for using ACPI power management
ii adduser 3.99 Add and remove users and groups
ii akregator 3.5.5.dfsg.1-1 RSS feed aggregator for KDE
ii alien 8.64 install non-native packages with dpkg
ii alsa-base 1.0.13-1 ALSA driver configuration files
ii alsa-utils 1.0.13-1 ALSA utilities
rc amarok 1.4.4-0.1 versatile and easy to use audio player for KDE
ii amor 3.5.5-1 a KDE creature for your desktop
ii apt 0.6.46.3 Advanced front-end for dpkg
ii apt-utils 0.6.46.3 APT utility programs
ii aptitude 0.4.4-1 terminal-based apt frontend
ii ark 3.5.5-1 graphical archiving tool for KDE
ii arts 1.5.5-1 sound system from the official KDE release
ii artsbuilder 3.5.5-1 synthesizer designer for aRts
rc at 3.1.10 Delayed job execution and batch processing
ii atlantik 3.5.5-1 KDE client for Monopoly-like network games
ii atlantikdesigner 3.5.5-1 game board designer for Atlantik
ii avahi-daemon 0.6.15-1 Avahi mDNS/DNS-SD daemon
ii avifile-divx-plugin 0.7.44.20051021-2.2+b1 Divx4Linux video de/encoding plugin for libavifile
ii avifile-mad-plugin 0.7.44.20051021-2.2+b1 MAD - MPEG audio plugin for libavifile
ii avifile-mjpeg-plugin 0.7.44.20051021-2.2+b1 MJPEG video plugin for libavifile
ii avifile-vorbis-plugin 0.7.44.20051021-2.2+b1 Vorbis audio plugin for libavifile
ii avifile-win32-plugin 0.7.44.20051021-2.2+b1 Win32 audio/video plugin for libavifile
ii avifile-xvid-plugin 0.7.44.20051021-2.2+b1 XviD video encoding plugin for libavifile
ii base-files 4 Debian base system miscellaneous files
ii base-passwd 3.5.11 Debian base system master password and group files
ii bash 3.1dfsg-7 The GNU Bourne Again SHell
ii bc 1.06-20 The GNU bc arbitrary precision calculator language
ii bin86 0.16.14-1.4 16-bit x86 assembler and loader
ii bind9-host 9.3.2-P1.0-1 Version of 'host' bundled with BIND 9.X
ii binutils 2.17-3 The GNU assembler, linker and binary utilities
ii bison 2.3.dfsg-4 A parser generator that is compatible with YACC
ii bittorrent 3.4.2-10 Scatter-gather network file transfer
ii blinken 3.5.5-1 KDE version of the Simon Says electronic memory game
rc brasero 0.4.4-4 CD/DVD burning application for GNOME
ii bsdmainutils 6.1.4 collection of more utilities from FreeBSD
ii bsdutils 2.12r-15 Basic utilities from 4.4BSD-Lite
ii bsh 2.0b4-4 Java scripting environment (BeanShell) Version 2
ii build-essential 11.3 informational list of build-essential packages
ii busybox 1.1.3-3 Tiny utilities for small and embedded systems
ii bzip2 1.0.3-6 high-quality block-sorting file compressor - utilities
ii ca-certificates 20061027 Common CA Certificates PEM files
ii cdparanoia 3.10+debian~pre0-2 audio extraction tool for sampling CDs
DO dupy pisze błedy brak a amrok mi szlak trafił i nie działa do dupy taki wykaz
Offline
dla pomocy moge podac jak wyglada moj firewall
#!/bin/bash
#ladowanie modulow
modprobe ip_conntrack
modprobe ip_conntrack_ftp
modprobe ip_conntrack_irc
modprobe ip_nat_ftp
modprobe ip_nat_irc
modprobe ip_tables
modprobe ipt_MASQUERADE
modprobe ip_conntrack
modprobe iptable_filter
modprobe iptable_mangle
modprobe iptable_nat
#czyszczenie poprzednich regol
iptables -F
iptables -F -t nat
iptables -X -t nat
iptables -F -t mangle
iptables -X -t mangle
iptables -F -t filter
iptables -X -t filter
#uruchomienie odpowiednich mechanizmów w jądrze systemu. Opis z zachowaniem kolejności :
#- ochrona przed atakami syn-flood
#- włączenie przekazywania pakietów pomiędzy interfejsami
echo "1" > /proc/sys/net/ipv4/tcp_syncookies
echo "1" > /proc/sys/net/ipv4/ip_forward
iptables -P INPUT DROP
iptables -P FORWARD DROP
iptables -P OUTPUT ACCEPT
iptables -A INPUT -i lo -j ACCEPT
#korzystamy z dobrodziejstw śledzenia połączeń pozwalając na połączenia nawiązane i powiązane z innymi
iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
#wpuszczamy http
iptables -A INPUT -p tcp -s 0.0.0.0/0 --dport 80 -j ACCEPT
#wpuszczamy dns
iptables -A INPUT -s 194.204.159.1 -j ACCEPT
iptables -A INPUT -s 194.204.152.34 -j ACCEPT
#Dobrym pomysłem może być zablokowanie wszystkich pakietów z ustawionym bitem SYN (inicjacja nowego połączenia dla protokołu TCP).
#iptables -A INPUT -p TCP --syn -j DROP
#aby nasz komputer odpowiadał na pingi
#iptables -A INPUT -p icmp -j ACCEPT
#lub tylko odpowiedzi na pingi wychodzące z naszego komputera docierały do nas
iptables -A INPUT -p icmp --icmp-type echo-reply -j ACCEPT
#wpuszczamy ftp
iptables -A INPUT -p tcp --dport 20:21 -j ACCEPT
#smtp
iptables -A INPUT -p tcp --dport 25 -j ACCEPT
#pop3
iptables -A INPUT -p tcp --dport 110 -j ACCEPT
#szyfrowany http
iptables -A INPUT -p tcp --dport 443 -j ACCEPT
#kadu
iptables -A INPUT -p tcp --dport 8074 -j ACCEPT
iptables -A INPUT -p tcp --dport 1550 -j ACCEPT
#torrent
iptables -A INPUT -p tcp --dport 6881 -j ACCEPT
iptables -A INPUT -p udp --dport 6881 -j ACCEPT
nie wiem dalej jak wylistowac z ktorego portu korzysta dany program. prosze o pomoc
Offline
Skąd pewność że iptables blokuje ? Czy jak "wyłączysz" iptables to liquid wether działa ? Może jest to wina złej konfiguracji programu liquid weather ? Jak dobrze kojarze to chyba program pobiera informacje ze stron internetowych np. http://www.weather.com/
Nie wiem jak moge pomóc , jesli wprowdziłem w błąd , przepraszam.
Pozdrawiam
Offline
no ale dalej nie wiem na ktorym porcie pracuje liquid weather.
[/quote]
Najlepiej jako root wpisz:
Kod:
netstat -lp
Offline
Strony: 1
Time (s) | Query |
---|---|
0.00010 | SET CHARSET latin2 |
0.00004 | SET NAMES latin2 |
0.00098 | 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.252.85' WHERE u.id=1 |
0.00119 | UPDATE punbb_online SET logged=1738450761 WHERE ident='18.118.252.85' |
0.00055 | SELECT * FROM punbb_online WHERE logged<1738450461 |
0.00073 | SELECT topic_id FROM punbb_posts WHERE id=44344 |
0.00006 | SELECT id FROM punbb_posts WHERE topic_id=5808 ORDER BY posted |
0.00055 | 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=5808 AND t.moved_to IS NULL |
0.00005 | SELECT search_for, replace_with FROM punbb_censoring |
0.00249 | 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=5808 ORDER BY p.id LIMIT 0,25 |
0.00097 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=5808 |
Total query time: 0.00771 s |