viewcomment.php実行時の例
赤字:「友人」・「友人の友人」抽出部分
青字:グループ指定・メンバー指定部分
"SELECT p.post_id, p.subject, p.post_time, p.uid, p.guest_name, p.unique_path,
t.topic_external_link_id, u.uname, u.name, d.bid, d.cid,
c.cname, c.openarea as openareacat FROM xxx_forum_posts p
INNER JOIN xxx_forum_topics t ON (t.topic_id=p.topic_id AND ! t.topic_invisible )
INNER JOIN xxx_forum_forums f ON (f.forum_id=t.forum_id AND f.forum_id='10')
INNER JOIN xxx_diary3_diary d ON t.topic_external_link_id=d.bid AND d.uid=4
LEFT JOIN xxx_diary3_category c ON (d.uid=c.uid OR c.uid=0) AND d.cid=c.cid
LEFT JOIN xxx_users u ON p.uid=u.uid
LEFT JOIN xxx_diary3_config cfg ON d.uid=cfg.uid
WHERE ! t.topic_invisible AND (d.uid='2' OR (d.openarea <>100 AND ( ( ( ( (d.openarea IN (0,1) )
AND (cfg.openarea IN (0,1) OR cfg.openarea IS NULL) AND (c.openarea IN (0,1) OR c.openarea IS NULL) )
OR ( ( (d.openarea='2' AND (c.openarea<='3' OR c.openarea IS NULL) AND (cfg.openarea<='3' OR cfg.openarea IS NULL) ) OR (c.openarea='2' AND d.openarea<='3' AND (cfg.openarea<='3' OR cfg.openarea IS NULL) ) OR (cfg.openarea='2' AND d.openarea<='3' AND (c.openarea<='3' OR c.openarea IS NULL) ) ) AND d.uid IN (1) ) OR ( ( (d.openarea='3' AND (c.openarea<='3' OR c.openarea IS NULL) AND (cfg.openarea<='3' OR cfg.openarea IS NULL) ) OR (c.openarea='3' AND d.openarea<='3' AND (cfg.openarea<='3' OR cfg.openarea IS NULL) ) OR (cfg.openarea='3' AND d.openarea<='3' AND (c.openarea<='3' OR c.openarea IS NULL) ) ) AND d.uid IN (1,2,3) ) )
OR ( (d.openarea='10' OR d.openarea='20') AND (d.vgids LIKE '%|2|%' OR d.vgids LIKE '%|4|%') ) OR ( (c.openarea='10' OR c.openarea='20') AND (c.vgids LIKE '%|2|%' OR c.vgids LIKE '%|4|%') ) ) OR (d.openarea='20' AND d.vpids LIKE '%|2|%') OR (c.openarea='20' AND c.vpids LIKE '%|2|%') ) ) )
ORDER BY p.post_time DESC LIMIT 0,50"
|