Feeds:
Yazılar
Yorumlar

Posts Tagged ‘gallery’

Photo Gallery for a website

While the Menalto Gallery gracefully hibernated I recommend to move over to Piwigo  if you want to use an opensource gallery system on your website. That’s all I can finally say about Gallery3 (G3).

Reklamlar

Read Full Post »

Small change in the template.tpl to make the title of a photo when clicked on “Album name – Photo name” instead of “Photo Name” as title:

{* If Gallery doesn't provide a header, we use the album/photo title (or filename) *} 
{if empty($head.title)} 
  {if $theme.pageType == 'photo' || $theme.pageType == 'album'} 
    <title>{$theme.parent.title|markup:strip} - {$theme.item.title|markup:strip}</title> 
  {else} 
    <title>{$theme.item.title|markup:strip|default:$theme.item.pathComponent}</title> 
  {/if} 
{/if}

Read Full Post »

delete spam from gallery2

Unless there’s no Akismet module for gallery2 one occasionally has to delete spam manually from the comment table of the gallery system (ref.: Gallery2: deleting comment spam) – if your table and field prefix is g2_ and g_ you can use the code below:

CREATE TEMPORARY TABLE tmptable
SELECT g_id
FROM `g2_Comment` gc
WHERE
g_subject like '%url%' or
g_subject like '%http%' or
g_subject like '%personals%' or
g_subject like '%poker%' or
g_subject like '%blackjack%' or
g_subject like '%gambling%' or
g_subject like '%viagra%' or
g_subject like '%phentermine%' or
g_subject like '%casino%' or
g_subject like '100%' or
g_subject like '%slots%' or
g_subject like '%Cialis%' or
g_subject like '%url%' or
g_comment like '%http%' or
g_comment like '%personals%' or
g_comment like '%poker%' or
g_comment like '%blackjack%' or
g_comment like '%gambling%' or
g_comment like '%viagra%' or
g_comment like '%phentermine%' or
g_comment like '%casino%' or
g_comment like '100%' or
g_comment like '%slots%' or
g_comment like '%Cialis%';
DELETE g2_Entity FROM g2_Entity
INNER JOIN tmptable ON g2_Entity.g_id = tmptable.g_id;
DELETE g2_ChildEntity FROM g2_ChildEntity
INNER JOIN tmptable ON g2_ChildEntity.g_id = tmptable.g_id;
DELETE g2_Comment FROM g2_Comment
INNER JOIN tmptable ON g2_Comment.g_id = tmptable.g_id;DROP TEMPORARY TABLE tmptable;

Read Full Post »