psnGallery2 : famous line 97

Quickfix to try.

Try to replace the famous line 97 :

if (!$wpdb->query("SHOW TABLES FROM ".DB_NAME." LIKE '$psnGalleryTable'"))

I wrote try because I can’t reproduce on my side the issue…..

Give me your feedback !

Sorry to be so absent but I have a lot of work…..

psnGallery 2

This plugin allows you to have access to your Coppermine Gallery directly in
WordPress (Version 1.2 or higher).
With this version, all the configuration parameters are stored in a new table.
In fact to make the plugin working, you must create it and insert few records.

Pre Requirement :

– Coppermine Gallery minimum 1.1D must be installed and versio 1.3 to be able to use the “multimedia” files
– WordPress 1.2 minimum

The album list below has been generated by using the following tag :

<cpg_galcatview>12|1</cpg_galcatview>

where the 12 is the category and 1 for thumbnail size.

Hobbies
    Grenouille-2.jpg

  • Animaux, poupées
  • 5 pictures, 279 hits, 11 votes

    Lustre.jpg

  • Abats-jours
  • 9 pictures, 174 hits, 8 votes

    Dscn4393.jpg

  • Accessoires Cuisine
  • 22 pictures, 502 hits, 3 votes

    Vide-Poche.jpg

  • Accessoires Salle de Bain
  • 2 pictures, 103 hits, 3 votes

    Dscn1050.jpg

  • Bijoux
  • 4 pictures, 111 hits, No vote

    Dscn4794.jpg

  • Cartes 3D
  • 4 pictures, 108 hits, 1 vote

    Dscn1361.jpg

  • Cartonnage
  • 7 pictures, 302 hits, 4 votes

    Dscn6201.jpg

  • Chambre de Shani
  • 6 pictures, 176 hits, 1 vote

    Dscn2822.jpg

  • Collage Serviettes
  • 19 pictures, 3820 hits, 20 votes

    Boule-Crantee.jpg

  • Fêtes
  • 18 pictures, 764 hits, 6 votes

    Dscn4767.jpg

  • Marché de Noël 2004
  • 30 pictures, 374 hits, 2 votes

    Dscn4737.jpg

  • Mosaïque
  • 10 pictures, 281 hits, 1 vote

    Senegal2004-0250.jpg

  • Peinture sur Soie
  • 15 pictures, 992 hits, 27 votes

    Revelation.jpg

  • Photos
  • 13 pictures, 22 hits, 1 vote

    Dscn2816.jpg

  • Sacs
  • 6 pictures, 152 hits, 4 votes

    22.jpg

  • Scrapbooking
  • 39 pictures, 1776 hits, 9 votes

 

psnGallery2 v1.4.0 Alpha 1.zip available for download

As promised, merry Christmas !

Enjoy ! Don’t forget this is an ALPHA version ! So don’t use it on your production server ! If you do so, don’t blame me !

I did my best to provide an easy-to-run install/upgrade but I only checked few configurations !

Let me know if you have issues ! 🙂

I am still working on EXIF and multimedia stuffs….

Here is the gift :
Continue reading “psnGallery2 v1.4.0 Alpha 1.zip available for download”

psnGallery2 1.4 preview

As you know I had some hard time those last weeks : too much work no enough time ! Well, I assume it is end-of-year related as it is like that every year !

Oops ! I said that it is “end-of-year” period…. Oh ! No ! No gift ?!?!!!

Well, in fact there is a gift : my famous psnGallery2 new version (1.4.0) will be soon available…probably current of the coming week.

The major innovations are :

  • Install / Upgrade script (as simple as the one from WordPress !)
  • psnCPGAdmin.php has been reviewed to allow to display albums without categories (sorry to be so late, Sophist…)
  • fixes of several bugs

To install or to upgrade to this version, you will have to fill in the following screen :

13-1848.jpg

Here below, some snapshots of the install script and of the psnCPGAdmin…

So this will be soon available for download ! Christmas time ! 😉

Continue reading “psnGallery2 1.4 preview”

psnGallery todo list

I want to gather your feedback and your requests for the plugin psnGallery2….

I already know few of them :

– Add a start and end date for all tags and functions
– Fix the multimedia files support
– Implement EXIF support
– “one-click” installation script or transparent install (

psnGallery2 fix for dash in the database name !

Well, I was helping Peter to use psnGallery2…And I finally found the issue :

His Coppermine database name was like “database-coppermine” ! So in the code, to be able to handle several databases (one for WordPress and another for Coppermine), the plugin is using this kind of syntax :

select * from database-coppermine->cpg110_config this causes a mySQL Error ! Because the first dash seems to be considered as a special character !

To fix this, I will deliver very soon the release 1.3.2 !

In the meantime, if you have the issue, simply replace in psnGallery2.php (around line 164)

$info['TBLPREFIX'] = $info['DBNAME'].'.'.$info['TBLPREFIX'];
with
$info['TBLPREFIX'] = '`'.$info['DBNAME'].'`.'.$info['TBLPREFIX'];

This will fix the issue !

plugin psnGallery2 version 1.3.1 available for download

The new version of the psnGallery2 has been released !

As announced, the new functionnalities are :

  • Display the last uploaded pictures from a specific Coppermine album
  • Display the most viewed pictures from a specific Coppermine album
  • Display the best rated pictures from a specific Coppermine album

They are available via tags in post and via php functions anywhere else.

The automatic install script will be soon available…

Continue reading “plugin psnGallery2 version 1.3.1 available for download”