System log of events

ℹ️ Support
1

Hi guys,
just wondering if there’s a way to download/export system log …
cheers

2

Not as it stands afaik, but the following code will allow you to run a mini-program to print it out in a browser page, then you can copy and paste it as required.

Is this of use?

Save the code as a php file in your phpList directory and add it’s file name to the allow filematch list in .htaccess In my example I call it dbprint so like this:

</FilesMatch>
<FilesMatch "(index.php|dl.php|ut.php|lt.php|download.php|connector.php|dbprint.php)$">
Order allow,deny
allow from all
</FilesMatch>

The code for dbprint.php:

<?php

if (isset($_SERVER['ConfigFile']) && is_file($_SERVER['ConfigFile'])) {
    include $_SERVER['ConfigFile'];
} elseif (is_file('config/config.php')) {
    include 'config/config.php';
} else {
    print "Error, cannot find config file\n";
    exit;
}

$servername = $database_host;
$username = $database_user;
$password = $database_password;
$dbname = $database_name;
$table = $table_prefix."eventlog";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT id, entered, entry FROM $table";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Date: " . $row["entered"]. " " . $row["entry"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>

By the way, the code expects to find the config.php file in your config/ directory as this is where it grabs the database info.

3

Thanks Dragonrider, I’ll give it a try then I’ll come back to you

4

@edorizzi I’ve taken Dragonrider’s code and put it into a plugin so that it can be run from within phplist. See https://github.com/bramley/phplist-plugin-demo

@Dragonrider if you have many similar scripts then you might want to extend the plugin by adding further pages. Because the page runs within phplist it doesn’t need the config file, database parameters and connection, so is a bit simpler and shorter.

5

Thanks Duncan, appreciate the extra work done.

6

In fact, despite adding dbprint.php in .htaccess, I was not able to see it running.
I put the script under phplist/ , when calling it I get error 403

Forbidden
You don’t have permission to access /phplist/dbprint.php on this server.

I’m going to try the plugin

7

@edorizzi did you also make the change to the .htaccess file?

The plugin even allows for a CSV file to be opened in Excel so Duncan’s upgraded my code snippet.

8

yes I made the changes in the .htaccess with no success, but …

… I just tested the plugin and it is working perfectly !!

In excel I had to import the .CSV rather than open it directly, but it works. Only a little mess with long system messages, but I can deal with it :wink:
Thank you !!

9

like export bounced users ? :wink:

10

I don’t use this option on my installations, I assume the db record used is _bounce? If someone can confirm this please?

I’ve already created an option to export blacklisted users if anyone is interested.

11

The Bounce Statistics plugin might do what you want. plugin:bouncestatistics [phpList Resources]

You can view and export blacklisted subscribers using the Subscribers plugin.

12

Thanks Duncan … and sorry for this very late reply …