After looking into this further and getting a better understanding about... everything, I have come to the conclusion that the most bullet proof way of logging visits would be to create a log parser that uses the nginx access log and updating the database that way. Seems like a pretty big thing for a piano tuner to do. I'm hoping that I could direct people to using a basic theme without lightbox or using the official app for browsing. My best bet (or laziest that is) is to get the app developer to have visit hits through it. Otherwise a log parser will be my next little project.

Am I missing something here? I've never thought about the complexity combining a highly customizable photo gallery with registering picture visits.

Hello,

Does this also work with Bootstrap Darkroom?

If so, could you explain in more detail what you did?

Remeber to change paths!

1. Start off by taking a backup of: piwigo\config\www\themes\bootstrap_darkroom\template\_photoswipe_js.tpl

2.Make a script called update_view_count.php that contains:

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

define('PHPWG_ROOT_PATH', '/app/www/public/');  // Path to your Piwigo installation
include_once(PHPWG_ROOT_PATH.'include/common.inc.php');

// Check if image_id is provided
if (isset($_GET['image_id'])) {
    $image_id = intval($_GET['image_id']);  // Get image_id from the URL and sanitize it

    // Update the view count for the image
    $query = 'UPDATE piwigo_images SET hit = hit + 1 WHERE id = ' . $image_id;
    pwg_query($query);

    // Optional: Display a success message
    echo "View count updated for image ID: " . $image_id;
} else {
    echo "No image ID provided.";
}
?>

3. Put update_view_count.php in the www\local\config folder (where the file config.inc.php is located).

4. Open piwigo\config\www\themes\bootstrap_darkroom\template\_photoswipe_js.tpl and replace the part with photoSwipe.listen('afterChange', function() with:

        photoSwipe.listen('afterChange', function() {

            let url = photoSwipe.currItem.href;

            let match = url.match(/picture\.php\?\/(\d+)\//);
            if (match) {
            fetch("local/update_view_count.php?image_id=" + match[1], { method: "GET" });
            console.log(match[1] + " swipe")
            }

            detectVideo(photoSwipe);
            $('.pswp__button--details').off().on('click touchstart', function() {
                location.href = photoSwipe.currItem.href
            });
        });

5. Add this new section (above photoSwipe.init()):

photoSwipe.listen('afterInit', function() {
    let url = photoSwipe.currItem.href;
    let match = url.match(/picture\.php\?\/(\d+)\//);
    if (match) {
        fetch("local/update_view_count.php?image_id=" + match[1], { method: "GET" });
        console.log(match[1] + " initial load");
    }
});


Thats all. Enable photoswipe by default so it starts up when you click an image (on all platforms). Start off by testing the script in a browser http://url/local/update_view_count.php?image_id=NUMBER to confirm its working. After that you can test clicking and swiping and check the console log in chrome (F12) to make sure it is triggered.

Last edited by dogen (2025-02-19 20:03:43)