%PDF- %PDF-
setcookie("moncookie","mavaleur",time()+2592000,"/",".mixs.fr",0);
ini_set('session.use_cookies', '1');
ini_set('session.use_only_cookies', '1'); // PHP >= 4.3
ini_set('session.use_trans_sid', '0');
ini_set('session.cookie_lifetime',time()+2592000);
ini_set('url_rewriter.tags', '');
session_start();
$mysqlconnect = @mysql_connect($mysqladdress,$mysqlusername,$mysqluserpass) or die("Connexion impossible. Veuillez nous en excuser, nous faisons actuellement tout notre possible pour un rapide retour à la normale...");
@mysql_select_db($mysqlbasename, $mysqlconnect) or die("Base introuvable");
if ($connexion_action > "") {
if (isset($_COOKIE["moncookie"])) {
$mysqlquery = "SELECT * FROM membres WHERE pseudo='$login' AND mdp='$passwd'";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_connexion=$row[0];
$pseudo_connexion=$row[1];
$mdp_connexion=$row[3];
$statut_connexion=$row[15];
if ($statut_connexion=="1") {
session_register('pseudo_connexion', 'mdp_connexion');
$date_log = date("Y-m-d H:i:s");
$ip_log = $_SERVER['REMOTE_ADDR'];
$mysqlquery2 = "INSERT into logs (id_log,date_log,ip_log) values ('$id_connexion','$date_log','$ip_log')";
$mysqlresult2 = mysql_query($mysqlquery2,$mysqlconnect) or die ("Erreur !");
} else { ?> }
}} else { header("location:http://www.mixs.fr/accounts/stop.php"); }
} else { ?> }
}
$connecte="non";
if($_SESSION['pseudo_connexion'] != "" && $_SESSION['mdp_connexion'] != "") {
$mysqlquery3 = "SELECT * FROM membres WHERE pseudo='$_SESSION[pseudo_connexion]' AND mdp='$_SESSION[mdp_connexion]'";
$mysqlresult3 = mysql_query($mysqlquery3,$mysqlconnect);
if(mysql_num_rows($mysqlresult3) > 0) {
$row=mysql_fetch_row($mysqlresult3);
$id_connecte=$row[0];
$pseudo_connecte=$row[1];
$email_connecte=$row[2];
$mdp_connecte=$row[3];
$nom_connecte=$row[4];
$prenom_connecte=$row[5];
$date_naissance_connecte=$row[6];
$presentation_connecte=$row[7];
$pays_connecte=$row[8];
$departement_connecte=$row[9];
$sexe_connecte=$row[10];
$ip_inscription_connecte=$row[11];
$date_inscription_connecte=$row[12];
$autorisation_connecte=$row[13];
$key_activation_connecte=$row[14];
$statut_connecte=$row[15];
$avatar_connecte=$row[16];
$etoiles_connecte=$row[17];
$connecte="oui";
}}
if( !defined('blogs') ) { include_once("functions_captcha.php"); }
$mysqlquery1 = "SELECT * FROM sondages_sondages WHERE id_rubrique='".$id_rubrique_sondage."' ORDER BY date_ajout DESC LIMIT 0,1";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
if(mysql_num_rows($mysqlresult1) > 0) {
$row=mysql_fetch_row($mysqlresult1);
$id_sondage=$row[0];
$date_ajout=$row[1];
$question=$row[2];
$vote_permis = true;
if ($HTTP_COOKIE_VARS["sondage_".$id_sondage]) { $vote_permis = false; }
if ($voter_sondage=="yes"){
if (!$HTTP_COOKIE_VARS["sondage_".$id_sondage]){
//echo "le cookie n'existe pas !";
$mysqlquery = "UPDATE sondages_reponses SET nb_votes = nb_votes+1 WHERE id_sondage='".$id_sondage."' AND id_reponse='".$rep_sondage."'";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect) or die ("Erreur !");
if ($rep_sondage) {
$vote_save = $id_sondage;
setcookie("sondage_".$id_sondage,1,time()+2592000,"/",".mixs.fr",0);
}
}
}
}
$erreur="";
if ($ajouter_commentaire_action > "") {
if($connecte!="oui") {
if ($pseudo_commentaire=="") { $erreur=1; }
if (!chk_crypt($code_commentaire)) { $erreur=1; }
if ($spam_commentaire!="Ne pas modifier ceci !") { $erreur=1; }
}
if ($texte_commentaire=="") { $erreur=1; }
if ($erreur=="") {
if ($mdp_commentaire!="") {
if (isset($_COOKIE["moncookie"])) {
$mysqlquery = "SELECT * FROM membres WHERE pseudo='".$pseudo_commentaire."' AND mdp='".$mdp_commentaire."'";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_connexion=$row[0];
$pseudo_connexion=$row[1];
$mdp_connexion=$row[3];
$statut_connexion=$row[15];
if ($statut_connexion=="1") {
session_register('pseudo_connexion', 'mdp_connexion');
$connecte="oui";
$pseudo_connecte=$pseudo_connexion;
$ip_log = $_SERVER['REMOTE_ADDR'];
$mysqlquery2 = "INSERT into logs (id_log,date_log,ip_log) values ('".$id_connexion."','".$date_log."','".$ip_log."')";
$mysqlresult2 = mysql_query($mysqlquery2,$mysqlconnect) or die ("Erreur !");
$mysqlquery14 = "INSERT into commentaires (id,nom,id_auteur,auteur,texte,date,ip) values ('','".$nom_service_commentaire."','".$id_connexion."','".$pseudo_connexion."','".$texte_commentaire."','".date("Y-m-d H:i:s")."','".$_SERVER['REMOTE_ADDR']."')";
$mysqlresult14 = mysql_query($mysqlquery14,$mysqlconnect) or die ("Erreur !");
$id_commentaire = mysql_insert_id();
header("location: http://www.mixs.fr/".$uri_redirection_commentaire."#c".$id_commentaire);
} else { $erreur=1; }
}} else {
$mysqlquery14 = "INSERT into commentaires (id,nom,id_auteur,auteur,texte,date,ip) values ('','".$nom_service_commentaire."','".$id_connecte."','".$pseudo_commentaire."','".$texte_commentaire."','".date("Y-m-d H:i:s")."','".$_SERVER['REMOTE_ADDR']."')";
$mysqlresult14 = mysql_query($mysqlquery14,$mysqlconnect) or die ("Erreur !");
$id_commentaire = mysql_insert_id();
header("location: http://www.mixs.fr/".$uri_redirection_commentaire."#c".$id_commentaire);
}} else { $erreur=1; }
} else {
$mysqlquery14 = "INSERT into commentaires (id,nom,id_auteur,auteur,texte,date,ip) values ('','".$nom_service_commentaire."','".$id_connecte."','".$pseudo_commentaire."','".$texte_commentaire."','".date("Y-m-d H:i:s")."','".$_SERVER['REMOTE_ADDR']."')";
$mysqlresult14 = mysql_query($mysqlquery14,$mysqlconnect) or die ("Erreur !");
$id_commentaire = mysql_insert_id();
header("location: http://www.mixs.fr/".$uri_redirection_commentaire."#c".$id_commentaire);
}
}
}
if ($erreur=="1") { header("location: http://www.mixs.fr/".$uri_redirection_commentaire."#c"); }
$erreur="";
// Live-counter
$nb_connectes_connexion=400;
// Heure courante
$heure_connectes=date("U");
// Récupère l'adresse IP
$ip_connectes=$REMOTE_ADDR;
// Recherche de l'Ip dans la base de données
$query_connectes="select ip from nb_connectes where ip='$ip_connectes'";
$result_connectes=mysql_query($query_connectes,$mysqlconnect);
$nb_connectes=mysql_num_rows($result_connectes);
if ($nb_connectes)
{
// Mise à jour de la connexion
$query_connectes="update nb_connectes set time='$heure_connectes', id_membre='$id_connecte' where ip='$ip_connectes'";
$result_connectes=mysql_query($query_connectes,$mysqlconnect);
}
else
{
// Création de la connexion
$query_connectes="insert into nb_connectes (ip, time, id_membre) values ('".$ip_connectes."', '".$heure_connectes."', '".$id_connecte."')";
$result_connectes=mysql_query($query_connectes,$mysqlconnect);
}
// Calcul tps max de connexion
$heure_max_connectes=$heure_connectes-$nb_connectes_connexion;
// Suppression des connexions max dans la base de données
$query_connectes="delete from nb_connectes where time<'$heure_max_connectes'";
$result_connectes=mysql_query($query_connectes,$mysqlconnect);
function noter($s_notes,$id_notes,$url_notes,$template='1') {
global $mysqlconnect,$connecte,$id_connecte;
if($connecte=="oui") {
$mysqlquery = "SELECT * FROM notes WHERE id_membre='".$id_connecte."' AND nom='".$s_notes."-".$id_notes."'";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
$row=mysql_fetch_row($mysqlresult);
$note_connecte=$row[3];
} else { $note_connecte=0; }
} else { $note_connecte=0; }
$mysqlquery1 = "SELECT * FROM notes WHERE nom='".$s_notes."-".$id_notes."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$nb_notes = mysql_num_rows($mysqlresult1);
$mysqlquery2 = "SELECT SUM(note) FROM notes WHERE nom='".$s_notes."-".$id_notes."' GROUP BY nom";
$mysqlresult2 = mysql_query($mysqlquery2,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult2);
$total_notes=$row[0];
$moyenne = @round($total_notes/$nb_notes);
?>
Ma note :
href="javascript:;" onClick="noter('= $s_notes; ?>','= $id_notes; ?>','1',= $template; ?>);" } else { ?>href="/accounts/reserve.php?url== $url_notes; ?>" } ?> onMouseOver="starOver('1','= $id_notes; ?>');" onMouseOut="starOut('0','= $id_notes; ?>','= $note_connecte; ?>');"> up } else { ?>down } ?>.png" id="star1-= $id_notes; ?>" alt="Donner la note de 1/5" /> href="javascript:;" onClick="noter('= $s_notes; ?>','= $id_notes; ?>','= $note_connecte; ?>',= $template; ?>);" } else { ?>href="/accounts/reserve.php?url== $url_notes; ?>" } ?> onMouseOver="starOver('2','= $id_notes; ?>');" onMouseOut="starOut('0','= $id_notes; ?>','= $note_connecte; ?>');"> up } else { ?>down } ?>.png" id="star2-= $id_notes; ?>" alt="Donner la note de 2/5" /> href="javascript:;" onClick="noter('= $s_notes; ?>','= $id_notes; ?>','3',= $template; ?>);" } else { ?>href="/accounts/reserve.php?url== $url_notes; ?>" } ?> onMouseOver="starOver('3','= $id_notes; ?>');" onMouseOut="starOut('0','= $id_notes; ?>','= $note_connecte; ?>');"> up } else { ?>down } ?>.png" id="star3-= $id_notes; ?>" alt="Donner la note de 3/5" /> href="javascript:;" onClick="noter('= $s_notes; ?>','= $id_notes; ?>','4',= $template; ?>);" } else { ?>href="/accounts/reserve.php?url== $url_notes; ?>" } ?> onMouseOver="starOver('4','= $id_notes; ?>');" onMouseOut="starOut('0','= $id_notes; ?>','= $note_connecte; ?>');"> up } else { ?>down } ?>.png" id="star4-= $id_notes; ?>" alt="Donner la note de 4/5" /> href="javascript:;" onClick="noter('= $s_notes; ?>','= $id_notes; ?>','5',= $template; ?>);" } else { ?>href="/accounts/reserve.php?url== $url_notes; ?>" } ?> onMouseOver="starOver('5','= $id_notes; ?>');" onMouseOut="starOut('0','= $id_notes; ?>','= $note_connecte; ?>');"> up } else { ?>down } ?>.png" id="star5-= $id_notes; ?>" alt="Donner la note de 5/5" /> if ($template==1) { ?> - } elseif ($template==2) { echo "
"; }?>Moyenne (= $nb_notes; ?> note if ($nb_notes > 1) { ?>s } ?>) :
.png" width="17" height="16" alt=" if ($moyenne >= 2) { echo "*"; } else { echo "-"; } ?>" />
.png" width="17" height="16" alt=" if ($moyenne >= 3) { echo "*"; } else { echo "-"; } ?>" />
.png" width="17" height="16" alt=" if ($moyenne >= 4) { echo "*"; } else { echo "-"; } ?>" />
.png" width="17" height="16" alt=" if ($moyenne == 5) { echo "*"; } else { echo "-"; } ?>" />
}
function nb_commentaires($nom) {
global $mysqlconnect;
$mysqlquery = "SELECT COUNT(*) FROM commentaires WHERE nom='".$nom."'";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult);
$nb_commentaires = $row[0];
return $nb_commentaires;
}
function commentaires ($nom,$uri) {
global $connecte,$pseudo_connecte,$mysqlconnect;
?>
Commentaires
$i=0;
$mysqlquery = "SELECT * FROM commentaires WHERE nom='".$nom."' ORDER BY date ASC";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_commentaire=$row[0];
$id_posteur=$row[2];
$nom_posteur=encoder($row[3]);
$texte_commentaire=encoder($row[4]);
$date_commentaire=$row[5];
$date_commentaire = fdate($date_commentaire, 1);
if($id_posteur!="0") {
$mysqlquery16 = "SELECT * FROM membres WHERE id='".$id_posteur."'";
$mysqlresult16 = mysql_query($mysqlquery16,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult16);
$nom_posteur=$row[1];
$avatar_posteur=$row[16];
}
?>
}} ?>
}
function convert_sec ($time) {
$output="";
$minutes=floor($time/60);
$secondes=$time-($minutes*60);
if ($minutes > 0) {
$output=$minutes." minute";
if ($minutes > 1) { $output.="s"; }
if ($secondes > 0) { $output.=", "; }}
if ($secondes > 0) {
$output.=$secondes." seconde";
if ($secondes > 1) { $output.="s"; }}
return $output;
}
function redimlogo ($image, $largeur_maxi, $hauteur_maxi) {
if ($largeur_maxi<=0 AND $hauteur_maxi<=0) {} // Pas de mise à l'échelle si négatif ou nul
elseif ($image != "images/") { // Que si l'image existe !
$dim_image = @getimagesize($image);
$largeur_image = $dim_image[0];
$hauteur_image = $dim_image[1];
if ($largeur_image+$hauteur_image>0) {
// Calcul des facteurs de réduction
$reduction_largeur = $largeur_maxi/$largeur_image;
$reduction_hauteur = $hauteur_maxi/$hauteur_image;
// Choix du "bon" facteur de réduction
if ($reduction_largeur<=0) { $reduction = min(1,$reduction_hauteur); }
elseif ($reduction_hauteur<=0) { $reduction = min(1,$reduction_largeur); }
else {$reduction = min(1, $reduction_hauteur, $reduction_largeur); }
// Calcul des paramètres à renvoyer
$largeur = ceil($largeur_image*$reduction);
$hauteur = ceil($hauteur_image*$reduction);
$parametres = "height=\"".$hauteur."\" width=\"".$largeur."\"";
if ($hauteur_maxi >= $hauteur_image && $largeur_maxi >= $largeur_image) { $parametres = ""; }
}
}
return $parametres;
}
/**
* main function for parsing xml file
*
* @param string $file xml file to parse
* @return array result of the parsing
*/
function MPxmlParse($file) {
ini_xml(); //in globals variables
$rXMLPARSER = xml_parser_create();
xml_parser_set_option($rXMLPARSER, XML_OPTION_CASE_FOLDING, 1);
xml_set_element_handler($rXMLPARSER, 'start_element', 'close_element');
xml_set_character_data_handler($rXMLPARSER,'character_data');
$fp = @fopen($file, 'r');
while($sXmlStream = @fread($fp, 4096)) {
if (!xml_parse($rXMLPARSER, $sXmlStream, feof($fp))) {
die('Error parsing xml file');
}
}
@fclose($fp);
$aRet['ressources'] = $GLOBALS[aXmlTotalElements];
$aRet['infos'] = $GLOBALS[xmlInfos];
return $aRet;
}
/**
* start_element
* @private
*/
function start_element($parser, $name, $attrs='') {
$name = strtolower(trim($name));
$GLOBALS[sXmlactualElement] = $name;
if(in_array($name, $GLOBALS[aSpecialElements])) {
$GLOBALS[xmlElementCpt]++;
}elseif($name == 'drt') {
$GLOBALS[aXmlAttrs] = $attrs;
}
} // end func start_element
/**
* close_element
* @private
*/
function close_element($parser, $name, $attrs='') {
$name = strtolower(trim($name));
if($name == 'ressource' && $GLOBALS[sXmlactualElement] != 'file') {
$GLOBALS[xmlElementCpt]++;
}
} // end func close_element
/**
* character_data
* @private
*/
function character_data($parser, $data='') {
if($GLOBALS[sXmlactualElement] != 'ressource'
&& $GLOBALS[sXmlactualElement] != 'drt'
&& !in_array($GLOBALS[sXmlactualElement], $GLOBALS[aSpecialElements]) ) {
$GLOBALS[aXmlTotalElements][$GLOBALS[xmlElementCpt]][$GLOBALS[sXmlactualElement]].= trim($data);
}elseif($GLOBALS[sXmlactualElement] == 'drt') {
$GLOBALS[xmlInfos] = $GLOBALS[aXmlAttrs];
}else{
if($GLOBALS[sXmlactualElement] != 'ressource') {
$GLOBALS[xmlInfos][$GLOBALS[sXmlactualElement]].= trim($data);
}
}
} // end func character_data
/**
* initialize xml variables
*/
function ini_xml() {
$GLOBALS[aXmlTotalElements] = array();
$GLOBALS[sXmlactualElement] = '';
$GLOBALS[xmlElementCpt] = 0;
$GLOBALS[aXmlAttrs] = array();
$GLOBALS[xmlInfos] = array();
$GLOBALS[aSpecialElements] = array('ressource','first_url','last_url','next_url','prev_url');
} // end func ini_xml
function urls ($var,$sep='-') {
$Caracs = array("¥" => "Y", "µ" => "u", "À" => "A", "Á" => "A",
"Â" => "A", "Ã" => "A", "Ä" => "A", "Å" => "A",
"Æ" => "A", "Ç" => "C", "È" => "E", "É" => "E",
"Ê" => "E", "Ë" => "E", "Ì" => "I", "Í" => "I",
"Î" => "I", "Ï" => "I", "Ð" => "D", "Ñ" => "N",
"Ò" => "O", "Ó" => "O", "Ô" => "O", "Õ" => "O",
"Ö" => "O", "Ø" => "O", "Ù" => "U", "Ú" => "U",
"Û" => "U", "Ü" => "U", "Ý" => "Y", "ß" => "s",
"à" => "a", "á" => "a", "â" => "a", "ã" => "a",
"ä" => "a", "å" => "a", "æ" => "a", "ç" => "c",
"è" => "e", "é" => "e", "ê" => "e", "ë" => "e",
"ì" => "i", "í" => "i", "î" => "i", "ï" => "i",
"ð" => "o", "ñ" => "n", "ò" => "o", "ó" => "o",
"ô" => "o", "õ" => "o", "ö" => "o", "ø" => "o",
"ù" => "u", "ú" => "u", "û" => "u", "ü" => "u",
"ý" => "y", "ÿ" => "y");
$var = strtr($var, $Caracs);
$var = str_replace($sep," ",$var);
$var = eregi_replace("[^a-z0-9\ ]", "", $var);
while(strpos($var," ")) {
$var = str_replace(" "," ",$var);
}
$var = trim($var);
$var = str_replace(" ",$sep,$var);
$var = strtolower($var);
if ($var=="") { $var="none"; }
return stripslashes($var);
}
function arrondi($nombrea,$n) {
return trim(number_format($nombrea,$n,".",""));
}
function verif_string($string)
{
$length = strlen($string);
$tab_valid = array('a','z','e','r','t','y','u','i','o','p','q','s','d','f','g','h','j','k','l','m','w','x','c','v','b','n', '-', '_', '1','2','3','4','5','6','7','8','9','0');
if ($length!=0) {
for($i=0; $i < $length; $i++) $tab_string[$i] = substr($string,$i,1);
$nb_car_valid = 0;
foreach ($tab_string as $car) {
foreach ($tab_valid as $car_valid) {
if ($car == $car_valid) {
$nb_car_valid++;
break 1;
}
}
}
if($nb_car_valid == $length) return 1;
return 0;
}
return 1;
}
function rendrecliquable($chaine){
$chaine = eregi_replace("(([a-z0-9_]|\\-|\\.)+@([^[:space:]]*)([[:alnum:]-]))","\\1 ",$chaine);
$chaine = preg_replace('`\[url=(.*?)](.*?)\[/url]`si','$2 ',$chaine);
return($chaine);
}
function smileys($chaine) {
$chemin = " ", $chaine);
$chaine = str_replace(":-D", $chemin . "biggrin.gif\">", $chaine);
$chaine = str_replace(":grin:", $chemin . "biggrin.gif\">", $chaine);
$chaine = str_replace(":)", $chemin . "smile.gif\">", $chaine);
$chaine = str_replace(":-)", $chemin . "smile.gif\">", $chaine);
$chaine = str_replace(":smile:", $chemin . "smile.gif\">", $chaine);
$chaine = str_replace(":(", $chemin . "sad.gif\">", $chaine);
$chaine = str_replace(":-(", $chemin . "sad.gif\">", $chaine);
$chaine = str_replace(":sad:", $chemin . "sad.gif\">", $chaine);
$chaine = str_replace(":oops:", $chemin . "redface.gif\">", $chaine);
$chaine = str_replace(":o", $chemin . "surprised.gif\">", $chaine);
$chaine = str_replace(":-o", $chemin . "surprised.gif\">", $chaine);
$chaine = str_replace(":eek:", $chemin . "surprised.gif\">", $chaine);
$chaine = str_replace(":shock:", $chemin . "eek.gif\">", $chaine);
$chaine = str_replace(":?:", $chemin . "question.gif\">", $chaine);
$chaine = str_replace(":?", $chemin . "confused.gif\">", $chaine);
$chaine = str_replace(":-?", $chemin . "confused.gif\">", $chaine);
$chaine = str_replace(":???:", $chemin . "confused.gif\">", $chaine);
$chaine = str_replace("8-)", $chemin . "cool.gif\">", $chaine);
$chaine = str_replace(":cool:", $chemin . "cool.gif\">", $chaine);
$chaine = str_replace(":lol:", $chemin . "lol.gif\">", $chaine);
$chaine = str_replace(":x", $chemin . "mad.gif\">", $chaine);
$chaine = str_replace(":-x", $chemin . "mad.gif\">", $chaine);
$chaine = str_replace(":mad:", $chemin . "mad.gif\">", $chaine);
$chaine = str_replace(":P", $chemin . "razz.gif\">", $chaine);
$chaine = str_replace(":-P", $chemin . "razz.gif\">", $chaine);
$chaine = str_replace(":razz:", $chemin . "razz.gif\">", $chaine);
$chaine = str_replace(":cry:", $chemin . "cry.gif\">", $chaine);
$chaine = str_replace(":evil:", $chemin . "evil.gif\">", $chaine);
$chaine = str_replace(":twisted:", $chemin . "twisted.gif\">", $chaine);
$chaine = str_replace(":roll:", $chemin . "rolleyes.gif\">", $chaine);
$chaine = str_replace(":wink:", $chemin . "wink.gif\">", $chaine);
$chaine = str_replace(";)", $chemin . "wink.gif\">", $chaine);
$chaine = str_replace(";-)", $chemin . "wink.gif\">", $chaine);
$chaine = str_replace(":!:", $chemin . "exclaim.gif\">", $chaine);
$chaine = str_replace(":idea:", $chemin . "idea.gif\">", $chaine);
$chaine = str_replace(":arrow:", $chemin . "arrow.gif\">", $chaine);
$chaine = str_replace(":|", $chemin . "neutral.gif\">", $chaine);
$chaine = str_replace(":-|", $chemin . "neutral.gif\">", $chaine);
$chaine = str_replace(":neutral:", $chemin . "neutral.gif\">", $chaine);
$chaine = str_replace(":mrgreen:", $chemin . "mrgreen.gif\">", $chaine);
return $chaine;
}
function chainepasse($var) {
return (eregi("[^a-z0-9]",$var));
}
function block_tags($string){
$replaced_string = str_replace('<','<',$string);
$replaced_string = str_replace('>','>',$replaced_string);
return $replaced_string;
}
function encoder($var, $option=0) {
if($var != "") {
if($option != "1") { $var=block_tags($var); }
return stripslashes($var);
}
}
function cutLongWords($string,$length='25',$separation=' ') {
return preg_replace('/([^ ]{'.$length.'})/si','\\1'.$separation,$string);
}
function censureIp($ip) {
$ereg = "([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})";
return ereg_replace($ereg, "\\1.\\2.\\3.***", $ip);
}
function email($email) {
return eregi('[a-z0-9-]{2,50}@[a-z0-9-]{2,50}\.[a-z]{2,3}', $email);
}
function google($texte) {
$texte = sprintf("%04.4d",$texte);
return $texte;
}
function fdate($date, $heure=0) {
if ($heure != "0") { $heure = substr($date, 11, 5); }
if ($heure == "00:00") { $heure=0; }
$tab_month = array(1=>"janvier", "février", "mars", "avril", "mai", "juin", "juillet", "août", "septembre", "octobre", "novembre", "décembre");
$tab_day = array("dimanche", "lundi", "mardi", "mercredi", "jeudi", "vendredi", "samedi");
$tab_date = explode(' ', $date);
$tab_dmy = explode('-', $tab_date[0]);
$day = date("w", mktime(0, 0, 0, $tab_dmy[1], $tab_dmy[2], $tab_dmy[0]));
$date = "$tab_day[$day] " . "$tab_dmy[2] ";
settype($tab_dmy[1], integer);
$date .= $tab_month[$tab_dmy[1]] . " $tab_dmy[0]";
if ($heure != "0") { $date .= " à $heure"; }
return $date;
}
function last_connection($date) {
$date = split(" ", $date);
list($aaaa,$mm,$jj) = explode("-",$date[0]);
$userDate = mktime(0,0,0,$mm,$jj,$aaaa);
$userDate2 = time();
return abs(intval( ($userDate - $userDate2) / (86400) ));
}
function calcul_age($nais) {
if(@ereg("/",$nais)) {
$nais=explode("/",$nais);
$nais1=$nais[0];
$nais2=$nais[1];
$nais3=$nais[2];
}
if($nais1<=31 && $nais2<=12 && $nais3>1900) {
$date = date("d");
$mois = date("m");
$jahre = date("Y")-$nais3;
if($mois>=$nais2) { $monat=$mois-$nais2; }
if($mois<$nais2) { $monat=(12-$nais2)+$mois; $jahre-=1; }
if($date<$nais1) {
$jahre-=1;
$monat=(12-$nais2)+$mois;
if($mois<$nais2) { $jahre++; $monat-=1; }
}
if($monat>=13) { $jahre++; $monat-=13; }
if($monat==12) { $monat=11; }
if($date>=$nais1){ $tag=$nais1-$date; } else { $tag=$date+(31-$nais1);
if(($mois/2)==Math.round($mois/2)) { $tag++; }
}
if($tag<0) $tag*=-1;;
$retour=array();
$retour[0]=$jahre; //age en années
$retour[1]=$monat; //age en mois
$retour[2]=$tag; //age en jours
if($nais1==$date && $nais2==$mois) $retour[3]="Joyeux anniversaire !";
} else{ $retour[0]=""; }
return $retour;
}
function affiche_date($date1,$h='') {
$jour = substr($date1, 8, 2);
$mois = substr($date1, 5, 2);
$annee = substr($date1, 0, 4); // année, 4 chiffres (ex: 2002)
$annee2 = substr($date1, 2, 2); // année, 2 chiffres (ex: 02)
$heure = substr($date1, 11, 5);
$date1 = $jour.'/'.$mois.'/'.$annee2;
if ($h=="") { $date1 .= ' à '.$heure; }
return $date1;
}
function navigation($niveau,$portail,$rubrique='',$page='') {
if ($niveau==1) { ?>
selected } else { ?>value="http://www.mixs.fr/sommaire.php" } ?>>mixs portail
selected } else { ?>value="http://www.mixs.fr/mag/" } ?>>mixs mag
selected } else { ?>value="http://www.mixs.fr/accounts/" } ?>>mixs accounts
} elseif ($niveau==2) {
if ($portail=="portail") { ?>
selected } ?> value="http://www.mixs.fr/actualite/">actualité
selected } ?> value="http://www.mixs.fr/cinema/">cinéma
selected } ?> value="http://www.mixs.fr/livres/">livres
selected } ?> value="http://www.mixs.fr/multimedia/">multimédia
selected } ?> value="http://www.mixs.fr/musique/">musique
selected } ?> value="http://www.mixs.fr/sante/">santé
selected } ?> value="http://www.mixs.fr/television/">télévision
selected } ?> value="http://www.mixs.fr/blagues/">blagues
selected } ?> value="http://www.mixs.fr/citations/">citations
selected } ?> value="http://www.mixs.fr/concours/">concours
selected } ?> value="http://www.mixs.fr/guide/">directory
selected } ?> value="http://www.mixs.fr/e-cartes/">e-cartes
selected } ?> value="http://www.mixs.fr/forum/">forum
selected } ?> value="http://www.mixs.fr/friends/">friends
selected } ?> value="http://www.mixs.fr/horoscope/">horoscope
selected } ?> value="http://www.mixs.fr/jeux-online/">jeux online
selected } ?> value="http://www.mixs.fr/meteo/">météo
selected } ?> value="http://www.mixs.fr/mail/">mixs mail
selected } ?> value="http://www.mixs.fr/mixstv/">mixs tv
selected } ?> value="http://mixs.sonnerie.net">mobile
selected } ?> value="http://www.mixs.fr/pixs/">pixs
selected } ?> value="http://www.mixs.fr/tests/">tests
}}}
function accounts($type,$page='') {
global $prenom_connecte, $nom_connecte, $mysqlconnect,$id_connecte;
if($type=="menu_gauche") {
$query_messages = "SELECT * FROM messages_prives WHERE statut_dest='1' AND id_dest='".$id_connecte."'";
$result_messages = mysql_query($query_messages,$mysqlconnect);
$nb_messages = mysql_num_rows($result_messages);
?>
}
}
function footer($background='EFEAD6',$color='CEBF84') {
global $mysqlconnect;
$query_visiteurs = "SELECT * FROM nb_connectes";
$result_visiteurs = mysql_query($query_visiteurs,$mysqlconnect);
$nb_visiteurs = mysql_num_rows($result_visiteurs);
?>
}
function html($type) {
global $msg_inscription_newsletter, $vote_save, $mysqlconnect, $connecte, $id_connecte, $pseudo_connecte, $email_connecte, $mdp_connecte, $etoiles_connecte, $avatar_connecte, $search, $voter, $rep_sondage;
if($type=="mymixs") {
?>
html(spotlight); ?>
} elseif ($type=="meta") { ?>
} elseif ($type=="pub_468_60") { ?>
} elseif ($type=="pub_250_250") { ?>
} elseif ($type=="pub_120_240") { ?>
} elseif ($type=="pixs") { ?>
//$mysqlquery = "SELECT t.*, t.somme_notes/t.nb_notes as moyenne FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='F' AND t.statut='1' ORDER BY moyenne DESC LIMIT 0,1";
$mysqlquery = "SELECT t.* FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='F' AND t.statut='1' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
$row=mysql_fetch_row($mysqlresult);
$id_membre=$row[0];
$id_photo=$row[1];
$date_ajout=$row[2];
$somme_notes=$row[3];
$nb_notes=$row[4];
$statut=$row[5];
$moyenne = $somme_notes / $nb_notes;
$moyenne = arrondi($moyenne,1);
$mysqlquery5 = "SELECT * FROM album_photos WHERE id_membre='".$id_membre."' AND id_photo='".$id_photo."'";
$mysqlresult5 = mysql_query($mysqlquery5,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult5);
$photo=$row[2];
$mysqlquery16 = "SELECT * FROM membres WHERE id='$id_membre'";
$mysqlresult16 = mysql_query($mysqlquery16,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult16);
$pseudo_membre=$row[1];
?>
= $moyenne; ?>/10
} ?>
//$mysqlquery = "SELECT t.*, t.somme_notes/t.nb_notes as moyenne FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='H' AND t.statut='1' ORDER BY moyenne DESC LIMIT 0,1";
$mysqlquery = "SELECT t.* FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='H' AND t.statut='1' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
$row=mysql_fetch_row($mysqlresult);
$id_membre=$row[0];
$id_photo=$row[1];
$date_ajout=$row[2];
$somme_notes=$row[3];
$nb_notes=$row[4];
$statut=$row[5];
$moyenne = $somme_notes / $nb_notes;
$moyenne = arrondi($moyenne,1);
$mysqlquery5 = "SELECT * FROM album_photos WHERE id_membre='".$id_membre."' AND id_photo='".$id_photo."'";
$mysqlresult5 = mysql_query($mysqlquery5,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult5);
$photo=$row[2];
$mysqlquery16 = "SELECT * FROM membres WHERE id='$id_membre'";
$mysqlresult16 = mysql_query($mysqlquery16,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult16);
$pseudo_membre=$row[1];
?>
= $moyenne; ?>/10
} ?>
$mysqlquery = "SELECT * FROM pictures WHERE statut='1' AND taille!='1' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult);
$id_img=$row[0];
$id_galerie=$row[1];
$copyright_img=$row[2];
$date_img=$row[3];
$id_posteur_img=$row[4];
$url_img=$row[5];
$taille_img=$row[6];
?>
0) { echo "-";
while ($row=mysql_fetch_row($mysqlresult1)) {
$id_tag=$row[0];
$nom_tag=$row[2];
echo urls($nom_tag);
if ($i!=mysql_num_rows($mysqlresult1)) { ?>- } $i++; }} ?>.html">
galerie d'images | tronches
} elseif ($type=="gauche_mag") { ?>
$mysqlquery = "SELECT url_news,title_news FROM actualites ORDER BY date_news DESC LIMIT 0,5";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row4=mysql_fetch_row($mysqlresult)) {
$url_news = $row4[0];
$title_news = $row4[1];
?> · = $title_news; ?>
}} else { echo "Le flux est en cours de mise à jour."; } ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='1' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='2' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='3' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='4' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='5' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='6' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
$mysqlquery = "SELECT * FROM mag_articles WHERE id_rubrique='7' AND statut='1' ORDER BY date DESC LIMIT 0,3";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row=mysql_fetch_row($mysqlresult)) {
$id_article=$row[0];
$titre_article=$row[3];
?> · = $titre_article; ?>
}} ?>
écrire un article
} elseif ($type=="search") { ?>
} elseif ($type=="xiti") { ?>
} elseif ($type=="actualite") { ?>
$mysqlquery = "SELECT url_news,title_news FROM actualites ORDER BY date_news DESC LIMIT 0,7";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row4=mysql_fetch_row($mysqlresult)) {
$url_news = $row4[0];
$title_news = $row4[1];
?> · = $title_news; ?>
}} else { echo "Le flux est en cours de mise à jour."; } ?>
afficher toute l'actualité
} elseif ($type=="spotlight") { ?>
} elseif ($type=="header") {
$query_messages = "SELECT * FROM messages_prives WHERE statut_dest='1' AND id_dest='".$id_connecte."'";
$result_messages = mysql_query($query_messages,$mysqlconnect);
$nb_messages = mysql_num_rows($result_messages);
?>
if(defined('mag')) { ?>
} else { ?>
dédicaces [ajoute la tienne! ] -
$i="1";
$mysqlquery = "SELECT * FROM `dedicaces` ORDER BY date DESC LIMIT 0,15";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row= mysql_fetch_row($mysqlresult)) {
$nom = encoder($row[1]);
$id_membre = $row[3];
$texte = encoder($row[4]);
if($id_membre) {
$mysqlquery2 = "SELECT * FROM membres WHERE id='$id_membre'";
$mysqlresult2 = mysql_query($mysqlquery2,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult2);
$nom=$row[1];
}
?> if ($id_membre!="0") { ?> } ?>= ucfirst($nom); ?> if ($id_membre!="0") { ?> } else { ?> (invité) } ?> : = $texte; ?> if (mysql_num_rows($mysqlresult) >= $i+1) { ?> - } $i++; }} ?>
}} elseif ($type=="forum") { ?>
} elseif ($type=="paroles") { ?>
$i="1";
$mysqlquery_paroles = "SELECT id,id_artiste,titre,sonnerie_hifi FROM paroles ORDER BY date_ajout DESC LIMIT 0,10";
$mysqlresult_paroles = mysql_query($mysqlquery_paroles,$mysqlconnect);
while ($row=mysql_fetch_row($mysqlresult_paroles)) {
$id_paroles=$row[0];
$id_artiste=$row[1];
$titre_paroles=$row[2];
$url_sonnerie_hifi=$row[3];
$mysqlquery3 = "SELECT nom FROM paroles_artistes WHERE id='$id_artiste'";
$mysqlresult3 = mysql_query($mysqlquery3,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult3);
$nom_artiste=$row[0];
$Caracs = array("¥" => "Y", "µ" => "u", "À" => "A", "Á" => "A",
"Â" => "A", "Ã" => "A", "Ä" => "A", "Å" => "A",
"Æ" => "A", "Ç" => "C", "È" => "E", "É" => "E",
"Ê" => "E", "Ë" => "E", "Ì" => "I", "Í" => "I",
"Î" => "I", "Ï" => "I", "Ð" => "D", "Ñ" => "N",
"Ò" => "O", "Ó" => "O", "Ô" => "O", "Õ" => "O",
"Ö" => "O", "Ø" => "O", "Ù" => "U", "Ú" => "U",
"Û" => "U", "Ü" => "U", "Ý" => "Y", "ß" => "s",
"à" => "a", "á" => "a", "â" => "a", "ã" => "a",
"ä" => "a", "å" => "a", "æ" => "a", "ç" => "c",
"è" => "e", "é" => "e", "ê" => "e", "ë" => "e",
"ì" => "i", "í" => "i", "î" => "i", "ï" => "i",
"ð" => "o", "ñ" => "n", "ò" => "o", "ó" => "o",
"ô" => "o", "õ" => "o", "ö" => "o", "ø" => "o",
"ù" => "u", "ú" => "u", "û" => "u", "ü" => "u",
"ý" => "y", "ÿ" => "y");
$url_sonnerie_hifi = strtr($url_sonnerie_hifi, $Caracs);
?>
bgcolor="#EBEBF5" } ?>>= $nom_artiste; ?> - = $titre_paroles; ?> if ($url_sonnerie_hifi!="") { ?> } ?>
$i++; if ($i=="3") { $i="1"; } } ?>
toutes les paroles | proposer
} elseif ($type=="sondages") { ?>
$mysqlquery1 = "SELECT * FROM sondages_sondages WHERE id_rubrique='0' ORDER BY date_ajout DESC LIMIT 0,1";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
if(mysql_num_rows($mysqlresult1) > 0) {
$row=mysql_fetch_row($mysqlresult1);
$id_sondage=$row[0];
$date_ajout=$row[1];
$question=$row[2];
$nb_total_reponses_sondage = "SELECT SUM(nb_votes) AS total FROM sondages_reponses WHERE id_sondage='".$id_sondage."'";
$nb_total_reponses_sondage = mysql_query($nb_total_reponses_sondage,$mysqlconnect);
$data = mysql_fetch_array($nb_total_reponses_sondage);
$nb_total_reponses_sondage = $data['total'];
$vote_permis = "oui";
if ($vote_save==$id_sondage) { $vote_permis = "non"; }
if ($_COOKIE["sondage_".$id_sondage]) { $vote_permis = "non"; }
?>
résultats | archives
} else {
$mysqlquery1 = "SELECT * FROM sondages_reponses WHERE id_sondage='".$id_sondage."' ORDER BY id_reponse ASC";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
if(mysql_num_rows($mysqlresult1) > 0) {
while ($row=mysql_fetch_row($mysqlresult1)) {
$id_reponse=$row[0];
$id_sondage=$row[1];
$reponse=$row[2];
$nb_votes=$row[3];
$pourcent_rep = round($nb_votes * 100 / $nb_total_reponses_sondage, 1);
?>
= $reponse; ?>
= $pourcent_rep; ?> %
$i++; }} ?>
archives | commentaires (= nb_commentaires("sondage-".$id_sondage); ?>)
}} else { echo "erreur"; } ?>
}} ?>