archiv.php File Reference

Variables
	$druck = Request::option('druck')
	$wiki_dump_id = Request::option('wiki_dump_id')
	$forum_dump_id = Request::option('forum_dump_id')
	$dump_id = Request::option('dump_id')
	$delete_id = Request::option('delete_id')
	$open = Request::option('open')
	$delete_user = Request::option('delete_user')
	$add_user = Request::option('add_user')
if(Request::option( 'suche')) elseif(! $open &&! $delete_id &&!Request::option('show_grants') &&!Request::option('hide_grants') &&! $delete_user &&!Request::submitted('add_user') &&!Request::submitted('new_search') &&!Request::option('close') &&! $dump_id &&!Request::option('sortby') &&!Request::option('back')) if(Request::option( 'show_grants')) if(Request::option('hide_grants')) if( $open) if((Request::option('close'))||(Request::option('suche')))	$_SESSION ['archiv_data']['sortby'] = Request::option('sortby', 'Name')
	$u_id = $user->id
if(($delete_id) &&Request::submitted('delete_really')) if( $delete_id) if($delete_user) if(Request::submitted( 'do_add_user')) if(!empty($dump_id)) elseif(!empty( $forum_dump_id)) elseif(!empty($wiki_dump_id))	else
if($msg) if	(isset($message)) ($message, $details) ?><? endif ?>< form name = _('Name der Veranstaltung:')
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE	fakultaet = _('Suche über <b>alle</b> Felder:')
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	seminar_id
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	name
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	untertitel
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	beschreibung
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	start_time
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	semester
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	studienbereiche
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	heimat_inst_id
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	institute
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	dozenten
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	archiv_file_id
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	archiv_protected_file_id
if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT	forumdump
	$parameters ['needle'] = trim($_SESSION['archiv_data']['all'])
	$statement = DBManager::get()->prepare($query)
	$results = $statement->fetchAll(PDO::FETCH_ASSOC)
	$hits = count($results)
	$template = $GLOBALS['template_factory']->open('layouts/base.php')
$template	content_for_layout = ob_get_clean()

Variable Documentation

$_SESSION

if(Request::option('suche')) elseif(! $open &&! $delete_id &&!Request::option( 'show_grants') &&!Request::option( 'hide_grants') &&! $delete_user &&!Request::submitted( 'add_user') &&!Request::submitted( 'new_search') &&!Request::option( 'close') &&! $dump_id &&!Request::option( 'sortby') &&!Request::option( 'back')) if(Request::option('show_grants')) if(Request::option( 'hide_grants')) if($open) if ((Request::option( 'close'))||(Request::option( 'suche'))) $_SESSION[ 'archiv_data'][ 'sortby'] = Request::option('sortby', 'Name')

$add_user

$add_user = Request::option('add_user')

$delete_id

$delete_id = Request::option('delete_id')

$delete_user

$delete_user = Request::option('delete_user')

$druck

$druck = Request::option('druck')

$dump_id

$dump_id = Request::option('dump_id')

$forum_dump_id

$forum_dump_id = Request::option('forum_dump_id')

$hits

$hits = count($results)

$open

$open = Request::option('open')

Examples

/usr/local/src/studip/jlu_3.3/lib/visual.inc.php.

$parameters

$parameters[ 'needle'] = trim($_SESSION['archiv_data']['all'])

$results

$results = $statement->fetchAll(PDO::FETCH_ASSOC)

$statement

$statement = DBManager::get()->prepare($query)

$template

$template = $GLOBALS['template_factory']->open('layouts/base.php')

$u_id

$u_id = $user->id

$wiki_dump_id

$wiki_dump_id = Request::option('wiki_dump_id')

(isset($message))

if ( $msg)if (isset( $message))( $message, $details) ?><? endif ?>< form name

(

isset( $message)

)

= _('Name der Veranstaltung:')

archiv_file_id

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id archiv_file_id

archiv_protected_file_id

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id archiv_protected_file_id

beschreibung

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id beschreibung

content_for_layout

$template content_for_layout = ob_get_clean()

dozenten

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id dozenten

else

if ( $hits > 0 &&(! $string_too_short)) else

Initial value:

{
 
PageLayout::setHelpKeyword("Basis.SuchenArchiv")

fakultaet

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id fakultaet = _('Suche über <b>alle</b> Felder:')

forumdump

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id forumdump

heimat_inst_id

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id heimat_inst_id

institute

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id institute

name

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id name

Initial value:

= :user_id";
        $parameters['user_id'] = $user->id;
    } else {
        $query = "SELECT seminar_id

semester

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id semester

seminar_id

string id alias column for seminar_id

start_time

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id start_time

studienbereiche

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id studienbereiche

untertitel

if( $msg) if Institute Name FROM archiv LEFT JOIN Institute ON(Institut_id=heimat_inst_id) " . "WHERE Institute.Name NOT IN('' ORDER BY Name s fak alle SELECT DISTINCT fakultaet FROM archiv WHERE an denen ich teilgenommen habe Suchen hidden suche yes perform_search all all name name desc desc doz doz pers inst fak all name desc doz pers inst fak SELECT wikidump FROM archiv LEFT JOIN archiv_user USING (seminar_id) WHERE user_id untertitel