if (!iMEMBER) redirect(FUSION_SELF);
$alb_where = dbcount("(alb_post_user)", DB_AL_BLOG_POSTS, "(alb_post_user='".$user_data['user_id']."')") ? " WHERE p.alb_post_user='".$user_data['user_id']."' " : " ";
$result = dbquery("SELECT p.*,pc.* FROM ".DB_AL_BLOG_POSTS." p LEFT JOIN ".DB_AL_BLOG_CATEGORIES." pc ON pc.alb_cat_id=p.alb_post_cat".$alb_where."ORDER BY alb_post_datestamp DESC");
if (dbrows($result)) {
opentable($locale['alb20']);
while ($data=dbarray($result)) {
// if ($data['alb_post_draft'] == 1) {
// $status = $locale['alb14'];
// } else {
$status = $data['alb_post_status'] == 1 ? $locale['alb45'] : $locale['alb46'];
// }
echo "".$data['alb_post_title']."
";
}
closetable();