[AusPhotography]

A cheap DB dump fragment...

PHP Code:

<?php
// dumpdb.php 
// Run module to dump SQLite database for this mod
// (c) Kym Farnik 2014 - permission given to use/modify as needed.

header('Content-type: text/csv');
header('Content-disposition: attachment;filename=dumpdb.csv');

$sqliteerror='';
define('DIR','/home/XXXXXX/public_html/forum'); // Edit path to YOUR forum folder

// Open the database
if ($sqlitedb = new SQLiteDatabase(DIR .'/sqlitedberrors.sqlite', 0666, $sqliteerror)) 
{
    $sqlitequery = $sqlitedb->unbufferedQuery("SELECT * FROM dberrors ORDER BY time DESC");
    while ($sqliteresult = $sqlitequery->fetch(SQLITE_ASSOC)) 
    {
        echo '"'.date("Y-m-d H:i:s",$sqliteresult['time']).'",'.
             '"'.$sqliteresult['error'].'",'.
                 $sqliteresult['errorcode'].','.
             '"'.$sqliteresult['ipaddress'].'",'.
             '"'.$sqliteresult['script'].'"'."\n";
    }
}    
else die ($sqliteerror); // the SQLite failed -- yuck
    
?>