select( 'utilisateurs', 'id, login, email', "login='$user' AND password='$pwd' AND idClient=1 AND actif=1 AND deleted=0"); $_SESSION['userId']=$tabTmp[0][0]; $_SESSION['userMail']=$tabTmp[0][1]; if ( $_SESSION['userId'] ) {//&& $_SESSION['auth']) { $authorized = true; } } else { //if (isset($_GET["login"]) && (! $authorized)) { header('WWW-Authenticate: Basic Realm="Login please"'); header('HTTP/1.0 401 Unauthorized'); $_SESSION['auth'] = true; print('Login now or forever hold your clicks...'); exit; } if (!$authorized) { ?>

you have logged!

$env) { $nomAncre='#n'.$idEnv; }} ?> Gestion des informations de la base de données select( 'utilisateurs', 'id, login', "idClient=1"); $tabLogin=array(0=>'Batch'); foreach ($tabTmp as $user) { $tabLogin[$user['id']]=$user['login']; } ?>

Sirenage des annonces Bodacc

select( 'bodacc_sirenage s, bodacc_detail b, bodacc d, tabMandataires m', 's.idLien, s.idAnn, s.siren, s.siretProposes, s.dateInsert AS dateInsert_Sirenage, b.Bodacc_Num, b.Bodacc_Date_Parution, b.Num_Annonce, b.Tribunal_Code, b.Rubrique_Bodacc, b.Rubrique, b.typeAnnonce, b.corrNum_Annonce, b.corrBodacc_Date_Parution, b.corrPage, b.corrNumParution, b.corrTexteRectificatif, b.RC, b.raisonSociale, b.nomCommercial, b.enseigne, b.nationalite, b.FJ, b.Capital, b.CapitalDev, b.adresse, b.adrNum, b.adrIndRep, b.adrTypVoie, b.adrLibVoie, b.adrComp1, b.adrComp2, b.codePostal, b.ville, b.adresseSiege, b.adrSiegeNum, b.adrSiegeIndRep, b.adrSiegeTypVoie, b.adrSiegeLibVoie, b.adrSiegeComp1, b.adrSiegeComp2, b.codePostalSiege, b.villeSiege, b.administration, b.activite, b.typeEven, b.dateEffet, b.dateDebutActivite, b.dateCessationActivite, b.dateCessationPaiement, b.dateJugement, b.dateInsert AS dateInsert_Bodacc, d.annonce, b.activite, s.appelerMand, m.Nom, m.Prenom, m.type, m.coursAppel, m.tribunal, m.Statut, m.adresse, m.adresseComp, m.cp, m.ville, m.tel, m.fax, m.email, m.web, m.contact', 's.appelerMand>0 AND s.idAnn=b.id AND b.id=d.id AND s.siren=b.siren AND s.appelerMand=m.id ORDER BY s.appelerMand ASC', false, MYSQL_ASSOC); print_r($tabTmp);die(); foreach ($tabTmp as $tabJour) { echo ''; } ?>
DateLoginTotal sirené
'.$tabJour['Jour'].''.$tabLogin[$tabJour['idSirenage']].''.$tabJour['Nb'].'