public function columnUrl()
{
$intColumnId = intval($this->input['column_id']);
if (!$intColumnId) {
$this->errorOutput('NO COLUMN_ID');
}
$sql = "SELECT col.id,col.special_id,col.column_name,col.outlink,spe.column_url\n FROM " . DB_PREFIX . "special_columns col \n LEFT JOIN " . DB_PREFIX . "special spe\n ON col.special_id = spe.id \n WHERE 1 AND col.id = " . $intColumnId;
$arColumnInfo = $this->db->query_first($sql);
if (!empty($arColumnInfo)) {
if (!$arColumnInfo['outlink']) {
$arColumnInfo['column_url'] = $arColumnInfo['column_url'] ? unserialize($arColumnInfo['column_url']) : array();
$intContentId = array_pop($arColumnInfo['column_url']);
if (!class_exists('publishcontent')) {
include ROOT_PATH . 'lib/class/publishcontent.class.php';
}
$objPublishContent = new publishcontent();
$arSpecialInfo = $objPublishContent->get_content_by_rid($intContentId);
$arColumnInfo['column_url'] = $arSpecialInfo['content_url'];
$arColumnInfo['column_url'] = explode('/', $arColumnInfo['column_url']);
array_pop($arColumnInfo['column_url']);
$arColumnInfo['column_url'] = implode('/', $arColumnInfo['column_url']);
$arColumnInfo['column_url'] = $arColumnInfo['column_url'] ? rtrim($arColumnInfo['column_url'], '/') . '/' . $arColumnInfo['id'] . '_list.html' : '';
if (!$arColumnInfo['column_url']) {
$arColumnInfo['column_url'] = COLURL . $arColumnInfo['id'];
}
} else {
$arColumnInfo['column_url'] = $arColumnInfo['outlink'];
}
}
$this->addItem($arColumnInfo['column_url']);
$this->output();
}
public function get_published_content_byid($id)
{
include_once ROOT_PATH . 'lib/class/publishcontent.class.php';
$publish_server = new publishcontent();
return $publish_server->get_content_by_rid($id);
}