Zobrazit příspěvky
Tato sekce Vám umožňuje zobrazit všechny příspěvky tohoto uživatele. Prosím uvědomte si, že můžete vidět příspěvky pouze z oblastí Vám přístupných.
SELECT count(p.id) as c FROM posts AS p WHERE p.poster_id=7 AND (1582453177 - p.posted)<301 AND left( p.message, 21)='Testujeme nějakej zaj' ORDER BY p.posted DESC LIMIT 5(1582453177 - p.posted)<301 AND left( p.message, 21)='Testujeme nějakej zaj' )SELECT t.id as topic_id, t.uid as poster_id, t.subject, t.desc_x, t.article as message, t.posted as posted, p.topic_id, p.poster_id, t.poster as username, u.email, u.url, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.message, p.posted as posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM topics AS t INNER JOIN (SELECT p.topic_id, p.poster_id, t.poster as username, u.email, u.url, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.message, p.posted as posted, p.edited, p.edited_by FROM post AS p UNION VALUES ROW (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)) posts) ON (t.id=p.topic_id) INNER JOIN users AS u ON (u.id=p.poster_id ) OR (p.poster_id IS NULL AND u.id=5) INNER JOIN groups AS g ON g.g_id=u.group_id LEFT JOIN online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE t.id=41 ORDER BY p.id
$query = array(
u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.message, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online
'SELECT' => 't.id as topic_id, t.uid as poster_id, t.subject, t.desc_x, t.article as message, t.posted as posted, p.topic_id, p.poster_id, t.poster as username, u.email, u.url, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.message, p.posted as posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online',
'FROM' => 'topics AS t',
'JOINS' => array(
array(
'INNER JOIN' => '(SELECT p.topic_id, p.poster_id, t.poster as username, u.email, u.url, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.message, p.posted as posted, p.edited, p.edited_by FROM post AS p UNION VALUES ROW (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)) posts)',
'ON' => '(t.id=p.topic_id)'
),
array(
'INNER JOIN' => 'users AS u',
'ON' => '(u.id=p.poster_id ) OR (p.poster_id IS NULL AND u.id='.$authors_id.')'
),
array(
'INNER JOIN' => 'groups AS g',
'ON' => 'g.g_id=u.group_id'
),
array(
'LEFT JOIN' => 'online AS o',
'ON' => '(o.user_id=u.id AND o.user_id!=1 AND o.idle=0)'
)
),
'WHERE' => 't.id='.$id,
'ORDER BY' => 'p.id'
);
ON (u.id=p.poster_id AND p.poster_id IS NOT NULL) OR (p.poster_id IS NULL AND u.id=5)
SELECT t.id, t.uid, t.posted AS posted, p.topic_id, p.poster_id, u.email, u.url, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.message, p.posted AS posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online
FROM topics AS t
LEFT JOIN posts AS p ON ( t.id = p.topic_id )
INNER JOIN users AS u ON u.id = p.poster_id
OR u.id =5
INNER JOIN groups AS g ON g.g_id = u.group_id
LEFT JOIN online AS o ON ( o.user_id = u.id
AND o.user_id !=1
AND o.idle =0 )
WHERE t.uid =5
ORDER BY p.id
LIMIT 0 , 30
INNER JOIN users AS u ON u.id = p.poster_id
OR u.id =5
INNER JOIN groups AS g ON g.g_id = u.group_id
LEFT JOIN online AS o ON ( o.user_id = u.id
AND o.user_id !=1
AND o.idle =0 )
WHERE t.uid =5
ORDER BY p.id
LIMIT 0 , 30
id uid topic_id poster_id
41 5 NULL NULL
Root.cz (www.root.cz), informace nejen ze světa Linuxu. ISSN 1212-8309
Copyright © 1998 – 2023 Internet Info, s.r.o. Všechna práva vyhrazena. Powered by Linux.