Plogger beta 3 Installation Tweaks

I just installed the Plogger application for one of my clients, and, as with most apps, had to make a few tweaks in order to get it working.  Plogger is a very basic open source PHP photo gallery.  If you need something with more functionality, I would suggest checking out the slew of other PHP Photo Galleries out there such as Gallery.  The reason I chose Plogger was its sheer simplicity for integrating the photo gallery into your website.  It is truly a “drop-in” app that requires only 3 PHP statements on your page.  The thumbnails, bread crumb nav, search bar, etc flows to fill any container width you have set.  No editing of PHP include files or complicated themes. However, I did struggle with 2 issues:

Issue #1: Clicking the image to bring up the actual enlarged image resulted in a 404 error.  The directory path was messed up.  Here’s how I fixed it:

Open ‘plog-functions.php’ and find the following code:

[code lang=”php”]
function plogger_get_source_picture_url() {
global $config;
return (!empty($config[‘allow_fullpic’])) ? $config[“baseurl”].’images/’.SmartStripSlashes($GLOBALS[“current_picture”][“path”]) : “#”;
}[/code]

and change it to read:

[code lang=”PHP”]function plogger_get_source_picture_url() {
global $config;
return (!empty($config[‘allow_fullpic’])) ? $config[“gallery_url”].’images/’.SmartStripSlashes($GLOBALS[“current_picture”][“path”]) : “#”;
}[/code]

Issue #2: This is not really an issue, but a tweak.  By default, the Plogger will display your Collection first, and then force the user to drill-down to see the albums contained in that Collection.  This is fine if you have many collections, but if you only have 1 collection, then it doesn’t make sense to force the user to drill-down to the album level.  To show the albums for a specific collection, make the following change:

Open ‘index.php’ or whichever page you are calling the Plogger from, and replace the third PHP “drop-in” statement with the following code. The Plogger-ID is the ID of the Collection you want to show the albums from.

[code lang=”PHP”]

[/code]

Final note: The instructions do not explicitly state this, but the 3 PHP drop-in statements need to be added to a page with the .php extension.

Here is the Plogger Gallery that I made in action.

Editing ALL rows in MS SQL Server Management Studio 2008

Edit all rows in MS SQL Server Management Studio 2008

Edit all rows in MS SQL Server Management Studio 2008

After I upgraded from Microsoft SQL Server 2005 to 2008, one of the first changes that I noticed was the menu that appears when you right-click on a table was missing my beloved ‘Open Table’ option.  In the 2005 version, I was able to click this option and my table would open up all the rows in it.  This option was replaced by an “Edit top 200 rows” in the 2008 version.

While this is all well and good, why go through the trouble of clicking the “Edit top 200 rows”, and then have to modify the query to have it return all rows?  To get rid of the “Edit Top 200 Rows”, go to Tools > Options > SQL Server Object Explorer and in the “Table and View Options“, change the following:

  • Value for Edit Top <n> Rows command = 0
  • Value for Select Top <n> Rows command = 0

Hit OK.

And there you have it.  When you right-click a table, you will see the option for “Edit All Rows”.