<?
session_start();
include("functions.php");
error_reporting(E_ALL);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><a href="fora_regler.php"><h2>FORUM REGLER - LÆS!</h2></a>
<?php
$userid = $_SESSION['userid'];
if(!is_numeric($userid)) { die('Af sikkerhedsmæssige årsager er siden stoppet i at loade. Kontakt webmaster hvis fejlen fortsætte'); exit(); }
$host="localhost"; // Host name
$username="users_camilla"; // Mysql username
$password=""; // Mysql password
$db_name="users_camilla"; // Database name
$tbl_name="forum_question"; // Table name
$limit = 500; //antal poster pr side
$page = (isset($_GET['side'])) ? $_GET['side'] : 1;
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$res = mysql_query("SELECT COUNT(*) FROM $tbl_name");
$total_rows = mysql_fetch_row($res);
$total_pages = ceil($total_rows[0] / $limit);
$offset = ($page - 1) * $limit;
$sql="SELECT * FROM $tbl_name ORDER BY sticky DESC,last_answer DESC LIMIT $offset, $limit";
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);
?>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#8FC1D5">
<tr>
<td width="6%" align="center" bgcolor="#C3E4F2"><strong>#</strong></td>
<td width="53%" align="center" bgcolor="#C3E4F2"><strong>Emne</strong></td>
<td width="53%" align="center" bgcolor="#C3E4F2"><strong>Oprettet af</strong></td>
<td width="13%" align="center" bgcolor="#C3E4F2"><strong>Svar</strong></td>
<td width="13%" align="center" bgcolor="#C3E4F2"><strong>Dato</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){ // Start looping table row
$name = $rows["name"];
$hvem = $rows["name"];
?>
<tr>
<td bgcolor="#E6F4F8"><? echo $rows['id']; ?></td>
<td bgcolor="#E6F4F8"><a href="view_topic.php?id=<? echo $rows['id']; ?>"><? echo $rows['topic']; ?></a><BR></td>
<td align="center" bgcolor="#E6F4F8"><a href="profil.php?hvem=<? echo "$hvem"; ?>"><?
//ADMINISTRATOR
if($name=='Admin')
{
echo "<font style='color: red;'>WEB/$name</font> <font style='color: orange;'>VHT</font>";
}
//MODERATORE
else
if($name=='Cupcake')
{
echo "<font style='color: #FF0080;'>MOD/$name</font>";
}
else
if($name=='Adornetto')
{
echo "<font style='color: green;'>MOD/$name</font>";
}
else
if($name=='Tears')
{
echo "<font style='color: #1D6787;'>MOD/$name</font> <font style='color: orange;'>VHT</font>";
}
else
if($name=='Fixon')
{
echo "<font style='color: green;'>MOD/$name</font>";
}
//VANDHESTETEGNERE
else
if($name=='Ignited')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Dipper')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='HuffelPuff')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Teardrop')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Funny')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Esrow')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Kagetsu')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Sighthounds')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
else
if($name=='Salvatore')
{
echo "$name <font style='color: orange;'>VHT</font>";
}
//ANDRE
else
{
echo "$name";
}
?></td>
<td align="center" bgcolor="#E6F4F8"><? echo $rows['reply']; ?></td>
<td align="center" bgcolor="#E6F4F8"><? echo $rows['datetime']; ?></td>
</tr>
<?php
// Exit looping and close connection
}
mysql_close();
?>
<link href="style.css" rel="stylesheet" type="text/css">
<tr>
<td colspan="5" align="right" bgcolor="#C3E4F2"><a href="create_topic.php"><strong>Opret emne</strong> </a></td>
</tr>
</table>
<?php
if ($page != 1)
$line .= "<a href=\"main_forum.php?page=" . ($page - 1) . "\"><</a>";
for ($i = 1; $i <= $total_pages; $i++) {
if($i == 1){
$line .= " ";
}else{
$line .= " | ";
}
if ($i == $page)
$line .= "<span style=\"font-weight: bold;\">$i</span>";
else
$line .= "<a href=\"main_forum.php?page=$i\">$i</a>";
}
if ($page != $total_pages)
$line .= " <a href=\"main_forum.php?page=" . ($page + 1) . "\">></a>";
echo "line: " . $line . "<br>";
echo "pages: " . $pages . "<br>";
echo "total_rows: " . $total_rows . "<br>";
echo "total_pages: " . $total_pages . "<br>";
echo "limit: " . $limit . "<br>";
?>
<small><center><a href="main_forum3.php">VHT-forum</a>-<a href="main_forum2.php">MOD-forum</a></center></small>
<br>
<? include("footer.php"); ?>
Ny bruger
Nybegynder
Opret
Preview
