<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;
define("DB_HOST","mysql117.loopia.se");
define("DB_USER","normal@i103189");
define("DB_PASS","KungMicke87");
define("DB_NAME","indiehjaerta_com");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<title>indiehjaerta.com - Forum</title>
<link href="style_test.css" rel="stylesheet" type="text/css" />
</head>
<body>
<a href="login.php">Login<a/> -
<a href="admin.php">Admin<a/> -
<a href="members.php">Members<a/> -
<a href="register.php">Register<a/> -
<a href="blog.php">Blog<a/> -
<a href="news.php">News<a/> -
<a href="event.php">Event<a/> -
<a href="forum.php">Forum<a/> -
<a href="profile.php">Profile<a/> -
<a href="logout.php">Logout<a/>
<br /> <br />
<!-- New Post Start -->
<!-- New Post End -->
<!-- List Forum Category Threads - Start -->
<?php
if (isset($_GET['fid']))
{
if (isset($_GET['tid']))
{
// Connect to MySQLi
$sqli = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) or die("Error: ".mysqli_error($sqli));
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$tid = $_GET['tid'];
$query = mysqli_query($sqli, "SELECT * FROM forumtopics WHERE id='$tid'") or die("Error: ".mysqli_error($sqli));
$checkthreadexists = mysqli_num_rows($query);
// Check if we have ny threads in this category
if($checkthreadexists == 0)
{
// No threads
echo '<span class="text">No such topic ID exists!</span><br />';
}
else
{
$row = mysqli_fetch_array($query);
$uid = $row['userid'];
$userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$uid'") or die("Error: ".mysqli_error($sqli));
$userrow = mysqli_fetch_array($userquery);
echo '<table border="0">';
echo '<tr> ';
echo '<th></th>';
echo '<th></th>';
echo '<th><span class="text"><span class="text">' .$row['threadname']. '</span></th>';
echo '<th></th>';
echo '</tr>';
echo '<tr>';
echo '<td><a href="profile.php?id=' .$uid. '"><span class="text">' .$userrow['username']. '</span></a></td>';
echo '<td></td>';
echo '<td><span class="text">' .$row['text']. '</span></td>';
echo '<td></td>';
echo '</tr>';
echo '</table><br />';
}
}
else
{
// Connect to MySQLi
$sqli = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) or die("Error: ".mysqli_error($sqli));
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$fid = $_GET['fid'];
$query = mysqli_query($sqli, "SELECT * FROM forumtopics WHERE categoryid='$fid' ORDER BY id") or die("Error: ".mysqli_error($sqli)); //Don't order by ID!
$checknumthreads = mysqli_num_rows($query);
// Check if we have ny threads in this category
if($checknumthreads == 0)
{
// No threads
echo '<span class="text">No forums threads found in the database!</span><br />';
}
else
{
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<strong>Forums</strong>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td><strong>Name</strong></td>
<td></td>
<td><strong>Replies</strong></td>
<td><strong>Last Post</strong></td>
</tr>
<?php
while ($row = mysqli_fetch_array($query))
{
?>
<tr>
<td><a href="?fid=<?php echo $_GET['fid'] ?> &tid= <?php echo $row['id'] ?>" style="color: black"><?php echo $row['threadname'] ?></a></td>
<td></td>
<td>0</td>
<td>00:00</td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
}
?>
<!-- List Forum Category Threads - End -->
<!-- List Forum Categories - Start -->
<?php
}
else
{
// Connect to MySQLi
$sqli = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) or die("Error: ".mysqli_error($sqli));
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$query = mysqli_query($sqli, "SELECT * FROM forumcat ORDER BY id") or die("Error: ".mysqli_error($sqli));
$checknumforums = mysqli_num_rows($query);
// Check if we have any forum categories
if($checknumforums == 0)
{
// No forums
echo '<span class="text">No forums found in the database!</span><br />';
}
else
{
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<strong>Forums</strong>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td><strong>Name</strong></td>
<td></td>
<td><strong>Threads</strong></td>
<td><strong>Last Post</strong></td>
</tr>
<?php
while ($row = mysqli_fetch_array($query))
{
?>
<tr>
<td><a href="?fid=<?php echo $row['id'] ?>" style="color: black"><?php echo $row['forumname'] ?></a></td>
<td></td>
<td>0</td>
<td>00:00</td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
}
}
?>
<!-- List Forum Categories - End -->
<?php
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$finish = $time;
$total_time = round(($finish - $start), 4);
echo '<span class="text">Page generated in '.$total_time.' seconds.</span><br />';
?>
</body>
</html>
- Output for 5.4.0 - 5.4.29
- Parse error: syntax error, unexpected 'else' (T_ELSE) in /in/vA5oc on line 173
Process exited with code 255. - Output for 5.3.0 - 5.3.28
- Parse error: syntax error, unexpected T_ELSE in /in/vA5oc on line 173
Process exited with code 255.
preferences:
182.93 ms | 1395 KiB | 66 Q