<?php

/* $Id: profile.php 42 2009-01-29 04:55:14Z john $ */

$page = "esami";
include "header.php";

// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
if($user->user_exists == 0 && $setting['setting_permission_profile'] == 0)
{
  $page = "error";
  $smarty->assign('error_header', 639);
  $smarty->assign('error_message', 656);
  $smarty->assign('error_submit', 641);
  include "footer.php";
}

$userid = $user->user_info['user_id'];
$user_displayname = $user->user_displayname;
$user_username = $user->user_info['user_username'];

//echo $user_username;
//echo ("SELECT * from se_users, esami  where esa_matricola=user_username and user_username='$user_username' order by esa_data");


  $esami = $database->database_query("SELECT * from se_users, esami  where esa_matricola=user_username and user_username='{$user->user_info['user_username']}' order by esa_data");
  while($esami_info = $database->database_fetch_assoc($esami)) {


//echo ("SELECT * from se_users, esami  where esa_matricola=user_username and user_username='{$user->user_info['user_username']}' order by esa_data");

    $esami_ids[] = $esami_info[esa_id];
    $esami_matricola[] = $esami_info[esa_matricola];
$esami_data[] = $esami_info[esa_data];
 //   $esami_data[]= strftime('%d/%m/%Y',$esami_info[esa_data]);
    $esami_codemat[] = $esami_info[esa_codemat];
    $esami_materia[] = $esami_info[esa_materia];
    $esami_cfu[] = $esami_info[esa_cfu];
    $esami_anno[] = $esami_info[esa_anno];
    $esami_sede[] = $esami_info[esa_sede];
if ($esami_info[esa_lode]==1){$esami_voto[] = $esami_info[esa_voto]." con lode";}else{$esami_voto[] = $esami_info[esa_voto]."/30";}
    
//$esami_lode[] = $esami_info[esa_lode];
  }
//echo ("SELECT * from se_users, esami  where esa_user_id=user_id and user_id='{$user->user_info['user_id']}'");

$total_esami = count($esami_ids);
$smarty->assign('esami_ids', $esami_ids);
$smarty->assign('esami_matricola', $esami_matricola);
$smarty->assign('esami_data', $esami_data);
$smarty->assign('esami_codemat', $esami_codemat);
$smarty->assign('esami_materia', $esami_materia);
$smarty->assign('esami_cfu', $esami_cfu);
$smarty->assign('esami_anno', $esami_anno);
$smarty->assign('esami_sede', $esami_sede);
$smarty->assign('esami_voto', $esami_voto);
//$smarty->assign('esami_lode', $esami_lode);
$smarty->assign('total_esami', $total_esami);
$smarty->assign('user_displayname', $user_displayname);
$smarty->assign('myuser_id', $userid);
include "footer.php";
?>