query("DELETE FROM cms_tags WHERE target='$target' AND item_id = $item_id");
if ($tagstr){
$tagstr = str_replace(', ', ',', $tagstr);
$tagstr = str_replace(' ,', ',', $tagstr);
$tags = explode(',', $tagstr);
foreach ($tags as $key=>$tag){
if(strlen($tag)>1){
if (strlen($tag>15) && !(strstr($tag, ' ') || strstr($tag, '-'))) { $tag = substr($tag, 0, 15); }
$tag = str_replace("\\", '', $tag);
$tag = str_replace('"', '', $tag);
$tag = str_replace("'", '', $tag);
$tag = str_replace("&", '', $tag);
$tag = strtolower($tag);
$sql = "INSERT INTO cms_tags (tag, target, item_id) VALUES ('$tag', '$target', $item_id)";
$inDB->query($sql);
}
}
}
return;
}
function cmsClearTags($target, $item_id){
$inDB = cmsDatabase::getInstance();
$inDB->query("DELETE FROM cms_tags WHERE target='$target' AND item_id = $item_id");
return;
}
function cmsTagLine($target, $item_id, $links=true, $selected=''){
$inDB = cmsDatabase::getInstance();
$sql = "SELECT tag
FROM cms_tags
WHERE target='$target' AND item_id=$item_id
ORDER BY tag DESC";
$rs = $inDB->query($sql) or die('Error while building tagline');
$html = '';
$tags = $inDB->num_rows($rs);
if ($tags){
$t = 1;
while ($tag=$inDB->fetch_assoc($rs)){
if ($links){
if ($selected==$tag['tag']){
$html .= ''.$tag['tag'].'';
} else {
$html .= ''.$tag['tag'].'';
}
} else {
$html .= $tag['tag'];
}
if ($t < $tags) { $html .= ', '; $t++; }
}
} else {
$html = '';
}
return $html;
}
function cmsTagBar($target, $item_id, $selected=''){
$inDB = cmsDatabase::getInstance();
if ($tagline = cmsTagLine($target, $item_id, true, $selected)){
return 'Теги: '.$tagline.'
';
} else {
return '';
}
}
function cmsTagItemLink($target, $item_id){
$inDB = cmsDatabase::getInstance();
switch ($target){
case 'content': $sql = "SELECT i.title as title, c.title as cat, i.seolink as seolink, c.seolink as cat_seolink
FROM cms_content i
LEFT JOIN cms_category c ON c.id = i.category_id
WHERE i.id = '$item_id' AND i.published = 1";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'blogpost': $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id, c.owner as owner, c.user_id user_id, i.seolink as seolink, c.seolink as bloglink
FROM cms_blog_posts i
LEFT JOIN cms_blogs c ON c.id = i.blog_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
if ($item['owner'] == 'club') { $item['cat'] = dbGetField('cms_clubs','id='.$item['user_id'],'title'); }
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'photo': $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id
FROM cms_photo_files i
LEFT JOIN cms_photo_albums c ON c.id = i.album_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'userphoto': $sql = "SELECT i.title as title, i.id as item_id, c.nickname as cat, c.id as cat_id, c.login as login
FROM cms_user_photos i
LEFT JOIN cms_users c ON c.id = i.user_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'catalog': $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id
FROM cms_uc_items i
LEFT JOIN cms_uc_cats c ON c.id = i.category_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'video': $sql = "SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id
FROM cms_video_movie i
LEFT JOIN cms_video_category c ON c.id = i.cat_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'shop': $sql = "SELECT i.title as title, i.seolink as seolink, c.title as cat, c.seolink as cat_seolink
FROM cms_shop_items i
LEFT JOIN cms_shop_cats c ON c.id = i.category_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
case 'maps': $sql = "SELECT i.title as title, i.seolink as seolink, c.title as cat, c.seolink as cat_seolink
FROM cms_maps_items i
LEFT JOIN cms_maps_cats c ON c.id = i.category_id
WHERE i.id = '$item_id'";
$rs = $inDB->query($sql) ;
if ($inDB->num_rows($rs)){
$item = $inDB->fetch_assoc($rs);
$link = ''.$item['cat'].' → ';
$link .= ''.$item['title'].'';
}
break;
}
return $link;
}
function cmsTagsList(){
$inDB = cmsDatabase::getInstance();
$html = '';
$sql = "SELECT t.tag, COUNT(t.tag) as num
FROM cms_tags t
GROUP BY t.tag
ORDER BY t.tag";
$result = $inDB->query($sql) ;
if ($inDB->num_rows($result)>0){
while($tag = $inDB->fetch_assoc($result)){
if ($tag['tag']){
$html .= ''.$tag['tag'].' ('.$tag['num'].') ';
}
}
}
return $html;
}
?>