Example #1
0
function db_retrieve_logs()
{
    global $link;
    mysqli_set_charset($link, "utf8");
    $stm = $link->stmt_init();
    $stm->prepare('SELECT RECORDED, IP, USERS.NAME, ID_USER, ID_TAB, ID_RECORD, OPERATION, DESCRIPTION, NEWVAL FROM LOG, USERS WHERE USERS.ID=ID_USER ORDER BY RECORDED DESC');
    $stm->execute();
    $logdata = $stm->get_result();
    $rv = array();
    while ($rw = $logdata->fetch_row()) {
        $rv[] = array($rw[0], $rw[1], $rw[2] . '(' . $rw[3] . ')', tabNameForID($rw[4]), $rw[5], operationNameForID($rw[6]), $rw[7], $rw[8]);
    }
    $stm->close();
    return $rv;
}
Example #2
0
function db_export_log()
{
    global $link;
    $stm = $link->stmt_init();
    $stm->prepare('SELECT LOG.ID, RECORDED, IP, ID_USER, USERS.NAME, USERS.ROLE, ID_TAB, ID_RECORD, OPERATION, DESCRIPTION, NEWVAL FROM LOG JOIN USERS ON USERS.ID=LOG.ID_USER ORDER BY RECORDED DESC');
    $stm->execute();
    $st = $stm->get_result();
    print '"ID","RECORDED","IP","ID_USER","USERNAME","USERROLE","ID_TAB","ID_RECORD","OPERATION","DESCRIPTION","NEWVALUE"';
    print_nl();
    while ($rw = $st->fetch_row()) {
        print $rw[0] . ',"' . $rw[1] . '","' . ddq($rw[2]) . '",' . $rw[3] . ',"' . ddq($rw[4]) . '","' . ddq($rw[5]) . '",' . $rw[6] . ',' . $rw[7] . ',"' . operationNameForID($rw[8]) . '","' . ddq($rw[9]) . '","' . ddq($rw[10]) . '"';
        print_nl();
    }
    $stm->close();
}