<?php

/* $Id: profile.php 42 2009-01-29 04:55:14Z john $ */

$page = "bacheca2";
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";
}


$user_displayname = $user->user_displayname;

if(isset($_GET['esa_id'])) { $esa_id = (int) $_GET['esa_id']; }


  $esami = $database->database_query("SELECT * from comunicazioni, combach where cob_com_id=com_id and cob_bac_id=$esa_id order by com_data desc, com_id desc");
  while($esami_info = $database->database_fetch_assoc($esami)) {
    $esami_ids[] = $esami_info[com_id];
    $esami_txt[] = $esami_info[com_txt];
	$esami_data[] = $esami_info[com_data];
    $esami_attach[] = $esami_info[com_attach];
  }
//echo("SELECT * from comesami where come_id=".$esa_id);

  $bacheche = $database->database_query("SELECT * from comesami order by come_id");
  while($comesami_info = $database->database_fetch_assoc($bacheche)) {
    $bacheche_ids[] = $comesami_info[come_id];
    $bacheche_nome[] = $comesami_info[come_esame];
	$bacheche_docente[] = $comesami_info[come_ndocente];
  }


  $miabacheca = $database->database_query("SELECT * from comesami where come_id=".$esa_id);
  while($miabacheca_info = $database->database_fetch_assoc($miabacheca)) {
    $miabacheca_ids[] = $miabacheca_info[come_id];
    $miabacheca_nome[] = $miabacheca_info[come_esame];
    $miabacheca_desc[] = $miabacheca_info[come_desc];
    $miabacheca_email[] = $miabacheca_info[come_email];
	$miabacheca_docente[] = $miabacheca_info[come_ndocente];
	$miabacheca_pdocente[] = $miabacheca_info[come_pdocente];
  }
//echo("SELECT * from comesami where come_id=".$esa_id);

$total_esami = count($esami_ids);
$total_bacheche = count($bacheche_ids);
$smarty->assign('esami_ids', $esami_ids);
$smarty->assign('esami_txt', $esami_txt);
$smarty->assign('esami_data', $esami_data);
$smarty->assign('esami_attach', $esami_attach);
$smarty->assign('total_esami', $total_esami);
$smarty->assign('user_displayname', $user_displayname);

$smarty->assign('bacheche_ids', $bacheche_ids);
$smarty->assign('bacheche_nome', $bacheche_nome);
$smarty->assign('bacheche_docente', $bacheche_docente);
$smarty->assign('total_bacheche', $total_bacheche);

$smarty->assign('miabacheca_ids', $miabacheca_ids);
$smarty->assign('miabacheca_nome', $miabacheca_nome);
$smarty->assign('miabacheca_desc', $miabacheca_desc);
$smarty->assign('miabacheca_email', $miabacheca_email);
$smarty->assign('miabacheca_docente', $miabacheca_docente);
$smarty->assign('miabacheca_pdocente', $miabacheca_pdocente);

include "footer.php";
?>