Topic: Relative date

[Romik84]

Hello, I would like to ask you for help. I use Customizable Post Listing and I would like to show date like relative. It means when I pubilsh a article on the day it will show beside title Today. What shoul I add or change in this code:

Code: [Select]

function c2c_get_recent_posts ($num_posts = 5,
$format = "<li>%post_date%: %post_URL%</li>",
$categories = '', // space separated list of category IDs -- leave empty to get all
$orderby = 'date',
$order = 'DESC', // either 'ASC' (ascending) or 'DESC' (descending)
$offset = 0, // number of posts to skip
$date_format = 'M j', // Date format, php-style, if different from blog's date-format setting
$authors = '', // space separated list of author IDs -- leave empty to get all
$include_passworded_posts = false)
{
global $wpdb, $tablecomments, $tableposts, $tablepost2cat;
if ($add_recent_comment_to_sql && !isset($tablecomments)) $tablecomments = $wpdb->comments;
if (!isset($tablepost2cat)) $tablepost2cat = $wpdb->post2cat;
if (!isset($tableposts)) $tableposts = $wpdb->posts;
if ($order != 'ASC') $order = 'DESC';
if ('max_comment_date' == $orderby) { $add_recent_comment_to_sql = 1; }
else {
if ($orderby != 'rand()') $orderby = "$tableposts.post_$orderby";
$add_recent_comment_to_sql = 0;
}
$include_sticky_posts = true;

$now = current_time('mysql');
if ($add_recent_comment_to_sql) $sql = "SELECT $tableposts.*, MAX(comment_date) AS max_comment_date FROM $tablecomments, $tableposts ";
else $sql = "SELECT DISTINCT * FROM $tableposts ";
if ($categories) {
$sql .= "LEFT JOIN $tablepost2cat ON ($tableposts.ID = $tablepost2cat.post_id) ";
$cats = explode(' ', $categories);
}
$sql .= "WHERE $tableposts.post_date <= '$now' AND $tableposts.post_type = 'post' AND ( $tableposts.post_status = 'publish' ";
if ($include_sticky_posts) $sql .= "OR $tableposts.post_status = 'sticky' ";
$sql .= ") ";
if (!$include_passworded_posts) $sql .= "AND $tableposts.post_password = '' ";
if ($add_recent_comment_to_sql) $sql .= "AND $tableposts.ID = $tablecomments.comment_post_ID AND $tablecomments.comment_approved = '1' ";
if ($categories) {
$first = 1;
$sql .= "AND ( ";
foreach ($cats as $cat) {
if ($first) $first = 0;
else $sql .= "OR ";
$sql .= "$tablepost2cat.category_id = '$cat' ";
}
$sql .= ") ";
}
if ($authors) {
$auths = explode(' ', $authors);
$first = 1;
$sql .= "AND ( ";
foreach ($auths as $author) {
if ($first) $first = 0;
else $sql .= "OR ";
$sql .= "$tableposts.post_author = '$author' ";
}
$sql .= ") ";
}
if ('modified' == $orderby) $sql .= "AND $tableposts.post_modified_gmt <= '$now' ";
$sql .= "GROUP BY $tableposts.ID ORDER BY $orderby $order";
if ($num_posts) $sql .= " LIMIT $offset, $num_posts";
$posts = array();
$posts = $wpdb->get_results($sql);
if (empty($posts)) return;
return c2c_get_recent_handler($posts, $format, $date_format);
} //end function c2c_get_recent_posts()
thanks. 

[GaMerZ]

you may want to try my wp-relativedate plugin to see if it works, id it don't, I do not think I can help you with it because it is quite tedious.

[Ttech]

...

[Romik84]

ok. It works but only in Category template. Isn't there a way how I could modify it? I need add the function to this code:

Code: [Select]

<?php c2c_get_recent_posts(3,"<li>%post_URL% <strong>%post_date%</strong><br /><span class='square'>%post_excerpt_short%</span></li>",1);?>

[GaMerZ]

modify it? not, it is not that straight forward.

[Romik84]

oh ok...so I cant do anything 

[GaMerZ]

yeap