D dh85 Medlem sedan maj 2004 22 inlägg Frågan 30 maj 2004 17:30 #1 Har ett forum på denna adress:
http://www.hpn.se/Meny/webforum/index_forum.php
På den sidan där man kan se ev. svar på inlägg skulle jag vilja ändra lite..ni kan själva se hur det ser ut nu.
Det är typ länk till svaret infogat efter startinlägget, det första inlägget.
Jag vill istället att svaret ska visas direkt under och inte länkas till en ny sida som det gör nu..
Koden för sidan:
<?
// Webforum mySQL 1.1
// Copyright © 2001 Mathias Niklasson
// [url]http://www.niklasson.net/[/url]
##################################################
# Script
session_start();
require ("./variablarna.php");
if (empty($id))
{
header ("Location: index_forum.php");
}
if (isset($svar))
{
mysql_connect ("$server","$anvandare","$losen");
mysql_select_db ("$databas");
$query = "SELECT * FROM forum WHERE id = $id";
$result = mysql_query($query);
while ($n = mysql_fetch_array($result))
{
$id = $n["id"];
$namn = $n["namn"];
$epost = $n["epost"];
$amne = $n["amne"];
$text = $n["text"];
$ip = $n["ip"];
$ref_id = $n["ref_id"];
$datum = $n["datum"];
$dat = date("Y-m-d H:i", $datum);
}
include ("./header.php");
?>
<?
include ("rubrik.php");
?>
<p align="center">
<? include ("online.php"); ?>
<?
// Utloggning
if (isset($_GET['logout'])){
session_unset();
session_destroy();
header("Location: logoutmessage.php");
exit;
}
?>
<link href="style.css" rel="stylesheet" type="text/css">
<center>
<strong> | <a href="index.php">» Login</a> | <a href="index_forum.php">»
New subject</a> | <a href="medlemmar.php">» Members</a> |
<a href="register.php">» Register</a> | <a href="index.php?logout="><strong>» Logout</strong></a> | </strong></strong>
</center><br><br>
</body>
</html>
<table width="<?=$tbwidth?>" align="center" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="<?=$tdtopbgfarg?>" width="45%"><font color="<?=$tdtopftfarg?>"><b>» <?=$amne?></b></font></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="30%" align="right"><a href="tabort.php?id=<?=$id?>"><img src="bilder/edit.gif" border="0" alt=" Ta bort inlägg (endast webmaster) "></a></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="25%" align="right"><font color="<?=$tdtopftfarg?>"><?=$dat?></font></td>
</tr>
<tr>
<td colspan="3" bgcolor="<?=$tdbgfarg?>"><font color="<?=$inlaggfarg?>"><?=$text?></font></td>
</tr>
<tr>
<td colspan="3" bgcolor="<?=$tdbgfarg?>" height="10"></td>
</tr>
<?
if (empty($epost))
{
?>
<tr>
<td colspan="2" bgcolor="<?=$tdbgfarg?>" width="70%"><img src="bilder/note.gif" border="0" width="15" height="15"> Written by: <b><?=$namn?></b></td>
<td bgcolor="<?=$tdbgfarg?>" width="30%" align="right">IP: <a href="http://www.ripe.net/cgi-bin/whois?query=<?=$ip?>" target="_blank"><?=$ip?></a></font></td>
</tr>
<?
}
else
{
?>
<tr>
<td colspan="2" bgcolor="<?=$tdbgfarg?>" width="70%"><img src="bilder/note.gif" border="0" width="15" height="15"> Written by: <a href="mailto:<?=$epost?>"><b><?=$namn?></b> </a></td>
<td bgcolor="<?=$tdbgfarg?>" width="30%" align="right">IP: <a href="http://www.ripe.net/cgi-bin/whois?query=<?=$ip?>" target="_blank"><b><?=$ip?></b></a></font></td>
</tr>
<?
}
?>
<tr>
<td colspan="3"><hr size="1" NOSHADOW></td>
</tr>
<tr>
<td colspan="3"><a href="JavaScript:history.go(-1);"><b>« Back</b></a></td>
</tr>
</table>
<?
include ("./footer.php");
exit;
}
$origid=$id;
mysql_connect ("$server","$anvandare","$losen");
mysql_select_db ("$databas");
$query = "SELECT * FROM forum WHERE id = $id";
$result = mysql_query($query);
while ($r = mysql_fetch_array($result))
{
$id = $r["id"];
$namn = $r["namn"];
$epost = $r["epost"];
$amne = $r["amne"];
$text = $r["text"];
$ip = $r["ip"];
$ref_id = $r["ref_id"];
$datum = $r["datum"];
$dat = date("Y-m-d H:i", $datum);
}
include ("./header.php");
?>
<?
include ("rubrik.php");
?>
<p align="center">
<? include ("online.php"); ?>
<?
// Utloggning
if (isset($_GET['logout'])){
session_unset();
session_destroy();
header("Location: logoutmessage.php");
exit;
}
?>
<center>
<strong> | <a href="index.php">» Login</a> | <a href="index_forum.php">»
New subject</a> | <a href="medlemmar.php">» Members</a> |
<a href="register.php">» Register</a> | <a href="index.php?logout="><strong>» Logout</strong></a> | </strong></strong>
</center><br><br>
</body>
</html>
<table width="<?=$tbwidth?>" align="center" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="<?=$tdtopbgfarg?>" width="45%"><font color="<?=$tdtopftfarg?>"><b>» <?=$amne?></b></font></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="30%" align="right"><a href="tabort.php?id=<?=$id?>"><img src="bilder/edit.gif" border="0" alt=" Delete subject (only crew) "></a></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="25%" align="right"><font color="<?=$tdtopftfarg?>"><?=$dat?></font></td>
</tr>
<tr>
<td colspan="3" bgcolor="<?=$tdbgfarg?>"><font color="<?=$inlaggfarg?>"><?=$text?></font></td>
</tr>
<tr>
<td colspan="3" bgcolor="<?=$tdbgfarg?>" height="10"></td>
</tr>
<?
if (empty($epost))
{
?>
<tr>
<td colspan="2" bgcolor="<?=$tdbgfarg?>" width="70%"><img src="bilder/note.gif" border="0" width="15" height="15"> Written by: <b><?=$namn?></b></td>
<td bgcolor="<?=$tdbgfarg?>" width="30%" align="right">IP: <a href="http://www.ripe.net/cgi-bin/whois?query=<?=$ip?>" target="_blank"><?=$ip?></a></font></td>
</tr>
<?
}
else
{
?>
<tr>
<td colspan="2" bgcolor="<?=$tdbgfarg?>" width="70%"><img src="bilder/note.gif" border="0" width="15" height="15"> Written by: <a href="mailto:<?=$epost?>"><b><?=$namn?></b></a></td>
<td bgcolor="<?=$tdbgfarg?>" width="30%" align="right">IP: <a href="http://www.ripe.net/cgi-bin/whois?query=<?=$ip?>" target="_blank"><b><?=$ip?></b></a></font></td>
</tr>
<?
}
$origamne = $amne;
?>
<tr>
<td colspan="3"><hr size="1" NOSHADOW></td>
</tr>
<?
mysql_connect ("$server","$anvandare","$losen");
mysql_select_db ("$databas");
$rader = mysql_num_rows(mysql_query("SELECT * FROM forum WHERE ref_id = $id"));
if (!$rader)
{
echo "<tr>\n <td colspan=\"3\">";
echo "<i>There are no answers to this subject.</i>\n";
echo " <p><a href=\"index.php\">« Tillbaka</a></td>\n</tr>\n";
mysql_close();
}
else
{
?><center>
<tr>
<td colspan="3"><H5>» REPLYS...</H5></td></tr></center>
<tr>
<td colspan="3" height="10"></td>
</tr>
<tr>
<td bgcolor="<?=$tdtopbgfarg?>" width="40%"><font color="<?=$tdtopftfarg?>"><b>Topic</b></font></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="30%"><font color="<?=$tdtopftfarg?>"><b>Written by</b></font></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="25%"><font color="<?=$tdtopftfarg?>"><b>Date</b></font></td>
</tr>
<?
mysql_connect ("$server","$anvandare","$losen");
mysql_select_db ("$databas");
$query = "SELECT * FROM forum WHERE ref_id = $id ORDER BY datum DESC";
$result = mysql_query($query);
while ($s = mysql_fetch_array($result))
{
$id = $s["id"];
$namn = $s["namn"];
$epost = $s["epost"];
$amne = $s["amne"];
$text = $s["text"];
$ip = $s["ip"];
$ref_id = $s["ref_id"];
$datum = $s["datum"];
$dat = date("Y-m-d H:i", $datum);
echo "<tr>\n";
echo " <td bgcolor=\"$tdbgfarg\"><a href=\"svar.php?id=$id&svar=1\"><b>» $amne</a></b></td>\n";
echo " <td bgcolor=\"$tdbgfarg\">$namn</td><td bgcolor=\"$tdbgfarg\">$dat</td>\n";
echo "</tr>\n";
}
mysql_close();
?>
<tr>
<td colspan="3" height="20"></td>
</tr>
<tr>
<td colspan="3"><a href="index_forum.php"><b>« Tillbaka</b></a></td>
</tr>
<?
}
echo "</table>\n";
if ($svar == 0)
{
?>
<p>
<center><p><h5>» WRITE AN ANSWER...</h5>
<form action="skicka.php" method="post">
<input type="hidden" name="ref_id" value="<?=$origid?>">
<input type="hidden" name="id" value="<?=$origid?>">
<?php
if (isset($_SESSION['sess_id'])) {
echo '
<input type="hidden" name="namn" value="'.$_SESSION['sess_user'].'">
<input type="hidden" name="epost" value="'.$_SESSION['sess_email'].'">
';
} else {
echo '
Name: <input type="text" name="namn"><br>
E-mail: <input type="text" name="epost"><br>
';
}
?>
Subject:
<input type="text" name="amne" maxlength="31" value="Re: <?=$origamne?>" size="35">
<br>
Message:<br>
<textarea name="text" cols="80" rows="10"></textarea>
<br>
<input type="Submit" value="Skicka" style="font-weight: bold"></form>
<p>You can also use <a href="javascript:smilies()"><b>» Smilies-code</b></a> and <a href="javascript:forumkod()"><b>» Discussion-code</b></a>.
<?
}
include ("./footer.php");
?></center>
Patrik81 Medlem sedan okt. 2001 538 inlägg Då borde du ta dig en titt på den här koden
<tr>
<td bgcolor="<?=$tdtopbgfarg?>" width="40%"><font color="<?=$tdtopftfarg?>"><b>Topic</b></font></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="30%"><font color="<?=$tdtopftfarg?>"><b>Written by</b></font></td>
<td bgcolor="<?=$tdtopbgfarg?>" width="25%"><font color="<?=$tdtopftfarg?>"><b>Date</b></font></td>
</tr>
<?
mysql_connect ("$server","$anvandare","$losen");
mysql_select_db ("$databas");
$query = "SELECT * FROM forum WHERE ref_id = $id ORDER BY datum DESC";
$result = mysql_query($query);
while ($s = mysql_fetch_array($result))
{
$id = $s["id"];
$namn = $s["namn"];
$epost = $s["epost"];
$amne = $s["amne"];
$text = $s["text"];
$ip = $s["ip"];
$ref_id = $s["ref_id"];
$datum = $s["datum"];
$dat = date("Y-m-d H:i", $datum);
echo "<tr>\n";
echo " <td bgcolor=\"$tdbgfarg\"><a href=\"svar.php?id=$id&svar=1\"><b>» $amne</a></b></td>\n";
echo " <td bgcolor=\"$tdbgfarg\">$namn</td><td bgcolor=\"$tdbgfarg\">$dat</td>\n";
echo "</tr>\n";
}
mysql_close();
?>
som du finner några rader ned från raden med "REPLYS..."
Denna bit kod får du ju ändra så att formateringen blir bättre (tjuvkika lite längre upp i koden för hur du skriver ut originalmeddelandet)
Har sådan ruskig träningsvärk och är så slutkörd efter att ha hjäplt far att masta på båten nu i helgen så jag orkar inte riktigt skriva om koden, men förstod jag frågan rätt, så borde mina tankar föra dig på rätt väg iaf.
MVH Patrik
D dh85 Medlem sedan maj 2004 22 inlägg Ingen annan som kan hjälpa mig med koden ??
//