if ($Parent==0) // insertion d'un sujet
{
$sujetformat = mb_strimwidth($sujet, 0, 20, " ...");
$query = $sql->query("INSERT INTO ".$_PRE."topics (idforum,sujet,date,nbrep,nbvues,datederrep,derposter,icone,idmembre,pseudo,poll) VALUES ('$ForumID','$sujet','$date',0,0,'$date','$pseudo','$_POST[icon]', '$idmembre','$pseudo','$idpoll')");
$topicid = mysql_insert_id();
$query = $sql->query("INSERT INTO ".$_PRE."posts (idforum,sujet,date,parent,msg,icone,idmembre,pseudo,postip,smiles,bbcode,notifyme) VALUES ('$ForumID','$sujet','$date','$topicid','$msg','$_POST[icon]','$idmembre','$pseudo','$_SERVER[REMOTE_ADDR]','$smiles','$nobb','$notifyme')");
$idderpost = mysql_insert_id();
$query = $sql->query("UPDATE ".$_PRE."forums SET lastforumposter='$pseudo',lastdatepost='$date',lastidpost='$idderpost',forumtopic=forumtopic+1, lastposttitle='$sujet',lastposticon='$_POST[icon]' WHERE forumid='$ForumID'");
$query = $sql->query("UPDATE ".$_PRE."topics SET idderpost='$idderpost' WHERE idtopic='$topicid'");
updatenbtopics();
}
else
{
$query = $sql->query("INSERT INTO ".$_PRE."posts (idforum,sujet,date,parent,msg,icone,idmembre,pseudo,postip,smiles,bbcode,notifyme) VALUES ('$ForumID','$sujet','$date','$Parent','$msg','$_POST[icon]','$idmembre','$pseudo','$_SERVER[REMOTE_ADDR]','$smiles','$nobb','$notifyme')");
$idderpost = mysql_insert_id();
$recup = $sql->query("SELECT sujet,icone FROM ".$_PRE."posts WHERE parent='$_POST[parent]' ORDER BY idpost LIMIT 1");
$Infofirstpost = mysql_fetch_array($recup);
$query = $sql->query("UPDATE ".$_PRE."topics SET datederrep='$date', nbrep=nbrep+1, derposter='$pseudo', idderpost='$idderpost' WHERE idtopic='$Parent'");
updatenbposts();
if(!$annonce)
$query = $sql->query("UPDATE ".$_PRE."forums SET lastforumposter='$pseudo',lastdatepost='$date',lastidpost='$idderpost',forumposts=forumposts+1,lastposttitle='$Infofirstpost[sujet]', lastposticon='$Infofirstpost[icone]' WHERE forumid='$ForumID'");