Here is some code to display a link to the last (n) commented posts:
<?php $query = "SELECT ID, post_title, comment_author, comment_date FROM $tableposts, $tablecomments WHERE $tableposts.ID=$tablecomments.comment_post_ID ORDER BY $tablecomments.comment_date DESC LIMIT 5";
$result = mysql_query($query);
while ($data = mysql_fetch_row($result)) {
echo "$data[2]
$data[1]
\n";
} ?>
If you changed your tables and database in anyway you would obviously need to edit the sql calls accordingly, but other than that this works just fine.
Last (n) comments... (13 posts)
-
Anonymous
Posted 8 years ago # -
Posted 8 years ago #Oh I forgot to tell you what to do with the above code, simply insert this wherever you want the data to show up, and BAM! There it is.
I am using thi son my site now, http://www.chrisjdavis.org/ it listed under, get this; recently commented!
Later -
HateSpitLove
Posted 8 years ago #Great feature. Can you explain what character "\" stands for or should that literally be put into the code? Put into my page this way just displays the title of my post with an /n after it and no hyperlinking.
-
It's a slash. \ I had to post it to my blog to figure it out. LOL
-
Argh... a forward slash that is. ;)
I can't seem to get it to work though. I am assuming the code isn't being displayed properly here. I viewed the source and copied but still no luck. -
kenko
Posted 8 years ago #replace the echo line with this
echo "$data[2]
$data[1]<br
/>
"; -
That worked, thanks!!
-
Posted 8 years ago #Is there a WordPress 1.01 version of this hack?
-
codergurl
Posted 8 years ago #*crosses fingers*
function recent_comments($limit = 5) {
global $wpdb, $tableposts, $tablecomments, $siteurl, $blogfilename;
$out = '';
$sql = "SELECT ID, post_title, comment_ID, comment_author, comment_date, comment_content FROM $tableposts, $tablecomments";
$sql .= " WHERE $tableposts.ID=$tablecomments.comment_post_ID";
$sql .= " ORDER BY $tablecomments.comment_date DESC LIMIT $limit";
$posts = $wpdb->get_results($sql);
foreach ($posts as $post) {
$permalink = $siteurl.'/'.$blogfilename.'/?p='.$post->ID.'&c=1#comment-'.$post->comment_ID;
$comment = substr(stripslashes($post->comment_content), 0, 50);
$out .= '- '.$post->comment_author.' - '.$comment.'
';
}
echo $out;
} -
Matt Mullenweg
Posted 8 years ago #PLEASE post code to the wiki and LINK TO IT from here. Thank you.
-
Posted 8 years ago #I would use this function for the creation of a url:
get_permalink($recentcomment->post_id)
Can you put that in the script? -
chrisjdavis
Posted 8 years ago #This hack is now officially dead, go here: http://www.chrisjdavis.org/index?p=439 for the last release.
Author_list is dead as well, as is the copyright hack, at least as far as releasing them to the general public.
You will still be able to find the code @http://www/chrisjdavis.org but I won't be releasing them here anymore. I might announce when something has reached a decent level of maturity, but that is about it. -
st3fo
Posted 7 years ago #This is the right code
<li id="last_comments">
<?php _e('Last Comments:'); ?>
<ul>
<?php
$query = "SELECT ID, comment_post_ID, comment_author, comment_content FROM $tableposts, $tablecomments WHERE $tableposts.ID=$tablecomments.comment_post_ID ORDER BY $tablecomments.comment_date DESC LIMIT 5";
$result = mysql_query($query);
while ($data = mysql_fetch_row($result)) {
if (!$data[2]) {
$data[2]="Anonymous";
}
echo "<li>";
echo "[$data[2]] <a href="index.php?p=$data[1]#comments">";
echo substr($data[3],'0','80');
echo "...</a></li>";
} ?>
</ul>
</li>
Topic Closed
This topic has been closed to new replies.
