inc.pwassist_session_handler.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

function db_pwassist_create_id(): string
{
    global $DIC;

    $ilDB = $DIC->database();

    do {
        $hash = bin2hex(ilPasswordUtils::getBytes(32));

        $exists = (
            (int) ($ilDB->fetchAssoc(
                $ilDB->query(
                    "SELECT EXISTS(" .
                    "SELECT 1 FROM usr_pwassist WHERE pwassist_id = " . $ilDB->quote($hash, ilDBConstants::T_TEXT) .
                    ") AS hit"
                )
            )['hit'] ?? 0) === 1
        );
    } while ($exists);

    return $hash;
}

function db_pwassist_session_read(string $pwassist_id): ?array
{
    global $DIC;

    $ilDB = $DIC->database();

    $q = 'SELECT * FROM usr_pwassist WHERE pwassist_id = ' . $ilDB->quote($pwassist_id, ilDBConstants::T_TEXT);
    $r = $ilDB->query($q);

    return $ilDB->fetchAssoc($r);
}

function db_pwassist_session_find(int $user_id): ?array
{
    global $DIC;

    $ilDB = $DIC->database();

    $q = 'SELECT * FROM usr_pwassist WHERE user_id = ' . $ilDB->quote($user_id, ilDBConstants::T_INTEGER);
    $r = $ilDB->query($q);

    return $ilDB->fetchAssoc($r);
}

function db_pwassist_session_write(string $pwassist_id, int $maxlifetime, int $user_id): void
{
    global $DIC;

    $ilDB = $DIC->database();

    $q = 'DELETE FROM usr_pwassist ' .
        'WHERE pwassist_id = ' . $ilDB->quote($pwassist_id, ilDBConstants::T_TEXT) . ' ' .
        'OR user_id = ' . $ilDB->quote($user_id, ilDBConstants::T_INTEGER);
    $ilDB->manipulate($q);

    $ctime = time();
    $expires = $ctime + $maxlifetime;
    $ilDB->manipulateF(
        'INSERT INTO usr_pwassist (pwassist_id, expires, user_id,  ctime)  VALUES (%s, %s, %s, %s)',
        [ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER, ilDBConstants::T_INTEGER, ilDBConstants::T_INTEGER],
        [$pwassist_id, $expires, $user_id, $ctime]
    );
}

function db_pwassist_session_destroy(string $pwassist_id): void
{
    global $DIC;

    $ilDB = $DIC->database();

    $q = 'DELETE FROM usr_pwassist WHERE pwassist_id = ' . $ilDB->quote($pwassist_id, ilDBConstants::T_TEXT);
    $ilDB->manipulate($q);
}


function db_pwassist_session_gc(): void
{
    global $DIC;

    $ilDB = $DIC->database();

    $q = 'DELETE FROM usr_pwassist WHERE expires < ' . $ilDB->quote(time(), ilDBConstants::T_INTEGER);
    $ilDB->manipulate($q);
}