Use joomgallery for article images script

Tazzios

i use joomgallery as media manager because :

i have a lot of different usersgroups and have created an hidden album for each group where the upload there
the current media manager from joomla is not friendly
User will makes a mess (of everything) so it is nice of you still can move stuff without breaking it.

For images within an article this is not a problem but is is for the article intro and full image picture. Users can of course select there image but it will brake when images are archieved(to other category). To fix this i made the SQL script below that replaces the image path to a joomgallery url.

Code

/* Replace ep23j with your own prefix*/ 

    /*replacing article intro image with joomgalley url incase of thumbnail*/
    update `joomla`.`ep23j_content` 
    SET images=replace(images,SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1), 
    concat('index.php?option=com_joomgallery&amp;view=image&amp;format=raw&amp;id=',(SELECT  `id` FROM `joomla`.`ep23j_joomgallery` where 
    catid= (SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-2),'/',1),'_',-1))
    AND imgfilename=( SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-1) )
    ),'&amp;type=thumb') )  
    where images like  '%\\\\/joomgallery\\\\/thumbnails%' /*adjust acording to you own path */
    ;
    /*replacing article intro image with joomgalley url incase of detail*/
    update `joomla`.`ep23j_content` 
    SET images=replace(images,SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1), 
    concat('index.php?option=com_joomgallery&amp;view=image&amp;format=raw&amp;id=',(SELECT  `id` FROM `joomla`.`ep23j_joomgallery` where 
    catid= (SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-2),'/',1),'_',-1))
    AND imgfilename=( SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-1) )
    ),'&amp;type=img') )  
    where images like '%\\\\/joomgallery\\\\/details%' /*adjust acording to you own path */
    ;
    /*replacing article intro image with joomgalley url incase of original*/
    update `joomla`.`ep23j_content` 
    SET images=replace(images,SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1), 
    concat('index.php?option=com_joomgallery&amp;view=image&amp;format=raw&amp;id=',(SELECT  `id` FROM `joomla`.`ep23j_joomgallery` where 
    catid= (SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-2),'/',1),'_',-1))
    AND imgfilename=( SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-1) )
    ),'&amp;type=orig') )  
    where images like '%\\\\/joomgallery\\\\/originals%' /*adjust acording to you own path */
    ;
    /*replacing article intro image with joomgalley url incase of detail*/
    update `joomla`.`ep23j_content` 
    SET images=replace(images,SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1), 
    concat('index.php?option=com_joomgallery&amp;view=image&amp;format=raw&amp;id=',(SELECT  `id` FROM `joomla`.`ep23j_joomgallery` where 
    catid= (SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-2),'/',1),'_',-1))
    AND imgfilename=( SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-1) )
    ),'&amp;type=img') )  
    where images like '%\\\\/joomgallery\\\\/details%' /*adjust acording to you own path */
    ;
    /*replacing article full image with joomgalley url incase of thumbnail*/
    update `joomla`.`ep23j_content` 
    SET images=replace(images,SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1), 
    concat('index.php?option=com_joomgallery&amp;view=image&amp;format=raw&amp;id=',(SELECT  `id` FROM `joomla`.`ep23j_joomgallery` where 
    catid= (SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-2),'/',1),'_',-1))
    AND imgfilename=( SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-1) )
    ),'&amp;type=thumb') )  
    where images like '%\\\\/joomgallery\\\\/thumbnails%' /*adjust acording to you own path */
    ;
    /*replacing article full image with joomgalley url incase of original*/
    update `joomla`.`ep23j_content` 
    SET images=replace(images,SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1), 
    concat('index.php?option=com_joomgallery&amp;view=image&amp;format=raw&amp;id=',(SELECT  `id` FROM `joomla`.`ep23j_joomgallery` where 
    catid= (SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-2),'/',1),'_',-1))
    AND imgfilename=( SUBSTRING_INDEX(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(images, '"', 4), '"',-1),"\\",""),'/',-1) )
    ),'&amp;type=orig') )  
    where images like '%\\\\/joomgallery\\\\/originals%' /*adjust acording to you own path */
    ;

Alles anzeigen

If some one knows how to edit the article edit pages so that the joomgallery plugin shows up instead of the joomla media manager that would be even better but till then this is maybe helpful for others.

Use at own risk, I`m sure there are people you can make a safer script in php as i`m now depend on the number of " in the string.

MrMusic

Hi,

there is the plugin 'JoomMediaFormField' to use the images of the JoomGallery as article intro or full images. This plugin adds an additional button to the article editor to select the image.

Even after moving to another category, the image will still be displayed.

Using an SQL script should not be necessary.

Regards

MrMusic

Tazzios

haha, yes that`s exactly what i need.

Well the script is maybe still usable to correct old content.

MrMusic

Fine if I could help you.

Thomas-DAV

Thanks, too. Maybe this could be the solution, that I was looking for.

Tazzios

To hide the default button i added this css to my template:

Code

    /*hide default  article image  button*/
    a[href$="/component/media/?view=images&tmpl=component&asset=com_content&author=&fieldid=jform_images_image_intro&folder="], a[href$="/component/media/?view=images&tmpl=component&asset=com_content&author=&fieldid=jform_images_image_fulltext&folder="] {
        display: none;
}

Maybe there is an more elegant way that can be added as a config option in the plugin. But for now this also works which why i wanted to share it for other users.

Tazzios

New version:

bugfix, old one only worked on new pages not on edits.

Code

/*hide default article image button*/
a[href$="jform_images_image_intro&folder="], a[href$="jform_images_image_fulltext&folder="] {
display: none;
}

Neuigkeiten

Neuigkeiten

Use joomgallery for article images script

URLs nach Update auf JoomGallery4 und SH404SEF /4SEF

Looking to replicate JG3 Gallery / Category View under JG4

What can you do with Tags?

JG3 Bilder als Artikelbild verlinkt - Welche Migrationseinstellung erhält die Dateipfade?

JoomGallery for Joomla 4

Bearbeiten von Bildern nicht möglich

URLS nach Migration auf JG4

Inconsistent category folder paths defined in the database of your JG3 tables

JoomImages Module in Joomgallery 4

4SEF have native support for JoomGallery