Stud.IP  trunk Revision
core.view.php File Reference

Variables

 $_views ["AUTH_USER_UNAME"]
 
 $_views ["AUTH_USER_UID"]
 
 $_views ["USER_DATA_UNAME"]
 
 $_views ["GENERIC_UPDATE"] = array("query" => "UPDATE § SET §=? WHERE user_id=?")
 
 $_views ["AUTH_USER_INSERT"] = array("query" => "INSERT INTO auth_user_md5 (user_id, username, perms, password, Vorname, Nachname, Email,auth_plugin) VALUES (?,?,?,?,?,?,?,?)")
 
 $_views ["USER_INFO_INSERT"] = array("query" => "INSERT INTO user_info (user_id, mkdate, chdate, preferred_language) VALUES (?,?,?,?)")
 
 $_views ["SEM_USER_INSERT"] = array("query" => "INSERT INTO seminar_user (Seminar_id, user_id, status, gruppe, mkdate) VALUES (?, ?, ?, §, UNIX_TIMESTAMP())")
 
 $_views ["FOLDER_GET_DATA_BY_RANGE"]
 
 $_views ["FOLDER_GET_DATA_BY_THEMA"]
 
 $_views ["FOLDER_GET_DATA_BY_GRUPPE"]
 
 $_views ["FOLDER_UPDATE_PERMISSION"] = array("query" => "UPDATE folder SET permission=? WHERE folder_id=?")
 
 $_views ["FOLDER_UPDATE_CHDATE"] = array("query" => "UPDATE folder SET chdate=UNIX_TIMESTAMP() WHERE folder_id=?")
 

Variable Documentation

◆ $_views [1/12]

$_views["AUTH_USER_UNAME"]
Initial value:
= array("pk"=>"user_id","temp_table_type"=>"HEAP",
"query"=>"SELECT * FROM auth_user_md5 WHERE username=? ")

◆ $_views [2/12]

$_views["AUTH_USER_UID"]
Initial value:
= array("pk"=>"user_id","temp_table_type"=>"HEAP",
"query"=>"SELECT * FROM auth_user_md5 WHERE user_id=? ")

◆ $_views [3/12]

$_views["USER_DATA_UNAME"]
Initial value:
= array("pk"=>"user_id","temp_table_type"=>"HEAP",
"query"=>"SELECT § FROM auth_user_md5 LEFT JOIN user_info USING(user_id) WHERE username=? ")

◆ $_views [4/12]

$_views["GENERIC_UPDATE"] = array("query" => "UPDATE § SET §=? WHERE user_id=?")

◆ $_views [5/12]

$_views["AUTH_USER_INSERT"] = array("query" => "INSERT INTO auth_user_md5 (user_id, username, perms, password, Vorname, Nachname, Email,auth_plugin) VALUES (?,?,?,?,?,?,?,?)")

◆ $_views [6/12]

$_views["USER_INFO_INSERT"] = array("query" => "INSERT INTO user_info (user_id, mkdate, chdate, preferred_language) VALUES (?,?,?,?)")

◆ $_views [7/12]

$_views["SEM_USER_INSERT"] = array("query" => "INSERT INTO seminar_user (Seminar_id, user_id, status, gruppe, mkdate) VALUES (?, ?, ?, §, UNIX_TIMESTAMP())")

◆ $_views [8/12]

$_views["FOLDER_GET_DATA_BY_RANGE"]
Initial value:
= array("pk"=>"folder_id","temp_table_type"=>"HEAP",
"query"=>"SELECT * FROM folder WHERE range_id=? ORDER BY mkdate")

◆ $_views [9/12]

$_views["FOLDER_GET_DATA_BY_THEMA"]
Initial value:
= array("pk"=>"folder_id","temp_table_type"=>"HEAP",
"query"=>"SELECT folder.* FROM themen INNER JOIN folder ON(issue_id=folder.range_id) WHERE themen.seminar_id=? ORDER BY priority")

◆ $_views [10/12]

$_views["FOLDER_GET_DATA_BY_GRUPPE"]
Initial value:
= array("pk"=>"folder_id","temp_table_type"=>"HEAP",
"query"=>"SELECT folder.* FROM statusgruppen INNER JOIN folder ON(statusgruppe_id=folder.range_id) WHERE statusgruppen.range_id=? ORDER BY position")

◆ $_views [11/12]

$_views["FOLDER_UPDATE_PERMISSION"] = array("query" => "UPDATE folder SET permission=? WHERE folder_id=?")

◆ $_views [12/12]

$_views["FOLDER_UPDATE_CHDATE"] = array("query" => "UPDATE folder SET chdate=UNIX_TIMESTAMP() WHERE folder_id=?")