function mise_en_html(&$expression)
{
//echo "IN".$expression;
$expression = str_replace("?",'',$expression);
$expression = str_replace(" ",'_',$expression);
$expression = str_replace("é",'e',$expression);
$expression = str_replace("è",'e',$expression);
$expression = str_replace("&",'&',$expression);
$expression = str_replace("-",'_',$expression);
$expression = str_replace("#",'',$expression);
//$expression = htmlspecialchars ($expression ,ENT_NOQUOTES);
//echo "
OUT".$expression."
";
}
include ("phpBB3/Vsession.php");
include "kphobos/vs.php";
include ("constantes.php");
?>
$dbhost = 'localhost';
$dblogi = 'vs';
$dbbase = 'vs';
$dbi = mysql_connect($dbhost, $dblogi, $dbpass);
mysql_select_db($dbbase,$dbi);
//PARTIE 1 des chroniques !!!
$reqde = MYSQL_QUERY("SELECT * FROM MyKronikInfos WHERE id='$id_news' and valider!='X'");
$i=0;
$id = mysql_result($reqde,$i,"id");
$idkro = $id;
$titre = stripslashes(trim(mysql_result($reqde,$i,"titre")));
$date = mysql_result($reqde,$i,"date");
$heure = mysql_result($reqde,$i,"heure");
$signature = stripslashes(trim(mysql_result($reqde,$i,"signature")));
$email_sign = mysql_result($reqde,$i,"email_sign");
$news = (stripslashes(trim(mysql_result($reqde,$i,"news"))));
$heure = str_replace(":","h",$heure);
$source = mysql_result($reqde,$i,"source");
$nom_source = mysql_result($reqde,$i,"nom_source");
$stopcom = mysql_result($reqde,$i,"url_source");
$image = mysql_result($reqde,$i,"image");
$path_image = trim(mysql_result($reqde,$i,"path_image"));
$mp3 = trim(mysql_result($reqde,$i,"mp3"));
$cptmp3 = mysql_result($reqde,$i,"cptmp3");
$path_mp3 = trim(mysql_result($reqde,$i,"path_mp3"));
$cptlink = mysql_result($reqde,$i,"cptlink");
$path_website = trim(mysql_result($reqde,$i,"path_website"));
$selection = mysql_result($reqde,$i,"selection");
$id_link1 = mysql_result($reqde,$i,"id_link1");
$id_link2 = mysql_result($reqde,$i,"id_link2");
$id_link3 = mysql_result($reqde,$i,"id_link3");
$label_name = mysql_result($reqde,$i,"label_name");
$band_name = mysql_result($reqde,$i,"band_name");
$SOURCE = " $nom_source ";
if ($selection == 'OUI') {
$selection= "Selection VS du ";
$vsicon = "";
}
else
{ $selection = '';
}
$cpt = mysql_result($reqde,$i,"cpt");
$cpt = $cpt + 1;
$news = preg_replace("@([[:alnum:]]+)://([^[:space:]]*)([[:alnum:]#?/&=])@","\\1://\\2\\3",$news);
$IMAGE = "
";
$SQLcpt = "Update MyKronikInfos SET cpt='$cpt' WHERE id='$id'";
$reqcpt = MYSQL_QUERY($SQLcpt);
//$SOURCE = " $SourceTitle $nom_source ";
//
mysql_free_result($reqde);
?>
"; if ($stopcom != "STOP") { //include("kkajouter-com.php"); ?> } else { echo "Impossible d'ajouter un commentaire"; } //------------------ Debut banniere pub bas de page $sql = "select banner_id, banner_url, banner_name from phpbb_banner where banner_active =\"1\" and banner_spot !='1'"; $reszzz = mysql_query($sql,$dbi); $NbBan = mysql_num_rows($reszzz); if ($NbBan) { // Si campagnes en cours srand(time()); rand(); $BanIndex=intval($NbBan*rand()/getrandmax()); $succ=mysql_data_seek($reszzz,$BanIndex); $row=mysql_fetch_row($reszzz); echo " "; $sql="UPDATE phpbb_banner SET banner_view = banner_view + 1 where banner_id = $row[0]"; mysql_query($sql,$dbi); } else { // C'est la banniere à afficher si toutes les campagnes // publicitaires sont épuisées echo ""; } mysql_free_result($reszzz); //------------------ FIN banniere pub bas de page ?> |