You are welcome !

Catégorie : sql

  • psnGallery 1.3.0Alpha Fix

    due to a small little tiny bug, the size selection is not working.

    To fix the issue :
    (suite…)

  • WP-plugin : psnGallery2 version 1.3.0Alpha is out !

    As you know I am working on psnGallery 1.3.0. I have decided to provide you the possibility to view it as I will be not available a while (I am going on holiday abroad).

    All the plugin parameters are displayed in the psnCPGAdmin module.

    The new functionnalities are :
    (suite…)

  • small issue in psnGallery2

    Issue description: If the <cpg_xxxx> tag is used with only 1 parameter and no separator, nothing is displayed.
    Discover by: William Spaetzel
    Final Fix : next release (probably 1.3.0)
    Workaround: use the tag with parameters (eg: <cpg_gallery>3|2|1</cpg_gallery> instead of <cpg_gallery>3</cpg_gallery>)

  • psnGallery2 v1.2.2 is available to download

    I fixed few issues, I followed the advices of several of you and specially those from Tarique Sani (Lead Dev Coppermine).

    Just click the download link here or on the download menu.

    As usual, if you have issue… Leave a comment !

  • WPPlugin psnGeneric soon out

    What’s psnGeneric ?

    It allows you to display an extract (random or not) of several records based on a key from a table. This can be used to display a random quote, a list of file to download, a list of … in fact, what you want !

    How does it work ?

    Few functions that you can call from your « index.php ». There is no limitation except your imagination ! The « Quote of the day » and the « Download » sections displayed on this page use this functionnality. Here is the call for the « Quote » :

    < ?php the_genRandom( 'QUOTE',1,'','','', ''); ?>

    You manage the content via the WP-Admin area (as you can see below).

    Nothing to display.

    This is only a preview. It will be out and available for download end of this week-end.

  • Further information on psnGallery2 tags/functions

    Out of a post (eg: in index.php)

    // Generate tags to display several random pictures from a specific Coppermine album (if -1 : from all albums)
    function CPGRndPicture($aid=-1, $count =-1, $nSize=1,$before='',$after='', $activelink=true, $dummy='') // Generate tags to display a full album from a specific Coppermine album (if -1 : from all albums)...
    function CPGAlbum($aid, $nCols=4, $nSize=1, $beforeCol="", $afterCol="", $beforeRow="", $afterRow="")

    // Get the name of an album
    function CPGAlbumName($aid)

    // Get the name of a category
    function CPGCategoryName($cid)

    // Get the number of pictures within an album
    function CPGAlbumPicCount($aid)

    // Get the album name list of a category
    function CPGAlbumListCategory($cid, $count=-1, $nSize=1, $before='', $after='')

    // Display a picture (in some modes)
    function CPGPicture($pictID, $nSize=1, $before='', $after='', $mode='picture', $dummy=0)

    // Display the specific thumbnail associated with an album
    function CPGAlbumThumb ($aid, $nSize=1, $before='', $after='')

    Within POST

    Tag defined Associated function Action

    • <cpg_album> => CPGAlbum($elems[ 0 ], $elems[ 1 ], $elems[ 2 ], $elems[ 3 ], $elems[ 4 ], $elems[ 5 ], $elems[ 6 ]);
    • <cpg_albumcatlist> => CPGAlbumListCategory($elems[ 0 ], $elems[ 1 ], $elems[ 2 ], $elems[ 3 ], $elems[ 4 ]);
    • <cpg_albumname> => CPGAlbumName($elems[ 0 ]) ;
    • <cpg_albumpiccount> => CPGAlbumPicCount($elems[ 0 ]);
    • <cpg_albumthumb> => CPGAlbumThumb($elems[ 0 ], $elems[ 1 ], $elems[ 2 ], $elems[ 3 ], $elems[ 4 ], $elems[ 5 ], $elems[ 6 ]);
    • <cpg_categoryname> => CPGCategoryName($elems[ 0 ]) ;
    • <cpg_gallery> => CPGRndPicture($elems[ 0 ], $elems[ 1 ], $elems[ 2 ], $elems[ 3 ], $elems[ 4 ], $elems[ 5 ], $elems[ 6 ]);
    • <cpg_picture> => CPGPicture($elems[ 0 ], $elems[ 1 ], $elems[ 2 ], $elems[ 3 ], $elems[ 4 ], $elems[ 5 ], $elems[ 6 ]);
    • <gallery> => CPGRndPicture($elems[ 0 ], $elems[ 1 ], $elems[ 2 ], $elems[ 3 ], $elems[ 4 ], $elems[ 5 ], $elems[ 6 ]);

    Of course, $elems[ x ] will be replace by the according value:

    In other words : <cpg_gallery>1|5|1</cpg_gallery> will become CPGRndPicture(1, 5, 1,  »,  »,  »,  »); and finally :

    • Dscn0126.jpgDscn0500.jpgDscn1380.jpgDscn1141.jpgDscn1379.jpg

    Another example : <cpg_picture>275|1</cpg_picture> will become CPGPicture(275, 1,  »,  »,  »,  »,  ») and finally :

    • Dscn3446.jpg