function wppa_create_session_entry($args)
{
    global $wpdb;
    $args = wp_parse_args((array) $args, array('session' => wppa_get_session_id(), 'timestamp' => time(), 'user' => wppa_get_user(), 'ip' => $_SERVER['REMOTE_ADDR'], 'status' => 'valid', 'data' => false, 'count' => '1'));
    $query = $wpdb->prepare("INSERT INTO `" . WPPA_SESSION . "` \t(\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`session`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`timestamp`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`user`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`ip`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`status`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`data`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`count`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES ( %s, %s, %s, %s, %s, %s, %s )", $args['session'], $args['timestamp'], $args['user'], $args['ip'], $args['status'], $args['data'], $args['count']);
    $iret = @$wpdb->query($query);
    return $iret;
}
function wppa_create_session_entry($args)
{
    global $wpdb;
    $args = wp_parse_args((array) $args, array('session' => wppa_get_session_id(), 'timestamp' => time(), 'user' => wppa_get_user(), 'ip' => $_SERVER['REMOTE_ADDR'], 'status' => 'valid', 'data' => false, 'count' => '1'));
    // WPPA_SESSION is auto increment
    $query = $wpdb->prepare("INSERT INTO `" . WPPA_SESSION . "` \t(\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`session`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`timestamp`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`user`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`ip`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`status`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`data`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`count`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES ( %s, %s, %s, %s, %s, %s, %s )", $args['session'], $args['timestamp'], $args['user'], $args['ip'], $args['status'], $args['data'], $args['count']);
    $iret = $wpdb->query($query);
    // Succcessful insert: return record id
    if ($iret) {
        $result = $wpdb->get_var($wpdb->prepare("SELECT `id` FROM `" . WPPA_SESSION . "` WHERE `session` = %s ORDER BY `id` DESC LIMIT 1", wppa_get_session_id()));
        return $result;
    } else {
        return false;
    }
}
Example #3
0
function wppa_session_end()
{
    global $wpdb;
    global $wppa_session;
    if (!wppa_get_session_id()) {
        return false;
    }
    $iret = $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_SESSION . "` SET `data` = %s WHERE `session` = %s", serialize($wppa_session), wppa_get_session_id()));
    if ($iret === false) {
        wppa_log('Error', 'Unable to save session.');
        return false;
    }
    return true;
}
function wppa_extend_session()
{
    global $wpdb;
    $sessionid = wppa_get_session_id();
    $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_SESSION . "` SET `timestamp` = %d WHERE `session` = %s", time(), $sessionid));
}