








 
|
require ("functions.php");
# entra passando:
# $forum
$db = mysql_connect("localhost", "gasperetti", "gas9761");
?>
if (!$forum) {
$sql="select distinct forum from forums";
$result=mysql_db_query("Gasperetti", "$sql",$db);
?>
while ($row = mysql_fetch_row($result)) {
$sql="select * from forums where forum='$row[0]'";
$result2=mysql_db_query("Gasperetti", "$sql",$db);
$msg=mysql_num_rows($result2)-1;
?>
|
echo("$row[0] | ") ?>
|
echo($msg)?>
|
}?>
|
}
else {
$sql="select forum from forums where forum='$forum'";
$result=mysql_db_query("Gasperetti", "$sql",$db);
if (mysql_affected_rows()>0) {
$row=mysql_fetch_row($result);
?>
|
echo("$forum");
?>
|
<-----
if ($forum) echo("Pubblica nuovo messaggio")?>
|
if($com=="readmsg") {
?>
|
$sql="select oggetto,messaggio,idparent,nome,email,datapost,orapost from forums where idtread='$idtread'";
$result=mysql_db_query("Gasperetti", "$sql",$db);
$row = mysql_fetch_row($result);
$tree=urldecode($tree);
if (substr($tree,strlen($tree)-1,strlen($tree))=="|") $tree=substr($tree,0,strlen($tree)-1);
$passi=array();
$passi=explode("|", $tree);
$tree="";
$k=1;
$ultimo=array_pop($passi);
foreach ($passi as $passo) {
list($temp,$id)=explode("jZx",$passo);
$tree=$tree.$temp."jZx".$id."|";
$tree=urlencode($tree);
$temp=urldecode($temp);
for ($i=0;$i<=$k;$i++) echo(" ");
$k++;
echo(" - $temp ");
}
list($temp,$id)=explode("jZx",$ultimo);
$tree=$tree.$temp."jZx".$id."|";
$tree=urlencode($tree);
$temp=urldecode($temp);
for ($i=0;$i<=$k;$i++) echo(" ");
echo(" - $temp ");
?>
|
<---------- ">Rispondi
al messaggio
|
Messaggio originale:
|
Oggetto:
echo($row[0])?>
|
Autore
|
|
Inviato il:
echo(conv_data($row[5])." alle $row[6]")?>
echo(nl2br($row[1]))?>
|
echo("$row[3] ($row[4])")?>
|
|
">Rispondi
al messaggio
|
Risposte:
} // end readmsg
$limite=5;
if (!$start) $start=0;
if (!$order) $order="datapost desc, orapost desc";
if (!$com and $forum) $sql="select idtread,oggetto,idparent,nome,datapost,emoticon,orapost,messaggio from forums where forum='$forum' and idparent=idtread and oggetto!='' order by $order limit $start,$limite";
else $sql="select idtread,oggetto,idparent,nome,datapost,emoticon,orapost,messaggio from forums where idtread!='$idtread' and forum='$forum' and idparent='$idtread' order by $order limit $start,$limite";
$i=0;
//echo ($sql);
$result=mysql_db_query("Gasperetti", "$sql",$db);
if (mysql_affected_rows()>0) {
//echo(" Totale messaggi:".mysql_affected_rows());
?>
|
n°
|
">Oggetto
|
n°risposte
|
Nome
|
">Data
|
while ($row = mysql_fetch_row($result)) {
$i++;
?>
|
echo($i+$start)?>
|
if (!$com and $forum) $tree=$row[1]."jZx".$row[0];
else $tree=$tree.$row[1]."jZx".$row[0];
echo("$row[1]");
echo(" ".substr($row[7],0,50)."...");
?>
|
$sql="select count(*) from forums where idparent='$row[0]' and idtread!='$idtread' and idparent!=idtread";
$result2=mysql_db_query("Gasperetti", "$sql",$db);
$row2 = mysql_fetch_row($result2);
echo($row2[0]);
?>
|
echo("$row[3]")?>
|
echo(conv_data($row[4])." $row[6]")?>
|
} ?>
if ($start>=$limite) echo("[ Visualizza precedenti $limite ]");
$start=$start+$limite;
if ($i>=$limite) echo("[ Visualizza prossimi $limite ]");
// echo("$i $start $limite");
} ?>
} // if forum
else {
echo("Forum inesistente");
exit;
}
}
?>
|