@ 2014-05-31T22:54:23Z <?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($catnamequery))
{
?>
<hr />
<a href="forum.php">Forum</a>
<span class="text"> - </span>
<? if (isset($_GET['tid']))
{
?>
<span class="text"><a href="forum.php?fid=<?php echo $_GET['fid'] ?>"><?php echo $row['forumname'] ?></a></span>
<?php
}
else
{
?>
<span class="text"><?php echo $row['forumname'] ?></span>
<?php
}
?>
<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 any 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'] ?><hr /><?php echo $row['timestamp'] ?></td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
//Ladda replies här under
$query = mysqli_query($sqli, "SELECT * FROM forumreplies WHERE threadid='$tid'") or die("Error: ".mysqli_error($sqli));
while ($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>
<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'] ?><hr /><?php echo $row['timestamp'] ?></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 any 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>
<?php
$id = $row['id'];
$replyquery = mysqli_query($sqli, "SELECT * FROM forumreplies WHERE threadid='$id'") or die("Error: ".mysqli_error($sqli));
$numreplies = mysqli_num_rows($replyquery);
echo $numreplies;
?>
</td>
<td>
<?php
//Tid för Senaste Post här
$lasttimepostquery = mysqli_query($sqli, "SELECT * FROM forumreplies WHERE threadid='$id' ORDER BY ASC") or die("Error: ".mysqli_error($sqli));
$numposts = mysqli_num_rows($lasttimepostquery);
$lasttimestamprow = mysqli_fetch_array($query)
echo $lasttimestamprow['timestamp'];
?>
</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']))
{
?>
<span class="text"> - </span>
<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.013 0.061 12.50 5.4.28 0.011 0.052 12.39 5.4.27 0.010 0.050 12.39 5.4.26 0.013 0.051 12.39 5.4.25 0.009 0.051 12.39 5.4.24 0.007 0.062 12.39 5.4.23 0.010 0.058 12.38 5.4.22 0.010 0.036 12.39 5.4.21 0.006 0.038 12.38 5.4.20 0.011 0.058 12.39 5.4.19 0.011 0.051 12.38 5.4.18 0.011 0.064 12.38 5.4.17 0.011 0.055 12.39 5.4.16 0.009 0.052 12.38 5.4.15 0.006 0.060 12.38 5.4.14 0.006 0.056 12.07 5.4.13 0.010 0.051 12.05 5.4.12 0.011 0.052 12.02 5.4.11 0.007 0.051 12.02 5.4.10 0.010 0.049 12.02 5.4.9 0.015 0.070 12.01 5.4.8 0.010 0.065 12.01 5.4.7 0.008 0.055 12.02 5.4.6 0.010 0.054 12.01 5.4.5 0.010 0.052 12.01 5.4.4 0.007 0.052 12.00 5.4.3 0.006 0.053 12.00 5.4.2 0.011 0.064 11.99 5.4.1 0.010 0.054 11.99 5.4.0 0.011 0.064 11.49 5.3.28 0.009 0.056 12.71 5.3.27 0.007 0.060 12.72 5.3.26 0.007 0.063 12.72 5.3.25 0.012 0.057 12.72 5.3.24 0.014 0.057 12.72 5.3.23 0.015 0.112 12.71 5.3.22 0.018 0.089 12.68 5.3.21 0.010 0.077 12.68 5.3.20 0.013 0.063 12.68 5.3.19 0.014 0.050 12.67 5.3.18 0.009 0.055 12.67 5.3.17 0.008 0.057 12.67 5.3.16 0.011 0.056 12.67 5.3.15 0.015 0.055 12.68 5.3.14 0.007 0.056 12.66 5.3.13 0.011 0.058 12.66 5.3.12 0.009 0.057 12.66 5.3.11 0.015 0.063 12.66 5.3.10 0.010 0.052 12.12 5.3.9 0.008 0.060 12.09 5.3.8 0.013 0.054 12.07 5.3.7 0.011 0.063 12.07 5.3.6 0.005 0.063 12.06 5.3.5 0.006 0.059 12.01 5.3.4 0.008 0.064 12.01 5.3.3 0.016 0.057 11.96 5.3.2 0.009 0.060 11.74 5.3.1 0.007 0.053 11.71 5.3.0 0.006 0.052 11.70
preferences:dark mode live preview
150.9 ms | 1394 KiB | 7 Q