include "class.phpmailer.php";
if ($_SERVER['SERVER_ADDR']=="127.0.0.1")
{
// nom de la base
define('MYSQL_BDD', "sri_label");
// adresse du serveur de la BDD
define('MYSQL_HOST', "127.0.0.1");
//login de connexion à la BDD
define('MYSQL_LOGIN', 'root');
define('MYSQL_PASSWORD', '');
}
else
{
// nom de la base
define('MYSQL_BDD', "p685_1");
// adresse du serveur de la BDD
define('MYSQL_HOST', "cl1-sql7");
//login de connexion à la BDD
define('MYSQL_LOGIN', 'p685_1');
define('MYSQL_PASSWORD', 'sakou3moi');
}
mysql_pconnect(MYSQL_HOST,MYSQL_LOGIN,MYSQL_PASSWORD) or die("erreur de connexion au serveur");
mysql_select_db(MYSQL_BDD) or die("erreur de connexion a la base de donnees");
function remote_file_exists ($url)
{
/*
Return error codes:
1 = Invalid URL host
2 = Unable to connect to remote host
*/
$head = "";
$url_p = parse_url ($url);
if (isset ($url_p["host"]))
{ $host = $url_p["host"]; }
else
{ return 1; }
if (isset ($url_p["path"]))
{ $path = $url_p["path"]; }
else
{ $path = ""; }
$fp = fsockopen ($host, 80, $errno, $errstr, 20);
if (!$fp)
{ return 2; }
else
{
$parse = parse_url($url);
$host = $parse['host'];
fputs($fp, "HEAD ".$url." HTTP/1.1\r\n" );
fputs($fp, "HOST: ".$host."\r\n" );
fputs($fp, "Connection: close\r\n\r\n" );
$headers = "";
while (!feof ($fp))
{ $headers .= fgets ($fp, 128); }
}
fclose ($fp);
$arr_headers = explode("\n", $headers);
$return = false;
if (isset ($arr_headers[0]))
{ $return = strpos ($arr_headers[0], "404" ) === false; }
return $return;
}
$maildepart="contact@sport-consultant.fr";
$mailclienth="contact@sport-consultant.fr";
$clienth="SRI Sport Consultant";
/*
CLUBS = contact@sport-consultant.fr
LIGUES = contact@sport-consultant.com
FEDERATIONS = contact@sport-consultant.eu
OMS = contact@sport-consultant.net
COLLECTIVITES = contact@sport-consultant.org
REUNION = srimetz@sport-consultant.re
RESEAU 3S (ex LABEL)= contact@sport-social.fr
*/
$type_nl=array (
0 => "Club",
1 => "Ligue",
2 => "Fédération",
3 => "Club labélisé",
4 => "OMS",
5 => "Collectivité",
6 => "Réunion",
);
function urltype($url)
{
switch ($url)
{
case 'www.sport-consultant.fr':
return 0;
break;
case 'www.sport-consultant.com':
return 1;
break;
case 'www.sport-consultant.eu':
return 2;
break;
case 'www.sport-consultant.net':
return 4;
break;
case 'www.sport-consultant.org':
return 5;
break;
case 'www.sport-consultant.re':
return 6;
break;
case 'www.sport-social.fr':
return 3;
break;
/*case 'localhost':
return 0;
break;*/
}
}
$urlsite="www.sport-social.fr";
//echo $_SERVER['HTTP_HOST'];
$nbenvoiparclic=95;
$type=urltype($_SERVER['HTTP_HOST']);
$rn="SELECT * FROM sri_nl_envoicron WHERE IDtype='".$type."'";
$rnx=mysql_query($rn);
if (mysql_num_rows($rnx)==0)//si il n'y a pas d'entrée pour le type voulu, on l'ajoute
{
$rinsert="INSERT INTO sri_nl_envoicron(IDtype,Encours) VALUES ('".$type."',1)";
mysql_query($rinsert);
}
//echo 'avant le fetch array '.$n['Encours'].'
';
$rnx=mysql_query($rn);
$n=mysql_fetch_array($rnx);
//echo 'après le fetch array '.$n['Encours'].'
';
if ($n['Encours']==1)
{
$rl="SELECT * FROM sri_nl_envoi WHERE Type='".$type."' ORDER BY ID DESC";
$rlx=mysql_query($rl);
$l=mysql_fetch_array($rlx);
if (isset($l['Paquet']))
{
$pack=$l['Paquet']-1;
}
else
{
$pack=1;
}
//si arrivé au bout, on repasse le pack à 1
$rs="SELECT * FROM sri_newsletter WHERE IDtype='".$type."' GROUP BY Mail";
$rsx=mysql_query($rs);
$snombre=mysql_num_rows($rsx);
if ((($pack-1)*$nbenvoiparclic)>$snombre)
$pack=1;
// si le paquet est différent de 1 alors on passe au paquet suivant et on envoie
$rs="SELECT * FROM sri_newsletter WHERE IDtype='".$type."' GROUP BY Mail";
$depart=$nbenvoiparclic*($pack-1);
$rs.=" LIMIT $depart,$nbenvoiparclic";
//echo $rs;
$rsx=mysql_query($rs);
$snombre=mysql_num_rows($rsx);
// --------------------- création des pubs hautes, édito, encarts **************
$textenl='