";
}
$db = mysql_connect("localhost", "atomik1_atomik1", "damnit1");
mysql_select_db("atomik1_interpac",$db);
if (isset($_SESSION['nomusager'])){
$nomusager = $_SESSION['nomusager'];
}else{
$nomusager="";
// session_unset();
// header("Location: http://www.interpac.ca/fr/");
}
$timeoutsecs = 300; // milli secs. for online users
$timestamp = time();
$ip=$_SERVER['REMOTE_ADDR'];
$idd=$_SESSION['uid'];
$t=0;
$t1=0;
$recherche="";
$self=$_SERVER['REQUEST_URI'];
$table="uonline";
$timeout=$timestamp-$timeoutsecs;
if($nomusager!=""){ //*****************************************doit etre undefined
$commande2 = "SELECT * FROM tmembres where NomUsager='$nomusager'" ;
$commande3 = "SELECT Online FROM tmembres where NomUsager='"+$nomusager+"'" ;
$insert1 = mysql_query("UPDATE atomik1_interpac.$table set id='$idd' where id='$idd'");
$rs2=mysql_query($commande2) ;
if(!$rs2){
echo " ";
}else{
// $rs3= mysql_query($commande3) ;
$checkip = mysql_query("SELECT nomusager FROM uonline WHERE nomusager='$idd'");
$compteip=mysql_fetch_row($checkip);
if(!$compteip[0]){
$insert = mysql_query("INSERT INTO atomik1_interpac.$table(timestamp,ip,file,nomusager,id) VALUES ('$timestamp','$ip','$self','$nomusager','$idd')");
}else{
$insert = mysql_query("UPDATE atomik1_interpac.$table SET timestamp='$timestamp' WHERE id='$idd'");
}
}}
//$checktimeout = mysql_query("delete FROM chat WHERE timestamp<$timeout");
if (isset($_SESSION['nomusager'])){
$nomusager = $_SESSION['nomusager'];
}
$motdepasse=$_SESSION['motdepasse'];
$nomusager=$_SESSION['nomusager'];
$commande7 = "SELECT * FROM tmembres where MotDePasse='$motdepasse' and NomUsager='$nomusager'" ;
$rs7=mysql_query($commande2) ;
while ($var7=mysql_fetch_array($rs7)){
$_SESSION['noMembre'] = $var7['noMembre'];
$_SESSION['nomMembre'] = $var7['nomMembre'];
$_SESSION['prenomMembre'] = $var7['prenomMembre'];
$_SESSION['noTelephone'] = $var7['noTelephone'];
$_SESSION['Adresse'] = $var7['Adresse'];
$_SESSION['Ville'] = $var7['Ville'];
$_SESSION['NomUsager'] = $var7['NomUsager'];
$_SESSION['CodePostal'] = $var7['CodePostal'];
$_SESSION['Online'] = $var7['Online'];
$_SESSION['email'] = $var7['email'];
$_SESSION['connecte'] = true;
$_SESSION['logged'] = true;
//$prenom=$_SESSION['prenomMembre'];
$pays=$var7['pays'];
}
/*
if(isset($_GET['province'])){
$province=$_GET['province'];
$rs=mysql_Query("SELECT City from pctous where ProvinceCode='$province' Group by City order by City ");
}else{
$province="QC";
$rs1="select * from tmembres where nomusager='".$_SESSION['nomusager']."'";
$rss1=mysql_query($rs1);
$var1=mysql_fetch_row($rss1);
$rs=mysql_Query("SELECT City from pctous where ProvinceCode='$province' Group by City order by City ");
}*/
if(isset($_GET['pays'])){
$pays=$_GET['pays'];
}
if(isset($_GET['province'])){
if($pays=='ca'){
$province=$_GET['province'];
$rs=mysql_Query("SELECT City from pctous where ProvinceCode='$province' Group by City order by City ");
}else{
$province=$_GET['province'];
$rs=mysql_Query("SELECT NomVille from Ville Group by NomVille order by NomVille ");
}
}else{
if($pays=='ca'){
$province="QC";
$rs=mysql_Query("SELECT City from pctous where ProvinceCode='$province' Group by City order by City ");
}else{
$province="11";
$rs=mysql_Query("SELECT NomVille from Ville Group by NomVille order by NomVille ");
}
}
$ab="";
$cb="";
$pe="";
$ma="";
$ns="";
$nb="";
$nu="";
$on="";
$qc="";
$sk="";
$nl="";
$nt="";
$yt="";
$ca="";
$fr="";
switch ($pays){
case "ca":
$ca="selected";
break;
case "fr":
$fr="selected";
break;
}
switch ($province){
case "AB":
$ab="selected";
break;
case "BC":
$cb="selected";
break;
case "PE":
$pe="selected";
break;
case "MB":
$ma="selected";
break;
case "NS":
$ns="selected";
break;
case "NB":
$nb="selected";
break;
case "NU":
$nu="selected";
break;
case "ON":
$on="selected";
break;
case "QC":
$qc="selected";
break;
case "SK":
$sk="selected";
break;
case "NL":
$nl="selected";
break;
case "NT":
$nt="selected";
break;
case "YT":
$yt="selected";
break;
}
?>
