function tkzy_get_recent_comments($limit = 10)
{
global $wpdb, $tablecomments, $tableposts;
global $siteurl, $blogfilename;
$lcomments = $wpdb->get_results("SELECT ID, post_title, post_date, \n comment_ID, comment_author, comment_author_url, comment_author_email, comment_date, comment_content \n FROM {$tableposts}, {$tablecomments} WHERE {$tableposts}.ID={$tablecomments}.comment_post_ID \n ORDER BY {$tablecomments}.comment_date DESC LIMIT {$limit}");
$output = '';
function sort_comment_by_date($a, $b)
{
if ($b->ID == $a->ID) {
return mysql2date('U', $a->comment_date) - mysql2date('U', $b->comment_date);
}
return mysql2date('U', $b->post_date) - mysql2date('U', $a->post_date);
}
if ($lcomments) {
usort($lcomments, "sort_comment_by_date");
}
$new_post_ID = -1;
if ($lcomments) {
foreach ($lcomments as $lcomment) {
if ($lcomment->ID != $new_post_ID) {
// next post
if ($new_post_ID != -1) {
$output .= "\t</ul>\n</li>\n";
}
$post_title = stripslashes($lcomment->post_title);
$permalink = "{$siteurl}/{$blogfilename}?p={$lcomment->ID}&c=1";
$output .= "<li>";
$output .= "<a href=\"{$permalink}\">{$post_title}</a>\n";
$output .= "\t<ul>\n";
$new_post_ID = $lcomment->ID;
}
$comment_date = $lcomment->comment_date;
if (time() - mysql2date('U', $comment_date) < 60 * 60 * 24) {
# within 24 hours
$comment_date = mysql2date('H:i', $comment_date);
} else {
$comment_date = mysql2date('m/d', $comment_date);
}
$output .= "\t\t<li style=\"list-style: none;\"><span style=\"font-size:90%;\" class=\"comment_date\">{$comment_date} </span>" . "<span class=\"comment_author\">" . tkzy_get_comment_author_link($lcomment, 25) . "</span></li>\n";
if (preg_match('|<trackback />|', $lcomment->comment_content)) {
$type = '[TrackBack]';
} elseif (preg_match('|<pingback />|', $lcomment->comment_content)) {
$type = '[Ping]';
} else {
$type = '[Comment]';
}
$output .= "<span style=\"font-size:70%\"> - {$type}</span>";
}
}
$output .= "\t</ul>\n</li>\n";
return $output;
}
function tkzy_get_recent_comments($limit = 10, $cat_date = 1, $show_type = 1)
{
$comment_lenth = 30;
$request = "SELECT ID, post_title, post_date, \n\t\tcomment_ID, comment_author, comment_author_url, comment_author_email, comment_date, comment_content \n\t\tFROM " . wp_table('posts') . ", " . wp_table('comments') . " WHERE " . wp_table('posts') . ".ID=" . wp_table('comments') . ".comment_post_ID AND " . wp_table('comments') . ".comment_approved='1'";
if (get_xoops_option(wp_mod(), 'wp_use_xoops_comments') == 1) {
$request .= "AND (comment_content like '<trackback />%' OR comment_content like '<pingkback />%') ";
}
$request .= " ORDER BY " . wp_table('comments') . ".comment_date DESC LIMIT {$limit}";
$lcomments = $GLOBALS['wpdb']->get_results($request);
$output = '';
if ($lcomments) {
usort($lcomments, "sort_comment_by_date");
}
$new_post_ID = -1;
if ($lcomments) {
$output .= "<ul class='wpBlockList'>";
foreach ($lcomments as $lcomment) {
if ($lcomment->ID != $new_post_ID) {
// next post
if ($new_post_ID != -1) {
$output .= "\t</ul>\n</li>\n";
}
$post_title = stripslashes($lcomment->post_title);
if (trim($post_title) == "") {
$post_title = _WP_POST_NOTITLE;
}
$comment_content = strip_tags($lcomment->comment_content);
$comment_content = stripslashes($comment_content);
if (function_exists('mb_substr')) {
$comment_excerpt = mb_substr($comment_content, 0, $comment_lenth);
} else {
$comment_excerpt = substr($comment_content, 0, $comment_lenth);
}
$permalink = wp_siteurl() . "/index.php?p={$lcomment->ID}&c=1";
$output .= "<li>";
$output .= "<span class='comment-title'><a href=\"{$permalink}\">{$post_title}</a></span>\n";
$output .= "\t<ul class=\"children\" style=\"list-style-type: none;\">\n";
$new_post_ID = $lcomment->ID;
}
$output .= "\t\t<li>";
if ($cat_date) {
$comment_date = $lcomment->comment_date;
if (time() - mysql2date('U', $comment_date) < 60 * 60 * 24) {
# within 24 hours
$comment_date = mysql2date('H:i', $comment_date);
} else {
$comment_date = mysql2date('m/d', $comment_date);
}
$output .= "<span class=\"post-date\">{$comment_date}</span> : ";
}
$output .= "<span class=\"comment_author\">" . tkzy_get_comment_author_link($lcomment, 25) . "</span></li>\n";
if (preg_match('|<trackback />|', $lcomment->comment_content)) {
$type = '[TrackBack]';
} elseif (preg_match('|<pingback />|', $lcomment->comment_content)) {
$type = '[Ping]';
} else {
$type = '[Comment]';
}
if ($show_type) {
$output .= "<span style=\"font-size:90%\"> - {$type}</span>";
}
}
}
$output .= "\t</ul>\n</li>\n</ul>\n";
return $output;
}
function tkzy_get_recent_comments($limit = 10, $cat_date = 1, $show_type = 1)
{
$comment_lenth = 30;
$request = 'SELECT ID, post_title, post_date,
comment_ID, comment_author, comment_author_url, comment_author_email, comment_date, comment_content
FROM ' . wp_table('posts') . ', ' . wp_table('comments') . ' WHERE ' . wp_table('posts') . '.ID=' . wp_table('comments') . '.comment_post_ID AND ' . wp_table('comments') . '.comment_approved=\'1\'';
if (get_xoops_option(wp_mod(), 'wp_use_xoops_comments') == 1) {
$request .= ' AND (comment_content like \'<trackback />%\' OR comment_content like \'<pingkback />%\') ';
}
$request .= ' ORDER BY ' . wp_table('comments') . '.comment_date DESC LIMIT ' . $limit;
$lcomments = $GLOBALS['wpdb']->get_results($request);
$output = '';
if ($lcomments) {
usort($lcomments, 'sort_comment_by_date');
}
$new_post_ID = -1;
if ($lcomments) {
$output .= '<ul class="wpBlockList">';
foreach ($lcomments as $lcomment) {
if ($lcomment->ID != $new_post_ID) {
// next post
if ($new_post_ID != -1) {
$output .= '</ul></li>';
}
$post_title = stripslashes($lcomment->post_title);
if (trim($post_title) == "") {
$post_title = _WP_POST_NOTITLE;
}
$comment_content = strip_tags($lcomment->comment_content);
$comment_content = stripslashes($comment_content);
if (function_exists('mb_substr')) {
$comment_excerpt = mb_substr($comment_content, 0, $comment_lenth);
} else {
$comment_excerpt = substr($comment_content, 0, $comment_lenth);
}
$permalink = wp_siteurl() . '/index.php?p=' . $lcomment->ID . '&c=1';
$output .= '<li>';
$output .= '<span class="comment-title"><a href="' . $permalink . '">' . $post_title . '</a></span>';
$output .= '<ul class="children" style="list-style-type: none;">';
$new_post_ID = $lcomment->ID;
}
$output .= "\t\t<li>";
if ($cat_date) {
$comment_date = $lcomment->comment_date;
if (time() - mysql2date('U', $comment_date) < 60 * 60 * 24) {
# within 24 hours
$comment_date = mysql2date('H:i', $comment_date);
} else {
$comment_date = mysql2date('m/d', $comment_date);
}
$output .= '<span class="post-date">' . $comment_date . '</span> : ';
}
$output .= '<span class="comment_author">' . tkzy_get_comment_author_link($lcomment, 25) . '</span></li>';
if (preg_match('|<trackback />|', $lcomment->comment_content)) {
$type = '[TrackBack]';
} elseif (preg_match('|<pingback />|', $lcomment->comment_content)) {
$type = '[Ping]';
} else {
$type = '[Comment]';
}
if ($show_type) {
$output .= '<span style="font-size:90%"> - ' . $type . '</span>';
}
}
}
$output .= '</ul></li></ul>';
return $output;
}
function tkzy_get_recent_comments($limit = 10, $cat_date = 1, $show_type = 1)
{
global $wpdb, $wp_id;
global $siteurl;
$comment_lenth = 30;
$lcomments = $wpdb->get_results("SELECT ID, post_title, post_date, \n\t\tcomment_ID, comment_author, comment_author_url, comment_author_email, comment_date, comment_content \n\t\tFROM {$wpdb->posts[$wp_id]}, {$wpdb->comments[$wp_id]} WHERE {$wpdb->posts[$wp_id]}.ID={$wpdb->comments[$wp_id]}.comment_post_ID AND {$wpdb->comments[$wp_id]}.comment_approved='1'\n\t\tORDER BY {$wpdb->comments[$wp_id]}.comment_date DESC LIMIT {$limit}");
$output = '';
if ($lcomments) {
usort($lcomments, "sort_comment_by_date");
}
$new_post_ID = -1;
if ($lcomments) {
$output .= "<ul class='wpBlockList'>";
foreach ($lcomments as $lcomment) {
if ($lcomment->ID != $new_post_ID) {
// next post
if ($new_post_ID != -1) {
$output .= "\t</ul>\n</li>\n";
}
$post_title = stripslashes($lcomment->post_title);
if (trim($post_title) == "") {
$post_title = _WP_POST_NOTITLE;
}
$comment_content = strip_tags($lcomment->comment_content);
$comment_content = stripslashes($comment_content);
if (function_exists('mb_substr')) {
$comment_excerpt = mb_substr($comment_content, 0, $comment_lenth);
} else {
$comment_excerpt = substr($comment_content, 0, $comment_lenth);
}
$permalink = "{$siteurl}/index.php?p={$lcomment->ID}&c=1";
$output .= "<li>";
$output .= "<span class='comment-title'><a href=\"{$permalink}\">{$post_title}</a></span>\n";
$output .= "\t<ul class=\"children\" style=\"list-style-type: none;\">\n";
$new_post_ID = $lcomment->ID;
}
$output .= "\t\t<li>";
if ($cat_date) {
$comment_date = $lcomment->comment_date;
if (time() - mysql2date('U', $comment_date) < 60 * 60 * 24) {
# within 24 hours
$comment_date = mysql2date('H:i', $comment_date);
} else {
$comment_date = mysql2date('m/d', $comment_date);
}
$output .= "<span class=\"post-date\">{$comment_date}</span> : ";
}
$output .= "<span class=\"comment_author\">" . tkzy_get_comment_author_link($lcomment, 25) . "</span></li>\n";
if (preg_match('|<trackback />|', $lcomment->comment_content)) {
$type = '[TrackBack]';
} elseif (preg_match('|<pingback />|', $lcomment->comment_content)) {
$type = '[Ping]';
} else {
$type = '[Comment]';
}
if ($show_type) {
$output .= "<span style=\"font-size:90%\"> - {$type}</span>";
}
}
}
$output .= "\t</ul>\n</li>\n</ul>\n";
return $output;
}
