diff options
Diffstat (limited to 'include/items.php')
| -rwxr-xr-x | include/items.php | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/include/items.php b/include/items.php index ee7bfd5bc..eb7b9ef78 100755 --- a/include/items.php +++ b/include/items.php @@ -3782,18 +3782,30 @@ function delete_item_lowlevel($item, $stage = DROPITEM_NORMAL, $force = false) { * * @param int $uid * @param boolean $wall (optional) default false + * hack: $wall = 2 selects articles * @return string|boolean date string, otherwise false */ function first_post_date($uid, $wall = false) { - $wall_sql = (($wall) ? " and item_wall = 1 " : "" ); - $item_normal = item_normal(); + $wall_sql = (($wall === 1) ? " and item_wall = 1 " : "" ); + if($wall === 2) { + $wall_sql = " and item_type = 7 "; + $item_normal = " and item.item_hidden = 0 and item.item_type = 7 and item.item_deleted = 0 + and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0 + and item.item_blocked = 0 "; + + } + else { + $item_normal = item_normal(); + } + $r = q("select id, created from item where uid = %d and id = parent $item_normal $wall_sql order by created asc limit 1", intval($uid) ); + if($r) { // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA); return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10); |