include("connection_data.php3");
include("mysql_func.php3");
$lk = connect();
echo "";
echo "
";
echo "";
echo "";
echo "";
$id = $_GET[id];
$request = mysql_db_query($db, "SELECT * FROM forum_data WHERE Id=$id");
$result = array();
while ($rec = mysql_fetch_array($request)) {
$result[] = $rec;
}
$root_id = $result[0][3];
$name = $result[0][5];
$email = $result[0][6];
$subject = $result[0][7];
$message = $result[0][8];
$cmessage = fmessage($message);
echo "";
echo "";
echo "| ";
echo "Auteur :";
echo " | ";
echo "";
if ($email == "None") {
echo " " . $name . "";
}
else {
echo " " . $name . "";
}
echo " | ";
echo "
";
echo "";
echo "| ";
echo " ";
echo " | ";
echo "
";
echo "";
echo "| ";
echo "Sujet :";
echo " | ";
echo "";
echo " " . $subject . "";
echo " | ";
echo "
";
echo "
";
echo "
";
echo "";
echo "";
echo "| ";
echo "Message :";
echo " | ";
echo "
";
echo "";
echo "| ";
echo "";
echo " | ";
echo "
";
echo "
";
echo "
";
echo "";
echo "";
echo "| ";
echo "Fil de discussion :";
echo " | ";
echo "
";
echo "";
echo "| ";
$request2 = mysql_db_query($db, "SELECT * FROM forum_data WHERE Id=$root_id");
while ($rec2 = mysql_fetch_array($request2)) {
getchildren($rec2, "", $db, $id);
}
echo " |
";
echo "
[répondre]
";
echo "[retour au forum]";
function getchildren($rec2, $space, $db, $id) {
$father_id = $rec2[0];
$id2 = $rec2[0];
$father = $rec2[1];
$icon = $rec2[4];
$name = $rec2[5];
$date = $rec2[9];
$ndate = fdate($date);
$icon_code = "
";
echo "";
if ($father == 0) {
if ($id == $id2) {
echo "
" . $space . $icon_code . $rec2[7] . " par " . $name . " le " . $ndate;
}
else if ($id != $id2) {
echo "
" . $space . $icon_code . "" . $rec2[7] . " par " . $name . " le " . $ndate;
}
}
else if ($father != 0) {
if ($id == $id2) {
echo $space . $icon_code . $rec2[7] . " par " . $name . " le " . $ndate;
}
else if ($id != $id2) {
echo $space . $icon_code . "" . $rec2[7] . " par " . $name . " le " . $ndate;
}
}
$request2 = mysql_db_query($db, "SELECT * FROM forum_data WHERE Father_Id=$father_id");
$space .= " ";
while ($rec2 = mysql_fetch_array($request2)) {
getchildren($rec2, $space, $db, $id);
}
echo "";
}
mysql_close();
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;
}
function fmessage($message) {
$html_code1 = "<";
$nohtml1 = "<";
$message1 = str_replace($html_code1, $nohtml1, $message);
$html_code2 = ">";
$nohtml2 = ">";
$message2 = str_replace($html_code2, $nohtml2, $message1);
$smile_code = "[:-)]";
$smile = "
";
$amessage = str_replace($smile_code, $smile, $message2);
$bigsmile_code = "[:D]";
$bigsmile = "
";
$bmessage = str_replace($bigsmile_code, $bigsmile, $amessage);
$sglasses_code = "[8)]";
$sglasses = "
";
$cmessage = str_replace($sglasses_code, $sglasses, $bmessage);
$pink_code = "[:]";
$pink = "
";
$dmessage = str_replace($pink_code, $pink, $cmessage);
$joke_code = "[:p]";
$joke = "
";
$emessage = str_replace($joke_code, $joke, $dmessage);
$eye_code = "[;)]";
$eye = "
";
$fmessage = str_replace($eye_code, $eye, $emessage);
$clown_code = "[:o)]";
$clown = "
";
$gmessage = str_replace($clown_code, $clown, $fmessage);
$eye2_code = "[°|]";
$eye2 = "
";
$hmessage = str_replace($eye2_code, $eye2, $gmessage);
$eight_code = "[8]";
$eight = "
";
$imessage = str_replace($eight_code, $eight, $hmessage);
$sad_code = "[:(]";
$sad = "
";
$jmessage = str_replace($sad_code, $sad, $imessage);
$bigeyes_code = "[:°|]";
$bigeyes = "
";
$kmessage = str_replace($bigeyes_code, $bigeyes, $jmessage);
$mouth_code = "[:o]";
$mouth = "
";
$lmessage = str_replace($mouth_code, $mouth, $kmessage);
$angry_code = "[:-((]";
$angry = "
";
$mmessage = str_replace($angry_code, $angry, $lmessage);
$cross_code = "[:-(p]";
$cross = "
";
$nmessage = str_replace($cross_code, $cross, $mmessage);
$asian_code = "[:|]";
$asian = "
";
$omessage = str_replace($asian_code, $asian, $nmessage);
$lipstick_code = "[:{}]";
$lipstick = "
";
$pmessage = str_replace($lipstick_code, $lipstick, $omessage);
$green_code = "[:))]";
$green = "
";
$qmessage = str_replace($green_code, $green, $pmessage);
$red_code = "[:((]";
$red = "
";
$rmessage = str_replace($red_code, $red, $qmessage);
$question_code = "[??]";
$question = "
";
$smessage = str_replace($question_code, $question, $rmessage);
$good_code = "[+]";
$good = "
";
$tmessage = str_replace($good_code, $good, $smessage);
$bad_code = "[-]";
$bad = "
";
$umessage = str_replace($bad_code, $bad, $tmessage);
$blue_code = "[;-))]";
$blue = "
";
$vmessage = str_replace($blue_code, $blue, $umessage);
$key_code = "[;-(]";
$keyh = "
";
$wmessage = str_replace($key_code, $keyh, $vmessage);
$veryangry_code = "[:-(((]";
$veryangry = "
";
$xmessage = str_replace($veryangry_code, $veryangry, $wmessage);
$questionblue_code = "[b??b]";
$questionblue = "
";
$ymessage = str_replace($questionblue_code, $questionblue, $xmessage);
$warning_code = "[!!]";
$warning = "
";
$zmessage = str_replace($warning_code, $warning, $ymessage);
$light_code = "[(o-]";
$light = "
";
$aamessage = str_replace($light_code, $light, $zmessage);
$text_code = "[(tx)]";
$text = "
";
$abmessage = str_replace($text_code, $text, $aamessage);
$img_code1 = "[-?";
$img1 = "
<";
$acmessage = str_replace($img_code1, $img1, $abmessage);
$img_code2 = "?-]";
$img2 = ">
";
$admessage = str_replace($img_code2, $img2, $acmessage);
return $admessage;
}
?>