| 35 | | <dc:language><?php echo $rss_language ?></dc:language> |
|---|
| 36 | | <dc:creator><?php echo antispambot($admin_email) ?></dc:creator> |
|---|
| 37 | | <dc:rights>Copyright <?php echo mysql2date('Y', get_lastpostdate()); ?></dc:rights> |
|---|
| 38 | | <dc:date><?php echo gmdate('Y-m-d\TH:i:s'); ?></dc:date> |
|---|
| 39 | | <admin:generatorAgent rdf:resource="http://wordpress.org/?v=<?php echo $wp_version ?>"/> |
|---|
| 40 | | <admin:errorReportsTo rdf:resource="mailto:<?php echo antispambot($admin_email) ?>"/> |
|---|
| 41 | | <sy:updatePeriod>hourly</sy:updatePeriod> |
|---|
| 42 | | <sy:updateFrequency>1</sy:updateFrequency> |
|---|
| 43 | | <sy:updateBase>2000-01-01T12:00+00:00</sy:updateBase> |
|---|
| | 24 | <language><?php echo $rss_language ?></language> |
|---|
| | 25 | <pubDate><?php echo gmdate('r'); ?></pubDate> |
|---|
| | 26 | <generator>http://wordpress.org/?v=<?php echo $wp_version ?></generator> |
|---|
| 47 | | $comments = $wpdb->get_results("SELECT comment_ID, |
|---|
| 48 | | comment_author, |
|---|
| 49 | | comment_author_email, |
|---|
| 50 | | comment_author_url, |
|---|
| 51 | | comment_date, |
|---|
| 52 | | comment_content, |
|---|
| 53 | | comment_post_ID, |
|---|
| 54 | | $tableposts.ID, |
|---|
| 55 | | $tableposts.post_password |
|---|
| 56 | | FROM $tablecomments |
|---|
| 57 | | LEFT JOIN $tableposts ON comment_post_id = id |
|---|
| 58 | | WHERE comment_post_ID = '$id' |
|---|
| 59 | | AND $tablecomments.comment_approved = '1' |
|---|
| 60 | | AND $tableposts.post_status = 'publish' |
|---|
| 61 | | AND post_date < '".date("Y-m-d H:i:s")."' |
|---|
| 62 | | ORDER BY comment_date |
|---|
| 63 | | LIMIT $posts_per_rss"); |
|---|
| 64 | | } |
|---|
| 65 | | else { // if no post id passed in, we'll just ue the last 10 comments. |
|---|
| 66 | | $comments = $wpdb->get_results("SELECT comment_ID, |
|---|
| 67 | | comment_author, |
|---|
| 68 | | comment_author_email, |
|---|
| 69 | | comment_author_url, |
|---|
| 70 | | comment_date, |
|---|
| 71 | | comment_content, |
|---|
| 72 | | comment_post_ID, |
|---|
| 73 | | $tableposts.ID, |
|---|
| 74 | | $tableposts.post_password |
|---|
| 75 | | FROM $tablecomments |
|---|
| 76 | | LEFT JOIN $tableposts ON comment_post_id = id |
|---|
| 77 | | WHERE $tableposts.post_status = 'publish' |
|---|
| 78 | | AND $tablecomments.comment_approved = '1' |
|---|
| 79 | | AND post_date < '".date("Y-m-d H:i:s")."' |
|---|
| 80 | | ORDER BY comment_date DESC |
|---|
| 81 | | LIMIT $posts_per_rss"); |
|---|
| | 30 | $comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_author_email, |
|---|
| | 31 | comment_author_url, comment_date, comment_content, comment_post_ID, |
|---|
| | 32 | $tableposts.ID, $tableposts.post_password FROM $tablecomments |
|---|
| | 33 | LEFT JOIN $tableposts ON comment_post_id = id WHERE comment_post_ID = '$id' |
|---|
| | 34 | AND $tablecomments.comment_approved = '1' AND $tableposts.post_status = 'publish' |
|---|
| | 35 | AND post_date < '".date("Y-m-d H:i:s")."' |
|---|
| | 36 | ORDER BY comment_date LIMIT $posts_per_rss"); |
|---|
| | 37 | } else { // if no post id passed in, we'll just ue the last 10 comments. |
|---|
| | 38 | $comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_author_email, |
|---|
| | 39 | comment_author_url, comment_date, comment_content, comment_post_ID, |
|---|
| | 40 | $tableposts.ID, $tableposts.post_password FROM $tablecomments |
|---|
| | 41 | LEFT JOIN $tableposts ON comment_post_id = id WHERE $tableposts.post_status = 'publish' |
|---|
| | 42 | AND $tablecomments.comment_approved = '1' AND post_date < '".date("Y-m-d H:i:s")."' |
|---|
| | 43 | ORDER BY comment_date DESC LIMIT $posts_per_rss"); |
|---|