<?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 )	
);
?>