GNOME Bugzilla – Bug 412023
Wordpress Blog Export
Last modified: 2018-07-12 00:04:57 UTC
I have a feature suggestion for the export. I found that I would really love to export the f-spot database to my Wordpress blog. I don't know if there is any desire to do this or not, but there is a potential to expand this greatly to include other blog support. First, the export feature in f-spot would be very similar to the stand-alone gallery export. However, only the hq, mq, and thumbs folders would be needed. It could also present the user with some options as to customize the interface, but those could all be tackled later. The photos.db would have to be copied elsewhere and have the photos table modified to include the path from the document root (specified in a dialog). The Wordpress part would need a PHP library to query the database as to make expansion and inclusion easier. I mocked up a sample page that pulled in the Wordpress content and added the photos to display. In this example, it has basic lightbox support if available and tries to follow the layout of the already existing folder export. I didn't have time to have it link the thumbnails but it would be the same as how they are used in the stand-alone version (reference by same name under thumbs/). Clearly this is just an example but it shows how f-spot database access can be added to a blog in the same manner of PennAve. Also, the concept where each folder is a gallery would be more than sufficient for this interface. Note that this does not technically need to be a full-fledged Wordpress plugin. It could be to manage the available options, such as lightbox support or document root (etc), but in my example, it was just a PHP page under the Wordpress root. This is similar to how the fGallery plugin works (can use mod_rewrite for short URLs). There are a ton of features that could be added in the future, such as a widget that acts similar to the Flickr tags. Below is the Wordpress example (http://s1n.dyndns.org/wordpress/wp-content/plugins/f-spot.php): <?php include("../../wp-blog-header.php "); ?> <?php get_header(); ?> <div id="content" class="narrowcolumn"> <div class="entry"> <?php $db = new PDO('sqlite: photos.db'); foreach($db->query('SELECT * from photos') as $row) { print "<a href= http://s1n.dyndns.org/wordpress/wp-content/pictures/".$row['name']." rel=lightbox style='text-align:center; -moz-border-radius:5px; margin:6px; display:block; border: 1px solid #727272; float:left;'><img src=" . "/wordpress/wp-content/pictures/". $row['name'] . " title='Test Title' style='width:140px; height:140px; padding:4px; border:0px'/></a>"; } ?> </div> </div> <?php get_sidebar(); ?> <?php get_footer(); ?>
This would be pretty sweet, especially now that Wordpress 2.5 has substantially better gallery functionality than previous versions of wordpress.
F-Spot has moved to https://github.com/f-spot/f-spot/issues If this Bugzilla ticket is still valid in a recent version of F-Spot, please feel free to post this topic as a ticket in the F-Spot project on GitHub. Closing this report as WONTFIX as part of Bugzilla Housekeeping as we are planning to shut down GNOME Bugzilla in favor of GNOME Gitlab.