<?
session_start();
$session = session_id();
//include('f/fxml.php5');
include('class/mysql.class.php5');

/*function date_convert($Date)
{
	$Temp_date = explode("-",$Date);
	$New_date = "$Temp_date[2]/$Temp_date[1]/$Temp_date[0]";
	return $New_date;
}


*/

    //Version avec argument passé par valeur
     function stripHTMLtags($texte){
     //On retire le code HTML
     $mots = explode("<",$texte);
     $texte = "";
     $nbmots = count($mots);
    
     for ($m = 0; $m < $nbmots; $m++)
     {
     $mot = $mots[$m];
     $finbalise = strpos($mot,">",0);
     if ($finbalise > 0) { $mot = substr($mot,$finbalise+1); }
     $texte .= "$mot";
     }
    
     return $texte;
     }
    
     //Version avec argument passé par référence
     function stripHTMLtags_byref(&$texte){
     //On retire le code HTML
     $mots = explode("<",$texte);
     $texte = "";
     $nbmots = count($mots);
    
     for ($m = 0; $m < $nbmots; $m++)
     {
     $mot = $mots[$m];
     $finbalise = strpos($mot,">",0);
     if ($finbalise > 0) { $mot = substr($mot,$finbalise+1); }
     $texte .= "$mot";
     }
     }


function addDesc($page){
	
$mysql = new mysql;
$mysql->connect('');
	//////////////////////////////////
	// IF ARTISTE
	if($_GET['rep'] == 'artistes'){
		$dj = str_replace('-',' ',$_GET['nompage']);
		$mysql->requete('SELECT * FROM `staff` WHERE active = "1" AND nom LIKE "%'.$dj.'%" ORDER BY id_staff ASC',1);
		$r1 = $mysql->fetch_row(1);
		echo stripHTMLtags($r1['bio_fr']);
	}
	//////////////////////////////////
	// IF PRODUIT
	if($_GET['catalogue'] != '' && $_GET['rep'] == 'shop' && $_GET['id_produit'] != ''){
		$mysql->requete('SELECT * FROM `shop_articles` WHERE id_produit = "' . $_GET['id_produit'] . '"',1);
		$r1 = $mysql->fetch_row(1);
		$mysql->requete('SELECT * FROM `shop_catalogue` WHERE id_catalogue = "' . $_GET['id_catalogue'] . '"',2);
		$r2 = $mysql->fetch_row(2);
		echo stripHTMLtags($r1['commentaire'] . ' [ '. round($r1['prix'],2) .'Eur. ]');
	}
	//////////////////////////////////
	// IF NEWS
	if($_GET['rep'] == 'news'){
		$mysql->requete('SELECT * FROM `news` WHERE id_news = "' . $_GET['id_news'] . '" AND active = "1"',1);
		$r1 = $mysql->fetch_row(1);
		echo stripHTMLtags($r1['infos']);
	}
	//////////////////////////////////
	// IF MAILING
	if($_GET['rep'] == 'news' && $_GET['id'] != ''){
		$mysql->requete('SELECT * FROM `newsletter_envoi` WHERE id_newsletter="'.$_GET['id'].'"',1);
		$r1 = $mysql->fetch_row(1);
		echo stripHTMLtags($r1['fr']);
	}
	//////////////////////////////////
	// IF LABEL
	if($_GET['rep'] == 'label'){
		$mysql->requete('SELECT * FROM `ebrec`',1);
			$r1 = $mysql->fetch_row(1);
		echo stripHTMLtags($r1['texte']);
	}
	//////////////////////////////////
	// DESCRIPTION DUNE FICHE CLUB TOUR
	if($_GET['cat'] == 'club-tour' && $_GET['etat'] != 'details'){
		$mysql->requete('SELECT * FROM `type` WHERE id_type = "' . $_GET['id_type'] . '"',1);
		$r1 = $mysql->fetch_row(1);
		$mysql->requete('SELECT * FROM `agenda` WHERE id_type="'.$r1['id_type'].'" ORDER BY date ASC',2);
		if($mysql->nbre_lignes(2) > 0){
			while($r2 = $mysql->fetch_row(2)){
				$mysql->requete('SELECT * FROM `club` WHERE id_club="'.$r2['id_club'].'"',4);
				$r4 = $mysql->fetch_row(4);
				$mysql->requete('SELECT * FROM `pays` WHERE id_pays ="'.$r4['id_pays'].'"',5);
				$r5 = $mysql->fetch_row(5);
				$agenda .= utf8_encode(ConvertDate($r2['date'])).' @ '.$r4['nom'].' // ';
			}
		}
		echo $agenda;
	}
	//////////////////////////////////
	// DESCRIPTION DUNE FICHE SOIREE AUTRE - ATTENTION A REVERIFIER !!
	if($_GET['rep'] == 'evenements' && $_GET['cat'] != 'club-tour' && $_GET['etat'] != 'details'){
		$mysql->requete('SELECT * FROM `type` WHERE id_type = "' . $_GET['id_type'] . '"',1);
		$r1 = $mysql->fetch_row(1);
		$mysql->requete('SELECT * FROM `agenda` WHERE id_type="'.$r1['id_type'].'" ORDER BY date ASC',2);
		$r2 = $mysql->fetch_row(2);
		$mysql->requete('SELECT * FROM `type` WHERE id_type="'.$r1['id_type'].'"',30);
		$r30 = $mysql->fetch_row(30);
		$mysql->requete('SELECT * FROM `club` WHERE id_club="'.$r2['id_club'].'"',4);
		$r4 = $mysql->fetch_row(4);
		$mysql->requete('SELECT * FROM `type_info` WHERE id_type="'.$r1['id_type'].'"',5);
		$r5 = $mysql->fetch_row(5);
		$infos .= ConvertDate($r2['date']).' - '.$r4['nom'].' - '.$r5['info'];
		
		echo str_replace('"','',$infos) .' // Line Up : '. utf8_encode(str_replace('<br>',' / ',$r5['dj']));
	}
	else if ($_GET['rep'] == 'accueil' || ($_GET['rep'] == 'shop' && $_GET['id_produit'] == '') || $_GET['rep'] == 'contact' || $_GET['rep'] == 'evenements') {
		$mysql->requete('SELECT * FROM `meta`',11);
		$r11 = $mysql->fetch_row(11);
		echo stripHTMLtags(str_replace('"','',$r11['description']));
	}
}


function redirection($page)
{
	echo '<script language="JavaScript">document.location.replace("' . $page . '");</script>';
}


function ConvertDate($value) {
		// JOURS
		$jours = array('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi');
		$jours_numero = date('w', $value);
		$jours_complet = $jours[$jours_numero];
		// Numero du jour
		$NumeroDuJour = date('d', $value);
				
		// MOIS
		$mois = array('', 'Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Décembre');
		$mois_numero = date("n", $value);
		$mois_complet = $mois[$mois_numero];
		
		// ANNEE
		$annee = date("Y", $value);
		
		// DATE FULL
		return $jours_complet .' '. $NumeroDuJour .' '. $mois_complet .' '. $annee;
}

function Cutxt($texte, $longeur_max)
					{
						if (strlen($texte) > $longeur_max) 
						{ 
						$texte = substr($texte, 0, $longeur_max); 
						$dernier_espace = strrpos($texte, ""); 
						$texte = substr($texte, 0, $dernier_espace)."..."; 
						} 
					
						return $texte;
					}

//fonction encode
  /*function encode($pass_str)
   {
   $pass_coder = mcrypt_ecb(MCRYPT_TripleDES, "3t3rn4lbl1ss", $pass_str, MCRYPT_ENCRYPT);
   return $pass_coder;
   }

   //fonction decode
   function decode($pass_coder)
   {
   $pass_str = mcrypt_ecb(MCRYPT_TripleDES, "3t3rn4lbl1ss", $pass_coder, MCRYPT_DECRYPT);
   return $pass_str;
   }*/
   
   
   function decode($str)
{
  /* $filter = "eb";
   $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 $str;
}

function encode($str)
{
   /*$filter = "eb";
   $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($str);
}

function ConvertChar($value) {
	$replace = Array ("","","","","","","","","","","","","","","","","","z","Y;","i","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","A","A","A","A","A","A","A","C","E","E","E","E","l","l","l","l","","N","O","O","O","O","O","","O","U","U","U","U","Y","","b","a","a","a","a","a","a","o","c","e","e","e","e","i","i","i","i","","n","o","o","o","o","o","","","u","u","u","u","y","","y","a","","","","","");

	$search = Array ("&","<",">","^","‘","’","“","”","•","–","—","˜","™","š","›","œ","","ž","Ÿ","¡","¢","£","¤","¥","¦","§","¨","©","ª","«","¬","­","®","¯","°","‘","²","³","´","µ","¶","·","¸","¹","º","»","¼","½","¾","¿","À","Á","Â","Ã","Ä","Å","Æ","Ç","È","É","Ê","Ë","Ì","Í","Î","Ï","Ð","Ñ","Ò","Ó","Ô","Õ","Ö","×","Ø","Ù","Ú","Û","Ü","Ý","Þ","ß","à","á","â","ã","ä","å","æ","ç","è","é","ê","ë","ì","í","î","ï","ð","ñ","ò","ó","ô","õ","ö","÷","ø","ù","ú","û","ü","ý","þ","ÿ","@","'","\""," ","/","#");
	
	return str_replace($search, $replace, $value);
}
function MiniConvertChar($value) {
	$replace = Array ("","","","","","","","","","","","","","","","","","z","Y;","i","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","A","A","A","A","A","A","A","C","E","E","E","E","l","l","l","l","","N","O","O","O","O","O","","O","U","U","U","U","Y","","b","a","a","a","a","a","a","o","c","e","e","e","e","i","i","i","i","","n","o","o","o","o","o","","","u","u","u","u","y","","y","a","","","-","","","");

	$search = Array ("&","<",">","^","‘","’","“","”","•","–","—","˜","™","š","›","œ","","ž","Ÿ","¡","¢","£","¤","¥","¦","§","¨","©","ª","«","¬","­","®","¯","°","‘","²","³","´","µ","¶","·","¸","¹","º","»","¼","½","¾","¿","À","Á","Â","Ã","Ä","Å","Æ","Ç","È","É","Ê","Ë","Ì","Í","Î","Ï","Ð","Ñ","Ò","Ó","Ô","Õ","Ö","×","Ø","Ù","Ú","Û","Ü","Ý","Þ","ß","à","á","â","ã","ä","å","æ","ç","è","é","ê","ë","ì","í","î","ï","ð","ñ","ò","ó","ô","õ","ö","÷","ø","ù","ú","û","ü","ý","þ","ÿ","@","'","\""," ","/","%","#");
	
	return str_replace($search, $replace, $value);
}
function dateFr($time) {
	$label_mois = array(1=>"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
	//return $label_mois[$mois];
	return date('d',$time).' '.$label_mois[date('n',$time)].' '.date('Y',$time);
}
function moisFr($mois) {
	$label_mois = array(1=>"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
	return $label_mois[$mois];
	//return date('d',$time).' '.$label_mois[date('n',$time)].' '.date('Y',$time);
}

 function count_files($dir)
     {
             $num = 0;
    
             $dir_handle = opendir($dir);
               while($entry = readdir($dir_handle))
                     if(is_file($dir.'/'.$entry))
                               $num++;
             closedir($dir_handle);
    
             return $num;
     }


function mailing($to, $sujet, $message, $prev=0){
	
$mysql = new mysql;
$mysql->connect('');

$mysql->requete('SELECT * FROM `'.$_GET['bdd'].'`',7);
$total = $mysql->nbre_lignes(7);


$mysql->requete('SELECT * FROM `newsletter_envoi` ORDER by id_newsletter DESC',11);
$r11 = $mysql->fetch_row(11);
$id_news = $r11['id_newsletter'];

$mysql->requete('SELECT * FROM `emailing` WHERE email="'.$to.'"',12);
$r12 = $mysql->fetch_row(12);
$id_emailing = $r12['id_emailing'];

$header_email = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Language" content="fr">
	
	<!-- ########## CSS Files ########## -->	

	<!-- Framework CSS -->
	<link rel="stylesheet" href="http://www.eternalbliss.net/v5/css/kriframework.css" type="text/css" media="screen" />
	<!-- lightbox CSS -->
	<link rel="stylesheet" href="http://www.eternalbliss.net/v5/js/prettyPhoto/css/prettyPhoto.css" type="text/css" media="screen" charset="utf-8" />	
	<!-- Screen CSS -->
	<link rel="stylesheet" href="http://www.eternalbliss.net/v5/css/style.css" type="text/css" media="screen" />	
	
	<!-- Stylesheets for each skin -->
	<link rel="stylesheet" href="http://www.eternalbliss.net/v5/css/style1.css" type="text/css" media="screen" />
    
    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://www.eternalbliss.net/rss.php" />
	
	
	<!-- ########## end css ########## -->	<!-- JAVASCRIPT GOES HERE -->	
	<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.2.js"></script>
    
    
	<script type="text/javascript" src="http://www.eternalbliss.net/v5/js/cufon.js"></script>
	<script type="text/javascript" src="http://www.eternalbliss.net/v5/js/prettyPhoto/js/jquery.prettyPhoto.js"  charset="utf-8"></script>	
	<script type="text/javascript" src="http://www.eternalbliss.net/v5/js/custom.js"></script>
 <script src="http://code.jquery.com/jquery-latest.js-"></script>
    <base href="http://www.eternalbliss.net">

</head>
<body id="top">

	<div class="wrap_fullwidth" id="head">
	
		<div class="center" style="width:800px;">
			<p class="headline" style="font-size:1.5em; letter-spacing:5px; font-weight:bold;">Newsletter #'.$id_news.' du '.dateFr(time()).'</p>
			<span class="headline" style="margin-top:0px;text-align:right;float:right;"><a href="http://www.eternalbliss.fr/news/">www.eternalbliss.fr/news/</a></span>
		</div>
	
	<!-- end header -->
	</div>

	<div class="wrap_fullwidth" id="second_header">
	
		<div class="center" style="width:800px;"> <a href="http://www.eternalbliss.net/" title="Eternal Bliss Productions & Records"><img src="http://www.eternalbliss.net/v5/images/skin1/logo.png" border="0" /></a>
		
			<ul id="nav">
				<li><a href="http://www.eternalbliss.net/v5/">Accueil</a></li>				
				<li><a href="http://www.eternalbliss.net/evenements/tous-les-evenements-eternal-bliss.html">Ev&egrave;nements</a> </li>
				<li><a href="http://www.eternalbliss.net/label/le-label-hard-dance-eternal-bliss-records.html">Label</a></li>
				<li><a href="http://www.eternalbliss.net/artistes/liste/les-djs-producteurs-de-chez-eternal-bliss.html">Artistes</a></li>
				<li><a href="http://www.eternalbliss.net/shop/tous-les-produits-eternal-bliss,1.html">Boutique en ligne</a></li>
				<li><a href="http://www.eternalbliss.net/contact/contactez-eternal-bliss.html">Contact</a></li>
			</ul>
		<!-- end center -->
		</div>
	
	<!-- end second_header -->
	</div>
	<div class="wrap_fullwidth small_margin" id="main">
		
		<div class="center" style="width:800px;">
		
		<div class="content_fullwidth" style="width:800px;">';
		
$footer_email1 ='
				
		<!-- end center -->
		</div>
	
	<!-- end main -->
	</div>
	<div class="wrap_fullwidth" id="breadcrumb_wrap">
	
		<div class="center" style="width:800px;">
		<p class="breadcrumb" style="font-size:1.5em;width:70%;color:#333;"><a href="http://www.eternalbliss.fr" target="_blank">http://www.eternalbliss.fr</a></p>
		
			<ul class="social_bookmarks">
				<li class="rss"><a href="http://www.eternalbliss.net/rss.php" class="" target="_blank">RSS</a></li>
				<li class="facebook"><a href="http://www.facebook.com/EternalBlissEvents" class="" target="_blank">Facebook</a></li>
				<li class="twitter"><a href="http://twitter.com/eternal__bliss" class="" target="_blank">Twitter</a></li>
				<li class="youtube"><a href="http://www.youtube.com/user/eternalblissevents" class="" target="_blank">Youtube Channel</a></li>
			</ul>
		
		<!-- end center -->
		</div>
	
	<!-- end breadcrumb_wrap -->
	</div>
	
	<div class="wrap_fullwidth" id="footer" style="background-color:#333;">
	
		<div class="center" style="width:800px;padding-top:10px;">';
			
	$footer_email2 .= '<!-- end center -->
		</div>
	
	
</body>
</html>';

	$header = "MIME-version: 1.0\n";
	$header .= "Content-type: text/html; charset= iso-8859-1\n";
	$header .= "From: info@eternalbliss.net\n";
	$header .= "Reply-To: no-reply@eternalbliss.net\n";
		
	
	// construction du header mail
	$eflyer = $header_email;
	
	// si en prev, modul d'envoi
	if($prev == 1){
		$eflyer .= '<table width="100%"><tr><td valign="top" align="center"><table width="650" style="background-color: #FFF;margin-top:15px;" class="rounded"><tr><td valign="top" align="center">
		Si le contenu de la mailing vous parait correcte, il suffit de cliquer sur le bouton ci dessous pour l\'envoyer !
<form name="form1" id="form1" method="post" action="">
<input title="Envoyer maintenant la mailing" class=" button" name="Submit" type="submit" value="OUI, Je veux envoyer la mailing maintenant aux ';
		$eflyer .= $total;
		$eflyer .= ' inscrits" />
</form></td></tr></table></td></tr></table>';
	}
	
	$eflyer .= $message;
	$eflyer .= $footer_email1;
	
	// mentions legales
	//if($prev == 1)
		$eflyer .= 'Conform&eacute;ment &agrave; la loi Informatique et Libert&eacute;s du 6/1/1978 (art 27), vous disposez d\'un droit d\'acc&egrave;s et de <a href="http://www.eternalbliss.fr/profil,'.$id_emailing.','.$to.'.html">rectification des donn&eacute;es vous concernant</a>. Si vous ne d&eacute;sirez plus recevoir de messages &eacute;lectroniques de la part d\'Eternal Bliss productions - <a href="http://www.eternalbliss.fr/desinscription,'.$id_emailing.','.$to.'.html">Cliquez ici pour vous d&eacute;sinscrire</a>
<br>';
	
	// fin du mail
	$eflyer .= $footer_email2;
	
	if($prev == 0)
		mail($to, $sujet, $eflyer, $header);
	else
		echo $eflyer;
}
?>