if (strlen($filterSQL) + strlen($expirationFilterSQL) > 0) { $whereSQL = 'WHERE'; } $db = eZDB::instance(); $query = "SELECT count( DISTINCT ezsession.user_id ) AS count\n FROM ezsession\n {$whereSQL}\n {$filterSQL}\n {$expirationFilterSQL}"; $rows = $db->arrayQuery($query); return $rows[0]['count']; } $param['sortby'] = false; $param['filter_type'] = $filterType; $param['expiration_filter'] = $expirationFilterType; $param['user_id'] = $userID; if (isset($viewParameters['sortby'])) { $param['sortby'] = $viewParameters['sortby']; } $sessionsActive = eZSession::countActive(); $sessionsCount = eZFetchActiveSessionCount($param); $sessionsList = eZFetchActiveSessions($param); if ($param['offset'] >= $sessionsActive and $sessionsActive != 0) { $module->redirectTo('/setup/session'); } $tpl->setVariable("gc_sessions_completed", $gcSessionsCompleted); $tpl->setVariable("sessions_removed", $sessionsRemoved); $tpl->setVariable("sessions_active", $sessionsActive); $tpl->setVariable("sessions_count", $sessionsCount); $tpl->setVariable("sessions_list", $sessionsList); $tpl->setVariable("page_limit", $param['limit']); $tpl->setVariable("view_parameters", $viewParameters); $tpl->setVariable("form_parameter_string", $viewParameters); $tpl->setVariable('filter_type', $filterType); $tpl->setVariable('expiration_filter_type', $expirationFilterType);
$cli->output( "Removing all sessions" ); eZSession::cleanup(); } } if ( $clean['expired_session'] ) { if ( !eZSession::getHandlerInstance()->hasBackendAccess() ) { $cli->output( "Could not remove expired sessions, current session handler does not support session garbage collection (not backend based)." ); } else { $cli->output( "Removing expired sessions,", false ); eZSession::garbageCollector(); $activeCount = eZSession::countActive(); $cli->output( " " . $cli->stylize( 'emphasize', $activeCount ) . " left" ); } } if ( $clean['preferences'] ) { $cli->output( "Removing all preferences" ); eZPreferences::cleanup(); } if ( $clean['browse'] ) { $cli->output( "Removing all recent items and bookmarks for browse page" ); eZContentBrowseRecent::cleanup(); eZContentBrowseBookmark::cleanup();
if (strlen($filterSQL) + strlen($expirationFilterSQL) > 0) { $whereSQL = 'WHERE'; } $db = eZDB::instance(); $query = "SELECT count( DISTINCT ezsession.user_id ) AS count\n FROM ezsession\n {$whereSQL}\n {$filterSQL}\n {$expirationFilterSQL}"; $rows = $db->arrayQuery($query); return $rows[0]['count']; } $param['sortby'] = false; $param['filter_type'] = $filterType; $param['expiration_filter'] = $expirationFilterType; $param['user_id'] = $userID; if (isset($viewParameters['sortby'])) { $param['sortby'] = $viewParameters['sortby']; } $sessionsActive = eZSession::countActive($param); $sessionsCount = eZFetchActiveSessionCount($param); $sessionsList = eZFetchActiveSessions($param); if ($param['offset'] >= $sessionsActive and $sessionsActive != 0) { $module->redirectTo('/setup/session'); } $tpl->setVariable("gc_sessions_completed", $gcSessionsCompleted); $tpl->setVariable("sessions_removed", $sessionsRemoved); $tpl->setVariable("sessions_active", $sessionsActive); $tpl->setVariable("sessions_count", $sessionsCount); $tpl->setVariable("sessions_list", $sessionsList); $tpl->setVariable("page_limit", $param['limit']); $tpl->setVariable("view_parameters", $viewParameters); $tpl->setVariable("form_parameter_string", $viewParameters); $tpl->setVariable('filter_type', $filterType); $tpl->setVariable('expiration_filter_type', $expirationFilterType);