# ajpn_administrateur ajpn_contributeur
# connect_base.php
# include
/*if (!function_exists(verifsession)) { */
function verifsession($idsession,$aduree,$uduree) {
$db=connect_base();
$now=date("Y-m-d H:i:s");
$requete="select * from ajpn_administrateur where idSession='$idsession' and validsession > '$now'";
#echo "
" . $requete;
$r = mysql_query($requete) or die("Erreur requête - $requete");
$tableadministrateur=mysql_fetch_array($r);
$ok=mysql_num_rows($r);
#echo "ok" . $ok;
if ($ok < '1') {
$idsession='';
} else {
$fin=mktime(date("H")+$aduree,date("i"),date("s"),date("m"),date("d"),date("Y"));
$fin=date("Y-m-d H:i:s",$fin);
$requete="update ajpn_administrateur set validsession='$fin' where idadministrateur='$tableadministrateur[idadministrateur]'";
$r = mysql_query($requete) or die("Erreur requête - $requete");
}
disconnect_base($db);
return $idsession;
}
/* } */
/* if (!function_exists(verifsessionclient)) { */
function verifsessionclient($idsession,$aduree,$uduree) {
$db=connect_base();
$now=date("Y-m-d H-i-s");
$requete="select * from ajpn_contributeur where idsession='$idsession' and validsession > '$now'";
#echo "
" . $requete;
$r = mysql_query($requete) or die("Erreur requête - $requete");
$tablepersonne=mysql_fetch_array($r);
$ok=mysql_num_rows($r);
if ($ok < '1') {
$requete="select * from ajpn_administrateur where idsession='$idsession' and validsession > '$now'";
$r = mysql_query($requete) or die("Erreur requête - $requete");
$tableadministrateur=mysql_fetch_array($r);
$ok=mysql_num_rows($r);
if ($ok < '1') {
$idsession='';
} else {
$fin=mktime(date("H")+$aduree,date("i"),date("s"),date("m"),date("d"),date("Y"));
$fin=date("Y-m-d H-i-s",$fin);
$requete="update ajpn_administrateur set validsession='$fin' where idadministrateur='$tableadministrateur[idadministrateur]'";
$r = mysql_query($requete) or die("Erreur requête - $requete");
}
} else {
$fin=mktime(date("H")+$uduree,date("i"),date("s"),date("m"),date("d"),date("Y"));
$fin=date("Y-m-d H-i-s",$fin);
$requete="update ajpn_contributeur set validsession='$fin' where noid='$tablepersonne[noid]'";
$r = mysql_query($requete) or die("Erreur requête - $requete");
}
disconnect_base($db);
return $idsession;
}
/* } */
/* if (!function_exists(renvoietype)) { */
function renvoietype($idsession) {
$db=connect_base();
$requete="select * from ajpn_contributeur where idsession='$idsession'";
$r = mysql_query($requete) or die("Erreur requête - $requete");
$tablepersonne=mysql_fetch_array($r);
$ok=mysql_num_rows($r);
if ($ok < '1') {
$requete="select * from ajpn_administrateur where idsession='$idsession'";
$r2 = mysql_query($requete) or die("Erreur requête - $requete");
$tablepersonnel=mysql_fetch_array($r2);
$type=$tablepersonnel['statut'];
} else {
$type="client";
}
disconnect_base($db);
return $type;
}
/* } */
/* if (!function_exists(kirikou)) { */
function kirikou($filter, $str)
{
$filter = md5($filter);
$letter = -1;
$newstr = '';
$str = base64_decode($str);
$strlen = strlen($str);
for ( $i = 0; $i < $strlen; $i++ )
{
$letter++;
if ( $letter > 31 )
{
$letter = 0;
}
$neword = ord($str{$i}) - ord($filter{$letter});
if ( $neword < 1 )
{
$neword += 256;
}
$newstr .= chr($neword);
}
return $newstr;
}
/* } */
function RecupererOrigine($Site)
{
$origine = 'Indéterminée';
$Fichier = file_get_contents($Site);
# cet appel ne sert plus sans la ligne ci-dessous
#if (eregi("(.*)", $Fichier, $Sortie)) $origine = $Sortie[1];
#if (preg_match("(.*)", $Fichier, $Sortie)) $origine = $Sortie[1];
return $origine;
}
function extractionentre($chainetexte, $depuis, $jusqua){
#echo "
depuis=" . $depuis;
#echo "
jusqua=" . $jusqua;
#echo "
chainetexte=" . $chainetexte;
$longueurdepuis = strlen($depuis);
$longueurjusqua = strlen($jusqua);
$longueurchainetexte = strlen($chainetexte);
#echo "
longueurdepuis=" . $longueurdepuis;
#echo "
longueurjusqua=" . $longueurjusqua;
#echo "
longueurchainetexte=" . $longueurchainetexte;
for ( $i = 1; $i < ($longueurchainetexte - $longueurdepuis); $i++ ) {
if ( substr($chainetexte, $i, $longueurdepuis) == $depuis ) {
$positiondebut = $i + $longueurDepuis;
break;
}
}
#echo "
positiondebut=" . $positiondebut;
for ( $i = 1; $i < ($longueurchainetexte - $longueurjusqua); $i++ ) {
if ( substr($chainetexte, $i, $longueurjusqua) == $jusqua ){
$positionfin = $i - 1;
break;
}
}
#echo "
positionfin=" . $positionfin;
$lextract = (substr($chainetexte, $positiondebut+1, $positionfin-1 - ($positiondebut - 1)));
return($lextract);
}
function extraitchaineentre($chaine, $chaine_deb, $chaine_fin)
{
$extr = '';
$debut = strpos($chaine, $chaine_deb);
$fin = strpos($chaine, $chaine_fin);
$extr = substr($chaine, $debut + strlen($chaine_deb), $fin - ($debut + strlen($chaine_deb)));
return ($extr);
}
// ---------------------------------------------------------------
// renvoie nom du robot si le visiteur est un robot de moteur de recherche
// ---------------------------------------------------------------
function isRobot() {
$robots = array("/Mediapartner/i", "/Googlebot/i", "/Slurp/i","/bingbot/i","/OrangeBot/i", "/smtbot/i","/MJ12bot/i","/Twitterbot/i","/msnbot/i", "/Twiceler/i", "/Exabot/i","/VoilaBot/i","/Yandex/i","/DotBot/i","/AltaVista/i","/BLEXBot/i","/ImageBot/i","/AddThis/i","/Feedfetcher/i","/deusu/i","/AhrefsBot/i","/Applebot/i","/SLCC/i","/tbot-nutch/i","/QuerySeekerSpider/i","/yacybot/i","/Baiduspider/i","/NerdyBot/i","/spbot/i","/NG\/2.0/i");
# Yandex : russie, DotBot américain seattle
$is_robot = "pasrobot";
foreach($robots as $robot) {
if (preg_match($robot, $_SERVER["HTTP_USER_AGENT"])) {
#$is_robot = $robot;
$is_robot = str_replace("/i","",$robot);
$is_robot = str_replace("/","",$is_robot);
break;
}
}
if ($is_robot == "pasrobot") {
if ( preg_match('/(bot|spider|yahoo)/i', $_SERVER[ "HTTP_USER_AGENT" ] )) {
#$is_robot = $_SERVER["HTTP_USER_AGENT"] ;
$is_robot = "robot" ;
}
}
return $is_robot;
}
function sans_accent($chaine) {
$accent ="ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøœùúûüýýþÿ?";
$noaccent="aaaaaaaceeeeiiiidnoooooouuuuybsaaaaaaaceeeeiiiidnooooooeuuuuyybyo";
$chaine=str_replace("è", "é",$chaine);
$chaine=str_replace("%C3%A9", "e",$chaine);
$urltous=str_replace("%C3%A0", "a",$urltous);
$chaine=str_replace("é", "e",$chaine);
$chaine=str_replace("ï", "i",$chaine);
$chaine=str_replace("ë", "e",$chaine);
$chaine=str_replace("’", "-",$chaine);
$chaine=str_replace("'", "-",$chaine);
$chaine=str_replace("%27", "-",$chaine);
$chaine=str_replace("â", "a",$chaine);
$chaine=str_replace("É", "e",$chaine);
$chaine=str_replace("Œ", "oe",$chaine);
$chaine=str_replace("œ", "oe",$chaine);
$chaine=str_replace("--", "-",$chaine);
return strtr(trim($chaine),$accent,$noaccent);
}
function stopira($chaine) {
$oldchaine_maju=$chaine;
$oldchaine_initial=$oldchaine_maju;
$oldchaine_maju=str_ireplace("SCRIPT", "SCRLPT",$oldchaine_maju);
$oldchaine_maju=str_ireplace("SESSDT", "TRUC",$oldchaine_maju);
#$oldchaine_maju=str_ireplace("OBJECT", "0BJECT",$oldchaine_maju);
$oldchaine_maju=str_ireplace("APPLET", "APPIET",$oldchaine_maju);
$oldchaine_maju=str_ireplace("EMBED", "EMBEO",$oldchaine_maju);
$oldchaine_maju=str_ireplace("HEADER", "HEAOER",$oldchaine_maju);
#$oldchaine_maju=str_ireplace("INCLUDE", "INCLUOE",$oldchaine_maju);
$oldchaine_maju=str_ireplace("IFRAME", "LFRAME",$oldchaine_maju);
$oldchaine_maju=str_ireplace("EXIT", "EXLT",$oldchaine_maju);
#$oldchaine_maju=str_ireplace("LINK", "LLNK",$oldchaine_maju);
# encodage
$nbX=substr_count ($oldchaine_maju, "XX");
$nbpcent=substr_count ($oldchaine_maju, "%");
if ($nbpcent>6) {
$oldchaine_maju=str_ireplace("%", "|",$oldchaine_maju);
}
if ($oldchaine_initial<>$oldchaine_maju) {
$chaine=$oldchaine_maju;
}
return $chaine;
}
function nettoie_date($chaine) {
$chaine=str_replace("JJ/","",$chaine);
$chaine=str_replace("MM/","",$chaine);
return $chaine;
}
function change_occcurence($lemot,$occurence_orig,$occurence_dest,$quelocu) {
#echo "
lemot=" . $lemot . " motorig=" . $occurence_orig . " motdest=" . $occurence_dest;
$lapos=strpos($lemot,$occurence_orig);
$debut=substr($lemot,0,$lapos);
$fin=substr($lemot,$lapos+strlen($occurence_orig),strlen($lemot));
$unmot1=$debut . $occurence_dest . $fin;
#echo "--------------------" . $unmot1;
return $unmot1;
}
function lien_juste($chaine) {
$lienjuste1="" . "WWustes";
$lienjuste2="" . "WXustes";
$lienjuste3="" . "WYuste";
$lienjuste4="" . "WZuste";
$chaine=str_replace("juste-","KQKuste",$chaine);
$chaine=str_replace("Henri Justes","HEXuste",$chaine);
$chaine=str_replace("Marthe Justes","MAXuste",$chaine);
$chaine=str_replace("Simone Justes","SIXuste",$chaine);
$chaine=str_replace("chez les Justes","CHZuste",$chaine);
$chaine=str_replace("Justes",$lienjuste1,$chaine);
$chaine=str_replace("justes",$lienjuste2,$chaine);
$chaine=str_replace("Juste",$lienjuste3,$chaine);
$chaine=str_replace("juste",$lienjuste4,$chaine);
$chaine=str_replace("WWustes","Justes",$chaine);
$chaine=str_replace("WXustes","justes",$chaine);
$chaine=str_replace("WYuste","Juste",$chaine);
$chaine=str_replace("WZuste","juste",$chaine);
$chaine=str_replace("KQKuste","juste-",$chaine);
$chaine=str_replace("kyjz.html","Justes.html",$chaine);
$chaine=str_replace("HEXuste","Henri Justes",$chaine);
$chaine=str_replace("MAXuste","Marthe Justes",$chaine);
$chaine=str_replace("SIXuste","Simone Justes",$chaine);
$chaine=str_replace("CHZuste","chez les Justes",$chaine);
$chaine=str_replace("uu","u",$chaine);
return $chaine;
}
function debut_calcultemps() {
$trouver_temps = explode(' ',microtime() );
$temps_debut = $trouver_temps[1].substr($trouver_temps[0], 1);
return $temps_debut;
}
function ecrire_temps($temps_debut,$precision) {
$partie_temps = explode(' ',microtime() );
$fin_temps = $partie_temps[1].substr($partie_temps[0],1);
$chrono = number_format($fin_temps - $temps_debut, 4);
if($precision > strlen($chrono)) { //si la precision demandée est plus grande que la longueur de la chaine
$chrono = substr($chrono, 0, strlen($chrono)); //on donne la precision maximale
} else {
$chrono = substr($chrono, 0, $precision);
}
return $chrono;
}
function kouriki($filter, $str)
{
$filter = md5($filter);
$letter = -1;
$newpass = '';
$strlen = strlen($str);
for ( $i = 0; $i < $strlen; $i++ )
{
$letter++;
if ( $letter > 31 )
{
$letter = 0;
}
$neword = ord($str{$i}) + ord($filter{$letter});
if ( $neword > 255 )
{
$neword -= 256;
}
$newstr .= chr($neword);
}
return base64_encode($newstr);
}
function cherchepos($lachaine, $lemot)
{
$stringmini = strtolower($lachaine);
$retval = strpos ($stringmini,$lemot);
return $retval;
}
function surmark($lachaine, $unmot, $couleur_accentuer_recherche, $couleur_accentuer_recherche_separ)
{
$stringmini = strtolower($lachaine);
$lapos = strpos ($stringmini,$unmot);
$lalong=strlen($unmot);
if ($lapos > -1) {
$debutchaine=substr($lachaine,0,$lapos);
$debutchaine=$debutchaine . "";
$lemotdansresultat=substr($lachaine,$lapos,strlen($unmot));
$finchaine="" . substr($lachaine,$lapos+strlen($unmot));
$lachaine= $debutchaine . $lemotdansresultat . $finchaine;
} else {
for ($j=0; $j < $lalong -1; $j++) {
$aunmot=substr($unmot,O,$j);
$bunmot=substr($unmot,$j,1);
$cunmot=substr($unmot,$j+1);
$defunmot= $aunmot . $bunmot . " " . $cunmot;
#echo "
==" . $defunmot . "==
";
$lapos1 = strpos ($stringmini,$defunmot);
if ($lapos1 > -1) {
$debutchaine=substr($lachaine,0,$lapos1);
$debutchaine=$debutchaine . "";
$lemotdansresultat=substr($lachaine,$lapos1,strlen($defunmot));
$finchaine="" . substr($lachaine,$lapos1+strlen($defunmot));
$lachaine= $debutchaine . $lemotdansresultat . $finchaine;
}
}
for ($j=0; $j < $lalong -1; $j++) {
$aunmot=substr($unmot,O,$j);
$bunmot=substr($unmot,$j,1);
$cunmot=substr($unmot,$j+1);
$defunmot= $aunmot . $bunmot . "-" . $cunmot;
#echo "
==" . $defunmot . "==
";
$lapos1 = strpos ($stringmini,$defunmot);
if ($lapos1 > -1) {
$debutchaine=substr($lachaine,0,$lapos1);
$debutchaine=$debutchaine . "";
$lemotdansresultat=substr($lachaine,$lapos1,strlen($defunmot));
$finchaine="" . substr($lachaine,$lapos1+strlen($defunmot));
$lachaine= $debutchaine . $lemotdansresultat . $finchaine;
}
}
}
return $lachaine;
}
$tablecivilite=array("mademoiselle"=>"Mademoiselle","madame"=>"Madame","monsieur"=>"Monsieur");
$tableaujour=array('01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31');
$tableaumois=array('01'=>"Janvier",'02'=>"Février",'03'=>"Mars",'04'=>"Avril",'05'=>"Mai",'06'=>"Juin",'07'=>"Juillet",'08'=>"Aout",'09'=>"Septembre",'10'=>"Octobre",'11'=>"Novembre",'12'=>"Décembre");
$tableheure=array("00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23");
$tablejour=array("1"=>"lundi","2"=>"mardi","3"=>"mercredi","4"=>"jeudi","5"=>"vendredi","6"=>"samedi","7"=>"dimanche");
$tableminute=array("00","15","30","45");
$date=date("Y");
$anneederniere=$date-1;
$anneeprochaine=$date+1;
$deuxans=$date+2;
$tableauannee=array($anneederniere,$date,$anneeprochaine,$deuxans);
$tableauannee2=array($date,$anneeprochaine);
include "connect_base.php";
?>