CMS Made Simple Forums

Code: Select all

if (isset($params['id'])) {
  $blog_ID = trim($params['id']);
  $blog_text = trim($params['text']);

  $db = cmsms()->GetDb();

  $query1 = "SELECT url,cgblog_title,status FROM ".cms_db_prefix()."module_cgblog WHERE cgblog_id = '$blog_ID'";
  $result1 = $db->Execute($query1);

  while ($result1 && $row = $result1->FetchRow()) {
        $url = $row['url'];
        $title = $row['cgblog_title'];
        $status = $row['status'];
   }

    //load config data
    $config = cmsms()->GetConfig();	
    //build the link how you like
    $url = $config['root_url'].'/my-cgblog-prefix/'.$blog_ID.'/'.$url.$config['page_extension'];

    if($blog_text =='') {
        $blog_text = $title;
     }
    //if article is active ->publish link, else text only.
    if($status =='published') {  echo "<a href='$url'>$blog_text</a>"; }
    else {     echo $blog_text; }
}