Tuesday, February 14, 2012 | Register | Login 
Minimize
 Module Support Forums
 
 Forum Forum metaPost Forums metaPost Forums Providers - Ven... Providers - Ven... MetaPost 1.3.7 and Article Image MetaPost 1.3.7 and Article Image
Previous Previous
 
Next Next
New Post
 3/11/2010 8:44 AM
DirkM
1 posts
No Ranking


MetaPost 1.3.7 and Article Image
 
Hello,

is the "ai" parameter in the alternate imagetext still working? I´ve tried this with mp 1.3.7, na .0.7.62 and dnn 5.2.3 but the image is still shown in the summery - as a placeholder with a red x in the summary. The image isn´t saved as an article image.

Dirk
 
New Post
 3/29/2010 12:06 PM
Don Worthley
332 posts
8th Level Poster


Re: MetaPost 1.3.7 and Article Image
 
Changes in 7.62 broke this feature.  A resolution is to execute the following SQL to create a trigger on the Article table.  As always, be sure to back up your database before running SQL from the hosts SQL tool:

---- Begin SQL ------

-- =============================================
-- Author:  Don Worthley, Old Town IT
-- Create date: 3/29/2010
-- Description: Trigger to Update Image Files for News Articles to New Format
-- =============================================
CREATE TRIGGER {databaseOwner}{objectQualifier}itc_metapost_news_articles_image_update
   ON  {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article
   AFTER INSERT,UPDATE
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    INSERT INTO {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Image(ArticleID, Title, FileName, Extension, Size, Width, Height, ContentType, Folder, SortOrder)
 SELECT
  a.ArticleID,
  f.FileName,
  f.FileName,
  f.Extension,
  f.Size,
  f.Width,
  f.Height,
  f.ContentType,
  f.Folder,
  0
 FROM
  {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article a INNER JOIN
   {databaseOwner}{objectQualifier}Files f ON 'FileID=' + CONVERT(varchar, f.FileID) = a.ImageUrl

 UPDATE
  {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article
 SET
  ImageUrl = NULL
 WHERE
  ArticleID IN (SELECT a.ArticleID FROM {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article a INNER JOIN {databaseOwner}{objectQualifier}Files f ON 'FileID=' + CONVERT(varchar, f.FileID) = a.ImageUrl)

 UPDATE
  {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article
 SET
  ImageCount = (SELECT count(*) FROM {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Image i WHERE {databaseOwner}{objectQualifier}DnnForge_NewsArticles_Article.ArticleID = i.ArticleID)

END
GO

 
Previous Previous
 
Next Next
 Forum Forum metaPost Forums metaPost Forums Providers - Ven... Providers - Ven... MetaPost 1.3.7 and Article Image MetaPost 1.3.7 and Article Image