New module: Show updates to your gallery

(Continued from this thread, since it no longer has anything to do with RSS.)

You can find here or attached to this post a very simple module that shows the last n items added to your gallery. This is a very hasty release, so consider it pre-alpha code. You can see it in action here.

To use the module, all you should need to do is download it, unzip it, read the README, place it in your modules directory, install and activate it in the Site Admin console of your gallery, and configure the number of items to display and how to display them. Once you've done this, you should be able to view your updates at a URL like:
http://foo.com/gallery2/main.php?g2_view=updates.ShowUpdates
You can also configure a simple URL through the URL rewriting module.

If you have any problems or suggestions, please let me know, preferrably via this thread.
----

Latest version: 0.2.4, 2005-10-09

Hi, joefish; I don't have an update to release yet, but can you replace the file updates/ShowUpdates.inc with this version? The only change is that there's a bit of code to print out the error properly.

I'm pretty sure the query a few lines before line 64 is failing for some reason, but I didn't properly output the error, so it's hard to say for sure. If you could swap in that version and post the full error here, I might be able to help debug it.

--
http://severinghaus.org/gallery/

Well, for some reason the query is failing. I can help debug this further, but it may be a bit of a pain. The main thing that would help is to know exactly what query it's trying to execute, since Gallery2 has a relatively complex system for executing queries.

To find out exactly what query is being executed, you'll need to modify:
gallery/modules/core/classes/GalleryStorage/DatabaseStorage.class

In this file, on line 1135, you'll see the call where G2 translates the query from what you specify into what you need in order to run it against MySQL. Right after this line, add:
var_dump($query);
This will cause G2 to dump out the SQL for every query it executes.

This query should look something like:

SELECT g2_Item.g_id, g2_Item.g_title, g2_Entity.g_creationTimestamp
FROM g2_Item INNER JOIN g2_Entity ON g2_Item.g_id = g2_Entity.g_id
WHERE g2_Entity.g_entityType = 'GalleryPhotoItem'
ORDER BY g2_Entity.g_creationTimestamp DESC
LIMIT 48

If it doesn't (unlikely), that's a problem I'm not sure I'll be able to help with. If that is what you get, I think the best thing to do will be to try to run that query manually against your MySQL database and see what MySQL has to say about it.

--
http://severinghaus.org/gallery/

HorsePunchKid, cool
after fixing the basic bugs, fee free to add it to the modules list on codex.gallery2.org -> user contributions

@url rewrites:
you should just register a short url with the url rewrite module, no need to do manual htaccess editing...

I'm not quite sure what you mean?

Thanks so much. This is perfect and a great addition to my gallery pages.

A new version, 0.2, is ready. You can download it here or get it from the attachment to this post. I have fixed (hopefully) the problem with needing to configure it before using it.

I also added a couple of configuration options, fixed the date display to use your gallery-wide setting, added a hook for the URL rewrite module, and added a "custom CSS" field in the Site Admin page so that you don't have to fiddle with templates to make style adjustments. Please read the README, even if you've already read it from a previous version; it is short and simple.

Edit: Uploaded version with the module version number corrected.

--
http://severinghaus.org/gallery/

Ok, I say I want to incude the latest 5 photos in another (non-gallery) page of my website. I don't want all the header stuff and gallery layout to be there. I tried editing the ShowUpdates.inc file, and commented out the line that says $template->head('modules/updates/templates/Header.tpl');, but obviously this only gets rid of the stuff done with the header.tpl from the updates module. How can I get rid of all gallery layout stuff when I call this page? It seems to get prepended before this module does anything...

For what it's worth, zduchene, I did completely uninstall and reinstall the module a couple of times while testing it, and it seemed to work fine. I don't think you'll have any trouble, but if you do, I will do my best to help. Worst case, it's easy enough to uninstall. ;-)

--
http://severinghaus.org/gallery/

Steven----
Is this what is causing v0.2 to install in Modules as v0.1? I'm sure I d/l'd v0.2 uninstalled/overwritten in modules and stuff but it still keeps signing on as v0.2;~/
----best wishes, Robert

Whoa Steven I've a small RFE... would you include the ability to remove the filename/title... you've only left that one out of your listing! Afterall the image itself is linked for clicking.
----best wishes, Robert

Standby I'll give a whirl.

In the zip archive the only file is a binary thing...is this what its supposed to be or are there problems on my end?

NBrady try Firefox instead of IE to d/l the zip file. I assume your problem is that the zip file was corrupt or something when you d/l'd it?

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

Yes, that's right. Either the list of divs or RSS would work for me.

Thankyou very much! That's excellent!

One suggestion: If I turn off 'show item titles' and 'show date created', I still get the extra divs in the output. For example, the output looks like this:

<div class="updates-item">
<div class="updates-thumb">
<a href="http://gallery.somewhere.net/v/student-life/sl2004/reunion/IMG_1530.jpg.html">
<img src="http://gallery.somewhere.net/d/1343-2/IMG_1530.jpg" alt="IMG_1530.jpg"/>
</a>
</div>
<div class="updates-caption">
</div>
</div>

(Extra spaces cut out obvisouly).

HorsePunchKid
it may be a good idea to keep the 1st post of this topic up to date, since it's the first thing users see and read when they find this topic.
i'd edit the first post and replace the 0.1 version file with the current version.
and i'd remove obsolete instructions (.htaccess) etc.
just a suggestion

joefish: I may add an option to remove the captions div entirely. I think you're not the only one would could make use of that option. In the meantime, you can use a CSS directive like div.updates-caption { display: none; } to remove it.

valiant: Very good idea indeed. :-) I have updated the first post.

kos: I hadn't even thought of that, since I don't use the permissions system at all. No promises, but I'll see what I can do about that in the next release.

--
http://severinghaus.org/gallery/

Version 0.2.3 of the updates module, available here or attached below, should fix the permissions problems and also allows you to disable captions entirely.

Thanks for the tip, valiant. I found the helper classes for permissions and used the "medium" one to retrieve permissions for each item for the current user. It is probably too simplistic at the moment, as it is just checking if you have any permissions at all. So for example, if you don't give someone view permissions on an item but do give them some other kind of permission, it will still show up in the updates. This seemed sufficiently unlikely that it was worth ignoring for this release, but it shouldn't be hard to correct.

Edit: This is now fixed; such a minor change that I'm just reuploading it as 0.2.3.

--
http://severinghaus.org/gallery/

I noticed that particular method and am already using it. :-) The hardest part about this fix was realizing and dealing with PHP's little quirk with arrays, where you unset an item and the array doesn't get reindexed. The fetch function didn't like the fact that indices were "missing" from the array.

--
http://severinghaus.org/gallery/

@upgrading:

basically, just add a function upgrade to your module.inc and if there's nothing to do, just return a success.
if you need to change something, e.g. add a plugin parameter, add a switch($oldersion) case statement to add a pluginparameter and finally return true.
just to be clear; in the upgrade function, you don't need to change the module version etc. that is done by the G2 framework.

HorsePunchKid

Thanks for the update.

Unfortunately it doesnt seem to be working perfectly for me. You can see it on: http://www.maven.sc/seycrew/gallery2/main.php?g2_view=updates.ShowUpdates

I have 2 user groups. Registered Users and Everybody. I have several root albums, 1 of which is public and the others are locked to regsitered users only.

When opening updates as member of registered users it is showing photos across all albums fine, as expected.

When opening as a guest it is still 'retrieving' images across ALL albums but its just not displaying the thumbnails for the images that guest has no permissions for.

Is it possible to make it not retrieve those images at all?

Hi

I belive that we need to use the album temple so that this module inhericts the desgin

and make a link addable to the template in the theme control

Paul

PS this is a needed and usefull module

Hi

new version seems to work without any probem But the default CSS didn't work for meI was getting a broken <HR> under the top row of images

fix it with the css block

/*set the total height so the float left work on all line*/
div.updates-item
{
width:160px;
float: left;
padding: 10px;
text-align: center;
display:block;
}
/*set the caption box and add scoll bars as needed to handle lage text blocks*/
div.updates-caption{
width:160px;
height:80px;
overflow:auto;
overflow-y:auto;
overflow-x:visible;
}
div.updates-link{
width:157px;
}
div.updates-thumb{
height:160px;
}

I hope this helps

Also is there any chance for Video support?

HI

If you want a quick/dirty hack just add a style block and hide all the elements you don't want (display:none;)etc.

With a quick bit of work you could get a text list