";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "[poster un message]";
$number = 5;
if (!$limit) {
$limit = 0;
}
$path_parts = pathinfo($PHP_SELF);
$page = $path_parts["basename"];
$select = "SELECT count(id) FROM forum_data WHERE Father=1";
$result = mysql_db_query($db, $select);
$row = mysql_fetch_row($result);
$total = $row[0];
$request = mysql_db_query($db, "SELECT * FROM forum_data WHERE Father=1 GROUP BY Date DESC LIMIT $limit, $number");
$nextlimit = $limit + $number;
$previouslimit = $limit - $number;
while ($rec = mysql_fetch_array($request)) {
getchildren($rec, "", $db);
}
if (($limit != 0) && ($previouslimit >= ($total - $limit - $number))) {
echo '
[précédent]';
}
if (($previouslimit < ($total - limit)) && ($limit == 0) && ($total >= ($number + 1))) {
echo '
[suivant]';
}
if (($limit != 0) && ($previouslimit < ($total - $limit - $number))) {
echo '
[précédent] [suivant]';
}
mysql_close();
function getchildren($rec, $space, $db) {
$father_id = $rec[0];
$id = $rec[0];
$father = $rec[1];
$icon = $rec[4];
$name = $rec[5];
$date = $rec[9];
$ndate = fdate($date);
$icon_code = "![](images/" . $icon . ".gif)
";
echo "";
if ($father == 1) {
echo "
" . $space . $icon_code . "" . $rec[7] . " par " . $name . " le " . $ndate;
}
if ($father !=1) {
echo "
" . $space . $icon_code . "" . $rec[7] . " par " . $name . " le " . $ndate;
}
$request = mysql_db_query($db, "SELECT * FROM forum_data WHERE Father_Id=$father_id");
$space .= " ";
while ($rec = mysql_fetch_array($request)) {
getchildren($rec, $space, $db);
}
echo "";
}
function fdate($date) {
$arr = explode(" ", $date);
$date = $arr[0];
$time = $arr[1];
$arr2 = explode("-", $date);
$year = $arr2[0];
$month = $arr2[1];
$day = $arr2[2];
$arr3 = explode(":", $time);
$hour = $arr3[0];
$min = $arr3[1];
$ndate = $day . "/" . $month . "/" . $year . " à " . $hour . "h" . $min;
return $ndate;
}
?>