<?
/*************************************************************
 * Configuration
 *************************************************************/
$serveur = "localhost";
$base = "2025_nagoya_bciaerospace";
$login = "25meenagoyabciae"; 
$passw = "n_a0c112M";
$wwwroot     = "https://meetings.nagoya.bciaerospace.com/2025/";
$dirroot     = "2025";

//CONFIGURATION LOGISTIQUE///////////////////////////////////////////////////////////////////////////////


/*************************************************************
 * Configuration base de données
 *************************************************************/
$mysqli = mysqli_connect($serveur, $login, $passw, $base);
if (!$mysqli) {
	die("No DB Connection");
}
mysqli_set_charset($mysqli, "latin1");
error_reporting(E_ERROR | E_PARSE);

function mysqli_field_name($result, $field_offset)
{
    $properties = mysqli_fetch_field_direct($result, $field_offset);
    return is_object($properties) ? $properties->name : null;
}

$requetecf="SELECT * FROM configuration";
$qidcf = mysqli_query($mysqli, $requetecf) or die ("erreur requete cf");
$nb_fieldcf = mysqli_num_fields ($qidcf);
while ($reponsecf = mysqli_fetch_array ($qidcf))
{
$config[$reponsecf['variable_config']]=utf8_encode($reponsecf['valeur_config']);
$config2[$reponsecf['variable_config']]=utf8_encode($reponsecf['parametre_config']);
}

function datefr($date_en)
{
$date_fr=substr($date_en,8,2)."/".substr($date_en,5,2)."/".substr($date_en,0,4);
return $date_fr;
}

function datejour($date_en,$lng)
{
$timestamp = mktime(0, 0, 0, substr($date_en,5,2), substr($date_en,8,2), substr($date_en,0,4));
$jouren=date('D',$timestamp);
if ($lng=="en")
{
	if(substr($date_en,5,2)=="01"){$mm="Jan.";}
	if(substr($date_en,5,2)=="02"){$mm="Feb.";}
	if(substr($date_en,5,2)=="03"){$mm="Mar.";}
	if(substr($date_en,5,2)=="04"){$mm="Apr.";}
	if(substr($date_en,5,2)=="05"){$mm="May.";}
	if(substr($date_en,5,2)=="06"){$mm="Jun.";}
	if(substr($date_en,5,2)=="07"){$mm="Jul.";}
	if(substr($date_en,5,2)=="08"){$mm="Aug.";}
	if(substr($date_en,5,2)=="09"){$mm="Sep.";}
	if(substr($date_en,5,2)=="10"){$mm="Oct.";}
	if(substr($date_en,5,2)=="11"){$mm="Nov.";}
	if(substr($date_en,5,2)=="12"){$mm="Dec.";}
	$final=$jouren.". ".substr($date_en,8,2)." ".$mm." ".substr($date_en,0,4);
}
else
{
	if($jouren=="Mon"){$jourfr="Lun";}
	if($jouren=="Tue"){$jourfr="Mar";}
	if($jouren=="Wed"){$jourfr="Mer";}
	if($jouren=="Thu"){$jourfr="Jeu";}
	if($jouren=="Fri"){$jourfr="Ven";}
	if($jouren=="Sat"){$jourfr="Sam";}
	if($jouren=="Sun"){$jourfr="Dim";}
	if(substr($date_en,5,2)=="01"){$mm="Jan.";}
	if(substr($date_en,5,2)=="02"){$mm="Fev.";}
	if(substr($date_en,5,2)=="03"){$mm="Mar.";}
	if(substr($date_en,5,2)=="04"){$mm="Avr.";}
	if(substr($date_en,5,2)=="05"){$mm="Mai.";}
	if(substr($date_en,5,2)=="06"){$mm="Jui.";}
	if(substr($date_en,5,2)=="07"){$mm="Jul.";}
	if(substr($date_en,5,2)=="08"){$mm="Aoû.";}
	if(substr($date_en,5,2)=="09"){$mm="Sep.";}
	if(substr($date_en,5,2)=="10"){$mm="Oct.";}
	if(substr($date_en,5,2)=="11"){$mm="Nov.";}
	if(substr($date_en,5,2)=="12"){$mm="Déc.";}
	$final=$jourfr." ".substr($date_en,8,2)." ".$mm." ".substr($date_en,0,4);
}
return utf8_encode($final);
}

function traduction($traduction_page,$traduction_langue)
{
global $mysqli;
$requetetraduction="SELECT * FROM traductions WHERE page='".$traduction_page."' OR page=''";
$qidtraduction = mysqli_query($mysqli, $requetetraduction) or die ("erreur requete traduction");
while ($reponsetraduction = mysqli_fetch_array ($qidtraduction))
{
$final_str = str_replace('€', '&#8364;', $reponsetraduction['texte_'.$traduction_langue]);
$TEXTE[$reponsetraduction['idtexte']]=utf8_encode(nl2br($final_str));
}
return $TEXTE;
}

function messagestop($messages_page,$messages_langue,$messages_profil)
{
global $mysqli;
$requetemessages="SELECT id_message, texte_".$messages_langue." AS texte_message, type_message, `condition`, fait, condition2, fait2, condition3, fait3 FROM messages WHERE profil_".strtolower($messages_profil)."=1 AND  page='".$messages_page."' AND ((date1 LIKE '0000-00-00 00:00:00') OR ((date1<='".date('Y-m-d H:i:s')."') AND (date2>='".date('Y-m-d H:i:s')."'))) ORDER BY type_message DESC, id_message";
$qidmessages = mysqli_query($mysqli, $requetemessages) or die ("erreur requete messages");
while ($reponsemessage = mysqli_fetch_array ($qidmessages))
{
$MESSAGE[$reponsemessage['id_message']]=$reponsemessage['type_message']."#".utf8_encode(nl2br($reponsemessage['texte_message']))."#".$reponsemessage['condition']."#".$reponsemessage['fait']."#".$reponsemessage['condition2']."#".$reponsemessage['fait2']."#".$reponsemessage['condition3']."#".$reponsemessage['fait3'];
}
return $MESSAGE;
}
//$lien_cata['1.jpg']="http://www.aerospacemeetings.com";
?>