This forum is obsolete

This support forum has been replaced by a news version. You can browse old posts in this forum, but please post your questions to the new forum by clicking on "Support" in the top level menu.

Support Forum
Subject: Support for Core Taxonomy as Categories?
Prev Next
You are not authorized to post a reply.

Author Messages
Steven Webster
Posts:92
Diamond Member


01/10/2013 5:07 PM  
Wondering if you have plans to use the core taxonomy within DNN as categories within UVG?

Steven Webster
dnnOsphere.com, An Independant Community for DNN Users
Pengtsen R
Posts:13551


01/11/2013 12:23 AM  
This script should help you:



if exists(select * from dbo.sysobjects where id = object_id('{databaseOwner}{objectQualifier}Taxonomy_Vocabularies') and type = 'U')
begin

declare @VocabularyID int
select @VocabularyID = VocabularyID from {databaseOwner}{objectQualifier}Taxonomy_Vocabularies where Name='Module_Categories'

declare @TermId int
if not exists (SELECT * FROM {databaseOwner}{objectQualifier}Taxonomy_Terms WHERE Name='UltraVideoGallery')
begin
Insert {databaseOwner}{objectQualifier}Taxonomy_Terms(VocabularyID, Name, Weight, TermLeft, TermRight) Values(@VocabularyID, 'UltraVideoGallery', 0, 0, 0)
select @TermId = SCOPE_IDENTITY()
end
else
begin
select @TermId = TermId from {databaseOwner}{objectQualifier}Taxonomy_Terms where Name = 'UltraVideoGallery'
end

Delete {databaseOwner}{objectQualifier}ContentItems_Tags Where TermID = @TermID

INSERT INTO {databaseOwner}{objectQualifier}ContentItems_Tags (TermID,ContentItemID) SELECT @TermID, ContentItemID from {databaseOwner}{objectQualifier}DesktopModules where FolderName='UltraVideoGallery'

end

Pengtsen R
http://www.bizmodules.net
You are not authorized to post a reply.
Forums > Ultra Video Gallery > General Questions > Support for Core Taxonomy as Categories?

Copyright © 2005-2013 BizModules Contact us