Immo 5 leader en gestion locative Ă Bruxelles et Brabant Wallon
La gestion locative intelligente et personnalisée
Un service de proximité compétent et flexible
/* ini_set('error_reporting', E_ALL); ini_set('display_errors', 1);*/ session_start(); include 'config.php'; include 'debug.php'; $link = mysql_connect(SQL_SVR,SQL_LOGIN,SQL_PASS) or die("Connexion failed :".mysql_error()); @mysql_select_db(SQL_DATABASE) or die("Unable to select the database: $bd ".mysql_error()); mysql_query("SET CHARACTER SET 'utf8';", $link)or die(mysql_error()); mysql_query("SET NAMES 'UTF8' "); include 'fr.php'; @include 'includes/class_paging.php'; if(isset($_GET['deconnexion'])){ unset($_SESSION['session_connecte']); unset($_SESSION['user_data_gl']); } /* GESTION DE LA CONNEXION */ @include '../includes/fonctions.php'; $connecte=false; if($_SESSION['session_connecte']>0){ $connecte=true; @include $dossier_syndic_online.'includes/fonctions.php'; @include($dossier_syndic_online."infos.php"); } if(!$connecte && isset($_GET['syndic_online'])){ header('LOCATION: accueil.html'); } /* AJOUT EASYSOLUTIONS */ if(isset($_POST['CONNEXION_FORM_ENVOYER'])) { //connexion // TODO $login=$_POST['log']; $password=trim($_POST['password']); $q = "SELECT sa.*, sc.* FROM (".PREFIXE_BDD_ESPACE_PRIVE."acces sa) LEFT JOIN ".PREFIXE_BDD_ESPACE_PRIVE."clients sc ON sa.idClient = sc.idClient". " WHERE LOWER(sa.login) = '".strtolower($login)."' AND LOWER(sa.password) = '".strtolower($password)."' AND online = '1'"; if ($tmp = mysql_query($q)){ if (mysql_num_rows($tmp) == 0){ $message_connexion=MESSAGE_CONNEXION_ERREUR; }else{ $user_data = mysql_fetch_assoc($tmp); //Connecté $_SESSION['session_connecte']='1'; $_SESSION['user_data_gl'] = $user_data; //recherche de l'exercice en cours $q = "(". "SELECT libelle_exercice, date_debut, date_fin, id_exercice, '1' courant FROM ".PREFIXE_BDD_ESPACE_PRIVE."exercice". " WHERE date_debut <= '". date("Y-m-d") ."'". " AND date_fin >= '". date("Y-m-d") ."'". " ORDER BY date_debut DESC". " LIMIT 1". ") UNION (". "SELECT libelle_exercice, date_debut, date_fin, id_exercice, '0' courant FROM ".PREFIXE_BDD_ESPACE_PRIVE."exercice". " ORDER BY date_debut DESC". " LIMIT 1". ")"; if( $exec_tmp = mysql_query($q) ){ if( $enr_tmp = mysql_fetch_assoc($exec_tmp) ){ $_SESSION['user_data_gl']['id_exercice']=$enr_tmp['id_exercice']; $_SESSION['user_data_gl']['exercice']=$enr_tmp; } } header('LOCATION:accueil_prive.html'); } }else{ $message_connexion=MESSAGE_CONNEXION_ERREUR; } } if(isset($_POST['MDP_FORM_ENVOYER'])) { //mot de passe oublié // TODO $login=$_POST['log']; $message_mdp="Cet identifiant n'existe pas."; } /* if($_GET['from']!='maj_auto'){ //verification_maj if(isset($GLOBALS['xml_version_path_MAJ'])){ $xml = @simplexml_load_file($GLOBALS['xml_version_path_MAJ']); if( !$xml ) $version = 0; else $version = $xml->version; //Numero de version du client $num_version = false; $query_version = "SELECT * FROM maj_version ORDER BY date_version DESC LIMIT 1"; if( $num_vers = mysql_query($query_version) ) $num_version = mysql_fetch_array($num_vers); if($num_version['num_version'] != $version){ header('location:../maj_auto_gl/index.php'); } } }*/ ?>