00001 <?php
00004
00005 set_include_path( '../php' . PATH_SEPARATOR . get_include_path());
00006 set_include_path( '../smarty/libs' . PATH_SEPARATOR . get_include_path());
00007
00008 if (session_id() == "") { session_start(); }
00009
00010 require_once 'Smarty.class.php';
00011 require_once 'sql.php';
00012 require_once 'error.php';
00013 require_once 'redirect.php';
00014 require_once 'util.php';
00015 require_once 'const.php';
00016 require_once 'config.php';
00017
00020
00021 function show_users() {
00022
00023 global $actions_info;
00024
00025 $smarty = smarty_init();
00026
00027 # init mysql connection
00028 $db = sql_init();
00029
00030 $sql_param = array ( "tables" => "user,state,degree",
00031 "cond" => "user.state_id = state.id AND
00032 degree.id = IF(user.use_alias,
00033 user.alias_degree_id,
00034 user.degree_id)",
00035 "columns" => " IF(user.use_alias,
00036 user.alias_forename,user.forename)
00037 AS forename,
00038 IF(user.use_alias,
00039 user.alias_surname,user.surname)
00040 AS surname,
00041 IF(user.use_alias,
00042 user.alias_sex,user.sex)
00043 AS sex,
00044 IF(user.use_alias,
00045 user.alias_degree_id,user.degree_id)
00046 AS degree_id,
00047 degree.description AS degree_description,
00048 user.use_alias,
00049 user.forename AS real_forename,
00050 user.surname AS real_surname, user.id,
00051 state.name AS state_name
00052 ",
00053 "order" => "surname,forename,sex,degree_description"
00054 );
00055
00056 if (isset($_SESSION['mode'])) {
00057 $tpl_vars['mode'] = $_SESSION['mode'];
00058 }
00059
00060 $tpl_vars['user'] = sql_query('select', $sql_param, $db);
00061
00062
00063 $tpl_vars['actions_info'] = $actions_info;
00064
00065 do_template($smarty, 'users.tpl', $tpl_vars, TRUE);
00066
00067 sql_exit($db);
00068
00069 }
00070
00071 show_users();
00072 ?>
