if ($_POST[parent]==0)
{
$sujetformat = mb_strimwidth($sujet, 0, 20, " ...");
$result = mysql_query("INSERT INTO CF_posts (idforum,sujet,date,parent,msg,nbrep,nbvues,datederrep,derposter,icone,idmembre,postip,smiles,bbcode,poll) VALUES ('$_POST[forumid]','$sujet','$date','$_POST[parent]','$msg',0,0,'$date','$pseudo','$_POST[icon]', '$idmembre','$_SERVER[REMOTE_ADDR]','$smiles','$nobb','$idpoll')");
$idderpost=mysql_insert_id();
$query = mysql_query("UPDATE CF_posts SET idderpost='$idderpost',idmembrelasttopic='$idmembre' WHERE idpost='$idderpost'");
$query=mysql_query("UPDATE CF_forums SET lastforumposter='$pseudo',lastdatepost='$date',lastidpost='$idderpost',idmembrelastposter='$idmembre',forumtopic=forumtopic+1, lastposttitle='$sujetformat', lastposticon='$_POST[icon]' WHERE forumid='$_POST[forumid]'");
}
else
{
$query = mysql_query("INSERT INTO CF_posts (idforum,sujet,date,parent,msg,icone,idmembre,postip,smiles,bbcode) VALUES ('$_POST[forumid]','$sujet','$date','$_POST[parent]','$msg','$_POST[icon]','$idmembre','$_SERVER[REMOTE_ADDR]','$smiles','$nobb')");
$idderpost=mysql_insert_id();
//Recup sujet + icon du topic actualisé
$recup = mysql_query("SELECT sujet,icone FROM CF_posts WHERE idpost='$_POST[parent]'");
$Infofirstpost = mysql_fetch_array($recup);
//
$query = mysql_query("UPDATE CF_posts SET datederrep='$date', nbrep=nbrep+1, derposter='$pseudo', idderpost='$idderpost', idmembrelasttopic='$idmembre' WHERE idpost='$_POST[parent]'");
if(!$annonce)
$query=mysql_query("UPDATE CF_forums SET lastforumposter='$pseudo',lastdatepost='$date', lastidpost='$idderpost', idmembrelastposter='$idmembre', forumposts=forumposts+1, lastposttitle='$Infofirstpost[sujet]', lastposticon='$Infofirstpost[icone]' WHERE forumid='$_POST[forumid]'");