egy oldal rész kommentejeinek kihagyása

Archívum 2006-2018.11.09 egyeb-temak
#1

az alábbi oldalon http://www.supertutorial.hu/











használok egy sima kommenteket mutató részt és egy üzenőfal plugint ami az itt http://www.supertutorial.hu/wp-wall-guestbook/ található kommenteket listázza ki a főoldalra











azt szeretném, hogy a sima kommenteket mutató rész ne mutatná azokat a kommenteket ami az üzenőfalhoz érkezik











a sima kommenteket mutató részre ezt használom





<?php global &#036;wpdb; $sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_author_url, SUBSTRING(comment_content,1,80) AS com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 10"; $comments = $wpdb->get_results($sql); $output = $pre_HTML; $output .= "\n

"; $output .= $post_HTML; echo $output;?>

ezt itt átlehetne úgy írni hogy a http://www.supertutorial.hu/wp-wall-guestbook/ oldalra érkező kommenteket ne vegye figyelembe?[code=php:1pzcgp92] <?php global &#036;wpdb; $sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_author_url, SUBSTRING(comment_content,1,80) AS com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 10"; $comments = $wpdb->get_results($sql); $output = $pre_HTML; $output .= "\n

"; $output .= $post_HTML; echo $output;?>











ezt itt átlehetne úgy írni hogy a http://www.supertutorial.hu/wp-wall-guestbook/ oldalra érkező kommenteket ne vegye figyelembe?

#2

talán most átláthatóbban sikerül beilleszteni a kódot











<?php global &#036;wpdb; $sql = “SELECT DISTINCT ID, post_title, post_password, comment_ID,


comment_post_ID, comment_author, comment_date_gmt, comment_approved,


comment_type,comment_author_url,


SUBSTRING(comment_content,1,80) AS com_excerpt


FROM &#036;wpdb->comments


LEFT OUTER JOIN &#036;wpdb->posts ON ($wpdb->comments.comment_post_ID =


&#036;wpdb->posts.ID) WHERE comment_approved = ‘1’ AND comment_type = ‘’ AND post_password = ‘’ ORDER BY comment_date_gmt DESC LIMIT 10”; $comments = $wpdb->get_results($sql);


&#036;output = $pre_HTML; $output .= “\n

    ”;


foreach (&#036;comments as $comment)


{ &#036;output .= “\n
  • ”.strip_tags($comment->comment_author) .":" . " ID) . “#comment-” . $comment->comment_ID . “\” title=\" " . $comment->post_title . “\”>" . strip_tags($comment->com_excerpt) ."…
    • "; } $output .= “\n”; $output .= $post_HTML;


    echo &#036;output;?>[code=php:2vnf9a4h]<?php global &#036;wpdb; $sql = “SELECT DISTINCT ID, post_title, post_password, comment_ID,


    comment_post_ID, comment_author, comment_date_gmt, comment_approved,


    comment_type,comment_author_url,


    SUBSTRING(comment_content,1,80) AS com_excerpt


    FROM     &#036;wpdb->comments


    LEFT OUTER JOIN &#036;wpdb->posts ON ($wpdb->comments.comment_post_ID =


    &#036;wpdb->posts.ID) WHERE comment_approved = ‘1’ AND comment_type = ‘’ AND post_password = ‘’ ORDER BY comment_date_gmt DESC LIMIT 10”; $comments = $wpdb->get_results($sql);


    &#036;output = $pre_HTML; $output .= “\n
      ”;


    foreach (&#036;comments as $comment)


    { &#036;output .= “\n
  • ”.strip_tags($comment->comment_author) .":" . " ID) . “#comment-” . $comment->comment_ID . “\” title=\" " . $comment->post_title . “\”>" . strip_tags($comment->com_excerpt) ."…
    • "; } $output .= “\n”; $output .= $post_HTML;


    echo &#036;output;?>