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();