<?php
// Datenbank-Tabelle, die verwendet wird
$table = 'loginlogs';

// Der Primary key, der Tabelle
$primaryKey = 'id';

// Das "datetime"-Format aus der Datenbank extrahieren, nur das Datum (in das Deutsche-Format)
function getonlydate($datetime){
    $exploded = explode("-", $datetime);
    $explodemeagain = explode(" ", $exploded[2]);
    $mergeme = $explodemeagain[0].".".$exploded[1].".".$exploded[0];
    return $mergeme;
}

// Das "datetime"-Format aus der Datenbank extrahieren, nur die Uhrzeit
function getonlytime($datetime){
    $exploded = explode("-", $datetime);
    $explodemeagain = explode(" ", $exploded[2]);
    $mergeme = $explodemeagain[1];
    return $mergeme;
}

// Array of database columns which should be read and sent back to DataTables.
// The `db` parameter represents the column name in the database, while the `dt`
// parameter represents the DataTables column identifier. In this case simple indexes.
$columns = array(
    array( 'db' => 'ip', 'dt' => 0 ),
    array(
        'db'        => 'status',
        'dt'        => 1,
        'formatter' => function( $d, $row ) {
            if($d == 1){
                return "Erfolgreich";
            }else{
                return "Fehlgeschlagen";
            }
        }
    ),
    array(
        'db'        => 'stayloggedin',
        'dt'        => 2,
        'formatter' => function( $d, $row ) {
            if($d == 1){
                return "Ja";
            }else{
                return "Nein";
            }
        }
    ),
    array(
        'db'        => 'date',
        'dt'        => 3,
        'formatter' => function( $d, $row ) {
            return getonlydate($d);
        }
    ),
    array(
        'db'        => 'date',
        'dt'        => 4,
        'formatter' => function( $d, $row ) {
            return getonlytime($d);
        }
    )
);

// SQL server connection information
require('../../phpfuncs/connection.php');
$sql_details = array(
    'user' => $user,
    'pass' => $pw,
    'db'   => $db,
    'host' => $host
);


require('ssp.class.php');

//Set the character encoding to UTF-8

echo json_encode(
    SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
);
?>