Latest Images / Most Viewed Hack

I'm not 100% clear on what you want but if I understand correctly you would need to reset the counters each month. Another option is to start changing Gallery code but then upgrading Gallery becomes a lot more difficult. What would be needed is another clicks (views) count for the past month. It could be done and would be very similar to what I did with my voting counter. However as I say upgrading Gallery later would be difficult.

I have done another hack that allows the stats page to only display images that have been uploaded during the current month, or any number of earlier months. It's in the latest tar on my website. The "period" variable controls what is displayed - for example:

stats.php?type=views&period=0 [current month]
stats.php?type=views&period=1 [last month and this month]
stats.php?type=views&period=6 [last 6 months]

This is documented in the readme.

Mmmm... I've just had another idea about how what I think you really want could be done. Let me think about it some more as implementing it could stretch my php knowledge....

Wally,

Thanks for your positive contribution - NOT!

Mmmm... enough said... anyway I don't ever remember telling anyone how to get this hack into a standard Gallery install. It seemed too basic for anyone looking through the Customizing forum...

For the record untar the stats.tar.gz file and as a first step type the url to the stats.php in your browsers address field. If it works and adds value to your site and you want to include it, then checkout http://www.eclecticpixels.com/tutorials/gallerytips/ That guide is the one I used myself which is IMHO very good.

Cheers, J

i found it ... i must have changed "thumb_size" in config accidently to "120" and your hack read it correctly from there. My fault !

works great!

The easiest way would be if I can reproduce the problem here. Ideally I could do with a copy of your albums directory. Do you have a tar.gz file of your albums directory that I could download? If that's too large then I will put some debug in stats.php so we can see where the problem is.

Cheers, J

It would be interesting to know if the Gallery search still works. Search uses similar code to stats.php.

I've now added some debug info to stats.php in an effort to find what is failing. The problem with this is that it can be a slow iterative process. My guess is that the code is blowing some php resource limit with the number of photos you have. Anyway try downloading the latest http://www.tearoom.me.uk/stats.tar.gz and opening http://www.shoobeedoodoo.com/gallery/stats.php?type=views&debug=1

I would like to see what debug info that shows. You can also try http://www.shoobeedoodoo.com/gallery/stats.php?type=views&debug=2 but that might produce too much debug info.

Cheers, J

That tells me that it is crashing very early in the code. I've added more debugging to try and get closer to the problem. Try downloading the latest version and see what that tells us. Use debug=2. As I said - this will be a slow process unfortunately - if I could reproduce it with my setup it would be a lot quicker.

Cheers, J

Ok - I have updated stats.php with yet more debug. Try that . I would be surprised if you had nothing this time!

Cheer,s J

Glad that I can be of assistance - your problems help me to learn php.

The debug output this time is much more interesting.

I suspect the problem with stats.php is the same one as with the random image code. I haven't seen that code so can't confirm. Anyway looking at the debug output, it's calling "new AlbumDB()" and never returning. "new AlbumDB()" is a standard Gallery function - not one of mine. This is how I call it in my code:

if ($debug >= 2)
{
        echo "Getting album database.<br>";
}
$albumDB = new AlbumDB();
if ($debug >= 2)
{
        echo "Retrieved album database.<br>";
}

The reason why albums.php works is that it uses:

$albumDB = new AlbumDB(FALSE);

The FALSE tells the AlbumDB code not to load photos. I guess albums.php has no need to load them being a simple top level list of albums. If FALSE is not specified then it defaults to TRUE and tries to load the photos.

So the question is why does the code never return from the new AlbumDB() call? It could be a resource issue or possibly data associated with one of your albums is corrupt in some way and it is failing to load and then crashing out silently. To diagnose you need to add debug code to the file "classes/AlbumDB.php" My code looks like this - yours might be different given IIRC you are running different Gallery code:

        function AlbumDB($loadphotos=TRUE) {
                global $gallery;

<cut>
                $changed = 0;
                while ($i < sizeof($this->albumOrder)) {
                        $name = $this->albumOrder[$i];

Try adding the echo as below:

        function AlbumDB($loadphotos=TRUE) {
                global $gallery;

<cut>
                $changed = 0;
                while ($i < sizeof($this->albumOrder)) {
                        $name = $this->albumOrder[$i];
                         echo "Loading album " . $name . "<br>";

When you run this code it will be interesting to see which album is the last one that gets listed. That is probably where the problem starts. I would then start drilling into the load code itself with echos to tell me what's happening. Alternatively you could try adding code to skip that album or even try deleting it from Gallery. Before doing any of this though I would make sure I had a backup of my albums directory.

BTW on Friday I'm leaving for a 2 week business trip to the US so these posts could stop for a while unless I can get online there.

I had a similar thing happen to me with it freezing during an upload that resulted in a "corrupt" album. I deleted it and then it was ok.

I notice from your site that the NY album has gone so I guess you have already deleted but it hasn't helped. Assuming I'm correct, after you deleted NY did you get the same result when you ran stats.php. ie did it stop after loading album newyork? The reason I ask because maybe there's still a reference to the newyork album.

The next thing to do if you still have problems is to add more "echo" statements to pin point where in the code it is failing. You can safely add

echo "I'm here";

type statements to the code to see where it is going.

Cheers, J

I didn't think to look for the NY album in Shoobee.... Ok - try coding round that newyork album first.

In AlbumDB.php change:

                while ($i < sizeof($this->albumOrder)) {
                        $name = $this->albumOrder[$i];
                        echo "Loading album " . $name . "<br>"; 
                        if (ereg("^\.", $name)) { // how did this get here??
                                array_splice($this->albumOrder, $i, 1);
                                $changed = 1;
                        } else if (fs_is_dir("$dir/$name")) {
                                $album = new Album;
                                if ($album->load($name,$loadphotos)) {
                                        array_push($this->albumList, $album);
                                } else {
                                        array_push($this->brokenAlbums, $name);
                                }
                                $i++;
                        } else {
                                /* Couldn't find the album -- delete it from order */
                                array_splice($this->albumOrder, $i, 1);
                                $changed = 1;
                        }
                }

to

       while ($i < sizeof($this->albumOrder)) {
                        $name = $this->albumOrder[$i];
                        echo "Loading album " . $name . "<br>"; 
                        if ( $name != "newyork" || !$loadphotos) {  /** ADD THIS LINE */
                        if (ereg("^\.", $name)) { // how did this get here??
                                array_splice($this->albumOrder, $i, 1);
                                $changed = 1;
                        } else if (fs_is_dir("$dir/$name")) {
                                $album = new Album;
                                if ($album->load($name,$loadphotos)) {
                                        array_push($this->albumList, $album);
                                } else {
                                        array_push($this->brokenAlbums, $name);
                                }
                                $i++;
                        } else {
                                /* Couldn't find the album -- delete it from order */
                                array_splice($this->albumOrder, $i, 1);
                                $changed = 1;
                        }
                    }   /**** ADD THIS AND THE NEXT 3 LINES ****/
                    else
                    {
                        $i++;
                    }
                }

Cheers, J

Hey Myriagon,
Once I coded it the way you said, bypassing New York, it worked perfectly. I tried splitting up the New York Album roughly 100 images each, and it still doesn't work however. Is 100 images still too much? Should I try splitting it up again?

Thanks again!

-Stephen

Thanks a lot for all your help, I guess I'll try moving it around some more and see if it works, but I do think something is probably corrupted with the NY album, as gallery remote did freeze up when uploading. If all else fails, I guess I'll just delete the NY album and reupload it again.

Your random photo code DOES work with the NY album bypassed, so I guess I'll just have to play around with that album some more.

Does anyone know how to backup an album so that it'll have all it's comments and number of clicks still intact? Is there anyway to delete, and reupload an album, and somehow merge the comments and number of clicks back into the album?

Thanks again, and I hope you have a lovely trip!

-Stephen

Hi again,
Ok, after playing around for the past day or so with this, I'm still as stumped as ever. I completely deleted the New York album, and it works fine, I reupload all the pictures, and then it doesn't work. So I upload like 20 pictures at a time, and stats.php works until I get to around 50 images or so in the New York album. But at the same time, other users on my site are uploading pictures and Stats.php works fine, so I'm really not sure what the problem is. Right now, I just have albumdb.php bypass the new york album and it works fine, as it doesn't take into account the new york album.

I noticed that when I do include the New York album, the stats.php page just shows at the top, "750 images in the album" or however many images there are, but shows no pictures. Other times, stats.php is just blank.

Also, there was another top ten hack created earlier by someone else (http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=9157&highlight=top+ten)
and that one works fine for me, including the New York album, but I don't quite the layout of this one, and how is that one different from Myriagon's?

Anyways, sorry for this lengthy post, but I'm just so confused, so anyone that can shed some light, it would be greatly appreciated.

Thanks!

-Stephen

Greetings, and thank you for stats.php.

Is it perhaps possible to create a cache file that can be read instead of going through the albums in realtime?

I have ~6000 pictures, and even though this works, it is still very slow.

Thanks!

/Jenny :D

Hi Stephen

Yes I'm back and suffering jet lag now... San Francisco was really cool although I'm sure I've put on a few lbs after too many dinners at the Cheesecake Factory!

How are things with you? Still problems with the NY album?

Cheers, J

Hey Myriagon,
I'm not sure what the problem is now, but stats.php works at times, and at other times it doesn't work, even when I bypass the New York album, now I have no idea what the problem is, maybe it's the number of albums I have? If another user is able to have 6000 pictures, I don't think it's the number of pictures, but perhaps the number of albums? Anyways, any ideas you may have in why I'm having the problems I'm having, please let me know.

I'm glad you had a great trip as well, San Francisco is a wonderful city, next time, drop by SoCal, it's a nice place as well.

Again, thanks for everything!

-Stephen

Hey Jeremy,
Before, stats.php would work sometimes, but the random photo code would always work.

Alas, as of right now, stats.php and the random photo code both do not work, so I have no idea what's going on. I asked the hosting people, and they say it's not a php memory limitation, as gallery is working fine, and everything else is ok.

Is there any way I can get you my data somehow? Should I just zip it all up and send it on over? Any ideas you have will be greatly appreciated.

Thanks again for helping me through all this.

-Stephen

Thanks Hollis for your support - much appreciated.

The details of how stats.php came about and how it relates to voting can be found at... http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=13139&highlight=

I left the voting code in but stopped it from being called because it makes it easier for me to maintain stats.php. The code behind getItemSVotes can be found here http://www.tearoom.me.uk/voting.tar.gz This does not include all the stuff that allows me to select my new "simple" polling type in the voting properties window and also the voting page that I added. If you want that then I will dump all the code into a tar.gz file as there were many changes across several files.

If you want to implement your own version based on rank or order polling then you need to modify getItemSVotes() in AlbumItem.php. This has to return a vote or poll score that corresponds with the Gallery voting mechanism that you are using.

Hope that makes sense.

Cheers, J

Hi Stephen,

Looking in that code it does not use the same Gallery code that I use. Instead it uses a recursive function (a function that calls itself) to find the number of views for each photo. It would be interesting to adapt stats.php to use the same technique. If I get chance I will see what I can do.

BTW if you want to let me have a look at your gallery, then you will need to log onto you server using telnet or ssh. You can then run a command such as

tar -czvf albums.tar.gz albums 

That command assumes your photos and albums are all stored in the "albums" directory. I think that is the default. You will need lots of spare disk space to do this given the number of photos you have. I should then be able to download all your albums by downloading albums.tar.gz

Cheers,

Jeremy

Hi

I just installed the script and its working just great 8)
But, however I want to tune it a little bit more and I have no idea how to
do it :roll:
Look at the pics for more info.

This is how its now, http://andreas.spbk.no/.
[img]http://andreas.spbk.no/now.jpg[/img]

And as you all can see, it does not look to good.
This is how it's supposed to look afterwards
[img]http://andreas.spbk.no/after.jpg[/img]

Does it make any sense?
And where do I edit the text? like "latest images" and such? Not to mention the fonts
Is it included in my css-file somewhere?

Maybe this will help as well, since im very new to php, I used the include-syntax to view the script, there maybe other solutions to the problem but that's the only way I know about.
And how come I have a line over "IMG 4030"? The ass pic

Thanks for the reply
I have no clue about the head stuff. Sorry about that. If it's not added with the script, I havent touched it

This is what I did i in the albums.php
So, all I want to to really, is to align stats.php?=date to the right, and
stats.php?views on the left.

<!-- top nav -->
<?php
includeLayout('navigator.inc');
includeLayout('navtableend.inc');
includeLayout('ml_pulldown.inc');

include("http://andreas.spbk.no/gallery/stats.php?type=date");
include("http://andreas.spbk.no/gallery/stats.php?type=views");

?>


<!-- album table begin -->

[/u]

Jeremy,
Thank you so much for helping me through all this, you've been such a big help and so friendly about everything, I feel so bad at times for bothering you so much!

Just a quick question, how do I go about setting up a new gallery installation with my exisitng album photos?

Thanks again for everything!

-Stephen

I've got 2100+ items on my site right now, spread over 93 sub-albums and it's running just fine.

Main Gallery Page

My Most Viewed Page

My Latest Items Page

Hope this info helps your problem Shoob!

Hollis

Hi Stephen

This has probably been discussed before so it could be worth a search on this forum. There might be some issues with my instructions below as I haven't had the time to test them right now. Anyway...

First you need to download the Gallery files from this website. It's probably best to go with the version you are already using if it's still available. Put the files in a "testgallery" or whatever directory. If you have the disk space then copy your album directory files into another new directory, "testalbums" or whatever you want to call it. Then point your web browser to the http://.../testgallery/albums.php and setup the new installation as you did before. You will need to tell it where to find the albums - in this case it will be ".../testalbums". Otherwise it should be very similar to before. IIRC there's a parameter in there to make each installation seperate - can't remember what it's called right now. Make sure that is different from what you used for your old Gallery.

Hope that's enough to get you going.

Cheers,

Jeremy