@ 2014-05-30T23:12:04Z <?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']))
{
// 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']
$catnamequery = mysqli_query($sqli, "SELECT * FROM forumcat WHERE id='$fid'") or die("Error: ".mysqli_error($sqli));
while ($row = mysqli_fetch_array($query))
{
?>
<hr />
<a href="?fid=<?php echo $_GET['fid'] ?>"><?php echo $row['forumname'] ?></a>
<hr />
<?php
}
if (isset($_GET['tid']))
{
$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
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>No such topic ID exists!</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
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);
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" cellpadding="4" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<th></th>
<th></th>
<th><?php echo $row['threadname'] ?></th>
<th></th>
</tr>
<tr>
<td><a href="profile.php?id=<?php echo $uid ?>" style="color: black"><?php echo $userrow['username'] ?></a></td>
<td></td>
<td><?php echo $row['text'] ?></td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
}
else
{
$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
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>No forums threads found in the database!</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
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
}
}
?>
<hr />
<a href="?fid=<?php echo $_GET['fid'] ?>&action=new">New Topic</a> -
<?php
if (isset($_GET['tid']) && empty(!$_GET['fid']))
{
?>
<a href="?fid=<?php echo $_GET['fid'] ?>&action=new">New Reply</a>
<?php
}
?>
<hr />
<!-- 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
?>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>No forums found in the database!</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
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>
<?php
$id = $row['id'];
$threadsquery = mysqli_query($sqli, "SELECT * FROM forumtopics WHERE categoryid='$id'") or die("Error: ".mysqli_error($sqli));
$numthreads = mysqli_num_rows($threadsquery);
echo $numthreads;
?>
</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>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).
Version System time (s) User time (s) Memory (MiB) 5.4.29 0.011 0.050 12.48 5.4.28 0.008 0.051 12.38 5.4.27 0.008 0.043 12.38 5.4.26 0.013 0.046 12.38 5.4.25 0.005 0.041 12.38 5.4.24 0.007 0.041 12.38 5.4.23 0.007 0.046 12.38 5.4.22 0.006 0.045 12.38 5.4.21 0.009 0.047 12.37 5.4.20 0.007 0.041 12.37 5.4.19 0.009 0.049 12.37 5.4.18 0.009 0.052 12.37 5.4.17 0.008 0.043 12.38 5.4.16 0.011 0.037 12.38 5.4.15 0.012 0.048 12.37 5.4.14 0.016 0.058 12.05 5.4.13 0.010 0.047 12.04 5.4.12 0.010 0.053 12.00 5.4.11 0.006 0.054 12.00 5.4.10 0.009 0.053 12.00 5.4.9 0.013 0.066 12.00 5.4.8 0.005 0.060 12.00 5.4.7 0.004 0.038 12.00 5.4.6 0.010 0.045 12.00 5.4.5 0.012 0.060 12.00 5.4.4 0.005 0.043 11.99 5.4.3 0.009 0.037 11.98 5.4.2 0.005 0.040 11.98 5.4.1 0.021 0.051 11.98 5.4.0 0.006 0.045 11.48 5.3.28 0.005 0.041 12.70 5.3.27 0.006 0.041 12.72 5.3.26 0.009 0.052 12.72 5.3.25 0.008 0.050 12.72 5.3.24 0.015 0.073 12.72 5.3.23 0.013 0.048 12.71 5.3.22 0.011 0.044 12.68 5.3.21 0.006 0.043 12.68 5.3.20 0.009 0.037 12.68 5.3.19 0.011 0.038 12.68 5.3.18 0.005 0.040 12.67 5.3.17 0.006 0.044 12.67 5.3.16 0.007 0.051 12.67 5.3.15 0.007 0.037 12.67 5.3.14 0.010 0.035 12.66 5.3.13 0.008 0.039 12.66 5.3.12 0.004 0.042 12.66 5.3.11 0.007 0.045 12.66 5.3.10 0.007 0.038 12.12 5.3.9 0.007 0.038 12.09 5.3.8 0.009 0.050 12.07 5.3.7 0.005 0.050 12.08 5.3.6 0.008 0.038 12.06 5.3.5 0.007 0.038 12.00 5.3.4 0.009 0.044 12.00 5.3.3 0.015 0.040 11.96 5.3.2 0.010 0.049 11.74 5.3.1 0.012 0.047 11.70 5.3.0 0.007 0.051 11.68
preferences:dark mode live preview
131.85 ms | 1394 KiB | 7 Q